$customer_join
WHERE ((select date_trunc('year', ac.transdate::date)) = (select date_trunc('year', ?::date))) AND ac.ob_transaction
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
GROUP BY c.accno, c.category, c.description |;
}
$sth->finish;
- if (!$form->{method} ne "cash") {
+ if ($form->{method} ne "cash") { # better eq 'accrual'
$sth = prepare_execute_query($form, $dbh, $fetch_accounts_before_from);
while ($ref = $sth->fetchrow_hashref("NAME_lc")) {
$trb{ $ref->{accno} }{description} = $ref->{description};
$customer_join
WHERE $where
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND (ac.amount < 0)
$customer_join
WHERE $where
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND ac.amount > 0
$customer_join
WHERE $saldowhere
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND c.accno = ? AND (NOT ac.ob_transaction OR ac.ob_transaction IS NULL)) AS saldo,
$customer_join
WHERE $sumwhere
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND ac.amount > 0
$customer_join
WHERE $sumwhere
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND ac.amount < 0
$customer_join
WHERE $where
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND c.accno = ?) AS last_transaction
$customer_join
WHERE $where
$dpt_where_without_arapgl
- $dpt_where
$customer_where
$project
AND c.accno = ?) AS last_transaction
my ($inclusion);
if ($category eq 'I') {
- $inclusion = "AND pos_eur = NULL OR pos_eur > '0' AND pos_eur <= '5'";
+ $inclusion = "AND pos_er = NULL OR pos_er > '0' AND pos_er <= '5'";
} elsif ($category eq 'E') {
- $inclusion = "AND pos_eur = NULL OR pos_eur >= '6' AND pos_eur < '100'";
+ $inclusion = "AND pos_er = NULL OR pos_er >= '6' AND pos_er < '100'";
} else {
$inclusion = "";
}