<?php
/**
* @package OTA Hotel Management
* @copyright e-Novate Pte Ltd 2012-2015
*/
error_reporting(E_ALL | E_STRICT);
include_once dirname(__FILE__) . "/../dailyfunc.php";
include_once dirname(__FILE__) . "/../PHPExcel/Classes/PHPExcel.php";
include_once dirname(__FILE__) . "/../PHPExcel/Classes/PHPExcel/Writer/Excel2007.php";
if ($_POST['Submit']) {
switch ($request) {
case 'holidayRpt':
if ($_POST['year']) {
$holidays = getHoliday_by_year($_POST['year']);
ob_end_clean();
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("e-Novate Pte Ltd")->setLastModifiedBy("e-Novate Pte Ltd");
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', "Holiday");
$objPHPExcel->getActiveSheet()->setCellValue('B1', "Date");
$i = 2;
for ($j = 0; $j < count($holidays); $j++) {
$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $holidays[$j]['Description']);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, substr($holidays[$j]['days'], 0, 10));
$i++;
}
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Holidays');
date_default_timezone_set(TIMEZONE);
// Get the current settings
Get_HotelSettings($hotel, $altname, $company, $register, $ebridgeid, $tax1, $tax2, $phone, $fax, $IM, $street, $city, $citycode, $state, $postcode, $countrycode, $country, $logo, $latitude, $longitude, $language, $email, $web, $ota, $chaincode);
access("reports");
//check if user is allowed to access this page
$year = getYearHoliday();
$result = array();
$request = "";
$submit = "";
if (isset($_POST['Submit'])) {
$submit = $_POST['Submit'];
}
if (isset($_POST['showReport'])) {
// delHolidayByID($_POST['HolidayID']);
if (isset($_POST['year'])) {
$result = getHoliday_by_year($_POST['year']);
}
}
if ($submit == $_L['EXP_download']) {
$request = 'holidayRpt';
include "reportfunction.php";
}
?>
<table height="500" class="listing-table">
<tbody>
<tr>
<?php
print_rightMenu_reports();
?>
<td valign="top">
