public static function index($tableName, $where) { //数据查找 !self::$dbConn ? self::initDB() : NULL; $set = ""; //??? //var_dump(array($id, $ostatus)); //if($ostatus != C('STATEHASSHIPPED')){ /*$orderForm = 'om_unshipped_order'; $orderDetailForm = 'om_unshipped_order_detail'; $orderDetailExtensionForm = 'om_unshipped_order_detail_extension'; $orderExtensionForm = 'om_unshipped_order_extension'; $orderUserInfoForm = 'om_unshipped_order_userInfo'; $orderWarehouseForm = 'om_unshipped_order_warehouse';*/ /*} else { $orderForm = 'om_shipped_order'; $orderDetailForm = 'om_shipped_order_detail'; $orderDetailExtensionForm = 'om_shipped_order_detail_extension'; $orderExtensionForm = 'om_shipped_order_extension'; $orderUserInfoForm = 'om_shipped_order_userInfo'; $orderWarehouseForm = 'om_shipped_order_warehouse'; }*/ $platfrom = omAccountModel::getPlatformSuffixById($orderData['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 $orderExtensionForm .= '_' . $extension; $orderDetailExtensionForm .= '_' . $extension; $sql = "SELECT\n\t\t\t\t\tda.*,\n\t\t\t\t\tdb.reviews,\n\t\t\t\t\tdb.sku,\n\t\t\t\t\tdb.amount,\n\t\t\t\t\tdb.itemPrice,\n\t\t\t\t\tdb.id AS datailId,\n\t\t\t\t\tdc.*,\n\t\t\t\t\tdd.platform,\n\t\t\t\t\tde.transId,\n\t\t\t\t\tde.PayPalPaymentId,\n\t\t\t\t\tde.feedback,\n\t\t\t\t\tde.currency,\n\t\t\t\t\tde.PayPalEmailAddress,\n\t\t\t\t\tdf.account,\n\t\t\t\t\tdf.email AS accountEmail,\n\t\t\t\t\tdh.content,\n\t\t\t\t\tdh.userId,\n\t\t\t\t\tdh.createdTime,\n\t\t\t\t\tdi.actualWeight,\n\t\t\t\t\tdi.actualShipping\n\t\t\t\tFROM\n\t\t\t\t\t" . $orderForm . " AS da\n\t\t\t\tLEFT JOIN " . $orderDetailForm . " AS db ON db.omOrderId = da.id\n\t\t\t\tLEFT JOIN " . $orderUserInfoForm . " AS dc ON dc.omOrderId = da.id\n\t\t\t\tLEFT JOIN om_platform AS dd ON dd.id\t= da.platformId\n\t\t\t\tLEFT JOIN " . $orderExtensionForm . " AS de ON de.omOrderId\t= da.id\n\t\t\t\tLEFT JOIN om_account AS df ON df.id\t= da.accountId\n\t\t\t\tLEFT JOIN om_order_notes AS dh ON dh.omOrderId\t= da.id\n\t\t\t\tLEFT JOIN " . $orderWarehouseForm . " AS di ON di.omOrderId\t= da.id\n\t\t\t\tWHERE\n\t\t\t\t\tda.id\t=\t" . $id; //echo $sql; echo "<br>"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret; } else { return false; } }
public static function combineOrder($orderIdArr) { self::initDB(); BaseModel::begin(); //开始事务 $serchSql = "SELECT * FROM om_unshipped_order WHERE id in ('" . join("','", $orderIdArr) . "') and is_delete = 0 and storeId = 1 "; $querySql = self::$dbConn->query($serchSql); $serchSqlArr = self::$dbConn->fetch_array_all($querySql); //判断一:订单数量统计 if (count($serchSqlArr) < 2) { self::$errCode = "1111"; self::$errMsg = "合并订单最少需要选择两个或两个以上的订单!"; return false; } $platfrom = omAccountModel::getPlatformSuffixById($serchSqlArr[0]['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 $temporderStatus = ""; //相同状态一 $temporderStatus2 = ""; //相同状态二 $userinfo = array(); //订单相同条件 $orderSn = array(); //订单编号 $onlineTotal = 0; //线上总价 $actualTotal = 0; //实际收款总价 $calcWeight = 0; //估算重量,单位是kg $calcShipping = 0; //估算运费 foreach ($serchSqlArr as $selectArr) { $orderSn[] = $selectArr['id']; $onlineTotal += $selectArr['onlineTotal']; $actualTotal += $selectArr['actualTotal']; $calcWeight += $selectArr['calcWeight']; $calcShipping += $selectArr['calcShipping']; //判断二:订单被其他人 <锁定> 订单判断 if ($selectArr['isLock'] == 1) { self::$errCode = "2222"; self::$errMsg = "订单[" . $selectArr['id'] . "]已经被 [" . UserModel::getUsernameById($selectArr['lockUser']) . "] 锁定,不能合并操作。"; return false; } //判断三:已合并订单,无法再次合并判断 if (in_array($selectArr['combineOrder'], array(1, 2))) { self::$errCode = "3333"; self::$errMsg = "订单[" . $selectArr['id'] . "]已经有订单合并操作,不能重复订单合并。"; return false; } //判断四:已合并包裹订单,无法合并判断 if (in_array($selectArr['combinePackage'], array(1, 2))) { self::$errCode = "4444"; self::$errMsg = "订单[" . $selectArr['id'] . "]是合并包裹订单,不能订单合并操作。"; return false; } //判断五:订单信息不相同判断 $userinfsql = "SELECT * FROM om_unshipped_order_userInfo WHERE omOrderId = {$selectArr['id']}"; $userinfsql = self::$dbConn->fetch_first($userinfsql); $tempArr = array(); $tempArr['accountId'] = trim($selectArr['accountId']); $tempArr['platformUsername'] = trim($userinfsql['platformUsername']); $tempArr['username'] = trim($userinfsql['username']); $tempArr['countryName'] = trim($userinfsql['countryName']); $tempArr['state'] = trim($userinfsql['state']); $tempArr['city'] = trim($userinfsql['city']); $tempArr['street'] = trim($userinfsql['street']); $tempArr['currency'] = trim($userinfsql['currency']); //币种判断 if (!empty($userinfo) && $userinfo != $tempArr) { self::$errCode = "5555"; self::$errMsg = "订单信息不相同,无法合并订单操作。"; return false; } $userinfo = $tempArr; //订单信息相同,进入下次比较。 //判断六:同状态判断 $orderStatus = ""; //订单状态一 $orderType = ""; //订单状态二 $orderStatus = $selectArr['orderStatus']; $orderType = $selectArr['orderType']; if (!empty($temporderStatus) && $temporderStatus != $orderStatus) { self::$errCode = "6666"; self::$errMsg = "订单不在同一文件夹,无法合并订单操作。"; return false; } $temporderStatus = $orderStatus; if (!empty($temporderStatus2) && $temporderStatus2 != $orderType) { self::$errCode = "6666"; self::$errMsg = "订单不在同一文件夹,无法合并订单操作。"; return false; } $orderExtensql = "SELECT * FROM om_unshipped_order_extension_" . $extension . " WHERE omOrderId = {$selectArr['id']}"; $orderExtensql = self::$dbConn->fetch_first($orderExtensql); $temporderStatus2 = $orderType; } $insertOrder = array(); $insertOrder['orderData'] = $serchSqlArr[0]; $insert_userinfo = $userinfsql; unset($insert_userinfo['omOrderId']); $insertOrder['orderUserInfoData'] = $insert_userinfo; $insert_orderExtensql = $orderExtensql; unset($insert_orderExtensql['omOrderId']); $insertOrder['orderExtenData'] = $insert_orderExtensql; //$insertOrder['orderNote'] = $userinfsql; unset($insertOrder['orderData']['id']); $insertOrder['orderData']['onlineTotal'] = $onlineTotal; $insertOrder['orderData']['actualTotal'] = $actualTotal; $insertOrder['orderData']['calcWeight'] = $calcWeight; $insertOrder['orderData']['calcShipping'] = $calcShipping; $insertOrder['orderData']['orderAddTime'] = time(); $insertOrder['orderData']['combineOrder'] = 2; $insertOrder['orderData']['orderAttribute'] = 3; //$insertOrder['orderDetail'] = array(); $detailSql = "SELECT * FROM om_unshipped_order_detail WHERE omOrderId in ('" . join("','", $orderIdArr) . "') and is_delete = 0 and storeId = 1 "; $detailSql = self::$dbConn->query($detailSql); $detailSqlArr = self::$dbConn->fetch_array_all($detailSql); $orderDetail = array(); foreach ($detailSqlArr as $value) { //$orderDetailData = array(); //$orderDetailExtenData = array(); $obj_orderDetail = $value; unset($obj_orderDetail['id']); unset($obj_orderDetail['omOrderId']); $orderDetailData = $obj_orderDetail; $detailExtenSql = "SELECT * FROM om_unshipped_order_detail_extension_" . $extension . " WHERE omOrderdetailId = '" . $value['id'] . "' "; $detailExtenSql = self::$dbConn->query($detailExtenSql); $detailExtenSqlArr = self::$dbConn->fetch_array($detailExtenSql); $obj_orderDetailExten = $detailExtenSqlArr; unset($obj_orderDetailExten['omOrderdetailId']); $orderDetailExtenData = $obj_orderDetailExten; $orderDetail[] = array('orderDetailData' => $orderDetailData, 'orderDetailExtenData' => $orderDetailExtenData); } $insertOrder['orderDetail'] = $orderDetail; //var_dump($insertOrder); exit; if ($insertId = OrderAddModel::insertAllOrderRowNoEvent($insertOrder)) { //echo $split_log .= 'insert success!' . "\n"; exit; //var_dump($_mainId,$_spitId); exit; if (!OrderLogModel::insertOrderLog($insertId, '合并产生新订单')) { BaseModel::rollback(); self::$errCode = '001'; self::$errMsg = "合并失败!"; return false; } if (!OrderRecordModel::insertCombineRecord($serchSqlArr[0]['id'], $insertId)) { BaseModel::rollback(); self::$errCode = '002'; self::$errMsg = "合并订单失败添加记录失败!"; return false; } $updateOrder = array(); $updateOrder['is_delete'] = 1; $updateOrder['combineOrder'] = 1; if (!OrderindexModel::updateOrder("om_unshipped_order", $updateOrder, " WHERE id in ('" . join("','", $orderSn) . "')")) { BaseModel::rollback(); //事物回滚 self::$errCode = "0012"; self::$errMsg = "合并更新原始订单失败!"; return false; } } else { //$split_log .= '补寄新订单产生失败!' . "\n"; BaseModel::rollback(); self::$errCode = '003'; self::$errMsg = "合并新订单产生失败"; return false; } BaseModel::commit(); self::$errCode = '200'; self::$errMsg = "合并新订单成功!"; return TRUE; }
/** * OrderPushModel::limitApplyPrintInfo($orderid) * 推送信息给仓库系统 * @return array */ public static function limitApplyPrintInfo($orderid) { self::initDB(); $storeId = 1; //基础信息 $sql = "SELECT * FROM " . self::$table_order . " WHERE id = '{$orderid}' AND is_delete = 0 AND storeId = {$storeId} "; $query = self::$dbConn->query($sql); $orderData = self::$dbConn->fetch_array($query); if ($orderData['transportId'] == '') { //echo $sql; //var_dump($orderData); self::$errCode = "0021"; self::$errMsg = "订单无运输方式不能申请打印!"; return false; } $platfrom = omAccountModel::getPlatformSuffixById($orderData['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 $ids[] = $orderid; if ($orderData['combinePackage'] == 2) { self::$errCode = "1041"; self::$errMsg = "此订单为合并包裹子订单,不能单独申请打印!"; return false; } else { if ($orderData['combinePackage'] == 1) { //如果是合并包裹 $sql = "SELECT split_order_id FROM " . self::$table_package . " WHERE main_order_id = '{$orderid}' AND is_enable = 1"; $query = self::$dbConn->query($sql); $affectedrows = self::$dbConn->affected_rows(); if ($affectedrows) { $result = self::$dbConn->fetch_array_all($query); for ($i = 0; $i < count($result); $i++) { $ids[] = $result[$i]['split_order_id']; } } } } /*$actualTotal = 0; $actualShipping = 0; $calcWeight = 0; $calcShipping = 0; if(count($ids) > 1){ foreach($ids as $vid){ $sql = "SELECT * FROM ".self::$table_order." WHERE id = '{$vid}' "; $query = self::$dbConn->query($sql); $orderOneInfo = self::$dbConn->fetch_array($query); $actualTotal += $orderOneInfo['actualTotal']; $actualShipping += $orderOneInfo['actualShipping']; $calcWeight += $orderOneInfo['calcWeight']; $calcShipping += $orderOneInfo['calcShipping']; } $orderData['actualTotal'] = $actualTotal; $orderData['actualShipping'] = $actualShipping; $orderData['calcWeight'] = $calcWeight; $orderData['calcShipping'] = $calcShipping; }*/ /*$sql = "SELECT * FROM ".self::$table_order_extension.$extension." WHERE omOrderId = '{$orderid}' "; $query = self::$dbConn->query($sql); $orderExtenData = self::$dbConn->fetch_array($query); $sql = "SELECT * FROM ".self::$table_userinfo." WHERE omOrderId = '{$orderid}' "; $query = self::$dbConn->query($sql); $orderUserInfoData = self::$dbConn->fetch_array($query);*/ $sql = "SELECT * FROM " . self::$table_tracknumber . " WHERE omOrderId = '{$orderid}' AND is_delete = 0 "; $query = self::$dbConn->query($sql); $orderTrackInfoData = self::$dbConn->fetch_array($query); if ($orderData['transportId'] == 6 && empty($orderTrackInfoData)) { self::$errCode = "0021"; self::$errMsg = "EUB订单号无跟踪号拒绝申请打印!"; return false; } $sql = "SELECT * FROM " . self::$table_express_remark . " WHERE omOrderId = '{$orderid}' "; $query = self::$dbConn->query($sql); $orderExpressRemark = self::$dbConn->fetch_array($query); if (in_array($orderData['transportId'], array(5, 8, 9)) && empty($orderExpressRemark)) { self::$errCode = "0025"; self::$errMsg = "EMS\\FEDEX\\DHL无快递描述不允许推送到仓库系统!"; return false; } /*$sql = "SELECT * FROM ".self::$table_notes." WHERE omOrderId = '{$orderid}' AND is_delete = 0 "; $query = self::$dbConn->query($sql); $orderNotesInfoData = self::$dbConn->fetch_array_all($query); $sql = "SELECT * FROM ".self::$table_detail." WHERE omOrderId IN (".join(',', $ids).") AND is_delete = 0 AND storeId = {$storeId} "; $query = self::$dbConn->query($sql); $orderDetailData = self::$dbConn->fetch_array_all($query); $detailids = array(); foreach($orderDetailData as $dv){ $detailids[] = $dv['id']; } if($detailids){ $sql = "SELECT * FROM ".self::$table_detail_extension.$extension." WHERE omOrderdetailId IN (".join(',', $detailids).") "; $query = self::$dbConn->query($sql); $orderDetailExtenData = self::$dbConn->fetch_array_all($query); }else{ $orderDetailExtenData = array(); } $obj_order_detail_data = array(); foreach($orderDetailData as $detailValue){ $obj_order_detail_data[] = array('orderDetailData' => $detailValue, 'orderDetailExtenData' => $orderDetailExtenData); } $orderDataInfo = array('orderData' => $orderData, 'orderExtenData' => $orderExtenData, 'orderUserInfoData' => $orderUserInfoData, 'orderDetail' => $obj_order_detail_data, 'tracknumbers' => $orderTrackInfoData, 'notes' => $orderNotesInfoData, 'flag' => $flag,//1发货单,0配货单 ); $exchange='send_order_exchange'; if($rabbitMQClass->queue_publish($exchange,$orderDataInfo)){ $sql = "UPDATE ".self::$table_order." SET orderStatus = ".C("STATESHIPPED").", orderType = ".C("STATESHIPPED_PRINTPEND")." WHERE id IN (".join(',', $ids).") AND is_delete = 0 AND storeId = {$storeId} "; if(!self::$dbConn->query($sql)){ self::$errCode = "0023"; self::$errMsg = "订单号申请打印之后,更新状态失败!"; return false; } foreach($ids as $id){ MarkShippingModel::insert_mark_shipping($id); } }*/ $where = " WHERE id = " . $orderid; $returnStatus0 = array('orderStatus' => C("STATESHIPPED"), 'orderType' => C('STATESHIPPED_APPLYPRINT')); if (OrderindexModel::updateOrder(self::$table_order, $returnStatus0, $where)) { self::$errCode = "200"; self::$errMsg = "申请打印成功!"; return true; } else { self::$errCode = "002"; self::$errMsg = "申请打印失败!"; return false; } }
public function act_updateDetail() { global $memc_obj; $start = time(); //ob_start();//不加这个是不行的(貌似不加可以) $omAvailableAct = new OmAvailableAct(); global $definedArr; require_once WEB_PATH . "conf/scripts/script.ebay.config.php"; $GLOBAL_EBAY_ACCOUNT = $omAvailableAct->act_getTNameList2arrById('om_account', 'id', 'account', ' WHERE is_delete=0 '); $FLIP_GLOBAL_EBAY_ACCOUNT = array_flip($GLOBAL_EBAY_ACCOUNT); $definedArr = get_defined_vars(); /*$end = time(); echo $end-$start; echo "<br>"; $start = $end;*/ //var_dump($_POST); exit; $orderid = $_POST['orderid']; $omOrderDetailId = $_POST['omOrderDetailId']; //$data = unset($_POST['omOrderDetailId']); $update_detail = array(); $update_detail_extral = array(); $update_detail['recordNumber'] = $_POST['recordNumber']; $update_detail['sku'] = $_POST['sku']; $update_detail_extral['itemTitle'] = $_POST['itemTitle']; $update_detail['itemPrice'] = $_POST['itemPrice']; $update_detail['shippingFee'] = $_POST['shippingFee']; $update_detail['amount'] = $_POST['amount']; $update_detail_extral['note'] = $_POST['note']; $platformId = $_POST['detail_platformId']; $platfrom = omAccountModel::getPlatformSuffixById($platformId); $extension = $platfrom['suffix']; //获取后缀名称 $detailArr = explode(',', $omData); //缺少事件 BaseModel::begin(); //开始事务 $tableName = "om_unshipped_order_detail"; $where = " WHERE id = " . $omOrderDetailId; if ($update_detail) { $rtn = OrderindexModel::updateOrder($tableName, $update_detail, $where); if ($rtn) { /*$tableName = "om_unshipped_order"; $where = " WHERE id = ".$orderid; $updateOrder = array(); $orderData = OrderindexModel::showOrderList($tableName, $where); $orderData = $orderData[$orderid]; //var_dump($orderData); $orderDetail = $orderData['orderDetail']; $calcInfo = CommonModel :: calcAddOrderWeight($orderDetail);//计算重量和包材 //var_dump($calcInfo); exit; $updateOrder['calcWeight'] = $calcInfo[0]; $updateOrder['pmId'] = $calcInfo[1]; if(count($orderDetail) > 1){ $updateOrder['orderAttribute'] = 3; }else if(isset($orderDetail[0]['orderDetailData']['amount']) && $orderDetail[0]['orderDetailData']['amount'] > 1){ $updateOrder['orderAttribute'] = 2; } $calcShippingInfo = CommonModel :: calcAddOrderShippingFee($orderData,1);//计算运费 //var_dump($calcShippingInfo); exit; //$insert_orderData['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee']; $updateOrder['channelId'] = $calcShippingInfo['fee']['channelId']; $interceptInfo = CommonModel :: auto_contrast_intercept($orderData); //print_r($interceptInfo); exit; $updateOrder['orderStatus'] = $interceptInfo['orderStatus']; $updateOrder['orderType'] = $interceptInfo['orderType']; $rtn2 = OrderindexModel::updateOrder($tableName, $updateOrder, $where); if(!$rtn2){ BaseModel :: rollback(); }*/ } else { BaseModel::rollback(); } } //ob_end_clean(); if ($update_detail_extral) { $tableName = "om_unshipped_order_detail_extension_" . $extension; $where = " WHERE omOrderdetailId = " . $omOrderDetailId; $rtn = OrderindexModel::updateOrder($tableName, $update_detail_extral, $where); if (!$rtn) { BaseModel::rollback(); } } BaseModel::commit(); BaseModel::autoCommit(); self::$errCode = OrderindexModel::$errCode; self::$errMsg = OrderindexModel::$errMsg; return $rtn; }
public function act_showOrderListAPI() { $id = $_GET['id'] ? $_GET['id'] : ''; if (!$id) { self::$errCode = '5806'; self::$errMsg = 'id is error'; return array(); } //$orderinfo = $this->act_showOrder('', '', ' limit 1 ', array('id'=>$id)); $where = "where `id` ={$id}"; $orderinfo = omAvailableModel::getTNameList("`om_unshipped_order`", "*", $where); if ($orderinfo) { $platfrom = omAccountModel::getPlatformSuffixById($orderinfo[0]['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 $where = "where omOrderId={$id}"; $msg = omAvailableModel::getTNameList("`om_unshipped_order_detail`", "*", $where); $detailId = $msg[0]['id']; $info = omAvailableModel::getTNameList("om_unshipped_order_detail_extension_" . $extension, "*", "where omOrderdetailId={$detailId}"); if ($info) { self::$errCode = '200'; self::$errMsg = 'success'; return $info; } } else { $orderinfo = omAvailableModel::getTNameList("`om_shipped_order`", "*", $where); $platfrom = omAccountModel::getPlatformSuffixById($orderinfo[0]['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 $where = "where omOrderId={$id}"; $msg = omAvailableModel::getTNameList("`om_shipped_order_detail`", "*", $where); $detailId = $msg[0]['id']; $info = omAvailableModel::getTNameList("om_shipped_order_detail_extension_" . $extension, "*", "where omOrderdetailId={$detailId}"); if ($info) { self::$errCode = '200'; self::$errMsg = 'success'; return $info; } } }
function act_getPlatformSuffixById($platformId) { $res = omAccountModel::getPlatformSuffixById($platformId); self::$errCode = omAccountModel::$errCode; self::$errMsg = omAccountModel::$errMsg; return $res; }
public static function killAllOrderRowNoEvent($omOrderId, $platformId, $tableName = 'om_unshipped_order') { !self::$dbConn ? self::initDB() : null; /*$where = ' WHERE id = {$omOrderId} AND storeId = 1 AND is_delete = 0 '; $sql = "SELECT * FROM $tableName $where"; //echo $sql.'<br>'; $query = self :: $dbConn->query($sql); $orderList = self :: $dbConn->fetch_array($query); $orderData = $orderList[$omOrderId]; $omOrderId = $orderData['id']; //echo $omOrderId; echo "<br>"; $orderList[$omOrderId]['orderData'] = $orderData;*/ if (!self::killOrder($omOrderId)) { self::$errCode = "010"; self::$errMsg = "删除订单表失败"; return false; //失败则设置错误码和错误信息, 返回false } $platfrom = omAccountModel::getPlatformSuffixById($platformId); $extension = $platfrom['suffix']; //获取后缀名称 if (!self::killOrderExtenData($tableName, 'WHERE omOrderId = ' . $omOrderId, $extension)) { self::$errCode = "011"; self::$errMsg = "删除订单附带表失败"; return false; //失败则设置错误码和错误信息, 返回false } //var_dump($orderExtenData); if (!self::killOrderUserInfoData($tableName, 'WHERE omOrderId = ' . $omOrderId, $extension)) { self::$errCode = "012"; self::$errMsg = "删除订单用户信息表失败"; return false; //失败则设置错误码和错误信息, 返回false } if (!self::killOrderWhInfoData($tableName, 'WHERE omOrderId = ' . $omOrderId, $extension)) { self::$errCode = "013"; self::$errMsg = "删除订单仓库信息表失败"; return false; //失败则设置错误码和错误信息, 返回false } if (!self::killOrderDetailList($tableName, 'WHERE omOrderId = ' . $omOrderId, $extension)) { self::$errCode = "014"; self::$errMsg = "删除订单明细表失败"; return false; //失败则设置错误码和错误信息, 返回false } /*if(!self::killOrderDetailList($tableName, 'WHERE omOrderId = '.$omOrderId, $extension)){ self :: $errCode = "015"; self :: $errMsg = "删除订单明细表失败"; return false; //失败则设置错误码和错误信息, 返回false }*/ return true; }
/** * 转移订单对应下的总表信息,没有批量处理事件 * @para $data as array * @add by Herman.Xi * @last modified 20131022 * $in 默认为进入订单模式 */ public static function shiftAllOrderRowNoEvent($orderData, $tName = 'om_shipped_order') { self::initDB(); //var_dump($orderData); exit; $obj_order_data = $orderData['orderData']; $orderExtenData = $orderData['orderExtenData']; $orderUserInfoData = $orderData['orderUserInfoData']; $orderDetailArr = $orderData['orderDetail']; $orderWhInfoData = $orderData['orderWhInfoData']; //var_dump($obj_order_data); exit; //$tName = 'om_unshipped_order'; $where = "WHERE recordNumber='{$obj_order_data['recordNumber']}' AND platformId={$obj_order_data['platformId']}"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); //var_dump($flagCountUnshipped); exit; /*$tName = 'om_shipped_order'; $flagCountshipped = OmAvailableModel :: getTNameCount($tName, $where);*/ if ($obj_order_data) { //判断订单是否已经在系统2个订单表(未发货和已发货)中存在 $platfrom = omAccountModel::getPlatformSuffixById($obj_order_data['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 //echo $extension; echo "<br>"; exit; $insertOrderDataRow = self::insertOrderRow($obj_order_data, $tName); //插入到order表 if (empty($insertOrderDataRow)) { self::$errCode = "020"; self::$errMsg = "插入订单失败!"; return false; } //$orderExtenData['omOrderId'] = $obj_order_data['id']; //$orderExtenData['omOrderId'] = $insertOrderDataRow; //$orderUserInfoData['omOrderId'] = $insertOrderDataRow; //$orderUserInfoData['omOrderId'] = $obj_order_data['id']; if ($orderExtenData) { $resultExten = self::insertExtension($orderExtenData, $extension, $tName); //插入到order_extend表 if (!$resultExten) { self::$errCode = "021"; self::$errMsg = "插入订单附加表失败!"; return false; } } if ($orderUserInfoData) { $resultUserInfo = self::insertUserinfoRow($orderUserInfoData, $tName); //插入到order_userInfo表 if (!$resultUserInfo) { self::$errCode = "022"; self::$errMsg = "插入用户信息表失败!"; return false; } } if ($orderWhInfoData) { $resultWhInfo = self::insertWhInfoRow($orderWhInfoData, $tName); //插入到order_userInfo表 if (!$resultWhInfo) { self::$errCode = "022"; self::$errMsg = "插入仓库信息表失败!"; return false; } } foreach ($orderDetailArr as $orderDetail) { $orderDetailData = $orderDetail['orderDetailData']; $orderDetailExtenData = $orderDetail['orderDetailExtenData']; //$orderDetailData['omOrderId'] = $insertOrderDataRow; //$orderDetailData['omOrderId'] = $obj_order_data['id']; $orderDetailData['createdTime'] = time(); $insertOrderDatilRow = self::insertOrderdetail($orderDetailData, $tName); //插入到detail表 if (empty($insertOrderDatilRow)) { self::$errCode = "023"; self::$errMsg = "插入订明细单失败!"; return false; } //$orderDetailExtenData['omOrderdetailId'] = $insertOrderDatilRow; //$orderDetailExtenData['omOrderdetailId'] = $orderDetailData['id']; if ($orderDetailExtenData) { $resultOrderDetailExten = self::insertDetailExtension($orderDetailExtenData, $extension, $tName); //插入到detailExtend if (!$resultOrderDetailExten) { self::$errCode = "024"; self::$errMsg = "插入订单明细附带表失败!"; return false; } } } /*if($obj_order_data['platformId'] == 1 && $in){ $insertOrderidsDada = array('omOrderId'=>$insertOrderDataRow,'PayPalPaymentId'=>$orderData['orderExtenData']['PayPalPaymentId'],'orderid'=>$orderData['orderExtenData']['orderId'],'accountId'=>$orderData['orderData']['accountId'],'saletime'=>time()); $insertOrderids = OrderidsModel::insertOrderidsList($insertOrderidsDada); if (!$insertOrderids) { self::$errCode = "025"; self::$errMsg = "插入ebay订单IDS失败!"; return false; } } if(isset($orderData['orderNote']) && !empty($orderData['orderNote'])){ $orderNote = $orderData['orderNote']; $insertOrderNoteDada = array('omOrderId'=>$insertOrderDataRow,'content'=>$orderNote['content'],'userId'=>$orderNote['userId'],'createdTime'=>$orderNote['createdTime']); $insertOrderNoteids = self::insertOrderNotesRow($insertOrderNoteDada); if (!$insertOrderNoteids) { self::$errCode = "026"; self::$errMsg = "插入订单Note失败!"; return false; } }*/ /*$buyerInfo = $orderUserInfoData; $buyerInfo['platformId'] = $obj_order_data['platformId']; unset($buyerInfo['omOrderId']); unset($buyerInfo['countrySn']); unset($buyerInfo['currency']); unset($buyerInfo['currency']); //var_dump($buyerInfo); $insertBuyerInfo = self::insertBuyerInfoRow($buyerInfo); //var_dump($insertBuyerInfo); if (!$insertBuyerInfo) { return false; } $ProductStatus = new ProductStatus(); if(!$ProductStatus->updateSkuStatusByOrderStatus(array($insertOrderDataRow))){ self::$errCode = "400"; self::$errMsg = "已经包含订单信息,不能重复插入!"; return false; }*/ //var_dump($insertOrderDataRow); exit; //return $insertOrderDataRow; self::$errCode = "200"; self::$errMsg = "转移成功!"; return true; } else { self::$errCode = "400"; self::$errMsg = "已经包含订单信息,不能重复插入!"; return false; } }