PageRenderTime 70ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 1ms

/classes/firebaseclass.php

https://bitbucket.org/devpronitzz/healthcase
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

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. $root = $_SERVER['DOCUMENT_ROOT'];
    3. 

  3. /*
    4. 

  4. include_once $root.'/services/connection/db.php';
    5. 

  5. include_once $root.'/services/classes/publicClass/commanClass.php';
    6. 

  6. include_once $root.'/services/classes/publicClass/responseClass.php';
    7. 

  7. */
    8. 

  8. 

  9. //include_once 'connection/db.php';
    10. 

  10. include_once 'publicClass/responseClass.php'; 
    11. 

  11. require './firebase/vendor/autoload.php';
    12. 

  12. 

  13. use Kreait\Firebase\Factory;
    14. 

  14. use Kreait\Firebase\ServiceAccount;
    15. 

  15. 

  16. 

  17. error_reporting(E_ALL ^ E_DEPRECATED);
    18. 

  18. //Create Connection Class
    19. 

  19. class UserClass
    20. 

  20. {
    21. 

  21.    	var $conn;
    22. 

  22. 	//constructor to eastablishment connection with database
    23. 

  23. 	public function __construct()
    24. 

  24. 	{
    25. 

  25. 		$serviceAccount = ServiceAccount::fromJsonFile('./firebase/firebase_credentials.json');
    26. 

  26. 		$firebase = (new Factory)
    27. 

  27.     				->withServiceAccount($serviceAccount)
    28. 

  28.     				->withDatabaseUri('https://projects-a6962.firebaseio.com')
    29. 

  29.     				->create();
    30. 

  30.     	$this->conn = $firebase->getDatabase();			
    31. 

  31. 		
    32. 

  32.     }
    33. 

  33. 	/*********Query start Following Block 1********/
    34. 

  34. 	
    35. 

  35. 	/*public function imageupload()
    36. 

  36. 	{
    37. 

  37. 		$image_name = $_FILES["fileUpload1"]["name"];	
    38. 

  38. 		$tmp_arr = explode(".",$image_name);
    39. 

  39. 		$img_extn = end($tmp_arr);
    40. 

  40. 		$new_image_name = 'image_'. uniqid() . date('YmdHis').'.'.$img_extn;	
    41. 

  41. 		$flag=0;				 
    42. 

  42. 		if (file_exists("uploads/".$new_image_name))
    43. 

  43. 		{
    44. 

  44. 		   return false;
    45. 

  45. 		}
    46. 

  46. 		else
    47. 

  47. 		{	
    48. 

  48. 			 move_uploaded_file($_FILES["fileUpload1"]["tmp_name"],"uploads/". $new_image_name);
    49. 

  49. 			$flag = 1;
    50. 

  50. 			$static_url = "http://bytesnmaterials.com/healthcare/uploads/".$new_image_name;
    51. 

  51. 			return $static_url; 
    52. 

  52. 		}
    53. 

  53. 	}*/
    54. 

  54. 	
    55. 

  55. 	
    56. 

  56. 	//$imagePath = 'http://bytesnmaterials.com/healthcare/profile/profile.png';
    57. 

  57. 	
    58. 

  58. 	public function signup_doctor($doctorName,$address,$mobileNo,$emailID,$passwordD,$deviceID,$register_image,$latID,$logID,$file_url_name,$imagePath,$unionID1,$feeID,$specialID,$callstatus)
    59. 

  59. 	{    
    60. 

  60. 		mysql_query("set character_set_server='utf8'");
    61. 

  61. 		mysql_query("set names 'utf8'");  
    62. 

  62. 		
    63. 

  63. 		
    64. 

  64. 			if(isset($_FILES['imageData']['name'])) 
    65. 

  65. 			{	
    66. 

  66. 			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))){
    67. 

  67. 	
    68. 

  68. 			
    69. 

  69. 	
    70. 

  70. 						if ($_FILES["imageData"]["error"] > 0)        echo "Return Code: " . $_FILES["imageData"]["error"] . "<br />"; else    {
    71. 

  71. 	
    72. 

  72. 							$Ex = end(explode(".",$_FILES['imageData']['name']));
    73. 

  73. 	
    74. 

  74. 							$array = explode(".",$_FILES['imageData']['name']);
    75. 

  75. 	
    76. 

  76. 							$file_url_name = $array[0].time().".".$Ex;
    77. 

  77. 	
    78. 

  78. 							move_uploaded_file($_FILES["imageData"]["tmp_name"], "uploads/col_certificate/".$file_url_name);
    79. 

  79. 			
    80. 

  80. 				}	
    81. 

  81. 			}
    82. 

  82. 		}
    83. 

  83. 		$file_url_name1 = "http://bytesnmaterials.com/healthcare/uploads/col_certificate/".$file_url_name;
    84. 

  84. 		$register_image1 = "http://bytesnmaterials.com/healthcare/uploads/register_image/".$register_image;
    85. 

  85. 		
    86. 

  86. 		$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')";
    87. 

  87. 		$result=mysql_query($sql);
    88. 

  88. 		return $result;
    89. 

  89. 		
    90. 

  90. 		
    91. 

  91. 	}
    92. 

  92. 	public function insert_notification_details($tokenID,$patientID,$doctorID,$name,$message,$caseD,$date,$type,$status)
    93. 

  93. 	
    94. 

  94. 	{    
    95. 

  95. 		mysql_query("set character_set_server='utf8'");
    96. 

  96. 		mysql_query("set names 'utf8'");
    97. 

  97. 		$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')";
    98. 

  98. 		$result=mysql_query($sql);
    99. 

  99. 		return $result;
    100. 

  100. 	}
    101. 

  101. 	public function insert_push_notification_details($tokenID,$patientID,$patientname,$getresult,$caseD,$date,$type,$status)
    102. 

  102. 	{    
    103. 

  103. 		mysql_query("set character_set_server='utf8'");
    104. 

  104. 		mysql_query("set names 'utf8'");
    105. 

  105. 		//$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')";
    106. 

  106. 		$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')";
    107. 

  107. 		//echo $sql;
    108. 

  108. 		$result=mysql_query($sql);
    109. 

  109. 		return $result;
    110. 

  110. 	}
    111. 

  111. 	public function insert_patient_notification($patientID,$doctorID,$message,$date,$status)
    112. 

  112. 	
    113. 

  113. 	{    
    114. 

  114. 		mysql_query("set character_set_server='utf8'");
    115. 

  115. 		mysql_query("set names 'utf8'"); 
    116. 

  116. 		$sql = "INSERT INTO `push_notification_details`(`patient_id`, `doctor_id`, `message`, `status`, `date`) VALUES ('$patientID','$doctorID','$message','$status','$date')";
    117. 

  117. 		$result=mysql_query($sql);
    118. 

  118. 		return $result;
    119. 

  119. 	}
    120. 

  120. 	
    121. 

  121. 	public function update_pushnotification($id,$status)
    122. 

  122. 	
    123. 

  123. 	{    
    124. 

  124. 		mysql_query("set character_set_server='utf8'");
    125. 

  125. 		mysql_query("set names 'utf8'"); 
    126. 

  126. 		$sql = "UPDATE `push_notification` SET `status`='$status' WHERE `id`='$id'";
    127. 

  127. 		$result=mysql_query($sql);
    128. 

  128. 		return $result;
    129. 

  129. 	}
    130. 

  130. 	
    131. 

  131. 	public function insert_patient_details($patientName,$emailID,$phoneNo,$address,$case_desc,$password,$age,$latitude,$logitude,$type,$tokenID)
    132. 

  132. 	
    133. 

  133. 	{    
    134. 

  134. 		mysql_query("set character_set_server='utf8'");
    135. 

  135. 		mysql_query("set names 'utf8'");
    136. 

  136. 		
    137. 

  137. 		$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')";
    138. 

  138. 		
    139. 

  139. 		$result=mysql_query($sql);
    140. 

  140. 		return $result;
    141. 

  141. 	}
    142. 

  142. 

  143. 	public function insert_pharmacy_details($pharmacyName,$emailID,$phoneNo,$address,$password,$age,$latitude,$logitude,$type,$tokenID,$hour_status,$working_hour)
    144. 

  144. 	
    145. 

  145. 	
    146. 

  146. 	
    147. 

  147. 	{    
    148. 

  148. 	
    149. 

  149. 	if($is_24_hours_support == ""){
    150. 

  150. 		
    151. 

  151. 		$is_24_hours_support1 = "false";
    152. 

  152. 	}else{
    153. 

  153. 		
    154. 

  154. 		$is_24_hours_support1 = $is_24_hours_support;
    155. 

  155. 	}
    156. 

  156. 		mysql_query("set character_set_server='utf8'");
    157. 

  157. 		mysql_query("set names 'utf8'");
    158. 

  158. 		$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')";
    159. 

  159. 		
    160. 

  160. 		$result=mysql_query($sql);
    161. 

  161. 		return $result;
    162. 

  162. 	}
    163. 

  163. 	
    164. 

  164. 	public function check_patient_mobile_details($mobile)
    165. 

  165. 	{
    166. 

  166. 	 //    mysql_query("set names 'utf8'");
    167. 

  167. 		// $sql = "SELECT * FROM  `patient` WHERE mobile_no = '".$mobile."'";	
    168. 

  168. 		// //echo $sql;
    169. 

  169. 		// $result=mysql_query($sql);
    170. 

  170. 		// return $result;
    171. 

  171. 

  172. 		$newPost = $this->conn->getReference('patient')
    173. 

  173.            			->orderByChild('mobile_no')
    174. 

  174.    					->equalTo($mobile);
    175. 

  175. 		$snapshot = $newPost->getSnapshot();
    176. 

  176. 		$k1 = $snapshot->getValue();
    177. 

  177. 		return $k1;
    178. 

  178. 	}
    179. 

  179. 	public function insert_quick_registration($mobile_no,$password,$latitude,$logitude,$tokenID)
    180. 

  180. 	
    181. 

  181. 	{    
    182. 

  182. 		// mysql_query("set character_set_server='utf8'");
    183. 

  183. 		// mysql_query("set names 'utf8'");
    184. 

  184. 		// $sql = "INSERT INTO `patient` (`mobile_no`, `password`, `type`, `lat`, `log`, `token`) VALUES ('$mobile_no', '$password', 'P', '$latitude', '$logitude','$tokenID')";	
    185. 

  185. 		// //echo $sql;
    186. 

  186. 		// $result=mysql_query($sql);
    187. 

  187. 		// return $result;
    188. 

  188. 

  189. 		$postData = [
    190. 

  190. 				'address' => "",
    191. 

  191. 				'age' => "",
    192. 

  192. 				 'call_status' => "",
    193. 

  193. 				 'case_desc' => "",
    194. 

  194. 				 'patient_name' => "",
    195. 

  195. 				 'profile_pic' => "",
    196. 

  196. 				 'took' => "",
    197. 

  197. 				 'email_id' => "null",
    198. 

  198. 				 'age' => "",
    199. 

  199.                 'status' =>"",
    200. 

  200.                 'password' => $password,
    201. 

  201.                 'type' => 'P',
    202. 

  202.                 'lat' => $latitude,
    203. 

  203.                 'log' => $logitude,
    204. 

  204.                 'token' => $tokenID,
    205. 

  205.                 'patient_id' => "",
    206. 

  206.                 'mobile_no' => $mobile_no
    207. 

  207.                ];
    208. 

  208. 		$postRef = $this->conn->getReference('patient')->push($postData);
    209. 

  209. 		return $postRef;
    210. 

  210. 

  211. 	}
    212. 

  212. 	public function get_doctor_details($doctorName,$emailID)
    213. 

  213. 

  214. 	{    
    215. 

  215. 		mysql_query("set character_set_server='utf8'");
    216. 

  216. 		mysql_query("set names 'utf8'");
    217. 

  217. 		$sql = "select * from doctor_signup where doctor_name = '$doctorName' and email_id = '$emailID'";
    218. 

  218. 		$result=mysql_query($sql);
    219. 

  219. 		return $result;
    220. 

  220. 	}
    221. 

  221. 	public function get_patient_notification_id($patientID,$doctorID,$date,$tokenID)
    222. 

  222. 

  223. 	{    
    224. 

  224. 		mysql_query("set character_set_server='utf8'");
    225. 

  225. 		mysql_query("set names 'utf8'");
    226. 

  226. 		$sql = "select * from push_notification where doctor_id = '$doctorID' and patient_id = '$patientID' AND date = '$date' AND token = '$tokenID'";
    227. 

  227. 		$result=mysql_query($sql);
    228. 

  228. 		return $result;
    229. 

  229. 	}
    230. 

  230. 	public function update_patient_lat_log_api($doctorID,$lat,$log)
    231. 

  231. 	{    
    232. 

  232. 		mysql_query("set character_set_server='utf8'");
    233. 

  233. 		mysql_query("set names 'utf8'");
    234. 

  234. 		$sql = "UPDATE doctor_signup SET lat = '$lat', log = '$log' WHERE doctor_id='$doctorID'";
    235. 

  235. 		$result=mysql_query($sql);
    236. 

  236. 		return $result;
    237. 

  237. 	}
    238. 

  238. 	public function get_detail_doctor($toID)
    239. 

  239. 

  240. 	{    
    241. 

  241. 		mysql_query("set character_set_server='utf8'");
    242. 

  242. 		mysql_query("set names 'utf8'");
    243. 

  243. 		$sql = "select * from doctor_signup where doctor_id = '$toID'";
    244. 

  244. 		$result=mysql_query($sql);
    245. 

  245. 		return $result;
    246. 

  246. 	}
    247. 

  247. 	public function check_union_id($unionID)
    248. 

  248. 	{    
    249. 

  249. 		mysql_query("set character_set_server='utf8'");
    250. 

  250. 		mysql_query("set names 'utf8'");
    251. 

  251. 		$sql = "select * from doctor_signup where union_id = '$unionID'";
    252. 

  252. 		$result=mysql_query($sql);
    253. 

  253. 		return $result;
    254. 

  254. 	}
    255. 

  255. 	public function check_patient_notification($patientID,$doctorID,$status)
    256. 

  256. 

  257. 	{    
    258. 

  258. 		mysql_query("set character_set_server='utf8'");
    259. 

  259. 		mysql_query("set names 'utf8'");
    260. 

  260. 		$sql = "select * from push_notification_details where doctor_id = '$patientID' and patient_id = '$doctorID' and status = '$status'";
    261. 

  261. 		$result=mysql_query($sql);
    262. 

  262. 		return $result;
    263. 

  263. 	}
    264. 

  264. 	public function get_all_patient_details_app($doctorID)	
    265. 

  265. 	{    
    266. 

  266. 		mysql_query("set character_set_server='utf8'");
    267. 

  267. 		mysql_query("set names 'utf8'");
    268. 

  268. 		$sql = "SELECT p.* FROM `patient` as p,push_notification_details as ps WHERE ps.doctor_id = '$doctorID'";
    269. 

  269. 		$result=mysql_query($sql);
    270. 

  270. 		return $result;
    271. 

  271. 	}
    272. 

  272. 		
    273. 

  273. 	public function get_patients_notification_details($patientID,$typeID)
    274. 

  274. 

  275. 	{    
    276. 

  276. 		mysql_query("set character_set_server='utf8'");
    277. 

  277. 		mysql_query("set names 'utf8'");
    278. 

  278. 		$sql = "SELECT p.*, pn.status,pn.date,pn.message,pn.id
    279. 

  279. 			FROM push_notification AS pn, patient AS p
    280. 

  280. 			WHERE pn.doctor_id =  '$patientID'
    281. 

  281. 			AND pn.type !=  '$typeID'
    282. 

  282. 			AND pn.patient_id = p.patient_id ORDER BY pn.id DESC";
    283. 

  283. 		$result=mysql_query($sql);
    284. 

  284. 		return $result;
    285. 

  285. 	}
    286. 

  286. 	
    287. 

  287. 	public function get_doctor_notification_details($patientID,$typeID)
    288. 

  288. 

  289. 	{    
    290. 

  290. 		mysql_query("set character_set_server='utf8'");
    291. 

  291. 		mysql_query("set names 'utf8'");
    292. 

  292. 		$sql = "SELECT pn.status,pn.date,pn.message,pn.id , d . * 
    293. 

  293. 				FROM  `push_notification` AS pn,  `doctor_signup` AS d
    294. 

  294. 				WHERE pn.patient_id =  '$patientID'
    295. 

  295. 				AND pn.type !=  '$typeID'
    296. 

  296. 				AND d.doctor_id = pn.doctor_id ORDER BY pn.id DESC";
    297. 

  297. 		$result=mysql_query($sql);
    298. 

  298. 		return $result;
    299. 

  299. 	}
    300. 

  300. 	/*-----------------------------------------NOTIFICATION---------------------------------------------------*/
    301. 

  301. 	public function insert_token($tokenID)
    302. 

  302. 	{    
    303. 

  303. 		mysql_query("set character_set_server='utf8'");
    304. 

  304. 		mysql_query("set names 'utf8'");
    305. 

  305. 		$sql = "INSERT INTO `push_notification`(`token`) VALUES ('$tokenID')";
    306. 

  306. 		$result=mysql_query($sql);
    307. 

  307. 		return $result;
    308. 

  308. 	}
    309. 

  309. 	public function gettokendetails($tokenID)
    310. 

  310. 	{    
    311. 

  311. 		mysql_query("set character_set_server='utf8'");
    312. 

  312. 		mysql_query("set names 'utf8'");
    313. 

  313. 		$sql = "select * from push_notification where token = '$tokenID'";
    314. 

  314. 		$result=mysql_query($sql);
    315. 

  315. 		return $result;
    316. 

  316. 	}
    317. 

  317. 	public function get_patient_name($patientID)
    318. 

  318. 	{    
    319. 

  319. 		mysql_query("set character_set_server='utf8'");
    320. 

  320. 		mysql_query("set names 'utf8'");
    321. 

  321. 		$sql = "select * from patient where patient_id = '$patientID'";
    322. 

  322. 		$result=mysql_query($sql);
    323. 

  323. 		return $result;
    324. 

  324. 	}
    325. 

  325. 	public function get_patient_name_det($patientID)
    326. 

  326. 	{    
    327. 

  327. 		mysql_query("set character_set_server='utf8'");
    328. 

  328. 		mysql_query("set names 'utf8'");
    329. 

  329. 		$sql = "select patient_id as id,patient_name as name,profile_pic,type from patient where patient_id = '$patientID'";
    330. 

  330. 		$result=mysql_query($sql);
    331. 

  331. 		return $result;
    332. 

  332. 	}
    333. 

  333. 	
    334. 

  334. 	/*--------------------------------------------------------------------------------------------------------*/
    335. 

  335. 	
    336. 

  336. 	public function update_doctor_profile_details($doctorID,$doctorName,$emailID,$address,$mobileNO,$file_url)
    337. 

  337. 	{    
    338. 

  338. 		mysql_query("set character_set_server='utf8'");
    339. 

  339. 		mysql_query("set names 'utf8'");
    340. 

  340. 		$sql = "UPDATE `doctor_signup` SET `doctor_name`='$doctorName',`address`='$address',`mobile_no`='$mobileNO',email_id = '$emailID',`profile_pic`='$file_url' WHERE `doctor_id`='$doctorID'";
    341. 

  341. 		
    342. 

  342. 		$result=mysql_query($sql);
    343. 

  343. 		return $result;
    344. 

  344. 	}
    345. 

  345. 	public function update_patient_profile_details($patientID,$patientName,$emailID,$mobileNO,$addressID,$file_url)
    346. 

  346. 	{    
    347. 

  347. 		mysql_query("set character_set_server='utf8'");
    348. 

  348. 		mysql_query("set names 'utf8'");
    349. 

  349. 		$sql = "UPDATE `patient` SET `patient_name`='$patientName',`profile_pic`='$file_url',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE patient_id = '$patientID'";
    350. 

  350. 		
    351. 

  351. 		$result=mysql_query($sql);
    352. 

  352. 		return $result;
    353. 

  353. 	}
    354. 

  354. 	public function update_patient_profile($patientID,$patientName,$emailID,$mobileNO,$addressID,$array_full)
    355. 

  355. 	{    
    356. 

  356. 		mysql_query("set character_set_server='utf8'");
    357. 

  357. 		mysql_query("set names 'utf8'");
    358. 

  358. 		
    359. 

  359. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    360. 

  360. 		
    361. 

  361. 		$sql = "UPDATE `patient` SET `patient_name`='$patientName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID',`profile_pic`='$array_full1' WHERE patient_id = '$patientID'";
    362. 

  362. 		
    363. 

  363. 		$result=mysql_query($sql);
    364. 

  364. 		return $result;
    365. 

  365. 	}
    366. 

  366. 	public function update_pharmacyd_profile($patientID,$patientName,$emailID,$mobileNO,$addressID,$array_full,$lat,$log)
    367. 

  367. 	{    
    368. 

  368. 	
    369. 

  369. 			if($is_24_hours_support == ""){
    370. 

  370. 				
    371. 

  371. 				$is_24_hours_support1 = "false";
    372. 

  372. 			}else{
    373. 

  373. 				
    374. 

  374. 				$is_24_hours_support1 = $is_24_hours_support;
    375. 

  375. 			}
    376. 

  376. 		mysql_query("set character_set_server='utf8'");
    377. 

  377. 		mysql_query("set names 'utf8'");
    378. 

  378. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    379. 

  379. 		
    380. 

  380. 		$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'";
    381. 

  381. 		
    382. 

  382. 		$result=mysql_query($sql);
    383. 

  383. 		return $result;
    384. 

  384. 	}
    385. 

  385. 	public function update_phar_profile($patientID,$patientName,$emailID,$mobileNO,$addressID)
    386. 

  386. 	{    
    387. 

  387. 		mysql_query("set character_set_server='utf8'");
    388. 

  388. 		mysql_query("set names 'utf8'");
    389. 

  389. 		$sql = "UPDATE `pharmacy` SET `pharmacy_name`='$patientName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE pharmacy_id = '$patientID'";
    390. 

  390. 		
    391. 

  391. 		$result=mysql_query($sql);
    392. 

  392. 		return $result;
    393. 

  393. 	}
    394. 

  394. 	public function update_pharmacy_profile($pharmacyID,$pharmacyName,$emailID,$mobileNO,$addressID)
    395. 

  395. 	{    
    396. 

  396. 		mysql_query("set character_set_server='utf8'");
    397. 

  397. 		mysql_query("set names 'utf8'");
    398. 

  398. 		$sql = "UPDATE `pharmacy` SET `pharmacy_name`='$pharmacyName',`email_id`='$emailID',`mobile_no`='$mobileNO',`address`='$addressID' WHERE pharmacy_id = '$pharmacyID'" or die(mysql_error());
    399. 

  399. 		$result=mysql_query($sql);
    400. 

  400. 		return $result;
    401. 

  401. 	}
    402. 

  402. 	public function update_doctor_profile($doctorID,$doctorName,$emailID,$feeID,$address,$mobileNO,$array_full)
    403. 

  403. 

  404. 	{    
    405. 

  405. 		mysql_query("set character_set_server='utf8'");
    406. 

  406. 		mysql_query("set names 'utf8'");
    407. 

  407. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    408. 

  408. 		$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'";
    409. 

  409. 		$result=mysql_query($sql);
    410. 

  410. 		return $result;
    411. 

  411. 	}
    412. 

  412. 	public function updatedoctortoken($emailID,$password,$token,$latitude,$logitude,$refID)
    413. 

  413. 	{    
    414. 

  414. 		// mysql_query("set character_set_server='utf8'");
    415. 

  415. 		// mysql_query("set names 'utf8'"); 
    416. 

  416. 		// $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'";
    417. 

  417. 		// $result=mysql_query($sql);
    418. 

  418. 		// return $result;
    419. 

  419. 	$newPost = $this->conn->getReference('doctor_signup')
    420. 

  420.            			->orderByChild('email_id')
    421. 

  421.    					->equalTo($emailID);
    422. 

  422. 

  423.    	$mobileCheck =  $this->conn->getReference('doctor_signup')
    424. 

  424.            			->orderByChild('mobile_no')
    425. 

  425.    					->equalTo($emailID);
    426. 

  426. 

  427. 		$snapshot_email = $newPost->getSnapshot();
    428. 

  428. 		$refID_email = $snapshot_email->getValue();
    429. 

  429. 

  430. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    431. 

  431. 		$refID_mobile = $snapshot_mobile->getValue();
    432. 

  432. 

  433. 			
    434. 

  434. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    435. 

  435. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    436. 

  436. 			$refUpdateKey =  empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0]; 
    437. 

  437. 			$resetArray =  array_values($refIDKey);
    438. 

  438. 

  439.    			if($resetArray[0]['password'] == $password){
    440. 

  440.    				if(isset($refUpdateKey)) {
    441. 

  441.    	 $updates = [
    442. 

  442.     //'doctor_signup/'.$newPostKey => $postData
    443. 

  443.      'doctor_signup/'.$refUpdateKey.'/device_id' => $token,
    444. 

  444.      'doctor_signup/'.$refUpdateKey.'/lat' => $latitude,
    445. 

  445.      'doctor_signup/'.$refUpdateKey.'/log' => $logitude,
    446. 

  446.      'doctor_signup/'.$refUpdateKey.'/status' => '1',
    447. 

  447. 

  448. 	];
    449. 

  449. 

  450. 	$res = $this->conn->getReference() // this is the root reference
    451. 

  451.    ->update($updates);	
    452. 

  452. }
    453. 

  453. else{
    454. 

  454. 	die("update key not found");
    455. 

  455. }
    456. 

  456.    	}
    457. 

  457.    			else{
    458. 

  458.    				die("password validation failed");
    459. 

  459.    		}
    460. 

  460.    	}
    461. 

  461.    		else{
    462. 

  462.    			die("no match");
    463. 

  463.    		}
    464. 

  464. 

  465.    	return true;
    466. 

  466. 

  467. 	}
    468. 

  468. 	public function updatepatienttoken($emailID,$password,$token,$latitude,$logitude)
    469. 

  469. 	{    
    470. 

  470. 		// mysql_query("set character_set_server='utf8'");
    471. 

  471. 		// mysql_query("set names 'utf8'"); 
    472. 

  472. 		// $sql = "UPDATE `patient` SET `token`='$token', lat = '$latitude', log = '$logitude', status = '1' WHERE (`email_id` = '$emailID' OR `mobile_no` = '$emailID') and `password` = '$password'";
    473. 

  473. 		// $result=mysql_query($sql);
    474. 

  474. 		// return $result;
    475. 

  475. 

  476. 		$newPost = $this->conn->getReference('patient')
    477. 

  477.            			->orderByChild('email_id')
    478. 

  478.    					->equalTo($emailID);
    479. 

  479. 

  480.    	   $mobileCheck =  $this->conn->getReference('patient')
    481. 

  481.            			->orderByChild('mobile_no')
    482. 

  482.    					->equalTo($emailID);
    483. 

  483. 

  484. 		$snapshot_email = $newPost->getSnapshot();
    485. 

  485. 		$refID_email = $snapshot_email->getValue();
    486. 

  486. 

  487. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    488. 

  488. 		$refID_mobile = $snapshot_mobile->getValue();
    489. 

  489. 

  490. 			
    491. 

  491. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    492. 

  492. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    493. 

  493. 			$refUpdateKey =  empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0]; 
    494. 

  494. 			$resetArray =  array_values($refIDKey);
    495. 

  495. 

  496.    			if($resetArray[0]['password'] == $password){
    497. 

  497.    	if(isset($refUpdateKey)){
    498. 

  498.    	 $updates = [
    499. 

  499.     //'doctor_signup/'.$newPostKey => $postData
    500. 

  500.      'patient/'.$refUpdateKey.'/token' => $token,
    501. 

  501.      'patient/'.$refUpdateKey.'/lat' => $latitude,
    502. 

  502.      'patient/'.$refUpdateKey.'/log' => $logitude,
    503. 

  503.      'patient/'.$refUpdateKey.'/status' => '1'
    504. 

  504. 

  505. 	];
    506. 

  506. 

  507. 	$res = $this->conn->getReference() // this is the root reference
    508. 

  508.    ->update($updates);	
    509. 

  509. }
    510. 

  510. else{
    511. 

  511. 	die("update key not found : updatepatienttoken ");
    512. 

  512. }
    513. 

  513.    	}
    514. 

  514.    			else{
    515. 

  515.    				die("password validation failed");
    516. 

  516.    		}
    517. 

  517.    	}
    518. 

  518.    		else{
    519. 

  519.    			die("no match");
    520. 

  520.    		}
    521. 

  521. 

  522.    	return true;
    523. 

  523. 	}	
    524. 

  524. 	public function updatepharmacytoken($emailID,$password,$token,$latitude,$logitude)
    525. 

  525. 	{    
    526. 

  526. 		// mysql_query("set character_set_server='utf8'");
    527. 

  527. 		// mysql_query("set names 'utf8'"); 
    528. 

  528. 		// $sql = "UPDATE `pharmacy` SET `token`='$token', status = '1' WHERE (`email_id` = '$emailID' OR `mobile_no` = '$emailID') and `password` = '$password'";
    529. 

  529. 		// $result=mysql_query($sql);
    530. 

  530. 		// return $result;
    531. 

  531. 		$newPost = $this->conn->getReference('pharmacy')
    532. 

  532.            			->orderByChild('email_id')
    533. 

  533.    					->equalTo($emailID);
    534. 

  534. 

  535.    	   $mobileCheck =  $this->conn->getReference('pharmacy')
    536. 

  536.            			->orderByChild('mobile_no')
    537. 

  537.    					->equalTo($emailID);
    538. 

  538. 

  539. 		$snapshot_email = $newPost->getSnapshot();
    540. 

  540. 		$refID_email = $snapshot_email->getValue();
    541. 

  541. 

  542. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    543. 

  543. 		$refID_mobile = $snapshot_mobile->getValue();
    544. 

  544. 

  545. 			
    546. 

  546. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    547. 

  547. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    548. 

  548. 			$refUpdateKey =  empty($refID_email) ? array_keys($refID_mobile)[0] : array_keys($refID_email)[0]; 
    549. 

  549. 			$resetArray =  array_values($refIDKey);
    550. 

  550. 

  551.    			if($resetArray[0]['password'] == $password){
    552. 

  552.    	if(isset($refUpdateKey)) {
    553. 

  553.    	 $updates = [
    554. 

  554.     //'doctor_signup/'.$newPostKey => $postData
    555. 

  555.      'pharmacy/'.$refUpdateKey.'/token' => $token,
    556. 

  556.      'pharmacy/'.$refUpdateKey.'/lat' => $latitude,
    557. 

  557.      'pharmacy/'.$refUpdateKey.'/log' => $logitude,
    558. 

  558.      'pharmacy/'.$refUpdateKey.'/status' => '1'
    559. 

  559. 

  560. 	];
    561. 

  561. 

  562. 	$res = $this->conn->getReference() // this is the root reference
    563. 

  563.    ->update($updates);	
    564. 

  564. }
    565. 

  565. else{
    566. 

  566. 	die("update key not found");
    567. 

  567. }
    568. 

  568.    	}
    569. 

  569.    			else{
    570. 

  570.    				die("password validation failed");
    571. 

  571.    		}
    572. 

  572.    	}
    573. 

  573.    		else{
    574. 

  574.    			die("no match");
    575. 

  575.    		}
    576. 

  576. 

  577.    	return true;
    578. 

  578. 

  579. 

  580. 

  581. 

  582. 	}
    583. 

  583. 	public function getalldoctordetails()
    584. 

  584. 

  585. 	{    
    586. 

  586. 		mysql_query("set character_set_server='utf8'");
    587. 

  587. 		mysql_query("set names 'utf8'");
    588. 

  588. 		$sql = "select * from doctor_signup";
    589. 

  589. 		$result=mysql_query($sql);
    590. 

  590. 		return $result;
    591. 

  591. 	}
    592. 

  592. 	public function get_patient_profile_details($patientID)
    593. 

  593. 

  594. 	{    
    595. 

  595. 		mysql_query("set character_set_server='utf8'");
    596. 

  596. 		mysql_query("set names 'utf8'");
    597. 

  597. 		$sql = "select * from patient where patient_id = '$patientID'";
    598. 

  598. 		
    599. 

  599. 

  600. 		$result=mysql_query($sql);
    601. 

  601. 		return $result;
    602. 

  602. 	}
    603. 

  603. 	public function get_pharmacy_profile_details($pharmacyID)
    604. 

  604. 

  605. 	{    
    606. 

  606. 		mysql_query("set character_set_server='utf8'");
    607. 

  607. 		mysql_query("set names 'utf8'");
    608. 

  608. 		$sql = "select * from pharmacy where pharmacy_id = '$pharmacyID'";
    609. 

  609. 		
    610. 

  610. 

  611. 		$result=mysql_query($sql);
    612. 

  612. 		return $result;
    613. 

  613. 	}
    614. 

  614. 	public function getalldoctor_details()
    615. 

  615. 

  616. 	{    
    617. 

  617. 		mysql_query("set character_set_server='utf8'");
    618. 

  618. 		mysql_query("set names 'utf8'");
    619. 

  619. 		$sql = "select device_id from doctor_signup";
    620. 

  620. 		$result=mysql_query($sql);
    621. 

  621. 		return $result;
    622. 

  622. 	}
    623. 

  623. 	
    624. 

  624. 	public function checknotificationdetails($patientID,$doctorID)
    625. 

  625. 

  626. 	{    
    627. 

  627. 		mysql_query("set character_set_server='utf8'");
    628. 

  628. 		mysql_query("set names 'utf8'");
    629. 

  629. 		$sql = "select * from push_notification where patient_id = '$patientID' and doctor_id = '$doctorID'";
    630. 

  630. 		$result=mysql_query($sql);
    631. 

  631. 		return $result;
    632. 

  632. 	}
    633. 

  633. 	public function get_doctor_profile_details($doctorID)
    634. 

  634. 

  635. 	{    
    636. 

  636. 		mysql_query("set character_set_server='utf8'");
    637. 

  637. 		mysql_query("set names 'utf8'");
    638. 

  638. 		$sql = "select * from doctor_signup where doctor_id = '$doctorID'";
    639. 

  639. 		$result=mysql_query($sql);
    640. 

  640. 		//$result3 = mysql_fetch_array($sql);
    641. 

  641. //		$image_old = $result3['profile_pic'];
    642. 

  642. 		return $result;
    643. 

  643. 	}
    644. 

  644. 	
    645. 

  645. 	public function patientdetail($emailID,$phoneNo,$patientName)
    646. 

  646. 	{    
    647. 

  647. 		mysql_query("set character_set_server='utf8'");
    648. 

  648. 		mysql_query("set names 'utf8'");
    649. 

  649. 		//$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'";
    650. 

  650. 		$sql = "select * from patient where patient_name = '$patientName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
    651. 

  651. 		$result=mysql_query($sql);
    652. 

  652. 		return $result;
    653. 

  653. 	}
    654. 

  654. 	public function get_pharmacy_detail($emailID,$phoneNo,$pharmacyName)
    655. 

  655. 	{    
    656. 

  656. 		mysql_query("set character_set_server='utf8'");
    657. 

  657. 		mysql_query("set names 'utf8'");
    658. 

  658. 		//$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'";
    659. 

  659. 		$sql = "select * from pharmacy where pharmacy_name = '$pharmacyName' and email_id = '$emailID' and mobile_no = '$phoneNo'";
    660. 

  660. 		$result=mysql_query($sql);
    661. 

  661. 		return $result;
    662. 

  662. 	}
    663. 

  663. 	public function getdoctordetaildetails($emailID,$password)
    664. 

  664. 

  665. 	{    
    666. 

  666. 		// mysql_query("set character_set_server='utf8'");
    667. 

  667. 		// mysql_query("set names 'utf8'");
    668. 

  668. 		// $sql = "select * from doctor_signup where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
    669. 

  669. 		// $result=mysql_query($sql);
    670. 

  670. 		// return $result;
    671. 

  671. 

  672. 		$newPost = $this->conn->getReference('doctor_signup')
    673. 

  673.            			->orderByChild('email_id')
    674. 

  674.    					->equalTo($emailID);
    675. 

  675. 

  676.    	$mobileCheck =  $this->conn->getReference('doctor_signup')
    677. 

  677.            			->orderByChild('mobile_no')
    678. 

  678.    					->equalTo($emailID);
    679. 

  679. 

  680. 		$snapshot_email = $newPost->getSnapshot();
    681. 

  681. 		$refID_email = $snapshot_email->getValue();
    682. 

  682. 

  683. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    684. 

  684. 		$refID_mobile = $snapshot_mobile->getValue();
    685. 

  685. 

  686. 			
    687. 

  687. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    688. 

  688. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    689. 

  689. 			$resetArray =  array_values($refIDKey);
    690. 

  690. 

  691.    			if($resetArray[0]['password'] == $password){
    692. 

  692. 

  693.    				return $refIDKey;
    694. 

  694.    		
    695. 

  695.    			}
    696. 

  696.    			else{
    697. 

  697.    				die("password validation failed : getdoctordetaildetails");
    698. 

  698.    			}
    699. 

  699.    		}
    700. 

  700.    		else{
    701. 

  701.    			die("no match: getdoctordetaildetails");
    702. 

  702.    		}
    703. 

  703. 

  704. 

  705. }
    706. 

  706. 	public function getquickregistrationdetail($mobile_no,$password)
    707. 

  707. 

  708. 	{    
    709. 

  709. 		// mysql_query("set character_set_server='utf8'");
    710. 

  710. 		// mysql_query("set names 'utf8'");
    711. 

  711. 		// $sql = "select * from patient where mobile_no = '$mobile_no' and password = '$password'";
    712. 

  712. 		// $result=mysql_query($sql);
    713. 

  713. 		// return $result;
    714. 

  714. 

  715.    	$mobileCheck =  $this->conn->getReference('patient')
    716. 

  716.            			->orderByChild('mobile_no')
    717. 

  717.    					->equalTo($mobile_no);
    718. 

  718. 

  719. 

  720. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    721. 

  721. 		$refID_mobile = $snapshot_mobile->getValue();
    722. 

  722. 

  723. 			
    724. 

  724. 		if(count($refID_mobile)==1 ){
    725. 

  725. 			$refIDKey =$refID_mobile; 
    726. 

  726. 			$resetArray =  array_values($refIDKey);
    727. 

  727. 

  728.    			if($resetArray[0]['password'] == $password){
    729. 

  729. 

  730.    				return $refIDKey;
    731. 

  731.    		
    732. 

  732.    			}
    733. 

  733.    			else{
    734. 

  734.    				die("password validation failed : getquickregistrationdetail");
    735. 

  735.    			}
    736. 

  736.    		}
    737. 

  737.    		else{
    738. 

  738.    			die("no match: getquickregistrationdetail");
    739. 

  739.    		}
    740. 

  740. 

  741. 

  742. 

  743. 

  744. 	}
    745. 

  745. 	
    746. 

  746. 	public function getpatient_details($emailID,$password)
    747. 

  747. 

  748. 	{    
    749. 

  749. 		// mysql_query("set character_set_server='utf8'");
    750. 

  750. 		// mysql_query("set names 'utf8'");
    751. 

  751. 		// $sql = "select * from patient where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
    752. 

  752. 		
    753. 

  753. 		// $result=mysql_query($sql);
    754. 

  754. 		
    755. 

  755. 		// return $result;
    756. 

  756. 

  757. 		$newPost = $this->conn->getReference('patient')
    758. 

  758.            			->orderByChild('email_id')
    759. 

  759.    					->equalTo($emailID);
    760. 

  760. 

  761.    	$mobileCheck =  $this->conn->getReference('patient')
    762. 

  762.            			->orderByChild('mobile_no')
    763. 

  763.    					->equalTo($emailID);
    764. 

  764. 

  765. 		$snapshot_email = $newPost->getSnapshot();
    766. 

  766. 		$refID_email = $snapshot_email->getValue();
    767. 

  767. 

  768. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    769. 

  769. 		$refID_mobile = $snapshot_mobile->getValue();
    770. 

  770. 

  771. 			
    772. 

  772. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    773. 

  773. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    774. 

  774. 			$resetArray =  array_values($refIDKey);
    775. 

  775. 

  776.    			if($resetArray[0]['password'] == $password){
    777. 

  777. 

  778.    				return $refIDKey;
    779. 

  779.    		
    780. 

  780.    			}
    781. 

  781.    			else{
    782. 

  782.    				die("password validation failed : getpatient_details");
    783. 

  783.    			}
    784. 

  784.    		}
    785. 

  785.    		else{
    786. 

  786.    			die("no match: getpatient_details");
    787. 

  787.    		}
    788. 

  788. 

  789. 

  790. 

  791. 

  792. 	}
    793. 

  793. 	public function getpharmacy_details($emailID,$password)
    794. 

  794. 

  795. 	{    
    796. 

  796. 		// mysql_query("set character_set_server='utf8'");
    797. 

  797. 		// mysql_query("set names 'utf8'");
    798. 

  798. 		// $sql = "select * from pharmacy where (email_id = '$emailID' OR mobile_no = '$emailID') and password = '$password'";
    799. 

  799. 		
    800. 

  800. 		// $result=mysql_query($sql);
    801. 

  801. 		// return $result;
    802. 

  802. 

  803. 		$newPost = $this->conn->getReference('pharmacy')
    804. 

  804.            			->orderByChild('email_id')
    805. 

  805.    					->equalTo($emailID);
    806. 

  806. 

  807.    	$mobileCheck =  $this->conn->getReference('pharmacy')
    808. 

  808.            			->orderByChild('mobile_no')
    809. 

  809.    					->equalTo($emailID);
    810. 

  810. 

  811. 		$snapshot_email = $newPost->getSnapshot();
    812. 

  812. 		$refID_email = $snapshot_email->getValue();
    813. 

  813. 

  814. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    815. 

  815. 		$refID_mobile = $snapshot_mobile->getValue();
    816. 

  816. 

  817. 			
    818. 

  818. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    819. 

  819. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    820. 

  820. 			$resetArray =  array_values($refIDKey);
    821. 

  821. 

  822.    			if($resetArray[0]['password'] == $password){
    823. 

  823. 

  824.    				return $refIDKey;
    825. 

  825.    		
    826. 

  826.    			}
    827. 

  827.    			else{
    828. 

  828.    				die("password validation failed : getpharmacy_details");
    829. 

  829.    			}
    830. 

  830.    		}
    831. 

  831.    		else{
    832. 

  832.    			die("no match: getpharmacy_details");
    833. 

  833.    		}
    834. 

  834. 

  835. 	}
    836. 

  836. 	public function get_patient_details($doctorID)
    837. 

  837. 	{    
    838. 

  838. 		mysql_query("set character_set_server='utf8'");
    839. 

  839. 		mysql_query("set names 'utf8'");
    840. 

  840. 		$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";
    841. 

  841. 		$result=mysql_query($sql);
    842. 

  842. 		return $result;
    843. 

  843. 	}
    844. 

  844. 	
    845. 

  845. 	public function getMyHistory($doctorID)
    846. 

  846. 	{    
    847. 

  847. 		mysql_query("set character_set_server='utf8'");
    848. 

  848. 		mysql_query("set names 'utf8'");
    849. 

  849. 		$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";
    850. 

  850. 		$result=mysql_query($sql);
    851. 

  851. 		return $result;
    852. 

  852. 	}
    853. 

  853. 	
    854. 

  854. 	public function getpatientdetailsa($patientID)
    855. 

  855. 	{		
    856. 

  856. 		mysql_query("set character_set_server='utf8'");
    857. 

  857. 		mysql_query("set names 'utf8'");
    858. 

  858. 		$sql = "select * from patient where patient_id = '$patientID'";
    859. 

  859. 		$result=mysql_query($sql);
    860. 

  860. 		return $result;
    861. 

  861. 	}
    862. 

  862. 	
    863. 

  863. 	public function check_login_details($email,$password,$type)
    864. 

  864. 	{    
    865. 

  865. 		
    866. 

  866. 

  867. 	$newPost = $this->conn->getReference('healthcare_login')
    868. 

  868.            			->orderByChild('email_id')
    869. 

  869.    					->equalTo($email);
    870. 

  870. 

  871.    	$mobileCheck =  $this->conn->getReference('healthcare_login')
    872. 

  872.            			->orderByChild('mobile_no')
    873. 

  873.    					->equalTo($email);
    874. 

  874. 

  875. 		$snapshot_email = $newPost->getSnapshot();
    876. 

  876. 		$refID_email = $snapshot_email->getValue();
    877. 

  877. 

  878. 		$snapshot_mobile = $mobileCheck->getSnapshot();
    879. 

  879. 		$refID_mobile = $snapshot_mobile->getValue();
    880. 

  880. 

  881. 			
    882. 

  882. 		if(count($refID_email) == 1 || count($refID_mobile)==1 ){
    883. 

  883. 			$refIDKey = empty($refID_email) ? $refID_mobile : $refID_email; 
    884. 

  884. 			$resetArray =  array_values($refIDKey);
    885. 

  885. 

  886.    			if($resetArray[0]['password'] == $password && $resetArray[0]['type'] == $type){
    887. 

  887.   				//login true
    888. 

  888.    				return $refIDKey;
    889. 

  889.    	}
    890. 

  890.    			else{
    891. 

  891.    				return [];
    892. 

  892.    		}
    893. 

  893.    	}
    894. 

  894.    		else{
    895. 

  895.    			return [];
    896. 

  896.    		}
    897. 

  897. 

  898. 

  899. 

  900. 	}
    901. 

  901. 	
    902. 

  902. 	public function checkemaildetails($emailID)
    903. 

  903. 

  904. 	{    
    905. 

  905. 		mysql_query("set character_set_server='utf8'");
    906. 

  906. 		mysql_query("set names 'utf8'");
    907. 

  907. 		$sql = "select * from healthcare_login where email_id = '$emailID'";
    908. 

  908. 		$result=mysql_query($sql);
    909. 

  909. 		return $result;
    910. 

  910. 	}
    911. 

  911. 	public function check_mobile_no_s($mobileNo)
    912. 

  912. 

  913. 	{    
    914. 

  914. 		mysql_query("set character_set_server='utf8'");
    915. 

  915. 		mysql_query("set names 'utf8'");
    916. 

  916. 		$sql = "select * from healthcare_login where mobile_no = '$mobileNo'";
    917. 

  917. 		
    918. 

  918. 		$result=mysql_query($sql);
    919. 

  919. 		return $result;
    920. 

  920. 	}
    921. 

  921. 	
    922. 

  922. 	public function insert_login($dID,$emailID,$mobileNo,$passwordD,$type)
    923. 

  923. 	{    
    924. 

  924. 		mysql_query("set character_set_server='utf8'");
    925. 

  925. 		mysql_query("set names 'utf8'");
    926. 

  926. 		$sql = "INSERT INTO `healthcare_login`(`id`,`email_id`, `mobile_no`, `password`, `type`) VALUES 
    927. 

  927. 		('$dID','$emailID','$mobileNo','$passwordD','D')";
    928. 

    929. 

  929. 		
    930. 

  930. 		$result=mysql_query($sql);
    931. 

  931. 		return $result;
    932. 

  932. 	}
    933. 

  933. 	public function quick_health_registration($mobileNo,$password,$id)
    934. 

  934. 	{    
    935. 

  935. 		// mysql_query("set character_set_server='utf8'");
    936. 

  936. 		// mysql_query("set names 'utf8'");
    937. 

  937. 		// $sql = "INSERT INTO `healthcare_login`(`mobile_no`, `password`, `type`) VALUES ('$mobileNo','$passwordD','P')";
    938. 

  938. 		// $result=mysql_query($sql);
    939. 

  939. 		// return $result;
    940. 

  940. 		$postData = [
    941. 

  941.                 'password' => $password,
    942. 

  942.                 'type' => 'P',
    943. 

  943.                 'mobile_no' => $mobileNo,
    944. 

  944.                 'login_id' => "",
    945. 

  945.                 'id' => $id,
    946. 

  946.                 'email_id' => "null"
    947. 

  947.                ];
    948. 

  948. 		$postRef = $this->conn->getReference('healthcare_login')->push($postData);
    949. 

  949. 		return $postRef;
    950. 

  950. 	}
    951. 

  951. 	
    952. 

  952. 	public function insert_p_login($pID,$emailID,$mobile_no,$passwordD)
    953. 

  953. 	{    
    954. 

  954. 		mysql_query("set character_set_server='utf8'");
    955. 

  955. 		mysql_query("set names 'utf8'");
    956. 

  956. 		$sql = "INSERT INTO `healthcare_login`(`id`,`email_id`,`mobile_no`, `password`, `type`) VALUES ('$pID','$emailID','$mobile_no','$passwordD','P')";
    957. 

  957. 		$result=mysql_query($sql);
    958. 

  958. 		return $result;
    959. 

  959. 	}
    960. 

  960. 	public function insert_pharmacy_login($p_ID,$emailID,$mobile_no,$passwordD)
    961. 

  961. 	{    
    962. 

  962. 		mysql_query("set character_set_server='utf8'");
    963. 

  963. 		mysql_query("set names 'utf8'");
    964. 

  964. 		$sql = "INSERT INTO `healthcare_login`(`id`,`email_id`,`mobile_no`, `password`, `type`) VALUES ('$p_ID','$emailID','$mobile_no','$passwordD','F')";
    965. 

  965. 		
    966. 

  966. 		$result=mysql_query($sql);
    967. 

  967. 		return $result;
    968. 

  968. 	}
    969. 

  969. 	public function update_status_detail($doctorID,$paymentID)
    970. 

  970. 	{    
    971. 

  971. 		mysql_query("set character_set_server='utf8'");
    972. 

  972. 		mysql_query("set names 'utf8'");
    973. 

  973. 		$sql = "UPDATE `doctor_signup` SET `payment_id`= '$paymentID',`status`= 1 WHERE `doctor_id`='$doctorID'";
    974. 

  974. 		$result=mysql_query($sql);
    975. 

  975. 		return $result;
    976. 

  976. 	}
    977. 

  977. 	public function checkemailid($emailID)
    978. 

  978. 

  979. 	{    
    980. 

  980. 		mysql_query("set character_set_server='utf8'");
    981. 

  981. 		mysql_query("set names 'utf8'");
    982. 

  982. 		$sql = "select * from doctor_signup where email_id = '$emailID'";
    983. 

  983. 		
    984. 

  984. 		$result=mysql_query($sql);
    985. 

  985. 		return $result;
    986. 

  986. 	}
    987. 

  987. 	public function check_patient_mobile_no($emailID,$phoneNo)
    988. 

  988. 	{    
    989. 

  989. 		mysql_query("set character_set_server='utf8'");
    990. 

  990. 		mysql_query("set names 'utf8'");
    991. 

  991. 		$sql = "select * from patient where email_id = '$emailID' OR mobile_no = '$phoneNo'";
    992. 

  992. 		
    993. 

  993. 		$result=mysql_query($sql);
    994. 

  994. 		return $result;
    995. 

  995. 	}
    996. 

  996. 	public function check_doctor_ID($doctorID)
    997. 

  997. 

  998. 	{    
    999. 

  999. 		mysql_query("set character_set_server='utf8'");
    1000. 

  1000. 		mysql_query("set names 'utf8'");
    1001. 

  1001. 		$sql = "select * from doctor_signup where doctor_id = '$doctorID'";
    1002. 

  1002. 		
    1003. 

  1003. 		$result=mysql_query($sql);
    1004. 

  1004. 		return $result;
    1005. 

  1005. 	}
    1006. 

  1006. 	/*------------------------------------------Chat-------------------------------------------------*/
    1007. 

  1007. 	public function get_type_details($id)
    1008. 

  1008. 	{    
    1009. 

  1009. 		mysql_query("set character_set_server='utf8'");
    1010. 

  1010. 		mysql_query("set names 'utf8'");
    1011. 

  1011. 		//$sql = "select * from push_notification_details where doctor_id = '$id' and status = '1'";
    1012. 

  1012. 		$sql = "select * from chat_message where from_id = '$id' OR to_id = '$id' and type = 'D' Group By to_id";
    1013. 

  1013. 		$result=mysql_query($sql);
    1014. 

  1014. 		return $result;
    1015. 

  1015. 	}
    1016. 

  1016. 	public function get_last_message_date($fromID,$toID,$type)
    1017. 

  1017. 	{    
    1018. 

  1018. 		mysql_query("set character_set_server='utf8'");
    1019. 

  1019. 		mysql_query("set names 'utf8'");
    1020. 

  1020. 		$sql = "select * from chat_message where to_id = '$toID' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
    1021. 

  1021. 	
    1022. 

  1022. 		$result=mysql_query($sql);
    1023. 

  1023. 		return $result;
    1024. 

  1024. 	}
    1025. 

  1025. 	public function get_farmacy_last_message_date($fromID,$toid,$type)
    1026. 

  1026. 	{    
    1027. 

  1027. 		mysql_query("set character_set_server='utf8'");
    1028. 

  1028. 		mysql_query("set names 'utf8'");
    1029. 

  1029. 		$sql = "select * from chat_message where to_id = '$toid' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
    1030. 

  1030. 		$result=mysql_query($sql);
    1031. 

  1031. 		return $result;
    1032. 

  1032. 	}
    1033. 

  1033. 	public function get_farmacy_p_last_message_date($fromID,$toid,$type)
    1034. 

  1034. 	{    
    1035. 

  1035. 		mysql_query("set character_set_server='utf8'");
    1036. 

  1036. 		mysql_query("set names 'utf8'");
    1037. 

  1037. 		$sql = "select * from chat_message where to_id = '$toid' and from_id = '$fromID' and type = '$type' ORDER BY chatmsg_id DESC LIMIT 1";
    1038. 

  1038. 		
    1039. 

  1039. 		$result=mysql_query($sql);
    1040. 

  1040. 		return $result;
    1041. 

  1041. 	}
    1042. 

  1042. 	public function get_chat_patient_details($id,$type)
    1043. 

  1043. 	{    
    1044. 

  1044. 		mysql_query("set character_set_server='utf8'");
    1045. 

  1045. 		mysql_query("set names 'utf8'");
    1046. 

  1046. 		$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";
    1047. 

  1047. 		$result=mysql_query($sql);
    1048. 

  1048. 		
    1049. 

  1049. 		
    1050. 

  1050. 		$PatToID  = array();
    1051. 

  1051. 		$PatFromID  = array();
    1052. 

  1052. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'D')";
    1053. 

  1053. 		$qryT=mysql_query($sqlT);
    1054. 

  1054. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1055. 

  1055. 			$PatToID[] = $resultT['to_id']; 
    1056. 

  1056. 		}
    1057. 

  1057. 		
    1058. 

  1058. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'P')";
    1059. 

  1059. 		$qryF=mysql_query($sqlF);
    1060. 

  1060. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1061. 

  1061. 			$PatFromID[] = $resultF['from_id']; 
    1062. 

  1062. 		}
    1063. 

  1063. 		$array_merge_patients =  array_merge($PatToID, $PatFromID);
    1064. 

  1064. 		$Newpatients = array_unique($array_merge_patients);
    1065. 

  1065. 		$all_chat_patients = array_values($Newpatients);
    1066. 

  1066. 		
    1067. 

  1067. 		/*echo "<pre>";
    1068. 

  1068. 		print_r($all_chat_patients);
    1069. 

  1069. 		echo "</pre>";*/
    1070. 

  1070. 		return $all_chat_patients;
    1071. 

  1071. 		
    1072. 

  1072. 	}
    1073. 

  1073. 	public function get_chat_pharmacy_details($id,$type)
    1074. 

  1074. 	{    
    1075. 

  1075. 		mysql_query("set character_set_server='utf8'");
    1076. 

  1076. 		mysql_query("set names 'utf8'");
    1077. 

  1077. 		$sql = "select from_id,to_id from chat_message where to_id = '$id' AND (type = 'DF' OR type = 'FD') GROUP BY from_id";
    1078. 

  1078. 		
    1079. 

  1079. 		$result=mysql_query($sql);
    1080. 

  1080. 		
    1081. 

  1081. 		$PhRToID  = array();
    1082. 

  1082. 		$PhRFromID  = array();
    1083. 

  1083. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'DF')";
    1084. 

  1084. 		$qryT=mysql_query($sqlT);
    1085. 

  1085. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1086. 

  1086. 			$PhRToID[] = $resultT['to_id']; 
    1087. 

  1087. 		}
    1088. 

  1088. 		
    1089. 

  1089. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'FD')";
    1090. 

  1090. 		$qryF=mysql_query($sqlF);
    1091. 

  1091. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1092. 

  1092. 			$PhRFromID[] = $resultF['from_id']; 
    1093. 

  1093. 		}
    1094. 

  1094. 		$array_merge_pharmcy =  array_merge($PhRToID, $PhRFromID);
    1095. 

  1095. 		$Newpharmcy = array_unique($array_merge_pharmcy);
    1096. 

  1096. 		$all_chat_pharmcy = array_values($Newpharmcy);
    1097. 

  1097. 		
    1098. 

  1098. 		return $all_chat_pharmcy;
    1099. 

  1099. 		
    1100. 

  1100. 		//return $all_chat_pharmcy;
    1101. 

  1101. 		
    1102. 

  1102. 	}
    1103. 

  1103. 	public function get_chat_pharmacy_patient_details($id,$type)
    1104. 

  1104. 	{    
    1105. 

  1105. 		mysql_query("set character_set_server='utf8'");
    1106. 

  1106. 		mysql_query("set names 'utf8'");
    1107. 

  1107. 		/*$sql = "select from_id,to_id from chat_message where from_id = '$id' AND (type = 'FP' OR type = 'PF') GROUP BY to_id";
    1108. 

  1108. 		
    1109. 

  1109. 		$result=mysql_query($sql);*/
    1110. 

  1110. 		
    1111. 

  1111. 		$PhRToID  = array();
    1112. 

  1112. 		$PhRFromID  = array();
    1113. 

  1113. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'PF')";
    1114. 

  1114. 		$qryT=mysql_query($sqlT);
    1115. 

  1115. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1116. 

  1116. 			$PhRToID[] = $resultT['to_id']; 
    1117. 

  1117. 		}
    1118. 

  1118. 		
    1119. 

  1119. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'FP')";
    1120. 

  1120. 		$qryF=mysql_query($sqlF);
    1121. 

  1121. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1122. 

  1122. 			$PhRFromID[] = $resultF['from_id']; 
    1123. 

  1123. 		}
    1124. 

  1124. 		$array_merge_pharmcy =  array_merge($PhRToID, $PhRFromID);
    1125. 

  1125. 		$Newpharmcy = array_unique($array_merge_pharmcy);
    1126. 

  1126. 		$all_chat_pharmcy = array_values($Newpharmcy);
    1127. 

  1127. 		
    1128. 

  1128. 		
    1129. 

  1129. 		
    1130. 

  1130. 		return $all_chat_pharmcy;
    1131. 

  1131. 		
    1132. 

  1132. 	}
    1133. 

  1133. 	public function get_patient_id_chat($id,$type)
    1134. 

  1134. 	{    
    1135. 

  1135. 		mysql_query("set character_set_server='utf8'");
    1136. 

  1136. 		mysql_query("set names 'utf8'");
    1137. 

  1137. 		/*$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";
    1138. 

  1138. 		$result=mysql_query($sql);*/
    1139. 

  1139. 		
    1140. 

  1140. 		$PatToID  = array();
    1141. 

  1141. 		$PatFromID  = array();
    1142. 

  1142. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'FP')";
    1143. 

  1143. 		$qryT=mysql_query($sqlT);
    1144. 

  1144. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1145. 

  1145. 			$PatToID[] = $resultT['to_id']; 
    1146. 

  1146. 		}
    1147. 

  1147. 		
    1148. 

  1148. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'PF')";
    1149. 

  1149. 		$qryF=mysql_query($sqlF);
    1150. 

  1150. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1151. 

  1151. 			$PatFromID[] = $resultF['from_id']; 
    1152. 

  1152. 		}
    1153. 

  1153. 		$array_merge_patients =  array_merge($PatToID, $PatFromID);
    1154. 

  1154. 		$Newpatients = array_unique($array_merge_patients);
    1155. 

  1155. 		$all_chat_patients = array_values($Newpatients);
    1156. 

  1156. 		
    1157. 

  1157. 		return $all_chat_patients;
    1158. 

  1158. 	}
    1159. 

  1159. 	public function get_doctor_id_chat($id,$type)
    1160. 

  1160. 	{    
    1161. 

  1161. 		mysql_query("set character_set_server='utf8'");
    1162. 

  1162. 		mysql_query("set names 'utf8'");
    1163. 

  1163. 		/*$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";
    1164. 

  1164. 		
    1165. 

  1165. 		$result=mysql_query($sql);*/
    1166. 

  1166. 		
    1167. 

  1167. 		$DcoToID  = array();
    1168. 

  1168. 		$DocFromID  = array();
    1169. 

  1169. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'FD')";
    1170. 

  1170. 		$qryT=mysql_query($sqlT);
    1171. 

  1171. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1172. 

  1172. 			$DcoToID[] = $resultT['to_id']; 
    1173. 

  1173. 		}
    1174. 

  1174. 		
    1175. 

  1175. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'DF')";
    1176. 

  1176. 		$qryF=mysql_query($sqlF);
    1177. 

  1177. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1178. 

  1178. 			$DocFromID[] = $resultF['from_id']; 
    1179. 

  1179. 		}
    1180. 

  1180. 		$array_merge_doctors =  array_merge($DcoToID, $DocFromID);
    1181. 

  1181. 		$Newdoctors= array_unique($array_merge_doctors);
    1182. 

  1182. 		$all_chat_doctors = array_values($Newdoctors);
    1183. 

  1183. 		
    1184. 

  1184. 		return $all_chat_doctors;
    1185. 

  1185. 		
    1186. 

  1186. 	}
    1187. 

  1187. 	public function get_pharmacy_det_id()
    1188. 

  1188. 	{    
    1189. 

  1189. 		mysql_query("set character_set_server='utf8'");
    1190. 

  1190. 		mysql_query("set names 'utf8'");
    1191. 

  1191. 		$sql = "select * from pharmacy";
    1192. 

  1192. 		
    1193. 

  1193. 		$result=mysql_query($sql);
    1194. 

  1194. 		return $result;
    1195. 

  1195. 	}
    1196. 

  1196. 	public function get_chat_doctor_chatlist($id)
    1197. 

  1197. 	{    
    1198. 

  1198. 		mysql_query("set character_set_server='utf8'");
    1199. 

  1199. 		mysql_query("set names 'utf8'");
    1200. 

  1200. 		$sql = "SELECT from_id,to_id 
    1201. 

  1201. 				FROM  `chat_message` 
    1202. 

  1202. 				WHERE (from_id =  '$id'
    1203. 

  1203. 				OR to_id =  '$id') AND type='DD'
    1204. 

  1204. 				GROUP BY (
    1205. 

  1205. 				to_id
    1206. 

  1206. 				AND from_id
    1207. 

  1207. 				)";
    1208. 

  1208. 		
    1209. 

  1209. 		$result=mysql_query($sql);
    1210. 

  1210. 		return $result;
    1211. 

  1211. 	}
    1212. 

  1212. 	public function get_chat_doctor_details($id,$type)
    1213. 

  1213. 	{   
    1214. 

  1214. 		mysql_query("set character_set_server='utf8'");
    1215. 

  1215. 		mysql_query("set names 'utf8'");
    1216. 

  1216. 		/*$sql = "select * from chat_message where from_id = '$id' AND type = '$type' GROUP BY to_id";
    1217. 

  1217. 		$result=mysql_query($sql);*/
    1218. 

  1218. 		
    1219. 

  1219. 		$DocToID  = array();
    1220. 

  1220. 		$DocFromID  = array();
    1221. 

  1221. 		$sqlT = "select DISTINCT to_id from chat_message where (from_id = '$id' AND type = 'P')";
    1222. 

  1222. 		$qryT=mysql_query($sqlT);
    1223. 

  1223. 		while($resultT=mysql_fetch_assoc($qryT)) {
    1224. 

  1224. 			$DocToID[] = $resultT['to_id']; 
    1225. 

  1225. 		}
    1226. 

  1226. 		
    1227. 

  1227. 		$sqlF = "select DISTINCT from_id from chat_message where (to_id = '$id' AND type = 'D')";
    1228. 

  1228. 		$qryF=mysql_query($sqlF);
    1229. 

  1229. 		while($resultF=mysql_fetch_assoc($qryF)) {
    1230. 

  1230. 			$DocFromID[] = $resultF['from_id']; 
    1231. 

  1231. 		}
    1232. 

  1232. 		$array_merge_doctor =  array_merge($DocToID, $DocFromID);
    1233. 

  1233. 		$Newdoctor = array_unique($array_merge_doctor);
    1234. 

  1234. 		$all_chat_doctor = array_values($Newdoctor);
    1235. 

  1235. 		
    1236. 

  1236. 		return $all_chat_doctor;
    1237. 

  1237. 		
    1238. 

  1238. 	}
    1239. 

  1239. 	public function get_doctor_requst_details($id)
    1240. 

  1240. 	{    
    1241. 

  1241. 		mysql_query("set character_set_server='utf8'");
    1242. 

  1242. 		mysql_query("set names 'utf8'");
    1243. 

  1243. 		$sql = "select * from push_notification_details where patient_id = '$id'";
    1244. 

  1244. 		//echo $sql;
    1245. 

  1245. 		//$sql = "select * from chat_message where from_id = '$id' OR to_id = '$id' and type = 'D' GROUP BY from_id OR to_id";
    1246. 

  1246. 		//echo $sql;
    1247. 

  1247. 		$result=mysql_query($sql);
    1248. 

  1248. 		return $result;
    1249. 

  1249. 	}
    1250. 

  1250. 	public function getpatientdetails($pID)
    1251. 

  1251. 	{    
    1252. 

  1252. 		mysql_query("set character_set_server='utf8'");
    1253. 

  1253. 		mysql_query("set names 'utf8'");
    1254. 

  1254. 		$sql = "select patient_id as id,patient_name as name,profile_pic,type from patient where patient_id = '$pID'";
    1255. 

  1255. 		//echo $sql;
    1256. 

  1256. 		//$sql = "select patient_id as id,patient_name as name,profile_pic,type from patient";
    1257. 

  1257. 		$result=mysql_query($sql);
    1258. 

  1258. 		return $result;
    1259. 

  1259. 	}
    1260. 

  1260. 	public function getdoctor_details($pID)
    1261. 

  1261. 	{    
    1262. 

  1262. 		mysql_query("set character_set_server='utf8'");
    1263. 

  1263. 		mysql_query("set names 'utf8'");
    1264. 

  1264. 		$sql = "select doctor_id as id,doctor_name as name,profile_pic,type from doctor_signup where doctor_id = '$pID'";
    1265. 

  1265. 		
    1266. 

  1266. 		$result=mysql_query($sql);
    1267. 

  1267. 		return $result;
    1268. 

  1268. 	}
    1269. 

  1269. 	public function get_doctor_detailrow($doctorID)
    1270. 

  1270. 	{    
    1271. 

  1271. 		mysql_query("set character_set_server='utf8'");
    1272. 

  1272. 		mysql_query("set names 'utf8'");
    1273. 

  1273. 		$sql = "select doctor_id as id,doctor_name as name,profile_pic,type from doctor_signup where doctor_id = '$doctorID'";
    1274. 

  1274. 		
    1275. 

  1275. 		$result=mysql_query($sql);
    1276. 

  1276. 		return $result;
    1277. 

  1277. 	}
    1278. 

  1278. 	public function get_detail_patient($fromID)
    1279. 

  1279. 	{    
    1280. 

  1280. 		mysql_query("set character_set_server='utf8'");
    1281. 

  1281. 		mysql_query("set names 'utf8'");
    1282. 

  1282. 		$sql = "select * from patient where patient_id = '$fromID'";
    1283. 

  1283. 		$result=mysql_query($sql);
    1284. 

  1284. 		return $result;
    1285. 

  1285. 	}
    1286. 

  1286. 	public function getmessaged($id,$pID)
    1287. 

  1287. 	{    
    1288. 

  1288. 		mysql_query("set character_set_server='utf8'");
    1289. 

  1289. 		mysql_query("set names 'utf8'");
    1290. 

  1290. 		//$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";
    1291. 

  1291. 		$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";
    1292. 

  1292. 		//echo $sql;
    1293. 

  1293. 		$result=mysql_query($sql);
    1294. 

  1294. 		return $result;
    1295. 

  1295. 	}
    1296. 

  1296. 	public function getDmessaged($id,$pID)
    1297. 

  1297. 	{    
    1298. 

  1298. 		mysql_query("set character_set_server='utf8'");
    1299. 

  1299. 		mysql_query("set names 'utf8'");
    1300. 

  1300. 		//$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";
    1301. 

  1301. 		$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";
    1302. 

  1302. 	
    1303. 

  1303. 	
    1304. 

  1304. 		$result=mysql_query($sql);
    1305. 

  1305. 		return $result;
    1306. 

  1306. 	}
    1307. 

  1307. 	
    1308. 

  1308. 	public function getpharmacymessaged($id,$fID)
    1309. 

  1309. 	{    
    1310. 

  1310. 		mysql_query("set character_set_server='utf8'");
    1311. 

  1311. 		mysql_query("set names 'utf8'");
    1312. 

  1312. 		//$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";
    1313. 

  1313. 		$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";
    1314. 

  1314. 		
    1315. 

  1315. 		$result=mysql_query($sql);
    1316. 

  1316. 		return $result;
    1317. 

  1317. 	}
    1318. 

  1318. 	
    1319. 

  1319. 	public function getpharmacypatientmessaged($id,$fID)
    1320. 

  1320. 	{    
    1321. 

  1321. 		mysql_query("set character_set_server='utf8'");
    1322. 

  1322. 		mysql_query("set names 'utf8'");		
    1323. 

  1323. 		$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";
    1324. 

  1324. 		
    1325. 

  1325. 		$result=mysql_query($sql);
    1326. 

  1326. 		return $result;
    1327. 

  1327. 	}
    1328. 

  1328. 	
    1329. 

  1329. 	public function getpharmacypatientmessaged1($id,$fID)
    1330. 

  1330. 	{    
    1331. 

  1331. 		mysql_query("set character_set_server='utf8'");
    1332. 

  1332. 		mysql_query("set names 'utf8'");		
    1333. 

  1333. 		$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";
    1334. 

  1334. 		
    1335. 

  1335. 		$result=mysql_query($sql);
    1336. 

  1336. 		return $result;
    1337. 

  1337. 	}
    1338. 

  1338. 	
    1339. 

  1339. 	public function getpharmacydoctormessaged($id,$fID)
    1340. 

  1340. 	{    
    1341. 

  1341. 		mysql_query("set character_set_server='utf8'");
    1342. 

  1342. 		mysql_query("set names 'utf8'");
    1343. 

  1343. 		$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";
    1344. 

  1344. 		
    1345. 

  1345. 		$result=mysql_query($sql);
    1346. 

  1346. 		return $result;
    1347. 

  1347. 	}
    1348. 

  1348. 	public function getpharmacydmessaged($id,$fID)
    1349. 

  1349. 	{    
    1350. 

  1350. 		mysql_query("set character_set_server='utf8'");
    1351. 

  1351. 		mysql_query("set names 'utf8'");
    1352. 

  1352. 		$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";
    1353. 

  1353. 		
    1354. 

  1354. 		$result=mysql_query($sql);
    1355. 

  1355. 		return $result;
    1356. 

  1356. 	}
    1357. 

  1357. 	
    1358. 

  1358. 	
    1359. 

  1359. 	public function insert_message($fromID,$toID,$message,$type,$mtype)
    1360. 

  1360. 	{    
    1361. 

  1361. 		mysql_query("set character_set_server='utf8'");
    1362. 

  1362. 		mysql_query("set names 'utf8'");
    1363. 

  1363. 		
    1364. 

  1364. 		$sql = "INSERT INTO `chat_message`(`from_id`, `to_id`, `message`, `status`, `type`, `message_type`,`read_status`) VALUES ('$fromID','$toID','$message','0','$type','$mtype','0')";
    1365. 

  1365. 		$result=mysql_query($sql);
    1366. 

  1366. 		return $result;
    1367. 

  1367. 	}
    1368. 

  1368. 	public function insert_invite_doctor_chat($doctorID,$member_ID,$messageID)
    1369. 

  1369. 	{    
    1370. 

  1370. 		mysql_query("set character_set_server='utf8'");
    1371. 

  1371. 		mysql_query("set names 'utf8'");
    1372. 

  1372. 		$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')";
    1373. 

  1373. 		$result=mysql_query($sql);
    1374. 

  1374. 		return $result;
    1375. 

  1375. 	}public function insert_case_description($patientID,$doctorID,$caseD,$date,$type,$status, $FirstLat = '', $FirstLan = '')
    1376. 

  1376. 	{    
    1377. 

  1377. 		mysql_query("set character_set_server='utf8'");
    1378. 

  1378. 		mysql_query("set names 'utf8'");
    1379. 

  1379. 		$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')";
    1380. 

  1380. 		$result=mysql_query($sql);
    1381. 

  1381. 		return $result;
    1382. 

  1382. 	}
    1383. 

  1383. 	public function upload_image($fromID,$toID,$file_url,$type,$mtype)
    1384. 

  1384. 	{    
    1385. 

  1385. 		mysql_query("set character_set_server='utf8'");
    1386. 

  1386. 		mysql_query("set names 'utf8'");
    1387. 

  1387. 		$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;
    1388. 

  1388. 		$result=mysql_query($sql);
    1389. 

  1389. 		return $result;
    1390. 

  1390. 	}
    1391. 

  1391. 	public function upload_image_group($fromID,$toID,$file_url,$type,$mtype)
    1392. 

  1392. 	{    
    1393. 

  1393. 		mysql_query("set character_set_server='utf8'");
    1394. 

  1394. 		mysql_query("set names 'utf8'");
    1395. 

  1395. 		$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;
    1396. 

  1396. 		$result=mysql_query($sql);
    1397. 

  1397. 		return $result;
    1398. 

  1398. 	}
    1399. 

  1399. 	public function update_read_message_status($fromID,$toID)
    1400. 

  1400. 	{    
    1401. 

  1401. 		mysql_query("set character_set_server='utf8'");
    1402. 

  1402. 		mysql_query("set names 'utf8'");
    1403. 

  1403. 		$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')";
    1404. 

  1404. 		$result=mysql_query($sql);
    1405. 

  1405. 		return $result;
    1406. 

  1406. 	}
    1407. 

  1407. 	public function update_read_message_from_pharmacy($fromID,$toID)
    1408. 

  1408. 	{    
    1409. 

  1409. 		mysql_q…
    1410.

Large files files are truncated, but you can click here to view the full file