/** * According to commission % specified in component parameter, * fee/commission is calculated on total amount and added in kart_store table against respected store id * * @param INTEGER $orderid orderid. * * @return VOID */ public function updateStoreFee($orderid) { $comquick2cartHelper = new comquick2cartHelper(); $db = JFactory::getDBO(); $pricedetails = $comquick2cartHelper->getStoreProdPrice($orderid); if (!empty($pricedetails)) { $params = JComponentHelper::getParams('com_quick2cart'); $per = $params->get('commission'); foreach ($pricedetails as $key => $tprice) { $fee = ''; $fee = (double) $tprice['totalprice'] * $per / 100; $query = "UPDATE `#__kart_store` SET `fee`=`fee` + " . $fee . " where `id`=" . $tprice['store_id']; $db->setQuery($query); $db->execute(); } } }