Summary: | Invoices hyperlink is broken on edifactmsgs.pl | ||
---|---|---|---|
Product: | Koha | Reporter: | Kyle M Hall (khall) <kyle> |
Component: | Acquisitions | Assignee: | Kyle M Hall (khall) <kyle> |
Status: | CLOSED INVALID | QA Contact: | Martin Renvoize (ashimema) <martin.renvoize> |
Severity: | minor | ||
Priority: | P5 - low | CC: | amit.gupta, amitddng135, martin.renvoize |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20782 | ||
Change sponsored?: | --- | Patch complexity: | Small patch |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: |
Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl
Sample database with invoice and edi message already added. Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl |
Description
Kyle M Hall (khall)
2020-06-15 15:56:33 UTC
Created attachment 105888 [details] [review] Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl The "Invoices" hyperlink on edifactmsgs.pl has always been broken. We can parse out the invoice number from the message and have the link search for that invoice number in Koha. Test Plan: 1) Locate an imported invoice from edifactmsgs.pl 2) Click the "Invoices" link for that invoice 3) Note no invoice is found 4) Apply this patch 5) Restart all the things! 6) Reload the page 7) Note the link now reads "Invoice: $invoice_number" 8) Click the new link 9) Note it is now found by Koha! Hi Kyle, is there a way to add 'fake' EDI data for testing this? Create an invoice with a invoice number of 2035199664, then run this query to insert an EDI invoice message with the same invoice number: INSERT INTO `edifact_messages` VALUES (9999,'INVOICE','2020-06-09',NULL,NULL,'new',NULL,NULL,'UNA:+.? \'UNB+UNOA:2+1556150:31B+3504069:31B+200609:0311+428\'UNG+INVOIC+1556150:31B+3504069:31B+20200609:0311+428+UN+D:96A\'UNH+1210+INVOIC:0:96:UN\'BGM+380+2035199664+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+4++9780062912756:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158155\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780310357179:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:164038\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781984804938:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:163698\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+13++9780316477536:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:162817\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+44++9780062988904:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163717\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+18++9781250216991:EN\'QTY+47:1\'MOA+203:9.19\'PRI+AAB:8.99::SRP\'PRI+AAA:5.39::DPR\'RFF+LI:163691\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+23++9780062937728:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164156\'RFF+ON:11105 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+15++9781538715642:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:158933\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157316\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159550\'RFF+ON:10821 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780525539520:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:154348\'RFF+ON:AF20 10442\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+32++9780062953926:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158183\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+27++9781982136116:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:160430\'RFF+ON:10886 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+57++9780062993861:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:162861\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:15\'CNT+2:14\'MOA+86:258.12\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:57\'ALC+C++++TX\'MOA+124:0\'UNT+171+1210\'UNH+1211+INVOIC:0:96:UN\'BGM+380+2035200766+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+2++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:152771\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:154677\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+21++9780385544962:EN\'QTY+47:1\'MOA+203:20.6\'PRI+AAB:29.95::SRP\'PRI+AAA:16.8::DPR\'RFF+LI:159724\'RFF+ON:10835 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781524745202:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:152331\'RFF+ON:AF20 10307\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+24++9781250168962:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:163697\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062951663:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162164\'RFF+ON:10984 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+17++9781250210883:EN\'QTY+47:2\'MOA+203:37.88\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158168\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+16++9780735291027:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:163689\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9781984805997:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163524\'RFF+ON:11069 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+16++9781250261878:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:159061\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+19++9781420149975:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:163692\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525542353:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:160067\'RFF+ON:10863 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780316422130:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:158921\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781982137977:EN\'QTY+47:3\'MOA+203:61.89\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:156872\'RFF+ON:10631 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+31++9781982137977:EN\'QTY+47:2\'MOA+203:41.26\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:161022\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+10++9781501188589:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158161\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+22++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158173\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162750\'RFF+ON:11026 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157317\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159183\'RFF+ON:10795 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:162324\'RFF+ON:10988 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780440000839:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158184\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9781250252203:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:163712\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9781538717820:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163707\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:160906\'RFF+ON:10913 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163118\'RFF+ON:11049 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781984802705:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:157214\'RFF+ON:10657 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9780593171592:EN\'QTY+47:1\'MOA+203:21.2\'PRI+AAB:29::SRP\'PRI+AAA:17.4::DPR\'RFF+LI:159768\'RFF+ON:10837 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781643852997:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162829\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+29++9781524760380:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:158180\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9780062966742:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158190\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+54++9780778310099:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158205\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+23++9780735223103:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158174\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+6++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:153700\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+1++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:157636\'RFF+ON:10697 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+14++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:160990\'RFF+ON:10919 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+30++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:162637\'RFF+ON:11019 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+20++9781250302045:EN\'QTY+47:1\'MOA+203:18.38\'PRI+AAB:25.99::SRP\'PRI+AAA:14.58::DPR\'RFF+LI:163693\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:162385\'RFF+ON:10994 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:164412\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:52\'CNT+2:40\'MOA+86:973.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:197.6\'ALC+C++++TX\'MOA+124:0\'UNT+457+1211\'UNH+1212+INVOIC:0:96:UN\'BGM+380+2035201654+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+15++9781644450178:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:159060\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161001\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161761\'RFF+ON:10953 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:164422\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9781472267474:EN\'QTY+47:1\'MOA+203:17.82\'PRI+AAB:24.99::SRP\'PRI+AAA:14.02::DPR\'RFF+LI:161591\'RFF+ON:10943 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+41++9780593129463:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:164046\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+43++9780525479123:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:163716\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9780785233527:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164039\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781538752111:EN\'QTY+47:2\'MOA+203:42.38\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:154404\'RFF+ON:LP 10446\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+2++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:160894\'RFF+ON:10911 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:162714\'RFF+ON:11024 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:12\'CNT+2:11\'MOA+86:233.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:45.6\'ALC+C++++TX\'MOA+124:0\'UNT+138+1212\'UNE+3+428\'UNZ+1+428\'','OUT149066162243.INT',0); Hi Kyle, the query gives me an error and I am not sure how to best fix it as I don't know EDI - can you help again? Here is an updated query: INSERT INTO `edifact_messages` ( id, message_type, transfer_date, vendor_id, edi_acct, status, basketno, raw_msg, filename, deleted ) VALUES (9999,'INVOICE','2020-06-09',NULL,NULL,'new',NULL, 'UNA:+.? \'UNB+UNOA:2+1556150:31B+3504069:31B+200609:0311+428\'UNG+INVOIC+1556150:31B+3504069:31B+20200609:0311+428+UN+D:96A\'UNH+1210+INVOIC:0:96:UN\'BGM+380+2035199664+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+4++9780062912756:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158155\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780310357179:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:164038\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781984804938:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:163698\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+13++9780316477536:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:162817\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+44++9780062988904:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163717\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+18++9781250216991:EN\'QTY+47:1\'MOA+203:9.19\'PRI+AAB:8.99::SRP\'PRI+AAA:5.39::DPR\'RFF+LI:163691\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+23++9780062937728:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164156\'RFF+ON:11105 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+15++9781538715642:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:158933\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157316\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159550\'RFF+ON:10821 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780525539520:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:154348\'RFF+ON:AF20 10442\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+32++9780062953926:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158183\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+27++9781982136116:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:160430\'RFF+ON:10886 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+57++9780062993861:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:162861\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:15\'CNT+2:14\'MOA+86:258.12\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:57\'ALC+C++++TX\'MOA+124:0\'UNT+171+1210\'UNH+1211+INVOIC:0:96:UN\'BGM+380+2035200766+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+2++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:152771\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:154677\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+21++9780385544962:EN\'QTY+47:1\'MOA+203:20.6\'PRI+AAB:29.95::SRP\'PRI+AAA:16.8::DPR\'RFF+LI:159724\'RFF+ON:10835 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781524745202:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:152331\'RFF+ON:AF20 10307\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+24++9781250168962:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:163697\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062951663:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162164\'RFF+ON:10984 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+17++9781250210883:EN\'QTY+47:2\'MOA+203:37.88\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158168\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+16++9780735291027:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:163689\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9781984805997:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163524\'RFF+ON:11069 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+16++9781250261878:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:159061\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+19++9781420149975:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:163692\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525542353:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:160067\'RFF+ON:10863 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780316422130:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:158921\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781982137977:EN\'QTY+47:3\'MOA+203:61.89\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:156872\'RFF+ON:10631 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+31++9781982137977:EN\'QTY+47:2\'MOA+203:41.26\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:161022\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+10++9781501188589:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158161\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+22++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158173\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162750\'RFF+ON:11026 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157317\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159183\'RFF+ON:10795 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:162324\'RFF+ON:10988 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780440000839:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158184\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9781250252203:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:163712\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9781538717820:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163707\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:160906\'RFF+ON:10913 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163118\'RFF+ON:11049 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781984802705:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:157214\'RFF+ON:10657 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9780593171592:EN\'QTY+47:1\'MOA+203:21.2\'PRI+AAB:29::SRP\'PRI+AAA:17.4::DPR\'RFF+LI:159768\'RFF+ON:10837 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781643852997:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162829\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+29++9781524760380:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:158180\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9780062966742:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158190\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+54++9780778310099:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158205\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+23++9780735223103:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158174\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+6++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:153700\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+1++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:157636\'RFF+ON:10697 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+14++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:160990\'RFF+ON:10919 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+30++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:162637\'RFF+ON:11019 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+20++9781250302045:EN\'QTY+47:1\'MOA+203:18.38\'PRI+AAB:25.99::SRP\'PRI+AAA:14.58::DPR\'RFF+LI:163693\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:162385\'RFF+ON:10994 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:164412\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:52\'CNT+2:40\'MOA+86:973.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:197.6\'ALC+C++++TX\'MOA+124:0\'UNT+457+1211\'UNH+1212+INVOIC:0:96:UN\'BGM+380+2035201654+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+15++9781644450178:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:159060\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161001\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161761\'RFF+ON:10953 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:164422\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9781472267474:EN\'QTY+47:1\'MOA+203:17.82\'PRI+AAB:24.99::SRP\'PRI+AAA:14.02::DPR\'RFF+LI:161591\'RFF+ON:10943 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+41++9780593129463:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:164046\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+43++9780525479123:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:163716\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9780785233527:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164039\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781538752111:EN\'QTY+47:2\'MOA+203:42.38\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:154404\'RFF+ON:LP 10446\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+2++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:160894\'RFF+ON:10911 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:162714\'RFF+ON:11024 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:12\'CNT+2:11\'MOA+86:233.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:45.6\'ALC+C++++TX\'MOA+124:0\'UNT+138+1212\'UNE+3+428\'UNZ+1+428\'','OUT149066162243.INT',0); Created attachment 112188 [details]
Sample database with invoice and edi message already added.
Created attachment 112451 [details] [review] Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl The "Invoices" hyperlink on edifactmsgs.pl has always been broken. We can parse out the invoice number from the message and have the link search for that invoice number in Koha. Test Plan: 1) Locate an imported invoice from edifactmsgs.pl 2) Click the "Invoices" link for that invoice 3) Note no invoice is found 4) Apply this patch 5) Restart all the things! 6) Reload the page 7) Note the link now reads "Invoice: $invoice_number" 8) Click the new link 9) Note it is now found by Koha! Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> Er.. just wondering.. shouldn't this be at the Koha::Object level rather than within the DBIC Class? Hmm.. also since bug 20782 this does work correctly for us.. Also, having now conferred with Colin, we believe a message is allowed to contain multiple invoices, so the extraction of invoice_id here may be too simplistic. We do store message_id in the invoices table to allow the link from invoice to message to be recorded.. which is what we're using for the GetInvoices search in current code. Perhaps a ByWater EDI plugin skips setting of message_id somewhere? Confirmed.. see the loop for 'messages' inside process_invoice within Koha::EDI. It loops through messages in the invoice file and extracts a docmsg_number for each one. (In reply to Martin Renvoize from comment #8) > Er.. just wondering.. shouldn't this be at the Koha::Object level rather > than within the DBIC Class? That was a development decision made by Colin iirc. (In reply to Martin Renvoize from comment #11) > Confirmed.. see the loop for 'messages' inside process_invoice within > Koha::EDI. > > It loops through messages in the invoice file and extracts a docmsg_number > for each one. I think we can make it work with multiple messages! Let me see what I can do. (In reply to Martin Renvoize from comment #11) > Confirmed.. see the loop for 'messages' inside process_invoice within > Koha::EDI. > > It loops through messages in the invoice file and extracts a docmsg_number > for each one. Ok, I feel like a nut ;) The invoice links are definitely working in master now! Must have messed up testing the before here as well :( :), thanks guys, really glad it's working as expected. |