include "../global.php"; /** PHPExcel */ require_once './phpexcel/Classes/PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set properties $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"); $unex = explode('|', $_SESSION['uname']); $from = $_GET['from']; $to = $_GET['to']; $state = !empty($_GET['state']) ? $_GET['state'] : 6; $shopid = !empty($_GET['shopid']) ? $_GET['shopid'] : 0; //当前报表属于哪家商铺 $shopname = $shopid ? '-' . iconv('gb2312', 'utf-8', get_shopname($db, $shopid)) : ""; $p = array('rqs' => $from, 'rqe' => $to, 'state' => $state, 'shopid' => $shopid); $orders_info = get_orders_info($db, $unex[0], $p); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '开始日期')->setCellValue('B1', $from)->setCellValue('C1', '结束日期')->setCellValue('D1', $to)->setCellValue('E1', '订单总数')->setCellValue('F1', $orders_info[2])->setCellValue('G1', '订单总额')->setCellValue('H1', $orders_info[3])->setCellValue('I1', '餐品总份')->setCellValue('J1', $orders_info[4]); // Add some data $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A3', '订单号')->setCellValue('B3', '状态')->setCellValue('C3', '配送地址')->setCellValue('D3', '联系电话')->setCellValue('E3', '送餐时间')->setCellValue('F3', '嘱咐')->setCellValue('G3', '订单总价')->setCellValue('H3', '下单时间')->setCellValue('I3', '餐店名称')->setCellValue('J3', '餐品名称')->setCellValue('K3', '餐品数量')->setCellValue('L3', '餐品总价'); $objActSheet = $objPHPExcel->getActiveSheet(); $objActSheet->getColumnDimension('A')->setWidth(10); $objActSheet->getColumnDimension('B')->setWidth(10); $objActSheet->getColumnDimension('C')->setWidth(20); $objActSheet->getColumnDimension('D')->setWidth(15); $objActSheet->getColumnDimension('E')->setWidth(12); $objActSheet->getColumnDimension('F')->setWidth(20); $objActSheet->getColumnDimension('G')->setWidth(10); $objActSheet->getColumnDimension('H')->setWidth(30); $objActSheet->getColumnDimension('I')->setWidth(20); $objActSheet->getColumnDimension('J')->setWidth(20); $objActSheet->getColumnDimension('H')->setWidth(10);
$count = $db->query($sql)->fetchColumn(); $tpages = $count ? ceil($count / $rpp) : 1; // total pages, last page number } else { $tpages = $param['tpages']; } $adjacents = intval($param['adjacents']); if ($page <= 0) { $page = 1; } if ($adjacents <= 0) { $adjacents = 2; } $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents . "&rqs=" . $param['rqs'] . "&rqe=" . $param['rqe'] . "&state=" . $param['state'] . "&shopid=" . $param['shopid'] . "&keyword=" . $param['keyword']; $pfrom = ($page - 1) * $rpp; $orders_info = get_orders_info($db, $unex[0], $param, $pfrom, $rpp); $shops = get_shops($db); ?> <html> <head> <link rel="stylesheet" href="./css/main.css" type="text/css" /> <link rel="stylesheet" href="./css/paginate.css" type="text/css" /> <script type="text/javascript" src="../jcart/jquery-1.5.1.js"></script> <script src="./js/ui/jquery.ui.core.js"></script> <script src="./js/ui/jquery.ui.widget.js"></script> <script src="./js/ui/jquery.ui.datepicker.js"></script> <link href="./js/ui/jquery.ui.all.css" rel="stylesheet" /> <script> $(function() { var dates = $( "#from, #to" ).datepicker({