Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
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.
116 lines
4.2 KiB
116 lines
4.2 KiB
43110^Bewerbungen Datenblatt (CO)^--Freemarker Template\ |
|
<#include "SQL_lingua_franca"/>\ |
|
<#include "SuperX_general"/>\ |
|
<#include "DatenblattSQLGenerator"/>\ |
|
\ |
|
--ram excelexport \ |
|
\ |
|
<sqlvars>\ |
|
<sqlvar name="basetable" ><![CDATA[\ |
|
SELECT distinct name\ |
|
from sx_tables\ |
|
where name in ('costage_bw_antr_aggr');]]>\ |
|
</sqlvar>\ |
|
<sqlvar name="getJoinTables" type="hashsequence"><![CDATA[\ |
|
SELECT distinct name\ |
|
from sx_tables\ |
|
where name in (''\ |
|
${DatenblattTables(<<tablestylesheet>>,"<<Weitere Tabellen>>",.vars["Weitere TabellenObject"].allKeys)}\ |
|
\ |
|
)\ |
|
order by 1;]]>\ |
|
</sqlvar>\ |
|
<sqlvar name="getJoinWhereClauses" type="hashsequence"><![CDATA[\ |
|
select table_name || '.' || name || '=' || foreignkey_tab || '.' || foreignkey_col as condition,\ |
|
table_name ,\ |
|
foreignkey_tab\ |
|
from sx_fields where table_name in ('${basetable}'\ |
|
${DatenblattTables(<<tablestylesheet>>,"<<Weitere Tabellen>>",.vars["Weitere TabellenObject"].allKeys)} )\ |
|
and foreignkey_tab in ('-xy'\ |
|
${DatenblattTables(<<tablestylesheet>>,"<<Weitere Tabellen>>",.vars["Weitere TabellenObject"].allKeys)})\ |
|
;]]>\ |
|
</sqlvar>\ |
|
<sqlvar name="getSelectClause" type="hashsequence"><![CDATA[\ |
|
SELECT name,\ |
|
caption,\ |
|
field_type,\ |
|
is_primarykey,\ |
|
foreignkey_tab,\ |
|
foreignkey_col,\ |
|
foreignkey_cap,\ |
|
foreignkey_cond,\ |
|
foreignkey_func,\ |
|
table_name,\ |
|
foreignkey_uniquename\ |
|
from sx_fields\ |
|
where table_name in ('${basetable}'\ |
|
${DatenblattTables(<<tablestylesheet>>,"<<Weitere Tabellen>>",.vars["Weitere TabellenObject"].allKeys)}\ |
|
)\ |
|
and currentlyused=1\ |
|
${DatenblattFields(<<tablestylesheet>>,"<<Felder>>",FelderObject.allKeys)}\ |
|
order by 2,3;]]>\ |
|
</sqlvar>\ |
|
</sqlvars>\ |
|
\ |
|
<#assign filter="and bw_typ_kb not in ('MBW')\ |
|
/* AND bw_zul_art_nr in (<<Zulassungsart>>) */\ |
|
/* and costage_bw_antr_aggr.st_studiengang_nr in (select G.st_studiengang_nr from costage_st_studiengaenge G where G.abschluss in (<<Abschluss>>)) */\ |
|
/* and studiengang_nr =<<Studiengang-Nr.>> */\ |
|
/* and fach_nr =<<Fach-Nr.>> */\ |
|
/* and costage_bw_antr_aggr.st_studstamm_nr in (select S.st_studstamm_nr from costage_st_studierendenstammdaten S where S.st_land1_nr in (<<Staatsangehörigkeit>>) ) */\ |
|
/* and costage_bw_antr_aggr.st_studstamm_nr in (select S2.st_studstamm_nr from costage_st_studierendenstammdaten S2 where S2.geschlecht = <<Geschlecht>> ) */\ |
|
/* and costage_bw_antr_aggr.unikey=<<Hochschule>> */\ |
|
/* and semester >= <<Seit Semester>> */\ |
|
/* and semester <= <<Bis Semester>> */\ |
|
/* and fachsemester <= <<bis Fachsemester>> */\ |
|
/* and st_studstamm_nr =<<Person-Nr.>> */\ |
|
" />\ |
|
\ |
|
/* <#assign filter = filter + " and 's_' || costage_bw_antr_aggr.st_studiengang_nr in "+Studiengang.allNeededKeysList /> --<<Studiengang>> */ \ |
|
\ |
|
<#if "<<Matrikel-Nr.>>"!="">\ |
|
<#assign filter=filter+" and costage_bw_antr_aggr.matrikelnummer in (<<Matrikel-Nr.>>)"?replace("'","")/>\ |
|
</#if>\ |
|
\ |
|
\ |
|
<#assign fach_filter="1=1" />\ |
|
--Default: TSG\ |
|
/* <#assign fach_filter="costage_bw_antr_aggr.st_studiengang_nr in (select G.st_studiengang_nr from costage_st_studiengaenge G where G.skz_key in (<<Fach>>)) "/> \ |
|
*/\ |
|
\ |
|
\ |
|
<#assign filter=filter +" and " + fach_filter />\ |
|
\ |
|
--\ |
|
\ |
|
<@generateDatenblatt \ |
|
p_basetable = basetable\ |
|
p_joinTables = getJoinTables\ |
|
p_joinWhereClauses = getJoinWhereClauses\ |
|
p_selectClause = getSelectClause\ |
|
p_aggregationsfeld ="summe"\ |
|
p_aggregatfunktion = "sum("\ |
|
p_filter = filter\ |
|
p_show_keys= <<Schlüssel anzeigen>>\ |
|
p_postProcessing= ""\ |
|
/>^--Freemarker Template \ |
|
XIL List\ |
|
sizable_columns horizontal_scrolling\ |
|
white_space_color=COLOR_WHITE fixed_columns=1\ |
|
min_heading_height=35\ |
|
<#assign i=1 />\ |
|
<#if getSelectClause?has_content >\ |
|
<#foreach myfield in getSelectClause>\ |
|
<#assign i=i+1 />\ |
|
Column CID=${i} heading_text="${myfield.caption}" explanation="" center_heading\ |
|
row_selectable col_selectable rightJust heading_platform readonly\ |
|
width=20\ |
|
<#if myfield.foreignkey_tab != '' && <<Schlüssel anzeigen>>==1>\ |
|
<#assign i=i+1 />\ |
|
Column CID=${i} heading_text="${myfield.caption}\\n(Schlüssel)" explanation="" center_heading\ |
|
row_selectable col_selectable rightJust heading_platform readonly\ |
|
width=20\ |
|
</#if>\ |
|
</#foreach>\ |
|
</#if>\ |
|
@@@^Altersgruppe^Anzahl^Bewerbungen Datenblatt aus CO^drop table tmp_tabelle;^^2^700^360^^1^^
|
|
|