Export | KSK Meldung

Export um Veranstaltungen bei der KSK zu melden.

Voraussetzung

• Benutzerfeld „KSK“ (Checkbox) angehakt
• Ticketeinnahmen
• Künstler-Deal

Vorschau

Preprozessor

return {
    ...ctx,
    events: ctx.events
        .filter(e => e.eventInformations
            .find(ei => ei.name === "KSK" && ei.value))
        .map(e => {
        const totalNetSum = Math.round(deps.lodash.sumBy(e.ticketing, (t) => Math.round(t.grossPrice * t.soldTickets)/1.07))
        let gageTotal = 0
        let kskTotal = 0
        return {
            ...e,
            ticketing: e.ticketing?.map(t => ({
                ...t,
                netPrice: Math.round(t.grossPrice/1.07),
                netSum: Math.round((t.grossPrice * t.soldTickets)/1.07),
                grossSum: Math.round(t.grossPrice) * t.soldTickets,
            })),
            deal: e.artists[0].deals?.map(d => {
                const guarantee = d.guarantee > 0 ? d.guarantee * 100 : null
                const breakEvenSales = d.breakEvenSales > 0 ? d.breakEvenSales * 100 : 0
                const hasShare = 
                    d.artistPercentage > 0 &&  breakEvenSales < totalNetSum && totalNetSum > guarantee ? 
                    {
                        toShare: totalNetSum - breakEvenSales,
                        percentage: d.artistPercentage ? d.artistPercentage * 100 : 0,
                        share: ((totalNetSum - breakEvenSales) * d.artistPercentage)
                    } : null
                const gage = guarantee > hasShare?.share ? guarantee : (hasShare?.share ?? 0)
                const ksk = gage / 100 * 5
                gageTotal = gageTotal + gage
                kskTotal = kskTotal + ksk
                return {
                    ...d,
                    breakEvenSales: breakEvenSales,
                    hasGuarantee: guarantee,
                    hasShare: hasShare,
                    gage: gage,
                    ksk: ksk
                }
            })?.[0],
            totalNetSum: totalNetSum,
            gageTotal: gageTotal,
            kskTotal: kskTotal
        }
    })
} 

Template

<style>
h1 {
font-family: Ubuntu;
text-decoration: none;
}

body, h2, h3, h4, p, th, td { font-family: Ubuntu; }

table {
table-layout: fixed;
width: 650px; 
border-spacing: 0px;
border-collapse: separate;
}
td, th {
text-align: left;
border-bottom: 1px solid black;
padding: 5px 10px;
vertical-align: top;
}

.alert {
    background-color: yellow;
    font-size: 1.5em;
}

</style>

# KSK Abrechnung

{{#if events.length}}
<table>
    <thead>
        <tr>
            <th>Datum</th>
            <th>Künstler</th>
            <th>Ort</th>
            <th>Einnahmen</th>
            <th>Gage</th>
            <th>KSK (5 %)</th>
        </tr>
    </thead>
    <tbody>
        {{#each events}}<tr>
            <td>{{ formatDate this.start "P" }}</td>
            <td>{{this.displayNames.artists}}</td>
            <td>{{this.displayNames.rooms}}</td>
            <td>{{ formatEuro ./this.totalNetSum }}</td> 
            <td>{{ formatEuro this.deal.gage }}</td> 
            <td>{{ formatEuro this.deal.ksk }}</td>
        </tr>{{/each}}
    </tbody>
    <tfoot>
        <tr>
            <th>Summe</th>
            <th></th>
            <th></th>
            <th>{{ formatEuro (sumBy events "totalNetSum") }}</th>
            <th>{{ formatEuro (sumBy events "gageTotal") }}</th>
            <th>{{ formatEuro (sumBy events "kskTotal") }}</th>
        </tr>
    </tfoot>    
</table>
{{else}}
Keine Daten vorhanden
{{/if}}