No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
function getAllReferrals(){ $sql = "(SELECT r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname AS nickname FROM CLIENT c INNER JOIN referral1 r ON c.referral_id = r.referral1_id INNER JOIN assign_psychotherapist ap ON ap.a_referral_id = c.referral_id INNER JOIN employee e ON ap.a_psychotherapist_id = e.empid WHERE r.referral_status ='Assigned' OR r.referral_status ='Accepted' ORDER BY referral_date DESC ) UNION ALL (SELECT r.referral_date,c.lastname,c.middlename,c.firstname, … 
|
|
|
$sql = (" SELECT referral1.*, client.*, employee.* FROM ( select r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname from client c inner join referral1 r on c.referral_id = r.referral1_id inner join assign_psychotherapist ap on ap.a_referral_id = c.referral_id inner join employee e on ap.a_psychotherapist_id = e.empid where referral_status ='Assigned' OR referral_status ='Accepted' order by referral_date desc ) as …
|
|
|
$this->db->select('referral1.*, client.*, employee.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assign_psychotherapist ', 'assign_psychotherapist.a_referral_id = client.referral_id', 'inner' ); $this->db->join('employee ', 'assign_psychotherapist.a_psychotherapist_id = employee.empid', 'inner' ); $this->db->where("referral_status ='Assigned' OR referral_status ='Accepted' "); $this->db->order_by("referral_date", "desc"); $this->db->select('referral1.*, client.*, volunteer.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assignvolunteer', 'assignvolunteer.Vreferralid = client.referral_id', 'inner' ); $this->db->join('volunteer', 'assignvolunteer.Vvolunteerid … 
|