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; } ?>
Date & Time | Invoice | Towards | Action |
---|