//----------------------------------------------------------------------------------------------------
-// trial_inquiry_controls();
print_list_of_journal_entries();
//----------------------------------------------------------------------------------------------------
{
global $path_to_root;
- include_once($path_to_root . "/reporting/includes/pdf_report.inc");
-
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$systype = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
+ $destination = $_POST['PARAM_4'];
+ if ($destination)
+ include_once($path_to_root . "/reporting/includes/excel_report.inc");
+ else
+ include_once($path_to_root . "/reporting/includes/pdf_report.inc");
+
$dec = user_price_dec();
$cols = array(0, 100, 240, 300, 400, 460, 520, 580);
2 => array('text' => _('Type'), 'from' => systypes::name($systype),
'to' => ''));
- $rep = new FrontReport(_('List of Journal Entries'), "JournalEntries.pdf", user_pagesize());
+ $rep = new FrontReport(_('List of Journal Entries'), "JournalEntries", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$trans = get_gl_transactions($from, $to, -1, null, 0, 0, $systype);
- $typeno = 0;
+ $typeno = $type = 0;
while ($myrow=db_fetch($trans))
{
- if ($typeno != $myrow['type_no'])
+ if ($type != $myrow['type'] || $typeno != $myrow['type_no'])
{
if ($typeno != 0)
{
$rep->NewLine();
}
$typeno = $myrow['type_no'];
+ $type = $myrow['type'];
$TransName = systypes::name($myrow['type']);
$rep->TextCol(0, 2, $TransName . " # " . $myrow['type_no']);
- $rep->TextCol(2, 3, sql2date($myrow['tran_date']));
+ $rep->DateCol(2, 3, $myrow['tran_date'], true);
$coms = payment_person_types::person_name($myrow["person_type_id"],$myrow["person_id"]);
$memo = get_comments_string($myrow['type'], $myrow['type_no']);
if ($memo != '')
$rep->TextCol(2, 3, $dim_str);
$rep->TextCol(3, 4, $myrow['memo_']);
if ($myrow['amount'] > 0.0)
- $rep->TextCol(4, 5, number_format2(abs($myrow['amount']), $dec));
+ $rep->AmountCol(4, 5, abs($myrow['amount']), $dec);
else
- $rep->TextCol(5, 6, number_format2(abs($myrow['amount']), $dec));
+ $rep->AmountCol(5, 6, abs($myrow['amount']), $dec);
$rep->NewLine(1, 2);
}
$rep->Line($rep->row + 4);