[opencourrier-Commits] r1107 - branches/5.1.0/data/pgsql

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

Author: jbastide
Date: 2020-06-10 11:49:22 +0200 (Wed, 10 Jun 2020)
New Revision: 1107

Modified:
branches/5.1.0/data/pgsql/init_data.sql
branches/5.1.0/data/pgsql/init_parametrage_metier.sql
Log:
widget et dashboard


Modified: branches/5.1.0/data/pgsql/init_data.sql
===================================================================
--- branches/5.1.0/data/pgsql/init_data.sql 2020-06-10 09:27:02 UTC (rev 1106)
+++ branches/5.1.0/data/pgsql/init_data.sql 2020-06-10 09:49:22 UTC (rev 1107)
@@ -49,16 +49,8 @@

INSERT INTO emetteur (emetteur, civilite, emetteurnom, emetteurprenom, emetteurad1, emetteurad2, emetteurcp, emetteurville, tel, type_correspondant, courriel, en_cours) VALUES (1, 3, 'DURANT', 'pierrette', '5 rue des postes', NULL, '13200', 'arles', NULL, 5, NULL, true);

-INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (1, 'courrier_arrive_du_jour', '', '', 'file','courrier_arrivee_du_jour_mail', '');
-INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (2, 'courrier_arrivee', '', '', 'file', 'courrier_arrivee', '');
-INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (3, 'diffusion_non_validee', '', '', 'file', 'diffusion_non_validee', '');
-INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (4, 'tache_non_solde', '', '', 'file', 'tachenonsolde', '');


-INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (1, 1, 'C1', 1, 1);
-INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (2, 1, 'C2', 1, 2);
-INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (3, 1, 'C3', 1, 3);
-INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (4, 1, 'C2', 2, 4);



@@ -65,6 +57,3 @@



-
-
-

Modified: branches/5.1.0/data/pgsql/init_parametrage_metier.sql
===================================================================
--- branches/5.1.0/data/pgsql/init_parametrage_metier.sql 2020-06-10 09:27:02 UTC (rev 1106)
+++ branches/5.1.0/data/pgsql/init_parametrage_metier.sql 2020-06-10 09:49:22 UTC (rev 1107)
@@ -140,6 +140,19 @@
INSERT INTO type_dossier (type_dossier, libelle) VALUES (3, 'pièce jointe');
SELECT pg_catalog.setval('type_courrier_seq', 3, true);

+-- widget

+INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (1, 'courrier_arrive_du_jour', '', '', 'file','courrier_arrivee_du_jour_mail', '');
+INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (2, 'courrier_arrivee', '', '', 'file', 'courrier_arrivee', '');
+INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (3, 'diffusion_non_validee', '', '', 'file', 'diffusion_non_validee', '');
+INSERT INTO om_widget (om_widget, libelle, lien, texte, type, script, arguments) VALUES (4, 'tache_non_solde', '', '', 'file', 'tachenonsolde', '');

+-- dashboard

+INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (1, 1, 'C1', 1, 1);
+INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (2, 1, 'C2', 1, 2);
+INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (3, 1, 'C3', 1, 3);
+INSERT INTO om_dashboard (om_dashboard, om_profil, bloc, "position", om_widget) VALUES (4, 1, 'C2', 2, 4);
+
+
+