<?php
include_once 'include/connect.php';
include_once 'class/range.class.php';
include_once 'class/device.class.php';
$results = Range::getAll();
$width = 0;
// Assign value for range
if ($results) {
$width = (960 - count($results) * 20) / count($results);
}
$smarty->assign('ranges', $results);
$smarty->assign('devices', Device::getAll());
$smarty->assign('width', $width);
$smarty->assign('menu', 1);
$smarty->display('dashboard.tpl');
<?php
include_once 'class/range.class.php';
include_once 'class/device.class.php';
include_once 'class/payment.class.php';
$ranges = Range::getAll();
$smarty->assign('ranges', $ranges);
$smarty->assign('menu', 2);
// Report
if ($_POST['report']) {
set_include_path(dirname(dirname(__FILE__)) . '/library/PEAR/');
include_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$workbook->setVersion(8);
$worksheet =& $workbook->addWorksheet('report');
$worksheet->setInputEncoding('UTF-8');
$header = $workbook->addFormat();
$header->setFontFamily('Arial');
$header->setSize(14);
$header->setFgColor('blue');
$header->setBold();
$header->setHAlign('center');
$header->setVAlign('center');
$header->setColor('white');
$common = $workbook->addFormat();
$common->setFontFamily('Arial');
$common->setSize(12);
$caption = $workbook->addFormat();
$caption->setFontFamily('Arial');
$caption->setSize(12);
$caption->setBorder(1);