[openads-Commits] r9719 - in branches/4.14.0-develop_max_caractere_id: data/pgsql gen/obj

[sof...@hephaestos.ovh.adullact.org]

Author: softime
Date: 2020-11-30 15:52:01 +0100 (Mon, 30 Nov 2020)
New Revision: 9719

Modified:
branches/4.14.0-develop_max_caractere_id/data/pgsql/v4.14.0.dev0.sql
branches/4.14.0-develop_max_caractere_id/gen/obj/action.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/dossier.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/etat.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/evenement.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/instruction.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/lien_demande_type_etat.class.php
branches/4.14.0-develop_max_caractere_id/gen/obj/transition.class.php
Log:
* Modification du nombre de caractere de certains champs (identifiant)


Modified: branches/4.14.0-develop_max_caractere_id/data/pgsql/v4.14.0.dev0.sql
===================================================================
--- branches/4.14.0-develop_max_caractere_id/data/pgsql/v4.14.0.dev0.sql 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/data/pgsql/v4.14.0.dev0.sql 2020-11-30 14:52:01 UTC (rev 9719)
@@ -407,4 +407,32 @@

--
-- END / [#9410] Ajout du champ "Date de dépôt en mairie"
---
\ No newline at end of file
+--
+
+--
+-- BEGIN / #1117 — Augmentation de la taille des identifiants
+--
+
+--action
+ALTER TABLE action ALTER COLUMN action TYPE character varying(150);
+ALTER TABLE evenement ALTER COLUMN action TYPE character varying(150);
+ALTER TABLE instruction ALTER COLUMN action TYPE character varying(150);
+
+-- etat
+ALTER TABLE etat ALTER COLUMN etat TYPE character varying(150);
+ALTER TABLE dossier ALTER COLUMN etat TYPE character varying(150);
+ALTER TABLE dossier ALTER COLUMN etat_pendant_incompletude TYPE character varying(150);
+ALTER TABLE evenement ALTER COLUMN etat TYPE character varying(150);
+ALTER TABLE instruction ALTER COLUMN archive_etat_pendant_incompletude TYPE character varying(150);
+ALTER TABLE instruction ALTER COLUMN archive_etat TYPE character varying(150);
+ALTER TABLE instruction ALTER COLUMN etat TYPE character varying(150);
+ALTER TABLE lien_demande_type_etat ALTER COLUMN etat TYPE character varying(150);
+ALTER TABLE transition ALTER COLUMN etat TYPE character varying(150);
+
+-- om_lettretype (correction)
+ALTER TABLE evenement ALTER COLUMN lettretype TYPE character varying(50);
+ALTER TABLE instruction ALTER COLUMN lettretype TYPE character varying(50);
+
+--
+-- END / #1117 — Augmentation de la taille des identifiants
+--

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/action.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/action.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/action.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 28/05/2019 16:15
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -447,7 +447,7 @@
* Methode setTaille
*/
function setTaille(&$form, $maj) {
- $form->setTaille("action", 20);
+ $form->setTaille("action", 30);
$form->setTaille("libelle", 30);
$form->setTaille("regle_etat", 30);
$form->setTaille("regle_delai", 30);
@@ -491,7 +491,7 @@
* Methode setMax
*/
function setMax(&$form, $maj) {
- $form->setMax("action", 20);
+ $form->setMax("action", 150);
$form->setMax("libelle", 60);
$form->setMax("regle_etat", 60);
$form->setMax("regle_delai", 60);

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/dossier.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/dossier.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/dossier.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 17/09/2020 13:03
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -1358,7 +1358,7 @@
function setTaille(&$form, $maj) {
$form->setTaille("dossier", 30);
$form->setTaille("annee", 10);
- $form->setTaille("etat", 20);
+ $form->setTaille("etat", 30);
$form->setTaille("instructeur", 11);
$form->setTaille("date_demande", 12);
$form->setTaille("date_depot", 12);
@@ -1397,7 +1397,7 @@
$form->setTaille("incompletude", 1);
$form->setTaille("evenement_suivant_tacite", 11);
$form->setTaille("evenement_suivant_tacite_incompletude", 11);
- $form->setTaille("etat_pendant_incompletude", 20);
+ $form->setTaille("etat_pendant_incompletude", 30);
$form->setTaille("date_limite_incompletude", 12);
$form->setTaille("delai_incompletude", 11);
$form->setTaille("dossier_libelle", 25);
@@ -1449,7 +1449,7 @@
function setMax(&$form, $maj) {
$form->setMax("dossier", 30);
$form->setMax("annee", 2);
- $form->setMax("etat", 20);
+ $form->setMax("etat", 150);
$form->setMax("instructeur", 11);
$form->setMax("date_demande", 12);
$form->setMax("date_depot", 12);
@@ -1488,7 +1488,7 @@
$form->setMax("incompletude", 1);
$form->setMax("evenement_suivant_tacite", 11);
$form->setMax("evenement_suivant_tacite_incompletude", 11);
- $form->setMax("etat_pendant_incompletude", 20);
+ $form->setMax("etat_pendant_incompletude", 150);
$form->setMax("date_limite_incompletude", 12);
$form->setMax("delai_incompletude", 11);
$form->setMax("dossier_libelle", 25);

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/etat.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/etat.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/etat.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 03/05/2018 09:18
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -97,7 +97,7 @@
* Methode setTaille
*/
function setTaille(&$form, $maj) {
- $form->setTaille("etat", 20);
+ $form->setTaille("etat", 30);
$form->setTaille("libelle", 30);
$form->setTaille("statut", 30);
}
@@ -106,7 +106,7 @@
* Methode setMax
*/
function setMax(&$form, $maj) {
- $form->setMax("etat", 20);
+ $form->setMax("etat", 150);
$form->setMax("libelle", 50);
$form->setMax("statut", 60);
}

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/evenement.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/evenement.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/evenement.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 13/06/2018 12:44
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -501,8 +501,8 @@
function setTaille(&$form, $maj) {
$form->setTaille("evenement", 11);
$form->setTaille("libelle", 30);
- $form->setTaille("action", 20);
- $form->setTaille("etat", 20);
+ $form->setTaille("action", 30);
+ $form->setTaille("etat", 30);
$form->setTaille("delai", 11);
$form->setTaille("accord_tacite", 10);
$form->setTaille("delai_notification", 11);
@@ -527,12 +527,12 @@
function setMax(&$form, $maj) {
$form->setMax("evenement", 11);
$form->setMax("libelle", 70);
- $form->setMax("action", 20);
- $form->setMax("etat", 20);
+ $form->setMax("action", 150);
+ $form->setMax("etat", 150);
$form->setMax("delai", 11);
$form->setMax("accord_tacite", 3);
$form->setMax("delai_notification", 11);
- $form->setMax("lettretype", 60);
+ $form->setMax("lettretype", 50);
$form->setMax("consultation", 3);
$form->setMax("avis_decision", 11);
$form->setMax("restriction", 255);

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/instruction.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/instruction.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/instruction.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 22/09/2020 09:42
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -1170,9 +1170,9 @@
$form->setTaille("complement_om_html", 80);
$form->setTaille("complement2_om_html", 80);
$form->setTaille("dossier", 30);
- $form->setTaille("action", 20);
+ $form->setTaille("action", 30);
$form->setTaille("delai", 11);
- $form->setTaille("etat", 20);
+ $form->setTaille("etat", 30);
$form->setTaille("accord_tacite", 10);
$form->setTaille("delai_notification", 11);
$form->setTaille("archive_delai", 20);
@@ -1181,7 +1181,7 @@
$form->setTaille("archive_date_limite", 12);
$form->setTaille("archive_date_notification_delai", 12);
$form->setTaille("archive_accord_tacite", 10);
- $form->setTaille("archive_etat", 20);
+ $form->setTaille("archive_etat", 30);
$form->setTaille("archive_date_decision", 12);
$form->setTaille("archive_avis", 20);
$form->setTaille("archive_date_validite", 12);
@@ -1215,7 +1215,7 @@
$form->setTaille("archive_incompletude", 1);
$form->setTaille("archive_evenement_suivant_tacite", 11);
$form->setTaille("archive_evenement_suivant_tacite_incompletude", 11);
- $form->setTaille("archive_etat_pendant_incompletude", 20);
+ $form->setTaille("archive_etat_pendant_incompletude", 30);
$form->setTaille("archive_date_limite_incompletude", 12);
$form->setTaille("archive_delai_incompletude", 11);
$form->setTaille("code_barres", 12);
@@ -1254,13 +1254,13 @@
$form->setMax("destinataire", 30);
$form->setMax("date_evenement", 12);
$form->setMax("evenement", 11);
- $form->setMax("lettretype", 40);
+ $form->setMax("lettretype", 50);
$form->setMax("complement_om_html", 6);
$form->setMax("complement2_om_html", 6);
$form->setMax("dossier", 30);
- $form->setMax("action", 20);
+ $form->setMax("action", 150);
$form->setMax("delai", 11);
- $form->setMax("etat", 20);
+ $form->setMax("etat", 150);
$form->setMax("accord_tacite", 3);
$form->setMax("delai_notification", 11);
$form->setMax("archive_delai", 20);
@@ -1269,7 +1269,7 @@
$form->setMax("archive_date_limite", 12);
$form->setMax("archive_date_notification_delai", 12);
$form->setMax("archive_accord_tacite", 3);
- $form->setMax("archive_etat", 20);
+ $form->setMax("archive_etat", 150);
$form->setMax("archive_date_decision", 12);
$form->setMax("archive_avis", 20);
$form->setMax("archive_date_validite", 12);
@@ -1303,7 +1303,7 @@
$form->setMax("archive_incompletude", 1);
$form->setMax("archive_evenement_suivant_tacite", 11);
$form->setMax("archive_evenement_suivant_tacite_incompletude", 11);
- $form->setMax("archive_etat_pendant_incompletude", 20);
+ $form->setMax("archive_etat_pendant_incompletude", 150);
$form->setMax("archive_date_limite_incompletude", 12);
$form->setMax("archive_delai_incompletude", 11);
$form->setMax("code_barres", 12);

Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/lien_demande_type_etat.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/lien_demande_type_etat.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/lien_demande_type_etat.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 03/05/2018 09:18
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -177,7 +177,7 @@
function setTaille(&$form, $maj) {
$form->setTaille("lien_demande_type_etat", 11);
$form->setTaille("demande_type", 11);
- $form->setTaille("etat", 20);
+ $form->setTaille("etat", 30);
}

/**
@@ -186,7 +186,7 @@
function setMax(&$form, $maj) {
$form->setMax("lien_demande_type_etat", 11);
$form->setMax("demande_type", 11);
- $form->setMax("etat", 20);
+ $form->setMax("etat", 150);
}



Modified: branches/4.14.0-develop_max_caractere_id/gen/obj/transition.class.php
===================================================================
--- branches/4.14.0-develop_max_caractere_id/gen/obj/transition.class.php 2020-11-30 14:51:22 UTC (rev 9718)
+++ branches/4.14.0-develop_max_caractere_id/gen/obj/transition.class.php 2020-11-30 14:52:01 UTC (rev 9719)
@@ -1,6 +1,6 @@
<?php
//$Id$
-//gen openMairie le 03/05/2018 09:18
+//gen openMairie le 30/11/2020 15:48

require_once "../obj/om_dbform.class.php";

@@ -175,7 +175,7 @@
*/
function setTaille(&$form, $maj) {
$form->setTaille("transition", 11);
- $form->setTaille("etat", 20);
+ $form->setTaille("etat", 30);
$form->setTaille("evenement", 11);
}

@@ -184,7 +184,7 @@
*/
function setMax(&$form, $maj) {
$form->setMax("transition", 11);
- $form->setMax("etat", 20);
+ $form->setMax("etat", 150);
$form->setMax("evenement", 11);
}