コード例 #1
0
ファイル: register_leave.php プロジェクト: ViShNuPrAtap/lss
            </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>
コード例 #2
0
    }
    $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') {
コード例 #3
0
	<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>