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.
34 lines
1.4 KiB
34 lines
1.4 KiB
50040^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^ ^ ^ |
|
50041^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^ ^ ^ |
|
50042^Antragsteller Nachname^10^0^0^100^200^1^char^100^0^1^<<SQL>> --freemarker template\ |
|
select distinct antragsteller_nachname,antragsteller_nachname \ |
|
from user_antrag U,user_antrag_empfaenger E where 1=1 \ |
|
<#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^ ^ ^ |
|
50043^Antragsdatum ab^2^0^0^100^200^1^date^30^0^0^^ ^ ^ |
|
50044^UUID^100^0^0^100^200^1^char^30^0^0^^ ^ ^
|
|
|