Server IP : 162.240.98.243 / Your IP : 3.139.82.4 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 include("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../patientmanager.php'); include("header.php"); include("dashboard_pharma.php"); if(isset($_POST['Action_med'])) { $sql ="UPDATE consumable_slot SET action_consumable='$_POST[Action_med]',status='$_POST[status]',batchno='$_POST[batchno]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Con_Slot_id='$_POST[id]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('Successfully Submit');</script>"; } else { echo "Sorry, there was an error uploading your file."; } } ?> <?php include("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../patientmanager.php'); include("header.php"); if(isset($_POST[opdmedicine])) { $updated_at=date("F d, Y / h:i:s A"); $created_at=date("F d, Y / h:i:s A"); $consumable_slot=$con->query("INSERT INTO `consumable_slot`( `prescriptionid`, `patientid`, `consumable_id`, `admin_id`, `slot_id`, `qtyGiven`, `UpdateQty`, `ReturnQty`, `POA`, `action_consumable`, `Dr_Id`, `entered_by`, `created_at`, `Updated_by`, `DisperseBy`) VALUES ('$_GET[prescriptionid]','$_GET[patientid]','$_POST[Consumable_id]','$_POST[Admin_id]','Null','$_POST[Quantity]','Null','Null','$_POST[poa]','process','$_POST[drid]','$_POST[Admin_id]','$created_at','$updated_at','Pharmacy')"); echo $consumable_slot; if($consumable_slot==1){ echo "<script>alert('Consumable add successfully..');</script><script>window.location='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</script>"; } } if(isset($_POST[action])) { $sql ="UPDATE consumable_slot SET action_consumable='$_POST[action]', qtyGiven='$_POST[quantitygiven]', UpdateQty='$_POST[SubQty]', batchno='$_POST[batchno]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Con_Slot_id='$_POST[srno]'"; if($qCS = mysqli_query($con,$sql)) { } else { echo "Sorry, there was an error uploading your file."; } // PatientManager::medicineslotupdate("$_GET[prescriptionid]","$_GET[patientid]","$_GET[medicine_id]","$_POST[admin_id]","$_POST[quantitygiven]","$_POST[slot_id]","$_POST[price]","$_POST[pricetotal]","$_POST[action]","$_POST[batchno]","$_POST[entered_by]"); } if(isset($_POST['action'])) { $TotalQuantity="UPDATE consumable_inventory SET totalQty='$_POST[SubQty]' WHERE batchno='$_POST[batchno]'"; if($qTQ = mysqli_query($con,$TotalQuantity)) { } else { echo "Sorry, there was an error uploading your file."; } } if(isset($_GET['id'])) { $consumable_slot="UPDATE `consumable_slot` SET `status`='0',action_consumable='Refuse' WHERE `Con_Slot_id`='$_GET[id]' AND `prescriptionid`='$_GET[prescriptionid]' AND `patientid`='$_GET[patientid]'"; if($qMD = mysqli_query($con,$consumable_slot)) { header("Location:Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]"); } } ?> <!DOCTYPE html> <html> <head> <script src="../js/jquery.min.js"></script> <script type="text/javascript"> jQuery(document).ready(function($) { // Find the toggles and hide their content $('.toggle').each(function(){ $(this).find('.toggle-content').hide(); }); // When a toggle is clicked (activated) show their content $('.toggle a.toggle-trigger').click(function(){ var el = $(this), parent = el.closest('.toggle'); if( el.hasClass('active') ) { parent.find('.toggle-content').slideToggle(); el.removeClass('active'); } else { parent.find('.toggle-content').slideToggle(); el.addClass('active'); } return false; }); }); //End </script> <!-- Toggle CSS --> <style type="text/css"> /* Main toggle */ .toggle { font-size: 13px; line-height:20px; font-family: "HelveticaNeue", "Helvetica Neue", Helvetica, Arial, sans-serif; background: #ffffff; /* Main background */ margin-bottom: 10px; border: 1px solid #e5e5e5; -webkit-border-radius: 5px; -moz-border-radius: 5px; border-radius: 5px; } /* Toggle Link text */ .toggle a.toggle-trigger { display:block; padding: 10px 10px 10px 10px; position:relative; text-decoration: none; color: #666; } /* Toggle Link hover state */ .toggle a.toggle-trigger:hover { opacity: .8; text-decoration: none; } /* Toggle link when clicked */ .toggle a.active { text-decoration: none; border-bottom: 1px solid #e5e5e5; -webkit-box-shadow: 0 8px 6px -6px #ccc; -moz-box-shadow: 0 8px 6px -6px #ccc; box-shadow: 0 8px 6px -6px #ccc; color: #000; } /* Lets add a "-" before the toggle link */ .toggle a.toggle-trigger:before { content: "-"; /* You can add any symbol, font icon, or graphic icon */ margin-right: 3px; font-size: 1.3em; } /* When the toggle is active, change the "-" to a "+" */ .toggle a.active.toggle-trigger:before { content: "+"; } /* The content of the toggle */ .toggle .toggle-content { padding: 10px 10px 10px 10px; color:#666; } .GFG { background-color: white; border: 1px solid black; color: black; padding: 5px 10px; text-align: center; display: inline-block; font-size: 20px; margin: 10px 10px 10px 10px; cursor: pointer; text-decoration:none; } </style> <script> function selection(){ var selected=document.getElementById("select1").value; if(selected==0){ document.getElementById("input1").removeAttribute("text"); }else{ //elsewhere actions } } </script> <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script> <script> $( function() { $.widget( "custom.combobox", { _create: function() { this.wrapper = $( "<span>" ) .addClass( "custom-combobox" ) .insertAfter( this.element ); this.element.hide(); this._createAutocomplete(); this._createShowAllButton(); }, _createAutocomplete: function() { var selected = this.element.children( ":selected" ), value = selected.val() ? selected.text() : ""; this.input = $( "<input>" ) .appendTo( this.wrapper ) .val( value ) .attr( "title", "" ) .addClass( "custom-combobox-input ui-widget ui-widget-content ui-state-default ui-corner-left" ) .autocomplete({ delay: 0, minLength: 0, source: $.proxy( this, "_source" ) }) .tooltip({ classes: { "ui-tooltip": "ui-state-highlight" } }); this._on( this.input, { autocompleteselect: function( event, ui ) { ui.item.option.selected = true; this._trigger( "select", event, { item: ui.item.option }); }, autocompletechange: "_removeIfInvalid" }); }, _createShowAllButton: function() { var input = this.input, wasOpen = false; $( "<a>" ) .attr( "tabIndex", -1 ) .attr( "title", "Show All Items" ) .tooltip() .appendTo( this.wrapper ) .button({ icons: { primary: "ui-icon-triangle-1-s" }, text: false }) .removeClass( "ui-corner-all" ) .addClass( "custom-combobox-toggle ui-corner-right" ) .on( "mousedown", function() { wasOpen = input.autocomplete( "widget" ).is( ":visible" ); }) .on( "click", function() { input.trigger( "focus" ); // Close if already visible if ( wasOpen ) { return; } // Pass empty string as value to search for, displaying all results input.autocomplete( "search", "" ); }); }, _source: function( request, response ) { var matcher = new RegExp( $.ui.autocomplete.escapeRegex(request.term), "i" ); response( this.element.children( "option" ).map(function() { var text = $( this ).text(); if ( this.value && ( !request.term || matcher.test(text) ) ) return { label: text, value: text, option: this }; }) ); }, _removeIfInvalid: function( event, ui ) { // Selected an item, nothing to do if ( ui.item ) { return; } // Search for a match (case-insensitive) var value = this.input.val(), valueLowerCase = value.toLowerCase(), valid = false; this.element.children( "option" ).each(function() { if ( $( this ).text().toLowerCase() === valueLowerCase ) { this.selected = valid = true; return false; } }); // Found a match, nothing to do if ( valid ) { return; } // Remove invalid value this.input .val( "" ) .attr( "title", value + " didn't match any item" ) .tooltip( "open" ); this.element.val( "" ); this._delay(function() { this.input.tooltip( "close" ).attr( "title", "" ); }, 2500 ); this.input.autocomplete( "instance" ).term = ""; }, _destroy: function() { this.wrapper.remove(); this.element.show(); } }); $( "#combobox" ).combobox(); $( "#toggle" ).on( "click", function() { $( "#combobox" ).toggle(); }); } ); </script> </head> <h3><i class="fa fa-angle-right"></i> Medication Order</h3> <style> form{ margin: 20px 0; } form input, button{ padding: 5px; } table{ width: 100%; margin-bottom: 20px; border-collapse: collapse; } table, th, td{ border: 1px solid #cdcdcd; } table th, table td{ padding: 10px; text-align: left; } <style> table{ border: solid 1px gray; width: 100%; } </style> </head> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div class="toggle"> <!-- Toggle Link --> <a href="#" title="Title of Toggle" class="toggle-trigger">Consumable Order Timiline</a> <!-- Toggle Content to display --> <div class="toggle-content"> <p><?php include("Consumable_order_timline.php"); ?></p> </div><!-- .toggle-content (end) --> </div><!-- .toggle (end) --> <!-- Toggle #2 --> <input type="search" class="light-table-filter" data-table="order-table" placeholder="Search"> <div id="container"> <table border="1" class="order-table"> <tbody> <tr> <th>Date & Time </th> <th>Consumable Details</th> <th>Quantity</th> <th style='width:25%;'>Action</th> </tr> </tbody> <tr> <?php include("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql1 ="SELECT * FROM consumable_slot WHERE prescriptionid='$_GET[prescriptionid]' AND action_consumable='process' AND status='1'"; $qsql1 = mysqli_query($con,$sql1); while($re1 = mysqli_fetch_array($qsql1)) { $sql3 =$con->query("SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'"); $re3=$sql3->fetch_assoc(); ?> <script> function sum<?php echo $re3['inventory_id'] ?>() { var txtFirstNumberValue = document.getElementById('txt1<?php echo $re3['inventory_id'] ?>').value; var txtSecondNumberValue = document.getElementById('txt2<?php echo $re3['inventory_id'] ?>').value; var result = parseInt(txtFirstNumberValue) - parseInt(txtSecondNumberValue); if (!isNaN(result)) { document.getElementById('txt3<?php echo $re3['inventory_id'] ?>').value = result; } } $(document).ready(function () { $("#chosen_a<?php echo $re3['inventory_id'] ?>").change(function () { $('#txt1<?php echo $re3['inventory_id'] ?>').val($('#chosen_a<?php echo $re3['inventory_id'] ?> option:selected').data('id')); }); $("#ValDisperse").click(function() { var num1 = $("#txt1<?php echo $re3['inventory_id'] ?>").val(); var num2 = $("#txt2<?php echo $re3['inventory_id'] ?>").val(); var answer = parseInt(num1) - parseInt(num2); //alert(answer); $("#txt3<?php echo $re3['inventory_id'] ?>").val(answer); }); }); $(document).ready(function(){ }) </script> <?php $sql2 ="SELECT * FROM site_users WHERE userno='$re1[entered_by]'"; $qsql2 = mysqli_query($con,$sql2); while($re = mysqli_fetch_array($qsql2)) { $sql3=$con->query("SELECT * FROM `consumable_stock` where Consumable_id='$re1[consumable_id]'"); while($rms=$sql3->fetch_assoc()){ if($rms['Category']==$rms['Category']){ $conqty=$re1['qtyGiven']; } } echo " <td><b>Created at:</b> $re1[created_at] <br><b>Created By:</b>$re[name] </td><td><b>Name :</b>"; if (is_numeric($re1[consumable_id])) { $sql ="SELECT * FROM consumable_stock WHERE Consumable_id='$re1[consumable_id]'"; $qsql = mysqli_query($con,$sql); while($re2 = mysqli_fetch_array($qsql)) echo"$re2[ConsumableName] ($re2[Category])"; echo""; } else { echo"$re1[consumable_id]"; } echo" </td> "; if($re1[status] == '1'){ $sql21="SELECT * FROM consumable_slot WHERE consumable_id='$re1[consumable_id]' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsql21 = mysqli_query($con,$sql21); while($rs21 = mysqli_fetch_array($qsql21)) $pavan=$rs21[Con_Slot_id]; echo " <form name='action' method='POST'><td>"; echo " <select name='batchno' id='chosen_a$re3[inventory_id]' required> <option value='' disabled selected required>Batch No</option>"; $sql3 ="SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'"; $qsql3 = mysqli_query($con,$sql3); while($batch = mysqli_fetch_array($qsql3)) { echo" <option value='$batch[batchno]' data-id='$batch[totalQty]'>$batch[batchno]</option> "; } echo" </select>"; echo "<div name='text-panel$re3[inventory_id]' id='text-panel$re3[inventory_id]'>"; echo "<input type='hidden' name='inventoryId' value='$re3[inventory_id]'/ > <input type='number' required value='$conqty' id='txt2$re3[inventory_id]' name='quantitygiven' onkeyup='sum$re3[inventory_id]();' maxlength='2' size='2' style='margin-top:12px'> $rms[Category] <br> <input type='hidden' id='txt1$re3[inventory_id]' value='$re3[totalQty]' onkeyup='sum$re3[inventory_id]();' style='width:25%;'/><br> <input type='hidden' id='txt3$re3[inventory_id]' name='SubQty' value='$re3[totalQty]' style='width:25%;'/>"; echo "</div>"; // echo "<br> <input type='number' value='$z' name='quantitygiven' maxlength='2' size='2' style='margin-top:12px;' > $rms[Category]"; echo" <input type='hidden' name='id' value='$re1[Con_Slot_id]'></td> <td><input type='hidden' name='consumable_id' value='$re1[consumable_id]'> <input type='hidden' name='srno' value='$pavan'> "; echo " <input type='submit' name='action' value='Disperse' id='ValDisperse' class='btn btn-success'> <br>"; // echo "<input type='text' name='deActiveId' value='$re1[id]'> <br> <input type='submit' name='action' value='Refuse' class='btn btn-info'>"; echo "<a href='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$re1[Con_Slot_id]' class='btn btn-info' style='margin-top:5px; width:97%;'>Refuse</a>"; echo " </form>"; }else{ echo " <form name='action' method='POST'><td>"; echo " <select name='batchno' id='chosen_a$re3[inventory_id]' required> <option value='' disabled selected required>Batch No</option>"; $sql3 ="SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'"; $qsql3 = mysqli_query($con,$sql3); while($batch = mysqli_fetch_array($qsql3)) { echo" <option value='$batch[batchno]' data-id='$batch[totalQty]'>$batch[batchno]</option> "; } echo" </select>"; echo "<div name='text-panel$re3[inventory_id]' id='text-panel$re3[inventory_id]'>"; echo "<input type='hidden' name='inventoryId' value='$re3[inventory_id]'/ > <input type='number' required value='$z' id='txt2$re3[inventory_id]' name='quantitygiven' onkeyup='sum$re3[inventory_id]();' maxlength='2' size='2' style='margin-top:12px'> $rms[Category] <br> <input type='hidden' id='txt1$re3[inventory_id]' value='$re3[totalQty]' onkeyup='sum$re3[inventory_id]();' style='width:25%;'/><br> <input type='hidden' id='txt3$re3[inventory_id]' name='SubQty' value='$re3[totalQty]' style='width:25%;'/>"; echo "</div>"; // echo "<br> <input type='number' value='$z' name='quantitygiven' maxlength='2' size='2' style='margin-top:12px;' > $rms[Category]"; echo" <input type='hidden' name='id' value='$re1[Con_Slot_id]'></td> <td><input type='hidden' name='consumable_id' value='$re1[consumable_id]'> <input type='hidden' name='srno' value='$pavan'> "; echo " <input type='submit' name='action' value='Disperse' id='ValDisperse' class='btn btn-success'> <br>"; // echo "<input type='text' name='deActiveId' value='$re1[id]'> <br> <input type='submit' name='action' value='Refuse' class='btn btn-info'>"; echo "<a href='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$re1[Con_Slot_id]' class='btn btn-info' style='margin-top:5px; width:97%;'>Refuse</a>"; echo " </form>"; } echo" </td> </tr> "; } } ?> <table id="example2" id ="demo" class="table table-bordered table-hover"> <?php $sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { echo " <tbody> "; } ?> </tbody> </table> <!--new medicine --> <!-- Button trigger modal --> <button type="button" class="btn btn-primary" data-toggle="modal" data-target="#exampleModal" style='height:40px;width:200px; float:right;'> Add Consumable </button> <!-- Modal --> <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-text="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <center> <h3 class="modal-title" id="exampleModalLabel" style='height:auto;width:auto;float:left;text-align:center;'><b>Add Consumable Order</b></h3></center> <button type="button" class="close" data-dismiss="modal" aria-label="Close" style='height:auto;width:auto;float:right;'> <span aria-text="true">×</span> </button> </div> <div class=""> <form class='form1' name="opdmedicine" id="myForm" method="post"> <?php $sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo"<input type='hidden' name='drid' value='$rs[Admitted_Under]'>"; $sql1 ="SELECT * FROM opdslip WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql1 = mysqli_query($con,$sql1); while($rs1 = mysqli_fetch_array($qsql1)) { echo"<input type='hidden' name='treatmentid' value='$rs1[tratment]'>"; } } ?> <label>Consumable Name</label> <input onkeyup="this.value = this.value.toUpperCase();" onchange="drmdiload(this.value)" name='ConsumableName' type='text' list='DRUGS'> <datalist name='DRUGS' id='DRUGS'> <?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 consumable_stock WHERE Admin_id='$re[entered_by]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo " <option value='$rs[Consumable_id]'>$rs[ConsumableName]</option> "; } } ?> </datalist> <div id='divmedidr'> </div> <label>Quantity</label> <input type="text" placeholder="Quantity" name="Quantity"> <input type="hidden" name="status" value="Active"> <input type="hidden" name="poa" value="IPD_Consumable" > <input type="submit" value="Add" class="btn btn-primary" style='height:40px;width:100px' name="opdmedicine"> </form> </div> <div class="modal-footer"> </div> </div> </div> </div> <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 drmdiload(drmeid) { 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("divmedidr").innerHTML = this.responseText; } }; xmlhttp.open("GET","loadConsumable.php?drmeid="+drmeid,true); xmlhttp.send(); } </script> <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 drmdiload(drmeid) { 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("divmedidr").innerHTML = this.responseText; } }; xmlhttp.open("GET","loadConsumable.php?drmeid="+drmeid,true); xmlhttp.send(); } </script> </body> </html>