</td>
<?php
}
else if(isset($_GET['overtime_delete']))
{
?>
<td>
<a class="btn btn-xs btn-danger" title="Permanently Delete" role="button" data-toggle="modal" href="#responsive_rej<?php echo $i ?>" style="text-decoration:none;">
<i class="fa fa-trash-o"></i></a>
<div style="display: none;" id="responsive_rej<?php echo $i ?>" class="modal fade" tabindex="-1" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header" style="color:#E02222 !important;border-bottom:0px !important;">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
<h4 class="modal-title"><strong><i class="fa fa-trash-o"></i> W</strong>ould you like to delete <?php echo fetchemployeename($row['reg_id']); ?> info. ?</h4>
</div>
<div class="modal-footer">
<button type="button" data-dismiss="modal" class="btn btn-default">Close</button>
<button onClick="delete_overtime(<?php echo $idd; ?>,<?php echo $i; ?>);" id="refresh" data-dismiss="modal" class="btn btn-danger" ><i class="fa fa-trash-o"></i> Delete</button>
</div>
</div>
</div>
</div>
<?php $all_del[]=$idd;
?>
</td>
<?php
}
else
}
?>
<th>TOTAL AMOUNT</th>
</tr>
</thead>
<tbody>
<?php
$s=0;
$result=mysql_query("select `id`,`name`,`wages` from `registration` where `depart_id`='".$depart_id."' ");
while($row=mysql_fetch_array($result))
{
$total_days=0;
$total_half=0;
?>
<tr>
<th style="text-align:left !important;"><?php echo fetchemployeename($row['id']); ?></th>
<?php
$all_advance1=0;
for($k=0;$k<sizeof($all_dates);$k++)
{
$advance_amnt1=0;
$res_advance1=mysql_query("select `amount` from `advance` where `reg_id`='".$row['id']."' and `advance_given_date`='".datefordb($all_dates[$k])."'");
while($row_advance1=@mysql_fetch_array($res_advance1))
{
$advance_amnt1+=$row_advance1['amount'];
$all_advance1+=$row_advance1['amount'];
}
?>
<td <?php if($advance_amnt1>0){ ?> style="background-color:#EBFCEE;" <?php } ?>><strong><?php if($advance_amnt1>0) { echo $advance_amnt1; } else { echo "-"; } ?></strong></td>
<?php
}
$mytime= $after_dot. " Miniute" ;
}
else if(!empty($before_dot)&&empty($after_dot))
{
$mytime=$before_dot. " Hours";
}
$res_fname=mysql_query("select `mobile_no` from registration where `id`='".$row['reg_id']."'");
$row_fname=@mysql_fetch_array($res_fname);
?>
<h4><i class="fa fa-cloud"></i> Overtime Detail:</h4>
<div class="table-responsive">
<table width="100%" class="table table-condensed table-hover">
<tr>
<td><strong>name:</strong></td>
<td><?php echo fetchemployeename($row['reg_id']);?></td>
<td><strong>Mobile No.</strong></td>
<td><?php echo $row_fname['mobile_no']; ?></td>
</tr>
<tr>
<td><strong>Overtime Date:</strong></td>
<td><?php echo dateforview($row['overtime_date']);?></td>
<td><strong>Total Overtime</strong></td>
<th><?php echo $mytime; ?></th>
</tr>
</table>
</div>
<?php
}
}
?>
<th>TOTAL AMOUNT</th>
</tr>
</thead>
<tbody>
<?php
$s=0;
$result=mysql_query("select `id`,`name`,`wages` from `registration` where `depart_id`='".$depart_id."' ");
while($row=mysql_fetch_array($result))
{
$total_days=0;
$total_half=0;
?>
<tr>
<td style="text-align:left !important;font-size:13px;font-weight:bold"><?php echo fetchemployeename($row['id']); ?></td>
<?php
$all_advance1=0;
for($k=0;$k<sizeof($all_dates);$k++)
{
$advance_amnt1=0;
$res_advance1=mysql_query("select `amount` from `advance` where `reg_id`='".$row['id']."' and `advance_given_date`='".datefordb($all_dates[$k])."'");
while($row_advance1=@mysql_fetch_array($res_advance1))
{
$advance_amnt1+=$row_advance1['amount'];
$all_advance1+=$row_advance1['amount'];
}
?>
<td <?php if($advance_amnt1>0){ ?> style="background-color:#EBFCEE;font-weight:bold;" <?php } ?>><?php if($advance_amnt1>0) { echo $advance_amnt1; } else { echo "-"; } ?></td>
<?php
}
