} else { //query for inserting referring_in in doctor_stub $temp = "temp"; $visibility = 1; $insert_pending_referring_in = mysql_query("insert into doctor_stub (Doctor_Title,Doctor_name,Doctor_mobile_number,visibility,Doctor_unregistered) values('{$doctor_title}','{$name}','{$mobile}','{$visibility}','{$temp}')"); } if ($doctor_id != "") { $doctor_stub_id = $doctor_id; } $refering_in_query = mysql_query("INSERT INTO hospital_refer_in_doctor_stub(refer_in_doc_title,refer_in_doc_name, refer_in_doc_mobile,refer_in_doc_email,refer_by_hos_id,doc_stub_id) VALUES ('{$doctor_title}','{$name}','{$mobile}','{$email}','{$hospital_id}','{$doctor_stub_id}')"); //query to get the helper clarification table $getClarificationHelper = mysql_query("select * from clarification_member_by_hospital where hospital_id='{$hospital_id}'"); $row_helper = mysql_fetch_assoc($getClarificationHelper); $person = $row_helper['person_name']; $mobile_number = $row_helper['mobile_number']; $extra_notes = $row_helper['extra_notes']; $clarification_msg = "For any help, contact " . $person . " at " . $mobile_number . ".Thanks." . $Doctor_HospitalName . "." . $extra_notes; $mobile_txt_msg = $Doctor_HospitalName . ": Dear " . $doctor_title . $name . " You have been added as a Referring doctor by " . $Doctor_HospitalName . ". Please use this below link to download the app: " . $link . " Or you can search for Referralio on android or ios app store"; send_msg($mobile, $mobile_txt_msg); if ($email != '') { $email_sender->send_email($email, $mobile_txt_msg); } if ($refering_in_query == "success") { send_msg($mobile, $clarification_msg); $success = array('status' => "Success", "msg" => "Successfully Registered"); } else { $success = array('status' => "Failure", "msg" => "Refer In doctor could not be registered"); } echo json_encode($success); exit(0); function send_msg($mobile, $mobile_msg)
//do nothing } } else { //do nothing for the time being } //end of changes for referral map entry if ($sql_insert) { //for sending text message to patient $logger->write("INFO :", "inside success"); $msg_pat_txt = $hospital_name . " :- You have been referred to " . $doc_ref_title . $doc_ref_id_name . " by " . $doc_title . $doctor_name; //send_msg($pat_mobile,$msg_pat_txt);//commented as per requested //for sending text message to referred doctor $msg_doc_txt = $hospital_name . " - Patient " . $pat_name . " has been referred to you by " . $doc_title . $doctor_name; send_msg($doc_ref_mobile_number, $msg_doc_txt); if ($doc_ref_email != '') { $email_sender->send_email($doc_ref_email, $msg_doc_txt); } //for sending text message to referring doctor $msg_doc_txt = $hospital_name . " - Dear " . $doc_title . $doctor_name . ", Thank you for referring Patient " . $pat_name; //.".You can get real time updates of this patient by downloading Referralio app on your phone"; send_msg($doc_mob_number, $msg_doc_txt); if ($doc_email != '') { $email_sender->send_email($doc_email, $msg_doc_txt); } $registatoin_ids = array($gcm_id); $message = array("msg" => " " . $hospital_name . " - " . $doc_ref_title . $doc_ref_id_name . " has reffered a patient " . $pat_name, "flag_push" => "Refer", "Refer_In_cnt" => $cnt_refer_in); $result = $gcm->send_notification($registatoin_ids, $message); $success = array('status' => "Success", "msg" => "Patient successfully registered", "result" => $result); echo json_encode($success); } else { $success = array('status' => "Failure", "msg" => "Transaction Could not be registered", "result" => $result);
$reg_email = $row_pat_referring['Reg_email']; $pat_name = $row_pat_referring['Patient_Name']; $ref_mob_number = $row_pat_referring['Ref_mob_number']; $ref_title = $row_pat_referring['Ref_Title']; $ref_name = $row_pat_referring['Ref_name']; $ref_email = $row_pat_referring['Ref_email']; //end of getting data $sms_msg_referring_doc = $hospital_name . " - Dear " . $reg_title . $reg_name . ", current status for patient " . $pat_name . " : " . $status; $sms_msg_referred_doc = $hospital_name . " - Dear " . $ref_title . $ref_name . ", current status for patient " . $pat_name . " : " . $status; $update_status = "update patient_stub set secondary_status='{$status}' where Patient_thread_id='{$pat_id}'"; $result = mysql_query($update_status); if ($result) { send_msg($reg_mob_number, $sms_msg_referring_doc); send_msg($ref_mob_number, $sms_msg_referred_doc); if ($reg_email != '') { $email_sender->send_email($reg_email, $sms_msg_referring_doc); } if ($ref_email != '') { $email_sender->send_email($ref_email, $sms_msg_referred_doc); } $success = array('status' => "Success", "msg" => "Patient status updated successfully"); echo json_encode($success); } else { $success = array('status' => "Failure", "msg" => "Patient status could not be updated"); echo json_encode($success); } function send_msg($mobile, $mobile_msg) { //$logger->write("INFO :","login with mobile".$mobile); $msg = ""; $msg = urlencode($mobile_msg);
$res_sql_mob = mysql_fetch_assoc($sql_mob_unique_temp); $doc_ser_id = $res_sql_mob['Doctor_serial_id']; $update_doctor = mysql_query("update doctor_stub set Doctor_name='{$Doctor_name}',Doctor_dob='{$Doctor_dob}',Doctor_email='{$Doctor_email}',Doctor_specialization='{$Doctor_specialization}',Doctor_qualification='{$Doctor_qualification}',Doctor_HospitalName='{$Doctor_HospitalName}',Doctor_Country='{$Doctor_Country}',Doctor_State='{$Doctor_State}',Doctor_City='{$Doctor_City}',Doctor_Address='{$Doctor_Address}',Doctor_password=md5('{$Doctor_password}'),Doctor_photograph='{$imageName}',Doctor_yxp='{$Doctor_yxp}',license_number='{$license_number}',visibility='{$visibility}',my_type='{$my_type}',country_code='{$country_code}',Doctor_unregistered='{$doc_unregister}' where Doctor_mobile_number='{$Doctor_mobile_number}'"); $update_refer_in = mysql_query("update hospital_refer_in_doctor_stub set doc_stub_id='{$doc_ser_id}' where refer_in_doc_mobile='{$Doctor_mobile_number}'"); $logger->write("INFO :", "updated doctor stub with doc info and hospital_refer_in_doctor_stub with doc serial id"); //$success = array('status' => "Success", "msg" => "Successfully doctor has been registered"); //$this->response($this->json($success),200); } //sending text message to registered doctor_id_present $link = "https://play.google.com/store/apps/details?id=com.hospitalcheck.referralio&hl=en"; $mobile_txt_msg = $hospital_name . " - Dear " . $doctor_title . $Doctor_name . " You have been added as a inhouse doctor by " . $Doctor_HospitalName . " hospital.Please use this below link to download the app: " . $link; //$logger->write("calling mobile msg"); send_msg($Doctor_mobile_number, $mobile_txt_msg); //sending email if doctor email is present if ($Doctor_email != '') { $email_sender->send_email($Doctor_email, $mobile_txt_msg); } $success = array('status' => "Success", "msg" => "Successfully doctor has been registered"); //$this->response($this->json($success),200); echo json_encode($success); exit(0); } else { $success = array('status' => "Failure", "msg" => "Doctor already added in this hospital"); //$this->response($this->json($success),200); echo json_encode($success); exit(0); } } else { $success = array('status' => "Failed", "msg" => "Doctor already added as a hospital doctor in another hospital"); //$this->response($this->json($error), 400); echo json_encode($success);