public function act_addNote($orderid, $data) { $add_notes = $data['add_notes']; //var_dump($add_pitemid); if (empty($add_notes)) { self::$errCode = '400'; self::$errMsg = '没有提交数据'; return false; } foreach ($add_notes as $key => $value) { $add_note = array(); if (isset($add_notes[$key]) && !empty($add_notes[$key])) { $add_note['content'] = $add_notes[$key]; } if ($add_note) { $add_note['omOrderId'] = $orderid; $add_note['userId'] = $_SESSION['sysUserId']; $add_note['createdTime'] = time(); if (!OrderAddModel::insertOrderNotesRow($add_note)) { self::$errCode = OrderModifyModel::$errCode; self::$errMsg = OrderModifyModel::$errMsg; return false; } } } self::$errCode = OrderModifyModel::$errCode; self::$errMsg = OrderModifyModel::$errMsg; return true; }
public function act_ApplicationException($omOrderId, $content) { $tableName = "om_unshipped_order"; $storeId = 1; if (!$omOrderId || !$content) { self::$errCode = '5806'; self::$errMsg = 'param is error'; return array(); } $where = " WHERE id = " . $omOrderId . " AND orderStatus = " . C('STATESHIPPED'); $returnStatus0 = array('orderStatus' => C('STATEINTERCEPTSHIP'), 'orderType' => C('STATEPENDING_APPEXC')); if (!OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) { self::$errCode = '5807'; self::$errMsg = 'update error'; return false; } $insertOrderNoteDada = array('omOrderId' => $omOrderId, 'content' => $content, 'userId' => 0, 'createdTime' => time()); if ($insertOrderNoteids = OrderAddModel::insertOrderNotesRow($insertOrderNoteDada)) { self::$errCode = '5808'; self::$errMsg = 'insert Note error'; return false; } self::$errCode = '200'; self::$errMsg = 'sync success'; return true; }
/** * 插入订单对应下的总表信息 * @para $data as array * @add by Herman.Xi * @last modified 20131022 * $in 默认为进入订单模式 */ public static function insertAllOrderRow($orderData, $extension = 'ebay', $in = true) { self::initDB(); //var_dump($orderData); exit; $obj_order_data = $orderData['orderData']; $orderExtenData = $orderData['orderExtenData']; $orderUserInfoData = $orderData['orderUserInfoData']; $orderDetailArr = $orderData['orderDetail']; if ($obj_order_data['platformId'] == "2") { //ebay $ebay_orderid = $orderExtenData['orderId']; $tName = 'om_unshipped_order_extension_ebay'; $where = "WHERE orderId='{$ebay_orderid}'"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); $tName = 'om_shipped_order_extension_ebay'; $flagCountshipped = OmAvailableModel::getTNameCount($tName, $where); } else { $tName = 'om_unshipped_order'; $where = "WHERE accountId='{$obj_order_data['accountId']}' AND recordNumber='{$obj_order_data['recordNumber']}' AND platformId={$obj_order_data['platformId']} and is_delete ='0'"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); $tName = 'om_shipped_order'; $flagCountshipped = OmAvailableModel::getTNameCount($tName, $where); } //if (empty ($flagCountUnshipped) && empty ($flagCountshipped)) { //判断订单是否已经在系统2个订单表(未发货和已发货)中存在 if (empty($flagCountUnshipped) && empty($flagCountshipped)) { $platfrom = omAccountModel::getPlatformSuffixById($obj_order_data['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 BaseModel::begin(); //开始事务 $insertOrderDataRow = self::insertOrderRow($obj_order_data); //插入到order表 if (empty($insertOrderDataRow)) { BaseModel::rollback(); //throw new Exception('insert orderData error'); } $orderExtenData['omOrderId'] = $insertOrderDataRow; $orderUserInfoData['omOrderId'] = $insertOrderDataRow; $resultExten = self::insertExtension($orderExtenData, $extension); //插入到order_extend表 if (!$resultExten) { BaseModel::rollback(); //throw new Exception('insert orderExtenData error'); } $resultUserInfo = self::insertUserinfoRow($orderUserInfoData); //插入到order_userInfo表 if (!$resultUserInfo) { BaseModel::rollback(); //throw new Exception('insert orderUserInfoData error'); } foreach ($orderDetailArr as $orderDetail) { $orderDetailData = $orderDetail['orderDetailData']; $orderDetailExtenData = $orderDetail['orderDetailExtenData']; $orderDetailData['omOrderId'] = $insertOrderDataRow; $orderDetailData['createdTime'] = time(); $insertOrderDatilRow = self::insertOrderdetail($orderDetailData); //插入到detail表 if (empty($insertOrderDatilRow)) { BaseModel::rollback(); //throw new Exception('insert orderDetailData error'); } $orderDetailExtenData['omOrderdetailId'] = $insertOrderDatilRow; if ($orderDetailExtenData) { $resultOrderDetailExten = self::insertDetailExtension($orderDetailExtenData, $extension); //插入到detailExtend if (!$resultOrderDetailExten) { BaseModel::rollback(); //throw new Exception('insert orderDetailExtenData error'); } } } if ($obj_order_data['platformId'] == 1) { $insertOrderidsDada = array('omOrderId' => $insertOrderDataRow, 'PayPalPaymentId' => $orderData['orderExtenData']['PayPalPaymentId'], 'orderid' => $orderData['orderExtenData']['orderId'], 'accountId' => $orderData['orderData']['accountId'], 'saletime' => time()); $insertOrderids = OrderidsModel::insertOrderidsList($insertOrderidsDada); if (!$insertOrderids) { BaseModel::rollback(); //throw new Exception('insert orderIds error'); } } if (isset($orderData['orderNote']) && !empty($orderData['orderNote'])) { $orderNote = $orderData['orderNote']; $insertOrderNoteDada = array('omOrderId' => $insertOrderDataRow, 'content' => $orderNote['content'], 'userId' => $orderNote['userId'], 'createdTime' => $orderNote['createdTime']); $insertOrderNoteids = OrderAddModel::insertOrderNotesRow($insertOrderNoteDada); if (!$insertOrderNoteids) { BaseModel::rollback(); //throw new Exception('insert orderNote error'); } } $buyerInfo = $orderUserInfoData; $buyerInfo['platformId'] = $obj_order_data['platformId']; unset($buyerInfo['omOrderId']); unset($buyerInfo['countrySn']); unset($buyerInfo['currency']); unset($buyerInfo['currency']); $insertBuyerInfo = self::insertBuyerInfoRow($buyerInfo); if (!$insertBuyerInfo) { BaseModel::rollback(); //throw new Exception('insert BuyerInfo error'); } $ProductStatus = new ProductStatus(); if (!$ProductStatus->updateSkuStatusByOrderStatus(array($insertOrderDataRow))) { BaseModel::rollback(); //throw new Exception('update puchaseinfo error'); } BaseModel::commit(); BaseModel::autoCommit(); return $insertOrderDataRow; } else { self::$errCode = "400"; self::$errMsg = "已经包含订单信息,不能重复插入!"; return false; } }