<!--                                                                  -->
<!--  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)">
      <br />
      <xsl:call-template name="replaceLineBreak">
        <xsl:with-param name="string" select="$client/StreetAddress"/>
      </xsl:call-template>
    </xsl:if>
    <xsl:if test="normalize-space($client/City) or normalize-space($client/StateProvince)">
      <br />
      <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" />
    </xsl:if>
    <xsl:if test="normalize-space($client/Email)">
      <br /><br />
      Questions? Email: <xsl:value-of select="$client/Email" />
		</xsl:if>
  </xsl:template>

  <xsl:template name="advanceRow">
    <tr>
      <td colspan="{$columns - 1}" class="amountLabel">License Subtotal:</td>
      <td class="amount total">
        <xsl:value-of select="Subtotal" />
      </td>
    </tr>
    <xsl:if test="translate(PreviousAdvanceBalance, translate(PreviousAdvanceBalance,'0123456789', ''), '') &gt; 0">
	    <tr>
	      <td colspan="{$columns - 1}" class="amountLabel">License Advance:</td>
	      <td class="amount">
	        <xsl:value-of select="PreviousAdvanceBalance" />
	      </td>
	    </tr>
			<tr>
				<td colspan="{$columns - 1}" class="amountLabel">Applied to Advance:</td>
				<td class="amount">
					<xsl:value-of select="AppliedToAdvance" />
				</td>
			</tr>
			<tr>
				<td colspan="{$columns - 1}" class="amountLabel">Current Advance Balance:</td>
				<td class="amount">
					<xsl:value-of select="AdvanceBalance" />
				</td>
			</tr>
	    <tr>
	      <td colspan="{$columns - 1}" class="amountLabel">License Adjusted Subtotal:</td>
	      <td class="amount 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="transactionTable">
			<tr>
				<td></td>
				<td class="amount"><strong>Amount</strong></td>
				<td class="icon"><strong>Check #</strong></td>
				<td class="icon"><strong>Date</strong></td>
				<td><strong>Memo</strong></td>
			</tr>
			<tr>
				<td class="leftCol">Previous Period Balance:</td>
				<td class="amount">
      		<xsl:value-of select="$statement/PreviousBalance" />
				</td>
				<td colspan="3">
				</td>
			</tr>
			<xsl:for-each select="$transactions">
				<tr>
					<td class="leftCol">
						<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="amount">
      		  <xsl:value-of select="Amount" />
					</td>
					<td class="icon"><xsl:value-of select="CheckNumber" /></td>
					<td class="icon"><xsl:value-of select="TransactionDate" /></td>
					<td><xsl:value-of select="Memo" /></td>
				</tr>
			</xsl:for-each>
			<tr>
				<td class="leftCol">Current Period Royalties:</td>
				<td class="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 colspan="3"></td>
			</tr>
      <xsl:if test="translate($statement/PreviousAdvanceBalance, translate($statement/PreviousAdvanceBalance,'0123456789', ''), '') != 0 and normalize-space($statement/PreviousAdvanceBalance)">
        <tr>
          <td class="leftCol total">Previous Advance Balance:</td>
          <td class="amount total">
            <xsl:value-of select="$statement/PreviousAdvanceBalance" />
          </td>
          <td colspan="3"></td>
        </tr>
        <tr>
          <td class="leftCol">Applied to Advance:</td>
          <td class="amount">
            <xsl:value-of select="$statement/AppliedToAdvance" />
          </td>
          <td colspan="3"></td>
        </tr>
        <tr>
          <td class="leftCol">Current Advance Balance:</td>
          <td class="amount">
            <xsl:value-of select="$statement/AdvanceBalance" />
          </td>
          <td colspan="3"></td>
        </tr>
      </xsl:if>
      <tr class="endingBalance">
        <td class="leftCol total">Ending Balance:</td>
        <td class="amount 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 colspan="3"></td>
      </tr>
      <tr>
        <td class="leftCol">Minimum Payment:</td>
        <td class="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 colspan="3"></td>
      </tr>
      <tr>
        <td class="leftCol"><strong>Amount Payable:</strong></td>
        <td class="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 colspan="3">
					<xsl:if test="$statement/OnHold != 1">
						(<xsl:value-of select="$statement/Balance/@currency_code" />)
					</xsl:if>
				</td>
      </tr>
		</table>
		<br class="superBreak" /><br />
	</xsl:template>  
  

</xsl:stylesheet>

