PHP comquick2cartHelper::appendExtraFieldData方法代码示例

 function updateCop_item($coupon, $cart_item, $called = "cart", $order_id = 0)
 {
     $db = JFactory::getDBO();
     // $cart_item = coupon items;
     foreach ($cart_item as $cart_item_id) {
         if ($called == "cart") {
             // Called from cart
             $Quick2cartModelcart = new Quick2cartModelcart();
             $cartid = $Quick2cartModelcart->getCartId();
             $query = "Select cart_item_id as id ,item_id as item_id, product_final_price as tamt ,product_quantity as qty\n\t\t\t FROM #__kart_cartitems\n\t\t\t WHERE item_id='{$cart_item_id}' AND cart_id =" . $cartid . " order by `store_id`";
         } else {
             // Called from  order
             $query = "Select order_item_id as id , item_id as item_id, product_final_price as tamt ,product_quantity as qty\n\t\t\t FROM #__kart_order_item\n\t\t\t WHERE item_id='{$cart_item_id}' AND order_id =" . $order_id . " order by `store_id`";
         }
         $db->setQuery($query);
         $cartitems = $db->loadAssocList();
         foreach ($cartitems as $item) {
             if ($item['item_id'] == $cart_item_id) {
                 if ($coupon[0]->val_type == 1) {
                     $cval = $coupon[0]->value / 100 * $item['tamt'];
                 } else {
                     $cval = $coupon[0]->value;
                     $cval = $cval * $item['qty'];
                     /*multiply cop disc with qty*/
                 }
                 $camt = $item['tamt'] - $cval;
                 if ($camt <= 0) {
                     $camt = 0;
                 }
                 $dis_totalamt = $camt ? $camt : $item['tamt'];
                 $cart_item = new stdClass();
                 $cart_item->item_id = $cart_item_id;
                 //as id
                 $cart_item->original_price = $item['tamt'];
                 $cart_item->product_final_price = $dis_totalamt;
                 $comquick2cartHelper = new comquick2cartHelper();
                 $db = JFactory::getDBO();
                 if ($called == "cart") {
                     $q = "SELECT  `params` FROM  `#__kart_cartitems` WHERE `cart_item_id` =" . $item['id'];
                     $cart_item->params = $comquick2cartHelper->appendExtraFieldData($coupon[0]->cop_code, $q, 'coupon_code');
                     $cart_item->cart_item_id = $item['id'];
                     $sql = $db->updateObject("#__kart_cartitems", $cart_item, "cart_item_id");
                 } else {
                     $q = "SELECT  `params` FROM  `#__kart_order_item` WHERE `order_item_id` =" . $item['id'];
                     $cart_item->params = $comquick2cartHelper->appendExtraFieldData($coupon[0]->cop_code, $q, 'coupon_code');
                     $cart_item->order_item_id = $item['id'];
                     $sql = $db->updateObject("#__kart_order_item", $cart_item, "order_item_id");
                 }
                 if (!$sql) {
                     echo $this->_db->stderr();
                     return -1;
                 }
             }
         }
     }
 }

 /**
  * This function update order info. Update mdate,transaction_id. [DOEN'T CHAGE ORDER STATUS HERE]
  *
  * @param   integer  $storeId  store id.
  * @param   array  $pg_plugin  processed plugin name.
  *
  */
 function updateOrder($data, $pg_plugin)
 {
     $db = JFactory::getDBO();
     $res = new stdClass();
     $eoid = $this->extract_prefix($data['order_id']);
     // $eoid means extracted order id
     $res->id = $eoid;
     $res->mdate = date("Y-m-d H:i:s");
     $res->transaction_id = $data['transaction_id'];
     //			$res->status 	  		= $data['status']; /*changed by dipti since there is already a update status function*/
     $res->processor = $data['processor'];
     //			$res->payee_id			= $data['buyer_email'];
     //appending raw data to orders's extra field data
     $comquick2cartHelper = new comquick2cartHelper();
     $q = "SELECT  `extra` FROM  `#__kart_orders` WHERE `id` =" . $eoid;
     $res->extra = $comquick2cartHelper->appendExtraFieldData($data['raw_data'], $q);
     if (!$db->updateObject('#__kart_orders', $res, 'id')) {
         //return false;
     }
     // Add payout entry
     $payout_id = $this->addPayoutEntry($eoid, $res->transaction_id, $data['status'], $pg_plugin);
 }

 /**
  * This function add currency exchange info in order's extra field
  *
  * @param   ARRAY  $data  contain orderid,to,from,and currency exchange rate
  *
  * @return  VOID
  */
 public function currencyExchangeMsg($data)
 {
     if (!empty($data)) {
         // Load payment model
         $path = JPATH_SITE . '/components/com_quick2cart/model/payment.php';
         if (!class_exists('Quick2cartModelpayment')) {
             JLoader::load('Quick2cartModelpayment');
         }
         $Quick2cartModelpayment = new Quick2cartModelpayment();
         $order_id = $Quick2cartModelpayment->extract_prefix($data['order_id']);
         // As we dont want to store( see next) in DB
         unset($data['order_id']);
         $comquick2cartHelper = new comquick2cartHelper();
         $q = "SELECT  `extra` FROM  `#__kart_orders` WHERE `id` =" . $order_id;
         $extraFieldData = $comquick2cartHelper->appendExtraFieldData($data, $q, 1);
         $res = new stdClass();
         $res->id = $order_id;
         $res->extra = $extraFieldData;
         $db = JFactory::getDBO();
         // Get previous data if exist
         if (!$db->updateObject('#__kart_orders', $res, 'id')) {
             echo $this->_db->stderr();
             return false;
         }
     }
 }