function act_getSkuInfo() { $sku = $_POST['sku']; $where = "where sku='{$sku}' and sellerId=0 and getUserId='{$_SESSION['userId']}' and detectStatus=1 order by getTime asc limit 1"; $list = WhStandardModel::getNowWhList("*", $where); if ($list) { $info = array(); $info['info'] = " 领货记录:{$_SESSION['userName']} 于<br> " . date("Y-m-d H:i", $list[0]['getTime']) . " 领货成功<br>\n\t\t\t\t\t料号信息:总共---{$list[0]['num']},<br>\n\t\t\t\t\t名字要获取!"; //(料:{$sku},库存:要获取 个, 仓:要获取,采购:要获取)!"; $info['num'] = $list[0]['num']; $info['id'] = $list[0]['id']; return $info; } else { self::$errCode = "003"; self::$errMsg = "未找到该料号[{$sku}]对于的{$_SESSION['userName']}领取记录!"; return false; } }
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_getSkuInfo() { $sku = $_POST['sku']; $where = "where sku='{$sku}' and sellerId=0 and detectStatus=0 order by id desc"; $list = WhStandardModel::getNowWhList("*", $where); if ($list) { return $list; } else { self::$errCode = "003"; self::$errMsg = "没有找到对应的料号!"; return false; } }
function act_otherCheck() { $data = array(); $typeid = $_POST['typeid']; $id = $_POST['id']; $num = $_POST['num']; $sku = $_POST['sku']; $spu = $_POST['spu']; $check_num = $_POST['check_num']; $rejects_num = $_POST['rejects_num']; $checkTypeID = $_POST['checkTypeID']; $bad_reason = post_check($_POST['bad_reason']); $sample_info = WhStandardModel::getNowWhList('*', ' where id = ' . $id); if ($sample_info[0][typeId] != 3) { self::$errCode = "001"; self::$errMsg = "此条记录不是属于退件检测的!请勿用退件检测!"; return false; } $ichibanNum = $num - $rejects_num; $msg = userCacheModel::updateWhOrderBackichibanNum($sample_info[0]['printBatch'], $sku, $ichibanNum); if (!empty($rejects_num)) { $set = "SET infoId='{$id}',sku='{$sku}',spu='{$spu}',defectiveNum='{$rejects_num}',note='{$bad_reason}',startTime=" . time() . " "; $res = DefectiveProductsModel::addDefectiveProducts($set); if ($res) { $data = array('detectorId' => $_SESSION['sysUserId'], 'detectStartTime' => time(), 'detectStatus' => 3, 'typeId' => $typeid, 'ichibanNum' => $num - $rejects_num); if (WhStandardModel::update($data, "and id='{$id}'")) { $c_data = array('sku' => $sku, 'goodsName' => $sample_info[0]['goodsName'], 'arrivalNum' => $num, 'checkNum' => $check_num, 'rejectsNum' => $rejects_num, 'rejectsReason' => $bad_reason, 'checkUser' => $_SESSION['sysUserId'], 'checkTime' => time(), 'skuTypeCheckID' => 1, 'checkTypeID' => $checkTypeID, 'sellerId' => 1); IqcCompleteInfoModel::insertRow($c_data); if ($checkTypeID == 3) { $data = UserCacheModel::qccenterUpdateErpGoodscount($sku, $rejects_num); } self::$errMsg = "提交成功,请检测下一料号"; return $data; } else { self::$errCode = "003"; self::$errMsg = "提交失败,请重试"; return false; } } else { self::$errCode = "003"; self::$errMsg = "提交失败,请重试"; return false; } } else { $data = array('detectorId' => $_SESSION['sysUserId'], 'detectStartTime' => time(), 'detectStatus' => 4, 'typeId' => $typeid, 'ichibanNum' => $num); if (WhStandardModel::update($data, "and id='{$id}'")) { $c_data = array('sku' => $sku, 'goodsName' => $sample_info[0]['goodsName'], 'arrivalNum' => $num, 'checkNum' => $check_num, 'rejectsNum' => $rejects_num, 'rejectsReason' => $bad_reason, 'checkUser' => $_SESSION['sysUserId'], 'checkTime' => time(), 'skuTypeCheckID' => 1, 'checkTypeID' => $checkTypeID, 'sellerId' => 1); IqcCompleteInfoModel::insertRow($c_data); self::$errMsg = "提交成功,请检测下一料号"; return true; } else { self::$errCode = "003"; self::$errMsg = "提交失败,请重试"; return false; } } }