-
Notifications
You must be signed in to change notification settings - Fork 5
/
chanzhi.php
137 lines (111 loc) · 4.71 KB
/
chanzhi.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<?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);
$connhigrid->query("SET NAMES utf8");
$grid = new hgGridRender($connhigrid);
//嗨网higrid:执行SQL查询
$grid->higridSC = 'SELECT * FROM higrid_chanzhi';
$grid->table = 'cd_chanzhi';
$grid->setPrimaryKeyId('period');
$grid->dataType = 'json';
$grid->setColModel();
$sarr = <<< FFF
{ "groupOp":"AND",
"rules":[
{"field":"period","op":"bw","data":"2012"}
]
}
FFF;
$grid->higridsCP('period',
array("label"=>"月份","width"=>"30",'align'=>'center',"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d", "newformat"=>"Y-m"),
"editoptions"=>array(
"defaultValue"=>date("Y-m-d"),
"dataInit"=>
"js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});
jQuery('.ui-datepicker').css({'font-size':'75%'});
},200);}")
));
$grid->higridsCP('ycommission', array("width"=>"60",'align'=>'right', "formatter"=>"number",'label'=>'合同一',));
$grid->higridsCP('ycc2', array("width"=>"80",'align'=>'right', "formatter"=>"currency",'label'=>'合同二',));
$grid->higridsCP('mcommission', array("width"=>"60",'align'=>'right', "formatter"=>"currency",'label'=>'合同一',));
$grid->higridsCP('mcc2', array("width"=>"60",'align'=>'right', "formatter"=>"currency",'label'=>'合同二',));
//嗨网higrid:设置本脚本文件路径
$grid->setUrl('./example/chanzhi.php');
//嗨网higrid:表格列属性修改
$grid->higridsGO(array(
"rownumbers"=>true,//设置显示行号
"caption"=>"数据台账",//标题
"hoverrows"=>true,
"altRows"=>true,
"rowNum"=>200,//默认行数
"height"=>300,
"rowList"=>array(20,50,100,200),
"sortable"=>true, //设置列与列之间可以拖拽表头排序
"search"=>true,
"postData"=>array( "filters"=> $sarr ),
'sortorder'=>'desc'));//指定排序方式 asc desc
$grid->navigator = true;
$grid->higridsNO('navigator', array("excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>true, "refresh"=>true,"search"=>true,"pdf"=>true));
$grid->higridsNO('add',array("width"=>500,"height"=>380,"dataheight"=>"auto",
"closeAfterAdd"=>true,"reloadAfterSubmit"=>true));//添加数据完后关闭对话框
//设置编辑对话框的信息
$grid->higridsNO('edit',array("width"=>500,"height"=>380,"dataheight"=>"auto",
"closeAfterEdit"=>true,"reloadAfterSubmit"=>true,"editCaption"=>"编辑数据","bSubmit"=>"更新"));
$grid->higridsGO(array("footerrow"=>true,"userDataOnFooter"=>true));//启用脚注行
$grid->callGridMethod('#cd_chanzhigrid', 'footerData', array("set",array('period'=>'小计:')));
$grid->callGridMethod("#cd_chanzhigrid", "setGroupHeaders", array(array(
"useColSpanStyle"=>true,
"groupHeaders"=>array(
array(
"startColumnName"=>'ycommission',
"numberOfColumns"=>2,
"titleText"=>'年初计划'
),
array(
"startColumnName"=>'mcommission',
"numberOfColumns"=>2,
"titleText"=>'每月上报'
)
)
)));
$oper = hgGridcommon::GetParam("oper");
// prevent some executions when not excel export
if($oper == "pdf") {
$grid->setPdfOptions(array(
// set the page orientation to landscape
"page_orientation"=>"R", //L
// enable header information
"header"=>true,
// set bigger top margin
"font_name_main"=>"stsongstdlight",
"font_monospaced"=>"stsongstdlight",
"font_name_data"=>"stsongstdlight",
"margin_top"=>27,
// set logo image
"header_logo"=>"higrid.png",
// set logo image width
"header_logo_width"=>30,
//header title
"header_title"=>"嗨网pdf导出测试, 打印时间:".date("Y-m-d H:i:s"),
// and a header string to print
"header_string"=>"higridpdf导出"
));
}
$grid->exportfile =date("Ymd_H:i:s").'sheyiexport.xml';
$grid->pdffile =date("Ymd_H:i:s").'sheyiexport.pdf';
$summaryrows = array("ycommission"=>array("ycommission"=>"SUM"),
"ycc2"=>array("ycc2"=>"SUM"),
"mcommission"=>array("mcommission"=>"SUM"),
"mcc2"=>array("mcc2"=>"SUM"),);
$grid->higridOP('#cd_chanzhigrid','#cd_chanzhipager',true, $summaryrows, null, true,true);
$connhigrid = null;
?>