You must have JavaScript enabled in order to use this theme. Please enable JavaScript and then reload this page in order to continue.
Logo Kalurahan Sendangsari

Memuat....

Aplikasi Sistem Informasi Kalurahan Sendangsari

Sekilas Info

Kembali

R. SUGIYONO

R. SUGIYONO
Jabatan : Dukuh Mrunggi
SK : Nomor 23 Tahun 2008
Masa Kerja :
Alamat : Mrunggi Rt. 25, Kalurahan Sendangsari, Kapanewon Pengasih, Kabupaten Kulonprogo, Provinsi DI Yogyakarta, Indonesia, 55652.
WA : R. SUGIYONO

Kehadiran

Bulan Sebelumnya Bulan Selanjutnya
  • CodeIgniter

    CodeIgniter version : 3.1.13

    CodeIgniter documentation

    DevelBar version : 1.2.2

    PHP version : 7.4.33

    Default language : Indonesia

  • Benchmarks 0.1774 sec

    Loading Time: Base Classes : 0.0016 sec

    Controller Execution Time ( Task / List Tukin ) : 0.1542 sec

  • Memory usage 5.01MB
  • Request Request : task/list_tukin

    Method : GET

  • Database Database
    Host:10.104.0.2/sid_sendangsari

    SHOW TABLES FROM `sid_sendangsari` 0.0030 sec


    SELECT `id`, `value` FROM `setting_aplikasi` WHERE `key` = 'url_aplikasi_publik' LIMIT 1 0.0006 sec


    SELECT * FROM `setting_aplikasi` ORDER BY `key` 0.0006 sec


    SHOW DATABASES 0.0012 sec


    SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'sid_sendangsari' AND table_name = 'user' 0.0006 sec


    SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa FROM `config` `c` LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id` LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id` 0.0009 sec


    select * from ( SELECT `p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`, `p`.`is_wilayah`, `p`.`is_absen_hp`, IFNULL(p.`pamong_masajab`,'-') AS `masajab`, `pen`.`nama` AS `nama`, `p`.`jabatan` AS `jabatan`, `p`.`id_pend` AS `id_pend`, `pen`.`nik` AS `nik`, `p`.`pamong_niap` AS `kode`, `pen`.`telepon` AS `telepon`, `p`.`urut` AS `urut`, IFNULL(`pen`.`telegram`,'-') AS `telegram`, IFNULL(`u`.`id`,'0') AS `id_user`, IFNULL(CONCAT('https://sendangsari.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://sendangsari.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto` FROM `tweb_desa_pamong` `p` LEFT JOIN `tweb_penduduk` `pen` ON `p`.`id_pend` = `pen`.`id` LEFT JOIN `user` as `u` ON `p`.`pamong_id`=`u`.`pamong_id` WHERE 1 and`p`.`pamong_status` = '1' order by urut asc ) as p left join ( select h.`kode`,p.`is_wilayah`,h.`foto` as `gambar`, MIN( CASE WHEN CAST(h.checktime AS TIME) BETWEEN IF(p.is_wilayah = 0, jam.jam_masuk - INTERVAL jam.boleh_absen MINUTE, jam.jam_masuk_wilayah - INTERVAL jam.boleh_absen MINUTE) AND IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah) THEN CAST(h.checktime AS TIME) WHEN CAST(h.checktime AS TIME) > IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah) THEN CAST(h.checktime AS TIME) ELSE NULL END ) AS jam_masuk, MAX( CASE WHEN CAST(h.checktime AS TIME) BETWEEN IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah) AND IF(p.is_wilayah = 0, jam.jam_keluar + INTERVAL jam.boleh_absen_pulang MINUTE, jam.jam_keluar_wilayah + INTERVAL jam.boleh_absen_pulang MINUTE ) THEN CAST(h.checktime AS TIME) ELSE NULL END ) AS jam_keluar, CASE WHEN TIMEDIFF(CAST(MIN(h.checktime) AS TIME), IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah)) < '00:00:00' THEN '00:00:00' ELSE TIMEDIFF(CAST(MIN(h.checktime) AS TIME), IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah)) END AS terlambat, CASE WHEN TIMEDIFF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), CAST(MAX(h.checktime) AS TIME)) < '00:00:00' THEN '00:00:00' ELSE TIMEDIFF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), CAST(MAX(h.checktime) AS TIME)) END AS duluan, TIMEDIFF(CAST(MAX(h.checktime) AS TIME), CAST(MIN(h.checktime) AS TIME)) AS waktu_kerja from ( select c.`userid` as kode, c.`checktime`,c.`koordinat`, c.`image` as foto from `checkinout` as c where date(c.`checktime`)= '2026-10-01' ) as h left join `tweb_desa_pamong` as p on h.kode=p.`pamong_niap` left join `kehadiran_jam_kerja` as jam on jam.`id`=dayofweek(h.`checktime`) group by h.`kode` ) as d on d.kode = p.kode order by d.jam_masuk desc 0.0004 sec


    SELECT COUNT(*) AS jumlah FROM v_agenda_all AS v WHERE v.`id_desa_pamong`='' and v.id_status<'2' limit 1 0.0102 sec


    SHOW COLUMNS FROM `checkinout_activity` 0.0011 sec


    SELECT SUM(IF(l.`tanggal` IS NOT NULL, 0, k.`status`)) as total FROM `a_calendar` AS a LEFT JOIN `kehadiran_jam_kerja` AS k ON DAYOFWEEK(a.`tanggal`) = k.`id` LEFT JOIN `kehadiran_hari_libur` AS l ON a.`tanggal` = l.`tanggal` WHERE 1 AND YEAR(a.tanggal) = '2026' AND MONTH(a.tanggal) = '2220' 0.0012 sec


    SELECT t.* FROM ( SELECT CONCAT(REPLACE(c.`tanggal`, '-', ''), p.`pamong_id`) AS id, c.`tanggal`, k.`nama_hari`, p.`pamong_id`, p.`jabatan`, IFNULL(p.`foto`, pend.`foto`) AS foto, pend.`telepon`, kap.`keterangan` AS keterangan, IFNULL(lb.`poin`,0) AS poin_berita, IFNULL(ls.`poin`,0) AS poin_surat, IFNULL(ps.`poin`,0) AS poin_status, IFNULL(pa.`poin`,0) AS poin_actifity, IFNULL(dispo_masuk.`poin`,0) AS poin_dispo_masuk, IFNULL(dispo_tugas.`poin`,0) AS poin_dispo_tugas, IFNULL(dispo_keluar.`poin`,0) AS poin_dispo_keluar, IFNULL(dispo_masuk.`poin`,0)+IFNULL(dispo_tugas.`poin`,0)+IFNULL(dispo_keluar.`poin`,0) as poin_dispo, IFNULL(j.`tunjangan`,0) AS tunjangan, j.`poin`, round((40/60)*IFNULL(j.`poin`,0),2) as max_poin_dispo, round((10/60)*IFNULL(j.`poin`,0),2) as max_poin_berita, round((10/60)*IFNULL(j.`poin`,0),2) as max_poin_surat, round((50/60)*IFNULL(j.`poin`,0),2) as max_poin_status, round((20/60)*IFNULL(j.`poin`,0),2) as max_poin_actifity, (60/100 * IFNULL(j.`tunjangan`,0)) as max_tunjangan_kinerja, IFNULL(p.`pamong_nama`, pend.nama) AS pamong_nama, IFNULL(k2.jam_masuk, IF(p.is_wilayah = 0, k.jam_masuk, k.jam_masuk_wilayah)) AS jadwal_masuk, DATE_SUB( IFNULL(k2.jam_masuk, IF(p.is_wilayah = 0, k.jam_masuk, k.jam_masuk_wilayah)), INTERVAL IFNULL(k2.boleh_absen, k.boleh_absen) MINUTE ) AS jadwal_boleh_masuk, DATE_ADD( IFNULL(k2.jam_keluar, IF(p.is_wilayah = 0, k.jam_keluar, k.jam_keluar_wilayah)), INTERVAL IFNULL(k2.boleh_absen_pulang, k.boleh_absen_pulang) MINUTE ) AS jadwal_boleh_keluar, IFNULL(k2.jam_keluar, IF(p.is_wilayah = 0, k.jam_keluar, k.jam_keluar_wilayah)) AS jadwal_keluar, MIN( CASE WHEN TIME(h.checktime) BETWEEN DATE_SUB(IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)), INTERVAL IFNULL(k2.boleh_absen, k.boleh_absen) MINUTE) AND IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)) THEN TIME(h.checktime) WHEN TIME(h.checktime) > IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)) THEN TIME(h.checktime) ELSE NULL END ) AS jam_masuk, CASE WHEN COUNT(h.checktime) <= 1 THEN NULL WHEN TIME(MIN(h.checktime)) = TIME(MAX(h.checktime)) THEN NULL ELSE TIME(MAX(h.checktime)) END AS jam_keluar, CASE WHEN TIMEDIFF(TIME(MIN(h.checktime)), IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah))) < '00:00:00' THEN '00:00:00' ELSE TIMEDIFF(TIME(MIN(h.checktime)), IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah))) END AS terlambat, CASE WHEN TIMEDIFF(IFNULL(k2.jam_keluar, IF(p.is_wilayah=0,k.jam_keluar,k.jam_keluar_wilayah)), TIME(MAX(h.checktime))) < '00:00:00' THEN '00:00:00' ELSE TIMEDIFF(IFNULL(k2.jam_keluar, IF(p.is_wilayah=0,k.jam_keluar,k.jam_keluar_wilayah)), TIME(MAX(h.checktime))) END AS duluan, TIMEDIFF(TIME(MAX(h.checktime)), TIME(MIN(h.checktime))) AS waktu_kerja, CASE WHEN k.status = 0 THEN 0 WHEN l.tanggal IS NOT NULL THEN 0 ELSE 1 END AS is_kerja, CASE WHEN k.status = 0 THEN 'Libur' WHEN l.tanggal IS NOT NULL THEN CONCAT('Libur Nasional: ', l.keterangan) WHEN kat.nama IS NOT NULL THEN kat.nama WHEN h.checktime IS NULL THEN 'Belum Absen' WHEN TIME(MIN(h.checktime)) > IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)) THEN 'Terlambat' ELSE 'Hadir' END AS status_kehadiran, kat.nama AS alasan, CASE WHEN MIN(h.checktime) IS NULL THEN 0 WHEN TIME(MIN(h.checktime)) <= IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)) THEN 1 ELSE 0 END AS tukin_masuk, CASE WHEN MAX(h.checktime) IS NULL THEN 0 WHEN TIME(MAX(h.checktime)) >= IFNULL(k2.jam_keluar, IF(p.is_wilayah=0,k.jam_keluar,k.jam_keluar_wilayah)) THEN 1 ELSE 0 END AS tukin_keluar, DATE_ADD( IFNULL(k2.jam_masuk, IF(p.is_wilayah=0,k.jam_masuk,k.jam_masuk_wilayah)), INTERVAL IFNULL(k2.boleh_absen, k.boleh_absen) MINUTE ) AS syarat_tukin_pulang, IFNULL(kat.denda,0)/100 AS ijin, -- Variabel PHP yang sudah dihitung di awal menggantikan Subquery lambat 1 AS jumlah_hari_kerja, ((40 / 100) * IFNULL(j.`tunjangan`,0)) / (1 * 2) AS tukin_presensi FROM (SELECT a.`tanggal` FROM `a_calendar` a WHERE 1 AND YEAR(a.tanggal) = '2026' AND MONTH(a.tanggal) = '2220' ) c CROSS JOIN `tweb_desa_pamong` p LEFT JOIN `tweb_penduduk` AS pend ON p.id_pend = pend.id LEFT JOIN `kehadiran_jam_kerja_periode` k2 ON k2.id = ( SELECT kjkp.id FROM `kehadiran_periode` kp_sub JOIN `kehadiran_jam_kerja_periode` kjkp ON kjkp.periode_id = kp_sub.id WHERE c.tanggal BETWEEN kp_sub.tanggal_mulai AND kp_sub.tanggal_selesai AND kp_sub.aktif = 1 AND kjkp.hari = DAYOFWEEK(c.tanggal) AND (kjkp.jabatan_id IS NULL OR kjkp.jabatan_id = p.jabatan_id) ORDER BY kjkp.jabatan_id DESC, kp_sub.id DESC LIMIT 1 ) LEFT JOIN `checkinout` h ON p.`pamong_niap` = h.`userid` COLLATE utf8_general_ci AND ( DATE(h.`checktime`) = c.`tanggal` OR (IFNULL(k2.lintas_hari,0) = 1 AND DATE(h.`checktime`) = DATE_ADD(c.`tanggal`, INTERVAL 1 DAY)) ) LEFT JOIN `kehadiran_jam_kerja` k ON DAYOFWEEK(c.`tanggal`) = k.`id` LEFT JOIN `kehadiran_att_keterangan_perangkat` kap ON kap.`kode_presensi` = p.`pamong_id` AND DATE(kap.`checktime`) = c.`tanggal` LEFT JOIN `kehadiran_att_keterangan` kat ON kap.`id_keterangan` = kat.`id_keterangan` LEFT JOIN `kehadiran_hari_libur` l ON c.`tanggal` = l.`tanggal` LEFT JOIN `ref_jabatan` AS j ON p.`jabatan_id` = j.`id` -- SUBQUERY LOG SURAT LEFT JOIN ( SELECT DATE(surat.tanggal) AS `cdate`, pamong_id, COUNT(surat.pamong_id) AS `poin` FROM ( SELECT l.`tanggal`, pa.`pamong_id` AS `pamong_id` FROM `log_surat` AS l LEFT JOIN `tweb_penduduk` AS p ON l.`id_pend` = p.`id` LEFT JOIN `tweb_wil_clusterdesa` AS c ON p.`id_cluster` = c.`id` LEFT JOIN `tweb_wil_clusterdesa` cc ON c.`dusun` = cc.`dusun` AND cc.`rt` = '0' AND cc.`rw` = '0' LEFT JOIN `tweb_penduduk` AS pp ON cc.`id_kepala` = pp.`id` LEFT JOIN `tweb_desa_pamong` AS pa ON pp.`id` = pa.`id_pend` WHERE 1 UNION ALL SELECT l.`tanggal`, l.`id_pamong` AS `pamong_id` FROM `log_surat` AS l WHERE 1 ) AS surat GROUP BY DATE(tanggal), pamong_id ) AS ls ON ls.pamong_id = p.`pamong_id` AND c.`tanggal` = ls.`cdate` -- SUBQUERY STATUS LEFT JOIN ( SELECT DATE(l.`waktu`) AS `cdate`, v.`pamong_id` AS pamong_id, sum(IFNULL(k.`poin`, 1)) AS `poin` FROM `tweb_desa_pamong_status` AS l LEFT JOIN ( SELECT `p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`, `p`.`is_wilayah`, `p`.`is_absen_hp`, IFNULL(p.`pamong_masajab`,'-') AS `masajab`, `pen`.`nama` AS `nama`, `p`.`jabatan` AS `jabatan`, `p`.`id_pend` AS `id_pend`, `pen`.`nik` AS `nik`, `p`.`pamong_niap` AS `kode`, `pen`.`telepon` AS `telepon`, `p`.`urut` AS `urut`, IFNULL(`pen`.`telegram`,'-') AS `telegram`, IFNULL(`u`.`id`,'0') AS `id_user`, IFNULL(CONCAT('https://sendangsari.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://sendangsari.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto` FROM `tweb_desa_pamong` `p` LEFT JOIN `tweb_penduduk` `pen` ON `p`.`id_pend` = `pen`.`id` LEFT JOIN `user` as `u` ON `p`.`pamong_id`=`u`.`pamong_id` WHERE 1 and`p`.`pamong_status` = '1' order by urut asc ) AS v ON l.`telepon` = v.`telepon` LEFT JOIN `klasifikasi_poin` AS k ON l.`id_poin` = k.`id` WHERE 1 GROUP BY v.`pamong_id`, DATE(l.`waktu`) ) AS ps ON ps.`pamong_id` = p.`pamong_id` AND c.`tanggal` = ps.`cdate` -- SUBQUERY ACTIVITY LEFT JOIN ( SELECT pamong_id, DATE(checktime) AS `cdate`, COUNT(DISTINCT CONCAT(pamong_id, DATE(checktime), HOUR(checktime))) AS `poin` FROM `checkinout_activity` WHERE 1 AND NOT (`activity` LIKE '%mobile%' OR `activity` LIKE 'Membuka SIDES Mobile%' OR `activity` LIKE 'Membuka % mobile aparatur%' OR `activity` LIKE 'membuka % surat keluar%') GROUP BY pamong_id, DATE(checktime) ) AS pa ON pa.`pamong_id` = p.`pamong_id` AND c.`tanggal` = pa.`cdate` -- SUBQUERY DISPO MASUK LEFT JOIN ( SELECT DATE(dispo.`waktu_update`) AS 'cdate', IFNULL(dispo.`id_desa_pamong`,0) AS `pamong_id`, SUM((IF(IFNULL(LENGTH(dispo.`keterangan`),0) > 15, 0.5, 0) * st.poin) + (IF(dispo.`link` IS NULL, 0, 0.5) * st.poin)) AS poin FROM `disposisi_surat_masuk` AS dispo LEFT JOIN `status_tugas` AS st ON dispo.`id_status` = st.`id` WHERE 1 GROUP BY dispo.`id_desa_pamong`, DATE(dispo.`waktu_update`) ) AS dispo_masuk ON dispo_masuk.`pamong_id` = p.`pamong_id` AND c.`tanggal` = dispo_masuk.`cdate` -- SUBQUERY DISPO TUGAS LEFT JOIN ( SELECT DATE(dispo.`waktu_update`) AS 'cdate', IFNULL(dispo.`id_desa_pamong`,0) AS `pamong_id`, SUM((IF(IFNULL(LENGTH(dispo.`keterangan`),0) > 15, 0.5, 0) * st.poin) + (IF(dispo.`link` IS NULL, 0, 0.5) * st.poin)) AS poin FROM `disposisi_surat_tugas` AS dispo LEFT JOIN `status_tugas` AS st ON dispo.`id_status` = st.`id` WHERE 1 GROUP BY dispo.`id_desa_pamong`, DATE(dispo.`waktu_update`) ) AS dispo_tugas ON dispo_tugas.`pamong_id` = p.`pamong_id` AND c.`tanggal` = dispo_tugas.`cdate` -- SUBQUERY DISPO KELUAR LEFT JOIN ( SELECT DATE(dispo.`waktu_update`) AS 'cdate', IFNULL(dispo.`id_desa_pamong`,0) AS `pamong_id`, SUM((IF(IFNULL(LENGTH(dispo.`keterangan`),0) > 15, 0.5, 0) * st.poin) + (IF(dispo.`link` IS NULL, 0, 0.5) * st.poin)) AS poin FROM `disposisi_surat_keluar` AS dispo LEFT JOIN `status_tugas` AS st ON dispo.`id_status` = st.`id` WHERE 1 GROUP BY dispo.`id_desa_pamong`, DATE(dispo.`waktu_update`) ) AS dispo_keluar ON dispo_keluar.`pamong_id` = p.`pamong_id` AND c.`tanggal` = dispo_keluar.`cdate` -- SUBQUERY BERITA LEFT JOIN ( SELECT u.`pamong_id`, DATE(a.`tgl_upload`) AS `cdate`, a.`hit` AS `poin` FROM `artikel` AS a LEFT JOIN `user` AS u ON a.`id_user` = u.`id` WHERE 1 GROUP BY DATE(tgl_upload), pamong_id ) AS lb ON lb.pamong_id = p.`pamong_id` AND c.`tanggal` = lb.`cdate` WHERE p.`pamong_status` = 1 AND p.pamong_id = '12' GROUP BY p.`pamong_id`, c.`tanggal` ) AS t ORDER BY t.`tanggal`, t.`pamong_id` 0.0040 sec

    Total Execution Time 0.0238 sec

    0.0238 sec

  • Hooks Hooks (1)

    post_controller_constructor [1]class:Billing_hookfunction:check_billingfilename:Billing_hook.phpfilepath:hooks

  • Ajax requests

    Method Status URL Time Profiler
  • Libraries Libraries (15)

    Benchmark

    Cache

    Config

    Hooks

    Input

    Lang

    Loader

    Log

    Output

    Router

    Security

    Session

    URI

    Upload

    Utf8

  • Helpers Helpers (20)

    Buku_tamu_helper

    Cdn_helper

    Database_helper

    Date_helper

    Donjolib_helper

    File_helper

    Form_helper

    General_helper

    Language_helper

    Object_storage_helper

    Opensid_helper

    Password_helper

    Pict_helper

    Scope_helper

    Sides_helper

    Sql_helper

    Surat_helper

    Text_helper

    Url_helper

    Utility_helper

  • Views Views (1)

    + /var/www/html/sendangsari/sides.id/donjo-app/views/task/tukin_task.php

  • Configuration Configuration

    base_url:https://sendangsari.id/

    index_page:index.php/

    uri_protocol:REQUEST_URI

    url_suffix:

    language:indonesia

    charset:UTF-8

    enable_hooks:1

    subclass_prefix:MY_

    composer_autoload:vendor/autoload.php

    permitted_uri_chars:a-z 0-9~%.:_\-

    enable_query_strings:

    controller_trigger:c

    function_trigger:m

    directory_trigger:d

    allow_get_array:1

    log_threshold:1

    log_path:storage//logs/

    clv_log_file_pattern:log-*.php

    log_file_extension:

    log_file_permissions:420

    log_date_format:Y-m-d H:i:s

    error_views_path:

    cache_path:desa/cache/

    cache_query_string:

    encryption_key:lumbungkomunitas

    sess_driver:redis

    sess_cookie_name:ci_session

    sess_expiration:3600

    sess_save_path:tcp://103.150.196.137:6379?auth=TaufiqKamalSKomMCs

    sess_match_ip:

    sess_time_to_update:300

    sess_regenerate_destroy:

    cookie_prefix:

    cookie_domain:

    cookie_path:/

    cookie_secure:

    cookie_httponly:

    standardize_newlines:

    global_xss_filtering:

    csrf_protection:1

    csrf_token_name:sidcsrf

    csrf_cookie_name:sidcsrf

    csrf_expire:7200

    csrf_regenerate:1

    csrf_exclude_uris:Array ( [0] => telegram/webhook [1] => api/post [2] => api/webhook [3] => apps/api_kk [4] => apps/api_ai [5] => apps/api_ai/buatagendadesa [6] => apps/api_ai/buatagendasaya [7] => apps/chat_send [8] => api_wa/webhook [9] => api_wa/webhook_watzap [10] => api_wa/webhook_whacenter [11] => api_wa/email [12] => api_wa/upload_surat [13] => api_webhook/handle_webhook [14] => task/validate_location [15] => task/backend [16] => task/presensi_finger [17] => task/simpan_ip [18] => app [19] => m [20] => app/share [21] => m/share [22] => app/share.* [23] => m/share.* [24] => app/share-target.* [25] => m/share-target.* [26] => app/share-target/surat-keluar [27] => m/share-target/surat-keluar [28] => app/presensi/validasi [29] => app/presensi/simpan [30] => m/presensi/validasi [31] => m/presensi/simpan [32] => app/lembaga_presensi_validate [33] => m/lembaga_presensi_validate [34] => app/lembaga_presensi_save [35] => m/lembaga_presensi_save [36] => app/lembaga_tidak_hadir_save [37] => m/lembaga_tidak_hadir_save [38] => app/profile/task-update [39] => m/profile/task-update [40] => app/profile/request-pin [41] => m/profile/request-pin [42] => app/surat-keluar [43] => m/surat-keluar [44] => app/surat-keluar/share [45] => m/surat-keluar/share [46] => app/api/login [47] => m/api/login [48] => app/api/restore-session [49] => m/api/restore-session [50] => app/api/forget-session [51] => m/api/forget-session [52] => app/api/switch-scope [53] => m/api/switch-scope [54] => app/api/share-upload [55] => m/api/share-upload [56] => app/api/surat-keluar-upload [57] => m/api/surat-keluar-upload [58] => app/api/surat-keluar-save [59] => m/api/surat-keluar-save [60] => api/v2/license [61] => webhook [62] => apps/grafik_parameter [63] => api_wa/save_log_bulk [64] => apps/grafik_parameter/* [65] => api/simpan_ukur_gps [66] => api/simpan_ukur_gps/(.*) [67] => api/simpan_titik_gps [68] => api/sewa_aset_simpan_ukur_gps [69] => api/sewa_aset_simpan_ukur_gps/(.*) [70] => api/sewa_aset_simpan_titik_gps [71] => area/simpan_ukur_gps [72] => area/simpan_ukur_gps/(.*) [73] => area/simpan_titik_gps [74] => area/cetak_barcode_terpilih [75] => area/cetak_barcode_terpilih/(.*) [76] => area/cetak_barcode_bidang [77] => area/cetak_barcode_bidang/(.*) [78] => api/bidang [79] => api/bidang/(.*) [80] => api/cetak_barcode_bidang [81] => api/cetak_barcode_bidang/(.*) [82] => sewa_aset/simpan_ukur_gps [83] => sewa_aset/simpan_ukur_gps/(.*) [84] => sewa_aset/simpan_titik_gps [85] => dokumen/get_upload_url [86] => layanan-mandiri/dokumen/get-upload-url [87] => layanan-mandiri/dokumen/upload-syarat [88] => suratsides/surat_master/kode_isian [89] => suratsides/surat_master/kode_isian/(.*) [90] => surat_master/kode_isian [91] => surat_master/kode_isian/(.*) )

    api_webhook_token:

    compress_output:

    time_reference:local

    rewrite_short_tags:

    proxy_ips:

    rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest

    rilis_premium:https://api.github.com/repos/opensid/rilis-premium/releases/latest

    api_idm:https://idm.kemendesa.go.id/open/api/desa/rumusan

    views_blade:resources//views/

    cache_blade:storage//framework/views/

    ppn:0.11

    useDatabaseConfig:1

    demo_mode:

    demo_akun:Array ( [1] => 123456 [2] => 234561 [3] => 345612 )

    demo_user:Array ( [username] => admin [password] => sid304 )

    user_admin:0

    tabel_pbb:sendangsarikp

    tabel_pbb_update:pbb_sendangsarikp

    protocol:smtp

    smtp_host:

    smtp_user:

    smtp_pass:

    smtp_port:

    theme_link:1

    theme_kritik:

    theme_hadir:1

    slogan_desa_cetak_kartu:PLERET - The Heritage Of Mataram - 2023

    kunci_kartu:130387

    kirim_wa_tu:

    status_server_wa:1

    api_wa:http://wa.pleret.id/api/send.php?key=908ad203cc9dfad19c2c9c0367a33a8e982148fa

    api_wa_by_pass:http://178.128.98.248:8000/sendImage

    url_asal_gambar:https://go.pleret.id

    no_tata_laksana:085878977782

    token_tracksid:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw

    vaksin:19

    urutpadukuhan:1

    lokasivaksin:Balai Kalurahan Pleret

    dosis1:

    dosis2:

    jenisvaksin:

    waktu:10:00

    penambah:+15 minutes

    pemisah:50

    servecapil:http://167.71.202.163:8888/dukcapil/get_json/PLERET/call_nik

    nama_kab:Kabupaten Bantul

    nama_kec:Kapanewon Pleret

    nama_desa:Kalurahan Pleret

    nama_desa_julukan:Kalurahan

    nama_desa_inti:Pleret

    nama_jabatan_lurah:Lurah Pleret

    alamat_lurah:Kanggotan, Pleret, Bantul, Yogyakarta, 55791

    nama_lurah:TAUFIQ KAMAL, S.Kom., M.Cs.

    nama_carik:IWAN ALIM SUNU PURWOKO, S.P.

    nama_petugas_aset:RIFQI FATONI, A.Md.

    kode_desa:34.02.13.2002

    nama_jagabaya:PRAPTA HADI SUSILA

    nama_kamituwa:ANANG JATMIKO

    nama_ululu:IRFANI ANDHI HERMAWAN

    nama_danarta:DWI ZULIYANTI, S.IP.

    pamong_ttd:32

    pamong_ketahui:26

    pamong_jam_pulang:14:30:00

    pamong_jam_akhir:16:30:00

    wa_url:https://app.whatspie.com/api/messages

    wa_device_id:2139

    wa_device:6289674499080

    wa_token:VfCtGzPpfGfYWspzNYRLlxG49QXEP4esWtrDQNC5P7Z4mpvUvk

    layanan_mandiri_id_artikel:4203

    kode_siskeudes:13.2005.

    tahun_siskeudes:2023

    admintask:Array ( [0] => 2 )

    key_whatspie:Bearer VfCtGzPpfGfYWspzNYRLlxG49QXEP4esWtrDQNC5P7Z4mpvUvk

    nomor_whatspie:6289674499080

    nomorlurah_whatspie:6285228901666

    url_whatspie:https://api.whatspie.com/messages

    iskirim_whatspie:1

    notif_surat_selesai_dibuat:Kepada [nama], permintaan surat Anda telah selesai diproses. Arsip surat dapat diakses pada link berikut: [link] Terimakasih.

    key_whatzap:LZKV2GCXTDSHWYVC

    nomor_whatzap:daobHxoG2ZSY2tqn

    nomorlurah_whatzap:6281326334562

    url_whatzap:https://api.watzap.id/v1/

    iskirim_whatzap:1

    vision_key:AIzaSyDPjep_oq8-2wVofWDHSkE1tcAb6CdGi5o

    openai_key:sk-vQQiQgn9ajmvxUcKxqgE3w

    model_ai:gemini/gemini-2.0-flash

    api_quota:abc123

    layanan_api:1

    server_quota:https://keuangan.pleret.id/home/

    object_storage_enabled:1

    object_storage_direct_upload:1

    object_storage_fallback_local:1

    object_storage_driver:s3

    object_storage_endpoint:https://s3.ap-southeast-1.wasabisys.com

    object_storage_region:ap-southeast-1

    object_storage_bucket:cdn-sides

    object_storage_key:TK1XWTI3QTS4DQ7GZP0T

    object_storage_secret:ENPBEoGctMmuvgGFM4NJULQlCBM5IVm7ENJCg0Ol

    object_storage_public_base_url:https://cdn-sides.b-cdn.net

    object_storage_path_style:1

    object_storage_signed_url_ttl:900

    object_storage_admin_base_url:

    sumopod_api_url:https://ai.sumopod.com/v1/chat/completions

    sumopod_api_key:sk-wHD-q71_tSxAyNUSFJZkNQ

    sumopod_model:gemini/gemini-3.1-flash-lite

    ai_provider:sumopod

    url_provider_ocr:https://vpn.dewanggatour.com/v1/images:annotate

    url_provider_ocr_api_key:dewangga_ocr_secret_key_2026

    cdn:1

    cdn_url:https://cdn-sides.b-cdn.net/kulonprogo-sendangsari/

    local_path:desa/upload/

    object_storage_path_prefix:kulonprogo-sendangsari

    desa:Array ( [desa/arsip/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/cache/] => Array ( [0] => 509 ) [desa/config/] => Array ( [0] => 509 ) [desa/logo/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/pengaturan/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/images/] => Array ( [0] => 509 ) [desa/template-surat/] => Array ( [0] => 509 ) [desa/themes/] => Array ( [0] => 509 ) [desa/upload/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dokumen/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/upload/galeri/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/area/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/garis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/point/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/fmedia/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/ttd/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/suratkeluar/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/suratdinas/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/surattugas/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/menu_anjungan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/Dok Pembangunan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/kartu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/status/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/telegram/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/status/cache/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/buku_tamu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/task/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/presensi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/temp/surat/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/cdesa/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/tdesa/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/produk/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/sinkronisasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/thumbs/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/user_pict/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/vaksin/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/widgets/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )

    lainnya:Array ( [storage/framework/] => Array ( [0] => 509 ) [storage/logs/] => Array ( [0] => 509 ) [backup_inkremental/] => Array ( [0] => 509 ) )

    config:<?php // ---------------------------------------------------------------------------- // Konfigurasi aplikasi dalam berkas ini merupakan setting konfigurasi tambahan // SID. Letakkan setting konfigurasi ini di desa/config/config.php. // ---------------------------------------------------------------------------- // Uncomment jika situs ini untuk demo. Pada demo, user admin tidak bisa dihapus // dan username/password tidak bisa diubah // $config['demo_mode'] = false; // Setting ini untuk menentukan user yang dipercaya. User dengan id di setting ini // dapat membuat artikel berisi video yang aktif ditampilkan di Web. // Misalnya, ganti dengan id = 1 jika ingin membuat pengguna admin sebagai pengguna terpecaya. $config['user_admin'] = 0; // config email $config['protocol'] = 'smtp'; // mail mail, sendmail, or smtp The mail sending protocol. $config['smtp_host'] = ''; // SMTP Server Address. $config['smtp_user'] = ''; // SMTP Username. $config['smtp_pass'] = ''; // SMTP Password. $config['smtp_port'] = ''; // SMTP Port."

    database:<?php // ------------------------------------------------------------------------- // // Letakkan username, password dan database sebetulnya di file ini. // File ini JANGAN di-commit ke GIT. TAMBAHKAN di .gitignore // ------------------------------------------------------------------------- // Data Konfigurasi MySQL yang disesuaikan $db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'root'; $db['default']['password'] = ''; $db['default']['port'] = 3306; $db['default']['database'] = 'premium'; /* | Untuk setting koneksi database 'Strict Mode' | Sesuaikan dengan ketentuan hosting */ $db['default']['stricton'] = TRUE;

    index_html:<html> <head> <title>403 Forbidden</title> </head> <body> <p>Directory access is forbidden.</p> </body> </html>

    htaccess1:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>

    htaccess2:<FilesMatch "\.(rtf|pdf|jpe?g|png|php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>

    offline_mode:<!DOCTYPE html> <html> <head> <title>Offline Mode - <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?></title> <link rel="shortcut icon" href="<?= favico_desa() ?>"/> </head> <body> <br/><br/><br/> <div align="center"> <img class="profile-user-img img-responsive img-circle" src="<?= gambar_desa($main['logo']); ?>" alt="Logo"> <p> Selamat datang di Halaman Situs Resmi <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?><br/> Kami mohon maaf untuk sementara halaman tidak dapat di akses, dikarenakan sedang adanya perbaikan oleh tim terkait. </p> <p> Jika ada keperluan yang mendesak silakan langsung datang ke Kantor <?= ucwords($this->setting->sebutan_desa)?>.<br> Alamat : <?= $main['alamat_kantor'] ?><br> Email : <?= $main['email_desa'] ?><br> Telepon : <?= $main['telepon'] ?> </p> <p> <?= ucwords($pamong_kades['jabatan']).' '.$main['nama_desa'] ?> <br> <br> <br> <u><b><?= $main['nama_kepala_desa'] ?></b></u><br> NIP. <?= $main['nip_kepala_desa'] ?> </p> </div> </body> </html>

    siteman_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background: url(images/latar_login.jpg) no-repeat center fixed; /*gambar background */ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }

    siteman_mandiri_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background: url(images/latar_login.jpg) no-repeat center fixed; /*gambar background */ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }

    url_aplikasi_publik:https://sendangsari.id/

    public_app_url:https://sendangsari.id/

  • Session Session

    __ci_last_regenerate:1790848937

    sudah_mulai:1

  • Models Models (14)

    seeder

    config_model

    setting_model

    database_model

    theme_model

    web_menu_model

    info_model

    surat_task_model

    M_api

    user_model

    grup_model

    surat_tugas_model

    log_kehadiran_model

    libsql

CodeIgniter

Aktifitas

APBDes 2026 Pelaksanaan

Pendapatan
Rp2,411,759,895 Rp3,288,798,940
73.33%
Belanja
Rp2,065,643,029 Rp3,242,750,703
63.7%
Pembiayaan
Rp239,802,563 Rp-46,048,237
-520.76%

APBDes 2026 Pendapatan

Hasil Usaha Desa
Rp132,806,343 Rp131,216,002
101.21%
Hasil Aset Desa
Rp20,400,000 Rp39,900,000
51.13%
Lain-lain Pendapatan Asli Desa
Rp34,374,150 Rp67,000,000
51.3%
Dana Desa
Rp373,456,000 Rp1,429,254,000
26.13%
Bagi Hasil Pajak Dan Retribusi
Rp170,981,276 Rp242,225,611
70.59%
Alokasi Dana Desa
Rp621,806,060 Rp813,497,627
76.44%
Bantuan Keuangan Provinsi
Rp1,020,000,000 Rp520,000,000
196.15%
Penerimaan Dari Hasil Kerjasama Antar Desa
Rp0 Rp205,700
0%
Hibah Dan Sumbangan Dari Pihak Ketiga
Rp0 Rp9,500,000
0%
Koreksi Kesalahan Belanja Tahun-tahun Sebelumnya
Rp55,500 Rp0
100%
Bunga Bank
Rp266,766 Rp6,000,000
4.45%
Lain-lain Pendapatan Desa Yang Sah
Rp37,613,800 Rp30,000,000
125.38%

APBDes 2026 Pembelanjaan

Bidang Penyelenggaran Pemerintahan Desa
Rp1,018,936,549 Rp1,587,403,121
64.19%
Bidang Pelaksanaan Pembangunan Desa
Rp868,965,480 Rp1,224,492,154
70.97%
Bidang Pembinaan Kemasyarakatan
Rp30,640,000 Rp249,753,200
12.27%
Bidang Pemberdayaan Masyarakat
Rp138,101,000 Rp78,682,818
175.52%
Bidang Penanggulangan Bencana, Darurat, Dan Mendesak Desa
Rp9,000,000 Rp102,419,410
8.79%
Beranda Peta Menu Login Galeri
CodeIgniter