<?php
include '../MicroCMS/src/model.php';
$connexion = new BDD('gestinv1');
$message = "";
$requete = "select nomClient, nomSite, numeroImmo, nomTypeequipement, numserie " . "from client, site, immobilisation, typeequipement";
$tab_inv = $connexion->select($requete);
?>
<!DOCTYPE html>
<html>
<head>
<?php
/** Inclusion des différents paramètres présent dans l'élément head commum aux pages */
//include("struct/param_headAccueil.php");
?>
<link rel="stylesheet" type="text/css" href="css/connexion.css">
<title>Gestion d'inventaire LMS Informatique</title>
</head>
<body>
<div id='cadre'>
<header><h1>Inventaire</h1></header>
<section>
<h1> Inventaire </h1>
<table cellspacing='10'><tr><th> Client </th>
<th> Site </th><th> n° Immo </th><th> Type d'équipement</th><th> n° Serie </th></tr>
<?php
foreach ($tab_inv as $ligne) {
//on crée un lien sur le numero de dt qui permet d'aller sur la page affichant le détail de cette dt
echo "<tr><td>" . $ligne['nomClient'] . "</td>\n";
public static function logUser($userId, $userFirstName, $userLastName, $userPicSrc)
{
$newStaticBdd = new BDD();
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
$userId = $newStaticBdd->real_escape_string(htmlspecialchars($userId));
$userPicSrc = $newStaticBdd->real_escape_string(htmlspecialchars($userPicSrc));
$userLink = $newStaticBdd->real_escape_string(htmlspecialchars(preg_replace("/[\\s\\W]+/", '', strtolower($userFirstName)) . "." . preg_replace("/[\\s\\W]+/", '', strtolower($userLastName))));
$userFirstName = $newStaticBdd->real_escape_string(htmlspecialchars($userFirstName));
$userLastName = $newStaticBdd->real_escape_string(htmlspecialchars($userLastName));
$userInfos = $newStaticBdd->select("fb_id, userlink, fb_firstname, fb_lastname, fb_picture, time_update", "users", "WHERE fb_id LIKE '" . $userId . "'");
$getUserInfos = $newStaticBdd->fetch_array($userInfos);
$getUserId = $newStaticBdd->num_rows($userInfos);
setcookie("username", $userFirstName . ' ' . $userLastName, time() + 7200, "/");
$_SESSION['SID_ID'] = session_id();
if (self::setToken($userId)) {
if ($getUserId != 1) {
$regUser = $newStaticBdd->insert("users", "fb_id, userlink, fb_firstname, fb_lastname, fb_picture, user_ip, isLoggedFB", "'" . $userId . "', '" . $userLink . "', '" . $userFirstName . "', '" . $userLastName . "', '" . $userPicSrc . "', '" . $ip . "', 1");
$dataArray['result'] = true;
$dataArray['error'] = null;
$dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " registred !";
} else {
$regUser = $newStaticBdd->update("users", "fb_id = '" . $userId . "', userlink = '" . $userLink . "', fb_firstname = '" . $userFirstName . "', fb_lastname = '" . $userLastName . "', fb_picture = '" . $userPicSrc . "', user_ip = '" . $ip . "', isLoggedFB = 1", "WHERE fb_id LIKE '" . $userId . "'");
$dataArray['result'] = true;
$dataArray['error'] = null;
$dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " updated and logged !";
}
} else {
$dataArray['result'] = false;
$dataArray['error'] = "Token not set !";
$dataArray['reply'] = "User not logged !";
}
return $dataArray;
}
public static function getUserInfos()
{
$dataArray = array();
if (User::isAdmin()) {
$newStaticBdd = new BDD();
$UserInfos = $newStaticBdd->select("id, fb_firstname, fb_lastname, fb_picture, email, user_ip", "users", "ORDER BY id ASC");
while ($getUserInfos = $newStaticBdd->fetch_array($UserInfos)) {
ob_start();
include '../models/users-infos-container.php';
$dataArray['reply'] .= ob_get_contents();
ob_end_clean();
}
return $dataArray;
}
}
