https://empresaexcelencia.cv/_next/static/chunks/3700-24dd11ad55aa5bfa.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[3700],{93162:function(t,o,a){var r,s;void 0!==(s="function"==typeof(r=function(){"use strict";function c(t,o,a){var r=new XMLHttpRequest;r.open("GET",t),r.responseType="blob",r.onload=function(){s(r.response,o,a)},r.onerror=function(){console.error("could not download file")},r.send()}function d(t){var o=new XMLHttpRequest;o.open("HEAD",t,!1);try{o.send()}catch(t){}return 200<=o.status&&299>=o.status}function e(t){try{t.dispatchEvent(new MouseEvent("click"))}catch(a){var o=document.createEvent("MouseEvents");o.initMouseEvent("click",!0,!0,window,0,0,0,80,20,!1,!1,!1,!1,0,null),t.dispatchEvent(o)}}var o="object"==typeof window&&window.window===window?window:"object"==typeof self&&self.self===self?self:"object"==typeof a.g&&a.g.global===a.g?a.g:void 0,r=o.navigator&&/Macintosh/.test(navigator.userAgent)&&/AppleWebKit/.test(navigator.userAgent)&&!/Safari/.test(navigator.userAgent),s=o.saveAs||("object"!=typeof window||window!==o?function(){}:"download"in HTMLAnchorElement.prototype&&!r?function(t,a,r){var s=o.URL||o.webkitURL,n=document.createElement("a");a=a||t.name||"download",n.download=a,n.rel="noopener","string"==typeof t?(n.href=t,n.origin===location.origin?e(n):d(n.href)?c(t,a,r):e(n,n.target="_blank")):(n.href=s.createObjectURL(t),setTimeout(function(){s.revokeObjectURL(n.href)},4e4),setTimeout(function(){e(n)},0))}:"msSaveOrOpenBlob"in navigator?function(t,o,a){if(o=o||t.name||"download","string"!=typeof t){var r;navigator.msSaveOrOpenBlob((void 0===(r=a)?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(t.type)?new Blob(["\uFEFF",t],{type:t.type}):t),o)}else if(d(t))c(t,o,a);else{var s=document.createElement("a");s.href=t,s.target="_blank",setTimeout(function(){e(s)})}}:function(t,a,s,n){if((n=n||open("","_blank"))&&(n.document.title=n.document.body.innerText="downloading..."),"string"==typeof t)return c(t,a,s);var i="application/octet-stream"===t.type,l=/constructor/i.test(o.HTMLElement)||o.safari,u=/CriOS\/[\d]+/.test(navigator.userAgent);if((u||i&&l||r)&&"undefined"!=typeof FileReader){var p=new FileReader;p.onloadend=function(){var t=p.result;t=u?t:t.replace(/^data:[^;]*;/,"data:attachment/file;"),n?n.location.href=t:location=t,n=null},p.readAsDataURL(t)}else{var m=o.URL||o.webkitURL,x=m.createObjectURL(t);n?n.location=x:location.href=x,n=null,setTimeout(function(){m.revokeObjectURL(x)},4e4)}});o.saveAs=s.saveAs=s,t.exports=s})?r.apply(o,[]):r)&&(t.exports=s)},80005:function(t,o,a){"use strict";a.d(o,{Z:function(){return Paginator}});var r=a(85893);function Paginator(t){let{page:o,setPage:a,size:s}=t,addPageButton=t=>(0,r.jsx)("button",{className:"mx-2 px-2 py-1 rounded ".concat(1===s?"hidden":""," ").concat(o===t?"bg-[#AD8B19] text-[#ffffff]":"text-[#ACACAC]"),onClick:()=>a(t),children:t+1},t),addEllipsis=t=>(0,r.jsx)("span",{className:"mx-2",children:"..."},t),buildInitialPages=()=>{let t=[];for(let o=1;o<5;o++)t.push(addPageButton(o));return t.push(addEllipsis("ellipsis-right")),t},buildFinalPages=()=>{let t=[addEllipsis("ellipsis-left")];for(let o=s-5;o<s-1;o++)t.push(addPageButton(o));return t},buildMiddlePages=()=>{let t=[addEllipsis("ellipsis-left")];for(let a=o-1;a<=o+1;a++)t.push(addPageButton(a));return t.push(addEllipsis("ellipsis-right")),t};return!s||s<2?null:(0,r.jsx)("div",{className:"flex justify-center my-4",children:(()=>{let t=[addPageButton(0)];if(s<=7)for(let o=1;o<s-1;o++)t.push(addPageButton(o));else{let a=[];a=o<4?buildInitialPages():o>=s-5?buildFinalPages():buildMiddlePages(),t.push(...a)}return s>1&&t.push(addPageButton(s-1)),t})()})}},33779:function(t,o,a){"use strict";a.d(o,{Z:function(){return ExcelExportBalance}});var r=a(85893),s=a(35773),n=a(9615),i=a(74295),l=a.n(i),u=a(93162),p=a(25675),m=a.n(p),x=a(22920),w=a(4023),g=a(67294),h=a(30727),f=a(42746);let getUniqueWorksheetName=(t,o)=>{let a=o,r=1;for(;t.getWorksheet(a);)a="".concat(o," (").concat(r,")"),r++;return a},fetchData=async(t,o,a,r,s)=>{try{let n=await t.getList(o,[["companies",a]],{page:r,size:s,sort:"dateInsert,desc"}),i=n.data.content;return{diagnosesData:i}}catch(o){var n,i,l,u,p,m,w,g,h,f,v;let t=Array.isArray(null==o?void 0:null===(l=o.response)||void 0===l?void 0:null===(i=l.data)||void 0===i?void 0:null===(n=i.errorsDetails)||void 0===n?void 0:n.debugMessage)?null==o?void 0:null===(g=o.response)||void 0===g?void 0:null===(w=g.data)||void 0===w?void 0:null===(m=w.errorsDetails)||void 0===m?void 0:null===(p=m.debugMessage)||void 0===p?void 0:null===(u=p[0])||void 0===u?void 0:u.message:null==o?void 0:null===(v=o.response)||void 0===v?void 0:null===(f=v.data)||void 0===f?void 0:null===(h=f.errorsDetails)||void 0===h?void 0:h.debugMessage;throw x.Am.error(t),o}};function ExcelExportBalance(t){let{balances:o=!1,dataArray:a,url:i,headings:p,fileName:x,icon:v=!1,buttonName:b="",companyName:C,currentPage:R,pageSize:y,type:L}=t;console.log(a,"dataArray"),console.log(L,"ExcelBalancesType");let E="balances"===L,{token:j,APIURL:N,companyID:A}=(0,w.qD)(),k=(0,g.useMemo)(()=>new h.Z(N,j),[j,N]),[F,S]=(0,g.useState)(!1),B=(0,f.useTranslations)("titles"),handleExport=async()=>{let t,r;if(S(!0),!v){try{let o=await fetchData(k,i,A,R,y);t=o.diagnosesData}catch(t){return}r=(0,s.OI)(t,p)}v&&(r=a),console.log(r,"arrayOfData");let m=new(l()).Workbook;if(r)for(let t of r){let a=getUniqueWorksheetName(m,(0,s.q6)(t.balanceSheetName)),r=m.addWorksheet(a);r.columns=[{header:"Rubricas",key:"rubricas",width:32},{header:"Valor",key:"valor",width:15}],r.spliceRows(1,0,[C,""]),r.spliceRows(2,0,["".concat((0,s.q6)(t.balanceSheetName)," de ").concat((0,s.p6)(t.startDate)," a ").concat((0,s.p6)(t.endDate)),""]),r.getRow(1).font={size:14,bold:!0},r.getRow(1).alignment={vertical:"middle",horizontal:"center"},r.getRow(2).font={size:12,italic:!0},r.getRow(3).font={size:14,bold:!0},r.getRow(2).font={size:14,bold:!0},r.getRow(2).alignment={vertical:"middle",horizontal:"center"}

1,t.headingResults.forEach(t=>{let a=r.addRow({rubricas:t.description,valor:o?null:parseFloat(t.result)});a.font={bold:!0};let s=(0,n.uj)(t.subHeadingResults,n.aK);null==s||s.forEach(t=>{let a=r.addRow({rubricas:t.description,valor:o?null:parseFloat(t.result)});a.font={bold:!0},a.getCell(1).alignment={indent:1};let s=(0,n.nE)(t.description),i=(0,n.uj)(t.categoryResults,s);if(null==i||i.forEach(t=>{let o=r.addRow({rubricas:t.description,valor:parseFloat(t.result)});o.getCell(1).alignment={indent:2};let a=(0,n.lr)(t.description),s=(0,n.uj)(t.subCategoryResults,a);null==s||s.forEach(t=>{let o=r.addRow({rubricas:t.description,valor:parseFloat(t.result)});o.getCell(1).alignment={indent:4}})}),o){let o=r.addRow({rubricas:E?"Total do/a ".concat(t.description):t.description,valor:parseFloat(t.result)});o.font={bold:!0},o.getCell(1).alignment={indent:1}}});let i=r.addRow({rubricas:"Total do/a ".concat(t.description),valor:parseFloat(t.result)});i.font={bold:!!E}}),function(t){t.columns.forEach(t=>{let o=0;t.eachCell({includeEmpty:!0},t=>{var a;let r=t.value,s=null!==(a=null==r?void 0:r.toString().length)&&void 0!==a?a:0;s>o&&(o=s)}),t.width=o<10?10:o})}(r)}let w=await m.xlsx.writeBuffer();S(!1);let g=new Blob([w],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});(0,u.saveAs)(g,x.replace(/\./g,"_"))};return v?(0,r.jsxs)("button",{title:"Extrair",type:"button",onClick:handleExport,className:F?"pointer-events-none button_Export bg-[#AD8B19FF]":"active:scale-95 transform ease-in-out button_Export hover:bg-[#f7e7b2]",children:[(0,r.jsx)(m(),{className:"block md:hidden",width:30,height:35,src:F?"/downloadFileBlank.svg":"/downloadFileGold.svg",alt:"SVG"}),(0,r.jsx)(m(),{className:"hidden md:block",width:20,height:15,src:F?"/downloadFileBlank.svg":"/downloadFileGold.svg",alt:"SVG"})]}):(0,r.jsxs)("button",{onClick:handleExport,className:F?"\npointer-events-none\nflex justify-center gap-2 items-center\n    button_Export \n    hover:!bg-[#FFFFFF] \n    !text-[#AD8B19FF] \n    hover:!text-[#AD8B19FF]":"\n    active:scale-95 \n    transform \n    ease-in-out \n    button_Export \n    hover:!bg-[#AD8B19FF] \n    text-white \n    hover:!text-white",children:[(0,r.jsx)("span",{children:F?B("loading"):b}),F&&(0,r.jsx)(m(),{width:20,height:15,src:"/rotation.svg",alt:"SVG",className:"!text-pink-500"})]})}},86799:function(t,o,a){"use strict";a.d(o,{Z:function(){return tables}});var r=a(85893),s=a(35773),n=a(42746),i=a(67294),l=a(9615),rows_SubCategoryResultsRow=t=>{let{subCategoryResults:o}=t;return(0,r.jsxs)("tr",{children:[(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2",colSpan:1,children:o.description}),(0,r.jsx)("td",{className:"border px-4 py-2 text-right",children:(0,s.zE)(o.result)})]})},rows_CategoryResultsRow=t=>{var o;let{categoryResults:a,expandedRows:n,handleRowClick:u}=t,p=(0,l.lr)(a.description),m=null===(o=a.subCategoryResults)||void 0===o?void 0:o.sort((t,o)=>{let a=p.indexOf(t.description.trim().toLowerCase()),r=p.indexOf(o.description.trim().toLowerCase());return a-r});return(0,r.jsxs)(i.Fragment,{children:[(0,r.jsxs)("tr",{onClick:()=>u(a.id),className:"cursor-pointer",children:[(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2",colSpan:2,children:(0,r.jsxs)("div",{className:"flex gap-[1rem] items-center",children:[a.subCategoryResults.length>0?(0,r.jsx)("span",{className:"text-[1.4rem] font-[700] text-[#ad8b19]",children:n.includes(a.id)?"-":"+"}):(0,r.jsx)("span",{className:"text-[1.25rem] font-[700] text-[#ad8b19]",children:n.includes(a.id)?"▫":"□"}),a.description]})}),(0,r.jsx)("td",{className:"border px-4 py-2 text-right",children:(0,s.zE)(a.result)})]}),n.includes(a.id)&&(0,r.jsx)(r.Fragment,{children:m.map((t,o)=>(0,r.jsx)(rows_SubCategoryResultsRow,{subCategoryResults:t},t.id))})]})},rows_SubHeadingResultsRow=t=>{var o,a;let{subHeadingResults:n,expandedRows:u,handleRowClick:p}=t,m=(0,l.nE)(n.description),x=null===(o=n.categoryResults)||void 0===o?void 0:o.sort((t,o)=>{let a=m.indexOf(t.description.trim().toLowerCase()),r=m.indexOf(o.description.trim().toLowerCase());return a-r});return(0,r.jsxs)(i.Fragment,{children:[(0,r.jsxs)("tr",{onClick:()=>p(n.id),className:"cursor-pointer",children:[(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2",colSpan:3,children:(0,r.jsxs)("div",{className:"flex gap-[1rem] items-center",children:[(null===(a=n.categoryResults)||void 0===a?void 0:a.length)>0?(0,r.jsx)("span",{className:"text-[1.4rem] font-[700] text-[#ad8b19]",children:u.includes(n.id

1)?"-":"+"}):(0,r.jsx)("span",{className:"text-[1.25rem] font-[700] text-[#ad8b19]",children:u.includes(n.id)?"▫":"□"}),n.description]})}),(0,r.jsx)("td",{className:"border px-4 py-2 text-right",colSpan:1,children:(0,s.zE)(n.result)})]}),u.includes(n.id)&&(0,r.jsx)(r.Fragment,{children:x.map((t,o)=>(0,r.jsx)(rows_CategoryResultsRow,{categoryResults:t,expandedRows:u,handleRowClick:p},t.id))})]})},rows_HeadingResultsRow=t=>{var o,a;let{headingResults:n,expandedRows:u,handleRowClick:p}=t,m=null===(o=n.subHeadingResults)||void 0===o?void 0:o.sort((t,o)=>{let a=l.aK.indexOf(t.description.trim().toLowerCase()),r=l.aK.indexOf(o.description.trim().toLowerCase());return a-r});return(0,r.jsxs)(i.Fragment,{children:[(0,r.jsxs)("tr",{onClick:()=>p(n.id),className:"cursor-pointer",children:[(0,r.jsx)("td",{className:"border px-4 py-2"}),(0,r.jsx)("td",{className:"border px-4 py-2",colSpan:4,children:(0,r.jsxs)("div",{className:"flex gap-[1rem] items-center",children:[(null===(a=n.subHeadingResults)||void 0===a?void 0:a.length)>0?(0,r.jsx)("span",{className:"text-[1.4rem] font-[700] text-[#ad8b19]",children:u.includes(n.id)?"-":"+"}):(0,r.jsx)("span",{className:"text-[1.25rem] font-[700] text-[#ad8b19]",children:u.includes(n.id)?"▫":"□"}),n.description]})}),(0,r.jsx)("td",{className:"border px-4 py-2 text-right",colSpan:1,children:(0,s.zE)(n.result)})]}),u.includes(n.id)&&(0,r.jsx)(r.Fragment,{children:m.map((t,o)=>(0,r.jsx)(rows_SubHeadingResultsRow,{subHeadingResults:t,expandedRows:u,handleRowClick:p},t.id))})]})},u=a(33779),p=a(74295),m=a.n(p),x=a(93162),w=a(25675),g=a.n(w),h=a(22920),f=a(4023),v=a(30727);let getUniqueWorksheetName=(t,o)=>{let a=o,r=1;for(;t.getWorksheet(a);)a="".concat(o," (").concat(r,")"),r++;return a},getMonthKey=t=>({"01":"jan","02":"fev","03":"mar","04":"apr","05":"may","06":"jun","07":"jul","08":"aug","09":"set",10:"oct",11:"nov",12:"dez"})[t]||"";function ExcelExportMap(t){let{balances:o=!1,dataArray:a,url:u,headings:p,fileName:w,icon:b=!1,buttonName:C="",companyName:R,currentPage:y,pageSize:L,year:E,frequency:j}=t,{token:N,APIURL:A,companyID:k}=(0,f.qD)(),F=(0,i.useMemo)(()=>new v.Z(A,N),[N,A]),[S,B]=(0,i.useState)(!1),O=(0,n.useTranslations)("sideBar"),M=O(j.toLowerCase()),handleExport=async()=>{B(!0);let t=new(m()).Workbook,fetchAndAddSheet=async(o,r)=>{let n="balances"===o;try{var i;let u=await F.getById(k,"companies","balance-results/".concat(o,"/since/").concat(E,"/type/").concat(j));console.log("customOrder data",u.data.content),console.log("customOrder order",a);let p=(0,s.OI)((0,s.gB)(u.data.content,E,j),a),m=getUniqueWorksheetName(t,(0,s.q6)(r)),x=t.addWorksheet(m);x.columns=[{header:"Rubricas",key:"rubricas",width:32},{header:"Janeiro",key:"jan",width:15},{header:"Fevereiro",key:"feb",width:15},{header:"Mar\xe7o",key:"mar",width:15},{header:"Abril",key:"apr",width:15},{header:"Maio",key:"may",width:15},{header:"Junho",key:"jun",width:15},{header:"Julho",key:"jul",width:15},{header:"Agosto",key:"aug",width:15},{header:"Setembro",key:"set",width:15},{header:"Outrubro",key:"oct",width:15},{header:"Novembro",key:"nov",width:15},{header:"Dezembro",key:"dez",width:15}],function(t,o){t.spliceRows(1,0,["Empresa:","".concat(R)]),t.spliceRows(2,0,["Mapa:","".concat(M)]),t.spliceRows(3,0,["Data: ".concat(parseInt(E)),"P\xe9riodos"]),t.mergeCells("B1:M1"),t.mergeCells("B2:M2"),t.mergeCells("B3:M3"),t.getRow(1).font={size:14,bold:!0},t.getRow(1).alignment={vertical:"middle",horizontal:"center"},t.getRow(2).font={size:12,italic:!0},t.getRow(3).font={size:12,italic:!0};let a=t.getCell("B3");a.fill={type:"pattern",pattern:"solid",fgColor:{argb:"cc9900"}}}(x,p[0]),function(t,o){let a=t.getRow(4);a.eachCell(t=>{t.font={size:12,bold:!0},t.alignment={horizontal:"center",vertical:"middle"}}),t.getRow(2).font={size:14,bold:!0},t.getRow(3).font={size:14,bold:!0},t.getRow(2).alignment={vertical:"middle",horizontal:"center"},t.getRow(3).alignment={vertical:"middle",horizontal:"center"}}(x,p[0]);let w=x.lastRow?x.lastRow.number+1:1;for(let t of(null===(i=p[0].headingResults)||void 0===i||i.forEach(t=>{let o=x.addRow({rubricas:"".concat(t.description)});o.font={bold:!!n},w++;let a=(0,l.uj)(t.subHeadingResults,l.aK);null==a||a.forEach(t=>{let o=x.addRow({rubricas:"".concat(t.description)});o.font={bold:!!n},o.getCell(1).alignment={indent:1},w++;let a=(0,l.nE)(t.description),r=(0,l.uj)(t.categoryResults,a);null==r||r.forEach(t=>{let o=x.addRow({rubricas:"".concat(t.description)});o.getCell(1).alignment={indent:2},w++;let a=(0,l.lr)(t.description),r=(0,l.uj)(t.subCategoryResults,a);null==r||r.forEach(t=>{let o=x.addRow({rubricas:"".concat(t.description)});o.getCell(1).alignment={indent:4},w++})});let s=x.addRow({rubricas:"Total do/a ".concat(t.description)});s.font={bold:!0},s.getCell(1).alignment={indent:1},w++});let r=x.addRow({rubricas:"Total do/a ".concat(t.description)});r.font={bold:!0},w++}),p)){let o=t.startDate.substring(5,7),a=getMonthKey(o),r={jan:2,fev:3,mar:4,apr:5,may:6,jun:7,jul:8,aug:9,set:10,oct:11,nov:12,dez:13}[a]||1,s=5;

1t.headingResults.forEach(t=>{let o=x.getRow(s);o.getCell(r).value=n?"":parseFloat(t.result),s++;let a=(0,l.uj)(t.subHeadingResults,l.aK);null==a||a.forEach(t=>{let o=x.getRow(s);o.getCell(r).value=n?"":parseFloat(t.result),s++;let a=(0,l.nE)(t.description),i=(0,l.uj)(t.categoryResults,a);null==i||i.forEach(t=>{let o=x.getRow(s);o.getCell(r).value=parseFloat(t.result),s++;let a=(0,l.lr)(t.description),n=(0,l.uj)(t.subCategoryResults,a);null==n||n.forEach(t=>{let o=x.getRow(s);o.getCell(r).value=parseFloat(t.result),s++})});let u=x.getRow(s);u.getCell(r).value=parseFloat(t.result),s++});let i=x.getRow(s);i.getCell(r).value=parseFloat(t.result),s++})}!function(t){t.columns.forEach(t=>{let o=0;t.eachCell({includeEmpty:!0},t=>{var a;let r=t.value,s=null!==(a=null==r?void 0:r.toString().length)&&void 0!==a?a:0;s>o&&(o=s)}),t.width=o<20?20:o})}(x)}catch(t){h.Am.error("Erro ao carregar dados de ".concat(r))}};await fetchAndAddSheet("balances","Balan\xe7os"),await fetchAndAddSheet("demonstrations","Demonstra\xe7\xf5es"),await fetchAndAddSheet("others","Outros");let o=await t.xlsx.writeBuffer();B(!1);let r=new Blob([o],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});(0,x.saveAs)(r,"".concat(R," - Mapa Mensal de ").concat(parseInt(E)," do ").concat(w).replace(/\./g,"_"))};return(0,r.jsxs)("button",{title:"Extrair Mapa ".concat(M),type:"button",onClick:handleExport,className:S?"pointer-events-none button_Export bg-[#AD8B19FF]":"active:scale-95 transform ease-in-out button_Export hover:bg-[#f7e7b2]",children:[(0,r.jsx)(g(),{className:"block md:hidden",width:30,height:35,src:S?"/downloadMapBlank.png":"/downloadMapGold.png",alt:"SVG"}),(0,r.jsx)(g(),{className:"hidden md:block",width:20,height:15,src:S?"/downloadMapBlank.png":"/downloadMapGold.png",alt:"SVG"})]})}let fetchMapData=async(t,o,a,r,n)=>{let i=[];try{let l=await t.getById(a,"companies","balance-results/balances/since/".concat(r,"/type/").concat(n)),u=(0,s.gB)((0,s.OI)(l.data.content,o),r,n);i.push(u);let p=await t.getById(a,"companies","balance-results/demonstrations/since/".concat(r,"/type/").concat(n)),m=(0,s.gB)((0,s.OI)(p.data.content,o),r,n);i.push(m);let x=await t.getById(a,"companies","balance-results/others/since/".concat(r,"/type/").concat(n)),w=(0,s.gB)((0,s.OI)(x.data.content,o),r,n);return i.push(w),i}catch(t){throw h.Am.error("mapData error"),t}};function ExcelExportAnnual(t){let{balances:o=!1,dataArray:a,url:u,headings:p,fileName:w,icon:h=!1,buttonName:b="",companyName:C,currentPage:R,pageSize:y,year:L,frequency:E}=t,{token:j,APIURL:N,companyID:A}=(0,f.qD)(),k=(0,i.useMemo)(()=>new v.Z(N,j),[j,N]),[F,S]=(0,i.useState)(!1),B=(0,n.useTranslations)("sideBar"),O=B(E.toLowerCase()),handleExport=async()=>{let t;S(!0);try{let o=await fetchMapData(k,a,A,L,E);t=o}catch(t){return}let o=new(m()).Workbook,r=0;for(let a of t){var n,i,u;if(r++,!Array.isArray(a))continue;let p=B(null===(n=a[0])||void 0===n?void 0:n.typeBalanceResult.toLowerCase())||"Sheet".concat(t.indexOf(a)+1),m=o.addWorksheet(p);(function(t,o,a,r){let n=parseInt(o);console.log(o,n,"arrayOfDataMapAnual minYear"),("ANNUAL"===a||"ANNUALLY"===a)&&(t.columns=[{header:"Rubricas",key:"rubricas",width:32},{header:"".concat(Number(n)),key:"Y0",width:15},{header:"".concat(Number(n)+1),key:"Y1",width:15},{header:"".concat(Number(n)+2),key:"Y2",width:15},{header:"".concat(Number(n)+3),key:"Y3",width:15},{header:"".concat(Number(n)+4),key:"Y4",width:15},{header:"".concat(Number(n)+5),key:"Y5",width:15},{header:"".concat(Number(n)+6),key:"Y6",width:15},{header:"".concat(Number(n)+7),key:"Y7",width:15},{header:"".concat(Number(n)+8),key:"Y8",width:15},{header:"".concat(Number(n)+9),key:"Y9",width:15},{header:"".concat(Number(n)+10),key:"Y10",width:15}]),"QUARTERLY"===a&&(t.columns=[{header:"Rubricas",key:"rubricas",width:32},{header:"".concat((0,s.Ji)(r,"Q1",o,a)),key:"Q1",width:15},{header:"".concat((0,s.Ji)(r,"Q2",o,a)),key:"Q2",width:15},{header:"".concat((0,s.Ji)(r,"Q3",o,a)),key:"Q3",width:15},{header:"".concat((0,s.Ji)(r,"Q4",o,a)),key:"Q4",width:15}]),("SEMIANNUAL"===a||"SEMI_ANNUALLY"===a)&&(t.columns=[{header:"Rubricas",key:"rubricas",width:32},{header:"".concat((0,s.Ji)(r,"S1",o,a)),key:"S1",width:15},{header:"".concat((0,s.Ji)(r,"S2",o,a)),key:"S2",width:15}])})(m,L,E,a),function(t,o,a,r){t.spliceRows(1,0,["Empresa:","".concat(C)]),("ANNUAL"===r||"ANNUALLY"===r)&&(t.spliceRows(2,0,["Mapa:","".concat(O)]),t.spliceRows(3,0,["Data: ".concat(parseInt(a)," - ").concat(parseInt(a)+10),"P\xe9riodos"]),t.mergeCells("B1:L1"),t.mergeCells("B2:L2"),t.mergeCells("B3:L3")),"QUARTERLY"===r&&(t.spliceRows(2,0,["Mapa:","".concat(O)]),t.spliceRows(3,0,["Data:".concat(parseInt(a)),"P\xe9riodos"]),t.mergeCells("B1:E1"),t.mergeCells("B2:E2"),t.mergeCells("B3:E3")),("SEMIANNUAL"===r||"SEMI_ANNUALLY"===r)&&(t.spliceRows(2,0,["Mapa:","".concat(O)]),t.spliceRows(3,0,["Data:".concat(parseInt(a)),"P\xe9riodos"]),t.mergeCells("B1:C1"),t.mergeCells("B2:C2"),t.mergeCells("B3:C3")),t.getRow(1).font={size:14,bold:!0},t.getRow(1).alignment={vertical:"middle",horizontal:"center"},t.getRow(2).font={size:12,italic:!0},t.getRow(3).font={size:12,italic:!0};let s=t.getCell("B3");s.fill={type:"pattern",pattern:"solid",fgColor:{argb:"cc9900"}}}(m,a[0],L,E),function(t,o){let a=t.getRow(4);a.eachCell(t=>{t.font={size:12,bold:!0},t.alignment={horizontal:"center",vertical:"middle"}}),t.getRow(2).font={size:14,bold:!0},t.getRow(3).font={size:14,bold:!0},t.getRow(2).alignment={vertical:"middle",horizontal:"center"},t.getRow(3).alignment={vertical:"middle",horizontal:"center"}}(m,a[0]);let x=m.lastRow?m.lastRow.number+1:1;for(let t of(null==a||null===(u=a[0])||void 0===u||null===(i=u.headingResults)||void 0===i||i.forEac

1h(t=>{let o=m.addRow({rubricas:"".concat(t.description)});o.font={bold:!(r>1)},x++;let a=(0,l.uj)(t.subHeadingResults,l.aK);null==a||a.forEach(t=>{let o=m.addRow({rubricas:"".concat(t.description)});o.font={bold:!(r>1)},o.getCell(1).alignment={indent:1},x++;let a=(0,l.nE)(t.description),s=(0,l.uj)(t.categoryResults,a);null==s||s.forEach(t=>{let o=m.addRow({rubricas:"".concat(t.description)});o.getCell(1).alignment={indent:2},x++;let a=(0,l.lr)(t.description),r=(0,l.uj)(t.subCategoryResults,a);null==r||r.forEach(t=>{let o=m.addRow({rubricas:"".concat(t.description)});o.getCell(1).alignment={indent:4},x++})});let n=m.addRow({rubricas:"Total do/a ".concat(t.description)});n.font={bold:!0},n.getCell(1).alignment={indent:1},x++});let s=m.addRow({rubricas:"Total do/a ".concat(t.description)});s.font={bold:!0},x++}),a)){let o=function(t,o){let a;return("ANNUAL"===o||"ANNUALLY"===o)&&(a={Y0:2,Y1:3,Y2:4,Y3:5,Y4:6,Y5:7,Y6:8,Y7:9,Y8:10,Y9:11,Y10:12}),"QUARTERLY"===o&&(a={Q1:2,Q2:3,Q3:4,Q4:5}),("SEMIANNUAL"===o||"SEMI_ANNUALLY"===o)&&(a={S1:2,S2:3}),a[t]||1}(t.tag,E),a=5;t.headingResults.forEach(t=>{let s=m.getRow(a);s.getCell(o).value=r>1?parseFloat(t.result):"",a++;let n=(0,l.uj)(t.subHeadingResults,l.aK);null==n||n.forEach(t=>{let s=m.getRow(a);s.getCell(o).value=r>1?parseFloat(t.result):"",a++;let n=(0,l.nE)(t.description),i=(0,l.uj)(t.categoryResults,n);null==i||i.forEach(t=>{let r=m.getRow(a);r.getCell(o).value=parseFloat(t.result),a++;let s=(0,l.lr)(t.description),n=(0,l.uj)(t.subCategoryResults,s);null==n||n.forEach(t=>{let r=m.getRow(a);r.getCell(o).value=parseFloat(t.result),a++})});let u=m.getRow(a);u.getCell(o).value=parseFloat(t.result),a++});let i=m.getRow(a);i.getCell(o).value=parseFloat(t.result),a++})}!function(t){t.columns.forEach(t=>{let o=0;t.eachCell({includeEmpty:!0},t=>{var a;let r=t.value,s=null!==(a=null==r?void 0:r.toString().length)&&void 0!==a?a:0;s>o&&(o=s)}),t.width=o<10?10:o})}(m)}let p=await o.xlsx.writeBuffer();S(!1);let g=new Blob([p],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});(0,x.saveAs)(g,"".concat(C," - Mapa Financeiro ").concat(O,"_").concat(parseInt(L)," do ").concat(w," ").replace(/\./g,"_"))};return(0,r.jsxs)("button",{title:"Extrair Mapa ".concat(O),type:"button",onClick:handleExport,className:F?"pointer-events-none button_Export bg-[#AD8B19FF]":"active:scale-95 transform ease-in-out button_Export hover:bg-[#f7e7b2]",children:[(0,r.jsx)(g(),{className:"block md:hidden",width:30,height:35,src:F?"/downloadMapBlank.png":"/downloadMapGold.png",alt:"SVG"}),(0,r.jsx)(g(),{className:"hidden md:block",width:20,height:15,src:F?"/downloadMapBlank.png":"/downloadMapGold.png",alt:"SVG"})]})}var tables=t=>{var o;let{balances:a=!1,balanceBalances:l,orderArray:p,type:m,companyName:x,getMapaData:w}=t,g=(0,n.useTranslations)("tables"),h=(0,n.useTranslations)("sideBar"),[f,v]=(0,i.useState)([]),handleRowClick=t=>{f.includes(t)?v(f.filter(o=>o!==t)):v([...f,t])},getFileType=t=>{switch(t){case"balances":return h("balance");case"demonstration":return h("resultReport");default:return h("others")}};return(0,r.jsxs)("table",{className:"min-w-full divide-y divide-gray-200 responsive-table",children:[(0,r.jsx)("thead",{className:"bg-gray-50",children:(0,r.jsxs)("tr",{children:[(0,r.jsx)("th",{scope:"col",colSpan:5,className:"tableHeadTW",children:g("report")}),(0,r.jsx)("th",{scope:"col",colSpan:1,className:"tableHeadTW !text-right",children:h("results")})]})}),(0,r.jsx)("tbody",{className:"bg-white divide-y divide-gray-200",children:null===(o=(0,s.OI)(l,p))||void 0===o?void 0:o.map((t,o)=>(0,r.jsxs)(i.Fragment,{children:[(0,r.jsxs)("tr",{className:"cursor-pointer",children:[(0,r.jsx)("td",{onClick:()=>handleRowClick(t.id),colSpan:5,className:"diagnostico_body_View",children:(0,r.jsxs)("div",{className:"flex gap-[1rem] items-center",children:[(0,r.jsx)("span",{className:"text-[1.4rem] font-[700] text-[#ad8b19]",children:f.includes(t.id)?"-":"+"}),"".concat((0,s.q6)(null==t?void 0:t.balanceSheetName),"  (").concat((0,s.p6)(null==t?void 0:t.startDate,!0)," a ").concat((0,s.p6)(null==t?void 0:t.endDate,!0),")")]})}),(0,r.jsx)("td",{colSpan:1,className:"diagnostico_body_View",children:(0,r.jsxs)("div",{className:"flex gap-[1rem] items-center justify-end",children:[(0,r.jsx)(u.Z,{balances:a,icon:!0,dataArray:[t],fileName:"".concat(getFileType(m)," ").concat((0,s.q6)(null==t?void 0:t.balanceSheetName),"  (").concat((0,s.p6)(null==t?void 0:t.startDate,!0)," a ").concat((0,s.p6)(null==t?void 0:t.endDate,!0),")"),companyName:x,type:m}),(null==t?void 0:t.typeFrequence)==="MONTHLY"&&(0,r.jsx)(ExcelExportMap,{balances:a,icon:!0,fileName:"".concat(getFileType(m)," ").concat((0,s.q6)(null==t?void 0:t.balanceSheetName),"  (").concat((0,s.p6)(null==t?void 0:t.startDate,!0)," a ").concat((0,s.p6)(null==t?void 0:t.endDate,!0),")"),companyName:x,year:null==t?void 0:t.startDate,frequency:null==t?void 0:t.typeFrequence,dataArray:p}),(null==t?void 0:t.typeFrequence)!="MONTHLY"&&(0,r.jsx)(ExcelExportAnnual,{balances:a,icon:!0,fileName:"".concat(getFileType(m)," ").concat((0,s.q6)(null==t?void 0:t.balanceSheetName),"  (").concat((0,s.p6)(null==t?void 0:t.startDate,!0)," a ").concat((0,s.p6)(null==t?void 0:t.endDate,!0),")"),companyName:x,year:null==t?void 0:t.startDate,frequency:null==t?void 0:t.typeFrequence,dataArray:p})]})})]}),f.includes(t.id)&&(0,r.jsx)(r.Fragment,{children:null==t?void 0:t.headingResults.map((t,o)=>(0,r.jsx)(rows_HeadingResultsRow,{headingResults:t,expandedRows:f,handleRowClick:handleRowClick},t.id))})]},t.id))})]})}},9615:function(t,o,a){"use strict";a.d(o,{FR:function(){return separateAndFilter},aK:function(){return g},g:function(){return calculateSum},kc:function(){return demonstrationCheck},lr:function(){return getSubCategoryOrder},nE:function(){return getCategoryOrder},uj:function(){return sortResults},wf:function(){return h},zy:function(){return L}});var r=a(35773);let s=["Terrenos e recursos naturais".trim().toLowerCase(),"Edif\xedcios e outras constru\xe7\xf5es".trim().toLowerCase(),"Equipamento b\xe1sico".trim().toLowerCase(),"Equipamento de transporte".trim().toLowerCase(),"Equipamento administrativo".trim().toLowerCase(),"Equipamentos biol\xf3gicos".trim().toLowerCase(),"Equipamento biol\xf3gicos".trim().toLowerCase(),"Outros activos fixos tang\xedveis".trim().toLowerCase()],n=["Terrenos e recursos naturais".trim().toLowerCase(),"Edif\xedcios e outras constru\xe7\xf5es".trim().toLowerCase(),"Outras propriedades de investimentos".trim().toLowerCase()],i=["Trespasse 

1(goodwill)".trim().toLowerCase(),"Projectos de desenvolvimento".trim().toLowerCase(),"Programas de computador".trim().toLowerCase(),"Propriedade industrial".trim().toLowerCase(),"Outros activos intang\xedveis".trim().toLowerCase()],l=["Ativos biol\xf3gicos".trim().toLowerCase(),"Activos biol\xf3gicos".trim().toLowerCase(),"Mercadorias".trim().toLowerCase(),"Produtas acabados e interm\xe9dios".trim().toLowerCase(),"Produtos acabados e interm\xe9dios".trim().toLowerCase(),"Subprodutos, desperd\xedcios, res\xedduos e refugos".trim().toLowerCase(),"Produtos e trabalhos em curso".trim().toLowerCase(),"Mat\xe9rias-primas, subsidi\xe1rias e de consumo".trim().toLowerCase(),"Outros produtos de consumo".trim().toLowerCase()],u=["Activo fixos tang\xedveis".trim().toLowerCase(),"Ativos fixos tang\xedveis".trim().toLowerCase(),"Propriedades de investimento".trim().toLowerCase(),"Activos intang\xedveis".trim().toLowerCase(),"Participa\xe7\xf5es financeiras - m\xe9todo da equival\xeancia patrimonial".trim().toLowerCase(),"Participa\xe7\xf5es financeiras - outros m\xe9todos".trim().toLowerCase(),"Acionistas/s\xf3cios".trim().toLowerCase(),"Outros activos financeiros".trim().toLowerCase(),"Activos por impostos diferidos".trim().toLowerCase(),"Activos n\xe3o correntes detidos para venda".trim().toLowerCase()],p=["Invent\xe1rios".trim().toLowerCase(),"Clientes".trim().toLowerCase(),"Adiantamentos a fornecedores".trim().toLowerCase(),"Estado e outros entes p\xfablicos".trim().toLowerCase(),"Accionistas/s\xf3cios".trim().toLowerCase(),"Outras contas a receber".trim().toLowerCase(),"Diferimentos".trim().toLowerCase(),"Activos financeiros detidos para negocia\xe7\xe3o".trim().toLowerCase(),"Outros activos financeiros".trim().toLowerCase(),"Caixa e dep\xf3sitos banc\xe1rios".trim().toLowerCase()],m=["Capital realizado".trim().toLowerCase(),"Ac\xe7\xf5es (quotas) pr\xf3prias".trim().toLowerCase(),"Presta\xe7\xf5es suplementares e outros instrumentos de capital pr\xf3prio".trim().toLowerCase(),"Pr\xe9mios de emiss\xe3o".trim().toLowerCase(),"Reservas legais".trim().toLowerCase(),"Outras reservas".trim().toLowerCase(),"Excedentes de revaloriza\xe7\xe3o".trim().toLowerCase(),"Ajustamentos em activos financeiros".trim().toLowerCase(),"Outras varia\xe7\xf5es no capital pr\xf3prio".trim().toLowerCase(),"Resultados transitados".trim().toLowerCase(),"Resultado l\xedquido do per\xedodo".trim().toLowerCase(),"Interesses que n\xe3o controlam".trim().toLowerCase()],x=["Provis\xf5es".trim().toLowerCase(),"Financiamentos obtidos n\xe3o correntes".trim().toLowerCase(),"Responsabilidades por benef\xedcios p\xf3s-emprego".trim().toLowerCase(),"Passivos por impostos diferidos".trim().toLowerCase(),"Outras contas a pagar".trim().toLowerCase()],w=["Fornecedores".trim().toLowerCase(),"Adiantamentos de clientes".trim().toLowerCase(),"Estado e outros entes p\xfablicos".trim().toLowerCase(),"Accionistas/s\xf3cios".trim().toLowerCase(),"Financiamentos obtidos correntes".trim().toLowerCase(),"Outras contas a pagar".trim().toLowerCase(),"Passivos financeiros detidos para a negocia\xe7\xe3o".trim().toLowerCase(),"Passivos financeiros detidos para negocia\xe7\xe3o".trim().toLowerCase(),"Outros passivos financeiros".trim().toLowerCase(),"Diferimentos".trim().toLowerCase()],g=["Ativo n\xe3o corrente".trim().toLowerCase(),"Ativo corrente".trim().toLowerCase(),"Capital pr\xf3prio".trim().toLowerCase(),"Passivo n\xe3o corrente".trim().toLowerCase(),"Passivo corrente".trim().toLowerCase()],h=["Ativo".trim().toLowerCase(),"Capital pr\xf3prio".trim().toLowerCase(),"Passivo".trim().toLowerCase(),"Vendas e servi\xe7os prestados".trim().toLowerCase(),"Subs\xeddios \xe0 explora\xe7\xe3o".trim().toLowerCase(),"Ganhos/perdas imputados de subsidi\xe1rias, associadas e empreendimentos conjuntos".trim().toLowerCase(),"Varia\xe7\xe3o nos invent\xe1rios de produ\xe7\xe3o".trim().toLowerCase(),"Trabalhos para a pr\xf3pria entidade ".trim().toLowerCase(),"Gasto com mercadorias vendidas e das mat\xe9rias consumidas".trim().toLowerCase(),"Resultado operacional bruto".trim().toLowerCase(),"Fornecimentos e servi\xe7os externos".trim().toLowerCase(),"Valor acrescentado bruto".trim().toLowerCase(),"Gastos com o pessoal".trim().toLowerCase(),"Imparidade de invent\xe1rios (perdas/revers\xf5es)".trim().toLowerCase(),"Imparidade de d\xedvidas a receber (perdas/revers\xf5es)".trim().toLowerCase(),"Provis\xf5es (aumentos/redu\xe7\xf5es)".trim().toLowerCase(),"Imparidade de investimentos n\xe3o depreci\xe1veis/amortiz\xe1veis (perdas/revers\xf5es)".trim().toLowerCase(),"Aumentos/redu\xe7\xf5es de justo valor".trim().toLowerCase(),"Outros rendimentos e ganhos".trim().toLowerCase(),"Outros gastos e perdas".trim().toLowerCase(),"Resultado antes de deprecia\xe7\xf5es, perdas/ganhos de financiamento e impostos".trim().toLowerCase(),"Gastos/Revers\xf5es de deprecia\xe7\xe3o e de amortiza\xe7\xe3o ".trim().toLowerCase(),"Perdas/revers\xf5es por Imparidade de investimentos depreci\xe1veis/amortiz\xe1veis".trim().toLowerCase(),"Resultado operacional (antes de perdas/ganhos de financiamento e impostos)".trim().toLowerCase(),"Juros e rendimentos similares obtidos".trim().toLowerCase(),"Juros e gastos similares suportados".trim().toLowerCase(),"Resultado antes de impostos".trim().toLowerCase(),"Imposto sobre o rendimento do per\xedodo".trim().toLowerCase(),"Resultado l\xedquido do per\xedodo".trim().toLowerCase()],getCategoryOrder=t=>{let o=t.trim().toLowerCase();return o==="Ativo n\xe3o corrente".trim().toLowerCase()?u:o==="Ativo Corrente".trim().toLowerCase()?p:o==="Capital pr\xf3prio".trim().toLowerCase()?m:o==="Passivo n\xe3o corrente".trim().toLowerCase()?x:o==="Passivo corrente".trim().toLowerCase()?w:u},getSubCategoryOrder=t=>{let o=t.trim().toLowerCase();return o==="Activo fixos tang\xedveis".trim().toLowerCase()?s:o==="Propriedades de investimento".trim().toLowerCase()?n:o==="Activos intang\xedveis".trim().toLowerCase()?i:o==="Invent\xe1rios".trim().toLowerCase()?l:s},sortResults=(t,o)=>{if(t)return t.sort((t,a)=>{let r=o.indexOf(t.description.trim().toLowerCase()),s=o.indexOf(a.description.trim().toLowerCase());return -1===r?1:-1===s?-1:r-s})};function calculateSum(t,o){var a;let s=0;for(let n=0;n<(null===(a=t[o])||void 0===a?void 0:a.length);n++)s+=(0,r.Ex)(t[o][n].result);return String(s)}let updateResultObject=(t,o)=>{let a={...t};return a.result=o,a.inputError="",a},demonstrationCheck=(t,o)=>{let updatingResult=(a,s)=>{let n=0,i=o.findIndex(t=>t.description===s);for(let o of t)a.includes(o.description)&&(n+=(0,r.Ex)(o.result)||0);if(-1!==i){o[i]=updateResultObject(o[i],(0,r.zE)(n));let t=document.getElementById("heading ".concat(o[i].id));null!==t&&(t.value=(0,r.zE)(n))}};

1updatingResult(f,"Resultado operacional bruto"),updatingResult(v,"Valor acrescentado bruto"),updatingResult(b,"Resultado antes de deprecia\xe7\xf5es, perdas/ganhos de financiamento e impostos"),updatingResult(C,"Resultado operacional (antes de perdas/ganhos de financiamento e impostos)"),updatingResult(R,"Resultado antes de impostos"),updatingResult(y,"Resultado l\xedquido do per\xedodo")},separateAndFilter=(t,o)=>{let a=t.reduce((t,o)=>{let a=o.typeBalanceResult||"Unknown";return t[a]=t[a]||[],t[a].push(o),t},{}),r=o&&a[o]||[],s=r.sort((t,o)=>{let a=h.indexOf(t.description.trim().toLowerCase()),r=h.indexOf(o.description.trim().toLowerCase());return a-r});return s},f=["Vendas e servi\xe7os prestados","Subs\xeddios \xe0 explora\xe7\xe3o","Ganhos/perdas imputados de subsidi\xe1rias, associadas e empreendimentos conjuntos","Varia\xe7\xe3o nos invent\xe1rios de produ\xe7\xe3o","Trabalhos para a pr\xf3pria entidade ","Gasto com mercadorias vendidas e das mat\xe9rias consumidas"],v=[...f,"Fornecimentos e servi\xe7os externos"],b=[...v,"Gastos com o pessoal","Imparidade de invent\xe1rios (perdas/revers\xf5es)","Imparidade de d\xedvidas a receber (perdas/revers\xf5es)","Provis\xf5es (aumentos/redu\xe7\xf5es)","Imparidade de investimentos n\xe3o depreci\xe1veis/amortiz\xe1veis (perdas/revers\xf5es)","Aumentos/redu\xe7\xf5es de justo valor","Outros rendimentos e ganhos","Outros gastos e perdas"],C=[...b,"Gastos/Revers\xf5es de deprecia\xe7\xe3o e de amortiza\xe7\xe3o ","Perdas/revers\xf5es por Imparidade de investimentos depreci\xe1veis/amortiz\xe1veis"],R=[...C,"Juros e rendimentos similares obtidos","Juros e gastos similares suportados"],y=[...R,"Imposto sobre o rendimento do per\xedodo"],L=["Resultado operacional bruto","Valor acrescentado bruto","Resultado antes de deprecia\xe7\xf5es, perdas/ganhos de financiamento e impostos","Resultado operacional (antes de perdas/ganhos de financiamento e impostos)","Resultado antes de impostos","Resultado l\xedquido do per\xedodo"]}}]);