Files
CHIEFSOFT\ameye 4c1ba8e01b fix refer data
2024-05-10 12:38:23 -04:00

97 lines
3.5 KiB
PHP

<?php
class Refer extends Bko_Controller {
public function index() {
$this->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'] = "<ul class='pagination'>";
$config['full_tag_close'] = "</ul>";
$config['num_tag_open'] = '<li>';
$config['num_tag_close'] = '</li>';
$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
$config['next_tag_open'] = "<li>";
$config['next_tagl_close'] = "</li>";
$config['prev_tag_open'] = "<li>";
$config['prev_tagl_close'] = "</li>";
$config['first_tag_open'] = "<li>";
$config['first_tagl_close'] = "</li>";
$config['last_tag_open'] = "<li>";
$config['last_tagl_close'] = "</li>";
$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||'<br> TO: '||r.email||'<br> ADDED: '|| r.added||'<br> SENT: '||r.sent AS RER, r.firstname||' '||r.lastname||' <br> LINK: '||r.refer_link AS ref_link,r.status ,
(CASE WHEN r.status=1
THEN '<input type=submit id=\"reslnk'||r.uid||'\" onclick=\"return resSendLink('''||r.uid||''')\" name=\"resend\" class=\"btn btn-warning btn-xs\" value=\"Resend\">'
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';
}
}
}
}