public static function temporarilyUnsend($orderIdArr)
{
self::initDB();
self::$dbConn->begin();
//事物
$serchSql = "SELECT * FROM om_unshipped_order WHERE id in ('" . join("','", $orderIdArr) . "') and is_delete = 0 ";
$querySql = self::$dbConn->query($serchSql);
$serchSqlArr = self::$dbConn->fetch_array_all($querySql);
//判断一：判断订单是否被删除
if (count($serchSqlArr) < count($orderIdArr)) {
self::$errCode = "1111";
self::$errMsg = "包含已经被删除的订单！请确认。";
return false;
}
//$orderSn = array();//订单编号
//$dateStr = date("Y-m",time());//日志日期表明
foreach ($serchSqlArr as $selectArr) {
//$orderSn[] = $selectArr['id'];
//判断二：订单被其他人 <锁定> 订单判断
if ($selectArr['isLock'] == 1 && $selectArr['lockUser'] != $_SESSION['sysUserId']) {
self::$errCode = "1111";
self::$errMsg = "订单：[" . $selectArr['id'] . "]已经被 [" . $selectArr['lockUser'] . "] 锁定，不能操作。";
return false;
}
//判断三：已经是‘暂不寄’的订单跳过
if ($selectArr['orderStatus'] == 100 && $selectArr['orderType'] == 500) {
continue;
}
//移动操作
$updateSql = "UPDATE om_unshipped_order SET orderStatus = 100,orderType = 500 WHERE id = {$selectArr['id']}";
if (!self::$dbConn->query($updateSql)) {
self::$dbConn->rollback();
//事物回滚
self::$errCode = "0000";
self::$errMsg = "mysq: " . $updateSql . " error!";
return false;
}
//移动日志添加 后期 会有公共方法插入 现在是写死了
/*$insertSql = "INSERT INTO `om_order_log_2013-09_2013-12` (`operatorId`,`omOrderId`,`oldStatus`,`newStatus`,`sql`,`createdTime`)VALUES('".$_SESSION['sysUserId']."','".$selectArr['id']."','".$selectArr['orderStatus']."','500','".addslashes($updateSql)."','".time()."')";
if(!self::$dbConn->query($insertSql)){
self::$dbConn->rollback();//事物回滚
self :: $errCode = "0000";
self :: $errMsg = "mysq: ".$insertSql." error!";
return false;
}*/
}
self::$dbConn->commit();
//事物提交
self::$errCode = "200";
self::$errMsg = "<暂不寄>标记成功！";
return true;
}
public function act_temporarilyUnsend()
{
$orderIdArr = array();
$postData = trim($_POST['omData']);
//订单编号队列
$orderIdArr = explode(',', $postData);
$returnList = TemporarilyUnsendModel::temporarilyUnsend($orderIdArr);
if ($returnList) {
self::$errCode = TemporarilyUnsendModel::$errCode;
self::$errMsg = TemporarilyUnsendModel::$errMsg;
return true;
} else {
self::$errCode = TemporarilyUnsendModel::$errCode;
self::$errMsg = TemporarilyUnsendModel::$errMsg;
return false;
}
}
