alert('Deleted successfully..');"; } } if(isset($_POST['saveAmt'])) { for ($j = 0; $j < count($_POST['srno']); $j++) { $srno = $_POST['srno'][$j]; $discount = $_POST['discount']; $pricetotal1=$_POST['pricetotal1']; $price= $_POST['price'][$j]; $paymentmode= $_POST['paymentmode']; $action=$_POST['action'][$j]; $c = $price - ($price * ($discount / 100)); $sql2="UPDATE medicine_slot SET discount='$discount',pricetotal='$c',UpgradeAmt='$c',price='$price',paymentmode='$paymentmode',action='$action' WHERE srno='$srno'"; $qsql2 = mysqli_query($con,$sql2); } } if($_GET['srno']){ $CalAmt=$_POST['CalAmt']; $srno = $_GET['srno']; $medicine_charge="UPDATE medicine_charge SET CalAmt='0',PaymentStatus='Clear' WHERE srno='$srno'"; $qmedicine_charge = mysqli_query($con,$medicine_charge); if($qmedicine_charge==1){ echo ""; echo ";"; } } if(isset($_POST['saveAmt'])){ for ($i = 0; $i < count($_POST['Batch_number']); $i++) { $DRUGS_name= $_POST["DRUGS_name"][$i]; $Category= $_POST["Category"][$i]; $quantitygiven= $_POST["quantitygiven"][$i]; $price= $_POST["price"][$i]; $updated_at=date("F d, Y / h:i:s A"); $created_at=date("F d, Y / h:i:s A"); $Batch_number= $_POST["Batch_number"][$i]; $HSN_No= $_POST["HSN_No"][$i]; $GSTfinal= $_POST["GSTfinal"][$i]; $gstper= $_POST["gstper"][$i]; $expireDate= $_POST["expireDate"][$i]; $DisPrice= $_POST["DisPrice"][$i]; $srno = $_POST['srno'][$i]; $Fprice = $_POST['Fprice'][$i]; $invoice=mt_rand(1000,99999); $PaidAmt=$_POST['PaidAmt']; $typevisit=$_POST['typevisit']; $CalAmt=round($_POST['CalAmt']); $medicine_id = $_POST['medicine_id'][$i]; $inventory_id = $_POST['inventory_id'][$i]; $Fgst=$_POST['Fgst'][$i]; $sql="INSERT INTO `medicine_charge`(`prescriptionid`, `patientid`, `hospital_Id`, `MedicineName`, `Quantity`, `Price`, `Category`, `TotalAmt`,`FinalAmt`, `gst`, `batchNumber`, `HSN_No`,`gstper`, `Expiry_Date`,`DisPrice`, `pricetotal1`, `Total_gst`, `paymentmode`, `GSTFinalAmt`,`srno`,`srno2`,`medicine_id`,`inventory_id`,`invoice_no`,`CardHolder`,`CardNumber`,`UPI_Number`,`saledate`, `PaidAmt`, `typevisit`, `CalAmt`, `Fgst`,`created_at`, `updated_at`) VALUES ('$_GET[prescriptionid]', '$_GET[patientid]','$_POST[userno]','$DRUGS_name','$quantitygiven','$price','$Category','$_POST[TotalAmt]','$Fprice','$GSTfinal','$Batch_number','$HSN_No','$gstper','$expireDate','$_POST[discount]','$_POST[pricetotal1]','$_POST[Total_gst]','$_POST[paymentmode]','$_POST[GSTFinalAmt]','$_POST[srno2]','$srno','$medicine_id','$inventory_id','$invoice','$_POST[CardHolder]','$_POST[CardNumber]','$_POST[UPI_Number]','$_POST[saledate]','$PaidAmt','$typevisit','$CalAmt','$Fgst','$created_at','$updated_at')"; //echo $sql; $result=mysqli_query($con,$sql); $last_id = $con->insert_id; } ?>
× Success!... Ready To Print.
'; echo ";"; }else{ echo '
× Not! Allowed.
'; } } ?>
Date & Time Invoice Towards Action
'> Sale
query("SELECT * FROM `medicine_charge` Where PaymentStatus='Due' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"); if($RowClearAmt=$ClaerAmt->fetch_assoc()){ ?> Due '>
"; ?> query("SELECT * FROM `medicine_charge` Where PaymentStatus='Due' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"); if($RowClearAmt=$ClaerAmt->fetch_assoc()){ ?> &prescriptionid=&patientid=' class='btn btn-info'>Pay
Return "; ?>

"; } } } } } ?>
Created Towards Medicine DetailsBatch NumberHSN Code Expiry DateQuantityMRP GST Status
Action
 $rsp2[created_at]
$rsn[name]
"; echo "$rh191[DRUGS_name] "; echo "
"; $disGST=$pricetotal/100; $GSTfinal1=$disGST*$rh1[gst]; $GSTfinal=round($GSTfinal1) ; $GRANDTOTAL=$rsp2[pricetotal]; echo "
"; echo" "; ?> ' type='hidden' name='Fgst[]' /> "; echo "
$rh1[Batch_number] $rh1[HSN_No] $rh1[Expiry_Date] $rsp2[quantitygiven] ($cat)"; echo "$pricetotal"; echo "$rh1[gst] %
$GSTfinal
"; $medicine_charge="SELECT * FROM medicine_charge Where AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND batchNumber='$rh1[Batch_number]'"; $qMedicine_Charge=mysqli_query($con,$medicine_charge); $RowMedicineCharge=mysqli_fetch_assoc($qMedicine_Charge); $status=$RowMedicineCharge['status']; $batchNumber=$RowMedicineCharge['batchNumber']; if($status == '1'){ echo "Paid"; } else{ echo "Due"; } echo "
"; if($batchNumber == ''){ echo ""; //echo "| "; } else{ echo "Return"; } // echo " "; // | // echo " // | // Return // "; echo "

Due Amt

"; ?> Gross Amt. :
GST . :
Discount. :

Grand Total :

Payment Mode :

Pay :
"; if($raddaspatient['typevisit']=='IPD' || $raddaspatient['typevisit']=='Ipd_Emergency'){ echo "
"; } ?>