comparison: www/js/prod_inprod.js
www/js/prod_inprod.js
- changeset 321
- 4116e6184609
- parent 286
- 124af734af68
- child 324
- d49da6d0b451
equal
deleted
inserted
replaced
| 320:f71bb1104375 | 321:4116e6184609 |
|---|---|
| 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: 'birth', type: 'string' }, | 32 { name: 'birth', type: 'string' }, |
| 33 { name: 'stage', type: 'int' }, | 33 { name: 'stage', type: 'int' }, |
| 34 { name: 'brew_date', type: 'string' }, | |
| 35 { name: 'package_date', type: 'string' }, | |
| 34 ], | 36 ], |
| 35 id: 'record', | 37 id: 'record', |
| 36 url: "includes/db_product.php?select=inprod" | 38 url: "includes/db_product.php?select=inprod" |
| 37 }; | 39 }; |
| 38 var dataAdapter = new $.jqx.dataAdapter(source); | 40 var dataAdapter = new $.jqx.dataAdapter(source); |
| 57 }, | 59 }, |
| 58 columns: [ | 60 columns: [ |
| 59 { text: 'Datum', datafield: 'birth', width: 120 }, | 61 { text: 'Datum', datafield: 'birth', width: 120 }, |
| 60 { text: 'Code', datafield: 'code', width: 120 }, | 62 { text: 'Code', datafield: 'code', width: 120 }, |
| 61 { text: 'Naam', datafield: 'name' }, | 63 { text: 'Naam', datafield: 'name' }, |
| 62 { text: 'Fase', datafield: 'stage', width: 130, | 64 { text: 'Fase', datafield: 'stage', width: 200, |
| 63 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { | 65 cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) { |
| 64 return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + StageData[value].nl + "</span>"; | 66 // 2 = brew, 6 = package, 7 = carbonation, 8 = mature, 9 = taste |
| 67 var fase = StageData[value].nl; | |
| 68 if (value == 2) { | |
| 69 fase = StageData[value].nl + " op " + rowdata.brew_date; | |
| 70 } | |
| 71 if (value >= 6 && value < 9) { | |
| 72 var d = new Date(); | |
| 73 var date2 = rowdata.package_date; | |
| 74 date2 = date2.split('-'); | |
| 75 // Now we convert the array to a Date object | |
| 76 date1 = new Date(d.getFullYear(), d.getMonth(), d.getDate()); | |
| 77 date2 = new Date(date2[0], date2[1]-1, date2[2]); | |
| 78 // We use the getTime() method and get the unixtime | |
| 79 date1_unixtime = parseInt(date1.getTime() / 1000); | |
| 80 date2_unixtime = parseInt(date2.getTime() / 1000); | |
| 81 // This is the calculated difference in seconds | |
| 82 var timeDifference = date1_unixtime - date2_unixtime; | |
| 83 var timeDifferenceInDays = timeDifference / 60 / 60 / 24; | |
| 84 if (timeDifferenceInDays >= 14) | |
| 85 fase = StageData[value].nl + " dag " + (timeDifferenceInDays - 14) + " van 42"; | |
| 86 else | |
| 87 fase = StageData[value].nl + " dag " + timeDifferenceInDays + " van 14"; | |
| 88 } | |
| 89 return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + fase + "</span>"; | |
| 65 } | 90 } |
| 66 }, | 91 }, |
| 67 { text: '', datafield: 'Edit', width: 100, align: 'center', columntype: 'button', cellsrenderer: function () { | 92 { text: '', datafield: 'Edit', width: 100, align: 'center', columntype: 'button', cellsrenderer: function () { |
| 68 return "Wijzig"; | 93 return "Wijzig"; |
| 69 }, buttonclick: function (row) { | 94 }, buttonclick: function (row) { |
