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/sipppnmandailing/public_html/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/sipppnmandailing/public_html/system/core/Exceptions.php:186)
Filename: core/Common.php
Line Number: 441
Error Number: 1300
Invalid utf8mb3 character string: '7\xAC'
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 (7¬"9·Þ Filename: /home/sipppnmandailing/public_html/models/perkara/perkara_m.php Line Number: 216