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

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_hikashop/classes/statistics.php

Назад
<?php /** * @package HikaShop for Joomla! * @version 4.4.1 * @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'); ?><?php class hikashopStatisticsClass extends hikashopClass { public $tables = array(); public $pkeys = array(); public $toggle = array(); public $timeoffset = ''; public function __construct($config = array()) { parent::__construct($config); $this->config = hikashop_config(); $this->joomlaConfig = JFactory::getConfig(); if(!isset($this->db)) $this->db = JFactory::getDBO(); if(!HIKASHOP_J30) $offset = $this->joomlaConfig->getValue('config.offset'); else $offset = $this->joomlaConfig->get('offset'); if(!is_numeric($offset)) { $tz = new DateTimeZone(JFactory::getUser()->getParam('timezone', $offset)); $date = JFactory::getDate('now', $tz); $offset = $date->getOffsetFromGmt(true); } $this->timeoffset = ((int)$offset)3600; $this->timeoffsetStr = ''.$this->timeoffset; if($this->timeoffset == 0) $this->timeoffsetStr = ''; else if($this->timeoffset > 0) $this->timeoffsetStr = '+' . $this->timeoffset ; } public function getDashboard($place = null) { $order_type = $this->db->Quote('sale'); $valid_order_statuses = explode(',', $this->config->get('stats_valid_order_statuses', 'confirmed,shipped')); $invoice_order_statuses = $this->config->get('invoice_order_statuses', 'confirmed,shipped'); $created_status = empty($invoice_order_statuses); foreach($valid_order_statuses as &$status) { if(trim($status) == 'created') $created_status = true; $status = $this->db->Quote(trim($status)); } unset($status); $ret = array(); $ret['sales_sum'] = array( 'slot' => 0, 'order' => 1, 'published' => 1, 'class' => 'hkc-lg-3 hkc-sm-6', 'label' => JText::_('HIKA_STATS_ORDERS_THIS_MONTH'), 'format' => 'price', 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'credit-card'), 'view' => hikashop_completeLink('order&task=listing'), ), 'vars' => array( 'DATE_RANGE' => 'past.month', ), 'query' => array( 'get' => 'list', 'select' => array( 'SUM(hk_order.order_full_price) as value', 'hk_order.order_currency_id as currency' ), 'tables' => hikashop_table('order') . ' AS hk_order ', 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})': 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'group' => 'hk_order.order_currency_id' ) ); $ret['sales_count'] = array( 'slot' => 0, 'order' => 2, 'published' => 1, 'class' => 'hkc-lg-3 hkc-sm-6', 'label' => JText::_('HIKA_STATS_TOTAL_ORDERS'), 'format' => 'number', 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'shopping-cart'), 'view' => hikashop_completeLink('order&task=listing'), ), 'vars' => array( 'DATE_RANGE' => 'past.month', ), 'query' => array( 'get' => 'single', 'select' => 'COUNT() as value', 'tables' => hikashop_table('order') . ' AS hk_order ', 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})' : 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ) ) ); $ret['sales_avg'] = array( 'slot' => 0, 'order' => 3, 'published' => 1, 'class' => 'hkc-lg-3 hkc-sm-6', 'label' => JText::_('HIKA_STATS_AVERAGE_ORDER_PRICE'), 'format' => 'price', 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'money fa-money-bill-alt'), 'view' => hikashop_completeLink('order&task=listing'), ), 'vars' => array( 'DATE_RANGE' => 'past.month', ), 'query' => array( 'get' => 'list', 'select' => array( 'AVG(hk_order.order_full_price) as value', 'hk_order.order_currency_id as currency' ), 'tables' => hikashop_table('order') . ' AS hk_order ', 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})': 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'group' => 'hk_order.order_currency_id' ) ); $ret['sales_today_count'] = array( 'slot' => 0, 'order' => 4, 'published' => 1, 'class' => 'hkc-lg-3 hkc-sm-6', 'label' => JText::_('HIKA_STATS_CURRENT_ORDERS'), 'format' => 'number', 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'shopping-cart'), 'view' => hikashop_completeLink('order&task=listing'), ), 'vars' => array( 'DATE_RANGE' => 'this.day', ), 'query' => array( 'get' => 'single', 'select' => 'COUNT() as value', 'tables' => hikashop_table('order') . ' AS hk_order ', 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})' : 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ) ) ); $ret['orders_history'] = array( 'slot' => 1, 'order' => 1, 'published' => 1, 'container' => 1, 'class' => 'hkc-lg-8 hkc-sm-12', 'label' => JText::_('ORDERS'), 'type' => 'graph', 'graph' => array( 'cols' => 'currency', 'axis' => 'date', ), 'vars' => array( 'DATE_RANGE' => 'this.year:month', 'DATE_GROUP' => 'week', 'DATE_START' => 0, 'DATE_END' => -1, ), 'query' => array( 'get' => 'list', 'select' => array( 'value' => 'SUM(hk_order.order_full_price) as value', 'axis' => ($created_status ? 'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis': 'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_invoice_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis'), 'currency' => 'currencies.currency_code as currency' ), 'tables' => array( hikashop_table('order') . ' AS hk_order', 'INNER JOIN '.hikashop_table('currency').' AS currencies ON hk_order.order_currency_id = currencies.currency_id' ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})': 'hk_order.order_invoice_id > 0 AND hk_order.order_invoice_created > 0 AND hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'group' => 'axis, hk_order.order_currency_id', 'order' => 'axis ASC' ) ); $ret['best_product'] = array( 'slot' => 1, 'order' => 2, 'published' => 1, 'class' => 'hkc-lg-2 hkc-sm-3', 'label' => JText::_('HIKA_STATS_BEST_PRODUCT'), 'type' => 'tile', 'tile' => array( 'mode' => 'small', 'image' => 'product', 'translate' => true, ), 'vars' => array( 'DATE_RANGE' => 'this.month', ), 'query' => array( 'get' => 'object', 'select' => array( 'key' => 'hk_product.product_id AS id', 'name' => 'hk_product.order_product_name AS name', 'value' => 'ROUND(SUM(hk_product.order_product_price * hk_product.order_product_quantity),2) AS value', 'counter' => 'COUNT(hk_order.order_id) AS counter', ), 'tables' => array( hikashop_table('order_product') . ' AS hk_product', 'INNER JOIN ' . hikashop_table('order') . ' AS hk_order ON hk_order.order_id = hk_product.order_id', ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})' : 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'order' => 'value DESC', 'group' => 'hk_product.product_id', 'limit' => 1 ) ); $ret['best_category'] = array( 'slot' => 1, 'order' => 3, 'published' => 1, 'class' => 'hkc-lg-2 hkc-sm-3', 'label' => JText::_('HIKA_STATS_BEST_CATEGORY'), 'type' => 'tile', 'tile' => array( 'mode' => 'small', 'image' => 'category', 'translate' => true, ), 'vars' => array( 'DATE_RANGE' => 'this.month', ), 'query' => array( 'get' => 'object', 'select' => array( 'key' => 'hk_category.category_id AS id', 'name' => 'hk_category.category_name AS name', 'value' => 'ROUND(SUM(hk_product.order_product_price * hk_product.order_product_quantity),2) AS value', 'counter' => 'COUNT(hk_order.order_id) AS counter', ), 'tables' => array( hikashop_table('order_product') . ' AS hk_product', 'INNER JOIN ' . hikashop_table('order') . ' AS hk_order ON hk_order.order_id = hk_product.order_id', 'INNER JOIN ' . hikashop_table('product_category') . ' AS hk_pc ON hk_product.product_id > 0 AND hk_pc.product_id = hk_product.product_id AND hk_pc.ordering = 1', 'INNER JOIN ' . hikashop_table('category') . ' AS hk_category ON hk_pc.category_id = hk_category.category_id', ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})' : 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'order' => 'value DESC', 'group' => 'hk_category.category_id', 'limit' => 1 ) ); $ret['best_customer'] = array( 'slot' => 1, 'order' => 4, 'published' => 1, 'class' => 'hkc-lg-2 hkc-sm-3', 'label' => JText::_('HIKA_STATS_BEST_CUSTOMER'), 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'user'), 'view' => array( 'process' => true, 'value' => 'user&task=edit&cid={ID}', ), 'class' => 'small-title', ), 'vars' => array( 'DATE_RANGE' => 'this.month', ), 'query' => array( 'get' => 'object', 'select' => array( 'name' => 'juser.name AS name', 'key' => 'hk_user.user_id AS id', 'email' => 'hk_user.user_email AS email', 'value' => 'ROUND(SUM(hk_order.order_full_price),2) AS value', ), 'tables' => array( hikashop_table('order') . ' AS hk_order', 'INNER JOIN ' . hikashop_table('user') . ' AS hk_user ON hk_user.user_id = hk_order.order_user_id', 'LEFT JOIN ' . hikashop_table('users', false) . ' AS juser ON hk_user.user_cms_id = juser.id', ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})' : 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'order' => 'value DESC', 'group' => 'hk_order.order_user_id', 'limit' => 1 ) ); $ret['conversion_rate'] = array( 'slot' => 1, 'order' => 5, 'published' => 1, 'class' => 'hkc-lg-2 hkc-sm-3', 'label' => JText::_('HIKA_STATS_CONVERSION_RATE'), 'format' => 'percentage', 'type' => 'tile', 'tile' => array( 'icon' => array('type' => 'fa', 'value' => 'tachometer fa-tachometer-alt'), ), 'vars' => array( 'DATE_RANGE' => 'this.month', 'ORDER_STATUSES' => 'IN (' . implode(',', $valid_order_statuses) . ')' ), 'vars-2' => array( 'DATE_RANGE' => 'this.month', 'ORDER_STATUSES' => 'IS NOT NULL' ), 'query' => array( 'get' => 'single', 'select' => array( 'value' => 'COUNT(hk_order.order_id) AS name', ), 'tables' => array( hikashop_table('order') . ' AS hk_order' ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => 'hk_order.order_status {ORDER_STATUSES}', 'order_created' => 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})', ), ), ); $ret['geo_sales'] = array( 'slot' => 2, 'order' => 1, 'published' => 1, 'container' => 1, 'class' => 'hkc-lg-4 hkc-sm-12', 'label' => JText::_('HIKA_STATS_GEO_SALES'), 'type' => 'geo', 'geo' => array( 'key' => 'zone', 'text' => 'value', ), 'vars' => array( 'DATE_RANGE' => 'this.month', ), 'query' => array( 'get' => 'list', 'select' => array( 'COUNT(hk_order.order_id) AS value', 'hk_zone.zone_name_english AS zone' ), 'tables' => array( hikashop_table('order') . ' AS hk_order ', ' INNER JOIN ' . hikashop_table('address') . ' AS hk_address ON hk_order.order_shipping_address_id = hk_address.address_id', ' INNER JOIN ' . hikashop_table('zone') . ' AS hk_zone ON hk_zone.zone_namekey = hk_address.address_country', ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'', 'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'), 'order_created' => ($created_status ? 'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})': 'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'), ), 'group' => 'hk_address.address_country' ), ); if(!isset($ret['geo_sales']['label'])) { $ret['geo_sales']['label'] = JText::_('HIKA_UPGRADE_HIKASHOP'); $ret['geo_sales']['type'] = 'ad'; } $ret['last_orders'] = array( 'slot' => 2, 'order' => 2, 'published' => 1, 'container' => 1, 'class' => 'hkc-lg-8 hkc-sm-12', 'type' => 'dynamic', 'label' => JText::_('HIKA_STATS_LAST_ORDERS'), 'vars' => array( 'COUNTER' => 6 ), 'prefix' => '<table style="width:100%" class="table table-striped table-hover table-bordered"><thead><tr><th>'.JText::_('ORDER_NUMBER').'</th><th>'.JText::_('ORDER_STATUS').'</th><th>'.JText::_('CUSTOMER').'</th><th>'.JText::_('DATE').'</th><th>'.JText::_('PRICE').'</th></thead><tbody>', 'dynamic' => '<tr><td>{order_number:order_link}</td><td>{order_status:order_status}</td><td>{user_email}</td><td>{order_created:date}</td><td>{order_full_price:price}</td></tr>', 'suffix' => '</tbody></table>', 'format' => 'text', 'query' => array( 'get' => 'list', 'select' => 'hk_order., hk_user., hk_order.order_currency_id as currency', 'tables' => array( hikashop_table('order') . ' AS hk_order', 'INNER JOIN '.hikashop_table('user').' AS hk_user ON hk_order.order_user_id = hk_user.user_id' ), 'filters' => array( 'order_type' => 'hk_order.order_type = '.$order_type.'' ), 'order' => 'hk_order.order_created DESC', 'limit' => '{COUNTER}' ) ); if(!empty($place) && is_string($place) && preg_match('#^[_a-zA-Z0-9]+$#', $place)) { $blocks = $this->config->get('statistics_'.$place, null); if($blocks !== null) { $blocks = explode(',', $blocks); $removed = array_diff(array_keys($ret), $blocks); foreach($removed as $r) { unset($ret[$r]); } } } JPluginHelper::importPlugin('hikashop'); $app = JFactory::getApplication(); $extra_list = $app->triggerEvent('onHikashopStatisticPluginList', array( array( 'created' => $created_status, 'valid' => $valid_order_statuses, 'offset' => $this->timeoffsetStr, 'place' => $place ) )); if(!empty($extra_list)) { foreach($extra_list as $v) { if(!isset($v['name'])) continue; $k = 'plugin.'.$v['name']; $ret[$k] = $v; } } return $ret; } public function getAjaxData($name, $value) { $app = JFactory::getApplication(); $statistics = array(); if(hikashop_isClient('administrator')) $statistics = $this->getDashboard(); if(empty($statistics[$name])) return false; if(empty($statistics[$name]['type']) \|\| !in_array($statistics[$name]['type'], array('graph', 'pie', 'geo'))) return false; if($statistics[$name]['type'] == 'graph') $dateRange = $this->getDateRangeList(true); else $dateRange = $this->getDateRangeList(); if(!isset($dateRange[$value])) return false; if(empty($statistics[$name]) \|\| empty($statistics[$name]['published'])) return false; $stat = $statistics[$name]; unset($statistics); $stat['vars']['DATE_RANGE'] = $value; switch($stat['type']) { case 'graph': list($headerData, $chartData) = $this->processGraphData($stat); break; case 'pie': list($headerData, $chartData) = $this->processPieData($stat); break; case 'geo': list($headerData, $chartData) = $this->processGeoData($stat); break; default: $headerData = array(); $chartData = array(); break; } if($stat['type'] == 'graph' && (count($headerData) == 1 \|\| empty($chartData))) return '[[],[]]'; return '['. '["' . implode('","', $headerData). '"]'. (empty($chartData) ? '' : ',[') . implode('],[', $chartData). (empty($chartData) ? '' : ']') . ']'; } public function setDateRange(&$conf, $mode, $base = 0) { $dates = $this->getDates($mode, $base); if(isset($conf['vars'])) { $conf['vars']['DATE_START'] = $dates['start']; $conf['vars']['DATE_END'] = $dates['end']; if(isset($dates['group'])) $conf['vars']['DATE_GROUP'] = $dates['group']; } else { $conf['DATE_START'] = $dates['start']; $conf['DATE_END'] = $dates['end']; if(isset($dates['group'])) $conf['DATE_GROUP'] = $dates['group']; } } public function getDates($mode, $base = 0) { $now = explode('-', hikashop_getDate(time(),'m-d-Y'), 3); $ret = array('start' => 0, 'end' => -1); if(strpos($mode, ':') !== false) { list($mode, $group) = explode(':', $mode, 2); if(in_array($group, array('day', 'week', 'month', 'year'))) $ret['group'] = $group; } $manualProcess = false; switch($mode) { case '': case 'all': $ret['start'] = 0; $ret['end'] = -1; break; case 'this.year': $ret['start'] = gmmktime(0, 0, 0, 1, 1, $now[2]) - $this->timeoffset; $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; break; case 'this.month': $ret['start'] = gmmktime(0, 0, 0, $now[0], 1, $now[2]) - $this->timeoffset; $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; break; case 'this.week': $ret['start'] = gmmktime(0, 0, 0, $now[0], $now[1], $now[2]) - (date('N')-1)243600 - $this->timeoffset; $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; break; case 'this.day': $ret['start'] = gmmktime(0, 0, 0, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; break; case 'past.year': $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['start'] = strtotime('-1 year', $ret['end'])+1; break; case 'past.month': $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['start'] = strtotime('-1 month', $ret['end'])+1; break; case 'past.month-1': $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['end'] = strtotime('-1 month', $ret['end'])+1; $ret['start'] = strtotime('-1 month', $ret['end'])+1; break; case 'past.week': $ret['end'] = gmmktime(23, 59, 59, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['start'] = strtotime('-1 week', $ret['end'])+1; break; case 'past.day': $ret['end'] = time() - $this->timeoffset; $ret['start'] = $ret['end'] - 243600; break; case 'previous.year': $ret['start'] = gmmktime(0, 0, 0, 1, 1, (int)$now[2]-1) - $this->timeoffset; $ret['end'] = gmmktime(23, 59, 59, 12, 31, (int)$now[2]-1) - $this->timeoffset; break; case 'previous.month': $ret['end'] = gmmktime(0, 0, 0, $now[0], 1, $now[2]) - 1 - $this->timeoffset; $ret['start'] = strtotime('-1 month', $ret['end']) + 1; break; case 'previous.week': $ret['end'] = gmmktime(0, 0, 0, $now[0], $now[1], $now[2]) - (date('N')-1)243600 - 1 - $this->timeoffset; $ret['start'] = strtotime('-1 week', $ret['end']) + 1; break; case 'previous.day': $ret['end'] = gmmktime(0, 0, 0, $now[0], $now[1], $now[2]) - $this->timeoffset; $ret['start'] = $ret['end'] - 243600; break; default: $manualProcess = true; break; } if($manualProcess) { } return $ret; } public function getDateRangeList($group = false) { $periods = array('this','past','previous'); $zones = array('year','month','week','day'); $ret = array( 'all' => 'HIKA_PERIOD_ALL' ); if($group === true) { $ret = array(); foreach($zones as $z) { $ret['all:'.$z] = JText::_('HIKA_PERIOD_ALL').' ('.JText::_('HIKA_PERIOD_BY_'.strtoupper($z)).')'; } } foreach($periods as $period) { foreach($zones as $zone) { $ret[$period.'.'.$zone] = 'HIKA_PERIOD_'.strtoupper($period).'_'.strtoupper($zone); if($group != true) continue; $m = $zone; foreach($zones as $z) { if($z === $m) { $m = true; continue; } if($m !== true) continue; $ret[$period.'.'.$zone.':'.$z] = JText::_('HIKA_PERIOD_'.strtoupper($period).'_'.strtoupper($zone)).' ('.JText::_('HIKA_PERIOD_BY_'.strtoupper($z)).')'; } } } return $ret; } protected function processQuery($queryData, $vars = array(), $limit = null) { if(empty($queryData['get'])) $queryData['get'] = 'single'; $select = $queryData['select']; if(is_array($select)) $select = implode(', ', $select); $tables = $queryData['tables']; if(is_array($tables)) $tables = implode(' ', $tables); $query = 'SELECT ' . $select . ' FROM ' . $tables; if(!empty($queryData['filters'])) { $query .= ' WHERE (' . implode(') AND (', $queryData['filters']) . ') '; } if(!empty($queryData['group'])) $query .= ' GROUP BY ' . (is_array($queryData['group']) ? implode(',', $queryData['group']) : $queryData['group']); if(!empty($queryData['order'])) $query .= ' ORDER BY ' . (is_array($queryData['order']) ? implode(',', $queryData['order']) : $queryData['order']); if(!empty($vars)) { if(isset($vars['DATE_RANGE'])) { $this->setDateRange($vars, $vars['DATE_RANGE']); $vars['_DATE_RANGE'] = $vars['DATE_RANGE']; unset($vars['DATE_RANGE']); } $keys = array_keys($vars); foreach($keys as &$key) { $key = '{'.$key.'}'; } unset($key); $values = array_values($vars); $query = str_replace($keys, $values, $query); if(isset($queryData['offset'])) $queryData['offset'] = str_replace($keys, $values, $queryData['offset']); if(isset($queryData['limit'])) $queryData['limit'] = str_replace($keys, $values, $queryData['limit']); unset($keys); unset($values); if(!isset($vars['DATE_FORMAT']) && isset($vars['DATE_GROUP'])) { $dateformat_key = '{DATE_FORMAT}'; switch($vars['DATE_GROUP']) { case 'year': $dateformat_value = '%Y'; break; case 'month': $dateformat_value = '%Y-%m'; break; case 'week': $dateformat_value = '%Y %u'; break; case 'day': default: $dateformat_value = '%Y-%m-%d'; break; } $query = str_replace($dateformat_key, $dateformat_value, $query); } } $offset = 0; if(!empty($queryData['offset'])) $offset = (int)$queryData['offset']; if(!empty($queryData['limit']) && $limit === null) $limit = (int)$queryData['limit']; if($limit === null) $limit = -1; $this->db->setQuery('SET @@session.time_zone = \'+00:00\''); $this->db->execute(); $this->db->setQuery($query, $offset, $limit); switch($queryData['get']) { case 'object': $ret = $this->db->loadObject(); break; case 'list': $ret = $this->db->loadObjectList(); break; case 'single': default: $ret = $this->db->loadResult(); break; } return $ret; } protected function initJS($vendor_id = null) { static $init = false; if($init) return; $app = JFactory::getApplication(); $url = hikashop_completeLink('user&task=reports', 'ajax', false, true); if(hikashop_isClient('administrator')) { $url = hikashop_completeLink('dashboard&task=reports', 'ajax', false, true); } $dateRanges = array( 'data' => array( 'all' => 0, 'year' => 1, 'month' => 2, 'week' => 3, 'day' => 4 ), 'text' => array( 'year' => JText::_('HIKA_PERIOD_BY_YEAR'), 'month' => JText::_('HIKA_PERIOD_BY_MONTH'), 'week' => JText::_('HIKA_PERIOD_BY_WEEK'), 'day' => JText::_('HIKA_PERIOD_BY_DAY') ) ); $doc = JFactory::getDocument(); $doc->addScript('https://www.google.com/jsapi'); $doc->addScriptDeclaration(' if(!window.localPage) window.localPage = {}; window.localPage.chartsInit = []; window.localPage.charts = {}; window.localPage.dateRanges = '.json_encode($dateRanges).'; window.localPage.changeChartData = function(type,id,name,value,el) { var chart = window.localPage.charts[id]; if(!chart) return false; var dataValue = value; if(type == "graph") { if(value.substring(0,1) != ":") dataValue = window.localPage.getRangeValue(value); else dataValue = chart.period + value; } var url = "'.$url.'", postdata = "chart="+encodeURIComponent(name)+"&value="+encodeURIComponent(dataValue); window.Oby.xRequest(url, {mode:"POST",data:postdata}, function(x,p) { var d = window.Oby.evalJSON(x.responseText) \|\| false; if(!d) return; chart.data = google.visualization.arrayToDataTable(d); chart.max = (d.length - 1); if(type == "graph") { chart.options.hAxis.viewWindow.min = 0; chart.options.hAxis.viewWindow.max = chart.max; chart.period = dataValue.substring(0, dataValue.indexOf(":")); chart.periodGroup = value.substring(value.indexOf(":") + 1); } chart.chart.draw(chart.data, chart.options); window.localPage.changeChartDropText(id, value, dataValue, el); }); return false; }; window.localPage.changeChartDropText = function(id,value,dataValue,el) { if(!el) return; if(value.substring(0,1) != ":") { var s = document.getElementById("hikashop_chart_"+id+"_range"); if(!s) return; s.innerHTML = el.innerHTML; var p = dataValue.indexOf(":"); if(p >= 0) value = dataValue.substring(p); } if(value.substring(0,1) == ":") { var s = document.getElementById("hikashop_chart_"+id+"_group"); if(!s) return; s.innerHTML = window.localPage.dateRanges.text[ value.substring(1) ]; } }; window.localPage.getRangeValue = function(value) { var r = window.localPage.dateRanges, ret = value; if(value.indexOf(".") >= 0) value = value.substring(value.indexOf(".")+1); if(r.data[value] === undefined) return ret; var v = (r.data[value] + 1); for(var k in r.data) { if(r.data.hasOwnProperty(k) && r.data[k] === v) return ret + ":" + k; } return ret; }; window.localPage.refreshGraphs = function() { for(var i in window.localPage.charts) { if(!window.localPage.charts.hasOwnProperty(i)) continue; var chart = window.localPage.charts[i]; chart.chart.draw(chart.data, chart.options); } }; google.load("visualization", "1", {packages:["corechart","geochart"]}); google.setOnLoadCallback(function(){ for(var i = 0; i < window.localPage.chartsInit.length; i++) { var f = window.localPage.chartsInit[i]; f(); } }); jQuery(window).on("resize", function(){ if(window.localPage.resizeTimer) clearTimeout(window.localPage.resizeTimer); window.localPage.resizeTimer = setTimeout(window.localPage.refreshGraphs, 250); }); '); $init = true; } public function display($data, $doText = true) { if(empty($data['type'])) $data['type'] = 'text'; $ret = ''; if(!empty($data['query']) && (!isset($data['value']) \|\| $data['value'] === null)) { if(!empty($data['vars'])) { $vars = reset($data['vars']); if(is_array($vars)) { $vars = $data['vars']; $ret = array(); foreach($vars as $v) { $data['vars'] = $v; $data['value'] = null; $ret[] = $this->display($data, false); } $data['type'] = 'aggreg'; unset($data['value']); $data['value'] = $ret; } else $data['value'] = $this->processQuery($data['query'], $data['vars']); } else $data['value'] = $this->processQuery($data['query']); } $ret = ''; switch($data['type']) { case 'dynamic': $ret = $this->displayDynamic($data); break; case 'tile': $ret = $this->displayTile($data); break; case 'graph': $ret = $this->displayGraph($data); break; case 'pie': $ret = $this->displayPie($data); break; case 'geo': $ret = $this->displayGeo($data); break; case 'list': $ret = $this->displayList($data); break; case 'raw': $ret = $data['value']; break; case 'aggreg': $sep = ''; if(!empty($data['separator'])) $sep = $data['separator']; $ret = implode($sep, $data['value']); break; case 'plugin': JPluginHelper::importPlugin('hikashop'); $app = JFactory::getApplication(); $ret = $app->triggerEvent('onHikashopStatisticPluginDisplay', array($data)); if(!empty($ret) && is_array($ret)) { $arr = $ret; $ret = reset($ret); if(empty($ret)) { while(empty($ret) && !empty($arr)) { $ret = array_shift($arr); } } unset($arr); } break; case 'ad': $ret = '<div class="hikashop_starter_adv"><a href="https://www.hikashop.com/" target="_blank">' . '<img class="upgrade_hikashop_starter_adv" src="'.HIKASHOP_IMAGES.'upgrade_your_hikashop.png" alt="Upgrade your HikaShop"/>' . '</a></div>'; break; case 'text': default: $ret = $this->getFormatedValue($data['value'], $data['format']); break; } if($doText) { if(!empty($data['prefix'])) $ret = $data['prefix'] . $ret; if(!empty($data['text'])) { $tmp = JText::_($data['text']); if($tmp != $data['text']) $ret = JText::sprintf($data['text'], $ret); } if(!empty($data['suffix'])) $ret = $ret . $data['suffix']; } if(!empty($data['container'])) { $ret = ' <div class="hikashop_panel hikashop_panel_stats"> <div class="hikashop_panel_heading">'. $data['label'] .'</div> <div class="hikashop_panel_body">'.$ret.'</div> </div>'; } return $ret; } protected function displayList($data) { if(is_object($data['value'])) $data['value'] = array($data['value']); $ret = array(); foreach($data['value'] as $value) { $ret[] = $this->getFormatedValue($value, $data['format']); } if(count($ret) > 1) return '<ul><li>'. implode('</li><li>', $ret) . '</li></ul>'; return reset($ret); } protected function displayDynamic($data) { if(empty($data['value'])) return ''; if(is_object($data['value'])) $data['value'] = array($data['value']); $ret = array(); foreach($data['value'] as $value) { $content = $data['dynamic']; if(preg_match_all('#{([-:. _A-Z0-9a-z]+)}#U', $content, $out)) { foreach($out[1] as $key) { if(strpos($key, ':') !== false) { list($col, $format) = explode(':', $key, 2); } else { $col = $key; $format = $data['format']; } if(isset($value->$col)) $content = str_replace('{'.$key.'}', $this->getFormatedValue($value->$col, $format, $value), $content); else { $v = ''; if(isset($data['vars'][$key])) $v = $data['vars'][$key]; $content = str_replace('{'.$key.'}', $v, $content); } } } $ret[] = $content; } if(count($ret) > 1) { if(!empty($data['prefix']) && !empty($data['suffix'])) return implode("\r\n", $ret); return '<ul><li>'. implode('</li><li>', $ret) . '</li></ul>'; } return reset($ret); } protected function displayTile($data) { if(!is_array($data['value'])) $data['value'] = array($data['value']); if(isset($data['vars-2'])) { $data['value'][] = $this->processQuery($data['query'], $data['vars-2']); } if(isset($data['format']) && $data['format'] == 'percentage' && count($data['value']) == 2) { $a = hikashop_toFloat($data['value'][0]); $b = hikashop_toFloat($data['value'][1]); $data['value'] = array(0); if($b > 0) $data['value'] = array( round($a / $b * 100) ); } $d = array(); foreach($data['value'] as $value) { $d[] = $this->getFormatedValue($value, @$data['format']); } $value = $this->getMergedValue($d, @$data['format']); if(!empty($data['tile']['mode']) && $data['tile']['mode'] == 'small') { $background = ''; if(!empty($data['tile']['image']) && empty($value->image) && !empty($value->id)) { $query = 'SELECT file_path FROM #__hikashop_file WHERE file_ref_id = '.(int)$value->id.' AND file_type = ' . $this->db->Quote($data['tile']['image']).' ORDER BY file_ordering ASC LIMIT 1'; $this->db->setQuery($query); $image = $this->db->loadResult(); if(!empty($image)) $value->image = $image; } if(isset($value->image)) { $imageHelper = hikashop_get('helper.image'); $img = $imageHelper->getThumbnail($value->image, array(150,150), array('default' => true), true); $background = '<img src="'.$img->url.'" alt=""/>'; } elseif(isset($data['tile']['background']) && $data['tile']['background']['value'] == 'fa') { $background = '<i class="fa fa-'.$data['tile']['background']['value'].'"></i>'; } if(empty($value->name) && isset($data['tile']['name'])) { foreach($data['tile']['name'] as $k) { if(isset($value->$k) && !empty($value->$k)) $value->name = $value->$k; } } if(!is_object($value)) { $tmp = $value; $value = new stdClass; $value->name = $tmp; unset($tmp); } if(!empty($data['tile']['translate'])) $value->name = hikashop_translate($value->name); return ' <div class="cpanel-smalltile-block"> <div class="cpanel-tile-background">'.$background.'</div> <div class="cpanel-tile-header">'.$data['label'].'</div> <div class="cpanel-tile-name">'.$value->name.'</div> <div class="cpanel-tile-details"></div> </div> '; } $icon = ''; $compare = ''; $footer = ''; $extra_class = ''; if(!empty($data['tile']['icon']['type']) && $data['tile']['icon']['type'] == 'fa') { $icon = '<i class="fa fa-'.$data['tile']['icon']['value'].'"></i>'; } if(!empty($data['tile']['view'])) { $t = JText::_('HIKA_VIEW_MORE'); $l = '#'; if(is_string($data['tile']['view'])) { $l = $data['tile']['view']; } elseif(is_array($data['tile']['view'])) { if(isset($data['tile']['view']['title'])) $t = $data['tile']['view']['title']; if(isset($data['tile']['view']['link'])) $l = $data['tile']['view']['link']; if(!empty($data['tile']['view']['process']) && !empty($data['tile']['view']['value'])) { $l = $data['tile']['view']['value']; $array = $value; if(is_object($value)) { $array = get_object_vars($value); } if(is_array($array)){ foreach($array as $k => $v) { $l = str_replace('{'.strtoupper($k).'}', $v, $l); } } $l = hikashop_completeLink($l); } } $footer = '<a href="'.$l.'">'.$t.'</a>'; } $text = $value; if(is_object($value)) { $text = ''; if(empty($data['tile']['name'])) $data['tile']['name'] = array('name'); if(!is_array($data['tile']['name'])) $data['tile']['name'] = array($data['tile']['name']); foreach($data['tile']['name'] as $k) { if(isset($value->$k) && !empty($value->$k)) $text = $value->$k; } } if(!empty($data['tile']['class'])) $extra_class = ' '.trim($data['tile']['class']); if(empty($footer)) $footer = '<div class="cpanel-tile-footer-empty"></div>'; else $footer = '<div class="cpanel-tile-footer">'.$footer.'</div>'; return ' <div class="cpanel-tile-block'.$extra_class.'"> <div class="cpanel-tile-header"> '.$data['label'].' <span class="cpanel-right">'.$compare.'</span> </div> <div class="cpanel-tile-body"> '.$icon.' <h2 class="cpanel-right">'.$text.'</h2> </div> '.$footer.' <div style="clear:both"></div> </div>'; } protected function displayGraph($data) { $this->initJS(@$data['vendor_id']); $id = uniqid(); list($headerData, $chartData) = $this->processGraphData($data); $viewport = ',hAxis:{viewWindow:{min:0,max:'.count($chartData).'}}'; $theme = ',chartArea:{width:"90%"}'; $ranges = $this->getDateRangeList(); $currentRange = isset($data['vars']['DATE_RANGE']) ? $data['vars']['DATE_RANGE'] : @$data['vars']['_DATE_RANGE']; $currentGroup = 'day'; if(strpos($currentRange, ':') !== false) list($currentRange, $currentGroup) = explode(':', $currentRange, 2); $js = ' window.localPage.chartsInit[window.localPage.chartsInit.length] = function() { var data = google.visualization.arrayToDataTable(['. '["' . implode('","', $headerData). '"]'. (empty($chartData) ? '' : ',[') . implode('],[', $chartData). (empty($chartData) ? '' : ']') . ']); var options = {legend:{position:"bottom"},focusTarget:"category",animation:{duration:500,easing:"in"}'.$theme.$viewport.'}; var chart = new google.visualization.LineChart(document.getElementById("hikashop_chart_'.$id.'_div")); chart.draw(data, options); window.localPage.charts["'.$id.'"] = {chart: chart, options:options, data:data, max:'.count($chartData).', period:"'.$currentRange.'",periodGroup:"'.$currentGroup.'"}; }; '; unset($chartData); $doc = JFactory::getDocument(); $doc->addScriptDeclaration($js); $dropdownHelper = hikashop_get('helper.dropdown'); $groups = array('year'=>'','month'=>'','week'=>'','day'=>''); foreach($groups as $k => &$v) { $v = array( 'name' => JText::_('HIKA_PERIOD_BY_'.strtoupper($k)), 'link' => '#'.$k, 'click' => 'return window.localPage.changeChartData(\'graph\',\''.$id.'\',\''.$data['key'].'\',\':'.$k.'\', this);' ); } unset($v); $dropData = array(); foreach($ranges as $k => $v) { if(strpos($k, '.day') !== false) continue; $dropData[] = array('name' => JText::_($v), 'link' => '#'.$k, 'click' => 'return window.localPage.changeChartData(\'graph\',\''.$id.'\',\''.$data['key'].'\',\''.$k.'\', this);'); } $drop = $dropdownHelper->display(JText::_($ranges[ $currentRange ]), $dropData, array('type' => '','right' => true,'up' => false, 'label-id' => 'hikashop_chart_'.$id.'_range')). $dropdownHelper->display(JText::_('HIKA_PERIOD_BY_'.strtoupper($currentGroup)), $groups, array('type' => '','right' => true,'up' => false, 'label-id' => 'hikashop_chart_'.$id.'_group')); return ' <div class="hikashop_chart_data_selector" style="float:right">'.$drop.'</div><div style="clear:both"></div> <div id="hikashop_chart_'.$id.'_div" style="width:100%; height: 250px;"><div class="hikashop_empty_chart">'.JText::_('HIKA_LOADING_CHART').'</div></div>'; } protected function processGraphData($data) { if(empty($data['type']) \|\| $data['type'] != 'graph') return array(false,false); if(!empty($data['query']) && (!isset($data['value']) \|\| $data['value'] === null)) { if(!empty($data['vars'])) { $data['value'] = $this->processQuery($data['query'], $data['vars']); } else $data['value'] = $this->processQuery($data['query']); } $col = $data['graph']['cols']; $headerData = array('Date'); $default = array(); if(!empty($data['value'])) { foreach($data['value'] as $value) { if(!isset($headerData[ 'col_'.$value->$col ])) { $headerData[ 'col_'.$value->$col ] = $value->$col; $default[$value->$col] = '0'; } } } else if(!empty($data['query']) && !empty($data['vars']) && isset($data['vars']['DATE_START'])) { $vars = $data['vars']; $vars['DATE_START'] = 0; $vars['DATE_END'] = -1; $vars['_DATE_RANGE'] = $vars['DATE_RANGE']; unset($vars['DATE_RANGE']); $headerValues = $this->processQuery($data['query'], $vars, 1); foreach($headerValues as $value) { if(!isset($headerData[ 'col_'.$value->$col ])) { $headerData[ 'col_'.$value->$col ] = $value->$col; $default[$value->$col] = '0'; } } } $chartData = array(); if(count($headerData) == 1) return array($headerData, $chartData); if(!empty($data['graph']['axis']) && $data['graph']['axis'] == 'date') { if(!empty($data['vars']['DATE_RANGE'])) $this->setDateRange($data, $data['vars']['DATE_RANGE']); if(empty($data['vars']['DATE_START'])) { $first = reset($data['value']); $first = $first->axis; $d = explode('-', $first, 3); if(!isset($d[2])) $d[2] = 1; if(!isset($d[1])) $d[1] = 1; $first = mktime(1,0,0,(int)$d[1],(int)$d[2],(int)$d[0]) - $this->timeoffset; } else { $first = $data['vars']['DATE_START'] - $this->timeoffset; } if(empty($data['vars']['DATE_END']) \|\| $data['vars']['DATE_END'] < 0) { $end = end($data['value']); $end = $end->axis; $d = explode('-', $end, 3); if(!isset($d[2])) $d[2] = 1; if(!isset($d[1])) $d[1] = 1; $end = mktime(1,0,0,(int)$d[1],(int)$d[2],(int)$d[0]) - $this->timeoffset; } else { $end = $data['vars']['DATE_END'] - $this->timeoffset; } $now = $end; if($now >= $first) { $inc = 86400; $format = 'Y-m-d'; switch(@$data['vars']['DATE_GROUP']) { case 'year': $format = 'Y'; $inc = 8640000; break; case 'month': $format = 'Y-m'; $inc = 864000; break; case 'week': $format = 'Y W'; $inc = 604800; break; } do { $chartData[ date($format, $first) ] = (array)$default; $first += $inc; } while($first < $now); if(!isset($chartData[ date($format, $now) ])) $chartData[ date($format, $now) ] = (array)$default; } } foreach($data['value'] as $value) { if(!isset($chartData[ $value->axis ])) { $chartData[ $value->axis ] = (array)($default); } $chartData[ $value->axis ][ $value->$col ] = strip_tags($value->value); } ksort($chartData); foreach($chartData as $k => &$d) { $d = '"' . strip_tags(str_replace('"','\\"', $k)) . '",' . strip_tags(implode(',', $d)); } unset($d); return array($headerData, $chartData); } protected function displayPie($data) { $this->initJS(@$data['vendor_id']); $id = uniqid(); list($headerData, $chartData) = $this->processPieData($data); $options = ''; if(!empty($data['pie']['donut'])) $options .= ',pieHole:0.4'; if(!empty($data['pie']['3d'])) $options .= ',is3D:true'; if(isset($data['pie']['legend']) && $data['pie']['legend'] === false) $options .= ',legend:"none"'; if(!empty($data['pie']['text']) && in_array($data['pie']['text'], array('label','percentage','value'))) $options .= ',pieSliceText:"'.$data['pie']['text'].'"'; $js = ' window.localPage.chartsInit[window.localPage.chartsInit.length] = function() { var data = google.visualization.arrayToDataTable(['. '["' . implode('","', $headerData). '"]'. (empty($chartData) ? '' : ',[') . implode('],[', $chartData). (empty($chartData) ? '' : ']') . ']); var options = {animation:{duration:500,easing:"in"}'.$options.'}; var chart = new google.visualization.PieChart(document.getElementById("hikashop_chart_'.$id.'_div")); chart.draw(data, options); window.localPage.charts["'.$id.'"] = {chart: chart, options:options, data:data, max:'.count($chartData).'}; }; '; $doc = JFactory::getDocument(); $doc->addScriptDeclaration($js); $dropdownHelper = hikashop_get('helper.dropdown'); $ranges = $this->getDateRangeList(); $dropData = array(); $currentRange = ''; if(isset($data['vars']['DATE_RANGE'])) $currentRange = JText::_($ranges[ $data['vars']['DATE_RANGE'] ]); else if(isset($data['vars']['_DATE_RANGE'])) $currentRange = JText::_($ranges[ $data['vars']['_DATE_RANGE'] ]); foreach($ranges as $k => $v) { $dropData[] = array('name' => JText::_($v), 'link' => '#'.$k, 'click' => 'return window.localPage.changeChartData(\'pie\',\''.$id.'\',\''.$data['key'].'\',\''.$k.'\', this);'); } $drop = $dropdownHelper->display($currentRange, $dropData, array('type' => '','right' => true,'up' => false, 'label-id' => 'hikashop_chart_'.$id.'_range')); return ' <div class="hikashop_chart_data_selector" style="float:right">'.$drop.'</div><div style="clear:both"></div> <div id="hikashop_chart_'.$id.'_div" style="width:100%; height: 250px;"><div class="hikashop_empty_chart">'.JText::_('HIKA_LOADING_CHART').'</div></div>'; } protected function processPieData($data) { if(empty($data['type']) \|\| $data['type'] != 'pie') return array(false,false); if(!empty($data['query']) && (!isset($data['value']) \|\| $data['value'] === null)) { if(!empty($data['vars'])) { $data['value'] = $this->processQuery($data['query'], $data['vars']); } else $data['value'] = $this->processQuery($data['query']); } $headerData = array('Key','Value'); if(isset($data['pie']['header'])) $headerData = $data['pie']['header']; $chartData = array(); $key = $data['pie']['key']; foreach($data['value'] as $value) { $chartData[ $value->$key ] = $value->value; } if(empty($chartData)) return array($headerData, $chartData); foreach($chartData as $k => &$d) { if(is_array($d)) $d = '"'.strip_tags(str_replace('"','\\"', $k)) . '",' . strip_tags(implode(',', $d)); else $d = '"' . strip_tags(str_replace('"','\\"', $k)) . '",' . strip_tags($d); } unset($d); return array($headerData, $chartData); } protected function displayGeo($data) { $this->initJS(@$data['vendor_id']); $id = uniqid(); list($headerData, $chartData) = $this->processGeoData($data); $options = array(); $js = ' window.localPage.chartsInit[window.localPage.chartsInit.length] = function() { var data = google.visualization.arrayToDataTable(['. '["' . implode('","', $headerData). '"]'. (empty($chartData) ? '' : ',[') . implode('],[', $chartData). (empty($chartData) ? '' : ']') . ']); var options = {'.implode(',', $options).'}; var chart = new google.visualization.GeoChart(document.getElementById("hikashop_chart_'.$id.'_div")); chart.draw(data, options); window.localPage.charts["'.$id.'"] = {chart:chart, options:options, data:data}; }; '; $doc = JFactory::getDocument(); $doc->addScriptDeclaration($js); $dropdownHelper = hikashop_get('helper.dropdown'); $ranges = $this->getDateRangeList(); $dropData = array(); $currentRange = ''; if(isset($data['vars']['DATE_RANGE'])) $currentRange = JText::_($ranges[ $data['vars']['DATE_RANGE'] ]); else if(isset($data['vars']['_DATE_RANGE'])) $currentRange = JText::_($ranges[ $data['vars']['_DATE_RANGE'] ]); foreach($ranges as $k => $v) { $dropData[] = array('name' => JText::_($v), 'link' => '#'.$k, 'click' => 'return window.localPage.changeChartData(\'geo\',\''.$id.'\',\''.$data['key'].'\',\''.$k.'\', this);'); } $drop = $dropdownHelper->display($currentRange, $dropData, array('type' => '','right' => true,'up' => false, 'label-id' => 'hikashop_chart_'.$id.'_range')); return ' <div class="hikashop_chart_data_selector" style="float:right">'.$drop.'</div><div style="clear:both"></div> <div id="hikashop_chart_'.$id.'_div" style="width:100%; height: 250px;"><div class="hikashop_empty_chart">'.JText::_('HIKA_LOADING_CHART').'</div></div>'; return ''; } protected function processGeoData($data) { if(empty($data['type']) \|\| $data['type'] != 'geo') return array(false,false); if(!empty($data['query']) && (!isset($data['value']) \|\| $data['value'] === null)) { if(!empty($data['vars'])) { $data['value'] = $this->processQuery($data['query'], $data['vars']); } else $data['value'] = $this->processQuery($data['query']); } $headerData = array('Country','Value'); if(isset($data['geo']['header'])) $headerData = $data['geo']['header']; $chartData = array(); $key = $data['geo']['key']; foreach($data['value'] as $value) { $chartData[ $value->$key ] = $value->value; } if(empty($chartData)) return array($headerData, $chartData); foreach($chartData as $k => &$d) { if(is_array($d)) $d = '"'.strip_tags(str_replace('"','\\"', $k)) . '",' . strip_tags(implode(',', $d)); else $d = '"' . strip_tags(str_replace('"','\\"', $k)) . '",' . strip_tags($d); } unset($d); return array($headerData, $chartData); return array(false,false); } protected function getFormatedValue($value, $format, $data = array()) { $ret = null; switch($format) { case 'number': $ret = (int)$value; break; case 'date': $ret = hikashop_getDate($value); break; case 'price': if(empty($this->currencyClass)) $this->currencyClass = hikashop_get('class.currency'); $currency_id = 0; if(!empty($data) && is_array($data)) $currency_id = (int)@$data['currency']; if(!empty($data) && is_object($data)) $currency_id = (int)@$data->currency; if(is_object($value)) { if(isset($value->currency)) $currency_id = $value->currency; $value = $value->value; } $ret = str_replace(' ', ' ', $this->currencyClass->format($value, $currency_id)); break; case 'percentage': $ret = round(hikashop_toFloat($value), 2).'%'; break; case 'translation': case 'trans': $ret = JText::_($value); break; case 'order_status': $ret = '<span class="order-label order-label-' . preg_replace('#[^a-z_0-9]#i', '_', str_replace(' ','_', $value)).'">' . hikashop_orderStatus($value) . '</span>'; break; case 'order_link': $order_id = 0; if(!empty($data)) { if(is_array($data)) $order_id = (int)@$data['order_id']; if(is_object($data)) $order_id = (int)@$data->order_id; } if($order_id > 0) { $ret = '<a href="'.hikashop_completeLink('order&task=show&cid='.$order_id).'">'.$value.'</a>'; } else $ret = $value; break; case 'string': default: $ret = $value; break; } return $ret; } protected function getMergedValue($value, $format, $data = array()) { $f = reset($value); if(is_object($f)) return $f; return implode('<br/>', $value); } }

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