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

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/joomla5/plugins/fabrik_list/order/order.php

Назад
<?php /** * Allows drag and drop reordering of rows * * @package Joomla.Plugin * @subpackage Fabrik.list.order * @copyright Copyright (C) 2005-2020 Media A-Team, Inc. - All rights reserved. * @license GNU/GPL http://www.gnu.org/copyleft/gpl.html / // No direct access defined('_JEXEC') or die('Restricted access'); use Joomla\CMS\MVC\Model\BaseDatabaseModel; // Require the abstract plugin class require_once COM_FABRIK_FRONTEND . '/models/plugin-list.php'; /* * Allows drag and drop reordering of rows * * @package Joomla.Plugin * @subpackage Fabrik.list.order * @since 3.0 / class PlgFabrik_ListOrder extends PlgFabrik_List { /* * Get the parameter name that defines the plugins acl access * * @return string / protected function getAclParam() { return 'order_access'; } /* * Can the plug-in select list rows * * @return bool / public function canSelectRows() { return false; } /* * Get the src(s) for the list plugin js class * * @return mixed string or array / public function loadJavascriptClass_result() { $mediaFolder = FabrikHelperHTML::getMediaFolder(); $src = parent::loadJavascriptClass_result(); $src['element'] = $mediaFolder . '/element.js'; return $src; } /* * Return the javascript to create an instance of the class defined in formJavascriptClass * * @param array $args Array [0] => string table's form id to contain plugin * * @return bool / public function onLoadJavascriptInstance($args) { if (!$this->canUse()) { return; } /* @var FabrikFEModelList $model / $model = $this->getModel(); $params = $this->getParams(); $orderEl = $model->getFormModel()->getElement($params->get('order_element'), true); $opts = $this->getElementJSOptions(); $orderElName = FabrikString::safeColNameToArrayKey(FArrayHelper::getValue($model->orderEls, 0, '')); $opts->enabled = $orderElName == FabrikString::safeColNameToArrayKey($orderEl->getOrderByName()) ? true : false; $opts->listid = $model->getId(); $opts->orderElementId = $params->get('order_element'); $opts->handle = $params->get('order_element_as_handle', 1) == 1 ? '.' . $orderEl->getOrderByName() : false; $opts->direction = $opts->enabled ? $model->orderDirs[0] : ''; $opts->transition = ''; $opts->duration = ''; $opts->constrain = ''; $opts->clone = ''; $opts->revert = ''; $opts = json_encode($opts); $this->jsInstance = "new FbListOrder($opts)"; return true; } /* * Load the AMD module class name * * @return string / public function loadJavascriptClassName_result() { return 'FbListOrder'; } /* * Called via ajax when dragged row is dropped. Reorders records * * @return void / public function onAjaxReorder() { // Get list model /* @var FabrikFEModelList $model */ $model = BaseDatabaseModel::getInstance('list', 'FabrikFEModel'); $input = $this->app->input; $model->setId($input->getInt('listid')); $db = $model->getDb(); $direction = $input->get('direction'); $orderEl = $model->getFormModel()->getElement($input->getInt('orderelid'), true); $table = $model->getTable(); $origOrder = $input->get('origorder', array(), 'array'); $orderBy = $db->quoteName($orderEl->getElement()->name); $order = $input->get('order', array(), 'array'); $dragged = $input->get('dragged'); // Are we dragging up or down? $origPos = array_search($dragged, $origOrder); $newPos = array_search($dragged, $order); $dragDirection = $newPos > $origPos ? 'down' : 'up'; // Get the rows whose order has been altered $result = array_diff_assoc($order, $origOrder); $result = array_flip($result); // Remove the dragged row from the list of altered rows unset($result[$dragged]); $result = array_flip($result); if (empty($result)) { // No order change return; } // Get the order for the last record in $result $splitId = $dragDirection == 'up' ? array_shift($result) : array_pop($result); $query = $db->getQuery(true); $query->select($orderBy)->from($table->db_table_name)->where($table->db_primary_key . ' = ' . $splitId); $db->setQuery($query); $o = (int) $db->loadResult(); if ($direction == 'desc') { $compare = $dragDirection == 'down' ? '<' : '<='; } else { $compare = $dragDirection == 'down' ? '<=' : '<'; } // Shift down the ordered records which have an order less than or equal the newly moved record $query = "UPDATE " . $table->db_table_name . " SET " . $orderBy . ' = COALESCE(' . $orderBy . ', 1) - 1 '; $query .= " WHERE " . $orderBy . ' ' . $compare . ' ' . $o . ' AND ' . $table->db_primary_key . ' <> ' . $dragged; $query .= " AND " . $table->db_primary_key . ' IN (' . implode(',', $db->q($order)) . ')'; $db->setQuery($query); if (!$db->execute()) { echo $db->getErrorMsg(); } else { // Shift up the ordered records which have an order greater than the newly moved record if ($direction == 'desc') { $compare = $dragDirection == 'down' ? '>=' : '>'; } else { $compare = $dragDirection == 'down' ? '>' : '>='; } $query = "UPDATE " . $table->db_table_name . " SET " . $orderBy . ' = COALESCE(' . $orderBy . ', 0) + 1'; $query .= " WHERE " . $orderBy . ' ' . $compare . ' ' . $o; $query .= " AND " . $table->db_primary_key . ' IN (' . implode(',', $db->q($order)) . ')'; $db->setQuery($query); if ($db->execute()) { // Change the order of the moved record $query = "UPDATE " . $table->db_table_name . " SET " . $orderBy . ' = ' . $o; $query .= " WHERE " . $table->db_primary_key . ' = ' . $dragged; $db->setQuery($query); $db->execute(); } } $model->reorder($input->getInt('orderelid')); } }

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