CHIEFSOFT\ameye
48 lines
2.2 KiB
PHP
48 lines
2.2 KiB
PHP
<?php
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Bkocards extends Bko_Controller {
|
|
|
|
public function cardlist(){
|
|
$arry= array();
|
|
|
|
$config = $this->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 ||'<br>'||m.firstname||' '||m.lastname||'<br>'|| m.email AS user,
|
|
cr.target_uid ||'<br>'||mt.firstname||' '||mt.lastname||'<br>'|| mt.email AS target_user,
|
|
cr.phone_number||'<br>'|| cr.address||'<br>'|| cr.state ||' '|| cr.postal_code AS address,
|
|
'<b>Owner ID :</b>'||COALESCE( cr.card_issue_id::text,'0000-00-00') ||'<br>'||
|
|
'<b>Card ID : </b>'||COALESCE( cr.card_id::text,'0000-00-00') ||'<br>'||
|
|
'<b>User Activated : </b>'||COALESCE( cr.user_activated::text,'0000-00-00') ||'<br>'||
|
|
'<b>Activation Date : </b>'|| COALESCE(cr.card_activated::text,'0000-00-00') ||'<br>'||
|
|
'<b>Assigned Date : </b>'|| 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);
|
|
}
|
|
|
|
} |