noalyss-commit
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Noalyss-commit] [noalyss] 34/34: Merge


From: dwm
Subject: [Noalyss-commit] [noalyss] 34/34: Merge
Date: Wed, 17 Jan 2024 12:54:09 -0500 (EST)

sparkyx pushed a commit to branch devel
in repository noalyss.

commit edc0a3f238c5411ba1706773429506e004d286cb
Merge: a50a3a2f8 8bc3ce771
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Jan 17 18:51:33 2024 +0100

    Merge

 html/css/style-classic7.css                        |  14 ++
 html/css/style-print.css                           |  10 +-
 include/category_card.inc.php                      |   2 +-
 include/class/follow_up.class.php                  | 159 +++++++++++----------
 include/template/follow_up-display.php             |  57 +++++---
 include/template/followup-show-action-add.php      |   8 +-
 .../template/operation_exercice-input_source.php   |  20 ++-
 include/template/operation_exercice-list_draft.php |   1 +
 include/template/show-all-variable.php             |  12 ++
 sql/upgrade.sql                                    |  28 ++++
 10 files changed, 191 insertions(+), 120 deletions(-)

diff --cc sql/upgrade.sql
index e69de29bb,56e744ad2..118d757f2
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@@ -1,0 -1,27 +1,28 @@@
+ CREATE OR REPLACE FUNCTION comptaproc.get_follow_up_tree(action_gestion_id 
integer)
+     RETURNS SETOF integer
++
+     LANGUAGE plpgsql
+ AS $function$
+ declare
+     i int;
+     x int;
+     e int;
+ begin
+     for x in select aga_least
+              from action_gestion_related
+              where
+                  aga_greatest = action_gestion_id
+         loop
+             return next x;
+ 
+             for e in select *  from  comptaproc.get_follow_up_tree(x)
+                 loop
+                     return next e;
+                 end loop;
+ 
+         end loop;
+     return;
+ end;
+ $function$
+ ;
+         



reply via email to

[Prev in Thread] Current Thread [Next in Thread]