| Server IP : 162.240.98.243 / Your IP : 18.118.226.66 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("../LoginManager.php");
require_once('../patientmanager.php');
include("header.php");
?>
<!DOCTYPE html>
<html> <head>
<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>
<title>Medicine in Stock</title>
</head>
<body>
<h2 Align="center">Medicine in Stock </h2>
</tbody>
<tfoot>
</tfoot>
</table>
<form action="actioninventoryfinal.php" method="POST">
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<h4 align='center'>$rs[DRUGS_name]-$rs[Dose]$rs[dose_value]</h4>
";
}
?>
<table id='example2' class='table table-bordered table-hover table-tbody'>
<tr> <th>Medication Details</th>
<th>Action</th></tr>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <tr>";
echo "<td> <b>Date & Time : </b>$rs[created_at]<br><b>Drug : </b>
";
if (is_numeric($rs[DRUGS]))
{
$sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rs[DRUGS]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
echo"$rs1[DRUGS_name]";
}
else
{
echo"$rs[DRUGS]";
}
echo" <br><b>Dose : </b>$rs[Dose]<br><b>Route : </b>$rs[Route]<br>"; echo "<b>Frequency :</b> ";
switch ($rs[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 '0.143':
echo "QWK (every week)";
break;
default:
echo "";
} echo"<br><b>Duration : </b> $rs[duration] ";
switch ($rs[durationselect]) {
case '1':
echo "Days";
break;
case '7':
echo "Week";
break;
case '28':
echo "Month";
break;
default:
echo "";
}
echo"
</td>";
echo"
<td> <a href='medication/$rs[potential]'>Edit</a>|<form method='post' action='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' name='status'><input type='submit' name='status' Value='Remove'></form></td>
</tr>
";
}
?>
<tr>
<td><label>Drug Name</label> <input onkeyup="this.value = this.value.toUpperCase();" onchange="drugload(this.value)" name='DRUGS' 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 medicine_stok WHERE admin_id='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<option value>Select one...</option>
<option value='$rs[medicine_id]'>$rs[DRUGS_name]-$rs[Dose]</option>
";
}
}
?>
</datalist>
<div id='divdr'>
<label>Dose</label>
<input type="text" placeholder="In mg" name="Dose" id="dose" class="form-control" />
<label>Cotegory</label>
<select onchange="cotegory(this.value)" class="form-control" name="Category" id="Category">
<option value="" disabled selected>Category </option>
<option value="Injectable">Injectable </option>
<option value="IV Fluid">IV Fluid </option>
<option value="Capsule">Capsule </option>
<option value="Tablet">Tablet </option>
<option value="Syrup">Syrup </option>
<option value="Powder">Powder </option>
<option value="Ointment">Ointment</option>
<option value="Drop">Drop</option>
<option value="Solution">Solution</option>
<option value="Patch">Patch</option>
</select>
</div>
<label>Route</label>
<select class="form-control" name="Route" id="Route" name="Route">
<option value="" disabled selected>Route </option>
<option value="Orally">Orally</option>
<option value="IV/IM">IV/IM</option>
<option value="Sublingually/ Buccally">Sublingually/ Buccally</option>
<option value="Vaginally">Vaginally</option>
<option value="Ocular/ Otic"> Ocular/ Otic </option>
<option value="Nasally">Nasally</option>
<option value="Inhalation/Nebulization">Inhalation/Nebulization</option>
<option value="cutaneously/systemic">cutaneously/systemic</option>
<option value="transdermally">transdermally</option>
</select>
<label> Frequency</label>
<select class="form-control"name="Frequency" id="Frequency" class="form-control">
<option value="" disabled selected>Frequency </option>
<option value="01">OD (Once Daily)</option>
<option value="2">BID/b.i.d. (twice a day)</option>
<option value="3">TID/t.id. (three times a day)</option>
<option value="04">QID/q.i.d. (four times a day)</option>
<option value="1"> QHS (every bedtime) </option>
<option value="6">Q4h (every 4 hours)</option>
<option value="4">Q4-6h (every 4 to 6 hours)</option>
<option value="0.143">QWK (every week)</option>
</select>
<div class="account-details">
<div>
<label> Duration</label>
<select class="form-control" name="durationselect" class="form-control">
<option value="" disabled selected>Duration </option>
<option value="1">Days</option>
<option value="7">Week </option>
<option value="28">Month </option>
</select>
</div>
<div>
<label>.</label>
<input type="number" name="duration">
</div>
</div>
<label>Potential side effects</label>
<input type="text" placeholder="Potential side effects" name="potential">
<input type="hidden" name="status" value="Active">
<input type="hidden" name="poa" value="Opd_Medicine" >
</td>
</tr>
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'>
";
}
?> <?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'>
";
}
?> <?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'>
";
}
?> <?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'>
";
}
?> <?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'>
";
}
?>
</table>
<script>
let lineNo = 1;
$(document).ready(function () {
$(".add-row").click(function () {
markup = "<tr><td width='90%'><div> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'> <label>Potential side effects</label> <input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'></div></td>"
"</tr>";
tableBody = $(".table-tbody");
tableBody.append(markup);
lineNo++;
});
});
</script>
<br> <br>
<input type="button" align="right" value="Add More" class="add-row">
<br> <br>
<input type="submit" value="Submit">
</form>
</div> </div> </div>
</body>
</html>