Server IP : 162.240.98.243 / Your IP : 3.14.245.167 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/www/ |
Upload File : |
<?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); } } }