From a37021d6889e42131935252a1acf4353ad73a828 Mon Sep 17 00:00:00 2001
From: Michael Ritter <mikejritter@users.noreply.github.com>
Date: Mon, 17 Apr 2023 19:25:00 -0600
Subject: [PATCH] DRYD-1176: Add xml payload for incomingloanletter (#332)

---
 .../main/resources/incoming_loan_letter.jrxml    |  4 ++--
 .../src/main/resources/incoming_loan_letter.xml  | 16 ++++++++++++++++
 2 files changed, 18 insertions(+), 2 deletions(-)
 create mode 100644 services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.xml

diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml
index 19faf6222..1ff4f5a0f 100644
--- a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml
+++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml
@@ -38,7 +38,7 @@
   from persons_common person
   inner join local_person_authority local_auth on person.inauthority = local_auth.name
   inner join hierarchy hier on hier.id = person.id
-  inner join hierarchy ptg_hier on ptg_hier.parentid = person.id and ptg_hier.primarytype = 'personTermGroup'
+  inner join hierarchy ptg_hier on ptg_hier.parentid = person.id and ptg_hier.primarytype = 'personTermGroup' and ptg_hier.pos = 0
   inner join persontermgroup ptg on ptg.id = ptg_hier.id
   left outer join contacts_common contact on contact.initem = hier.name
   left outer join hierarchy addr_hier on addr_hier.parentid = contact.id and addr_hier.primarytype = 'addressGroup' and addr_hier.pos = 0
@@ -48,7 +48,7 @@
   from organizations_common org
   inner join local_org_authority local_auth on org.inauthority = local_auth.name
   inner join hierarchy hier on hier.id = org.id
-  inner join hierarchy otg_hier on otg_hier.parentid = org.id and otg_hier.primarytype = 'orgTermGroup'
+  inner join hierarchy otg_hier on otg_hier.parentid = org.id and otg_hier.primarytype = 'orgTermGroup' and otg_hier.pos = 0
   inner join orgtermgroup otg on otg.id = otg_hier.id
   left outer join contacts_common contact on contact.initem = hier.name
   left outer join hierarchy addr_hier on addr_hier.parentid = contact.id and addr_hier.primarytype = 'addressGroup' and addr_hier.pos = 0
diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.xml b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.xml
new file mode 100644
index 000000000..fa191a149
--- /dev/null
+++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
+<document name="report">
+  <ns2:reports_common xmlns:ns2="http://collectionspace.org/services/report">
+    <name>Incoming Loan Letter</name>
+    <notes>Incoming Loan Letter</notes>
+    <forDocTypes>
+      <forDocType>Loanin</forDocType>
+    </forDocTypes>
+    <supportsSingleDoc>true</supportsSingleDoc>
+    <supportsDocList>false</supportsDocList>
+    <supportsGroup>false</supportsGroup>
+    <supportsNoContext>true</supportsNoContext>
+    <filename>incoming_loan_letter.jrxml</filename>
+    <outputMIME>application/pdf</outputMIME>
+  </ns2:reports_common>
+</document>
-- 
2.47.3