203 }, |
202 }, |
204 filterable: true, |
203 filterable: true, |
205 filtermode: 'excel', |
204 filtermode: 'excel', |
206 columns: [ |
205 columns: [ |
207 { text: 'Ingredient naam', datafield: 'name', menu: false }, |
206 { text: 'Ingredient naam', datafield: 'name', menu: false }, |
208 { text: 'Type', datafield: 'type', align: 'center', cellsalign: 'center', width: 120, |
207 { text: 'Type', datafield: 'type', align: 'left', width: 120, |
209 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
208 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
210 return "<div style='margin: 4px;' class='jqx-center-align'>" + MiscTypeData[value].nl + "</div>"; |
209 return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + MiscTypeData[value].nl + "</span>"; |
211 } |
210 } |
212 }, |
211 }, |
213 { text: 'Gebruik', datafield: 'use_use', align: 'center', cellsalign: 'center', width: 120, |
212 { text: 'Gebruik', datafield: 'use_use', align: 'left', width: 120, |
214 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
213 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
215 return "<div style='margin: 4px;' class='jqx-center-align'>" + MiscUseData[value].nl + "</div>"; |
214 return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + MiscUseData[value].nl + "</span>"; |
216 } |
215 } |
217 }, |
216 }, |
218 { text: 'Tijd', datafield: 'time', width: 90, align: 'left', menu: false, |
217 { text: 'Tijd', datafield: 'time', width: 90, align: 'left', menu: false, |
219 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
218 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
220 if (value == 0) |
219 var duration = ""; |
221 return "<div style='margin: 4px;' class='jqx-left-align'></div>"; |
220 if (value > 0) { |
222 if (value == 1) |
221 if (value == 1) |
223 return "<div style='margin: 4px;' class='jqx-left-align'>1 minuut</div>"; |
222 duration = "1 minuut"; |
224 if (value < 60) |
223 else if (value < 60) |
225 return "<div style='margin: 4px;' class='jqx-left-align'>"+dataAdapter.formatNumber(value, "f0")+" minuten</div>"; |
224 duration = dataAdapter.formatNumber(value, "f0")+" minuten"; |
226 if (value == 60) |
225 else if (value == 60) |
227 return "<div style='margin: 4px;' class='jqx-left-align'>1 uur</div>"; |
226 duration = "1 uur"; |
228 if (value < 1440) |
227 else if (value < 1440) |
229 return "<div style='margin: 4px;' class='jqx-left-align'>"+dataAdapter.formatNumber(value / 60, "f0")+" uren</div>"; |
228 duration = dataAdapter.formatNumber(value / 60, "f0")+" uren"; |
230 if (value == 1440) |
229 else if (value == 1440) |
231 return "<div style='margin: 4px;' class='jqx-left-align'>1 dag</div>"; |
230 duration = "1 dag"; |
232 return "<div style='margin: 4px;' class='jqx-left-align'>"+dataAdapter.formatNumber(value / 1440, "f0")+" dagen</div>"; |
231 else |
|
232 duration = dataAdapter.formatNumber(value / 1440, "f0")+" dagen"; |
|
233 } |
|
234 return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + duration + "</span>"; |
233 } |
235 } |
234 }, |
236 }, |
235 { text: 'Voorraad', datafield: 'inventory', width: 110, menu: false, align: 'right', cellsalign: 'right', |
237 { text: 'Voorraad', datafield: 'inventory', width: 110, menu: false, align: 'right', |
236 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
238 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
237 if (value == 0) |
239 var amount = ""; |
238 return "<div style='margin: 4px;' class='jqx-right-align'></div>"; |
240 if (value > 0) { |
239 if (rowdata.amount_is_weight) |
241 if (rowdata.amount_is_weight) |
240 return "<div style='margin: 4px;' class='jqx-right-align'>"+dataAdapter.formatNumber(value,"f1")+" gr</div>"; |
242 amount = dataAdapter.formatNumber(value,"f1")+" gr"; |
241 return "<div style='margin: 4px;' class='jqx-right-align'>"+dataAdapter.formatNumber(value,"f1")+" ml</div>"; |
243 else |
|
244 amount = dataAdapter.formatNumber(value,"f1")+" ml"; |
|
245 } |
|
246 return "<span style='margin: 3px; margin-top: 6px; float: right;'>" + amount + "</span>"; |
242 } |
247 } |
243 }, |
248 }, |
244 { text: 'THT datum', datafield: 'tht_date', width: 100, menu: false, align: 'center', cellsalign: 'center' }, |
249 { text: 'THT datum', datafield: 'tht_date', width: 100, menu: false, align: 'center', cellsalign: 'center' }, |
245 { text: 'Wijzig', datafield: 'Edit', columntype: 'button', width: 100, menu: false, align: 'center', cellsrenderer: function () { |
250 { text: '', datafield: 'Edit', columntype: 'button', width: 100, menu: false, align: 'center', cellsrenderer: function () { |
246 return "Wijzig"; |
251 return "Wijzig"; |
247 }, buttonclick: function (row) { |
252 }, buttonclick: function (row) { |
248 // open the popup window when the user clicks a button. |
253 // open the popup window when the user clicks a button. |
249 editrow = row; |
254 editrow = row; |
250 $("#popupWindow").jqxWindow({ position: { x: 110, y: 30 } }); |
255 $("#popupWindow").jqxWindow({ position: { x: 110, y: 30 } }); |