View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001806NOALYSSBugpublic2020-06-17 17:122020-07-30 12:31
Reporterdanydb Assigned Todanydb  
PriorityurgenteSeveritycritiqueReproducibilitytoujours
Status ferméResolutioncorrigé 
Product Version7.4 
Target Version7.4.1Fixed in Version7.4.1 
Summary0001806: Bug dans la fonction pour vérifier si un journal est fermé
DescriptionRemplacement , arrive quand il y a beaucoup de journaux, il y a une erreur l'appel à is_closed

CREATE OR REPLACE FUNCTION comptaproc.jrn_check_periode()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
declare
bClosed bool;
str_status text;
ljr_tech_per jrn.jr_tech_per%TYPE;
ljr_def_id jrn.jr_def_id%TYPE;
lreturn jrn%ROWTYPE;
begin
if TG_OP='UPDATE' then
    ljr_tech_per :=OLD.jr_tech_per ;
    NEW.jr_tech_per := comptaproc.find_periode(to_char(NEW.jr_date,'DD.MM.YYYY'));
    ljr_def_id :=OLD.jr_def_id;
    lreturn :=NEW;
    if NEW.jr_date = OLD.jr_date then
        return NEW;
    end if;
    if comptaproc.is_closed(NEW.jr_tech_per,NEW.jr_def_id) = true then
              raise exception 'Periode fermee';
    end if;
end if;

if TG_OP='INSERT' then
    NEW.jr_tech_per := comptaproc.find_periode(to_char(NEW.jr_date,'DD.MM.YYYY'));
    ljr_tech_per :=NEW.jr_tech_per ;
    ljr_def_id :=NEW.jr_def_id;
    lreturn :=NEW;
end if;

if TG_OP='DELETE' then
    ljr_tech_per :=OLD.jr_tech_per;
    ljr_def_id :=OLD.jr_def_id;
    lreturn :=OLD;
end if;

if comptaproc.is_closed (ljr_tech_per,ljr_def_id) = true then
       raise exception 'Periode fermee';
end if;

return lreturn;
end;$function$
;
TagsNo tags attached.
Extension NoalyssAucun

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-06-17 17:12 danydb New Issue
2020-07-11 19:05 danydb Assigned To => danydb
2020-07-11 19:05 danydb Status new => resolved
2020-07-11 19:05 danydb Resolution open => fixed
2020-07-11 19:05 danydb Fixed in Version => 7.4.1
2020-07-11 19:05 danydb Product Version => 7.4
2020-07-11 19:05 danydb Target Version => 7.4.1
2020-07-30 12:31 danydb Status resolved => closed