MAINHACK

Viewing / Editing File: department.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{
$pageTitle1 = 'Department';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

if(isset($_POST['submit'])){

$depart_name = test_input($_POST['depart_name']);
 $status = test_input($_POST['status']);

$date = date("Y-m-d H:i:a");

if(empty($depart_name)){
}else {
$stmt = $con->prepare("insert into department (depart_name,business_name,date,status) values (?,?,?,?)");
$stmt->execute(array($depart_name,$shopname,$date,$status));

}
}

if(isset($_POST['del'])){
$SID = filter_input(INPUT_POST, 'SID', FILTER_SANITIZE_STRING);
$SID = htmlspecialchars($SID, ENT_QUOTES, 'UTF-8');
$stmt = $con->prepare("DELETE FROM department WHERE depart_id = ?");
$stmt->execute(array($SID)); 
}

if(isset($_POST['update'])){

$depart_name = filter_input(INPUT_POST, 'depart_name', FILTER_SANITIZE_STRING);
$depart_name = htmlspecialchars($depart_name, ENT_QUOTES, 'UTF-8');

$status = filter_input(INPUT_POST, 'status', FILTER_SANITIZE_STRING);
$status = htmlspecialchars($status, ENT_QUOTES, 'UTF-8');

$depart_id = filter_input(INPUT_POST, 'depart_id', FILTER_SANITIZE_STRING);
$depart_id = htmlspecialchars($depart_id, ENT_QUOTES, 'UTF-8');

$stmt_update_service = $con->prepare("UPDATE department SET depart_name = ?, status = ?  WHERE depart_id = ?");
$stmt_update_service->execute(array($depart_name,$status,$depart_id));
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $shopname;?> - <?php echo $pageTitle1;?></title>

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}

@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>

</head>

<div id="layout-wrapper">
<div class="header-border"></div>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">
<h4 class="mb-0 font-size-18">Department</h4>

</div>
</div>
</div>

<button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
             <br   /><br   />
    <div class="table-responsive">           
 <table id="basic-datatable" class="table table-hover table-striped table-bordered">
     <thead style="background-color:#428bca;border:#428bca;">
<tr style="color: #ffffff;">
    <th>ID</th>
    <th>Department</th>
    <th>Status</th>
    <th>Action</th>
    </tr>
</thead>
 <tbody>
       <?php
$cont = 1;
$stmt = $con->prepare("SELECT * FROM department WHERE business_name = ?  ORDER BY depart_id DESC");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
              ?>
                    <tr>
                        <?php 
                        foreach($rows_services as $service){
                        ?>
                        <td><?php echo $cont++;?></td>
                        <td><?php echo $service['depart_name'];?></td>

<td><?php if($service['status'] == 'active') {
                             echo "<span class='badge bg-success rounded-pill' style='color:#fff'>Active</span>";
                        } else {
                            echo "<span class='badge bg-danger rounded-pill' style='color:#fff'>Inactive</span>";
                        };?></td>
                        <td>

<?php  $edit_data = "edit_".$service["depart_id"];?>
                <?php  $delete_data = "delete_".$service["depart_id"];?>

<li class="list-inline-item" data-toggle="tooltip" title="Edit">
            <a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
            </li>

<li class="list-inline-item" data-toggle="tooltip" title="Delete">
            <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt"style="color:red" ></i></a>
            </li>

<div class="modal fade bd-example-modal-lg12" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $edit_data; ?>" aria-hidden="true">

<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Edit Department name</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
        <div id="response"></div>
</div>

<div class="modal-body">
<form method="post" accept-charset="utf-8">
       <div class="row">
            <div class="form-group col-md-6">
                <label>Department name</label>
                <input type="text" name="depart_name" value="<?php echo $service["depart_name"]; ?>"  class="form-control" style="height:40px">
            </div>
            <input type="hidden" name="depart_id" value="<?php echo $service["depart_id"]; ?>">

<div class="form-group col-md-6">
                <label>Select status</label>
              <select class="form-control" style="height:40px" name="status" value="<?php echo $service["status"]; ?>">
                  <option value="">Select status</option>
                  <option value="active">Active</option>
                  <option value="inactive">Inactive</option>
              </select>
            </div>
            <br  />

<div class="modal fade" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $delete_data; ?>" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Delete Department</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<form method="POST">
Are you sure you want to delete this Department?
</div>
<input type="hidden" name="SID" value="<?php echo $service['depart_id']; ?>">
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>

<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>
</div>

</li>
</ul>
</td>
                    </tr>
                <?php  };?>
                </tbody>
            </table>
</div>

</div>

</div> 
</div>

</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<div class="modal fade bd-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Add Department</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>

<div class="modal-body">
<form method="post" accept-charset="utf-8">
       <div class="row">
            <div class="form-group col-md-6">
                <label>Department name</label>
                <input type="text" name="depart_name"  class="form-control" style="height:40px" required>
            </div>
            <div class="form-group col-md-6">
                <label>Select status</label>
              <select class="form-control" style="height:40px" name="status">
                  <option value="">Select status</option>
                  <option value="active">Active</option>
                  <option value="inactive">Inactive</option>
              </select>
            </div>
            <br  />
             <div class="form-group col-md-2">
             <button type="submit" name="submit"  class="btn btn-success form-control">Send</button>
            </div>
        </div>
        </form>
</div>
</div>
</div>
</div>

<?php //include("includes/modals/PayrunModal.php");?>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: department.php

Server Info

System Features

User Info