public function getProd($item_obj) { $comquick2cartHelper = new comquick2cartHelper(); $currency = $comquick2cartHelper->getCurrencySession(); $Quick2cartModelcart = new Quick2cartModelcart(); if (empty($item_obj['item_id'])) { $item_id = $Quick2cartModelcart->getitemid($item_obj["id"], $item_obj['parent']); } else { $item_id = $item_obj['item_id']; } // $query = "SELECT parent,product_id,name,price FROM #__kart_items WHERE product_id = ".(int) $item_obj["id"]." AND parent='".$item_obj['parent']."'"; $itemid_rec = $this->getItemRec($item_id); $params = JComponentHelper::getParams('com_quick2cart'); $query = "SELECT kc.id as base_currency_id,kc.item_id,"; if ($params->get('usedisc')) { $query .= " CASE WHEN kc.discount_price IS NOT NULL THEN kc.discount_price\n\t\t\t\tELSE kc.price\n\t\t\t\tEND as price, "; } else { $query .= " kc.price, "; } // removed parent and product_id $query .= " ki.name\n\t\tFROM #__kart_items AS ki\n\t\tLEFT JOIN `#__kart_base_currency` AS kc\n\t\tON `ki`.`item_id` = `kc`.`item_id`\n\t\tWHERE ki.`item_id` =" . $itemid_rec->item_id . "\n\t\tAND kc.currency = '" . $currency . "'"; // AND ki.parent='".$item_obj['parent']."'"; $this->_db->setQuery($query); $item_result = $this->_db->loadAssoc(); //$pid=(int) $item_obj["id"]; //product_id $item_result['price'] = $item_result['price']; $item_result["count"] = $item_obj["count"]; // input to this f() $final_result[] = $item_result; // IF product has attributes if ($item_obj['options']) { //$query = "SELECT * FROM #__kart_itemattributeoptions WHERE itemattributeoption_id IN (".$item_obj['options'].")";//old query $query = "\n\t\t\tSELECT \tko.itemattributeoption_id,ko.itemattribute_id,ko.itemattributeoption_name,ko.itemattributeoption_code,ko.itemattributeoption_prefix,ko.ordering,\n\t\t\t currency as optioncurrency,price as optionprice\n\t\t\t FROM #__kart_itemattributeoptions as ko\n\t\t\t LEFT JOIN #__kart_option_currency as kc\n\t\t\t ON `ko`.`itemattributeoption_id`=`kc`.`itemattributeoption_id`\n\t\t\t WHERE ko.itemattributeoption_id IN (" . $item_obj['options'] . ") AND currency='" . $currency . "'"; $this->_db->setQuery($query); $options_result = $this->_db->loadAssocList(); $item_options = array(); foreach ($options_result as $options_result) { $item_options_arr[] = $options_result['itemattribute_id']; foreach ($options_result as $k => $v) { $item_options[$options_result['itemattribute_id']][$k] = $v; } } $itemattribute_ids = implode(",", $item_options_arr); $final_result[] = $item_options; $query = "SELECT * FROM #__kart_itemattributes WHERE itemattribute_id IN (" . $itemattribute_ids . ")"; $this->_db->setQuery($query); $item_attri = $this->_db->loadAssocList(); $final_result[] = $item_attri; } return $final_result; }
<button type="button" class="close" data-dismiss="alert"></button> <?php $create_store_itemid = $comquick2cartHelper->getitemid('index.php?option=com_quick2cart&view=vendor&layout=createstore'); $createstore = "<a href=\"" . JRoute::_('index.php?option=com_quick2cart&view=vendor&layout=createstore&Itemid=' . $create_store_itemid) . "\"> Click Here</a>"; ?> <strong><?php echo "<br>" . JText::sprintf('QTC_NO_STORE', $createstore); ?> </strong> </div> <?php } else { JLoader::import('cart', JPATH_SITE . DS . 'components' . DS . 'com_quick2cart' . DS . 'models'); $model = new Quick2cartModelcart(); if (!empty($pid)) { $item_id = $model->getitemid($pid, $client); } /*fetch Minimum/ max /stock item Quantity*/ if (!empty($item_id)) { $minmaxstock = $model->getItemRec($item_id); } $class_nm = 'form-horizontal'; if ($client === 'com_zoo') { $class_nm = ''; } // If article is QTC product then show qtc fields. $showQtcFields = 'display:none;'; if (!empty($itemDetail['item_id'])) { $showQtcFields = ''; } else { ?>