$inwhere = " AND (acc.transdate >= $fromdate)";
} else {
$where .= " AND (ac.transdate >= $fromdate)";
+ # hotfix for projectfilter in guv and bwa
+ # fromdate is otherwise ignored if project is selected
+ $prwhere = " AND (a.transdate >= $fromdate)";
}
}
$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 |;
$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
if ($form->{$ct_id}) {
$where .= qq| AND (ct.id = | . conv_i($form->{$ct_id}) . qq|)|;
} elsif ($form->{ $form->{ct} }) {
- $where .= qq| AND (ct.name ILIKE | . $dbh->quote('%' . $form->{$ct} . '%') . qq|)|;
+ $where .= qq| AND (ct.name ILIKE | . $dbh->quote(like($form->{$ct})) . qq|)|;
}
my $dpt_join;
my $invnumber;
my $reference;
if ($form->{reference}) {
- $reference = $dbh->quote('%' . $form->{reference} . '%');
+ $reference = $dbh->quote(like($form->{reference}));
$invnumber = " AND (a.invnumber LIKE $reference)";
$reference = " AND (a.reference LIKE $reference)";
}
if ($form->{source}) {
- $where .= " AND (ac.source ILIKE " . $dbh->quote('%' . $form->{source} . '%') . ") ";
+ $where .= " AND (ac.source ILIKE " . $dbh->quote(like($form->{source})) . ") ";
}
if ($form->{memo}) {
- $where .= " AND (ac.memo ILIKE " . $dbh->quote('%' . $form->{memo} . '%') . ") ";
+ $where .= " AND (ac.memo ILIKE " . $dbh->quote(like($form->{memo})) . ") ";
}
my %sort_columns = (