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_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; }