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.
37 lines
1.8 KiB
37 lines
1.8 KiB
50100^Antrag Laufnummer^1^0^0^100^150^3^integer^30^0^1^<<SQL>>--freemarker template\ |
|
select A.tid,A.tid || '-' || E.name\ |
|
from user_antrag A, user_antrag_empfaenger E\ |
|
where A.antragsempfaenger_id=E.tid\ |
|
<#if !UserIsAdmin> \ |
|
and (\ |
|
--entweder Antragsempfänger -> Genehmigung 1 \ |
|
(<<UserID>> in (select U.user_id \ |
|
from user_antrag_empfaenger_userinfo_bez U\ |
|
where E.tid=U.antragsempfaenger_id)\ |
|
)\ |
|
--oder Genehmigung2:\ |
|
or <<UserID>> in (select user_id from user_antrag_genehmigung2_userinfo_bez)\ |
|
)\ |
|
</#if> order by 1 desc^ ^ ^ |
|
50101^Genehmigung^50^0^0^100^200^1^char^30^0^1^<<SQL>> select 'og1','ohne Genehmigung1' from xdummy union select 'og2','ohne Genehmigung2' from xdummy\ |
|
union select 'mg1','mit Genehmigung1' from xdummy union select 'mg2','mit Genehmigung2' from xdummy order by 2^ ^ ^ |
|
50102^Antragsteller Nachname^10^0^0^100^200^1^char^100^0^1^<<SQL>> \ |
|
<sqlvars>\ |
|
<sqlvar name="UsernameBenutzerantraegeNichtFBs">select benutzer from userinfo where info='BenutzerantraegeNichtFBs'</sqlvar>\ |
|
</sqlvars>\ |
|
\ |
|
select distinct antragsteller_nachname,antragsteller_nachname from user_antrag where 1=1 \ |
|
<#if !UserIsAdmin&&UserMaskRights?index_of(",9800230,")==-1> --Genehmigung2-Maske?Datacockpit=AlleRechte\ |
|
<#if Username?starts_with("dgf")> and antragsempfaenger='${Username}'\ |
|
<#elseif Username==UsernameBenutzerantraegeNichtFBs> and antragsempfaenger='BenutzerantraegeNichtFBs'\ |
|
\ |
|
<#else>\ |
|
and 1=0 -- keine Rechte!\ |
|
</#if>\ |
|
\ |
|
</#if>\ |
|
order by 1^ ^ ^ |
|
50103^Antragsdatum ab^2^0^0^100^200^1^date^30^0^0^^ ^ ^ |
|
50104^UUID^100^0^0^100^200^1^char^30^0^0^^ ^ ^ |
|
50105^Genehmigung 1^200^0^0^150^300^1^char^30^0^18^^^<<SQL>>select '../edit/userantrag/user_antrag_empfaenger_list.jsp' from xdummy;^ |
|
50106^Genehmigung 2^300^0^0^150^300^1^char^30^0^18^^^<<SQL>>select '../edit/userantrag/user_antrag_genehmigung2_userinfo_bez_list.jsp' from xdummy;^
|
|
|