</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++;
}
}
?>
