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'); }
/** * 功能:调用发送短信接口 * @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; } }
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; } }
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; } }
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; } }
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'); }
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) {
/** * 调用开放系统指定接口的公用方法 * 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; } } }
/** * 提供给刊登那边的接口,根据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; } }
<?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;
/** * 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; }
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 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++; } }
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; }
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"); }
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'];
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!"; } } }
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 { //字符串中带_
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; }
/** * 调用开放系统指定接口的公用方法 * 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; } } }
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);
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; }
/** * 备货单料号复核完成后,将配货数量同步到采购系统备货单 * 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; }