Example #1
0
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);
Example #2
0
    $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 . "&amp;adjacents=" . $adjacents . "&amp;rqs=" . $param['rqs'] . "&amp;rqe=" . $param['rqe'] . "&amp;state=" . $param['state'] . "&amp;shopid=" . $param['shopid'] . "&amp;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({