Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/j3/plugins/hikashop/hikaparentchild/hikaparentchild_class.php

Назад
<?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); } }

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка