$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>