-
Notifications
You must be signed in to change notification settings - Fork 5
/
groupingtwosum.php
60 lines (52 loc) · 2.01 KB
/
groupingtwosum.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<?php
/**
* Copyright (C) 2014 HiGrid Inc.
* higrid嗨网 中文PHP表格, http://higrid.net
*
* Released on 2014-7-13 v2.2.1
*/
defined('HIPATH') || define('HIPATH', dirname(__FILE__).'/');//绝对路径
require_once(HIPATH.'config.php');//数据库连接设置,修改本目录下config.php相关参数
$connhigrid = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
hiGridDB::query($connhigrid,"SET NAMES utf8");
// Create the jqGrid instance
$grid = new hgGridRender($connhigrid);
// Write the SQL Query
$grid->higridSC = 'SELECT OrderID, OrderDate, CustomerID, EmployeeID, Freight, ShipName FROM higrid_orders';
// set the ouput format to json
$grid->dataType = 'json';
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('./example/groupingtwosum.php');
// Set alternate background using altRows property
$grid->higridsGO(array(
"rowNum"=>10,
"sortname"=>"OrderID",
"rowList"=>array(10,20,50),
"height"=>'auto',
"footerrow"=>true,
"userDataOnFooter"=>true,
"grouping"=>true,
"groupingView"=>array(
"groupField" => array('CustomerID', 'EmployeeID'),
"groupOrder" => array('asc', 'asc'),
"groupColumnShow" => array(true, true),
"groupText" =>array('<b> Client:{0}</b>', '<b>Employee: {0}</b>'),
"groupSummary" => array(true, false)
)
));
// Change some property of the field(s)
$grid->higridsCP("OrderID", array("label"=>"ID", "width"=>60));
$grid->higridsCP("OrderDate", array(
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y")
)
);
// Add a summary property to the Freight Column
$grid->higridsCP("Freight", array("summaryType"=>"sum", "summaryTpl"=>"{0}", "formatter"=>"number"));
$summaryrows = array("Freight"=>array("Freight"=>"SUM"));
// Enjoy
$grid->higridOP('#grid','#pager',true, $summaryrows, null, true,true);
$connhigrid = null;