projekt kivitendo

      $query .=

        qq| UNION | .

        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .

        $pg_select .

        $main_cp_select .

        qq|, a.invnumber, a.ordnumber, a.quonumber, a.id AS invid, | .

        qq|LEFT JOIN business b ON (ct.business_id = b.id) | .

        qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .

        qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .

        $pg_join .

        qq|WHERE $where AND (a.invoice = '1')|;

    }

      $query .=

        qq| UNION | .

        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .

        $pg_select .

        $main_cp_select .

        qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | .

        qq|LEFT JOIN business b ON (ct.business_id = b.id) | .

        qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .

        qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .

        $pg_join .

        qq|WHERE $where AND ((o.record_type = 'sales_order') OR (o.record_type = 'purchase_order'))|;

    }

      $query .=

        qq| UNION | .

        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .

        $pg_select .

        $main_cp_select .

        qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | .

        qq|LEFT JOIN business b ON (ct.business_id = b.id) | .

        qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .

        qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .

        $pg_join .

        qq|WHERE $where AND ((o.record_type = 'sales_quotation') OR (o.record_type = 'request_quotation'))|;

    }