Severity: Notice
Message: Undefined offset: 1
Filename: controllers/list_perkara.php
Line Number: 195
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/pnposogo/public_html/sipp/system/core/Exceptions.php:186)
Filename: libraries/Session.php
Line Number: 689
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/pnposogo/public_html/sipp/system/core/Exceptions.php:186)
Filename: core/Common.php
Line Number: 441
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?\0018?S? SELECT
SQL_CALC_FOUND_ROWS
IDPerkara,
klasifikasiPerkara,
jenisPerkara,
statusAkhir,
noPerkara,
tglPendaftaran,
pihakPertama,
pihakKedua,
(CASE
WHEN IDProses<220 THEN DATEDIFF(CURDATE(),tglPendaftaran)-IFNULL(med.durasi_mediasi,0)
ELSE DATEDIFF(tglPutusan,tglPendaftaran)-IFNULL(med.durasi_mediasi,0)END
)AS durasi
FROM dataumumweb
LEFT JOIN (SELECT IDPerkara AS id_perkara, SUM(DATEDIFF(IF(tglLaporan IS NULL,NOW(),tglLaporan),tglMulaiMediasi)) AS durasi_mediasi FROM mediasiweb WHERE IDTahapan = 10 GROUP BY IDPerkara) AS med ON dataumumweb.IDPerkara = med.id_perkara
WHERE klasifikasiPerkara IN (5ŠS‚ Filename: /home/pnposogo/public_html/sipp/models/perkara/perkara_m.php Line Number: 215