Directory:~$ /home/lmsyaran/www/plugins/hikashop/hikaparentchild/

Upload File

[Home] [System Details] [Kill Me]

<?php
/**
 * @package	HikaShop for Joomla!
 * @version	4.4.4
 * @author	hikashop.com
 * @copyright	(C) 2010-2021 HIKARI SOFTWARE. All rights reserved.
 * @license	GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
use Joomla\CMS\HTML\HTMLHelper;
?><?php
class fieldOpt_myuser_options
{
    public function show($value)
    {
        $input = JFactory::getApplication()->input;
        $cid = $input->get('cid', array());
            
        if (!empty($cid))
            $fieldid = $cid[0];
        else
            $fieldid = 0;

        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select($db->quoteName(array(
            'field_options'
        )));
        $query->from($db->quoteName('#__hikashop_field'));
        $query->where($db->quoteName('field_id') . ' =
' . $db->quote($fieldid));
        $db->setQuery($query);
        $value = $db->loadResult();

        if (!empty($value))
        {
            if (is_string($value)) $value = hikashop_unserialize($value);
        }
        else
        {
            $value = array();
        }
        $plg = JPluginHelper::getPlugin('hikashop',
'hikaparentchild');
        $plg_setting_url =
"/administrator/index.php?option=com_plugins&task=plugin.edit&extension_id={$plg->id}";
        $msg =
JText::sprintf("HIKAPARENTCHILD_PLUGIN_SETUP_WARNING",
$plg_setting_url);
        $html = '<script>
                       
jQuery(document).ready(jQuery("#fieldtype").chosen().on("change",
function (evt, params) {
                            if (params.selected ===
"plg.hikaparentchild") {
                                var message =
"'.$msg.'";
                                Joomla.JText.load({error:
"Warning"});
                                Joomla.renderMessages({"error":
[message]});
                            }
                        }));</script>';
        $db = JFactory::getDbo();
        $query = 'SHOW TABLES;';
        $db->setQuery($query);
        $tables = $db->loadColumn();
        $tables = array_combine(array_values($tables) , $tables);
        $cmp = JComponentHelper::getComponent('com_hilation');

        if(!isset($value['parenttables']) ||
$value['parenttables'] == '' )
        {
            $flag = false;
            foreach($tables as $table)
            {
                if(substr($table, -17) == 'hilation_relation'
&& $cmp->id) // check table exist an componenet installed and
enabled
                {
                    $value['parenttables'] = $table;
                    $value['parentcol'] = 'parent';
                    $value['childcol'] = 'userid';
                    $flag = true;
                }
            }
            if(!$flag)
            {
                $html .= '<div class="alert
alert-warning">'.JText::_('HIKAPARENTCHILD_WARNING').'</div>';

            }
        }
        $html .= '<dl class="hika_options
large"><dt>Select table: </dt><dd>' .
JHTML::_('select.genericlist', $tables,
"field_options[parenttables]",
'class="custom-select" required', 'value',
'text', @$value['parenttables']) .
'</dd>';
        $html .= '<dt><label
for="parentcol">Parent column: </label></dt><dd
class="input_small"><input
name="field_options[parentcol]" id="parentcol"
value="' . @$value['parentcol'] . '"
class="inputbox" required></dd>';
        $html .= '<dt><label
for="childcol">Child column: </label></dt><dd
class="input_small"><input
name="field_options[childcol]" id="childcol"
value="' . @$value['childcol'] . '"
class="inputbox" required></dd></dl>';
        

        return $html;
    }

    public function save(&$options)
    {
        
    }
}
require_once JPATH_ADMINISTRATOR .
"/components/com_hikashop/classes/field.php";
//
class hikashopHikaparentchild extends hikashopFieldMultipledropdown
{

    public $prefix = null;
    public $suffix = null;
    public $excludeValue = null;
    public $report = null;
    public $parent = null;
    public $displayFor = false;
    protected $params = null;

    public function __construct(&$obj)
    {
        $this->prefix = $obj->prefix;
        $this->suffix = $obj->suffix;
        $this->excludeValue = & $obj->excludeValue;
        $this->report = @$obj->report;
        $this->parent = & $obj;

        $timeoffset = 0;
        $jconfig = JFactory::getConfig();
        if (!HIKASHOP_J30)
        {
            $timeoffset =
$jconfig->getValue('config.offset');
        }
        else
        {
            $timeoffset = $jconfig->get('offset');
        }
        $dateC = JFactory::getDate(time() , $timeoffset);
        $timeoffset = $dateC->getOffsetFromGMT(true);
        $this->timeoffset = $timeoffset * 60 * 60 +
date('Z');
    }

    public function show(&$field, $value)
    {
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select('CONCAT(name, " (", username,
")") as u');
        $query->from($db->quoteName('#__users'));
        $query->where($db->quoteName('id') . ' IN
(' . $value . ')');
        $db->setQuery($query);
        $usernames = $db->loadColumn();
        return implode(', ', $usernames);

    }
    function display($field, $value, $map, $inside, $options =
'', $test = false, $allFields = null, $allValues = null)
    {
        $thisuser = JFactory::getUser();
        

        

        $db = JFactory::getDbo();

        if (property_exists($field, "field_options"))
        {
            $fo = $field->field_options;
            if (isset($fo['childcol']) &&
isset($fo['parentcol']) &&
isset($fo['parenttables']))
            {

                // $query = "SELECT u.id AS id, CONCAT(u.username,
' - ', u.name) AS value FROM `#__users` AS u INNER JOIN " .
$db->quoteName($fo['parenttables']) . " AS t ON u.id =
t." . $db->quoteName($fo['childcol']) . " WHERE
t." . $db->quoteName($fo['parentcol']) . " = "
. $db->quote($thisuser->id);
                
                $q = $db->getQuery(true);
                $q
                  ->select(array($db->quoteName('u.id',
'id'), "CONCAT(u.username, ' - ', u.name) as
value"))
                  ->from($db->quoteName('#__users',
'u'))
                  ->join('INNER',
$db->quoteName($fo['parenttables'], 't') . ' ON
' . $db->quoteName('u.id') . ' = ' .
$db->quoteName('t.'.$fo['childcol']))
                 
->where($db->quoteName('t.'.$fo['parentcol']) .
' = ' . $db->quote($thisuser->id));

                
                $db->setQuery($q);
                $results = $db->loadObjectList('id');
                $fieldid = $field->field_namekey;
                $field->field_value = $results;
                $config = hikashop_config();
                $use_chosen =
$config->get('bootstrap_forcechosen');
                
                if($use_chosen)
                {
                  $document = JFactory::getDocument();
                 
$document->addStyleSheet('/media/jui/css/chosen.css?88b10fdcf6c05253943557533fb6dc28');
                 
$document->addScript('/media/jui/js/chosen.jquery.min.js?88b10fdcf6c05253943557533fb6dc28');
                  $document->addScriptDeclaration("
                      jQuery(window).load(function(){
                          jQuery('#$fieldid').chosen();
                      });
                  ");
                }
            }
        }
        return parent::display($field, $value, $map, $inside, $options,
$test, $allFields, $allValues);
    }
}