PHP Tienda::load方法代码示例

 /**
  * 
  * @return unknown_type
  */
 function getItems()
 {
     // Check the registry to see if our Tienda class has been overridden
     if (!class_exists('Tienda')) {
         JLoader::register("Tienda", JPATH_ADMINISTRATOR . "/components/com_tienda/defines.php");
     }
     // load the config class
     Tienda::load('Tienda', 'defines');
     JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/tables');
     JModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/models');
     // get the model
     $model = JModel::getInstance('Manufacturers', 'TiendaModel');
     // TODO Make this depend on the current filter_category?
     // setting the model's state tells it what items to return
     $model->setState('filter_enabled', '1');
     $model->setState('order', 'tbl.manufacturer_name');
     // set the states based on the parameters
     // using the set filters, get a list
     $items = $model->getList();
     if (!empty($items)) {
         foreach ($items as $item) {
             // this gives error
             $item->itemid = Tienda::getClass("TiendaHelperRoute", 'helpers.route')->manufacturer($item->manufacturer_id, false);
             if (empty($item->itemid)) {
                 $item->itemid = $this->params->get('itemid');
             }
         }
     }
     return $items;
 }

 /**
  * downloads a file
  *
  * @return void
  */
 function downloadFile()
 {
     $user = JFactory::getUser();
     $productfile_id = intval(JRequest::getvar('id', '', 'request', 'int'));
     $product_id = intval(JRequest::getvar('product_id', '', 'request', 'int'));
     $link = 'index.php?option=com_tienda&view=products&task=edit&id=' . $product_id;
     Tienda::load('TiendaHelperBase', 'helpers._base');
     $helper = TiendaHelperBase::getInstance('ProductDownload', 'TiendaHelper');
     JTable::addIncludePath(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_tienda' . DS . 'tables');
     $productfile = JTable::getInstance('ProductFiles', 'TiendaTable');
     $productfile->load($productfile_id);
     if (empty($productfile->productfile_id)) {
         $this->messagetype = 'notice';
         $this->message = JText::_('COM_TIENDA_INVALID FILE');
         $this->setRedirect($link, $this->message, $this->messagetype);
         return false;
     }
     // log and download
     Tienda::load('TiendaFile', 'library.file');
     // geting the ProductDownloadId to updated for which productdownload_max  is greater then 0
     $productToDownload = $helper->getProductDownloadInfo($productfile->productfile_id, $user->id);
     if ($downloadFile = TiendaFile::download($productfile)) {
         $link = JRoute::_($link, false);
         $this->setRedirect($link);
     }
 }

 /**
  * Override parent::_getData()
  *
  * @return unknown_type
  */
 function _getData()
 {
     $app = JFactory::getApplication();
     Tienda::load('TiendaQuery', 'library.query');
     // just in case
     $db = JFactory::getDbo();
     $state = $this->_getState();
     $model = $this->_getModel();
     // filter only complete orders ( 3 - Shipped, 5 - Complete, 17 - Payment Received )
     $order_states = array('3', '5', '17');
     $model->setState('filter_orderstates', $order_states);
     $model->setState('order', '`price_total`');
     $model->setState('direction', 'DESC');
     $query = $model->getQuery(true);
     $query->group('p.manufacturer_id');
     $field[] = " SUM(tbl.orderitem_final_price) AS `price_total` ";
     $field[] = " SUM(tbl.orderitem_quantity) AS `count_items` ";
     $query->select($field);
     $model->setQuery($query);
     $list = $model->getList();
     if (!count($list)) {
         return $list;
     }
     return $list;
 }

    function fetchElement($name, $value, &$node, $control_name)
    {
        $output = '<span class="k2Note">' . JText::_('Click Apply to be able to create product attributes') . '</span>';
        $id = JRequest::getInt('cid');
        if ($id) {
            $K2Item = JTable::getInstance('K2Item', 'Table');
            $K2Item->load($id);
            $params = new K2Parameter($K2Item->plugins, JPATH_PLUGINS . '/k2/tienda.xml', 'tienda');
            $productID = $params->get('productID');
            if ($productID) {
                Tienda::load('TiendaUrl', 'library.url');
                Tienda::load("TiendaHelperProduct", 'helpers.product');
                $attributes = TiendaHelperProduct::getAttributes($productID);
                $output = '<div class="tiendaButton">' . TiendaUrl::popup("index.php?option=com_tienda&controller=products&task=setattributes&id=" . $productID . "&tmpl=component", JText::_('Set Attributes')) . '</div>';
                $output .= '<div>';
                foreach (@$attributes as $attribute) {
                    $output .= '
					<div>
						<span>' . $attribute->productattribute_name . '(' . $attribute->option_names_csv . ')</span>
						<div class="tiendaButton">' . TiendaUrl::popup("index.php?option=com_tienda&controller=products&task=setattributeoptions&id=" . $attribute->productattribute_id . "&tmpl=component", JText::_('Set Attribute Options')) . '</div>
						<div class="tiendaButton"><a href="' . "index.php?option=com_tienda&controller=productattributes&task=delete&cid[]=" . $attribute->productattribute_id . "&return=" . base64_encode("index.php?option=com_k2&view=item&cid=" . $id) . '">' . JText::_('Remove') . '</a></div>
					</div>';
                }
                $output .= '</div>';
            }
        }
        return $output;
    }

 /**
  * Method to calculate statistics about manufacturers in an order
  * 
  * @param $items Array of order items
  * 
  * @return	Array with list of manufacturers and their stats
  */
 function calculateStatsOrder($items)
 {
     $db = JFactory::getDbo();
     JModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/models');
     Tienda::load('TiendaQuery', 'library.query');
     $q = new TiendaQuery();
     $q->select('manufacturer_id');
     $q->from('`#__tienda_products`');
     $result = array();
     foreach ($items as $item) {
         $q->where('product_id = ' . (int) $item->product_id);
         $db->setQuery($q);
         $res = $db->loadObject();
         if ($res == null) {
             $man_id = 0;
         } else {
             $man_id = $res->manufacturer_id;
         }
         if (!isset($result[$man_id])) {
             $model = JModel::getInstance('Manufacturers', 'TiendaModel');
             $model->setId($man_id);
             if (!($man_item = $model->getItem())) {
                 $man_item = new stdClass();
             }
             $result[$man_id] = $man_item;
             $result[$man_id]->subtotal = 0;
             $result[$man_id]->total_tax = 0;
         }
         $result[$man_id]->subtotal += $item->orderitem_final_price;
         $result[$man_id]->total_tax += $item->orderitem_tax;
     }
     return $result;
 }

 /**
  * Method to process the export
  * @return 
  */
 function processExport()
 {
     $export = new JObject();
     if (empty($this->_model)) {
         $this->_errors = JText::_('COM_TIENDA_PLEASE_SET_A_MODEL_IN_THE_PLUGIN_METHOD_PROCESSEXPORT');
         return $this;
     }
     $classname = 'TiendaGenericExporterModel' . $this->_model;
     if (version_compare(JVERSION, '1.6.0', 'ge')) {
         // Joomla! 1.6+ code here
         Tienda::load($classname, 'genericexporter.genericexporter.models.' . $this->_model, array('site' => 'site', 'type' => 'plugins', 'ext' => 'tienda'));
     } else {
         // Joomla! 1.5 code here
         Tienda::load($classname, 'genericexporter.models.' . $this->_model, array('site' => 'site', 'type' => 'plugins', 'ext' => 'tienda'));
     }
     $class = new $classname();
     $items = $class->loadDataList();
     $this->_modelone = $class->getSingleName();
     if (empty($items)) {
         $this->_errors = JText::_('COM_TIENDA_NO_DATA_FOUND');
         return $this;
     }
     //convert items to array upto child nodes
     //$items = $this->objectToArray( $items );
     $f_name = $this->_model . '_' . time() . '.xml';
     $this->_link = 'tmp/' . $f_name;
     $this->_name = $f_name;
     if (!($res = $this->fromXMLToFile('tmp/' . $f_name, $items))) {
         $this->_errors = JText::_('COM_TIENDA_ERROR_SAVING_FILE');
     }
     return $this;
 }

 function export()
 {
     Tienda::load('TiendaCSV', 'library.csv');
     $request = JRequest::get('request');
     //// load the plugins
     JPluginHelper::importPlugin('tienda');
     JModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/models');
     $params = json_decode(base64_decode($request['exportParams']));
     $model = JModel::getInstance($params->view, 'TiendaModel');
     $list = $model->getList();
     $arr = array();
     $header = array();
     // header -> it'll be filled out when
     $fill_header = true;
     // we need to fill header
     for ($i = 0, $c = count($list); $i < $c; $i++) {
         if ($fill_header) {
             $list_vars = get_object_vars($list[$i]);
             foreach ($list_vars as $key => $value) {
                 if ($fill_header) {
                     $header[] = $key;
                 }
             }
             $fill_header = false;
             // header is filled
         }
         $arr[] = $this->objectToString($list[$i], true);
     }
     $f_name = 'tmp/' . $params->view . '_' . time() . '.csv';
     $res = TiendaCSV::FromArrayToFile($f_name, $arr, $header);
     $this->render_page($f_name, $params->view);
 }

 function setRates()
 {
     Tienda::load('TiendaGrid', 'library.grid');
     Tienda::load('TiendaSelect', 'library.select');
     $this->includeCustomModel('ShippingRatesWeightbased');
     $sid = JRequest::getVar('sid');
     $this->includeCustomTables();
     $row = JTable::getInstance('ShippingMethodsWeightbased', 'TiendaTable');
     $row->load($sid);
     $model = JModel::getInstance('ShippingRatesWeightbased', 'TiendaModel');
     $model->setState('filter_shippingmethod', $sid);
     $app = JFactory::getApplication();
     $ns = $this->getNamespace();
     $state = array();
     $state['limit'] = $app->getUserStateFromRequest('global.list.limit', 'limit', $app->getCfg('list_limit'), 'int');
     $state['limitstart'] = $app->getUserStateFromRequest($ns . 'limitstart', 'limitstart', 0, 'int');
     foreach (@$state as $key => $value) {
         $model->setState($key, $value);
     }
     $items = $model->getList();
     //form
     $form = array();
     $form['action'] = $this->baseLink();
     // view
     $view = $this->getView('shipping_weightbased', 'html');
     $view->hidemenu = true;
     $view->hidestats = true;
     $view->setModel($model, true);
     $view->assign('row', $row);
     $view->assign('items', $items);
     $view->assign('form2', $form);
     $view->assign('baseLink', $this->baseLink());
     $view->setLayout('setrates');
     $view->display();
 }

    function fetchElement($name, $value, &$node, $control_name)
    {
        $output = '
		<input type="text" class="text_area" value="" id="pluginstiendaproductPrice" name="plugins[tiendaproductPrice]">
		<span class="k2Note">' . JText::_('Set Normal Price Now Special Prices Later') . '</span>
		';
        $id = JRequest::getInt('cid');
        if ($id) {
            $K2Item = JTable::getInstance('K2Item', 'Table');
            $K2Item->load($id);
            $params = new K2Parameter($K2Item->plugins, JPATH_PLUGINS . '/k2/tienda.xml', 'tienda');
            $productID = $params->get('productID');
            if ($productID) {
                Tienda::load('TiendaUrl', 'library.url');
                Tienda::load("TiendaHelperProduct", 'helpers.product');
                $prices = TiendaHelperProduct::getPrices($productID);
                if (count($prices)) {
                    $output = '<div class="tiendaButton">' . TiendaUrl::popup("index.php?option=com_tienda&controller=products&task=setprices&id=" . $productID . "&tmpl=component", JText::_('COM_TIENDA_SET_PRICES')) . '</div>';
                    $output .= '<div>';
                    foreach (@$prices as $price) {
                        $output .= '
						<div>
							<span>' . TiendaHelperBase::currency($price->product_price) . '</span>
							<div class="tiendaButton"><a href="' . $price->link_remove . '&return=' . base64_encode("index.php?option=com_k2&view=item&cid=" . $id) . '">' . JText::_('Remove') . '</a></div>
						</div>';
                    }
                    $output .= '</div>';
                }
            }
        }
        return $output;
    }

 /**
  * Checks row for data integrity.
  * Assumes working dates have been converted to local time for display,
  * so will always convert working dates to GMT
  *
  * @return unknown_type
  */
 function check()
 {
     if (empty($this->product_id)) {
         $this->setError(JText::_('COM_TIENDA_PRODUCT_ASSOCIATION_REQUIRED'));
         return false;
     }
     $offset = JFactory::getConfig()->getValue('config.offset');
     if (isset($this->publishing_date)) {
         $this->publishing_date = date('Y-m-d H:i:s', strtotime(TiendaHelperBase::getOffsetDate($this->publishing_date, -$offset)));
     }
     $nullDate = $this->_db->getNullDate();
     Tienda::load('TiendaHelperBase', 'helpers._base');
     if (empty($this->created_date) || $this->created_date == $nullDate) {
         $date = JFactory::getDate();
         $this->created_date = $date->toMysql();
     }
     $date = JFactory::getDate();
     $this->modified_date = $date->toMysql();
     $act = strtotime(Date('Y-m-d', strtotime($this->publishing_date)));
     $db = $this->_db;
     if (empty($this->product_issue_id)) {
         $q = 'SELECT `publishing_date` FROM `#__tienda_productissues` WHERE `product_id`=' . $this->product_id . ' ORDER BY `publishing_date` DESC LIMIT 1';
         $db->setQuery($q);
         $next = $db->loadResult();
         if ($next === null) {
             return true;
         }
         $next = strtotime($next);
         if ($act <= $next) {
             $this->setError(JText::_('COM_TIENDA_PUBLISHING_DATE_IS_NOT_PRESERVING_ISSUE_ORDER') . ' - ' . $this->publishing_date);
             return false;
         }
     } else {
         $q = 'SELECT `publishing_date` FROM `#__tienda_productissues` WHERE `product_issue_id`=' . $this->product_issue_id;
         $db->setQuery($q);
         $original = $db->loadResult();
         if ($act == strtotime(Date('Y-m-d', strtotime($original)))) {
             return true;
         }
         $q = 'SELECT `publishing_date` FROM `#__tienda_productissues` WHERE `product_id`=' . $this->product_id . ' AND `publishing_date` < \'' . $original . '\' ORDER BY `publishing_date` DESC LIMIT 1';
         $db->setQuery($q);
         $prev = $db->loadResult();
         $q = 'SELECT `publishing_date` FROM `#__tienda_productissues` WHERE `product_id`=' . $this->product_id . ' AND `publishing_date` > \'' . $original . '\' ORDER BY `publishing_date` ASC LIMIT 1';
         $db->setQuery($q);
         $next = $db->loadResult();
         if ($prev === null) {
             $prev = 0;
         } else {
             $prev = strtotime($prev);
         }
         if ($next) {
             $next = strtotime($next);
         }
         if ($prev >= $act || $next && $next <= $act) {
             $this->setError(JText::_('COM_TIENDA_PUBLISHING_DATE_IS_NOT_PRESERVING_ISSUE_ORDER') . ' - ' . $this->publishing_date);
             return false;
         }
     }
     return true;
 }

 function __construct($config = array())
 {
     parent::__construct($config);
     $this->defines = Tienda::getInstance();
     Tienda::load("TiendaHelperRoute", 'helpers.route');
     $this->router = new TiendaHelperRoute();
     $this->user = JFactory::getUser();
 }

 /**
  * Include a particular Tienda Model
  * @param $name the name of the mode (ex: products)
  */
 protected function includeTiendaModel($name)
 {
     if (strtolower($name) != 'base') {
         Tienda::load('TiendaModel' . ucfirst(strtolower($name)), 'models.' . strtolower($name));
     } else {
         Tienda::load('TiendaModelBase', 'models._base');
     }
 }

 function __construct($config = array())
 {
     parent::__construct($config);
     if (empty($this->helpers)) {
         $this->helpers = array();
     }
     Tienda::load("TiendaHelperProduct", 'helpers.product');
     $this->helpers['product'] = new TiendaHelperProduct();
 }

 /**
  * Method to get content article data for the frontpage
  *
  * @since 1.5
  */
 function getList()
 {
     $where = array();
     $mainframe = JFactory::getApplication();
     if (!empty($this->_list)) {
         return $this->_list;
     }
     // Initialize variables
     $db = $this->getDBO();
     $filter = null;
     // Get some variables from the request
     //		$sectionid			= JRequest::getVar( 'sectionid', -1, '', 'int' );
     //		$redirect			= $sectionid;
     //		$option				= JRequest::getCmd( 'option' );
     $filter_order = $mainframe->getUserStateFromRequest('userelement.filter_order', 'filter_order', '', 'cmd');
     $filter_order_Dir = $mainframe->getUserStateFromRequest('userelement.filter_order_Dir', 'filter_order_Dir', '', 'word');
     $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
     $limitstart = $mainframe->getUserStateFromRequest('userelement.limitstart', 'limitstart', 0, 'int');
     $search = $mainframe->getUserStateFromRequest('userelement.search', 'search', '', 'string');
     $search = JString::strtolower($search);
     if (!$filter_order) {
         $filter_order = 'tbl.product_id';
     }
     $order = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir;
     $all = 1;
     // Keyword filter
     if ($search) {
         $where[] = 'LOWER( tbl.product_id ) LIKE ' . $db->Quote('%' . $db->getEscaped($search, true) . '%', false);
         $where[] = 'LOWER( tbl.product_name ) LIKE ' . $db->Quote('%' . $db->getEscaped($search, true) . '%', false);
     }
     // Build the where clause of the query
     $where = count($where) ? ' WHERE ' . implode(' OR ', $where) : '';
     // Get the total number of records
     $query = 'SELECT COUNT(tbl.product_id)' . ' FROM #__tienda_products AS tbl' . $where;
     $db->setQuery($query);
     $total = $db->loadResult();
     // Create the pagination object
     jimport('joomla.html.pagination');
     $this->_page = new JPagination($total, $limitstart, $limit);
     // Get the products
     $query = 'SELECT tbl.*, pp.* ' . ' FROM #__tienda_products AS tbl' . ' LEFT JOIN #__tienda_productprices pp ON pp.product_id = tbl.product_id ' . $where . $order;
     $db->setQuery($query, $this->_page->limitstart, $this->_page->limit);
     $this->_list = $db->loadObjectList();
     //currency formatting
     Tienda::load('TiendaHelperBase', 'helpers._base');
     foreach ($this->_list as $item) {
         $item->product_price = TiendaHelperBase::currency($item->product_price);
     }
     // If there is a db query error, throw a HTTP 500 and exit
     if ($db->getErrorNum()) {
         JError::raiseError(500, $db->stderr());
         return false;
     }
     return $this->_list;
 }

 /**
  * 
  * @return void
  **/
 function _default($tpl = null)
 {
     Tienda::load('TiendaSelect', 'library.select');
     Tienda::load('TiendaGrid', 'library.grid');
     Tienda::load('TiendaTools', 'library.tools');
     // check config
     $row = Tienda::getInstance();
     $this->assign('row', $row);
     // add toolbar buttons
     JToolBarHelper::apply('save');
     JToolBarHelper::cancel('close', 'COM_TIENDA_CLOSE');
     // plugins
     $filtered = array();
     $items = TiendaTools::getPlugins();
     for ($i = 0; $i < count($items); $i++) {
         $item =& $items[$i];
         // Check if they have an event
         if ($hasEvent = TiendaTools::hasEvent($item, 'onListConfigTienda')) {
             // add item to filtered array
             $filtered[] = $item;
         }
     }
     $items = $filtered;
     $this->assign('items_sliders', $items);
     // Add pane
     jimport('joomla.html.pane');
     $sliders = JPane::getInstance('sliders');
     $this->assign('sliders', $sliders);
     // form
     $validate = JUtility::getToken();
     $form = array();
     $view = strtolower(JRequest::getVar('view'));
     $form['action'] = "index.php?option=com_tienda&controller={$view}&view={$view}";
     $form['validate'] = "<input type='hidden' name='{$validate}' value='1' />";
     $this->assign('form', $form);
     // set the required image
     // TODO Fix this to use defines
     $required = new stdClass();
     $required->text = JText::_('COM_TIENDA_REQUIRED');
     $required->image = "<img src='" . JURI::root() . "/media/com_tienda/images/required_16.png' alt='{$required->text}'>";
     $this->assign('required', $required);
     // Elements
     $elementArticleModel = JModel::getInstance('ElementArticle', 'TiendaModel');
     $this->assign('elementArticleModel', $elementArticleModel);
     // terms
     $elementArticle_terms = $elementArticleModel->fetchElement('article_terms', @$row->get('article_terms'));
     $resetArticle_terms = $elementArticleModel->clearElement('article_terms', '0');
     $this->assign('elementArticle_terms', $elementArticle_terms);
     $this->assign('resetArticle_terms', $resetArticle_terms);
     // shipping
     $elementArticle_shipping = $elementArticleModel->fetchElement('article_shipping', @$row->get('article_shipping'));
     $resetArticle_shipping = $elementArticleModel->clearElement('article_shipping', '0');
     $this->assign('elementArticle_shipping', $elementArticle_shipping);
     $this->assign('resetArticle_shipping', $resetArticle_shipping);
 }