[Noalyss-commit] [noalyss] 02/09: Widget : add install.php for each

[dwm]

sparkyx pushed a commit to branch unstable
in repository noalyss.

commit 5a7a2c9b1190044506eb582845a0c4a26b603fd0
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Sun Aug 18 22:41:51 2024 +0200

    Widget : add install.php for each
---
 include/widget/agenda/install.php         | 28 ++++++++++++++++++++++++++++
 include/widget/coming_event/install.php   | 31 +++++++++++++++++++++++++++++++
 include/widget/last_event/install.php     | 30 ++++++++++++++++++++++++++++++
 include/widget/last_operation/install.php | 30 ++++++++++++++++++++++++++++++
 include/widget/mini_report/install.php    | 31 +++++++++++++++++++++++++++++++
 include/widget/todo_list/install.php      | 29 +++++++++++++++++++++++++++++
 sql/upgrade.sql                           |  7 -------
 7 files changed, 179 insertions(+), 7 deletions(-)

diff --git a/include/widget/agenda/install.php 
b/include/widget/agenda/install.php
new file mode 100644
index 000000000..1c92bc1f5
--- /dev/null
+++ b/include/widget/agenda/install.php
@@ -0,0 +1,28 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+('agenda','Présentation d''un calendrier avec les dates de rappel des 
événements',0,'Agenda')");
diff --git a/include/widget/coming_event/install.php 
b/include/widget/coming_event/install.php
new file mode 100644
index 000000000..8f231500e
--- /dev/null
+++ b/include/widget/coming_event/install.php
@@ -0,0 +1,31 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+        ('coming_event','Rappel pour des actions pour  aujourd''hui ou en 
retard',0,'Actions');
+
+
+");
diff --git a/include/widget/last_event/install.php 
b/include/widget/last_event/install.php
new file mode 100644
index 000000000..98bd34e8e
--- /dev/null
+++ b/include/widget/last_event/install.php
@@ -0,0 +1,30 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+        ('last_event','Affiche les derniers actions de suivi',0,'Suivi')
+"
+);
diff --git a/include/widget/last_operation/install.php 
b/include/widget/last_operation/install.php
new file mode 100644
index 000000000..bb64a0a98
--- /dev/null
+++ b/include/widget/last_operation/install.php
@@ -0,0 +1,30 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+        ('last_operation','Affichage des dernières opérations comptables 
saisies',0,'Comptabilité');
+
+");
diff --git a/include/widget/mini_report/install.php 
b/include/widget/mini_report/install.php
new file mode 100644
index 000000000..2358768f6
--- /dev/null
+++ b/include/widget/mini_report/install.php
@@ -0,0 +1,31 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+        ('mini_report','Affiche des rapports de comptabilité',1,'Rapport');
+
+"
+);
diff --git a/include/widget/todo_list/install.php 
b/include/widget/todo_list/install.php
new file mode 100644
index 000000000..4417f468e
--- /dev/null
+++ b/include/widget/todo_list/install.php
@@ -0,0 +1,29 @@
+<?php
+/*
+ *   This file is part of NOALYSS.
+ *
+ *   NOALYSS is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   NOALYSS is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with NOALYSS; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+// Copyright Author Dany De Bontridder danydb@aevalys.eu 18/08/24
+/*! 
+ * \file
+ * \brief 
+ */
+global $cn;
+
+$cn->exec_sql("
+INSERT INTO widget_dashboard (wd_code,wd_description,wd_parameter,wd_name) 
VALUES
+        ('todo_list','Liste de choses à faire , de petites 
notes',0,'Pense-Bête');
+");
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 605cce64b..c8746858c 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -57,13 +57,6 @@ INSERT INTO public.widget_dashboard 
(wd_id,wd_code,wd_description,wd_parameter,w
                                                                                
       (6,'mini_report','Affiche des rapports de comptabilité',1,'Rapport');
 
 
-INSERT INTO public.user_widget 
(use_login,dashboard_widget_id,uw_parameter,uw_order)
-    VALUES
-         ('admin',1,NULL,10),
-         ('admin',3,NULL,30),
-         ('admin',4,NULL,40),
-         ('admin',5,NULL,50),
-         ('admin',2,NULL,45);
 
 alter table  public.widget_dashboard add wd_name text;
 ALTER TABLE public.widget_dashboard ALTER COLUMN wd_name SET NOT NULL;