projekt kivitendo

         WHERE $where $dpt_where

           AND ac.trans_id IN ( SELECT trans_id FROM acc_trans JOIN chart ON (chart_id = id) WHERE (link LIKE '%AR_paid%') $subwhere)

           $project

         UNION

         WHERE $where $dpt_where

           AND ac.trans_id IN ( SELECT trans_id FROM acc_trans JOIN chart ON (chart_id = id) WHERE (link LIKE '%AP_paid%') $subwhere)

           $project

         UNION

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

         JOIN gl a ON (a.id = ac.trans_id)

         $dpt_join

           AND NOT ((c.link = 'AR') OR (c.link = 'AP'))

           $project

         GROUP BY c.$category

         WHERE (c.category = 'I') $prwhere $dpt_where

           AND ac.trans_id IN ( SELECT trans_id FROM acc_trans JOIN chart ON (chart_id = id) WHERE (link LIKE '%AR_paid%') $subwhere)

           $project

         UNION

         WHERE (c.category = 'E') $prwhere $dpt_where

           AND ac.trans_id IN ( SELECT trans_id FROM acc_trans JOIN chart ON (chart_id = id) WHERE (link LIKE '%AP_paid%') $subwhere)

         $project

         |;

    }

    if ($ref->{amount} != 0 || $form->{all_accounts}) {

      $trb{ $ref->{accno} }{description} = $ref->{description};

      $trb{ $ref->{accno} }{charttype}   = 'A';

      if ($ref->{amount} > 0) {

        $trb{ $ref->{accno} }{haben_eb}   = $ref->{amount};

      } else {

               (ac.trans_id in (SELECT id from gl)

                $glwhere)

              )|;

qq| AND ((ac.trans_id IN (SELECT id from ar) AND

                ac.trans_id IN

                  (

               (ac.trans_id in (SELECT id from gl)

                $glsaldowhere)

              )|;

qq| AND ((ac.trans_id IN (SELECT id from ar) AND

                ac.trans_id IN

                  (