public function act_getAllPicApi() { require_once WEB_PATH . "html/api/include/opensys_functions.php"; if (empty($spu)) { $spu = strlen(htmlentities($_REQUEST['spu'], ENT_QUOTES)) > 0 ? htmlentities($_REQUEST['spu'], ENT_QUOTES) : ''; } if (empty($picType)) { $picType = strlen(htmlentities($_REQUEST['picType'], ENT_QUOTES)) > 0 ? htmlentities($_REQUEST['picType'], ENT_QUOTES) : ''; } $errStr = ''; if (empty($spu)) { $errStr .= '料号输入错误!<br />'; } if (empty($picType)) { $errStr .= '站点输入错误!<br />'; } if (!empty($errStr)) { self::$errCode = '001'; self::$errMsg = $errStr; return false; } $token = "5f5c4f8c005f09c567769e918fa5d2e3"; $url = 'http://idc.gw.open.valsun.cn/router/rest?'; $paramArr = array('method' => 'datacenter.picture.getAllSizePic', 'format' => 'json', 'v' => '1.0', 'username' => 'datacenter', 'spu' => $spu, 'picType' => $picType); //生成签名 $sign = createSign($paramArr, $token); //组织参数 $strParam = createStrParam($paramArr); $strParam .= 'sign=' . $sign; //构造Url $urls = $url . $strParam; //echo $urls; //return $urls; $cnt = 0; while ($cnt < 3 && ($result = @vita_get_url_content($urls)) === FALSE) { $cnt++; } $data = json_decode($result, true); return $data; }
function act_updateTNameRow() { $jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : ''; //传过来的base64编码的json字符串 if (empty($jsonArr)) { self::$errCode = 101; self::$errMsg = '参数数组为空'; return false; } $jsonArr = json_decode(base64_decode($jsonArr), true); //对base64及json解码 if (!is_array($jsonArr)) { self::$errCode = 103; self::$errMsg = '参数数组不是数组格式'; return false; } $tName = $jsonArr['tName']; //表名 $set = $jsonArr['set']; //set,用关键字SET $where = $jsonArr['where']; //where,要带上关键字WHERE if (empty($tName) || empty($set) || empty($where)) { self::$errCode = '300'; self::$errMsg = '必要参数不完整'; return false; } $affectRows = OmAvailableModel::updateTNameRow($tName, $set, $where); if ($affectRows !== FALSE) { self::$errCode = '200'; self::$errMsg = '成功'; return $affectRows; } else { self::$errCode = '404'; self::$errMsg = '数据库操作错误'; return false; } }
/** *功能:提供接口,给深圳ERP同步产品信息 * */ public function act_getGoodsInForERPTB() { $tName = 'pc_goods'; $select = '*'; $where = "order by id desc limit 500"; $skuList = OmAvailableModel::getTNameList($tName, $select, $where); $returnArr = array(); foreach ($skuList as $value) { $tmpArr = array(); $tmpArr['goods_id'] = $value['id']; $tmpArr['goods_name'] = $value['goodsName']; $tmpArr['goods_sn'] = $value['sku']; $tmpArr['spu'] = $value['spu']; $tmpArr['goods_price'] = $value['goodsCost']; $tmpArr['goods_cost'] = $value['goodsCost']; $tmpArr['goods_weight'] = $value['goodsWeight']; $tmpArr['goods_length'] = $value['goodsLength']; $tmpArr['goods_width'] = $value['goodsWidth']; $tmpArr['goods_height'] = $value['goodsHeight']; $tmpArr['goods_category'] = $value['goodsCategory']; $tmpArr['ebay_user'] = '******'; $tmpArr['color'] = $value['goodsColor']; $tmpArr['size'] = $value['goodsSize']; $goodsStatus = $value['goodsStatus']; if ($goodsStatus == 1) { //在线 $tmpArr['isuse'] = 0; } elseif ($goodsStatus == 51) { //PK产品 $tmpArr['isuse'] = 51; } elseif ($goodsStatus == 2) { //停售 $tmpArr['isuse'] = 1; } elseif ($goodsStatus == 3) { //暂时停售 $tmpArr['isuse'] = 3; } else { //其余的都做下线处理 $tmpArr['isuse'] = 1; } $tmpArr['cguser'] = getPersonNameById($value['purchaseId']); if (intval($value['spu']) > 0) { $tmpArr['mainsku'] = $value['spu']; } else { $tmpArr['mainsku'] = intval(ord(substr($value['spu'], 0, 1)) . ord(substr($value['spu'], 1, 1))) * 100000 + intval(substr($value['spu'], 2)); } $tmpArr['add_time'] = $value['goodsCreatedTime']; $tmpArr['goods_code'] = $value['id'] + 1000000; $tmpArr['is_new'] = $value['isNew']; $returnArr[] = $tmpArr; } self::$errCode = 200; self::$errMsg = "成功"; return $returnArr; }
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; }