<!--                                                                  -->
<!--  Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved     -->
<!--  $Id$  -->
<!--                                                                  -->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:dyn="http://exslt.org/dynamic" extension-element-prefixes="dyn">


    <xsl:template name="clientInfo">
        From:<br />
        <xsl:value-of select="$client/Name" />
        <xsl:if test="normalize-space($client/StreetAddress)">
            <p>
                <xsl:call-template name="replaceLineBreak">
                    <xsl:with-param name="string" select="$client/StreetAddress"/>
                </xsl:call-template>
            </p>
        </xsl:if>
        <xsl:if test="normalize-space($client/City) or normalize-space($client/StateProvince)">
            <p>
                <xsl:if test="normalize-space($client/City)"><xsl:value-of select="$client/City" /><xsl:if test="normalize-space($client/StateProvince)">, </xsl:if></xsl:if><xsl:value-of select="$client/StateProvince" />&#160;<xsl:value-of select="$client/PostalCode" />
            </p>
        </xsl:if>
        <xsl:if test="normalize-space($client/Email)">
            <p>
                Questions? Email: <xsl:value-of select="$client/Email" />
            </p>
        </xsl:if>
    </xsl:template>

    <xsl:template name="advanceRow">
        <tr class="Table-row Table-row-data">
            <td colspan="{$columns - 1}" class="Table-col Table-col-heading">License Subtotal:</td>
            <td class="Table-col Table-col-amount total">
                <xsl:value-of select="Subtotal" />
            </td>
        </tr>
        <xsl:if test="translate(PreviousAdvanceBalance, translate(PreviousAdvanceBalance,'0123456789', ''), '') &gt; 0">
            <tr class="Table-row Table-row-data">
                <td colspan="{$columns - 1}" class="Table-col Table-col-heading">License Advance:</td>
                <td class="Table-col Table-col-amount">
                    <xsl:value-of select="PreviousAdvanceBalance" />
                </td>
            </tr>
            <tr class="Table-row Table-row-data">
                <td colspan="{$columns - 1}" class="Table-col Table-col-heading">Applied to Advance:</td>
                <td class="Table-col Table-col-amount">
                    <xsl:value-of select="AppliedToAdvance" />
                </td>
            </tr>
            <tr class="Table-row Table-row-data">
                <td colspan="{$columns - 1}" class="Table-col Table-col-heading">Current Advance Balance:</td>
                <td class="Table-col Table-col-amount">
                    <xsl:value-of select="AdvanceBalance" />
                </td>
            </tr>
            <tr class="Table-row Table-row-data">
                <td colspan="{$columns - 1}" class="Table-col Table-col-heading">License Adjusted Subtotal:</td>
                <td class="Table-col Table-col-amount Table-col-total">
                    <xsl:value-of select="AdjustedSubtotal" />
                </td>
            </tr>
        </xsl:if>
    </xsl:template>

    <xsl:template name="transactionTable">
        <xsl:param name="statement" />
        <xsl:param name="transactions" />
        <table class="Table Table-with-highlight">
            <thead>
                <tr class="Table-row Table-row-header">
                    <th class="Table-col Table-col-shrink"></th>
                    <th class="Table-col Table-col-shrink Table-col-amount">Amount</th>
                    <th class="Table-col">Check #</th>
                    <th class="Table-col">Date</th>
                    <th class="Table-col">Memo</th>
                </tr>
            </thead>
            <tbody>
                <tr class="Table-row Table-row-data">
                    <td class="Table-col Table-col-shrink">Previous Period Balance:</td>
                    <td class="Table-col Table-col-shrink Table-col-amount">
                        <xsl:value-of select="$statement/PreviousBalance" />
                    </td>
                    <td class="Table-col" colspan="3">
                    </td>
                </tr>
                <xsl:for-each select="$transactions">
                    <tr class="Table-row Table-row-data">
                        <td class="Table-col Table-col-shrink">
                            <xsl:if test="TypeCode = 2">Adjustment:</xsl:if>
                            <xsl:if test="TypeCode = 3">Advance:</xsl:if>
                            <xsl:if test="TypeCode = 4">Payment:</xsl:if>
                        </td>
                        <td class="Table-col Table-col-shrink Table-col-amount">
                            <xsl:value-of select="Amount" />
                        </td>
                        <td class="Table-col"><xsl:value-of select="CheckNumber" /></td>
                        <td class="Table-col"><xsl:value-of select="TransactionDate" /></td>
                        <td class="Table-col"><xsl:value-of select="Memo" /></td>
                    </tr>
                </xsl:for-each>
                <tr class="Table-row Table-row-data">
                    <td class="Table-col Table-col-shrink">Current Period Royalties:</td>
                    <td class="Table-col Table-col-shrink Table-col-amount">
                        <xsl:choose>
                            <xsl:when test="$cmd = 'show_mechanical' or $cmd = 'show_ca_mechanical'">
                                <xsl:value-of select="$statement/Subtotal" />
                            </xsl:when>
                            <xsl:otherwise>
                                <xsl:value-of select="$statement/Total" />
                            </xsl:otherwise>
                        </xsl:choose>
                    </td>
                    <td class="Table-col" colspan="3"></td>
                </tr>
                <xsl:if test="translate($statement/PreviousAdvanceBalance, translate($statement/PreviousAdvanceBalance,'0123456789', ''), '') != 0 and normalize-space($statement/PreviousAdvanceBalance)">
                    <tr class="Table-row Table-row-data Table-row-total">
                        <td class="Table-col Table-col-shrink">Previous Advance Balance:</td>
                        <td class="Table-col Table-col-shrink Table-col-amount Table-col-total">
                            <xsl:value-of select="$statement/PreviousAdvanceBalance" />
                        </td>
                        <td class="Table-col" colspan="3"></td>
                    </tr>
                    <tr class="Table-row Table-row-data">
                        <td class="Table-col Table-col-shrink">Applied to Advance:</td>
                        <td class="Table-col Table-col-shrink Table-col-amount">
                            <xsl:value-of select="$statement/AppliedToAdvance" />
                        </td>
                        <td class="Table-col" colspan="3"></td>
                    </tr>
                    <tr class="Table-row Table-row-data">
                        <td class="Table-col Table-col-shrink">Current Advance Balance:</td>
                        <td class="Table-col Table-col-shrink Table-col-amount">
                            <xsl:value-of select="$statement/AdvanceBalance" />
                        </td>
                        <td class="Table-col" colspan="3"></td>
                    </tr>
                </xsl:if>
                <tr class="Table-row Table-row-data Table-row-total Table-row-heading endingBalance">
                    <td class="Table-col Table-col-shrink">Ending Balance:</td>
                    <td class="Table-col Table-col-shrink Table-col-amount Table-col-total">
                        <strong>
                            <xsl:choose>
                                <xsl:when test="$cmd = 'show_artist' or $cmd = 'show_label'">
                                    <xsl:choose>
                                        <xsl:when test="translate($statement/Balance, translate($statement/Balance,'0123456789', ''), '') = 0 and translate($statement/AmountDue, translate($statement/AmountDue,'0123456789', ''), '') &gt; 0">
                                            <xsl:value-of select="$statement/AmountDue" />
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="$statement/Balance" />
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:when>
                                <xsl:when test="translate($statement/Balance, translate($statement/Balance,'0123456789', ''), '') != 0">
                                    <xsl:value-of select="$statement/Balance" />
                                </xsl:when>
                                <xsl:when test="translate($statement/AmountDue, translate($statement/AmountDue,'0123456789', ''), '') != 0">
                                    <xsl:value-of select="$statement/AmountDue" />
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="$statement/StatementTotal" />
                                </xsl:otherwise>
                            </xsl:choose>
                        </strong>
                    </td>
                    <td class="Table-col" colspan="3"></td>
                </tr>
                <tr class="Table-row Table-row-data">
                    <td class="Table-col Table-col-shrink">Minimum Payment:</td>
                    <td class="Table-col Table-col-shrink Table-col-amount">
                        <xsl:choose>
                            <xsl:when test="$cmd = 'show_mechanical' or $cmd = 'show_ca_mechanical'">
                                <xsl:value-of select="$statement/MinimumPayment" />
                            </xsl:when>
                            <xsl:otherwise>
                                <xsl:value-of select="$statement/MinPayment" />
                            </xsl:otherwise>
                        </xsl:choose>
                    </td>
                    <td class="Table-col" colspan="3"></td>
                </tr>
                <tr class="Table-row Table-row-data Table-row-total Table-row-heading">
                    <td class="Table-col Table-col-shrink"><strong>Amount Payable:</strong></td>
                    <td class="Table-col Table-col-shrink Table-col-amount">
                        <strong>
                            <xsl:choose>
                                <xsl:when test="$statement/OnHold = 1">ON-HOLD</xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="$statement/AmountDue" />
                                </xsl:otherwise>
                            </xsl:choose>
                        </strong>
                    </td>
                    <td class="Table-col" colspan="3">
                        <xsl:if test="$statement/OnHold != 1">
                            (<xsl:value-of select="$statement/Balance/@currency_code" />)
                        </xsl:if>
                    </td>
                </tr>
            </tbody>
        </table>
    </xsl:template>


</xsl:stylesheet>

