<?xml version="1.0" encoding="UTF-8"?>
<xmlpanel>
    <configuration
        table="wwAuftraege"
        searchDialog="idAuftraegeSuchDialog"
        recordControlPattern="{0}"
        bookmarks="true"
        bookmarkTitle="Kunde: $idName"
        history="true"
        historyTitle="Kunde: $idName"
    >
        <primaryKey>
            <column name="nNr" type="INT" source="AUTO" />
        </primaryKey>
    </configuration>

    <searchDialog
        id="idAuftraegeSuchDialog"
        title="Auftrags-Suche"
        autoResizeMode="AUTO_RESIZE_OFF"
        size="500 500"
        table="wwAuftraege"
        where="wwAuftraege.sStatus!='L'"
        orderBy="wwAuftraege.dtAnlageDatum"
    >
        <primaryKey>
            <column name="nNr" type="INT" />
        </primaryKey>
        <column title="Kunde"             field="nKundeNr"         width="180" minWidth="10" maxWidth="200"
            joinTable="wwKunden" joinKeyField="nNr" joinField="sName"/>
        <column title="Kundenauftragsnr." field="sKundeAuftragsnr" width="120" minWidth="10" maxWidth="150"/>
        <column title="Anlage"            field="dtAnlageDatum"    width="70"  minWidth="10" maxWidth="90"
            type="DATE" pattern="dd.MM.yyyy"/>
        <column title="Ziel"              field="dtZielDatum"      width="70"  minWidth="10" maxWidth="90"
            type="DATE" pattern="dd.MM.yyyy"/>
    </searchDialog>

    <searchDialog
        id="idKundenSuchDialog"
        title="Kunden-Suche"
        autoResizeMode="AUTO_RESIZE_OFF"
        size="420 500"
        table="wwKunden"
        where="wwKunden.sStatus='A'"
        orderBy="wwKunden.sName"
    >
        <primaryKey>
            <column name="nNr" type="INT" />
        </primaryKey>
        <column title="Name"   field="sName"        width="120" minWidth="10" maxWidth="200"/>
        <column title="Ort"    field="sOrt"         width="120" minWidth="10" maxWidth="150"/>
        <column title="Straße" field="sStrasse"     width="100" minWidth="10" maxWidth="150"/>
        <column title="H.Nr."  field="sHausnummer"  width="50"  minWidth="10" maxWidth="600"/>
        <column title="Status" field="sStatus"      width="90"  minWidth="10" maxWidth="100"
            type="COMBOBOX">
            <item value="0" text="Erfassung" />
            <item value="1" text="Offen" />
            <item value="2" text="Geliefert" />
            <item value="3" text="Fakturiert" />
            <item value="4" text="Erledigt" />
            <item value="S" text="Storniert" />
        </column>
    </searchDialog>

    <panel id="main" widgetGroupID="">
        <label text="Kunde:"
            constraints="0 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idKunde"
            toolTipText="Kunde"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            size="180 21"
            searchDialog="idKundenSuchDialog"
            field="nKundeNr"
            type="INT"
        >
            <masterWidget
                table="wwKunden"
                showField="sName"
                where=""
            >
                <primaryKey type="SINGLE">
                    <column name="nNr"        type="INT"/>
                </primaryKey>
                <slaveWidget id="idKundeOrt"        mode="VALUE" field="sOrt"        type="STRING" />
                <slaveWidget id="idKundeStrasse"    mode="VALUE" field="sStrasse"    type="STRING" />
                <slaveWidget id="idKundeHausnummer" mode="VALUE" field="sHausnummer" type="STRING" />
            </masterWidget>
        </textField>
        <textField
            id="idKundeOrt"
            toolTipText="Ort des Kunden"
            constraints="2 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            locked="true"
            size="150 21"
        />
        <textField
            id="idKundeStrasse"
            toolTipText="Straße des Kunden"
            constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            locked="true"
            size="150 21"
        />
        <textField
            id="idKundeHausnummer"
            toolTipText="Hausnummer des Kunden"
            constraints="4 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            locked="true"
            size="50 21"
        />

        <label text="Kundenauftragsnummer:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idKundenauftragsnummer"
            name="Kundenauftragsnummer"
            toolTipText="Kundenauftragsnummer"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="180 21"
            field="sKundeAuftragsnr"
            type="STRING"
        />

        <label text="Anlagedatum:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <dateField
            id="idAnlagedatum"
            name="Anlagedatum"
            format="DATE"
            toolTipText="Anlagedatum"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="75 21"
            field="dtAnlageDatum"
            type="DATE"
        />

        <label text="Zieldatum:"
            constraints="2 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <dateField
            id="idZieldatum"
            name="Zieldatum"
            format="DATE"
            toolTipText="Zieldatum"
            constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="75 21"
            field="dtZielDatum"
            type="DATE"
        />

        <label text="Bemerkungen:"
            constraints="0 +1 1 1 0.0 0.0 NORTHEAST NONE 5 5 0 0 0 0"
        />
        <textArea
            id="id"
            name="Bemerkungen"
            toolTipText="Bemerkungen"
            constraints="1 +0 4 1 10.0 0.0 WEST HORIZONTAL 5 5 0 0 0 0"
            size="300 80"
            field="sBemerkungen"
            type="STRING"
        />

        <label
            text="Status:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 5 0 0 0"
        />
        <comboBox
            id="idStatus"
            name="Status"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 5 0 0 0"
            defaultValue="0"
            field="sStatus"
            type="STRING"
        >
            <item value="0" text="Erfassung" />
            <item value="1" text="Offen" />
            <item value="2" text="Geliefert" />
            <item value="3" text="Fakturiert" />
            <item value="4" text="Erledigt" />
            <item value="S" text="Storniert" />
        </comboBox>
        
        <label text=""
            constraints="0 +1 5 1 1.0 1.0 WEST BOTH 0 0 0 0 0 0"
        />
    </panel>
</xmlpanel>