<?php
/*note:
When a doctor get referred it needs to get inserted in doctor stub table with a doctorSerialID and 'temp' in Doctor_unregistered table
when doctor registering before checking hospital doctor, check whther this mobile number present in hospital_refer_in_doctor_stub
if present update entry then update doc id hospital_refer_in_doc_stub where mobile number and also update doctor_unregistered as fals in doctor stub table, and then go for hospital_refer_out_doc_stub
end of note */
session_start();
if (!isset($_SESSION['hospital_id_SESSION'])) {
header("Location: hospital_login.php");
die;
}
include 'db_conn.php';
include 'Email_sender.php';
//include 'logger.php';
//$logger=new Logger();
$email_sender = new EMAIL_SENDER();
$hospital_name = "";
$hospital_id = $_POST['hospital_id'];
$mobile = $_POST['mobile'];
$name = $_POST['name'];
$email = $_POST['email'];
$doctor_title = $_POST['doctor_title'];
$link = "https://play.google.com/store/apps/details?id=com.hospitalcheck.referralio&hl=en";
//$logger->write("INFO :","before count result_query_referin".$count_queryin);
//query to check if already referredin
$query_get_referin = "select * from hospital_refer_in_doctor_stub where refer_by_hos_id='{$hospital_id}' and refer_in_doc_mobile='{$mobile}'";
$result_query_referin = mysql_query($query_get_referin);
$count_queryin = mysql_num_rows($result_query_referin);
if ($count_queryin > 0) {
<?php
session_start();
if (!isset($_SESSION['hospital_id_SESSION'])) {
header("Location: hospital_login.php");
die;
}
$hospital_id = $_SESSION['hospital_id_SESSION'];
$hospital_name = $_SESSION['hospital_name_SESSION'];
include 'db_conn.php';
include 'logger.php';
include 'GCM.php';
include 'Email_sender.php';
$logger = new Logger();
$gcm = new GCM();
$email_sender = new EMAIL_SENDER();
$logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']);
$logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']);
$doctor_name = "";
$doc_mob_number = "";
$doc_email = "";
$doc_title = "";
$doc_ref_id_name = "";
$doc_ref_mobile_number = "";
$doc_ref_email = "";
$doc_ref_title = "";
$gcm_id = "";
$logger->write("INFO :", "before post");
$pat_name = $_POST['pat_name'];
$pat_mobile = $_POST['pat_mobile'];
$pat_age = $_POST['pat_age'];
<?php
session_start();
if (!isset($_SESSION['hospital_id_SESSION'])) {
header("Location: hospital_login.php");
die;
}
$hospital_id = $_SESSION['hospital_id_SESSION'];
$hospital_name = $_SESSION['hospital_name_SESSION'];
include 'db_conn.php';
include 'Email_sender.php';
include 'logger.php';
include 'GCM.php';
$logger = new Logger();
$gcm = new GCM();
$email_sender = new EMAIL_SENDER();
$logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']);
$logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']);
$logger->write("INFO :", "before post");
$pat_id = $_POST['pat_id'];
$status = $_POST['status'];
$logger->write("INFO :", "received post");
/*for sending SMS to refering doctor regarding the patient */
$query_pat_referring = "select tmp.*,sd.Doctor_mobile_number as Ref_mob_number,sd.Doctor_Title as Ref_Title,sd.Doctor_name as Ref_name,sd.Doctor_email as Ref_email from doctor_stub sd inner join (SELECT ps.patient_thread_id,ps.Patient_Name ,ps.reg_by_doc,ps.doc_ref_id,ds.Doctor_Title as Reg_Title,ds.Doctor_name as Reg_name,ds.Doctor_mobile_number as Reg_mobnumber,ds.Doctor_email as Reg_email FROM `patient_stub` ps inner join doctor_stub ds on ps.reg_by_doc=ds.Doctor_serial_id where ps.patient_thread_id= '{$pat_id}')as tmp on tmp.doc_ref_id=sd.Doctor_serial_id";
$logger->write("INFO for query:", $query_pat_referring);
$res_pat_referring = mysql_query($query_pat_referring);
$row_pat_referring = mysql_fetch_assoc($res_pat_referring);
$reg_mob_number = $row_pat_referring['Reg_mobnumber'];
$reg_title = $row_pat_referring['Reg_Title'];
$reg_name = $row_pat_referring['Reg_name'];
$reg_email = $row_pat_referring['Reg_email'];
<?php
session_start();
if (!isset($_SESSION['hospital_id_SESSION'])) {
header("Location: hospital_login.php");
die;
}
$hospital_id = $_SESSION['hospital_id_SESSION'];
$hospital_name = $_SESSION['hospital_name_SESSION'];
include 'db_conn.php';
include 'logger.php';
include 'Email_sender.php';
$logger = new Logger();
$email_sender = new EMAIL_SENDER();
$logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']);
$logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']);
$img_path = "/profile_doc_images/";
$Doctor_name = mysql_real_escape_string($_POST['Doctor_name']);
$Doctor_dob = $_POST['Doctor_dob'];
$Doctor_email = mysql_real_escape_string($_POST['Doctor_email']);
$Doctor_specialization = mysql_real_escape_string($_POST['Doctor_specialization']);
$Doctor_qualification = mysql_real_escape_string($_POST['Doctor_qualification']);
$Doctor_HospitalName = mysql_real_escape_string($_POST['Doctor_HospitalName']);
$Doctor_mobile_number = $_POST['Doctor_mobile_number'];
$Doctor_password = mysql_real_escape_string($_POST['Doctor_password']);
$Doctor_photograph = $_POST['Doctor_photograph'];
$Doctor_yxp = mysql_real_escape_string($_POST['Doctor_yxp']);
$Doctor_Country = mysql_real_escape_string($_POST['Doctor_Country']);
$Doctor_State = mysql_real_escape_string($_POST['Doctor_State']);
$Doctor_City = mysql_real_escape_string($_POST['Doctor_City']);
$Doctor_Address = mysql_real_escape_string($_POST['Doctor_Address']);
