public function changeOrderStatus($orderId, $status, $opUser)
{
$orderInf = $this->getOrderInfroByid($orderId);
if (FALSE === $orderInf) {
self::$errMsg = '不存在订单信息!';
return FALSE;
}
$originStatus = $orderInf['status'];
$optime = time();
$updataSql = "update wh_prepGoodsOrder set status='{$status}' where id='{$orderId}'";
$logSql = "\n insert into wh_preGoodsStatusChLog (orderId, originalStatus, changedStatus, opuser, optime) values (\n '{$orderId}', '{$originStatus}', '{$status}', '{$opUser}', '{$optime}'\n )\n ";
$this->dbConn->begin();
$changeQuery = $this->dbConn->query($updataSql);
//更新状态
if (FALSE === $changeQuery) {
$this->dbConn->rollback();
self::$errMsg = '更新状态出错!';
return FALSE;
}
$logQuery = $this->dbConn->query($logSql);
//记录操作日志
if (FALSE === $logQuery) {
$this->dbConn->rollback();
self::$errMsg = '记录日志失败!';
return FALSE;
}
$this->dbConn->commit();
return TRUE;
}
