/classes/firebaseclass.php
PHP | 2574 lines | 2073 code | 336 blank | 165 comment | 85 complexity | 42dcbe36a7edf2689d4e663363405111 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, BSD-3-Clause, Apache-2.0, MIT
- <?php
- $root = $_SERVER['DOCUMENT_ROOT'];
- /*
- include_once $root.'/services/connection/db.php';
- include_once $root.'/services/classes/publicClass/commanClass.php';
- include_once $root.'/services/classes/publicClass/responseClass.php';
- */
- //include_once 'connection/db.php';
- include_once 'publicClass/responseClass.php';
- require './firebase/vendor/autoload.php';
- use Kreait\Firebase\Factory;
- use Kreait\Firebase\ServiceAccount;
- error_reporting(E_ALL ^ E_DEPRECATED);
- //Create Connection Class
- class UserClass
- {
- var $conn;
- //constructor to eastablishment connection with database
- public function __construct()
- {
- $serviceAccount = ServiceAccount::fromJsonFile('./firebase/firebase_credentials.json');
- $firebase = (new Factory)
- ->withServiceAccount($serviceAccount)
- ->withDatabaseUri('https://projects-a6962.firebaseio.com')
- ->create();
- $this->conn = $firebase->getDatabase();
-
- }
- /*********Query start Following Block 1********/
-
- /*public function imageupload()
- {
- $image_name = $_FILES["fileUpload1"]["name"];
- $tmp_arr = explode(".",$image_name);
- $img_extn = end($tmp_arr);
- $new_image_name = 'image_'. uniqid() . date('YmdHis').'.'.$img_extn;
- $flag=0;
- if (file_exists("uploads/".$new_image_name))
- {
- return false;
- }
- else
- {
- move_uploaded_file($_FILES["fileUpload1"]["tmp_name"],"uploads/". $new_image_name);
- $flag = 1;
- $static_url = "http://bytesnmaterials.com/healthcare/uploads/".$new_image_name;
- return $static_url;
- }
- }*/
-
-
- //$imagePath = 'http://bytesnmaterials.com/healthcare/profile/profile.png';
-
- public function signup_doctor($doctorName,$address,$mobileNo,$emailID,$passwordD,$deviceID,$register_image,$latID,$logID,$file_url_name,$imagePath,$unionID1,$feeID,$specialID,$callstatus)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
-
- if(isset($_FILES['imageData']['name']))
- {
- if((($_FILES['imageData']['type'] == "image/jpeg")|| ($_FILES['imageData']['type'] == "image/gif")|| ($_FILES['imageData']['type'] == "image/jpg")|| ($_FILES['imageData']['type'] == "image/png")&& ($_FILES['imageData']['size'] < 1000000000000000))){
-
-
-
- if ($_FILES["imageData"]["error"] > 0) echo "Return Code: " . $_FILES["imageData"]["error"] . "<br />"; else {
-
- $Ex = end(explode(".",$_FILES['imageData']['name']));
-
- $array = explode(".",$_FILES['imageData']['name']);
-
- $file_url_name = $array[0].time().".".$Ex;
-
- move_uploaded_file($_FILES["imageData"]["tmp_name"], "uploads/col_certificate/".$file_url_name);
-
- }
- }
- }
- $file_url_name1 = "http://bytesnmaterials.com/healthcare/uploads/col_certificate/".$file_url_name;
- $register_image1 = "http://bytesnmaterials.com/healthcare/uploads/register_image/".$register_image;
-
- $sql = "INSERT INTO `doctor_signup` (`device_id`,`register_image`, `doctor_name`, `address`, `mobile_no`, `email_id`, `password`, `lat`, `log`,`col_certificate`, `union_id`, `status`, `type`, `profile_pic`, `specialization`,`payment_id`, `fee`, `chat_status`,`call_status`) VALUES ('$deviceID','$register_image1', '$doctorName', '$address', '$mobileNo', '$emailID', '$passwordD', '$latID', '$logID' ,'$file_url_name1', '$unionID1', '0', 'D','http://bytesnmaterials.com/healthcare/profile/profile.png','$specialID','0','$feeID','0','$callstatus')";
- $result=mysql_query($sql);
- return $result;
-
-
- }
- public function insert_notification_details($tokenID,$patientID,$doctorID,$name,$message,$caseD,$date,$type,$status)
-
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `push_notification`(`doctor_id`, `patient_id`, `name`, `message`, `token`, `case_description`,`date`, `type`, `status`) VALUES ('$doctorID', '$patientID','$name','$message','$tokenID','$caseD','$date','P','$status')";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_push_notification_details($tokenID,$patientID,$patientname,$getresult,$caseD,$date,$type,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "INSERT INTO `push_notification`(`doctor_id`, `patient_id`, `name`, `message`, `token`, `case_description`,`date`, `type`, `status`) VALUES ('$getresult', '$patientID','$name','Request To Chat','$tokenID','$caseD','$date','$type','$status')";
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`, `read_status`) VALUES ('$patientID','$getresult','$caseD','0','P','p_text','0')";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_patient_notification($patientID,$doctorID,$message,$date,$status)
-
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `push_notification_details`(`patient_id`, `doctor_id`, `message`, `status`, `date`) VALUES ('$patientID','$doctorID','$message','$status','$date')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function update_pushnotification($id,$status)
-
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `push_notification` SET `status`='$status' WHERE `id`='$id'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function insert_patient_details($patientName,$emailID,$phoneNo,$address,$case_desc,$password,$age,$latitude,$logitude,$type,$tokenID)
-
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "INSERT INTO `patient` (`patient_name`, `email_id`, `mobile_no`, `address`,`case_desc`, `profile_pic`, `password`, `age`, `lat`, `log`, `type`, `token`, `took`,`status`,`call_status`) VALUES ('$patientName', '$emailID', '$phoneNo', '$address','$case_desc', 'http://bytesnmaterials.com/healthcare/profile/profile.png', '$password', '$age', '$latitude', '$logitude', '$type', '$tokenID','0','0','1')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_pharmacy_details($pharmacyName,$emailID,$phoneNo,$address,$password,$age,$latitude,$logitude,$type,$tokenID,$hour_status,$working_hour)
-
-
-
- {
-
- if($is_24_hours_support == ""){
-
- $is_24_hours_support1 = "false";
- }else{
-
- $is_24_hours_support1 = $is_24_hours_support;
- }
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `pharmacy`(`pharmacy_name`, `email_id`, `mobile_no`, `address`, `profile_pic`, `password`, `age`, `lat`, `log`, `type`, `token`, `call_status`, `hour_status`, `home_delivery`, `working_hour`, `injection_provider`, `status`) VALUES ('$pharmacyName', '$emailID', '$phoneNo', '$address', 'http://bytesnmaterials.com/healthcare/profile/profile.png', '$password', '$age', '$latitude', '$logitude', '$type', '$tokenID','1','$hour_status','0','$working_hour','0','0')";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function check_patient_mobile_details($mobile)
- {
- // mysql_query("set names 'utf8'");
- // $sql = "SELECT * FROM `patient` WHERE mobile_no = '".$mobile."'";
- // //echo $sql;
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('patient')
- ->orderByChild('mobile_no')
- ->equalTo($mobile);
- $snapshot = $newPost->getSnapshot();
- $k1 = $snapshot->getValue();
- return $k1;
- }
- public function insert_quick_registration($mobile_no,$password,$latitude,$logitude,$tokenID)
-
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "INSERT INTO `patient` (`mobile_no`, `password`, `type`, `lat`, `log`, `token`) VALUES ('$mobile_no', '$password', 'P', '$latitude', '$logitude','$tokenID')";
- // //echo $sql;
- // $result=mysql_query($sql);
- // return $result;
- $postData = [
- 'address' => "",
- 'age' => "",
- 'call_status' => "",
- 'case_desc' => "",
- 'patient_name' => "",
- 'profile_pic' => "",
- 'took' => "",
- 'email_id' => "null",
- 'age' => "",
- 'status' =>"",
- 'password' => $password,
- 'type' => 'P',
- 'lat' => $latitude,
- 'log' => $logitude,
- 'token' => $tokenID,
- 'patient_id' => "",
- 'mobile_no' => $mobile_no
- ];
- $postRef = $this->conn->getReference('patient')->push($postData);
- return $postRef;
- }
- public function get_doctor_details($doctorName,$emailID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where doctor_name = '$doctorName' and email_id = '$emailID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_notification_id($patientID,$doctorID,$date,$tokenID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from push_notification where doctor_id = '$doctorID' and patient_id = '$patientID' AND date = '$date' AND token = '$tokenID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_lat_log_api($doctorID,$lat,$log)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE doctor_signup SET lat = '$lat', log = '$log' WHERE doctor_id='$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_detail_doctor($toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where doctor_id = '$toID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_union_id($unionID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where union_id = '$unionID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_patient_notification($patientID,$doctorID,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from push_notification_details where doctor_id = '$patientID' and patient_id = '$doctorID' and status = '$status'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_all_patient_details_app($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT p.* FROM `patient` as p,push_notification_details as ps WHERE ps.doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_patients_notification_details($patientID,$typeID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT p.*, pn.status,pn.date,pn.message,pn.id
- FROM push_notification AS pn, patient AS p
- WHERE pn.doctor_id = '$patientID'
- AND pn.type != '$typeID'
- AND pn.patient_id = p.patient_id ORDER BY pn.id DESC";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_doctor_notification_details($patientID,$typeID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT pn.status,pn.date,pn.message,pn.id , d . *
- FROM `push_notification` AS pn, `doctor_signup` AS d
- WHERE pn.patient_id = '$patientID'
- AND pn.type != '$typeID'
- AND d.doctor_id = pn.doctor_id ORDER BY pn.id DESC";
- $result=mysql_query($sql);
- return $result;
- }
- /*-----------------------------------------NOTIFICATION---------------------------------------------------*/
- public function insert_token($tokenID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `push_notification`(`token`) VALUES ('$tokenID')";
- $result=mysql_query($sql);
- return $result;
- }
- public function gettokendetails($tokenID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from push_notification where token = '$tokenID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_name($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from patient where patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_name_det($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select patient_id as id,patient_name as name,profile_pic,type from patient where patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- /*--------------------------------------------------------------------------------------------------------*/
-
- public function update_doctor_profile_details($doctorID,$doctorName,$emailID,$address,$mobileNO,$file_url)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `doctor_signup` SET `doctor_name`='$doctorName',`address`='$address',`mobile_no`='$mobileNO',email_id = '$emailID',`profile_pic`='$file_url' WHERE `doctor_id`='$doctorID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_profile_details($patientID,$patientName,$emailID,$mobileNO,$addressID,$file_url)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient` SET `patient_name`='$patientName',`profile_pic`='$file_url',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE patient_id = '$patientID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_profile($patientID,$patientName,$emailID,$mobileNO,$addressID,$array_full)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
-
- $sql = "UPDATE `patient` SET `patient_name`='$patientName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID',`profile_pic`='$array_full1' WHERE patient_id = '$patientID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_pharmacyd_profile($patientID,$patientName,$emailID,$mobileNO,$addressID,$array_full,$lat,$log)
- {
-
- if($is_24_hours_support == ""){
-
- $is_24_hours_support1 = "false";
- }else{
-
- $is_24_hours_support1 = $is_24_hours_support;
- }
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
-
- $sql = "UPDATE `pharmacy` SET `pharmacy_name`='$patientName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID',`profile_pic`='$array_full1',`lat`='$lat',`log`='$log' WHERE pharmacy_id = '$patientID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_phar_profile($patientID,$patientName,$emailID,$mobileNO,$addressID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `pharmacy` SET `pharmacy_name`='$patientName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE pharmacy_id = '$patientID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_pharmacy_profile($pharmacyID,$pharmacyName,$emailID,$mobileNO,$addressID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `pharmacy` SET `pharmacy_name`='$pharmacyName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE pharmacy_id = '$pharmacyID'" or die(mysql_error());
- $result=mysql_query($sql);
- return $result;
- }
- public function update_doctor_profile($doctorID,$doctorName,$emailID,$feeID,$address,$mobileNO,$array_full)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
- $sql = "UPDATE `doctor_signup` SET `doctor_name`='$doctorName',`address`='$address',`mobile_no`='$mobileNO',`email_id`='$emailID',`profile_pic`='$array_full1',`fee`='$feeID' WHERE `doctor_id`='$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function updatedoctortoken($emailID,$password,$token,$latitude,$logitude,$refID)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "UPDATE `doctor_signup` SET `device_id`='$token', lat = '$latitude', log = '$logitude', status = '1' WHERE (`email_id` = '$emailID' OR `mobile_no` = '$emailID') and password = '$password'";
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('doctor_signup')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('doctor_signup')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $refUpdateKey = empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0];
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- if(isset($refUpdateKey)) {
- $updates = [
- //'doctor_signup/'.$newPostKey => $postData
- 'doctor_signup/'.$refUpdateKey.'/device_id' => $token,
- 'doctor_signup/'.$refUpdateKey.'/lat' => $latitude,
- 'doctor_signup/'.$refUpdateKey.'/log' => $logitude,
- 'doctor_signup/'.$refUpdateKey.'/status' => '1',
- ];
- $res = $this->conn->getReference() // this is the root reference
- ->update($updates);
- }
- else{
- die("update key not found");
- }
- }
- else{
- die("password validation failed");
- }
- }
- else{
- die("no match");
- }
- return true;
- }
- public function updatepatienttoken($emailID,$password,$token,$latitude,$logitude)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "UPDATE `patient` SET `token`='$token', lat = '$latitude', log = '$logitude', status = '1' WHERE (`email_id` = '$emailID' OR `mobile_no` = '$emailID') and `password` = '$password'";
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('patient')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('patient')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $refUpdateKey = empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0];
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- if(isset($refUpdateKey)){
- $updates = [
- //'doctor_signup/'.$newPostKey => $postData
- 'patient/'.$refUpdateKey.'/token' => $token,
- 'patient/'.$refUpdateKey.'/lat' => $latitude,
- 'patient/'.$refUpdateKey.'/log' => $logitude,
- 'patient/'.$refUpdateKey.'/status' => '1'
- ];
- $res = $this->conn->getReference() // this is the root reference
- ->update($updates);
- }
- else{
- die("update key not found : updatepatienttoken ");
- }
- }
- else{
- die("password validation failed");
- }
- }
- else{
- die("no match");
- }
- return true;
- }
- public function updatepharmacytoken($emailID,$password,$token,$latitude,$logitude)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "UPDATE `pharmacy` SET `token`='$token', status = '1' WHERE (`email_id` = '$emailID' OR `mobile_no` = '$emailID') and `password` = '$password'";
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('pharmacy')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('pharmacy')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $refUpdateKey = empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0];
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- if(isset($refUpdateKey)) {
- $updates = [
- //'doctor_signup/'.$newPostKey => $postData
- 'pharmacy/'.$refUpdateKey.'/token' => $token,
- 'pharmacy/'.$refUpdateKey.'/lat' => $latitude,
- 'pharmacy/'.$refUpdateKey.'/log' => $logitude,
- 'pharmacy/'.$refUpdateKey.'/status' => '1'
- ];
- $res = $this->conn->getReference() // this is the root reference
- ->update($updates);
- }
- else{
- die("update key not found");
- }
- }
- else{
- die("password validation failed");
- }
- }
- else{
- die("no match");
- }
- return true;
- }
- public function getalldoctordetails()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_profile_details($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from patient where patient_id = '$patientID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_profile_details($pharmacyID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from pharmacy where pharmacy_id = '$pharmacyID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function getalldoctor_details()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select device_id from doctor_signup";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function checknotificationdetails($patientID,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from push_notification where patient_id = '$patientID' and doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_profile_details($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- //$result3 = mysql_fetch_array($sql);
- // $image_old = $result3['profile_pic'];
- return $result;
- }
-
- public function patientdetail($emailID,$phoneNo,$patientName)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "select patient_id,patient_name,email_id,mobile_no,address,case_description,age,lat,log,type,token from patient where patient_name = '$patientName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
- $sql = "select * from patient where patient_name = '$patientName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_detail($emailID,$phoneNo,$pharmacyName)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "select patient_id,patient_name,email_id,mobile_no,address,case_description,age,lat,log,type,token from patient where patient_name = '$patientName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
- $sql = "select * from pharmacy where pharmacy_name = '$pharmacyName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
- $result=mysql_query($sql);
- return $result;
- }
- public function getdoctordetaildetails($emailID,$password)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "select * from doctor_signup where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('doctor_signup')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('doctor_signup')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- return $refIDKey;
-
- }
- else{
- die("password validation failed : getdoctordetaildetails");
- }
- }
- else{
- die("no match: getdoctordetaildetails");
- }
- }
- public function getquickregistrationdetail($mobile_no,$password)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "select * from patient where mobile_no = '$mobile_no' and password = '$password'";
- // $result=mysql_query($sql);
- // return $result;
- $mobileCheck = $this->conn->getReference('patient')
- ->orderByChild('mobile_no')
- ->equalTo($mobile_no);
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_mobile)==1 ){
- $refIDKey =$refID_mobile;
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- return $refIDKey;
-
- }
- else{
- die("password validation failed : getquickregistrationdetail");
- }
- }
- else{
- die("no match: getquickregistrationdetail");
- }
- }
-
- public function getpatient_details($emailID,$password)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "select * from patient where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
-
- // $result=mysql_query($sql);
-
- // return $result;
- $newPost = $this->conn->getReference('patient')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('patient')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- return $refIDKey;
-
- }
- else{
- die("password validation failed : getpatient_details");
- }
- }
- else{
- die("no match: getpatient_details");
- }
- }
- public function getpharmacy_details($emailID,$password)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "select * from pharmacy where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
-
- // $result=mysql_query($sql);
- // return $result;
- $newPost = $this->conn->getReference('pharmacy')
- ->orderByChild('email_id')
- ->equalTo($emailID);
- $mobileCheck = $this->conn->getReference('pharmacy')
- ->orderByChild('mobile_no')
- ->equalTo($emailID);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password){
- return $refIDKey;
-
- }
- else{
- die("password validation failed : getpharmacy_details");
- }
- }
- else{
- die("no match: getpharmacy_details");
- }
- }
- public function get_patient_details($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select pa.*,p.*, pa.status as TookStatus from patient_took as pa,patient as p where pa.doctor_id = '$doctorID' and p.patient_id=pa.patient_id and pa.status != 0";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getMyHistory($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select pa.*,p.*, pa.status as TookStatus from patient_took as pa,doctor_signup as p where pa.time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND pa.patient_id = '$doctorID' and p.doctor_id=pa.doctor_id";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getpatientdetailsa($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from patient where patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function check_login_details($email,$password,$type)
- {
-
- $newPost = $this->conn->getReference('healthcare_login')
- ->orderByChild('email_id')
- ->equalTo($email);
- $mobileCheck = $this->conn->getReference('healthcare_login')
- ->orderByChild('mobile_no')
- ->equalTo($email);
- $snapshot_email = $newPost->getSnapshot();
- $refID_email = $snapshot_email->getValue();
- $snapshot_mobile = $mobileCheck->getSnapshot();
- $refID_mobile = $snapshot_mobile->getValue();
-
- if(count($refID_email) == 1 || count($refID_mobile)==1 ){
- $refIDKey = empty($refID_email) ? $refID_mobile : $refID_email;
- $resetArray = array_values($refIDKey);
- if($resetArray[0]['password'] == $password && $resetArray[0]['type'] == $type){
- //login true
- return $refIDKey;
- }
- else{
- return [];
- }
- }
- else{
- return [];
- }
- }
-
- public function checkemaildetails($emailID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from healthcare_login where email_id = '$emailID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_mobile_no_s($mobileNo)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from healthcare_login where mobile_no = '$mobileNo'";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function insert_login($dID,$emailID,$mobileNo,$passwordD,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `healthcare_login`(`id`,`email_id`, `mobile_no`, `password`, `type`) VALUES
- ('$dID','$emailID','$mobileNo','$passwordD','D')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function quick_health_registration($mobileNo,$password,$id)
- {
- // mysql_query("set character_set_server='utf8'");
- // mysql_query("set names 'utf8'");
- // $sql = "INSERT INTO `healthcare_login`(`mobile_no`, `password`, `type`) VALUES ('$mobileNo','$passwordD','P')";
- // $result=mysql_query($sql);
- // return $result;
- $postData = [
- 'password' => $password,
- 'type' => 'P',
- 'mobile_no' => $mobileNo,
- 'login_id' => "",
- 'id' => $id,
- 'email_id' => "null"
- ];
- $postRef = $this->conn->getReference('healthcare_login')->push($postData);
- return $postRef;
- }
-
- public function insert_p_login($pID,$emailID,$mobile_no,$passwordD)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `healthcare_login`(`id`,`email_id`,`mobile_no`, `password`, `type`) VALUES ('$pID','$emailID','$mobile_no','$passwordD','P')";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_pharmacy_login($p_ID,$emailID,$mobile_no,$passwordD)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `healthcare_login`(`id`,`email_id`,`mobile_no`, `password`, `type`) VALUES ('$p_ID','$emailID','$mobile_no','$passwordD','F')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_status_detail($doctorID,$paymentID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `doctor_signup` SET `payment_id`= '$paymentID',`status`= 1 WHERE `doctor_id`='$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function checkemailid($emailID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where email_id = '$emailID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function check_patient_mobile_no($emailID,$phoneNo)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from patient where email_id = '$emailID' OR mobile_no = '$phoneNo'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function check_doctor_ID($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where doctor_id = '$doctorID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- /*------------------------------------------Chat-------------------------------------------------*/
- public function get_type_details($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "select * from push_notification_details where doctor_id = '$id' and status = '1'";
- $sql = "select * from chat_message where from_id = '$id' OR to_id = '$id' and type = 'D' Group By to_id";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_last_message_date($fromID,$toID,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from chat_message where to_id = '$toID' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_farmacy_last_message_date($fromID,$toid,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from chat_message where to_id = '$toid' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_farmacy_p_last_message_date($fromID,$toid,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from chat_message where to_id = '$toid' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_chat_patient_details($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select from_id,to_id from chat_message where (from_id = '$id' AND type = 'D') OR (to_id = '$id' AND type = 'P') GROUP BY from_id";
- $result=mysql_query($sql);
-
-
- $PatToID = array();
- $PatFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'D')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $PatToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'P')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $PatFromID[] = $resultF['from_id'];
- }
- $array_merge_patients = array_merge($PatToID, $PatFromID);
- $Newpatients = array_unique($array_merge_patients);
- $all_chat_patients = array_values($Newpatients);
-
- /*echo "<pre>";
- print_r($all_chat_patients);
- echo "</pre>";*/
- return $all_chat_patients;
-
- }
- public function get_chat_pharmacy_details($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select from_id,to_id from chat_message where to_id = '$id' AND (type = 'DF' OR type = 'FD') GROUP BY from_id";
-
- $result=mysql_query($sql);
-
- $PhRToID = array();
- $PhRFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'DF')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $PhRToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'FD')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $PhRFromID[] = $resultF['from_id'];
- }
- $array_merge_pharmcy = array_merge($PhRToID, $PhRFromID);
- $Newpharmcy = array_unique($array_merge_pharmcy);
- $all_chat_pharmcy = array_values($Newpharmcy);
-
- return $all_chat_pharmcy;
-
- //return $all_chat_pharmcy;
-
- }
- public function get_chat_pharmacy_patient_details($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- /*$sql = "select from_id,to_id from chat_message where from_id = '$id' AND (type = 'FP' OR type = 'PF') GROUP BY to_id";
-
- $result=mysql_query($sql);*/
-
- $PhRToID = array();
- $PhRFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'PF')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $PhRToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'FP')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $PhRFromID[] = $resultF['from_id'];
- }
- $array_merge_pharmcy = array_merge($PhRToID, $PhRFromID);
- $Newpharmcy = array_unique($array_merge_pharmcy);
- $all_chat_pharmcy = array_values($Newpharmcy);
-
-
-
- return $all_chat_pharmcy;
-
- }
- public function get_patient_id_chat($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- /*$sql = "select from_id,to_id from chat_message where (from_id = '$id' AND type = 'FP') OR (to_id = '$id' AND type = 'PF') GROUP BY from_id";
- $result=mysql_query($sql);*/
-
- $PatToID = array();
- $PatFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'FP')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $PatToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'PF')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $PatFromID[] = $resultF['from_id'];
- }
- $array_merge_patients = array_merge($PatToID, $PatFromID);
- $Newpatients = array_unique($array_merge_patients);
- $all_chat_patients = array_values($Newpatients);
-
- return $all_chat_patients;
- }
- public function get_doctor_id_chat($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- /*$sql = "select from_id,to_id from chat_message where (from_id = '$id' AND type = 'FD') OR (to_id = '$id' AND type = 'DF') GROUP BY to_id";
-
- $result=mysql_query($sql);*/
-
- $DcoToID = array();
- $DocFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'FD')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $DcoToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'DF')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $DocFromID[] = $resultF['from_id'];
- }
- $array_merge_doctors = array_merge($DcoToID, $DocFromID);
- $Newdoctors= array_unique($array_merge_doctors);
- $all_chat_doctors = array_values($Newdoctors);
-
- return $all_chat_doctors;
-
- }
- public function get_pharmacy_det_id()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from pharmacy";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_chat_doctor_chatlist($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT from_id,to_id
- FROM `chat_message`
- WHERE (from_id = '$id'
- OR to_id = '$id') AND type='DD'
- GROUP BY (
- to_id
- AND from_id
- )";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_chat_doctor_details($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- /*$sql = "select * from chat_message where from_id = '$id' AND type = '$type' GROUP BY to_id";
- $result=mysql_query($sql);*/
-
- $DocToID = array();
- $DocFromID = array();
- $sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'P')";
- $qryT=mysql_query($sqlT);
- while($resultT=mysql_fetch_assoc($qryT)) {
- $DocToID[] = $resultT['to_id'];
- }
-
- $sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'D')";
- $qryF=mysql_query($sqlF);
- while($resultF=mysql_fetch_assoc($qryF)) {
- $DocFromID[] = $resultF['from_id'];
- }
- $array_merge_doctor = array_merge($DocToID, $DocFromID);
- $Newdoctor = array_unique($array_merge_doctor);
- $all_chat_doctor = array_values($Newdoctor);
-
- return $all_chat_doctor;
-
- }
- public function get_doctor_requst_details($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from push_notification_details where patient_id = '$id'";
- //echo $sql;
- //$sql = "select * from chat_message where from_id = '$id' OR to_id = '$id' and type = 'D' GROUP BY from_id OR to_id";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function getpatientdetails($pID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select patient_id as id,patient_name as name,profile_pic,type from patient where patient_id = '$pID'";
- //echo $sql;
- //$sql = "select patient_id as id,patient_name as name,profile_pic,type from patient";
- $result=mysql_query($sql);
- return $result;
- }
- public function getdoctor_details($pID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select doctor_id as id,doctor_name as name,profile_pic,type from doctor_signup where doctor_id = '$pID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_detailrow($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select doctor_id as id,doctor_name as name,profile_pic,type from doctor_signup where doctor_id = '$doctorID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_detail_patient($fromID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from patient where patient_id = '$fromID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function getmessaged($id,$pID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT chatmsg_id,message,status,date,message_type FROM chat_message WHERE (from_id = '$id' AND to_id = '$pID') OR (from_id = '$pID' AND to_id = '$id') ORDER BY chatmsg_id DESC LIMIT 1";
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$pID' AND type = 'D') OR (from_id = '$pID' AND to_id = '$id' AND type = 'P') ORDER BY chatmsg_id DESC LIMIT 1";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function getDmessaged($id,$pID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT chatmsg_id,message,status,date,message_type FROM chat_message WHERE (from_id = '$id' AND to_id = '$pID') OR (from_id = '$pID' AND to_id = '$id') ORDER BY chatmsg_id DESC LIMIT 1";
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$pID' AND type = 'P') OR (from_id = '$pID' AND to_id = '$id' AND type = 'D') ORDER BY chatmsg_id DESC LIMIT 1";
-
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getpharmacymessaged($id,$fID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT chatmsg_id,message,status,date,message_type FROM chat_message WHERE (from_id = '$id' AND to_id = '$pID') OR (from_id = '$pID' AND to_id = '$id') ORDER BY chatmsg_id DESC LIMIT 1";
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$fID' AND type = 'DF') OR (from_id = '$fID' AND to_id = '$id' AND type = 'FD') ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getpharmacypatientmessaged($id,$fID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$fID' AND type = 'PF') OR (from_id = '$fID' AND to_id = '$id' AND type = 'FP') ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getpharmacypatientmessaged1($id,$fID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$fID' AND type = 'FP') OR (from_id = '$fID' AND to_id = '$id' AND type = 'PF') ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getpharmacydoctormessaged($id,$fID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$fID' AND type = 'FD') OR (from_id = '$fID' AND to_id = '$id' AND type = 'DF') ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function getpharmacydmessaged($id,$fID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chat_message WHERE (from_id = '$id' AND to_id = '$fID' AND type = 'FF') OR (from_id = '$fID' AND to_id = '$id' AND type = 'FF') ORDER BY chatmsg_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
-
-
- public function insert_message($fromID,$toID,$message,$type,$mtype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`,`read_status`) VALUES ('$fromID','$toID','$message','0','$type','$mtype','0')";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_invite_doctor_chat($doctorID,$member_ID,$messageID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`,`read_status`) VALUES ('$doctorID','$member_ID','$messageID','0','DD','text','0')";
- $result=mysql_query($sql);
- return $result;
- }public function insert_case_description($patientID,$doctorID,$caseD,$date,$type,$status, $FirstLat = '', $FirstLan = '')
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`,`read_status`, `first_lat`, `first_lang`) VALUES ('$patientID','$doctorID','$caseD','0','P','p_text','0', '$FirstLat', '$FirstLan')";
- $result=mysql_query($sql);
- return $result;
- }
- public function upload_image($fromID,$toID,$file_url,$type,$mtype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`,`read_status`, `message_type`) VALUES ('$fromID','$toID','$file_url','0','$type','0','$mtype')"; //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function upload_image_group($fromID,$toID,$file_url,$type,$mtype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `group_chat`(`member_id`, `group_id`, `message`, `message_type`, `read_status`, `type`) VALUES ('$fromID','$toID','$file_url','$mtype','0','$type')"; //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_status($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND (type = 'P' OR type = 'D')";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'FP'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_far_patient_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'PF'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_far_doc_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'DF'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_phar_to_phar($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE (`from_id` = '$toID' AND `to_id` = '$fromID') AND type = 'FF'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_from_doc_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'FD'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_patientd_message_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'PF'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_docmessage_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'DF'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_messageFF_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'FD'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_messagefp_from_pharmacy($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `chat_message` SET `read_status`='1' WHERE ((`from_id` = '$fromID' AND `to_id` = '$toID') OR (`from_id` = '$toID' AND `to_id` = '$fromID')) AND type = 'FP'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_read_message_from_group($toID,$fromID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `readchatmessage` SET `status`='1' WHERE group_id = '$toID' AND member_id = '$fromID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_chat_image($fromID,$toID,$type,$mtype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chat_message WHERE patient_id = '$pid'";
- $result=mysql_query($sql);
- return $result;
- }
- public function getmessagedetail($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' AND to_id = '$tid' AND type = 'D') OR (from_id = '$tid' and to_id = '$fid' AND type = 'P')";
- $result=mysql_query($sql);
- return $result;
- }
- public function getfmessagedetail($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' AND to_id = '$tid' AND type = 'DF') OR (from_id = '$tid' AND to_id = '$fid' AND type = 'FD')";
- $result=mysql_query($sql);
- return $result;
- }
- public function getpatientmessagedetail($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' AND to_id = '$tid' AND type = 'PF') OR (from_id = '$tid' AND to_id = '$fid' AND type = 'FP')";
- $result=mysql_query($sql);
- return $result;
- }
- public function getmessagedetaildetails($fid,$tid,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT from_id,to_id,message,status,date,type,message_type from `chat_message` where ((from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')) AND type='DD'";
- $result=mysql_query($sql);
- return $result;
- }
- public function getpmessagedetail($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' AND to_id = '$tid' AND type = 'P') OR (from_id = '$tid' AND to_id = '$fid' AND type = 'D')";
- //$sql = "SELECT from_id as toid,to_id as fromid,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_chat_message($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where ((from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')) AND (type = 'DF' OR type = 'PF' OR type = 'FD' OR type = 'FP' OR type = 'FF')";
- //$sql = "SELECT from_id as toid,to_id as fromid,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_pharmacy_doctor_chat_message($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' AND to_id = '$tid' AND type = 'FD') OR (from_id = '$tid' AND to_id = '$fid' AND type = 'DF')";
- //$sql = "SELECT from_id as toid,to_id as fromid,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_pharmacy_patient_chat_message($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid' AND type = 'FP') OR (from_id = '$tid' and to_id = '$fid' AND type = 'PF')";
- //$sql = "SELECT from_id as toid,to_id as fromid,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_pharmacy_pharmacy_chat_message($fid,$tid,$type,$to_type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT chatmsg_id,from_id,to_id,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid' AND type = 'FF') OR (from_id = '$tid' and to_id = '$fid' AND type = 'FF')";
- //$sql = "SELECT from_id as toid,to_id as fromid,message,status,date,type,message_type from `chat_message` where (from_id = '$fid' and to_id = '$tid') OR (from_id = '$tid' and to_id = '$fid')";
- $result=mysql_query($sql);
- return $result;
- }
-
-
-
- public function count_unread_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type != '$type'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_unread_pharmacyd_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$id' AND `to_id` = '$res') and `read_status` = '0' AND type = 'FP'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_unread_far_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type = 'FD'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_unread_DS_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type = 'D'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_pharmacyunread_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type = 'FP'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_pharunread_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type = '$type'";
- $result=mysql_query($sql);
- return $result;
- }
- public function count_unread_pat_message($id,$res,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') AND `read_status` = '0' AND type = 'P'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function count_unread_message_doctor($id,$doctor_Id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$doctor_Id' AND `to_id` = '$id') OR (`from_id` = '$id' AND `to_id` = '$doctor_Id') AND `read_status` = '0'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_member_det($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM chatgroup_details WHERE group_id = '$toID' AND doctor_id != '$fromID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function count_unread_group_message($group_id,$memberID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `readchatmessage` WHERE group_id = '$group_id' AND member_id = '$memberID' AND `status` = '0'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_unread_message($fromID,$toID,$groupchatID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `readchatmessage`( `groupchat_id`, `group_id`, `member_id`, `status`) VALUES ('$groupchatID','$toID','$fromID','0')";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_took($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE patient set took = '1' where patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_attended($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT *
- FROM `patient`
- WHERE patient_id NOT
- IN (
- SELECT patient_id
- FROM push_notification_details
- WHERE doctor_id = '$doctorID'
- AND STATUS = '1'
- )";
-
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_doctor_token_details($getresult,$categoryID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT device_id
- FROM `doctor_signup`
- WHERE doctor_id = '$getresult'";
-
- $result=mysql_query($sql);
- return $result;
- }
-
-
- public function get_patient_token_details($PatientId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT token FROM `patient` WHERE patient_id = '$PatientId'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result;
- }
-
- public function getDoctorTokenDevice($PatientId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT device_id FROM `doctor_signup` WHERE doctor_id = '$PatientId'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result;
- }
-
- public function get_pharmacydetail()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from pharmacy";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_details_api($fromID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from pharmacy";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_details_api_d($fromID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from pharmacy where pharmacy_id = '$fromID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_f($patientID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT `patient_id` as id, `patient_name` as name, `profile_pic`, `type` FROM `patient` where patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_f($dID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT `doctor_id` as id, `doctor_name` as name, `profile_pic`, `type` FROM `doctor_signup` where doctor_id = '$dID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- /*------------------------------------------End Chat-------------------------------------------------*/
-
- /*------------------------------------------Group Chat-------------------------------------------------*/
- public function create_group($groupName,$doctorID,$groupImg)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `create_group`(`group_name`, `doctor_id`,`group_image`,`type`) VALUES ('$groupName',$doctorID,'$groupImg','G')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_group_records($groupName,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from `create_group` where group_name = '$groupName' AND doctor_id = '$doctorID'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_patient_help($patient_id,$speciallize_doctor,$description)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from `patient_help`";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
-
- public function create_group_without_url($groupName,$doctorID,$file_url_name)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- if(isset($_FILES['imageData']['name']))
- {
- if((($_FILES['imageData']['type'] == "image/jpeg")|| ($_FILES['imageData']['type'] == "image/gif")|| ($_FILES['imageData']['type'] == "image/jpg")|| ($_FILES['imageData']['type'] == "image/png")&& ($_FILES['imageData']['size'] < 1000000000000000))){
-
-
-
- if ($_FILES["imageData"]["error"] > 0) echo "Return Code: " . $_FILES["imageData"]["error"] . "<br />"; else {
-
- $Ex = end(explode(".",$_FILES['imageData']['name']));
-
- $array = explode(".",$_FILES['imageData']['name']);
-
- $file_url_name = $array[0].time().".".$Ex;
-
- move_uploaded_file($_FILES["imageData"]["tmp_name"], "uploads/group_image/".$file_url_name);
-
- }
- }
- }
- $file_url_name1 = "http://bytesnmaterials.com/healthcare/uploads/group_image/".$file_url_name;
-
-
- $sql = "INSERT INTO `create_group`(`group_name`, `doctor_id`,`group_image`,`type`) VALUES ('$groupName','$doctorID','$file_url_name1','G')";
- $result=mysql_query($sql);
- return $result;
- }
- public function add_doctor_from_group($groupName,$doctorID,$member_id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chatgroup_details`(`group_id`, `doctor_id`,`member_id`) VALUES ('$groupName','$doctorID','$member_id')";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function add_patient_help($patient_id,$speciallize_doctor,$description)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `patient_help`(`patient_id`, `speciallize_doctor`, `description`) VALUES ('$patient_id','$speciallize_doctor','$description')";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function get_group_all_doctor($groupID,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chatgroup_details` where group_id = '$groupID' AND doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_all_group_doctor($doctor_iD)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM doctor_signup where doctor_id != '$doctor_iD'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_group_list($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT g.group_id AS id, g.group_name AS name, g.group_image AS profile_pic, g.type
- FROM `create_group` AS g, chatgroup_details AS cg
- WHERE cg.group_id
- IN (
- SELECT group_id
- FROM chatgroup_details
- WHERE cg.doctor_id = '$id'
- ) AND g.group_id = cg.group_id";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_group_name($groupName)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `create_group` where group_id = '$groupName'";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_group_admin_details($groupId,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chatgroup_details`(`group_id`, `doctor_id`, `member_id`) VALUES ('$groupId','$doctorID','$doctorID')";
-
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function get_group_admin_id($groupID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `create_group` where group_id = '$groupID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function getlastmessagegroup($group_id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `group_chat` where group_id = '$group_id' ORDER BY groupchat_id DESC LIMIT 1";
- $result=mysql_query($sql);
- return $result;
- }
- public function getgroupmessagedetail($tid,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "SELECT groupchat_id,member_id as fromid,group_id,message,message_type,read_status,type,date FROM `group_chat` where group_id = '$tid' AND type = '$type'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_profile_pic($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT profile_pic FROM `doctor_signup` where doctor_id = '$doctorID'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function getgroup_doc_IDet($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chatgroup_details` where doctor_id = '$id'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_group_message($fromID,$toID,$message,$type,$mtype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `group_chat`(`member_id`, `group_id`, `message`, `message_type`, `read_status`, `type`) VALUES ('$fromID','$toID','$message','$mtype',0,'$type')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_all_doctor_group_details($groupID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `chatgroup_details` where group_id = '$groupID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_group_doctor_token_detail($docID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT device_id FROM `doctor_signup` where doctor_id = '$docID'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function get_last_group_message_date($toID,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `group_chat` where group_id = '$toID' ORDER BY groupchat_id DESC LIMIT 1";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_pstient_took($patientID,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `patient_took` where doctor_id = '$doctorID' AND patient_id = '$patientID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_patienttook($patientID,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `patient_took` where doctor_id = '$doctorID' AND patient_id = '$patientID' AND status = '1'";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_patient_took($patientID,$doctorID,$status,$duration, $lat, $lang)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT * FROM `patient_took` where patient_id = '$patientID' AND doctor_id = '$doctorID' AND doctor_id = '$status'";
- $sql = "INSERT INTO `patient_took`(`patient_id`, `doctor_id`, `status`,`duration`, `lat`, `lang`) VALUES ('$patientID','$doctorID','$status','$duration', '$lat', '$lang')";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_took_patientd($patientID,$doctorID,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT * FROM `patient_took` where patient_id = '$patientID' AND doctor_id = '$doctorID' AND doctor_id = '$status'";
- $sql = "UPDATE `patient_took` set `status` = '$status' Where patient_id = '$patientID' AND doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function update_took_patientdAndTime($patientID,$doctorID,$status, $Duration)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT * FROM `patient_took` where patient_id = '$patientID' AND doctor_id = '$doctorID' AND doctor_id = '$status'";
- $sql = "UPDATE `patient_took` set `status` = '$status', `duration` = '$Duration' Where patient_id = '$patientID' AND doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_doctor_name_notification($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- //$sql = "SELECT * FROM `patient_took` where patient_id = '$patientID' AND doctor_id = '$doctorID' AND doctor_id = '$status'";
- $sql = "SELECT * from doctor_signup where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_deviceId_D($getresult)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "SELECT * from doctor_signup where doctor_id = '$getresult'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_ID($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from patient_took where doctor_id = '$doctorID' AND status = '1'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctorID($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from patient_took where patient_id = '$id' AND status = '1'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function check_mail_id($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from healthcare_login where (email_id = '$id' OR mobile_no = '$id')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_healthcare_login($id,$npassword)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "Update healthcare_login SET password = '$npassword' where (email_id = '$id' OR mobile_no = '$id')";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_password_details($id,$npassword)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient` SET `password`='$npassword' WHERE email_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_doctor_password_details($id,$npassword)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `doctor_signup` SET `password`='$npassword' WHERE email_id = '$id'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_mpassword_details($id,$npassword)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient` SET `password`='$npassword' WHERE mobile_no = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_doctor_mpassword_details($id,$npassword)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `doctor_signup` SET `password`='$npassword' WHERE mobile_no = '$id'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function update_doctor_call_status($id,$type,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `doctor_signup` SET call_status = '$status' WHERE `doctor_id`='$id'";
- //echo $sql;
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_call_status($id,$type,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient` SET call_status = '$status' WHERE patient_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_call_status($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from doctor_signup where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_logout_status($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE patient SET token = '', status = '2' where patient_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_doctor_logout_status($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE doctor_signup SET device_id = '', status = '2' where doctor_id = '$id'";
- //$sql = "UPDATE doctor_signup SET status = '2' where doctor_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_pharmacy_logout_status($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE pharmacy SET token = '', status = '2' where pharmacy_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
-
-
-
- public function update_doctor_status($id,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE doctor_signup SET status = '$status' where doctor_id = '$id'";
- //$sql = "UPDATE doctor_signup SET status = '2' where doctor_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function update_doctor_lat_long($id,$lat,$long)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE doctor_signup SET lat = '$lat', log = '$long' where doctor_id = '$id'";
- //$sql = "UPDATE doctor_signup SET status = '2' where doctor_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
-
-
- public function check_doctor_logout_status($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT status FROM doctor_signup where doctor_id = '$id'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result['status'];
- }
-
- public function update_doctor_took_status($did,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE doctor_signup SET status = '$status' where doctor_id = '$did'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_patient_took_status($pid,$status)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE patient SET status = '$status' where patient_id = '$pid'";
- $result=mysql_query($sql);
- return $result;
- }
- public function compress_image($source_url, $destination_url, $quality) {
- $info = getimagesize($source_url);
- //echo $destination_url;
- //echo $destination_url;
- if ($info['mime'] == 'image/jpeg')
- $image = imagecreatefromjpeg($source_url);
- elseif ($info['mime'] == 'image/gif')
- $image = imagecreatefromgif($source_url);
- elseif ($info['mime'] == 'image/png')
- $image = imagecreatefrompng($source_url);
- //echo $image;
- imagejpeg($image, $destination_url, $quality);
- return $destination_url;
- }
- /*-----------------------Map All Person API--------------------------------*/
- public function get_all_patient_api()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from `patient`";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_all_doctor_api($id = "")
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- if($id != "")
- {
- //$sql = "SELECT * from doctor_signup where doctor_id != '".$id."' AND `lat` != '' AND `lat` != '0.0' AND `log` != '' AND `log` != '0.0'";
- $sql = "SELECT * from doctor_signup where `lat` != '' AND `lat` != '0.0' AND `log` != '' AND `log` != '0.0'";
- }
- else{
- $sql = "SELECT * FROM `doctor_signup` WHERE `lat` != '' AND `lat` != '0.0' AND `log` != '' AND `log` != '0.0'";
- }
- $result=mysql_query($sql);
- return $result;
- }
- public function get_all_pharmacy_api()
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from pharmacy";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_api($PatientId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from patient where patient_id='$PatientId'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_pharmacy_details($pharmacyID,$hourID,$workinghourID,$home_deliveryID,$inject)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE pharmacy SET hour_status = '$hourID',home_delivery = '$home_deliveryID',working_hour = '$workinghourID',injection_provider = '$inject' where pharmacy_id = '$pharmacyID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_details($pID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM pharmacy where pharmacy_id = '$pID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_healthcare_logindetails($ID,$emailID,$mobileNo,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `healthcare_login` SET `email_id` = '$emailID' , `mobile_no` = '$mobileNo' where `id` = '$ID' AND type = '$type'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function update_healthcare_pharmacy_logindetails($pharmacyID,$emailID,$mobileNO)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `healthcare_login` SET `email_id` = '$emailID' , `mobile_no` = '$mobileNO' where `id` = '$pharmacyID'";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_lastmessage_groupchat($fromID,$toID,$message)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `group_chat`where `member_id` = '$fromID' AND `group_id` = '$toID' AND `message` = '$message' ORDER BY groupchat_id DESC LIMIT 1";
-
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctordetailsD($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `doctor_signup`where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_rating_details($patientID,$doctorID,$rate)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `rating`(`patient_id`, `doctor_id`, `rate`) VALUES ('$patientID','$doctorID','$rate')";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_rating_status($patientID,$doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM rating where patient_id = '$patientID' AND doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function update_rating_details($patientID,$doctorID,$rate)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE rating SET rate = '$rate' where patient_id = '$patientID' AND doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_patient_token_id($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT token as ud_id,patient_id FROM patient where patient_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_token_id($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT device_id as ud_id,doctor_id FROM doctor_signup where doctor_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_pharmacy_token_id($id,$type)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT pharmacy_id,token as ud_id FROM pharmacy where pharmacy_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_casedescription_chat_message($getresult,$patientID,$caseD)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT pharmacy_id,token as ud_id FROM pharmacy where pharmacy_id = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_history($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from doctor_signup where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_doctor_rating($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * from rating where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function get_sum_of_rating($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select sum(rate) as rate from rating where doctor_id = '$doctorID'";
- $result=mysql_query($sql);
- return $result;
- }
- public function check_h_took_status($fromID,$toID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select * FROM patient_took where patient_id = '$fromID' AND doctor_id = '$toID' AND status = 1";
- $result=mysql_query($sql);
- return $result;
- }
- public function insert_duration_chat($patientID,$doctorID,$messg,$status,$mytype)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`, `read_status`) VALUES ('$doctorID','$patientID','$messg','$status','$mytype','text','0')";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function getDoctorTookStatus($DocId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `patient_took` WHERE `doctor_id` = '$DocId' and `status` = '1'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result;
- }
-
- public function getPatientTookStatus($PTId, $DocId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "SELECT * FROM `patient_took` WHERE `patient_id` = '$PTId' and `doctor_id` = '$DocId' and `status` = '1'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result;
- }
-
- public function GetTookDetail($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * FROM `patient_took` WHERE `id` = '$id'";
- $result=mysql_fetch_assoc(mysql_query($sql));
- return $result;
- }
-
- public function UpdateDoneStatus($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient_took` SET status = '2' WHERE `id` = '$id'";
- $result=mysql_query($sql);
- return $result;
- }
- public function UpdatePaitentReview($id, $Rating, $Review)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient_took` SET pt_rating = '$Rating', pt_review = '$Review' where `id` = '$id'";
- mysql_query($sql);
- }
- public function UpdateDoctorReview($id, $Rating, $Review)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient_took` SET doctor_rate = '$Rating', doctor_review = '$Review' where `id` = '$id'";
- mysql_query($sql);
- }
-
-
-
- public function GetDoctorAvgRating($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT AVG(`doctor_rate`) as AvgRate from patient_took where `doctor_id` = '$id'";
- return mysql_fetch_assoc(mysql_query($sql));
- }
-
- public function get_patient_cancel_details($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select pa.*,p.*, pa.status as TookStatus from patient_took as pa,patient as p where pa.time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND pa.doctor_id = '$doctorID' and p.patient_id=pa.patient_id and pa.status = 0";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function get_doctor_cancel_details($doctorID)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "select pa.*,p.*, pa.status as TookStatus from patient_took as pa,doctor_signup as p where pa.time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND pa.patient_id = '$doctorID' and p.doctor_id=pa.doctor_id and pa.status = 4";
- $result=mysql_query($sql);
- return $result;
- }
-
- public function AcceptTimeExt($TookId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "UPDATE `patient_took` SET status = '1' WHERE `id` = '$TookId'";
- $result=mysql_query($sql);
- return $result;
- }
- public function InsertCancelTook($TookId)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
-
- $sql = "SELECT * FROM `patient_took` WHERE `id` = '$TookId'";
- $result=mysql_fetch_assoc(mysql_query($sql));
-
- $PTID = $result['patient_id'];
- $DocId = $result['doctor_id'];
-
- $sql = "INSERT INTO `cancel_took`(`cancel_took_patient`, `cancel_took_doctor`) VALUES ('$PTID','$DocId')";
- mysql_query($sql);
-
-
- $sql = "DELETE FROM `patient_took` WHERE `id` = '$TookId'";
- mysql_query($sql);
- }
-
- public function GetAllPatientRating($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from patient_took as ptt LEFT JOIN doctor_signup as DS on ptt.doctor_id=DS.doctor_id where `patient_id` = '$id' and pt_rating != '0'";
- return mysql_query($sql);
- }
-
- public function GetAllDoctorRating($id)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT * from patient_took as ptt LEFT JOIN patient as DS on ptt.patient_id=DS.patient_id where `doctor_id` = '$id' and doctor_rate != '0'";
- return mysql_query($sql);
- }
-
- /*public function get_doctor_history($doctor_id,$hist_date)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- echo $sql = "SELECT patient_id FROM patient_took where doctor_id = '$doctor_id' AND status = '2' AND time >= '$hist_date'";
- $result=mysql_query($sql);
- return $result;
- }
- */
-
- /*public function get_doctor_history($doctor_id,$hist_date)
- {
- mysql_query("set character_set_server='utf8'");
- mysql_query("set names 'utf8'");
- $sql = "SELECT patient_id FROM patient_took where doctor_id = '$doctor_id' AND status = '2' AND time >= '$hist_date'";
- $result=mysql_query($sql);
- return $result;
- }*/
- }
- ?>