projekt kivitendo

  my @headingaccounts = ();

  my $dpt_where;

  my $dpt_where_without_arapgl;

  my $project;

  my $where    = "1 = 1";

                                                 (SELECT department_id FROM gl WHERE gl.id=ac.trans_id),

                                                 (SELECT department_id FROM ap WHERE ap.id=ac.trans_id)) = | . conv_i($department_id);

  }

  # project_id only applies to getting transactions

  # it has nothing to do with a trial balance

      my $min_max = $prefix eq 'from' ? 'min' : 'max';

      $query      = qq|SELECT ${min_max}(transdate)

                       FROM acc_trans ac

                       WHERE (1 = 1)

                         $dpt_where_without_arapgl

                         $project|;

      ($form->{"${prefix}date"}) = selectfirst_array_query($form, $dbh, $query);

    }

      qq|SELECT c.accno, c.category, SUM(ac.amount) AS amount, c.description

          FROM acc_trans ac

          LEFT 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

            $dpt_where_without_arapgl

            $project

          GROUP BY c.accno, c.category, c.description |;

       SELECT c.accno, c.description, c.category, SUM(ac.amount) AS amount

       FROM acc_trans ac

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

       WHERE $where

         $dpt_where_without_arapgl

         $project

      JOIN chart c ON (p.income_accno_id = c.id)

      WHERE $invwhere

        $dpt_where

        $project

      GROUP BY c.accno, c.description, c.category

      JOIN chart c ON (p.expense_accno_id = c.id)

      WHERE $invwhere

        $dpt_where

        $project

      GROUP BY c.accno, c.description, c.category

      |;

         (SELECT SUM(ac.amount) * -1

          FROM acc_trans ac

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

          WHERE $where

            $dpt_where_without_arapgl

            $project

          AND (ac.amount < 0)

          AND (c.accno = ?)) AS debit,

         (SELECT SUM(ac.amount)

          FROM acc_trans ac

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

          WHERE $where

            $dpt_where_without_arapgl

            $project

          AND ac.amount > 0

          AND c.accno = ?) AS credit,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $saldowhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ? AND (NOT ac.ob_transaction OR ac.ob_transaction IS NULL)) AS saldo,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $sumwhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ?) AS sum_credit,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $sumwhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ?) AS sum_debit,

        (SELECT max(ac.transdate) FROM acc_trans ac

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

        WHERE $where

          $dpt_where_without_arapgl

          $project

        AND c.accno = ?) AS last_transaction

           JOIN chart c ON (p.expense_accno_id = c.id)

           WHERE $invwhere

             $dpt_where

             $project

           AND c.accno = ?) AS debit,

           JOIN chart c ON (p.income_accno_id = c.id)

           WHERE $invwhere

             $dpt_where

             $project

           AND c.accno = ?) AS credit,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $saldowhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ? AND (NOT ac.ob_transaction OR ac.ob_transaction IS NULL)) AS saldo,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $sumwhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ?) AS sum_credit,

        (SELECT SUM(ac.amount)

         FROM acc_trans ac

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

         WHERE $sumwhere

           $dpt_where_without_arapgl

           $project

         AND c.accno = ?) AS sum_debit,

        (SELECT max(ac.transdate) FROM acc_trans ac

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

        WHERE $where

          $dpt_where_without_arapgl

          $project

        AND c.accno = ?) AS last_transaction

 |;

use SL::DB::Default;

use SL::DB::Project;

use SL::PE;

use SL::RP;

use SL::Iconv;

  );

  $::form->{title} = $title{$::form->{report}};

  # get departments

  $::form->all_departments(\%::myconfig);

  $form->{company} = $locale->text('Company') . " " . $defaults->company;

  push (@options, $form->{company});

  $form->{template_to} = $locale->date(\%myconfig, $form->{todate}, 0);

    </td>

  </tr>

[%- END %]

[%- BLOCK projectnumber %]

  <tr>

    <th align=right nowrap>[% 'Project' | $T8 %]</th>

[%- END %]

[%- IF is_trial_balance %]

[%- PROCESS projectnumber %]

  <input type=hidden name=nextsub value=generate_trial_balance>

</table>