Bug 25759 - Invoices hyperlink is broken on edifactmsgs.pl
Summary: Invoices hyperlink is broken on edifactmsgs.pl
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor (vote)
Assignee: Kyle M Hall
QA Contact: Martin Renvoize
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-15 15:56 UTC by Kyle M Hall
Modified: 2021-06-14 21:29 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: Small patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl (2.05 KB, patch)
2020-06-15 15:59 UTC, Kyle M Hall
Details | Diff | Splinter Review
Sample database with invoice and edi message already added. (978.11 KB, application/x-gzip)
2020-10-22 12:48 UTC, Kyle M Hall
Details
Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl (2.11 KB, patch)
2020-10-25 02:10 UTC, Katrin Fischer
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall 2020-06-15 15:56:33 UTC
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.
Comment 1 Kyle M Hall 2020-06-15 15:59:17 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!
Comment 2 Katrin Fischer 2020-06-22 22:03:00 UTC
Hi Kyle, is there a way to add 'fake' EDI data for testing this?
Comment 3 Kyle M Hall 2020-06-23 12:17:22 UTC
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);
Comment 4 Katrin Fischer 2020-10-19 15:44:54 UTC
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?
Comment 5 Kyle M Hall 2020-10-22 12:35:44 UTC
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);
Comment 6 Kyle M Hall 2020-10-22 12:48:39 UTC
Created attachment 112188 [details]
Sample database with invoice and edi message already added.
Comment 7 Katrin Fischer 2020-10-25 02:10:14 UTC
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>
Comment 8 Martin Renvoize 2020-11-02 16:48:38 UTC
Er.. just wondering.. shouldn't this be at the Koha::Object level rather than within the DBIC Class?
Comment 9 Martin Renvoize 2020-11-02 16:57:13 UTC
Hmm.. also since bug 20782 this does work correctly for us..
Comment 10 Martin Renvoize 2020-11-02 17:06:33 UTC
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?
Comment 11 Martin Renvoize 2020-11-02 17:21:25 UTC
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.
Comment 12 Kyle M Hall 2020-11-02 17:22:02 UTC
(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.
Comment 13 Kyle M Hall 2020-11-02 17:23:34 UTC
(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.
Comment 14 Kyle M Hall 2020-11-02 17:54:22 UTC
(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!
Comment 15 Katrin Fischer 2020-11-02 19:10:26 UTC
Must have messed up testing the before here as well :(
Comment 16 Martin Renvoize 2020-11-03 08:40:28 UTC
:), thanks guys, really glad it's working as expected.