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()); } } ?>