/**
* 功能:调用发送短信接口
* @param array $paramArr
* @param str $token
* @return void
* @author wxb
* date: 2013/11/1
*/
function view_sendMessage()
{
if (!isset($_SESSION)) {
@session_start();
}
$content = trim($_GET['content']);
$from = trim($_GET['from']);
$to = trim($_GET['to']);
$type = trim($_GET['type']);
$callback = trim($_GET['callback']);
if (!isset($_SESSION['userId'])) {
echo $callback . '({"errCode":"176","errMsg":"no login"})';
return;
}
if (empty($_GET['content']) || empty($_GET['from']) || empty($_GET['to']) || empty($_GET['type'])) {
echo $callback . '({"errCode":"044","errMsg":"get param fail"})';
return;
}
$paramArr = array("content" => $content, "from" => $from, "to" => $to, "type" => $type, "callback" => $callback);
$res = UserCacheModel::getOpenSysApi('notice.send.message', $paramArr, 'gw88', false);
//print_r('111');
// exit;
if ($res) {
echo $res;
} else {
echo $callback . '({"errCode":"1120","errMsg":"call open fail"})';
}
}
function act_getProducts2pc($select, $where)
{
$listArr = UserCacheModel::getOpenSysApi('pc.getEbayProducts2PcProducts', array('all' => 'all'), 'gw88');
if ($listArr) {
foreach ($listArr as $value) {
$tName = 'pc_products';
$where = "WHERE is_delete=0 and productsStatus=1 and sku='{$value['sku']}'";
$skuCount = OmAvailableModel::getTNameCount($tName, $where);
if (!$skuCount) {
$pc_pro = array();
$pc_pro['id'] = $value['id'];
if (!empty($value['sku'])) {
$tmpArr = explode('_', $value['sku']);
$pc_pro['spu'] = $tmpArr[0];
}
$pc_pro['sku'] = $value['sku'];
$pc_pro['productsStatus'] = 1;
$pc_pro['productsComfirmerId'] = getPersonIdByName($value['comfirmuser']);
$pc_pro['productsComfirmTime'] = $value['comfirmtime'];
OmAvailableModel::addTNameRow2arr($tName, $pc_pro);
}
}
self::$errCode = 200;
self::$errMsg = 'success';
return true;
} else {
self::$errCode = 404;
self::$errMsg = 'error';
return false;
}
}
/**
* 提供给刊登那边的接口，根据SPU返回对应SPU下每个SKU的状态
* 三无产品， 即符合以下任一条件的产品
1. 无包材
2. 无重量
3. 无英文品名
4. 无海关编码
5. 无仓位
6. 停售
* 传递一个spu， 拉取所有sku的三无判断， 以sku为键值对
array(
//sku=>array(状态码, 原因)
'1001_A' => array('0',''), //正常
'1001_B' => array('1','无仓位'),
'1001_C' => array('2','无重量'),
'1001_D' => array('6','停售', 'ebay'),
)
不同原因用不同的状态码标示。
add by zqt 20140626 支持虚拟SPU
为第二个版本接口
*/
function act_getSkusStatusCodeBySpuV2()
{
$spu = isset($_REQUEST['spu']) ? $_REQUEST['spu'] : "";
if (empty($spu)) {
self::$errCode = '101';
self::$errMsg = "SPU为空";
return false;
}
$returnArr = array();
$tName = 'pc_goods';
$select = 'sku,goodsStatus,pmId,goodsWeight';
$where = "WHERE is_delete=0 AND spu='{$spu}'";
$skuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($skuList)) {
//单料号
$tName = 'pc_spu_tax_hscode';
$select = 'customsNameEN,hsCode';
$where = "WHERE spu='{$spu}'";
$spuHscodeList = OmAvailableModel::getTNameList($tName, $select, $where);
$customsNameEN = $spuHscodeList[0]['customsNameEN'];
//英文品名
$hsCode = $spuHscodeList[0]['hsCode'];
//海关编码
$skuTmpArr = array();
foreach ($skuList as $value) {
$skuTmpArr[] = $value['sku'];
}
$skuTmpArr = array_filter($skuTmpArr);
$overSeaSkuLocationList = UserCacheModel::getOpenSysApi('oversea.getSkuPos', array('type' => 'getSkuArrPos', 'skuArr' => json_encode($skuTmpArr)));
//根据SKU数组获取对应的美国仓库的仓位信息
$overSeaSkuLocationKVArr = $overSeaSkuLocationList['data'];
foreach ($skuList as $value) {
$sku = $value['sku'];
$goodsStatus = $value['goodsStatus'];
//状态
$pmId = $value['pmId'];
//包材id
$goodsWeight = $value['goodsWeight'];
//重量
$tName = 'pc_goods_whId_location_raletion';
$where = "WHERE sku='{$sku}' AND isHasLocation=1";
$isHasLocation = OmAvailableModel::getTNameCount($tName, $where);
//是否有仓位
$tmpArr = array();
//返回的为二维数组，第一维度为1，或2,1为中国仓，2为美国仓，第二维标识状态
$flagCN = 0;
//标识该料号中国仓是否正常，默认为0，正常
$flagAM = 0;
//标识该料号美国仓是否正常，默认为0，正常
if (intval($pmId) <= 0) {
$tmpArr[1][1] = '无包材';
$tmpArr[2][1] = '无包材';
$flagCN = 1;
$flagAM = 1;
}
if ($goodsWeight == 0) {
$tmpArr[1][2] = '无重量';
$tmpArr[2][2] = '无重量';
$flagCN = 1;
$flagAM = 1;
}
//恢复拦截
if (empty($customsNameEN)) {
$tmpArr[1][3] = '无英文品名';
$tmpArr[2][3] = '无英文品名';
$flagCN = 1;
$flagAM = 1;
}
if (empty($hsCode)) {
$tmpArr[1][4] = '无海关编码';
$tmpArr[2][4] = '无海关编码';
$flagCN = 1;
$flagAM = 1;
}
if (!$isHasLocation) {
$tmpArr[1][5] = '无仓位';
$flagCN = 1;
}
if (empty($overSeaSkuLocationKVArr[$sku]['pos'])) {
$tmpArr[2][5] = '无仓位';
$flagAM = 1;
}
//停售的先不包括在内
//if($goodsStatus != 1 && $goodsStatus != 51){
// $tmpArr[6] = '停售/暂时停售';
// $flag = 1;
// }
if ($flagCN == 0) {
$tmpArr[1][0] = '正常';
}
if ($flagAM == 0) {
$tmpArr[2][0] = '正常';
}
$returnArr[$sku] = $tmpArr;
}
self::$errCode = '200';
self::$errMsg = "真实SPU返回成功";
return $returnArr;
}
//虚拟料号
$combineSkuDetailInfo = getSkuDetailInfoByCombineSpu($spu);
if (!empty($combineSkuDetailInfo)) {
$skuArr = array();
foreach ($combineSkuDetailInfo as $combineSku => $skuDetailInfoArr) {
$skuArr = array();
foreach ($skuDetailInfoArr as $sku => $count) {
$skuArr[] = "'" . $sku . "'";
}
$skuSqlStr = implode(',', $skuArr);
if (!empty($skuSqlStr)) {
$tName = 'pc_goods';
$select = 'spu,sku,goodsStatus,pmId,goodsWeight';
$where = "WHERE is_delete=0 AND sku in({$skuSqlStr})";
$skuList = OmAvailableModel::getTNameList($tName, $select, $where);
$skuTmpArr = array();
foreach ($skuList as $value) {
$skuTmpArr[] = $value['sku'];
}
$skuTmpArr = array_filter($skuTmpArr);
$overSeaSkuLocationList = UserCacheModel::getOpenSysApi('oversea.getSkuPos', array('type' => 'getSkuArrPos', 'skuArr' => json_encode($skuTmpArr)));
//根据SKU数组获取对应的美国仓库的仓位信息
$overSeaSkuLocationKVArr = $overSeaSkuLocationList['data'];
$tmpArr = array();
//返回的为二维数组，第一维度为1，或2,1为中国仓，2为美国仓，第二维标识状态
$flagCN = 0;
//标识该料号中国仓是否正常，默认为0，正常
$flagAM = 0;
//标识该料号美国仓是否正常，默认为0，正常
if (!empty($skuList)) {
//单料号
foreach ($skuList as $value) {
$spu = $value['spu'];
$sku = $value['sku'];
$goodsStatus = $value['goodsStatus'];
//状态
$pmId = $value['pmId'];
//包材id
$goodsWeight = $value['goodsWeight'];
//重量
$tName = 'pc_spu_tax_hscode';
$select = 'customsNameEN,hsCode';
$where = "WHERE spu='{$spu}'";
$spuHscodeList = OmAvailableModel::getTNameList($tName, $select, $where);
$customsNameEN = $spuHscodeList[0]['customsNameEN'];
//英文品名
$hsCode = $spuHscodeList[0]['hsCode'];
//海关编码
$tName = 'pc_goods_whId_location_raletion';
$where = "WHERE sku='{$sku}' AND isHasLocation=1";
$isHasLocation = OmAvailableModel::getTNameCount($tName, $where);
//是否有仓位
if (intval($pmId) <= 0) {
$tmpArr[1][1] = '无包材';
$tmpArr[2][1] = '无包材';
$flagCN = 1;
$flagAM = 1;
}
if ($goodsWeight == 0) {
$tmpArr[1][2] = '无重量';
$tmpArr[2][2] = '无重量';
$flagCN = 1;
$flagAM = 1;
}
//恢复拦截
if (empty($customsNameEN)) {
$tmpArr[1][3] = '无英文品名';
$tmpArr[2][3] = '无英文品名';
$flagCN = 1;
$flagAM = 1;
}
if (empty($hsCode)) {
$tmpArr[1][4] = '无海关编码';
$tmpArr[2][4] = '无海关编码';
$flagCN = 1;
$flagAM = 1;
}
if (!$isHasLocation) {
$tmpArr[1][5] = '无仓位';
$flagCN = 1;
}
if (empty($overSeaSkuLocationKVArr[$sku]['pos'])) {
$tmpArr[2][5] = '无仓位';
$flagAM = 1;
}
//停售的先不包括在内
//if($goodsStatus != 1 && $goodsStatus != 51){
// $tmpArr[6] = '停售/暂时停售';
// $flag = 1;
// }
}
if ($flagCN == 0) {
$tmpArr[1][0] = '正常';
}
if ($flagAM == 0) {
$tmpArr[2][0] = '正常';
}
}
$returnArr[$combineSku] = $tmpArr;
}
}
self::$errCode = '200';
self::$errMsg = "虚拟SPU返回成功";
return $returnArr;
} else {
self::$errCode = '102';
self::$errMsg = "该SPU下不存在SKU";
return false;
}
}
public static function getAdjustransportFromPurchase($get = 1)
{
$method = 'purchase.getAdjustransport';
$paramArr = array();
//传递应用级参数数组
$paramArr['get'] = $get;
$data = UserCacheModel::getOpenSysApi($method, $paramArr);
//var_dump($data);
if (!isset($data['data'])) {
return array();
}
$__liquid_items_array = array();
foreach ($data['data'] as $dataValue) {
$__liquid_items_array[$dataValue['category']] = $dataValue['skulist'];
}
return $__liquid_items_array;
}
<?php
error_reporting(-1);
require_once "scripts.comm.php";
$accountArr = UserCacheModel::getOpenSysApi("getaccount", array('add' => 1));
$platformArr = array("aliexpress" => 2, "cndirect" => 8, "DHgate" => 4, "dresslink" => 10, "ebay平台" => 1, "Newegg" => 15, "亚马逊" => 11, "出口通" => 3, "国内销售部" => 16, "天猫哲果" => 13, "天猫芬哲" => 12, "海外仓" => 14, "海外销售平台" => 1, "线下结算客户" => 9);
foreach ($accountArr as $account) {
$insertarr = array();
foreach ($platformArr as $key => $value) {
if ($key == $account['ebay_platform']) {
$platformId = $value;
break;
}
}
$insertarr['id'] = $account['id'];
$insertarr['account'] = $account['ebay_account'];
$insertarr['addTime'] = 0;
$insertarr['addUser'] = $account['ebay_user'];
$insertarr['platformId'] = $platformId;
$insertarr['appname'] = $account['appname'];
$insertarr['email'] = $account['mail'];
$insertarr['suffix'] = $account['account_suffix'];
$insertarr['token'] = $account['ebay_token'];
$count = OmAvailableModel::getTNameList("fb_account", "id", " where id={$account['id']}");
$sql = array2sql($insertarr);
if (!count($count) > 0) {
if (OmAvailableModel::insertRow("fb_account", " set {$sql}")) {
echo "{$account['id']} \n";
} else {
echo "失败";
}
echo "总数小于或等于0，错误，退出 \n";
exit;
}
echo "总数是 {$countGoods} \n";
$per = 200;
//每次读取的条数
$countFor = ceil($countGoods / $per);
echo "每次读取 {$per} 条\n";
echo "要循环 {$countFor} 次 \n";
for ($i = 0; $i < $countFor; $i++) {
$start = $per * $i;
//$tName = 'ebay_goods';
// $select = '*';
// $where = "limit $start,$per";
//$ebayGoodsList = OmAvailableModel::getTNameList($tName, $select, $where);
$skuList = UserCacheModel::getOpenSysApi('pc.erp.getEbayOrderProductCrontab', array('start' => $start, 'per' => $per), 'gw88');
echo "这是第 {$i} 次读取，读取为 {$start} {$per} \n";
//print_r($skuList);
// exit;
$pcProductsArr = array();
$now = time();
foreach ($skuList as $value) {
$pcProductsArr['id'] = $value['id'];
$pcProductsArr['sku'] = $value['sku'];
if (!empty($value['sku'])) {
$tmpArr = explode('_', $value['sku']);
$pcProductsArr['spu'] = $tmpArr[0];
}
$pcProductsArr['productsStatus'] = $value['change_type'];
$comfirmer = $value['comfirmuser'];
$taker = $value['takeuser'];
$tName = 'pc_goods';
$where = "WHERE 1=1";
OmAvailableModel::deleteTNameRow($tName, $where);
//清空goods表
echo "清空 pc_goods表 成功！\n";
$tName = 'pc_goods_partner_relation';
$where = "WHERE 1=1";
OmAvailableModel::deleteTNameRow($tName, $where);
echo "清空 pc_goods_partner_relation 成功!\n";
for ($i = 0; $i < $countFor; $i++) {
$start = $per * $i;
//$tName = 'ebay_goods';
// $select = '*';
// $where = "limit $start,$per";
//$ebayGoodsList = OmAvailableModel::getTNameList($tName, $select, $where);
$ebayGoodsList = UserCacheModel::getOpenSysApi('pc.erp.getEbayGoodsCrontab', array('start' => $start, 'per' => $per), 'gw88');
echo "这是第 {$i} 次读取，读取为 {$start} {$per} \n";
//print_r($ebayGoodsList);
// exit;
$now = time();
foreach ($ebayGoodsList as $value) {
$pcGoodsArr = array();
$pcGoodsArr['id'] = $value['goods_id'];
$pcGoodsArr['goodsName'] = $value['goods_name'];
if (empty($pcGoodsArr['goodsName']) || $pcGoodsArr['goodsName'] == '无') {
$pcGoodsArr['is_delete'] = 1;
}
$pcGoodsArr['sku'] = $value['goods_sn'];
//$tName = 'pc_goods';
// $where = "WHERE sku='{$value['goods_sn']}'";
// OmAvailableModel::deleteTNameRow($tName, $where);
$userInfo = Auth::getApiGlobalUser($queryConditions);
$userInfo = json_decode($userInfo, true);
//print_r($userInfo);
//echo "\n";
$personId = $userInfo[0]['userId'];
echo "确认人Id is '{$personId}'\n";
$iostoreArr['comfirmUserId'] = $personId;
$iostoreArr['isComfirm'] = 2;
//已确认
}
$tName = 'pc_products_iostore';
$ioStoreId = OmAvailableModel::replaceTNameRow2arr($tName, $iostoreArr);
if (!$ioStoreId) {
continue;
}
$ioStoreDetailList = UserCacheModel::getOpenSysApi('pc.erp.getEbayProductIostoreDetailCrontab', array('io_ordersn' => $value['io_ordersn']), 'gw88');
//print_r($ioStoreDetailList);
// exit;
$countStoreDetail = count($ioStoreDetailList);
echo "{$value['io_ordersn']} 一共有 {$countStoreDetail} 条详细记录\n";
foreach ($ioStoreDetailList as $valueDetail) {
$iostoreDetailArr = array();
$iostoreDetailArr['id'] = $valueDetail['id'];
$iostoreDetailArr['iostoreId'] = $ioStoreId;
$iostoreDetailArr['iostoreTypeId'] = $iostoreArr['iostoreTypeId'];
$iostoreDetailArr['useTypeId'] = $iostoreArr['useTypeId'];
$iostoreDetailArr['sku'] = $valueDetail['goods_sn'];
if (intval($iostoreArr['addUserId']) > 0) {
$iostoreDetailArr['addUserId'] = $iostoreArr['addUserId'];
$iostoreDetailArr['addTime'] = $iostoreArr['createdTime'];
}
public static function getConversionSku($sku)
{
/*add by Herman.Xi @ 2013-06-04
新旧料号转换问题解决*/
$paArr = array('oldSku' => $sku);
$conversion_sku = UserCacheModel::getOpenSysApi('ph.showNewSku', $paArr);
return trim($conversion_sku['new_sku']);
}
function act_getSpuQcUserBySpu()
{
$spu = $_POST['spu'];
if (empty($spu)) {
self::$errCode = '101';
self::$errMsg = "SPU为空";
return false;
}
$spuQcUserIdList = UserCacheModel::getOpenSysApi('qc.getDetecorBySupArr', array('spuArr' => json_encode(array($spu))));
$qcUserId = $spuQcUserIdList['data'][$spu];
if (intval($qcUserId) <= 0) {
self::$errCode = '404';
self::$errMsg = "接口返回为空";
return false;
} else {
self::$errCode = '200';
self::$errMsg = "返回成功";
return getPersonNameById($qcUserId);
}
}
$where = "WHERE 1=1";
OmAvailableModel::deleteTNameRow($tName, $where);
//清空 combine 表
echo "pc_goods_combine 清空 success! \n";
$tName = 'pc_sku_combine_relation';
$where = "WHERE 1=1";
OmAvailableModel::deleteTNameRow($tName, $where);
//清空旧的关系表
echo "pc_sku_combine_relation 清空 success! \n";
for ($i = 0; $i < $countFor; $i++) {
$start = $per * $i;
//$tName = 'ebay_goods';
// $select = '*';
// $where = "limit $start,$per";
//$ebayGoodsList = OmAvailableModel::getTNameList($tName, $select, $where);
$ebayGoodsList = UserCacheModel::getOpenSysApi('pc.erp.getProductscombineCrontab2', array('start' => $start, 'per' => $per), 'gw88');
echo "这是第 {$i} 次读取，读取为 {$start} {$per} \n";
//print_r($ebayGoodsList);
// exit;
$pcGoodsArr = array();
$now = time();
foreach ($ebayGoodsList as $value) {
$pcGoodsArr = array();
$pcGoodsArr['id'] = $value['id'];
$pcGoodsArr['combineSku'] = $value['goods_sn'];
$tName = 'pc_goods_combine';
//$where = "WHERE combineSku='{$value['goods_sn']}'";
// OmAvailableModel::deleteTNameRow($tName, $where);//删除要插入的combineSku先
// echo "删除 combineSku{{$value['goods_sn']}} success!\n";
$pcGoodsArr['combineSpu'] = '';
if (strpos($value['goods_sn'], '_') === false) {
<?php
require_once "/data/web/pc.valsun.cn/framework.php";
Core::getInstance();
session_start();
header("Content-type:text/html;charset=utf-8");
date_default_timezone_set("Asia/Shanghai");
session_cache_expire(30);
//session有效时间为30分钟
$ebayGoodsList = array();
$ebayGoodsList = UserCacheModel::getOpenSysApi('pc.erp.getEbayProductscombineCrontab', array('all' => 'all'), 'gw88');
//print_r($ebayGoodsList);
//exit;
if (empty($ebayGoodsList)) {
echo 'no data';
exit;
}
$tName = 'pc_goods_combine';
$where = "WHERE id>127600";
OmAvailableModel::deleteTNameRow($tName, $where);
echo "删除 id>127600 成功\n";
$pcGoodsArr = array();
foreach ($ebayGoodsList as $value) {
$pcGoodsArr['id'] = $value['id'];
$pcGoodsArr['combineSku'] = $value['goods_sn'];
$pcGoodsArr['combineSpu'] = '';
if (strpos($value['goods_sn'], '_') === false) {
//字符串中不带_
$pcGoodsArr['combineSpu'] = $value['goods_sn'];
} else {
//字符串中带_
function getAllChannelInfo()
{
$data = UserCacheModel::getOpenSysApi('trans.carrier.channel.info.get', array('carrierId' => 'all'));
$returnArr = array();
if (!empty($data['data'])) {
foreach ($data['data'] as $value) {
$returnArr[$value['carrierId']][] = array('id' => $value['id'], 'channelName' => $value['channelName']);
}
}
return $returnArr;
}
public static function newData2ErpInterfOpen($metode, $paraArr, $idc = '', $decode = true)
{
if (self::$isSync == 'YES') {
$res = UserCacheModel::getOpenSysApi($metode, $paraArr, $idc, $decode = true);
return $res;
}
}
function getPicFromOpenSys($sku, $picType = '')
{
if (empty($sku)) {
return false;
}
if (empty($picType)) {
$picType = 'G';
}
$tName = 'pc_goods';
$select = 'spu';
$where = "WHERE sku='{$sku}'";
$spuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (empty($spuList[0]['spu'])) {
return false;
}
$spu = $spuList[0]['spu'];
$spuPicList = UserCacheModel::getOpenSysApi('datacenter.picture.getAllSizePic', array('spu' => str_pad($spu, 3, 0, STR_PAD_LEFT), 'picType' => $picType));
//$spuPicList = json_decode($spuPicList, true);
//return $spuPicList;
if (!empty($spuPicList['errCode'])) {
return false;
}
if (empty($spuPicList['data']['artwork'][$spu][0])) {
return false;
}
return $spuPicList['data']['artwork'][$spu][0];
}
<?php
require_once "/data/web/pc.valsun.cn/framework.php";
Core::getInstance();
session_start();
header("Content-type:text/html;charset=utf-8");
date_default_timezone_set("Asia/Shanghai");
session_cache_expire(30);
//session有效时间为30分钟
echo date('Y-m-d_H:i:s') . "开始运行 \n";
$page = 1;
//标识第几次通过接口取数据，初始值为第一次
do {
$skuInfoList = UserCacheModel::getOpenSysApi('wh.getSKUInInfo', array('page' => $page));
//调用idc上的仓库系统接口，返回指定下标及对应记录数
$skuInfoList = $skuInfoList['data'];
//print_r($skuInfoList);
// exit;
$totalNum = $skuInfoList['totalNum'];
//sku记录的总数
if (intval($totalNum) <= 0) {
echo "{$totalNum} <= 0 或者不是数字 \n";
continue;
}
$totalPage = ceil($totalNum / 200);
echo "共有 {$totalPage} 页 \n";
echo "这是第 {$page} 页，调用接口取得数据 \n";
$skuInfo = $skuInfoList['skuInfo'];
//具体的sku信息数组
if (empty($skuInfo) || !is_array($skuInfo)) {
echo "{$skuInfo} 为空或者不是数组 \n";
