19 * along with ThermFerm; see the file COPYING. If not, write to the Free |
19 * along with ThermFerm; see the file COPYING. If not, write to the Free |
20 * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. |
20 * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. |
21 *****************************************************************************/ |
21 *****************************************************************************/ |
22 |
22 |
23 |
23 |
24 $(document).ready(function () { |
24 $(document).ready(function() { |
25 var source = { |
25 var source = { |
26 datatype: "json", |
26 datatype: 'json', |
27 cache: false, |
27 cache: false, |
28 datafields: [ |
28 datafields: [ |
29 { name: 'record', type: 'number' }, |
29 { name: 'record', type: 'number' }, |
30 { name: 'name', type: 'string' }, |
30 { name: 'name', type: 'string' }, |
31 { name: 'code', type: 'string' }, |
31 { name: 'code', type: 'string' }, |
32 { name: 'year', type: 'string' }, |
32 { name: 'year', type: 'string' }, |
33 { name: 'date', type: 'string' }, |
33 { name: 'date', type: 'string' }, |
34 { name: 'style', type: 'string' }, |
34 { name: 'style', type: 'string' }, |
35 { name: 'og', type: 'float' }, |
35 { name: 'og', type: 'float' }, |
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 dataAdapter = new $.jqx.dataAdapter(source); |
42 dataAdapter = new $.jqx.dataAdapter(source); |
43 |
43 |
44 // initialize jqxGrid |
44 // initialize jqxGrid |
45 $("#jqxgrid").jqxGrid({ |
45 $('#jqxgrid').jqxGrid({ |
46 width: 1280, |
46 width: 1280, |
47 height: 630, |
47 height: 630, |
48 source: dataAdapter, |
48 source: dataAdapter, |
49 groupable: true, |
49 groupable: true, |
50 theme: theme, |
50 theme: theme, |
51 columns: [ |
51 columns: [ |
52 { text: 'Jaar', datafield: 'year', width: 80 }, |
52 { text: 'Jaar', datafield: 'year', width: 80 }, |
53 { text: 'Datum', datafield: 'date', width: 120, menu: false }, |
53 { text: 'Datum', datafield: 'date', width: 120, menu: false }, |
54 { text: 'Naam', datafield: 'name', menu: false }, |
54 { text: 'Naam', datafield: 'name', menu: false }, |
55 { text: 'Stijl', datafield: 'style', width: 250 }, |
55 { text: 'Stijl', datafield: 'style', width: 250 }, |
56 { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3', menu: false }, |
56 { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3', menu: false }, |
57 { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3', menu: false }, |
57 { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3', menu: false }, |
58 { text: 'Code', datafield: 'code', width: 100, menu: false }, |
58 { text: 'Code', datafield: 'code', width: 100, menu: false }, |
59 { 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 }, |
60 { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function () { |
60 { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function() { |
61 return "Bekijk"; |
61 return 'Bekijk'; |
62 }, buttonclick: function (row) { |
62 }, buttonclick: function(row) { |
63 var datarecord = dataAdapter.records[row]; |
63 var datarecord = dataAdapter.records[row]; |
64 window.location.href = "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'; |
65 } |
65 } |
66 } |
66 } |
67 ], |
67 ], |
68 groups: ['year'] |
68 groups: ['year'] |
69 }); |
69 }); |
70 }); |
70 }); |