Example #1
0
			<td width="10%" align="center"><b>Hrs</b></td>
			<td width="10%" align="center"><b>Shift</b></td>
			<td align="center"><b>Check Here</b></td>
		</tr>
<? $sno_d =1;
while($row=mysql_fetch_array($result_prj)){
	$emp_id=$row['id'];
	
	$total_salary_earing=0;
	$total_salary_basic=getSalaryDetail("basic",$emp_id,getdbDate($date_upto));
	if($row['employee_typ']=='daily_wages'){
		$salary_basic=$total_salary_basic/8;
	}else{
		$salary_basic=($total_salary_basic/31)/8;
	}
	$good_work=getGoodWorkBydate($emp_id,getdbDate($date_upto));
	if($good_work!=""){?>
		<tr <? if ($sno_d%2==1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
			<td width="5%" align="center"><?php 
echo $sno_d;
?>
</td>
			<td width="5%" align="center"><?php 
echo $row['ticket_no'];
?>
<input type="hidden" name="cardNo" id="cardNo" value="<?php 
echo $sno_d;
?>
"  /></td>
			<td width="5%" align="left"><? $empName = $row['first_name'].' '.$row['last_name']?><input type="hidden" name="empName" id="empName" value="<?php 
echo $empName;
  while($row=mysql_fetch_array($result_prj))
  {
  
  $emp_id=$row['id'];														
                                                                  
  $total_salary_earing=0;
  $total_salary_basic=getSalaryDetail("basic",$emp_id,getdbDate($month));
  if($row['employee_typ']=='daily_wages')
      {
          $salary_basic=$total_salary_basic/8;
      }
      else
      {
          $salary_basic=($total_salary_basic/31)/8;
      }
  $good_work=getGoodWorkBydate($emp_id,getdbDate($month));
  if($good_work!="")
  {
   ?>
 <tr <? if ($sno%2==1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
  <td width="5%" align="center"><?=$sno?></td>
  <td width="5%" align="center"><?=$row['ticket_no']?></td>
  <td width="5%" align="left">
  <?=$row['first_name']?> <?=$row['last_name']?><br/>
  </td>
  <td> 
      <?=getdesignationMaster('designation_name','rec_id',getdesignationDetail('designation_id',$emp_id,getdbDate($month)));?>  	
  </td>
      <td>
          <?=$total_salary_basic?></td>
      <td>
 if ($i != 0) {
     $date = $date + 86400;
 } else {
     $date = $date - 86400;
 }
 $today = date('Y-m-d', $date);
 //echo "$today ";
 $yy = date('Y', $date);
 $mm = date('m', $date);
 $dd = date('d', $date);
 $date1 = $yy . "-" . $mm . "-" . $dd;
 echo "<td>";
 if ($row['Day'] >= $dd and $row['Month'] == $mm and $row['Year'] == $yy) {
     echo 'N/A';
 } else {
     $good_work = getGoodWorkBydate($row['emp_id'], $date1);
     $daily_good_work_array = explode(':', $good_work);
     if ($good_work != "") {
         if ($daily_good_work_array[1] == 0) {
             $daily_good_work_array[1] = "00";
         }
         echo $daily_good_work_array[0] . ":" . $daily_good_work_array[1];
     } else {
         echo "0.0";
     }
     echo "</td>";
     if ($good_work != "") {
         $good_work_array = explode(':', $good_work);
         $good_work_min = $good_work_min + $good_work_array[1];
         $good_work_hour = $good_work_hour + $good_work_array[0];
         if ($good_work_min == 60) {