Server IP : 162.240.98.243 / Your IP : 3.145.60.202 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 include("dbconnection.php"); require_once('../DBManager.php'); require_once('../patientmanager.php'); include("header.php"); include("dashboarddocument.php"); if(isset($_POST['Action_med'])) { $sql="UPDATE medicinede SET Action_med='$_POST[Action_med]',status='$_POST[status]',batchno='$_POST[batchno]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND 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[action])) { 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 medicine_inventory SET totalQuatity='$_POST[SubQty]' WHERE inventory_id='$_POST[inventoryId]'"; if($qTQ = mysqli_query($con,$TotalQuantity)) { } else { echo "Sorry, there was an error uploading your file."; } } ?> <!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("hidden"); }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">Medication Order Timiline</a> <!-- Toggle Content to display --> <div class="toggle-content"> <p><?php include("Medication_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>Medication 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 medicinede WHERE prescriptionid='$_GET[prescriptionid]' AND Action_med='process'"; $qsql1 = mysqli_query($con,$sql1); while($re1 = mysqli_fetch_array($qsql1)) { $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 `medicine_stok` where medicine_id='$re1[DRUGS]'"); while($rms=$sql3->fetch_assoc()){ if($rms['Category']=='Injectable'){ $z=1; } if($rms['Category']=='IV Fluid'){ $z=1; } if($rms['Category']=='Capsule'){ $x=1; $y=$re1[duration]; $w=$re1[Frequency]; $a=$x*$y; $z=$a*$w; } if($rms['Category']=='Tablet'){ $x=1; $y=$re1[duration]; $w=$re1[Frequency]; $a=$x*$y; $z=$a*$w; } if($rms['Category']=='Syrup'){ $z=1; } if($rms['Category']=='Powder'){ $z=1; } if($rms['Category']=='Ointment'){ $z=1; } if($rms['Category']=='Drop'){ $z=1; } if($rms['Category']=='Solution'){ $z=1; } if($rms['Category']=='Patch'){ $z=1; } } 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[DRUGS])) { $sql ="SELECT * FROM medicine_stok WHERE medicine_id='$re1[DRUGS]'"; $qsql = mysqli_query($con,$sql); while($re2 = mysqli_fetch_array($qsql)) echo"$re2[DRUGS_name] ($re2[Category])"; echo""; } else { echo"$re1[DRUGS]"; } echo" <br><b>Dose :</b> $re1[Dose]<br><b>Route : </b>$re1[Route]<br>"; echo "<b>Frequency :</b> "; switch ($re1[Frequency]) { case '01': echo "OD (Once Daily)"; break; case '2': echo "BID/b.i.d. (twice a day)"; break; case '3': echo "TID/t.id. (three times a day)"; break; case '04': echo "QID/q.i.d. (four times a day)"; break; case '1': echo "QHS (every bedtime)"; break; case '6': echo "Q4h (every 4 hours)"; break; case '4': echo "Q4-6h (every 4 to 6 hours)"; break; case '1': echo "QWK (every week)"; break; default: echo ""; } echo"<br><b>Duration : </b> $re1[duration] "; switch ($re1[durationselect]) { case '1': echo "Days"; break; case '7': echo "Week"; break; case '28': echo "Month"; break; default: echo ""; } echo" </td> "; if($re1[availability] == 'Available'){ $sql21="SELECT * FROM medicine_slot WHERE medicine_id='$re1[DRUGS]' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsql21 = mysqli_query($con,$sql21); while($rs21 = mysqli_fetch_array($qsql21)) $sql3 ="SELECT * FROM medicine_inventory WHERE medicine_id='$re1[DRUGS]'"; $qsql3 = mysqli_query($con,$sql3); $re3 = mysqli_fetch_array($qsql3); $pavan=$rs21[srno]; echo " <form name='action' method='POST'><td>"; echo "<div name='hidden-panel$re3[inventory_id]' id='hidden-panel$re3[inventory_id]'>"; echo "<input type='number' value='$z' id='txt2$re3[inventory_id]' name='quantitygiven' onkeyup='sum$re3[inventory_id]();' maxlength='2' size='2' > $rms[Category] <br> "; echo "</div>"; ?> <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')); }); $("#Disperse").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> <input type='hidden' name="inventoryId" value="<?php echo $re3['inventory_id']; ?>" > <?php echo" <input type='text' id='txt1$re3[inventory_id]' value='$re3[totalQuatity]' onkeyup='sum$re3[inventory_id]();' style='width:25%;'/><br> <input type='text' id='txt3$re3[inventory_id]' name='SubQty' value='$re3[totalQuatity]' style='width:25%;'/> <select name='batchno' id='chosen_a$re3[inventory_id]' > <option value='' disabled selected>Batch No</option>"; $sql3 ="SELECT * FROM medicine_inventory WHERE medicine_id='$re1[DRUGS]'"; $qsql3 = mysqli_query($con,$sql3); while($re3 = mysqli_fetch_array($qsql3)) { echo" <option value='$re3[Batch_number]' data-id='$re3[totalQuatity]'>$re3[Batch_number]</option> "; } echo" </select>"; echo ""; echo" <input type='hidden' name='id' value='$re1[id]'></td> <td><input type='hidden' name='DRUGS' value='$re1[DRUGS]'> <input type='hidden' name='srno' value='$pavan'> <input type='submit' name='action' id='Disperse' value='Disperse'> <br><input type='submit' name='action' value='Refuse'> </form>"; }else{ echo " <form name='Action_med' method='POST'><td><input type='number' value='$z' name='status' maxlength='4' size='4'> <input type='hidden' name='id' value='$re1[id]'></td><td><input type='hidden' name='id' value='$re1[id]'><input type='submit' name='Action_med' value='Refuse'> </form> <a href='/hco/add_Medicine_in_Stock.php?id=$re1[id]' class='GFG'> Add Stock </a></td>"; } 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 --> </body> </html>