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
| <!DOCTYPE html>
| <html>
| <head>
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
| <title>标准销售流向</title>
| <link rel="stylesheet" type="text/css" href="../../css/easyui.css">
| <link rel="stylesheet" type="text/css" href="../../css/icon.css">
| <script src="../../js/jquery-1.7.2.min.js"></script>
| <script src="../../js/foundation-2.0.js"></script>
| <script type="text/javascript" src="../../js/jquery.easyui.min.js"></script>
| <script type="text/javascript" src="../../js/datagrid-filter.js"></script>
| <script type="text/javascript" src="../../js/easyui-lang-zh_CN.js"></script>
| <script type="text/javascript" src="../../js/datagrid_handler.js"></script>
| <script type="text/javascript" >
| var grid;
|
| function dateFormater(val,row) {
| if(val){
| return '<span style="color:red;">('+val+')</span>';
| }
| }
|
| function Filter(){
|
| }
|
| $(document).ready(function() {
| grid = $('#sales');
| var columnsurl = "basic-report/sales";
| var gridUrl = 'root/data/procedure/getSales/getDataSet';
| dataGridHander = new DataGridHandler({
| grid:grid,
| tbOption:["fieldSetting","fresh","addline","export","upload","delete","edit"],
| columnUrl:columnsurl,
| gridUrl:gridUrl,
| fieldFormatter: {
| field:"bizdate",
| formatter:dateFormater
| },
| changeFilter:{
| field:"customertype",
| newFilter:{
| field: 'category',
| type: 'combobox',
| editable: false,
| options: {
| panelHeight: 'auto',
| mode: 'remote',
| valueField: 'id',
| textField: 'name',
| loader: function (param, success, error) {
| $.ajax({
| url: "root/data/procedure/getCustomerType/getDataSet?filter=1=1",
| type: 'get',
| cache: false,
| dataType: 'json',
| success: function (data) {
| alert(data);
| }
| });
| },
| onChange: function (value) {
| if (value == '') {
| var_activitimodel_datagrid.datagrid('removeFilterRule', 'enable');
| } else {
| var_activitimodel_datagrid.datagrid('addFilterRule', {
| field: 'category',
| op: 'equal',
| value: value
| });
| }
| var_activitimodel_datagrid.datagrid('doFilter');
| }
| }
| }
| },
| tbFuncParams: [
| {
| //url
| },
| {},
| {
| tablename:"haha"
| },
| {
| exporturl:"http://localhost:3456/api/FileCenter/Download?code=InvoicingComparisonTotal&fileExtension=xlsx"
| },
| {
| from:"InvoicingComparisonTotal"
| },
| {
| key:"key",
| tablename:"name"
| },{}]
|
| });
|
|
| });
|
| </script>
| </head>
|
| <body>
| <div id="table_root">
| <table id="sales" style="min-height: 600px;"></table>
| </div>
| </body>
| </html>
|
|
