Olusesan Ameye
67 lines
3.7 KiB
PHP
67 lines
3.7 KiB
PHP
<?php
|
|
|
|
class Practice_model extends CI_Model {
|
|
|
|
function __construct() {
|
|
|
|
}
|
|
|
|
public function getPendingPractice() {
|
|
$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 '<button type=\"button\" class=\"btn btn-warning\" onclick=\"selectPendingPractice('||id||');\">Select</button>' AS process,
|
|
'<button type=\"button\" class=\"btn btn-danger\" onclick=\"resendEmail('||id||');\">Email</button>' AS semail,
|
|
$case_statement AS status,
|
|
practice_name,username,email,added::date from practice_pending ORDER BY id DESC LIMIT 200";
|
|
$data['pending_practice'] = "";
|
|
return $query = $this->db->query($mysql);
|
|
}
|
|
|
|
public function getPractice() {
|
|
$case_statement = "(CASE WHEN status=1 THEN 'Active' WHEN status=0 THEN 'Deleted' WHEN status=3 THEN 'Deleted' WHEN status=5 THEN 'Acive' ELSE 'Unknown' END)";
|
|
$mysql = "SELECT '<button type=\"button\" class=\"btn btn-warning\" onclick=\"selectPractice('||id||');\">Select</button>' AS process,
|
|
$case_statement AS status,
|
|
name,username,email,added::date FROM practice ORDER BY id DESC LIMIT 200";
|
|
$data['pending_practice'] = "";
|
|
return $query = $this->db->query($mysql);
|
|
}
|
|
|
|
/*
|
|
mermsemr_dev=> SELECT * FROM practice_pending WHERE id = 1 AND status = 1;
|
|
id | firstname | lastname | practice_name | email | username | password | status | added | loc
|
|
----+-----------+----------+---------------+---------------------+----------+----------+--------+----------------------------+-----------
|
|
1 | Olu | Amey | Testing | works@chiefsoft.com | ses66181 | | 1 | 2020-12-19 10:40:57.740114 | 10.0.0.15
|
|
(1 row)
|
|
*/
|
|
|
|
public function loadPendingPractice($pending_practice_id) {
|
|
$data = [];
|
|
$mysql = "SELECT * FROM practice_pending WHERE id = $pending_practice_id AND status = 1";
|
|
$data = $this->db->query($mysql)->result_array();
|
|
return $data[0];
|
|
}
|
|
|
|
/*
|
|
mermsemr_dev=> SELECT * FROM practice;
|
|
id | name | firstname | lastname | email | phone | username | password | added | loc | last_login | status
|
|
----+---------------------------+-----------+----------+--------------------------+------------+----------+----------------------------------+---------------------------+----------+------------+--------
|
|
1 | University Hospital Space | Sanya | Ameye | ses66181+merms@gmail.com | 6784564356 | sameye | d0fbea2563b377ea7074bced45c88dcb | 2019-03-03 21:35:51.48451 | 10.0.0.1 | | 1
|
|
(1 row)
|
|
|
|
*/
|
|
|
|
public function loadPractice($practice_id) {
|
|
$data = [];
|
|
$mysql = "SELECT * FROM practice WHERE id = $practice_id ";
|
|
$data = $this->db->query($mysql)->result_array();
|
|
return $data[0];
|
|
}
|
|
|
|
public function loadPracticeUsers($practice_id) {
|
|
$data = [];
|
|
$case_statement = "(CASE WHEN status=1 THEN 'Active' WHEN status=0 THEN 'Deleted' WHEN status=3 THEN 'Deleted' WHEN status=5 THEN 'Acive' ELSE 'Unknown' END)";
|
|
$mysql = "SELECT '<button type=\"button\" class=\"btn btn-info btn-sm\" onclick=\"editSelecteduser('||id||');\">Edit</button>' AS Edit,$case_statement AS Status,firstname,lastname,email,phone,username, added::date,last_login FROM practice_users WHERE practice_id = $practice_id ";
|
|
return $query = $this->db->query($mysql);
|
|
}
|
|
|
|
}
|