OpenSID Desa Banjarejo - Siteman

CodeIgniter version : 3.1.13

CodeIgniter documentation

DevelBar version : 1.2.2

PHP version : 7.4.33

Default language : Indonesia
1.0735 sec

Loading Time: Base Classes : 0.0059 sec

Controller Execution Time ( Siteman / Lupa Sandi ) : 0.1238 sec
3.37MB
Request : siteman/lupa_sandi

Method : GET
Database

Host:localhost/jojo_sid

SHOW TABLES FROM `jojo_sid` 0.0012 sec

SHOW DATABASES 0.0006 sec

SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'jojo_sid' AND table_name = 'user' 0.0003 sec

SHOW COLUMNS FROM `anjungan` 0.0008 sec

SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.216.99' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0003 sec

SHOW COLUMNS FROM `tweb_desa_pamong` 0.0012 sec

SHOW COLUMNS FROM `tweb_desa_pamong` 0.0008 sec

Total Execution Time 0.0053 sec
Host:localhost_ORM/jojo_sid

select * from `config` limit 1 2.0400 sec

select count(*) as aggregate from `config` 0.3600 sec

select count(*) as aggregate from `config` 0.2400 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'config' 1.1400 sec

select * from `config` where `app_key` = 'base64:BQeueIC+gzBroV3Q6JDzvU/c5miZd+HIQw8PYiLiKh8=' limit 1 0.4700 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'config' 0.8100 sec

select * from `config` where `app_key` = 'base64:BQeueIC+gzBroV3Q6JDzvU/c5miZd+HIQw8PYiLiKh8=' limit 1 0.3700 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'setting_aplikasi' 0.8400 sec

select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 1.0600 sec

select * from information_schema.tables where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.6300 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' 0.9800 sec

select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.4400 sec

select * from information_schema.tables where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.5500 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' 0.9300 sec

select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.3900 sec

select count(*) as aggregate from `config` 0.2000 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'config' 0.7700 sec

select * from `config` where `app_key` = 'base64:BQeueIC+gzBroV3Q6JDzvU/c5miZd+HIQw8PYiLiKh8=' limit 1 0.3300 sec

select exists(select * from `migrasi` where `versi_database` = 2024030101) as `exists` 0.3600 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'anjungan' 0.7500 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'anjungan' 0.6700 sec

select * from information_schema.tables where table_schema = 'jojo_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.3900 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'kehadiran_jam_kerja' 0.8300 sec

select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Sabtu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.3800 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'kehadiran_jam_kerja' 0.6600 sec

select id, nama_hari, jam_masuk, status, keterangan, date_add(jam_keluar, interval 10 minute) as jam_keluar from `kehadiran_jam_kerja` where `nama_hari` = 'Sabtu' and (time(`jam_masuk`) > '11:19' or date_add(jam_keluar, interval 10 minute) < '11:19') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.3500 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'kehadiran_perangkat_desa' 0.7800 sec

select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.3700 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'config' 0.8400 sec

select * from `config` where `app_key` = 'base64:BQeueIC+gzBroV3Q6JDzvU/c5miZd+HIQw8PYiLiKh8=' limit 1 0.3600 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'config' 1.0600 sec

select * from `config` where `app_key` = 'base64:BQeueIC+gzBroV3Q6JDzvU/c5miZd+HIQw8PYiLiKh8=' limit 1 0.4200 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' 1.0000 sec

select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.3900 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'tweb_desa_pamong' 0.7300 sec

select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.5100 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'ref_jabatan' 0.7000 sec

select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.3900 sec

select column_name as `column_name` from information_schema.columns where table_schema = 'jojo_sid' and table_name = 'tweb_desa_pamong' 0.7700 sec

select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.5300 sec

Total Execution Time 25.7900 sec

25.7953 sec
N/A
Method Status URL Time Profiler
Libraries (17)

Benchmark

Cache

Config

Hooks

Input

Lang

Loader

Log

Output

Password

Router

Security

Session

URI

Upload

User_agent

Utf8
Helpers (15)

Cek_helper

Database_helper

Date_helper

Donjolib_helper

File_helper

Form_helper

General_helper

Language_helper

Opensid_helper

Password_helper

Pict_helper

Surat_helper

Text_helper

Url_helper

Utility_helper

Views (1)

+ /home/jojo/web/sid.gaga.my.id/public_html/donjo-app/views/lupa_sandi.php

Array
(
    [header] => Array
        (
            [id] => 1
            [nama_desa] => Banjarejo
            [kode_desa] => 3507182002
            [kode_pos] => 
            [nama_kecamatan] => Pakis
            [kode_kecamatan] => 350718
            [nama_kepala_camat] => Camat
            [nip_kepala_camat] => 
            [nama_kabupaten] => Malang
            [kode_kabupaten] => 3507
            [nama_propinsi] => Jawa Timur
            [kode_propinsi] => 35
            [logo] => 
            [lat] => 
            [lng] => 
            [zoom] => 
            [map_tipe] => 
            [path] => 
            [alamat_kantor] => Alamat
            [email_desa] => 
            [telepon] => 
            [nomor_operator] => 
            [website] => 
            [kantor_desa] => 
            [warna] => 
            [created_at] => 2024-03-04T09:10:44.000000Z
            [created_by] => 
            [updated_at] => 2024-03-04T16:21:24.000000Z
            [updated_by] => 2
            [nip_kepala_desa] => 
            [nama_kepala_desa] => 
            [path_logo] => assets/files/logo/opensid_logo.png
            [path_kantor_desa] => assets/files/logo/opensid_kantor.jpg
        )

    [latar_login] => https://sid.gaga.my.id/assets/css/images/latar_login.jpg?v4c6907b07cbb39745929ca335ee61ca4
)

Configuration

trusted_hosts:Array ( )
base_url:https://sid.gaga.my.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:Array ( [0] => 1 [1] => 5 )
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:/home/jojo/web/sid.gaga.my.id/public_html/desa/cache/
cache_query_string:
encryption_key:lumbungkomunitas
sess_driver:files
sess_cookie_name:ci_session
sess_expiration:7200
sess_save_path:/home/jojo/tmp
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] => api.*+ )
compress_output:
time_reference:local
rewrite_short_tags:
proxy_ips:
nama_aplikasi:OpenSID
nama_lembaga:OpenDesa
fb_opendesa:https://www.facebook.com/groups/komunitasopendesa
tg_opendesa:https://t.me/komunitasopensidstop
tg_kontributor:https://t.me/+mi5ydVtVfmw0YWY1
github:https://github.com/OpenSID/OpenSID
website:https://opendesa.id
forum:https://forum.opendesa.id
youtube:https://www.youtube.com/KomunitasOpenSID-OpenDesa
server_pantau:https://pantau.opensid.my.id
token_pantau:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw
server_layanan:https://layanan.opendesa.id
rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest
api_idm:https://idm.kemendesa.go.id/open/api/desa/rumusan
api_sdgs:https://sid.kemendesa.go.id/sdgs/searching/score-sdgs?location_code=
api_hari_libur:https://raw.githubusercontent.com/guangrei/APIHariLibur_V2/main/calendar.min.json
views_blade:resources/views/
cache_blade:storage/framework/views/
maximum_login_attempts:3
lockout_time:300
useDatabaseConfig:1
demo_mode:
demo_akun:Array ( [1] => 123456 [2] => 234561 [3] => 345612 )
demo_user:Array ( [username] => admin [password] => sid304 )
rentang_kirim_pesan:60
user_admin:0
impor_massal:1
protocol:smtp
smtp_host:
smtp_user:
smtp_pass:
smtp_port:
desa:Array ( [desa/anjungan/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [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/template-surat/lampiran/] => 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/buku_tamu/] => 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/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => 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/upload/dtks/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )
lainnya:Array ( [storage/framework/] => Array ( [0] => 509 [1] => htaccess3 ) [storage/logs/] => Array ( [0] => 509 [1] => htaccess3 ) [backup_inkremental/] => Array ( [0] => 509 [1] => htaccess3 ) [assets/] => Array ( [0] => 493 [1] => htaccess3 ) [assets/filemanager/] => Array ( [0] => 493 [1] => htaccess4 ) )
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'] = true; // 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; // Ijinkan agar bisa melakukan impor data penduduk dari OpenKAB $config['impor_massal'] = false; // Untuk menghindari masalah keamanan, Anda mungkin ingin mengonfigurasi daftar "host tepercaya". // Contoh: ['localhost', 'my-development.com', 'my-production.com', 'subdomain.domain.com'] $config['trusted_hosts'] = []; // 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'] = 'umum'; /* | Untuk setting koneksi database 'Strict Mode' | Sesuaikan dengan ketentuan hosting */ $db['default']['stricton'] = TRUE;
index_html:<html> <head> <title>403 Forbidden</title> </head> <body> Directory access is forbidden. </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>
htaccess3:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg|pl|py|jsp|asp|htm|shtml|sh|cgi)$"> order allow,deny deny from all </FilesMatch>
htaccess4:<FilesMatch "\.(php)$"> order allow,deny allow 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> <div align="center"> <img class="profile-user-img img-responsive img-circle" src="<?= gambar_desa($main['logo']); ?>" alt="Logo"> Selamat datang di Halaman Situs Resmi <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?> Kami mohon maaf untuk sementara halaman tidak dapat di akses, dikarenakan sedang adanya perbaikan oleh tim terkait. Jika ada keperluan yang mendesak silakan langsung datang ke Kantor <?= ucwords($this->setting->sebutan_desa)?>. Alamat : <?= $main['alamat_kantor'] ?> Email : <?= $main['email_desa'] ?> Telepon : <?= $main['telepon'] ?> <?= ucwords($pamong_kades['jabatan']).' '.$main['nama_desa'] ?> <?= $main['nama_kepala_desa'] ?> NIP. <?= $main['nip_kepala_desa'] ?> </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-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-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 */ }
Session

__ci_last_regenerate:1775881164
sudah_mulai:1
siteman_wait:0
Models (7)

seeder

setting_model

anjungan_model

database_model

user_model

grup_model

theme_model

Desa Banjarejo

AlamatKodepos Kecamatan PakisKabupaten Malang

Alamat
Kodepos
Kecamatan Pakis
Kabupaten Malang