<!--<input type="hidden" name="emp_id" id="emp_id" value="<?//=$row["ticket_no"]?>"> -->
<!--<input type="text" name="em" id="em" readonly="readonly" value="<?//=$row["ticket_no"]?>" /> -->
</td>
<td align="center">
<?php
echo $row["first_name"];
?>
<?php
echo $row["last_name"];
?>
</td>
<td align="center">
<?php
echo getdesignationMaster('designation_name', 'rec_id', $row["designation_id"]);
?>
<input type="hidden" name="designation" id="designation_id" value="<?php
echo $row["designation_id"];
?>
" />
</td>
<td align="center">
<?php
echo $row["from_date"];
?>
</td>
<td align="center">
<? if($row["to_date"]=='0000-00-00'){echo 'TODAY';}else{echo $row["to_date"]; }?>
</td>
<td align="center"><a href="javascript:;" onClick="get_frm('edit_designation_list.php','<?php
</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++;
}
}
}
}
}
<td align="center"><?php
echo $row_doc['first_name'];
?>
-<?php
echo $row_doc['last_name'];
?>
</td>
<?php
if ($type != "Staff") {
?>
<td>
<?php
if ($row_doc['badli_as'] == "") {
echo 'None';
} else {
echo getdesignationMaster('designation_name', 'rec_id', $row_doc['badli_as']);
}
?>
</td>
<?php
}
?>
<td align="center"><?php
echo $row_doc['attendance_status'];
?>
</td>
</tr>
<?php
$sno++;
}
</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;
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;
$designation=$_GET['designation'];
$sql = "select * from mpc_employee_master where ticket_no='$emp_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
$emp_designation_id=$row['designation'];
//$designation_id = $_GET["id"];
$sql = "select * from mpc_designation_employee where designation_id = '$emp_designation_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
//$emp_id = $row["emp_id"];
//$emp_designation_id = $row["designation_id"];
$emp_type=getdesignationMaster('emp_category','rec_id',$emp_designation_id);
$from_date = getDatetime($row["from_date"]);
if($row["to_date"]=='0000-00-00')
{
$to_date = date('d/m/Y');
}
else
{
$to_date = getDatetime($row["to_date"]);
}
//$emp_id = $row["emp_id"];
$rec_id=$row['rec_id'];
}
?>
<form name="frm" action="<?php
echo $url;
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1" width="40%">Employee Type</td>
<td align="left" width="60%">
<?php
echo $emp_type = getdesignationMaster('emp_category', 'rec_id', $designation_id);
?>
</td>
<td class="text_1">
</td>
</tr>
<tr>
<td class="text_1" width="40%">Designation</td>
<td align="left" width="60%">
<div id="div_designation_edit"><?php
echo getdesignationMaster('designation_name', 'rec_id', $designation_id);
?>
</div>
</td>
</tr>
<tr>
<td class="text_1" width="40%">Effective From</td>
<td align="left" width="60%">
<div id="div_from_date_edit_des"><?php
echo $designation_from_date;
?>
<div id="div_rotation_type"></div>
</div>
</td>
<td class="text_1">
<a href="javascript:;" onclick="post_frm('change_category.php','<?php
</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 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
?>
</td>
<td align="center"><?php
echo $ticket_id;
?>
</td>
<td align="center"><?php
echo $first_name;
echo $last_name;
?>
</td>
<? if($type!="Staff")
{
?>
<td>
<? if($row_doc['badli_as']==""){echo 'None';}else{ echo getdesignationMaster('designation_name','rec_id',$row_doc['badli_as']); }?>
</td>
<?
}
?>
<td align="center"><?php
echo $row_doc['shift'];
?>
</td>
<td align="center"><?php
echo $row_doc['attendance_status'];
?>
</td>
<td>
<a href="javascript:;" onclick="get_frm_focus('get_employee_list_udate.php','<?php
echo $id;
}
$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>
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);
}
</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;
}
}
$sql = "SELECT * FROM " . $mysql_table_prefix . "department_employee where emp_id = '$emp_offical_edit1' and to_date='00-00-0000'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$dept_id = $row['dept_id'];
$dep = getdeptDetail('reference_id', 'rec_id', $dept_id);
}
$sql = "SELECT * FROM " . $mysql_table_prefix . "designation_employee where emp_id = '$emp_offical_edit1' and to_date='00-00-0000'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$designation_id = $row['designation_id'];
$emp_category = getdesignationMaster('emp_category', 'rec_id', $designation_id);
}
$sql = "SELECT * FROM mpc_shift_detail where emp_id = '$emp_offical_edit1' and to_date='0000-00-00'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$shift = $row['shift'];
}
}
$sql = "SELECT * FROM mpc_weekly_off_employee where emp_id = '$emp_offical_edit1' and to_date='0000-00-00'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$off_day = $row['off_day'];
</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++;
}
}
?>
