<?xml version="1.0" encoding="UTF-8"?>
<View xmlns="http://www.geograt.de/namespaces/gisx3/themedefinition/1.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<visibleName>Projekt Übersicht</visibleName>
	<attributeDefinition>
		<attribute>
			<name>datum</name>
			<format>date</format>
		</attribute>
		<attribute>
			<name>plankosten</name>
			<format>currency</format>
		</attribute>
		<attribute>
			<name>auftragsSumme</name>
			<format>currency</format>
		</attribute>
		<attribute>
			<name>rechnungssummeGesamt</name>
			<format>currency</format>
		</attribute>
	</attributeDefinition>
	<defaultDialog>projekt-dlg</defaultDialog>
	<columns>
		e.id as id,
		e.objektNr as objektNr,
		e.objektBez as objektBez,
		e.jahr as jahr,
		e.ort as ort,
		e.plankosten as plankosten,
		(select min(b.benutzerName) from e.benutzer as b) as bearbeiterName1,
		COALESCE(sum(a.betrag),0) as auftragsSumme,
		COALESCE(sum(r.rechnungBetrag),0) as rechnungssummeGesamt
	</columns>
	<from>Projekt e left join e.auftraege as a left join a.rechnungen as r</from>
	<groupBy>e.id,e.objektNr,e.objektBez,e.jahr,e.ort,e.plankosten</groupBy>
	<editableThemeId>projekt</editableThemeId>
	<dashboardThemeId>projekt</dashboardThemeId>
	<authorization>
		<restrictToRoles>
			<roleName>ROLE_ADMIN</roleName>
		</restrictToRoles>
	</authorization>
	<filter>e.plankosten &lt; 100</filter>
</View>

<?xml version="1.0" encoding="UTF-8"?>
<View xmlns="http://www.geograt.de/namespaces/gisx3/themedefinition/1.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<visibleName>Kanal Übersicht</visibleName>
	<defaultDialog>haltung</defaultDialog>
	<columns>
		e.id.id as id,
		e.id.project as project,
		e.usage as nutzung,
		e.classification as bezeichnung,
		ko.upperHeight as deckelhoeheOben,
		ku.upperHeight as deckelhoeheUnten,
		round(((ko.upperHeight - e.startHeight) + (ku.upperHeight - e.endHeight)) / 2,2)  as ueberdeckung 
	</columns>
	<from>
		SewerEdge as e, 
		SewerNode as ko, 
		SewerNode as ku
	</from>
	<filter>
		e.id.project = ko.id.project and 
		e.upperNodeId=ko.id.id and
		e.id.project = ku.id.project and 
		e.lowerNodeId=ku.id.id
	</filter>
	<editableThemeId>sewer.sewer-edge</editableThemeId>
	<dashboardThemeId>sewer.sewer-edge</dashboardThemeId>
</View>

...
		<form>
			<title>Test mit View</title>
			<requestId>
				<attribute>
					<attribute>_id</attribute>
				</attribute>
			</requestId>
			<requestTheme>
				<constant>
					<value>gisx2:sewer.sewerView</value>
				</constant>
			</requestTheme>
			<content>
				<field>
					<name>Nutzung</name>
					<content>
						<featureAttribute>
							<name>nutzung</name>
						</featureAttribute>
					</content>
				</field>
				<field>
					<name>Deckelhöhe oben</name>
					<content>
						<featureAttribute>
							<name>deckelhoeheOben</name>
						</featureAttribute>
					</content>
				</field>
				<field>
					<name>Deckelhöhe unten</name>
					<content>
						<featureAttribute>
							<name>deckelhoeheUnten</name>
						</featureAttribute>
					</content>
				</field>
				<field>
					<name>Überdeckung</name>
					<content>
						<featureAttribute>
							<name>ueberdeckung</name>
						</featureAttribute>
					</content>
				</field>
			</content>
		</form>
...

...
		<table>
			<title>Haltungen mit gleichen Baujahr</title>
			<filter>e.yearOfConstruction = :baujahr</filter>
			<themeId>gisx2:sewer.sewerView</themeId>
			<requestParameter>
				<name>baujahr</name>
				<type>
					<attribute>
						<attribute>yearOfConstruction</attribute>
					</attribute>
				</type>
			</requestParameter>
			<column>
				<title>HaltungsNr</title>
				<content>
					<featureAttribute>
						<name>id</name>
					</featureAttribute>
				</content>
			</column>
			<column>
				<title>Nutzung</title>
				<content>
					<featureAttribute>
						<name>nutzung</name>
					</featureAttribute>
				</content>
			</column>
			<column>
				<title>Überdeckung</title>
				<content>
					<featureAttribute>
						<name>ueberdeckung</name>
					</featureAttribute>
				</content>
			</column>
			<action>
				<click>
					<text>Haltung anzeigen</text>
					<href>
						<internal>true</internal>
					</href>
				</click>
			</action>
		</table>
...

<?xml version="1.0" encoding="UTF-8"?>
<View xmlns="http://www.geograt.de/namespaces/gisx3/themedefinition/1.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <visibleName>Flurstücke zur Person</visibleName>
    <columns>
        e.id.id as id,
        e.id.project as project,
        e.district as district,
        e.corridorNumber as corridorNumber,
        e.parcelNumber as parcelNumber,
        b.kennzeichen as kennzeichen,
        concat(n.anteil.anteilZaehler,'/',n.anteil.anteilNenner) as anteil,
        n.eigentuemerart as eigentuemerart
    </columns>
    <from>Namensnummer as n join n.buchungsblatt as b join n.person as p join b.buchungsstellen as s join s.parcels as e</from>
    <dashboardThemeId>gisx2:alkis.flurstueck</dashboardThemeId>
    <defaultDialog>alkis.flurstueck</defaultDialog>
</View>

<Table ...>
    <filter>p.id.id = :personId and p.id.project = :project</filter>
    <themeId>gisx2:alkis.person-flurstuecksview</themeId>
	... beliebige Spalten aus View ...
    <column>
        <title>Flurstück</title>
        <content>
            <featureAttribute>
                <name>parcelNumber</name>
            </featureAttribute>
        </content>
    </column>
</Table>

<Dialog ...>
    ...
    <component id="person-flurstuecke">
        <referencedTable>
            <title>Flurstücke</title>
            <tableId>alkis.personFlurstuecksListe</tableId>
            <parameter>
                <name>personId</name>
                <type>
                    <attribute><attribute>id</attribute></attribute>
                </type>
            </parameter>
            <parameter>
                <name>project</name>
                <type>
                    <attribute><attribute>project</attribute></attribute>
                </type>
            </parameter>
        </referencedTable>
    </component>    
</Dialog>