}
- $query = "SELECT inventory_accno_id FROM defaults";
- ($form->{"std_inventory_accno_id"}) = $dbh->selectrow_array($query);
+ $query = "SELECT inventory_accno_id, income_accno_id, expense_accno_id ".
+ "FROM defaults";
+ ($form->{"std_inventory_accno_id"}, $form->{"std_income_accno_id"},
+ $form->{"std_expense_accno_id"}) = $dbh->selectrow_array($query);
my $module = "IC";
$query = qq|SELECT c.accno, c.description, c.link, c.id,
servicenumber = '$form->{servicenumber}',
yearend = '$form->{yearend}',
curr = '$form->{curr}',
- weightunit = '$form->{weightunit}',
businessnumber = '$form->{businessnumber}'
|;
$dbh->do($query) || $form->dberror($query);
my $units = $self->retrieve_units(\%main::myconfig, $form);
my $h = $units->{$unit}->{"LANGUAGES"}->{$template_code};
- $main::lxdebug->dump(0, "klaus", $h);
my $new_unit = $unit;
if ($h) {
if (($amount != 1) && $h->{"localized_plural"}) {
$dbh->do($query) || $form->dberror($query);
if ($delete_units && (0 != scalar(@{$delete_units}))) {
- $query = "DELETE FROM units WHERE name = (";
+ $query = "DELETE FROM units WHERE name IN (";
map({ $query .= "?," } @{$delete_units});
substr($query, -1, 1) = ")";
- $dbh->do($query, undef, @{$delete_units}) || $form->dberror($query . " ($_)");
+ $dbh->do($query, undef, @{$delete_units}) ||
+ $form->dberror($query . " (" . join(", ", @{$delete_units}) . ")");
}
$query = "UPDATE units SET name = ?, base_unit = ?, factor = ? WHERE name = ?";