<?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">