https://erp.dianxiaobao.net/assets/chunk/fa7d2bb6.BDvO2edl.js

1import{n as e}from"./61b66786.8BhlS34s.js";import{Yf as t,ap as n,tp as r}from"./027ffcfc.eLkoaQ3Q.js";import{J as i,f as a,u as o,y as s}from"./ce65bdc9.BVjkH_eL.js";import*as c from"https://js-c.etc4.com/dxb/js/xlsx.Db5Fj5do.js";async function l(e=[],n=[],{cellMinWidth:r=120,sheetName:i=`sheet 1`,tableName:l=``,ptName:u=`${window.app.name}-`,downLoad:d=!0}={}){let f=[e.map(e=>e.title)],p=n.map((t,n)=>{let r=[];return e.forEach((e,i)=>{let s=e.key;switch(o(s)){case`String`:r.push(t[s]);break;case`Function`:r.push(s(a({item:t,header:e,itemIndex:n,headerIndex:i})))}}),r});f.push(...p);let m=c.utils.aoa_to_sheet(f);m[`!cols`]=e.map(e=>({wpx:Number(e.width)||r}));let h=c.utils.book_new();c.utils.book_append_sheet(h,m,i);let g=`${u+t()+(l||` `)+s(Date.now(),`YYYY-MM-DD`)}.xlsx`;return d?(c.writeFile(h,g),Promise.resolve()):Promise.resolve(c.write(h,{bookType:`xlsx`,type:`binary`}))}function u(e){return new Promise((t,n)=>{let r=e[0],i=[`xlsx`,`xls`],a=r.name.split(`.`);if(!i.find(e=>e===a[a.length-1])){n(`文件类型错误，请选择excel文件！`);return}let o=new FileReader;o.readAsBinaryString(r),o.onload=e=>{let n=c.read(e.target.result,{type:`binary`,cellDates:!0}),r=n.SheetNames,i={};r.forEach((e,t)=>{let r=n.Sheets[e],a=c.utils.sheet_to_json(r),o=[];for(let e in r)e.match(/[A-Z]+1/i)&&o.push(r[e].v);i[t]={index:t,sheetName:e,data:a,head:o}}),t(i)},o.onerror=n})}async function d(e=[],n=[],r=[],{cellMinWidth:i=120,sheetName:l=`sheet 1`,tableName:u=``,ptName:d=`${window.app.name}-`,downLoad:f=!0}={}){let p=[e.map(e=>e.title)],m=n.map((t,n)=>{let r=[];return e.forEach((e,i)=>{let s=e.key;switch(o(s)){case`String`:r.push(t[s]);break;case`Function`:r.push(s(a({item:t,header:e,itemIndex:n,headerIndex:i})))}}),r});p.push(...m);let h=c.utils.aoa_to_sheet(p);h[`!cols`]=e.map(e=>({wpx:Number(e.width)||i})),h[`!merges`]=r;let g=c.utils.book_new();c.utils.book_append_sheet(g,h,l);let _=`${d+t()+(u||` `)+s(Date.now(),`YYYY-MM-DD`)}.xlsx`;return f?(c.writeFile(g,_),Promise.resolve()):Promise.resolve(c.write(g,{bookType:`xlsx`,type:`binary`}))}async function f(e,t=[],n=[],r=[],i=[],{downLoad:a=!0}={}){let o=c.utils.book_new(),s=c.utils.aoa_to_sheet(t);c.utils.book_append_sheet(o,s,`sheet-1`),s[`!merges`]=[{s:{r:0,c:0},e:{r:1,c:0}},{s:{r:0,c:1},e:{r:0,c:e}}],s.B1.v=`国家`,s.A1.v=`渠道`,s[`!cols`]=[{wpx:200},...i.map(e=>({wpx:120}))];let l=c.utils.aoa_to_sheet(n);return c.utils.book_append_sheet(o,l,`sheet-2`),l[`!cols`]=[...r.map(()=>({wpx:120}))],a?(c.writeFile(o,`${window.app.name}-利润定价器数据.xlsx`),Promise.resolve()):Promise.resolve(c.write(o,{bookType:`xlsx`,type:`binary`}))}function p(){return(p=e((()=>{r(),i(),n()})))()}export{p as a,u as i,f as n,d as r,l as t};