<?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 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 setActivityLog($userno,$prescriptionid,$discription,$link,$enteredby)
{
	$updated_at=date("Y-m-d");
   $created_at=date("F d, Y / h:i:s A");
	$sql="INSERT INTO save_activity(srno,userno,prescriptionid,discription,entered_by,link,created_at,updated_at) VALUES (NULL, '$userno','$prescriptionid','$discription<br>Doc.no-','$enteredby','$link',' $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 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);
}	
}

}



// Start Consumable Inventory

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 Medicine Inventory//


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);
	
}

}



}