<?php
define('DB_SERVER','localhost');
define('DB_USER','btiyawmy_software');
define('DB_PASS' ,'@#admin@#');
define('DB_NAME', 'btiyawmy_software');
class DB_con
{
function __construct()
{
$con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME);
$this->dbh=$con;
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
}
public function currentUser()
{
	if(isset($_SESSION['uname']))
		return $_SESSION['uname'];
	else
		return "";
	//header("location: index.php");
}

public function Patient_feedbackOPD($prescriptionid, $patientid, $hospital_id, $FO_id, $Acc_id, $Nurse_id, $Pharma_Id, $Doc_Id, $FO_Accessibility, $FO_Behavior, $FO_Knowledge, $Acc_Accessibility, $Acc_Behavior, $Acc_Knowledge, $Bill_Consultation, $Bill_Investigation, $Bill_Medicine, $Nurse_Accessibility, $Nurse_Behavior, $Nurse_Knowledge, $WaitingPeriod, $DocKnowledgeable, $PharmaCheck,$PharmaPolicy, $CleannessWaitingArea, $CleannessToilet, $HosEnvironment,$Counseling, $EnteredBy, $CreatedTime,$CreateDate,$Crated_At)
{
$ret=mysqli_query($this->dbh,"UPDATE `opd_feedback` SET `FO_id`='$FO_id',`Acc_id`='$Acc_id',`Nurse_id`='$Nurse_id',`Pharma_Id`='$Pharma_Id',`Doc_Id`='$Doc_Id',`FO_Accessibility`='$FO_Accessibility',`FO_Behavior`='$FO_Behavior',`FO_Knowledge`='$FO_Knowledge',`Acc_Accessibility`='$Acc_Accessibility',`Acc_Behavior`='$Acc_Behavior',`Acc_Knowledge`='$Acc_Knowledge',`Bill_Consultation`='$Bill_Consultation',`Bill_Investigation`='$Bill_Investigation',`Bill_Medicine`='$Bill_Medicine',`Nurse_Accessibility`='$Nurse_Accessibility',`Nurse_Behavior`='$Nurse_Behavior',`Nurse_Knowledge`='$Nurse_Knowledge',`WaitingPeriod`='$WaitingPeriod',`DocKnowledgeable`='$DocKnowledgeable',`PharmaCheck`='$PharmaCheck',`PharmaPolicy`='$PharmaPolicy',`CleannessWaitingArea`='$CleannessWaitingArea',`CleannessToilet`='$CleannessToilet',`HosEnvironment`='$HosEnvironment',`Counseling`='$Counseling',`CreatedTime`='$CreatedTime',`Updated_At`='$Crated_At',`Status`='1' WHERE `prescriptionid`='$prescriptionid' AND `patientid`='$patientid'");


return $ret;

}


public function save_activity($prescriptionid, $patientid, $EnteredBy,$Crated_At)
{

$save_activity=mysqli_query($this->dbh,"INSERT INTO `save_activity`(`userno`, `prescriptionid`, `discription`, `link`, `entered_by`, `created_at`) VALUES ('$patientid','$prescriptionid','Out-Patient Feedback<br>Doc.no-','View_Patient_feedback_OPD.php?prescriptionid=$prescriptionid&patientid=$patientid&srno=','$EnteredBy','$Crated_At')");
return $save_activity;

}


public function OPD_Patient_follow_up($prescriptionid,$patientid,$hospital_id,$Outcome,$Investigation,$Investigation_note,$Medication,$Medication_note,$entered_by,$CreatedTime,$CreateDate,$Crated_At)
{
$OPD_Patient_follow_up=mysqli_query($this->dbh,"UPDATE `opd_follow_up` SET `Outcome`='$Outcome',`ReactionInvestigation`='$Investigation',`SpecifyInvestigation`='$Investigation_note',`ReactionTreatment`='$Medication',`SpecifyTreatment`='$Medication_note',`CreatedTime`='$CreatedTime',`UpdatedAt`='$Crated_At',`Status`='1' WHERE `prescriptionid`='$prescriptionid' AND `patientid`='$patientid'");


return $OPD_Patient_follow_up;
}


public function Patient_feedbackIPD($prescriptionid, $patientid, $FO_id, $MO_id, $Nurse_id, $All_Nurse_Id, $Doc_Id, $FO_Accessibility, $FO_Behavior, $FO_Knowledge, $MOTreatmentPatient, $MOBehaviorPatient, $MOKnowledgePatient, $HosAdmissionCharges, $HosInvestigation, $HosTreatment, $Nurse_Accessibility, $Nurse_Behavior, $Nurse_Knowledge,$ANSPunctuality,$ANSBehavior,$ANSKnowledge,$KnowledgeableCounseling,$DietDietician,$treatmentSurgeries,$CreatedTime,$Crated_At )
{
$ipd_feedbackipd_feedback=mysqli_query($this->dbh,"UPDATE `ipd_feedback` SET `FO_id`='$FO_id',`MO_id`='$MO_id',`Nurse_id`='$Nurse_id',`All_Nurse_Id`='$All_Nurse_Id',`Doc_Id`='$Doc_Id',`FO_Accessibility`='$FO_Accessibility',`FO_Behavior`='$FO_Behavior',`FO_Knowledge`='$FO_Knowledge',`MO_Accessibility`='$MOTreatmentPatient',`MO_Behavior`='$MOBehaviorPatient',`MO_Knowledge`='$MOKnowledgePatient',`hos_Consultation`='$HosAdmissionCharges',`hos_Investigation`='$HosInvestigation',`hos_Medicine`='$HosTreatment',`Nurse_Accessibility`='$Nurse_Accessibility',`Nurse_Behavior`='$Nurse_Behavior',`Nurse_Knowledge`='$Nurse_Knowledge',`All_Nurse_Accessibility`='$ANSPunctuality',`All_Nurse_Behavior`='$ANSBehavior',`All_Nurse_Knowledge`='$ANSKnowledge',`doctor`='$KnowledgeableCounseling',`Dietician`='$DietDietician',`counselor`='$treatmentSurgeries',`CreatedTime`='$CreatedTime',`Updated_At`='$Crated_At',`Status`='1' WHERE  `prescriptionid`='$prescriptionid' AND `patientid`='$patientid'");


return $ipd_feedback;

}
}
?>