Revision 52cec5bf
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
SL/DB/MetaSetup/Part.pm | ||
---|---|---|
31 | 31 |
notes => { type => 'text' }, |
32 | 32 |
obsolete => { type => 'boolean', default => 'false', not_null => 1 }, |
33 | 33 |
onhand => { type => 'numeric', default => '0', precision => 25, scale => 5 }, |
34 |
order_qty => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, |
|
34 | 35 |
part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment' ], db_type => 'part_type_enum', not_null => 1 }, |
35 | 36 |
partnumber => { type => 'text', not_null => 1 }, |
36 | 37 |
partsgroup_id => { type => 'integer' }, |
locale/de/all | ||
---|---|---|
2594 | 2594 |
'Order Date missing!' => 'Auftragsdatum fehlt!', |
2595 | 2595 |
'Order Number' => 'Auftragsnummer', |
2596 | 2596 |
'Order Number missing!' => 'Auftragsnummer fehlt!', |
2597 |
'Order Size' => 'Bestellmenge', |
|
2597 | 2598 |
'Order amount' => 'Auftragswert', |
2598 | 2599 |
'Order data' => 'Auftragsinformationen', |
2599 | 2600 |
'Order deleted!' => 'Auftrag gelöscht!', |
locale/en/all | ||
---|---|---|
2593 | 2593 |
'Order Date missing!' => '', |
2594 | 2594 |
'Order Number' => '', |
2595 | 2595 |
'Order Number missing!' => '', |
2596 |
'Order Size' => '', |
|
2596 | 2597 |
'Order amount' => '', |
2597 | 2598 |
'Order data' => '', |
2598 | 2599 |
'Order deleted!' => '', |
sql/Pg-upgrade2/add_parts_order_qty.sql | ||
---|---|---|
1 |
-- @tag: add_parts_order_qty |
|
2 |
-- @description: Bestellmenge für Artikel |
|
3 |
-- @depends: release_3_8_0 |
|
4 |
-- @ignore: 0 |
|
5 |
|
|
6 |
ALTER TABLE parts ADD COLUMN |
|
7 |
order_qty numeric(15, 5) NOT NULL DEFAULT 0; |
templates/webpages/part/_basic_data.html | ||
---|---|---|
160 | 160 |
<th align="right" nowrap="true">[% 'ROP' | $T8 %]</th> |
161 | 161 |
<td>[% L.input_tag("part.rop_as_number", SELF.part.rop_as_number, size=10, class="reformat_number numeric") %]</td> |
162 | 162 |
</tr> |
163 |
<tr> |
|
164 |
<th align="right" nowrap="true">[% 'Order Size' | $T8 %]</th> |
|
165 |
<td>[% L.input_tag("part.order_qty_as_number", SELF.part.order_qty_as_number, size=10, class="numeric") %]</td> |
|
166 |
</tr> |
|
163 | 167 |
[% IF SELF.all_warehouses.size %] |
164 | 168 |
<tr> |
165 | 169 |
<th align="right" nowrap="true">[% 'Default Warehouse' | $T8 %]</th> |
Auch abrufbar als: Unified diff
Part: Bestellmenge hinzugefügt