</form> </td> </tr> <tr> <td> <table> <tr> <td> FULL NAME </td> <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> <tr> <td>
} $sql = "delete from " . $mysql_table_prefix . "loan_employee where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "official_detail where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "plant_employee where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "rotation_type_employee where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "salary_master where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "shift_detail where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $sql = "delete from " . $mysql_table_prefix . "weekly_off_employee where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $employee_picture = getemployeeDetail('employee_picture', $rec_id); if ($employee_picture != "") { unlink("employee_picture/thumb/{$employee_picture}"); unlink("employee_picture/{$employee_picture}"); } $sql = "delete from " . $mysql_table_prefix . "employee_master where rec_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); $msg = "Employee Sucessfully Deleted"; } if (isset($_POST["btn_del_unreleaved"])) { $rec_id = $_POST["hidden_overlay_realeaved"]; $sql = "update " . $mysql_table_prefix . "account_detail set date_releaving='0000-00-00' where emp_id = '" . $rec_id . "'"; mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); } if (isset($_GET['start'])) { if ($_GET['start'] == 'All') {
<tr> <td align="center" colspan="3"> <h3>FORM-18</h3> (Prescribed Under Rule 102) <h3>Register Of Leave With Wages</h3> </td> </tr> <tr> <td> <table> <tr> <td> FULL NAME </td> <td> :<?=getemployeeDetail('first_name',$emp_id)?> <?=getemployeeDetail('last_name',$emp_id)?> </td> </tr> <tr> <td> DATE OF JOINING </td> <td> :<?=getDatetime(getofficeDetail('date_joining',$emp_id))?> </td> </tr> <tr> <td> DATE OF DISCHARGE </td> <td>