function show_login()
{
$data = array();
$data['system_message'] = '';
if (Input::get('op')) {
$username = Input::get('username');
$password = Input::get('password');
if ($username == "" || $password == "") {
$data['system_message'] = 'Please complete the fields!';
} else {
// Encript password
$password = do_hash($password, 'md5');
$u = new User_m();
$u->where('username', $username);
$u->where('password', $password);
$u->where('stat', 'Active');
$u->get();
// Check if the user exists
if ($u->exists()) {
// Lets check if the idle function is enable
// Seconds before logout if user is idle
$seconds_user_idle = Setting::getField('seconds_user_idle');
if ($seconds_user_idle != '') {
unset($this->session->sess_expiration);
$this->session->sess_expiration = $seconds_user_idle;
$this->load->library('session');
}
$session_data = array('user_id' => $u->id, 'username' => $u->username, 'lname' => $u->lname, 'office_id' => $u->office_id, 'group_id' => $u->group_id, 'user_type' => $u->user_type);
Session::put($session_data);
redirect('home/home_page', 'refresh');
} else {
$data['system_message'] = 'Invalid username or password!';
}
}
}
return View::make('login', $data);
}
function user_options($add_blank = FALSE)
{
$u = new User_m();
$u->where('username !=', 'mannysoft');
$rows = $u->order_by('username')->get();
$minute = 0;
if ($add_blank == TRUE) {
$options[''] = '';
}
$options[0] = '-- All --';
foreach ($rows as $row) {
$options[$row->username] = $row->username . ' -- ' . $row->lname . ', ' . $row->fname;
}
return $options;
}
function up()
{
$lgu_code = Setting::getField('lgu_code');
if ($lgu_code == 'marinduque_province') {
$u = new User_m();
$u->where('group_id !=', 1000);
$users = $u->get();
foreach ($users as $user) {
//echo $user->user_type;
//echo $user->group_id;
// Lets update the
$us = new User_m();
$us->get_by_id($user->id);
$us->group_id = $user->user_type;
$us->save();
// Lets assign permission
if ($user->group_id == 5) {
$p = new Permission_m();
$p->where('group_id', $user->group_id);
$p->where('module', 'attendance')->get();
$p->group_id = $user->group_id;
$p->module = 'attendance';
$p->roles = json_encode(array('view_attendance', 'dtr'));
$p->save();
$p = new Permission_m();
$p->where('group_id', $user->group_id);
$p->where('module', 'leave_manage')->get();
$p->group_id = $user->group_id;
$p->module = 'leave_manage';
$p->roles = json_encode(array('file_leave', 'leave_apps', 'reports'));
$p->save();
$p = new Permission_m();
$p->where('group_id', $user->group_id);
$p->where('module', 'manual_manage')->get();
$p->group_id = $user->group_id;
$p->module = 'manual_manage';
$p->roles = json_encode(array('cto', 'cto_apps'));
$p->save();
}
if ($user->group_id == 3) {
$p = new Permission_m();
$p->where('group_id', $user->group_id);
$p->where('module', 'attendance')->get();
$p->group_id = $user->group_id;
$p->module = 'attendance';
$p->roles = json_encode(array('view_attendance', 'dtr', 'jo', 'double_entries', 'view_absences', 'view_late', 'view_ob', 'view_tardiness', 'view_ten_tardiness'));
$p->save();
$p = new Permission_m();
$p->where('group_id', $user->group_id);
$p->where('module', 'manual_manage')->get();
$p->group_id = $user->group_id;
$p->module = 'manual_manage';
$p->roles = json_encode(array('login', 'cto', 'cto_apps', 'cto_forward_balance', 'office_pass'));
$p->save();
}
}
if ($this->db->table_exists('groups')) {
$g = new Group_m();
$g->get();
// We will populate only if the groups
// table is empty
if (!$g->exists()) {
$this->db->order_by('id');
$q = $this->db->get('user_group');
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $row) {
$g = new Group_m();
$g->name = $row['name'];
$g->description = $row['description'];
$g->save();
}
}
}
}
}
}
