Revision 5b2980ad
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
SL/IC.pm | ||
---|---|---|
70 | 70 |
|
71 | 71 |
$form->{onhand} *= 1; |
72 | 72 |
|
73 |
my %oid = ('Pg' => 'a.oid', |
|
74 |
'Oracle' => 'a.rowid'); |
|
75 |
|
|
76 | 73 |
# part or service item |
77 | 74 |
$form->{item} = ($form->{inventory_accno}) ? 'part' : 'service'; |
78 | 75 |
if ($form->{assembly}) { |
... | ... | |
88 | 85 |
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) |
89 | 86 |
LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id |
90 | 87 |
WHERE (a.id = ?) |
91 |
ORDER BY $oid{$myconfig->{dbdriver}}|;
|
|
88 |
ORDER BY a.oid|;
|
|
92 | 89 |
$sth = prepare_execute_query($form, $dbh, $query, conv_i($form->{id})); |
93 | 90 |
|
94 | 91 |
$form->{assembly_rows} = 0; |
Auch abrufbar als: Unified diff
Oracle Support entfernt.