Dashboard Canvassing Tracker \u2014 Pandai Gadai<\/title>\r\n<link rel=\"preconnect\" href=\"https:\/\/fonts.googleapis.com\">\r\n<link rel=\"preconnect\" href=\"https:\/\/fonts.gstatic.com\" crossorigin>\r\n<link rel=\"stylesheet\" href=\"https:\/\/fonts.googleapis.com\/css2?family=Rubik:wght@400;500;600;700;800;900&display=swap\">\r\n<style>\r\n#pg-page *, #pg-page *::before, #pg-page *::after{box-sizing:border-box;margin:0;padding:0}\r\nhtml,body{margin:0;padding:0;background:#f0f2f8}\r\n#pg-page{\r\n --radius:0.625rem;--background:#ffffff;--foreground:#021431;--card:#ffffff;\r\n --primary:#02439F;--primary-deep:#011455;--primary-bright:#0255CA;--primary-foreground:#f8fafc;\r\n --accent:#ffcd05;--accent-foreground:#021431;--secondary:#f3f5fb;--muted:#f0f2f8;\r\n --muted-foreground:#6b7280;--destructive:#dc2626;--success:#047857;--border:#e2e6f0;\r\n --footer-bg:#02439f;--shadow-card:0 2px 8px -2px rgba(2,20,49,0.08);\r\n --gradient-hero:linear-gradient(135deg,#011455,#0255CA);\r\n}\r\n#pg-page{font-family:\"Rubik\",system-ui,-apple-system,\"Segoe UI\",sans-serif;background:var(--muted);color:var(--foreground);line-height:1.6;-webkit-font-smoothing:antialiased}\r\n#pg-page h1,#pg-page h2,#pg-page h3,#pg-page h4{letter-spacing:-0.02em}\r\n#pg-page p{margin:0}#pg-page a{text-decoration:none;color:inherit}#pg-page img{display:block;max-width:100%}\r\n#pg-page ul{list-style:none}\r\n#pg-page .site-header{position:sticky;top:0;z-index:100;background:var(--background);border-bottom:1px solid var(--border)}\r\n#pg-page .header-inner{max-width:78rem;margin:0 auto;display:flex;height:5rem;align-items:center;justify-content:space-between;padding:0 1rem}\r\n#pg-page .btn-header{display:inline-flex;align-items:center;gap:.375rem;border-radius:calc(var(--radius) - 2px);background:var(--accent);padding:.5rem .875rem;font-size:.875rem;font-weight:700;color:var(--accent-foreground);box-shadow:0 1px 2px rgba(0,0,0,.05)}\r\n#pg-page .dash-hero{background:var(--gradient-hero);color:var(--primary-foreground);position:relative;overflow:hidden}\r\n#pg-page .dash-hero-overlay{position:absolute;inset:0;opacity:.3;background:radial-gradient(ellipse at top right,rgba(255,205,5,.35),transparent 60%);pointer-events:none}\r\n#pg-page .dash-hero-inner{position:relative;max-width:78rem;margin:0 auto;padding:2rem 1rem 2.25rem}\r\n#pg-page .dash-hero .eyebrow{display:inline-flex;align-items:center;gap:.4rem;font-size:.7rem;font-weight:800;text-transform:uppercase;letter-spacing:.08em;background:rgba(255,255,255,.15);padding:.3rem .7rem;border-radius:999px}\r\n#pg-page .dash-hero h1{font-size:1.6rem;font-weight:800;margin:.7rem 0 .25rem}\r\n#pg-page .dash-hero p{font-size:.9rem;color:rgba(255,255,255,.85)}\r\n@media(min-width:768px){#pg-page .dash-hero h1{font-size:2rem}}\r\n#pg-page .dash-body{max-width:78rem;margin:0 auto;padding:1.25rem 1rem 2.5rem}\r\n#pg-page .controls{display:flex;flex-wrap:wrap;gap:.6rem;align-items:center;background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:.75rem .9rem;box-shadow:var(--shadow-card);margin-bottom:1rem}\r\n#pg-page .ctl-label{font-size:.72rem;font-weight:700;text-transform:uppercase;letter-spacing:.05em;color:var(--muted-foreground)}\r\n#pg-page select,#pg-page input[type=text],#pg-page input[type=number]{font-family:inherit;padding:.42rem .55rem;border:1px solid var(--border);border-radius:calc(var(--radius) - 2px);font-size:.8125rem;color:var(--foreground);background:var(--card);outline:none}\r\n#pg-page input[type=text]{flex:1;min-width:180px}\r\n#pg-page input:focus,#pg-page select:focus{border-color:var(--primary)}\r\n#pg-page .btn-accent{display:inline-flex;align-items:center;gap:.4rem;border-radius:calc(var(--radius) - 2px);background:var(--accent);padding:.5rem 1.1rem;font-family:inherit;font-size:.8125rem;font-weight:700;color:var(--accent-foreground);border:none;cursor:pointer;box-shadow:0 1px 2px rgba(0,0,0,.05)}\r\n#pg-page .tabs{display:flex;gap:.2rem;border-bottom:2px solid var(--border);margin:.25rem 0 1.15rem;overflow-x:auto}\r\n#pg-page .tabs button{border:none;background:none;font-family:inherit;font-size:.9rem;font-weight:700;color:var(--muted-foreground);padding:.6rem .95rem;cursor:pointer;border-bottom:3px solid transparent;margin-bottom:-2px;white-space:nowrap}\r\n#pg-page .tabs button:hover{color:var(--foreground)}\r\n#pg-page .tabs button.active{color:var(--primary);border-bottom-color:var(--primary)}\r\n#pg-page .status{font-size:.82rem;padding:.6rem .8rem;border-radius:calc(var(--radius) - 2px);margin-bottom:1rem;line-height:1.5}\r\n#pg-page .status.info{background:var(--secondary);color:var(--primary-deep);border:1px solid var(--border)}\r\n#pg-page .status.ok{background:#ecfdf5;color:var(--success);border:1px solid #a7f3d0}\r\n#pg-page .status.err{background:#fef2f2;color:var(--destructive);border:1px solid #fca5a5}\r\n#pg-page .scorecards{display:grid;grid-template-columns:repeat(5,1fr);gap:.75rem;margin-bottom:1.25rem}\r\n#pg-page .sc{background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:.9rem 1rem;box-shadow:var(--shadow-card);border-top:3px solid var(--primary)}\r\n#pg-page .sc.accent{border-top-color:var(--accent)}#pg-page .sc.green{border-top-color:var(--success)}\r\n#pg-page .sc.amber{border-top-color:#f59e0b}#pg-page .sc.red{border-top-color:var(--destructive)}\r\n#pg-page .sc .lbl{font-size:.66rem;font-weight:800;text-transform:uppercase;letter-spacing:.05em;color:var(--muted-foreground)}\r\n#pg-page .sc .val{font-size:1.55rem;font-weight:800;color:var(--primary);line-height:1.1;margin-top:.3rem}\r\n#pg-page .sc.accent .val{color:var(--primary-deep)}#pg-page .sc.green .val{color:var(--success)}\r\n#pg-page .sc.amber .val{color:#b45309}#pg-page .sc.red .val{color:var(--destructive)}\r\n#pg-page .sc .sub{font-size:.7rem;color:var(--muted-foreground);margin-top:.2rem}\r\n@media(max-width:1000px){#pg-page .scorecards{grid-template-columns:repeat(2,1fr)}}\r\n#pg-page .panel{background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:1rem 1.15rem;box-shadow:var(--shadow-card);margin-bottom:1.25rem}\r\n#pg-page .panel-head{display:flex;align-items:center;justify-content:space-between;gap:.5rem;margin-bottom:.9rem;flex-wrap:wrap}\r\n#pg-page .panel-title{font-size:1rem;font-weight:800;color:var(--foreground)}\r\n#pg-page .panel-sub{font-size:.72rem;color:var(--muted-foreground);font-weight:600}\r\n#pg-page .tbl-wrap{overflow:auto;max-height:min(66vh,620px);border-radius:calc(var(--radius) - 2px);border:1px solid var(--border)}\r\n#pg-page table{width:100%;border-collapse:collapse;font-size:.82rem}\r\n#pg-page thead th{position:sticky;top:0;z-index:4;background:var(--secondary);color:var(--primary-deep);font-size:.68rem;text-transform:uppercase;letter-spacing:.04em;font-weight:800;padding:.6rem .65rem;text-align:right;cursor:pointer;user-select:none;white-space:nowrap;border-bottom:2px solid var(--border)}\r\n#pg-page thead th.l,#pg-page tbody td.l{text-align:left}\r\n#pg-page thead th.c,#pg-page tbody td.c{text-align:center}\r\n#pg-page thead th.sorted{color:var(--primary);background:#e8eefb}\r\n#pg-page tbody td{padding:.5rem .65rem;text-align:right;border-bottom:1px solid var(--border);white-space:nowrap;font-variant-numeric:tabular-nums}\r\n#pg-page tbody tr:hover{background:var(--secondary)}\r\n#pg-page td.branch{font-weight:700;color:var(--foreground)}\r\n#pg-page .rank{color:var(--muted-foreground);font-weight:700}\r\n#pg-page .muted{color:var(--muted-foreground)}\r\n#pg-page .stcell{font-weight:800}\r\n#pg-page .st-ok{color:var(--success)}#pg-page .st-warn{color:var(--destructive)}\r\n#pg-page table.pivot th.stick,#pg-page table.pivot td.stick{position:sticky;left:0;z-index:3;background:var(--card);text-align:left;box-shadow:1px 0 0 var(--border)}\r\n#pg-page table.pivot thead th.stick{z-index:6;background:var(--secondary)}\r\n#pg-page td.cell-red{background:#fef2f2;color:var(--destructive);font-weight:800}\r\n#pg-page td.cell-ok{color:var(--foreground);font-weight:600}\r\n#pg-page td.cell-blank{color:#c3c9d6}\r\n#pg-page td.avg-col{font-weight:800;color:var(--primary-deep);background:#f7f9fe}\r\n#pg-page th.avg-col{background:#e8eefb}\r\n#pg-page .hint{font-size:.72rem;color:var(--muted-foreground);margin-top:.5rem;line-height:1.55}\r\n#pg-page .site-footer{background:var(--footer-bg);color:#fff}\r\n#pg-page .footer-grid{display:grid;grid-template-columns:1fr;gap:2.5rem;max-width:78rem;margin:0 auto;padding:3rem 1rem}\r\n#pg-page .footer-bottom{border-top:1px solid rgba(255,255,255,.15)}\r\n#pg-page .footer-bottom-inner{display:flex;flex-direction:column-reverse;align-items:center;justify-content:space-between;gap:.75rem;max-width:78rem;margin:0 auto;padding:1.25rem 1rem;font-size:.75rem;color:rgba(255,255,255,.8)}\r\n#pg-page .social-link{display:inline-flex;height:2rem;width:2rem;align-items:center;justify-content:center;border-radius:9999px;background:rgba(255,255,255,.1);color:#fff}\r\n#pg-page .footer-nav-link{color:rgba(255,255,255,.85)}\r\n@media(min-width:640px){#pg-page .footer-bottom-inner{flex-direction:row}}\r\n@media(min-width:768px){#pg-page .footer-grid{grid-template-columns:5fr 3fr 4fr}}\r\n#pg-page .dash-hero h1,#pg-page .dash-hero p,#pg-page .dash-hero .eyebrow{color:#fff!important}\r\n#pg-page .dash-hero p{color:rgba(255,255,255,.85)!important}\r\n#pg-page .site-footer h1,#pg-page .site-footer h2,#pg-page .site-footer h3,#pg-page .site-footer h4{color:#fff!important}\r\n#pg-page .site-footer p,#pg-page .site-footer a,#pg-page .site-footer li{color:rgba(255,255,255,.85)!important}\r\n#pg-page .footer-bottom-inner,#pg-page .footer-bottom-inner span{color:rgba(255,255,255,.8)!important}\r\n<\/style>\r\n<\/head>\r\n<body>\r\n<div id=\"pg-page\">\r\n\r\n<div class=\"site-header\">\r\n <div class=\"header-inner\">\r\n <a href=\"https:\/\/pandaigadai.com\" style=\"display:flex;align-items:center\">\r\n <img decoding=\"async\" src=\"https:\/\/pandaigadai.com\/blog\/wp-content\/uploads\/2026\/01\/cropped-panda-1.webp\" alt=\"Pandai Gadai\" style=\"height:3rem;width:auto\">\r\n <\/a>\r\n <a href=\"https:\/\/pandaigadai.com\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"btn-header\">pandaigadai.com<\/a>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"dash-hero\">\r\n <div class=\"dash-hero-overlay\"><\/div>\r\n <div class=\"dash-hero-inner\">\r\n <span class=\"eyebrow\">\ud83d\udeb6 Canvassing Activity Tracker<\/span>\r\n <h1>Dashboard Canvassing Tracker<\/h1>\r\n <p>Kuantitas canvassing FL per cabang per bulan. Target minimal 15x\/bulan, di bawah itu ditandai merah.<\/p>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"dash-body\">\r\n\r\n <div id=\"status\" class=\"status info\">Memuat data\u2026<\/div>\r\n\r\n <div class=\"controls\">\r\n <button class=\"btn-accent\" onclick=\"CV.load()\">\u27f3 Muat \/ Refresh<\/button>\r\n <span class=\"ctl-label\" id=\"window-label\"><\/span>\r\n <\/div>\r\n\r\n <div class=\"controls\">\r\n <input type=\"text\" id=\"inp-search-global\" placeholder=\"Cari nama cabang\u2026\" oninput=\"CV.setSearch(this.value)\">\r\n <span class=\"ctl-label\">Area:<\/span>\r\n <select id=\"sel-area\" onchange=\"CV.setFilter('area',this.value)\"><option value=\"\">Semua Area<\/option><\/select>\r\n <span class=\"ctl-label\">AM:<\/span>\r\n <select id=\"sel-am\" onchange=\"CV.setFilter('am',this.value)\"><option value=\"\">Semua AM<\/option><\/select>\r\n <span class=\"ctl-label\">KASTER:<\/span>\r\n <select id=\"sel-kaster\" onchange=\"CV.setFilter('kaster',this.value)\"><option value=\"\">Semua KASTER<\/option><\/select>\r\n <\/div>\r\n\r\n <div class=\"tabs\" id=\"tabs\" style=\"display:none\">\r\n <button data-tab=\"ringkasan\" class=\"active\" onclick=\"CV.setTab('ringkasan')\">\ud83d\udcca Ringkasan<\/button>\r\n <button data-tab=\"am\" onclick=\"CV.setTab('am')\">\ud83d\udc64 Ringkasan AM & KASTER<\/button>\r\n <button data-tab=\"cabang\" onclick=\"CV.setTab('cabang')\">\ud83d\udccb Detail Cabang<\/button>\r\n <\/div>\r\n\r\n <section class=\"tabpane\" id=\"pane-ringkasan\" style=\"display:none\">\r\n <div class=\"scorecards\" id=\"scorecards\"><\/div>\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udd25 Heatmap Cabang × Bulan<\/div>\r\n <div class=\"panel-sub\" id=\"heat-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table class=\"pivot\" id=\"tbl-heat\"><thead><tr id=\"heat-thead\"><\/tr><\/thead><tbody id=\"heat-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Merah = di bawah target (15x\/bulan). Putih = capai target. Abu-abu titik (\u00b7) = belum ada data bulan itu. Data source (tab SUMMARY) diupdate manual, bukan real-time dari form.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <section class=\"tabpane\" id=\"pane-am\" style=\"display:none\">\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udc64 Ringkasan per Area Manager<\/div>\r\n <div class=\"panel-sub\" id=\"am-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table id=\"tbl-am\"><thead><tr id=\"am-thead\"><\/tr><\/thead><tbody id=\"am-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Diurutkan dari % di bawah target terbesar. Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udc64 Ringkasan per KASTER<\/div>\r\n <div class=\"panel-sub\" id=\"kaster-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table id=\"tbl-kaster\"><thead><tr id=\"kaster-thead\"><\/tr><\/thead><tbody id=\"kaster-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Diurutkan dari % di bawah target terbesar. Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <section class=\"tabpane\" id=\"pane-cabang\" style=\"display:none\">\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udccb Detail per Cabang<\/div>\r\n <div class=\"panel-sub\" id=\"cabang-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table class=\"pivot\" id=\"tbl-cabang\"><thead><tr id=\"cabang-thead\"><\/tr><\/thead><tbody id=\"cabang-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Kolom Rata-rata dihitung dari bulan yang ada datanya saja (bulan kosong tidak ikut dibagi). Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <div class=\"hint\" id=\"footer-note\" style=\"display:none\"><\/div>\r\n <div style=\"text-align:center;padding-top:.5rem\">\r\n <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1nO3eIJ4b-ABN1oAKmh4hKs9KtlAdwFqy_uEk9PRQuiI\/edit\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"font-size:.78rem;font-weight:700;color:var(--primary)\">\ud83d\udcc4 Buka Spreadsheet Asli (detail lengkap) \u2197<\/a>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"site-footer\">\r\n <div class=\"footer-grid\">\r\n <div>\r\n <img decoding=\"async\" src=\"https:\/\/pandaigadai.com\/blog\/wp-content\/uploads\/2026\/01\/cropped-panda-1.webp\" alt=\"Pandai Gadai\" style=\"height:3.5rem;width:auto\">\r\n <p style=\"margin-top:1.25rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">Berizin dan Diawasi Otoritas Jasa Keuangan<\/p>\r\n <p style=\"margin-top:.5rem;font-size:.875rem;font-weight:600\">Nomor Izin: KEP-180\/PL.02\/2023<\/p>\r\n <\/div>\r\n <div>\r\n <h3 style=\"font-size:1rem;font-weight:700\">Navigasi<\/h3>\r\n <ul style=\"margin-top:1rem;display:flex;flex-direction:column;gap:.625rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">\r\n <li><a href=\"https:\/\/pandaigadai.com\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"footer-nav-link\">pandaigadai.com<\/a><\/li>\r\n <\/ul>\r\n <\/div>\r\n <div>\r\n <h3 style=\"font-size:1rem;font-weight:700\">Layanan Pengaduan Kantor Pusat<\/h3>\r\n <p style=\"margin-top:1rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">\r\n Telepon: <a href=\"tel:085715322146\" class=\"footer-nav-link\">0857-1532-2146<\/a><br>\r\n Email: <a href=\"mailto:hello@pandaigadai.com\" class=\"footer-nav-link\">hello@pandaigadai.com<\/a>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n <div class=\"footer-bottom\">\r\n <div class=\"footer-bottom-inner\">\r\n <span>© Copyright PT Solusi Gadai Pintar 2026 All Rights Reserved<\/span>\r\n <div style=\"display:flex;align-items:center;gap:.75rem\">\r\n <a href=\"https:\/\/www.instagram.com\/pandaigadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Instagram\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"height:1rem;width:1rem\"><rect x=\"2\" y=\"2\" width=\"20\" height=\"20\" rx=\"5\" ry=\"5\"\/><path d=\"M16 11.37A4 4 0 1112.63 8 4 4 0 0116 11.37z\"\/><line x1=\"17.5\" y1=\"6.5\" x2=\"17.51\" y2=\"6.5\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.tiktok.com\/@pandaigadai.id\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"TikTok\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M19.59 6.69a4.83 4.83 0 01-3.77-4.25V2h-3.45v13.67a2.89 2.89 0 01-5.2 1.74 2.89 2.89 0 012.31-4.64 2.93 2.93 0 01.88.13V9.4a6.84 6.84 0 00-1-.05A6.33 6.33 0 005.8 20.1a6.34 6.34 0 0010.86-4.43V8.92a8.16 8.16 0 004.77 1.52V7A4.86 4.86 0 0119.59 6.69z\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.facebook.com\/pandaigadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Facebook\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M24 12.073c0-6.627-5.373-12-12-12s-12 5.373-12 12c0 5.99 4.388 10.954 10.125 11.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007 1.792-4.669 4.533-4.669 1.312 0 2.686.235 2.686.235v2.953H15.83c-1.491 0-1.956.925-1.956 1.874v2.25h3.328l-.532 3.47h-2.796v8.385C19.612 23.027 24 18.062 24 12.073z\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.youtube.com\/@PandaiGadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"YouTube\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M23.498 6.186a3.016 3.016 0 00-2.122-2.136C19.505 3.545 12 3.545 12 3.545s-7.505 0-9.377.505A3.017 3.017 0 00.502 6.186C0 8.07 0 12 0 12s0 3.93.502 5.814a3.016 3.016 0 002.122 2.136c1.871.505 9.376.505 9.376.505s7.505 0 9.377-.505a3.015 3.015 0 002.122-2.136C24 15.93 24 12 24 12s0-3.93-.502-5.814z\"\/><\/svg><\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<script>\r\n(function(){\r\n'use strict';\r\nvar $=function(id){return document.getElementById(id);};\r\n\r\n\/* ====== SETTINGS ====== *\/\r\nvar SHEET_ID='1nO3eIJ4b-ABN1oAKmh4hKs9KtlAdwFqy_uEk9PRQuiI';\r\nvar TAB_SUMMARY='SUMMARY';\r\nvar TARGET=15;\r\nvar WINDOW_SIZE=6;\r\nvar MASTER_SHEET_ID='1DV9BxMNuWo3z_U7qv7q-0js0iBrHIkw_T-PhK5wQhh0';\r\nvar TAB_MASTER='MASTER AM DAN NAMA CABANG ';\r\n\/* ====================== *\/\r\n\r\nvar LS='cv_dash_pg_v1';\r\nvar MONTH_MAP={jan:0,feb:1,mar:2,apr:3,may:4,jun:5,jul:6,aug:7,sep:8,oct:9,nov:10,dec:11};\r\n\r\nvar state={\r\n tab:'ringkasan', search:'', filterArea:'', filterAM:'', filterKaster:'',\r\n sortAM:{key:'pctBelow',dir:-1}, sortKaster:{key:'pctBelow',dir:-1}, sortCabang:{key:'branch',dir:1},\r\n branches:[], months:[]\r\n};\r\n\r\nfunction savePrefs(){try{localStorage.setItem(LS,JSON.stringify({tab:state.tab}));}catch(e){}}\r\nfunction loadPrefs(){try{var p=JSON.parse(localStorage.getItem(LS)||'{}');if(p.tab)state.tab=p.tab;}catch(e){}}\r\n\r\nfunction setStatus(m,c){var s=$('status');s.style.display='block';s.className='status '+(c||'info');s.innerHTML=m;}\r\nfunction esc(s){return String(s==null?'':s).replace(\/[&<>\"']\/g,function(c){return{'&':'&','<':'<','>':'>','\"':'"',\"'\":'''}[c];});}\r\nfunction nf(n){return isFinite(n)?Math.round(n).toLocaleString('id-ID'):'\u2014';}\r\n\r\nfunction parseCSV(text){var rows=[],row=[],cur='',i=0,q=false;while(i<text.length){var c=text[i];\r\n if(q){if(c==='\"'){if(text[i+1]==='\"'){cur+='\"';i++;}else q=false;}else cur+=c;}\r\n else{if(c==='\"')q=true;else if(c===','){row.push(cur);cur='';}else if(c==='\\n'){row.push(cur);rows.push(row);row=[];cur='';}else if(c==='\\r'){}else cur+=c;}\r\n i++;}\r\n if(cur.length||row.length){row.push(cur);rows.push(row);}return rows;}\r\n\r\nfunction cbucket(){return Math.floor(Date.now()\/300000);}\r\nfunction gvizUrl(tab){return 'https:\/\/docs.google.com\/spreadsheets\/d\/'+SHEET_ID+'\/gviz\/tq?tqx=out:csv&sheet='+encodeURIComponent(tab)+'&_cb='+cbucket();}\r\nfunction gvizUrlFor(sheetId,tab){return 'https:\/\/docs.google.com\/spreadsheets\/d\/'+sheetId+'\/gviz\/tq?tqx=out:csv&sheet='+encodeURIComponent(tab)+'&_cb='+cbucket();}\r\n\r\nfunction fetchCsv(url){return fetch(url,{credentials:'omit'}).then(function(r){\r\n if(!r.ok)throw new Error('HTTP '+r.status);var ct=r.headers.get('content-type')||'';return r.text().then(function(t){\r\n if(\/text\\\/html\/i.test(ct)||new RegExp('<'+'html','i').test(t.slice(0,200)))throw new Error('html\/blocked \u2014 cek sharing sheet');\r\n var rows=parseCSV(t);\r\n if(rows.length<1)throw new Error('sheet kosong');return rows;});});}\r\n\r\nfunction normName(s){return (s||'').toUpperCase().replace(\/^PANDAI\\s*GADAI\\s*\/,'').replace(\/[.,]\/g,'').replace(\/\\s+\/g,' ').trim();}\r\nfunction levenshtein(a,b){var m=a.length,n=b.length;if(!m)return n;if(!n)return m;\r\n var dp=Array.from({length:m+1},function(){return new Array(n+1).fill(0);});\r\n for(var i=0;i<=m;i++)dp[i][0]=i;for(var j=0;j<=n;j++)dp[0][j]=j;\r\n for(i=1;i<=m;i++)for(j=1;j<=n;j++)dp[i][j]=a[i-1]===b[j-1]?dp[i-1][j-1]:1+Math.min(dp[i-1][j],dp[i][j-1],dp[i-1][j-1]);\r\n return dp[m][n];}\r\nfunction findBestMatch(name,masterList){\r\n var n=normName(name);\r\n var exact=masterList.find(function(m){return m.norm===n;}); if(exact)return exact;\r\n var contain=masterList.find(function(m){return m.norm.indexOf(n)>=0||n.indexOf(m.norm)>=0;});\r\n if(contain&&Math.abs(contain.norm.length-n.length)<=6)return contain;\r\n var best=null,bestDist=999;\r\n masterList.forEach(function(m){var d=levenshtein(n,m.norm);if(d<bestDist){bestDist=d;best=m;}});\r\n if(best&&bestDist<=Math.max(2,Math.floor(n.length*0.2)))return best;\r\n return null;\r\n}\r\nfunction loadAreaMap(){\r\n return fetchCsv(gvizUrlFor(MASTER_SHEET_ID,TAB_MASTER)).then(function(rows){\r\n var master=rows.slice(1).filter(function(r){return r[2];}).map(function(r){\r\n return{area:r[0]||'',branch:r[2],norm:normName(r[2])};\r\n });\r\n return master;\r\n }).catch(function(){return [];});\r\n}\r\n\r\n\/* ---- deteksi kolom bulan otomatis dari header, format \"Mmm,YYYY\" atau \"Mmm,YY\" ---- *\/\r\nfunction parseMonthLabel(s){\r\n var m=String(s||'').trim().match(\/^([A-Za-z]{3,9}),\\s*(\\d{2,4})$\/);\r\n if(!m)return null;\r\n var mi=MONTH_MAP[m[1].toLowerCase().slice(0,3)];\r\n if(mi==null)return null;\r\n var y=parseInt(m[2],10);if(m[2].length===2)y+=2000;\r\n return{label:s.trim(),month:mi,year:y,sortKey:y*12+mi};\r\n}\r\n\r\nfunction findHeaderRow(rows){\r\n for(var r=0;r<Math.min(rows.length,10);r++){\r\n for(var c=0;c<rows[r].length;c++){\r\n if(String(rows[r][c]||'').trim().toLowerCase()==='branch')return r;\r\n }\r\n }\r\n return -1;\r\n}\r\n\r\nfunction ingest(rows,areaMap){\r\n var hr=findHeaderRow(rows);\r\n if(hr<0)throw new Error('Header row (kolom \"Branch\") gak ketemu di tab SUMMARY.');\r\n var header=rows[hr];\r\n var branchCol=-1,amCol=-1,kasterCol=-1;\r\n header.forEach(function(h,i){var v=String(h||'').trim().toLowerCase();\r\n if(v==='branch')branchCol=i; else if(v==='am')amCol=i; else if(v==='kaster')kasterCol=i;});\r\n if(branchCol<0)throw new Error('Kolom Branch gak ketemu.');\r\n\r\n var monthCols=[];\r\n header.forEach(function(h,i){var p=parseMonthLabel(h);if(p){p.col=i;monthCols.push(p);}});\r\n monthCols.sort(function(a,b){return a.sortKey-b.sortKey;});\r\n var windowCols=monthCols.slice(-WINDOW_SIZE);\r\n if(!windowCols.length)throw new Error('Kolom bulan (format \"Mmm,YYYY\") gak ketemu di header.');\r\n state.months=windowCols;\r\n\r\n var branches=[];\r\n for(var r=hr+1;r<rows.length;r++){\r\n var row=rows[r];if(!row)continue;\r\n var branch=(row[branchCol]||'').trim();if(!branch)continue;\r\n var am=amCol>=0?(row[amCol]||'').trim():'';\r\n var kaster=kasterCol>=0?(row[kasterCol]||'').trim():'';\r\n var vals={};var sum=0,cnt=0;\r\n windowCols.forEach(function(mc){\r\n var raw=(row[mc.col]||'').trim();\r\n var v=raw===''?null:parseFloat(raw);\r\n if(v!=null&&!isNaN(v)){vals[mc.label]=v;sum+=v;cnt++;}else{vals[mc.label]=null;}\r\n });\r\n var areaMatch=areaMap&&areaMap.length?findBestMatch(branch,areaMap):null;\r\n branches.push({branch:branch,am:am,kaster:kaster,area:areaMatch?areaMatch.area:'',vals:vals,avg:cnt?(sum\/cnt):null,hasData:cnt>0});\r\n }\r\n state.branches=branches;\r\n}\r\n\r\nfunction load(){\r\n setStatus('Memuat data dari Google Sheet\u2026','info');\r\n Promise.all([fetchCsv(gvizUrl(TAB_SUMMARY)),loadAreaMap()]).then(function(res){\r\n ingest(res[0],res[1]);\r\n $('tabs').style.display='flex';\r\n renderFilterOptions();\r\n var withData=state.branches.filter(function(b){return b.hasData;}).length;\r\n var mlabel=state.months.map(function(m){return m.label;}).join(', ');\r\n var noArea=state.branches.filter(function(b){return !b.area;}).length;\r\n setStatus('\u2713 Termuat '+state.branches.length+' cabang. Window bulan terdeteksi: <b>'+esc(mlabel)+'<\/b>. '+withData+' cabang punya data di rentang ini.'+(noArea?(' '+noArea+' cabang gak ke-match Area (nama beda jauh dari master).'):'')+' Tab SUMMARY diupdate manual (bukan real-time), jadi cek juga spreadsheet asli kalau ragu ke-update-annya.','ok');\r\n $('window-label').textContent='Menampilkan '+state.months.length+' bulan terakhir yang terdeteksi otomatis dari header sheet';\r\n render();\r\n }).catch(function(err){\r\n setStatus('Gagal memuat data. Pastikan sheet sharing \"Anyone with link \u2013 Viewer\". ('+esc(String(err&&err.message||err))+')','err');\r\n });\r\n}\r\n\r\nfunction render(){\r\n syncTabs();\r\n renderScorecards();\r\n renderHeatmap();\r\n renderAMTable();\r\n renderKasterTable();\r\n renderCabangTable();\r\n $('footer-note').style.display='block';\r\n $('footer-note').innerHTML=filteredBranches().length+' dari '+state.branches.length+' cabang tampil \u2022 window '+state.months.length+' bulan \u2022 diperbarui '+new Date().toLocaleString('id-ID');\r\n}\r\n\r\nfunction filteredBranches(){\r\n var q=state.search.toUpperCase();\r\n return state.branches.filter(function(b){\r\n if(q&&b.branch.toUpperCase().indexOf(q)<0)return false;\r\n if(state.filterArea&&b.area!==state.filterArea)return false;\r\n if(state.filterAM&&b.am!==state.filterAM)return false;\r\n if(state.filterKaster&&b.kaster!==state.filterKaster)return false;\r\n return true;\r\n });\r\n}\r\n\r\nfunction renderFilterOptions(){\r\n var areas=Array.from(new Set(state.branches.map(function(b){return b.area;}).filter(Boolean))).sort();\r\n var ams=Array.from(new Set(state.branches.map(function(b){return b.am;}).filter(Boolean))).sort();\r\n var kasters=Array.from(new Set(state.branches.map(function(b){return b.kaster;}).filter(Boolean))).sort();\r\n function fill(id,opts,allLabel){\r\n var sel=$(id);var cur=sel.value;\r\n sel.innerHTML='<option value=\"\">'+allLabel+'<\/option>'+opts.map(function(o){return '<option value=\"'+esc(o)+'\">'+esc(o)+'<\/option>';}).join('');\r\n sel.value=cur;\r\n }\r\n fill('sel-area',areas,'Semua Area');\r\n fill('sel-am',ams,'Semua AM');\r\n fill('sel-kaster',kasters,'Semua KASTER');\r\n}\r\n\r\nfunction syncTabs(){\r\n var tabs=document.querySelectorAll('#tabs button');\r\n for(var i=0;i<tabs.length;i++)tabs[i].classList.toggle('active',tabs[i].getAttribute('data-tab')===state.tab);\r\n ['ringkasan','am','cabang'].forEach(function(p){var el=$('pane-'+p);if(el)el.style.display=(state.tab===p)?'block':'none';});\r\n}\r\n\r\nfunction latestMonth(){return state.months[state.months.length-1];}\r\n\r\n\/* ---------------- TAB: RINGKASAN ---------------- *\/\r\nfunction renderScorecards(){\r\n var lm=latestMonth();if(!lm)return;\r\n var total=filteredBranches().length,capai=0,belowT=0,noData=0,sum=0,cnt=0;\r\n filteredBranches().forEach(function(b){\r\n var v=b.vals[lm.label];\r\n if(v==null)noData++;\r\n else{if(v>=TARGET)capai++;else belowT++;sum+=v;cnt++;}\r\n });\r\n var avgNet=cnt?(sum\/cnt):null;\r\n $('scorecards').innerHTML=\r\n '<div class=\"sc\"><div class=\"lbl\">Total Cabang<\/div><div class=\"val\">'+nf(total)+'<\/div><div class=\"sub\">di roster SUMMARY<\/div><\/div>'+\r\n '<div class=\"sc green\"><div class=\"lbl\">Capai Target<\/div><div class=\"val\">'+nf(capai)+'<\/div><div class=\"sub\">'+esc(lm.label)+', ≥ '+TARGET+'x<\/div><\/div>'+\r\n '<div class=\"sc red\"><div class=\"lbl\">Di Bawah Target<\/div><div class=\"val\">'+nf(belowT)+'<\/div><div class=\"sub\">'+esc(lm.label)+', < '+TARGET+'x<\/div><\/div>'+\r\n '<div class=\"sc amber\"><div class=\"lbl\">Belum Ada Data<\/div><div class=\"val\">'+nf(noData)+'<\/div><div class=\"sub\">'+esc(lm.label)+'<\/div><\/div>'+\r\n '<div class=\"sc accent\"><div class=\"lbl\">Rata-rata Network<\/div><div class=\"val\">'+(avgNet!=null?avgNet.toFixed(1):'\u2014')+'<\/div><div class=\"sub\">'+esc(lm.label)+'<\/div><\/div>';\r\n}\r\n\r\nfunction renderHeatmap(){\r\n $('heat-sub').textContent=state.months.map(function(m){return m.label;}).join(' \u00b7 ');\r\n var th=$('heat-thead');\r\n var h='<th class=\"stick l\">Cabang<\/th><th class=\"l\">AM<\/th>';\r\n state.months.forEach(function(m){h+='<th class=\"c\">'+esc(m.label)+'<\/th>';});\r\n th.innerHTML=h;\r\n var tb=$('heat-tbody');\r\n if(!filteredBranches().length){tb.innerHTML='<tr><td colspan=\"'+(2+state.months.length)+'\" class=\"muted\" style=\"padding:1rem;text-align:center\">Gak ada cabang yang cocok filter.<\/td><\/tr>';return;}\r\n tb.innerHTML=filteredBranches().map(function(b){\r\n var cells=state.months.map(function(m){\r\n var v=b.vals[m.label];\r\n if(v==null)return '<td class=\"c cell-blank\">\u00b7<\/td>';\r\n var cls=v<TARGET?'cell-red':'cell-ok';\r\n return '<td class=\"c '+cls+'\">'+nf(v)+'<\/td>';\r\n }).join('');\r\n return '<tr><td class=\"stick l branch\">'+esc(b.branch)+'<\/td><td class=\"l muted\">'+esc(b.am||'\u2014')+'<\/td>'+cells+'<\/tr>';\r\n }).join('');\r\n}\r\n\r\n\/* ---------------- TAB: AM & KASTER ---------------- *\/\r\nfunction groupAgg(keyFn){\r\n var groups={};\r\n var lm=latestMonth();\r\n filteredBranches().forEach(function(b){\r\n var key=keyFn(b)||'(Tanpa data)';\r\n if(!groups[key])groups[key]={label:key,total:0,capai:0,below:0,noData:0,sumAvg:0,cntAvg:0};\r\n var g=groups[key];g.total++;\r\n var v=lm?b.vals[lm.label]:null;\r\n if(v==null)g.noData++; else if(v>=TARGET)g.capai++; else g.below++;\r\n if(b.avg!=null){g.sumAvg+=b.avg;g.cntAvg++;}\r\n });\r\n return Object.keys(groups).map(function(k){\r\n var g=groups[k];\r\n var denomForPct=g.total-g.noData;\r\n g.pctBelow=denomForPct?Math.round(g.below\/denomForPct*100):0;\r\n g.avgOverall=g.cntAvg?(g.sumAvg\/g.cntAvg):null;\r\n return g;\r\n });\r\n}\r\n\r\nvar GROUPCOLS=[{k:'label',t:'Nama',l:true,s:true},{k:'total',t:'Jumlah Cabang',s:true},{k:'capai',t:'Capai Target',s:true},\r\n {k:'below',t:'Di Bawah Target',s:true},{k:'noData',t:'Belum Ada Data',s:true},{k:'pctBelow',t:'% Di Bawah Target',s:true},{k:'avgOverall',t:'Rata-rata',s:true}];\r\n\r\nfunction renderGroupTable(rows,sortState,theadId,tbodyId,labelHead,onSortChange){\r\n var sk=sortState.key,sd=sortState.dir;\r\n rows=rows.slice().sort(function(a,b){var x=a[sk],y=b[sk];\r\n if(x==null)x=sk==='avgOverall'?-1:0; if(y==null)y=sk==='avgOverall'?-1:0;\r\n if(typeof x==='string')return sd*x.localeCompare(y);return sd*(x-y);});\r\n var th=$(theadId);th.innerHTML='';\r\n GROUPCOLS.forEach(function(c){\r\n var el=document.createElement('th');\r\n var label=c.k==='label'?labelHead:c.t;\r\n el.textContent=label+(sortState.key===c.k?(sd<0?' \u25bc':' \u25b2'):'');\r\n el.className=(c.l?'l':'')+(sortState.key===c.k?' sorted':'');\r\n el.onclick=function(){if(sortState.key===c.k)sortState.dir*=-1;else{sortState.key=c.k;sortState.dir=(c.k==='label')?1:-1;}onSortChange();};\r\n th.appendChild(el);\r\n });\r\n var tb=$(tbodyId);\r\n if(!rows.length){tb.innerHTML='<tr><td colspan=\"7\" class=\"muted\" style=\"padding:1rem;text-align:center\">Belum ada data.<\/td><\/tr>';return;}\r\n tb.innerHTML=rows.map(function(r){\r\n var pc=r.pctBelow>=30?'style=\"color:var(--destructive);font-weight:800\"':(r.pctBelow>0?'style=\"color:#b45309;font-weight:700\"':'class=\"muted\"');\r\n return '<tr><td class=\"l branch\">'+esc(r.label)+'<\/td>'+\r\n '<td style=\"font-weight:700\">'+nf(r.total)+'<\/td>'+\r\n '<td style=\"color:var(--success);font-weight:700\">'+nf(r.capai)+'<\/td>'+\r\n '<td style=\"color:var(--destructive);font-weight:800\">'+nf(r.below)+'<\/td>'+\r\n '<td class=\"muted\">'+nf(r.noData)+'<\/td>'+\r\n '<td '+pc+'>'+r.pctBelow+'%<\/td>'+\r\n '<td style=\"font-weight:700\">'+(r.avgOverall!=null?r.avgOverall.toFixed(1):'\u2014')+'<\/td><\/tr>';\r\n }).join('');\r\n}\r\n\r\nfunction renderAMTable(){\r\n var lm=latestMonth();\r\n $('am-sub').textContent=lm?('status '+lm.label+' \u00b7 rata-rata dari seluruh window'):'';\r\n renderGroupTable(groupAgg(function(b){return b.am;}),state.sortAM,'am-thead','am-tbody','Area Manager',renderAMTable);\r\n}\r\nfunction renderKasterTable(){\r\n var lm=latestMonth();\r\n $('kaster-sub').textContent=lm?('status '+lm.label+' \u00b7 rata-rata dari seluruh window'):'';\r\n renderGroupTable(groupAgg(function(b){return b.kaster;}),state.sortKaster,'kaster-thead','kaster-tbody','KASTER',renderKasterTable);\r\n}\r\n\r\n\/* ---------------- TAB: DETAIL CABANG ---------------- *\/\r\nfunction renderCabangTable(){\r\n var filtered=filteredBranches();\r\n $('cabang-sub').textContent=filtered.length+' cabang';\r\n\r\n var sk=state.sortCabang.key,sd=state.sortCabang.dir;\r\n filtered=filtered.slice().sort(function(a,b){\r\n var x,y;\r\n if(sk==='branch'||sk==='am'||sk==='kaster'){x=(a[sk]||'').toString();y=(b[sk]||'').toString();return sd*x.localeCompare(y);}\r\n if(sk==='avg'){x=a.avg==null?-1:a.avg;y=b.avg==null?-1:b.avg;return sd*(x-y);}\r\n \/\/ sort by a specific month label\r\n x=a.vals[sk]==null?-1:a.vals[sk];y=b.vals[sk]==null?-1:b.vals[sk];return sd*(x-y);\r\n });\r\n\r\n var th=$('cabang-thead');\r\n var cols=[{k:'branch',t:'Cabang',l:true},{k:'area',t:'Area',l:true},{k:'am',t:'AM',l:true},{k:'kaster',t:'KASTER',l:true}]\r\n .concat(state.months.map(function(m){return{k:m.label,t:m.label,c:true};}))\r\n .concat([{k:'avg',t:'Rata-rata',c:true,avgCol:true}]);\r\n th.innerHTML=cols.map(function(c){\r\n var cls=(c.l?'l':(c.c?'c':''))+(state.sortCabang.key===c.k?' sorted':'')+(c.avgCol?' avg-col':'');\r\n return '<th class=\"'+cls+'\" data-k=\"'+c.k+'\">'+esc(c.t)+(state.sortCabang.key===c.k?(sd<0?' \u25bc':' \u25b2'):'')+'<\/th>';\r\n }).join('');\r\n th.querySelectorAll('th').forEach(function(el){\r\n el.onclick=function(){var k=el.getAttribute('data-k');if(state.sortCabang.key===k)state.sortCabang.dir*=-1;else{state.sortCabang.key=k;state.sortCabang.dir=1;}renderCabangTable();};\r\n });\r\n\r\n var tb=$('cabang-tbody');\r\n if(!filtered.length){tb.innerHTML='<tr><td colspan=\"'+cols.length+'\" class=\"muted\" style=\"padding:1rem;text-align:center\">Gak ada cabang yang cocok.<\/td><\/tr>';return;}\r\n tb.innerHTML=filtered.map(function(b){\r\n var monthCells=state.months.map(function(m){\r\n var v=b.vals[m.label];\r\n if(v==null)return '<td class=\"c cell-blank\">\u00b7<\/td>';\r\n var cls=v<TARGET?'cell-red':'cell-ok';\r\n return '<td class=\"c '+cls+'\">'+nf(v)+'<\/td>';\r\n }).join('');\r\n return '<tr><td class=\"stick l branch\">'+esc(b.branch)+'<\/td><td class=\"l muted\">'+esc(b.area||'\u2014')+'<\/td><td class=\"l\">'+(b.am?esc(b.am):'<span class=\"muted\">\u2014<\/span>')+'<\/td><td class=\"l muted\">'+esc(b.kaster||'\u2014')+'<\/td>'+\r\n monthCells+'<td class=\"c avg-col\">'+(b.avg!=null?b.avg.toFixed(1):'\u2014')+'<\/td><\/tr>';\r\n }).join('');\r\n}\r\n\r\nwindow.CV={\r\n load:load,\r\n setTab:function(t){state.tab=t;savePrefs();syncTabs();},\r\n setSearch:function(v){state.search=v;render();},\r\n setFilter:function(field,value){state['filter'+field.charAt(0).toUpperCase()+field.slice(1)]=value;render();}\r\n};\r\n\r\nloadPrefs();load();\r\n})();\r\n<\/script>\r\n<\/body>\r\n<\/html>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"unboxed","site-sidebar-style":"unboxed","ast-global-header-display":"disabled","ast-banner-title-visibility":"disabled","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"disabled","ast-disable-related-posts":"disabled","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-2960","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Julia Afildah","author_link":"https:\/\/pandaigadai.com\/blog\/author\/julia-afildah\/"},"uagb_comment_info":0,"uagb_excerpt":null,"_links":{"self":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/comments?post=2960"}],"version-history":[{"count":1,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960\/revisions"}],"predecessor-version":[{"id":2961,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960\/revisions\/2961"}],"wp:attachment":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/media?parent=2960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":2960,"date":"2026-09-04T15:49:16","date_gmt":"2026-09-04T08:49:16","guid":{"rendered":"https:\/\/pandaigadai.com\/blog\/?page_id=2960"},"modified":"2026-09-04T15:49:16","modified_gmt":"2026-09-04T08:49:16","slug":"canvassing-branch-tracker","status":"publish","type":"page","link":"https:\/\/pandaigadai.com\/blog\/canvassing-branch-tracker\/","title":{"rendered":"Canvassing Branch Tracker"},"content":{"rendered":"\r\n\r\n\r\n\r\n\r\nDashboard Canvassing Tracker \u2014 Pandai Gadai<\/title>\r\n<link rel=\"preconnect\" href=\"https:\/\/fonts.googleapis.com\">\r\n<link rel=\"preconnect\" href=\"https:\/\/fonts.gstatic.com\" crossorigin>\r\n<link rel=\"stylesheet\" href=\"https:\/\/fonts.googleapis.com\/css2?family=Rubik:wght@400;500;600;700;800;900&display=swap\">\r\n<style>\r\n#pg-page *, #pg-page *::before, #pg-page *::after{box-sizing:border-box;margin:0;padding:0}\r\nhtml,body{margin:0;padding:0;background:#f0f2f8}\r\n#pg-page{\r\n --radius:0.625rem;--background:#ffffff;--foreground:#021431;--card:#ffffff;\r\n --primary:#02439F;--primary-deep:#011455;--primary-bright:#0255CA;--primary-foreground:#f8fafc;\r\n --accent:#ffcd05;--accent-foreground:#021431;--secondary:#f3f5fb;--muted:#f0f2f8;\r\n --muted-foreground:#6b7280;--destructive:#dc2626;--success:#047857;--border:#e2e6f0;\r\n --footer-bg:#02439f;--shadow-card:0 2px 8px -2px rgba(2,20,49,0.08);\r\n --gradient-hero:linear-gradient(135deg,#011455,#0255CA);\r\n}\r\n#pg-page{font-family:\"Rubik\",system-ui,-apple-system,\"Segoe UI\",sans-serif;background:var(--muted);color:var(--foreground);line-height:1.6;-webkit-font-smoothing:antialiased}\r\n#pg-page h1,#pg-page h2,#pg-page h3,#pg-page h4{letter-spacing:-0.02em}\r\n#pg-page p{margin:0}#pg-page a{text-decoration:none;color:inherit}#pg-page img{display:block;max-width:100%}\r\n#pg-page ul{list-style:none}\r\n#pg-page .site-header{position:sticky;top:0;z-index:100;background:var(--background);border-bottom:1px solid var(--border)}\r\n#pg-page .header-inner{max-width:78rem;margin:0 auto;display:flex;height:5rem;align-items:center;justify-content:space-between;padding:0 1rem}\r\n#pg-page .btn-header{display:inline-flex;align-items:center;gap:.375rem;border-radius:calc(var(--radius) - 2px);background:var(--accent);padding:.5rem .875rem;font-size:.875rem;font-weight:700;color:var(--accent-foreground);box-shadow:0 1px 2px rgba(0,0,0,.05)}\r\n#pg-page .dash-hero{background:var(--gradient-hero);color:var(--primary-foreground);position:relative;overflow:hidden}\r\n#pg-page .dash-hero-overlay{position:absolute;inset:0;opacity:.3;background:radial-gradient(ellipse at top right,rgba(255,205,5,.35),transparent 60%);pointer-events:none}\r\n#pg-page .dash-hero-inner{position:relative;max-width:78rem;margin:0 auto;padding:2rem 1rem 2.25rem}\r\n#pg-page .dash-hero .eyebrow{display:inline-flex;align-items:center;gap:.4rem;font-size:.7rem;font-weight:800;text-transform:uppercase;letter-spacing:.08em;background:rgba(255,255,255,.15);padding:.3rem .7rem;border-radius:999px}\r\n#pg-page .dash-hero h1{font-size:1.6rem;font-weight:800;margin:.7rem 0 .25rem}\r\n#pg-page .dash-hero p{font-size:.9rem;color:rgba(255,255,255,.85)}\r\n@media(min-width:768px){#pg-page .dash-hero h1{font-size:2rem}}\r\n#pg-page .dash-body{max-width:78rem;margin:0 auto;padding:1.25rem 1rem 2.5rem}\r\n#pg-page .controls{display:flex;flex-wrap:wrap;gap:.6rem;align-items:center;background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:.75rem .9rem;box-shadow:var(--shadow-card);margin-bottom:1rem}\r\n#pg-page .ctl-label{font-size:.72rem;font-weight:700;text-transform:uppercase;letter-spacing:.05em;color:var(--muted-foreground)}\r\n#pg-page select,#pg-page input[type=text],#pg-page input[type=number]{font-family:inherit;padding:.42rem .55rem;border:1px solid var(--border);border-radius:calc(var(--radius) - 2px);font-size:.8125rem;color:var(--foreground);background:var(--card);outline:none}\r\n#pg-page input[type=text]{flex:1;min-width:180px}\r\n#pg-page input:focus,#pg-page select:focus{border-color:var(--primary)}\r\n#pg-page .btn-accent{display:inline-flex;align-items:center;gap:.4rem;border-radius:calc(var(--radius) - 2px);background:var(--accent);padding:.5rem 1.1rem;font-family:inherit;font-size:.8125rem;font-weight:700;color:var(--accent-foreground);border:none;cursor:pointer;box-shadow:0 1px 2px rgba(0,0,0,.05)}\r\n#pg-page .tabs{display:flex;gap:.2rem;border-bottom:2px solid var(--border);margin:.25rem 0 1.15rem;overflow-x:auto}\r\n#pg-page .tabs button{border:none;background:none;font-family:inherit;font-size:.9rem;font-weight:700;color:var(--muted-foreground);padding:.6rem .95rem;cursor:pointer;border-bottom:3px solid transparent;margin-bottom:-2px;white-space:nowrap}\r\n#pg-page .tabs button:hover{color:var(--foreground)}\r\n#pg-page .tabs button.active{color:var(--primary);border-bottom-color:var(--primary)}\r\n#pg-page .status{font-size:.82rem;padding:.6rem .8rem;border-radius:calc(var(--radius) - 2px);margin-bottom:1rem;line-height:1.5}\r\n#pg-page .status.info{background:var(--secondary);color:var(--primary-deep);border:1px solid var(--border)}\r\n#pg-page .status.ok{background:#ecfdf5;color:var(--success);border:1px solid #a7f3d0}\r\n#pg-page .status.err{background:#fef2f2;color:var(--destructive);border:1px solid #fca5a5}\r\n#pg-page .scorecards{display:grid;grid-template-columns:repeat(5,1fr);gap:.75rem;margin-bottom:1.25rem}\r\n#pg-page .sc{background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:.9rem 1rem;box-shadow:var(--shadow-card);border-top:3px solid var(--primary)}\r\n#pg-page .sc.accent{border-top-color:var(--accent)}#pg-page .sc.green{border-top-color:var(--success)}\r\n#pg-page .sc.amber{border-top-color:#f59e0b}#pg-page .sc.red{border-top-color:var(--destructive)}\r\n#pg-page .sc .lbl{font-size:.66rem;font-weight:800;text-transform:uppercase;letter-spacing:.05em;color:var(--muted-foreground)}\r\n#pg-page .sc .val{font-size:1.55rem;font-weight:800;color:var(--primary);line-height:1.1;margin-top:.3rem}\r\n#pg-page .sc.accent .val{color:var(--primary-deep)}#pg-page .sc.green .val{color:var(--success)}\r\n#pg-page .sc.amber .val{color:#b45309}#pg-page .sc.red .val{color:var(--destructive)}\r\n#pg-page .sc .sub{font-size:.7rem;color:var(--muted-foreground);margin-top:.2rem}\r\n@media(max-width:1000px){#pg-page .scorecards{grid-template-columns:repeat(2,1fr)}}\r\n#pg-page .panel{background:var(--card);border:1px solid var(--border);border-radius:calc(var(--radius)+4px);padding:1rem 1.15rem;box-shadow:var(--shadow-card);margin-bottom:1.25rem}\r\n#pg-page .panel-head{display:flex;align-items:center;justify-content:space-between;gap:.5rem;margin-bottom:.9rem;flex-wrap:wrap}\r\n#pg-page .panel-title{font-size:1rem;font-weight:800;color:var(--foreground)}\r\n#pg-page .panel-sub{font-size:.72rem;color:var(--muted-foreground);font-weight:600}\r\n#pg-page .tbl-wrap{overflow:auto;max-height:min(66vh,620px);border-radius:calc(var(--radius) - 2px);border:1px solid var(--border)}\r\n#pg-page table{width:100%;border-collapse:collapse;font-size:.82rem}\r\n#pg-page thead th{position:sticky;top:0;z-index:4;background:var(--secondary);color:var(--primary-deep);font-size:.68rem;text-transform:uppercase;letter-spacing:.04em;font-weight:800;padding:.6rem .65rem;text-align:right;cursor:pointer;user-select:none;white-space:nowrap;border-bottom:2px solid var(--border)}\r\n#pg-page thead th.l,#pg-page tbody td.l{text-align:left}\r\n#pg-page thead th.c,#pg-page tbody td.c{text-align:center}\r\n#pg-page thead th.sorted{color:var(--primary);background:#e8eefb}\r\n#pg-page tbody td{padding:.5rem .65rem;text-align:right;border-bottom:1px solid var(--border);white-space:nowrap;font-variant-numeric:tabular-nums}\r\n#pg-page tbody tr:hover{background:var(--secondary)}\r\n#pg-page td.branch{font-weight:700;color:var(--foreground)}\r\n#pg-page .rank{color:var(--muted-foreground);font-weight:700}\r\n#pg-page .muted{color:var(--muted-foreground)}\r\n#pg-page .stcell{font-weight:800}\r\n#pg-page .st-ok{color:var(--success)}#pg-page .st-warn{color:var(--destructive)}\r\n#pg-page table.pivot th.stick,#pg-page table.pivot td.stick{position:sticky;left:0;z-index:3;background:var(--card);text-align:left;box-shadow:1px 0 0 var(--border)}\r\n#pg-page table.pivot thead th.stick{z-index:6;background:var(--secondary)}\r\n#pg-page td.cell-red{background:#fef2f2;color:var(--destructive);font-weight:800}\r\n#pg-page td.cell-ok{color:var(--foreground);font-weight:600}\r\n#pg-page td.cell-blank{color:#c3c9d6}\r\n#pg-page td.avg-col{font-weight:800;color:var(--primary-deep);background:#f7f9fe}\r\n#pg-page th.avg-col{background:#e8eefb}\r\n#pg-page .hint{font-size:.72rem;color:var(--muted-foreground);margin-top:.5rem;line-height:1.55}\r\n#pg-page .site-footer{background:var(--footer-bg);color:#fff}\r\n#pg-page .footer-grid{display:grid;grid-template-columns:1fr;gap:2.5rem;max-width:78rem;margin:0 auto;padding:3rem 1rem}\r\n#pg-page .footer-bottom{border-top:1px solid rgba(255,255,255,.15)}\r\n#pg-page .footer-bottom-inner{display:flex;flex-direction:column-reverse;align-items:center;justify-content:space-between;gap:.75rem;max-width:78rem;margin:0 auto;padding:1.25rem 1rem;font-size:.75rem;color:rgba(255,255,255,.8)}\r\n#pg-page .social-link{display:inline-flex;height:2rem;width:2rem;align-items:center;justify-content:center;border-radius:9999px;background:rgba(255,255,255,.1);color:#fff}\r\n#pg-page .footer-nav-link{color:rgba(255,255,255,.85)}\r\n@media(min-width:640px){#pg-page .footer-bottom-inner{flex-direction:row}}\r\n@media(min-width:768px){#pg-page .footer-grid{grid-template-columns:5fr 3fr 4fr}}\r\n#pg-page .dash-hero h1,#pg-page .dash-hero p,#pg-page .dash-hero .eyebrow{color:#fff!important}\r\n#pg-page .dash-hero p{color:rgba(255,255,255,.85)!important}\r\n#pg-page .site-footer h1,#pg-page .site-footer h2,#pg-page .site-footer h3,#pg-page .site-footer h4{color:#fff!important}\r\n#pg-page .site-footer p,#pg-page .site-footer a,#pg-page .site-footer li{color:rgba(255,255,255,.85)!important}\r\n#pg-page .footer-bottom-inner,#pg-page .footer-bottom-inner span{color:rgba(255,255,255,.8)!important}\r\n<\/style>\r\n<\/head>\r\n<body>\r\n<div id=\"pg-page\">\r\n\r\n<div class=\"site-header\">\r\n <div class=\"header-inner\">\r\n <a href=\"https:\/\/pandaigadai.com\" style=\"display:flex;align-items:center\">\r\n <img decoding=\"async\" src=\"https:\/\/pandaigadai.com\/blog\/wp-content\/uploads\/2026\/01\/cropped-panda-1.webp\" alt=\"Pandai Gadai\" style=\"height:3rem;width:auto\">\r\n <\/a>\r\n <a href=\"https:\/\/pandaigadai.com\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"btn-header\">pandaigadai.com<\/a>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"dash-hero\">\r\n <div class=\"dash-hero-overlay\"><\/div>\r\n <div class=\"dash-hero-inner\">\r\n <span class=\"eyebrow\">\ud83d\udeb6 Canvassing Activity Tracker<\/span>\r\n <h1>Dashboard Canvassing Tracker<\/h1>\r\n <p>Kuantitas canvassing FL per cabang per bulan. Target minimal 15x\/bulan, di bawah itu ditandai merah.<\/p>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"dash-body\">\r\n\r\n <div id=\"status\" class=\"status info\">Memuat data\u2026<\/div>\r\n\r\n <div class=\"controls\">\r\n <button class=\"btn-accent\" onclick=\"CV.load()\">\u27f3 Muat \/ Refresh<\/button>\r\n <span class=\"ctl-label\" id=\"window-label\"><\/span>\r\n <\/div>\r\n\r\n <div class=\"controls\">\r\n <input type=\"text\" id=\"inp-search-global\" placeholder=\"Cari nama cabang\u2026\" oninput=\"CV.setSearch(this.value)\">\r\n <span class=\"ctl-label\">Area:<\/span>\r\n <select id=\"sel-area\" onchange=\"CV.setFilter('area',this.value)\"><option value=\"\">Semua Area<\/option><\/select>\r\n <span class=\"ctl-label\">AM:<\/span>\r\n <select id=\"sel-am\" onchange=\"CV.setFilter('am',this.value)\"><option value=\"\">Semua AM<\/option><\/select>\r\n <span class=\"ctl-label\">KASTER:<\/span>\r\n <select id=\"sel-kaster\" onchange=\"CV.setFilter('kaster',this.value)\"><option value=\"\">Semua KASTER<\/option><\/select>\r\n <\/div>\r\n\r\n <div class=\"tabs\" id=\"tabs\" style=\"display:none\">\r\n <button data-tab=\"ringkasan\" class=\"active\" onclick=\"CV.setTab('ringkasan')\">\ud83d\udcca Ringkasan<\/button>\r\n <button data-tab=\"am\" onclick=\"CV.setTab('am')\">\ud83d\udc64 Ringkasan AM & KASTER<\/button>\r\n <button data-tab=\"cabang\" onclick=\"CV.setTab('cabang')\">\ud83d\udccb Detail Cabang<\/button>\r\n <\/div>\r\n\r\n <section class=\"tabpane\" id=\"pane-ringkasan\" style=\"display:none\">\r\n <div class=\"scorecards\" id=\"scorecards\"><\/div>\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udd25 Heatmap Cabang × Bulan<\/div>\r\n <div class=\"panel-sub\" id=\"heat-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table class=\"pivot\" id=\"tbl-heat\"><thead><tr id=\"heat-thead\"><\/tr><\/thead><tbody id=\"heat-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Merah = di bawah target (15x\/bulan). Putih = capai target. Abu-abu titik (\u00b7) = belum ada data bulan itu. Data source (tab SUMMARY) diupdate manual, bukan real-time dari form.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <section class=\"tabpane\" id=\"pane-am\" style=\"display:none\">\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udc64 Ringkasan per Area Manager<\/div>\r\n <div class=\"panel-sub\" id=\"am-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table id=\"tbl-am\"><thead><tr id=\"am-thead\"><\/tr><\/thead><tbody id=\"am-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Diurutkan dari % di bawah target terbesar. Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udc64 Ringkasan per KASTER<\/div>\r\n <div class=\"panel-sub\" id=\"kaster-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table id=\"tbl-kaster\"><thead><tr id=\"kaster-thead\"><\/tr><\/thead><tbody id=\"kaster-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Diurutkan dari % di bawah target terbesar. Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <section class=\"tabpane\" id=\"pane-cabang\" style=\"display:none\">\r\n <div class=\"panel\">\r\n <div class=\"panel-head\">\r\n <div class=\"panel-title\">\ud83d\udccb Detail per Cabang<\/div>\r\n <div class=\"panel-sub\" id=\"cabang-sub\"><\/div>\r\n <\/div>\r\n <div class=\"tbl-wrap\">\r\n <table class=\"pivot\" id=\"tbl-cabang\"><thead><tr id=\"cabang-thead\"><\/tr><\/thead><tbody id=\"cabang-tbody\"><\/tbody><\/table>\r\n <\/div>\r\n <div class=\"hint\">Kolom Rata-rata dihitung dari bulan yang ada datanya saja (bulan kosong tidak ikut dibagi). Klik judul kolom untuk mengurutkan.<\/div>\r\n <\/div>\r\n <\/section>\r\n\r\n <div class=\"hint\" id=\"footer-note\" style=\"display:none\"><\/div>\r\n <div style=\"text-align:center;padding-top:.5rem\">\r\n <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1nO3eIJ4b-ABN1oAKmh4hKs9KtlAdwFqy_uEk9PRQuiI\/edit\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"font-size:.78rem;font-weight:700;color:var(--primary)\">\ud83d\udcc4 Buka Spreadsheet Asli (detail lengkap) \u2197<\/a>\r\n <\/div>\r\n<\/div>\r\n\r\n<div class=\"site-footer\">\r\n <div class=\"footer-grid\">\r\n <div>\r\n <img decoding=\"async\" src=\"https:\/\/pandaigadai.com\/blog\/wp-content\/uploads\/2026\/01\/cropped-panda-1.webp\" alt=\"Pandai Gadai\" style=\"height:3.5rem;width:auto\">\r\n <p style=\"margin-top:1.25rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">Berizin dan Diawasi Otoritas Jasa Keuangan<\/p>\r\n <p style=\"margin-top:.5rem;font-size:.875rem;font-weight:600\">Nomor Izin: KEP-180\/PL.02\/2023<\/p>\r\n <\/div>\r\n <div>\r\n <h3 style=\"font-size:1rem;font-weight:700\">Navigasi<\/h3>\r\n <ul style=\"margin-top:1rem;display:flex;flex-direction:column;gap:.625rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">\r\n <li><a href=\"https:\/\/pandaigadai.com\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"footer-nav-link\">pandaigadai.com<\/a><\/li>\r\n <\/ul>\r\n <\/div>\r\n <div>\r\n <h3 style=\"font-size:1rem;font-weight:700\">Layanan Pengaduan Kantor Pusat<\/h3>\r\n <p style=\"margin-top:1rem;font-size:.875rem;color:rgba(255,255,255,0.85)\">\r\n Telepon: <a href=\"tel:085715322146\" class=\"footer-nav-link\">0857-1532-2146<\/a><br>\r\n Email: <a href=\"mailto:hello@pandaigadai.com\" class=\"footer-nav-link\">hello@pandaigadai.com<\/a>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n <div class=\"footer-bottom\">\r\n <div class=\"footer-bottom-inner\">\r\n <span>© Copyright PT Solusi Gadai Pintar 2026 All Rights Reserved<\/span>\r\n <div style=\"display:flex;align-items:center;gap:.75rem\">\r\n <a href=\"https:\/\/www.instagram.com\/pandaigadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Instagram\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"height:1rem;width:1rem\"><rect x=\"2\" y=\"2\" width=\"20\" height=\"20\" rx=\"5\" ry=\"5\"\/><path d=\"M16 11.37A4 4 0 1112.63 8 4 4 0 0116 11.37z\"\/><line x1=\"17.5\" y1=\"6.5\" x2=\"17.51\" y2=\"6.5\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.tiktok.com\/@pandaigadai.id\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"TikTok\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M19.59 6.69a4.83 4.83 0 01-3.77-4.25V2h-3.45v13.67a2.89 2.89 0 01-5.2 1.74 2.89 2.89 0 012.31-4.64 2.93 2.93 0 01.88.13V9.4a6.84 6.84 0 00-1-.05A6.33 6.33 0 005.8 20.1a6.34 6.34 0 0010.86-4.43V8.92a8.16 8.16 0 004.77 1.52V7A4.86 4.86 0 0119.59 6.69z\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.facebook.com\/pandaigadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"Facebook\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M24 12.073c0-6.627-5.373-12-12-12s-12 5.373-12 12c0 5.99 4.388 10.954 10.125 11.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007 1.792-4.669 4.533-4.669 1.312 0 2.686.235 2.686.235v2.953H15.83c-1.491 0-1.956.925-1.956 1.874v2.25h3.328l-.532 3.47h-2.796v8.385C19.612 23.027 24 18.062 24 12.073z\"\/><\/svg><\/a>\r\n <a href=\"https:\/\/www.youtube.com\/@PandaiGadai\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"YouTube\" class=\"social-link\"><svg viewBox=\"0 0 24 24\" fill=\"currentColor\" style=\"height:1rem;width:1rem\"><path d=\"M23.498 6.186a3.016 3.016 0 00-2.122-2.136C19.505 3.545 12 3.545 12 3.545s-7.505 0-9.377.505A3.017 3.017 0 00.502 6.186C0 8.07 0 12 0 12s0 3.93.502 5.814a3.016 3.016 0 002.122 2.136c1.871.505 9.376.505 9.376.505s7.505 0 9.377-.505a3.015 3.015 0 002.122-2.136C24 15.93 24 12 24 12s0-3.93-.502-5.814z\"\/><\/svg><\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<script>\r\n(function(){\r\n'use strict';\r\nvar $=function(id){return document.getElementById(id);};\r\n\r\n\/* ====== SETTINGS ====== *\/\r\nvar SHEET_ID='1nO3eIJ4b-ABN1oAKmh4hKs9KtlAdwFqy_uEk9PRQuiI';\r\nvar TAB_SUMMARY='SUMMARY';\r\nvar TARGET=15;\r\nvar WINDOW_SIZE=6;\r\nvar MASTER_SHEET_ID='1DV9BxMNuWo3z_U7qv7q-0js0iBrHIkw_T-PhK5wQhh0';\r\nvar TAB_MASTER='MASTER AM DAN NAMA CABANG ';\r\n\/* ====================== *\/\r\n\r\nvar LS='cv_dash_pg_v1';\r\nvar MONTH_MAP={jan:0,feb:1,mar:2,apr:3,may:4,jun:5,jul:6,aug:7,sep:8,oct:9,nov:10,dec:11};\r\n\r\nvar state={\r\n tab:'ringkasan', search:'', filterArea:'', filterAM:'', filterKaster:'',\r\n sortAM:{key:'pctBelow',dir:-1}, sortKaster:{key:'pctBelow',dir:-1}, sortCabang:{key:'branch',dir:1},\r\n branches:[], months:[]\r\n};\r\n\r\nfunction savePrefs(){try{localStorage.setItem(LS,JSON.stringify({tab:state.tab}));}catch(e){}}\r\nfunction loadPrefs(){try{var p=JSON.parse(localStorage.getItem(LS)||'{}');if(p.tab)state.tab=p.tab;}catch(e){}}\r\n\r\nfunction setStatus(m,c){var s=$('status');s.style.display='block';s.className='status '+(c||'info');s.innerHTML=m;}\r\nfunction esc(s){return String(s==null?'':s).replace(\/[&<>\"']\/g,function(c){return{'&':'&','<':'<','>':'>','\"':'"',\"'\":'''}[c];});}\r\nfunction nf(n){return isFinite(n)?Math.round(n).toLocaleString('id-ID'):'\u2014';}\r\n\r\nfunction parseCSV(text){var rows=[],row=[],cur='',i=0,q=false;while(i<text.length){var c=text[i];\r\n if(q){if(c==='\"'){if(text[i+1]==='\"'){cur+='\"';i++;}else q=false;}else cur+=c;}\r\n else{if(c==='\"')q=true;else if(c===','){row.push(cur);cur='';}else if(c==='\\n'){row.push(cur);rows.push(row);row=[];cur='';}else if(c==='\\r'){}else cur+=c;}\r\n i++;}\r\n if(cur.length||row.length){row.push(cur);rows.push(row);}return rows;}\r\n\r\nfunction cbucket(){return Math.floor(Date.now()\/300000);}\r\nfunction gvizUrl(tab){return 'https:\/\/docs.google.com\/spreadsheets\/d\/'+SHEET_ID+'\/gviz\/tq?tqx=out:csv&sheet='+encodeURIComponent(tab)+'&_cb='+cbucket();}\r\nfunction gvizUrlFor(sheetId,tab){return 'https:\/\/docs.google.com\/spreadsheets\/d\/'+sheetId+'\/gviz\/tq?tqx=out:csv&sheet='+encodeURIComponent(tab)+'&_cb='+cbucket();}\r\n\r\nfunction fetchCsv(url){return fetch(url,{credentials:'omit'}).then(function(r){\r\n if(!r.ok)throw new Error('HTTP '+r.status);var ct=r.headers.get('content-type')||'';return r.text().then(function(t){\r\n if(\/text\\\/html\/i.test(ct)||new RegExp('<'+'html','i').test(t.slice(0,200)))throw new Error('html\/blocked \u2014 cek sharing sheet');\r\n var rows=parseCSV(t);\r\n if(rows.length<1)throw new Error('sheet kosong');return rows;});});}\r\n\r\nfunction normName(s){return (s||'').toUpperCase().replace(\/^PANDAI\\s*GADAI\\s*\/,'').replace(\/[.,]\/g,'').replace(\/\\s+\/g,' ').trim();}\r\nfunction levenshtein(a,b){var m=a.length,n=b.length;if(!m)return n;if(!n)return m;\r\n var dp=Array.from({length:m+1},function(){return new Array(n+1).fill(0);});\r\n for(var i=0;i<=m;i++)dp[i][0]=i;for(var j=0;j<=n;j++)dp[0][j]=j;\r\n for(i=1;i<=m;i++)for(j=1;j<=n;j++)dp[i][j]=a[i-1]===b[j-1]?dp[i-1][j-1]:1+Math.min(dp[i-1][j],dp[i][j-1],dp[i-1][j-1]);\r\n return dp[m][n];}\r\nfunction findBestMatch(name,masterList){\r\n var n=normName(name);\r\n var exact=masterList.find(function(m){return m.norm===n;}); if(exact)return exact;\r\n var contain=masterList.find(function(m){return m.norm.indexOf(n)>=0||n.indexOf(m.norm)>=0;});\r\n if(contain&&Math.abs(contain.norm.length-n.length)<=6)return contain;\r\n var best=null,bestDist=999;\r\n masterList.forEach(function(m){var d=levenshtein(n,m.norm);if(d<bestDist){bestDist=d;best=m;}});\r\n if(best&&bestDist<=Math.max(2,Math.floor(n.length*0.2)))return best;\r\n return null;\r\n}\r\nfunction loadAreaMap(){\r\n return fetchCsv(gvizUrlFor(MASTER_SHEET_ID,TAB_MASTER)).then(function(rows){\r\n var master=rows.slice(1).filter(function(r){return r[2];}).map(function(r){\r\n return{area:r[0]||'',branch:r[2],norm:normName(r[2])};\r\n });\r\n return master;\r\n }).catch(function(){return [];});\r\n}\r\n\r\n\/* ---- deteksi kolom bulan otomatis dari header, format \"Mmm,YYYY\" atau \"Mmm,YY\" ---- *\/\r\nfunction parseMonthLabel(s){\r\n var m=String(s||'').trim().match(\/^([A-Za-z]{3,9}),\\s*(\\d{2,4})$\/);\r\n if(!m)return null;\r\n var mi=MONTH_MAP[m[1].toLowerCase().slice(0,3)];\r\n if(mi==null)return null;\r\n var y=parseInt(m[2],10);if(m[2].length===2)y+=2000;\r\n return{label:s.trim(),month:mi,year:y,sortKey:y*12+mi};\r\n}\r\n\r\nfunction findHeaderRow(rows){\r\n for(var r=0;r<Math.min(rows.length,10);r++){\r\n for(var c=0;c<rows[r].length;c++){\r\n if(String(rows[r][c]||'').trim().toLowerCase()==='branch')return r;\r\n }\r\n }\r\n return -1;\r\n}\r\n\r\nfunction ingest(rows,areaMap){\r\n var hr=findHeaderRow(rows);\r\n if(hr<0)throw new Error('Header row (kolom \"Branch\") gak ketemu di tab SUMMARY.');\r\n var header=rows[hr];\r\n var branchCol=-1,amCol=-1,kasterCol=-1;\r\n header.forEach(function(h,i){var v=String(h||'').trim().toLowerCase();\r\n if(v==='branch')branchCol=i; else if(v==='am')amCol=i; else if(v==='kaster')kasterCol=i;});\r\n if(branchCol<0)throw new Error('Kolom Branch gak ketemu.');\r\n\r\n var monthCols=[];\r\n header.forEach(function(h,i){var p=parseMonthLabel(h);if(p){p.col=i;monthCols.push(p);}});\r\n monthCols.sort(function(a,b){return a.sortKey-b.sortKey;});\r\n var windowCols=monthCols.slice(-WINDOW_SIZE);\r\n if(!windowCols.length)throw new Error('Kolom bulan (format \"Mmm,YYYY\") gak ketemu di header.');\r\n state.months=windowCols;\r\n\r\n var branches=[];\r\n for(var r=hr+1;r<rows.length;r++){\r\n var row=rows[r];if(!row)continue;\r\n var branch=(row[branchCol]||'').trim();if(!branch)continue;\r\n var am=amCol>=0?(row[amCol]||'').trim():'';\r\n var kaster=kasterCol>=0?(row[kasterCol]||'').trim():'';\r\n var vals={};var sum=0,cnt=0;\r\n windowCols.forEach(function(mc){\r\n var raw=(row[mc.col]||'').trim();\r\n var v=raw===''?null:parseFloat(raw);\r\n if(v!=null&&!isNaN(v)){vals[mc.label]=v;sum+=v;cnt++;}else{vals[mc.label]=null;}\r\n });\r\n var areaMatch=areaMap&&areaMap.length?findBestMatch(branch,areaMap):null;\r\n branches.push({branch:branch,am:am,kaster:kaster,area:areaMatch?areaMatch.area:'',vals:vals,avg:cnt?(sum\/cnt):null,hasData:cnt>0});\r\n }\r\n state.branches=branches;\r\n}\r\n\r\nfunction load(){\r\n setStatus('Memuat data dari Google Sheet\u2026','info');\r\n Promise.all([fetchCsv(gvizUrl(TAB_SUMMARY)),loadAreaMap()]).then(function(res){\r\n ingest(res[0],res[1]);\r\n $('tabs').style.display='flex';\r\n renderFilterOptions();\r\n var withData=state.branches.filter(function(b){return b.hasData;}).length;\r\n var mlabel=state.months.map(function(m){return m.label;}).join(', ');\r\n var noArea=state.branches.filter(function(b){return !b.area;}).length;\r\n setStatus('\u2713 Termuat '+state.branches.length+' cabang. Window bulan terdeteksi: <b>'+esc(mlabel)+'<\/b>. '+withData+' cabang punya data di rentang ini.'+(noArea?(' '+noArea+' cabang gak ke-match Area (nama beda jauh dari master).'):'')+' Tab SUMMARY diupdate manual (bukan real-time), jadi cek juga spreadsheet asli kalau ragu ke-update-annya.','ok');\r\n $('window-label').textContent='Menampilkan '+state.months.length+' bulan terakhir yang terdeteksi otomatis dari header sheet';\r\n render();\r\n }).catch(function(err){\r\n setStatus('Gagal memuat data. Pastikan sheet sharing \"Anyone with link \u2013 Viewer\". ('+esc(String(err&&err.message||err))+')','err');\r\n });\r\n}\r\n\r\nfunction render(){\r\n syncTabs();\r\n renderScorecards();\r\n renderHeatmap();\r\n renderAMTable();\r\n renderKasterTable();\r\n renderCabangTable();\r\n $('footer-note').style.display='block';\r\n $('footer-note').innerHTML=filteredBranches().length+' dari '+state.branches.length+' cabang tampil \u2022 window '+state.months.length+' bulan \u2022 diperbarui '+new Date().toLocaleString('id-ID');\r\n}\r\n\r\nfunction filteredBranches(){\r\n var q=state.search.toUpperCase();\r\n return state.branches.filter(function(b){\r\n if(q&&b.branch.toUpperCase().indexOf(q)<0)return false;\r\n if(state.filterArea&&b.area!==state.filterArea)return false;\r\n if(state.filterAM&&b.am!==state.filterAM)return false;\r\n if(state.filterKaster&&b.kaster!==state.filterKaster)return false;\r\n return true;\r\n });\r\n}\r\n\r\nfunction renderFilterOptions(){\r\n var areas=Array.from(new Set(state.branches.map(function(b){return b.area;}).filter(Boolean))).sort();\r\n var ams=Array.from(new Set(state.branches.map(function(b){return b.am;}).filter(Boolean))).sort();\r\n var kasters=Array.from(new Set(state.branches.map(function(b){return b.kaster;}).filter(Boolean))).sort();\r\n function fill(id,opts,allLabel){\r\n var sel=$(id);var cur=sel.value;\r\n sel.innerHTML='<option value=\"\">'+allLabel+'<\/option>'+opts.map(function(o){return '<option value=\"'+esc(o)+'\">'+esc(o)+'<\/option>';}).join('');\r\n sel.value=cur;\r\n }\r\n fill('sel-area',areas,'Semua Area');\r\n fill('sel-am',ams,'Semua AM');\r\n fill('sel-kaster',kasters,'Semua KASTER');\r\n}\r\n\r\nfunction syncTabs(){\r\n var tabs=document.querySelectorAll('#tabs button');\r\n for(var i=0;i<tabs.length;i++)tabs[i].classList.toggle('active',tabs[i].getAttribute('data-tab')===state.tab);\r\n ['ringkasan','am','cabang'].forEach(function(p){var el=$('pane-'+p);if(el)el.style.display=(state.tab===p)?'block':'none';});\r\n}\r\n\r\nfunction latestMonth(){return state.months[state.months.length-1];}\r\n\r\n\/* ---------------- TAB: RINGKASAN ---------------- *\/\r\nfunction renderScorecards(){\r\n var lm=latestMonth();if(!lm)return;\r\n var total=filteredBranches().length,capai=0,belowT=0,noData=0,sum=0,cnt=0;\r\n filteredBranches().forEach(function(b){\r\n var v=b.vals[lm.label];\r\n if(v==null)noData++;\r\n else{if(v>=TARGET)capai++;else belowT++;sum+=v;cnt++;}\r\n });\r\n var avgNet=cnt?(sum\/cnt):null;\r\n $('scorecards').innerHTML=\r\n '<div class=\"sc\"><div class=\"lbl\">Total Cabang<\/div><div class=\"val\">'+nf(total)+'<\/div><div class=\"sub\">di roster SUMMARY<\/div><\/div>'+\r\n '<div class=\"sc green\"><div class=\"lbl\">Capai Target<\/div><div class=\"val\">'+nf(capai)+'<\/div><div class=\"sub\">'+esc(lm.label)+', ≥ '+TARGET+'x<\/div><\/div>'+\r\n '<div class=\"sc red\"><div class=\"lbl\">Di Bawah Target<\/div><div class=\"val\">'+nf(belowT)+'<\/div><div class=\"sub\">'+esc(lm.label)+', < '+TARGET+'x<\/div><\/div>'+\r\n '<div class=\"sc amber\"><div class=\"lbl\">Belum Ada Data<\/div><div class=\"val\">'+nf(noData)+'<\/div><div class=\"sub\">'+esc(lm.label)+'<\/div><\/div>'+\r\n '<div class=\"sc accent\"><div class=\"lbl\">Rata-rata Network<\/div><div class=\"val\">'+(avgNet!=null?avgNet.toFixed(1):'\u2014')+'<\/div><div class=\"sub\">'+esc(lm.label)+'<\/div><\/div>';\r\n}\r\n\r\nfunction renderHeatmap(){\r\n $('heat-sub').textContent=state.months.map(function(m){return m.label;}).join(' \u00b7 ');\r\n var th=$('heat-thead');\r\n var h='<th class=\"stick l\">Cabang<\/th><th class=\"l\">AM<\/th>';\r\n state.months.forEach(function(m){h+='<th class=\"c\">'+esc(m.label)+'<\/th>';});\r\n th.innerHTML=h;\r\n var tb=$('heat-tbody');\r\n if(!filteredBranches().length){tb.innerHTML='<tr><td colspan=\"'+(2+state.months.length)+'\" class=\"muted\" style=\"padding:1rem;text-align:center\">Gak ada cabang yang cocok filter.<\/td><\/tr>';return;}\r\n tb.innerHTML=filteredBranches().map(function(b){\r\n var cells=state.months.map(function(m){\r\n var v=b.vals[m.label];\r\n if(v==null)return '<td class=\"c cell-blank\">\u00b7<\/td>';\r\n var cls=v<TARGET?'cell-red':'cell-ok';\r\n return '<td class=\"c '+cls+'\">'+nf(v)+'<\/td>';\r\n }).join('');\r\n return '<tr><td class=\"stick l branch\">'+esc(b.branch)+'<\/td><td class=\"l muted\">'+esc(b.am||'\u2014')+'<\/td>'+cells+'<\/tr>';\r\n }).join('');\r\n}\r\n\r\n\/* ---------------- TAB: AM & KASTER ---------------- *\/\r\nfunction groupAgg(keyFn){\r\n var groups={};\r\n var lm=latestMonth();\r\n filteredBranches().forEach(function(b){\r\n var key=keyFn(b)||'(Tanpa data)';\r\n if(!groups[key])groups[key]={label:key,total:0,capai:0,below:0,noData:0,sumAvg:0,cntAvg:0};\r\n var g=groups[key];g.total++;\r\n var v=lm?b.vals[lm.label]:null;\r\n if(v==null)g.noData++; else if(v>=TARGET)g.capai++; else g.below++;\r\n if(b.avg!=null){g.sumAvg+=b.avg;g.cntAvg++;}\r\n });\r\n return Object.keys(groups).map(function(k){\r\n var g=groups[k];\r\n var denomForPct=g.total-g.noData;\r\n g.pctBelow=denomForPct?Math.round(g.below\/denomForPct*100):0;\r\n g.avgOverall=g.cntAvg?(g.sumAvg\/g.cntAvg):null;\r\n return g;\r\n });\r\n}\r\n\r\nvar GROUPCOLS=[{k:'label',t:'Nama',l:true,s:true},{k:'total',t:'Jumlah Cabang',s:true},{k:'capai',t:'Capai Target',s:true},\r\n {k:'below',t:'Di Bawah Target',s:true},{k:'noData',t:'Belum Ada Data',s:true},{k:'pctBelow',t:'% Di Bawah Target',s:true},{k:'avgOverall',t:'Rata-rata',s:true}];\r\n\r\nfunction renderGroupTable(rows,sortState,theadId,tbodyId,labelHead,onSortChange){\r\n var sk=sortState.key,sd=sortState.dir;\r\n rows=rows.slice().sort(function(a,b){var x=a[sk],y=b[sk];\r\n if(x==null)x=sk==='avgOverall'?-1:0; if(y==null)y=sk==='avgOverall'?-1:0;\r\n if(typeof x==='string')return sd*x.localeCompare(y);return sd*(x-y);});\r\n var th=$(theadId);th.innerHTML='';\r\n GROUPCOLS.forEach(function(c){\r\n var el=document.createElement('th');\r\n var label=c.k==='label'?labelHead:c.t;\r\n el.textContent=label+(sortState.key===c.k?(sd<0?' \u25bc':' \u25b2'):'');\r\n el.className=(c.l?'l':'')+(sortState.key===c.k?' sorted':'');\r\n el.onclick=function(){if(sortState.key===c.k)sortState.dir*=-1;else{sortState.key=c.k;sortState.dir=(c.k==='label')?1:-1;}onSortChange();};\r\n th.appendChild(el);\r\n });\r\n var tb=$(tbodyId);\r\n if(!rows.length){tb.innerHTML='<tr><td colspan=\"7\" class=\"muted\" style=\"padding:1rem;text-align:center\">Belum ada data.<\/td><\/tr>';return;}\r\n tb.innerHTML=rows.map(function(r){\r\n var pc=r.pctBelow>=30?'style=\"color:var(--destructive);font-weight:800\"':(r.pctBelow>0?'style=\"color:#b45309;font-weight:700\"':'class=\"muted\"');\r\n return '<tr><td class=\"l branch\">'+esc(r.label)+'<\/td>'+\r\n '<td style=\"font-weight:700\">'+nf(r.total)+'<\/td>'+\r\n '<td style=\"color:var(--success);font-weight:700\">'+nf(r.capai)+'<\/td>'+\r\n '<td style=\"color:var(--destructive);font-weight:800\">'+nf(r.below)+'<\/td>'+\r\n '<td class=\"muted\">'+nf(r.noData)+'<\/td>'+\r\n '<td '+pc+'>'+r.pctBelow+'%<\/td>'+\r\n '<td style=\"font-weight:700\">'+(r.avgOverall!=null?r.avgOverall.toFixed(1):'\u2014')+'<\/td><\/tr>';\r\n }).join('');\r\n}\r\n\r\nfunction renderAMTable(){\r\n var lm=latestMonth();\r\n $('am-sub').textContent=lm?('status '+lm.label+' \u00b7 rata-rata dari seluruh window'):'';\r\n renderGroupTable(groupAgg(function(b){return b.am;}),state.sortAM,'am-thead','am-tbody','Area Manager',renderAMTable);\r\n}\r\nfunction renderKasterTable(){\r\n var lm=latestMonth();\r\n $('kaster-sub').textContent=lm?('status '+lm.label+' \u00b7 rata-rata dari seluruh window'):'';\r\n renderGroupTable(groupAgg(function(b){return b.kaster;}),state.sortKaster,'kaster-thead','kaster-tbody','KASTER',renderKasterTable);\r\n}\r\n\r\n\/* ---------------- TAB: DETAIL CABANG ---------------- *\/\r\nfunction renderCabangTable(){\r\n var filtered=filteredBranches();\r\n $('cabang-sub').textContent=filtered.length+' cabang';\r\n\r\n var sk=state.sortCabang.key,sd=state.sortCabang.dir;\r\n filtered=filtered.slice().sort(function(a,b){\r\n var x,y;\r\n if(sk==='branch'||sk==='am'||sk==='kaster'){x=(a[sk]||'').toString();y=(b[sk]||'').toString();return sd*x.localeCompare(y);}\r\n if(sk==='avg'){x=a.avg==null?-1:a.avg;y=b.avg==null?-1:b.avg;return sd*(x-y);}\r\n \/\/ sort by a specific month label\r\n x=a.vals[sk]==null?-1:a.vals[sk];y=b.vals[sk]==null?-1:b.vals[sk];return sd*(x-y);\r\n });\r\n\r\n var th=$('cabang-thead');\r\n var cols=[{k:'branch',t:'Cabang',l:true},{k:'area',t:'Area',l:true},{k:'am',t:'AM',l:true},{k:'kaster',t:'KASTER',l:true}]\r\n .concat(state.months.map(function(m){return{k:m.label,t:m.label,c:true};}))\r\n .concat([{k:'avg',t:'Rata-rata',c:true,avgCol:true}]);\r\n th.innerHTML=cols.map(function(c){\r\n var cls=(c.l?'l':(c.c?'c':''))+(state.sortCabang.key===c.k?' sorted':'')+(c.avgCol?' avg-col':'');\r\n return '<th class=\"'+cls+'\" data-k=\"'+c.k+'\">'+esc(c.t)+(state.sortCabang.key===c.k?(sd<0?' \u25bc':' \u25b2'):'')+'<\/th>';\r\n }).join('');\r\n th.querySelectorAll('th').forEach(function(el){\r\n el.onclick=function(){var k=el.getAttribute('data-k');if(state.sortCabang.key===k)state.sortCabang.dir*=-1;else{state.sortCabang.key=k;state.sortCabang.dir=1;}renderCabangTable();};\r\n });\r\n\r\n var tb=$('cabang-tbody');\r\n if(!filtered.length){tb.innerHTML='<tr><td colspan=\"'+cols.length+'\" class=\"muted\" style=\"padding:1rem;text-align:center\">Gak ada cabang yang cocok.<\/td><\/tr>';return;}\r\n tb.innerHTML=filtered.map(function(b){\r\n var monthCells=state.months.map(function(m){\r\n var v=b.vals[m.label];\r\n if(v==null)return '<td class=\"c cell-blank\">\u00b7<\/td>';\r\n var cls=v<TARGET?'cell-red':'cell-ok';\r\n return '<td class=\"c '+cls+'\">'+nf(v)+'<\/td>';\r\n }).join('');\r\n return '<tr><td class=\"stick l branch\">'+esc(b.branch)+'<\/td><td class=\"l muted\">'+esc(b.area||'\u2014')+'<\/td><td class=\"l\">'+(b.am?esc(b.am):'<span class=\"muted\">\u2014<\/span>')+'<\/td><td class=\"l muted\">'+esc(b.kaster||'\u2014')+'<\/td>'+\r\n monthCells+'<td class=\"c avg-col\">'+(b.avg!=null?b.avg.toFixed(1):'\u2014')+'<\/td><\/tr>';\r\n }).join('');\r\n}\r\n\r\nwindow.CV={\r\n load:load,\r\n setTab:function(t){state.tab=t;savePrefs();syncTabs();},\r\n setSearch:function(v){state.search=v;render();},\r\n setFilter:function(field,value){state['filter'+field.charAt(0).toUpperCase()+field.slice(1)]=value;render();}\r\n};\r\n\r\nloadPrefs();load();\r\n})();\r\n<\/script>\r\n<\/body>\r\n<\/html>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"unboxed","site-sidebar-style":"unboxed","ast-global-header-display":"disabled","ast-banner-title-visibility":"disabled","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"disabled","ast-disable-related-posts":"disabled","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-2960","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Julia Afildah","author_link":"https:\/\/pandaigadai.com\/blog\/author\/julia-afildah\/"},"uagb_comment_info":0,"uagb_excerpt":null,"_links":{"self":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/comments?post=2960"}],"version-history":[{"count":1,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960\/revisions"}],"predecessor-version":[{"id":2961,"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/pages\/2960\/revisions\/2961"}],"wp:attachment":[{"href":"https:\/\/pandaigadai.com\/blog\/wp-json\/wp\/v2\/media?parent=2960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}