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