<?php
include_once "db.php";
$idDocument = $_REQUEST["id"];
// SQL
$idModele = DBAccess::singleValue("SELECT idModele\n FROM documentGamme, gamme, anneeModele\n WHERE documentGamme.idGamme=gamme.idGamme\n AND gamme.idAnneeModele = anneeModele.idAnneeModele\n AND idDocumentGamme='{$idDocument}'");
DBAccess::exec("UPDATE documentGamme\n SET emblem_modele=0\n WHERE idGamme IN\n (\n SELECT idGamme\n FROM gamme, anneeModele\n WHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n AND idModele='{$idModele}'\n )");
DBAccess::exec("UPDATE documentGamme\n SET emblem_modele=1\n WHERE idDocumentGamme='{$idDocument}'");
$response = 'ok';
print json_encode($response, JSON_PRETTY_PRINT);
<?php
include_once "db.php";
$idModele = $_REQUEST["idModele"];
$mini = $_REQUEST["mini"];
// SQL
DBAccess::exec("UPDATE modele\n SET mini = '{$mini}'\n WHERE idModele = '{$idModele}'");
include_once "list-mini.php";
$status['query'] = "UPDATE documentMarque\n\t\t\t\t\t\t\t\t\t\t\t\t SET idMarque='{$idMarque}', ordre='{$ordre}', source='{$source}', date='{$date}', legende='{$legende}', motCle='{$motCle}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE idDocumentMarque = '{$idDocumentMarque}'";
}
} else {
if ($objet == "docGamme") {
$idGamme = getParam("idGamme");
$source = getParam("source");
$date = getParam("date");
$legende = getParam("legende");
$lien = getParam("lien");
if ($action == "add") {
$status['query'] = "INSERT INTO documentGamme(idGamme, source, date, legende, lien)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t VALUES('{$idGamme}', '{$source}', '{$date}', '{$legende}', '{$lien}')";
} else {
$idDocumentGamme = getParam("idDocumentGamme");
$status['query'] = "UPDATE documentGamme\n\t\t\t\t\t\t\t\t\t\t\t\t SET idGamme='{$idGamme}', source='{$source}', date='{$date}', legende='{$legende}', lien='{$lien}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE idDocumentGamme = '{$idDocumentGamme}'";
}
}
}
}
}
}
$status['result'] = DBAccess::exec($status['query']) ? "ok" : "ko";
if ($action == "add") {
if ($objet == "docMarque") {
$status['new'] = DBAccess::singleValue("SELECT max(idDocumentMarque) as id FROM documentMarque");
} else {
if ($objet == "docGamme") {
$status['new'] = DBAccess::singleValue("SELECT max(idDocumentGamme) as id FROM documentGamme");
}
}
}
print json_encode($status, JSON_PRETTY_PRINT);
