Untitled

<?php
require("../Common.php");
if(empty($_SESSION['ADM'])){
    header("Location: ../Index.php");
    die("Redirecting to ../Index.php");
}
$Admin = $_SESSION['ADM']['Email'];

$ErrMessID = "";

$QryCallList = "SELECT * FROM tblcalls
                WHERE Status = :Status
                ORDER BY StartDay, Service, StartTime";
$QryPar = array(':Status' => 1);
try{
    $Stmt = $db->prepare($QryCallList);
    $Stmt->execute($QryPar);
}catch(PDOException $ex){
    die("Échec de la Requête: " . $ex->getMessage());
}
$CallList = $Stmt->fetchAll();

//PROCESSUS DE DISPATCH
if(!empty($_POST['KeyID']) && !empty($_POST['Dispatch'])){
    // VERIF MESSAGER ID EXISTE
    $QryValidMessID = "SELECT 1 FROM tblmessagers WHERE MessID = :MessID";
    $QryPar = array(':MessID' => $_POST['Dispatch']);
    try{
        $Stmt = $db->prepare($QryValidMessID);
        $Stmt->execute($QryPar);
    }catch(PDOException $ex){die("Échec de la Requête: " . $ex->getMessage());}
    $Row = $Stmt->fetch();
    if(!$Row){
        $ErrMessID = "Numéro de Messager Invalide. Le Call n'a pas été Dispatché.";
    }else{
        // UPDATE tblcalls
        $QryDispatch = "
                    UPDATE tblcalls SET
                        MessID = :MessID,
                        Status = :Status,
                        DispatchedDay = :DispatchedDay,
                        DispatchedTime = :DispatchedTime
                    WHERE
                        KeyID = :KeyID";
        $DispatchedDay = date('Y-m-d');
        $DispatchedTime = date('H:i:s');
        $QryPar = array(
                    ':MessID' => $_POST['Dispatch'],
                    ':Status' => 0,
                    ':DispatchedDay' => $DispatchedDay,
                    ':DispatchedTime' => $DispatchedTime,
                    ':KeyID' => $_POST['KeyID']);
        try{
            $Stmt = $db->prepare($QryDispatch);
            $Stmt->execute($QryPar);
        }catch(PDOException $ex){die("Échec de la Requête: " . $ex->getMessage());}
        // INSERT LE CALL DISPATCHÉ DANS tbldispatchedcalls
        $QryDispatch = "
                    INSERT INTO tbldispatchedcalls(
                        KeyID, DateTimeReceived, ClientID, CorpName,
                        StartDay, StartTime, FromInfo, FromContact, FromPhone,
                        ToInfo, ToContact, ToPhone, Memo, Service, strService,
                        AR, DispatchedDay, DispatchedTime, MessID, Status)
                    SELECT
                        KeyID, DateTimeReceived, ClientID, CorpName,
                        StartDay, StartTime, FromInfo, FromContact, FromPhone,
                        ToInfo, ToContact, ToPhone, Memo, Service, strService,
                        AR, DispatchedDay, DispatchedTime, MessID, Status
                    FROM tblcalls
                    WHERE KeyID = :KeyID";
        $QryPar = array(':KeyID' => $_POST['KeyID']);
        try{
            $Stmt = $db->prepare($QryDispatch);
            $Stmt->execute($QryPar);
        }catch(PDOException $ex){die("Échec de la Requête: " . $ex->getMessage());}
        // DELETE LE CALL VENANT D'ETRE DISPATCHÉ de tblcalls
        $QryDispatch = "
                    DELETE FROM tblcalls
                    WHERE KeyID = :KeyID";
        $QryPar = array(':KeyID' => $_POST['KeyID']);
        try{
            $Stmt = $db->prepare($QryDispatch);
            $Stmt->execute($QryPar);
        }catch(PDOException $ex){die("Échec de la Requête: " . $ex->getMessage());}
        header("Location: IndexAdmin.php");
        die("Redirecting to IndexAdmin.php");
    }
}


print_r($_POST);


?>
<!DOCTYPE html>
<html>
<head>
    <title>Messagerie Bobbie - Administrateur</title>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="../CSS/IndexAdmin.css" />
</head>
<body>
    <div id="BlocPage">
        <header>
            <div id="Logo">
                <img src="../Images/LogoTransAdmin.png" alt="Logo Messagerie Bobbie" id="Logo" />
            </div>
            <div id="AdminData">
                Bienvenue <?php echo $Admin;?>
                <a href="../Logout.php">Déconnexion</a>
            </div>


            <div id="MenuAdmin">
                <a href="AddPickup.php" id="btnAddPickUp">Ajouter Une Course</a>
                <a href="Undispatch.php" id="btnUndispatch">Reprendre Une Course</a>
            </div>
        </header>

        <div class="CallList">
            <div class="ErrMessID"><?php echo $ErrMessID; ?></div>
            <?php foreach($CallList as $Key => $Call){ ?>
            <div class="Call<?php echo $Call['KeyID']?>">
                <form name="Dispatch" class="frmDispatch" action="" method="post">
                    <input type="hidden" name="KeyID" class="hidKeyID" value="<?php echo $Call['KeyID'];?>" />
                    <div class="ServDayTime">
                        <div class="Serv"><?php echo htmlspecialchars($Call['StrService'], ENT_QUOTES, 'UTF-8'); ?></div>
                        <div class="Day"><?php
                            $dteStartDay = date_create($Call['StartDay']);
                            $dteStartDay = date_format($dteStartDay, 'N');
                            switch($dteStartDay){
                                case '1': $dteStartDay = 'Lundi'; break;
                                case '2': $dteStartDay = 'Mardi'; break;
                                case '3': $dteStartDay = 'Mercredi'; break;
                                case '4': $dteStartDay = 'Jeudi'; break;
                                case '5': $dteStartDay = 'Vendredi'; break;
                                default: $dteStartDay = 'Invalid'; break;
                            }echo $dteStartDay; ?>
                        </div>
                        <div class="Time"><?php
                            $dteStartTime = date_create($Call['StartTime']);
                            echo date_format($dteStartTime, 'G:i'); ?>
                        </div>
                    </div>
                    <div class="NameID">
                        <div class="ClientID"><?php echo htmlspecialchars($Call['ClientID'], ENT_QUOTES, 'UTF-8'); ?></div>
                        <div class="CorpName"><?php echo htmlspecialchars($Call['CorpName'], ENT_QUOTES, 'UTF-8'); ?></div>
                    </div>
                    <div class="From">
                        <div class="FromInfo"><?php echo nl2br(htmlspecialchars($Call['FromInfo'], ENT_QUOTES, 'UTF-8')); ?></div>

                        <div class="FromContactPhone">
                            <div class="FromContact"><?php echo htmlspecialchars($Call['FromContact'], ENT_QUOTES, 'UTF-8'); ?></div>
                            <div class="FromPhone"><?php echo htmlspecialchars($Call['FromPhone'], ENT_QUOTES, 'UTF-8'); ?></div>
                        </div>
                    </div>
                    <div class="Vers">
                        <div>></div><div>></div>
                    </div>
                    <div class="To">
                        <div class="ToInfo"><?php echo nl2br(htmlspecialchars($Call['ToInfo'], ENT_QUOTES, 'UTF-8')); ?></div>

                        <div class="ToContactPhone">
                            <div><?php echo htmlspecialchars($Call['ToContact'], ENT_QUOTES, 'UTF-8'); ?></div>
                            <div><?php echo htmlspecialchars($Call['ToPhone'], ENT_QUOTES, 'UTF-8'); ?></div>
                        </div>
                    </div>
                    <div class="Memo"><?php echo nl2br(htmlspecialchars($Call['Memo'], ENT_QUOTES, 'UTF-8')); ?></div>

                    <div class="Dispatch">
                        <input type="text" name="Dispatch" class="txtDispatch" value="" />
                    </div>
                    <div class="btnModifDel">


                            <input type="submit" name="Modif" class="btnModifPickUp" value="Modif"/>
                            <input type="submit" name="Delete" class="btnDel" value="Delete" />


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

    <?php
            switch($Call['Service']){
                case 1: echo '<style>.Call' . $Call['KeyID'] . '{background-color: #FFC20E; min-width: 1160px; max-width: 1160px; min-height: 60px; max-height: 60px; margin-bottom: 1px; border-style: solid; border-width: 2px;} </style>'; break;
                case 2: echo '<style>.Call' . $Call['KeyID'] . '{background-color: #FFF200; min-width: 1160px; max-width: 1160px; min-height: 60px; max-height: 60px; margin-bottom: 1px; border-style: solid; border-width: 2px;} </style>'; break;
                case 3: echo '<style>.Call' . $Call['KeyID'] . '{background-color: #22B14C; min-width: 1160px; max-width: 1160px; min-height: 60px; max-height: 60px; margin-bottom: 1px; border-style: solid; border-width: 2px;} </style>'; break;
                case 4: echo '<style>.Call' . $Call['KeyID'] . '{background-color: #0072BC; min-width: 1160px; max-width: 1160px; min-height: 60px; max-height: 60px; margin-bottom: 1px; border-style: solid; border-width: 2px;} </style>'; break;
            }
        }
        if(!empty($ErrMessID)){
            echo '<style>.Call' . $_POST['KeyID'] . '{background-color: red;} </style>';
            echo '<style>.ErrMessID {font-weight: bold; background-color: yellow; border-radius: 70px; padding: 3px; border-style:solid; border-color: red; margin-bottom: 1px;}';
        }


    ?>
        </div>
        <h1>Vous êtes Logger en tant qu'Administrateur!</h1>

    </div>

</body>
<script src="../JS/jQuery.js"></script>
<script src="../JS/IndexAdmin.js"></script>

</html>