{
$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);
?>
<tr id="<?php echo $i; ?>">
<td><?php echo $i;?></td>
<td><?php echo fetchemployeename($row['reg_id']);?></td>
<td><?php echo $row_fname['mobile_no']; ?></td>
<td><?php echo dateforview($row['overtime_date']);?></td>
<th><?php echo $mytime; ?></th>
<?php
if(isset($_GET['overtime_view']))
{
?>
<td>
<a class="btn btn-success btn-xs" role="button" href="view.php?overtime=true&id=<?php echo $idd;?>"target="_blank" style="text-decoration:none;">
<i class="fa fa-th"></i></a>
</td>
<?php
}
else if(isset($_GET['overtime_delete']))
{
?>
<td>
<div class="form-group">
<label class="col-md-3 control-label">Amount</label>
<div class="col-md-4">
<div class="input-icon right">
<i class="fa"></i>
<input class="form-control" name="amount" value="<?php echo $row_data['amount']; ?>" id="amount" onKeyUp="allLetter(this.value,this.id)">
</div>
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label">Advance Given Date</label>
<div class="col-md-4">
<div class="input-icon right">
<i class="fa"></i>
<input class="form-control date-picker" value="<?php echo dateforview($row_data['advance_given_date']); ?>" name="advance_given_date" data-date-format="dd-mm-yyyy">
</div>
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label">Reason/Remarks</label>
<div class="col-md-4">
<div class="input-icon right">
<i class="fa"></i>
<textarea class="form-control" name="remarks" rows="2" style="resize:none;"><?php echo $row_data['remarks']; ?></textarea>
</div>
</div>
</div>
</select>
<span class="input-group-btn">
<button class="btn btn-info" type="submit" name="attendance_fill">NEXT <i class="fa fa-arrow-circle-right "></i></button>
</span>
</div>
</div>
</div>
<?php
if(isset($_POST['attendance_fill']))
{
?>
<div class="table-responsive" style="margin-top:5%;">
<div class="note note-success">
<p>
Showing <strong><?php if(!empty($_POST['depart_id'])) { echo fetchdepartmentname(strtoupper($_POST['depart_id'])); } else { echo "All Department"; } ?></strong> Attendance <strong>@ <?php echo dateforview($_POST['attendance_date']); ?></strong><span id="notification" style="margin-left:200px;color:#E35C59;font-weight:bold;font-size:14px;"></span>
</p>
</div>
<table width="100%" class="table table-bordered table-striped table-condensed table-hover flip-content">
<thead>
<tr>
<th rowspan="2" style="vertical-align:middle; text-align:center;">SL.</th>
<th rowspan="2" style="vertical-align:middle; text-align:center;">Name [code]</th>
<th style="text-align:center;">P</th>
<th style="text-align:center;">A</th>
<th style="text-align:center;">H</th>
</tr>
<tr>
<td style="text-align:center;" ><div class="radio-list"><label class="radio-inline" style="width: 100%;"><input what="P" type="radio" class="attendance" name="for_p" ></label></div></td>
<td style="text-align:center;" ><div class="radio-list"><label class="radio-inline" style="width: 100%;"><input what="A" type="radio" class="attendance" id="second" name="for_p" ></label></div></td>
</div>
</form>
<?php
if(isset($_POST['done']))
{
$from=$_POST['from'];
$to=$_POST['to'];
?>
<hr/>
<div class="note note-success">
<p>
Showing <strong>Department</strong> Report from <b><?php echo dateforview($from); ?></b> To <b><?php echo dateforview($to); ?></b>
</p>
</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="department" name="excel_for">
</form>
<div class="table-scrollable">
<?php
$datePeriod_1 = returnDates($from, $to);
foreach($datePeriod_1 as $date_1) {
//$date->format('d-m-Y'), PHP_EOL;
$all_dates_1[]=$date_1->format('d-m-Y');}
?>
<!------------------------------------------------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>
$sql="select * from `advance` order by `id` desc ";
else
$sql=$qry.$q1.$q2.$q3.$q4;
$result= @mysql_query($sql);
if($result)
{
while($row=mysql_fetch_array($result))
{$i++;
$idd=$row['id'];
$res_fname=mysql_query("select `mobile_no` from registration where `id`='".$row['reg_id']."'");
$row_fname=@mysql_fetch_array($res_fname);
?>
<tr id="<?php echo $i; ?>">
<td><?php echo $i;?></td>
<td><?php echo fetchemployeename($row['reg_id']); ?></td>
<td><?php echo dateforview($row['advance_given_date']);?></td>
<td><?php echo $row_fname['mobile_no'];?></td>
<td><?php echo $row['amount'];?></td>
<?php
if(isset($_GET['advance_view']))
{
?>
<td>
<a class="btn btn-success btn-xs" role="button" href="view.php?advance=true&id=<?php echo $idd;?>"target="_blank" style="text-decoration:none;">
<i class="fa fa-th"></i></a>
</td>
<?php
}
else if(isset($_GET['advance_del']))
{
?>
</div>
</form>
<?php
if(isset($_POST['done']))
{
$depart_id=$_POST['depart_id'];
$from=$_POST['from'];
$to=$_POST['to'];
?>
<hr/>
<div class="note note-success">
<p>
Showing <strong>Total Amount</strong> Report from <b><?php echo dateforview($from); ?></b> To <b><?php echo dateforview($to); ?></b>
</p>
</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="totalamount" name="excel_for">
</form>
<div class="table-scrollable">
<table width="100%" id="general_last" class="table table-bordered table-striped table-condensed table-hover flip-content">
<thead class="flip-content">
<tr>
<th style="text-align:left;">Name of Department</th>
<th>Attendance</th>
<th>Salary</th>
else
echo '<option value="'.$row['id'].'">'.$row['name']." [".$row['code']."]".'</option>';
}
?>
</select>
</div>
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label">Overtime Date</label>
<div class="col-md-4">
<div class="input-icon right">
<i class="fa"></i>
<input class="form-control date-picker" name="overtime_date" value="<?php echo dateforview($row_data['overtime_date']); ?>" data-date-format="dd-mm-yyyy">
</div>
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label">Total Overtime</label>
<div class="col-md-2">
<select name="total_overtime_hh" class="form-control select2me">
<option value="">--HH--</option>
<?php
list($before_dot, $after_dot) = explode('.', $row_data['total_overtime']);
for ($i = 0; $i <24; $i++) {
if($i<10)
if($before_dot=="0".$i)