[openmairie-framework-Commits] r4959 - openmairie_exemple/branches/om5_rad/obj

[fray...@users.adullact.net]

Author: fraynaud
Date: 2024-05-08 22:16:48 +0200 (Wed, 08 May 2024)
New Revision: 4959

Modified:
openmairie_exemple/branches/om5_rad/obj/om_actions.class.php
Log:
action generer etat d om_actions




Modified: openmairie_exemple/branches/om5_rad/obj/om_actions.class.php
===================================================================
--- openmairie_exemple/branches/om5_rad/obj/om_actions.class.php 2024-05-08 12:32:56 UTC (rev 4958)
+++ openmairie_exemple/branches/om5_rad/obj/om_actions.class.php 2024-05-08 20:16:48 UTC (rev 4959)
@@ -59,9 +59,12 @@
}

function generer_etat(){
+ // initialisation
+ $idx=$this->getParameter('idx');
$obj = $this->getParameter('idxformulaire');
+ $variable = '&';
// recherche des champs
- $sql = "select omforms ";
+ $sql = "select column_name ";
$sql .= " from ".DB_PREFIXE."om_forms ";
$sql .= " where table_name ='".$obj."'";
$res = $this->f->db->query($sql);
@@ -68,32 +71,30 @@
$this->f->addToLog(__METHOD__."(): db->query(\"".$sql."\");", VERBOSE_MODE);
$this->f->isDatabaseError($res2);
// sql
- $temp='';
- $temp1='';
- if($field!=array()){
- for ($i = 0; $i < sizeof($field); $i++) {
- $temp2=explode(".",$field[$i]);
- $temp3=$temp2[1];
- $temp.=$field[$i].' as '.$temp3.',';
- $temp1.="[".$temp3.']'.chr(13).chr(10);
- }
- $temp=substr($temp, 0, strlen($temp)-1);
+ $t_etat='';
+ $t_requete="";
+ while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
+ $t=explode(".",$row['column_name']);
+ $t_requete .= $row['column_name']." AS ".$t[1]." ,";
+ $t_etat .= "[".$t[1]."]".chr(13).chr(10);
}
-
-
+ $t_requete = substr($t_requete, 0, strlen($t_requete)-1);
+ $t_etat = substr($t_etat, 0, strlen($t_etat)-1);
// om_requete
$this->f->db->autoCommit(false);
require_once "../core/obj/om_requete.class.php";
$om_requete = new om_requete_core("]", $this->f->db, $DEBUG);
- $variable = '&';
+
//
$val = array(
"om_requete" => "",
- "code" => $obj,
- "libelle" => __("Requete")." '".$obj."'",
+ "code" => $obj."_".$idx,
+ "libelle" => __("Requete")." '".$obj."_".$idx."'",
"description" => "créé le ".date('d/m/Y'),
"type" => "sql",
- "requete" => "select * from &DB_PREFIXE".$obj." where ".$obj.".".$obj."='".$variable."idx'",
+ "requete" => "select ".$obj.".".$obj.", ".$t_requete.
+ " from &DB_PREFIXE".$obj.
+ " where ".$obj.".".$obj."='".$variable."idx'",
"classe" => "",
"methode" => "",
"merge_fields" => "",
@@ -105,9 +106,32 @@
$this->addToMessage(__("Erreur lors de l'ajout de la requête. Contactez votre administrateur."));
return "";
}
- $this->addToMessage(__("création de requête"));
- //$this->f->db->commit();
-
+ $this->addToMessage(__("création de requête")." ".$om_requete->valF[$om_requete->clePrimaire]);
+ // etat
+ require_once "../core/obj/om_etat.class.php";
+ $om_etat = new om_etat_core("]", $this->f->db, $DEBUG);
+ //
+ $etat = $om_etat->get_default_values();
+ $etat['om_sql'] = $om_requete->valF[$om_requete->clePrimaire];
+ $etat['titre_om_htmletat'] = "le ".$variable."aujourdhui";
+ $etat['corps_om_htmletatex'] = $t_etat;
+ // id
+ $etat['id'] = $obj."_".$idx;
+ $etat['libelle'] = $obj."_".$idx." no code le ".date('d/m/Y');
+ $etat['actif'] = false;
+ // om_collectivite
+ $etat['om_collectivite'] = $_SESSION['collectivite'];
+ $etat['om_etat'] = "";
+ //
+ $ret = $om_etat->ajouter($etat, $this->f->db, null);
+ if ($ret !== true) {
+ //
+ $this->f->addToLog(__METHOD__."(): ".$om_etat->msg);
+ $this->f->displayMessage("error", __("Erreur lors de l'ajout de l'état. Contactez votre administrateur."));
+ return "";
+ }
+ $this->addToMessage(__("création d'état")." ".$om_etat->valF[$om_etat->clePrimaire]);
+ $this->f->db->commit();
}