<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="MSJN Loan Invoice v5" pageWidth="595" pageHeight="842" whenNoDataType="NoPages" columnWidth="483" leftMargin="56" rightMargin="56" topMargin="42" bottomMargin="20" scriptletClass="edu.ku.brc.specify.config.Scriptlet" uuid="ec85af8d-e1c0-4f9b-9f91-711a6aade1ec">
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<field name="52.loan.remarks" class="java.lang.String"/>
	<field name="52.loan.isClosed" class="java.lang.Boolean"/>
	<field name="52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.Genus" class="java.lang.String"/>
	<field name="52.loan.dateClosed" class="java.lang.String"/>
	<field name="52,54-loanPreparations.loanpreparation.isResolved" class="java.lang.Boolean"/>
	<field name="52.loan.text1" class="java.lang.String"/>
	<field name="52,54-loanPreparations.loanpreparation.descriptionOfMaterial" class="java.lang.String"/>
	<field name="52,71-shipments.shipment.shipmentMethod" class="java.lang.String"/>
	<field name="52.loan.loanNumber" class="java.lang.Object"/>
	<field name="52,54-loanPreparations.loanpreparation.outComments" class="java.lang.String"/>
	<field name="52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.fullName" class="java.lang.String"/>
	<field name="52,54-loanPreparations.loanpreparation.receivedComments" class="java.lang.String"/>
	<field name="52.loan.loanDate" class="java.lang.String"/>
	<field name="52,54-loanPreparations.loanpreparation.quantity" class="java.lang.Integer"/>
	<field name="52,53-loanagents.loanagent.loanAgents" class="java.lang.String"/>
	<field name="52,54-loanPreparations.loanpreparation.inComments" class="java.lang.String"/>
	<field name="52,54-loanpreparations,63,1.collectionobject.catalogNumber" class="java.lang.Object"/>
	<field name="52.loan.currentDueDate" class="java.lang.String"/>
	<field name="id" class="java.lang.Integer"/>
	<field name="resultsetsize" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="115" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-1" x="0" y="85" width="480" height="30" uuid="66c9b38e-02b9-4052-86a0-35a7057e6fcf"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font size="18" isBold="true"/>
				</textElement>
				<text><![CDATA[UDLÅNS-DOKUMENT]]></text>
			</staticText>
			<image>
				<reportElement key="image-1" x="0" y="0" width="140" height="57" uuid="10054102-7121-47db-8bff-78ea95dc868a"/>
				<imageExpression><![CDATA[new java.net.URL("https://specify-snm.science.ku.dk/ireportslogo/msjn_large.png")]]></imageExpression>
			</image>
			<staticText>
				<reportElement key="staticText-2" x="140" y="2" width="340" height="54" uuid="24d7cbf8-b2ae-4a30-b831-69f5380ead6c"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="html">
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[<html><b>NATURHISTORIE</b><p/>LERGRAVSVEJ 2<br/>DK-6510 GRAM<p/>+45 65 370 806</html>]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-1" x="140" y="57" width="340" height="26" uuid="60c8c397-f1c4-423a-8f9c-efc996d6ae2b"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" markup="html"/>
				<textFieldExpression><![CDATA["<html><b>LÅN NUMMER: " + $F{52.loan.loanNumber} + "</b><p>" + $F{52.loan.loanDate}.toString() + "</html>"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="35" splitType="Stretch">
			<line>
				<reportElement key="line-1" x="0" y="1" width="480" height="1" uuid="5479466f-8cf3-4b94-9d63-09057c57ef16"/>
			</line>
			<staticText>
				<reportElement key="staticText-3" x="6" y="6" width="470" height="15" uuid="37db2a84-1b19-4f3d-a5ea-b180d89718b5"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[GENSTANDE DER UDLÅNES:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="7" y="21" width="70" height="14" uuid="abab3f4b-ce16-4804-aa0b-556abfe66792"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[MUSEUMSNR.]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-5" x="80" y="21" width="91" height="14" uuid="385d7586-8ad8-4468-8667-714c3b3e857f"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[GENSTAND]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-6" x="176" y="21" width="37" height="14" uuid="0c8691c5-8af5-414c-9769-0e7064bde454"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[ANTAL]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-7" x="213" y="21" width="264" height="14" uuid="39f5907b-12fc-4b06-9e59-9ac1f467c8db"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[BESKRIVELSE]]></text>
			</staticText>
			<line>
				<reportElement key="line-2" x="0" y="2" width="1" height="33" uuid="0a508b04-4c96-4d40-873b-54ab710ce0f5"/>
			</line>
			<line>
				<reportElement key="line-3" x="480" y="2" width="1" height="33" uuid="2a2d157d-754f-485f-ac81-d153e64a8a22"/>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="19" splitType="Stretch">
			<line>
				<reportElement key="line-4" x="0" y="0" width="1" height="19" uuid="b095f1c2-d7f7-4533-86ca-1e37895f9bfd"/>
			</line>
			<line>
				<reportElement key="line-5" x="480" y="0" width="1" height="19" uuid="697d98b0-a3f3-4c88-acec-64e4725ddeac"/>
			</line>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-2" x="6" y="2" width="70" height="14" uuid="7392947f-8a68-427f-b1d7-c098d57e7795"/>
				<textElement markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{52,54-loanpreparations,63,1.collectionobject.catalogNumber} != null ? "MSJN "+ $F{52,54-loanpreparations,63,1.collectionobject.catalogNumber} : "intet")]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-3" x="80" y="2" width="91" height="14" uuid="18494b2d-45c1-4da7-a472-20d4822f869d"/>
				<textElement markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA["<html>" + ($F{52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.Genus} != null ? "<i>" + $F{52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.fullName} + "</i>" : ($F{52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.fullName} != null ? $F{52,54-loanPreparations,63,1,9-determinations,4-preferredTaxon.taxon.fullName} : "-")) + "</html>"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-4" x="176" y="2" width="32" height="14" uuid="c0fdae86-7d9b-41b5-ac9e-f6a941128079"/>
				<textElement markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{52,54-loanPreparations.loanpreparation.quantity} != null ? $F{52,54-loanPreparations.loanpreparation.quantity} : "-" )]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-5" x="213" y="2" width="264" height="14" uuid="4bf0a893-9c39-4f95-9ebd-c9090f4388a7"/>
				<textElement markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[( $F{52,54-loanPreparations.loanpreparation.descriptionOfMaterial} != null ? $F{52,54-loanPreparations.loanpreparation.descriptionOfMaterial} : "" )]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<lastPageFooter>
		<band height="50" splitType="Stretch"/>
	</lastPageFooter>
	<summary>
		<band height="420" splitType="Stretch">
			<line>
				<reportElement key="line-6" x="1" y="1" width="480" height="1" uuid="71dc5dec-66b1-432f-ab58-01db2b85a5f5"/>
			</line>
			<line>
				<reportElement key="line-7" x="0" y="0" width="1" height="419" uuid="8a6143b1-e0c9-4b09-af2d-40fb54b57fb6"/>
			</line>
			<line>
				<reportElement key="line-8" x="480" y="1" width="1" height="418" uuid="ebad4524-9d90-4fa6-a1ed-c906e90d9d8e"/>
			</line>
			<staticText>
				<reportElement key="staticText-8" x="6" y="6" width="470" height="15" uuid="b0bc6542-7ef9-4275-86fe-ce2ab543c5c3"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[UDLÅNES AF:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-9" x="6" y="21" width="218" height="53" uuid="fe2b223f-b9c9-4c77-9f3b-1d0cc0d42e81"/>
				<textElement markup="html"/>
				<text><![CDATA[<html><b>MUSEUM SØNDERJYLLAND,</b><p/>NATURHISTORIE<p/>LERGRAVSVEJ 2<p/>DK-6510 GRAM<p/>Danmark</html>]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-6" x="228" y="22" width="247" height="51" uuid="67af2b44-ca0e-433f-80ca-3caaf1d703f1"/>
				<textElement markup="html"/>
				<textFieldExpression><![CDATA[($F{52,53-loanagents.loanagent.loanAgents}.split(";")[1].contains("authorizer") ? 
($F{52,53-loanagents.loanagent.loanAgents}.split(";")[1].replace("|", "<br/>"))
.replace("- authorizer", "")
: "- No authorizer defined! - ")]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-10" x="6" y="6" width="470" height="15" uuid="e6b13094-3bb8-465c-a1f8-2ed84bb32b19"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[UDLÅNES AF:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-11" x="6" y="78" width="470" height="15" uuid="e2c4d8c4-2142-46bc-b1b0-c849c91b2c33"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[UDLÅNES TIL:]]></text>
			</staticText>
			<line>
				<reportElement key="line-9" x="0" y="76" width="480" height="1" uuid="4fe88160-d87f-4a03-b3d0-0e87a394e59c"/>
				<graphicElement>
					<pen lineWidth="1.0"/>
				</graphicElement>
			</line>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-7" x="6" y="94" width="470" height="58" uuid="0e2f4d85-917e-4a18-bb9a-07be64188bc4"/>
				<textElement markup="html"/>
				<textFieldExpression><![CDATA[($F{52,53-loanagents.loanagent.loanAgents}.split(";")[0].contains("borrower") ? 
($F{52,53-loanagents.loanagent.loanAgents}.split(";")[0].replace("|", "<br/>"))
.replace("- borrower", "")
: "- No borrower defined! - ")]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-10" x="0" y="154" width="480" height="1" uuid="5e3e343a-3e72-4eb4-939d-7495279e5ede"/>
				<graphicElement>
					<pen lineWidth="2.0"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-12" x="6" y="156" width="470" height="15" uuid="bbff7af9-e79a-4c8e-886e-39b2fccd4f76"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[PERIODE:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-8" x="5" y="171" width="471" height="14" uuid="5c971e3e-3dc8-41e2-8f8f-434e8677ea0d"/>
				<textElement markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{52.loan.loanDate} + " – " + $F{52.loan.currentDueDate}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-13" x="6" y="190" width="470" height="15" uuid="059c0145-cb2b-4f0d-8030-cc2d2de8fa50"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[HÅNDTERING:]]></text>
			</staticText>
			<line>
				<reportElement key="line-11" x="0" y="188" width="480" height="1" uuid="a78dad2a-227d-4f04-bd4f-27b86720bb44"/>
			</line>
			<staticText>
				<reportElement key="staticText-14" x="7" y="205" width="468" height="35" uuid="3c7e636b-1b1d-4ff9-b2a6-08e6dab1b9ce"/>
				<textElement markup="html">
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Udlånte genstand(e) skal opbevares og håndteres i henhold til museets anvisninger. Ændringer i form af præparation, afstøbning, konservering, coating, udtagning af prøver osv. må kun må foretages med skriftlig tilladelse fra museets samlingsansvarlige.]]></text>
			</staticText>
			<line>
				<reportElement key="line-12" x="0" y="241" width="480" height="1" uuid="81682488-8673-4282-9f25-909b8f2f1ef3"/>
			</line>
			<staticText>
				<reportElement key="staticText-15" x="6" y="243" width="470" height="17" uuid="0b43be6e-e56f-4d54-8dc1-1ffb64556557"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[BEMÆRKNINGER:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-9" x="6" y="261" width="470" height="65" uuid="bf251903-052f-4cc6-a966-875344f6438a"/>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[( $F{52.loan.remarks} != null ? $F{52.loan.remarks} : "" )]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-16" x="6" y="326" width="470" height="15" uuid="8ae1019d-31d2-49a9-acfe-6d7c976640b1"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[SIGNATURER:]]></text>
			</staticText>
			<line>
				<reportElement key="line-14" x="6" y="370" width="230" height="1" uuid="e46cecc2-a5ca-4317-a3a7-299405b481fe"/>
			</line>
			<line>
				<reportElement key="line-15" x="246" y="370" width="230" height="1" uuid="c6a8f4bf-bd3c-4020-a7ef-de88bba78d5f"/>
			</line>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-10" x="6" y="372" width="230" height="46" uuid="747b0443-f30d-438b-bb00-e6d03af8a831"/>
				<textElement markup="html"/>
				<textFieldExpression><![CDATA["<html><b>DATO, UDLÅNT AF</b><p/>" + 
$F{52,53-loanagents.loanagent.loanAgents}.split(";")[1].substring(0,
$F{52,53-loanagents.loanagent.loanAgents}.split(";")[1].indexOf("|"))
+ "</html>"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-11" x="246" y="372" width="229" height="46" uuid="e2b91f23-51d7-485a-843c-481092416bd9"/>
				<textElement markup="html"/>
				<textFieldExpression><![CDATA["<html><b>DATO, UDLÅNT TIL</b><p/>" + 
$F{52,53-loanagents.loanagent.loanAgents}.split(";")[0].substring(0,
$F{52,53-loanagents.loanagent.loanAgents}.split(";")[0].indexOf("|"))
+ "</html>"]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-16" x="0" y="419" width="480" height="1" uuid="1d05933d-583e-4eff-9f81-970153371bb9"/>
			</line>
		</band>
	</summary>
</jasperReport>
