You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
3.3 KiB
99 lines
3.3 KiB
50040^Nutzungsantrag suchen^--Freemarker Template\ |
|
<sqlvars>\ |
|
<sqlvar name="UsernameBenutzerantraegeNichtFBs">select benutzer from userinfo where info='BenutzerantraegeNichtFBs'</sqlvar>\ |
|
</sqlvars>\ |
|
create temp table tmp_erg\ |
|
(tid integer,\ |
|
antragssteller varchar(250),\ |
|
antragsdatum date,\ |
|
genehmigung1_zeitpunkt timestamp,\ |
|
genehmigung2_zeitpunkt timestamp,\ |
|
nextedit1 varchar(255),\ |
|
nextedit2 varchar(255)\ |
|
);\ |
|
insert into tmp_erg \ |
|
select A.tid,\ |
|
coalesce(A.antragsteller_titel||' ','')||A.antragsteller_vorname||' '||A.antragsteller_nachname,\ |
|
A.antragsdatum,\ |
|
genehmigung1_zeitpunkt,\ |
|
genehmigung2_zeitpunkt,\ |
|
'/superx/edit/userantrag/user_antrag_anzeigen.jsp?antrag='||A.tid ,\ |
|
<#if UserIsAdmin>\ |
|
'/superx/edit/userantrag/user_antrag_edit.jsp?tid='||A.tid \ |
|
<#else>\ |
|
''\ |
|
</#if>\ |
|
from user_antrag A \ |
|
where\ |
|
1=1\ |
|
/* and A.tid in (<<Antrag Laufnummer>>) */\ |
|
/* and A.antragsteller_nachname=<<Antragsteller Nachname>> */\ |
|
/* and A.antragsdatum>=date_val(<<Antragsdatum ab>>) */\ |
|
/* and position(<<UUID>> in A.uuid) >0 */\ |
|
<#if Genehmigung!=''>\ |
|
<#switch Genehmigung>\ |
|
<#case "og1">\ |
|
and genehmigung1_zeitpunkt is null\ |
|
<#break>\ |
|
<#case "og2">\ |
|
and genehmigung2_zeitpunkt is null\ |
|
<#break>\ |
|
<#case "mg1">\ |
|
and genehmigung2_zeitpunkt is not null\ |
|
<#break>\ |
|
<#case "mg2">\ |
|
and genehmigung2_zeitpunkt is not null\ |
|
<#break>\ |
|
</#switch>\ |
|
</#if>\ |
|
<#if !UserIsAdmin> --Genehmigung2-Maske?Datacockpit=AlleRechte\ |
|
and (\ |
|
--entweder Antragsempfänger -> Genehmigung 1 \ |
|
(A.antragsempfaenger_id in (select E.tid from user_antrag_empfaenger E, user_antrag_empfaenger_userinfo_bez U\ |
|
where E.tid=U.antragsempfaenger_id\ |
|
and U.user_id=<<UserID>>)\ |
|
)\ |
|
--oder Genehmigung2:\ |
|
or <<UserID>> in (select user_id from user_antrag_genehmigung2_userinfo_bez)\ |
|
)\ |
|
</#if>\ |
|
\ |
|
;\ |
|
\ |
|
select tid,\ |
|
antragssteller,\ |
|
antragsdatum,\ |
|
genehmigung1_zeitpunkt,\ |
|
genehmigung2_zeitpunkt,\ |
|
nextedit1,\ |
|
nextedit2\ |
|
from tmp_erg\ |
|
order by 1;^--Freemarker Template\ |
|
XIL List\ |
|
drop_and_delete movable_columns sizable_columns horizontal_scrolling\ |
|
white_space_color=COLOR_WHITE fixed_columns=2\ |
|
min_heading_height=35\ |
|
Column CID=0 heading_text="ID" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=20 text_size=100\ |
|
Column CID=1 heading_text="Antragsteller" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=20 text_size=100\ |
|
Column CID=1 heading_text="Antragsdatum" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=20 text_size=100\ |
|
Column CID=2 heading_text="Genehmigung1" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=20 text_size=15\ |
|
Column CID=3 heading_text="Genehmigung2" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=30 text_size=15\ |
|
Column CID=4 heading_text="Ansehen / Bearbeiten" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=50 text_size=15 \ |
|
<#if UserIsAdmin>\ |
|
Column CID=4 heading_text="Verwalten" explanation="" center_heading\ |
|
row_selectable col_selectable heading_platform readonly\ |
|
width=50 text_size=15\ |
|
</#if>\ |
|
@@@^ ^ ^Übersicht und ggfs. Bearbeitungsmöglichkeit für Benutzeranträge^drop table tmp_erg;^^1^440^360^^0^^
|
|
|