
			
		<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>
							<td class="divider">
								<span class="line">&nbsp;</span>
								<span><b>NAME &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <?php echo $name; ?></b></span>
								<span><b>YEAR &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <?php echo (isset($year) ? $year : ' '); ?></b></span>
								<span><b>MONTH &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <?php echo (isset($month) ? $month : ' '); ?></b></span>
                                <span><b>CLAIM STATUS &nbsp;&nbsp;&nbsp;&nbsp;: <?php echo (isset($claim_status) ? $claim_status : ' '); ?></b></span>
                                <span><b>PAID STATUS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <?php echo (isset($paid_status) ? $paid_status : ' '); ?></b></span>
							</td>
						</tr>
					</table>
				</div>
			</div>
		</header>

		<div class="col-12 table-responsive " style="margin-top:2rem">
			<table class="table table-bordered" width="100%" border="1">
				<!-- <thead>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="#: activate to sort column ascending" style="width: 0px;">
						#
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Company Code/ Cost Centre: activate to sort column ascending" style="width: 0px;">
						Date
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Company Name: activate to sort column ascending" style="width: 0px;">
						Client
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Task
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Meal Allowance
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Start Time
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						End Time
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Break (minutes)
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Total Hours
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Day Type
					</th>
					<th class="sorting border-top text-center" tabindex="0" aria-controls="table_contact" rowspan="1" colspan="1" aria-label="Employee Total Upload: activate to sort column ascending" style="width: 0px;">
						Status
					</th>						
				</thead> -->	

				<tbody>
					<?php if (!empty($otLists)): ?>
                        <?php foreach ($otLists as $key => $ot): ?>       
                        <!-- <tr>
                            <td><?php echo $key+1;?></td>
                            <td><?php echo date('d/m/Y',strtotime($ot['otDate']));?></td>
                            <td><?php if($ot['clientID'] > 0 ){ echo $ot['clientName']; }else{ echo 'Others';};?></td>
                            <td><?php echo $ot['task'];?></td>                                          
                            <td><?php if($ot['mealAllowance'] == 1){
                                        echo 'Claimable (Included)';
                                      } else if($ot['mealAllowance'] == 2){
                                        echo 'Claimable (Not Included)';
                                      } else {
                                        echo 'Unclaimable';
                                      } ?>  
                            </td>
                            <td><?php echo date("h:i A", strtotime($ot['startTime']));?></td>
                            <td><?php echo date("h:i A", strtotime($ot['endTime']));?></td>
                            <td><?php echo $ot['refreshment'];?></td>
                            <td><?php echo $ot['totalHoursApplied'];?></td>
                            <td><?php 
                                if($ot['dayType'] == 1){
                                    echo 'Normal Day';
                                }else if($ot['dayType'] == 2){
                                    echo 'Rest Day';
                                }else if($ot['dayType'] == 3){
                                    echo 'Public Holiday';
                                }
                             ?></td>
                            <td id="otID" class="text-left" otDetailID="<?php echo $ot['ID']; ?>" otID="<?php echo $ot['otID']; ?>">
                                <?php if($ot['status'] == 0) { ?>
	                                <span class="badge badge-warning text-white">Pending</span><br>
	                                <small><i><b>*Remarks : </b><?php echo $ot['remarks'];?></i><br></small>
	                            <?php } else if($ot['status'] == 1) { ?>
	                                <span class="badge badge-success text-white">Approved</span><br>
	                                <small><i><b>*Remarks : </b><?php echo $ot['remarks'];?></i><br></small>
	                                <small><i><b>*Approved by : </b><?php echo $ot['status_by_name'];?></i><br></small>
	                            <?php }else { ?>
	                                <span class="badge badge-danger text-white">Rejected</span><br>
	                                <small><i><b>*Remarks : </b><?php echo $ot['remarks'];?></i><br></small>
	                                <small><i><b>*Rejected by : </b><?php echo $ot['status_by_name'];?></i><br></small>
	                            <?php } ?> 
                            </td>                                                
                        </tr>  -->
                        <?php endforeach ?>
                    <?php endif ?>
				</tbody>		
			</table>				
		</div>	
		<div class="card-body">

            <table class="table-bordered" width="100%">
                <h5>Claim Summary By Job for <?php echo date("F Y",mktime(0,0,0, $rsOt['month'],1,$rsOt['year'])) ?>
                <thead>
                    <th colspan="2" class="text-center bg-light py-3">Department</th>
                    <th colspan="2" class="text-center bg-light">Details</th>
                </thead>
                <tbody>
                    <?php $sum = 0; ?>
                    <?php foreach($OTSummaryByDept as $row): ?>
                        <tr>
                            <?php if($row['svDeptID'] !=0){ ?>
                                <td colspan="2" class="text-center"><?php echo $row['dept']; ?></td>
                            <?php } else { ?>
                                <td colspan="2" class="text-center"><?php echo $department_name; ?></td>
                            <?php }?>
                            <td class="text-left">
                                &nbsp;OT Applied (Hours)<br>
                                &nbsp;OT Approved (Hours)<br> 
                                &nbsp;OT Claim<br><hr> 
                                <?php if($row['svDeptID'] !=0){ ?>
                                    &nbsp;<b>Total for <?php echo $row['dept']; ?></b>
                                <?php } else { ?>
                                    &nbsp;<b>Total for <?php echo $department_name; ?></b>
                                <?php }?>
                                
                            </td>
                            <td colspan="2" class="text-center">
                                
                                <?php 
                                    if(!empty($row['totalHoursApproved'])){ $row['totalHoursApproved'] = $row['totalHoursApproved']; } else { $row['totalHoursApproved'] = 0; };

                                    $totalClaim = $row['totalHoursApproved']*7;

                                    $totalDept = $totalClaim;

                                    $sum+=$totalDept;

                                ?>

                                <?php echo $row['totalHoursApplied']; ?><br>
                                <?php echo $row['totalHoursApproved']; ?><br>
                                RM<?php echo number_format((float)$totalClaim, 2, '.', ''); ?><br><hr>
                                <b>RM<?php echo number_format((float)$totalDept, 2, '.', ''); ?></b>
                            </td>
                        </tr>
                    <?php endforeach ?>
                </tbody>
                <tfoot>
                    <td colspan="3" class="text-right bg-light py-3"><b>Total Claim All : </b></td>
                    <td colspan="2" class="text-center bg-light"><b>RM<?php echo number_format((float)$sum, 2, '.', ''); ?></b></td>
                </tfoot>
            </table><br><br>

            <table class="table-bordered" width="100%">
                <h5>Claim Summary for <?php echo date("F Y",mktime(0,0,0, $rsOt['month'],1,$rsOt['year'])) ?></h5>
                <h5 class="text-right"><span class="text-danger">* </span><small>CO = Conversion Leave </small></h5>
                <thead>
                    <th class="bg-light"></th>
                    <th colspan="2" class="text-center bg-light py-3">OT Applied (Hours)</th>
                    <th colspan="2" class="text-center bg-light py-3">OT Approved (Hours)</th>
                </thead>
                <tbody>
                    <?php 
                        if(!empty($ot['otID'])){ $ot['otID']             = $ot['otID']; } else { $ot['otID'] = 0; };
                        if(!empty($ot['NormalMeal'])){ $ot['NormalMeal'] = $ot['NormalMeal']; } else { $ot['NormalMeal'] = 0; };
                        if(!empty($ot['RestMeal'])){ $ot['RestMeal']     = $ot['RestMeal']; } else { $ot['RestMeal'] = 0; };
                        if(!empty($ot['PublicMeal'])){ $ot['PublicMeal'] = $ot['PublicMeal']; } else { $ot['PublicMeal'] = 0; };

                        if(!empty($ot['normal'])){ $ot['normal'] = $ot['normal']; } else { $ot['normal'] = 0; };
                        if(!empty($ot['rest'])){ $ot['rest']     = $ot['rest']; } else { $ot['rest'] = 0; };
                        if(!empty($ot['public'])){ $ot['public'] = $ot['public']; } else { $ot['public'] = 0; };
                        if(!empty($ot['weekend'])){ $ot['weekend']   = $ot['weekend']; } else { $ot['weekend'] = 0; };
                        if(!empty($ot['weekdays'])){ $ot['weekdays'] = $ot['weekdays']; } else { $ot['weekdays'] = 0; };
                        if(!empty($ot['totalHoursAppliedTotal'])){ $ot['totalHoursAppliedTotal'] = $ot['totalHoursAppliedTotal']; } else { $ot['totalHoursAppliedTotal'] = 0; };
                        if(!empty($ot['totalHoursApproved'])){ $ot['totalHoursApproved'] = $ot['totalHoursApproved']; } else { $ot['totalHoursApproved'] = 0; };
                        if(!empty($ot['claim_status'])){ $ot['claim_status'] = $ot['claim_status']; } else { $ot['claim_status'] = 0; };

                        $weekendTotal2   = $ot['weekend']*7;
                        $weekdaysTotal2  = $ot['weekdays']*7;
                        $total2          = $weekendTotal2+$weekdaysTotal2;

                        $convertALHour      = number_format($ot['totalHoursApproved']/8)*8;
                        $convertALHourValue = 0;
                        $total2Final        = $total2-$convertALHourValue;

                    ?>
                    <tr>
                        <td class="text-center py-3">Total OT</td>
                        <td colspan="2" class="text-center"><input type="hidden" value="<?php echo $ot['totalHoursAppliedTotal']; ?>" id="totalOT" data-otID="<?php echo $ot['otID']; ?>"><?php echo $ot['totalHoursAppliedTotal']; ?></td>
                        <td colspan="2" class="text-center"><input type="hidden" value="<?php echo $ot['totalHoursApproved']; ?>" id="totalApprovedOT"><?php echo $ot['totalHoursApproved']; ?></td>
                    </tr>
                    <tr>
                        <td class="bg-light py-2"><b></b></td>
                        <td class="text-center bg-light py-3"><b>Total Hours Approved</b></td>
                        <td class="text-center bg-light"><b>Calculation</b></td>
                        <td class="text-center bg-light" colspan="2"><b>Total</b></td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td class="text-center"> 
                            Weekend 
                        </td>
                        <td class="text-center"><?php if($ot['weekend']){ echo $ot['weekend']; }else{ echo "0"; } ?></td>
                        <td class="text-center"><?php echo $ot['weekend'].' x RM7 '; ?><br><small>(Actual Overtime x RM7.00)</small></td>
                        <td class="text-center" colspan="2"><b>RM<?php echo number_format((float)$weekendTotal2, 2, '.', ''); ?></b></td>
                    </tr>
                    <tr>
                        <td class="text-center"> 
                            Weekdays
                        </td>
                        <td class="text-center"><?php if($ot['weekdays']){ echo $ot['weekdays']; }else{ echo "0"; } ?></td>
                        <td class="text-center"><?php echo $ot['weekdays'].' x RM7 '; ?><br><small>(Actual Overtime x RM7.00 )</small></td>
                        <td class="text-center" colspan="2"><b>RM<?php echo number_format((float)$weekdaysTotal2, 2, '.', ''); ?></b></td>
                    </tr>
                    <tr>
                        <td colspan="3" class="text-right bg-light py-3"><b>Total Claim :</b></td>
                        <td class="text-center bg-light" colspan="2"><input type="hidden" name="total2" id="total2" value="<?php echo number_format((float)$total2, 2, '.', ''); ?>"><b>RM<?php echo number_format((float)$total2, 2, '.', ''); ?></b>
                        </td>
                    </tr>
                    <?php if($basicSalary->basic_pay > 2000){ ?>
                        <?php if($ot['claim_status']==2){ ?>
                            <tr>
                                <td class="text-center"><span class="text-danger">* </span>Convert to CO<br><small>(Completion of 8 hours)</small></td>
                                <td colspan="3"><input type="text" value="<?php echo $ot['totalConvertToLeave']; ?>" id="totalConvertAL" class="form-control text-center" onchange="calculateALValue()" disabled></td>
                                <td class="text-center"><input type="hidden" class="form-control text-center" name="ALValue" id="ALValue" value="<?php echo number_format((float)$ot['totalConvertToLeave']*10, 2, '.', ''); ?>"><b id="total2echo"><?php echo "(RM". number_format((float)$ot['totalConvertToLeave']*10, 2, '.', '').")" ?></b>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="4" class="text-right bg-light py-3"><b>Final Total Claim :</b></td>
                                <td class="text-center bg-light"><input type="hidden" class="form-control text-center" name="total2Final" id="total2Final" value="<?php echo number_format((float)$ot['totalClaim'], 2, '.', ''); ?>"><b id="ALValueEcho"><?php echo "RM".number_format((float)$total2-$ot['totalConvertToLeave']*10, 2, '.', '').""; ?></b></td>
                            </tr>
                        <?php } else { ?>
                            <?php if($ot['totalHoursApproved'] >= 8){ ?> 
                                <tr>
                                    <td class="text-center"><span class="text-danger">* </span>Convert to CO<br><small>(Completion of 8 hours)</small></td>
                                    <td colspan="3"><input type="text" value="<?php echo $ot['totalConvertToLeave']; ?>" id="totalConvertAL" class="form-control text-center" onchange="calculateALValue()"></td>
                                    <td class="text-center"><input type="hidden" class="form-control text-center" name="ALValue" id="ALValue" value="<?php echo number_format((float)$ot['totalConvertToLeave']*10, 2, '.', ''); ?>"><b id="total2echo"><?php echo "(RM". number_format((float)$ot['totalConvertToLeave']*10, 2, '.', '').")" ?></b>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="4" class="text-right bg-light py-3"><b>Final Total Claim :</b></td>
                                    <td class="text-center bg-light"><input type="hidden" class="form-control text-center" name="total2Final" id="total2Final" value="<?php echo number_format((float)$ot['totalClaim'], 2, '.', ''); ?>"><b id="ALValueEcho"><?php echo "RM".number_format((float)$total2-$ot['totalConvertToLeave']*10, 2, '.', '').""; ?></b></td>
                                </tr>
                            <?php } else { ?>
                                <tr>
                                    <td class="text-center"><span class="text-danger">* </span>Convert to AL<br><small>(Completion of 8 hours)</small></td>
                                    <td colspan="3"><input type="text" value="0" id="totalConvertAL" class="form-control text-center" disabled></td>
                                    <td class="text-center"><input type="hidden" class="form-control text-center" name="ALValue" id="ALValue" value="<?php echo number_format((float)$convertALHourValue, 2, '.', ''); ?>"><b id="total2echo"><?php echo "(RM". number_format((float)$convertALHourValue, 2, '.', '').")" ?></b>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="4" class="text-right bg-light py-3"><b>Final Total Claim :</b></td>
                                    <td class="text-center bg-light"><input type="hidden" class="form-control text-center" name="total2Final" id="total2Final" value="<?php echo number_format((float)$total2Final, 2, '.', ''); ?>"><b id="ALValueEcho"><?php echo "RM".number_format((float)$total2Final, 2, '.', '').""; ?></b></td>
                                </tr>
                            <?php } ?>
                        <?php } ?>
                    <?php }else{ ?>

                    <?php } ?>
                </tfoot>
            </table>

        </div>
									

