$periodto_id = $_POST['periodto_id'];
$reportlevel = $_POST['reportlevel'];
$showzero = $_POST['showzero'];
$showaccountcode = $_POST['showaccountcode'];
$period = new Period();
if ($period->fetchPeriod($periodfrom_id)) {
$header[1] = $period->period_name;
} else {
$header[1] = "Unknown";
}
if ($period->fetchPeriod($periodto_id)) {
$header_to = $period->period_name;
} else {
$header_to = "Unknown";
}
$period_list = getPeriodList($header[1], $header_to);
$header[1] = $header[1] . " to " . $header_to;
if ($showaccountcode == "on") {
$orderby = "ORDER BY ac.classtype,a.accountcode_full";
} else {
$orderby = "ORDER BY ac.classtype,a.accountcode_full,a.placeholder desc,a.accounts_name";
}
$sql = "SELECT a.accountcode_full,a.accounts_id,a.accounts_name,ac.classtype, a.treelevel,a.placeholder,a.parentaccounts_id,\r\n\t\tcase when (SELECT sum(transactionamt) FROM {$tabletranssummary} where accounts_id=a.accounts_id and period_id in ({$period_list})) is null\r\n\t\tthen 0 else (SELECT sum(transactionamt) FROM {$tabletranssummary} where accounts_id=a.accounts_id and period_id in ({$period_list})) end\r\n\t\t as transactionamt\r\n\t\tFROM {$tableaccounts} a \r\n\t\tINNER JOIN {$tableaccountgroup} ag on ag.accountgroup_id=a.accountgroup_id\r\n\t\tINNER JOIN {$tableaccountclass} ac on ag.accountclass_id=ac.accountclass_id\r\n\t\tWHERE ac.classtype in ('1S','2C','3O','4X') and a.treelevel<={$reportlevel} \r\n\t\t{$orderby} ";
$query = $xoopsDB->query($sql);
$pdf->AddPage();
$prefix = "";
$currentcategory = "1S";
$grossprofit = 0;
$totalsales = 0;
$totalcost = 0;
$totalexpenses = 0;
$tpl->assign("headerMenu_options", _("Options"));
/*
* List of elements - Depends on different criteria
*/
$rq = "SELECT * FROM pdfreports_reports {$SearchTool} ORDER BY name LIMIT " . $num * $limit . ", " . $limit;
$DBRESULT =& $pearDB->query($rq);
$form = new HTML_QuickForm('form', 'POST', "?p=" . $p);
/*
* Different style between each lines
*/
$style = "one";
require_once "./include/reporting/dashboard/common-Func.php";
/*
* Getting period table list to make the form period selection (today, this week etc.)
*/
$periodList = getPeriodList();
/*
* Fill a tab with a mutlidimensionnal Array we put in $tpl
*/
$elemArr = array();
for ($i = 0; $report =& $DBRESULT->fetchRow(); $i++) {
$moptions = "";
$selectedElements =& $form->addElement('checkbox', "select[" . $report['report_id'] . "]");
$moptions .= "<a href='main.php?p=" . $p . "&report_id=" . $report['report_id'] . "&o=rn'><img src='img/icones/16x16/gears_run.gif' border='0' alt='" . _("Run now") . "'></a> ";
if ($report["activate"]) {
$moptions .= "<a href='main.php?p=" . $p . "&report_id=" . $report['report_id'] . "&o=u&limit=" . $limit . "&num=" . $num . "&search=" . $search . "'><img src='img/icones/16x16/element_previous.gif' border='0' alt='" . _("Disabled") . "'></a> ";
} else {
$moptions .= "<a href='main.php?p=" . $p . "&report_id=" . $report['report_id'] . "&o=s&limit=" . $limit . "&num=" . $num . "&search=" . $search . "'><img src='img/icones/16x16/element_next.gif' border='0' alt='" . _("Enabled") . "'></a> ";
}
$moptions .= " ";
$moptions .= "<input onKeypress=\"if(event.keyCode > 31 && (event.keyCode < 45 || event.keyCode > 57)) event.returnValue = false; if(event.which > 31 && (event.which < 45 || event.which > 57)) return false;\" maxlength=\"3\" size=\"3\" value='1' style=\"margin-bottom:0px;\" name='dupNbr[" . $report['report_id'] . "]'></input>";
