36 { name: 'fg', type: 'float' }, |
36 { name: 'fg', type: 'float' }, |
37 { name: 'batch_size', type: 'float' }, |
37 { name: 'batch_size', type: 'float' }, |
38 ], |
38 ], |
39 id: 'record', |
39 id: 'record', |
40 url: "includes/db_product.php?select=archdate" |
40 url: "includes/db_product.php?select=archdate" |
41 }; |
41 }, |
42 var dataAdapter = new $.jqx.dataAdapter(source); |
42 dataAdapter = new $.jqx.dataAdapter(source); |
|
43 |
43 // initialize jqxGrid |
44 // initialize jqxGrid |
44 $("#jqxgrid").jqxGrid({ |
45 $("#jqxgrid").jqxGrid({ |
45 width: 1280, |
46 width: 1280, |
46 height: 630, |
47 height: 630, |
47 source: dataAdapter, |
48 source: dataAdapter, |
58 { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1', menu: false }, |
59 { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1', menu: false }, |
59 { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function () { |
60 { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function () { |
60 return "Bekijk"; |
61 return "Bekijk"; |
61 }, buttonclick: function (row) { |
62 }, buttonclick: function (row) { |
62 var datarecord = dataAdapter.records[row]; |
63 var datarecord = dataAdapter.records[row]; |
63 var url= "prod_edit.php?record=" + datarecord.record + "&select=archdate&return=prod_archive_date.php"; |
64 window.location.href = "prod_edit.php?record=" + datarecord.record + "&select=archdate&return=prod_archive_date.php"; |
64 window.location.href = url; |
|
65 } |
65 } |
66 } |
66 } |
67 ], |
67 ], |
68 groups: ['year'] |
68 groups: ['year'] |
69 }); |
69 }); |