LAPOR

array(4) { ["code"]=> int(500) ["message"]=> string(1318) "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) as data group by IF(status = 'late', 'Terlambat >3 hari', 'Tepat Wa' at line 9 (SQL: select IF(status = 'late', 'Terlambat >3 hari', 'Tepat Waktu <=3 hari') as label, sum(total) as total, sum(sum_verified_days) as hari from (SELECT status, sum_verified_days, created_at, disposition_id, total, disposition_type_id, disposition_name, disposition_alias, disposition_type FROM lapor_warehouse.report_by_verification_disposition WHERE disposition_id IN (15803, 15804, 16683, 121469, 135643, 135644, 135645, 135646, 135647, 135648, 135649, 135650, 135651, 135652, 135653, 135689, 135692, 135784, 135785, 135786, 135787, 135788, 135789, 135790, 135791, 135792, 135793, 135794, 135963, 157020, 157021, 157022, 157023, 157024, 157025, 157026, 157027, 157028, 157029, 157030, 157032, 157034, 157058, 157059, 157064, 166420, 12974, 12974) AND created_at BETWEEN '2025-01-01' AND '2025-12-31' AND disposition_id IS NOT NULL AND disposition_id NOT IN () ) as data group by IF(status = 'late', 'Terlambat >3 hari', 'Tepat Waktu <=3 hari'))" ["error_code"]=> string(11) "error_query" ["status"]=> bool(false) } LAPOR

#content-wrapper, #footer-wrapper { display: none } body, html { overflow: hidden } /* Noscript Popup by igniel.com */ #ignielNoscript { background: rgba(0, 0, 0, 0.85); padding: 0; position: fixed; bottom: 0; left: 0; top: -100px; right: 0; z-index: 1000; opacity: 1; visibility: visible; height: auto; } #ignielNoscript svg { width: 100px; height: 100px } #ignielNoscript svg path { fill: #fff } #ignielNoscript .isiNoscript { background: #008c5f; color: #fff; position: absolute; text-align: center; padding: 0 30px 30px 30px; margin: auto; top: 30%; left: 0; right: 0; font-size: 1.5rem; font-weight: 400; line-height: 1.5em; font-family: monospace; max-width: 670px; box-shadow: 0 20px 10px -10px rgba(0, 0, 0, 0.15); border: 15px solid rgba(0, 0, 0, .07); overflow: hidden; transition: all .6s cubic-bezier(.25, .8, .25, 1); -webkit-transform: translateZ(0); transform: translateZ(0); backface-visibility: visible; transition: all .2s ease-in-out, visibility 0s; transform-origin: bottom center; pointer-events: auto; transform: rotateX(0deg) rotateY(0deg) rotateZ(0deg) scale(1); opacity: 1; animation: ignielWobble .5s; -moz-animation: ignielWobble .5s; -webkit-animation: ignielWobble .5s; -o-animation: ignielWobble .5s } #ignielNoscript .isiNoscript:hover { box-shadow: 0 20px 10px -10px rgba(0, 0, 0, 0.2); } #ignielNoscript .isiNoscript h4, #ignielNoscript .isiNoscript .judul { display: inline-block; background: rgba(0, 0, 0, .07); padding: 5px 25px 15px 25px; font-size: 2.2rem; font-weight: 600; margin-bottom: 20px }