public static function auditOrder($orderid, $sku, $type, $status, $purchaseId, $note = '', $storeId = 1) { //exit; !self::$dbConn ? self::initDB() : NULL; $res = array(); //var_dump($orderid, $sku, $type, $status, $purchaseId); $ordercheck = "select * from om_unshipped_order where id = {$orderid} and is_delete = 0 and storeId = " . $storeId; $ordercheck = self::$dbConn->query($ordercheck); $ordercheck = self::$dbConn->fetch_array($ordercheck); if (empty($ordercheck)) { self::$errCode = 502; self::$errMsg = '未找到对应的订单!'; return false; } else { $notecontent = ''; if (!empty($note)) { $notecontent = " , note = '{$note}' "; } $c_sql = "select * from om_records_order_audit where omOrderId={$orderid} and sku='{$sku}' "; //echo $c_sql; $c_sql = self::$dbConn->query($c_sql); $c_sql = self::$dbConn->fetch_array_all($c_sql); //var_dump($c_sql); if (empty($c_sql)) { $sql = "INSERT INTO om_records_order_audit SET omOrderId={$orderid},sku='{$sku}',auditUser='******',auditTime=" . time() . ",lastModified=" . time() . ",auditStatus='{$status}'" . $notecontent; //echo $sql; } else { $sql = "UPDATE om_records_order_audit SET lastModified=" . time() . ",auditStatus='{$status}'" . $notecontent . " WHERE omOrderId={$orderid} AND sku='{$sku}'"; } if (self::$dbConn->query($sql)) { //echo "insert auit log"; echo "<br>"; } //BaseModel :: begin(); //开始事务 /*if($type=='1'){*/ $ch_sql = "SELECT a.sku,a.omOrderId as detail_id FROM om_unshipped_order_detail AS a WHERE a.omOrderId='{$orderid}' "; $ch_sql = self::$dbConn->query($ch_sql); $check_array = self::$dbConn->fetch_array_all($ch_sql); $isend = true; $status_arr = array(); $array_sku = array(); //echo "<pre>"; //var_dump($check_array); foreach ($check_array as $check_sku) { $array_sku = GoodsModel::get_realskuinfo($check_sku['sku']); //var_dump($array_sku); foreach ($array_sku as $key_sku => $num) { $compare_sql = "SELECT sku,auditStatus FROM om_records_order_audit WHERE omOrderId='{$orderid}' and sku='{$key_sku}' "; //echo $compare_sql; echo "<br>"; $compare_sql = self::$dbConn->query($compare_sql); $compare_sql = self::$dbConn->fetch_array($compare_sql); if (empty($compare_sql)) { $isend = false; break; } else { if (!in_array($compare_sql['auditStatus'], $status_arr)) { array_push($status_arr, $compare_sql['auditStatus']); } } } } //var_dump($isend); //var_dump($status_arr); exit; if ($isend) { if (in_array(1, $status_arr) && in_array(2, $status_arr)) { $updateArr = array('orderStatus' => C('STATEOVERSIZEDORDERS'), 'orderType' => C('STATEOVERSIZEDORDERS_PA')); } else { if (in_array(1, $status_arr)) { if ($ordercheck['calcWeight'] > 2) { $updateArr = array('orderStatus' => C('STATEPENDING'), 'orderType' => C('STATEPENDING_OW')); } else { $updateArr = array('orderStatus' => C('STATEOVERSIZEDORDERS'), 'orderType' => C('STATEOVERSIZEDORDERS_TA')); } } else { if (in_array(2, $status_arr)) { $updateArr = array('orderStatus' => C('STATEOVERSIZEDORDERS'), 'orderType' => C('STATEOVERSIZEDORDERS_WB')); } } } /*else{ }*/ //var_dump($updateArr); //$sql = "UPDATE om_unshipped_order SET ".array2sql($updateArr)." where id={$orderid} AND orderStatus = '".C('STATEOVERSIZEDORDERS')."' AND orderType = '".C('STATEOVERSIZEDORDERS_PEND')."' AND is_delete = 0 "; $sql = "UPDATE om_unshipped_order SET " . array2sql($updateArr) . " where id={$orderid} AND orderStatus = '" . C('STATEOVERSIZEDORDERS') . "' AND is_delete = 0 "; //$log_data .= $sql."\n"; if (self::$dbConn->query($sql)) { //echo "update order success"; } /*else{ echo "update order error"; }*/ //BaseModel :: commit(); //BaseModel :: autoCommit(); } else { /*self::$errCode = 040; self::$errMsg = '审核异常,有审核通过!'; return false;*/ //$log_data .= "isend is false!\n"; } /*}else */ if ($type == '2') { $sql = "UPDATE om_records_order_audit SET lastModified=" . time() . ",note='{$note}' WHERE omOrderId={$orderid} AND sku='{$sku}' "; if (self::$dbConn->query($sql)) { //BaseModel :: commit(); //BaseModel :: autoCommit(); self::$errCode = 200; self::$errMsg = '添加备注成功!'; return true; } else { self::$errCode = 03; self::$errMsg = '添加备注失败!'; return false; } } self::$errCode = 200; self::$errMsg = '审核完成!'; return true; } }