1: <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 2: class Model_user extends CI_Model{
 3:     public function browse($filter = ''){
 4:         $this->db->select('lice_id, lice_macaddres, lice_status, lice_updates, lice_key, (select merc_name from xenon_merchant where xenon_merchant.merc_id = xenon_licence.lice_merchant) as lice_merchant, ');
 5:         //$this->db->join('xenon_merchant_store','xenon_merchant_store.merc_id = xenon_merchant.merc_id');
 6:         $this->db->from('xenon_licence');
 7:         $this->db->where('xenon_licence.is_deleted','n');
 8:         if($this->input->get('page')!=''){
 9:             $page = $this->input->get('page');
10:             $start = ($page * 50)-50;
11:             $end = ($page * 50);
12:             $this->db->limit(50,$start);
13:         }else{
14:             $this->db->limit(50);
15:         }
16:         return $this->db->get();
17:     }
18:     public function render($merchant){
19:         return '
20:             <tr>
21:                 <td>'.$merchant->lice_macaddres.'</td>
22:                 <td>'.($merchant->lice_merchant == 't'?'Trial':'Purchased').'</td>
23:                 <td>'.date('F d, Y h:i:s',$merchant->lice_updates).'</td>
24:                 <td align="center">'.($merchant->lice_merchant == ''?'GreenMedicineWorks':$merchant->lice_merchant).'</td>
25:                 <td align="center">'.($merchant->lice_key == ''?'N/A':$merchant->lice_key).'</td>
26:                 <td align="center"><a href="'.site_url('user/edit/'.urlencode(base64_encode($merchant->lice_id))).'">Edit</a> | <a href="'.site_url('user/detail/'.urlencode(base64_encode($merchant->lice_id))).'">Details</a> | <a href="?action=delete&id='.urlencode(base64_encode($merchant->lice_id)).'">Delete</a>
27:             </tr>
28:         ';
29:     }
30: 
31:     public function error(){
32:         return '
33:             <tr>
34:                 <td colspan="5">No users found</td>
35:             </tr>
36:         ';
37:     }
38: }
39: ?>