PrepPagination(10, 3, '/bkouser/jobs');
$mysql0 = "SELECT * FROM members_card_request ORDER BY id DESC";
$q = $this->db->query($mysql0);
$config["total_rows"] = $q->num_rows();
$this->load->library('pagination');
$this->pagination->initialize($config);
$data["pagination_links"] = $this->pagination->create_links();
$this->load->library('table');
$this->table->set_template($this->template);
$page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
$page = is_numeric($page) ? $page : 0;
//$mysql = "SELECT * FROM members_card_request"; card_issue_id
$mysql = "SELECT cr.member_uid ||'
'||m.firstname||' '||m.lastname||'
'|| m.email AS user,
cr.target_uid ||'
'||mt.firstname||' '||mt.lastname||'
'|| mt.email AS target_user,
cr.phone_number||'
'|| cr.address||'
'|| cr.state ||' '|| cr.postal_code AS address,
'Owner ID :'||COALESCE( cr.card_issue_id::text,'0000-00-00') ||'
'||
'Card ID : '||COALESCE( cr.card_id::text,'0000-00-00') ||'
'||
'User Activated : '||COALESCE( cr.user_activated::text,'0000-00-00') ||'
'||
'Activation Date : '|| COALESCE(cr.card_activated::text,'0000-00-00') ||'
'||
'Assigned Date : '|| COALESCE(cr.card_assigned::text,'0000-00-00') AS card_process ,
cr.status
FROM members_card_request cr
LEFT JOIN members m ON m.id =cr.member_id
LEFT JOIN members mt ON mt.uid::text = cr.target_uid
ORDER BY cr.id DESC";
$data['page_title'] = "Card Request";
$query = $this->db->query($mysql);
$this->table->function = 'smart_htmlspecialchars';
$data['job_list_table'] = $this->table->generate($query);
$this->secureBkoPage('issued_cards',$data);
}
}