referlist();
}
public function referlist() {
$this->load->library('pagination');
$config = array();
$mysql = "SELECT * FROM members_refer_friend ORDER BY id DESC";
$query = $this->db->query($mysql);
$config["total_rows"] = $query->num_rows();
$config["base_url"] = base_url() . "/refer/referlist";
$config["per_page"] = 15;
$config["uri_segment"] = 3;
$config["num_links"] = 5;
$config['full_tag_open'] = "";
$config['num_tag_open'] = '';
$config['num_tag_close'] = '';
$config['cur_tag_open'] = "";
$config['cur_tag_close'] = "";
$config['next_tag_open'] = "";
$config['next_tagl_close'] = "";
$config['prev_tag_open'] = "";
$config['prev_tagl_close'] = "";
$config['first_tag_open'] = "";
$config['first_tagl_close'] = "";
$config['last_tag_open'] = "";
$config['last_tagl_close'] = "";
$this->pagination->initialize($config);
$page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
$page = is_numeric($page) ? $page : 0;
$mysql = "SELECT 'FROM: '||m.username||'
TO: '||r.email||'
ADDED: '|| r.added||'
SENT: '||r.sent AS RER, r.firstname||' '||r.lastname||'
LINK: '||r.refer_link AS ref_link,r.status ,
(CASE WHEN r.status=1
THEN ''
ELSE 'Completed' END) AS action
FROM members_refer_friend r
LEFT JOIN members m ON m.id=r.member_id
ORDER BY r.id DESC LIMIT " . $config["per_page"] . " OFFSET " . $page;
$query = $this->db->query($mysql);
$this->load->library('table');
$this->table->set_template($this->template);
$data["pagination_links"] = $this->pagination->create_links();
/*
$this->load->library('pagination');
$this->pagination->initialize($config);
$data["pagination_links"] = $this->pagination->create_links();
*/
// $this->table->set_heading(array('data' => 'Added/Name', 'style' => 'width:170px'), 'Email', array('data' => 'Status', 'style' => 'width:80px'));
$data['refer_table'] = $this->table->generate($query);
$data['page_title'] ="Refer Friend List";
$this->load->view('bko/view_bko_header', $data);
$this->load->view('bko/view_bko_referlist', $data);
$this->load->view('bko/view_bko_footer', $data);
}
//#define WRENCHBOARD_ACCOUNT_REFRESENDLNK 11133
public function resendLink(){
echo "YES I GOT HERE - uid needed";
if($_GET){
$uid = substr(trim($this->input->get('uid')),0,55);
$in_data=[];
$in_data['uid'] = $uid;
$in_data['action'] = WRENCHBOARD_ACCOUNT_REFRESENDLNK;
$this->load->model('backend_model');
$out = array();
$res = $this->backend_model->wrenchboard_api($in_data, $out);
if ($res == PHP_API_OK) {
echo 'All Okay';
} else {
echo 'Not Okay';
}
}
}
}