MAINHACK

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

$notificationType = "success";

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));

}

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

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

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

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

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

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

$stmt_update_service = $con->prepare("UPDATE employees SET first_name = ?, last_name = ?, phone_number = ?,email = ?  WHERE employee_id = ?");
$stmt_update_service->execute(array($first_name,$last_name,$phone_number,$email,$employee_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">Employees Schedule</h4>

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

<?php

if(isset($_GET['employee'])){
    
$do = htmlspecialchars($_GET['employee']);

$stmt = $con->prepare("SELECT e.first_name,e.last_name,s.from_hour,s.to_hour,d.day FROM employees e,employees_schedule s,days d  WHERE e.employee_id = s.employee_id and s.day_id = d.day_value and e.business_name = ? and e.employee_id = ?  ");
$stmt->execute(array($shopname,$do));
$rows_services = $stmt->fetchAll();

foreach($rows_services as $service){

}

}
?>
        <div class="card-body">
             <center><h3>Working days and time for <?php echo $service['first_name'].' '.$service['last_name'] ?></h3></center>
             <br  />
     <div class="table-responsive">                       
 <table  class="table table-bordered">
  <thead style="background-color:#428bca;border:#428bca;">
<tr style="color: #ffffff;">
                        <th>Wroking Days</th>
                        <th>Wroking start time </th>
                        <th>Wroking end time </th>
                    </tr>
                </thead>
                <tbody>
     
                    <tr>
                        <?php 
                        foreach($rows_services as $service){
                        ?>
                        <td><?php echo $service['day'];?></td>
                        <td><?php echo $time12hr = date("h:i A", strtotime($service['from_hour']));?></td>
                        <td><?php echo $time12hr = date("h:i A", strtotime($service['to_hour']));?></td>

</tr>
                <?php  };?>
                </tbody>
            </table>
        </div>
        
        </div> 
    </div> 
</div>
</div>

</div>

</div> 
</div>

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

</div>

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

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

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: schedule.php

Server Info

System Features

User Info