<body>
<?php
include "../settings.php";
include "../language/{$cfg_language}";
include "../classes/db_functions.php";
include "../classes/security_functions.php";
include "../classes/display.php";
$lang = new language();
$dbf = new db_functions($cfg_server, $cfg_username, $cfg_password, $cfg_database, $cfg_tableprefix, $cfg_theme, $lang);
$sec = new security_functions($dbf, 'Report Viewer', $lang);
if (!$sec->isLoggedIn()) {
header("location: ../login.php");
exit;
}
if (isset($_POST['date_range'])) {
$date_range = $_POST['date_range'];
$dates = explode(':', $date_range);
$date1 = $dates[0];
$date2 = $dates[1];
}
$display = new display($dbf->conn, $cfg_theme, $cfg_currency_symbol, $lang);
$display->displayTitle("{$cfg_company} {$lang->profitReport}");
$tableheaders = array("{$lang->date}", "{$lang->totalAmountSoldWithOutTax}", "{$lang->profit}");
$display->displayTotalsReport($cfg_tableprefix, 'profit', $tableheaders, $date1, $date2, 'id', '');
?>
</body>
</html>
<body>
<?php
include "../settings.php";
include "../language/{$cfg_language}";
include "../classes/db_functions.php";
include "../classes/security_functions.php";
include "../classes/display.php";
$lang = new language();
$dbf = new db_functions($cfg_server, $cfg_username, $cfg_password, $cfg_database, $cfg_tableprefix, $cfg_theme, $lang);
$sec = new security_functions($dbf, 'Report Viewer', $lang);
if (!$sec->isLoggedIn()) {
header("location: ../login.php");
exit;
}
if (isset($_POST['date_range']) and isset($_POST['selected_item'])) {
$selected_item = $_POST['selected_item'];
$date_range = $_POST['date_range'];
$dates = explode(':', $date_range);
$date1 = $dates[0];
$date2 = $dates[1];
}
$display = new display($dbf->conn, $cfg_theme, $cfg_currency_symbol, $lang);
$display->displayTitle("{$cfg_company} {$lang->itemReport}");
$tableheaders = array("{$lang->itemName}", "{$lang->brand}", "{$lang->category}", "{$lang->supplier}", "{$lang->numberPurchased}", "{$lang->subTotalForItem}", "{$lang->totalForItem}");
$display->displayTotalsReport($cfg_tableprefix, 'item', $tableheaders, $date1, $date2, 'id', "{$selected_item}");
?>
</body>
</html>
include "../classes/db_functions.php";
include "../classes/security_functions.php";
include "../classes/display.php";
$lang = new language();
$dbf = new db_functions($cfg_server, $cfg_username, $cfg_password, $cfg_database, $cfg_tableprefix, $cfg_theme, $lang);
$sec = new security_functions($dbf, 'Report Viewer', $lang);
if (!$sec->isLoggedIn()) {
header("location: ../login.php");
exit;
}
$display = new display($dbf->conn, $cfg_theme, $cfg_currency_symbol, $lang);
$display->displayTitle("{$cfg_company} {$lang->allItemsReport}");
if (isset($_POST['month1'])) {
$month1 = $_POST['month1'];
$day1 = $_POST['day1'];
$year1 = $_POST['year1'];
$month2 = $_POST['month2'];
$day2 = $_POST['day2'];
$year2 = $_POST['year2'];
$date1 = date("{$year1}-{$month1}-{$day1}");
$date2 = date("{$year2}-{$month2}-{$day2}");
}
$tableheaders = array("{$lang->itemName}", "{$lang->brand}", "{$lang->category}", "{$lang->supplier}", "{$lang->numberPurchased}", "{$lang->subTotalForItem}", "{$lang->totalForItem}");
$display->displayTotalsReport($cfg_tableprefix, 'items', $tableheaders, $date1, $date2, '', '');
?>
</body>
</html>
