load->helper('url');
$data = array();
$this->load->model('Dash_model');
$data = $this->Dash_model->dashData();
// $data = $this->dashData();
$this->load->library('table');
$this->table->set_template($this->template);
$data['recent_members'] = "";
$mysql = "SELECT '' AS View"
. " ,username,firstname,lastname,added::date,loc,last_login,acc_link FROM members ORDER by id DESC LIMIT 15";
$query = $this->db->query($mysql);
$this->table->set_heading(array('data' => 'View', 'style' => 'width:50px'), 'Username', 'Firstname', 'Lastname', 'Added', 'Location', 'Last Login', array('data' => 'Folder', 'style' => 'width:40px'));
$data['recent_members'] = $this->table->generate($query);
$view_practice_button = "Open";
$mysql = "SELECT 'Open' AS View,name,username,email,added,last_login from practice ORDER BY id DESC LIMIT 7";
$data['recent_practice'] = "";
$query = $this->db->query($mysql);
$this->table->set_heading(array('data' => 'View', 'style' => 'width:50px'), 'Practice Name', 'Username', 'Email', 'Added', 'Last logn');
$data['recent_practice'] = $this->table->generate($query);
// Pending practice data
// $case_statement = "(CASE WHEN status=1 THEN 'Pending' WHEN status=0 THEN 'Deleted' WHEN status=3 THEN 'Cancelled' WHEN status=5 THEN 'Acive' ELSE 'Unknown' END)";
$case_statement = "(CASE WHEN status=1 THEN 'Pending' WHEN status=0 THEN 'Deleted' WHEN status=3 THEN 'Rejected' WHEN status=5 THEN 'Acive' ELSE 'Unknown' END)";
$mysql = "SELECT '' AS process,
'' AS semail,
$case_statement AS status,
practice_name,username,email,added::date from practice_pending ORDER BY id DESC LIMIT 7";
$data['pending_practice'] = "";
$query = $this->db->query($mysql);
$this->table->set_heading(array('data' => 'Process', 'style' => 'width:50px'), 'Resend Email', 'Status', 'Practice Name', 'Username', 'Email', array('data' => 'Date Added', 'style' => 'width:40px'));
$data['pending_practice'] = $this->table->generate($query);
$this->renderAdminPage('view_dash', $data);
}
public function pendingpractice() {
$data = array();
$data["page_title"] = "Pending Practice";
$this->load->library('table');
$this->table->set_template($this->template);
$this->load->model('Practice_model');
$query = $this->Practice_model->getPendingPractice();
$this->table->set_heading(array('data' => 'Process', 'style' => 'width:50px'), 'Resend Email', 'Status', 'Practice Name', 'Username', 'Email', array('data' => 'Date Added', 'style' => 'width:40px'));
$data['pending_practice'] = $this->table->generate($query);
$this->renderAdminPage('view_pendingpractice', $data);
}
public function practice() {
$data = array();
$data["page_title"] = "Practice";
$this->load->library('table');
$this->table->set_template($this->template);
$this->load->model('Practice_model');
$query = $this->Practice_model->getPractice();
$this->table->set_heading(array('data' => 'Process', 'style' => 'width:50px'), 'Status', 'Practice Name', 'Username', 'Email', array('data' => 'Date Added', 'style' => 'width:40px'));
$data['pending_practice'] = $this->table->generate($query);
$this->renderAdminPage('view_pendingpractice', $data);
}
public function pendingusers() {
$case_statement = "(CASE WHEN status=1 THEN 'Active' WHEN status=0 THEN 'Inactive' ELSE 'Unknown' END)";
$data = array();
$data["page_title"] = "Pending Members";
$this->load->library('table');
$this->table->set_template($this->template);
$data['recent_members'] = "";
$mysql = "SELECT '' AS process,"
. "username,firstname,lastname,added::date,loc,last_login,acc_link FROM members ORDER by id DESC LIMIT 15";
$query = $this->db->query($mysql);
$this->table->set_heading(array('data' => 'Select', 'style' => 'width:50px'), 'Username', 'Firstname', 'Lastname', 'Added', 'Location', 'Last Login', 'Link');
$data['recent_members'] = $this->table->generate($query);
$this->renderAdminPage('view_pendingusers', $data);
}
public function invoices() {
$data = array();
$data["page_title"] = "Invoices";
$this->load->library('table');
$this->table->set_template($this->template);
$data['recent_members'] = "";
$mysql = "SELECT id,username,firstname,lastname,added::date,loc,last_login,acc_link FROM members ORDER by id DESC LIMIT 15";
$query = $this->db->query($mysql);
//$this->table->set_heading( array('data' => 'ID', 'style' => 'width:50px'),'Email', 'Firstname', 'Lastname','Last Login','Location', array('data' => 'ACTION', 'style' => 'width:40px'), array('data' => 'Select', 'style' => 'width:40px'));
$data['recent_members'] = $this->table->generate($query);
$this->renderAdminPage('view_invoices', $data);
}
public function payments() {
$data = array();
$data["page_title"] = "Payments";
$this->load->library('table');
$this->table->set_template($this->template);
$data['recent_members'] = "";
$mysql = "SELECT id,username,firstname,lastname,added::date,loc,last_login,acc_link FROM members ORDER by id DESC LIMIT 15";
$query = $this->db->query($mysql);
//$this->table->set_heading( array('data' => 'ID', 'style' => 'width:50px'),'Email', 'Firstname', 'Lastname','Last Login','Location', array('data' => 'ACTION', 'style' => 'width:40px'), array('data' => 'Select', 'style' => 'width:40px'));
$data['recent_members'] = $this->table->generate($query);
$this->renderAdminPage('view_payments', $data);
}
public function usersactivities() {
$data = array();
$data["page_title"] = "Users Activities";
$this->load->library('table');
$this->table->set_template($this->template);
$data['recent_members'] = "";
$mysql = "SELECT id,username,firstname,lastname,added::date,loc,last_login,acc_link FROM members ORDER by id DESC LIMIT 15";
$query = $this->db->query($mysql);
//$this->table->set_heading( array('data' => 'ID', 'style' => 'width:50px'),'Email', 'Firstname', 'Lastname','Last Login','Location', array('data' => 'ACTION', 'style' => 'width:40px'), array('data' => 'Select', 'style' => 'width:40px'));
$data['recent_members'] = $this->table->generate($query);
$this->renderAdminPage('view_usersactivities', $data);
}
protected function renderAdminPage($page_name, $data) {
$this->load->view('template/secure_header', $data);
$this->load->view('admin/' . $page_name, $data);
$this->load->view('template/secure_footer', $data);
}
}