PageRenderTime 54ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/classes/mainclass.php

https://bitbucket.org/devpronitzz/healthcase
PHP | 2216 lines | 1863 code | 242 blank | 111 comment | 42 complexity | 664c424599a08943ccef778430f06cfc 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. 

  12. 

  13. error_reporting(E_ALL ^ E_DEPRECATED);
    14. 

  14. //Create Connection Class
    15. 

  15. class UserClass
    16. 

  16. {
    17. 

  17.    	var $conn;
    18. 

  18. 	//constructor to eastablishment connection with database
    19. 

  19. 	public function __construct()
    20. 

  20. 	{
    21. 

  21. 		$conn= new connection();
    22. 

  22.         return $this->conn;
    23. 

  23.     }
    24. 

  24. 	/*********Query start Following Block 1********/
    25. 

  25. 	
    26. 

  26. 	/*public function imageupload()
    27. 

  27. 	{
    28. 

  28. 		$image_name = $_FILES["fileUpload1"]["name"];	
    29. 

  29. 		$tmp_arr = explode(".",$image_name);
    30. 

  30. 		$img_extn = end($tmp_arr);
    31. 

  31. 		$new_image_name = 'image_'. uniqid() . date('YmdHis').'.'.$img_extn;	
    32. 

  32. 		$flag=0;				 
    33. 

  33. 		if (file_exists("uploads/".$new_image_name))
    34. 

  34. 		{
    35. 

  35. 		   return false;
    36. 

  36. 		}
    37. 

  37. 		else
    38. 

  38. 		{	
    39. 

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

  40. 			$flag = 1;
    41. 

  41. 			$static_url = "http://bytesnmaterials.com/healthcare/uploads/".$new_image_name;
    42. 

  42. 			return $static_url; 
    43. 

  43. 		}
    44. 

  44. 	}*/
    45. 

  45. 	
    46. 

  46. 	
    47. 

  47. 	//$imagePath = 'http://bytesnmaterials.com/healthcare/profile/profile.png';
    48. 

  48. 	
    49. 

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

  50. 	{    
    51. 

  51. 		mysql_query("set character_set_server='utf8'");
    52. 

  52. 		mysql_query("set names 'utf8'");  
    53. 

  53. 		
    54. 

  54. 		
    55. 

  55. 			if(isset($_FILES['imageData']['name'])) 
    56. 

  56. 			{	
    57. 

  57. 			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))){
    58. 

  58. 	
    59. 

  59. 			
    60. 

  60. 	
    61. 

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

  62. 	
    63. 

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

  64. 	
    65. 

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

  66. 	
    67. 

  67. 							$file_url_name = $array[0].time().".".$Ex;
    68. 

  68. 	
    69. 

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

  70. 			
    71. 

  71. 				}	
    72. 

  72. 			}
    73. 

  73. 		}
    74. 

  74. 		$file_url_name1 = "http://bytesnmaterials.com/healthcare/uploads/col_certificate/".$file_url_name;
    75. 

  75. 		$register_image1 = "http://bytesnmaterials.com/healthcare/uploads/register_image/".$register_image;
    76. 

  76. 		
    77. 

  77. 		$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')";
    78. 

  78. 		$result=mysql_query($sql);
    79. 

  79. 		return $result;
    80. 

  80. 		
    81. 

  81. 		
    82. 

  82. 	}
    83. 

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

  84. 	
    85. 

  85. 	{    
    86. 

  86. 		mysql_query("set character_set_server='utf8'");
    87. 

  87. 		mysql_query("set names 'utf8'");
    88. 

  88. 		$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')";
    89. 

  89. 		$result=mysql_query($sql);
    90. 

  90. 		return $result;
    91. 

  91. 	}
    92. 

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

  93. 	{    
    94. 

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

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

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

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

  98. 		//echo $sql;
    99. 

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

  100. 		return $result;
    101. 

  101. 	}
    102. 

  102. 	public function insert_patient_notification($patientID,$doctorID,$message,$date,$status)
    103. 

  103. 	
    104. 

  104. 	{    
    105. 

  105. 		mysql_query("set character_set_server='utf8'");
    106. 

  106. 		mysql_query("set names 'utf8'"); 
    107. 

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

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

  109. 		return $result;
    110. 

  110. 	}
    111. 

  111. 	
    112. 

  112. 	public function update_pushnotification($id,$status)
    113. 

  113. 	
    114. 

  114. 	{    
    115. 

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

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

  117. 		$sql = "UPDATE `push_notification` SET `status`='$status' WHERE `id`='$id'";
    118. 

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

  119. 		return $result;
    120. 

  120. 	}
    121. 

  121. 	
    122. 

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

  123. 	
    124. 

  124. 	{    
    125. 

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

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

  127. 		
    128. 

  128. 		$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')";
    129. 

  129. 		
    130. 

  130. 		$result=mysql_query($sql);
    131. 

  131. 		return $result;
    132. 

  132. 	}
    133. 

  133. 

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

  135. 	
    136. 

  136. 	
    137. 

  137. 	
    138. 

  138. 	{    
    139. 

  139. 	
    140. 

  140. 	if($is_24_hours_support == ""){
    141. 

  141. 		
    142. 

  142. 		$is_24_hours_support1 = "false";
    143. 

  143. 	}else{
    144. 

  144. 		
    145. 

  145. 		$is_24_hours_support1 = $is_24_hours_support;
    146. 

  146. 	}
    147. 

  147. 		mysql_query("set character_set_server='utf8'");
    148. 

  148. 		mysql_query("set names 'utf8'");
    149. 

  149. 		$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')";
    150. 

  150. 		
    151. 

  151. 		$result=mysql_query($sql);
    152. 

  152. 		return $result;
    153. 

  153. 	}
    154. 

  154. 	
    155. 

  155. 	public function check_patient_mobile_details($mobile)
    156. 

  156. 	{
    157. 

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

  158. 		$sql = "SELECT * FROM  `patient` WHERE mobile_no = '".$mobile."'";	
    159. 

  159. 		//echo $sql;
    160. 

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

  161. 		return $result;
    162. 

  162. 	}
    163. 

  163. 	public function insert_quick_registration($mobile_no,$password,$latitude,$logitude,$tokenID)
    164. 

  164. 	
    165. 

  165. 	{    
    166. 

  166. 		mysql_query("set character_set_server='utf8'");
    167. 

  167. 		mysql_query("set names 'utf8'");
    168. 

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

  169. 		//echo $sql;
    170. 

  170. 		$result=mysql_query($sql);
    171. 

  171. 		return $result;
    172. 

  172. 	}
    173. 

  173. 	public function get_doctor_details($doctorName,$emailID)
    174. 

  174. 

  175. 	{    
    176. 

  176. 		mysql_query("set character_set_server='utf8'");
    177. 

  177. 		mysql_query("set names 'utf8'");
    178. 

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

  179. 		$result=mysql_query($sql);
    180. 

  180. 		return $result;
    181. 

  181. 	}
    182. 

  182. 	public function get_patient_notification_id($patientID,$doctorID,$date,$tokenID)
    183. 

  183. 

  184. 	{    
    185. 

  185. 		mysql_query("set character_set_server='utf8'");
    186. 

  186. 		mysql_query("set names 'utf8'");
    187. 

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

  188. 		$result=mysql_query($sql);
    189. 

  189. 		return $result;
    190. 

  190. 	}
    191. 

  191. 	public function update_patient_lat_log_api($doctorID,$lat,$log)
    192. 

  192. 	{    
    193. 

  193. 		mysql_query("set character_set_server='utf8'");
    194. 

  194. 		mysql_query("set names 'utf8'");
    195. 

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

  196. 		$result=mysql_query($sql);
    197. 

  197. 		return $result;
    198. 

  198. 	}
    199. 

  199. 	public function get_detail_doctor($toID)
    200. 

  200. 

  201. 	{    
    202. 

  202. 		mysql_query("set character_set_server='utf8'");
    203. 

  203. 		mysql_query("set names 'utf8'");
    204. 

  204. 		$sql = "select * from doctor_signup where doctor_id = '$toID'";
    205. 

  205. 		$result=mysql_query($sql);
    206. 

  206. 		return $result;
    207. 

  207. 	}
    208. 

  208. 	public function check_union_id($unionID)
    209. 

  209. 	{    
    210. 

  210. 		mysql_query("set character_set_server='utf8'");
    211. 

  211. 		mysql_query("set names 'utf8'");
    212. 

  212. 		$sql = "select * from doctor_signup where union_id = '$unionID'";
    213. 

  213. 		$result=mysql_query($sql);
    214. 

  214. 		return $result;
    215. 

  215. 	}
    216. 

  216. 	public function check_patient_notification($patientID,$doctorID,$status)
    217. 

  217. 

  218. 	{    
    219. 

  219. 		mysql_query("set character_set_server='utf8'");
    220. 

  220. 		mysql_query("set names 'utf8'");
    221. 

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

  222. 		$result=mysql_query($sql);
    223. 

  223. 		return $result;
    224. 

  224. 	}
    225. 

  225. 	public function get_all_patient_details_app($doctorID)	
    226. 

  226. 	{    
    227. 

  227. 		mysql_query("set character_set_server='utf8'");
    228. 

  228. 		mysql_query("set names 'utf8'");
    229. 

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

  230. 		$result=mysql_query($sql);
    231. 

  231. 		return $result;
    232. 

  232. 	}
    233. 

  233. 		
    234. 

  234. 	public function get_patients_notification_details($patientID,$typeID)
    235. 

  235. 

  236. 	{    
    237. 

  237. 		mysql_query("set character_set_server='utf8'");
    238. 

  238. 		mysql_query("set names 'utf8'");
    239. 

  239. 		$sql = "SELECT p.*, pn.status,pn.date,pn.message,pn.id
    240. 

  240. 			FROM push_notification AS pn, patient AS p
    241. 

  241. 			WHERE pn.doctor_id =  '$patientID'
    242. 

  242. 			AND pn.type !=  '$typeID'
    243. 

  243. 			AND pn.patient_id = p.patient_id ORDER BY pn.id DESC";
    244. 

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

  245. 		return $result;
    246. 

  246. 	}
    247. 

  247. 	
    248. 

  248. 	public function get_doctor_notification_details($patientID,$typeID)
    249. 

  249. 

  250. 	{    
    251. 

  251. 		mysql_query("set character_set_server='utf8'");
    252. 

  252. 		mysql_query("set names 'utf8'");
    253. 

  253. 		$sql = "SELECT pn.status,pn.date,pn.message,pn.id , d . * 
    254. 

  254. 				FROM  `push_notification` AS pn,  `doctor_signup` AS d
    255. 

  255. 				WHERE pn.patient_id =  '$patientID'
    256. 

  256. 				AND pn.type !=  '$typeID'
    257. 

  257. 				AND d.doctor_id = pn.doctor_id ORDER BY pn.id DESC";
    258. 

  258. 		$result=mysql_query($sql);
    259. 

  259. 		return $result;
    260. 

  260. 	}
    261. 

  261. 	/*-----------------------------------------NOTIFICATION---------------------------------------------------*/
    262. 

  262. 	public function insert_token($tokenID)
    263. 

  263. 	{    
    264. 

  264. 		mysql_query("set character_set_server='utf8'");
    265. 

  265. 		mysql_query("set names 'utf8'");
    266. 

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

  267. 		$result=mysql_query($sql);
    268. 

  268. 		return $result;
    269. 

  269. 	}
    270. 

  270. 	public function gettokendetails($tokenID)
    271. 

  271. 	{    
    272. 

  272. 		mysql_query("set character_set_server='utf8'");
    273. 

  273. 		mysql_query("set names 'utf8'");
    274. 

  274. 		$sql = "select * from push_notification where token = '$tokenID'";
    275. 

  275. 		$result=mysql_query($sql);
    276. 

  276. 		return $result;
    277. 

  277. 	}
    278. 

  278. 	public function get_patient_name($patientID)
    279. 

  279. 	{    
    280. 

  280. 		mysql_query("set character_set_server='utf8'");
    281. 

  281. 		mysql_query("set names 'utf8'");
    282. 

  282. 		$sql = "select * from patient where patient_id = '$patientID'";
    283. 

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

  284. 		return $result;
    285. 

  285. 	}
    286. 

  286. 	public function get_patient_name_det($patientID)
    287. 

  287. 	{    
    288. 

  288. 		mysql_query("set character_set_server='utf8'");
    289. 

  289. 		mysql_query("set names 'utf8'");
    290. 

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

  291. 		$result=mysql_query($sql);
    292. 

  292. 		return $result;
    293. 

  293. 	}
    294. 

  294. 	
    295. 

  295. 	/*--------------------------------------------------------------------------------------------------------*/
    296. 

  296. 	
    297. 

  297. 	public function update_doctor_profile_details($doctorID,$doctorName,$emailID,$address,$mobileNO,$file_url)
    298. 

  298. 	{    
    299. 

  299. 		mysql_query("set character_set_server='utf8'");
    300. 

  300. 		mysql_query("set names 'utf8'");
    301. 

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

  302. 		
    303. 

  303. 		$result=mysql_query($sql);
    304. 

  304. 		return $result;
    305. 

  305. 	}
    306. 

  306. 	public function update_patient_profile_details($patientID,$patientName,$emailID,$mobileNO,$addressID,$file_url)
    307. 

  307. 	{    
    308. 

  308. 		mysql_query("set character_set_server='utf8'");
    309. 

  309. 		mysql_query("set names 'utf8'");
    310. 

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

  311. 		
    312. 

  312. 		$result=mysql_query($sql);
    313. 

  313. 		return $result;
    314. 

  314. 	}
    315. 

  315. 	public function update_patient_profile($patientID,$patientName,$emailID,$mobileNO,$addressID,$array_full)
    316. 

  316. 	{    
    317. 

  317. 		mysql_query("set character_set_server='utf8'");
    318. 

  318. 		mysql_query("set names 'utf8'");
    319. 

  319. 		
    320. 

  320. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    321. 

  321. 		
    322. 

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

  323. 		
    324. 

  324. 		$result=mysql_query($sql);
    325. 

  325. 		return $result;
    326. 

  326. 	}
    327. 

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

  328. 	{    
    329. 

  329. 	
    330. 

  330. 			if($is_24_hours_support == ""){
    331. 

  331. 				
    332. 

  332. 				$is_24_hours_support1 = "false";
    333. 

  333. 			}else{
    334. 

  334. 				
    335. 

  335. 				$is_24_hours_support1 = $is_24_hours_support;
    336. 

  336. 			}
    337. 

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

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

  339. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    340. 

  340. 		
    341. 

  341. 		$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'";
    342. 

  342. 		
    343. 

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

  344. 		return $result;
    345. 

  345. 	}
    346. 

  346. 	public function update_phar_profile($patientID,$patientName,$emailID,$mobileNO,$addressID)
    347. 

  347. 	{    
    348. 

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

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

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

  351. 		
    352. 

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

  353. 		return $result;
    354. 

  354. 	}
    355. 

  355. 	public function update_pharmacy_profile($pharmacyID,$pharmacyName,$emailID,$mobileNO,$addressID)
    356. 

  356. 	{    
    357. 

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

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

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

  360. 		$result=mysql_query($sql);
    361. 

  361. 		return $result;
    362. 

  362. 	}
    363. 

  363. 	public function update_doctor_profile($doctorID,$doctorName,$emailID,$feeID,$address,$mobileNO,$array_full)
    364. 

  364. 

  365. 	{    
    366. 

  366. 		mysql_query("set character_set_server='utf8'");
    367. 

  367. 		mysql_query("set names 'utf8'");
    368. 

  368. 		$array_full1 = "http://bytesnmaterials.com/healthcare/profile/".$array_full;
    369. 

  369. 		$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'";
    370. 

  370. 		$result=mysql_query($sql);
    371. 

  371. 		return $result;
    372. 

  372. 	}
    373. 

  373. 	public function updatedoctortoken($emailID,$password,$token,$latitude,$logitude)
    374. 

  374. 	{    
    375. 

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

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

  377. 		$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'";
    378. 

  378. 		$result=mysql_query($sql);
    379. 

  379. 		return $result;
    380. 

  380. 	}
    381. 

  381. 	public function updatepatienttoken($emailID,$password,$token,$latitude,$logitude)
    382. 

  382. 	{    
    383. 

  383. 		mysql_query("set character_set_server='utf8'");
    384. 

  384. 		mysql_query("set names 'utf8'"); 
    385. 

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

  386. 		$result=mysql_query($sql);
    387. 

  387. 		return $result;
    388. 

  388. 	}	
    389. 

  389. 	public function updatepharmacytoken($emailID,$password,$token,$latitude,$logitude)
    390. 

  390. 	{    
    391. 

  391. 		mysql_query("set character_set_server='utf8'");
    392. 

  392. 		mysql_query("set names 'utf8'"); 
    393. 

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

  394. 		$result=mysql_query($sql);
    395. 

  395. 		return $result;
    396. 

  396. 	}
    397. 

  397. 	public function getalldoctordetails()
    398. 

  398. 

  399. 	{    
    400. 

  400. 		mysql_query("set character_set_server='utf8'");
    401. 

  401. 		mysql_query("set names 'utf8'");
    402. 

  402. 		$sql = "select * from doctor_signup";
    403. 

  403. 		$result=mysql_query($sql);
    404. 

  404. 		return $result;
    405. 

  405. 	}
    406. 

  406. 	public function get_patient_profile_details($patientID)
    407. 

  407. 

  408. 	{    
    409. 

  409. 		mysql_query("set character_set_server='utf8'");
    410. 

  410. 		mysql_query("set names 'utf8'");
    411. 

  411. 		$sql = "select * from patient where patient_id = '$patientID'";
    412. 

  412. 		
    413. 

  413. 

  414. 		$result=mysql_query($sql);
    415. 

  415. 		return $result;
    416. 

  416. 	}
    417. 

  417. 	public function get_pharmacy_profile_details($pharmacyID)
    418. 

  418. 

  419. 	{    
    420. 

  420. 		mysql_query("set character_set_server='utf8'");
    421. 

  421. 		mysql_query("set names 'utf8'");
    422. 

  422. 		$sql = "select * from pharmacy where pharmacy_id = '$pharmacyID'";
    423. 

  423. 		
    424. 

  424. 

  425. 		$result=mysql_query($sql);
    426. 

  426. 		return $result;
    427. 

  427. 	}
    428. 

  428. 	public function getalldoctor_details()
    429. 

  429. 

  430. 	{    
    431. 

  431. 		mysql_query("set character_set_server='utf8'");
    432. 

  432. 		mysql_query("set names 'utf8'");
    433. 

  433. 		$sql = "select device_id from doctor_signup";
    434. 

  434. 		$result=mysql_query($sql);
    435. 

  435. 		return $result;
    436. 

  436. 	}
    437. 

  437. 	
    438. 

  438. 	public function checknotificationdetails($patientID,$doctorID)
    439. 

  439. 

  440. 	{    
    441. 

  441. 		mysql_query("set character_set_server='utf8'");
    442. 

  442. 		mysql_query("set names 'utf8'");
    443. 

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

  444. 		$result=mysql_query($sql);
    445. 

  445. 		return $result;
    446. 

  446. 	}
    447. 

  447. 	public function get_doctor_profile_details($doctorID)
    448. 

  448. 

  449. 	{    
    450. 

  450. 		mysql_query("set character_set_server='utf8'");
    451. 

  451. 		mysql_query("set names 'utf8'");
    452. 

  452. 		$sql = "select * from doctor_signup where doctor_id = '$doctorID'";
    453. 

  453. 		$result=mysql_query($sql);
    454. 

  454. 		//$result3 = mysql_fetch_array($sql);
    455. 

  455. //		$image_old = $result3['profile_pic'];
    456. 

  456. 		return $result;
    457. 

  457. 	}
    458. 

  458. 	
    459. 

  459. 	public function patientdetail($emailID,$phoneNo,$patientName)
    460. 

  460. 	{    
    461. 

  461. 		mysql_query("set character_set_server='utf8'");
    462. 

  462. 		mysql_query("set names 'utf8'");
    463. 

  463. 		//$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'";
    464. 

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

  465. 		$result=mysql_query($sql);
    466. 

  466. 		return $result;
    467. 

  467. 	}
    468. 

  468. 	public function get_pharmacy_detail($emailID,$phoneNo,$pharmacyName)
    469. 

  469. 	{    
    470. 

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

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

  472. 		//$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'";
    473. 

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

  474. 		$result=mysql_query($sql);
    475. 

  475. 		return $result;
    476. 

  476. 	}
    477. 

  477. 	public function getdoctordetaildetails($emailID,$password)
    478. 

  478. 

  479. 	{    
    480. 

  480. 		mysql_query("set character_set_server='utf8'");
    481. 

  481. 		mysql_query("set names 'utf8'");
    482. 

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

  483. 		$result=mysql_query($sql);
    484. 

  484. 		return $result;
    485. 

  485. 	}
    486. 

  486. 	public function getquickregistrationdetail($mobile_no,$password)
    487. 

  487. 

  488. 	{    
    489. 

  489. 		mysql_query("set character_set_server='utf8'");
    490. 

  490. 		mysql_query("set names 'utf8'");
    491. 

  491. 		$sql = "select * from patient where mobile_no = '$mobile_no' and password = '$password'";
    492. 

  492. 		$result=mysql_query($sql);
    493. 

  493. 		return $result;
    494. 

  494. 	}
    495. 

  495. 	
    496. 

  496. 	public function getpatient_details($emailID,$password)
    497. 

  497. 

  498. 	{    
    499. 

  499. 		mysql_query("set character_set_server='utf8'");
    500. 

  500. 		mysql_query("set names 'utf8'");
    501. 

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

  502. 		
    503. 

  503. 		$result=mysql_query($sql);
    504. 

  504. 		
    505. 

  505. 		return $result;
    506. 

  506. 	}
    507. 

  507. 	public function getpharmacy_details($emailID,$password)
    508. 

  508. 

  509. 	{    
    510. 

  510. 		mysql_query("set character_set_server='utf8'");
    511. 

  511. 		mysql_query("set names 'utf8'");
    512. 

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

  513. 		
    514. 

  514. 		$result=mysql_query($sql);
    515. 

  515. 		return $result;
    516. 

  516. 	}
    517. 

  517. 	public function get_patient_details($doctorID)
    518. 

  518. 	{    
    519. 

  519. 		mysql_query("set character_set_server='utf8'");
    520. 

  520. 		mysql_query("set names 'utf8'");
    521. 

  521. 		$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";
    522. 

  522. 		$result=mysql_query($sql);
    523. 

  523. 		return $result;
    524. 

  524. 	}
    525. 

  525. 	
    526. 

  526. 	public function getMyHistory($doctorID)
    527. 

  527. 	{    
    528. 

  528. 		mysql_query("set character_set_server='utf8'");
    529. 

  529. 		mysql_query("set names 'utf8'");
    530. 

  530. 		$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";
    531. 

  531. 		$result=mysql_query($sql);
    532. 

  532. 		return $result;
    533. 

  533. 	}
    534. 

  534. 	
    535. 

  535. 	public function getpatientdetailsa($patientID)
    536. 

  536. 	{		
    537. 

  537. 		mysql_query("set character_set_server='utf8'");
    538. 

  538. 		mysql_query("set names 'utf8'");
    539. 

  539. 		$sql = "select * from patient where patient_id = '$patientID'";
    540. 

  540. 		$result=mysql_query($sql);
    541. 

  541. 		return $result;
    542. 

  542. 	}
    543. 

  543. 	
    544. 

  544. 	public function check_login_details($emailID,$password,$type)
    545. 

  545. 

  546. 	{    
    547. 

  547. 		mysql_query("set character_set_server='utf8'");
    548. 

  548. 		mysql_query("set names 'utf8'");
    549. 

  549. 		$sql = "select * from healthcare_login where (email_id = '$emailID' OR mobile_no = '$emailID') AND password = '$password' and type = '$type'";
    550. 

  550. 		$result=mysql_query($sql);
    551. 

  551. 		return $result;
    552. 

  552. 	}
    553. 

  553. 	
    554. 

  554. 	public function checkemaildetails($emailID)
    555. 

  555. 

  556. 	{    
    557. 

  557. 		mysql_query("set character_set_server='utf8'");
    558. 

  558. 		mysql_query("set names 'utf8'");
    559. 

  559. 		$sql = "select * from healthcare_login where email_id = '$emailID'";
    560. 

  560. 		$result=mysql_query($sql);
    561. 

  561. 		return $result;
    562. 

  562. 	}
    563. 

  563. 	public function check_mobile_no_s($mobileNo)
    564. 

  564. 

  565. 	{    
    566. 

  566. 		mysql_query("set character_set_server='utf8'");
    567. 

  567. 		mysql_query("set names 'utf8'");
    568. 

  568. 		$sql = "select * from healthcare_login where mobile_no = '$mobileNo'";
    569. 

  569. 		
    570. 

  570. 		$result=mysql_query($sql);
    571. 

  571. 		return $result;
    572. 

  572. 	}
    573. 

  573. 	
    574. 

  574. 	public function insert_login($dID,$emailID,$mobileNo,$passwordD,$type)
    575. 

  575. 	{    
    576. 

  576. 		mysql_query("set character_set_server='utf8'");
    577. 

  577. 		mysql_query("set names 'utf8'");
    578. 

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

  579. 		('$dID','$emailID','$mobileNo','$passwordD','D')";
    580. 

    581. 

  581. 		
    582. 

  582. 		$result=mysql_query($sql);
    583. 

  583. 		return $result;
    584. 

  584. 	}
    585. 

  585. 	public function quick_health_registration($mobileNo,$passwordD)
    586. 

  586. 	{    
    587. 

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

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

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

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

  591. 		return $result;
    592. 

  592. 	}
    593. 

  593. 	
    594. 

  594. 	public function insert_p_login($pID,$emailID,$mobile_no,$passwordD)
    595. 

  595. 	{    
    596. 

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

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

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

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

  600. 		return $result;
    601. 

  601. 	}
    602. 

  602. 	public function insert_pharmacy_login($p_ID,$emailID,$mobile_no,$passwordD)
    603. 

  603. 	{    
    604. 

  604. 		mysql_query("set character_set_server='utf8'");
    605. 

  605. 		mysql_query("set names 'utf8'");
    606. 

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

  607. 		
    608. 

  608. 		$result=mysql_query($sql);
    609. 

  609. 		return $result;
    610. 

  610. 	}
    611. 

  611. 	public function update_status_detail($doctorID,$paymentID)
    612. 

  612. 	{    
    613. 

  613. 		mysql_query("set character_set_server='utf8'");
    614. 

  614. 		mysql_query("set names 'utf8'");
    615. 

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

  616. 		$result=mysql_query($sql);
    617. 

  617. 		return $result;
    618. 

  618. 	}
    619. 

  619. 	public function checkemailid($emailID)
    620. 

  620. 

  621. 	{    
    622. 

  622. 		mysql_query("set character_set_server='utf8'");
    623. 

  623. 		mysql_query("set names 'utf8'");
    624. 

  624. 		$sql = "select * from doctor_signup where email_id = '$emailID'";
    625. 

  625. 		
    626. 

  626. 		$result=mysql_query($sql);
    627. 

  627. 		return $result;
    628. 

  628. 	}
    629. 

  629. 	public function check_patient_mobile_no($emailID,$phoneNo)
    630. 

  630. 	{    
    631. 

  631. 		mysql_query("set character_set_server='utf8'");
    632. 

  632. 		mysql_query("set names 'utf8'");
    633. 

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

  634. 		
    635. 

  635. 		$result=mysql_query($sql);
    636. 

  636. 		return $result;
    637. 

  637. 	}
    638. 

  638. 	public function check_doctor_ID($doctorID)
    639. 

  639. 

  640. 	{    
    641. 

  641. 		mysql_query("set character_set_server='utf8'");
    642. 

  642. 		mysql_query("set names 'utf8'");
    643. 

  643. 		$sql = "select * from doctor_signup where doctor_id = '$doctorID'";
    644. 

  644. 		
    645. 

  645. 		$result=mysql_query($sql);
    646. 

  646. 		return $result;
    647. 

  647. 	}
    648. 

  648. 	/*------------------------------------------Chat-------------------------------------------------*/
    649. 

  649. 	public function get_type_details($id)
    650. 

  650. 	{    
    651. 

  651. 		mysql_query("set character_set_server='utf8'");
    652. 

  652. 		mysql_query("set names 'utf8'");
    653. 

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

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

  655. 		$result=mysql_query($sql);
    656. 

  656. 		return $result;
    657. 

  657. 	}
    658. 

  658. 	public function get_last_message_date($fromID,$toID,$type)
    659. 

  659. 	{    
    660. 

  660. 		mysql_query("set character_set_server='utf8'");
    661. 

  661. 		mysql_query("set names 'utf8'");
    662. 

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

  663. 	
    664. 

  664. 		$result=mysql_query($sql);
    665. 

  665. 		return $result;
    666. 

  666. 	}
    667. 

  667. 	public function get_farmacy_last_message_date($fromID,$toid,$type)
    668. 

  668. 	{    
    669. 

  669. 		mysql_query("set character_set_server='utf8'");
    670. 

  670. 		mysql_query("set names 'utf8'");
    671. 

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

  672. 		$result=mysql_query($sql);
    673. 

  673. 		return $result;
    674. 

  674. 	}
    675. 

  675. 	public function get_farmacy_p_last_message_date($fromID,$toid,$type)
    676. 

  676. 	{    
    677. 

  677. 		mysql_query("set character_set_server='utf8'");
    678. 

  678. 		mysql_query("set names 'utf8'");
    679. 

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

  680. 		
    681. 

  681. 		$result=mysql_query($sql);
    682. 

  682. 		return $result;
    683. 

  683. 	}
    684. 

  684. 	public function get_chat_patient_details($id,$type)
    685. 

  685. 	{    
    686. 

  686. 		mysql_query("set character_set_server='utf8'");
    687. 

  687. 		mysql_query("set names 'utf8'");
    688. 

  688. 		$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";
    689. 

  689. 		$result=mysql_query($sql);
    690. 

  690. 		
    691. 

  691. 		
    692. 

  692. 		$PatToID  = array();
    693. 

  693. 		$PatFromID  = array();
    694. 

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

  695. 		$qryT=mysql_query($sqlT);
    696. 

  696. 		while($resultT=mysql_fetch_assoc($qryT)) {
    697. 

  697. 			$PatToID[] = $resultT['to_id']; 
    698. 

  698. 		}
    699. 

  699. 		
    700. 

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

  701. 		$qryF=mysql_query($sqlF);
    702. 

  702. 		while($resultF=mysql_fetch_assoc($qryF)) {
    703. 

  703. 			$PatFromID[] = $resultF['from_id']; 
    704. 

  704. 		}
    705. 

  705. 		$array_merge_patients =  array_merge($PatToID, $PatFromID);
    706. 

  706. 		$Newpatients = array_unique($array_merge_patients);
    707. 

  707. 		$all_chat_patients = array_values($Newpatients);
    708. 

  708. 		
    709. 

  709. 		/*echo "<pre>";
    710. 

  710. 		print_r($all_chat_patients);
    711. 

  711. 		echo "</pre>";*/
    712. 

  712. 		return $all_chat_patients;
    713. 

  713. 		
    714. 

  714. 	}
    715. 

  715. 	public function get_chat_pharmacy_details($id,$type)
    716. 

  716. 	{    
    717. 

  717. 		mysql_query("set character_set_server='utf8'");
    718. 

  718. 		mysql_query("set names 'utf8'");
    719. 

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

  720. 		
    721. 

  721. 		$result=mysql_query($sql);
    722. 

  722. 		
    723. 

  723. 		$PhRToID  = array();
    724. 

  724. 		$PhRFromID  = array();
    725. 

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

  726. 		$qryT=mysql_query($sqlT);
    727. 

  727. 		while($resultT=mysql_fetch_assoc($qryT)) {
    728. 

  728. 			$PhRToID[] = $resultT['to_id']; 
    729. 

  729. 		}
    730. 

  730. 		
    731. 

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

  732. 		$qryF=mysql_query($sqlF);
    733. 

  733. 		while($resultF=mysql_fetch_assoc($qryF)) {
    734. 

  734. 			$PhRFromID[] = $resultF['from_id']; 
    735. 

  735. 		}
    736. 

  736. 		$array_merge_pharmcy =  array_merge($PhRToID, $PhRFromID);
    737. 

  737. 		$Newpharmcy = array_unique($array_merge_pharmcy);
    738. 

  738. 		$all_chat_pharmcy = array_values($Newpharmcy);
    739. 

  739. 		
    740. 

  740. 		return $all_chat_pharmcy;
    741. 

  741. 		
    742. 

  742. 		//return $all_chat_pharmcy;
    743. 

  743. 		
    744. 

  744. 	}
    745. 

  745. 	public function get_chat_pharmacy_patient_details($id,$type)
    746. 

  746. 	{    
    747. 

  747. 		mysql_query("set character_set_server='utf8'");
    748. 

  748. 		mysql_query("set names 'utf8'");
    749. 

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

  750. 		
    751. 

  751. 		$result=mysql_query($sql);*/
    752. 

  752. 		
    753. 

  753. 		$PhRToID  = array();
    754. 

  754. 		$PhRFromID  = array();
    755. 

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

  756. 		$qryT=mysql_query($sqlT);
    757. 

  757. 		while($resultT=mysql_fetch_assoc($qryT)) {
    758. 

  758. 			$PhRToID[] = $resultT['to_id']; 
    759. 

  759. 		}
    760. 

  760. 		
    761. 

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

  762. 		$qryF=mysql_query($sqlF);
    763. 

  763. 		while($resultF=mysql_fetch_assoc($qryF)) {
    764. 

  764. 			$PhRFromID[] = $resultF['from_id']; 
    765. 

  765. 		}
    766. 

  766. 		$array_merge_pharmcy =  array_merge($PhRToID, $PhRFromID);
    767. 

  767. 		$Newpharmcy = array_unique($array_merge_pharmcy);
    768. 

  768. 		$all_chat_pharmcy = array_values($Newpharmcy);
    769. 

  769. 		
    770. 

  770. 		
    771. 

  771. 		
    772. 

  772. 		return $all_chat_pharmcy;
    773. 

  773. 		
    774. 

  774. 	}
    775. 

  775. 	public function get_patient_id_chat($id,$type)
    776. 

  776. 	{    
    777. 

  777. 		mysql_query("set character_set_server='utf8'");
    778. 

  778. 		mysql_query("set names 'utf8'");
    779. 

  779. 		/*$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";
    780. 

  780. 		$result=mysql_query($sql);*/
    781. 

  781. 		
    782. 

  782. 		$PatToID  = array();
    783. 

  783. 		$PatFromID  = array();
    784. 

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

  785. 		$qryT=mysql_query($sqlT);
    786. 

  786. 		while($resultT=mysql_fetch_assoc($qryT)) {
    787. 

  787. 			$PatToID[] = $resultT['to_id']; 
    788. 

  788. 		}
    789. 

  789. 		
    790. 

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

  791. 		$qryF=mysql_query($sqlF);
    792. 

  792. 		while($resultF=mysql_fetch_assoc($qryF)) {
    793. 

  793. 			$PatFromID[] = $resultF['from_id']; 
    794. 

  794. 		}
    795. 

  795. 		$array_merge_patients =  array_merge($PatToID, $PatFromID);
    796. 

  796. 		$Newpatients = array_unique($array_merge_patients);
    797. 

  797. 		$all_chat_patients = array_values($Newpatients);
    798. 

  798. 		
    799. 

  799. 		return $all_chat_patients;
    800. 

  800. 	}
    801. 

  801. 	public function get_doctor_id_chat($id,$type)
    802. 

  802. 	{    
    803. 

  803. 		mysql_query("set character_set_server='utf8'");
    804. 

  804. 		mysql_query("set names 'utf8'");
    805. 

  805. 		/*$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";
    806. 

  806. 		
    807. 

  807. 		$result=mysql_query($sql);*/
    808. 

  808. 		
    809. 

  809. 		$DcoToID  = array();
    810. 

  810. 		$DocFromID  = array();
    811. 

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

  812. 		$qryT=mysql_query($sqlT);
    813. 

  813. 		while($resultT=mysql_fetch_assoc($qryT)) {
    814. 

  814. 			$DcoToID[] = $resultT['to_id']; 
    815. 

  815. 		}
    816. 

  816. 		
    817. 

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

  818. 		$qryF=mysql_query($sqlF);
    819. 

  819. 		while($resultF=mysql_fetch_assoc($qryF)) {
    820. 

  820. 			$DocFromID[] = $resultF['from_id']; 
    821. 

  821. 		}
    822. 

  822. 		$array_merge_doctors =  array_merge($DcoToID, $DocFromID);
    823. 

  823. 		$Newdoctors= array_unique($array_merge_doctors);
    824. 

  824. 		$all_chat_doctors = array_values($Newdoctors);
    825. 

  825. 		
    826. 

  826. 		return $all_chat_doctors;
    827. 

  827. 		
    828. 

  828. 	}
    829. 

  829. 	public function get_pharmacy_det_id()
    830. 

  830. 	{    
    831. 

  831. 		mysql_query("set character_set_server='utf8'");
    832. 

  832. 		mysql_query("set names 'utf8'");
    833. 

  833. 		$sql = "select * from pharmacy";
    834. 

  834. 		
    835. 

  835. 		$result=mysql_query($sql);
    836. 

  836. 		return $result;
    837. 

  837. 	}
    838. 

  838. 	public function get_chat_doctor_chatlist($id)
    839. 

  839. 	{    
    840. 

  840. 		mysql_query("set character_set_server='utf8'");
    841. 

  841. 		mysql_query("set names 'utf8'");
    842. 

  842. 		$sql = "SELECT from_id,to_id 
    843. 

  843. 				FROM  `chat_message` 
    844. 

  844. 				WHERE (from_id =  '$id'
    845. 

  845. 				OR to_id =  '$id') AND type='DD'
    846. 

  846. 				GROUP BY (
    847. 

  847. 				to_id
    848. 

  848. 				AND from_id
    849. 

  849. 				)";
    850. 

  850. 		
    851. 

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

  852. 		return $result;
    853. 

  853. 	}
    854. 

  854. 	public function get_chat_doctor_details($id,$type)
    855. 

  855. 	{   
    856. 

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

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

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

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

  860. 		
    861. 

  861. 		$DocToID  = array();
    862. 

  862. 		$DocFromID  = array();
    863. 

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

  864. 		$qryT=mysql_query($sqlT);
    865. 

  865. 		while($resultT=mysql_fetch_assoc($qryT)) {
    866. 

  866. 			$DocToID[] = $resultT['to_id']; 
    867. 

  867. 		}
    868. 

  868. 		
    869. 

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

  870. 		$qryF=mysql_query($sqlF);
    871. 

  871. 		while($resultF=mysql_fetch_assoc($qryF)) {
    872. 

  872. 			$DocFromID[] = $resultF['from_id']; 
    873. 

  873. 		}
    874. 

  874. 		$array_merge_doctor =  array_merge($DocToID, $DocFromID);
    875. 

  875. 		$Newdoctor = array_unique($array_merge_doctor);
    876. 

  876. 		$all_chat_doctor = array_values($Newdoctor);
    877. 

  877. 		
    878. 

  878. 		return $all_chat_doctor;
    879. 

  879. 		
    880. 

  880. 	}
    881. 

  881. 	public function get_doctor_requst_details($id)
    882. 

  882. 	{    
    883. 

  883. 		mysql_query("set character_set_server='utf8'");
    884. 

  884. 		mysql_query("set names 'utf8'");
    885. 

  885. 		$sql = "select * from push_notification_details where patient_id = '$id'";
    886. 

  886. 		//echo $sql;
    887. 

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

  888. 		//echo $sql;
    889. 

  889. 		$result=mysql_query($sql);
    890. 

  890. 		return $result;
    891. 

  891. 	}
    892. 

  892. 	public function getpatientdetails($pID)
    893. 

  893. 	{    
    894. 

  894. 		mysql_query("set character_set_server='utf8'");
    895. 

  895. 		mysql_query("set names 'utf8'");
    896. 

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

  897. 		//echo $sql;
    898. 

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

  899. 		$result=mysql_query($sql);
    900. 

  900. 		return $result;
    901. 

  901. 	}
    902. 

  902. 	public function getdoctor_details($pID)
    903. 

  903. 	{    
    904. 

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

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

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

  907. 		
    908. 

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

  909. 		return $result;
    910. 

  910. 	}
    911. 

  911. 	public function get_doctor_detailrow($doctorID)
    912. 

  912. 	{    
    913. 

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

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

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

  916. 		
    917. 

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

  918. 		return $result;
    919. 

  919. 	}
    920. 

  920. 	public function get_detail_patient($fromID)
    921. 

  921. 	{    
    922. 

  922. 		mysql_query("set character_set_server='utf8'");
    923. 

  923. 		mysql_query("set names 'utf8'");
    924. 

  924. 		$sql = "select * from patient where patient_id = '$fromID'";
    925. 

  925. 		$result=mysql_query($sql);
    926. 

  926. 		return $result;
    927. 

  927. 	}
    928. 

  928. 	public function getmessaged($id,$pID)
    929. 

  929. 	{    
    930. 

  930. 		mysql_query("set character_set_server='utf8'");
    931. 

  931. 		mysql_query("set names 'utf8'");
    932. 

  932. 		//$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";
    933. 

  933. 		$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";
    934. 

  934. 		//echo $sql;
    935. 

  935. 		$result=mysql_query($sql);
    936. 

  936. 		return $result;
    937. 

  937. 	}
    938. 

  938. 	public function getDmessaged($id,$pID)
    939. 

  939. 	{    
    940. 

  940. 		mysql_query("set character_set_server='utf8'");
    941. 

  941. 		mysql_query("set names 'utf8'");
    942. 

  942. 		//$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";
    943. 

  943. 		$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";
    944. 

  944. 	
    945. 

  945. 	
    946. 

  946. 		$result=mysql_query($sql);
    947. 

  947. 		return $result;
    948. 

  948. 	}
    949. 

  949. 	
    950. 

  950. 	public function getpharmacymessaged($id,$fID)
    951. 

  951. 	{    
    952. 

  952. 		mysql_query("set character_set_server='utf8'");
    953. 

  953. 		mysql_query("set names 'utf8'");
    954. 

  954. 		//$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";
    955. 

  955. 		$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";
    956. 

  956. 		
    957. 

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

  958. 		return $result;
    959. 

  959. 	}
    960. 

  960. 	
    961. 

  961. 	public function getpharmacypatientmessaged($id,$fID)
    962. 

  962. 	{    
    963. 

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

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

  965. 		$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";
    966. 

  966. 		
    967. 

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

  968. 		return $result;
    969. 

  969. 	}
    970. 

  970. 	
    971. 

  971. 	public function getpharmacypatientmessaged1($id,$fID)
    972. 

  972. 	{    
    973. 

  973. 		mysql_query("set character_set_server='utf8'");
    974. 

  974. 		mysql_query("set names 'utf8'");		
    975. 

  975. 		$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";
    976. 

  976. 		
    977. 

  977. 		$result=mysql_query($sql);
    978. 

  978. 		return $result;
    979. 

  979. 	}
    980. 

  980. 	
    981. 

  981. 	public function getpharmacydoctormessaged($id,$fID)
    982. 

  982. 	{    
    983. 

  983. 		mysql_query("set character_set_server='utf8'");
    984. 

  984. 		mysql_query("set names 'utf8'");
    985. 

  985. 		$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";
    986. 

  986. 		
    987. 

  987. 		$result=mysql_query($sql);
    988. 

  988. 		return $result;
    989. 

  989. 	}
    990. 

  990. 	public function getpharmacydmessaged($id,$fID)
    991. 

  991. 	{    
    992. 

  992. 		mysql_query("set character_set_server='utf8'");
    993. 

  993. 		mysql_query("set names 'utf8'");
    994. 

  994. 		$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";
    995. 

  995. 		
    996. 

  996. 		$result=mysql_query($sql);
    997. 

  997. 		return $result;
    998. 

  998. 	}
    999. 

  999. 	
    1000. 

  1000. 	
    1001. 

  1001. 	public function insert_message($fromID,$toID,$message,$type,$mtype)
    1002. 

  1002. 	{    
    1003. 

  1003. 		mysql_query("set character_set_server='utf8'");
    1004. 

  1004. 		mysql_query("set names 'utf8'");
    1005. 

  1005. 		
    1006. 

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

  1007. 		$result=mysql_query($sql);
    1008. 

  1008. 		return $result;
    1009. 

  1009. 	}
    1010. 

  1010. 	public function insert_invite_doctor_chat($doctorID,$member_ID,$messageID)
    1011. 

  1011. 	{    
    1012. 

  1012. 		mysql_query("set character_set_server='utf8'");
    1013. 

  1013. 		mysql_query("set names 'utf8'");
    1014. 

  1014. 		$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')";
    1015. 

  1015. 		$result=mysql_query($sql);
    1016. 

  1016. 		return $result;
    1017. 

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

  1018. 	{    
    1019. 

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

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

  1021. 		$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')";
    1022. 

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

  1023. 		return $result;
    1024. 

  1024. 	}
    1025. 

  1025. 	public function upload_image($fromID,$toID,$file_url,$type,$mtype)
    1026. 

  1026. 	{    
    1027. 

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

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

  1029. 		$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;
    1030. 

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

  1031. 		return $result;
    1032. 

  1032. 	}
    1033. 

  1033. 	public function upload_image_group($fromID,$toID,$file_url,$type,$mtype)
    1034. 

  1034. 	{    
    1035. 

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

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

  1037. 		$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;
    1038. 

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

  1039. 		return $result;
    1040. 

  1040. 	}
    1041. 

  1041. 	public function update_read_message_status($fromID,$toID)
    1042. 

  1042. 	{    
    1043. 

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

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

  1045. 		$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')";
    1046. 

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

  1047. 		return $result;
    1048. 

  1048. 	}
    1049. 

  1049. 	public function update_read_message_from_pharmacy($fromID,$toID)
    1050. 

  1050. 	{    
    1051. 

  1051. 		mysql_query("set character_set_server='utf8'");
    1052. 

  1052. 		mysql_query("set names 'utf8'");
    1053. 

  1053. 		$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'";
    1054. 

  1054. 		
    1055. 

  1055. 		$result=mysql_query($sql);
    1056. 

  1056. 		return $result;
    1057. 

  1057. 	}
    1058. 

  1058. 	public function update_read_message_far_patient_from_pharmacy($fromID,$toID)
    1059. 

  1059. 	{
    1060. 

  1060. 		mysql_query("set character_set_server='utf8'");
    1061. 

  1061. 		mysql_query("set names 'utf8'");
    1062. 

  1062. 		$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'";
    1063. 

  1063. 		$result=mysql_query($sql);
    1064. 

  1064. 		return $result;
    1065. 

  1065. 	}
    1066. 

  1066. 	public function update_read_message_far_doc_from_pharmacy($fromID,$toID)
    1067. 

  1067. 	{    
    1068. 

  1068. 		mysql_query("set character_set_server='utf8'");
    1069. 

  1069. 		mysql_query("set names 'utf8'");
    1070. 

  1070. 		$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'";
    1071. 

  1071. 		
    1072. 

  1072. 		$result=mysql_query($sql);
    1073. 

  1073. 		return $result;
    1074. 

  1074. 	}
    1075. 

  1075. 	public function update_read_message_phar_to_phar($fromID,$toID)
    1076. 

  1076. 	{    
    1077. 

  1077. 		mysql_query("set character_set_server='utf8'");
    1078. 

  1078. 		mysql_query("set names 'utf8'");
    1079. 

  1079. 		$sql = "UPDATE `chat_message` SET `read_status`='1' WHERE (`from_id` = '$toID' AND `to_id` = '$fromID') AND type = 'FF'";
    1080. 

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

  1081. 		return $result;
    1082. 

  1082. 	}
    1083. 

  1083. 	public function update_read_message_from_doc_pharmacy($fromID,$toID)
    1084. 

  1084. 	{    
    1085. 

  1085. 		mysql_query("set character_set_server='utf8'");
    1086. 

  1086. 		mysql_query("set names 'utf8'");
    1087. 

  1087. 		$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'";
    1088. 

  1088. 		$result=mysql_query($sql);
    1089. 

  1089. 		return $result;
    1090. 

  1090. 	}
    1091. 

  1091. 	public function update_read_patientd_message_from_pharmacy($fromID,$toID)
    1092. 

  1092. 	{    
    1093. 

  1093. 		mysql_query("set character_set_server='utf8'");
    1094. 

  1094. 		mysql_query("set names 'utf8'");
    1095. 

  1095. 		$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'";
    1096. 

  1096. 		
    1097. 

  1097. 		$result=mysql_query($sql);
    1098. 

  1098. 		return $result;
    1099. 

  1099. 	}
    1100. 

  1100. 	public function update_read_docmessage_from_pharmacy($fromID,$toID)
    1101. 

  1101. 	{    
    1102. 

  1102. 		mysql_query("set character_set_server='utf8'");
    1103. 

  1103. 		mysql_query("set names 'utf8'");
    1104. 

  1104. 		$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'";
    1105. 

  1105. 		
    1106. 

  1106. 		$result=mysql_query($sql);
    1107. 

  1107. 		return $result;
    1108. 

  1108. 	}
    1109. 

  1109. 	public function update_read_messageFF_from_pharmacy($fromID,$toID)
    1110. 

  1110. 	{    
    1111. 

  1111. 		mysql_query("set character_set_server='utf8'");
    1112. 

  1112. 		mysql_query("set names 'utf8'");
    1113. 

  1113. 		$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'";
    1114. 

  1114. 		
    1115. 

  1115. 		$result=mysql_query($sql);
    1116. 

  1116. 		return $result;
    1117. 

  1117. 	}
    1118. 

  1118. 	public function update_read_messagefp_from_pharmacy($fromID,$toID)
    1119. 

  1119. 	{    
    1120. 

  1120. 		mysql_query("set character_set_server='utf8'");
    1121. 

  1121. 		mysql_query("set names 'utf8'");
    1122. 

  1122. 		$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'";
    1123. 

  1123. 		
    1124. 

  1124. 		$result=mysql_query($sql);
    1125. 

  1125. 		return $result;
    1126. 

  1126. 	}
    1127. 

  1127. 	public function update_read_message_from_group($toID,$fromID)
    1128. 

  1128. 	{    
    1129. 

  1129. 		mysql_query("set character_set_server='utf8'");
    1130. 

  1130. 		mysql_query("set names 'utf8'");
    1131. 

  1131. 		$sql = "UPDATE `readchatmessage` SET `status`='1' WHERE group_id = '$toID' AND member_id = '$fromID'";
    1132. 

  1132. 		$result=mysql_query($sql);
    1133. 

  1133. 		return $result;
    1134. 

  1134. 	}
    1135. 

  1135. 	public function get_chat_image($fromID,$toID,$type,$mtype)
    1136. 

  1136. 	{    
    1137. 

  1137. 		mysql_query("set character_set_server='utf8'");
    1138. 

  1138. 		mysql_query("set names 'utf8'");
    1139. 

  1139. 		$sql = "SELECT * FROM chat_message WHERE patient_id =  '$pid'";
    1140. 

  1140. 		$result=mysql_query($sql);
    1141. 

  1141. 		return $result;
    1142. 

  1142. 	}
    1143. 

  1143. 	public function getmessagedetail($fid,$tid,$type,$to_type)
    1144. 

  1144. 	{    
    1145. 

  1145. 		mysql_query("set character_set_server='utf8'");
    1146. 

  1146. 		mysql_query("set names 'utf8'");
    1147. 

  1147. 		$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')";
    1148. 

  1148. 		$result=mysql_query($sql);
    1149. 

  1149. 		return $result;
    1150. 

  1150. 	}
    1151. 

  1151. 	public function getfmessagedetail($fid,$tid,$type,$to_type)
    1152. 

  1152. 	{    
    1153. 

  1153. 		mysql_query("set character_set_server='utf8'");
    1154. 

  1154. 		mysql_query("set names 'utf8'");
    1155. 

  1155. 		$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')";
    1156. 

  1156. 		$result=mysql_query($sql);
    1157. 

  1157. 		return $result;
    1158. 

  1158. 	}
    1159. 

  1159. 	public function getpatientmessagedetail($fid,$tid,$type,$to_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,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')";
    1164. 

  1164. 		$result=mysql_query($sql);
    1165. 

  1165. 		return $result;
    1166. 

  1166. 	}
    1167. 

  1167. 	public function getmessagedetaildetails($fid,$tid,$type)
    1168. 

  1168. 	{    
    1169. 

  1169. 		mysql_query("set character_set_server='utf8'");
    1170. 

  1170. 		mysql_query("set names 'utf8'");
    1171. 

  1171. 		$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'";
    1172. 

  1172. 		$result=mysql_query($sql);
    1173. 

  1173. 		return $result;
    1174. 

  1174. 	}
    1175. 

  1175. 	public function getpmessagedetail($fid,$tid,$type,$to_type)
    1176. 

  1176. 	{    
    1177. 

  1177. 		mysql_query("set character_set_server='utf8'");
    1178. 

  1178. 		mysql_query("set names 'utf8'");
    1179. 

  1179. 		$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')";
    1180. 

  1180. 		//$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')";
    1181. 

  1181. 		$result=mysql_query($sql);
    1182. 

  1182. 		return $result;
    1183. 

  1183. 	}
    1184. 

  1184. 	public function get_pharmacy_chat_message($fid,$tid,$type,$to_type)
    1185. 

  1185. 	{    
    1186. 

  1186. 		mysql_query("set character_set_server='utf8'");
    1187. 

  1187. 		mysql_query("set names 'utf8'");
    1188. 

  1188. 		$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')";
    1189. 

  1189. 		//$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')";
    1190. 

  1190. 		$result=mysql_query($sql);
    1191. 

  1191. 		return $result;
    1192. 

  1192. 	}
    1193. 

  1193. 	
    1194. 

  1194. 	public function get_pharmacy_doctor_chat_message($fid,$tid,$type,$to_type)
    1195. 

  1195. 	{    
    1196. 

  1196. 		mysql_query("set character_set_server='utf8'");
    1197. 

  1197. 		mysql_query("set names 'utf8'");
    1198. 

  1198. 		$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')";
    1199. 

  1199. 		//$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')";
    1200. 

  1200. 		$result=mysql_query($sql);
    1201. 

  1201. 		return $result;
    1202. 

  1202. 	}
    1203. 

  1203. 	
    1204. 

  1204. 	public function get_pharmacy_patient_chat_message($fid,$tid,$type,$to_type)
    1205. 

  1205. 	{    
    1206. 

  1206. 		mysql_query("set character_set_server='utf8'");
    1207. 

  1207. 		mysql_query("set names 'utf8'");
    1208. 

  1208. 		$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')";
    1209. 

  1209. 		//$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')";
    1210. 

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

  1211. 		return $result;
    1212. 

  1212. 	}
    1213. 

  1213. 	
    1214. 

  1214. 	public function get_pharmacy_pharmacy_chat_message($fid,$tid,$type,$to_type)
    1215. 

  1215. 	{    
    1216. 

  1216. 		mysql_query("set character_set_server='utf8'");
    1217. 

  1217. 		mysql_query("set names 'utf8'");
    1218. 

  1218. 		$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')";
    1219. 

  1219. 		//$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')";
    1220. 

  1220. 		$result=mysql_query($sql);
    1221. 

  1221. 		return $result;
    1222. 

  1222. 	}
    1223. 

  1223. 	
    1224. 

  1224. 	
    1225. 

  1225. 	
    1226. 

  1226. 	public function count_unread_message($id,$res,$type)
    1227. 

  1227. 	{
    1228. 

  1228. 		mysql_query("set character_set_server='utf8'");
    1229. 

  1229. 		mysql_query("set names 'utf8'");
    1230. 

  1230. 		$sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$res' AND `to_id` = '$id') and `read_status` = '0' AND type != '$type'";
    1231. 

  1231. 		$result=mysql_query($sql);
    1232. 

  1232. 		return $result;
    1233. 

  1233. 	}
    1234. 

  1234. 	public function count_unread_pharmacyd_message($id,$res,$type)
    1235. 

  1235. 	{
    1236. 

  1236. 		mysql_query("set character_set_server='utf8'");
    1237. 

  1237. 		mysql_query("set names 'utf8'");
    1238. 

  1238. 		$sql = "SELECT * FROM `chat_message` WHERE (`from_id` = '$id' AND `to_id` = '$res') and `read_status` = '0' AND type = 'FP'";
    1239. 

  1239. 		$result=mysql_query($sql);
    1240. 

  1240. 		return $result;
    1241. 

  1241. 	}
    1242. 

  1242. 	public function count_unread_far_message($id,$res,$type)
    1243. 

  1243. 	{
    1244. 

  1244. 		mysql_query("set character_set_server='utf8'");
    1245. 

  1245. 		mysq…
    1246.

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