$query .= qq|
UNION ALL
-
+
SELECT a.id, a.invnumber, c.name, a.transdate,
a.invoice, ac.sellprice, 'ar' as module
FROM ar a
$todate_where
$dpt_where
$project
-
+
UNION ALL
-
+
SELECT a.id, a.invnumber, v.name, a.transdate,
a.invoice, ac.sellprice, 'ap' as module
FROM ap a
}
1;
-