/** * * 订单数据服务费列表 * */ public function actionIndex() { $ecmsTaxModel = new EcmsTaxReceiptModel(); $dataserviceModel = new DataServiceFeeModel(); $plamfromType = CDict::$platform_type; $getData = $this->_get(); $curr_page = $getData['page'] ? $getData['page'] : 1; $platform_type = $this->_get('platform_type'); // 平台类型 $platfromType = CDict::$platform_type; $whereSql = ''; if ($getData['platform_type'] != '0' && $getData['platform_type']) { $whereSql .= "AND ORDERTYPE = '" . $getData['platform_type'] . "'"; } if (strlen($getData['gbillno']) > 0) { $whereSql .= "AND GENERALBILLNO LIKE '%" . $getData['gbillno'] . "%'"; } if (strlen($getData['start-time']) > 0) { $whereSql .= " AND TO_CHAR(REALARRIVALDATE, 'YYYY-MM-DD HH24:MI:SS') > '" . $getData['start-time'] . " 00:00:00'"; } if (strlen($getData['end-time']) > 0) { $whereSql .= " AND TO_CHAR(REALARRIVALDATE, 'YYYY-MM-DD HH24:MI:SS') < '" . $getData['end-time'] . " 24:00:00'"; } $data = $dataserviceModel->getList($whereSql, $curr_page, $this->_pageSize); $count = $dataserviceModel->getNowhereCount($whereSql); $page = new pager($count, $curr_page, $this->_pageSize); $pageStr = $page->GetPagerContent(); //var_dump($data); //var_dump($getData); //var_dump($whereSql); $count1 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='0' "); $count2 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='1' "); $count3 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='2' "); $count4 = $ecmsTaxModel->get_count(" AND TYPE='ECMS'"); $count5 = $ecmsTaxModel->get_count(" AND TYPE='UPS'"); $count6 = $dataserviceModel->getNowhereCount(""); $this->assign("count1", $count1); $this->assign("count2", $count2); $this->assign("count3", $count3); $this->assign("count4", $count4); $this->assign("count5", $count5); $this->assign("count6", $count6); array_unshift($plamfromType, "选择平台类型"); $this->assign('page', $pageStr); $this->assign('count', $count); $this->assign('platform_type', $getData['platform_type']); $this->assign('gbillno', $getData['gbillno']); $this->assign('starttime', $getData['start-time']); $this->assign('endtime', $getData['end-time']); $this->assign('data', $data); $this->assign("platformType", $plamfromType); $this->display('dataservicefee/dataservicefee_index.html'); }
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>----分页演示-----</title> </head> <body> <?php include "PHPPager.php"; error_reporting(7); $myPage = new pager(1300, intval(isset($_GET['page']) ? $_GET['page'] : 1)); echo $myPage->GetPagerContent(); ?> </body> </html>