Beispiel #1
0
 function act_accountAllListById()
 {
     $res = omAccountModel::accountAllListById();
     self::$errCode = omAccountModel::$errCode;
     self::$errMsg = omAccountModel::$errMsg;
     return $res;
 }
Beispiel #2
0
 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");
 }
Beispiel #3
0
 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');
 }