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(); }