</td> <td><?php echo $row_emp['ticket_no']; ?> </td> <td> <?php echo $row_emp['first_name']; ?> <?php echo $row_emp['last_name']; ?> </td> <td> <?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row_emp['emp_id'], $db_date)); ?> </td> <td> <?php echo getDatetime($row_emp['date_joining']); ?> </td> </tr> <? $s++; } } } } }
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> <?=$good_work?> </td> <td> <? $good_work=explode(':',$good_work); $good_work_hour=$good_work[0]; $net_pay=$salary_basic*$good_work[0]; if($good_work[1]=="30") { $net_pay=$net_pay+($salary_basic/2); }
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; ?> " /><br/></td> <td><?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, getdbDate($date_upto))); echo $desig; ?> <input type="hidden" name="designation" id="designation" value="<?php echo $desig; ?> " /></td> <td><?php echo $total_salary_basic; ?> </td> <td><?php echo $good_work; ?> <input type="hidden" name="goodWork" id="goodWork" value="<?php echo $good_work;
</tr> <? while ($row = mysql_fetch_array($result_prj)) { $present = 0; $absent = 0; $h = 0; $wo = 0; $Pl = 0; $Cl = 0; $Total = 0; ?> <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="15%" align="left"><?= $row['first_name'] ?> <?= $row['last_name'] ?></td> <td width="15%" align="center"><?= getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date)); ?> </td> <? $start_date = "01"; $day1 = $start_date; $month1 = $month; $year1 = $year; $day1 = $day1 + 1; $end_date = date("t", strtotime($year . "-" . $month . "-01")); $day2 = $end_date; $month2 = $month; $year2 = $year;
?> </td> <td width="5%" align="center"> <?php echo $row['first_name']; ?> <?php echo $row['last_name']; ?> <br/> </td> <td width="15%" align="center"><?php echo getfamilyDetail('father_name', $emp_id); ?> <br/><?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, $date_month)); ?> </td> <td align="center"> <?php echo $basic_rate; ?> <br/> <?php echo $row_salary_deduction['salary_house_rent']; ?> </td> <td align="center"><?php echo $Total; ?> <br/> <?php
</tr> <? while ($row = mysql_fetch_array($result_prj)) { $present = 0; $absent = 0; $h = 0; $wo = 0; $Pl = 0; $Cl = 0; $HalfCl = 0; $Total = 0; ?> <tr <? if ($sno % 2 == 1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt"> <td align="center"><?= $sno ?><br/><?= $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date) ?></td> <td align="center"><?= $row['ticket_no'] ?></td> <td align="left" ><?= $row['first_name'] ?> <?= getfamilyDetail('father_name', $row['id']) ?><br/><?= getDatetime(getofficeDetail('date_joining', $row['id'])) ?>/<?= getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date)); ?></td> <? $start_date = "01"; $day1 = $start_date; $month1 = $month; $year1 = $year; $day1 = $day1 + 1; $end_date = date("t", strtotime($year . "-" . $month . "-01")); $day2 = $end_date; $month2 = $month; $year2 = $year;
} $total_esi=ceil("$total_esi"); $total_deductions=round($total_pf)+$total_esi+$total_advance+$other_deductions+$prof_tax+$tds+$total_loan+$monthDeduction; $net_salary=$total_earning-$total_deductions; $grand_days=$grand_days+$Total; ?> <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="center"> <?=$row['first_name']?> <?=$row['last_name']?><br/> </td> <td width="15%" align="center"><?=getfamilyDetail('father_name',$emp_id)?><br/><?=getdesignationMaster('designation_name','rec_id',getdesignationDetail('designation_id',$emp_id,$date_month));?></td> <td align="center"> <?=$basic_rate?> <br/> <?=$row_salary_deduction['salary_house_rent']?> </td> <td align="center"><?=$Total?><br/> <?=$total_advance?> <br/> <?=$row_salary_deduction['salary_fine']?></td> <td align="center"> <?=round($total_salary_basic,2)?> <br/> <?=round($total_loan,2)?> <br/> <?=$row_salary_deduction['salary_damage']?> </td> <td align="center"> <?=round($total_lta,2)?> <br/>
echo $row['ticket_no']; ?> </td> <td width="15%" align="left"><?php echo $row['first_name']; ?> <?php echo getfamilyDetail('father_name', $row['id']); ?> <br/> <?php echo getDatetime(getofficeDetail('date_joining', $row['id'])); ?> / <?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date)); ?> </td> <?php $start_date = "01"; $day1 = $start_date; $month1 = $month; $year1 = $year; $day1 = $day1 + 1; $end_date = date("t", strtotime($year . "-" . $month . "-01")); $day2 = $end_date; $month2 = $month; $year2 = $year; $start_date = "{$year1}-{$month1}-{$day1}"; $end_date = "{$year2}-{$month2}-{$day2}"; $date = mktime(0, 0, 0, $month1, $day1, $year1);
<td> :<?=getDatetime(getofficeDetail('date_joining',$emp_id))?> </td> </tr> <tr> <td> DATE OF DISCHARGE </td> <td> :<?=getDatetime(getAccountDetail('date_releaving',$emp_id))?> </td> </tr> </table> </td> <td> DESIGNATION :<?=getdesignationMaster('designation_name','rec_id',getdesignationDetail('designation_id',$emp_id,$date_month));?> <br/> Year:<?=$year?> </td> <td> DEPARTMENT:<?=getdeptDetail('department_name','rec_id',getdepartmentDetail('dept_id',$emp_id,$date_month));?> </td> </tr> <tr> <td colspan="3"> <table border="1" width="100%" class="tableborder" cellpadding="0" cellspacing="0"> <tr> <td rowspan="2">Month</td> <td rowspan="2">No. of <br/>Working Days</td> <td rowspan="2">No of Days <br/>Work Performed</td>
</td> <td width="15%" align="left"> <?php echo getofficeDetail('grade', $emp_id); ?> </td> <td width="15%" align="left"> <?php echo getofficeDetail('employee_typ', $emp_id); ?> </td> <td width="15%" align="left"> <?php echo getdesignationMaster('emp_category', 'rec_id', getdesignationDetail('designation_id', $emp_id, getdbDateSepretoe($txt_from_date))); ?> </td> <td width="15%" align="left"> <?php echo getSalaryDetail('basic', $emp_id, getdbDateSepretoe($txt_from_date)); ?> </td> <td width="15%" align="left"> <?php echo getDatetime(getofficeDetail('date_joining', $emp_id)); ?> </td>
</td> <td align="center"><?php echo $row_emp['ticket_no']; ?> </td> <td align="left"> <?php echo $row_emp['first_name']; ?> <?php echo $row_emp['last_name']; ?> </td> <td align="left"> <?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row_emp['emp_id'], getdbDateSepretoe($date))); ?> </td> <td align="center"> <?php echo $row_emp['attendance_status']; ?> </td> </tr> <?php $s++; } } ?>