-
Notifications
You must be signed in to change notification settings - Fork 5
/
JqGrid-Basico-3-filtros.html
executable file
·52 lines (50 loc) · 2.96 KB
/
JqGrid-Basico-3-filtros.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
<!DOCTYPE html >
<html lang="es">
<head>
<title>jqGrid Básico(3) - Filtros. </title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/jquery-ui.css" />
<link rel="stylesheet" type="text/css" href="css/ui.jqgrid.css" />
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-es.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="js/jquery-ui.js" type="text/javascript"></script>
<script type="text/javascript">
var mydata = [ {id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}, {id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}, {id:"7",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"9",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"} ];
$(document).ready(function(){
$("#list").jqGrid({
datatype: "local",
height: "auto",
colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
colModel:[
{name:'id',index:'id', width:60, search:false},
{name:'invdate',index:'invdate', width:90, searchoptions:{sopt:['eq'], dataInit:function(elem){$(elem).datepicker()}}},
{name:'name',index:'name', width:100, stype:"select", searchoptions:{value:":;test:test;test2:test2;test3:test3"}},
{name:'amount',index:'amount', width:80, align:"right", searchrules:{integer:true}},
{name:'tax',index:'tax', width:80, align:"right", searchrules:{integer:true}},
{name:'total',index:'total', width:80,align:"right", searchrules:{integer:true}},
{name:'note',index:'note', width:150, sortable:false}
],
caption: "http://sosinformatico.blogspot.com",
//viewrecords: true,
altRows: true,
pager:'#pager',
rowNum: 10,
rowList:[10,15,20]
}).navGrid('#pager', { view: false, del: false, add: false, edit: false },
{},//opciones edit
{}, //opciones add
{}, //opciones del
{multipleSearch:true,closeAfterSearch: true, closeOnEscape: true}//opciones search
).jqGrid("filterToolbar");
for(var i=0;i<=mydata.length;i++)
jQuery("#list").jqGrid('addRowData',i+1,mydata[i]);
jQuery("#list").trigger("reloadGrid")
});
</script>
</head>
<body>
<table id='list'></table>
<div id='pager'></div>
</body>
</html>