projekt kivitendo

        qq|SELECT SUM(ac.amount) AS amount

            FROM acc_trans ac

            JOIN chart c ON (ac.chart_id = c.id)

            WHERE ((select date_trunc('year', ac.transdate::date)) = (select date_trunc('year', ?::date))) AND ac.ob_transaction

              $project

            AND c.accno = ? $acc_cash_where|;