Viewing file: view_staff.php (26.4 KB) -rw-rw-r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start();
include('includes/header.php');
if(isset($_GET['s']))
{
$s = $_GET['s'];
}
?>
<?php
// Storing session data
$_SESSION["role"];
if(!isset($_SESSION["role"]))
{
header("location:admin_login.php");
?>
<script type="text/javascript">
window.location.href = "admin_login.php";
</script>
<?php
}
else
{
?>
<input type="hidden" id="s" value="<?php echo $s; ?>">
<div class="page-container">
<div class="left-content">
<div class="mother-grid-inner">
<!--header start here-->
<div class="header-main">
<div class="header-left">
<div class="logo-name">
<a href="admin_index.php"> <h3>SICS ADMIN</h3>
</br>
<h4>View Staff</h4>
<!--<img id="logo" src="" alt="Logo"/>-->
</a>
</div>
<!--search-box-->
<!--
<div class="search-box">
<form>
<input type="text" placeholder="Search..." required="">
<input type="submit" value="">
</form>
</div>//end-search-box
-->
<div class="clearfix"> </div>
</div>
<!--
<div class="header-right">
<div class="profile_details_left">notifications of menu start
<ul class="nofitications-dropdown">
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-envelope"></i><span class="badge">3</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 3 new messages</h3>
</div>
</li>
<li><a href="#">
<div class="user_img"><img src="images/p4.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li class="odd"><a href="#">
<div class="user_img"><img src="images/p2.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor </p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li><a href="#">
<div class="user_img"><img src="images/p3.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all messages</a>
</div>
</li>
</ul>
</li>
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-bell"></i><span class="badge blue">3</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 3 new notification</h3>
</div>
</li>
<li><a href="#">
<div class="user_img"><img src="images/p5.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li class="odd"><a href="#">
<div class="user_img"><img src="images/p6.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li><a href="#">
<div class="user_img"><img src="images/p7.png" alt=""></div>
<div class="notification_desc">
<p>Lorem ipsum dolor</p>
<p><span>1 hour ago</span></p>
</div>
<div class="clearfix"></div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all notifications</a>
</div>
</li>
</ul>
</li>
<li class="dropdown head-dpdn">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-tasks"></i><span class="badge blue1">9</span></a>
<ul class="dropdown-menu">
<li>
<div class="notification_header">
<h3>You have 8 pending task</h3>
</div>
</li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Database update</span><span class="percentage">40%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar yellow" style="width:40%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Dashboard done</span><span class="percentage">90%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar green" style="width:90%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Mobile App</span><span class="percentage">33%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar red" style="width: 33%;"></div>
</div>
</a></li>
<li><a href="#">
<div class="task-info">
<span class="task-desc">Issues fixed</span><span class="percentage">80%</span>
<div class="clearfix"></div>
</div>
<div class="progress progress-striped active">
<div class="bar blue" style="width: 80%;"></div>
</div>
</a></li>
<li>
<div class="notification_bottom">
<a href="#">See all pending tasks</a>
</div>
</li>
</ul>
</li>
</ul>
<div class="clearfix"> </div>
</div>
-->
<!--notification menu end -->
<div class="profile_details">
<ul>
<li class="dropdown profile_details_drop">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
<div class="profile_img">
<span class="prfil-img"><img src="images/p1.png" alt=""> </span>
<div class="user-name">
<p>Srishti Innovative</p>
<span><?php echo $_SESSION["name"];?></span>
</div>
<i class="fa fa-angle-down lnr"></i>
<i class="fa fa-angle-up lnr"></i>
<div class="clearfix"></div>
</div>
</a>
<ul class="dropdown-menu drp-mnu">
<!-- <li> <a href="#"><i class="fa fa-cog"></i> Settings</a> </li>
<li> <a href="#"><i class="fa fa-user"></i> Profile</a> </li> -->
<li> <a href="logout.php"><i class="fa fa-sign-out"></i> Logout</a> </li>
</ul>
</li>
</ul>
</div>
</div>
<div class="inner-block">
<?php
if($s=='success'){
echo '<div class="alert alert-success" role="alert">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
Updated Successfully
</div>';
}
else if($s=='failed'){
echo '<div class="alert alert-danger" role="alert">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
Updated Failed
</div>';
}
?>
<?php
$query = "select * from `admin` where role='staff' ";
$result = $con->query($query);
?>
<table id="users" class="table table-striped table-condensed">
<thead style='background: #7ab9f3;'>
<tr>
<th> Sl no </th>
<th>Name</th>
<th>Email</th>
<th>Password</th>
<th>Technology</th>
<th><th>
</tr>
</thead>
<tbody>
<?php
$i=1;
while ($row = $result->fetch_assoc()) {
?>
<tr>
<!-- <td><?php //echo $row["user_id"]; ?></td> -->
<td><?php echo $i; ?></td>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["email"]; ?></td>
<td><?php echo $row["password"]; ?></td>
<td style="text-align: center;">
<ul>
<?php
$id=$row['id'];
//echo $id;
$sql1 ="SELECT *
FROM staff_technology
INNER JOIN technologies
ON staff_technology.technology_id = technologies.id where staff_technology.staff_id=$id ";
$r=$con->query($sql1);
while($ro=$r->fetch_assoc()){
echo '<li>'.$ro['name'].'</li>';
}
?>
</ul>
</td>
<td><a href="delete_staff.php?id=<?php echo $row['id'];?>"><i class="fa fa-trash-o" style="font-size:20px;color:red"></i></a></td>
<td><a href="edit_staff.php?id=<?php echo $row['id'];?>">Edit</a></td>
<!-- <td><?php //echo $row["qualification"]; ?></td>
<td><?php //echo $row["technical"]; ?></td> -->
<?php
$i++;
}
?>
</tr>
</tbody>
</table>
</div>
<div class="clearfix"> </div>
</div>
<div class="clearfix"> </div>
</div>
<!--heder end here-->
<!-- script-for sticky-nav -->
<!-- /script-for sticky-nav -->
<!--inner block start here-->
<div class="inner-block">
</section>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
<div class="clearfix"> </div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--slider menu-->
<?php include('includes/sidebar.php'); ?>
<div class="clearfix"> </div>
</div>
<!--slide bar menu end here-->
<?php include('includes/footer.php'); ?>
<script>
$(document).ready(function () {
$('#users').DataTable();
var navoffeset = $(".header-main").offset().top;
$(window).scroll(function () {
var scrollpos = $(window).scrollTop();
if (scrollpos >= navoffeset) {
$(".header-main").addClass("fixed");
} else {
$(".header-main").removeClass("fixed");
}
});
});
</script>
<!--
<script type="text/javascript">
var x = $('#s').val();
if (x == 'Success') {
// $("#myModal").modal();
// swal('User has been Deleted !!');
swal({
title: "",
type: "success",
text: 'User has been Deleted !!',
confirmButtonColor: "#00B4B4"
},function() {
window.location.href = "view_users.php";
});
}
</script> -->
<?php
}
?>
|