コード例 #1
0
ファイル: warehouseAPI.model.php プロジェクト: ohjack/newErp
 public static function getInstance()
 {
     if (!self::$_instance instanceof self) {
         self::$_instance = new self();
     }
     return self::$_instance;
 }
コード例 #2
0
ファイル: warehouseAPI.action.php プロジェクト: ohjack/newErp
 function act_operateAbOrder($orderId, $calcWeight)
 {
     $res = WarehouseAPIModel::operateAbOrder($orderId, $calcWeight);
     //self::$errCode = WarehouseAPIModel::$errCode;
     //self::$errMsg = WarehouseAPIModel::$errMsg;
     return $res;
 }
コード例 #3
0
ファイル: cancelDeal.action.php プロジェクト: ohjack/newErp
 public function act_cancelDeal()
 {
     $orderid = isset($_GET['orderid']) ? intval($_GET['orderid']) : 0;
     $type = isset($_GET['type']) ? intval($_GET['type']) : 2;
     if ($orderid < 1) {
         // 传入订单号不正确
         self::$errCode = 300;
         self::$errMsg = '订单号类型不正确!';
         return FALSE;
     }
     //var_dump($orderid); exit;
     //$oi_obj = new OrderInfoModel ();
     $orderinfo = OrderInfoModel::getOrderInfo($orderid);
     //var_dump($orderinfo);
     if (!$orderinfo) {
         // 未找到订单
         self::$errCode = OrderInfoModel::$errCode;
         self::$errMsg = OrderInfoModel::$errMsg;
         return FALSE;
     }
     if (C('STATESHIPPED') == $orderinfo['orderStatus'] && C('STATEHASSHIPPED_CONV') == $orderinfo['orderType']) {
         //订单已发货不能取消交易
         self::$errCode = 304;
         self::$errMsg = '订单已完成不能取消交易!';
         return FALSE;
     } else {
         if (C('STATESHIPPED') == $orderinfo['orderStatus'] && C('STATESHIPPED_APPLYPRINT') != $orderinfo['orderType']) {
             /*$ro_obj = new RequestOpenApiModel();
             		
             		$parameter = array(
             			'method' => 'wh.discardShippingOrder',  //API名称
             			'format' => 'json',  //返回格式
             			'v' => '1.0',   //API版本号
             			'username'	 => 'valsun.cn',
             			'originOrderId'=>$orderid,
             			'storeId'=>1
             		);
             		
             		$sendresult = $ro_obj->sendRequest($parameter);
             		$sendresult = json_decode($sendresult, TRUE);*/
             //$orderids = array(0=>$orderid);
             $sendresult = WarehouseAPIModel::discardShippingOrder($orderid);
             //var_dump($sendresult);
             if (!$sendresult) {
                 //推送消息到仓库系统失败
                 self::$errCode = 305;
                 self::$errMsg = "发货单仓库废弃失败";
                 return FALSE;
             }
         }
     }
     $rtn = OrderInfoModel::cancelDeal($orderid, $type);
     self::$errCode = OrderInfoModel::$errCode;
     self::$errMsg = OrderInfoModel::$errMsg;
     return $rtn;
 }
コード例 #4
0
ファイル: skuInfo.view.php プロジェクト: ohjack/newErp
 public function view_skuInfo()
 {
     $sku = isset($_GET['sku']) ? trim($_GET['sku']) : "";
     //$spu = ExportsToXlsModel::getGoods($sku);
     $spu = GoodsModel::getSkuList($sku);
     $spu = $spu['spu'];
     $where = "where spu = '{$spu}'";
     $skuinfo = OmAvailableModel::getTNameList("pc_goods", "*", $where);
     $skuStock = array();
     foreach ($skuinfo as $key => $value) {
         $sku = $value['sku'];
         //获取库存
         $skuStock = WarehouseAPIModel::getSkuStock($sku);
         //获取料号信息
         //$skumsg = ExportsToXlsModel::getGoods($sku);
         $skumsg = GoodsModel::getSkuList($sku);
         //获取缓存表信息
         $where = "where sku='{$sku}'";
         $skuStatics = OmAvailableModel::getTNameList("om_sku_daily_status", "*", $where);
         $skuStockList = array();
         $skuStockList['nums'] = $skuStock;
         $skuStockList['sku'] = $skumsg['sku'];
         $skuStockList['spu'] = $skumsg['spu'];
         $skuStockList['goodsName'] = $skumsg['goodsName'];
         $skuStockList['goodsCost'] = $skumsg['goodsCost'];
         $skuStockList['goodsWeight'] = $skumsg['goodsWeight'];
         $skuStockList['AverageDailyCount'] = $skuStatics['AverageDailyCount'];
         $skuStockList['waitingSendCount'] = $skuStatics['waitingSendCount'];
         $skuStockList['xuniCount'] = $skuStatics['waitingSendCount'];
         $skuStockList['goodsStatus'] = $skumsg['goodsStatus'];
         $path = $skumsg['goodsCategory'];
         $cateName = GoodsModel::getCategoryInfoByPath($path);
         $skuStockList['cateName'] = $cateName['name'];
         $skuStockList['isNew'] = $skumsg['isNew'];
         $skuStockList['pmId'] = $skumsg['pmId'];
         $pmName = GoodsModel::getMaterInfoById($skumsg['pmId']);
         $skuStockList['pmName'] = $pmName['pmName'];
         //print_r($pmName);
         $pName = $skumsg['purchaseId'];
         $skuStockList['pName'] = UserModel::getUsernameById($pName);
         $skuStockList['isPacking'] = $skumsg['isPacking'];
         $skuStockList['whName'] = "深圳A仓";
         $skuStock_arr[] = $skuStockList;
     }
     $this->smarty->assign("skuStockList", $skuStock_arr);
     //print_r($skuStockList);
     $this->smarty->display("skuInfo.htm");
 }
コード例 #5
0
ファイル: excelExport.action.php プロジェクト: ohjack/newErp
 /**
  * 海外仓销售报表数据导出,未开发完成
  */
 public function act_ebayOversea()
 {
     $user = $_SESSION['userName'];
     $objPHPExcel = new PHPExcel();
     $sendreplacement = array('1' => '补寄全部', '2' => '补寄主体', '3' => '补寄配件');
     $ebay_splitorder_logs = array('0' => '拆分 订单', '1' => '复制 订单', '2' => '异常 订单', '3' => '合并 包裹', '4' => '邮局退回补寄', '5' => '自动部分包货拆分', '7' => '同步异常订单');
     $MAILWAYCONFIG = array(0 => 'EUB', 1 => '深圳', 2 => '福州', 3 => '三泰', 4 => '泉州', 5 => '义乌', 6 => '福建', 7 => '中外联', 8 => 'GM', 9 => '香港', 10 => '快递');
     $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '日期');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', 'ebay store');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '交易号');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '客户ID');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '仓位号');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '料号');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '数量');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '国家');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '产品价格');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', 'ebay运费');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '包裹总价值');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '币种');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1', '包装员');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1', '挂号条码');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1', '是/否');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1', '重量');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1', '邮费');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1', '运输方式');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('S1', '订单编号');
     /* 王民伟 2012-04-18*/
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('T1', '产品货本');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('U1', '交易ID');
     /*---end Tt Uu Vv Ww Xx*/
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('V1', 'ItemID');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('W1', '是否复制订单');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('X1', '是否补寄');
     //add by Herman.Xi 2012-09-13
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Y1', '是否拆分订单');
     //add by Herman.Xi 2012-09-14
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Z1', '包材');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AA1', '包材费用');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AB1', '是否组合料号');
     //add by Herman.Xi 2012-12-17
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AC1', '发货分区');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AD1', '是否邮局退回后补寄');
     //add by Herman.Xi 2013-03-09
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AE1', 'PayPal邮箱');
     //add by Herman.Xi 2013-03-09
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AF1', '采购');
     //add by chenwei 2013-09-07
     $start = strtotime($_REQUEST['start']);
     $end = strtotime($_REQUEST['end']);
     //echo $start."||".$end;exit;
     $account = $_REQUEST['account'];
     $tjstr = '';
     if ($account != '') {
         $account = explode("#", $account);
         for ($i = 0; $i < count($account); $i++) {
             $a0 = $account[$i];
             if ($a0 != '') {
                 $tjstr .= " a.accountId = '" . $a0 . "' or ";
             }
         }
     }
     $packinglists = GoodsModel::getMaterInfo();
     //需要调产品中心的接口才可以使用。
     $packings = array();
     foreach ($packinglists as $packinglist) {
         //$packings[$packinglist['id']] = $packinglist['pmCost'];
         $packings[$packinglist['pmAlias']] = $packinglist['pmCost'];
     }
     unset($packinglists);
     $tjstr = substr($tjstr, 0, strlen($tjstr) - 3);
     //$ret = OrderInfoModel::getShipOrderList($start,$end,$tjstr);
     $ret = WarehouseAPIModel::getAbOrderList();
     $a = 2;
     for ($i = 0; $i < count($shipData); $i++) {
         $ordersn = $ret[$i]['ebay_ordersn'];
         $paidtime = @date('Y-m-d', $ret[$i]['ebay_paidtime']);
         $ebay_usermail = $ret[$i]['ebay_usermail'];
         $ebay_userid = $ret[$i]['ebay_userid'];
         $name = @html_entity_decode($ret[$i]['ebay_username'], ENT_QUOTES, 'UTF-8');
         $street1 = @$ret[$i]['ebay_street'];
         $street2 = @$ret[$i]['ebay_street1'];
         $city = $ret[$i]['ebay_city'];
         $state = $ret[$i]['ebay_state'];
         $countryname = $ret[$i]['ebay_countryname'];
         //客服部小霞提出 导出列 国家 显示英文 方便退款处理
         //$cnname				= $country[$countryname];
         $cnname = $countryname;
         $zip = $ret[$i]['ebay_postcode'];
         $tel = $ret[$i]['ebay_phone'];
         $ebay_shipfee = $ret[$i]['ebay_shipfee'];
         $ebay_note = $ret[$i]['ebay_note'];
         $ebay_total = @round($ret[$i]['ebay_total'], 2);
         $ebay_tracknumber = @$ret[$i]['ebay_tracknumber'];
         $ebay_account = @$ret[$i]['ebay_account'];
         $recordnumber0 = @$ret[$i]['recordnumber'];
         $ebay_carrier = @$ret[$i]['ebay_carrier'];
         $ebay_phone = $ret[$i]['ebay_phone'];
         $ebay_currency = $ret[$i]['ebay_currency'];
         $packinguser = $ret[$i]['packagingstaff'];
         $ordershipfee = $ret[$i]['ordershipfee'];
         $ebay_id = $ret[$i]['ebay_id'];
         $ebay_ptid = $ret[$i]['ebay_ptid'];
         $ebay_pp = $ret[$i]['PayPalEmailAddress'];
         $ebay_noteb = $ret[$i]['ebay_noteb'];
         //=='复制 订单' ? $ret[$i]['ebay_noteb'] : ''
         $is_sendreplacement = $ret[$i]['is_sendreplacement'];
         $is_main_order = $ret[$i]['is_main_order'];
         $mailway = $ret[$i]['mailway'];
         $address = $street1 . "\n" . $street2 . "\n" . $city . "\n" . $state . "\n" . $zip . "\n" . $countryname;
         $scantime = date('Y-m-d', $sql[$i]['scantime']);
         //$calculate_weight			= $sql[$i]['orderweight'];   //计算重量
         $orderweight2 = number_format($sql[$i]['orderweight2'] / 1000, 3);
         //实际重量
         $totalweight = $orderweight2;
         $ordershipfee = round(calctrueshippingfee($ebay_carrier, $totalweight, $countryname, $ebay_id), 2);
         $ebay_noteb = $is_main_order == 2 ? '复制 订单' : ($is_main_order == 1 ? '被复制 订单' : '');
         $ebay_splitorder = judge_is_splitorder($ebay_id) == 1 ? '拆分 订单' : '';
         $ebay_combineorder = judge_contain_combinesku($ordersn) ? '组合 料号' : '';
         $splitorder_log = func_readlog_splitorder($ebay_id);
         $ebay_splitorder_log = '';
         if ($splitorder_log != false) {
             $ebay_splitorder_log = $ebay_splitorder_logs[$splitorder_log];
         }
         $is_sendreplacement = isset($sendreplacement[$is_sendreplacement]) ? $sendreplacement[$is_sendreplacement] : '';
         $sl = "select * from ebay_orderdetail where ebay_ordersn='{$ordersn}'";
         $sl = $dbcon->execute($sl);
         $sl = $dbcon->getResultArray($sl);
         if ($mailway === null) {
             $mailsql = "SELECT mailway FROM ebay_scan_mailway WHERE ebay_id={$sql[$i]['combine_package']}";
             $mailsql = $dbcon->execute($mailsql);
             $mailllist = $dbcon->getResultArray($mailsql);
             $mailway_c = !empty($mailllist[0]['mailway']) ? $MAILWAYCONFIG[$mailllist[0]['mailway']] . '合并包裹' : '';
         } else {
             $mailway_c = $MAILWAYCONFIG[$mailway];
         }
     }
 }
コード例 #6
0
ファイル: goods.model.php プロジェクト: ohjack/newErp
 public static function getSkuinfo($sku)
 {
     self::initDB();
     $sql = "SELECT * FROM  `pc_goods` WHERE sku = '{$sku}' and is_delete = 0 ";
     $query = self::$dbConn->query($sql);
     $goodsInfo = self::$dbConn->fetch_array($query);
     if (!$goodsInfo) {
         return false;
     }
     $goodsInfo['purchaseName'] = UserModel::getUsernameById($goodsInfo['purchaseId']);
     //echo $sku; echo "<br>";
     $autoStock = WarehouseAPIModel::getSkuStock($sku);
     if (!$autoStock) {
         $autoStock = 0;
     }
     $goodsInfo['enableCount'] = $autoStock;
     //var_dump($goodsInfo);
     return $goodsInfo;
 }
コード例 #7
0
ファイル: common.model.php プロジェクト: ohjack/newErp
 public static function get_sku_info($sku)
 {
     self::initDB();
     //$sql = "SELECT cguser FROM ebay_goods WHERE goods_sn='{$sku}'";
     /*$sql = "SELECT o.goods_count,g.cguser FROM ebay_goods AS g LEFT JOIN ebay_onhandle AS o ON o.goods_sn=g.goods_sn WHERE o.goods_sn='{$sku}'";
     		$sql		= self::$dbConn->query($sql);
     		$goodsinfo  = self::$dbConn->fetch_array_all($sql);
     		
     		if (empty($goodsinfo)||empty($goodsinfo[0]['cguser'])){
     			return array();
     		}*/
     $sql = "SELECT g.* FROM pc_goods AS g WHERE g.sku='{$sku}'";
     $sql = self::$dbConn->query($sql);
     $goodsinfo = self::$dbConn->fetch_array_all($sql);
     //var_dump($sku,$goodsinfo);
     if (empty($goodsinfo) || empty($goodsinfo[0]['purchaseId'])) {
         echo "\n该料号{$sku}没有添加采购人员!\n";
         return true;
     }
     //$goodsCountInfo = OldsystemModel::qccenterGetErpGoodscount($sku);
     $goodsCountInfo = WarehouseAPIModel::getSkuStock($sku);
     /*if (!$goodsCountInfo){
     			echo "\n该料号没有库存信息!\n";
     			return true;
     		}*/
     if (is_null($goodsCountInfo)) {
         echo "\n该料号{$sku}没有库存信息!\n";
         return true;
     }
     /*$sql = "SELECT * FROM om_sku_daily_status WHERE sku='{$sku}'";
     		$sql = self::$dbConn->query($sql);
     		$sku_info = self::$dbConn->fetch_array($sql);*/
     $purchaseinfo = !empty($sku_info) ? $sku_info : array();
     //$purchaseinfo['realnums'] = $goodsCountInfo['goods_count'];
     $purchaseinfo['realnums'] = $goodsCountInfo;
     return $purchaseinfo;
 }
コード例 #8
0
ファイル: productstatus.class.php プロジェクト: ohjack/newErp
 public function resetSkuStock($sku, $storeid = 1)
 {
     $dbcon = $this->dbcon;
     $number1 = WarehouseAPIModel::getSkuStock($sku, 1);
     $number2 = WarehouseAPIModel::getSkuStock($sku, 2);
     $number = $number1 + $number2;
     $waitingsend = $this->getWaitingSendCount($sku);
     $availableStockCount = $number - $waitingsend;
     // 虚拟库存
     //计算sku是否预警
     $skuInfo = $this->getSkuDaysInfo($sku);
     $goodsdays = $skuInfo["goodsdays"];
     // 预警天数
     $averageDailyCount = $this->getAverageDailyCount($sku);
     if ($averageDailyCount != 0) {
         $canUseDay = floor($availableStockCount / $averageDailyCount);
         if ($canUseDay <= $goodsdays) {
             $is_warning = 1;
         } else {
             $is_warning = 0;
         }
     } else {
         $is_warning = 0;
     }
     $bigOrder = $this->getInterceptSendCount($sku);
     $shortagesendCount = $this->getShortageSendCount($sku);
     //自动拦截数量
     $waitingauditCount = $this->getWaitingAuditCount($sku);
     //超大订单待审核数量
     $lastDaySaleCount = $this->lastDaySaleCount($sku);
     $lastDaySendCount = $this->lastDaySendCount($sku);
     $lastWeekSaleCount = $this->lastWeekSaleCount($sku);
     $lastWeekSendCount = $this->lastWeekSendCount($sku);
     $lastMouthSaleCount = $this->lastMouthSaleCount($sku);
     $lastMounthSendCount = $this->lastMouthSendCount($sku);
     $sql = "select count(*) as number from om_sku_daily_status where sku='{$sku}'";
     $sql = $dbcon->execute($sql);
     $dataInfo = $dbcon->fetch_one($sql);
     if ($dataInfo['number'] > 0) {
         $sql = "update om_sku_daily_status set \n\t\t\t\taverageDailyCount={$averageDailyCount},\n\t\t\t\tactualStockCount={$number},\n\t\t\t\twaitingSendCount={$waitingsend},\n\t\t\t\tavailableStockCount={$availableStockCount},\n\t\t\t\tlastDaySaleCount={$lastDaySaleCount},\n\t\t\t\tlastDaySendCount={$lastDaySendCount},\n\t\t\t\tlastWeekSaleCount={$lastWeekSendCount},\n\t\t\t\tlastWeekSendCount={$lastWeekSendCount},\n\t\t\t\tlastMouthSaleCount={$lastMouthSaleCount},\n\t\t\t\tlastMouthSendCount={$lastMounthSendCount},\n\t\t\t\tshortageSendCount={$shortagesendCount},\n\t\t\t\twaitingAuditCount={$waitingauditCount},\n\t\t\t\tinterceptSendCount={$bigOrder},\n\t\t\t\tis_warning={$is_warning}\n\t\t\t\tWHERE sku='{$sku}'";
     } else {
         $sql = "insert into om_sku_daily_status set \n\t\t\t\taverageDailyCount={$averageDailyCount},\n\t\t\t\tactualStockCount={$number},\n\t\t\t\twaitingSendCount={$waitingsend},\n\t\t\t\tavailableStockCount={$availableStockCount},\n\t\t\t\tlastDaySaleCount={$lastDaySaleCount},\n\t\t\t\tlastDaySendCount={$lastDaySendCount},\n\t\t\t\tlastWeekSaleCount={$lastWeekSendCount},\n\t\t\t\tlastWeekSendCount={$lastWeekSendCount},\n\t\t\t\tlastMouthSaleCount={$lastMouthSaleCount},\n\t\t\t\tlastMouthSendCount={$lastMounthSendCount},\n\t\t\t\tis_warning={$is_warning},\n\t\t\t\tshortageSendCount={$shortagesendCount},\n\t\t\t\twaitingAuditCount={$waitingauditCount},\n\t\t\t\tinterceptSendCount={$bigOrder},\n\t\t\t\tsku='{$sku}'";
     }
     if ($dbcon->execute($sql)) {
         $exchange = $this->exchange;
         //	$this->rmqObj->queue_publish($exchange,$sql); //发布消息
         echo "{$sql} 更新成功。。。\n";
     } else {
         echo $sql;
     }
 }
コード例 #9
0
ファイル: productstatus.class.php プロジェクト: ohjack/newErp
 public function resetSkuStock($sku, $storeid = 1)
 {
     $dbcon = $this->dbcon;
     $number = WarehouseAPIModel::getSkuStock($sku, $storeid);
     $waitingsend = $this->getWaitingSendCount($sku);
     $availableStockCount = $number - $waitingsend;
     // 虚拟库存
     //计算sku是否预警
     $skuInfo = $this->getSkuDaysInfo($sku);
     $goodsdays = $skuInfo["goodsdays"];
     // 预警天数
     $averageDailyCount = $this->getAverageDailyCount($sku);
     if ($averageDailyCount != 0) {
         $canUseDay = floor($availableStockCount / $averageDailyCount);
         if ($canUseDay <= $goodsdays) {
             $is_warning = 1;
         } else {
             $is_warning = 0;
         }
     } else {
         $is_warning = 0;
     }
     $bigOrder = $this->getInterceptSendCount($sku);
     $lastDaySaleCount = $this->lastDaySaleCount($sku);
     $lastDaySendCount = $this->lastDaySendCount($sku);
     $lastWeekSaleCount = $this->lastWeekSaleCount($sku);
     $lastWeekSendCount = $this->lastWeekSendCount($sku);
     $lastMouthSaleCount = $this->lastMouthSaleCount($sku);
     $lastMounthSendCount = $this->lastMouthSendCount($sku);
     $sql = "update om_sku_daily_status set \n\t\t\taverageDailyCount={$averageDailyCount},\n\t\t\tactualStockCount={$number},\n\t\t\twaitingSendCount={$waitingsend},\n\t\t\tavailableStockCount={$availableStockCount},\n\t\t\tlastDaySaleCount={$lastDaySaleCount},\n\t\t\tlastDaySendCount={$lastDaySendCount},\n\t\t\tlastWeekSaleCount={$lastWeekSendCount},\n\t\t\tlastWeekSendCount={$lastWeekSendCount},\n\t\t\tlastMouthSaleCount={$lastMouthSaleCount},\n\t\t\tlastMouthSendCount={$lastMounthSendCount},\n\t\t\tis_warning={$is_warning}\n\t\t   \tWHERE sku='{$sku}'";
     echo "{$sql}\n";
     if ($dbcon->execute($sql)) {
         $exchange = $this->exchange;
         $this->rmqObj->queue_publish($exchange, $sql);
         //发布消息
         echo "{$sku} 更新成功。。。\n";
     } else {
         echo $sql;
     }
 }
コード例 #10
0
 if ($sf['isuse'] == '1') {
     $enable = 0;
 }
 if ($enable == 0) {
     continue;
 }
 if ($sf['goods_location'] == "停售") {
     continue;
 }
 /*if(in_array($key,$__liquid_items_postbyhkpost)||in_array($key,$__liquid_items_cptohkpost)||in_array($key,$__liquid_items_BuiltinBattery)||in_array($key,$__liquid_items_Paste)){
 		continue;
 	}*/
 /*$ss = "SELECT goods_count FROM ebay_onhandle WHERE goods_sn='$key'";
 	$ss = $dbConn->query($ss);
 	$ss = $dbConn->fetch_array($ss);*/
 $goods_count = WarehouseAPIModel::getSkuStock($key);
 $salensend = CommonModel::getpartsaleandnosendall($key);
 $useable_stock = $goods_count - $salensend;
 if ($useable_stock > 0) {
     $now_status = '1';
 } else {
     $now_status = '0';
 }
 $sql = "SELECT * FROM om_adjust_sku WHERE sku='{$key}' and type=1 order by createdtime desc";
 $sql = $dbConn->query($sql);
 $sql = $dbConn->fetch_array($sql);
 if ($sql) {
     if ($now_status == $sql['adjustvalue']) {
         continue;
     }
 } else {