| Server IP : 162.240.98.243 / Your IP : 3.141.38.121 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/Pharmacy/ |
Upload File : |
<?php
session_start();
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
require_once('../../patientmanager.php');
include 'menu.php';
include 'header.php';
include("../dbconnection.php");
?>
<div class='content-wrapper'>
<!-- Content Header (Page header) -->
<section class='content-header'>
<?php
session_start();
include("../dbconnection.php");
require_once('../../DBManager.php');
require_once("../../LoginManager.php");
require_once('../../patientmanager.php');
if(isset($_POST[MasterCategory]))
{
$updated_at=date("F d, Y / h:i:s A");
$created_at=date("F d, Y / h:i:s A");
$Medicine = $con->query("SELECT MCategory FROM implant_category WHERE MCategory = '$_POST[MCategory]'");
$numrows=mysqli_num_rows($Medicine);
if($numrows > 0){
echo "<script>alert('Already Exists');</script>";
}else{
$implant_category=$con->query("INSERT INTO `implant_category`( `MCategory`,`created_at`) VALUES ('$_POST[MCategory]','$created_at')");
if($implant_category==1){
echo "<script>alert('Add successfully..');</script><script>window.location='AddMasterCategory.php'</script>;</script>";
}
}}
if(isset($_GET[delid]))
{
$ConsumableStock =$con->query("UPDATE implant_category SET status='0' WHERE id='$_GET[delid]'");
if($ConsumableStock == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>window.location='AddMasterCategory.php'</script>;</script>";
}
}
?>
<!DOCTYPE html>
<html> <head>
<title>Master Category</title>
<style>
.modal {
display: none;
position: fixed;
z-index: 8;
left: 0;
top: 0;
width: 100%;
height: 100%;
overflow: auto;
background-color: rgb(0, 0, 0);
background-color: rgba(0, 0, 0, 0.4);
}
.modal-content {
margin: 50px auto;
border: 1px solid #999;
width: 60%;
}
h2,p {
margin: 0 0 20px;
font-weight: 400;
}
.form1 {
padding: 25px;
margin: 25px;
box-shadow: 0 2px 5px #f5f5f5;
background: #eee;
}
input,
textarea, select {
width: 100%;
padding: 6px;
margin-bottom: 20px;
border: 1px solid #1c87c9;
outline: none;
}
.contact-form button {
width: 100%;
padding: 10px;
border: none;
background: #1c87c9;
font-size: 16px;
font-weight: 400;
color: #fff;
}
button:hover {
background: #2371a0;
}
.close {
color: #aaa;
float: right;
font-size: 58px;
font-weight: bold;
}
.close:hover,
.close:focus {
color: black;
text-decoration: none;
cursor: pointer;
}
button.button {
display: inline-block;
border-bottom: #02274a 1px solid;
font-size: 19px;
cursor: pointer;
}
button.button:hover {
border-bottom: #a99567 1px solid;
color: #a99567;
}
</style>
<style>
/* Automatic Serial Number Row */
.css-serial {
counter-reset: serial-number; /* Set the serial number counter to 0 */
}
.css-serial td:first-child:before {
counter-increment: serial-number; /* Increment the serial number counter */
content: counter(serial-number); /* Display the counter */
}
</style>
</head>
<body>
<h2 Align="center">Master Category </h2>
<input type="search" class="light-table-filter" data-table="order-table" placeholder="Search" />
<p align="right">
<button class="button" data-modal="modalOne"> Add Master Category</button>
</p>
<table id="example2" class="order-table table table-bordered table-hover css-serial">
<thead>
<tr>
<th>SR No</th>
<th>Master Category</th>
<th>Action</th>
</tr>
</thead>
<?php
include("../dbconnection.php");
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql2 ="SELECT * FROM `implant_category` WHERE status='1' ORDER BY `id` DESC";
$qsql2 = mysqli_query($con,$sql2);
while($rs2 = mysqli_fetch_array($qsql2))
{
echo " <tbody>
<tr>
<td> </td>
<td> <b><b></b>$rs2[MCategory]
</td>
<td width='20%'>
<a href='edit_masterCategory.php?id=$rs2[id]'> <i class='fa fa-pencil-square-o' style='font-size:20px; color:blue;padding:20px;'></i></a>
<a href='AddMasterCategory.php?delid=$rs2[id]')'> <i class='fa fa-trash-o' style='font-size:20px; color:red;padding:20px; '></i> </a>
</td>
</tr>
";
}
?> </tbody>
<tfoot>
</tfoot>
</table>
<div id="modalOne" class="modal">
<div class="modal-content">
<div class="contact-form">
<a class="close">×</a>
<form class='form1' name="MasterCategory" method="post">
<a href='AddImplantCategory.php' style='float:right;'><i class="fa fa-plus-circle" aria-hidden="true"></i> Add Missing Category</a><br>
<label>Name of Master Category</label>
<input type="text" placeholder="Name of Master Category" name="MCategory" id="MCategory" class="form-control" required/>
<input type="submit" value="Add" name="MasterCategory">
</form>
</div> </div> </div>
<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>
<script>
function cotegory(ctid)
{
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("divct").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadcotegory.php?ctid="+ctid,true);
xmlhttp.send();
}
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>
$(document).ready(function () {
$('select').selectize({
sortField: 'text'
});
});
</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />
<script>
$(document).ready(function(){
$('#Category').on('change',function(){
var selectedText = $(this).children(':selected').text();
$('#sometext').val(selectedText);
});
});
</script>
</body>
</html>