/**
*功能：提供接口，给深圳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;
}
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;
}
}
