Exemplo n.º 1
0
 private function getTemplateList()
 {
     extract($this->generateInfo());
     $pagesize = 100;
     $msgtpl_obj = new AmazonMessageTemplateModel();
     $all = $msgtpl_obj->getAllMessageNumber(' and ownerid in (0, ' . $_SESSION['globaluserid'] . ')');
     $page_obj = new Page($all, $pagesize);
     $usercache = new UserCacheModel();
     $templatelist = $msgtpl_obj->getAllTemplateList(' and ownerid in (0,' . $_SESSION['globaluserid'] . ') ' . $page_obj->limit);
     foreach ($templatelist as &$tpval) {
         $info = empty($tpval['ownerid']) ? $tpval['username'] = '******' : $usercache->getUserInfoBySysId($tpval['ownerid'], 0);
         if (is_array($info)) {
             $tpval['username'] = $info['userName'];
         }
     }
     if ($all > $pagesize) {
         //分页
         $pagestr = $page_obj->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
     } else {
         $pagestr = $page_obj->fpage(array(0, 2, 3));
     }
     $this->smarty->assign('pagestr', $pagestr);
     $this->smarty->assign('addurl', $editUrl);
     $this->smarty->assign('toplevel', 2);
     $this->smarty->assign('sec_menue', $sec_menueid);
     $this->smarty->assign('tpllist', $templatelist);
     $this->smarty->assign('toptitle', 'message模板列表');
     $this->smarty->display('msgtemplatelistAmazon.htm');
 }
Exemplo n.º 2
0
 /**
  * 功能:调用发送短信接口
  * @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"})';
     }
 }
Exemplo n.º 3
0
 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;
     }
 }
Exemplo n.º 4
0
function P($group, $power)
{
    $powerlist = UserCacheModel::getPowerList($_SESSION['userId']);
    if (array_key_exists($group, $powerlist) && in_array($power, $powerlist[$group])) {
        return TRUE;
    } else {
        return FALSE;
    }
}
Exemplo n.º 5
0
 public function act_search($buyer_userid = "", $recordnumber = "")
 {
     if (!empty($buyer_userid) || !empty($recordnumber)) {
         $paramArr = array('method' => 'erp.scan_returnSearch.php', 'buyer_userid' => $buyer_userid, 'recordnumber' => ${$recordnumber});
         $data = UserCacheModel::callOpenSystem2($paramArr);
         return $data;
     } else {
         self::$errCode = "301";
         self::$errMsg = "非法搜索条件不";
         return false;
     }
 }
Exemplo n.º 6
0
 public function act_login()
 {
     $username = trim($_POST['username']);
     //用户名
     $password = trim($_POST['password']);
     //密码
     if (empty($username) || empty($password)) {
         //用户名或密码为空
         self::$errCode = 1;
         self::$errMsg = '请正确填写用户名和密码!';
         return false;
     }
     //echo $username, $password;exit;
     $loginresult = Auth::login($username, $password, '1');
     $loginresult = json_decode($loginresult, true);
     //json解码
     if ($loginresult['errCode'] != 0) {
         //登陆失败
         self::$errCode = 1;
         switch ($loginresult['errCode']) {
             case '0001':
                 self::$errMsg = '网络错误!';
                 break;
             case '1820':
                 self::$errMsg = '状态错误';
                 break;
             case '1821':
                 self::$errMsg = 'token过期!';
                 break;
             case '1822':
                 self::$errMsg = '用户名或密码不正确!';
                 break;
             default:
                 break;
         }
         return false;
     } else {
         //登陆成功
         self::$errCode = 2;
         self::$errMsg = '';
         //添加数据到session
         $_SESSION['userId'] = $loginresult['userId'];
         $_SESSION['userName'] = $username;
         $_SESSION['userToken'] = $loginresult['userToken'];
         //缓存数据到memcache和数据库
         //var_dump($loginresult);exit;
         UserCacheModel::userInfoCache($loginresult['userToken'], $loginresult['userId']);
         return $loginresult;
     }
 }
Exemplo n.º 7
0
 public function act_login()
 {
     $errStr = "";
     $username = "";
     $password = "";
     if ($_SERVER['REQUEST_METHOD'] == "POST") {
         $username = trim($_POST['username']);
         $password = trim($_POST['password']);
     } else {
         $username = trim($_GET['username']);
         $password = trim($_GET['password']);
     }
     $loginInfo = Auth::login($username, $password);
     $loginInfo = json_decode($loginInfo, true);
     if (isset($loginInfo['errCode'])) {
         return array('errCode' => $loginInfo['errCode'], 'errMsg' => '用户名或者密码错误', 'data' => '');
     }
     $_SESSION['userId'] = $loginInfo['userId'];
     $_SESSION['userToken'] = $loginInfo['userToken'];
     $_SESSION['lastLoginTime'] = $loginInfo['lastLoginTime'];
     $_SESSION['userName'] = $username;
     /*
     	   $where  = "and `username` = '$username'";
             $result = UserModel::getUserInfo($where);
     if(!empty($result)){
     	$where1 = "and `username` = '$username'";
     	$data = array(
     		'userPowerId' => $loginInfo['userId']
     	);
     	UserModel::update($data,$where1);
     }else{
     	$data = array(
     		'userPowerId' => $loginInfo['userId'],
     		'userName'    => $username,
     	);
     	UserModel::insertRow($data);
     }
     //存储缓存数据
     //UserCacheModel::userInfoCache($loginInfo['userToken'] ,$loginInfo['userId']);
     */
     UserCacheModel::userInfoCache($loginInfo['userToken']);
     //UserCacheModel::goodsInfosCache("*", "sku='001'");
     return array('url' => 'index.php?mod=iqc&act=iqcList');
 }
Exemplo n.º 8
0
 function act_getsku()
 {
     $TransactionID = isset($_POST['TransactionID']) ? post_check($_POST['TransactionID']) : '';
     $TransactionID = trim($TransactionID, "´");
     $CommentingUser = isset($_POST['CommentingUser']) ? post_check($_POST['CommentingUser']) : '';
     $ItemID = isset($_POST['itemId']) ? post_check($_POST['itemId']) : '';
     $FeedbackID = isset($_POST['FeedbackID']) ? post_check($_POST['FeedbackID']) : '';
     $CommentType = isset($_POST['CommentType']) ? post_check($_POST['CommentType']) : '';
     $field = 'a.ebay_ordersn, a.ebay_paidtime, b.sku, b.ebay_amount';
     //echo "$CommentingUser,$ItemID,$TransactionID";
     $orderInfo = UserCacheModel::getErpOrderInfo($CommentingUser, $ItemID, $TransactionID, $field);
     //var_dump($orderInfo);exit;
     $ordersn = $orderInfo['data'][0]['ebay_ordersn'];
     //订单号
     $sku = $orderInfo['data'][0]['sku'];
     //料号
     $amount = $orderInfo['data'][0]['ebay_amount'];
     //数量
     $orderPayTime = $orderInfo['data'][0]['ebay_paidtime'];
     //付款时间
     $data = array('Qty' => $amount, 'sku' => $sku, 'orderPayTime' => $orderPayTime);
     EbayFeedbackModel::update($data, " and FeedbackID = '{$FeedbackID}'");
     UserCacheModel::updateErpOrderInfoFeedback($ordersn, $ItemID, $TransactionID, $CommentType);
 }
$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) {
Exemplo n.º 10
0
 /**
  * 调用开放系统指定接口的公用方法
  * para:method:调用开发系统接口的接口名,paArr为传递的参数(参数均要用数组包装,不能直接传字段)
  * add by hws
  */
 public static function callOpenSystemForRq($paArr, $type = "get")
 {
     include_once "/data/web/wh.valsun.cn/api/include/functions.php";
     if (empty($paArr) || !is_array($paArr)) {
         //参数不规范
         self::$errCode = 301;
         self::$errMsg = '参数信息不规范';
         return false;
     } else {
         $paramArr = $paArr;
         $paramArr['format'] = 'json';
         $paramArr['v'] = '1.0';
         $paramArr['username'] = '******';
         //生成签名
         if ($type == "post") {
             $sign = createSignP($paramArr, self::$token);
         } else {
             $sign = createSign($paramArr, self::$token);
         }
         //echo $sign,"<br/>";
         //组织参数
         $strParam = createStrParam($paramArr);
         $strParam .= 'sign=' . $sign;
         //echo $strParam,"<br/>";
         //构造Url
         $urls = self::$url . $strParam;
         //echo $urls,"<br/>";
         //连接超时自动重试3次
         $cnt = 0;
         if ($type == "post") {
             while ($cnt < 3 && ($result = @curl($urls, $paramArr)) === FALSE) {
                 $cnt++;
             }
         } else {
             while ($cnt < 3 && ($result = @vita_get_url_content($urls)) === FALSE) {
                 $cnt++;
             }
         }
         //$result = file_get_contents($urls);
         //print_r($result);die;
         $data = json_decode($result, true);
         if ($data) {
             self::$errCode = 200;
             self::$errMsg = 'Success';
             return $data;
         } else {
             self::$errCode = $data['errCode'];
             self::$errMsg = $data['errMsg'];
             return false;
         }
     }
 }
Exemplo n.º 11
0
 /**
 * 提供给刊登那边的接口,根据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;
     }
 }
Exemplo n.º 12
0
<?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 "失败";
        }
        $pmId = $pmList[0]['pmName'];
    }
    if (empty($purchaseId)) {
        $purchaseId = "<span style='color:red'>无</span>";
    } else {
        $purchaseId = getPersonNameById($purchaseId);
    }
    if (empty($goodsCategory)) {
        $goodsCategory = "<span style='color:red'>无</span>";
    } else {
        $goodsCategory = getAllCateNameByPath($goodsCategory);
    }
    $tdIndex = $index + 1;
    $table .= "<tr><td>{$tdIndex}</td><td>{$sku}</td><td>{$goodsWeight}</td><td>{$pmId}</td><td>{$purchaseId}</td><td>{$goodsCategory}</td></tr>";
}
$table .= "</table>";
$table .= '<p style="' . $css_height . '">欲知所有问题料号,请联系产品中心负责人。详情请登录:<a href="' . $system_url . '" target="_blank">' . $system_name . '</a><br/></br>' . date('Y-m-d', $endTime) . '<br/>' . $system_name . '</p>';
//$table = '1111111';
echo $table . "\n";
echo 'table length = ' . strlen($table) . "\n";
echo 'table urlencode length = ' . strlen(urlencode($table)) . "\n";
$paramArr = array("sysName" => 'ProductCenter', "from" => $from, "to" => $to, "cc" => $cc, "type" => $type, "title" => $title, "content" => $table);
$message = UserCacheModel::getOpenSysApiPost('notice.send.message', $paramArr, '');
//get
//$message = UserCacheModel :: getOpenSysApiPost('notice.send.message', $paramArr,'gw88');//post
echo 'message = ';
var_dump($message);
echo "\n";
//echo $message, "\n";
echo "完成时间" . date('Y-m-d H:i:s', time()) . "\n";
exit;
Exemplo n.º 14
0
 /**
  * CommonModel::updateOrderStatusFromWhAfterMQ()
  * 接收队列接收订单时,推送订单号到订单系统
  * @author Gary
  * @param int $orderId
  * @return
  */
 public static function updateOrderStatusFromWhAfterMQ($orderId)
 {
     $paramArr = array('method' => 'order.updateOrderStatusFromWhAfterMQ', 'omOrderIds' => $orderId);
     $res = UserCacheModel::callOpenSystem2($paramArr);
     unset($paramArr);
     return $res;
 }
Exemplo n.º 15
0
 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']);
 }
Exemplo n.º 16
0
function GetFeedback($account, $startpage, $endpage, $perPageCount)
{
    //require_once  WEB_PATH."lib/xmlhandle.php";
    global $dbcon, $api_feedback, $user;
    echo '同步feedback,开始于第' . $startpage . '页,结束于第' . $endpage . '页,每页同步' . $perPageCount . '条' . "\n";
    $hasmore = true;
    $status = "";
    $FBAct = new EbayFeedbackAct();
    while (true) {
        echo '开始运行,第' . $startpage . '页' . "\n";
        $responseXml = $api_feedback->request($startpage, $perPageCount);
        if (stristr($responseXml, 'HTTP 404') || $responseXml == '') {
            return 'id not found';
        }
        $data = XML_unserialize($responseXml);
        //var_dump($data);
        $ack = $data['GetFeedbackResponse']['Ack'];
        $TotalNumberOfPages = $data['GetFeedbackResponse']['PaginationResult']['TotalNumberOfPages'];
        if ($ack != "Success") {
            echo "<font color=red>评价加载失败</font>";
            //var_dump($data['GetFeedbackResponse']);exit;
        }
        $feedback = $data['GetFeedbackResponse']['FeedbackDetailArray']['FeedbackDetail'];
        foreach ($feedback as $li) {
            $CommentingUser = str_rep($li['CommentingUser']);
            $CommentingUserScore = str_rep($li['CommentingUserScore']);
            $CommentText = mysql_real_escape_string(str_rep($li['CommentText']));
            $CommentTime = str_rep($li['CommentTime']);
            $feedbacktime = date('Y-m-d H:i:s', strtotime($CommentTime));
            $feedbacktime = date('Y-m-d H:i:s', strtotime("{$feedbacktime} - 900 minutes"));
            $feedbacktime = strtotime($feedbacktime);
            $CommentType = str_rep($li['CommentType']);
            $ItemID = str_rep($li['ItemID']);
            $FeedbackID = str_rep($li['FeedbackID']);
            $TransactionID = $li['TransactionID'] ? $li['TransactionID'] : 0;
            $ItemTitle = str_rep($li['ItemTitle']);
            $currencyID = str_rep($li['ItemPrice attr']['currencyID']);
            $ItemPrice = str_rep($li['ItemPrice']);
            $data = array('CommentingUser' => $CommentingUser, 'account' => $account, 'CommentingUserScore' => $CommentingUserScore, 'CommentText' => $CommentText, 'CommentTime' => $CommentTime, 'CommentType' => $CommentType, 'ItemID' => $ItemID, 'FeedbackID' => $FeedbackID, 'TransactionID' => $TransactionID, 'ItemTitle' => $ItemTitle, 'currencyID' => $currencyID, 'ItemPrice' => $ItemPrice, 'feedbacktime' => $feedbacktime);
            $list = $FBAct->act_getOrderList('id', " where FeedbackID='{$FeedbackID}' ");
            if (!$list) {
                //不存在,则插入
                $ret = EbayFeedbackModel::insertRow($data);
                if ($ret) {
                    echo "insert success!\n";
                    $field = 'a.ebay_ordersn, a.ebay_paidtime, b.sku, b.ebay_amount';
                    $orderInfo = UserCacheModel::getErpOrderInfo($CommentingUser, $ItemID, $TransactionID, $field);
                    /* var_dump($orderInfo);
                    			exit; */
                    $ordersn = $orderInfo['data'][0]['ebay_ordersn'];
                    //订单号
                    $sku = $orderInfo['data'][0]['sku'];
                    //料号
                    $amount = $orderInfo['data'][0]['ebay_amount'];
                    //数量
                    $orderPayTime = $orderInfo['data'][0]['ebay_paidtime'];
                    //付款时间
                    $data = array('Qty' => $amount, 'sku' => $sku, 'orderPayTime' => $orderPayTime);
                    EbayFeedbackModel::update($data, " and FeedbackID = '{$FeedbackID}'");
                    UserCacheModel::updateErpOrderInfoFeedback($ordersn, $ItemID, $TransactionID, $CommentType);
                } else {
                    echo "insert failed!\n";
                }
            } else {
                echo "Exsited!\n";
            }
        }
        if ($startpage >= $endpage) {
            break;
        }
        $startpage++;
    }
}
Exemplo n.º 17
0
 public function outStock($sku, $num, $opuser, $orderid, &$isEnd, $waitScan, $orderSn)
 {
     $isLastOne = true;
     //是否为最后一个待配货sku
     $preGoods_Obj = new PreGoodsOrdderManageModel();
     $allSkuInfo = $preGoods_Obj->getSKUDetail($orderid);
     //订单的全部sku列表
     foreach ($allSkuInfo as $row) {
         //判断该料号配完以后是否可以终结该备货单
         if ($row['amount'] != $row['scantnum'] && $row['sku'] != $sku) {
             $isLastOne = FALSE;
         }
     }
     if ($waitScan != $num) {
         $isLastOne = FALSE;
     }
     $isEnd = $isLastOne;
     //$this->logRequest(" sku==> $sku 数量==> $num");                           //记录请求日志
     $paramArr['method'] = 'ow_pregood_changestock';
     //API名称
     $paramArr['sku'] = $sku;
     $paramArr['num'] = $num;
     $paramArr['orderSn'] = $orderSn;
     $paramArr['operUser'] = getUserNameById($opuser);
     $messageInfo = UserCacheModel::callOpenSystem2($paramArr);
     //先到老系统扣库存
     if (FALSE === $messageInfo) {
         //请求开发系统出错
         self::$errmsg = '请求开放系统出错!';
         return FALSE;
     }
     $code = isset($messageInfo['code']) ? trim($messageInfo['code']) : '';
     if ($code !== 'success') {
         //扣库存失败
         self::$errmsg = $messageInfo['msg'];
         return FALSE;
     }
     $sku = mysql_real_escape_string($sku);
     $this->dbConn->begin();
     $rcordInfo = $this->getSkuInboxRecords($sku);
     if (FALSE === $rcordInfo) {
         //还没有封箱库存记录 则新增一条记录
         $insertResult = $this->insertNewInboxRecords($sku, $num);
         if (FALSE === $insertResult) {
             //插入失败 回滚
             $this->dbConn->rollback();
             self::$errmsg = "新增封箱库存记录失败!";
             return FALSE;
         }
     } else {
         //追加库存
         $updateSql = "update wh_inboxStock set num=num+{$num} where sku='{$sku}'";
         $updateQuery = $this->dbConn->query($updateSql);
         if (FALSE === $updateQuery) {
             //更新封箱库存失败 回滚
             $this->dbConn->rollback();
             self::$errmsg = "更新封箱库存失败!";
             return FALSE;
         }
     }
     $time = time();
     $updateOrder = "\n                update wh_prepDetail set scantnum=scantnum+{$num}, scantime={$time}, scanuser='******' where \n                sku='{$sku}' and orderid='{$orderid}'\n            ";
     $upOrderQuery = $this->dbConn->query($updateOrder);
     //更新备货单的扫描数量
     if (FALSE === $upOrderQuery) {
         $this->dbConn->rollback();
         self::$errmsg = '更新备货单数据失败!';
         return FALSE;
     }
     if (TRUE === $isLastOne) {
         //配货完成 修改备货单状态
         $upStatusSql = "update wh_prepGoodsOrder set status=3 where id='{$orderid}'";
         $upStatusQuery = $this->dbConn->query($upStatusSql);
         if (FALSE === $upStatusQuery) {
             $this->dbConn->rollback();
             self::$errmsg = '更新备货单状态失败!';
             return FALSE;
         }
     }
     $originNum = isset($rcordInfo['num']) ? $rcordInfo['num'] : 0;
     $logSql = "insert into wh_skuscanLog (orderId, sku, scanNum, originNum, opuser, scanTime) values\n                    ({$orderid}, '{$sku}', '{$num}', '{$originNum}', '{$opuser}', '{$time}')\n                ";
     $logResult = $this->dbConn->query($logSql);
     //记录操作日志
     if (FALSE === $logResult) {
         //写日志失败 回滚
         $this->dbConn->rollback();
         self::$errmsg = '写入操作日志失败!';
         return FALSE;
     }
     $this->dbConn->commit();
     return TRUE;
 }
Exemplo n.º 18
0
 public function view_getWhRecManageList()
 {
     $paramArr = array();
     $type = isset($_GET['type']) ? $_GET['type'] : '';
     $status = isset($_GET['status']) ? $_GET['status'] : '';
     $reStatus = isset($_GET['reStatus']) ? $_GET['reStatus'] : 0;
     $page = isset($_GET['page']) ? $_GET['page'] : 1;
     $paramArr['method'] = 'purchase.getPurchaseOrderList';
     //API名称
     $paramArr['page'] = $page;
     $paramArr['status'] = $reStatus;
     if ($type == 'search') {
         $keyWord = isset($_GET['keyWord']) ? post_check($_GET['keyWord']) : '';
         $select = isset($_GET['select']) ? post_check($_GET['select']) : 0;
         $cStartTime = isset($_GET['cStartTime']) ? post_check($_GET['cStartTime']) : '';
         $cEndTime = isset($_GET['cEndTime']) ? post_check($_GET['cEndTime']) : '';
         $eStartTime = isset($_GET['eStartTime']) ? post_check($_GET['eStartTime']) : '';
         $eEndTime = isset($_GET['eEndTime']) ? post_check($_GET['eEndTime']) : '';
         if (!empty($select)) {
             $paramArr['key'] = $keyWord;
             $paramArr['type'] = $select;
         }
         if (!empty($cStartTime)) {
             $startTime = strtotime($cStartTime . '00:00:00');
             $paramArr['addTime_start'] = $startTime;
         }
         if (!empty($cEndTime)) {
             $endTime = strtotime($cEndTime . '23:59:59');
             $paramArr['addTime_end'] = $endTime;
         }
         if (!empty($eStartTime)) {
             $startTime = strtotime($eStartTime . '00:00:00');
             $paramArr['auditTime_start'] = $startTime;
         }
         if (!empty($eEndTime)) {
             $endTime = strtotime($eEndTime . '23:59:59');
             $paramArr['auditTime_end'] = $endTime;
         }
     }
     $purchase_order = UserCacheModel::callOpenSystem($paramArr);
     $total = $purchase_order[0];
     $whRecManageList = $purchase_order[1];
     if (!empty($whRecManageList)) {
         $usermodel = UserModel::getInstance();
         $count = count($whRecManageList);
         for ($i = 0; $i < $count; $i++) {
             //仓库
             $storeId = empty($whRecManageList[$i]['warehouse_id']) ? 1 : $whRecManageList[$i]['warehouse_id'];
             $whName_info = WarehouseManagementModel::warehouseManagementModelList("where companyId=1 and id={$storeId}");
             $whRecManageList[$i]['whName'] = $whName_info[0]['whName'];
             $purchaseuser_info = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id='{$whRecManageList[$i]['purchaseuser_id']}'", '', 'limit 1');
             $inventory_info[$i]['purchaseuser'] = $purchaseuser_info[0]['global_user_name'];
         }
     }
     $num = 100;
     //每页显示的个数
     $page = new Page($total, $num, '', 'CN');
     if (!empty($_GET['page'])) {
         if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
             $n = 1;
         } else {
             $n = (intval($_GET['page']) - 1) * $num + 1;
         }
     } else {
         $n = 1;
     }
     if ($total > $num) {
         //输出分页显示
         $show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
     } else {
         $show_page = $page->fpage(array(0, 2, 3));
     }
     $navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '库存信息'), array('url' => '', 'title' => '收货管理表'));
     $this->smarty->assign('navlist', $navlist);
     $this->smarty->assign('toptitle', '收货管理表');
     $this->smarty->assign('toplevel', 0);
     $this->smarty->assign('secondlevel', '09');
     $this->smarty->assign('show_page', $show_page);
     $this->smarty->assign('status', $status);
     $this->smarty->assign('whRecManageList', $whRecManageList);
     //循环列表
     $this->smarty->display("whRecManageList.htm");
 }
Exemplo n.º 19
0
 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);
     }
 }
     $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'];
     }
    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'];
Exemplo n.º 22
0
 public static function getGoodsInfos($fields = '*', $where = 'id=1')
 {
     if (empty($fields) || empty($where)) {
         //参数不完整
         self::$errCode = 301;
         self::$errMsg = '参数信息不完整';
         return false;
     } else {
         $paramArr = array('method' => 'pc.goods.info.get', 'format' => 'json', 'v' => '1.0', 'username' => 'valsun.cn', 'fields' => $fields, 'where' => $where);
         //生成签名
         $sign = createSign($paramArr, self::$token);
         //echo $sign,"<br/>";
         //组织参数
         $strParam = createStrParam($paramArr);
         $strParam .= 'sign=' . $sign;
         //echo $strParam,"<br/>";
         //构造Url
         $urls = self::$url . $strParam;
         //echo $urls,"<br/>";exit;
         //连接超时自动重试3次
         $cnt = 0;
         while ($cnt < 3 && ($result = @vita_get_url_content($urls)) === FALSE) {
             $cnt++;
         }
         //$result = file_get_contents($urls);
         $data = json_decode($result, true);
         if ($data) {
             self::$errCode = 200;
             self::$errMsg = 'Success';
             return $data;
         } else {
             self::$errCode = "000";
             self::$errMsg = "is empty!";
         }
     }
 }
Exemplo n.º 23
0
 public function view_printOrder()
 {
     @session_start();
     $orderId = isset($_GET['orderId']) ? trim($_GET['orderId']) : NULL;
     if (empty($orderId)) {
         goErrMsgPage(array('data' => array('缺少参数!'), 'link' => 'index.php?mod=owGoodsReplenishManage&act=showOrderList'));
         exit;
     }
     $preObj = new PreGoodsOrdderManageModel();
     $idar = explode(",", $orderId);
     $idar = array_map('intval', $idar);
     $finalAr = array();
     foreach ($idar as $id) {
         $newData = array();
         $orderInf = $preObj->getOrderInfroByid($id);
         if (FALSE == $orderInf) {
             continue;
         }
         //如果备货单状态为待处理更状态为待配货状态
         if ($orderInf['status'] == 1) {
             $preObj->changeOrderStatus($id, 2, $_SESSION['userId']);
         }
         $tempAr = array('orderInf' => $orderInf);
         $deatil = $preObj->getSKUDetailByStatus($id);
         $skuArr = '';
         foreach ($deatil as $k => $v) {
             $sku = $v['sku'];
             $skuArr .= "'" . $sku . "',";
         }
         $skuArr = substr($skuArr, 0, strlen($skuArr) - 1);
         $paramArr['method'] = 'wh.OverSeaGetSkuStock';
         //API名称
         $paramArr['sku'] = $skuArr;
         $rtnInfo = UserCacheModel::callOpenSystem2($paramArr);
         $code = $rtnInfo['errCode'];
         $data = array();
         $printArr = array();
         $skuStock = array();
         if ($code == 200) {
             $data = $rtnInfo['data'];
             foreach ($data as $m => $n) {
                 $sku = $n['sku'];
                 $qty = $n['qty'];
                 //B仓库存
                 if ($qty > 0) {
                     if (!in_array($sku, $printArr)) {
                         $printArr[] = $sku;
                         $skuStock[$sku] = $qty;
                     }
                 }
             }
         }
         $detail = array();
         $num = 0;
         foreach ($deatil as $kk => $vv) {
             $sku = $vv['sku'];
             if (in_array($sku, $printArr)) {
                 $detail[$num]['id'] = $vv['id'];
                 $detail[$num]['sku'] = $vv['sku'];
                 $detail[$num]['amount'] = $vv['amount'];
                 $detail[$num]['qtyB'] = $skuStock[$sku];
                 $num++;
             }
         }
         $tempAr['skulist'] = $detail;
         $finalAr[] = $tempAr;
     }
     include WEB_PATH . 'html/template/v1/pregoodsprint.htm';
 }
<?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 {
        //字符串中带_
Exemplo n.º 25
0
 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;
 }
Exemplo n.º 26
0
 /**
  * 调用开放系统指定接口的公用方法
  * para:method:调用开发系统接口的接口名,paArr为传递的参数(参数均要用数组包装,不能直接传字段)
  * add by zqt
  */
 public static function getOpenSysApi($method, $paArr)
 {
     require_once WEB_PATH . "api/include/functions.php";
     if (empty($method) || empty($paArr) || !is_array($paArr)) {
         //参数不规范
         self::$errCode = 301;
         self::$errMsg = '参数信息不规范';
         return false;
     } else {
         $paramArr = array('format' => 'json', 'v' => '1.0', 'username' => 'valsun.cn');
         $paramArr['method'] = $method;
         //调用接口名称,系统级参数
         foreach ($paArr as $key => $value) {
             if (!is_array($value)) {
                 //如果传递的应用级参数不是数组的话,直接加入到paramArr中
                 $paramArr[$key] = $value;
             } else {
                 $paramArr['jsonArr'] = base64_encode(json_encode($value));
                 //对数组进行jsonencode再对其进行base64编码进行传递,否则直接传递数组会出错
             }
         }
         //生成签名
         $sign = createSign($paramArr, self::$token);
         //echo $sign,"<br/>";
         //组织参数
         $strParam = createStrParam($paramArr);
         $strParam .= 'sign=' . $sign;
         //echo $strParam,"<br/>";
         //构造Url
         $urls = self::$url . $strParam;
         //连接超时自动重试3次
         $cnt = 0;
         while ($cnt < 3 && ($result = @vita_get_url_content($urls)) === FALSE) {
             $cnt++;
         }
         //$result = file_get_contents($urls);
         $data = json_decode($result, true);
         if ($data) {
             self::$errCode = 200;
             self::$errMsg = 'Success';
             return $data;
         } else {
             self::$errCode = "000";
             self::$errMsg = "is empty!";
             return false;
         }
     }
 }
Exemplo n.º 27
0
 public static function getOpenSysApiPost($method, $paArr, $idc = '')
 {
     include_once WEB_PATH . "api/include/functions.php";
     if (empty($method) || empty($paArr) || !is_array($paArr)) {
         //参数不规范
         self::$errCode = 301;
         self::$errMsg = '参数信息不规范';
         return false;
     } else {
         $paramArr = array('format' => 'json', 'v' => '1.0', 'app_key' => 'valsun.cn', 'protocol' => 'param2');
         $paramArr['method'] = $method;
         //调用接口名称,系统级参数
         foreach ($paArr as $key => $value) {
             if (!is_array($value)) {
                 //如果传递的应用级参数不是数组的话,直接加入到paramArr中
                 $paramArr[$key] = $value;
             } else {
                 $paramArr['jsonArr'] = base64_encode(json_encode($value));
                 //对数组进行jsonencode再对其进行base64编码进行传递,否则直接传递数组会出错
             }
         }
         //生成签名
         $sign = createSign2($paramArr, self::$token);
         //echo $sign,"<br/>";
         //组织参数
         $strParam = createStrParam($paramArr);
         $strParam .= 'sign=' . $sign;
         //echo $strParam,"<br/>";
         if ($idc == '') {
             $url = self::$url;
         } else {
             $url = 'http://gw.open.valsun.cn:88/router/rest?';
         }
         //构造Url
         $urls = $url . $strParam;
         // echo self::$token.'<br>';
         //echo $urls;
         //            exit;
         //连接超时自动重试3次
         $cnt = 0;
         while ($cnt < 3 && ($result = @Curl($urls, $paramArr)) === FALSE) {
             $cnt++;
         }
         //print_r($result);
         //            exit;
         $data = json_decode($result, true);
         // 			var_dump($data,$result,"++___+++");exit;
         if ($data) {
             self::$errCode = 200;
             self::$errMsg = 'Success';
             return $data;
         } else {
             self::$errCode = "000";
             self::$errMsg = "is empty!";
         }
     }
 }
$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);
Exemplo n.º 29
0
 function updateErpOrderInfoFeedback($ordersn, $ebay_itemid, $ebay_tid, $feedback)
 {
     if ($ordersn == '' || $ebay_itemid == '' || $ebay_tid == '' || $feedback == '') {
         self::$errCode = '001';
         self::$errMsg = "参数错误!";
         return false;
     }
     $paArr = array('ordersn' => $ordersn, 'ebay_itemid' => $ebay_itemid, 'ebay_tid' => $ebay_tid, 'ebay_feedback' => $feedback);
     $info = self::getOpenSysApi('erp.updateErpOrderInfoFeedback', $paArr);
     return $info;
 }
Exemplo n.º 30
0
 /**
  * 备货单料号复核完成后,将配货数量同步到采购系统备货单
  * Enter description here ...
  * @param 备货单号 $ordersn
  * @param 料号 $sku
  * @param 数量 $num
  */
 public function updPurOrderQty($ordersn, $sku, $num)
 {
     $paramArr['method'] = 'ow_updBOrderAmount';
     //API名称
     $paramArr['ordersn'] = $ordersn;
     $paramArr['sku'] = $sku;
     $paramArr['amount'] = $num;
     $rtnInfo = UserCacheModel::callOpenSystem($paramArr);
     return $rtnInfo;
 }