https://osys-kembarasufi.vercel.app/_next/static/chunks/1174.d9956d904a90d89a.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[1174,8436],{11186:(e,a,t)=>{"use strict";t.d(a,{bq:()=>h,eb:()=>p,gC:()=>u,l6:()=>c,yv:()=>d});var s=t(95155);t(12115);var n=t(55644),l=t(24033),o=t(5917),i=t(12108),r=t(64269);function c(e){let{...a}=e;return(0,s.jsx)(n.bL,{"data-slot":"select",...a})}function d(e){let{...a}=e;return(0,s.jsx)(n.WT,{"data-slot":"select-value",...a})}function h(e){let{className:a,size:t="default",children:o,...i}=e;return(0,s.jsxs)(n.l9,{"data-slot":"select-trigger","data-size":t,className:(0,r.cn)("border-input data-[placeholder]:text-muted-foreground [&_svg:not([class*='text-'])]:text-muted-foreground focus-visible:border-ring focus-visible:ring-ring/50 aria-invalid:ring-destructive/20 dark:aria-invalid:ring-destructive/40 aria-invalid:border-destructive dark:bg-input/30 dark:hover:bg-input/50 flex w-fit items-center justify-between gap-2 rounded-md border bg-transparent px-3 py-2 text-sm whitespace-nowrap shadow-xs transition-[color,box-shadow] outline-none focus-visible:ring-[3px] disabled:cursor-not-allowed disabled:opacity-50 data-[size=default]:h-9 data-[size=sm]:h-8 *:data-[slot=select-value]:line-clamp-1 *:data-[slot=select-value]:flex *:data-[slot=select-value]:items-center *:data-[slot=select-value]:gap-2 [&_svg]:pointer-events-none [&_svg]:shrink-0 [&_svg:not([class*='size-'])]:size-4",a),...i,children:[o,(0,s.jsx)(n.In,{asChild:!0,children:(0,s.jsx)(l.A,{className:"size-4 opacity-50"})})]})}function u(e){let{className:a,children:t,position:l="popper",...o}=e;return(0,s.jsx)(n.ZL,{children:(0,s.jsxs)(n.UC,{"data-slot":"select-content",className:(0,r.cn)("bg-popover text-popover-foreground data-[state=open]:animate-in data-[state=closed]:animate-out data-[state=closed]:fade-out-0 data-[state=open]:fade-in-0 data-[state=closed]:zoom-out-95 data-[state=open]:zoom-in-95 data-[side=bottom]:slide-in-from-top-2 data-[side=left]:slide-in-from-right-2 data-[side=right]:slide-in-from-left-2 data-[side=top]:slide-in-from-bottom-2 relative z-50 max-h-(--radix-select-content-available-height) min-w-[8rem] origin-(--radix-select-content-transform-origin) overflow-x-hidden overflow-y-auto rounded-md border shadow-md","popper"===l&&"data-[side=bottom]:translate-y-1 data-[side=left]:-translate-x-1 data-[side=right]:translate-x-1 data-[side=top]:-translate-y-1",a),position:l,...o,children:[(0,s.jsx)(m,{}),(0,s.jsx)(n.LM,{className:(0,r.cn)("p-1","popper"===l&&"h-[var(--radix-select-trigger-height)] w-full min-w-[var(--radix-select-trigger-width)] scroll-my-1"),children:t}),(0,s.jsx)(g,{})]})})}function p(e){let{className:a,children:t,...l}=e;return(0,s.jsxs)(n.q7,{"data-slot":"select-item",className:(0,r.cn)("focus:bg-accent focus:text-accent-foreground [&_svg:not([class*='text-'])]:text-muted-foreground relative flex w-full cursor-default items-center gap-2 rounded-sm py-1.5 pr-8 pl-2 text-sm outline-hidden select-none data-[disabled]:pointer-events-none data-[disabled]:opacity-50 [&_svg]:pointer-events-none [&_svg]:shrink-0 [&_svg:not([class*='size-'])]:size-4 *:[span]:last:flex *:[span]:last:items-center *:[span]:last:gap-2",a),...l,children:[(0,s.jsx)("span",{className:"absolute right-2 flex size-3.5 items-center justify-center",children:(0,s.jsx)(n.VF,{children:(0,s.jsx)(o.A,{className:"size-4"})})}),(0,s.jsx)(n.p4,{children:t})]})}function m(e){let{className:a,...t}=e;return(0,s.jsx)(n.PP,{"data-slot":"select-scroll-up-button",className:(0,r.cn)("flex cursor-default items-center justify-center py-1",a),...t,children:(0,s.jsx)(i.A,{className:"size-4"})})}function g(e){let{className:a,...t}=e;return(0,s.jsx)(n.wn,{"data-slot":"select-scroll-down-button",className:(0,r.cn)("flex cursor-default items-center justify-center py-1",a),...t,children:(0,s.jsx)(l.A,{className:"size-4"})})}},32383:()=>{},60496:(e,a,t)=>{"use strict";t.d(a,{$K:()=>m,bJ:()=>n,q7:()=>f});var s=t(4246);function n(e){let{filename:a,sheetName:t="Data",columns:n,data:l}=e,o=n.map(e=>e.header),i=l.map(e=>n.map(a=>{let t=e[a.key];return null==t?"":t})),r=s.utils.aoa_to_sheet([o,...i]),c=n.map(e=>({wch:e.width||Math.max(e.header.length,15)}));r["!cols"]=c;let d=s.utils.book_new();

1s.utils.book_append_sheet(d,r,t),s.writeFile(d,"".concat(a,".xlsx"))}let l=e=>null!=e&&isFinite(e)?e:0,o=e=>Math.round(100*l(e))/100;function i(e,a,t){let n=[["Metrik","Nilai"],["Total Spend (RM)",o(e.totalSpending)],["Total Leads",l(e.totalLeads)],["CPL (RM)",o(e.cpl)],["Total Pax",l(e.totalPax)],["Cost Per Pax (RM)",o(e.costPerPax)],["Total Revenue (RM) (Anggaran)",o(e.totalRevenue)],["ROAS (Anggaran)",o(e.roas)],["Closing Rate (%)",o(e.closingRate)],[],["Tempoh",a&&t?"".concat(a," hingga ").concat(t):"Semua"],["Nota","Revenue dan ROAS adalah anggaran."]],i=s.utils.aoa_to_sheet(n);return i["!cols"]=[{wch:30},{wch:25}],{sheet:i,name:"Overview"}}function r(e){let a=e.length>0?e.map(e=>[e.platform,o(e.spend),l(e.leads),o(e.cpl)]):[["Tiada data","","",""]],t=s.utils.aoa_to_sheet([["Platform","Spend (RM)","Leads","CPL (RM)"],...a]);return t["!cols"]=[{wch:20},{wch:15},{wch:10},{wch:15}],{sheet:t,name:"By Platform"}}function c(e){let a=e.length>0?e.map(e=>[e.campaign||"-",e.platform||"-",o(e.spend),e.isMultiPackage?"Multi-Pakej":"Langsung","db"===e.mappingSource?"DB":"auto"===e.mappingSource?"Auto":"-","leads"===e.allocationMethod?"Ikut Lead":"equal"===e.allocationMethod?"Sama Rata":"-",(e.targetPackages||[]).join(", ")||"-"]):[["Tiada data","","","","","",""]],t=s.utils.aoa_to_sheet([["Nama Kempen","Platform","Spend (RM)","Jenis","Sumber","Kaedah Agihan","Pakej Sasaran"],...a]);return t["!cols"]=[{wch:40},{wch:15},{wch:15},{wch:12},{wch:8},{wch:15},{wch:50}],{sheet:t,name:"By Campaign"}}function d(e){let a=e.length>0?e.map(e=>[e.name||"-",o(e.directSpend||0),o(e.allocatedSpend||0),o(e.spending),l(e.leads),l(e.pax),o(e.revenue),o(e.cpl),o(e.costPerPax),o(e.roas||0),e.topCloser||"-"]):[["Tiada data","","","","","","","","","",""]],t=s.utils.aoa_to_sheet([["Nama Pakej","Spend Langsung (RM)","Spend Agihan (RM)","Jumlah Spend (RM)","Leads","Pax","Revenue (RM)","CPL (RM)","Cost/Pax (RM)","ROAS","Top Closer"],...a]);return t["!cols"]=[{wch:30},{wch:16},{wch:16},{wch:16},{wch:8},{wch:8},{wch:15},{wch:12},{wch:12},{wch:8},{wch:20}],{sheet:t,name:"By Package"}}function h(e){let a=e.length>0?e.map(e=>[e.staffName||"-",l(e.leads),l(e.receipts),l(e.pax),o(e.revenue),o(e.closingRate)]):[["Tiada data","","","","",""]],t=s.utils.aoa_to_sheet([["Nama Staff","Leads","Resit","Pax","Revenue (RM)","Closing Rate (%)"],...a]);return t["!cols"]=[{wch:20},{wch:10},{wch:10},{wch:8},{wch:15},{wch:15}],{sheet:t,name:"By Staff"}}function u(e){let a=e.length>0?e.map(e=>{var a;return[e.date||"-",e.platform||"-",e.campaign_name||"-",e.nama_pakej||"-",o(e.amount),(null==(a=e.staff)?void 0:a.name)||"-"]}):[["Tiada data","","","","",""]],t=s.utils.aoa_to_sheet([["Tarikh","Platform","Nama Kempen","Nama Pakej","Jumlah (RM)","Direkod Oleh"],...a]);return t["!cols"]=[{wch:12},{wch:15},{wch:35},{wch:25},{wch:15},{wch:18}],{sheet:t,name:"Raw Data"}}function p(e,a){return e&&a?"-".concat(e,"-to-").concat(a):""}function m(e){let{overview:a,byPlatform:t,byCampaign:n,byPackage:m,byStaff:g,rawData:f,unmappedPackages:w,unknownLeadSources:x,dateFrom:k,dateTo:v}=e,b=s.utils.book_new(),_=[i(a,k,v),r(t),c(n),d(m),h(g),u(f)],P=function(e){let a=e.filter(e=>e.isMultiPackage&&e.allocatedPackages&&e.allocatedPackages.length>0);if(0===a.length)return null;let t=[["Kempen","Platform","Jumlah Spend (RM)","Kaedah","Pakej Sasaran","Leads","Agihan (RM)","CPL (RM)"]];for(let e of a)for(let a of e.allocatedPackages||[])t.push([e.campaign,e.platform,o(e.spend),"leads"===e.allocationMethod?"Ikut Lead":"Sama Rata",a.packageName,l(a.leads),o(a.allocatedSpend),o(a.cpl)]);t.push([]),t.push(["Nota: Agihan adalah anggaran berdasarkan lead dalam tempoh laporan.","","","","","","",""]);let n=s.utils.aoa_to_sheet(t);return n["!cols"]=[{wch:35},{wch:15},{wch:15},{wch:12},{wch:30},{wch:8},{wch:15},{wch:12}],{sheet:n,name:"Agihan Kempen"}}(n);for(let e of(P&&_.push(P),(w&&w.length>0||x&&x.length>0)&&_.push(function(e,a){let t=[["--- Pakej/Kempen Tidak Dipetakan ---","","","","","",""],["Nama Asal","Sumber","Rekod","Spend (RM)","Leads","Pax","Cadangan"]];e&&e.length>0?e.forEach(e=>t.push([e.rawName||"-","marketing_spending"===e.source?"Spending":"lead_reports"===e.source?"Leads":"Sales",e.count,o(e.totalSpend),l(e.totalLeads),l(e.totalPax),e.suggestedMatch||"-"])):t.push(["Tiada item tidak dipetakan","","","","","",""]),t.push([]),t.push(["--- Sumber Lead Tidak Dikenali ---","","","","","",""]),t.push(["Sumber Asal","Bilangan Leads","","","","",""]),a&&a.length>

10?a.forEach(e=>t.push([e.rawLeadSource,e.count,"","","","",""])):t.push(["Tiada sumber tidak dikenali","","","","","",""]);let n=s.utils.aoa_to_sheet(t);return n["!cols"]=[{wch:30},{wch:15},{wch:10},{wch:15},{wch:10},{wch:8},{wch:20}],{sheet:n,name:"Unmapped"}}(w,x)),_))s.utils.book_append_sheet(b,e.sheet,e.name);s.writeFile(b,"marketing-report".concat(p(k,v),".xlsx"))}let g={overview:"overview",platform:"platform",campaign:"campaign",package:"package",staff:"staff",raw:"raw-data"};function f(e,a){let t,{overview:n,byPlatform:l,byCampaign:o,byPackage:m,byStaff:f,rawData:w,dateFrom:x,dateTo:k}=e,v=s.utils.book_new();switch(a){case"overview":t=i(n,x,k);break;case"platform":t=r(l);break;case"campaign":t=c(o);break;case"package":t=d(m);break;case"staff":t=h(f);break;case"raw":t=u(w)}s.utils.book_append_sheet(v,t.sheet,t.name),s.writeFile(v,"marketing-report-".concat(g[a]).concat(p(x,k),".xlsx"))}},83686:()=>{}}]);