Wed, 30 Jun 2021 23:09:31 +0200
Added HCO3 to the water summary. Changed some water chemicals limits to new insights.
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | /***************************************************************************** |
690
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
2 | * Copyright (C) 2014-2020 |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | * |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | * Michiel Broek <mbroek at mbse dot eu> |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | * |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
6 | * This file is part of Brewery Management System |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
7 | * |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | * This is free software; you can redistribute it and/or modify it |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | * under the terms of the GNU General Public License as published by the |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | * Free Software Foundation; either version 2, or (at your option) any |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | * later version. |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | * |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | * BrewCloud is distributed in the hope that it will be useful, but |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | * WITHOUT ANY WARRANTY; without even the implied warranty of |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | * General Public License for more details. |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | * |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | * You should have received a copy of the GNU General Public License |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | * along with ThermFerm; see the file COPYING. If not, write to the Free |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | *****************************************************************************/ |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
24 | function createDelElements() { |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
25 | $('#eventWindow').jqxWindow({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
26 | theme: theme, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
27 | position: { x: 490, y: 210 }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
28 | width: 300, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
29 | height: 175, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
30 | resizable: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
31 | isModal: true, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
32 | modalOpacity: 0.4, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
33 | okButton: $('#delOk'), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
34 | cancelButton: $('#delCancel'), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
35 | initContent: function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
36 | $('#delOk').jqxButton({ template: 'danger', width: '65px', theme: theme }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
37 | $('#delCancel').jqxButton({ template: 'success', width: '65px', theme: theme }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
38 | $('#delCancel').focus(); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
39 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
40 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
41 | $('#eventWindow').jqxWindow('hide'); |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | } |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
45 | $(document).ready(function() { |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
46 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
47 | function calcTotal(cost, inventory) { |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
48 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
49 | $('#totval').val(cost * (inventory / 1000)); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
50 | } |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
51 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
52 | function prompts(isweight) { |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
53 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
54 | if (isweight) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
55 | $('#pmpt_cost').html('Prijs per kg:'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
56 | $('#pmpt_inventory').html('Voorraad gram:'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
57 | } else { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
58 | $('#pmpt_cost').html('Prijs per liter:'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
59 | $('#pmpt_inventory').html('Voorraad ml:'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
60 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
61 | } |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
62 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
63 | var dataRecord = {}, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
64 | url = 'includes/db_inventory_miscs.php', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
65 | // prepare the data |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
66 | source = { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
67 | datatype: 'json', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
68 | cache: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
69 | datafields: [ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
70 | { name: 'record', type: 'number' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
71 | { name: 'name', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
72 | { name: 'type', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
73 | { name: 'use_use', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
74 | { name: 'time', type: 'int' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
75 | { name: 'amount', type: 'float' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
76 | { name: 'amount_is_weight', type: 'int' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
77 | { name: 'use_for', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
78 | { name: 'notes', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
79 | { name: 'always_on_stock', type: 'int' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
80 | { name: 'inventory', type: 'float' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
81 | { name: 'cost', type: 'float' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
82 | { name: 'production_date', type: 'string' }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
83 | { name: 'tht_date', type: 'string' } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
84 | ], |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
85 | id: 'record', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
86 | url: url, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
87 | deleterow: function(rowid, commit) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
88 | // synchronize with the server - send delete command |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
89 | var data = 'delete=true&' + $.param({ record: rowid }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
90 | $.ajax({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
91 | dataType: 'json', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
92 | url: url, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
93 | cache: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
94 | data: data, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
95 | type: 'POST', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
96 | success: function(data, status, xhr) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
97 | commit(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
98 | location.reload(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
99 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
100 | error: function(jqXHR, textStatus, errorThrown) { commit(false); } |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
101 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
102 | }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
103 | addrow: function(rowid, rowdata, position, commit) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
104 | var data = 'insert=true&' + $.param(rowdata); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
105 | $.ajax({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
106 | dataType: 'json', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
107 | url: url, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
108 | cache: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
109 | data: data, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
110 | type: 'POST', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
111 | success: function(data, status, xhr) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
112 | commit(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
113 | location.reload(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
114 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
115 | error: function(jqXHR, textStatus, errorThrown) { commit(false); } |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
116 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
117 | }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
118 | updaterow: function(rowid, rowdata, commit) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
119 | var data = 'update=true&' + $.param(rowdata); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
120 | $.ajax({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
121 | dataType: 'json', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
122 | url: url, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
123 | cache: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
124 | data: data, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
125 | type: 'POST', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
126 | success: function(data, status, xhr) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
127 | commit(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
128 | location.reload(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
129 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
130 | error: function(jqXHR, textStatus, errorThrown) { commit(false); } |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
131 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
132 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
133 | }, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
134 | dataAdapter = new $.jqx.dataAdapter(source), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
135 | editrow = -1; |
488
77f1617b6994
Fixed inventory databases race conditions
Michiel Broek <mbroek@mbse.eu>
parents:
395
diff
changeset
|
136 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
137 | // initialize the input fields. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
138 | $('#name').jqxInput({ theme: theme, width: 640, height: 23 }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
139 | $('#notes').jqxInput({ theme: theme, width: 800, height: 100 }); |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
140 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
141 | $('#type').jqxDropDownList({theme: theme, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
142 | source: MiscTypeAdapter, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
143 | valueMember: 'nl', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
144 | displayMember: 'nl', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
145 | width: 180, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
146 | height: 23, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
147 | autoDropDownHeight: true |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
148 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
149 | $('#use_use').jqxDropDownList({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
150 | theme: theme, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
151 | source: MiscUseAdapter, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
152 | valueMember: 'nl', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
153 | displayMember: 'nl', |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
154 | width: 180, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
155 | height: 23, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
156 | autoDropDownHeight: true |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
157 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
158 | $('#time').jqxNumberInput(PosInt); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
159 | $('#amount_is_weight').jqxCheckBox({ theme: theme, width: 120, height: 23 }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
160 | $('#use_for').jqxInput({ theme: theme, width: 640, height: 48 }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
161 | $('#always_on_stock').jqxCheckBox({ theme: theme, width: 120, height: 23 }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
162 | $('#inventory').jqxNumberInput(Spin1dec); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
163 | $('#production_date').jqxDateTimeInput(Dateopts); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
164 | $('#cost').jqxNumberInput(Spin2dec); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
165 | $('#tht_date').jqxDateTimeInput(Dateopts); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
166 | $('#totval').jqxNumberInput(Show2dec); |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
167 | |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
168 | var localizationobj = {}; |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
169 | localizationobj.filterchoosestring= "Keuze:"; |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
170 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
171 | // initialize jqxGrid |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
172 | $('#jqxgrid').jqxGrid({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
173 | width: 1280, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
174 | height: 630, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
175 | source: dataAdapter, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
176 | theme: theme, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
177 | showstatusbar: true, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
178 | renderstatusbar: function(statusbar) { |
702
f0896a6f9b64
Add total count in the statusbar for inventory and profile databases.
Michiel Broek <mbroek@mbse.eu>
parents:
701
diff
changeset
|
179 | var rowCount = $("#jqxgrid").jqxGrid('getrows').length; |
f0896a6f9b64
Add total count in the statusbar for inventory and profile databases.
Michiel Broek <mbroek@mbse.eu>
parents:
701
diff
changeset
|
180 | statusbar.append('<div style="float: left; margin: 8px; color: orange !important;">Aantal items: ' + rowCount + '</div>'); |
690
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
181 | var container = $('<div style="overflow: hidden; position: relative; margin: 5px;"></div>'); |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
182 | var addButton = $('<div style="float: right; margin-right: 15px;"><img style="position: relative; margin-top: 2px;" ' + |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
183 | 'src="images/add.png"/><span style="margin-left: 4px; position: relative; top: -4px;">Nieuw</span></div>'); |
690
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
184 | var impButton = $('<div style="float: right; margin-right: 50px;"><img style="position: relative; margin-top: 2px;" ' + |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
185 | 'src="images/add.png"/><span style="margin-left: 4px; position: relative; top: -4px;">Import</span></div>'); |
690
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
186 | var expButton = $('<div style="float: right; margin-right: 50px;"><img style="position: relative; margin-top: 2px;" ' + |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
187 | 'src="images/database.png"/><span style="margin-left: 4px; position: relative; top: -10px;">Export</span></div>'); |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
188 | container.append(addButton); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
189 | container.append(impButton); |
563
acdd54144838
Added export inventory and profiles in beerxml format. Small fixes in beerxml recipe and product export.
Michiel Broek <mbroek@mbse.eu>
parents:
528
diff
changeset
|
190 | container.append(expButton); |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
191 | statusbar.append(container); |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
192 | addButton.jqxButton({ theme: theme, width: 90, height: 17 }); |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
193 | impButton.jqxButton({ theme: theme, width: 90, height: 17 }); |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
194 | expButton.jqxButton({ theme: theme, width: 90, height: 17 }); |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
195 | // add new row. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
196 | addButton.click(function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
197 | editrow = -1; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
198 | $('#popupWindow').jqxWindow({ position: { x: 110, y: 30 } }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
199 | $('#name').val(''); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
200 | $('#type').val('Specerij'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
201 | $('#use_use').val('Starter'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
202 | $('#time').val(0); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
203 | $('#amount_is_weight').val(1); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
204 | $('#use_for').val(''); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
205 | $('#notes').val(''); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
206 | $('#always_on_stock').val(0); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
207 | $('#inventory').val(0); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
208 | $('#cost').val(0); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
209 | $('#production_date').val(''); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
210 | $('#tht_date').val(''); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
211 | $('#popupWindow').jqxWindow('open'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
212 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
213 | impButton.click(function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
214 | window.location.href = 'import_ingredients.php?select=miscs'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
215 | }); |
563
acdd54144838
Added export inventory and profiles in beerxml format. Small fixes in beerxml recipe and product export.
Michiel Broek <mbroek@mbse.eu>
parents:
528
diff
changeset
|
216 | expButton.click(function(event) { |
acdd54144838
Added export inventory and profiles in beerxml format. Small fixes in beerxml recipe and product export.
Michiel Broek <mbroek@mbse.eu>
parents:
528
diff
changeset
|
217 | window.open('export_miscs.php'); |
acdd54144838
Added export inventory and profiles in beerxml format. Small fixes in beerxml recipe and product export.
Michiel Broek <mbroek@mbse.eu>
parents:
528
diff
changeset
|
218 | }); |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
219 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
220 | ready: function () { |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
221 | $("#jqxgrid").jqxGrid('localizestrings', localizationobj); |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
222 | }, |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
223 | filterable: true, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
224 | showfilterrow: true, |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
225 | columns: [ |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
226 | { text: 'Ingredient naam', datafield: 'name', filtertype: 'textbox' }, |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
227 | { text: 'Type', datafield: 'type', align: 'left', width: 120, filtertype: 'list' }, |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
228 | { text: 'Gebruik', datafield: 'use_use', align: 'left', width: 120, filtertype: 'list' }, |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
229 | { text: 'Tijd', datafield: 'time', width: 90, align: 'left', filterable: false, |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
230 | cellsrenderer: function(index, datafield, value, defaultvalue, column, rowdata) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
231 | var duration = ''; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
232 | if (value > 0) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
233 | if (value == 1) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
234 | duration = '1 minuut'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
235 | else if (value < 60) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
236 | duration = dataAdapter.formatNumber(value, 'f0') + ' minuten'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
237 | else if (value == 60) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
238 | duration = '1 uur'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
239 | else if (value < 1440) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
240 | duration = dataAdapter.formatNumber(value / 60, 'f0') + ' uren'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
241 | else if (value == 1440) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
242 | duration = '1 dag'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
243 | else |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
244 | duration = dataAdapter.formatNumber(value / 1440, 'f0') + ' dagen'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
245 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
246 | return '<span style="margin: 3px; margin-top: 6px; float: left;">' + duration + '</span>'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
247 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
248 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
249 | { text: 'Voorraad', datafield: 'inventory', width: 110, align: 'right', filtertype: 'number', filtercondition: 'not_equal', |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
250 | cellsrenderer: function(index, datafield, value, defaultvalue, column, rowdata) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
251 | var amount = ''; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
252 | if (value > 0) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
253 | if (rowdata.amount_is_weight) |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
254 | amount = dataAdapter.formatNumber(value, 'f1') + ' gr'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
255 | else |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
256 | amount = dataAdapter.formatNumber(value, 'f1') + ' ml'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
257 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
258 | return '<span style="margin: 3px; margin-top: 6px; float: right;">' + amount + '</span>'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
259 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
260 | }, |
701
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
261 | { text: 'THT datum', datafield: 'tht_date', width: 100, align: 'center', cellsalign: 'center', filtertype: 'date' }, |
3ce3df681be0
Changed inventory and profile databases filtering.
Michiel Broek <mbroek@mbse.eu>
parents:
690
diff
changeset
|
262 | { text: '', datafield: 'Edit', columntype: 'button', width: 100, align: 'center', filterable: false, |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
263 | cellsrenderer: function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
264 | return 'Wijzig'; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
265 | }, buttonclick: function(row) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
266 | // open the popup window when the user clicks a button. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
267 | editrow = row; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
268 | $('#popupWindow').jqxWindow({ position: { x: 110, y: 30 } }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
269 | // get the clicked row's data and initialize the input fields. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
270 | dataRecord = $('#jqxgrid').jqxGrid('getrowdata', editrow); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
271 | $('#name').val(dataRecord.name); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
272 | $('#type').val(dataRecord.type); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
273 | $('#use_use').val(dataRecord.use_use); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
274 | $('#time').val(dataRecord.time); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
275 | $('#amount_is_weight').val(dataRecord.amount_is_weight); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
276 | $('#use_for').val(dataRecord.use_for); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
277 | $('#notes').val(dataRecord.notes); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
278 | $('#always_on_stock').val(dataRecord.always_on_stock); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
279 | $('#inventory').val(dataRecord.inventory); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
280 | $('#cost').val(dataRecord.cost); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
281 | $('#production_date').val(dataRecord.production_date); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
282 | $('#tht_date').val(dataRecord.tht_date); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
283 | calcTotal(dataRecord.cost, dataRecord.inventory); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
284 | prompts(dataRecord.amount_is_weight); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
285 | // show the popup window. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
286 | $('#popupWindow').jqxWindow('open'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
287 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
288 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
289 | ] |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
290 | }); |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
291 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
292 | $('#cost').on('change', function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
293 | dataRecord.cost = parseFloat(event.args.value); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
294 | calcTotal(dataRecord.cost, dataRecord.inventory); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
295 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
296 | $('#inventory').on('change', function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
297 | dataRecord.inventory = parseFloat(event.args.value); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
298 | calcTotal(dataRecord.cost, dataRecord.inventory); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
299 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
300 | $('#amount_is_weight').on('checked', function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
301 | dataRecord.amount_is_weight = true; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
302 | prompts(true); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
303 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
304 | $('#amount_is_weight').on('unchecked', function(event) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
305 | dataRecord.amount_is_weight = false; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
306 | prompts(false); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
307 | }); |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
308 | |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
309 | // initialize the popup window and buttons. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
310 | $('#popupWindow').jqxWindow({ |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
311 | width: 1050, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
312 | height: 550, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
313 | resizable: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
314 | theme: theme, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
315 | isModal: true, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
316 | autoOpen: false, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
317 | cancelButton: $('#Cancel'), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
318 | modalOpacity: 0.40 |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
319 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
320 | $('#popupWindow').on('open', function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
321 | $('#name').jqxInput('selectAll'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
322 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
323 | $('#Delete').jqxButton({ template: 'danger', width: '90px', theme: theme }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
324 | $('#Delete').click(function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
325 | if (editrow >= 0) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
326 | // Open a popup to confirm this action. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
327 | $('#eventWindow').jqxWindow('open'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
328 | $('#delOk').click(function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
329 | var rowID = $('#jqxgrid').jqxGrid('getrowid', editrow); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
330 | $('#jqxgrid').jqxGrid('deleterow', rowID); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
331 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
332 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
333 | $('#popupWindow').jqxWindow('hide'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
334 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
335 | $('#Cancel').jqxButton({ template: 'primary', width: '90px', theme: theme }); |
690
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
336 | $('#Clone').jqxButton({ template: 'warning', width: '90px', theme: theme }); |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
337 | $('#Clone').click(function() { |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
338 | var row = { |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
339 | record: -1, |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
340 | name: $('#name').val() + ' kopie', |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
341 | type: $('#type').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
342 | use_use: $('#use_use').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
343 | time: parseFloat($('#time').jqxNumberInput('decimal')), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
344 | amount_is_weight: $('#amount_is_weight').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
345 | use_for: $('#use_for').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
346 | notes: $('#notes').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
347 | always_on_stock: $('#always_on_stock').val(), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
348 | inventory: 0, |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
349 | cost: parseFloat($('#cost').jqxNumberInput('decimal')), |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
350 | production_date: '', |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
351 | tht_date: '' |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
352 | }; |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
353 | $('#jqxgrid').jqxGrid('addrow', null, row); |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
354 | $('#popupWindow').jqxWindow('hide'); |
10ff024acff1
In inventory miscs added the clone option.
Michiel Broek <mbroek@mbse.eu>
parents:
563
diff
changeset
|
355 | }); |
528
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
356 | $('#Save').jqxButton({ template: 'success', width: '90px', theme: theme }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
357 | // update the edited row when the user clicks the 'Save' button. |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
358 | $('#Save').click(function() { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
359 | var row, rowID = -1; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
360 | if (editrow >= 0) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
361 | rowID = $('#jqxgrid').jqxGrid('getrowid', editrow); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
362 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
363 | row = { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
364 | record: rowID, |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
365 | name: $('#name').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
366 | type: $('#type').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
367 | use_use: $('#use_use').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
368 | time: parseFloat($('#time').jqxNumberInput('decimal')), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
369 | amount_is_weight: $('#amount_is_weight').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
370 | use_for: $('#use_for').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
371 | notes: $('#notes').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
372 | always_on_stock: $('#always_on_stock').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
373 | inventory: parseFloat($('#inventory').jqxNumberInput('decimal')), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
374 | cost: parseFloat($('#cost').jqxNumberInput('decimal')), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
375 | production_date: $('#production_date').val(), |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
376 | tht_date: $('#tht_date').val() |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
377 | }; |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
378 | if (editrow >= 0) { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
379 | $('#jqxgrid').jqxGrid('updaterow', rowID, row); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
380 | } else { |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
381 | $('#jqxgrid').jqxGrid('addrow', null, row); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
382 | } |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
383 | $('#popupWindow').jqxWindow('hide'); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
384 | }); |
202272a28052
Code cleanup and manual compress
Michiel Broek <mbroek@mbse.eu>
parents:
514
diff
changeset
|
385 | createDelElements(); |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
386 | }); |
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
387 |