<?php
require_once "../model/session.php";
require_once '../model/models.php';
$controllerCalled = 1;
$tours = new Tours();
$model = new Model();
$list = "";
if (isset($_GET["page"])) {
$page = strip_tags(htmlspecialchars($_GET["page"]));
switch ($page) {
case 'post':
# code...
$list = $model->_list("poste", "*");
$_SESSION['page'] = "Post";
break;
case 'guard':
# code...
$_SESSION['page'] = "Guard";
$list = $model->_list("guard", "*");
break;
case 'guardTours':
# code...
$list = $model->_list("guardtours", "*");
for ($i = 0; $i < sizeof($list); $i++) {
foreach ($list[$i] as $key => $value) {
if ($key == "poste_id") {
$list[$i][$key] = $model->getBy("poste", "nom", "id", $value);
}
if ($key == "guard_id") {
$list[$i][$key] = $model->getBy("guard", "nom", "id", $value) . " " . $model->getBy("guard", "prenom", "id", $value);
<?php
require_once "../model/session.php";
require_once '../model/models.php';
$controllerCalled = 1;
$report = new Model();
$listReport = "";
if (isset($_POST['id'])) {
$_SESSION["report-list"] = array("id" => '', "key" => '');
$_SESSION["report-list"]['id'] = json_decode($_POST['id'], true);
$_SESSION["report-list"]['key'] = json_decode($_POST['key'], true);
}
if (!empty($_SESSION["report-list"]['id']) && !empty($_SESSION["report-list"]['key'])) {
$listReport = $report->dynamicSelectAll("tours", "id IN(" . implode(',', $_SESSION["report-list"]['id']) . ")", implode(',', $_SESSION["report-list"]['key']));
}
$company = $report->_list("company", "*")[0];
for ($i = 0; $i < sizeof($listReport); $i++) {
foreach ($listReport[$i] as $key => $value) {
if ($key == "guardtours_id") {
$guardtours_id = $listReport[$i][$key];
$guard_id = $report->getBy("guardtours", "guard_id", "id", $guardtours_id);
$nom = $report->getBy("guard", "nom", "id", $guard_id);
$prenom = $report->getBy("guard", "prenom", "id", $guard_id);
$listReport[$i][$key] = $nom . " " . $prenom;
}
if ($key == "mention") {
if ($listReport[$i][$key] == "#dd5826") {
$listReport[$i][$key] = "Bad";
}
if ($listReport[$i][$key] == "#f0b518") {
$listReport[$i][$key] = "Warning";
public static function listDataFK()
{
$model = new Model();
$stmt = $model->query("SELECT poste_id FROM `guardtours` GROUP BY poste_id HAVING COUNT(poste_id)>1");
$guardpost = $stmt->fetchAll(PDO::FETCH_ASSOC);
$guard_ = $model->_list("guardtours", "guard_id");
$array = array("poste_id" => array(), "guard_id" => array());
for ($i = 0; $i < sizeof($guardpost); $i++) {
foreach ($guardpost[$i] as $key => $value) {
$array[$key][] = $value;
}
}
for ($i = 0; $i < sizeof($guard_); $i++) {
foreach ($guard_[$i] as $key => $value) {
$array[$key][] = $value;
}
}
$postAdress = $model->dynamicSelectAll("poste", "id NOT IN(" . implode(',', $array['poste_id']) . ")", "adress, nom");
$guardId = $model->dynamicSelectAll("guard", "id NOT IN(" . implode(',', $array['guard_id']) . ")", "uid, nom, prenom");
$array['poste_id'] = $postAdress;
$array['guard_id'] = $guardId;
return $array;
}
<?php
require_once "../model/session.php";
require_once '../model/models.php';
define('LIMIT', 500);
$controllerCalled = 1;
$_SESSION['page'] = "report";
$report = new Model();
$tours = new Tours();
$list = $report->_list("tours", "*");
$listTours = $tours->_list("tours", "*");
// La liste des titres des colonnes de la table tours.
$toursKeys = Constants::getListKey()['tours'];
//la taille du tableau tours dans la base
$size = sizeof($list);
//On divise le table par 500 pour ne pas afficher tout les donnees.
$div = $size > LIMIT ? $size / LIMIT : 1;
$limit = LIMIT;
for ($i = 0; $i < sizeof($list); $i++) {
foreach ($list[$i] as $key => $value) {
if ($key == "guardtours_id") {
$guardtours_id = $list[$i][$key];
$guard_id = $report->getBy("guardtours", "guard_id", "id", $guardtours_id);
$nom = $report->getBy("guard", "nom", "id", $guard_id);
$prenom = $report->getBy("guard", "prenom", "id", $guard_id);
$list[$i][$key] = $nom . " " . $prenom;
}
}
}
// $mention = $tours->getMention("09:00:00", 1);
include "../vue/report.php";
