MermsEmrWeb/adminwww/application/controllers/Dash.php

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Dash extends Admin_Controller {

    public function index() {

        $this->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 '<a href=\"/members/viewMember/'||id||'\"><button type=\"button\" class=\"btn btn-warning\"><i class=\"fa fa-check-circle\"></i></button></a>' 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 = "<a href=\"/practice/viewPracticeDetail/'||id||'\" class=\"btn btn-primary\" >Open</a>";

        $mysql = "SELECT  '<a href=\"/practice/viewPracticeDetail/'||id||'\" class=\"btn btn-primary\" >Open</a>' 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 '<span style=\"color:red;\">Rejected</span>'  WHEN status=5 THEN 'Acive' ELSE 'Unknown' END)";

        $mysql = "SELECT  '<a href=\"/practice/viewPendingPractice/'||id||'\"><button type=\"button\" class=\"btn btn-warning\"><i class=\"fa fa-check-circle\"></i></button></a>' AS process,
            '<button type=\"button\" class=\"btn btn-danger\" id=\"bremail'||id||'\" onclick=\"resendEmail('||id||');\"><i class=\"fa fa-bars\"></i></button>' 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 '<button type=\"button\" class=\"btn btn-warning\" onclick=\"approvePractice('||id||');\">Select</button>' 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);
    }

}