<?php
	if(($this->session->userdata('sv_hotel_filter_month') && $this->session->userdata('sv_hotel_filter_month') != 'no result')){
		if($this->session->userdata('sv_hotel_filter_month') == '01'){
	         $month = "JANUARY";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '02'){
	         $month = "FEBRUARY";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '03'){
	         $month = "MARCH";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '04'){
	         $month = "APRIL";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '05'){
	         $month = "MAY";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '06'){
	         $month = "JUNE";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '07'){
	         $month = "JULY";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '08'){
	         $month = "AUGUST";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '09'){
	         $month = "SEPTEMBER";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '10'){
	         $month = "OCTOBER";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '11'){
	         $month = "NOVEMBER";
	    }else if($this->session->userdata('sv_hotel_filter_month') == '12'){
	         $month = "DECEMBER";
        }else if($this->session->userdata('sv_hotel_filter_month') == 'ALL'){
	         $month = "ALL";
	    }else  $month = "Unknown";
	}
?>

<header>
	<div class="row">
		<div class="col-12">
			<div class="t-corp pull-left">
				<div class="t-corp-logo">
					<img src="<?php echo base_url().'assets/images/logo/salihin-logo.png'; ?>" alt="company logo" />
				</div>
				<div class="t-corp-name"><b>SPS</b> | HR SYSTEM</div>
			</div>
			<div class="report-title pull-right" style="padding-top: 30px;">
				<h5><?php echo (isset($title) ? $title : 'Report'); ?></h5>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-12">
			<table class="company">
				<tr>
					<td class="divider">
						<span class="line">&nbsp;</span>
					</td>
					<td class="details">
						<span><b>SALIHIN (AF 1426)</b></span>
						<span>555, Jalan Samudra Utara 1, Taman Samudra, Batu Caves,</span>
						<span>68100, Batu Caves, Selangor</span>
						<span>Phone: 03-6185 9970 &nbsp;&nbsp; Fax: 03-6185 9970</span>
						<span>Website: salihin.com.my</span>
					</td>
					<?php if(!empty($ID)){ ?>
						<td class="divider">
							<span class="line">&nbsp;</span>
						</td>
					<?php } else { ?>
						<td class="divider">
							<span class="line">&nbsp;</span>
							<table>
								<tr>
									<td><span><b>DEPARTMENT</b></span></td>
									<td><span><b style="padding-left: 2rem;">:</b></span></td>
									<?php if(!empty($this->session->userdata('sv_hotel_filter_dept')) && $this->session->userdata('sv_hotel_filter_dept') != 'ALL'){ ?>
										<td><span><b style="padding-left: 1rem;"><?php echo $department['name'].' ['.$department['branch_name'].']'; ?></b></span></td>
									<?php } else {?>
										<?php if($_SESSION['module_data']['role']=='admin'){ ?>
											<td><span><b style="padding-left: 1rem;">ALL</b></span></td>
										<?php } else{ ?>
											<td><span><b style="padding-left: 1rem;"><?php echo $_SESSION['user']['department_name'].' ['.$_SESSION['user']['branch_name'].']'; ?></b></span></td>
										<?php } ?>
									<?php } ?>
								</tr>
								<tr>
									<td><span><b>STATUS</b></span></td>
									<td><span><b style="padding-left: 2rem;">:</b></span></td>
									<td><span><b style="padding-left: 1rem;"><?php echo (!empty($this->session->userdata('sv_hotel_filter_status')))?(str_replace('_',' ',$this->session->userdata('sv_hotel_filter_status'))):'ALL'; ?></b></span></td>
								</tr>
								<tr>
									<td><span><b>YEAR</b></span></td>
									<td><span><b style="padding-left: 2rem;">:</b></span></td>
									<td><span><b style="padding-left: 1rem;"><?php echo (!empty($this->session->userdata('sv_hotel_filter_year')))?($this->session->userdata('sv_hotel_filter_year')):'ALL'; ?></b></span></td>
								</tr>
								<tr>
									<td><span><b>MONTH</b></span></td>
									<td><span><b style="padding-left: 2rem;">:</b></span></td>
									<td><span><b style="padding-left: 1rem;"><?php echo (!empty($this->session->userdata('sv_hotel_filter_month')))?($this->session->userdata('sv_hotel_filter_month')):'ALL'; ?></b></span></td>
								</tr>
							</table>
						</td>
					<?php } ?>
				</tr>
			</table>
		</div>
	</div>
</header>

<?php if(!empty($ID)){ ?>
	<div class="container">
		<div class="col-12" style="margin-top:2rem">
			<div class="row">
				<div class="col">
					<h3><b>DETAIL OF HOTEL BOOKING</b></h3>
				</div>
			</div>
			<div class="row">
				<div class="col">
					<p style="border-top: 3px solid; width: 33rem;"></p><br>
				</div>
			</div>
			<div class="row">
				<div class="col d-flex" style="padding-left: 5rem;">
					<div class="align-self-end w-100">
						<div class="row">
							<div class="col-4">
								<b>STAFF ID</b>
							</div>
							<div class="col">
								<p class="report-font">:
									<?php echo (!empty($rsHotelList[0]['staff_id']))?strtoupper($rsHotelList[0]['staff_id']):'N/A'; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>STAFF NAME</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['requestor']))?$rsHotelList[0]['requestor'].' ['.$rsHotelList[0]['requestor_email'].']':''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>DEPARTMENT</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['dept_name']))?$rsHotelList[0]['dept_name'].'/'.$rsHotelList[0]['branchName']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>DATE REQUEST</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['createdTS']))?date('d-m-Y',strtotime($rsHotelList[0]['createdTS'])):''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>HOTEL NAME</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['hotel_name']))?$rsHotelList[0]['hotel_name']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>LOCATION</b>
							</div>
							<div class="col">
								<p class="report-font">:
									<?php echo (!empty($rsHotelList[0]['location']))?$rsHotelList[0]['location']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>CHECK IN DATE AND TIME</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['checkin_date'] && $rsHotelList[0]['checkin_time']))?date('d-m-Y',strtotime($rsHotelList[0]['checkin_date'])).' '.$rsHotelList[0]['checkin_time']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>CHECK OUT DATE AND TIME</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['checkout_date'] && $rsHotelList[0]['checkout_time']))?date('d-m-Y',strtotime($rsHotelList[0]['checkout_date'])).' '.$rsHotelList[0]['checkout_time']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>NO. OF PAX</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['pax']))?$rsHotelList[0]['pax']:''; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>NO. OF ROOM</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo (!empty($rsHotelList[0]['room_details']))?count($rsHotelList[0]['room_details']):'0'; ?>
								</p>
							</div>
						</div>

						<div class="row">
							<div class="col-4">
								<b>STATUS</b>
							</div>
							<div class="col">
								<p class="report-font">: 
									<?php echo ($rsHotelList[0]['status_app']==null || $rsHotelList[0]['status_app']=='Pending' )?'Pending ':str_replace('_',' ',$rsHotelList[0]['status_app']); ?>
								</p>
							</div>
						</div>
					</div>
				</div>
			</div>
			<div class="row">
				<div class="col">
					<b>ROOM DETAIL</b>
					<br><br>								
					<table class="table table-bordered p-0 m-0" width="100%">
						<thead>
							<th class="text-center">#</th>
							<th class="text-center">Room</th>
							<th class="text-center">Guest Name</th>
							<th class="text-center">Guest IC</th>
							<th class="text-center">Guest Phone</th>
						</thead>
						<tbody>
							<?php if($rsHotelList[0]['room_details']) foreach($rsHotelList[0]['room_details'] as $key => $row){ ?>
								<tr>
									<td class="text-center"><?php echo $key+1; ?></td>
									<td class=text-center><?php echo $row['room_type'] ?></td>
									<td>
										<?php
											$guest_name = explode(',', $row['guest_room_name']);

											if($guest_name) foreach($guest_name as $g_key => $g_name)
											{
												echo '<li>'.$g_name.'</li>';
											}
										?>
									</td>
									<td>
										<?php
											$guest_ic = explode(',', $row['guest_room_ic_no']);

											if($guest_ic) foreach($guest_ic as $g_key => $g_ic)
											{
												echo '<li>'.$g_ic.'</li>';
											}
										?>
									</td>
									<td>
										<?php
											$guest_phone = explode(',', $row['guest_room_phone']);

											if($guest_phone) foreach($guest_phone as $g_key => $g_phone)
											{
												echo '<li>'.$g_phone.'</li>';
											}
										?>
									</td>
								</tr>
							<?php } ?>
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>


	<?php echo $approval; ?>

<?php } else { ?>

    <div class="col-12 table-responsive " style="margin-top:2rem">
        <table class="table table-bordered p-0 m-0" width="100%">
            <thead> 
                <th class="text-center" width="5%">
                    #
                </th>
                <th class="text-center" width="20%">
                    Requestor / Creator
                </th>
                <th class="text-center" width="10%">
                    Hotel Name
                </th>
                <th class="text-center" width="27%">
                    Location 
                </th>
                <th class="text-center" width="10%">
                    Check In Date and Time
                </th>
                <th class="text-center" width="10%">
                    Check Out Date and Time
                </th>
                <th class="text-center" width="5%">
                    Pax
                </th>
                <th class="text-center" width="8%">
                    Status
                </th>         
            </thead>
            <tbody>
                <?php if(!empty($rsHotelList) && is_array($rsHotelList)) { ?> 
                    <?php foreach($rsHotelList as $key => $row) {
                        ?>
                        <tr>
                            <td class="text-center"><?php echo $key+1; ?></td>
                            <td>
                                <b>Requestor : </b><br><?php echo $row['requestor'].' ['.$row['requestor_email'].']'; ?>
                                <br><br>
                                <b>Creator : </b><br><?php echo $row['created_name'].' ['.$row['created_email'].']' ?>
                            </td>
                            <td><?php echo $row['hotel_name']; ?></td>
                            <td><?php echo $row['location']; ?></td>
                            <td class="text-center"><?php echo date ('d-m-Y', strtotime($row['checkin_date'])) . ' / ' . $row['checkin_time']; ?></td>
                            <td class="text-center"><?php echo date ('d-m-Y', strtotime($row['checkout_date'])) . ' / ' . $row['checkout_time']; ?></td>
                            <td class="text-center"><?php echo $row['pax']; ?></td>
                            <td class="text-center">
                                <?php echo ($row['status_app']==null || $row['status_app']=='Pending' )?'Pending':str_replace('_',' ',$row['status_app']); ?> 
                            </td> 
                        </tr>
                    <?php } ?>
                <?php } ?>
            </tbody>
        </table>	
    </div>	
<?php } ?>





