32 { name: 'st_guide', type: 'string' }, |
32 { name: 'st_guide', type: 'string' }, |
33 { name: 'name', type: 'string' }, |
33 { name: 'name', type: 'string' }, |
34 { name: 'est_og', type: 'float' }, |
34 { name: 'est_og', type: 'float' }, |
35 { name: 'est_color', type: 'float' }, |
35 { name: 'est_color', type: 'float' }, |
36 { name: 'est_ibu', type: 'float' }, |
36 { name: 'est_ibu', type: 'float' }, |
|
37 { name: 'est_abv', type: 'float' }, |
37 ], |
38 ], |
38 id: 'record', |
39 id: 'record', |
39 url: "includes/db_recipes.php" |
40 url: "includes/db_recipes.php" |
40 }; |
41 }; |
41 var dataAdapter = new $.jqx.dataAdapter(source); |
42 var dataAdapter = new $.jqx.dataAdapter(source); |
63 filterable: true, |
64 filterable: true, |
64 filtermode: 'excel', |
65 filtermode: 'excel', |
65 columns: [ |
66 columns: [ |
66 { text: 'Stijlgids', datafield: 'st_guide', width: 120 }, |
67 { text: 'Stijlgids', datafield: 'st_guide', width: 120 }, |
67 { text: 'Letter', datafield: 'st_letter', width: 60 }, |
68 { text: 'Letter', datafield: 'st_letter', width: 60 }, |
68 { text: 'Stijl', datafield: 'st_name', width: 150 }, |
69 { text: 'Stijl', datafield: 'st_name', width: 160 }, |
69 { text: 'Naam', datafield: 'name' }, |
70 { text: 'Naam', datafield: 'name' }, |
70 { text: 'OG', datafield: 'est_og', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f3' }, |
71 { text: 'OG', datafield: 'est_og', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f3' }, |
71 { text: 'EBC', datafield: 'est_color', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f0' }, |
72 { text: 'EBC', datafield: 'est_color', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f0' }, |
72 { text: 'IBU', datafield: 'est_ibu', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f0' }, |
73 { text: 'IBU', datafield: 'est_ibu', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'f0' }, |
|
74 { text: 'ABV', datafield: 'est_abv', width: 60, align: 'right', cellsalign: 'right', cellsformat: 'p1' }, |
73 { text: 'Wijzig', datafield: 'Edit', width: 120, align: 'center', columntype: 'button', cellsrenderer: function () { |
75 { text: 'Wijzig', datafield: 'Edit', width: 120, align: 'center', columntype: 'button', cellsrenderer: function () { |
74 return "Wijzig"; |
76 return "Wijzig"; |
75 }, buttonclick: function (row) { |
77 }, buttonclick: function (row) { |
76 var datarecord = dataAdapter.records[row]; |
78 var datarecord = dataAdapter.records[row]; |
77 var url= "rec_edit.php?record=" + datarecord.record + "&return=rec_main.php"; |
79 var url= "rec_edit.php?record=" + datarecord.record + "&return=rec_main.php"; |