Severity: Notice
Message: Undefined offset: 0
Filename: generete/Excel_spm.php
Line Number: 132
Backtrace:
File: /home/phicosdev/projects/surakarta/solodata/application/controllers/generete/Excel_spm.php
Line: 132
Function: _error_handler
File: /home/phicosdev/projects/surakarta/solodata/application/controllers/generete/Excel_spm.php
Line: 22
Function: getData
File: /home/phicosdev/projects/surakarta/solodata/index.php
Line: 294
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/phicosdev/projects/surakarta/solodata/system/core/Exceptions.php:271)
Filename: core/Common.php
Line Number: 570
Backtrace:
File: /home/phicosdev/projects/surakarta/solodata/application/controllers/generete/Excel_spm.php
Line: 144
Function: get
File: /home/phicosdev/projects/surakarta/solodata/application/controllers/generete/Excel_spm.php
Line: 22
Function: getData
File: /home/phicosdev/projects/surakarta/solodata/index.php
Line: 294
Function: require_once
Error Number: 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 ') ORDER BY `a`.`id` ASC, `b`.`id` ASC' at line 6
SELECT `a`.`nama_indikator`, `a`.`keterangan`, `b`.*, `c`.`total_dilayani`, `c`.`total_terlayani`, `d`.`dilayani`, `d`.`terlayani` FROM `spm_indikator` `a` JOIN `spm_elemen_data` `b` ON `a`.`id` = `b`.`id_indikator` LEFT JOIN `spm_indikator_isian` `c` ON `a`.`id` = `c`.`id_indikator` AND `c`.`tahun` = 2021 LEFT JOIN `spm_elemen_isian` `d` ON `b`.`id` = `d`.`id_elemen` AND `d`.`tahun` = 2021 JOIN `spm_plotting_bidang` `e` ON `e`.`id_bidang` = `a`.`id_bidang` AND `e`.`id_opd` IN () ORDER BY `a`.`id` ASC, `b`.`id` ASC
Filename: controllers/generete/Excel_spm.php
Line Number: 144