function act_addPendingProducts($set)
{
$list = PendingProductsModel::updatePendingProducts($set);
if ($list) {
return $list;
} else {
self::$errCode = PendingProductsModel::$errCode;
self::$errMsg = PendingProductsModel::$errMsg;
return false;
}
}
function act_operatePendingProducts()
{
//QC对待定列表中进行修改图片，正常回测，待退回（全部，不分部分）
//$pendingId表示待定表中的记录ID,$status表示修改图片，正常回测或待退回
try {
$cTime1 = time() + microtime();
$pendingId = isset($_GET['pendingId']) ? post_check($_GET['pendingId']) : '';
$status = isset($_GET['status']) ? post_check($_GET['status']) : '';
$tracktime = isset($_GET['tracktime']) ? post_check($_GET['tracktime']) : '';
//echo $pendingId.' '.$status;
$select = '*';
$where = "WHERE id='{$pendingId}'";
$pendingProductsList = PendingProductsModel::getPendingProductsList($select, $where);
if (empty($pendingProductsList)) {
throw new Exception("error");
}
TransactionBaseModel::begin();
$selectStatus = $pendingProductsList[0]['pendingStatus'];
if ($selectStatus != 0 && $selectStatus != 2) {
//如果该条待定记录中的状态不是0或2（待处理或者是图片修改完成时，报错）
throw new Exception("error");
}
$startTime = $pendingProductsList[0]['startTime'];
$pendingNum = $pendingProductsList[0]['pendingNum'];
$pendingId = $pendingProductsList[0]['id'];
$infoId = $pendingProductsList[0]['infoId'];
// $spu = $pendingProductsList[0]['spu'];
$sku = $pendingProductsList[0]['sku'];
$now = time();
if ($status == 1) {
//修改图片
$set = "SET pendingStatus='1',processedNum='{$pendingNum}',startTime='{$now}' ";
//状态改为需要修改图片
$where = "WHERE id='{$pendingId}'";
PendingProductsModel::updatePendingProducts($set, $where);
//先将该待定记录的相关字段修改
//这里还要调用API在产品中心待修改列表中添加一条记录//
//先略过，到时处理
} elseif ($status == 2) {
//正常回测
$set = "SET pendingStatus='3',processedNum='{$pendingNum}',lastModified='{$now}' ";
//状态改为已处理pendingStatus='3'
if (empty($startTime)) {
//如果不是从修改完图片进行回测的话(即开始处理时间为空)，要加上开始处理时间
$set .= ",startTime='{$now}' ";
}
$where = "WHERE id='{$pendingId}'";
//echo $set;
PendingProductsModel::updatePendingProducts($set, $where);
//先将该待定记录的相关字段修改
//这里还要在wh_sample_info中将$infoId这条记录的detectStatus状态改为1（待检测），pid=$pendingId
$select = 'id';
$where = "WHERE id='{$infoId}'";
$whInfoList = PendingProductsModel::getWhInfo($select, "WHERE id='{$infoId}'");
//取出wh_info表中关联pendingId的记录
if (empty($whInfoList)) {
//如果该infoid在whInfo中找不到记录的话
throw new Exception("error infoId");
}
$set = "set detectStatus='1',pid='{$pendingId}' ";
$affectRow = PendingProductsModel::updateWhInfo($set, $where);
//更新原来的wh_info表中的该记录
if ($affectRow != 1) {
//如果更新记录数不是唯一的，也报错
throw new Exception("update error");
}
} elseif ($status == 3) {
//待退回
$set = "SET pendingStatus='3',processedNum='{$pendingNum}',startTime='{$now}',lastModified='{$now}' ";
$where = "WHERE id='{$pendingId}'";
PendingProductsModel::updatePendingProducts($set, $where);
//先将该待定记录的相关字段修改
$note = '待定移至待退回';
$set = "SET infoId='{$infoId}',sku='{$sku}',note='{$note}',returnNum='{$pendingNum}'";
ReturnProductsModel::addReturnProducts($set);
//在退回表中表中添加记录；
} else {
throw new Exception("error status");
}
TransactionBaseModel::commit();
TransactionBaseModel::autoCommit();
$cTime2 = time() + microtime();
self::$errCode = $cTime2 . ' ' . $cTime1;
self::$errMsg = 'Success';
return 1;
} catch (Exception $e) {
TransactionBaseModel::rollback();
$cTime2 = time() + microtime();
self::$errCode = $cTime2 . ' ' . $cTime1;
self::$errMsg = $e->getMessage();
return 0;
}
}
