MAINHACK

Viewing / Editing File: employees.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 = 'Employees';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$message = "";
if(isset($_POST['add'])){

$first_name = test_input($_POST['first_name']);
$last_name = test_input($_POST['last_name']);
$email = test_input($_POST['email']);
$phone_number = test_input($_POST['phone_number']);
$dob = test_input($_POST['dob']);
$gender = test_input($_POST['gender']);
$address = test_input($_POST['address']);
$department = test_input($_POST['department']);
$monthly_salary = test_input($_POST['monthly_salary']);
$status = test_input($_POST['status']);
$employee_id = test_input($_POST['employee_id']);

$sele = mysqli_query($new,"SELECT * FROM employees WHERE email = '$email' AND business_name = '$shopname'");
$conrow = mysqli_fetch_array($sele);
$dbvendor = $conrow['email'];
$phone = $conrow['phone_number'];

if($first_name == ""){
     $message = '<script> $(document).ready(function(){
    swal("Warning!", "Please enter Employees firstname", "warning");}); </script>';
}
if($last_name ==""){
     $message = '<script> $(document).ready(function(){
    swal("Warning!", "Please enter Employees lastname", "warning");}); </script>';

}
if($phone == $phone_number) {
 $message = '<script> $(document).ready(function(){
    swal("Warning!", "Phone number already  Exist", "warning");}); </script>';
}

if(!$message){

$stmt = $con->prepare("insert into employees (first_name,last_name,phone_number,email,dob,gender,department,monthly_salary,status,address,business_name) values (?,?,?,?,?,?,?,?,?,?,?)");
$stmt->execute(array($first_name,$last_name,$phone_number,$email,$dob,$gender,$department,$monthly_salary,$status,$address,$shopname));

$message = '<script> $(document).ready(function(){
    swal("Success!", "New employees added", "success");}); </script>';

}
}

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 employees WHERE employee_id = ?");
$stmt->execute(array($SID));

$message = '<script> $(document).ready(function(){
    swal("Success!", "Employee is deleted", "success");}); </script>';

}

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

$stmt_update_service = $con->prepare("UPDATE employees SET first_name = ?, last_name = ?, phone_number = ?,email = ?, dob = ?, gender = ?, department = ?, monthly_salary = ?, status = ?, address = ?   WHERE employee_id = ?");
$stmt_update_service->execute(array($first_name,$last_name,$phone_number,$email,$dob,$gender,$department,$monthly_salary,$status,$address,$employee_id));

$message = '<script> $(document).ready(function(){
    swal("Success!", "Employee records updated", "success");}); </script>';

}
}
?>
<!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">All Employee</h4>

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

<?php 
$stmt = $con->prepare("SELECT account_type FROM  barber_admin WHERE username = ? and business_name = ?");
$stmt->execute(array($username,$shopname));
$userstatus = $stmt->fetchAll();

foreach($userstatus as $sta)
{
    $namee = $sta['account_type'];
}

$select_role = mysqli_query($new,"SELECT * FROM role_permissions  WHERE business_name = '$shopname' and type = '$namee' and page_name = 'Employee'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];
?>
<?php 
if($namee != "Admin"){?>
    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
        <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
<button type="button" disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>

<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>Name</th>
    <th>Department </th>
    <th>Info</th>
    <th>Status</th>
    <th>Action</th>
    </tr>
</thead>
 <tbody>
<?php
            $cont = 1;

$stmt = $con->prepare("SELECT * FROM employees e,department d  WHERE e.department = d.depart_id AND e.business_name = ?  ORDER BY employee_id DESC");
    $stmt->execute(array($shopname));
    $rows_services = $stmt->fetchAll();
    ?>
    <tr>
    <?php 
    foreach($rows_services as $service){
    $f = $service['first_name'];
    $l = $service['last_name'];
    $name = $f.' , '.$l;

?>
        <td><?php echo $cont++;?></td>
        <td class="py-0 px-1"><?php echo $name ?>
        <?php if($service['gender'] == "male"): ?>
        <span class="fa fa-mars mx-1 text-primary opacity-50" title="Male"></span>
        <?php else: ?>
        <span class="fa fa-venus mx-1 text-danger opacity-50" title="Female"></span>
        <?php endif; ?>
        </td>
        <td><?php echo $service['depart_name'];?></td>
        <td class="py-0 px-1">
        <small>DoB: <?php echo date("M d, Y",strtotime($service['dob'])) ?></small><br>
        <small>Email: <?php if(empty($service['email'])){
            echo "N/A";
        } else {
            echo $service['email'];
        }?></small><br>

<small>Phone: <?php if(empty($service['phone_number'])){
            echo "N/A";
        } else {
            echo  $service['phone_number'];
        }?></small>

</td>

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

<?php 
        if($namee != "Admin"){?>
        <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>
        
        <?php } elseif($namee == "Admin" and $updaterecord == '1' ) {?>
        <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>

<?php } elseif ($namee == "Admin" and $updaterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-edit"></i></a>
        </li>

<?php }?>

<li class="list-inline-item" data-toggle="tooltip" title="Schedule">
            <a href="schedule?employee=<?php echo $service['employee_id'];?>&&<?php echo md5($employee_id); ?>" class=""><i class="fa fa-user-alt"style="color:green" ></i></a>
            </li>

<?php 
        if($namee != "Admin"){?>
        <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>

<?php } elseif($namee == "Admin" and $deleterecord == '1' ) {?>
        <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>

<?php } elseif ($namee == "Admin" and $deleterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>
        <?php }?>

<ul>

<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 Employee</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 Employee?
</div>
<input type="hidden" name="SID" value="<?php echo $service['employee_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>

<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 Employee</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" data-ng-form="newcustomer1">
<div class="setting-steps">
<form   accept-charset="utf-8" method="POST">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Phone number</label>
                <input type="text" class="form-control" id="validationTooltip03" name="phone_number" value="<?php echo $service["phone_number"]; ?>">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">First Name<span class="req">*</span></label>
                <input type="text" class="form-control" id="customerName" name="first_name" value="<?php echo $service["first_name"]; ?>" >
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Last Name</label>
              <input type="text" class="form-control" id="last_name" name="last_name" value="<?php echo $service["last_name"]; ?>">
            </div>
        </div>
    </div>
    <div class="row">
      <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">DOB</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="dob" data-provide="datepicker" data-date-format="d-M-yyyy" value="<?php echo $service["dob"]; ?>">
                    
            </div>
        </div>
        </div> 
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Email ID</label>
          <input type="email" class="form-control" id="email" name="email" value="<?php echo $service["email"]; ?>">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Gender</label>
                <div class="inline-radio tbl">
                    <div class="radio">
                        <input type="radio" id="male" name="gender" value="male">
                        <label for="male">Male</label>
                    </div>
                    <div class="radio">
                        <input type="radio" id="female" name="gender" value="female">
                        <label for="female">Female</label>
                    </div>
                </div>
            </div>
        </div>                
    </div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Location</label>
                <input type="text" class="form-control" name="address" value="<?php echo $service["address"]; ?>"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Department</label>
                <select class="form-control" name="department">
                  <option value="<?php echo $service["department"]; ?>">Select status</option>
                   <?php 
                     $sel = mysqli_query($new,"SELECT * FROM department WHERE business_name = '$shopname'");
                     while($fo = mysqli_fetch_array($sel)){
                   ?>
                   <option value="<?php echo $fo['depart_id'];?>"><?php echo $fo['depart_name'];?></option>
                 <?php }?>
                </select>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Basic Salary (optional)</label>
                <input type="number" step="any" name="monthly_salary" id="monthly_salary" class="form-control" value="<?php echo $service["monthly_salary"]; ?>">
            </div>
        </div>
    </div>

<div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Status</label>

<select name="status" id="status" class="form-control">
          <option value="active" <?php echo (isset($status) && $status == 1 ) ? 'selected' : '' ?>>Active</option>
         <option value="inactive" <?php echo (isset($status) && $status == 0 ) ? 'selected' : '' ?>>Inactive</option>
                </select>

</div>
        </div>
    </div>
    <button type="submit" name="update" class="btn btn-success">Save</button>
</form>

</div>
</div>
        </div>
        </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>

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

<h5 class="modal-title h4" id="myLargeModalLabel">Add New Employee</h5>

<?php 
if($message != "") {
echo ($message) ;
}
?>
<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" data-ng-form="newcustomer1">
<div class="setting-steps">
<form   accept-charset="utf-8" method="POST">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Phone number</label>
                <input type="text" class="form-control" id="validationTooltip03" name="phone_number" required>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">First Name<span class="req">*</span></label>
                <input type="text" class="form-control" id="customerName" name="first_name" required >
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Last Name</label>
              <input type="text" class="form-control" id="last_name" name="last_name" required>
            </div>
        </div>
    </div>
    <div class="row">
      <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">DOB</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="dob" data-provide="datepicker" data-date-format="d-M">
                    
            </div>
        </div>
        </div> 
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Email ID</label>
          <input type="email" class="form-control" id="email" name="email">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Gender</label>
                <div class="inline-radio tbl">
                    <div class="radio">
                        <input type="radio" id="male" name="gender" value="male">
                        <label for="male">Male</label>
                    </div>
                    <div class="radio">
                        <input type="radio" id="female" name="gender" value="female">
                        <label for="female">Female</label>
                    </div>
                </div>
            </div>
        </div>                
    </div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Location</label>
                <input type="text" class="form-control" name="address"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Department</label>
                <select class="form-control" name="department">
                  <option>Select status</option>
                   <?php 
                     $sel = mysqli_query($new,"SELECT * FROM department WHERE business_name = '$shopname'");
                     while($fo = mysqli_fetch_array($sel)){
                   ?>
                   <option value="<?php echo $fo['depart_id'];?>"><?php echo $fo['depart_name'];?></option>
                 <?php }?>
                </select>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Basic Salary (optional)</label>
                <input type="number" step="any" name="monthly_salary" id="monthly_salary" class="form-control">
            </div>
        </div>
    </div>

<div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Status</label>
                <select class="form-control" name="status">
                  <option>Select status</option>
                   <option value="active">Active</option>
                   <option value="inactive">Inactive</option>
                </select>
            </div>
        </div>
    </div>
    <button type="submit" name="add" class="btn btn-success">Submit</button>
</form>

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

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

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: employees.php

Server Info

System Features

User Info