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>