<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) {