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