-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path40grpsearch2.html
52 lines (52 loc) · 1.55 KB
/
40grpsearch2.html
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
<div style="font-size:12px;">
Just like edition it is possible to check the data entered from the user. <br/>
This is done with the new property searchrules.<br/>
Try to enter non numeric value in <b>id</b> field
</div>
<br />
<table id="grps2"></table>
<div id="pgrps2"></div>
<script src="40grpsearch2.js" type="text/javascript"> </script>
<br />
<div style="font-size:12px;">
<b> HTML </b>
<XMP>
<table id="grps2"></table>
<div id="pgrps2"></div>
</XMP>
<b>Java Scrpt code</b>
<XMP>
jQuery("#grps2").jqGrid({
url:'server.php?q=4',
datatype: "json",
colNames:['Inv No', 'Date', 'Client', 'Amount','Tax','Total','Notes'],
colModel:[
{name:'id', key : true, index:'id', width:55, searchtype:"integer", searchrules:{"required":true, "number":true, "maxValue":13}},
{name:'invdate',index:'invdate', width:90},
{name:'name', index:'name', width:100},
{name:'amount',index:'amount', width:80, align:"right", searchtype:"number"},
{name:'tax',index:'tax', width:80, align:"right", searchtype:"number"},
{name:'total',index:'total', width:80,align:"right", searchtype:"number"},
{name:'note',index:'note', width:150, sortable:false}
],
rowNum:10,
width:700,
rowList:[10,20,30],
pager: '#pgrps2',
sortname: 'invdate',
viewrecords: true,
sortorder: "desc",
jsonReader: {
repeatitems : false
},
caption: "Show query in search",
height: '100%'
});
jQuery("#grps2").jqGrid('navGrid','#pgrps2',
{edit:false,add:false,del:false},
{},
{},
{},
{multipleSearch:true, multipleGroup:true, showQuery: true}
);
</XMP>