$date_default = "";
$date_url = "";
$button_download = "";
if (isset($_GET['preview'])) {
$i_year = get_isset($_GET['year']);
}
$action = "report_customer_year.php?page=form_result&preview=1";
include '../views/report_customer_year/form.php';
if (isset($_GET['preview'])) {
if (isset($_GET['year'])) {
$i_year = $_GET['year'];
} else {
extract($_POST);
$i_year = get_isset($i_year);
}
$query_customer = select_customer();
$year = $i_year;
include '../views/report_customer_year/list_detail.php';
//include '../views/report_customer_year/list_item.php';
//include '../views/report_customer_year/list_partner.php';
//include '../views/report_customer_year/list_transaction.php';
}
get_footer();
break;
case 'form_result':
$id = isset($_GET['id']) ? $_GET['id'] : null;
$date_default = "";
$date_url = "";
//if(isset($_GET['preview'])){
extract($_POST);
$i_year = isset($_POST['i_year']) ? $_POST['i_year'] : null;
<?php
require "settings.php";
// Navigation logic
if (isset($_REQUEST["key"])) {
switch ($_REQUEST["key"]) {
case "select_customer":
$OUTPUT = select_customer();
break;
case "input_amount":
$OUTPUT = input_amount;
break;
}
} else {
$OUTPUT = select_customer();
}
require "template.php";
function select_customer()
{
extract($_REQUEST);
$fields = array();
$fields["cusnum"] = 0;
$fields["search"] = "[_BLANK_]";
extract($fields, EXTR_SKIP);
$sql = "\n\tSELECT cusnum, surname FROM cubit.customers\n\tWHERE surname ILIKE '{$search}%' ORDER BY surname ASC";
$cust_rslt = db_exec($sql) or errDie("Unable to retrieve customers.");
$cust_out = "";
$i = 0;
while (list($cusnum, $surname) = pg_fetch_array($cust_rslt)) {
if ($i == 5) {
$cust_out .= "</tr>";
