<?php
	require_once('check_login.php');

	if(empty($_GET["order_id"]) || (int)$_GET["order_id"] <= 0){
		echo "<script>alert('請選擇正確的合約。'); history.back();</script>";
		exit;
	}

	/**
	 * PHPExcel
	 *
	 * Copyright (C) 2006 - 2014 PHPExcel
	 *
	 * This library is free software; you can redistribute it and/or
	 * modify it under the terms of the GNU Lesser General Public
	 * License as published by the Free Software Foundation; either
	 * version 2.1 of the License, or (at your option) any later version.
	 *
	 * This library is distributed in the hope that it will be useful,
	 * but WITHOUT ANY WARRANTY; without even the implied warranty of
	 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
	 * Lesser General Public License for more details.
	 *
	 * You should have received a copy of the GNU Lesser General Public
	 * License along with this library; if not, write to the Free Software
	 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
	 *
	 * @category   PHPExcel
	 * @package    PHPExcel
	 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
	 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
	 * @version    1.8.0, 2014-03-02
	 */

	/** Error reporting */
	/*error_reporting(E_ALL);
	ini_set('display_errors', TRUE);
	ini_set('display_startup_errors', TRUE);*/
	date_default_timezone_set('Asia/Hong_Kong');

	ini_set('apc.cache_by_default', 0);

	if (PHP_SAPI == 'cli')
		die('This example should only be run from a Web Browser');

	/** Include PHPExcel */
	require_once dirname(__FILE__) . '/PHPExcel_1.8.0/Classes/PHPExcel.php';

	$reader = PHPExcel_IOFactory::createReader('Excel5'); // 讀取舊版 excel 檔案
	$PHPExcel = $reader->load("../webadmin/PHPExcel_1.8.0/contract_template.xls"); // 檔案名稱
	$sheet = $PHPExcel->getSheet(0); // 讀取第一個工作表(編號從 0 開始)

	// Set Orientation, size and scaling
	$PHPExcel->setActiveSheetIndex(0);
	$PHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT);
	$PHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
	$PHPExcel->getActiveSheet()->getPageSetup()->setFitToPage(true);
	$PHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1);
	$PHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight(0);

	//get order data
	$order_id = (int)$_GET["order_id"];
	if(!empty($order_id)){
		$order_info = get_order($order_id);
		$order_room_info = get_order_room($order_id);
		$order_room_list = "";
		foreach($order_room_info as $order_room){
			$room_info = get_room($order_room["room_id"]);
			$order_room_list .= $room_info["code"].", ";
		}
		$order_room_list = substr_replace($order_room_list, "", -2);

		//$customer_info = get_customer($order_info["customer_id"]);

		//->setCellValue('W13', $customer_info["customer_name"])

		if($order_info["location_id"] == 1){
			$Licensor_en = "In N Out International Corporate Limited, whose principal place of business in Hong Kong 12/F, Shing Dao Industrial Building, 232 Aberdeen Main Road, Aberdeen, Hong Kong";
			$Licensor_tc = "以出入易迷你倉國際有限公司之名營業, 在香港的主要營業場所設於 香港仔大道232號城都工業大厦十二字樓";
		}else if($order_info["location_id"] == 2){
			$Licensor_en = "In N Out International Corporate Limited, whose principal place of business in Hong Kong 14/F, Shing Dao Industrial Building, 232 Aberdeen Main Road, Aberdeen, Hong Kong";
			$Licensor_tc = "以出入易迷你倉國際有限公司之名營業, 在香港的主要營業場所設於 香港仔大道232號城都工業大厦十四字樓";
		}
// Add some data
		$sheet
			->setCellValue('V5', $order_info["code"])
			->setCellValue('AS5', date("Y-m-d"))
			->setCellValue('G7', $Licensor_en)
			->setCellValue('G8', $Licensor_tc);

		if($order_info["customer_typeid"] == "PERSONAL"){
			$sheet
				->setCellValue('A12', "Identification Number 身份證明號碼 :")
				->setCellValue('S12', rsa_crypt($order_info["customer_identity_id"], 2))
				->setCellValue('A13', "Name 姓名 :")
				->setCellValue('H13', $order_info["customer_name"]);
		}else{
			$sheet
				->setCellValue('A12', "Business Registration No 商業登記證號碼 :")
				->setCellValue('U12', rsa_crypt($order_info["customer_identity_id"], 2))
				->setCellValue('A13', "Company Name 公司名稱 :")
				->setCellValue('N13', $order_info["customer_companyname"]);
		}

		$sheet ->mergeCells('N15:Z15');
		$sheet->getStyle('N15')
			->getAlignment()
			->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);


		$paymethod = get_master_type_code("PAYMENT_METHOD", $order_info["paymethod"]);
		if(empty($order_info["paymethod2"]))
			$order_info["paymethod2"] = $order_info["paymethod"];

		$paymethod2 = get_master_type_code("PAYMENT_METHOD", $order_info["paymethod2"]);

		if($order_info["prepaid_month"] > 0){
			$total_prepaid = $order_info["prepaid_amount"]+$order_info["total_order_product"];
			$total_paid = $order_info["last_paid"]+$order_info["prepaid_amount"]+$order_info["total_order_product"];
			$total_remain = $order_info["total_discounted_price"]*$order_info["rent_month"]+$order_info["deposit"]-$order_info["last_paid"]-$order_info["free_first_month_deduct"]-$order_info["prepaid_amount"];
		}else{
			$total_prepaid = 0;
			$total_paid = $order_info["last_paid"];
			$total_remain = $order_info["total_discounted_price"]*$order_info["rent_month"]+$order_info["deposit"]+$order_info["total_order_product"]-$order_info["last_paid"]-$order_info["free_first_month_deduct"]-$order_info["prepaid_amount"];
		}

		$sheet
			->setCellValue('I14', rsa_crypt($order_info["customer_address"], 2))
			//->setCellValue('N15', "=TEXT(".rsa_crypt($order_info["tel"], 2).",'0') ")
			->setCellValue('N15', (string)rsa_crypt($order_info["customer_tel"], 2))
			//->setCellValueExplicit('N15', rsa_crypt($order_info["tel"], 2), PHPExcel_Cell_DataType::TYPE_STRING)
			->setCellValue('N16', rsa_crypt($order_info["customer_email"], 2))
			->setCellValue('M19', $order_room_list)
			->setCellValue('O20', $order_info["roughly_size"]."立方呎")
			->setCellValue('N21', $order_info["startdate"]." 至 ".$order_info["enddate"])
			->setCellValue('O22', $order_info["room_key"])
			->setCellValue('Q25', "(原價 : HKD$".numberformat($order_info["total_retail_price"]).")")
			->setCellValue('AD25', "租金以".$paymethod["name_tc"]."支付")
			->setCellValue('Q26', "港幣 : HKD$".numberformat($order_info["total_discounted_price"])." x ".$order_info["rent_month"]."月")
			->setCellValue('AO26', "港幣 : HKD$".numberformat($order_info["total_discounted_price"]*$order_info["rent_month"]))
			->setCellValue('AO27', "港幣 : HKD$".numberformat($order_info["deposit"]))
			->setCellValue('AD27', "按金以".$paymethod2["name_tc"]."支付")
			->setCellValue('AO28', "港幣 : HKD$".numberformat($order_info["total_order_product"]))
			->setCellValue('AO29', "港幣 : -HKD$".numberformat($order_info["free_first_month_deduct"]))
			->setCellValue('AO30', "港幣 : HKD$".numberformat(($order_info["total_discounted_price"]*$order_info["rent_month"])+$order_info["deposit"]+$order_info["total_order_product"]))
			//->setCellValue('AO31', "港幣 : -HKD$".numberformat($order_info["last_paid"]+$order_info["prepaid_amount"]+$order_info["total_order_product"]))
			->setCellValue('AO31', "港幣 : -HKD$".numberformat($total_paid))
			//->setCellValue('I31', "(預繳: HKD$".numberformat($order_info["prepaid_amount"]).")")
			->setCellValue('I31', "(預繳: HKD$".numberformat($total_prepaid).")")
			//->setCellValue('AO32', "港幣 : HKD$".numberformat(($order_info["total_discounted_price"]*$order_info["rent_month"])+$order_info["deposit"]+$order_info["total_order_product"]-$order_info["last_paid"]-$order_info["free_first_month_deduct"]-$order_info["prepaid_amount"]))
			->setCellValue('AO32', "港幣 : HKD$".numberformat($total_remain))
			->setCellValue('A35', $order_info["remark"])
			->setCellValue('R41', date("Y-m-d"))
			->setCellValue('AQ41', date("Y-m-d"));

		if($order_info["customer_typeid"] == "BUSINESS"){
			//insert row for business user contact person name
			$sheet->insertNewRowBefore(15, 1);
			$sheet
				->setCellValue('A15', "Contact Person 聯絡人 :")
				->setCellValue('N15', $order_info["customer_name"]);
		}

		//add 2 row in head
		$sheet->insertNewRowBefore(1, 2);

// Redirect output to a client’s web browser (Excel5)
		header('Content-Type: application/vnd.ms-excel');
		header('Content-Disposition: attachment;filename="Contract_'.$order_info["code"].'.xls"');
		header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
		header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
		header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
		header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
		header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
		header ('Pragma: public'); // HTTP/1.0

		$objWriter = PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel5');
		$objWriter->save('php://output');

		exit;
	}else{
		echo "<script>alert('找不到相關合約。');history.back();</script>";
		exit;
	}