Server IP : 162.240.98.243 / Your IP : 18.225.255.187 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/public_html/login.easenup.in/Pharmacy/ |
Upload File : |
<?php session_start(); require_once("../../dbconnection.php"); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); $DisplayForm=True; $sql= "SELECT * FROM implant_purchasereport WHERE invoice_no='$_GET[invoice_id]' AND vendor='$_GET[vendor]' AND implant_ID=$_GET[implant_id] AND status='1'"; $qsql = mysqli_query($con,$sql); if($rh = mysqli_fetch_array($qsql)) { $DisplayForm=False; echo "<script>window.location='view_implant_purchase_invoice.php?invoice_id=$rh[invoice_no]&vendor=$_GET[vendor]&pid=$rh[implant_report_id]&implant_id=$_GET[implant_id]'</script>"; } if($DisplayForm) { ?> <?php include("../dbconnection.php"); require_once('../../DBManager.php'); require_once('../../patientmanager.php'); include("header.php"); include 'menu.php'; ?> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <h1>Purchase Invoice</h1> <br> <!-- Toggle #1 --> <!--start --> <?php include("../dbconnection.php"); require_once('../../DBManager.php'); if(isset($_POST['saveAmt'])){ for ($i = 0; $i < count($_POST["implant_id"]); $i++) { $ImplantName= $_POST["ImplantName"][$i]; $Cmrp= $_POST["Cmrp"][$i]; $mrp=$_POST["mrp"][$i]; $Quantity= $_POST["Quantity"][$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["Expiry_Date"][$i]; $DisPrice= $_POST["DisPrice"][$i]; $srno = $_POST['srno'][$i]; $Fprice = $_POST['Fprice'][$i]; $inventory_id=$_POST['inventory_id'][$i]; $implant_id=$_POST['implant_id'][$i]; $GST=$_POST['GST'][$i]; $invoice=mt_rand(1000,99999); $total_gst=$_POST['GSTfinal'][$i]; $Fgst=$_POST['Fgst'][$i]; $purchase_report=$con->query("INSERT INTO `implant_purchasereport`(`invoice_no`, `implant_id`, `Batch_number`, `HSN_No`, `Expiry_Date`, `Quantity`, `Rate`, `MRP`, `GST`, `GST_Final`, `CalAmt`, `DisAmt`,`ReturnAmt`, `TotalAmt`, `Discount`, `GrantTotal`, `PaymentMode`, `CardHolder`, `CardHolderName`, `UPI_Card_No`, `Inventory_ID`, `GSTFinalAmt`, `implant_name`, `vendor`, `purchaseDate`,`purchase_invoice`,`Cal_gst`,`Fgst`, `created_at`, `update_by`) VALUES ('$_POST[invoice_no]','$implant_id','$Batch_number','$HSN_No','$expireDate','$Quantity','$Cmrp','$mrp','$GST','$total_gst','$price','$Fprice','$Fprice','$_POST[TotalAmt]','$_POST[discount]','$_POST[pricetotal1]','$_POST[paymentmode]','$_POST[CardHolder]','$_POST[CardNumber]','$_POST[UPI_Number]','$inventory_id','$_POST[GSTFinalAmt]','$ImplantName','$_GET[vendor]','$_POST[purchasedate]','$invoice','$_POST[Cal_gst]','$Fgst','$created_at','$updated_at')"); // echo "INSERT INTO `implant_purchasereport`(`invoice_no`, `implant_id`, `Batch_number`, `HSN_No`, `Expiry_Date`, `Quantity`, `Rate`, `MRP`, `GST`, `GST_Final`, `CalAmt`, `DisAmt`,`ReturnAmt`, `TotalAmt`, `Discount`, `GrantTotal`, `PaymentMode`, `CardHolder`, `CardHolderName`, `UPI_Card_No`, `Inventory_ID`, `GSTFinalAmt`, `Consumable_name`, `vendor`, `purchaseDate`,`purchase_invoice`,`Cal_gst`,`Fgst`, `created_at`, `update_by`) VALUES ('$_POST[invoice_no]','$implant_id','$Batch_number','$HSN_No','$expireDate','$Quantity','$Cmrp','$mrp','$GST','$total_gst','$price','$Fprice','$Fprice','$_POST[TotalAmt]','$_POST[discount]','$_POST[pricetotal1]','$_POST[paymentmode]','$_POST[CardHolder]','$_POST[CardNumber]','$_POST[UPI_Number]','$inventory_id','$_POST[GSTFinalAmt]','$ImplantName','$_GET[vendor]','$_POST[purchasedate]','$invoice','$_POST[Cal_gst]','$Fgst','$created_at','$updated_at')"; if($purchase_report==1){ } } } if(isset($_POST['saveAmt'])){ for ($i = 0; $i < count($_POST["implant_id"]); $i++) { $price= $_POST["price"][$i]; $Batch_number= $_POST["Batch_number"][$i]; $Fprice = $_POST['Fprice'][$i]; $implant_id=$_POST['implant_id'][$i]; $pur_invoice=$con->query("UPDATE `implant_purchase_invoice` SET `PaymentMode`='$_POST[paymentmode]',`CardHolder`='$_POST[CardHolder]',`CardNo`='$_POST[CardNumber]',`UPI_No`='$_POST[UPI_Number]',`DiscountPrice`='$_POST[discount]',`PriceTotal1`='$_POST[pricetotal1]',`price`='$_POST[price]',`Fprice`='$_POST[Fprice]' ,`status`='1' WHERE `invoice_id`='$_GET[invoice_id]' AND implant_id='$implant_id' AND batchNo='$Batch_number'"); echo $pur_invoice; } ?> <!-- /.card-header --> <div class="card-body"> <?php if($pur_invoice==1){ echo'<script>alert("Save Successfully.....");</script>'; echo "<script>window.location='view_implant_purchase_invoice.php?implant_id=$_GET[implant_id]&invoice_no=$_GET[invoice_id]&vendor=$_GET[vendor]'</script>;</script>"; }else{ echo '<div class="alert"> <span class="closebtn">×</span> <strong>Not!</strong> Allowed. </div>'; } } ?> <br> <table style='width:100%' class="table table-bordered table-hover" id="myTable"> <form method="post" enctype='multipart/form-data'> <table id="myTable1" class="table table-bordered table-hover" style='width:100%;'> <thead style='width:100%;'> <tr> <th><strong>Created Towards</strong></th> <th><strong>Invoice</strong></th> <th><strong>Implant Details</strong></th><th><strong>Batch Number</strong></th><th><strong>HSN Code</strong></th> <th><strong>Expiry Date</strong></th><th><strong>Quantity</strong></th><th><strong>Rate</strong></th> <th><strong>MRP</strong></th> <th><strong>GST</strong></th> <th><strong>Status</strong></th> <th><strong>Net Amt</strong></th> </tr> </thead> <tbody> <?php include("../dbconnection.php"); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql1 ="SELECT * FROM site_users WHERE userno='$usertype'"; $qsql1 = mysqli_query($con,$sql1); if($re = mysqli_fetch_array($qsql1)) { $sql ="SELECT * FROM implant_purchase_invoice where invoice_id='$_GET[invoice_id]' "; $qsql = mysqli_query($con,$sql); while($RowMedicineIn = mysqli_fetch_array($qsql)) { $implant_stock ="SELECT * FROM implant_stock WHERE implant_id='$RowMedicineIn[implant_id]' AND Admin_id='$re[entered_by]'"; $qimplant_stock = mysqli_query($con,$implant_stock); while($rmedicine_stok = mysqli_fetch_array($qimplant_stock)) { if($rmedicine_stok['Category']==$rmedicine_stok['Category']){ $pricetotal1=$RowMedicineIn['cmrp']*$RowMedicineIn['qty']; //$pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } $disGST=$pricetotal/100; $GSTfinal1=$disGST*$RowMedicineIn[gst]; $GSTfinal=round($GSTfinal1) ; $GRANDTOTAL=$rsp2[pricetotal]; ?> <tr> <td><?php echo $RowMedicineIn['created_at'] ?> <input type='hidden' name='created_at' id='created_at' value='<?php echo $RowMedicineIn['created_at'] ?>'> <input type='hidden' name='inventory_id[]' id='inventory_id' value='<?php echo $RowMedicineIn['inventory_id'] ?>'> <input type='hidden' name='implant_id[]' id='implant_id' value='<?php echo $RowMedicineIn['implant_id'] ?>'> </td> <td><?php echo $RowMedicineIn['invoice_id'] ?> <input type='hidden' name='invoice_no' id='invoice_no' value='<?php echo $RowMedicineIn['invoice_id'] ?>'></td> <td><?php echo $rmedicine_stok['ImplantName'] ?> <input type='hidden' name='ImplantName[]' id='ImplantName' value='<?php echo $rmedicine_stok['ImplantName'] ?>'></td> <td><?php echo $RowMedicineIn['batchNo'] ?> <input type='hidden' name='Batch_number[]' id='Batch_number' value='<?php echo $RowMedicineIn['batchNo'] ?>'></td> <td><?php echo $RowMedicineIn['Hsn_no'] ?> <input type='hidden' name='HSN_No[]' id='HSN_No' value='<?php echo $RowMedicineIn['Hsn_no'] ?>'></td> <td><?php echo $RowMedicineIn['expiryDate'] ?> <input type='hidden' name='Expiry_Date[]' id='Expiry_Date' value='<?php echo $RowMedicineIn['expiryDate'] ?>'></td> <td><?php echo $RowMedicineIn['qty'] ?> <input type='hidden' name='Quantity[]' id='Quantity' value='<?php echo $RowMedicineIn['qty'] ?>'></td> <td><?php echo $RowMedicineIn['cmrp'] ?> <input type='hidden' name='Cmrp[]' id='Cmrp' value='<?php echo $RowMedicineIn['cmrp'] ?>'></td> <td><?php echo $RowMedicineIn['mrp'] ?> <input type='hidden' name='mrp[]' id='mrp' value='<?php echo $RowMedicineIn['mrp'] ?>'></td> <td><?php echo $RowMedicineIn['gst'] ?>%<br><?php echo $GSTfinal ?> <input type='hidden' name='GSTfinal[]' id='gst<?php echo $RowMedicineIn['purchase_id'] ?>' class='gst' value='<?php echo $GSTfinal ?>'> <input class='Fgst' id='Fgst<?php echo $RowMedicineIn['purchase_id'] ?>' type='hidden' name='Fgst[]' /> <input type='hidden' name='GST[]' id='total_gst' class='total_gst' value='<?php echo $RowMedicineIn['gst'] ?>'> </td> <td>Due</td> <td><?php echo $pricetotal; ?> <input type='hidden' name='price[]' id='price<?php echo $RowMedicineIn['purchase_id'] ?>' class='price' value='<?php echo $pricetotal ?>'> <input class='Fprice' id='Fprice<?php echo $RowMedicineIn['purchase_id'] ?>' type='hidden' name='Fprice[]' /> <script> $(document).on("change keyup blur", "#chDiscount", function() { var main3 = $('#price<?php echo $RowMedicineIn['purchase_id'] ?>').val(); var disc3 = $('#chDiscount').val(); var dec3 = (disc3 / 100).toFixed(2); //its convert 10 into 0.10 var mult3 = main3 * dec3; // gives the value for subtract from main value var discont3 = main3 - mult3; $('#Fprice<?php echo $RowMedicineIn['purchase_id'] ?>').val(discont3); }); $(document).on("change keyup blur", "#chDiscount", function() { var main4 = $('#gst<?php echo $RowMedicineIn['purchase_id'] ?>').val(); var disc4 = $('#chDiscount').val(); var dec4 = (disc4 / 100).toFixed(2); //its convert 10 into 0.10 var mult4 = main4 * dec4; // gives the value for subtract from main value var discont4 = main4 - mult4; $('#Fgst<?php echo $RowMedicineIn['purchase_id'] ?>').val(discont4); }); </script> </td> </tr> <?php } } }?> </tbody> <tfoot> <tr> <td colspan=9> <span style='float:right;'> <b>Gross Amt. :</b></span> <br> <span style='float:right;'> <b>Total Cmrp. :</b></span> <br> <span style='float:right;'> <b>GST . :</b></span> <br> <span style='float:right;'> <b>Discount. :</b></span><br><br> <span style='float:right;'> <b>Grand Total :</b></span> <!-- <br><br>--> <!--<span style='float:right;'>--> <!-- <b>GST Final :</b></span>--> <br><br> <span style='float:right;'> <b>Payment Mode :</b></span> </td> <td colspan=3> <?php date_default_timezone_set("Asia/Kolkata"); //India time (GMT+5:30) $date= date('Y-m-d'); echo" <b><i class='fa fa-inr'></i> <span align='right' id='val'></b></span> <div class=''> <b><i class='fa fa-inr'></i> <span align='right' id='val2'></span></div> <div class=''> <b><i class='fa fa-inr'></i> <span align='right' id='AddGST'></span></div> <input type='hidden' id='cBalance'> <div class=''><span><input type='text' name='discount' id='chDiscount' size='2'></span></div> <div class=''> <input type='text' name='pricetotal1' size='2' id='result' required style='margin-top:5px;'></span></div> <div class=''> <input type='hidden' name='Cal_gst' size='2' id='result2' class='result2' required style='margin-top:5px;'> <input type='hidden' name='purchasedate' size='2' id='' value='$date' required style='margin-top:5px;'></span></div> <div class='checkbox'> <select name='paymentmode'> <option value='Cash'>Cash</option> <option value='Card'>Card</option> <option value='UPI'>UPI</option> </select></span></div> <div class=''> <div class='Card box'><input name='CardHolder' id='CardHolder' class='CardHolder' type='text' placeholder='Enter Card Hoder' style='margin-top:5px;' /> <input name='CardNumber' id='CardNumber' class='CardNumber' type='text' placeholder='Enter Card Number' style='margin-top:5px;'/> </div></div> <div class=''> <div class='UPI box'><input name='UPI_Number' id='UPI_Number' class='UPI_Number' type='text' placeholder='Enter UPI Number' style='margin-top:5px;' /> </div></div> "; ?> <br> <br> </div> <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script> <script> $(document).ready(function(){ $("select").change(function(){ $(this).find("option:selected").each(function(){ var optionValue = $(this).attr("value"); if(optionValue){ $(".box").not("." + optionValue).hide(); $("." + optionValue).show(); } else{ $(".box").hide(); } }); }).change(); }); </script> <script> $(document).on("change keyup blur", "#chDiscount", function() { var main2 = $('#GSTFinalAmt').val(); var disc2 = $('#chDiscount').val(); var dec2 = (disc2 / 100).toFixed(2); //its convert 10 into 0.10 var mult2 = main2 * dec2; // gives the value for subtract from main value var discont2 = main2 - mult2; var discont3 = main2 - mult2; $('#result2').val(discont2); }); </script> <script> $(document).on("change keyup blur", "#chDiscount", function() { var main = $('#cBalance').val(); var disc = $('#chDiscount').val(); var dec = (disc / 100).toFixed(2); //its convert 10 into 0.10 var mult = main * dec; // gives the value for subtract from main value var discont = main - mult; $('#result').val(discont); }); </script> <!--<b><i class='fa fa-inr'></i> <span align='right' id="DisVal"></b></span><br><br>--> <!--<span id="sum">0</span><br>--> <input type="hidden" id="total_value" name="TotalAmt" /> <input type="hidden" id="Final_value1" name="FinalAmt" /> <input type="hidden" id="GSTFinalAmt" name="GSTFinalAmt" /> </td> </tr> <!--<tr>--> <!-- <td>GST Discount</td><td><b><i class='fa fa-inr'></i> <span align='right' id="gstAmt"></b></span></td>--> <!--</tr>--> </tfoot> </table> <?php $medicine_slot = "SELECT * FROM medicine_slot WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND action='Disperse'"; $qMS = mysqli_query($con,$medicine_slot); $rMS = mysqli_fetch_array($qMS); if($rMS['action']=='Disperse' ) ?> <b> <input id="addAll" type="submit" name="saveAmt" value="Pay" /><br /> </form> <?php ?> </table> <br> <script type="text/javascript" src="http://ajax.microsoft.com/ajax/jQuery/jquery-1.4.2.min.js"> </script> <script type="text/javascript"> $(function() { $("#addAll").click(function() { var add = 0; $(".price").each(function() { add += Number($(this).val()); }); // $("#val").text("Rs : " +add); $('#total_value').val(add); var Disadd = 0; $(".DisPrice").each(function() { Disadd += Number($(this).val()); }); // $("#val").text("Rs : " +add); $('#Final_value').val(Disadd); }); }); $(function() { $("#addAll").click(function() { }); }); // $(document).ready(function(){ // //iterate through each textboxes and add keyup // //handler to trigger sum event // $(".txt").each(function() { // $(this).keyup(function(){ // calculateSum(); // }); // }); // }); // function calculateSum() { // var sum = 0; // //iterate through each textboxes and add the values // $(".txt").each(function() { // //add only if the value is number // if(!isNaN(this.value) && this.value.length!=0) { // sum += parseFloat(this.value); // } // }); // //.toFixed() method will roundoff the final sum to 2 decimal places // $("#sum").html(sum.toFixed(2)); // $('#total_value').val(sum); // } var close = document.getElementsByClassName("closebtn"); var i; for (i = 0; i < close.length; i++) { close[i].onclick = function(){ var div = this.parentElement; div.style.opacity = "0"; setTimeout(function(){ div.style.display = "none"; }, 600); } } </script> <script> var table = document.getElementById("myTable"), sumVal = 0; $(".price").each(function() { sumVal += Number($(this).val()); }); document.getElementById("val").innerHTML = "" + sumVal; $('#total_value').val(sumVal); document.getElementById("val2").innerHTML = "" + sumVal; $('#total_value2').val(sumVal); document.getElementById("val2").innerHTML = "" + sumVal; $('#result').val(sumVal); document.getElementById("val2").innerHTML = "" + sumVal; $('#cBalance').val(sumVal); console.log(sumVal); </script> <script> ///////////////////Dis Price/////////////////// var table2 = document.getElementById("myTable"), DissumVal = 0; $(".DisPrice").each(function() { DissumVal += Number($(this).val()); }); document.getElementById("DisVal").innerHTML = "" + DissumVal; $('#Final_value1').val(DissumVal); console.log(DissumVal); </script> <script> ////////////////////GST Final Value////////////////// var table3 = document.getElementById("myTable"), sumGST = 0; $(".gst").each(function() { sumGST += Number($(this).val()); console.log(sumGST); }); document.getElementById("AddGST").innerHTML = "" + sumGST; $('#GSTFinalAmt').val(sumGST) console.log(sumGST); </script> <?php } ?>