"._("calcul de la place")); /** * ONGLETS */ // Ouverture de la balise - Conteneur d'onglets echo "
\n"; // Affichage de la liste des onglets echo "\n\n"; /** * */ // echo "\n
\n"; // $f->displaySubTitle(" -> "._("calcul de la place")); // echo "\n"; // Exécution du traitement if (isset($_POST["traitement_calcul_concession_place_form_valid"])) { // echo "
\n"; // debut de transaction [begining transaction) $f->db->autoCommit(true); // $msg = ""; // $sql = "select * from ".DB_PREFIXE."emplacement"; $res = $f->db->query($sql); $f->addToLog("app/trt_calcul_concession_place.php: db->query(\"".$sql."\");", VERBOSE_MODE); $f->isDatabaseError($res); // $valF = array(); // while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) { // $sql1 = " SELECT sum(taille) FROM ".DB_PREFIXE."defunt "; $sql1 .= " WHERE emplacement =".$row['emplacement']; // $valF['placeoccupe'] = $f->db->getOne($sql1); $f->addToLog("app/trt_calcul_concession_place.php: db->getone(\"".$sql1."\");", VERBOSE_MODE); $f->isDatabaseError($res); // if ($valF['placeoccupe'] == '') { $valF['placeoccupe'] = 0; } $cle = "emplacement=".$row['emplacement']; $res1 = $f->db->autoExecute(DB_PREFIXE."emplacement", $valF, DB_AUTOQUERY_UPDATE, $cle); $f->addToLog("app/trt_calcul_concession_place.php: db->autoExecute(\"".DB_PREFIXE."emplacement\", ".print_r($valF, true).", DB_AUTOQUERY_UPDATE, \"".$cle."\");", VERBOSE_MODE); $f->isDatabaseError($res1); } // $msg=$msg."
".$res->numRows()." "._("concession")." "._("calcul_placeoccupe"); // enregistrement $msg en /tmp // [record file in directory /tmp] $aff="recalcul_place"; $fichier = "../tmp/".$aff."_".date("dmy_Gis").".htm"; $inf = fopen($fichier,"w"); $ent= date("d/m/Y G:i:s"). "
No "._("collectivite")." : ".$_SESSION['coll']. "
"._("utilisateur")." : ".$_SESSION['login']."
". "=========================================="."
"; $msg=$ent."
".$msg ; fwrite($inf,$msg); fclose($inf); // ************************************************** echo $msg; // fin de transaction [end transaction] $f->db->commit(); // echo "
\n"; } // echo "
\n"; echo "\t\n"; echo "
\n"; // echo "\n"; // echo "
\n"; /** * */ // Fermeture de la balise - Conteneur d'onglets echo "
\n"; ?>