Server IP : 162.240.98.243 / Your IP : 3.143.254.88 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/ |
Upload File : |
<?php session_start(); include("dbconnection.php"); require_once('../DBManager.php'); require_once('../patientmanager.php'); include("header.php"); include("dashboarddocument.php"); $medicine_slot ="SELECT * FROM medicine_slot WHERE batchno='$_GET[Batch_number]'"; $Qmedicine_slot = mysqli_query($con,$medicine_slot); $Rowmedicine_slot = mysqli_fetch_array($Qmedicine_slot); if(isset($_POST['CreateReturn'])) { $sql ="UPDATE `medicine_inventory` SET `totalQuatity`='$_POST[AddQty]' WHERE inventory_id='$_GET[inventory_id]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('Successfully');</script>"; if($_GET['Normal_care']=='Normal_care'){ echo "<script>window.location.replace('Medication_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Normal_care=$_GET[Normal_care]'); </script>"; }else{ echo "<script>window.location.replace('Medication_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'); </script>"; } } else { echo "Sorry, there was an error uploading your file."; } } if(isset($_POST['CreateReturn'])) { $a=$_POST['UpgradeAmt']; $b=$_POST['priceFinal']; $res=$a-$b; $sql1 ="UPDATE `medicine_slot` SET `ReturnQuantity`='$_POST[ReturnQuantity]',`UpgradeAmt`='$res', `action2`='Return',`upgradeQty`='$_POST[upgradeQty]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND medicine_id='$_GET[medicine_id]'"; if($qsql1 = mysqli_query($con,$sql1)) { echo "<script>alert('Qty Successfully');</script>"; echo "<script>window.location.replace('Medication_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'); </script>"; } else { echo "Sorry, there was an error uploading your file."; } } if(isset($_POST['CreateReturn'])) { $a=$_POST['UpgradeAmt']; $b=$_POST['priceFinal']; $res=$a-$b; $updated_at=date("F d, Y / h:i:s A"); $created_at=date("F d, Y / h:i:s A"); $sql1="INSERT INTO `RetuneMedicine`(`MedicineId`, `InventoryId`, `PrescriptionId`, `PatientId`, `ReturnQuantity`, `QuantityGiven`, `TotalQuatity`, `BatchNumber`, `AmountPaid`,`ReturnAmt`, `IncludedDiscount`,`entered_by`, `CreatedAt`, `UpdatedBy`) VALUES ('$_GET[medicine_id]','$_GET[inventory_id]','$_GET[prescriptionid]','$_GET[patientid]','$_POST[ReturnQuantity]','$_POST[upgradeQty]','','$_GET[Batch_number]','$_POST[priceFinal]','$res','$_POST[discount]','$_POST[entered_by]','$created_at','$updated_at')"; if($qsql1 = mysqli_query($con,$sql1)) { echo "<script>window.location.replace('Medication_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'); </script>"; } else { echo "Sorry, there was an error uploading your file."; } } ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <style> #loaderImg { position: absolute; top: 0; bottom: 0; left: 0; right: 0; margin: auto; border: 10px solid grey; border-radius: 50%; border-top: 10px solid black; width: 100px; height: 100px; animation: spin 1s linear infinite; z-index:10000000; } @keyframes spin { 0% { -webkit-transform: rotate(0deg); transform: rotate(0deg); } 100% { -webkit-transform: rotate(360deg); transform: rotate(360deg); } } </style> </div> </div> <div class="wrapper col4"> <div id="container"> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div> <form method="post" enctype='multipart/form-data'> <table id="myTable" class="table table-bordered table-hover" > <thead> <tr> <th><strong>Created Towards</strong></th> <th><strong>Medicine 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>MRP</strong></th> <th><strong>GST</strong></th> <th><strong>Status</strong></th> <th><strong><section class="content-header">Action</section> </strong></th> </tr> </thead> <?php include("dbconnection.php"); $sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { $sqlpatient2 = "SELECT * FROM medicine_slot WHERE prescriptionid='$_GET[prescriptionid]' AND action='Disperse' OR prescriptionid='$_GET[prescriptionid]' AND action='Paid'"; $qsqlpatient2 = mysqli_query($con,$sqlpatient2); while($rsp2 = mysqli_fetch_array($qsqlpatient2)) { $sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp2[entered_by]'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); while($rsn = mysqli_fetch_array($qsqlpatient1)) { $sql1 ="SELECT * FROM medicine_inventory WHERE medicine_id='$rsp2[medicine_id]' AND Batch_number='$_GET[batch]' "; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) { $sql191 ="SELECT * FROM medicine_stok WHERE medicine_id='$rh1[medicine_id]'"; $qsql191 = mysqli_query($con,$sql191); while($rh191 = mysqli_fetch_array($qsql191)) { if($rh191['Category']=='Injectable'){ $cat="Vial"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='IV Fluid'){ $cat="Bottle"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Capsule'){ $cat="Capsules"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Tablet'){ $cat="Tablets"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Syrup'){ $cat="Bottle"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Powder'){ $cat="Bottle"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Ointment'){ $cat="Tube"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Drop'){ $cat="Bottle"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Solution'){ $cat="Bottle"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } if($rh191['Category']=='Patch'){ $cat="Patch"; $sizefinal=$rh1[mrp]/$rh191[size]; $pricetotal1=$sizefinal*$rsp2[quantitygiven]; $pricetotal=round($pricetotal1); } echo " <tbody> <tr> <td> $rsp2[created_at] <br>$rsn[name] <input name='userno' class='name' type='hidden' value='$rsn[userno]' /><br> </td> <td> "; echo "<b></b>$rh191[DRUGS_name] "; echo "<br> <b>"; $disGST=$pricetotal/100; $GSTfinal1=$disGST*$rh1[gst]; $GSTfinal=round($GSTfinal1) ; $GRANDTOTAL=$rsp2[pricetotal]; echo " <br> <b>"; echo" <input class='DisPrice' id='DisPrice' type='hidden' name='DisPrice[]' value='$rsp2[pricetotal]'/> <input class='price' id='price' type='hidden' name='price[]' value='$pricetotal'/> <input name='DRUGS_name[]' class='DRUGS_name' type='hidden' value='$rh191[DRUGS_name]' /> <input name='Category[]' class='Category' type='hidden' value='$rh191[Category]' /> <input name='quantitygiven[]' id='qty' class='quantitygiven' type='hidden' value='$rsp2[quantitygiven]' /> <input name='Batch_number[]' class='Batch_number' type='hidden' value='$rh1[Batch_number]' /> <input name='HSN_No[]' class='HSN_No' type='hidden' value='$rh1[HSN_No]' /> <input name='GSTfinal[]' id='gst' class='gst' type='hidden' value='$GSTfinal' /> <input name='gstper[]' id='gstper' class='gstper' type='hidden' value='$rh1[gst]' /> <input name='expireDate[]' id='expireDate' class='expireDate' type='hidden' value='$rh1[Expiry_Date]' /> "; echo "</td> <td>$rh1[Batch_number]</td> <td>$rh1[HSN_No]</td> <td>$rh1[Expiry_Date]</td> <td> <input name='quantitygiven[]' id='qty' class='quantitygiven' type='text' value='$rsp2[quantitygiven]' /></td><td>"; echo "$pricetotal"; echo "</td><td><b>$rh1[gst] % </b><br> $GSTfinal </td> <td>"; $medicine_charge="SELECT * FROM medicine_charge Where status='1' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qMedicine_Charge=mysqli_query($con,$medicine_charge); $RowMedicineCharge=mysqli_fetch_assoc($qMedicine_Charge); $status=$RowMedicineCharge['status']; if($status == '1'){ echo "Paid"; } else{ echo "Due"; } echo "</td> <td><section class='content-header'>"; // echo "<a href='billing.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&srno=$rsp2[srno]' ><i class='fa fa-pencil-square-o' style='font-size:30px;'></i></a> "; // <a href='medicinebill.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&srno=$rsp2[srno]' ><i class='fa fa-eye' style='font-size:30px;'></i></a> | echo " <a href='billing.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&srno=$rsp2[srno]' ><i class='fa fa-pencil-square-o' style='font-size:30px;'></i></a> | <a href='add_medicine_qty.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&batch=$rh1[Batch_number]' >Return</a> "; echo " <br> </section></td> </tr> "; } } } } } ?> </tbody> <tfoot> <tr> <td colspan=9> <span style='float:right;'> <b>Gross Amt. :</b></span> <br> <span style='float:right;'> <b>Total Amt. :</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> <?php 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='text' name='Total_gst' size='2' id='result2' 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> "; ?> <br> <br> </div> <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; $('#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> </tfoot> </table> <?php $Medicine_charge=$con->query("SELECT * FROM `medicine_charge` WHERE prescriptionid=$_GET[prescriptionid] AND patientid=$_GET[patientid]"); $Row_MC=$Medicine_charge->fetch_assoc(); if($Row_MC['status']=='1'){ echo "<a href='showpage_medicine_invoice.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Normal_care=$_GET[Normal_care]' class='btn btn-success'>View invoice</a>"; ?> <?php }else{?> <b> <input id="addAll" type="submit" name="saveAmt" value="Pay" /><br /> <?php } ?> </form> <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> <p> </p> </div> </div> </div> <div class="clear"></div> </div> </div> <?php include("footer.php"); ?> <script> let modalBtns = [...document.querySelectorAll(".button")]; modalBtns.forEach(function(btn) { btn.onclick = function() { let modal = btn.getAttribute('data-modal'); document.getElementById(modal) .style.display = "block"; } }); let closeBtns = [...document.querySelectorAll(".close")]; closeBtns.forEach(function(btn) { btn.onclick = function() { let modal = btn.closest('.modal'); modal.style.display = "none"; } }); window.onclick = function(event) { if(event.target.className === "modal") { event.target.style.display = "none"; } } </script> <script> function drugload(drid) { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { document.getElementById("divdr").innerHTML = this.responseText; } }; xmlhttp.open("GET","loaddrug.php?drid="+drid,true); xmlhttp.send(); } </script> </body> </html> </div> <?php $sql12="SELECT * FROM medicine_inventory where inventory_id=$_GET[inventory_id]"; $result = $con->query($sql12); $row = mysqli_fetch_array($result); $sql2 ="SELECT * FROM medicine_stok WHERE medicine_id='$row[medicine_id]'"; $qsql2 = mysqli_query($con,$sql2); $rs2 = mysqli_fetch_array($qsql2); ?> <script> // function reSum<?php echo $_GET['inventory_id'] ?>() // { // var num1 = parseInt(document.getElementById("Num1<?php echo $_GET['inventory_id'] ?>").value); // var num2 = parseInt(document.getElementById("Num2<?php echo $_GET['inventory_id'] ?>").value); // document.getElementById("Sum<?php echo $_GET['inventory_id'] ?>").value = num1 + num2; // } function sum<?php echo $_GET['inventory_id'] ?>() { var txtFirstNumberValue = document.getElementById('txt1<?php echo $_GET['inventory_id'] ?>').value; var txtSecondNumberValue = document.getElementById('txt2<?php echo $_GET['inventory_id'] ?>').value; var txtFourthNumberValue = document.getElementById('txt4<?php echo $_GET['inventory_id'] ?>').value; var txtFifthNumberValue = document.getElementById('UpgradeAmt<?php echo $_GET['inventory_id'] ?>').value; var txtpriceFinalValue=document.getElementById('priceFinal<?php echo $_GET['inventory_id'] ?>').value; var result = parseInt(txtFirstNumberValue) + parseInt(txtSecondNumberValue); var TQty= parseInt(txtFourthNumberValue)-parseInt(txtFirstNumberValue); var DividePrice=parseInt(txtFifthNumberValue)/parseInt(txtFourthNumberValue); var FinalPrice=parseInt(DividePrice)*parseInt(txtFirstNumberValue); if (!isNaN(result)) { document.getElementById('txt3<?php echo $_GET['inventory_id'] ?>').value = result; } if (!isNaN(TQty)) { document.getElementById('txt5<?php echo $_GET['inventory_id'] ?>').value = TQty; } if (!isNaN(FinalPrice)) { document.getElementById('priceFinal<?php echo $_GET['inventory_id'] ?>').value = FinalPrice; } } </script> <?php ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#myForm').submit(function() { $('#loaderImg').show(); return true; }); }); </script>