$q4=" && `status`='0' ";
}
$sql=$qry.$q1.$q2.$q3.$q4;
$result= @mysql_query($sql);
if($result)
{
while($row=mysql_fetch_array($result))
{$i++;
$idd=$row['id'];
?>
<tr id="<?php echo $i; ?>">
<td><?php echo $i;?></td>
<td><?php echo $row['name']." [".$row['code']."]";?></td>
<td><?php echo $row['mobile_no'];?></td>
<td><?php echo $row['wages'];?></td>
<td><?php echo fetchdepartmentname($row['depart_id']);?></td>
<?php
if(isset($_GET['emp_view']))
{
?>
<td>
<a class="btn btn-success btn-xs" role="button" href="view.php?emp=true&id=<?php echo $idd;?>"target="_blank" style="text-decoration:none;">
<i class="fa fa-th"></i></a>
</td>
<?php
}
else if(isset($_GET['emp_del']))
{
?>
<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;">
<div class="form-group" id="emp_place_here">
</div>
</td>
<tr>
</table>
<?php
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
else if(!empty($_GET['emp_depart_wise']))
{
?>
<table class="table table-bordered table-striped table-condensed table-hover flip-content" width="100%">
<tr>
<th colspan="4" style="text-align:center;background-color:#EBFCEE;">please fill required info for <?php echo fetchdepartmentname($_GET['emp_depart_wise']); ?>*</th>
</tr>
<?php
for($i=1;$i<=10;$i++)
{
?>
<tr>
<td><input class="form-control" placeholder="<?php echo $i; ?> Employee Name: " name="name<?php echo $i; ?>"></td>
<td><input class="form-control" placeholder="Mobile No." name="mobile_no<?php echo $i; ?>" id="mobile_no"></td>
<td><input class="form-control" placeholder="Wages" id="wages" name="wages<?php echo $i; ?>" onKeyUp="allLetter(this.value,this.id);"></td>
<td><input class="form-control" placeholder="Address" name="address<?php echo $i; ?>"></td>
</tr>
<?php
}
?>
</table>
{
while($row=@mysql_fetch_array($result))
{$i++;
$res_check=mysql_query("select `status` from `attendance` where `attendance_date`='".datefordb($_POST['attendance_date'])."' && `reg_id`='".$row['id']."'");
$row_check=@mysql_fetch_array($res_check);
?>
<?php
if($row['depart_id']==$mydepart)
{
}
else
{
$mydepart=$row['depart_id'];
?>
<tr>
<th colspan="5" style="background-color:#EBFCEE;"><?php echo fetchdepartmentname($row['depart_id']); ?> Employee</th>
</tr>
<?php
}
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $row['name'].' ['.$row['code'].']';?></td>
<td style="text-align:center;" class="has-success"><div id="show_p<?php echo $row['id']; ?>"><?php if($row_check['status']=='P') { ?> <div class="input-icon right"><i class="fa fa-check" data-original-title="success input!"></i></div><?php } ?></div><div class="radio-list"><label class="radio-inline" style="width: 100%;"><input class="P" onClick="fetch_att(this.value,<?php echo $row['id']; ?>)" type="radio" <?php if($row_check['status']=='P') { ?> checked <?php } ?> value="P" myid="<?php echo $row['id']; ?>" name="all<?php echo $i; ?>" ></label></div></td>
<td style="text-align:center;" class="has-error"><div id="show_a<?php echo $row['id']; ?>"><?php if($row_check['status']=='A' || empty($row_check['status'])) { ?> <div class="input-icon right"><i class="fa fa-check" data-original-title="success input!"></i></div><?php } ?></div><div class="radio-list"><label class="radio-inline" style="width: 100%;"><input type="radio" onClick="fetch_att(this.value,<?php echo $row['id']; ?>)" <?php if($row_check['status']=='A'||empty($row_check['status'])) { ?> checked <?php } ?> value="A" class="A" name="all<?php echo $i; ?>" myid="<?php echo $row['id']; ?>"> </label></div></td>
<td style="text-align:center;" class="has-warning"><div id="show_h<?php echo $row['id']; ?>"><?php if($row_check['status']=='H') { ?> <div class="input-icon right"><i class="fa fa-check" data-original-title="success input!"></i></div><?php } ?></div><div class="radio-list"><label class="radio-inline" style="width: 100%;"><input type="radio" class="H" myid="<?php echo $row['id']; ?>" onClick="fetch_att(this.value,<?php echo $row['id']; ?>)" <?php if($row_check['status']=='H') { ?> checked <?php } ?> value="H" name="all<?php echo $i; ?>" > </label></div></td>
</tr>
<?php
}
<!------------------------------------------------o v e r t i m e c a l c u l a t i o n e n d------------------------------------------------------------------------------->
<!------------------------------------------------A d v a n c e a m o u n t c a l c u l a t i o n s t a r t------------------------------------------------------------------>
<?php
$all_dates='';
?>
<div class="note note-success">
<span>
Showing <strong><?php echo fetchdepartmentname(strtoupper($depart_id)); ?> Advance</strong> Report from <b><?php echo dateforview($from); ?></b> To <b><?php echo dateforview($to); ?></b>
</span>
</div>
<form method="post" action="docburner.php">
<button type="submit" class="btn btn-success btn-xs diplaynone tooltips" title="Download in Excel" data-placement="bottom"><i class="fa fa-download"></i> Download in Excel</button>
<input type="hidden" value="<?php echo $_POST['from']; ?>" name="date_from">
<input type="hidden" value="<?php echo $_POST['to']; ?>" name="date_to">
<input type="hidden" value="<?php echo $_POST['depart_id']; ?>" name="depart_id">
<input type="hidden" value="advance" name="excel_for">
<input type="text" id="search_advance" style="float:right;" placeholder="search advance"/>
</form>
<div class="table-scrollable">
<table width="100%" id="general" class="table table-bordered table-striped table-condensed table-hover flip-content">
<thead class="flip-content">
<tr>
<td style="text-align:left !important;font-size:13px;font-weight:bold;">Name [code]</td>
