function up() { if ($this->db->table_exists('groups')) { $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(); } } } }
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(); } } } } } }