Server : LiteSpeed
System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User : claqxcrl ( 523)
PHP Version : 8.1.32
Disable Function : NONE
Directory : /home/claqxcrl/www/ondjoweb/admin/
|
Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory : /home/claqxcrl/www/ondjoweb/admin/ |
<?php
session_start();
include('includes/config.php');
error_reporting(0);
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
if($_GET['action']=='del' && $_GET['scid'])
{
$id=intval($_GET['scid']);
$query=mysqli_query($con,"update tblsubcategoria set Is_Active='0' where SubCategoryId='$id'");
$msg="Category deleted ";
}
// Code for restore
if($_GET['resid'])
{
$id=intval($_GET['resid']);
$query=mysqli_query($con,"update tblsubcategoria set Is_Active='1' where SubCategoryId='$id'");
$msg="Sub-Categoria restaurada com sucesso";
}
// Code for Forever deletionparmdel
if($_GET['action']=='perdel' && $_GET['scid'])
{
$id=intval($_GET['scid']);
$query=mysqli_query($con,"delete from tblsubcategoria where SubCategoryId='$id'");
$delmsg="Sub-Categoria eliminada permanentemente";
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<title> OndjoWEB | Gerir Sub-Categorias</title>
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/core.css" rel="stylesheet" type="text/css" />
<link href="assets/css/components.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
<link href="assets/css/pages.css" rel="stylesheet" type="text/css" />
<link href="assets/css/menu.css" rel="stylesheet" type="text/css" />
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="../plugins/switchery/switchery.min.css">
<script src="assets/js/modernizr.min.js"></script>
</head>
<body class="fixed-left">
<!-- Begin page -->
<div id="wrapper">
<!-- Top Bar Start -->
<?php include('includes/topheader.php');?>
<!-- ========== Left Sidebar Start ========== -->
<?php include('includes/leftsidebar.php');?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="content-page">
<!-- Start content -->
<div class="content">
<div class="container">
<div class="row">
<div class="col-xs-12">
<div class="page-title-box">
<h4 class="page-title">Gerir SubCategorias</h4>
<ol class="breadcrumb p-0 m-0">
<li>
<a href="#">Admin</a>
</li>
<li>
<a href="#">SubCategorias </a>
</li>
<li class="active">
Gerir SubCategorias
</li>
</ol>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- end row -->
<div class="row">
<div class="col-sm-6">
<?php if($msg){ ?>
<div class="alert alert-success" role="alert">
<strong>Sucesso!</strong> <?php echo htmlentities($msg);?>
</div>
<?php } ?>
<?php if($delmsg){ ?>
<div class="alert alert-danger" role="alert">
<strong>Oh pá!</strong> <?php echo htmlentities($delmsg);?></div>
<?php } ?>
</div>
<div class="row">
<div class="col-md-12">
<div class="demo-box m-t-20">
<div class="m-b-30">
<a href="add-subcategory.php">
<button id="addToTable" class="btn btn-success waves-effect waves-light">Adicionar <i class="mdi mdi-plus-circle-outline" ></i></button>
</a>
</div>
<div class="table-responsive">
<table class="table m-0 table-colored-bordered table-bordered-primary">
<thead>
<tr>
<th>#</th>
<th> Categoria</th>
<th>Sub Categoria</th>
<th>Descrição</th>
<th>Data de criação</th>
<th>Última actualização</th>
<th>Acção</th>
</tr>
</thead>
<tbody>
<?php
$query=mysqli_query($con,"Select tblcategoria.CategoryName as catname,tblsubcategoria.Subcategory as subcatname,tblsubcategoria.SubCatDescription as SubCatDescription,tblsubcategoria.PostingDate as subcatpostingdate,tblsubcategoria.UpdationDate as subcatupdationdate,tblsubcategoria.SubCategoryId as subcatid from tblsubcategoria join tblcategoria on tblsubcategoria.CategoryId=tblcategoria.id where tblsubcategoria.Is_Active=1");
$cnt=1;
$rowcount=mysqli_num_rows($query);
if($rowcount==0)
{
?>
<tr>
<td colspan="7" align="center"><h3 style="color:red">Sem registo</h3></td>
<tr>
<?php
} else {
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<th scope="row"><?php echo htmlentities($cnt);?></th>
<td><?php echo htmlentities($row['catname']);?></td>
<td><?php echo htmlentities($row['subcatname']);?></td>
<td><?php echo htmlentities($row['SubCatDescription']);?></td>
<td><?php echo htmlentities($row['subcatpostingdate']);?></td>
<td><?php echo htmlentities($row['subcatupdationdate']);?></td>
<td><a href="edit-subcategory.php?scid=<?php echo htmlentities($row['subcatid']);?>"><i class="fa fa-pencil" style="color: #29b6f6;"></i></a>
<a href="manage-subcategories.php?scid=<?php echo htmlentities($row['subcatid']);?>&&action=del"> <i class="fa fa-trash-o" style="color: #f05050"></i></a> </td>
</tr>
<?php
$cnt++;
}} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!--- end row -->
<div class="row">
<div class="col-md-12">
<div class="demo-box m-t-20">
<div class="m-b-30">
<h4><i class="fa fa-trash-o" ></i> SubCategorias eliminadas</h4>
</div>
<div class="table-responsive">
<table class="table m-0 table-colored-bordered table-bordered-danger">
<thead>
<tr>
<th>#</th>
<th> Categoria</th>
<th>Sub Categoria</th>
<th>Descrição</th>
<th>Data de criação</th>
<th>Última actualização</th>
<th>Acção</th>
</tr>
</thead>
<tbody>
<?php
$query=mysqli_query($con,"Select tblcategoria.CategoryName as catname,tblsubcategoria.Subcategory as subcatname,tblsubcategoria.SubCatDescription as SubCatDescription,tblsubcategoria.PostingDate as subcatpostingdate,tblsubcategoria.UpdationDate as subcatupdationdate,tblsubcategoria.SubCategoryId as subcatid from tblsubcategoria join tblcategoria on tblsubcategoria.CategoryId=tblcategoria.id where tblsubcategoria.Is_Active=0");
$cnt=1;
$rowcount=mysqli_num_rows($query);
if($rowcount==0)
{
?>
<tr>
<td colspan="7" align="center"><h3 style="color:red">Sem registo</h3></td>
<tr>
<?php
} else {
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<th scope="row"><?php echo htmlentities($cnt);?></th>
<td><?php echo htmlentities($row['catname']);?></td>
<td><?php echo htmlentities($row['subcatname']);?></td>
<td><?php echo htmlentities($row['SubCatDescription']);?></td>
<td><?php echo htmlentities($row['subcatpostingdate']);?></td>
<td><?php echo htmlentities($row['subcatupdationdate']);?></td>
<td><a href="manage-subcategories.php?resid=<?php echo htmlentities($row['subcatid']);?>"><i class="ion-arrow-return-right" title="Restaurar sub-categoria"></i></a>
<a href="manage-subcategories.php?scid=<?php echo htmlentities($row['subcatid']);?>&&action=perdel"> <i class="fa fa-trash-o" style="color: #f05050"></i></a> </td>
</tr>
<?php
$cnt++;
} }?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div> <!-- container -->
</div> <!-- content -->
<?php include('includes/footer.php');?>
</div>
</div>
<!-- END wrapper -->
<script>
var resizefunc = [];
</script>
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/detect.js"></script>
<script src="assets/js/fastclick.js"></script>
<script src="assets/js/jquery.blockUI.js"></script>
<script src="assets/js/waves.js"></script>
<script src="assets/js/jquery.slimscroll.js"></script>
<script src="assets/js/jquery.scrollTo.min.js"></script>
<script src="../plugins/switchery/switchery.min.js"></script>
<!-- App js -->
<script src="assets/js/jquery.core.js"></script>
<script src="assets/js/jquery.app.js"></script>
</body>
</html>
<?php } ?>