$sth->finish;
}
+
+ $query = "SELECT inventory_accno_id FROM defaults";
+ ($form->{"std_inventory_accno_id"}) = $dbh->selectrow_array($query);
+
my $module = "IC";
$query = qq|SELECT c.accno, c.description, c.link, c.id,
d.inventory_accno_id, d.income_accno_id, d.expense_accno_id
$sth->execute || $form->dberror($query);
while (my $ref = $sth->fetchrow_hashref(NAME_lc)) {
foreach my $key (split(/:/, $ref->{link})) {
+ if (!$form->{"std_inventory_accno_id"} && ($key eq "IC")) {
+ $form->{"std_inventory_accno_id"} = $ref->{"id"};
+ }
if ($key =~ /$module/) {
if ( ($ref->{id} eq $ref->{inventory_accno_id})
|| ($ref->{id} eq $ref->{income_accno_id})
description => $ref->{description},
selected => "selected",
id => $ref->{id} };
- } else {
+ } else {
push @{ $form->{"${module}_links"}{$key} },
{ accno => $ref->{accno},
description => $ref->{description},
$query = qq|UPDATE defaults SET closedto = NULL,
revtrans = '1'|;
- } else {
- if ($form->{closedto}) {
+ } elsif ($form->{closedto}) {
- $query = qq|UPDATE defaults SET closedto = '$form->{closedto}',
+ $query = qq|UPDATE defaults SET closedto = '$form->{closedto}',
revtrans = '0'|;
- } else {
+ } else {
- $query = qq|UPDATE defaults SET closedto = NULL,
+ $query = qq|UPDATE defaults SET closedto = NULL,
revtrans = '0'|;
- }
}
# set close in defaults