</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_convence=0; $total_medical=0; $total_hra=0; $other_deductions=0; $side_allowance=0; $prof_tax=0; $tds=0; $start_date="01"; $Total=0; $flag=0; $grand_days=0; $emp_id=$row_dept['emp_id']; $employee_typ=getofficeDetail('employee_typ',$emp_id); $start_date =getdbDateSepretoe($_POST['txt_date_from']); $end_date = getdbDateSepretoe($_POST['txt_date_to']); $day1 = substr($_POST['txt_date_from'],0,2); $month1 = substr($_POST['txt_date_from'],3,2); $year1 = substr($_POST['txt_date_from'],6,4); $day2 = substr($_POST['txt_date_to'],0,2); $month2 = substr($_POST['txt_date_to'],3,2); $year2 = substr($_POST['txt_date_to'],6,4); //$day1 = $day1 + 1;
<td><?php echo $month_days = date("t", strtotime($year . "-" . $i . "-01")); ?> </td> <td><?php echo $no_present = getleavecountMonthly($emp_id, "P", $i, $year); ?> </td> <td><?php if ($i <= date('m')) { $total_month = 0; for ($j = 1; $j <= $month_days; $j++) { $date = mktime(0, 0, 0, $i, $j, $year); $dd = date('d', $date); $salary_ann = getSalaryDetail("basic", $emp_id, $year . '-' . $i . '-' . $dd); if (getofficeDetail('employee_typ', $emp_id) == 'daily_wages') { $per_day = $salary_ann / $month_days; } else { $per_day = $salary_ann / $month_days; } $total_month = $total_month + $per_day; } $total_month = round($total_month, 2); echo round($no_present * $total_month / $month_days); } ?> </td> <!--<td> </td> <td> </td>--> <td colspan="2"><?php if ($i <= date('m')) {
echo $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date); ?> </td> <td width="5%" align="center"><?php 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;
<td> :<?php echo getemployeeDetail('first_name', $emp_id); ?> <?php echo getemployeeDetail('last_name', $emp_id); ?> </td> </tr> <tr> <td> DATE OF JOINING </td> <td> :<?php echo getDatetime(getofficeDetail('date_joining', $emp_id)); ?> </td> </tr> </table> </td> <td> DESIGNATION :<?php echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, $date_month)); ?> </td> <td> DEPARTMENT:<?php echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $emp_id, $date_month)); ?> </td>