<?PHP
require_once('DBManager.php');
require_once('LoginManager.php');


class PatientManager
{	
public static $userhomepage="welcome.php",$loginpage="login.php",$adminhomepage="price.php",$drhomepage="drprofile.php",$patienthomepage="patient_basic.php";




public static function listinvestigation($Investigation,$labdepartmentid,$radiobodypartid,$adminid)
{
	echo "";
	$link=DBManager::connect();
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");


$sql="INSERT INTO list_Investigation(ivid,Investigation,labdepartmentid	,radiobodypartid,adminid) VALUES (NULL,'$Investigation','$labdepartmentid','$radiobodypartid','$adminid')";
	$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('Investigation Create  successfully..');</script><script> window.history.go(-1)</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}


public static function createinhouse($ivid,$hospitalid,$scope,$sample_urgent,$sample_urgent_duration,$sample_normal,$sample_normal_duration,$report_urgent,$report_urgent_duration,$report_normal,$report_normal_duration,$rate,$entered_by)
{
	echo "";
	$link=DBManager::connect();
		$narayan=LoginManager::currentUser();
	$anilka=LoginManager::getUserTypeByuname("$narayan");
	$entered_by="$anilka";
		$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO create_inhouse(srno,ivid,hospitalid,scope,sample_urgent,sample_urgent_duration,sample_normal,sample_normal_duration,report_urgent,report_urgent_duration,report_normal,report_normal_duration,rate,entered_by,created_at,updated_at) VALUES (NULL,'$ivid','$hospitalid','$scope','$sample_urgent','$sample_urgent_duration','$sample_normal','$sample_normal_duration','$report_urgent','$report_urgent_duration','$report_normal','$report_normal_duration','$rate','$entered_by','$created_at','$updated_at')";
		$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('Add successfully..');</script><script> window.history.go(-2)</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}

public static function testdesciption($ivid,$methodid,$parametersid,$Test_Description,$Unit,$Hospitaltype,$same_to_all,$all_min,$all_max,$mNewborn_min,$mNewborn_max,$mChild_min,$mChild_max,$mAdult_min,$mAdult_max,$mSenior_Citizen_min,$mSenior_Citizen_max,$mold_min,$mold_max,$fNewborn_min,$fNewborn_max,$fChild_min,$fChild_max,$fAdult_min,$fAdult_max,$fSenior_Citizen_min,$fSenior_Citizen_max,$fold_min,$fold_max,$entered_by)
{
	echo "";
	$link=DBManager::connect();
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$sql="INSERT INTO Test_Description_final(testdesid,ivid,methodid,parametersid,Test_Description,Unit,gender,same_to_all,all_min,all_max,mNewborn_min,mNewborn_max,mChild_min,mChild_max,mAdult_min,mAdult_max,mSenior_Citizen_min,mSenior_Citizen_max,mold_min,mold_max,fNewborn_min,fNewborn_max,fChild_min,fChild_max,fAdult_min,fAdult_max,fSenior_Citizen_min,fSenior_Citizen_max,fold_min,fold_max,entered_by,created_at) VALUES (NULL,'$ivid','$methodid','$parametersid','$Test_Description','$Unit','$Hospitaltype','$same_to_all','$all_min','$all_max','$mNewborn_min','$mNewborn_max','$mChild_min','$mChild_max','$mAdult_min','$mAdult_max','$mSenior_Citizen_min','$mSenior_Citizen_max','$mold_min','$mold_max','$fNewborn_min','$fNewborn_max','$fChild_min','$fChild_max','$fAdult_min','$fAdult_max','$fSenior_Citizen_min','$fSenior_Citizen_max','$fold_min','$fold_max','$entered_by','$created_at')";
	$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('Test Description Create  successfully..');</script><script> window.history.go(-1)</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}



public static function frqsurgury($hospitalid,$surgery,$drid,$entered_by)
{
	echo "";
	$link=DBManager::connect();
		$narayan=LoginManager::currentUser();
	$anilka=LoginManager::getUserTypeByuname("$narayan");
	$entered_by="$anilka";
   $updated_at=date("Y-m-d");
   $created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO frquencytracker(surgeryid,hospitalid,surgery,drid,entered_by,created_at,updated_at) VALUES (NULL,'$hospitalid','$surgery','$drid','$entered_by','$created_at','$updated_at')";
     $result=mysqli_query($link,$sql);
if($result)
{
    	$surgeryid=mysqli_insert_id($link);

echo "<script>alert('FPM Add successfully');</script><script>window.location='frequency_add.php?drid=$drid&surgeryid=$surgeryid'</script>;</script>";
}
else 
	echo "Fail";
	$link=DBManager::close($link);
}


// Start FREQUENCY PRESCRIBE MEDICATION//
public static function frqsurguryinv($hospitalid,$surgery,$drid,$entered_by)
{
	echo "";
	$link=DBManager::connect();
		$narayan=LoginManager::currentUser();
	$anilka=LoginManager::getUserTypeByuname("$narayan");
	$entered_by="$anilka";
   $updated_at=date("Y-m-d");
   $created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO frquencytracker(surgeryid,hospitalid,surgery,drid,entered_by,created_at,updated_at) VALUES (NULL,'$hospitalid','$surgery','$drid','$entered_by','$created_at','$updated_at')";
     $result=mysqli_query($link,$sql);
if($result)
{
    	$surgeryid=mysqli_insert_id($link);

echo "<script>alert('FPM Add successfully');</script><script>window.location='frequencyinvestigation_add.php?drid=$drid&surgeryid=$surgeryid'</script>;</script>";
}
else 
	echo "Fail";
	$link=DBManager::close($link);
}

public static function frequency($type,$typeid,$frq,$route,$duration,$potential,$adminid,$drid,$surgeryid,$entered_by)
{
    	$link=DBManager::connect();
		$narayan=LoginManager::currentUser();
	$anilka=LoginManager::getUserTypeByuname("$narayan");
	$entered_by="$anilka";
    $frequency = $link->query("SELECT typeid,drid,surgeryid FROM frequency WHERE typeid = '$typeid' AND drid = '$drid' AND surgeryid = '$surgeryid'");
$numMI=mysqli_num_rows($frequency);
if($numMI > 0){
        echo "<script>alert('Already Exists');</script>";
    }else{ 
    
    $updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");



$sql="INSERT INTO frequency(id,type,typeid,frq,route,duration,potential,adminid,drid,surgeryid,entered_by,created_at,updated_at) VALUES (NULL,'$type','$typeid','$frq','$route','$duration','$potential','$adminid','$drid','$surgeryid','$entered_by','$created_at','$updated_at')";
	$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('frequency add successfully..');</script><script>window.location='frequency_add.php?drid=$drid&surgeryid=$surgeryid'</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}
}

public static function frequencyiv($type,$typeid,$frq,$route,$duration,$potential,$adminid,$drid,$surgeryid,$entered_by)
{
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");


	$link=DBManager::connect();
		$narayan=LoginManager::currentUser();
	$anilka=LoginManager::getUserTypeByuname("$narayan");
	$entered_by="$anilka";
$sql="INSERT INTO frequency(id,type,typeid,frq,route,duration,potential,adminid,drid,surgeryid,entered_by,created_at,updated_at) VALUES (NULL,'$type','$typeid','$frq','$route','$duration','$potential','$adminid','$drid','$surgeryid','$entered_by','$created_at','$updated_at')";
	$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('frequency add successfully..');</script><script>window.location='frequencyinvestigation_add.php?drid=$drid&surgeryid=$surgeryid'</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}

//Start Medicine Stok//

public static function Medicinestok($admin_id,$Category,$DRUGS_name,$Contain,$Dose,$dose_value,$mrp,$size,$Name_brand,$vendorname)
{
	//echo "";
	$link=DBManager::connect();
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$entered_by=$harilal;
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$Medicine = $link->query("SELECT DRUGS_name,admin_id FROM medicine_stok WHERE admin_id = '$admin_id' AND DRUGS_name = '$DRUGS_name'");
$numrows=mysqli_num_rows($Medicine);
if($numrows > 0){
        echo "<script>alert('Medicine Already Exists');</script>";
    }else{ 
    $sql="INSERT INTO medicine_stok(medicine_id,admin_id,Category,DRUGS_name,Contain,Dose,dose_value,mrp,size,Name_brand,vendorname,created_at,updated_at) VALUES (NULL, '$admin_id','$Category','$DRUGS_name','$Contain','$Dose','$dose_value','$mrp','$size','$Name_brand','$vendorname','$created_at','$updated_at')";
    $result=mysqli_query($link,$sql);
    if(!$result)
	return false;
$sql ="select last_insert_medicine_id() from medicine_stok";
$result=mysqli_query($link,$sql);
if(!$result)
	return false;
$row=mysqli_fetch_row($result);
$medicine_id=$row[0];
	$result=mysqli_query($link,$sql);
		PatientManager::setActivityLog($patientid,"$prescriptionid","medicine Prescription","show_medicine.php?medicine_id=$medicine_id","$entered_by");
if($result)
echo "<script>alert('Add successfully..');</script><script>window.location='Medicine_in_Stock.php';</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}
}

//End Medicine Stock//

public static function Composition($Contain)
{	
    $link=DBManager::connect();
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$entered_by=$harilal;
	$updated_at=date("Y-m-d");
  $created_at=date("F d, Y / h:i:s A");
	$Composition="INSERT INTO `Composition`(`CompositionName`, `Created_By`) VALUES ('$Contain','$updated_at')";	
	//echo $Composition;
	$result=mysqli_query($link,$Composition);		
if($result)
echo "<script>alert('Add successfully..');</script><script>window.location='Medicine_in_Stock.php';</script>;</script>";

	

	}	


public static function Medicinestokinventory($medicine_id,$invoice_no,$date_of_purchase,$vendor,$date_invoice,$Cmrp,$cost_gst,$Batch_number,$HSN_No,$mrp,$gst,$Quantity,$totalQuatity,$Expiry_Date,$entered_by)
{
	//echo "";
	$link=DBManager::connect();
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$entered_by=$harilal;
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$MedicineInventory = $link->query("SELECT medicine_id,invoice_no FROM medicine_inventory WHERE medicine_id = '$medicine_id' AND invoice_no = '$invoice_no'");
$numMI=mysqli_num_rows($MedicineInventory);
if($numMI > 0){
        echo "<script>alert('Already Exists');</script>";
    }else{ 
	$sql="INSERT INTO medicine_inventory(inventory_id,medicine_id,invoice_no,date_of_purchase,vendor,date_invoice,Cmrp,cost_gst,Batch_number,HSN_No,mrp,gst,Quantity,totalQuatity,Expiry_Date,entered_by,created_at,updated_at) VALUES (NULL,'$medicine_id','$invoice_no','$date_of_purchase','$vendor','$date_invoice','$Cmrp','$cost_gst','$Batch_number','$HSN_No','$mrp','$gst','$Quantity','$totalQuatity','$Expiry_Date','$entered_by','$created_at','$updated_at')";
	
		$purchase_invoice=$link->query("INSERT INTO `purchase_invoice`(`medicine_id`, `invoice_no`, `date_of_purchase`, `vendor`, `date_invoice`, `Cmrp`, `cost_gst`, `Batch_number`, `HSN_No`, `mrp`, `gst`, `Quantity`, `totalQuatity`, `Expiry_Date`, `entered_by`, `created_at`, `updated_at`) VALUES ('$medicine_id','$invoice_no','$date_of_purchase','$vendor','$date_invoice','$Cmrp','$cost_gst','$Batch_number','$HSN_No','$mrp','$gst','$Quantity','$totalQuatity','$Expiry_Date','$entered_by','$created_at','$updated_at')");
    $result=mysqli_query($link,$sql);
    {
  	$insid= mysqli_insert_id($link);
			$invetory_id= $insid;
			
	PatientManager::setActivitybill($invetory_id,"$medicine_id","$date_of_purchase","$vendor","$date_invoice","$Cmrp","$cost_gst","$Batch_number","$mrp","$gst","$entered_by");
    }
if($result)

echo "<script>alert('Medicine add successfully..');</script><script>window.location='Add_inventory.php?medicine_id=$medicine_id'</script>;</script>";

else 
	echo "Fail";
	$link=DBManager::close($link);
	
}
public static function setActivitybill($invetory_id,$medicine_id,$date_of_purchase,$vendor,$date_invoice,$Cmrp,$cost_gst,$Batch_number,$mrp,$gst,$entered_by)
{
	$updated_at=date("Y-m-d");
   $created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO vendor_billing(vendor_billid,invetory_id,medicine_id,date_of_purchase,vendor,date_invoice,Cmrp,cost_gst,Batch_number,mrp,gst,entered_by,created_at,updated_at) VALUES (NULL,'$invetory_id','$medicine_id','$date_of_purchase','$vendor','$date_invoice','$Cmrp','$cost_gst','$Batch_number','$mrp','$gst','$entered_by','$created_at','$updated_at')";
			$link=DBManager::connect();
	$result=mysqli_query($link,$sql);
	{
  	$insid= mysqli_insert_id($link);
			$vendor_billid= $insid;
			
	PatientManager::setActivitybillsave($invetory_id,"$vendor_billid","$date_of_purchase","$Cmrp","status","mode","$entered_by");
    }
	if($result)
		$link=DBManager::close($link);
	}


public static function setActivitybillsave($invetory_id,$vendor_billid,$date_time,$price_pay,$status,$mode,$entered_by)
{
	$updated_at=date("Y-m-d");
   $created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO part_vendor_billing(part_vendor_billid,invetory_id,vendor_billid,date_time,price_pay,status,mode,entered_by,created_at,updated_at) VALUES (NULL,'$invetory_id','$vendor_billid','$date_time','$price_pay','$status','$mode','$entered_by','$created_at','$updated_at')";
	
	$link=DBManager::connect();
	$result=mysqli_query($link,$sql);
	
	if($result)
		$insid= mysqli_insert_id($link);
			$srid= $insid;
		$link=DBManager::close($link);
	}	

public static function Implant_inventory($implant_id,$invoice_no,$dateOfPurchase,$Vendor,$date_invoice,$cmrp,$batchno,$HSN,$mrp,$gst,$qty,$totalQty,$expiryDate,$entered_by)
{
	//echo "";
	$link=DBManager::connect();
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$entered_by=$harilal;
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$implantInventory = $link->query("SELECT implant_id,invoice_no,batchno FROM implant_inventory WHERE implant_id = '$implant_id' AND invoice_no = '$invoice_no' AND batchno = '$batchno'");
$numMI=mysqli_num_rows($implantInventory);
if($numMI > 0){
        echo "<script>alert('Already Exists');</script>";
    }else{ 
	$sql="INSERT INTO implant_inventory(`inventory_id`, `implant_id`, `invoice_no`, `dateOfPurchase`, `Vendor`, `cmrp`, `batchno`, `HSN`, `mrp`, `gst`, `qty`, `totalQty`, `expiryDate`, `enteredBy`, `created_at`, `updated_at`) VALUES (NULL,'$implant_id','$invoice_no','$dateOfPurchase','$Vendor','$cmrp','$batchno','$HSN','$mrp','$gst','$qty','$totalQty','$expiryDate','$entered_by','$created_at','$updated_at')";
	//echo $sql;
	

		$purchase_invoice=$link->query("INSERT INTO `implant_purchase_invoice`(`purchase_id`, `implant_id`, `invoice_id`, `dateOfPurchase`, `vendor`, `dateOfInvoice`, `cmrp`, `Cost_gst`, `batchNo`, `Hsn_no`, `mrp`, `gst`, `qty`, `totalQty`, `expiryDate`, `DiscountPrice`, `PriceTotal1`, `PaymentMode`, `CardHolder`, `CardNo`, `UPI_No`, `entered_by`, `created_at`, `updated_at`) VALUES (NUll,'$implant_id','$invoice_no','$dateOfPurchase','$Vendor','','$cmrp','','$batchno','$HSN','$mrp','$gst','$qty','$totalQty','$expiryDate','','','','','','','$entered_by','$created_at','$updated_at')");
	echo $purchase_invoice;
	
    $result=mysqli_query($link,$sql);
    {
  	$insid= mysqli_insert_id($link);
			$invetory_id= $insid;
			
	PatientManager::setActivitybill($invetory_id,"$implant_id","$dateOfPurchase","$Vendor","Null","$cmrp","Null","$batchno","$mrp","$gst","$entered_by");
    }
if($result){

echo "<script>alert('Implant add successfully..');</script><script>window.location='Implants_Add_inventory.php?implant_id=$implant_id'</script>;</script>";
}
else {
	echo "Fail";
	$link=DBManager::close($link);
}	
}

}


public static function Consumable_inventory($Consumable_id,$invoice_no,$dateOfPurchase,$Vendor,$date_invoice,$cmrp,$batchno,$HSN,$mrp,$gst,$qty,$totalQty,$expiryDate,$entered_by)
{
	//echo "";
	$link=DBManager::connect();
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$entered_by=$harilal;
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$MedicineInventory = $link->query("SELECT Consumable_id,invoice_no,batchno FROM consumable_inventory WHERE Consumable_id = '$Consumable_id' AND invoice_no = '$invoice_no' AND batchno = '$batchno'");
$numMI=mysqli_num_rows($MedicineInventory);
if($numMI > 0){
        echo "<script>alert('Already Exists');</script>";
    }else{ 
	$sql="INSERT INTO consumable_inventory(`inventory_id`, `Consumable_id`, `invoice_no`, `dateOfPurchase`, `Vendor`, `cmrp`, `batchno`, `HSN`, `mrp`, `gst`, `qty`, `totalQty`, `expiryDate`, `enteredBy`, `created_at`, `updated_at`) VALUES (NULL,'$Consumable_id','$invoice_no','$dateOfPurchase','$Vendor','$cmrp','$batchno','$HSN','$mrp','$gst','$qty','$totalQty','$expiryDate','$entered_by','$created_at','$updated_at')";
	//echo $sql;
	

		$purchase_invoice=$link->query("INSERT INTO `consumable_purchase_invoice`(`purchase_id`, `consumable_id`, `invoice_id`, `dateOfPurchase`, `vendor`, `dateOfInvoice`, `cmrp`, `Cost_gst`, `batchNo`, `Hsn_no`, `mrp`, `gst`, `qty`, `totalQty`, `expiryDate`, `DiscountPrice`, `PriceTotal1`, `PaymentMode`, `CardHolder`, `CardNo`, `UPI_No`, `entered_by`, `created_at`, `updated_at`) VALUES (NUll,'$Consumable_id','$invoice_no','$dateOfPurchase','$Vendor','','$cmrp','','$batchno','$HSN','$mrp','$gst','$qty','$totalQty','$expiryDate','','','','','','','$entered_by','$created_at','$updated_at')");
	echo $purchase_invoice;
	
    $result=mysqli_query($link,$sql);
    {
  	$insid= mysqli_insert_id($link);
			$invetory_id= $insid;
			
	PatientManager::setActivitybill($invetory_id,"$Consumable_id","$dateOfPurchase","$Vendor","Null","$cmrp","Null","$batchno","$mrp","$gst","$entered_by");
    }
if($result){

echo "<script>alert('Consumable add successfully..');</script><script>window.location='Consumable_Add_inventory.php?Consumable_id=$Consumable_id'</script>;</script>";
}
else {
	echo "Fail";
	$link=DBManager::close($link);
}	
}

}

// START SAMPLE COLLECTION//
public static function CollectSample($ivid,$prescriptionid,$patientid,$patientname,$Investigation_des,$Specimen_type,$Specimen_type1,$Specimen_type2,$Specimen_type3,$Container_Number,$entered_by)
{
	echo "";
	$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
date_default_timezone_set("Asia/Calcutta");   //India time (GMT+5:30)
$collectionDate= date("Y-m-d");
$TimeIn= date('H:i:s');
$TimeOut= date('H:i:s');

	$link=DBManager::connect();
	PatientManager::updatenayainvestigation($prescriptionid,$patientid,$hospital_id,$Raised_at,$Investigation_type,$Category,$Sub_Category,$Priority_slip,$Investigation,$ivid,"$Container_Number",$Evidence,$entered_by);
$sql="INSERT INTO Collect_Sample(Collectid,ivid,prescriptionid,patientid,patientname,Investigation_des,Specimen_type,Specimen_type1,Specimen_type2,Specimen_type3,Container_Number,collectionDate,TimeIn,TimeOut,entered_by,created_at) VALUES (NULL,'$ivid','$prescriptionid','$patientid','$patientname','$Investigation_des','$Specimen_type','$Specimen_type1','$Specimen_type2','$Specimen_type3','$Container_Number','$collectionDate','$TimeIn','$TimeOut','$entered_by','$created_at')";

	$result=mysqli_query($link,$sql);
	
if($result)

echo "<script>alert('Sample Collect successfully..');</script><script>window.location='showpathlogy.php?prescriptionid=$prescriptionid&patientid=$patientid'</script>;</script>";
else 
	echo "Fail";
	$link=DBManager::close($link);
}

//END SAMPLE COLLECTION//


// Start investigation Update Status//
public static function updatenayainvestigation($prescriptionid,$patientid,$Raised_at,$Investigation_type,$Category,$Sub_Category,$Priority_slip,$Investigation,$ivid,$Result,$Evidence,$entered_by)
{
	$link=DBManager::connect();
$sql ="UPDATE investigation SET Result='$_POST[Container_Number]' WHERE id='$_POST[Container_Number]'";
$result=mysqli_query($link,$sql);
if($result)
echo "";
else 
	echo "";
	$link=DBManager::close($link);
}

//END investigation update Status//

// START REPORT//
public static function REPORTGenerated($prescriptionid,$patientid,$requesttestid,$Impression,$Study_Reveals,$Interpretation,$marks_critical,$entered_by)
{
	echo "";
	$link=DBManager::connect();
	$updated_at=date("F d, Y / h:i:s A");
$created_at=date("F d, Y / h:i:s A");

date_default_timezone_set('Asia/Calcutta'); 

$date1=date("Y-m-d");
$timeIn= date("H:i:s"); // time in India
$timeOut= date("H:i:s");
	PatientManager::updatenayainvestigationreport($prescriptionid,$patientid,$hospital_id,$Raised_at,$Investigation_type,$Category,$Sub_Category,$Priority_slip,$Investigation,$ivid,"$requesttestid",$Evidence,$entered_by);
$sql="INSERT INTO labreports(labreportid,prescriptionid,patientid,requesttestid,Impression,Study_Reveals,Interpretation,marks_critical,TimeIn,TimeOut,entered_by,Critical_Date,created_at,updated_at) VALUES (NULL,'$prescriptionid','$patientid','$requesttestid','$Impression','$Study_Reveals','$Interpretation','$marks_critical','Null','$timeOut','$entered_by','$date1','$created_at','$updated_at')";
	$result=mysqli_query($link,$sql);
if($result)
echo "<script>alert('REPORT Generated successfully..');</script><script> window.history.go(-2)</script>;</script>";

else 
	echo "Fail";
	$link=DBManager::close($link);
}

//END REPORT//

// Start investigation Update Status//
public static function updatenayainvestigationreport($prescriptionid,$patientid,$Raised_at,$Investigation_type,$Category,$Sub_Category,$Priority_slip,$Investigation,$ivid,$Result,$Evidence,$entered_by)
{
	$link=DBManager::connect();
$sql ="UPDATE investigation SET Result='Done' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_POST[requesttestid]'";
$result=mysqli_query($link,$sql);
if($result)
echo "";
else 
	echo "";
	$link=DBManager::close($link);
}

//END investigation update Status//

}
?>