https://www.bankstatementconverterai.online/_next/static/chunks/5332.41f964d7bbe0355d.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[5332],{45332:(e,t,o)=>{"use strict";o.r(t),o.d(t,{downloadInvoiceExcel:()=>r,downloadMergedExcel:()=>i});var n=o(26575),a=o.n(n),l=o(91540);async function r(e){let{fileName:t,summary:o,dataRows:n}=e,r=new(a()).Workbook,i=r.addWorksheet("Summary");i.addRow(["Date","Vendor","Total Amount"]),(o&&o.length>0?o:[null]).forEach(e=>{var t,o,n;i.addRow([null!=(t=null==e?void 0:e.date)?t:"",null!=(o=null==e?void 0:e.vendor)?o:"",null!=(n=null==e?void 0:e.totalAmount)?n:""])});let c=r.addWorksheet("Extracted Data");n.forEach(e=>c.addRow(e));let s=e=>{e.columns.forEach(e=>{let t=0;e&&e.eachCell&&e.eachCell({includeEmpty:!0},e=>{let o=e.value?e.value.toString().length:0;o>t&&(t=o)}),e.width=Math.min(t+2,50)})};s(i),s(c);let d=new Blob([await r.xlsx.writeBuffer()],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});(0,l.saveAs)(d,t.replace(/\.(pdf|PDF)$/,"")+".xlsx")}async function i(e){let t=new(a()).Workbook,o=t.addWorksheet("Invoices"),n={HEADER:"F0F7FF",FOOTER:"F7FAFC"},r=1;e.forEach((e,t)=>{let a="".concat(function(e){let t=["th","st","nd","rd"],o=e%100;return e+(t[(o-20)%10]||t[o]||t[0])}(t+1)," Source File: ").concat(e.name);o.addRow([a]).font={bold:!0,size:12,color:{argb:"FF4F46E5"}},r++;let l=e.csv.split("\n"),i=null;l.forEach(e=>{let t=e.trim();if(""===t)return;if(t.startsWith("[SECTION:")&&t.endsWith("]")){i=t.replace("[SECTION:","").replace("]","");return}let a=function(e){let t=[],o="",n=!1;for(let a=0;a<e.length;a++){let l=e[a];'"'===l&&(0===a||"\\"!==e[a-1])?n=!n:","!==l||n?o+=l:(t.push(o.replace(/^"|"$/g,"").trim()),o="")}return t.push(o.replace(/^"|"$/g,"").trim()),t}(t),l=o.addRow(a);i&&n[i]&&(l.fill={type:"pattern",pattern:"solid",fgColor:{argb:n[i]}}),r++}),o.addRow([]),r++}),o.columns.forEach(e=>{let t=0;e&&e.eachCell&&e.eachCell({includeEmpty:!0},e=>{let o=e.value?e.value.toString().length:0;o>t&&(t=o)}),e.width=Math.min(t+2,50)});let i=new Blob([await t.xlsx.writeBuffer()],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});(0,l.saveAs)(i,"merged_invoices.xlsx")}},91540:function(e,t,o){var n,a;void 0===(a="function"==typeof(n=function(){"use strict";function t(e,t,o){var n=new XMLHttpRequest;n.open("GET",e),n.responseType="blob",n.onload=function(){i(n.response,t,o)},n.onerror=function(){console.error("could not download file")},n.send()}function n(e){var t=new XMLHttpRequest;t.open("HEAD",e,!1);try{t.send()}catch(e){}return 200<=t.status&&299>=t.status}function a(e){try{e.dispatchEvent(new MouseEvent("click"))}catch(o){var t=document.createEvent("MouseEvents");

1t.initMouseEvent("click",!0,!0,window,0,0,0,80,20,!1,!1,!1,!1,0,null),e.dispatchEvent(t)}}var l="object"==typeof window&&window.window===window?window:"object"==typeof self&&self.self===self?self:"object"==typeof o.g&&o.g.global===o.g?o.g:void 0,r=l.navigator&&/Macintosh/.test(navigator.userAgent)&&/AppleWebKit/.test(navigator.userAgent)&&!/Safari/.test(navigator.userAgent),i=l.saveAs||("object"!=typeof window||window!==l?function(){}:"download"in HTMLAnchorElement.prototype&&!r?function(e,o,r){var i=l.URL||l.webkitURL,c=document.createElement("a");c.download=o=o||e.name||"download",c.rel="noopener","string"==typeof e?(c.href=e,c.origin===location.origin?a(c):n(c.href)?t(e,o,r):a(c,c.target="_blank")):(c.href=i.createObjectURL(e),setTimeout(function(){i.revokeObjectURL(c.href)},4e4),setTimeout(function(){a(c)},0))}:"msSaveOrOpenBlob"in navigator?function(e,o,l){if(o=o||e.name||"download","string"!=typeof e){var r;navigator.msSaveOrOpenBlob((void 0===(r=l)?r={autoBom:!1}:"object"!=typeof r&&(console.warn("Deprecated: Expected third argument to be a object"),r={autoBom:!r}),r.autoBom&&/^\s*(?:text\/\S*|application\/xml|\S*\/\S*\+xml)\s*;.*charset\s*=\s*utf-8/i.test(e.type)?new Blob(["\uFEFF",e],{type:e.type}):e),o)}else if(n(e))t(e,o,l);else{var i=document.createElement("a");i.href=e,i.target="_blank",setTimeout(function(){a(i)})}}:function(e,o,n,a){if((a=a||open("","_blank"))&&(a.document.title=a.document.body.innerText="downloading..."),"string"==typeof e)return t(e,o,n);var i="application/octet-stream"===e.type,c=/constructor/i.test(l.HTMLElement)||l.safari,s=/CriOS\/[\d]+/.test(navigator.userAgent);if((s||i&&c||r)&&"undefined"!=typeof FileReader){var d=new FileReader;d.onloadend=function(){var e=d.result;e=s?e:e.replace(/^data:[^;]*;/,"data:attachment/file;"),a?a.location.href=e:location=e,a=null},d.readAsDataURL(e)}else{var u=l.URL||l.webkitURL,f=u.createObjectURL(e);a?a.location=f:location.href=f,a=null,setTimeout(function(){u.revokeObjectURL(f)},4e4)}});l.saveAs=i.saveAs=i,e.exports=i})?n.apply(t,[]):n)||(e.exports=a)}}]);