public function boxReview($sku, $num, $boxid, $user, &$isend)
{
$inboxSkuInfo = $this->getSkuInfoInBox($sku, $boxid);
if (FALSE === $inboxSkuInfo) {
self::$errMsg = '不存在的sku!';
return FALSE;
}
if ($inboxSkuInfo['num'] != $num) {
//相等 复核成功
self::$errMsg = '复核数量不对!';
return FALSE;
}
$isend = $this->isLastSku($sku, $boxid);
// var_dump($isend);exit;
$this->dbConn->begin();
$sku = mysql_real_escape_string($sku);
$time = time();
$insertReview = "insert into wh_boxReview (boxId, sku, number, time, opuser) values ('{$boxid}', '{$sku}', '{$num}', '{$time}', '{$user}')";
// echo $insertReview;exit;
$insert_query = $this->dbConn->query($insertReview);
if (FALSE === $insert_query) {
$this->dbConn->rollback();
self::$errMsg = '写入复核记录失败!';
return FALSE;
}
if ($isend) {
$updateSql = "update wh_boxinuse set status=2, reviewTime={$time}, reviewUser={$user} where boxid='{$boxid}'";
// echo $updateSql;exit;
$updateQuery = $this->dbConn->query($updateSql);
if (FALSE === $updateQuery) {
//更新状态失败 回滚
$this->dbConn->rollback();
self::$errMsg = '更新订单状态回滚';
return FALSE;
}
}
$this->dbConn->commit();
return TRUE;
}
