Example #1
0
<?php

require_once "session.php";
require_once "class.user.php";
require_once "PostService.php";
$auth_user = new USER();
$service = new PostService();
if (isset($_GET['guard'])) {
    $list = $service->listGuard();
    $action = "Guard";
} else {
    if (isset($_GET['post'])) {
        $list = $service->listPost();
        $action = "Post";
    } else {
        $service->redirect("error.php");
    }
}
$user_id = $_SESSION['user_session'];
$stmt = $auth_user->runQuery("SELECT * FROM admin WHERE id=:user_id");
$stmt->execute(array(":user_id" => $user_id));
$userRow = $stmt->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
  
 <head>
    <meta charset="utf-8">
    <title>PAPS - Admin</title>
    
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
Example #2
0
<?php

require_once "PostService.php";
require_once "session.php";
require_once "class.user.php";
$auth_user = new USER();
$user_id = $_SESSION['user_session'];
$stmt = $auth_user->runQuery("SELECT * FROM admin WHERE id=:user_id");
$stmt->execute(array(":user_id" => $user_id));
$userRow = $stmt->fetch(PDO::FETCH_ASSOC);
$service = new PostService();
$listguard = $service->listGuard();
$listpost = $service->listPost();
if (isset($_POST["validate"])) {
    $interval = $_POST["hour"];
    $heure = $_POST["date"];
    $guard = $_POST["guard"];
    $post = $_POST["post"];
    $debut = $_POST["debut"];
    $fin = $_POST["fin"];
    try {
        $guard_id = $service->getGuardId($guard);
        $poste_id = $service->getPostId($post);
        $stmt = $service->runQuery("SELECT poste_id, guard_id FROM guardtours WHERE poste_id=:poste_id OR guard_id=:guard_id");
        $stmt->execute(array(':poste_id' => $poste_id, ":guard_id" => $guard_id));
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        if ($row['poste_id'] == $poste_id) {
            $error[] = "sorry this post already taken !";
        } else {
            if ($row['guard_id'] == $guard_id) {
                $error[] = "sorry this guard already taken !";