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;
}
}
