|
Server IP : 145.79.210.100 / Your IP : 216.73.216.101 Web Server : LiteSpeed System : Linux in-mum-web1954.main-hosting.eu 5.14.0-570.26.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Jul 16 09:12:04 EDT 2025 x86_64 User : u474798400 ( 474798400) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u474798400/domains/excentia.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include('config.php');
include('checksession.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>AdminLTE 3 | Gallery</title>
<!-- Google Font: Source Sans Pro -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
<!-- Font Awesome -->
<link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
<!-- Ekko Lightbox -->
<link rel="stylesheet" href="plugins/ekko-lightbox/ekko-lightbox.css">
<!-- Theme style -->
<link rel="stylesheet" href="dist/css/adminlte.min.css">
<link rel="stylesheet" href="plugins/summernote/summernote-bs4.min.css">
<link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
<link rel="stylesheet" href="last/summernote-bs4.min.css">
<style>
#example2_paginate{float: right; margin: 0 20px 0 0;}
#example2_info{float: left; margin: 0 0 0 20px;}
.dataTables_filter{
float:right;
margin-right:10px;
}
</style>
</head>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
<!-- Left navbar links -->
<!-- Right navbar links -->
<ul class="navbar-nav ml-auto">
<!-- Navbar Search -->
<li><a href="logout.php" class="btn btn-block btn-danger">Logout</a></li>
</ul>
</nav>
<!-- Navbar -->
<!-- /.navbar -->
<!-- Main Sidebar Container -->
<aside class="main-sidebar sidebar-dark-primary elevation-4">
<!-- Brand Logo -->
<a href="dashboard.php" class="brand-link">
<img src="last/logo.jpg" alt="salient Logo" class="brand-image img-circle elevation-3" style="opacity: .8">
<span class="brand-text font-weight-light">salient</span>
</a>
<!-- Sidebar -->
<!-- /.sidebar -->
<?php include 'sitebar.php';?>
</aside>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card card-primary">
<div class="card-header">
<h4 class="card-title">All Project <a href="addproject.php" class="btn btn-tool btn-danger" style="background:rgb(203, 114, 13); margin:0 0 0 30px; border:none;">
Add New</a></h4>
<div class="card-tools">
<button type="button" class="btn btn-tool" data-card-widget="collapse" title="Collapse">
<i class="fas fa-minus"></i>
</button>
<button type="button" class="btn btn-tool" data-card-widget="remove" title="Remove">
<i class="fas fa-times"></i>
</button>
</div>
</div>
<div class="card-body p-0">
<table class="table table-striped projects" id="example2">
<thead>
<tr>
<th style="width: 1%">
#
</th>
<th style="width: 20%">
Project Name
</th>
<th style="width: 30%">
Project Image
</th>
<th style="width: 30%">
Project Category
</th>
<th style="width: 1%">
Position
</th>
<th style="width: 20%" class="text-center">
Status
</th>
<th style="width: 20%">
Action
</th>
</tr>
</thead>
<tbody>
<?php $query=mysqli_query($conn,"SELECT t1.*, GROUP_CONCAT(t3.sub_cat_name) sname FROM tbl_project t1 INNER JOIN project_cat t2 ON t1.pro_id=t2.pro_id
left join tbl_sub_cat t3 on t3.sub_cat_id=t2.sub_cat_id GROUP BY t1.pro_id order by t1.pro_id desc");
while($row=mysqli_fetch_array($query)){
if($row['status']==1){
$status='Active';
}else{
$status='Inactive';
}
?>
<tr id="tr_<?=$row['pro_id'];?>">
<td>
#
</td>
<td>
<a>
<?=$row['pro_name'];?>
</a>
<br/>
<small>
Created on <?=date("d M Y",strtotime($row['created_date']));?>
</small>
</td>
<td>
<ul class="list-inline">
<li class="list-inline-item">
<img alt="Avatar" class="table-avatar1" src="project_image/<?=$row['pro_img'];?>" width="80">
</li>
<!--<li class="list-inline-item">-->
<!-- <img alt="Avatar" class="table-avatar1" src="images/photo2.png" width="80">-->
<!--</li>-->
<!--<li class="list-inline-item">-->
<!-- <img alt="Avatar" class="table-avatar1" src="images/photo2.png" width="80">-->
<!--</li>-->
</ul>
</td>
<td class="project_progress">
<?=$row['sname'];?>
</td>
<td class="project_progress">
<input type="text" name="position_change" id="position_change_<?=$row['pro_id'];?>" onchange="change_position(<?=$row['pro_id'];?>,<?=$row['position'];?>);" value="<?=$row['position'];?>">
</td>
<td class="project-state">
<select class="form-control select2bs4" name="stat" id="stat<?=$row['pro_id'];?>" style="width: 100%;" onchange="change_status(<?=$row['pro_id'];?>);">
<option value="1" <?php if($row['status']==1){ echo 'selected';} ?>>Active</option>
<option value="0" <?php if($row['status']==0){ echo 'selected';} ?>>Inactive</option>
</select>
</td>
<td class="project-actions text-right">
<a class="btn btn-info btn-sm" href="edit_project.php?pro_id=<?=$row['pro_id'];?>">
<i class="fas fa-pencil-alt">
</i>
Edit
</a>
<a class="btn btn-danger btn-sm" href="javascript:void(0);" onclick="delete_project(<?=$row['pro_id'];?>)">
<i class="fas fa-trash">
</i>
Delete
</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</section>
<!-- Main content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
</div>
<strong>Copyright © 2014-2021 <a href="https://salientdesignstudio.com/">Salient Design Studio</a>.</strong> All rights reserved.
</footer>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Ekko Lightbox -->
<script src="plugins/ekko-lightbox/ekko-lightbox.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- Filterizr-->
<script src="plugins/filterizr/jquery.filterizr.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- Page specific script -->
<script>
$(function () {
$(document).on('click', '[data-toggle="lightbox"]', function(event) {
event.preventDefault();
$(this).ekkoLightbox({
alwaysShowClose: true
});
});
$('.filter-container').filterizr({gutterPixels: 3});
$('.btn[data-filter]').on('click', function() {
$('.btn[data-filter]').removeClass('active');
$(this).addClass('active');
});
})
</script>
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- CodeMirror -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- Page specific script -->
<!-- jQuery -->
<script src="last/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="last/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<!-- Summernote -->
<script src="last/summernote-bs4.min.js"></script>
<!-- CodeMirror -->
<!-- AdminLTE for demo purposes -->
<script src="last/demo.js"></script>
<script src="last/jquery.dataTables.min.js"></script>
<script src="last/dataTables.bootstrap4.min.js"></script>
<script src="last/dataTables.buttons.min.js"></script>
<!-- Page specific script -->
<script>
$(function () {
// Summernote
$('#summernote').summernote()
// CodeMirror
CodeMirror.fromTextArea(document.getElementById("codeMirrorDemo"), {
mode: "htmlmixed",
theme: "monokai"
});
})
$(function () {
// Summernote
$('#summernote2').summernote()
// CodeMirror
CodeMirror.fromTextArea(document.getElementById("codeMirrorDemo"), {
mode: "htmlmixed",
theme: "monokai"
});
})
</script>
<script>
$(function () {
$("#example1").DataTable({
"responsive": true, "lengthChange": false, "autoWidth": false,
"buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
}).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": true,
"ordering": true,
"info": true,
"autoWidth": false,
"responsive": true,
});
});
function delete_project(id){
var result = confirm("Want to delete this project?");
if (result) {
$.ajax({
url: 'allajax.php',
type:'POST',
data: ({
action: 'delete_project',
'pro_id' :id
}),
success:function(result){
console.log(result);
$("#tr_"+id).hide();
if(result==1){
alert('Project deleted successfully.');
}
}
});
}else{
return false;
}
}
function change_position(id,pos) {
var position=$("#position_change_"+id).val();
//alert(position);
if(position==''){
alert('Please chose a position first.');
$("#position_change_"+id).val(pos);
}else{
$.ajax({
url: 'allajax.php',
type:'POST',
data: ({
action: 'change_position',
'pro_id' :id,
'position':position
}),
success:function(result){
console.log(result);
if(result==1){
alert('Position changed successfully.');
//window.location.href='allproject.php';
}
}
});
}
}
function change_status(id) {
var stat=$("#stat"+id).val();
//alert(position);
$.ajax({
url: 'allajax.php',
type:'POST',
data: ({
action: 'change_pro_stat',
'id' :id,
'stat':stat
}),
success:function(result){
console.log(result);
if(result==1){
alert('Status changed successfully.');
//window.location.href='allproject.php';
}
}
});
}
</script>
</body>
</html>