/**
* 插入一条记录
* @para $data as array
* return insert_id
*/
public static function insertRow($data)
{
self::initDB();
$sql = array2sql($data);
$sql = "INSERT INTO `" . self::$table . "` SET " . $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$insertId = self::$dbConn->insert_id();
return $insertId;
} else {
self::$errCode = "003";
self::$errMsg = "error";
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'];
$check_num = $_POST['check_num'];
$rejects_num = $_POST['rejects_num'];
$bad_reason = post_check($_POST['bad_reason']);
if (!empty($rejects_num)) {
$set = "SET infoId='{$id}',sku='{$sku}',defectiveNum='{$rejects_num}',note='{$bad_reason}' ";
$res = DefectiveProductsModel::addDefectiveProducts($set);
if ($res) {
$data = array('detectorId' => $_SESSION['userId'], 'detectStartTime' => time(), 'detectStatus' => 3, 'typeId' => $typeid, 'ichibanNum' => $num - $rejects_num);
if (WhStandardModel::update($data, "and id='{$id}'")) {
self::$errMsg = "提交成功，请检测下一料号";
return true;
} else {
self::$errCode = "003";
self::$errMsg = "提交失败，请重试";
return false;
}
} else {
self::$errCode = "003";
self::$errMsg = "提交失败，请重试";
return false;
}
} else {
$data = array('detectorId' => $_SESSION['userId'], 'detectStartTime' => time(), 'detectStatus' => 3, 'typeId' => $typeid, 'ichibanNum' => $num);
if (WhStandardModel::update($data, "and id='{$id}'")) {
self::$errMsg = "提交成功，请检测下一料号";
return true;
} else {
self::$errCode = "003";
self::$errMsg = "提交失败，请重试";
return false;
}
}
}
function act_getWhSkuInfo()
{
$sku = $_POST['sku'];
/*
*扫描SKU条码goods_code转换
*/
if (is_numeric($sku) && $sku > 1000000) {
$goods_codes = WhStandardModel::goods_codeTosku($sku);
$sku = $goods_codes['sku'];
}
//SKU信息API接口
$OmAvailableApiAct = new OmAvailableApiAct();
$skuInfo = $OmAvailableApiAct->act_getGoodsInfoBySku($sku);
if ($skuInfo['errCode'] == '201') {
self::$errCode = "003";
self::$errMsg = "【{$sku}】：没有该SKU信息，请确认！";
return false;
}
$skuInfo = $skuInfo['data'];
$reSku = $skuInfo['sku'];
//接口返回SKU
$reSpu = $skuInfo['spu'];
//接口返回SKU
$skuName = $skuInfo['goodsName'];
//产品描述
$purchaseId = $skuInfo['purchaseId'];
//采购人ID
/*
*产品分类信息ID格式 : 8-49-270
*产品分类信息name格式 : 服装及配饰-女装-T恤衫
*/
$goodsCategory = $skuInfo['goodsCategory'];
$goodsCategoryNameArray = explode("-", $goodsCategory);
$qcCategoryListAct = new qcCategoryListAct();
$getCategoryArr = $qcCategoryListAct->act_getCategoryArr();
//获取产品类别列表信息
/*
* 产品分类 对比 检测类别 path ： sampleTypeId 1-15-422 -> 服装类
* 返回数组：[2] => 3C电子-功能检测
* 参数：8-49-270
*/
$getSampleTypeArr = $qcCategoryListAct->act_getSampleTypeName($goodsCategory);
$goodsCategoryName = array();
foreach ($goodsCategoryNameArray as $cvalue) {
$goodsCategoryName[] = $getCategoryArr[$cvalue];
}
$goodsCategoryNameStr = join('-', $goodsCategoryName);
if (!$getSampleTypeArr) {
self::$errCode = "003";
self::$errMsg = "【{$goodsCategoryNameStr}】：分类错误，请确认！";
return false;
}
foreach ($getSampleTypeArr as $key => $valArr) {
$sampleTypeKey = $key;
$sampleTypeStr = $valArr;
}
/*
*获取仓库信息：
[goods_count] => 30
[goods_location] => B0501
[cguser] => 张文辉
*/
$whData = UserCacheModel::qccenterGetErpGoodscount($sku);
self::$errCode = "200";
$info = array();
$info['info'] = "产品描述：【{$sku}】{$skuName} <br> 产品分类： {$goodsCategoryNameStr} <br>现有库存： " . $whData['goods_count'] . " <br>仓位信息：【" . $whData['goods_location'] . "】<br>采购信息：{$whData['cguser']} ";
$info['spu'] = $reSpu;
//返回图片系统SPU
$info['sku'] = $reSku;
//返回系统正确SKU
$info['whNum'] = $whData['goods_count'];
//返回比较数据：检测数不能超过实际库存数量
$info['skuName'] = $skuName;
//返回产品描述
$info['sampleTypeId'] = $sampleTypeKey;
//返回检测列别ID
$info['sampleTypeStr'] = $sampleTypeStr;
//返回检测方法
return $info;
}
