<?php
session_start();                                     /* Here session is start */
require_once("../codelibrary/inc/variables.php"); /* This file is required for database connection.  */
require_once("../codelibrary/inc/functions.php"); /* This file contain all function.  */
@extract($_REQUEST);                                 /* This is used for get the request. */
validate_user();                                     /* Validate user for open/access this page with login. */
$ipdVisit=array();
/* log4php start here */
include('../log4php/Logger.php');
Logger::configure('../logger-config.xml');
$logger = Logger::getLogger("-Add Doctor Calculate-");
/* log4php end here */

/*Get data from prevois page to store in database*/

$doctorName=$_POST['doctorName'];
$gender=$_POST['gender'];
$depttId=$_POST['depttId'];
//$doctorCategory=$_POST['doctorCategory'];
$doctorCategory='1';
$bloodGroup=$_POST['bloodGroup'];
$address=$_POST['address'];
$qualificationId=$_POST['qualificationId'];
$age=$_POST['age'];
$opdFee=$_POST['opdFee'];
$ipdFee=$_POST['ipdFee'];
$opdRoom=$_POST['opdRoom'];
$experience=$_POST['experience'];
$schedule=$_POST['schedule'];
$contactNumber=$_POST['contactNumber'];
$doctorImage=$_POST['doctorImage'];
$opdFeeNight=$_POST['opdFeeNight'];
$opdFeeEmergency=$_POST['opdFeeEmergency'];
$ipdFeeNight=$_POST['ipdFeeNight'];
$ipdFeeEmergency=$_POST['ipdFeeEmergency'];
$ecoGen=$_POST['ecoGen'];
$ecoEmer=$_POST['ecoEmer'];
$semiGen=$_POST['semiGen'];
$semiEmer=$_POST['semiEmer'];
$pvtGen=$_POST['pvtGen'];
$pvtEmer=$_POST['pvtEmer'];
$dlxGen=$_POST['dlxGen'];
$dlxEmer=$_POST['dlxEmer'];
$icuGen=$_POST['icuGen'];
$icuEmer=$_POST['icuEmer'];

if($_FILES['doctorImage']['size']>0) /* Check image file size is not null*/
{        
    if(getimagesize($_FILES['doctorImage']['tmp_name'])!=''){
        $doctorImage= addslashes($_FILES['doctorImage']['tmp_name']);
        //$name= addslashes($_FILES['doctorImage']['name']);
        $doctorImage= file_get_contents($doctorImage);
        $doctorImage= base64_encode($doctorImage);
    }
    $wh.=",doctorImage='$doctorImage'";
}
$doctorName=trim($doctorName);
if($_POST['did']){
$did=$_POST['did'];
$nn="update health_doctors set doctorName='$doctorName',gender='$gender',depttId='$depttId',doctorCategory='$doctorCategory',bloodGroup='$bloodGroup',address='$address',qualificationId='$qualificationId',age='$age',opdFee='$opdFee',ipdFee='$ipdFee',opdRoom='$opdRoom',experience='$experience',schedule='$schedule',contactNumber='$contactNumber',opdFeeNight='$opdFeeNight',opdFeeEmergency='$opdFeeEmergency',ipdFeeNight='$ipdFeeNight',ipdFeeEmergency='$ipdFeeEmergency',lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'$wh where id='$did'";
mysql_query_db("update health_doctors set doctorName='$doctorName',gender='$gender',depttId='$depttId',doctorCategory='$doctorCategory',bloodGroup='$bloodGroup',address='$address',qualificationId='$qualificationId',age='$age',opdFee='$opdFee',ipdFee='$ipdFee',opdRoom='$opdRoom',experience='$experience',schedule='$schedule',contactNumber='$contactNumber',opdFeeNight='$opdFeeNight',opdFeeEmergency='$opdFeeEmergency',ipdFeeNight='$ipdFeeNight',ipdFeeEmergency='$ipdFeeEmergency',lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'$wh where id='$did'");
$logger->warn("Doctor update by ".$_SESSION['sess_uname']." - ".$curDateTime." and IP: ".$ipAddress.", query-".$nn);
$_SESSION['sess_opd_msg']=2;
}
else{
$nn="insert into health_doctors set doctorName='$doctorName',gender='$gender',depttId='$depttId',doctorCategory='$doctorCategory',bloodGroup='$bloodGroup',address='$address',qualificationId='$qualificationId',age='$age',opdFee='$opdFee',ipdFee='$ipdFee',opdRoom='$opdRoom',experience='$experience',schedule='$schedule',contactNumber='$contactNumber',doctorStatus=1,opdFeeNight='$opdFeeNight',opdFeeEmergency='$opdFeeEmergency',ipdFeeNight='$ipdFeeNight',ipdFeeEmergency='$ipdFeeEmergency',lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'$wh";
mysql_query_db("insert into health_doctors set doctorName='$doctorName',gender='$gender',depttId='$depttId',doctorCategory='$doctorCategory',bloodGroup='$bloodGroup',address='$address',qualificationId='$qualificationId',age='$age',opdFee='$opdFee',ipdFee='$ipdFee',opdRoom='$opdRoom',experience='$experience',schedule='$schedule',contactNumber='$contactNumber',doctorStatus=1,opdFeeNight='$opdFeeNight',opdFeeEmergency='$opdFeeEmergency',ipdFeeNight='$ipdFeeNight',ipdFeeEmergency='$ipdFeeEmergency',lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'$wh");
$logger->warn("Doctor add by ".$_SESSION['sess_uname']." - ".$curDateTime." and IP: ".$ipAddress.", query-".$nn);
$did=mysql_insert_id_db($sql);
$_SESSION['sess_opd_msg']=1;
}
//
//check for first time entry

$findipd=mysql_query_db("select * from health_doctors where id=$did");
$findline=mysql_fetch_db($findipd);
$ipdVisiting=$findline['ipdVisit'];
//code for IPD visit setting
if($ipdVisiting==0){
$ipdcode="DV-".$did;
$doctorName="Dr.".$doctorName;
$priority=14;
$tpaId=1;
$departmentId=0;
$ipdHeadType=1;
$irda_code=501001;
$irda_master=5;
$code=$ipdcode;

//for eco
$roomId=1;
$ipdHeadName=strtolower($doctorName." General Visit (Eco)");
$ipdHeadName=ucwords($ipdHeadName);
$ipdHeadRate=$ecoGen;
if($ipdHeadRate!=0){
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',irda_master='$irda_master',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
$ipdHeadRate=$ecoEmer;
$ipdHeadName=strtolower($doctorName." Emergency Visit");
$ipdHeadName=ucwords($ipdHeadName);
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',irda_master='$irda_master',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
}
//eco end

//for semi
$roomId=2;
$ipdHeadName=strtolower($doctorName." General Visit (Semi)");
$ipdHeadName=ucwords($ipdHeadName);
$ipdHeadRate=$semiGen;
if($ipdHeadRate!=0){
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
$ipdHeadRate=$semiEmer;
$ipdHeadName=strtolower($doctorName." Emergency Visit (Semi)");
$ipdHeadName=ucwords($ipdHeadName);
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
}
//semi end

//for private
$roomId=3;
$ipdHeadName=strtolower($doctorName." General Visit (Pvt)");
$ipdHeadName=ucwords($ipdHeadName);
$ipdHeadRate=$pvtGen;
if($ipdHeadRate!=0){
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
$ipdHeadRate=$pvtEmer;
$ipdHeadName=strtolower($doctorName." Emergency Visit (Pvt)");
$ipdHeadName=ucwords($ipdHeadName);
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
}
//pvt end

//for deluxe
$roomId=5;
$ipdHeadName=strtolower($doctorName." General Visit (Dlx)");
$ipdHeadName=ucwords($ipdHeadName);
$ipdHeadRate=$dlxGen;
if($ipdHeadRate!=0){
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
$ipdHeadRate=$dlxEmer;
$ipdHeadName=strtolower($doctorName." Emergency Visit (Dlx)");
$ipdHeadName=ucwords($ipdHeadName);
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
}
//delx end

//for icu
$roomId=6;
$ipdHeadName=strtolower($doctorName." General Visit (ICU)");
$ipdHeadName=ucwords($ipdHeadName);
$ipdHeadRate=$icuGen;
if($ipdHeadRate!=0){
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
$ipdHeadRate=$icuEmer;
$ipdHeadName=strtolower($doctorName." Emergency Visit (ICU)");
$ipdHeadName=ucwords($ipdHeadName);
mysql_query_db("insert into health_manageripdhead set code='$code', departmentId='$departmentId',tpaId='$tpaId',irda_code='$irda_code',priority='$priority',ipdHeadName='$ipdHeadName',ipdHeadRate='$ipdHeadRate',roomId='$roomId',ipdHeadStatus=1,lastUpdate='$curDateTime',updateBy='".$_SESSION['sess_uid']."',ipAddress='$ipAddress'");
$Id=mysql_insert_id_db($sql);
$ipdVisit[]=$Id;
}
//icu end
$ipdAll=implode(',',$ipdVisit);
//insert into dr for array
mysql_query_db("update health_doctors set ipdVisit='$ipdAll' where id='$did'");
}
header("location:list-doctor.php");
