function EditList($parent = '0', $spacer = '') {
$sql = "select * from mpc_department_master where reference_id = '$parent' order by department_name";
$result = mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$num = mysql_num_rows($result) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
$spacer .= '- ';
while ($row = mysql_fetch_array($result)) {
if ($num == 0 || $row['reference_id'] == '0') {
$spacer = '';
}
?>
<tr bgcolor="#F2F7F9">
<td class="Text01"><?= $spacer . $row["department_name"] ?></td>
<td class="Text01"><?= getdeptDetail("department_name", "rec_id", $row["reference_id"]); ?></td>
</td>
<td class="Text01"><a href="add_department.php?rec_id=<?= $row['rec_id'] ?>&mode=edit">Edit</a></td>
<td class="Text01"><a href="javascript:;" onClick="overlay(<?= $row['rec_id'] ?>);">Delete</a></td>
</tr>
<?
EditList($row['rec_id'], $spacer);
}
}
}
$esic_rate_employer = $row['esic_rate_employer'];
$esic_number = $row['esic_number'];
$esic_nominee = $row['esic_nominee'];
$esic_relationship = $row['esic_relationship'];
$account_no = $row['account_no'];
$bank_name = $row['bank_name'];
$payment_mode = $row['payment_mode'];
$pf_deduction = $row['pf_deduction'];
}
}
$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'];
<tr>
<td align="left">Attendance Sheet for <?
if ($_POST["print_plant_name"] != "") {
echo '-Plant :' . $_POST["print_plant_name"];
}
?><?
if ($_POST["print_employee_type"] != "") {
echo '-Employee Type :' . $_POST["print_employee_type"];
}
?> <?
if ($_POST["print_department"] != "") {
echo '-Department :' . getdeptDetail('department_name', 'rec_id', $_POST["print_department"]);
}
?><?
if ($_POST["print_sub_department"] != "") {
echo '-Sub Department :' . getdeptDetail('department_name', 'rec_id', $_POST["print_sub_department"]);
}
?><?
if ($_POST["print_ticket_id"] != "") {
echo '-Employee ID.:' . $_POST["print_ticket_id"];
}
?></td>
</tr>
<tr>
<td valign="top">
<?
if (mysql_num_rows($result_prj) > 0) {
$sno = $start + 1;
?>
<table align="center" width="100%" cellpadding="0" cellspacing="0" class="table1" border="1">
<tr class="gredBg">
<?php
echo $row["ticket_no"];
?>
</td>
<td align="center">
<?php
echo $row["first_name"];
?>
<?php
echo $row["last_name"];
?>
</td>
<td align="center">
<?php
echo getdeptDetail('department_name', 'rec_id', $row["dept_id"]);
?>
</td>
<td align="center">
<?php
echo getDatetime($row["from_date"]);
?>
</td>
<td align="center">
<?
if ($row["to_date"] == '0000-00-00') {
echo 'TODAY';
} else {
echo getDatetime($row["to_date"]);
}
?>
{
?>
<tr <? if ($sno%2==1) { ?> bgcolor="#F5F2F1" <? } ?>>
<td align="center" width="13%"><?php
echo $sno;
?>
</td>
<td align="center"><?php
echo getemployeeDetailByTicket('first_name', $row['emp_id']);
?>
<?php
echo getemployeeDetailByTicket('last_name', $row['emp_id']);
?>
</td>
<td align="center"><?php
echo getdeptDetail('department_name', 'rec_id', $row['department']);
?>
</td>
<td align="center"><?php
echo getplantDetail('plant_name', 'rec_id', $row['plant_id']);
?>
</td>
<td align="center"><a href="javascript:;" onClick="return hs.htmlExpand(this)">
<img src="images/Find-icon.png" border="0" width="24" height="24" /></a>
<div class="highslide-maincontent">
<table align="center" width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="gredBg">
<td align="center"><b>Stock Item</b></td>
<td align="center"><b>Quatity</b></td>
<td align="center"><b>Description</b></td>
</tr>
<td align="left">
<div id="div_department_edit">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1" width="40%">Department</td>
<td align="left" width="60%">
<?php
echo getdeptDetail('department_name', 'rec_id', $main_dept_id);
?>
</td>
</tr>
<tr>
<td class="text_1" width="40%">Sub Department</td>
<td align="left" width="60%">
<div id="div_sub_department_edit"><?php
echo getdeptDetail('department_name', 'rec_id', $dept_id);
?>
<div id="div_rotation_type"></div>
</div>
</td>
</tr>
<tr>
<td class="text_1" width="40%">Effective From</td>
<td align="left" width="60%">
<div id="div_from_date_edit"><?php
echo $dept_from_date;
?>
<div id="div_rotation_type"></div>
</div>
</td>
<!--<td class="text_1">
<? include ("inc/dbconnection.php");?>
<? include ("inc/function.php");?>
<?
$url = "list_employee.php";
$product_name = "";
$dept_id = "";
if(isset($_GET["id"]))
{
$dept_id = $_GET["id"];
$old_dept_id = $_GET["old_dept_id"];
$old_main_id=getdeptDetail('reference_id','rec_id',$old_dept_id);
$emp_id = $_GET["str"];
}
?>
<table width="40%" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<?
$sql = "SELECT * FROM mpc_department_master where reference_id = '$dept_id' order by department_name";
$result_city = mysql_query ($sql) or die ("Error in : ".$sql."<br>".mysql_errno()." : ".mysql_error());
if(mysql_num_rows($result_city)>0)
{
?>
<select name="sub_department" id="sub_department">
<option value="">--Select--</option>
<?
while($row_city = mysql_fetch_array($result_city))
{
?>
<option value="<?php
echo $row_city['rec_id'];
header("Content-Disposition: attachment; filename=Advance_list-".$month."-".$year.".xls");
?>
<table width="98%" cellpadding="0" cellspacing="0" align="center" border="0">
<tr>
<td style="padding-left:5px; padding-top:5px;" valign="top">
<table width="100%" cellpadding="0" cellspacing="0" align="center" border="0">
<thead>
<tr>
<td align="center">Laxyo Solution Soft Pvt. Ltd.</td>
</tr>
<tr>
<td align="left">Salary Employee Report MONTH -<?=date("F",mktime(0, 0, 0,$month, 1, 0))?>,<?=$year?></td>
</tr>
<tr>
<td align="left">Salary Employee for <? if($_POST["print_plant_name"]!=""){echo '-Plant :'.$_POST["print_plant_name"]; } ?><? if($_POST["print_employee_type"]!=""){echo '-Employee Type :'.$_POST["print_employee_type"]; } ?> <? if($_POST["print_department"]!=""){echo '-Department:'.getdeptDetail('department_name','rec_id',$_POST["print_department"]);}?><? if($_POST["print_sub_department"]!="")
{echo '-Sub Department:'.getdeptDetail('department_name','rec_id',$_POST["print_sub_department"]);}?><? if($_POST["print_ticket_id"]!="")
{echo '-Employee ID.:'.$_POST["print_ticket_id"];}?></td>
</tr>
</thead>
<tr>
<td valign="top">
<?
if(mysql_num_rows($result_prj)>0)
{
$sno = $start+1;
?>
<table align="center" width="100%" cellpadding="0" cellspacing="0" class="table1" border="1">
<thead>
<tr>
<td width="5%" align="center"><b>Sno.</b></td>
<td width="5%" align="center"><b>Emp Id</b></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 rowspan="2">Wage Rate</td>
<!--<td rowspan="2">No.of Days Maternity Leave With Wage</td>
<td rowspan="2">No. Of Days Layoff</td>-->
<td colspan="3">PREVILAGE EARNED LEAVE</td>
<td colspan="3">CASUAL LEAVE</td>
<td rowspan="2">Total Paid <br/>Leave</td>
<td>
:<?php
echo getDatetime(getAccountDetail('date_releaving', $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:</td><td><?php
echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $emp_id, $date_month));
?>
</td>
</tr>
<tr>
<td colspan="4">
<table border="1" width="100%">
<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 rowspan="2">Wage Rate</td>
<!--<td rowspan="2">No.of Days Maternity Leave With Wage</td>
<td rowspan="2">No. Of Days Layoff</td>-->
<td colspan="3">PREVILAGE EARNED LEAVE</td>
<td colspan="3">CASUAL LEAVE</td>
<tr>
<td colspan="2">
<table width="1000px">
<tr>
<td width="51%">
DEPT/SHIFT WISE Attendance REPORT OF DATE:<?=$date?>
</td>
<td width="49%" align="right">
SHIFT:<?=$shift?>
</td>
</tr>
</table>
</tr>
<tr>
<td>
Department-<?=getdeptDetail('department_name','rec_id',$sub_department)?>
</td>
</tr>
<tr>
<td colspan="2">
<table width="100%">
<tr>
<td width="11%" align="center">
SNO </td>
<td width="13%" align="center">
EMPLOYEE ID </td>
<td width="33%" align="left">
NAME </td>
<td width="21%" align="left">
Designation </td>
<td width="22%" align="center">
?>
</td>
<td width="49%" align="right">
SHIFT:<?php
echo $shift;
?>
</td>
</tr>
</table>
</tr>
<tr>
<td>
Department-<?php
echo getdeptDetail('department_name', 'rec_id', $sub_department);
?>
</td>
</tr>
<tr>
<td colspan="2">
<table width="100%">
<tr>
<td width="11%" align="center">
SNO </td>
<td width="13%" align="center">
EMPLOYEE ID </td>
<td width="33%" align="left">
NAME </td>
<td width="22%" align="left">
Designation </td>
$from_date = "";
$to_date = "";
if (isset($_GET["id"])) {
$emp_id = $_GET["id"];
//$dept_id = $_GET["id"];
$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);
$dept_id = $row['department'];
$rec_id = $row['emp_id'];
$sql = "select * from mpc_department_employee where emp_id = '{$rec_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"];
$dept_sub_id = $row["dept_id"];
$main_dept_id = getdeptDetail('reference_id', 'rec_id', $dept_sub_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"]);
}
$rec_id = $row["rec_id"];
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="100%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
$row = mysql_fetch_array($result);
echo "department_id="."<br>".$dept_id=$row['department'];
$rec_id=$row['emp_id'];
echo $sql = "select * from mpc_department_employee where emp_id = '$rec_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
echo $row = mysql_fetch_array($result);
echo "<pre>";
print_r($row);
echo "hello";
echo "<br><br><br><br>";
// $emp_id = $row["emp_id"];
echo "dept_sub_id"."<br>".$dept_sub_id = $row["dept_id"]."<br>";
echo "main_dept_id"."<br>".$main_dept_id=getdeptDetail('reference_id','rec_id',$dept_sub_id);
echo "from date"."<br>".$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"]);
}
echo "****Rec_id".$rec_id = $row["rec_id"];
}
?>
<form name="frm" action="<?php
echo $url;
?>
</tr>
<tr>
<td>
Off Day.
</td>
<td style="border-bottom:1px solid #333333;"><?php
echo $off_day;
?>
</td>
<td colspan="2">
Department
</td>
<td colspan="2" style="border-bottom:1px solid #333333;">
<?php
echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $row['rec_id'], $date_month));
?>
</td>
</tr>
<tr>
<td>
Designation
</td>
<td style="border-bottom:1px solid #333333;">
<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['rec_id'], $date_month));
?>
</td>
<td colspan="2">
Date Of Joining
</td>
