Ejemplo n.º 1
0
 /**
  * Returns the tax rate for an item
  *  
  * @param int $shipping_method_id
  * @param int $geozone_id
  * @return int
  */
 protected function getTaxRate($shipping_method_id, $geozone_id)
 {
     Tienda::load('TiendaQuery', 'library.query');
     $taxrate = "0.00000";
     $db = JFactory::getDBO();
     $query = new TiendaQuery();
     $query->select('tbl.*');
     $query->from('#__tienda_taxrates AS tbl');
     $query->join('LEFT', '#__tienda_shippingmethods AS shippingmethod ON shippingmethod.tax_class_id = tbl.tax_class_id');
     $query->where('shippingmethod.shipping_method_id = ' . $shipping_method_id);
     $query->where('tbl.geozone_id = ' . $geozone_id);
     $db->setQuery((string) $query);
     if ($data = $db->loadObject()) {
         $taxrate = $data->tax_rate;
     }
     return $taxrate;
 }
Ejemplo n.º 2
0
 /**
  * Gets list of all subscriptions by issue x-days before expiring
  *
  * @$days Number of days before expiring (0 stands for expired now)
  *
  * @return List of subscriptions by issue
  */
 public function getListByIssues($days = 0)
 {
     $db = $this->getDBO();
     $date = JFactory::getDate();
     $date->setOffset(-JFactory::getConfig()->getValue('config.offset'));
     $today = $date->toFormat("%Y-%m-%d");
     Tienda::load('TiendaQuery', 'library.query');
     $q = new TiendaQuery();
     $q->select('s.*');
     $q->from('`#__tienda_productissues` tbl');
     $q->join('left', '`#__tienda_subscriptions` s ON s.`product_id` = tbl.`product_id`');
     $q->join('left', '`#__tienda_orderitems` oi ON s.`orderitem_id` = oi.`orderitem_id`');
     $q->where('s.`subscription_enabled` = 1');
     $q->where('oi.`subscription_period_unit` = \'I\'');
     if ($days) {
         $query = " SELECT DATE_ADD('" . $today . "', INTERVAL '.{$days}.' DAY) ";
         $db->setQuery($query);
         $date = Date('Y-m-d', strtotime($db->loadResult()));
     } else {
         $date = $today;
     }
     $q->where('DATE_FORMAT( tbl.`publishing_date`, \'%Y-%m-%d\' ) = \'' . $date . '\'');
     $db->setQuery((string) $q);
     return $db->loadObjectList();
 }
Ejemplo n.º 3
0
 /**
  * Dedicated function for eav fields filtering
  * @param TiendaQuery $query
  */
 protected function _buildQueryEav(&$query)
 {
     $eavStates = $this->getEavState()->getProperties();
     // If there are eav states set
     if (count($eavStates)) {
         // Loop through the filters
         foreach ($eavStates as $k => $v) {
             $filter_prefix = 'filter_';
             // Is it a filter?
             if (strpos($k, $filter_prefix) === 0) {
                 // Different table name for different joins!
                 // alias on which we want to filter
                 $attribute_alias = substr($k, strlen($filter_prefix));
                 $tbl_key = $this->getTable()->getKeyName();
                 $eav_tbl_name = 'eav_' . $attribute_alias;
                 $value_tbl_name = 'value_' . $attribute_alias;
                 // Join the table based on the type of the value
                 Tienda::load("TiendaHelperBase", 'helpers._base');
                 $eav_helper = TiendaHelperBase::getInstance('Eav');
                 $table_type = $eav_helper->getType($attribute_alias);
                 // Join the tables
                 $query->join('LEFT', '#__tienda_eavattributes AS ' . $eav_tbl_name . ' ON tbl.' . $tbl_key . ' = ' . $eav_tbl_name . '.eaventity_id');
                 $query->join('LEFT', '#__tienda_eavvalues' . $table_type . ' AS ' . $value_tbl_name . ' ON ' . $eav_tbl_name . '.eavattribute_id = ' . $value_tbl_name . '.eavattribute_id');
                 // Filter using '='
                 $query->where($eav_tbl_name . ".eavattribute_alias = '{$attribute_alias}'");
                 $query->where($value_tbl_name . ".eavvalue_value = '{$v}'");
             }
         }
     }
 }
Ejemplo n.º 4
0
 function view($cachable = false, $urlparams = false)
 {
     $model = $this->getModel($this->get('suffix'));
     $model->getId();
     $row = $model->getItem();
     $view = $this->getView($this->get('suffix'), 'html');
     $view->setModel($model, true);
     $view->assign('row', $row);
     $view->setLayout('view');
     $orderstates_csv = Tienda::getInstance()->get('orderstates_csv', '2, 3, 5, 17');
     $orderstates_array = explode(',', $orderstates_csv);
     //Get Data From OrdersItems Model
     JModel::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/models');
     $modelOrders = JModel::getInstance('Orders', 'TiendaModel');
     $modelOrders->setState('filter_userid', $row->id);
     $modelOrders->setState('order', 'tbl.created_date');
     $modelOrders->setState('direction', 'DESC');
     $modelOrders->setState('filter_orderstates', $orderstates_array);
     $allorders = $modelOrders->getList();
     $modelOrders->setState('limit', '5');
     $lastfiveorders = $modelOrders->getList(true);
     $view->assign('orders', $lastfiveorders);
     $spent = 0;
     foreach ($allorders as $orderitem) {
         $spent += $orderitem->order_total;
     }
     $view->assign('spent', $spent);
     //Get Data From Carts Model
     $modelCarts = JModel::getInstance('Carts', 'TiendaModel');
     $modelCarts->setState('filter_user', $row->id);
     $carts = $modelCarts->getList();
     $view->assign('carts', $carts);
     $total_cart = 0;
     foreach (@$carts as $cart) {
         $cart->total_price = $cart->product_price * $cart->product_qty;
         $total_cart += $cart->total_price;
     }
     $view->assign('total_cart', $total_cart);
     //Subcription Data
     $modelSubs = JModel::getInstance('subscriptions', 'TiendaModel');
     $modelSubs->setState('filter_userid', $row->id);
     $modelSubs->setState('filter_enabled', 1);
     $modelOrders->setState('limit', '5');
     $subs = $modelSubs->getList();
     $view->assign('subs', $subs);
     //Get Data from Productcomments Model and left join to products
     $database = $model->getDbo();
     Tienda::load('TiendaQuery', 'library.query');
     $query = new TiendaQuery();
     $query->select('tbl.*');
     $query->select('substring(tbl.productcomment_text, 1, 250) AS trimcom');
     $query->from('#__tienda_productcomments AS tbl');
     $query->select('p.product_name AS p_name');
     $query->join('LEFT', '#__tienda_products AS p ON p.product_id = tbl.product_id');
     $query->where("tbl.user_id='{$row->id}'");
     $database->setQuery((string) $query);
     $procoms = $database->loadObjectList();
     $view->assign('procoms', $procoms);
     $model->emptyState();
     $this->_setModelState();
     $surrounding = $model->getSurrounding($model->getId());
     $view->assign('surrounding', $surrounding);
     $view->setTask(true);
     $view->display();
     $this->footer();
     return;
 }
Ejemplo n.º 5
0
 public static function calculateProductAttributeProperty(&$product, $attributes, $product_price, $product_weight)
 {
     Tienda::load('TiendaHelperBase', 'helpers._base');
     $helper_product = TiendaHelperBase::getInstance('Product');
     // first we get rid off phantom attributes (the ones that should be hidden because their parent attribute was just unselected)
     $attr_base = TiendaHelperProduct::getAttributes($product->product_id, array_merge($attributes, array('0')));
     $attr_final = TiendaHelperProduct::getDefaultAttributeOptions($attr_base);
     foreach ($attr_final as $key => $value) {
         if (isset($attributes['attribute_' . $key])) {
             $attr_final[$key] = $attributes['attribute_' . $key];
         }
     }
     Tienda::load('TiendaQuery', 'library.query');
     $q = new TiendaQuery();
     $q->select('tbl.`productattributeoption_price` , tbl.`productattributeoption_prefix`, tbl.`productattributeoption_id` ');
     $q->select('tbl.`productattributeoption_code`, tbl.`productattributeoption_weight`, tbl.`productattributeoption_prefix_weight`');
     $q->from('`#__tienda_productattributeoptions` tbl');
     $q->join('left', '`#__tienda_productattributes` atr ON tbl.	productattribute_id = atr.productattribute_id');
     $q->where("tbl.productattributeoption_id IN ('" . implode("', '", $attr_final) . "')");
     $q->order('atr.ordering ASC');
     $db = JFactory::getDbo();
     $db->setQuery($q);
     $res = $db->loadObjectList();
     $attributes = array();
     for ($i = 0, $c = count($res); $i < $c; $i++) {
         // update product price
         // is not + or -
         if ($res[$i]->productattributeoption_prefix == '=') {
             $product->{$product_price} = floatval($res[$i]->productattributeoption_price);
         } else {
             $product->{$product_price} = $product->{$product_price} + floatval($res[$i]->productattributeoption_prefix . $res[$i]->productattributeoption_price);
         }
         // update product weight
         if ($res[$i]->productattributeoption_prefix_weight == '=') {
             $product->{$product_weight} = floatval($res[$i]->productattributeoption_weight);
         } else {
             $product->{$product_weight} = $product->{$product_weight} + floatval($res[$i]->productattributeoption_prefix_weight . $res[$i]->productattributeoption_weight);
         }
         $attributes[] = $res[$i]->productattributeoption_id;
     }
     $product->sku = self::getProductSKU($product, $attributes);
 }
Ejemplo n.º 6
0
 /**
  * 
  * Method to get product categories.
  * @param int $id - product id
  * @return string
  */
 function _getCategoryName($id)
 {
     Tienda::load('TiendaQuery', 'library.query');
     JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_tienda/tables');
     $table = JTable::getInstance('ProductCategories', 'TiendaTable');
     $query = new TiendaQuery();
     $query->select("c.category_name");
     $query->from($table->getTableName() . " AS tbl");
     $query->where("tbl.product_id = " . (int) $id);
     $query->join('LEFT', '#__tienda_categories AS c ON tbl.category_id = c.category_id');
     $db = JFactory::getDBO();
     $db->setQuery((string) $query);
     $items = $db->loadResultArray();
     $name = "";
     if (!empty($items)) {
         $name = implode(" | ", $items);
     }
     return $name;
 }
Ejemplo n.º 7
0
 /**
  * Method to get if user has multiple user group
  * @return array
  */
 private function getUserGroups()
 {
     $user = JFactory::getUser();
     $database = JFactory::getDBO();
     Tienda::load('TiendaQuery', 'library.query');
     $query = new TiendaQuery();
     $query->select('tbl.group_id');
     $query->from('#__tienda_usergroupxref AS tbl');
     $query->join('INNER', '#__tienda_groups AS g ON g.group_id = tbl.group_id');
     $query->where("tbl.user_id = " . (int) $user->id);
     $query->order('g.ordering ASC');
     $database->setQuery((string) $query);
     return $database->loadResultArray();
 }