1: <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
2: class Model_employee extends CI_Model{
3: public function login(){
4: if($this->input->post('action')=='login'){
5:
6: $this->form_validation->set_rules('uemail', 'Username', 'required');
7: $this->form_validation->set_rules('upass', 'Password', 'required');
8: if ($this->form_validation->run() != FALSE){
9: $user = $this->db->from('xenon_employee')->join('xenon_role','role_id = empl_role')->where('empl_email',$this->input->post('uemail'))->where('empl_password',md5($this->input->post('upass')))->where('xenon_employee.is_deleted','n')->get();
10: if($user->num_rows() > 0){
11:
12: $this->session->set_userdata('empl_id',$user->row()->empl_id);
13: $this->session->set_userdata('empl_dname',$user->row()->empl_dname);
14: $this->session->set_userdata('empl_email',$user->row()->empl_email);
15: $this->session->set_userdata('empl_perm',$user->row()->role_perm);
16: $this->session->set_userdata('role_assigned',$user->row()->role_assigned);
17: $this->session->set_userdata('role_perm',$user->row()->role_perm);
18: $this->session->set_userdata('role_id',$user->row()->role_id);
19: redirect('employee');
20: }else{
21:
22: $this->session->set_userdata('error','Authentication failed. Enter correct information.');
23: }
24: }else{
25: $this->session->set_userdata('error','Authentication failed. Enter correct information.');
26: }
27: }
28: }
29: public function browse(){
30: return $this->db->from('xenon_employee')->join('xenon_role','xenon_employee.empl_role = xenon_role.role_id')->where('empl_id !=',0)->get();
31: }
32: public function render($employee){
33: return '
34: <tr>
35: <td align="center">'.$employee->empl_id.'</td>
36: <td>'.$employee->empl_dname.'</td>
37: <td>'.$employee->empl_email.'</td>
38: <td align="center">'.$employee->role_name.'</td>
39: <td align="center"><a href="'.site_url('employee/edit/'.urlencode(base64_encode($employee->empl_id))).'">Edit</a> | <a href="#">Delete</a>
40: </tr>
41: ';
42: }
43: public function error(){
44: return '
45: <tr>
46: <td colspan="5">No employees found</td>
47: </tr>
48: ';
49: }
50: public function pick($enc_id){
51: return $this->db->from('xenon_employee')->join('xenon_role','role_id=empl_role')->where('empl_id',base64_decode(urldecode($enc_id)))->get()->row();
52: }
53:
54: function get_selected_articles(){
55: $selected_titles = $this->session->userdata('selected_articles');
56: echo '<table class="riz_grid" cellpadding="0" cellspacing="0">';
57: echo '<thead><tr><th colspan="2">Topic</th></thead><tbody>';
58: if(is_array($selected_titles)){
59: if(count($selected_titles) > 0){
60: foreach($selected_titles as $key=>$val){
61: if($val!=''){
62: echo '<tr>';
63: echo '<td align="center"><input type="checkbox" name="selected[]" checked = "checked" value="'.$key.'"></td>';
64: echo '<td>'.$val.'</td>';
65: echo '</tr>';
66: }
67: }
68: }else{
69: echo '<tr><td colspan="2">No Articles Selected</td></tr>';
70: }
71: }else{
72: echo '<tr><td colspan="2">No Articles Selected</td></tr>';
73: }
74: echo '</tbody></table>';
75: }
76:
77: function add_employee(){
78: if($this->input->post('action') == 'add-employee'){
79: $data['empl_email'] = $this->input->post('employeeEmail');
80: $data['empl_password'] = md5($this->input->post('employeePassword'));
81: $data['empl_role'] = $this->input->post('role');
82: $data['empl_dname'] = $this->input->post('displayName');
83: $data['empl_created'] = time();
84: $this->db->insert('xenon_employee',$data);
85: $id = $this->db->insert_id();
86: if(isset($_POST['selected'])){
87: foreach($_POST['selected'] as $val){
88: $data_index['data_editor'] = $id;
89: $data_index['data_editing_status'] = 't';
90: $this->db->where('data_id',base64_decode(urldecode($val)));
91: $this->db->update('xenon_data',$data_index);
92: }
93: }
94: $this->session->set_userdata('selected_articles','');
95: return array('success'=>'Employee has been created Successfully');
96: }
97: }
98:
99: function update_employee($uid){
100: if($this->input->post('action') == 'update-employee'){
101: $data['empl_role'] = $this->input->post('role');
102: $data['empl_dname'] = $this->input->post('displayName');
103: $data['empl_email'] = $this->input->post('emailName');
104: if($this->input->post('userPassword')!=''){
105: $data['empl_password'] = md5($this->input->post('userPassword'));
106: }
107: $this->db->where('empl_id',$uid);
108: $this->db->update('xenon_employee',$data);
109:
110: $data_z['data_editor'] = 0;
111: $data_z['data_editing_status'] = 'n';
112: $this->db->where('data_editor',$uid);
113: $this->db->update('xenon_data',$data_z);
114: if(isset($_POST['selected'])){
115: foreach($_POST['selected'] as $val){
116: $data_index['data_editor'] = $uid;
117: $data_index['data_editing_status'] = 't';
118: $this->db->where('data_id',base64_decode(urldecode($val)));
119: $this->db->update('xenon_data',$data_index);
120: }
121: }
122: return array('success'=>'Employee has been updated Successfully');
123: }
124: }
125:
126: function add_selected_articles(){
127: if($this->input->post('action') == 'choose-topic'){
128: $selected_titles = $this->session->userdata('selected_articles');
129: if(isset($_POST['selected'])){
130: foreach($_POST['selected'] as $val){
131: $vals = explode('::',$val);
132: if($selected_titles==''){
133: $selected_titles[$vals[0]] = $vals[1];
134: }else{
135:
136: if(in_array($vals[1],$selected_titles)!==FALSE || in_array($vals[1],$selected_titles) == ''){
137: $selected_titles[$vals[0]] = $vals[1];
138: }
139: }
140: }
141: }
142: $this->session->set_userdata('selected_articles',$selected_titles);
143: }
144: }
145:
146: function edit_selected_articles($uid){
147: if($this->input->post('action') == 'choose-topic'){
148: if(isset($_POST['selected'])){
149: foreach($_POST['selected'] as $val){
150: $vals = explode('::',$val);
151: $data_index['data_editor'] = $uid;
152: $data_index['data_editing_status'] = 't';
153: $this->db->where('data_id',base64_decode(urldecode($vals[0])));
154: $this->db->update('xenon_data',$data_index);
155: }
156: }
157: }
158: }
159: }
160: ?>
161: