<>N 833PLINVDAILY - GET INVENTORY FOR A CUSTOMER -SEND EMAIL34 " &$ 513 %Y%Mz%Dz@@( $2 P@@$0$ @83^1000 "------------ main logic$1 %Y-%Mz-%Dz4$!Y/reportdefs/ssrs/StockStatus/Customer/Simple2/runner?customerid=1¶meters=CustomerIDs: '~StartDate:2022-01-01T00:00:01~EndDate:1$T23:59:59~FacilityIDs:1~utcOffset:-66$" XLSFILENAMEGET3PLC!GET"# #d<$7".XLS23A=SCALL("/usr/local/bin/3plfixreport1.sh "+OUT1$)$(mv " 7 3loop through `N $ Job Finished 3done<3done#(@3T=$ ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#V$" YE2^ ERRORPAGE3-------- EMAIL ERROR MESSAGE+$'WFDIRtmp/000_last_error.txt,O_CREATE,O_TRUNC=$ ERROR ۩(Ө AT LINE ۩(Ө" IN ۩# L E$$' error_email (JBMAILTO@#(U39000 OUTTA HERE#<$3TEXT$=TEXT$+"
"+DEBUG$+"
"#F $ -&N 3---------- SEND THE EMAMILN%"$4' premailer FORCEMUTTN*$chuck@tssconnect.comN/L 51>$chuck@tssconnect.commaggie.dunn@ezicerinks.comN1; SENDTO$$SENDTO3TESTINGN2$, N45$3PLC Daily Inventory - CustId:  - 1N>$ NH$57N,WHMAILTO65N1$ 

Email sent to: , N8U V$&`=$''WFDIRtmp//_۩(Өө.jsonj $(% > ' 2>&1t(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)~$)$,)'3^1001)B?&3^100)n8 U3--------$+A3LET J=UNT; OPEN (J)"&1"*3READ RECORD(J,SIZ=99999)JQOUT$; CLOSE (J)($%cat " | jq -c '*' U $+&*8P ,Z&$|:C(1*=,),n8x]ô þ$.$.8(.] !$  $+$< width="۩(">8"], 6! $ @8J]T ^,$ $
h8r]| Ć ĚĐ/$//Ě8Ĥ]Į ĸ$"",8]( $, ۩5$۩ ۩ 8]  $   ($   ܨ 8] $$$ө8&]D  N# $ŞS$./X(  M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($/// @ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ]Ũ< // Ų ż$' 8] $$Alloc2Alloc| $"2"|*$2 4$|2>3 W$$ WAREHOUSEWHSE TRANSACTIONTRANSP$,.,$,,,|,,|:C(1*),8,,]  *)$Ө4$ %Ml %YH8R]˄  ˎ,$"'˘$\ˢ8ˬ] 5$ ӨM$ $ %Y%Mz Ө  $ %Y%Mz%Dz8 ]`3SCAN THRU CUSTOMER $Z/STARTING CUST ID: $(3PLINV1($<*$CGI TDELEMENTYYY1YYY2YYYYYCYYSYYZYYYVTEXTYYY1YYY2YYY ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1OUT3OUTFILEAC DOFILTERJQOUTZZZ1XIDLISTZZZ FILTERNAMEDOPAGEDATE2EOLASOFDUMMY ATTACHFILE HTMLFILEOUTCSV CGI.DOCUSTCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MMDYSAVEPERENDSUBJDOSCALLGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTFIX.DOCUSTCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MMDYSAVEPERENDSUBJDOSCALLGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTFIXAANTPLMAKEINTFIXAYYSYYZYYYVTEXTYYY1YYY2YYYDOYEAR ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEACRFILTER DOFILTERJQOUTZZZ1RROWVISTABLESQLDOTID RROW.QTY RROW.ITEMIDENTIFIERSKU VI.TRANSIDXIDLIST CH3PLSKUDOTTYPE CH3PLSKU.SKU CH3PLSKU.QTY CH3PLSKU.PERENDSKULIST CH3PLSKU.ITEMID RROW.ITEMIDENTIFIERIDZZZ CH3PLSKU.WHSETRANSTYPE CH3PLSKU.NOTES RROW.NOTESILISTRLIST FILTERNAMEDOPAGEDATE2EOLTSVFILEPERENDASOFCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MMDYSAVEPERENDSUBJDOSCALLGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTFIXXWHSE## TRANSACTIONTRANSP$2#.,$22,|22|:C(1*),822]  *)$"Ө4$ "%Ml %YH8R]˄  #ˎ,$##"##'˘$##\ˢ8#ˬ] 5$ӨM$$ %Y%MzӨ  $ %Y%Mz%Dz8 ]`3SCAN THRU CUSTOMER (Z/STARTING CUST ID: ((3PLINV1((<*(FTPLCGI TDELEMENTYYY1YYY2YYYYYCYYSYYZYYYVTEXTYYY1YYY2YYYDOYEAR ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTDEBUGYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEACRFILTER DOFILTERJQOUTZZZ1RROWVIFCOUNTFLISTVALS FLIST.NQTDSQLSTABLESQLFUNCFTYPEDOTID RROW.QTY RROW.ITEMIDENTIFIERSKU VI.TRANSIDXIDLIST CH3PLSKUDOTTYPE CH3PLSKU.SKU CH3PLSKU.QTYSQLOUT1 CH3PLSKU.PERENDSKULIST CH3PLSKU.ITEMID RROW.ITEMIDENTIFIERIDCOLS2S S.ITEMID S.SKU S.CUSTIDZZZ CH3PLSKU.WHSETRANSTYPE CH3PLSKU.NOTES RROW.NOTESSQLOUT2DOSQLILISTRLIST FILTERNAMEDOPAGE CH3PLINV S.LOCATION S.MU S.ONHAND S.INVDATEDATE2EOLTSVFILERROWTRR RROW.F1 RROW.F29 RROW.F24 RROW.F25LOC RROW.F5SKU S.PERENDDOFIRSTPERENDASOFCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MMDYSAVEPERENDSUBJDOSCALLGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTFIXt