/** * 功能:调用发送短信接口 * @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";