예제 #1
0
 /**
  *  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();
         }
     }
 }