| Server IP : 162.240.98.243 / Your IP : 3.145.50.222 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/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>