3 ؀h9@s*ddlmZmZmZmZmZmZmZmZddl m Z m Z ddl Z ddl Z ddl Z ddlZddlZddlmZddlmZddlmZddlmZddlmZddlZdd lmZd d Zd d Zej ddgdddZ!ej dddZ"ej dddZ#ej dddZ$ej ddgdddZ%dS))Flaskjsonifyrender_templateurl_forrequestredirectjson make_response)datetime timedeltaN)etree)app)db) BatchfileCode)get_single_user) OrderedDictcCs|jjdS)N)sessionclose)selfr(/booking_service/app/routes/batchfile.pyrsrcCshtjjtj}|r t|j}nd}d}||}|sLt|d}tjj|n||_tjjt t|S)Nl_)batchfile_code) rrqueryrfirstintraddcommitr)get_current_codeZpStartZ pIntervalreccoderrr autoIncrements   r!z/batchfile/postPOST)methodsc6Csbg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jd Wn.tk r}z|jd WYdd}~XnX|rtd |id fStjtj tjd}|j d krXg}|jdtd|id fStjdtjdd}tjdt j dd|d}|jd}|jd}g}t } t| x|D]} t} | d| d<d| d<t| d| d<d| d<d| d<d| d <d| d!<t| d"| d#| d$d%| d&<| d'| d(<d| d)<| d*| d+<d| d,<| d-| d.<| d/| d0<d| d1<d| d2<d| d3<d| d4<d| d5<d| d6<d| d7<d| d8<d| d9<d| d:<| d;| d<<| d$| d=<y| d#| d"| d><Wntk r d| d><YnXd| d?<d| d@<d| dA<d| dB<d| dC<d| dD<d| dE<| dF| dG<| dH| dI<dJ| dK<dJ| dL<dJ| dM<dJ| dN<dJ| dO<dJ| dP<dJ| dQ<dJ| dR<d| dS<d| dT<d| dU<d| dV<d| dW<d| dX<d| dY<d| dZ<d| d[<d| d\<d| d]<d| d^<d| d_<d| d`<d| dA<d| da<d| db<d| dc<d| dd<d| de<d| d<d| d<d| d <d| d!<d| d<d| d<d| d <d| d!<d| d <d| d!<d| d<d| d<d| d <d| d!<d| d<d| d<d| d <d| d!<d| d <d| d!<d| df<d| dg<d| dh<d| di<d| dj<d| dk<d| dl<d| dm<d| dn<d| do<d| dp<d| dq<d| dr<d| ds<d| dt<d| du<d| dv<d| dw<d| dx<d| dy<d| dz<d| d{<d| d|<d| d}<d| d~<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d!<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<| jdr| dnd| d<|j| qWtj|} | jdj | ddddddtttt| ddt| dd} g}x|D]}t}|d|d<d|d<t|d|d<d|d<d|d<d|d <d|d!<t|d#|d|d$d%|d&<|d'|d(<d|d)<|d*|d+<d|d,<|d-|d.<|d/|d0<d|d1<d|d2<d|d3<d|d4<d|d5<d|d6<d|d7<d|d8<d|d9<d|d:<|d;|d<<|d$|d=<y|d#|d|d><Wntk r`d|d><YnXd|d?<d|d@<d|dA<d|dB<d|dC<d|dD<d|dE<dJ|dG<dJ|dI<dJ|dK<dJ|dL<dJ|dM<dJ|dN<dJ|dO<dJ|dP<dJ|dQ<dJ|dR<d|dS<d|dT<d|dU<d|dV<d|dW<d|dX<d|dY<d|dZ<d|d[<d|d\<d|d]<d|d^<d|d_<d|d`<d|dA<d|da<d|db<d|dc<d|dd<d|de<d|d<d|d<d|d <d|d!<d|d<d|d<d|d <d|d!<d|d <d|d!<d|d<d|d<d|d <d|d!<d|d<d|d<d|d <d|d!<d|d <d|d!<d|df<d|dg<d|dh<d|di<d|dj<d|dk<d|dl<d|dm<d|dn<d|do<d|dp<d|dq<d|dr<d|ds<d|dt<d|du<d|dv<d|dw<d|dx<d|dy<d|dz<d|d{<d|d|<d|d}<d|d~<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d!<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<|jd r|dnd|d<|j|qWtj|}|jdj | dddddddt j ddj | dt j ddj | dƜ}tt|S)z! Handling requests from the UI start_datezStart date is empty.zStart date is missing.Nend_datezEnd date is empty.zEnd date is missing. session_idzSession ID is empty.zSession ID is missing.messagesiz(Not authorised to perform this operationmessage)r$r%zhttps://SERVERz:5005/batchfile/generate/data)rdatatransation_dataincome_accountz Account CodezAccounting Period sales_datezTransaction DateFillerLz Record TypezJournal NumberzJournal Line Number base_amount tran_quantityconversion_ratez Base Amount dc_markerz D/C MarkerzAllocation Marker journal_typez Journal TypezJournal Sourcecustomer_referencezTransaction Referenceaccount_description Descriptionz Entry Datez Entry PeriodzDue DatezFiller 1zAllocation RefzAllocation DatezAllocation PeriodzAsset Indicatorz Asset Codez Asset SubcodecurrencyzConversion CodezConversion RatezTransaction AmountzTransaction Decimal PlaceszCleardown Sequence NumberzFiller 2z Reversal FlagzLoss Gain FlagzRough Transaction FlagzTransaction in UseoutletzAnalysis 1 Code departmentzAnalysis 2 Code#zAnalysis 3 CodezAnalysis 4 CodezAnalysis 5 CodezAnalysis 6 CodezAnalysis 7 CodezAnalysis 8 CodezAnalysis 9 CodezAnalysis 10 CodezPosting Date for Rough JournalszUpdate Order Balance IndicatorzAllocation in Progress FlagzJournal Hold ReferencezHold Operator IDzBudget Check Accountz"Conversion Rate from Pivot to BasezOperator for abovezOperator for Transaction Ratez)Conversion Rate from Pivot to Second BasezOperator for above 1zReport/Second Base Amountz Memo Amountz%Exclude from Balancing in RevaluationzLedger Extension Details FlagzConsumed Budget IDzValue 4 Currency CodezValue 4 AmountzValue 4 Conversion RatezValue 4 Operator 1zValue 4 Decimal PlaceszValue 5 Currency Codejournal_line_numberzValue 5 Amount 1zValue 5 Conversion Rate 1zValue 5 Operator 2zValue 5 Decimal Places 2zLink Reference 1zLink Reference 2zLink Reference 3zAllocation Code 2zAllocation Statements CountzAllocation User ID 1zOriginal Line for this SplitzValue DatetimezSigning DetailszInstallment DatezPrincipal CodezPrincipal Code 1zPrincipal Code 2zPrincipal Code 3zPrincipal Code 4zPrincipal Code 5zPrincipal Code 6zPrincipal Code 7zPrincipal Code 8zPrincipal Code 9zPrincipal Code 10zPrincipal Code 11zPrincipal Code 12zPrincipal Code 13zPrincipal Code 14zPrincipal Code 15zPrincipal Code 16zPrincipal Code 17zPrincipal Code 18zPrincipal Code 19z Binder Statusz Agreed StatuszSplit Link ReferencezPosting ReferencezTrue Rated Flagz Date Heldz Held TextzInstalment Numberz#Supplementary Extension Record FlagzApprovals Extension FlagzRevaluation Link ReferencezManual Payment Override Flagz Payment StampzAuthorization in ProgresszSplit in Progressz!Voucher Number / Second ReferencezJournal Class Codez Originator IdzOriginated Date and Timez Allocator IdzJournal Reversal TypezDocument Date 1zDocument Date 2zDocument Date 3zDocument Date 4zDocument Prefix 1zDocument Number 1zDocument Prefix 2zDocument Number 2zDocument Prefix 3zDocument Number 3zDocument Prefix 4zDocument Number 4zDiscount 1 DatezDiscount 1 PercentagezDiscount 2 DatezDiscount 2 Percentagez Interest DatezInterest PercentagezLate Payment DatezLate Payment PercentagezPayment Referencez Bank CodezSource Referencez Module CodezPayment Terms CodecuinvoicenumberzGeneral Description 1zbatchfiles/{0}.csv,Fzutf-8z )sepheaderindexencodingline_terminatorrr unit_pricez/docs/batchfiles/{0}.csv)url_1url_2)rrstripappendKeyErrorrrequestsgetrformat status_coder configr!printrstrround Exceptionpd DataFrameto_csvrr )r'eget_userr) json_data batch_data incoming_datatransaction_data_jsonr+ batch_numbercontentresponsedfbatchfile_numbertransaction_data transaction response_datatransaction_dfresponseObjectrrrui_generated_batchfile2sB                  *            riz/batchfile/datac Cs tjdtjdd}|jd}|jd}g}t}t|x|D]}t}|d|d<d|d <t|d |d <d|d <d |d<d|d<d|d<t |d|d|dd|d<|d|d<d|d<|d|d<|d|d<|d|d<|d|d <d|d!<d|d"<d|d#<d|d$<d|d%<d|d&<d|d'<d|d(<d|d)<d|d*<|d+|d,<|d|d-<y|d|d|d.<Wnt k rd|d.<YnXd|d/<d|d0<d|d1<d|d2<d|d3<d|d4<d|d5<|d6|d7<|d8|d9<d:|d;<d:|d<<d:|d=<d:|d><d:|d?<d:|d@<d:|dA<d:|dB<d|dC<d|dD<d|dE<d|dF<d|dG<d|dH<d|dI<d|dJ<d|dK<d|dL<d|dM<d|dN<d|dO<d|dP<d|d1<d|dQ<d|dR<d|dS<d|dT<d|dU<d|d <d|d<d|d<d|d<d|d <d|d<d|d<d|d<d|d<d|d<d|d <d|d<d|d<d|d<d|d <d|d<d|d<d|d<d|d<d|d<d|dV<d|dW<d|dX<d|dY<d|dZ<d|d[<d|d\<d|d]<d|d^<d|d_<d|d`<d|da<d|db<d|dc<d|dd<d|de<d|df<d|dg<d|dh<d|di<d|dj<d|dk<d|dl<d|dm<d|dn<d|do<d|dp<d|dq<d|dr<d|ds<d|dt<d|du<d|dv<d|dw<d|dx<d|dy<d|dz<d|d{<d|d|<d|d}<d|d~<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<|jdr,|dnd|d<|j |qJWt j |}|jdj|ddddddtttt|ddt|dd}g} x|D]} t} | d| d<d| d <t| d | d <d| d <d | d<d| d<d| d<t | d| d| dd| d<| d| d<d| d<| d| d<d| d<| d| d<| d| d <d| d!<d| d"<d| d#<d| d$<d| d%<d| d&<d| d'<d| d(<d| d)<d| d*<| d+| d,<| d| d-<y| d| d| d.<Wnt k rd| d.<YnXd| d/<d| d0<d| d1<d| d2<d| d3<d| d4<d| d5<d:| d7<d:| d9<d:| d;<d:| d<<d:| d=<d:| d><d:| d?<d:| d@<d:| dA<d:| dB<d| dC<d| dD<d| dE<d| dF<d| dG<d| dH<d| dI<d| dJ<d| dK<d| dL<d| dM<d| dN<d| dO<d| dP<d| d1<d| dQ<d| dR<d| dS<d| dT<d| dU<d| d <d| d<d| d<d| d<d| d <d| d<d| d<d| d<d| d<d| d<d| d <d| d<d| d<d| d<d| d <d| d<d| d<d| d<d| d<d| d<d| dV<d| dW<d| dX<d| dY<d| dZ<d| d[<d| d\<d| d]<d| d^<d| d_<d| d`<d| da<d| db<d| dc<d| dd<d| de<d| df<d| dg<d| dh<d| di<d| dj<d| dk<d| dl<d| dm<d| dn<d| do<d| dp<d| dq<d| dr<d| ds<d| dt<d| du<d| dv<d| dw<d| dx<d| dy<d| dz<d| d{<d| d|<d| d}<d| d~<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<d| d<| jd rv| dnd| d<| j | qWt j | } | jdj|dddddddtjddj|dtjddj|d} tt| S)Nzhttps://r*z:5005/batchfile/generate/datar+r,r-z Account Coder.zAccounting Periodr/zTransaction Dater0r1z Record TypezJournal NumberzJournal Line Numberr2r3r4r5z Base Amountr6z D/C MarkerzAllocation Markerr7z Journal Typecredit_note_refzJournal Sourcer8zTransaction Referencer9r:z Entry Datez Entry PeriodzDue DatezFiller 1zAllocation RefzAllocation DatezAllocation PeriodzAsset Indicatorz Asset Codez Asset Subcoder;zConversion CodezConversion RatezTransaction AmountzTransaction Decimal PlaceszCleardown Sequence NumberzFiller 2z Reversal FlagzLoss Gain FlagzRough Transaction FlagzTransaction in User<zAnalysis 1 Coder=zAnalysis 2 Coder>zAnalysis 3 CodezAnalysis 4 CodezAnalysis 5 CodezAnalysis 6 CodezAnalysis 7 CodezAnalysis 8 CodezAnalysis 9 CodezAnalysis 10 CodezPosting Date for Rough JournalszUpdate Order Balance IndicatorzAllocation in Progress FlagzJournal Hold ReferencezHold Operator IDzBudget Check Accountz"Conversion Rate from Pivot to BasezOperator for abovezOperator for Transaction Ratez)Conversion Rate from Pivot to Second BasezOperator for above 1zReport/Second Base Amountz Memo Amountz%Exclude from Balancing in RevaluationzLedger Extension Details FlagzConsumed Budget IDzValue 4 Currency CodezValue 4 AmountzValue 4 Conversion RatezValue 4 Operator 1zValue 4 Decimal PlaceszValue 5 Currency Coder?zValue 5 Amount 1zValue 5 Conversion Rate 1zValue 5 Operator 2zValue 5 Decimal Places 2zLink Reference 1zLink Reference 2zLink Reference 3zAllocation Code 2zAllocation Statements CountzAllocation User ID 1zOriginal Line for this SplitzValue DatetimezSigning DetailszInstallment DatezPrincipal CodezPrincipal Code 1zPrincipal Code 2zPrincipal Code 3zPrincipal Code 4zPrincipal Code 5zPrincipal Code 6zPrincipal Code 7zPrincipal Code 8zPrincipal Code 9zPrincipal Code 10zPrincipal Code 11zPrincipal Code 12zPrincipal Code 13zPrincipal Code 14zPrincipal Code 15zPrincipal Code 16zPrincipal Code 17zPrincipal Code 18zPrincipal Code 19z Binder Statusz Agreed StatuszSplit Link ReferencezPosting ReferencezTrue Rated Flagz Date Heldz Held TextzInstalment Numberz#Supplementary Extension Record FlagzApprovals Extension FlagzRevaluation Link ReferencezManual Payment Override Flagz Payment StampzAuthorization in ProgresszSplit in Progressz!Voucher Number / Second ReferencezJournal Class Codez Originator IdzOriginated Date and Timez Allocator IdzJournal Reversal TypezDocument Date 1zDocument Date 2zDocument Date 3zDocument Date 4zDocument Prefix 1zDocument Number 1zDocument Prefix 2zDocument Number 2zDocument Prefix 3zDocument Number 3zDocument Prefix 4zDocument Number 4zDiscount 1 DatezDiscount 1 PercentagezDiscount 2 DatezDiscount 2 Percentagez Interest DatezInterest PercentagezLate Payment DatezLate Payment PercentagezPayment Referencez Bank CodezSource Referencez Module CodezPayment Terms Coder@zGeneral Description 1zbatchfiles/{0}.csvrAFzutf-8z )rBrCrDrErFrrrGz/docs/batchfiles/{0}.csv)rHrI)rMrNr rQrr!rRrrSrTrUrKrVrWrXrOrr r)r\r]r^r+r_r`rarbrcrdrerfrgrhrrrcreateBatchfile&s                *            rkz/batchfile-credit/datac Cstjdtjdd}|jd}g}tjjtj }t |j }t t t t |ddt |dd}|}x|D]}t }|d|d <d |d <t |d |d <d |d<d|d<d |d<d |d<t|d|d|dd|d<|d|d<d |d<|d|d<|d|d<|d|d<|d |d!<d |d"<d |d#<d |d$<d |d%<d |d&<d |d'<d |d(<d |d)<d |d*<d |d+<|d,|d-<|d|d.<y|d|d|d/<Wntk rd|d/<YnXd |d0<d |d1<d |d2<d |d3<d |d4<d |d5<d |d6<|d7|d8<|d9|d:<d;|d<<d;|d=<d;|d><d;|d?<d;|d@<d;|dA<d;|dB<d;|dC<d |dD<d |dE<d |dF<d |dG<d |dH<d |dI<d |dJ<d |dK<d |dL<d |dM<d |dN<d |dO<d |dP<d |dQ<d |d2<d |dR<d |dS<d |dT<d |dU<d |dV<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |dW<d |dX<d |dY<d |dZ<d |d[<d |d\<d |d]<d |d^<d |d_<d |d`<d |da<d |db<d |dc<d |dd<d |de<d |df<d |dg<d |dh<d |di<d |dj<d |dk<d |dl<d |dm<d |dn<d |do<d |dp<d |dq<d |dr<d |ds<d |dt<d |du<d |dv<d |dw<d |dx<d |dy<d |dz<d |d{<d |d|<d |d}<d |d~<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<|jdr\|dnd |d<|j|qzWtj|}|jdj|ddddddddtjddj|i} tt| S)Nzhttps://r*z:5005/credit/batchfiler+rr5rr-z Account Coder.zAccounting Periodr/zTransaction Dater0r1z Record TypezJournal NumberzJournal Line Numberr2r3r4z Base Amountr6z D/C MarkerzAllocation Markerr7z Journal TyperjzJournal Sourcer8zTransaction Referencer9r:z Entry Datez Entry PeriodzDue DatezFiller 1zAllocation RefzAllocation DatezAllocation PeriodzAsset Indicatorz Asset Codez Asset Subcoder;zConversion CodezConversion RatezTransaction AmountzTransaction Decimal PlaceszCleardown Sequence NumberzFiller 2z Reversal FlagzLoss Gain FlagzRough Transaction FlagzTransaction in User<zAnalysis 1 Coder=zAnalysis 2 Coder>zAnalysis 3 CodezAnalysis 4 CodezAnalysis 5 CodezAnalysis 6 CodezAnalysis 7 CodezAnalysis 8 CodezAnalysis 9 CodezAnalysis 10 CodezPosting Date for Rough JournalszUpdate Order Balance IndicatorzAllocation in Progress FlagzJournal Hold ReferencezHold Operator IDzBudget Check Accountz"Conversion Rate from Pivot to BasezOperator for abovezOperator for Transaction Ratez)Conversion Rate from Pivot to Second BasezOperator for above 1zReport/Second Base Amountz Memo Amountz%Exclude from Balancing in RevaluationzLedger Extension Details FlagzConsumed Budget IDzValue 4 Currency CodezValue 4 AmountzValue 4 Conversion RatezValue 4 Operator 1zValue 4 Decimal PlaceszValue 5 Currency Coder?zValue 5 Amount 1zValue 5 Conversion Rate 1zValue 5 Operator 2zValue 5 Decimal Places 2zLink Reference 1zLink Reference 2zLink Reference 3zAllocation Code 2zAllocation Statements CountzAllocation User ID 1zOriginal Line for this SplitzValue DatetimezSigning DetailszInstallment DatezPrincipal CodezPrincipal Code 1zPrincipal Code 2zPrincipal Code 3zPrincipal Code 4zPrincipal Code 5zPrincipal Code 6zPrincipal Code 7zPrincipal Code 8zPrincipal Code 9zPrincipal Code 10zPrincipal Code 11zPrincipal Code 12zPrincipal Code 13zPrincipal Code 14zPrincipal Code 15zPrincipal Code 16zPrincipal Code 17zPrincipal Code 18zPrincipal Code 19z Binder Statusz Agreed StatuszSplit Link ReferencezPosting ReferencezTrue Rated Flagz Date Heldz Held TextzInstalment Numberz#Supplementary Extension Record FlagzApprovals Extension FlagzRevaluation Link ReferencezManual Payment Override Flagz Payment StampzAuthorization in ProgresszSplit in Progressz!Voucher Number / Second ReferencezJournal Class Codez Originator IdzOriginated Date and Timez Allocator IdzJournal Reversal TypezDocument Date 1zDocument Date 2zDocument Date 3zDocument Date 4zDocument Prefix 1zDocument Number 1zDocument Prefix 2zDocument Number 2zDocument Prefix 3zDocument Number 3zDocument Prefix 4zDocument Number 4zDiscount 1 DatezDiscount 1 PercentagezDiscount 2 DatezDiscount 2 Percentagez Interest DatezInterest PercentagezLate Payment DatezLate Payment PercentagezPayment Referencez Bank CodezSource Referencez Module CodezPayment Terms Coder@zGeneral Description 1zbatchfiles/{0}.csvrAFzutf-8z )rBrCrDrErFrHz/docs/batchfiles/{0}.csv)rMrNr rQrrrrrrrrrSrrTrUrKrVrWrXrOr r) r\r]r+rr_rcr`rarbrhrrrcreateCreditBatchfiles  *             rlz/payment-credit/batchfile/datac Cstjdtjdd}|jd}g}tjjtj }t |j }t t t t |ddt |dd}|}x|D]}t }|d |d <d |d <t |d |d<d |d<d|d<d |d<d |d<t|d|d|dd|d<|d|d<d |d<|d|d<td|d<|d |d!<|d"|d#<d |d$<d |d%<d |d&<d |d'<d |d(<d |d)<d |d*<d |d+<d |d,<d |d-<|d.|d/<|d|d0<y|d|d|d1<Wntk rd|d1<YnXd |d2<d |d3<d |d4<d |d5<d |d6<d |d7<d |d8<d9|d:<d9|d;<d9|d<<d9|d=<d9|d><d9|d?<d9|d@<d9|dA<d9|dB<d9|dC<d |dD<d |dE<d |dF<d |dG<d |dH<d |dI<d |dJ<d |dK<d |dL<d |dM<d |dN<d |dO<d |dP<d |dQ<d |d4<d |dR<d |dS<d |dT<d |dU<d |dV<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |dW<d |dX<d |dY<d |dZ<d |d[<d |d\<d |d]<d |d^<d |d_<d |d`<d |da<d |db<d |dc<d |dd<d |de<d |df<d |dg<d |dh<d |di<d |dj<d |dk<d |dl<d |dm<d |dn<d |do<d |dp<d |dq<d |dr<d |ds<d |dt<d |du<d |dv<d |dw<d |dx<d |dy<d |dz<d |d{<d |d|<d |d}<d |d~<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<d |d<|jdrT|dnd |d<|j|qzWtj|}|jdj|ddddddddtjddj|i} tt| S)zF Used to clear up certain issues that are made in payments received zhttps://r*z:5005/payments/credit/batchfiler+rrNr-z Account Coder.zAccounting Periodr/zTransaction Dater0r1z Record TypezJournal NumberzJournal Line Numberr3rGr4r5z Base Amountr6z D/C MarkerzAllocation Markerr7z Journal TyperjzJournal Sourcer8zTransaction Referencer9r:z Entry Datez Entry PeriodzDue DatezFiller 1zAllocation RefzAllocation DatezAllocation PeriodzAsset Indicatorz Asset Codez Asset Subcoder;zConversion CodezConversion RatezTransaction AmountzTransaction Decimal PlaceszCleardown Sequence NumberzFiller 2z Reversal FlagzLoss Gain FlagzRough Transaction FlagzTransaction in User>zAnalysis 1 CodezAnalysis 2 CodezAnalysis 3 CodezAnalysis 4 CodezAnalysis 5 CodezAnalysis 6 CodezAnalysis 7 CodezAnalysis 8 CodezAnalysis 9 CodezAnalysis 10 CodezPosting Date for Rough JournalszUpdate Order Balance IndicatorzAllocation in Progress FlagzJournal Hold ReferencezHold Operator IDzBudget Check Accountz"Conversion Rate from Pivot to BasezOperator for abovezOperator for Transaction Ratez)Conversion Rate from Pivot to Second BasezOperator for above 1zReport/Second Base Amountz Memo Amountz%Exclude from Balancing in RevaluationzLedger Extension Details FlagzConsumed Budget IDzValue 4 Currency CodezValue 4 AmountzValue 4 Conversion RatezValue 4 Operator 1zValue 4 Decimal PlaceszValue 5 Currency Coder?zValue 5 Amount 1zValue 5 Conversion Rate 1zValue 5 Operator 2zValue 5 Decimal Places 2zLink Reference 1zLink Reference 2zLink Reference 3zAllocation Code 2zAllocation Statements CountzAllocation User ID 1zOriginal Line for this SplitzValue DatetimezSigning DetailszInstallment DatezPrincipal CodezPrincipal Code 1zPrincipal Code 2zPrincipal Code 3zPrincipal Code 4zPrincipal Code 5zPrincipal Code 6zPrincipal Code 7zPrincipal Code 8zPrincipal Code 9zPrincipal Code 10zPrincipal Code 11zPrincipal Code 12zPrincipal Code 13zPrincipal Code 14zPrincipal Code 15zPrincipal Code 16zPrincipal Code 17zPrincipal Code 18zPrincipal Code 19z Binder Statusz Agreed StatuszSplit Link ReferencezPosting ReferencezTrue Rated Flagz Date Heldz Held TextzInstalment Numberz#Supplementary Extension Record FlagzApprovals Extension FlagzRevaluation Link ReferencezManual Payment Override Flagz Payment StampzAuthorization in ProgresszSplit in Progressz!Voucher Number / Second ReferencezJournal Class Codez Originator IdzOriginated Date and Timez Allocator IdzJournal Reversal TypezDocument Date 1zDocument Date 2zDocument Date 3zDocument Date 4zDocument Prefix 1zDocument Number 1zDocument Prefix 2zDocument Number 2zDocument Prefix 3zDocument Number 3zDocument Prefix 4zDocument Number 4zDiscount 1 DatezDiscount 1 PercentagezDiscount 2 DatezDiscount 2 Percentagez Interest DatezInterest PercentagezLate Payment DatezLate Payment PercentagezPayment Referencez Bank CodezSource Referencez Module CodezPayment Terms Coder@zGeneral Description 1zbatchfiles/{0}.csvrAFzutf-8z )rBrCrDrErFrHz/docs/batchfiles/{0}.csv)rMrNr rQrrrrrrrrrSrrTr`rUrKrVrWrXrOr r) r\r]r+rr_rcrerfrbrhrrrcreatePaymentsCreditBatchfiles   *           rnz/credit-notes/batchfilec Cstjjtj}t|j}tttt|ddt|dd}|}tj dtj dd}t j dt j d d |d }|j d }g}x|D]}t}|d |d<d|d<t|d|d<d|d<d|d<d|d<d|d<t|d|d|dd|d<|d|d<d|d<|d|d <|d!|d"<|d#|d$<|d%|d&<d|d'<d|d(<d|d)<d|d*<d|d+<d|d,<d|d-<d|d.<d|d/<d|d0<|d1|d2<|d|d3<y|d|d|d4<Wntk rd|d4<YnXd|d5<d|d6<d|d7<d|d8<d|d9<d|d:<d|d;<|d<|d=<|d>|d?<d@|dA<d@|dB<d@|dC<d@|dD<d@|dE<d@|dF<d@|dG<d@|dH<d|dI<d|dJ<d|dK<d|dL<d|dM<d|dN<d|dO<d|dP<d|dQ<d|dR<d|dS<d|dT<d|dU<d|dV<d|d7<d|dW<d|dX<d|dY<d|dZ<d|d[<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d\<d|d]<d|d^<d|d_<d|d`<d|da<d|db<d|dc<d|dd<d|de<d|df<d|dg<d|dh<d|di<d|dj<d|dk<d|dl<d|dm<d|dn<d|do<d|dp<d|dq<d|dr<d|ds<d|dt<d|du<d|dv<d|dw<d|dx<d|dy<d|dz<d|d{<d|d|<d|d}<d|d~<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<d|d<|jdrv|dnd|d<|j|qWtj|} | jdj|ddddddtddt j d dj|idfS)z, The actual credit not batchfile function rr5rNr$r%)r$r%zhttps://r*z:5005/credit-notes/data)rr+r-z Account Coder.zAccounting Periodr/zTransaction Dater0r1z Record TypezJournal NumberzJournal Line Numberr2r3r4z Base Amountr6z D/C MarkerzAllocation Markerr7z Journal Typer9zJournal Sourcer8zTransaction Referencerjr:z Entry Datez Entry PeriodzDue DatezFiller 1zAllocation RefzAllocation DatezAllocation PeriodzAsset Indicatorz Asset Codez Asset Subcoder;zConversion CodezConversion RatezTransaction AmountzTransaction Decimal PlaceszCleardown Sequence NumberzFiller 2z Reversal FlagzLoss Gain FlagzRough Transaction FlagzTransaction in User<zAnalysis 1 Coder=zAnalysis 2 Coder>zAnalysis 3 CodezAnalysis 4 CodezAnalysis 5 CodezAnalysis 6 CodezAnalysis 7 CodezAnalysis 8 CodezAnalysis 9 CodezAnalysis 10 CodezPosting Date for Rough JournalszUpdate Order Balance IndicatorzAllocation in Progress FlagzJournal Hold ReferencezHold Operator IDzBudget Check Accountz"Conversion Rate from Pivot to BasezOperator for abovezOperator for Transaction Ratez)Conversion Rate from Pivot to Second BasezOperator for above 1zReport/Second Base Amountz Memo Amountz%Exclude from Balancing in RevaluationzLedger Extension Details FlagzConsumed Budget IDzValue 4 Currency CodezValue 4 AmountzValue 4 Conversion RatezValue 4 Operator 1zValue 4 Decimal PlaceszValue 5 Currency Coder?zValue 5 Amount 1zValue 5 Conversion Rate 1zValue 5 Operator 2zValue 5 Decimal Places 2zLink Reference 1zLink Reference 2zLink Reference 3zAllocation Code 2zAllocation Statements CountzAllocation User ID 1zOriginal Line for this SplitzValue DatetimezSigning DetailszInstallment DatezPrincipal CodezPrincipal Code 1zPrincipal Code 2zPrincipal Code 3zPrincipal Code 4zPrincipal Code 5zPrincipal Code 6zPrincipal Code 7zPrincipal Code 8zPrincipal Code 9zPrincipal Code 10zPrincipal Code 11zPrincipal Code 12zPrincipal Code 13zPrincipal Code 14zPrincipal Code 15zPrincipal Code 16zPrincipal Code 17zPrincipal Code 18zPrincipal Code 19z Binder Statusz Agreed StatuszSplit Link ReferencezPosting ReferencezTrue Rated Flagz Date Heldz Held TextzInstalment Numberz#Supplementary Extension Record FlagzApprovals Extension FlagzRevaluation Link ReferencezManual Payment Override Flagz Payment StampzAuthorization in ProgresszSplit in Progressz!Voucher Number / Second ReferencezJournal Class Codez Originator IdzOriginated Date and Timez Allocator IdzJournal Reversal TypezDocument Date 1zDocument Date 2zDocument Date 3zDocument Date 4zDocument Prefix 1zDocument Number 1zDocument Prefix 2zDocument Number 2zDocument Prefix 3zDocument Number 3zDocument Prefix 4zDocument Number 4zDiscount 1 DatezDiscount 1 PercentagezDiscount 2 DatezDiscount 2 Percentagez Interest DatezInterest PercentagezLate Payment DatezLate Payment PercentagezPayment Referencez Bank CodezSource Referencez Module CodezPayment Terms Coder@zGeneral Description 1zbatchfiles/{0}.csvrAFzutf-8z )rBrCrDrErFurlz/docs/batchfiles/{0}.csvr()rrrrrrrrSrrrMpostr rQrrTrUrNrKrVrWrXrOr) rr_rcr[r\r]r+r`rarbrrrgenerate_credit_note_files *              rq)&flaskrrrrrrrr r r pymysqlosmathrMuuidlxmlr ETroutesr rZdatabase.batchfile_coder variablesrpandasrV collectionsrrr!routerirkrlrnrqrrrrs0((      wPtv