Gecko [ contributie.vriendennsm.nl ]

Name	Size	Permission	Date
report_itemised	[ DIR ]	drwxr-xr-x	2025-02-08 22:29
index.html	249 B	-rwxr-xr-x	2022-02-20 10:42
report_itemised.php	5.02 KB	-rwxr-xr-x	2022-02-20 10:42
report_itemised.xml	870 B	-rwxr-xr-x	2022-02-20 10:42

Rename

<?php
/**
 * @package J2Store
 * @copyright Copyright (c)2014-17 Ramesh Elamathi / J2Store.org
 * @license GNU GPL v3 or later
 */
/** ensure this file is being included by a parent file */
defined('_JEXEC') or die('Restricted access');
require_once(JPATH_ADMINISTRATOR.'/components/com_j2store/library/plugins/report.php');
class plgJ2StoreReport_itemised extends J2StoreReportPlugin
{
	/**
	 * @var $_element  string  Should always correspond with the plugin's filename,
	 *                         forcing it to be unique
	 */
    var $_element   = 'report_itemised';

/**
     * Overriding
     *
     * @param $options
     * @return unknown_type
     */
    function onJ2StoreGetReportView( $row )
    {
	   	if (!$this->_isMe($row))
    	{
    		return null;
    	}

$html = $this->viewList();

return $html;
    }

/**
     * Validates the data submitted based on the suffix provided
     * A controller for this plugin, you could say
     *
     * @param $task
     * @return html
     */
    function viewList()
    {
    	$app = JFactory::getApplication();
    	$option = 'com_j2store';
    	$ns = $option.'.report';
    	$html = "";
    	JToolBarHelper::title(JText::_('J2STORE_REPORT').'-'.JText::_('PLG_J2STORE_'.strtoupper($this->_element)),'j2store-logo');

$vars = new JObject();
	   	//$this->includeCustomModel('Reportitemised');
    	//$this->includeCustomTables();
        F0FModel::addIncludePath(JPATH_SITE . '/plugins/j2store/' . $this->_element . '/' . $this->_element . '/models');
        F0FModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_j2store/models');
        F0FTable::addIncludePath(JPATH_SITE . '/plugins/j2store/' . $this->_element . '/' . $this->_element . '/tables');
        F0FTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_j2store/tables');

$model = F0FModel::getTmpInstance('ReportItemised', 'J2StoreModel');
    	$model->setState('limit',$app->input->getInt('limit',0));
    	$model->setState('limitstart',$app->input->getInt('limitstart',0));
    	$model->setState('filter_search', $app->input->getString('filter_search'));
    	$model->setState('filter_orderstatus', $app->input->getString('filter_orderstatus'));
    	$model->setState('filter_order', $app->input->getString('filter_order','oi.j2store_orderitem_id'));
    	$model->setState('filter_order_Dir', $app->input->getString('filter_order_Dir'));
		$model->setState('filter_datetype', $app->input->getString('filter_datetype'));
        try {
            $list = $model->getData();
            //$list = $model->getList();
            $vars->list = $list;
            $vars->total = $model->getTotal();
            $vars->total = 0;
        } catch (Exception $e) {
            $vars->list = array();
        }
        $vars->state = $model->getState();
    	$vars->pagination = $model->getPagination();
    	$vars->orderStatus =F0FModel::getTmpInstance('OrderStatuses','J2StoreModel')->enabled(1)->getList();
		$vars->orderDateType = $this->getOrderDateType ();
    	$id = $app->input->getInt('id', '0');
    	$vars->id = $id;
    	$form = array();
    	$form['action'] = "index.php?option=com_j2store&view=report&task=view&id={$id}";
    	$vars->form = $form;
    	$html = $this->_getLayout('default', $vars);
    	return $html;
    }

//search order by days type
	public function getOrderDateType(){
		$data = array(
			'select' =>JText::_('J2STORE_DAY_TYPES'),
			'today' => JText::_('J2STORE_TODAY'),
			'this_week' => JText::_('J2STORE_THIS_WEEK'),
			'this_month' => JText::_('J2STORE_THIS_MONTH'),
			'this_year' => JText::_('J2STORE_THIS_YEAR'),
			'last_7day' => JText::_('J2STORE_LAST_7_DAYS'),
			'last_month' => JText::_('J2STORE_LAST_MONTH'),
			'last_year' => JText::_('J2STORE_LAST_YEAR')
		);
		return $data;
	}

function onJ2StoreGetReportExported($row){
    	$app = JFactory::getApplication();

$ignore_column =array('sum','count','orderitem_quantity','product_source_id','id');
    	//$this->includeCustomModel('Reportitemised');
    	if (!$this->_isMe($row))
    	{
    		return null;
    	}
        F0FModel::addIncludePath(JPATH_SITE . '/plugins/j2store/' . $this->_element . '/' . $this->_element . '/models');
        F0FModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_j2store/models');
        F0FTable::addIncludePath(JPATH_SITE . '/plugins/j2store/' . $this->_element . '/' . $this->_element . '/tables');
        F0FTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_j2store/tables');
    	$model = F0FModel::getTmpInstance('ReportItemised', 'J2StoreModel');
    	$items = $model->getData();
  		foreach($items as &$item){
			$item->orderitem_options ='';
			if(isset($item->orderitem_attributes) && $item->orderitem_attributes){
				foreach($item->orderitem_attributes as $attr){
					unset($item->orderitem_attributes);
					$item->orderitem_options.=$attr->orderitemattribute_name .' : '.$attr->orderitemattribute_value;
				}
			}
			$item->qty = $item->sum;
			$item->total_purchase = $item->count;

foreach($ignore_column as $key =>$value){
				unset($item->$value);
			}
  		}
	   	return $items;
    }

}