Log of /trunk/data/pgsql/v3.2.0-dev.sql
Parent Directory
| Revision Log
Revision
1008 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Dec 6 16:21:28 2012 UTC
(12 years, 2 months ago)
by
vpihour
File length: 52516 byte(s)
Diff to
previous 1005
,
to
selected 605
Ajout de nouveaux droits pour le menu de récupération des récépissés de demande et pour afficher les actions de supression et de modification, du portlet de l'objet demande, uniquement aux administrateurs
Revision
974 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Dec 3 18:06:16 2012 UTC
(12 years, 2 months ago)
by
atreal
File length: 51140 byte(s)
Diff to
previous 947
,
to
selected 605
Correction du bug empéchant la création de nouveaux messages lié au nom
de la séquence message_seq qui ne respecte pas la charte de nommage openmairie :
la séquence doit avoir pour nom celui de la table
changement du champ de clé primaire de la table dossier_message
=> renommage du champ en dossier_message conformément à la charte de nommage openairie
=> modification de la séquence liée
=> modification de tous les sql en découlant
Revision
946 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 30 15:58:49 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 51051 byte(s)
Diff to
previous 939
,
to
selected 605
Ajout d'un option (option_ERP) dans la table om_parametre permettant d'activer ou non le menu des messages ERP
Revision
917 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Nov 29 18:51:21 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 50127 byte(s)
Diff to
previous 915
,
to
selected 605
Modification de la table nature (agrandissement de la taille des champs)
Ajout du champ dossier_autorisation_type_detaille dans la table dossier
Revision
915 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Nov 29 18:25:39 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 49168 byte(s)
Diff to
previous 912
,
to
selected 605
Ajout d'envoi de message "Demande d'ouverture ERP PC" "rattache" au dossier DAACT, et correction d'envoi en cas d'annulation de la demande
Revision
891 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Nov 29 10:45:24 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 49186 byte(s)
Diff to
previous 886
,
to
selected 605
Correction de la module messages: date_emission est TIMESTAMP, la surcharges non-necessaires dans setvalF sont supprimes
Revision
886 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Nov 29 10:18:34 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 49181 byte(s)
Diff to
previous 883
,
to
selected 605
Modification du type de clé primaire de la table dossier_autorisation,
modification du type des clés étrangères liées à ce champ,
création d'un table de liaison entre dossier et demandeur
Revision
865 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Wed Nov 28 17:47:39 2012 UTC
(12 years, 2 months ago)
by
fmichon
File length: 48570 byte(s)
Diff to
previous 863
,
to
selected 605
Renommage de la table demande_genre en genre + Ajout de relations obligatoires entre dossier_autorisation_type_detaille et dossier_autorisation_type et entre dossier_autorisation_type_detaille et dossier_instruction_type
Revision
851 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Wed Nov 28 12:54:56 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 47421 byte(s)
Diff to
previous 840
,
to
selected 605
Envoi des messages: "ERP qualifie", "Demande d'ouverture ERP DAT", et "Depot de dossier DAT". Ajout des lignes dans table nature
Revision
840 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Nov 27 13:40:37 2012 UTC
(12 years, 2 months ago)
by
vpihour
File length: 47294 byte(s)
Diff to
previous 837
,
to
selected 605
Lorsqu'une demande d'affichage est effectuée, ajoute une instruction, dont l'événement est "affichage_obligatoire", au dossier n'ayant jamais été affiché
Revision
833 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Nov 26 14:36:51 2012 UTC
(12 years, 2 months ago)
by
vpihour
File length: 46720 byte(s)
Diff to
previous 826
,
to
selected 605
Ajout de l'action du sous-menu edition dans le menu guichet unique.
Génération d'un PDF regroupant les dossiers en cours d'instruction (dont l'état a pour statut "encours")
Revision
745 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Nov 19 13:47:32 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 37613 byte(s)
Diff to
previous 738
,
to
selected 605
Changement du type de dossier_message.contenu de varchar a text.
Bug: affichage de multiples lignes d'une message est errone
Fix: Le \n est ajoute par simple retour a la ligne suivante dans le services/REST/messagesmanage.php
Revision
737 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Nov 19 08:19:29 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 37725 byte(s)
Diff to
previous 730
,
to
selected 605
Changement des droits pour la table messages, qui est remplace par la table dossier_message, par des droits pour la table dossier_message
Revision
730 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 16 17:25:05 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 37704 byte(s)
Diff to
previous 725
,
to
selected 605
Correction d'une erreur de bdd sur le champ dossier_autorisation_type_detaille de la table dossier_autorisation
Revision
723 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 16 15:04:37 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 37589 byte(s)
Diff to
previous 721
,
to
selected 605
Correction d'une erreur de base de données ainsi que de l'objet sur lequel pointe le lien du menu.
Revision
721 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 16 14:45:49 2012 UTC
(12 years, 2 months ago)
by
nhaye
File length: 37568 byte(s)
Diff to
previous 710
,
to
selected 605
Modification du menu : changement de l'objet sur lequel on fait la recherche.
Ajout de champs dans la table dossier_autorisation, liaisons avec d'autre table.
Création d'une table de liaison entre la table demandeur et dossier_autorisation.
Régénération
Revision
697 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Nov 15 11:39:32 2012 UTC
(12 years, 2 months ago)
by
mlimic
File length: 35811 byte(s)
Diff to
previous 694
,
to
selected 605
Increased the number of chars that can be stored in the field om_parametre.libelle. Previously 20, now 40.
Revision
608 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Nov 6 11:02:46 2012 UTC
(12 years, 3 months ago)
by
mlimic
File length: 16333 byte(s)
Diff to
previous 605
table dossier now containts two boolean fields, enjeu_erp and enjeu_urba, instead of one boolean field enjeu
Revision
605 -
(
view)
(
annotate)
-
[selected]
Modified
Tue Nov 6 09:36:32 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 16351 byte(s)
Diff to
previous 603
Augmentation du nombre de caractères du champs chef de la table direction
Revision
603 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Nov 5 18:28:00 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 16350 byte(s)
Diff to
previous 599
,
to
selected 605
Ajout des colonnes manquante dans les tables division, direction et instructeur,
agrandissement de libellés à 100 caractères.
Revision
586 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 2 17:27:11 2012 UTC
(12 years, 3 months ago)
by
mlimic
File length: 15977 byte(s)
Diff to
previous 583
,
to
selected 605
creation of messages table, add of messages tab for the dossier currently opened; bug: some fields are set or reinitalized when the modification to 'lu' is made
Revision
577 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Nov 2 10:10:56 2012 UTC
(12 years, 3 months ago)
by
mlimic
File length: 15297 byte(s)
Diff to
previous 575
,
to
selected 605
remove double insert into om_profile from v3.2.0-dev.sql, deleted the constructor from the utils.class.php since now it is the same as that of the om_application.php due to the fact that the login in the MetierManager is now set to 'admin'; moved th function that checks that a date is inside of an inteval into MetierManager
Revision
563 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Wed Oct 31 10:25:25 2012 UTC
(12 years, 3 months ago)
by
vpihour
File length: 15146 byte(s)
Diff to
previous 561
,
to
selected 605
Personnalisation du formulaire d'ajout et du tableau lien entre un instructeur, le type de dossier et la localisation
Revision
561 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Wed Oct 31 09:57:15 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 14949 byte(s)
Diff to
previous 560
,
to
selected 605
Ajout d'un droit de modification du champs lu,
ce champ est automatiquement mis à false lorsqu'un avis est rendu ou modifié
Revision
560 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Oct 30 17:41:31 2012 UTC
(12 years, 3 months ago)
by
mlimic
File length: 14790 byte(s)
Diff to
previous 558
,
to
selected 605
addition of temporary table avis_consultation_tmp that is used to populate table avis_consultation
Revision
554 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Oct 30 11:34:29 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 12254 byte(s)
Diff to
previous 549
,
to
selected 605
Ajout de l'objet correspondant à l'historique des avis rendus par les services.
Ajout de l'entrée de menu et des droits d'accès à cet objet.
Revision
549 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Oct 30 09:42:33 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 12128 byte(s)
Diff to
previous 546
,
to
selected 605
Ajout du droit pour le ratachement d'un utilisateur à un service et d'un service à un utilisateur
Revision
545 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Oct 29 16:35:10 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 11980 byte(s)
Diff to
previous 544
,
to
selected 605
Suppression des colonnes inutiles de la table om_utilisateur suite à la migration vers la table instructeur
Revision
544 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Oct 29 16:25:36 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 11830 byte(s)
Diff to
previous 538
,
to
selected 605
Création d'une classe "abstraite" virtual_dbform.class.php
création de la classe demande_encours (accessible aux services),
création de la classe consultation_retour_service (permettant un retour d'avis des services),
ajout d'une méthode d'affichage de dialog box (jquery-ui dialog), fonctionne de la même façon que ajaxIt,
correction des entrées de menu,
ajout des droits necessaires.
Revision
538 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Fri Oct 26 09:53:58 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 11613 byte(s)
Diff to
previous 532
,
to
selected 605
Correction de la gestion d'erreur des retours de consultation, amélioration du menu et ajout du droits pour accéder aux retours de consultation.
Revision
532 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Oct 23 10:43:49 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 11535 byte(s)
Diff to
previous 520
,
to
selected 605
Modification de la méthode d'envoi de mail.
Agrandissement du champ valeur de la table om_parametre + régénération
Envoi de notification lors de l'ajout de consultation
Revision
520 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Oct 18 15:05:59 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 11207 byte(s)
Diff to
previous 519
,
to
selected 605
Modification de clé étrangère de dossier->om_utilisateur pour dossier->instructeur
Régénération
Ajout de la division sur le formulaire dossier
Revision
519 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Oct 18 13:22:10 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 10928 byte(s)
Diff to
previous 517
,
to
selected 605
Ajout des entrées de menu pour les table d'organisation,
ajout des droits correspondant à ces tables,
ajout de commentaires dans le script de maj.
Revision
517 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Oct 18 09:35:21 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 10409 byte(s)
Diff to
previous 514
,
to
selected 605
Ajout du parametre d'affichage de la division dans les dossiers
Modification des requètes (pour l'instant commentées : tester sur table instructeur)
Revision
510 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Wed Oct 17 11:02:35 2012 UTC
(12 years, 3 months ago)
by
vpihour
File length: 8549 byte(s)
Diff to
previous 509
,
to
selected 605
Mise à jour de la table service et du formulaire
Suppression des fichiers inutiles
Modification des etats pdf dans init.sql
Mise à jour des scripts concernant l'ancienne table avis
Revision
509 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Tue Oct 16 16:50:50 2012 UTC
(12 years, 3 months ago)
by
nhaye
File length: 8511 byte(s)
Diff to
previous 506
,
to
selected 605
Ajout de deux entrées de menu,
création des objets correspondants,
ajout de surcharge de tableau, recherche avancée/simple, tri
Ajout d'un champ booleen "enjeu" dans la table dossier,
régénération,
mise en gras des consultations non lues
Mise en forme du formulaire de consultation
Amélioration, nétoyage de méthodes obsolètes
Revision
500 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Mon Oct 15 08:34:00 2012 UTC
(12 years, 3 months ago)
by
vpihour
File length: 9099 byte(s)
Diff to
previous 498
,
to
selected 605
Ajout de deux champs dans la table service, création d'une nouvelle table et génération des fichiers PHP
Revision
489 -
(
view)
(
annotate)
-
[select for diffs]
Modified
Thu Oct 11 08:27:21 2012 UTC
(12 years, 3 months ago)
by
vpihour
File length: 7354 byte(s)
Diff to
previous 487
,
to
selected 605
Modification du fichier v3.2.0-dev.sql
Nouveaux fichiers generes suite a la modification de la base de donnees et correction des personnalisations
Revision
486 -
(
view)
(
annotate)
-
[select for diffs]
Added
Tue Oct 9 16:15:50 2012 UTC
(12 years, 3 months ago)
by
vpihour
File length: 5324 byte(s)
Diff
to
selected 605
Ajout du nouveau fichier de migration SQL pour la version 3.2.0
This form allows you to request diffs between any two revisions of this file.
For each of the two "sides" of the diff,
enter a numeric revision.