public function getReport(DataParam $dataParam, array $years)
{
try {
$asJson = $this->asJson;
$this->asJson = false;
$values = $this->getValues($dataParam, $years);
$this->asJson = $asJson;
return $this->report->getReport($values, $years, $this->grouper);
} catch (LoginException $exception) {
return $this->loginExceptionMessage($exception);
}
}
<?php require 'Config/common.php'; require MODEL_PATH . 'Report.php'; $report = new Report(); //getting filter list $date_filter_list = $report->getDateFilter(); $client_filter_list = $report->getClientFilter(); $product_filter_list = $report->getProductFilter(); //getting invoice list $invoice_list = $report->getReport(); include VIEW_PATH . 'dashboard.php';
/**
* Get data for standart report and assign with xt
* @param &Array _options
*/
public function setStandartData(&$_options)
{
include_once getabspath('classes/reportlib.php');
$whereComponents = $this->getWhereComponents();
$sqlArray = $this->getReportSQLData();
$rb = new Report($sqlArray, $this->pSet->GetTableData(".orderindexes"), $this->connection, $this->pageSize, $_options, $whereComponents["searchWhere"], $whereComponents["searchHaving"], $this);
$this->arrReport = $rb->getReport($this->pagestart);
$this->setDetailLinks();
$this->buildPagination();
$this->standardReportCommonAssign();
}
/**
* Get data for standart report and assign with xt
* @param &Array _options
*/
public function setStandartData(&$_options)
{
include_once getabspath('classes/reportlib.php');
if (!$_SESSION[$this->sessionPrefix . "_pagesize"]) {
$_SESSION[$this->sessionPrefix . "_pagesize"] = -1;
}
// a temporary fix
if (!$_SESSION[$this->sessionPrefix . "_pagenumber"]) {
$_SESSION[$this->sessionPrefix . "_pagenumber"] = 1;
}
if (isset($_REQUEST["all"]) && $_REQUEST["all"]) {
$PageSize = -1;
$pagestart = 0;
$this->jsSettings['tableSettings'][$this->tName]['reportPrintMode'] = 1;
} else {
$PageSize = $_SESSION[$this->sessionPrefix . "_pagesize"];
$pagestart = ($_SESSION[$this->sessionPrefix . "_pagenumber"] - 1) * $PageSize;
}
$whereComponents = $this->getWhereComponents();
$sqlArray = $this->getReportSQLData();
$rb = new Report($sqlArray, $this->pSet->GetTableData(".orderindexes"), $this->connection, $PageSize, $_options, $whereComponents["searchWhere"], $whereComponents["searchHaving"], $this);
$this->arrReport = $rb->getReport($pagestart);
$this->standardReportCommonAssign();
}
} elseif ($date_type == 'last_year') {
$str = date('Y-m-d', strtotime('-1 year ' . date('Y-m-d')));
list($y, $m, $d) = explode('-', $str);
$start_date = "{$y}-01-01";
$end_date = "{$y}-12-31";
$condition .= " and inv.invoice_date>='{$start_date}' and inv.invoice_date<='{$end_date}'";
}
}
if ($client_id != '') {
$condition .= " and c.client_id='{$client_id}'";
}
if ($product_id != '') {
$condition .= " and p.product_id='{$product_id}'";
}
}
$invoice_list = $report->getReport($condition);
if (!$invoice_list) {
$html .= '<tr><td colspan="6" align="center">No data found for selected filter </td><tr>';
} else {
foreach ($invoice_list as $key => $value) {
$html .= '
<tr>
<td>' . $value['invoice_num'] . '</td>
<td>' . date('d/m/Y', strtotime($value['invoice_date'])) . '</td>
<td>' . $value['product_description'] . '</td>
<td>' . $value['qty'] . '</td>
<td>' . $value['price'] . '</td>
<td>' . round($value['price'] * $value['qty'], 2) . '</td>
<tr>';
}
}
