public function view_addOrder() { $OmAccountAct = new OmAccountAct(); $state = isset($_GET['state']) ? post_check($_GET['state']) : ''; $this->smarty->assign('state', $state); //平台 //$platform_lsit = OmAvailableModel::getTNameList("om_platform","*","where is_delete=0"); $platform_lsit = $OmAccountAct->act_getPlatformListByPower(); $tmpPlatformList = array(); foreach ($platform_lsit as $value) { if (in_array($value['id'], array(3))) { $tmpPlatformList[] = $value; } } $platform_lsit = $tmpPlatformList; $this->smarty->assign('platform_lsit', $platform_lsit); //账号 //$account_lsit = OmAvailableModel::getTNameList("om_account","*","where is_delete=0 and platformId=3"); $account_lsit = $OmAccountAct->act_getAccountListByPlatform(); $account_lsit = array(); $this->smarty->assign('account_lsit', $account_lsit); //物流 $Shiping = CommonModel::getCarrierList(); $this->smarty->assign('Shiping', $Shiping); $toplevel = 2; //一级菜单的序号 $this->smarty->assign('toplevel', $toplevel); $secondlevel = 21; //当前的二级菜单 $this->smarty->assign('secondlevel', $secondlevel); $this->smarty->assign('toptitle', '订单添加'); $this->smarty->assign('curusername', $_SESSION['userName']); $this->smarty->display('orderAdd.htm'); }
public function view_index() { $toptitle = '报表导出页面'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 5); $OmAccountAct = new OmAccountAct(); $reportAct = new ExcelExportAct(); $ebayAccountList = $OmAccountAct->act_getEbayAccountList(); $b2bAccountList = $OmAccountAct->act_getB2BAccountList(); $neweggAccountList = $OmAccountAct->act_getNeweggAccountList(); $ebayAccountList = $OmAccountAct->act_ebayaccountAllList(); $amazonAccountList = $OmAccountAct->act_amazonaccountAllList(); $dresslinkAccountList = $OmAccountAct->act_dresslinkaccountAllList(); $aliexpressAccountList = $OmAccountAct->act_getAccountListByPid(2); $innerAccountList = $OmAccountAct->act_getINNERAccountList(); $aliexpressAccountList = json_decode($aliexpressAccountList, true); $transAPI = new TransAPIAct(); $transType = $transAPI->act_getChannelistByApi(); //var_dump($aliexpressAccountList); $allAccountList = $OmAccountAct->act_getAllAccountList(); $priceInfoUrl = $reportAct->act_priceInfoReport(); $this->smarty->assign("ebayAccountList", $ebayAccountList); $this->smarty->assign("b2bAccountList", $b2bAccountList); $this->smarty->assign("neweggAccountList", $neweggAccountList); $this->smarty->assign("innerAccountList", $innerAccountList); $this->smarty->assign("dresslinkAccountList", $dresslinkAccountList); $this->smarty->assign("aliexpressAccountList", $aliexpressAccountList); $this->smarty->assign("allAccountList", $allAccountList); $this->smarty->assign("amazonAccountList", $amazonAccountList); $this->smarty->assign("transType", $transType); $this->smarty->assign("priceInfoUrl", $priceInfoUrl); $startTime = date('Y-m-d ') . ' 00:00:00'; $endTime = date('Y-m-d ') . ' 23:59:59'; $chkTime = date('Y-m-d '); $this->smarty->assign("curStartTime", $startTime); $this->smarty->assign("curEndTime", $endTime); $this->smarty->assign("chkTime", $chkTime); //单个时间 $this->smarty->display("exportXls.htm"); }
public function view_abnormalStockList() { global $memc_obj; $pagesize = 200; //页面大小 //var_dump($AbOrderList); exit; $omAvailableAct = new OmAvailableAct(); $TransAPIAct = new TransAPIAct(); $OrderindexAct = new OrderindexAct(); $GoodsAct = new GoodsAct(); $OrderRefundAct = new OrderRefundAct(); //平台信息 $OmAccountAct = new OmAccountAct(); $WarehouseAPIAct = new WarehouseAPIAct(); $AbOrderList = $WarehouseAPIAct->act_getAbOrderList(); //var_dump($AbOrderList); exit; $AbOrderListArr = array(); $AbOrderids = array(); $AbOrderShow = array(); foreach ($AbOrderList as $orderId) { $AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']); $AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo; $AbOrderids[] = $orderId['originOrderId']; $AbOrderShow[$orderId['originOrderId']] = $orderId['id']; } //var_dump($AbOrderListArr); exit; $this->smarty->assign('AbOrderListArr', $AbOrderListArr); $this->smarty->assign('AbOrderShow', $AbOrderShow); //var_dump($AbOrderListArr); exit; $platform = $OmAccountAct->act_getPlatformListByPower(); $this->smarty->assign('platform', $platform); $account = $OmAccountAct->act_accountAllListById(); //账号信息 /**导航 start**/ $ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : 0; $this->smarty->assign('ostatus', 770); $StatusMenuAct = new StatusMenuAct(); $ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0'); //var_dump($ostatusList); $this->smarty->assign('ostatusList', $ostatusList); //二级目录 /*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc'); $this->smarty->assign('o_secondlevel', $o_secondlevel);*/ $second_count = array(); $second_type = array(); foreach ($ostatusList as $o_secondinfo) { $orderStatus = $o_secondinfo['statusCode']; //echo $orderStatus."============"; echo "<br>"; $s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus); //echo $orderStatus."==".$s_total; echo "<br>"; $second_count[$o_secondinfo['statusCode']] = $s_total; $s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc'); $second_type[$orderStatus] = $s_type[0]['statusCode']; } $this->smarty->assign('second_count', $second_count); $this->smarty->assign('second_type', $second_type); //退款数量 $where = " WHERE is_delete=0 "; $accountList = $_SESSION['accountList']; $platformList = $_SESSION['platformList']; //echo "<pre>"; print_r($accountList); exit; $platformsee = array(); for ($i = 0; $i < count($platformList); $i++) { $platformsee[] = $platformList[$i]; } if ($platformsee) { $where .= ' AND platformId IN (' . join(",", $platformsee) . ') '; } else { //$where .= " AND 1=2 "; } $accountsee = array(); for ($i = 0; $i < count($accountList); $i++) { $accountsee[] = $accountList[$i]; } if ($accountsee) { $where .= ' AND accountId IN (' . join(",", $accountsee) . ') '; } else { //$where .= " AND 1=2 "; } //if($where){ //$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 "); $refund_total = $OrderRefundAct->act_getRecordNums(); //}else{ //$refund_total = 0; //} $this->smarty->assign('refund_total', $refund_total); //三级目录 /*$refund_one = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=0"); $this->smarty->assign('refund_one', $refund_one); $refund_two = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=1"); $this->smarty->assign('refund_two', $refund_two); $refund_three = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=2"); $this->smarty->assign('refund_three', $refund_three);*/ /**导航 end**/ $toptitle = '异常缺货统计页面'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 0); $threelevel = '1'; //当前的三级菜单 $this->smarty->assign('threelevel', $threelevel); $statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0'); $this->smarty->assign('statusMenu', $statusMenu); /* $where = ' WHERE is_delete = 0 '.$where; $total = $omAvailableAct->act_getTNameCount('om_order_refund', $where);*/ $parameterArr = array(); $parameterArr['AbOrderList'] = $AbOrderids; $total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr); $this->smarty->assign('abnormal_total', $total); //echo $total; exit; $num = $pagesize; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); //$limit = $page->limit; //var_dump($parameterArr); $omOrderList = $OrderindexAct->act_showABOrder($ostatus, $otype, $page->limit, $parameterArr); $this->smarty->assign('omOrderList', $omOrderList); $pm = $GoodsAct->act_getMaterInfoByList(); $transportationList = $TransAPIAct->act_getCarrierListById(); $this->smarty->assign('transportationList', $transportationList); 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)); } //获取系统所有状态 //$statusList = copyOrderModel::selectStatusList(); //var_dump($statusList); exit; //$this->smarty->assign('statusList', $statusList); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('account', $account); //$this->smarty->assign('sku', $sku); $this->smarty->assign('pm', $pm); $this->smarty->assign('omOrderList', $omOrderList); $this->smarty->display('orderindex.htm'); }
public function view_showUserCompense() { $OmAccountAct = new OmAccountAct(); $StatusMenuAct = new StatusMenuAct(); $uid = $_GET['uid']; //var_dump($_POST); exit; $showinfo = ''; if (isset($_POST['action']) && !empty($_POST['action'])) { if ($OmAccountAct->act_addUserCompense($_POST)) { $showinfo = "<font color='green'>添加权限成功!</font>"; } else { $showinfo = "<font color='red'>添加权限失败!</font>"; } $uid = $_POST['uid']; } if (empty($uid)) { header("location:index.php?mod=user&act=index"); exit; } $this->smarty->assign('uid', $uid); $this->smarty->assign('showinfo', $showinfo); $UserCompenseList = $OmAccountAct->act_getUserCompenseList($uid); //echo "<pre>"; //print_r($UserCompenseList); exit; //$visible_platform = array(); //$visible_account = array(); //echo "<pre>"; //var_dump($UserCompenseList); //$visible_platform = $UserCompenseList['visible_platform']; //$visible_account = $UserCompenseList['visible_account']; $visible_movefolder = json_decode($UserCompenseList['visible_movefolder'], true); //$visible_showfolder = $UserCompenseList['visible_showfolder']; //$visible_editorder = $UserCompenseList['visible_editorder']; $visible_platform_account = json_decode($UserCompenseList['visible_platform_account'], true); //var_dump($visible_platform_account); exit; /*if(empty($visible_movefolder)){ echo "============="; }*/ $key_visible_movefolder = array(); if (is_array($visible_movefolder)) { $key_visible_movefolder = array_keys($visible_movefolder); } $StatusMenu = $StatusMenuAct->act_getStatusMenuListById('*', ' WHERE groupId != 0 '); //var_dump($StatusMenu); $statusGroupLists = $StatusMenuAct->act_getMenuGroupList(); //echo "<pre>"; print_r($statusGroupLists); exit; //$all_platform = $UserCompenseList['all_platform']; //var_dump($all_platform); //$all_account = $UserCompenseList['all_account']; //$all_account = $UserCompenseList['all_account']; $arr_all_platform_account = $UserCompenseList['arr_all_platform_account']; $editorder_options = array(1 => '平台', '账号', '买家ID', '订单号', '下单时间', '付款时间', '产品总金额', '物流费用', '订单金额', 'Transaction ID', '币种', '估算重量', '买家选择发货物流', '跟踪号', 'Full name', 'Street1', 'Street2', 'City', 'State', 'Country ', 'Postcode', 'Tel1', 'Tel2', 'Tel3', '买家邮箱1', '买家邮箱2', '买家邮箱3', '订单备注'); $this->smarty->assign('editorder_options', $editorder_options); //$this->smarty->assign('visible_platform', $visible_platform); //$this->smarty->assign('visible_account', $visible_account); $this->smarty->assign('visible_platform_account', $visible_platform_account); $this->smarty->assign('arr_all_platform_account', $arr_all_platform_account); $this->smarty->assign('key_visible_movefolder', $key_visible_movefolder); $this->smarty->assign('visible_showfolder', $visible_showfolder); $this->smarty->assign('visible_editorder', $visible_editorder); //$this->smarty->assign('all_platform', $all_platform); //$this->smarty->assign('all_account', $all_account); $this->smarty->assign('StatusMenu', $StatusMenu); $this->smarty->assign('statusGroupLists', $statusGroupLists); $this->smarty->assign('toptitle', '订单系统细颗粒度权限控制'); $this->smarty->assign('toplevel', 3); $this->smarty->assign('secondlevel', '32'); $this->smarty->display("showUserCompense.htm"); }
function act_getAllInStatusIds() { //global $memc_obj; //调用memcache获取sku信息 //$statusId = isset($_POST['statusId']) ? $_POST['statusId'] : $statusId; $addUser = $_SESSION['sysUserId']; $OmAccountAct = new OmAccountAct(); $UserCompenseList = $OmAccountAct->act_getUserCompenseList($addUser); //echo "<pre>"; //var_dump($UserCompenseList); //$visible_platform = $UserCompenseList['visible_platform']; //$visible_account = $UserCompenseList['visible_account']; $visible_movefolder = json_decode($UserCompenseList['visible_movefolder'], true); if (!empty($visible_movefolder)) { return $visible_movefolder; } else { return array(); } }
public function view_guoneiSaleImport() { //var_dump($_POST);//exit; include_once WEB_PATH . "lib/PHPExcel.php"; //phpexcel include_once WEB_PATH . "conf/scripts/script.ebay.config.php"; //global $SYSTEM_ACCOUNTS,$__liquid_items_fenmocsku,$__liquid_items_BuiltinBattery,$__liquid_items_SuperSpecific,$__liquid_items_Paste; $toptitle = '速卖通线下订单导入'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 2); $this->smarty->assign('secondlevel', 220); $OmAccountAct = new OmAccountAct(); $aliexpressAccountList = $OmAccountAct->act_getINNERAccountList(); $this->smarty->assign("aliexpressAccountList", $aliexpressAccountList); if (isset($_FILES['aliexpressFile']['tmp_name'])) { $filePath = $_FILES['aliexpressFile']['tmp_name']; $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { echo 'no Excel'; return; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); //$excellists = excel2array($PHPExcel, $filePath, 0, 0); //print_r($excellists);print_r($_SESSION); $orderid = array(); $orderData = array(); //$orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order","where da.id=14448"); //echo "<pre>";print_r($orderarr); $account = $_POST['aliexpressAccount']; $transportation = CommonModel::getCarrierList(); //所有的 $c = 2; while (true) { $aa = 'A' . $c; $bb = 'B' . $c; $cc = 'C' . $c; $dd = 'D' . $c; $ee = 'E' . $c; $ff = 'F' . $c; $gg = 'G' . $c; $hh = 'H' . $c; $ii = 'I' . $c; $jj = 'J' . $c; $kk = 'K' . $c; $ll = 'L' . $c; $mm = 'M' . $c; $nn = 'N' . $c; $oo = 'O' . $c; $pp = 'P' . $c; $qq = 'Q' . $c; $rr = 'R' . $c; $ss = 'S' . $c; $tt = 'T' . $c; $uu = 'U' . $c; $vv = 'V' . $c; $ww = 'W' . $c; $xx = 'X' . $c; $yy = 'Y' . $c; $zz = 'Z' . $c; $c++; $recordNumber = trim($currentSheet->getCell($aa)->getValue()); $userId = trim($currentSheet->getCell($bb)->getValue()); $skuStr = trim($currentSheet->getCell($cc)->getValue()); $amount = trim($currentSheet->getCell($dd)->getValue()); $countryName = trim($currentSheet->getCell($ee)->getValue()); $actualTotal = trim($currentSheet->getCell($ff)->getValue()); $currency = trim($currentSheet->getCell($gg)->getValue()); $street1 = trim($currentSheet->getCell($hh)->getValue()); $street2 = trim($currentSheet->getCell($ii)->getValue()); $carrierNameCn = trim($currentSheet->getCell($jj)->getValue()); $city = trim($currentSheet->getCell($kk)->getValue()); $state = trim($currentSheet->getCell($ll)->getValue()); $zipCode = trim($currentSheet->getCell($mm)->getValue()); $phone = trim($currentSheet->getCell($nn)->getValue()); $trackNumber = trim($currentSheet->getCell($oo)->getValue()); $noteStr = trim($currentSheet->getCell($pp)->getValue()); $ordersTime = time(); $paymentTime = time(); $email = ''; $onlineTotal = ''; $shippingFee = ''; $transId = ''; $note = ''; $username = $userId; $platformUsername = $userId; $PayPalPaymentId = $transId; if (empty($recordNumber)) { break; } $skuArrlist = explode(',', $skuStr); $noteArr = explode(',', $noteStr); $skuCount = count($skuArrlist); for ($i = 0; $i < $skuCount; $i++) { list($sku, $amount) = explode('*', $skuArrlist[$i]); //echo "--sku=$sku---amount=$amount-------"; //detail信息 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time(); $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $noteArr[$i]; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId; if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } //order信息 $orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderData']['ordersTime'] = $ordersTime; $orderData[$recordNumber]['orderData']['paymentTime'] = $paymentTime; $orderData[$recordNumber]['orderData']['onlineTotal'] = $onlineTotal; $orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal; $orderData[$recordNumber]['orderData']['actualShipping'] = $shippingFee; $orderData[$recordNumber]['orderData']['calcShipping'] = $shippingFee; $orderData[$recordNumber]['orderData']['orderAddTime'] = time(); $orderData[$recordNumber]['orderData']['orderStatus'] = 100; $orderData[$recordNumber]['orderData']['orderType'] = 101; $SYS_ACCOUNTS = OmAvailableModel::getTNameList("om_account", "*", " where account='{$account}'"); $orderData[$recordNumber]['orderData']['accountId'] = $SYS_ACCOUNTS[0]['id']; $orderData[$recordNumber]['orderData']['platformId'] = $SYS_ACCOUNTS[0]['platformId']; $plataccountId = $SYS_ACCOUNTS[0]['id']; $platformId = $SYS_ACCOUNTS[0]['platformId']; $SYS_ACCOUNTS = OmAvailableModel::getPlatformAccount(); foreach ($SYS_ACCOUNTS as $platform => $accounts) { foreach ($accounts as $accountId => $accountname) { if ($account == $accountname) { if ($platform == "ebay") { $orderData[$recordNumber]['orderData']['isFixed'] = 2; } else { $orderData[$recordNumber]['orderData']['isFixed'] = 1; } } } } foreach ($transportation as $tranValue) { if ($tranValue['carrierNameCn'] == $carrierNameCn) { $orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id']; break; } } if ($trackNumber != '') { $orderData[$recordNumber]['orderTrack']['tracknumber'] = $trackNumber; $orderData[$recordNumber]['orderTrack']['addUser'] = $_SESSION['sysUserId']; $orderData[$recordNumber]['orderTrack']['createdTime'] = time(); } //order扩展信息 $orderData[$recordNumber]['orderExtenData']['currency'] = $currency; $orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS"; $orderData[$recordNumber]['orderExtenData']['transId'] = $recordNumber; // 交易id;; $orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId; $orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername; $orderData[$recordNumber]['orderExtenData']['currency'] = $currency; //user信息 $orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername; $orderData[$recordNumber]['orderUserInfoData']['username'] = $username; $orderData[$recordNumber]['orderUserInfoData']['email'] = $email; $orderData[$recordNumber]['orderUserInfoData']['street'] = $street1; $orderData[$recordNumber]['orderUserInfoData']['address2'] = ${$street2}; $orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency; //$orderData[$recordNumber]['orderUserInfoData']['address3'] = $address3; $orderData[$recordNumber]['orderUserInfoData']['city'] = $city; $orderData[$recordNumber]['orderUserInfoData']['state'] = $state; $orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode; $orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName; $orderData[$recordNumber]['orderUserInfoData']['landline'] = $phone; $orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone; //note信息 if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } //print_r($orderData); //echo "<pre>";print_r($orderData);//exit; $message = ""; foreach ($orderData as $id => $order) { //echo $id; //$msg = commonModel::checkOrder($id); $msg = commonModel::checkRecordNumber($id, $platformId, $plataccountId); if ($msg) { $message .= "<font color='red'>订单{$id}已存在!</font><br>"; continue; } //计算订单属性 if (count($order['orderDetail']) == 1) { $detail = current($order['orderDetail']); if ($detail['orderDetailData']['amount'] == 1) { $orderData[id]['orderData']['orderAttribute'] = 1; } else { $orderData[id]['orderData']['orderAttribute'] = 2; } } else { $orderData[id]['orderData']['orderAttribute'] = 3; } //计算订单重量及包材 $obj_order_detail_data = array(); foreach ($order['orderDetail'] as $sku => $detail) { $obj_order_detail_data[] = $detail['orderDetailData']; } $weightfee = commonModel::calcOrderWeight($obj_order_detail_data); $orderData[$id]['orderData']['calcWeight'] = $weightfee[0]; //$orderData[$value[0]]['orderData']['calcShipping'] = $weightfee[3]; $orderData[$id]['orderData']['pmId'] = $weightfee[1]; //计算运费 $calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, $orderData[$id]['orderData']['isFixed']); //计算运费 $orderData[$id]['orderData']['channelId'] = $calcShippingInfo['fee']['channelId']; //$orderData[$id]['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee']; //缺货拦截 $orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]); /*$orderData[$id]['orderData']['orderStatus'] = $status['orderStatus']; $orderData[$id]['orderData']['orderType'] = $status['orderType'];*/ //echo "<pre>";print_r($orderData[$id]); //print_r($orderData); //exit; //插入订单 $info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]); if ($info) { $message .= "<font color='green'>订单{$id}上传成功!</font><br>"; } else { $message .= "<font color='red'>订单{$id}上传失败!</font><br>"; } } $this->smarty->assign("showerrorinfo", $message); //header("location:index.php?mod=underLineOrderImport&act=importOrder"); } $this->smarty->display('guoneiSaleImport.htm'); }
public function act_showOrder($ostatus, $otype, $limit = '', $parameterArr = '', $storeId = 1) { $where = ' WHERE da.is_delete = 0 AND da.storeId = ' . $storeId; $UserCompetenceAct = new UserCompetenceAct(); $accountList = $UserCompetenceAct->act_showGlobalUser(); if (!$accountList) { if ($limit != '') { return array(); } else { return 0; } } $StatusMenuAct = new StatusMenuAct(); $tableName = $StatusMenuAct->act_getOrderNameByStatus($ostatus, $otype); //$tableName = "om_unshipped_order"; $searchKeywordsType = isset($parameterArr['searchKeywordsType']) ? $parameterArr['searchKeywordsType'] : ''; $searchKeywords = isset($parameterArr['searchKeywords']) ? $parameterArr['searchKeywords'] : ''; $AbOrderList = isset($parameterArr['AbOrderList']) ? $parameterArr['AbOrderList'] : ''; if (!$AbOrderList) { if ($ostatus != '') { $where .= ' AND da.orderStatus = ' . $ostatus; } if ($otype != '') { $where .= ' AND da.orderType = ' . $otype; } } if (is_array($AbOrderList)) { $where .= ' AND da.id in ("' . join('","', $AbOrderList) . '") AND orderStatus != ' . C('STATEOUTOFSTOCK') . ' AND orderType != ' . C('STATEOUTOFSTOCK_ABNORMAL'); } else { if ($AbOrderList != '') { $where .= ' AND da.id="' . $AbOrderList . '" AND orderStatus != ' . C('STATEOUTOFSTOCK') . ' AND orderType != ' . C('STATEOUTOFSTOCK_ABNORMAL'); } } if (!empty($parameterArr) && $searchKeywordsType != '') { $searchPlatformId = $parameterArr['searchPlatformId']; /*if($searchKeywordsType == 4 && empty($searchPlatformId)){ self::$errCode = '0001'; self::$errMsg = '扩展信息请先选择平台!'; if($limit != ''){ return array(); }else{ return 0; } }*/ $OmAccountAct = new OmAccountAct(); $platfrom = $OmAccountAct->act_getPlatformSuffixById($searchPlatformId); $extension = $platfrom['suffix']; //获取后缀名称 $searchTable = ''; if ($searchKeywords) { switch ($searchKeywordsType) { case 1: $_where = ' AND platformUsername="******"'; $searchTable = $tableName . '_userInfo'; break; case 2: $_where = ' AND email="' . $searchKeywords . '"'; $searchTable = $tableName . '_userInfo'; break; case 3: $where .= ' AND da.recordNumber="' . $searchKeywords . '"'; break; case 4: $_where = ' AND PayPalPaymentId="' . $searchKeywords . '"'; $searchTable = $tableName . '_extension_' . $extension; break; case 5: $_where = ' AND tracknumber="' . $searchKeywords . '"'; $searchTable = 'om_order_tracknumber'; break; case 6: $where .= ' AND da.id="' . $searchKeywords . '"'; break; } } if ($searchTable != '') { //echo $searchTable; echo "<br>"; //echo $_where; echo "<br>"; $searchTableList = OmAvailableModel::getTNameList($searchTable, ' * ', ' WHERE 1 ' . $_where); //var_dump($searchTableList); //$where = ''; if (empty($searchTableList)) { self::$errCode = '0002'; self::$errMsg = '无法获取扩展信息!'; if ($limit != '') { return array(); } else { return 0; } } //var_dump("--------------"); $arrayId = ''; foreach ($searchTableList as $key => $tableValue) { if ($arrayId == '') { $arrayId .= '(' . $tableValue['omOrderId']; } else { $arrayId .= ',' . $tableValue['omOrderId']; } } $arrayId .= ')'; $where .= ' AND da.id in ' . $arrayId; } //order表 if ($searchPlatformId != '') { $where .= ' AND da.platformId = "' . $searchPlatformId . '" '; if ($parameterArr['searchAccountId'] != '') { $where .= ' AND da.accountId = "' . $parameterArr['searchAccountId'] . '" '; } } if ($parameterArr['searchIsNote'] != '') { switch ($parameterArr['searchIsNote']) { case 1: $where .= ' AND da.isNote = "1" '; break; case 2: $where .= ' AND da.isNote = "0" '; break; default: break; } } if ($parameterArr['searchTransportation'] != '') { $where .= ' AND da.transportId = ' . $parameterArr['searchTransportation']; } else { if ($parameterArr['searchTransportationType'] != '') { if ($parameterArr['searchTransportationType'] == 1) { //快递 $kdCarrierIDList = CommonModel::getCarrierExp(); //echo "<pre>"; print_r($kdCarrierIDList); echo "<br>"; $where .= ' AND da.transportId in (' . join(',', $kdCarrierIDList) . ')'; } else { if ($parameterArr['searchTransportationType'] == 2) { //平邮 $xbCarrierIDList = CommonModel::getCarrierNoExp(); $where .= ' AND da.transportId in (' . join(',', $xbCarrierIDList) . ')'; } } } } //echo $where; echo "<br>"; if ($parameterArr['searchIsBuji'] != '') { switch ($parameterArr['searchIsBuji']) { case 1: $where .= ' AND da.isBuji = 2 '; break; case 2: $where .= ' AND da.isBuji != 2 '; break; default: break; } } /*if($parameterArr['searchIsTracknumber'] != ''){ switch($parameterArr['searchIsTracknumber']){ case 1: $where .= ' AND da.isBuji = 2 '; break; case 2: $where .= ' AND da.isBuji != 2 '; break; default: break; } }*/ if ($parameterArr['searchIsLock'] != '') { switch ($parameterArr['searchIsLock']) { case 2: $where .= ' AND da.isLock = 0 '; break; case 1: $where .= ' AND da.isLock = 1 '; break; default: break; } } $id_arr = array(); if ($parameterArr['searchTimeType'] == 1) { if ($parameterArr['searchOrderTime1'] != '' && $parameterArr['searchOrderTime2'] != '') { $where .= ' AND da.paymentTime >= "' . strtotime($parameterArr['searchOrderTime1']) . '" AND da.paymentTime <= "' . strtotime($parameterArr['searchOrderTime2']) . '" '; } } elseif ($parameterArr['searchTimeType'] == 2) { if ($parameterArr['searchOrderTime1'] != '' && $parameterArr['searchOrderTime2'] != '') { $warehouse_where = "where weighTime between " . strtotime($parameterArr['searchOrderTime1']) . " AND " . strtotime($parameterArr['searchOrderTime2']); $warehouse = OmAvailableModel::getTNameList($tableName . "_warehouse", "omOrderId", $warehouse_where); if ($warehouse) { foreach ($warehouse as $key => $value) { $id_arr[] = $value['omOrderId']; } //$where .= ' AND da.id in('.$id_str.') '; } } } elseif ($parameterArr['searchTimeType'] == 3) { //add by zqt ,同步时间搜索 if ($parameterArr['searchOrderTime1'] != '' && $parameterArr['searchOrderTime2'] != '') { $where .= ' AND da.orderAddTime >= "' . strtotime($parameterArr['searchOrderTime1']) . '" AND da.orderAddTime <= "' . strtotime($parameterArr['searchOrderTime2']) . '" '; } } /*if($otype != ''){ $where .= ' AND da.orderType = '.$otype; }*/ //order_detail表 if ($parameterArr['searchReviews'] != '') { switch ($parameterArr['searchReviews']) { case 1: $where .= ' AND db.reviews is NULL '; break; case 2: $where .= ' AND db.reviews = "1" '; break; case 3: $where .= ' AND db.reviews = "2" '; break; case 4: $where .= ' AND db.reviews = "3" '; break; default: break; } } //order_userInfo表 $userInfo_where = "where 1=1"; if ($parameterArr['countryName'] != '') { $userInfo_where .= ' AND countryName = "' . $parameterArr['countryName'] . '" '; } if ($parameterArr['state'] != '') { $userInfo_where .= ' AND state = "' . $parameterArr['state'] . '" '; } if ($parameterArr['city'] != '') { $userInfo_where .= ' AND city = "' . $parameterArr['city'] . '" '; } if ($parameterArr['zipCode'] != '') { $userInfo_where .= ' AND zipCode = "' . $parameterArr['zipCode'] . '" '; } if ($userInfo_where != "where 1=1") { $userInfo = OmAvailableModel::getTNameList($tableName . "_userInfo", "omOrderId", $userInfo_where); } if ($userInfo) { //$id_arr = array(); foreach ($userInfo as $key => $value) { $id_arr[] = $value['omOrderId']; } } if ($id_arr) { $where .= ' AND da.id in(' . implode(",", $id_arr) . ') '; } if ($parameterArr['searchSku'] != '') { $where .= ' AND db.sku = "' . $parameterArr['searchSku'] . '" '; } /*if($searchOmOrderId != ''){ $where .= ' AND db.recordNumber = "'.$searchOmOrderId.'" '; }*/ if ($parameterArr['searchOrderType'] != '') { switch ($parameterArr['searchOrderType']) { case 1: $where .= ' AND da.orderAttribute =1 '; break; case 2: $where .= ' AND da.orderAttribute =2 '; break; case 3: $where .= ' AND da.orderAttribute =3 '; break; } } } //echo $where; if ($limit != '') { $extenwhere = ' GROUP BY da.id ORDER BY da.paymentTime ' . $limit; //$extenwhere = ' ORDER BY da.paymentTime '.$limit; $data = OrderindexModel::showSearchOrderList($tableName, $where, $extenwhere); if (empty($data) && empty($ostatus) && empty($otype)) { $data = $this->act_showOrder(900, 21, $limit, $parameterArr, $storeId); } } else { //$extenwhere = ' GROUP BY da.id ORDER BY da.paymentTime '; $extenwhere = ' ORDER BY da.paymentTime '; $data = OrderindexModel::showSearchOrderNum($tableName, $where, $extenwhere); if (empty($data) && empty($ostatus) && empty($otype)) { $data = $this->act_showOrder(900, 21, $limit, $parameterArr, $storeId); } } //var_dump($data); self::$errCode = OrderindexModel::$errCode; self::$errMsg = OrderindexModel::$errMsg; return $data; }
public function view_aliexpressimport() { $this->smarty->assign('toplevel', 2); $this->smarty->assign('secondlevel', 24); $OmAccountAct = new OmAccountAct(); //$aliexpressAccountList = $OmAccountAct->act_getAccountListByPid(2); $aliexpressAccountList = $OmAccountAct->act_getAccountListAliexpress(); var_dump($aliexpressAccountList); $aliexpressAccountList = json_decode($aliexpressAccountList, true); $this->smarty->assign("aliexpressAccountList", $aliexpressAccountList); $this->smarty->display('aliexpressImport.htm'); include_once WEB_PATH . "lib/PHPExcel.php"; //phpexcel $toptitle = 'underLineOrderImport'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 2); $this->smarty->assign('secondlevel', 22); if (isset($_FILES['orderUpfile']['tmp_name'])) { $filePath = $_FILES['orderUpfile']['tmp_name']; $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { echo 'no Excel'; return; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); //$excellists = excel2array($PHPExcel, $filePath, 0, 0); //print_r($excellists);print_r($_SESSION); $orderid = array(); $orderData = array(); //$orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order","where da.id=14448"); //echo "<pre>";print_r($orderarr); $c = 2; while (true) { $aa = 'A' . $c; $bb = 'B' . $c; $cc = 'C' . $c; $dd = 'D' . $c; $ee = 'E' . $c; $ff = 'F' . $c; $gg = 'G' . $c; $hh = 'H' . $c; $ii = 'I' . $c; $jj = 'J' . $c; $kk = 'K' . $c; $ll = 'L' . $c; $mm = 'M' . $c; $nn = 'N' . $c; $oo = 'O' . $c; $pp = 'P' . $c; $qq = 'Q' . $c; $rr = 'R' . $c; $ss = 'S' . $c; $tt = 'T' . $c; $uu = 'U' . $c; $vv = 'V' . $c; $ww = 'W' . $c; $xx = 'X' . $c; $yy = 'Y' . $c; $zz = 'Z' . $c; $c++; $account = trim($currentSheet->getCell($aa)->getValue()); $recordNumber = trim($currentSheet->getCell($bb)->getValue()); $platformUsername = trim($currentSheet->getCell($cc)->getValue()); $email = trim($currentSheet->getCell($dd)->getValue()); $ordersTime = trim($currentSheet->getCell($ee)->getValue()); $paymentTime = trim($currentSheet->getCell($ff)->getValue()); $sku = trim($currentSheet->getCell($gg)->getValue()); $amount = trim($currentSheet->getCell($hh)->getValue()); $itemTitle = trim($currentSheet->getCell($ii)->getValue()); $note = trim($currentSheet->getCell($jj)->getValue()); $itemPrice = trim($currentSheet->getCell($kk)->getValue()); $shippingFee = trim($currentSheet->getCell($ll)->getValue()); $actualTotal = trim($currentSheet->getCell($mm)->getValue()); $currency = trim($currentSheet->getCell($nn)->getValue()); $transId = trim($currentSheet->getCell($oo)->getValue()); $username = trim($currentSheet->getCell($pp)->getValue()); $street = trim($currentSheet->getCell($qq)->getValue()); $address2 = trim($currentSheet->getCell($rr)->getValue()); $address3 = trim($currentSheet->getCell($ss)->getValue()); $city = trim($currentSheet->getCell($tt)->getValue()); $state = trim($currentSheet->getCell($uu)->getValue()); $zipCode = trim($currentSheet->getCell($vv)->getValue()); $countryName = trim($currentSheet->getCell($ww)->getValue()); $landline = trim($currentSheet->getCell($xx)->getValue()); $carrierNameCn = trim($currentSheet->getCell($yy)->getValue()); if (empty($account)) { break; } if (in_array($recordNumber, $orderid)) { $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['itemPrice'] = $itemPrice; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['shippingFee'] = $shippingFee; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $itemTitle; //$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10]; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId; if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } else { $orderid[] = $recordNumber; //order信息 $orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderData']['ordersTime'] = strtotime($ordersTime); $orderData[$recordNumber]['orderData']['paymentTime'] = strtotime($paymentTime); $orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal; $orderData[$recordNumber]['orderData']['orderAddTime'] = time(); $SYSTEM_ACCOUNTS = OmAvailableModel::getTNameList("om_account", "*", " where account='{$account}'"); $orderData[$recordNumber]['orderData']['accountId'] = $SYSTEM_ACCOUNTS[0]['id']; $orderData[$recordNumber]['orderData']['platformId'] = $SYSTEM_ACCOUNTS[0]['platformId']; $SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount(); foreach ($SYSTEM_ACCOUNTS as $platform => $accounts) { foreach ($accounts as $accountId => $accountname) { if ($account == $accountname) { if ($platform == "ebay") { $orderData[$recordNumber]['orderData']['isFixed'] = 2; } else { $orderData[$recordNumber]['orderData']['isFixed'] = 1; } } } } $transportation = CommonModel::getCarrierList(); //所有的 foreach ($transportation as $tranValue) { if ($tranValue['carrierNameCn'] == $carrierNameCn) { $orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id']; break; } //$transportationList[$tranValue['id']] = $tranValue['carrierNameCn']; } //order扩展信息 $orderData[$recordNumber]['orderExtenData']['currency'] = $currency; $orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS"; $orderData[$recordNumber]['orderExtenData']['transId'] = $recordNumber; // 交易id;; $orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername; //$orderData[$recordNumber]['orderExtenData']['currency'] = $currency; //user信息 $orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername; $orderData[$recordNumber]['orderUserInfoData']['username'] = $username; $orderData[$recordNumber]['orderUserInfoData']['email'] = $email; $orderData[$recordNumber]['orderUserInfoData']['street'] = $street; $orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency; $orderData[$recordNumber]['orderUserInfoData']['address2'] = $address2; $orderData[$recordNumber]['orderUserInfoData']['address3'] = $address3; $orderData[$recordNumber]['orderUserInfoData']['city'] = $city; $orderData[$recordNumber]['orderUserInfoData']['state'] = $state; $orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode; $orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName; $orderData[$recordNumber]['orderUserInfoData']['landline'] = $landline; //detail信息 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['itemPrice'] = $itemPrice; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['shippingFee'] = $shippingFee; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time(); $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $itemTitle; //$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10]; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId; //note信息 if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } } //echo "<pre>";print_r($orderData); $message = ""; foreach ($orderData as $id => $order) { $msg = commonModel::checkOrder($id); if ($msg) { $message .= "<font color='red'>订单{$id}已存在!</font><br>"; continue; } //计算订单属性 if (count($order['orderDetail']) == 1) { $detail = current($order['orderDetail']); if ($detail['orderDetailData']['amount'] == 1) { $orderData[id]['orderData']['orderAttribute'] = 1; } else { $orderData[id]['orderData']['orderAttribute'] = 2; } } else { $orderData[id]['orderData']['orderAttribute'] = 3; } //计算订单重量及包材 $obj_order_detail_data = array(); foreach ($order['orderDetail'] as $sku => $detail) { $obj_order_detail_data[] = $detail['orderDetailData']; } $weightfee = commonModel::calcOrderWeight($obj_order_detail_data); $orderData[$id]['orderData']['calcWeight'] = $weightfee[0]; //$orderData[$value[0]]['orderData']['calcShipping'] = $weightfee[3]; $orderData[$id]['orderData']['pmId'] = $weightfee[1]; //计算运费 $calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, $orderData[$id]['orderData']['isFixed']); //计算运费 $orderData[$id]['orderData']['channelId'] = $calcShippingInfo['fee']['channelId']; //缺货拦截 $status = commonModel::auto_contrast_intercept($orderData[$id]); $orderData[$id]['orderData']['orderStatus'] = $status['orderStatus']; $orderData[$id]['orderData']['orderType'] = $status['orderType']; //print_r($order); //插入订单 $info = OrderAddModel::insertAllOrderRowNoEvent($order); if ($info) { $message .= "<font color='green'>订单{$id}上传成功!</font><br>"; } else { $message .= "<font color='red'>订单{$id}上传失败!</font><br>"; } } $this->smarty->assign("showerrorinfo", $message); //header("location:index.php?mod=underLineOrderImport&act=importOrder"); } $this->smarty->display('underLineOrderImport.htm'); }
function act_accountAllListById() { $res = omAccountModel::accountAllListById(); self::$errCode = omAccountModel::$errCode; self::$errMsg = omAccountModel::$errMsg; return $res; }
public function view_getOrderList() { global $memc_obj; $pagesize = isset($_GET['pnum']) && intval($_GET['pnum']) > 0 && intval($_GET['pnum']) < 101 ? intval($_GET['pnum']) : 20; //页面大小 if ($_GET['debug'] == 1) { $starttime = time() + microtime(); echo microtime() . '-----' . $starttime . "\n"; } //菜单 $status = ''; $search = isset($_REQUEST['search']) ? $_REQUEST['search'] : ''; //搜索时使用的数据 //order表 $searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : ''; //搜索平台 $searchAccountId = isset($_GET['accountId']) ? $_GET['accountId'] : ''; //搜索账号 $searchIsNote = isset($_GET['isNote']) ? $_GET['isNote'] : ''; //是否有留言 $searchTransportationType = isset($_GET['transportationType']) ? $_GET['transportationType'] : ''; //运输类型 $searchTransportation = isset($_GET['transportation']) ? $_GET['transportation'] : ''; //运输方式 $searchIsBuji = isset($_GET['isBuji']) ? $_GET['isBuji'] : ''; //是否补寄订单 $searchIsLock = isset($_GET['isLock']) ? $_GET['isLock'] : ''; //是否锁定 $searchOrderTime1 = isset($_GET['OrderTime1']) ? $_GET['OrderTime1'] : ''; //搜索下单初始时间 $searchOrderTime2 = isset($_GET['OrderTime2']) ? $_GET['OrderTime2'] : ''; //搜索下单结束时间 //order_detail表 $searchReviews = isset($_GET['reviews']) ? $_GET['reviews'] : ''; //是否评价 $searchSku = isset($_GET['sku']) ? $_GET['sku'] : ''; //sku //$searchOmOrderId = ''; //订单编号 $searchOrderType = isset($_GET['selectOrderType']) ? $_GET['selectOrderType'] : ''; //订单种类 //order_userInfo表 //$searchUsername = ''; //买家名 //$searchEmail = ''; $countryName = isset($_GET['country']) ? $_GET['country'] : ""; $state = isset($_GET['state']) ? $_GET['state'] : ""; $city = isset($_GET['city']) ? $_GET['city'] : ""; $zipCode = isset($_GET['zipCode']) ? $_GET['zipCode'] : ""; //order_warehouse表 //$weighTimeStart = isset($_GET['searchTimeStart'])? $_GET['searchTimeStart']:""; //$weighTimeEnd = isset($_GET['searchTimeEnd'])? $_GET['searchTimeEnd']:""; $searchTimeType = isset($_GET['searchTimeType']) ? $_GET['searchTimeType'] : ''; //order_tracknumbe表 //$searchTracknumber = ''; //跟踪号 //order_extension_ebay表 //$searchTransId = ''; //交易ID $searchKeywordsType = isset($_GET['KeywordsType']) ? $_GET['KeywordsType'] : ''; //搜索关键字类型 $searchKeywords = isset($_GET['Keywords']) ? $_GET['Keywords'] : ''; //搜索关键字 $this->smarty->assign('searchPlatformId', $searchPlatformId); $this->smarty->assign('searchAccountId', $searchAccountId); $this->smarty->assign('searchIsNote', $searchIsNote); $this->smarty->assign('searchTransportationType', $searchTransportationType); $this->smarty->assign('searchTransportation', $searchTransportation); $this->smarty->assign('searchIsBuji', $searchIsBuji); $this->smarty->assign('searchIsLock', $searchIsLock); $this->smarty->assign('searchOrderTime1', $searchOrderTime1); $this->smarty->assign('searchOrderTime2', $searchOrderTime2); $this->smarty->assign('searchReviews', $searchReviews); $this->smarty->assign('searchSku', $searchSku); $this->smarty->assign('searchOrderType', $searchOrderType); //$this->smarty->assign('searchEmail', $searchEmail); $this->smarty->assign('searchKeywordsType', $searchKeywordsType); $this->smarty->assign('searchKeywords', $searchKeywords); $this->smarty->assign('searchCountry', $countryName); $this->smarty->assign('searchState', $state); $this->smarty->assign('searchCity', $city); $this->smarty->assign('searchZipCode', $zipCode); //$this->smarty->assign('searchTimeStart', $weighTimeStart); //$this->smarty->assign('searchTimeEnd', $weighTimeEnd); $this->smarty->assign('searchTimeType', $searchTimeType); if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "firsttime ==={$dotime}=== " . ($dotime - $starttime) . "\n\n"; } $OrderRefundAct = new OrderRefundAct(); $omAvailableAct = new OmAvailableAct(); $OrderindexAct = new OrderindexAct(); //平台信息 $OmAccountAct = new OmAccountAct(); $WarehouseAPIAct = new WarehouseAPIAct(); if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "secondtime === " . ($dotime1 - $dotime) . "\n\n"; } $AbOrderList = $WarehouseAPIAct->act_getAbOrderList(); //var_dump($AbOrderList); exit; if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "thirdtime === " . ($dotime - $dotime1) . "\n\n"; } $AbOrderListArr = array(); $AbOrderids = array(); $AbOrderShow = array(); foreach ($AbOrderList as $orderId) { $AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']); $AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo; $AbOrderids[] = $orderId['originOrderId']; $AbOrderShow[$orderId['originOrderId']] = $orderId['id']; } if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "forthtime === " . ($dotime1 - $dotime) . "\n\n"; } //var_dump($AbOrderListArr); exit; $this->smarty->assign('AbOrderListArr', $AbOrderListArr); $this->smarty->assign('AbOrderShow', $AbOrderShow); //$platform = $omAvailableAct->act_getTNameList('om_platform','id,platform','WHERE is_delete=0'); $platform = $OmAccountAct->act_getPlatformListByPower(); //var_dump($platform); if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "fiftytime === " . ($dotime - $dotime1) . "\n\n"; } $this->smarty->assign('platform', $platform); /**导航 start**/ $default_ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : C('STATEPENDING'); /*if(isset($_GET['ostatus']) && !empty($_GET['ostatus'])){ $ostatus = $_GET['ostatus']; }else{ $ostatus = C('STATEPENDING'); }*/ $ostatus = $_GET['ostatus']; //echo C('STATEPENDING'); $this->smarty->assign('ostatus', $ostatus); $otype = isset($_GET['otype']) ? $_GET['otype'] : ''; $this->smarty->assign('otype', $otype); //二级目录 $StatusMenuAct = new StatusMenuAct(); $ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0'); //var_dump($ostatusList); $this->smarty->assign('ostatusList', $ostatusList); if ($ostatus) { $otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0'); } else { $otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $default_ostatus . '" AND is_delete=0'); } if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "sixtytime === " . ($dotime1 - $dotime) . "\n\n"; } //var_dump($otypeList); $this->smarty->assign('otypeList', $otypeList); /*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc'); $this->smarty->assign('o_secondlevel', $o_secondlevel);*/ $second_count = array(); $second_type = array(); $accountacc = $_SESSION['accountacc']; //var_dump($ostatusList); echo "<br>"; foreach ($ostatusList as $o_secondinfo) { $orderStatus = $o_secondinfo['statusCode']; //echo $orderStatus."============"; echo "<br>"; $s_total = 0; //$OrderindexAct->act_showSearchOrderNum($orderStatus); //echo $orderStatus."==".$s_total; echo "<br>"; $second_count[$o_secondinfo['statusCode']] = $s_total; //$s_type = $omAvailableAct->act_getTNameList("om_status_menu","*","WHERE is_delete=0 and groupId='$orderStatus' order by sort asc"); $s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc'); $second_type[$orderStatus] = $s_type[0]['statusCode']; } if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "seventime === " . ($dotime - $dotime1) . "\n\n"; } //var_dump($second_count); $this->smarty->assign('second_count', $second_count); $this->smarty->assign('second_type', $second_type); //var_dump($second_type); //退款数量 $accountList = $_SESSION['accountList']; $platformList = $_SESSION['platformList']; //echo "<pre>"; print_r($accountList); exit; $where = " WHERE is_delete=0 "; $platformsee = array(); for ($i = 0; $i < count($platformList); $i++) { $platformsee[] = $platformList[$i]; } if ($platformsee) { $where .= ' AND platformId IN (' . join(",", $platformsee) . ') '; } else { //$where .= " AND 1=2 "; } $accountsee = array(); for ($i = 0; $i < count($accountList); $i++) { $accountsee[] = $accountList[$i]; } if ($accountsee) { $where .= ' AND accountId IN (' . join(",", $accountsee) . ') '; } else { //$where .= " AND 1=2 "; } //echo $where; //$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 "); $refund_total = $OrderRefundAct->act_getRecordNums(); $this->smarty->assign('refund_total', $refund_total); $parameterArr = array(); //var_dump($AbOrderids); $parameterArr['AbOrderList'] = $AbOrderids; $total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr); $this->smarty->assign('abnormal_total', $total); if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "8time === " . ($dotime1 - $dotime) . "\n\n"; } //三级目录 $three_count = array(); if ($ostatus) { $o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc"); foreach ($o_threelevel as $o_threeinfo) { $orderType = $o_threeinfo['statusCode']; /*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' "; if($accountacc){ $or_where .= ' AND ('.$accountacc.') '; }*/ //$s_total = $OrderindexAct->act_showSearchOrderNum($ostatus, $orderType); $s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType); //$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where); $three_count[$o_threeinfo['statusCode']] = $s_total; } } else { $or_where = "WHERE is_delete=0 and groupId='{$default_ostatus}' "; if ($accountacc) { $or_where .= ' AND (' . $accountacc . ') '; } $or_where .= " order by sort asc"; $o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$default_ostatus}' order by sort asc"); foreach ($o_threelevel as $o_threeinfo) { $orderType = $o_threeinfo['statusCode']; /*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' "; if($accountacc){ $or_where .= ' AND ('.$accountacc.') '; }*/ $s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType); //$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where); $three_count[$o_threeinfo['statusCode']] = $s_total; } } // if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "9time === " . ($dotime - $dotime1) . "\n\n"; } $this->smarty->assign('o_threelevel', $o_threelevel); $this->smarty->assign('three_count', $three_count); $toptitle = '订单显示页面'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 0); $threelevel = '1'; //当前的三级菜单 $this->smarty->assign('threelevel', $threelevel); $statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 '); $this->smarty->assign('statusMenu', $statusMenu); $value = ''; $where = ''; switch ($searchTransportationType) { case '1': $transportation = CommonModel::getCarrierList(1); //快递 break; case '2': $transportation = CommonModel::getCarrierList(0); //平邮 break; default: $transportation = CommonModel::getCarrierList(); //所有的 break; } if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "10time === " . ($dotime1 - $dotime) . "\n\n"; } //var_dump($transportation); exit; $transportationList = array(); foreach ($transportation as $tranValue) { $transportationList[$tranValue['id']] = $tranValue['carrierNameCn']; } //var_dump($transportationList); exit; $this->smarty->assign('transportation', $transportation); $this->smarty->assign('transportationList', $transportationList); if ($search == '') { /*$where = ' WHERE is_delete = 0 AND storeId = 1 AND orderStatus = '.$ostatus; if($otype != ''){ $where .= ' AND orderType = '.$otype; }*/ //$total = $omAvailableAct->act_getTNameCount($orderForm, $where); $total = $OrderindexAct->act_showOrder($ostatus, $otype); //echo $total; exit; $num = $pagesize; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); //$where .= " ORDER BY ordersTime " . $page->limit; //echo "========订单系统升级中========="; echo "<br>"; $omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit); //echo "<pre>"; var_dump($omOrderList); exit; //$omOrderList = $omAvailableAct->act_getTNameList($orderForm, '*', $where); } else { $parameterArr = array(); $parameterArr['searchPlatformId'] = $searchPlatformId; $parameterArr['searchAccountId'] = $searchAccountId; $parameterArr['searchIsNote'] = $searchIsNote; $parameterArr['searchTransportationType'] = $searchTransportationType; $parameterArr['searchTransportation'] = $searchTransportation; $parameterArr['searchIsBuji'] = $searchIsBuji; $parameterArr['searchIsLock'] = $searchIsLock; $parameterArr['searchOrderTime1'] = $searchOrderTime1; $parameterArr['searchOrderTime2'] = $searchOrderTime2; $parameterArr['searchReviews'] = $searchReviews; $parameterArr['searchSku'] = trim($searchSku); $parameterArr['searchOrderType'] = $searchOrderType; $parameterArr['searchKeywordsType'] = $searchKeywordsType; $parameterArr['countryName'] = trim($countryName); $parameterArr['state'] = trim($state); $parameterArr['city'] = trim($city); $parameterArr['zipCode'] = trim($zipCode); $parameterArr['searchTimeType'] = trim($searchTimeType); $parameterArr['searchKeywords'] = trim($searchKeywords); //$parameterArr['searchKeywords'] = trim($searchKeywords); /*if($_SESSION['sysUserId'] == 8){ var_dump($ostatus.'---'.$otype); }*/ //echo "订单系统升级中。。。。。。。<br>"; //var_dump($parameterArr); echo "<br>"; //$total = $OrderindexAct->act_index($parameterArr,$searchKeywordsType,$searchKeywords); $total = $OrderindexAct->act_showOrder($ostatus, $otype, '', $parameterArr); //echo $total; exit; $num = $pagesize; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); //$limit = $page->limit; //var_dump($parameterArr); $omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit, $parameterArr); //var_dump($omOrderList); //$omOrderList = OrderindexAct::act_index($parameterArr,$searchKeywordsType,$searchKeywords,$limit,$ostatus); } if ($_GET['debug'] == 1) { $dotime = time() + microtime(); echo "11time ={$dotime}== " . ($dotime - $dotime1) . "\n\n"; } //$sku = array(); $account_where = ' WHERE is_delete = 0 '; if ($searchPlatformId) { $account_where .= ' AND platformId = ' . $searchPlatformId; } $UserCompetenceAct = new UserCompetenceAct(); $accountList = $UserCompetenceAct->act_showGlobalUser(); if ($accountList) { $account_where .= ' AND id in ( ' . join(',', $accountList) . ' ) '; } //帐号信息 $accountList = $omAvailableAct->act_getTNameList('om_account', '*', $account_where); //var_dump($accountList); exit; $account = array(); foreach ($accountList as $v) { $account[$v['id']] = $v['account']; } //包材信息 $pm = GoodsModel::getMaterInfoByList(); 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; } //var_dump($page); 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)); } //echo $show_page; //获取系统所有状态 $statusList = copyOrderModel::selectStatusList(); if ($_GET['debug'] == 1) { $dotime1 = time() + microtime(); echo "12time ={$dotime1}== " . ($dotime1 - $dotime) . "\n\n"; } //echo $show_page; $this->smarty->assign('statusList', $statusList); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('account', $account); $this->smarty->assign('accountList', $accountList); $this->smarty->assign('pm', $pm); $this->smarty->assign('omOrderList', $omOrderList); $this->smarty->display('orderindex.htm'); }
public function view_addMissingOrder() { $OmAccountAct = new OmAccountAct(); $message = isset($_GET['message']) ? trim($_GET['message']) : ''; $aliexpressmessage = isset($_GET['aliexpressmessage']) ? trim($_GET['aliexpressmessage']) : ''; //echo $message; $amazonAccountList = $OmAccountAct->act_getAccountListByPid(11); //print_r($amazonAccountList); $amazonAccountList = json_decode($amazonAccountList, true); $ebayAccountList = $OmAccountAct->act_getEbayAccountList(); //print_r($ebayAccountList); exit; if (isset($_POST['addOrder']) && !empty($_POST)) { $addorder = isset($_POST['addOrder']) ? $_POST['addOrder'] : ""; if ($addorder == "ebay") { //$message = ""; $accountId = isset($_POST['ebay_account']) ? $_POST['ebay_account'] : ""; $account = OmAvailableModel::getTNameList("om_account", "*", " where id={$accountId}"); $account = $account[0]['account']; //echo $account; include WEB_PATH . "conf/scripts/script.ebay.config.php"; include WEB_PATH . "conf/scripts/script.config.php"; require_once WEB_PATH . "crontab/scripts.comm.php"; require_once WEB_PATH_LIB_SCRIPTS_EBAY . "ebay_order_cron_func.php"; $rmq_config = C("RMQ_CONFIG"); //echo "<pre>"; var_dump($rmq_config); exit; $rabbitMQClass = new RabbitMQClass($rmq_config['fetchOrder'][1], $rmq_config['fetchOrder'][2], $rmq_config['fetchOrder'][4], $rmq_config['fetchOrder'][0]); //队列对象 include WEB_PATH . "lib/sdk/ebay/GetCertainOrder.php"; require_once WEB_PATH . "lib/PHPExcel.php"; if (isset($_FILES) && !empty($_FILES['ebay_id']['tmp_name'])) { $ftype1 = $_FILES['ebay_id']['type']; $tmp_name = $_FILES['ebay_id']['tmp_name']; $fsize = $_FILES['ebay_id']['size']; define("MAX_UPLOAD_SIZE", 128 * 1024 * 1024); if ($fsize <= MAX_UPLOAD_SIZE) { //判断文件头2字节 $allow_excel_type = array('application/vnd.ms-excel', 'application/octet-stream', 'text/comma-separated-values', 'application/ww-plugin', 'application/npalicdo', 'application/qscall-plugin', 'application/octet-stream', 'text/csv'); $allow_excel_ftypecode = array('8397', '349', '983'); //csv $f = fopen($tmp_name, 'rb'); $bin = fread($f, 2); fclose($f); $strInfo = @unpack('c2chars', $bin); $ftype2 = intval($strInfo['chars1'] . $strInfo['chars2']); if (in_array($ftype1, $allow_excel_type) && in_array($ftype2, $allow_excel_ftypecode)) { $upload_fname = $_FILES['ebay_id']['name']; $ext = 'csv'; $f_order = fopen($tmp_name, 'r'); $EXCEL_ROW_CNT = 0; $excel_order_cnt = 0; $OrderMatch = array(); $OrderMissed = array(); //漏单 $OrderIDWrong = array(); //excel中订单号格式不对 $OrderDuplicate = array(); //重复的订单号 $OrderException = array(); //异常订单 while ($order_line = fgetcsv($f_order, 1024, ',')) { if ($EXCEL_ROW_CNT == 0) { $EXCEL_ROW_CNT++; continue; //ignore the first line } $ebay_recordnumber = $order_line[0]; $ebay_orderid = scientific_convert_digital(trim($order_line[1])); $ebay_itemid = scientific_convert_digital(trim($order_line[2])); $ebay_tranid = scientific_convert_digital(trim($order_line[3])); $EXCEL_ROW_CNT++; $order_line = NULL; unset($order_line); if (empty($ebay_orderid)) { //column orderid is empty if (preg_match('#^\\d{12}$#i', $ebay_itemid) && (preg_match('#^\\d{12,14}$#i', $ebay_tranid) || $ebay_tranid == '0')) { $ebay_orderid = $ebay_itemid . '-' . $ebay_tranid; } else { //echo "$ebay_recordnumber 不满足生成orderid的条件,请检查itemid(要求12位),tranid要求(12-14位)<br>"; continue; } } else { //wrong format orderid if (!preg_match('#^\\d{12}$#i', $ebay_orderid)) { continue; } //if all the 3 columns has value,then this is one transaction of a multiple line item order if (!empty($ebay_itemid) && !empty($ebay_tranid) && !empty($ebay_orderid)) { continue; } } $order_info = array('record_no' => $ebay_recordnumber, 'order_id' => $ebay_orderid); $compare_res = fetchEbayOrderModel::checkEbayOrder($ebay_orderid, $ebay_recordnumber, $accountId); //echo "sdg"; if ($compare_res == '001') { $OrderIDWrong[] = $order_info; } else { if ($compare_res == '002') { $OrderMissed[] = $order_info; } else { if ($compare_res == '100' || $compare_res == '003') { $OrderDuplicate[] = $order_info; } else { if ($compare_res === FALSE) { $OrderException[] = $order_info; } else { //$OrderMatch[]=$order_info; } } } } } fclose($f_order); if (count($OrderIDWrong) != 0) { $message .= "<br><font >以下订单格式错误</font><br>"; $i = 0; foreach ($OrderIDWrong as $k => $v) { $message .= " <font color='red'>{$v['record_no']}</font> "; if ($i >= 3) { $message .= "<br>"; $i = 0; } $i++; } } if (count($OrderMissed) != 0) { $message .= "<br><font>以下为漏单情况</font><br>"; $i = 0; foreach ($OrderMissed as $k => $v) { //$message .= " <font color='red'>{$v['order_id']}</font> "; $message .= "<font color='green'>{$v['order_id']}</font><br>"; /*if($i>=3){ $message .= "<br>"; $i = 0; } $i++;*/ } } if (count($OrderDuplicate) != 0) { $message .= "<br><font>以下为重复订单</font><br>"; $i = 0; foreach ($OrderDuplicate as $k => $v) { $message .= " <font color='red'>{$v['record_no']}</font> "; if ($i >= 3) { $message .= "<br>"; $i = 0; } $i++; } } if (count($OrderException) != 0) { $message .= "<br><font >以下为异常订单</font><br>"; $i = 0; foreach ($OrderException as $k => $v) { $message .= " <font color='red'>{$v['record_no']}</font> "; if ($i >= 3) { $message .= "<br>"; $i = 0; } $i++; } } } else { $message .= "[{$ftype1}][{$ftype2}]此处只能上传CSV文件!!!<br/>"; } } else { $message .= '你上传的文件有' . $fsize / (1024 * 1024) . 'M,已超过限制' . MAX_UPLOAD_SIZE / (1024 * 1024) . 'M!'; } } //$ebay_id = isset($_POST['ebay_id'])?$_POST['ebay_id']:""; $tip = false; //echo "<pre>"; print_r($OrderMissed); exit; if (count($OrderMissed) == 0) { $message .= "<font color='green'>没有漏单</font><br>"; echo $message; exit; } else { $ebay_ids = array(); foreach ($OrderMissed as $k => $v) { $where = "where orderId='{$v['order_id']}'"; //echo $where; $msg = OmAvailableModel::getTNameList("om_unshipped_order_extension_ebay", "*", $where); //print_r($msg); if ($msg) { $message .= "<font color='red'>订单{$id}已存在!</font><br>"; continue; } $ebay_ids[] = $v['order_id']; } if (empty($ebay_ids)) { $message .= "<font color='green'>不存在漏单</font><br>"; } else { //echo "<pre>"; print_r($ebay_ids); exit; //$ebay_ids = explode(",",$ebay_id); $api_gco = new GetCertainOrderAPI($account); //ob_start(); $api_gco->GetCertainOrder($account, $ebay_ids); //监听获取队列信息 //ob_end_clean(); } /*foreach($ebay_ids as $key=>$id){ $where = "where orderId='{$id}'"; //echo $where; $msg = OmAvailableModel::getTNameList("om_unshipped_order_extension_ebay","*",$where); //print_r($msg); if($msg){ $message .= "<font color='red'>订单{$id}已存在!</font><br>"; continue; } $info = $ebay_api->push_ebay_orderid_queue($id,$account,$rabbitMQClass); $tip=true; }*/ //$info = $ebay_api-> } //ob_start(); //$message = fetchEbayOrderModel::addOrder($account); //ob_end_clean(); //echo fetchEbayOrderModel::$errMsg; } elseif ($addorder == "amazon") { $fetch_amazon_order = new fetchAmazonOrderAct(); $aliexpressmessage = $fetch_amazon_order->act_fetchOrder(); //header("Location:index.php?mod=missingOrderAdd&act=addMissingOrder&aliexpressmessage={$aliexpressmessage}"); } } //print_r($ebayAccountList); $this->smarty->assign("ebayAccountList", $ebayAccountList); $this->smarty->assign("amazonAccountList", $amazonAccountList); $this->smarty->assign('message', $message); $this->smarty->assign('aliexpressmessage', $aliexpressmessage); $this->smarty->assign('toptitle', '漏单添加'); $this->smarty->assign('toplevel', 2); $this->smarty->assign('secondlevel', '280'); $this->smarty->display("missingOrderAdd.htm"); }
public function view_orderRefundList() { global $memc_obj; $pagesize = 200; //页面大小 //菜单 $status = ''; //print_r($_GET); //搜索时使用的数据 //order表 $searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : ''; //搜索平台 $searchRefundType = isset($_GET['refundType']) ? $_GET['refundType'] : ''; //退款类型 $searchRefundStatus = isset($_GET['refundStatus']) ? $_GET['refundStatus'] : ''; // $searchOmOrderId = isset($_GET['omOrderId']) ? $_GET['omOrderId'] : ''; //订单编号 $searchTransId = isset($_GET['transId']) ? $_GET['transId'] : ''; //交易ID $searchApplyTime1 = isset($_GET['applyTime1']) ? $_GET['applyTime1'] : ''; //初始时间 $searchApplyTime2 = isset($_GET['applyTime2']) ? $_GET['applyTime2'] : ''; //结束时间 $status = isset($_GET['status']) ? $_GET['status'] : 0; //操作状态 $orderType = isset($_GET['orderType']) ? $_GET['orderType'] : 1; //单据种类 $ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : 0; //一级分类 //echo "------------------$searchOmOrderId----------------"; $where = ' where is_delete=0 '; if ($searchPlatformId != '') { $where .= ' AND platformId = ' . $searchPlatformId; } if ($searchRefundType != '') { $where .= ' AND refundType = ' . $searchRefundType; } if ($searchTransId != '') { $where .= ' AND transId = ' . $searchTransId; } if ($searchOmOrderId != '') { $where .= ' AND omOrderId = ' . $searchOmOrderId; } if ($status != '') { $where .= ' AND status = ' . $status; } if ($searchApplyTime1 != '' && $searchApplyTime2 != '') { $where .= ' AND addTime >= "' . strtotime($searchApplyTime1) . '" AND addTime <= "' . strtotime($searchApplyTime2) . '" '; } $accountList = $_SESSION['accountList']; $platformList = $_SESSION['platformList']; //echo "<pre>"; print_r($accountList); exit; $platformsee = array(); for ($i = 0; $i < count($platformList); $i++) { $platformsee[] = $platformList[$i]; } if ($platformsee) { $where .= ' AND platformId IN (' . join(",", $platformsee) . ') '; } else { $where .= " AND 1=2 "; } $accountsee = array(); for ($i = 0; $i < count($accountList); $i++) { $accountsee[] = $accountList[$i]; } if ($accountsee) { $where .= ' AND accountId IN (' . join(",", $accountsee) . ') '; } else { $where .= " AND 1=2 "; } $this->smarty->assign('searchPlatformId', $searchPlatformId); $this->smarty->assign('searchRefundType', $searchRefundType); $this->smarty->assign('searchRefundStatus', $searchRefundStatus); $this->smarty->assign('searchOmOrderId', $searchOmOrderId); $this->smarty->assign('searchTransId', $searchTransId); $this->smarty->assign('searchApplyTime1', $searchApplyTime1); $this->smarty->assign('searchApplyTime2', $searchApplyTime2); $omAvailableAct = new OrderRefundAct(); $OrderindexAct = new OrderindexAct(); //平台信息 $OmAccountAct = new OmAccountAct(); $WarehouseAPIAct = new WarehouseAPIAct(); $AbOrderList = $WarehouseAPIAct->act_getAbOrderList(); //var_dump($AbOrderList); exit; $AbOrderListArr = array(); $AbOrderids = array(); $AbOrderShow = array(); foreach ($AbOrderList as $orderId) { $AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']); $AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo; $AbOrderids[] = $orderId['originOrderId']; $AbOrderShow[$orderId['originOrderId']] = $orderId['id']; } //var_dump($AbOrderListArr); exit; $this->smarty->assign('AbOrderListArr', $AbOrderListArr); $this->smarty->assign('AbOrderShow', $AbOrderShow); //$platform = $omAvailableAct->act_getTNameList('om_platform','id,platform','WHERE is_delete=0'); $platform = $OmAccountAct->act_getPlatformListByPower(); $this->smarty->assign('platform', $platform); /**导航 start**/ $this->smarty->assign('ostatus', $ostatus); $this->smarty->assign('status', $status); $this->smarty->assign('refund_status', $status); $StatusMenuAct = new StatusMenuAct(); $ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0'); /*var_dump($ostatusList);*/ $this->smarty->assign('ostatusList', $ostatusList); //二级目录 /*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc'); $this->smarty->assign('o_secondlevel', $o_secondlevel);*/ $second_count = array(); $second_type = array(); foreach ($ostatusList as $o_secondinfo) { $orderStatus = $o_secondinfo['statusCode']; //echo $orderStatus."============"; echo "<br>"; $s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus); //echo $orderStatus."==".$s_total; echo "<br>"; $second_count[$o_secondinfo['statusCode']] = $s_total; $s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc'); $second_type[$orderStatus] = $s_type[0]['statusCode']; } $this->smarty->assign('second_count', $second_count); $this->smarty->assign('second_type', $second_type); //退款数量 //echo $where; //$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0 "); $refund_total = $omAvailableAct->act_getRecordNums(); $this->smarty->assign('refund_total', $refund_total); $parameterArr = array(); //var_dump($AbOrderids); $parameterArr['AbOrderList'] = $AbOrderids; $total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr); $this->smarty->assign('abnormal_total', $total); //三级目录 /*$refund_one = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=0"); $this->smarty->assign('refund_one', $refund_one); $refund_two = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=1"); $this->smarty->assign('refund_two', $refund_two); $refund_three = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=2"); $this->smarty->assign('refund_three', $refund_three);*/ /**导航 end**/ $refund_status = array('671' => array(1, 0), '673' => array(1, 1), '674' => array(1, 2), '675' => array(2, 0), '676' => array(2, 1), '677' => array(2, 2), '678' => array(3, 0), '679' => array(3, 1)); $o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc"); //var_dump($o_threelevel); $extral_str = array(); foreach ($o_threelevel as $o_threeinfo) { $statusCode = $o_threeinfo['statusCode']; $torderType = $refund_status[$statusCode][0]; $tostatus = $refund_status[$statusCode][1]; $where = " WHERE orderType = '{$torderType}' and status = '{$tostatus}' and is_delete = 0 "; //echo $where; echo "<br>"; $s_total = $omAvailableAct->act_getRecordNums($where); //$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where); $three_count[$o_threeinfo['statusCode']] = $s_total; $extral_str[$o_threeinfo['statusCode']] = "orderType={$torderType}&status={$tostatus}"; } $this->smarty->assign('extral_str', $extral_str); $this->smarty->assign('o_threelevel', $o_threelevel); $this->smarty->assign('three_count', $three_count); $toptitle = '退款操作页面'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 0); $threelevel = '1'; //当前的三级菜单 $this->smarty->assign('threelevel', $threelevel); $statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0'); $this->smarty->assign('statusMenu', $statusMenu); //print_r($orderRefundList);//exit; //$where = ' WHERE is_delete = 0 '.$where; $where = " WHERE orderType = '{$orderType}' and status = '{$status}' and is_delete = 0 "; //echo $where; //$total = $omAvailableAct->act_getTNameCount('om_order_refund', $where); $total = $omAvailableAct->act_getRecordNums($where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); //$where .= " ORDER BY id " . $page->limit; //$orderRefundList = $omAvailableAct->act_getTNameList('om_order_refund', '*', $where); $orderRefundList = $omAvailableAct->act_getRefundList($where); //echo $where; if (empty($orderRefundList)) { $orderRefundList = array(); } $this->smarty->assign('orderRefundList', $orderRefundList); $where = ' WHERE is_delete = 0 '; //$where = ' WHERE is_delete = 0 AND orderRefundId in('.$value.') '.$where; if (!empty($orderRefundList)) { foreach ($orderRefundList as $k => $v) { if ($value == '') { $value = $v['id']; } else { $value .= ',' . $v['id']; } } $where = ' WHERE is_delete = 0 AND orderRefundId in(' . $value . ') '; } else { $where .= " AND 1=2 "; } $orderRefundDetailList = $omAvailableAct->act_getTNameList('om_order_refund_detail', '*', $where); /*if(empty($orderRefundDetailList)){ $status = '无符合条件的订单'; $this->smarty->assign('status', $status); $this->smarty->display('orderRefund.htm.htm'); exit; }*/ //print_r($orderRefundDetailList); if (empty($orderRefundDetailList)) { $orderRefundDetailList = array(); } $this->smarty->assign('orderRefundDetailList', $orderRefundDetailList); 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)); } //获取系统所有状态 $statusList = copyOrderModel::selectStatusList(); $this->smarty->assign('status', $status); $this->smarty->assign('statusList', $statusList); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('account', $account); $this->smarty->assign('sku', $sku); $this->smarty->assign('pm', $pm); $this->smarty->assign('orderdEtailExtensionEbay', $orderdEtailExtensionEbay); $this->smarty->assign('omOrderList', $omOrderList); $this->smarty->assign('omOrderDetail', $omOrderDetail); //$this->smarty->assign('orderTracknumber', $orderTracknumber); $this->smarty->assign('omOrderExtensionEbay', $omOrderExtensionEbay); $this->smarty->assign('omOrderUserInfo', $omOrderUserInfo); $this->smarty->display('orderRefund.htm'); }