$order = "p.party_city, coa.account_name"; } else { if (isset($_GET['city']) && strlen($_GET['city']) > 0) { $where = "p.party_city = '{$_GET['city']}'\n"; $order = "coa.account_name"; } } $items = oci_parse($conn, "SELECT coa.account_ref_id\n" . " FROM chart_of_account coa\n" . " INNER JOIN party p ON p.account_ref_id = coa.account_ref_id\n" . " WHERE {$where}" . " AND coa.company_ref_id = {$_SESSION['company_id']}\n" . "ORDER BY {$order}"); oci_execute($items); while ($row = oci_fetch_assoc($items)) { $accounts[] = $row['account_ref_id']; } } $_outstanding = array(); foreach ($accounts as $account) { $outstandingData = getOutstandingData($account, $_GET['report'], $date_start, $date_end, true); $d = $outstandingData['data'][0]; $_outstanding[] = $d; } $outstanding = array(); $outstanding['data']['data'] = $_outstanding; $mysqli->close(); if ($_GET['report'] == 'pdf') { include_once '../reports/outstanding.pdf.php'; } else { if ($_GET['report'] == 'xls') { include_once '../reports/outstanding.xls.php'; } } } else { ?>
require_once '../includes/connecti.php'; require_once '../includes/funcs.inc.php'; $_title = getReportTitle(); if (isset($_GET['report'])) { $date_start = ""; if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) { $date_start = $_GET['date_start']; } $date_end = ""; if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) { $date_end = $_GET['date_end']; } updateDate('rpt_account_outstanding_start', $date_start); updateDate('rpt_account_outstanding_end', $date_end); $outstanding = array(); $outstanding[] = getOutstandingData($_GET['account_category'], $_GET['report'], $date_start, $date_end, false); $mysqli->close(); if ($_GET['report'] == 'pdf') { include_once '../reports/outstanding.pdf.php'; } else { if ($_GET['report'] == 'xls') { include_once '../reports/outstanding.xls.php'; } } } else { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="shortcut icon" href="../images/logo_icon.gif"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
/** @var $mysqli mysqli */ /** @var $result mysqli_result */ $_title = getReportTitle(); if (isset($_GET['report'])) { $date_start = ""; if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) { $date_start = $_GET['date_start']; } $date_end = ""; if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) { $date_end = $_GET['date_end']; } updateDate('rpt_account_class_start', $date_start); updateDate('rpt_account_class_end', $date_end); $outstanding = array(); $outstanding[] = getOutstandingData($_GET['account_class'], $_GET['report'], $date_start, $date_end, false, true); $mysqli->close(); if ($_GET['report'] == 'pdf') { include_once '../reports/outstanding.pdf.php'; } else { if ($_GET['report'] == 'xls') { include_once '../reports/outstanding.xls.php'; } } } else { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="shortcut icon" href="../images/logo_icon.gif"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />