employee_list_cells(_("Select an Employee: "), 'selected_id', null, _('New Employee'), true, check_value('show_inactive'));
$new_item = get_post('selected_id') == '';
end_row();
end_table();
if (get_post('_show_inactive_update')) {
$Ajax->activate('selected_id');
set_focus('selected_id');
}
} else {
hidden('selected_id', get_post('selected_id'));
}
//$_POST['leave_days'] = $_POST['monthly_loan'] = 0;
div_start('details');
if (isset($selected_id) && $selected_id != '') {
$_POST['empl_id'] = $_POST['selected_id'];
$myrow = get_employee($_POST['empl_id']);
$_POST['empl_id'] = $myrow["empl_id"];
$_POST['empl_name'] = $myrow["empl_name"];
$gross = $_POST['gross_salary'] = $myrow["gross_salary"];
start_table(TABLESTYLE2, "width=30%");
table_section_title(_("Employee Informations"));
hidden('empl_id', $_POST['empl_id']);
label_row(_("Employee Name:"), $_POST['empl_id'] . '-' . $_POST['empl_name']);
date_row(_("Date of Pay") . ":", 'date_of_pay');
label_row(_("Gross Pay:"), $_POST['gross_salary']);
hidden('gross_pay', $_POST['gross_salary']);
text_row(_("Number of Leave days :"), 'leave_days', null, 2, 40);
text_row(_("Monthly loan Amount:"), 'monthly_loan', null, 2, 40);
//submit_cells('RefreshInquiry', _("Show"),'',_('Show Results'), 'default');
end_table();
br();
} else {
$employee['password'] = get_employee($employee['employeeID'])['password'];
}
update_employee($employee);
}
$success_notification = 'Successfully saved';
}
} catch (Exception $e) {
$error_notification = $e->getMessage();
}
} else {
if (isset($_GET['employeeID'])) {
$employeeID = $_GET['employeeID'];
}
if (!empty($employeeID)) {
$employee = get_employee($employeeID);
}
}
?>
<script type="text/javascript">
sodon_create = {
init: function() {
$('#createForm').ajaxForm({
target:'#edit-target',
url:'employee_create.php'
});
},
success: function() {
$('#createModal').modal('hide');
sodon_main.list();
<?php
require "../settings.php";
if (isset($_POST["key"])) {
switch ($_POST["key"]) {
case "confirm":
$OUTPUT = show_report($_POST);
break;
case "xls":
$OUTPUT = show_xls($_POST);
break;
default:
$OUTPUT = get_employee();
}
} else {
$OUTPUT = get_employee();
}
// require ("../tmpl-print.php");
require "../template.php";
function get_employee()
{
db_connect();
$get_employees = "SELECT * FROM employees ORDER BY sname";
$run_employees = db_exec($get_employees) or errDie("Unable to get employees information.");
if (pg_numrows($run_employees) < 1) {
return "<li class='err'>No Employees Found.</li>";
} else {
$emp_drop = "<select name='employee'>";
while ($earr = pg_fetch_array($run_employees)) {
$emp_drop .= "<option value='{$earr['empnum']}'>{$earr['fnames']} {$earr['sname']} ({$earr['empnum']})</option>";
}
require_once '../util/main.php';
require_once '../model/database.php';
require_once '../model/employee_db.php';
$error_message = '';
if (!empty($_POST['username']) && !empty($_POST['password'])) {
try {
$sql = 'SELECT userID, userName, status, eFlag, password FROM users WHERE userName = :uname LIMIT 1';
$prestmt = $db->prepare($sql);
$prestmt->bindValue(':uname', $_POST['username']);
$prestmt->execute();
$user = $prestmt->fetch();
$userlogin = $_POST['username'];
$userpwd = $_POST['password'];
if (password_verify($userpwd, $user['password']) && $user['status'] == 'E' && $user['eFlag'] == '1') {
$employee = get_employee($user['userID']);
session_start();
$_SESSION['userId'] = $user['userID'];
$_SESSION['userName'] = $user['userName'];
$_SESSION['employeeTitle'] = $employee['title'];
header("Location: index.php");
} else {
$error_message = 'Your username or password was incorrect';
}
} catch (PDOException $e) {
display_db_error($e->getMessage());
}
}
?>
