$nom = sqlproof($version["nom"]); $query = "INSERT INTO gamme (type, nom, idAnneeModele) VALUES ('$type', '$nom', '$idAnneeModele')"; print($query . '<br/>'); DBAccess::exec($query); } */ $docs = DBAccess::query("SELECT *\n\tFROM a_supprimer_documentVersion, a_supprimer_version\n\tWHERE a_supprimer_documentVersion.idVersion = a_supprimer_version.idVersion AND idModele=4\n"); foreach ($docs as $id => $doc) { $idDocumentVersion = $doc["idDocumentVersion"]; $idModele = $doc["idModele"]; $anneeModele = sqlproof($doc["anneeModele"]); $gamme = sqlproof($doc["type"]); $nomGamme = sqlproof($doc["nom"]); $ordre = sqlproof($doc["ordre"]); $source = sqlproof($doc["source"]); $date = sqlproof($doc["date"]); $legende = sqlproof($doc["legende"]); $idGamme = DBAccess::singleValue("SELECT idGamme\n\t\tFROM gamme, anneeModele\n\t\tWHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n\t\t\tAND annee = '{$anneeModele}'\n\t\t\tAND (type='{$gamme}' AND (nom<>'' AND nom='{$nomGamme}'))\n\t\t\tAND idModele = '{$idModele}'\n\t"); if (!$idGamme) { $idGamme = DBAccess::singleValue("SELECT idGamme\n\t\t\tFROM gamme, anneeModele\n\t\t\tWHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n\t\t\t\tAND annee = '{$anneeModele}'\n\t\t\t\tAND (type='{$gamme}' AND nom='')\n\t\t\t\tAND idModele = '{$idModele}'\n\t\t"); if (!$idGamme) { $idGamme = DBAccess::singleValue("SELECT idGamme\n\t\t\t\tFROM gamme, anneeModele\n\t\t\t\tWHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n\t\t\t\t\tAND annee = '{$anneeModele}'\n\t\t\t\t\tAND type='{$gamme}'\n\t\t\t\t\tAND idModele = '{$idModele}'\n\t\t\t"); if (!$idGamme) { $idGamme = DBAccess::singleValue("SELECT idGamme\n\t\t\t\t\tFROM gamme, anneeModele\n\t\t\t\t\tWHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n\t\t\t\t\t\tAND annee = '{$anneeModele}'\n\t\t\t\t\t\tAND nom='{$nomGamme}'\n\t\t\t\t\t\tAND idModele = '{$idModele}'\n\t\t\t\t"); } } } $query = "INSERT INTO documentGamme (idDocumentGamme, idGamme, ordre, source, date, legende) VALUES ('{$idDocumentVersion}', '{$idGamme}', '{$ordre}', '{$source}', '{$date}', '{$legende}')"; print $query . '<br/>'; //DBAccess::exec($query); }
<?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"; $idMarque = $_REQUEST["id"]; // SQL $marque = DBAccess::singleRow("SELECT * FROM marque WHERE idMarque='{$idMarque}'"); $modeles = DBAccess::query("SELECT * FROM modele WHERE idMarque='{$idMarque}' ORDER BY ordre"); $documentsMarque = DBAccess::query("SELECT * FROM documentMarque WHERE idMarque='{$idMarque}' ORDER BY ordre"); foreach ($modeles as $id => $modele) { $idModele = $modele['idModele']; $modeles[$id]['idDocEmblematique'] = DBAccess::singleValue("\n\t\tSELECT idDocumentGamme\n\t\tFROM documentGamme, gamme, anneeModele\n\t\tWHERE documentGamme.idGamme=gamme.idGamme\n\t\t AND gamme.idAnneeModele=anneeModele.idAnneeModele\n\t\t\tAND idModele='{$idModele}'\n\t\tORDER BY emblem_modele DESC\n\t"); } $marque['modeles'] = $modeles; $marque['docs'] = $documentsMarque; $marque['categories'] = isset($categories) ? $categories : null; $aText = "texte/marque/{$idMarque}.txt"; if (is_file($aText) && ($desc = implode(file($aText)))) { //$marque['histo'] = utf8_encode($desc); $marque['histo'] = $desc; } print json_encode($marque, JSON_PRETTY_PRINT);
$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);