1: <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2: class Model_firefly extends CI_Model{
  3:     public function browse($filter = '',$is_employee = '0'){
  4:         $db2 = $this->load->database('second', TRUE);
  5:         $db2->from('firefly_data');
  6:         if($filter <> ''){
  7:             $db2->where($filter,'',FALSE);
  8:         }
  9:         if($this->input->get('order')!=''){
 10:             $db2->order_by('data_'.$this->input->get('order').($this->input->get('leval')!=''?' '.$this->input->get('leval'):''));
 11:         }
 12:         $db2->where('firefly_data.is_deleted','n');
 13:         if($this->input->get('term')!=''){
 14:             $db2->like('data_title',$this->input->get('term'));
 15:         }
 16:         if($this->input->get('alpha')!=''){
 17:             $db2->where("data_title like '".$this->input->get('alpha')."%'",'',FALSE);}
 18:         if($this->input->get('sort')!=''){
 19:             $db2->order_by($this->input->get('sort'));
 20:         }else{
 21:             $db2->order_by('data_title');
 22:         }
 23:         if($this->input->get('page')!=''){
 24:             $page = $this->input->get('page');
 25:             $start = ($page * 50)-50;
 26:             $end = ($page * 50);
 27:             $db2->limit(50,$start);
 28:         }else{
 29:             $db2->limit(50);
 30:         }
 31:         return $db2->get();
 32:     }
 33:     
 34:     public function browse_link(){
 35:         $db2 = $this->load->database('second', TRUE);
 36:         $db2->from('firefly_data');
 37:         $db2->where('firefly_data.is_deleted','n');
 38:         $links = $db2->get();
 39:         foreach($links->result() as $link){
 40:             echo $this->render_link($link);
 41:         }
 42:     }
 43:     
 44:     public function render($article){
 45:         return '
 46:             <tr>
 47:                 <td>'.$article->data_title.'</td>
 48:                 <td align="center">'.date('F d,Y',$article->data_modified).'</td>
 49:                 <td align="center">'.urlencode(base64_encode($article->data_id)).'</td>
 50:                 <td align="center"><a href="'.site_url('firefly/edit/'.urlencode(base64_encode($article->data_id))).'">Edit</a> '.(check_permission('dc')?'| <a href="'.site_url('firefly/detail/'.urlencode(base64_encode($article->data_id))).'">Details</a> | <a href="?action=delete&id='.urlencode(base64_encode($article->data_id)).'">Delete</a>':'').'</td>
 51:             </tr>
 52:         ';
 53:     }
 54:     
 55:     public function add_user(){
 56:         if($this->input->post('url')!=''){
 57:             $db2 = $this->load->database('second', TRUE);
 58:             $data['user_name'] = $this->input->post('sname');
 59:             $data['user_url'] = $this->input->post('url');
 60:             $data['user_code'] = md5(base64_encode($this->input->post('url')));
 61:             $data['user_cname'] = $this->input->post('uname');
 62:             $data['user_cemail'] = $this->input->post('uemail');
 63:             $data['user_cphone'] = $this->input->post('uphone');
 64:             $data['user_rate'] = $this->input->post('rate');
 65:             $data['user_opening'] = $this->input->post('opening');
 66:             $data['user_copyright'] = '&copy; Copyright 2013 All Rights Reserved';
 67:             $data['user_created'] = time();
 68:             $db2->insert('firefly_user',$data);
 69:              echo '<b>Key:</b> '.md5(base64_encode($this->input->post('url')));
 70:         } 
 71:     }
 72:     
 73:     public function add(){
 74:         $db2 = $this->load->database('second', TRUE);
 75:         if($this->input->post('action') == 'add_article'){
 76:             $data['data_title'] = $this->input->post('dtitle');
 77:             $data['data_body'] = htmlentities($this->input->post('content'));
 78:             $data['data_link'] = url_title($this->input->post('dtitle'));
 79:             $data['data_modified'] = time();
 80:             $data['data_created'] = time();
 81:             $db2->insert('firefly_data',$data);
 82: 
 83:             return array('success'=>'Article has been added Successfully');
 84:         }
 85:     }
 86:     
 87:     public function render_link($article){
 88:         return '
 89:             <tr>
 90:                 <td>'.$article->data_title.'</td>
 91:                 <td align="center">'.urlencode(base64_encode($article->data_id)).'</td>
 92:             </tr>
 93:         ';
 94:     }
 95:     public function render_pop($article){
 96:         $url = $article->data_id;//'<a class="article_link" href="/data/'.urlencode(base64_encode($article->data_id)).'">'.$article->data_title.'</a>';
 97:         $url = urlencode(base64_encode($url));
 98:         return '
 99:             <tr>
100:                 <td>'.$article->data_title.'</td>
101:                 <td align="center"><a href="?selected='.$url.'">Select</a>
102:             </tr>
103:         ';
104:     }
105:     public function render_emp_edit($article,$check = 'n'){
106:         $url = '<a target="_blank" href="'.site_url('article/view/'.urlencode(base64_encode($article->data_id))).'">View</a>';
107:         //$url = urlencode(base64_encode($url));
108:         return '
109:             <tr>
110:                 <td align="center"><input type="checkbox" name="selected[]" '.($check =='y' || $article->empl_id > 0?'checked = "checked"':'').' value="'.urlencode(base64_encode($article->data_id)).'"></td>
111:                 <td>'.$article->data_title.'</td>
112:                 <td align="center">'.$url.'</td>
113:             </tr>
114:         ';
115:     }
116:     
117:     public function render_emp_add($article){
118:         $url = '<a target="_blank" href="'.site_url('article/view/'.urlencode(base64_encode($article->data_id))).'">View</a>';
119:         //$url = urlencode(base64_encode($url));
120:         return '
121:             <tr>
122:                 <td align="center"><input type="checkbox" name="selected[]" value="'.urlencode(base64_encode($article->data_id)).'::'.$article->data_title.'"></td>
123:                 <td>'.$article->data_title.'</td>
124:                 <td align="center">'.$url.'</td>
125:             </tr>
126:         ';
127:     }
128:     
129:     public function error(){
130:         return '
131:             <tr>
132:                 <td colspan="5">No artciles found</td>
133:             </tr>
134:         ';
135:     }
136:     public function pick($enc_id){
137:         $db2 = $this->load->database('second', TRUE);
138:         $article = $db2->select('data_id, data_title, data_body')->from('firefly_data')->where('data_id',base64_decode(urldecode($enc_id)))->get()->row();
139:         return $article;
140:     }
141: 
142:     public function update($id){
143:         $db2 = $this->load->database('second', TRUE);
144:         if($this->input->post('action')=='update_article'){
145:             $id = base64_decode(urldecode($id));
146:             $data['data_title'] = $this->input->post('dtitle');
147:             $data['data_body'] = htmlentities($this->input->post('content'));
148:             $data['data_modified'] = time();
149:             $db2->where('data_id',$id);
150:             $db2->update('firefly_data',$data);
151:             return array('success'=>'Article has been updated Successfully');
152:         }
153:     }
154:     public function remove($enc_id){
155:         $db2 = $this->load->database('second', TRUE);
156:         $data['is_deleted'] = 'y';
157:         $db2->where('data_id',base64_decode(urldecode($enc_id)));
158:         $db2->update('firefly_data',$data);
159:     }
160:     public function remove_article_full(){
161:         $db2 = $this->load->database('second', TRUE);
162:         if($this->input->get('action') == 'delete'){
163:             $enc_id = $this->input->get('id');
164:             if($enc_id != ''){
165:                 $db2->delete('firefly_data',array('data_id'=>base64_decode(urldecode($enc_id))));
166:             }
167:         }
168:     }
169:     
170:     public function list_portals($id = ''){
171:         $db2 = $this->load->database('second', TRUE);
172:         if($id != ''){
173:             $db2->where('user_id',$id);
174:         }
175:         return $db2->from('firefly_user')->get();
176:     }
177:     
178:     public function add_portal($data){
179:         $db2 = $this->load->database('second', TRUE);
180:         $data['user_created'] = time();
181:         $data['user_show_search'] = ($data['user_show_search'] == ''?'n':$data['user_show_search']);
182:         $data['user_copyright'] = '&copy; Copyright 2013 All Rights Reserved';
183:         $data['user_code'] = md5(base64_encode($data['user_url']));
184:         $db2->insert('firefly_user',$data);
185:         return $db2->insert_id();
186:     }
187:     
188:     public function update_portal($id,$data){
189:         $db2 = $this->load->database('second', TRUE);
190:         $data['user_created'] = time();
191:         $data['user_show_search'] = ($data['user_show_search'] == ''?'n':$data['user_show_search']);
192:         $data['user_copyright'] = '&copy; Copyright 2013 All Rights Reserved';
193:         $data['user_code'] = md5(base64_encode($data['user_url']));
194:         $db2->where('user_id',$id);
195:         $db2->update('firefly_user',$data);
196:         return $db2->insert_id();
197:     }
198:     
199:     public function get_portal($id){
200:         $portals = $this->list_portals($id);
201:         return $portals->row();
202:     }
203:     
204:     public function render_portal($portal){
205:         return '
206:             <tr>
207:                 <td>'.$portal->user_name.'</td>
208:                 <td>'.$portal->user_url.'</td>
209:                 <td>'.$portal->user_cname.' ('.$portal->user_cemail.','.$portal->user_cphone.')</td>
210:                 <td>'.($portal->user_status == 'a'?'Active':'Blocked').'</td>
211:                 <td>'.date('F d, Y',$portal->user_created).'</td>
212:                 <td align="center"><a href="'.site_url('firefly/manage/'.$portal->user_id).'">Manage</a></td>
213:             </tr>
214:         ';
215:     }
216: }
217: ?>