function act_getSkuInfo()
{
$sku = $_POST['sku'];
$is_delete = $_POST['is_delete'];
if (is_numeric($sku) && $sku > 1000000) {
//此sku为goods_code
$goods_codes = WhStandardModel::goods_codeTosku($sku);
$sku = $goods_codes['sku'];
}
//$where = "where sku='$sku' and sellerId=0 and detectStatus=0 order by id desc";
if ($is_delete) {
//如果是已删数据检索
$where = "where sku='{$sku}' and is_delete=1 order by id desc";
} else {
$where = "where sku='{$sku}' and detectStatus=0 and is_delete=0 order by id desc";
}
$list = WhStandardModel::getNowWhList("*", $where);
foreach ($list as $key => $value) {
$list[$key]['printTime'] = date("Y-m-d H:i:s", $value['printTime']);
$list[$key]['printerId'] = userModel::getUsernameById($value['printerId']);
$list[$key]['purchaseId'] = userModel::getUsernameById($value['purchaseId']);
$list[$key]['deleteUserId'] = userModel::getUsernameById($value['deleteUserId']);
$list[$key]['getUserId'] = userModel::getUsernameById($value['getUserId']);
}
if ($list) {
return $list;
} else {
$where = "where sku='{$sku}' order by id desc limit 3";
$list = WhStandardModel::getNowWhList("*", $where);
foreach ($list as $key => $value) {
if (!empty($value['getTime']) && $value['detectStatus'] == 1) {
$user = userModel::getUsernameById($value['getUserId']);
$getTime = date('Y-m-d H:i:s', $value['getTime']);
self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$getTime}</font>被<font color='green'>{$user}</font>领取，请联系他/她。<br>";
} else {
if ($value['is_delete'] == 1) {
$printer = userModel::getUsernameById($value['printerId']);
$printTime = date('Y-m-d H:i:s', $value['printTime']);
self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$printTime}</font>由<font color='green'>{$printer}</font>打印，已过期删除!<br>";
} else {
if ($value['detectStatus'] == 3) {
$detector = userModel::getUsernameById($value['detectorId']);
$detectTime = date('Y-m-d H:i:s', $value['detectStartTime']);
self::$errMsg .= "-料号-{$value['sku']} {$value['num']}件-于<font color='green'>{$detectTime}</font>由<font color='green'>{$detector}</font>检测完成!<br>";
}
}
}
}
if (self::$errMsg == '') {
if ($is_delete == 0) {
self::$errMsg .= "-料号-{$sku}-不在待领取列表中，请联系<font color='green'>仓库或打标人员</font>!<br>";
} else {
self::$errMsg .= "-料号-{$sku}-未在删除数据中找到。<br>";
}
}
self::$errCode = "003";
return false;
}
}
function act_allDetermined($category = 1, $skuTypeCheckID = 1)
{
$data = array();
$data['infoId'] = $_POST['id'];
$id = $_POST['id'];
$data['spu'] = $_POST['spu'];
$data['pendingNum'] = $_POST['num'];
$data['sku'] = $_POST['sku'];
$data['pendingStatus'] = empty($_POST['rewrite_type']) ? 0 : 1;
$data['note'] = post_check($_POST['wait_reason']);
$data['modifyStatus'] = $_POST['rewrite_type'];
$data['startTime'] = time();
$sample_info = WhStandardModel::getNowWhList('*', ' where id = ' . $id);
//之前待定过，然后恢复检测的不能再待定
$pendingStatus = $sample_info[0]['pendingStatus'];
if ($pendingStatus == 5) {
self::$errCode = '004';
self::$errMsg = '此料号已正常回测，不能再待定！';
return false;
}
if ($data['modifyStatus'] == 1) {
$modifynum = PendingProductsModel::getModifyNum($_POST['sku']);
if ($modifynum >= 3) {
self::$errCode = "001";
self::$errMsg = "此料号本月修改图片已超过三次！请见其全部检测未不良品！";
return false;
}
}
$log_file = 'skuDetermined/' . date("Y-m-d") . '.txt';
$data['purchaseId'] = $sample_info[0]['purchaseId'];
$set = "SET " . array2sql($data);
$res = PendingProductsModel::addPendingProducts($set);
$log_info = "全部待定：" . date("Y-m-d H:i:s") . "批次：{$sample_info[0]['printBatch']}，SKU:{$_POST['sku']}，待定数：{$data['pendingNum']}\r\n";
write_log($log_file, $log_info);
if ($res) {
$data = array('detectorId' => $_SESSION['sysUserId'], 'detectStartTime' => time(), 'detectStatus' => 4);
if (WhStandardModel::update($data, "and id='{$_POST['id']}'")) {
$c_data = array('sku' => $_POST['sku'], 'goodsName' => $sample_info[0]['goodsName'], 'arrivalNum' => $_POST['num'], 'checkNum' => $check_num, 'rejectsNum' => 0, 'rejectsReason' => '', 'checkUser' => $_SESSION['sysUserId'], 'checkTime' => time(), 'skuTypeCheckID' => $skuTypeCheckID, 'checkTypeID' => $category);
//$useract = new userAct();
IqcCompleteInfoModel::insertRow($c_data);
$purchaser = userModel::getUsernameById($sample_info[0]['purchaseId']);
//$purchaser = userModel::getUsernameById(9);
$from = userModel::getUsernameById($_SESSION['sysUserId']);
$mailList['content'] = $from . "在IQC检测中检测料号 " . $_POST['sku'] . " 时将其全部待定！数量：" . $_POST['num'] . ",请及时做处理!====" . date("Y-m-d H:i:s") . "====";
//$mailList['content'] = "发错了！不好意思。";
$mailList['from'] = $from;
$mailList['to'] = $purchaser;
$mailList['type'] = "email";
$mailList['callback'] = "";
self::$errMsg = "提交成功，请检测下一料号";
return $mailList;
} else {
self::$errCode = "003";
self::$errMsg = "提交失败，请重试";
return false;
}
} else {
self::$errCode = "003";
self::$errMsg = "提交失败，请重试";
return false;
}
//TransactionBaseModel::commit();
}
