<?php
$where = "";
$_POST["date_jour"] = $_POST["date_jour"] == "" ? date('d/m/Y') : $_POST["date_jour"];
$nottoday = dateDifference(datebdd($_POST["date_jour"]), date('Y/m/d'), '%d') == 0 ? false : true;
$_POST["date_debut"] = jourdebutmois($_POST["date_jour"]) . " 00:00:00";
$_POST["date_fin"] = jourfinmois($_POST["date_jour"]) . " 23:59:59";
require $_SERVER["DOCUMENT_ROOT"] . __racine__ . "/tpl/script/rapport-kilometrique.php";
$sql="select *
from ".__racinebd__."device d
inner join positions p on d.devices_id=p.device_id and d.device_id=".$_POST["vehicule"]."
where valid=1 $where
ORDER BY p.time ASC";
*/
$sql = "select * \r\n from " . __racinebd__ . "device d\r\n inner join positions p on d.devices_id=p.device_id and d.device_id=" . $_POST["vehicule"] . "\r\n where latitude!=0 and longitude!=0 {$where} \r\n ORDER BY p.time ASC";
} else {
/*
$sql="select *
from ".__racinebd__."device d
inner join positions p on d.devices_id=p.device_id and d.device_id=".$_POST["vehicule"]."
where p.time>='".datebdd($_POST["date_jour"])." 00:00:00' and p.time<='".datebdd($_POST["date_jour"])." 23:59:59' and valid=1 and latitude!=0 and longitude!=0
ORDER BY p.time ASC";
*/
$sql = "select * \r\n from " . __racinebd__ . "device d\r\n inner join positions p on d.devices_id=p.device_id and d.device_id=" . $_POST["vehicule"] . "\r\n where p.time>='" . datebdd($_POST["date_jour"]) . " 00:00:00' and p.time<='" . datebdd($_POST["date_jour"]) . " 23:59:59' and latitude!=0 and longitude!=0\r\n ORDER BY p.time ASC";
}
//print $sql."<br>";
$linkconduite = query($sql);
$tbl["conduite"] = 0;
$lastspeed = 0;
$lastlat = 0;
$lastlon = 0;
$lastdistance = 0;
$totalconduite = 0;
$totaldistance = 0;
$totalarret = 0;
$trajet = array();
$i = 0;
$lastdate = 0;
$vitessemoy = array();
<?php
$_POST["date_jour"] = $_POST["date_jour"] == "" ? date('d/m/Y') : $_POST["date_jour"];
if ($_POST["date_jour"] != "") {
$where .= " and p.time>='" . datebdd(jourdebutsemaine(date2tab($_POST["date_jour"]))) . " 00:00:00'";
$where .= " and p.time<='" . datebdd(jourfinsemaine(date2tab($_POST["date_jour"]))) . " 23:59:59'";
}
require "rapport-gen.php";
<?php
$_POST["date_jour"] = $_POST["date_jour"] == "" ? date('d/m/Y') : $_POST["date_jour"];
if ($_POST["date_jour"] != "") {
$where .= " and p.time>='" . datebdd(jourdebutmois($_POST["date_jour"])) . " 00:00:00'";
$where .= " and p.time<='" . datebdd(jourfinmois($_POST["date_jour"])) . " 23:59:59'";
}
require "rapport-gen.php";
//$TxtTitreDesc="Textes";
$table = __racinebd__ . "compte_log";
$tablekey = "compte_log_id";
//$txtretour=false;
if ($_GET["mode"] != "") {
if ($_GET["mode"] == "list") {
//$szQuery = "select * from $table where supprimer = 0";
$where = "";
if ($_POST["compte_id"] != "") {
$where .= " and c.compte_id=" . $_POST["compte_id"];
}
if ($_POST["date_debut"] != "") {
$where .= " and t.date_connexion>='" . datebdd($_POST["date_debut"]) . " 00:00:00'";
}
if ($_POST["date_fin"] != "") {
$where .= " and t.date_connexion<='" . datebdd($_POST["date_fin"]) . " 23:59:59'";
}
$szQuery = "select * from {$table} t inner join " . __racinebd__ . "compte c on t.compte_id=c.compte_id where supprimer=0 and actif=1 {$where}";
//print $szQuery;
$ImgAjout = false;
$tabcolonne = array("Compte" => "nom", "Date de connexion" => "date_connexion");
$filtre = "filtrestat.php";
$update = false;
$delete = false;
$search = false;
$notview = true;
$defaultcoltri = "date_connexion";
$defaultorder = "desc";
require "../../include/template_list.php";
}
}
query($sql);
$msgsave = "Sauvegarde éffectuée";
}
if ($_POST["id"] != "" && $_POST["mode"] == "modif") {
/*
$sql="update ".__racinebd__."device set kilometreentretien='".$_POST["kilometreentretien"]."',dateentretien='".datebdd($_POST["dateentretien"])."',nbheureentretien='".$_POST["nbheureentretien"]."' where owner_id=".$_POST["id"];
//print $sql."<br>";
query($sql);
*/
$sql = "update " . __racinebd__ . "alarme_entretien set km='" . $_POST["km"] . "',\r\n date='" . datebdd($_POST["date"]) . "',entretien_compte_id='" . $_POST["entretien_compte"] . "' where alarme_entretien_id=" . $_POST["id"];
//print $sql;
query($sql);
$msgsave = "Sauvegarde éffectuée";
}
if ($_POST["agence"] != "" && $_POST["mode"] == "ajout") {
$sql = "insert into " . __racinebd__ . "alarme_entretien (device_id,km,date,entretien_compte_id)\r\n values('" . $_POST["vehicule"] . "','" . $_POST["km"] . "','" . datebdd($_POST["date"]) . "','" . $_POST["entretien_compte"] . "')";
query($sql);
$msgsave = "Sauvegarde éffectuée";
}
if ($_POST["agence"] != "") {
//listing des véhicules
/*
$sql = getsqllistvehicule()." and agence_compte_id=".$_POST["agence"];
$link=query($sql);
while($tbl=fetch($link)){
//mettre a jour les km
$sql="select * from ".__racinebd__."type_compte tc where type_compte_id=".$tbl["type_compte_id"];
//print $sql;
$link2=query($sql);
$tbl_type=fetch($link2);
$tbl["type"]=$tbl_type;
