Refactor Database : balai -> ok (halls) contact -> ok (contacts) infografis -> ok (infographics) ma_agenda -> ok (ma_agendas) ma_contact -> ok (ma_contacts) ma_download -> ok (ma_downloads) ma_galery -> ok (ma_galleries) ma_imggalery -> ok (ma_image_galleries) ma_kategori ma_katperaturan -> ok (ma_regulation_categories) ma_ihkpn -> ok (ma_ihkpns) ma_link -> ok (ma_links) ma_menu_balai -> ok (ma_hall_menus) ma_options -> ok (ma_options) ma_pengguna -> ok (users) ma_peraturan -> ok (ma_regulations) ma_pooling -> ok (ma_pollings) ma_post -> ok (ma_posts) ma_profile -> ok (ma_profiles) ma_profilpejabat -> ok (ma_official_profiles) ma_profilpejabatlist -> ok (ma_official_profile_lists) ma_profilpejabatppid -> ok (ma_official_ppid_profiles) ma_regulasi -> ok (ma_regulations) ma_regulasifile -> ok (ma_regulation_files) ma_setting ma_slide ma_video pages portaldata refactor name ma_agenda -> ma_agendas ma_contact -> ma_contacts ma_download -> ma_downloads ma_galery -> ma_galleries ma_imggalery -> ma_image_galleries ma_kategori -> ma_categories ma_katperaturan -> ma_regulation_categories ma_ihkpn -> ma_ihkpns ma_link -> ma_links ma_menu_balai -> ma_hall_menus ma_options -> ma_options ma_pengguna -> ma_users ma_peraturan -> ma_regulations ma_pooling -> ma_pollings ma_post -> ma_posts ma_profile -> ma_profiles ma_profilpejabat -> ma_official_profiles ma_profilpejabatlist -> ma_official_profile_lists ma_profilpejabatppid -> ma_official_ppid_profiles ma_regulasi -> ma_regulations ma_regulasifile -> ma_regulation_files ma_setting -> ma_settings ma_slide -> ma_slides ma_video -> ma_videos pages -> pages portaldata -> portal_data //striktur menu -> Master -> slide -> berita -> home anggaran -> infografis -> jumlah informasi -> portal data -> pejabat ppid -> foto -> video -> agenda -> download -> regulasi -> link terkait -> hubungi kami -> pengguna -> Setting -> Setting menjadi tab layout saja - info website - nama website - telpon - deskripsi - email - alamat - keyword - online - profile - berisikan deskripsi profile - sosial media - facebook - twitter - instagram - youtube - image - berisikan image dan preview existing image - maps - input url maps - preview existing map -> Management -> profile -> sejarah -> visi misi -> tupoksi -> struktur organisasi -> profile pebajat CATATAN PENTING menu berita (kurang validasi role id ) -> MaHallMenu tidak ada controller dan view nya di existing (tolong tambahkan) -> Rombak alur crud balai + tambah menunya (sudah) CATATAN KURANG RELATE -> existing tabel pages digunakan untuk menu home anggaran. field table non use (seo_pages, image, type ) CATATAN COMPLETED MENU Master -> balai (ok) -> slide (ok) -> berita (kurang action lihat berita di home page) -> home anggaran (ok) -> infografis (ok) -> jumlah informasi (ok) -> portal data (ok) -> pejabat ppid (ok) -> foto/gallery (ok) -> video (ok) -> agenda (ok) -> download (ok) -> regulasi (ok) -> link terkait (ok) -> hubungi kami -> pengguna (ok) catatan revisi - berita punya 5 type (ok) - regulasi punya 2 tipe (ok) - tambah menu review (ok) - profile (ok) - logout (ok) buat dashboard role user (ok) home (ok) profil (ok) balai/upt (ok) berita (ok) pengaduan (ok) portal data (ok) regulasi (ok) unduh (ok) agenda (ok) gallery - photo (ok) - video (ok) hubungi kami (ok) pooling (ok) tambah statistik dashboard (ok) revisi : 1. animasi belum keluar ? 2. berita dan informasi public bisa autoshare 3. berita dikelompokken per kategori 4. 5. video ditampilkan 2 / 3 baris nge slide (ada judul dan waktu) 6. menu pencarian (ok untuk berita) 7. menu ppid 8. footer (udah mentok) 9. permohonan informasi huruf dibesarin (ok) catatan PENTING menu dashboard -> bagian berita -> hilangkan input menu untuk berita (ok) -> flow fitur ppid (tiap menu memiliki deskripsi utama) -> daftar informasi public (berisikan file) -> daftar informasi setiap saat (berisikan file) -> informasi serta merta berisi berita -> informasi dikecualian berisi file -> informasi dikecualikan A -> A1 -> A2 -> informasi dikecualian B -> B1 -> B2 PPID -> MODEL (PublicInformation) -> (PublicInformationNews) -> (PublicInformationFiles) -> PublicInformation - id - title - description -> PublicInformationNews - id - title - seo - description - image - is_publish - views - public_information_id -> PublicInformationFile - id - title - file - public_information_news_id -> form permohonan informasi - id - name - phone - job - address - email - image - information - purpose - howtoget_information - howtocopy_information - type (request) -> form keberatan - id - name - phone - job - address - email - image - information - description - reason - type (objection) -> form pengaduan asn - id - name - phone - address - email - image - nameof_reported - witness (Ya/Tidak) - reported_identity - information (kejadian / kesaksian) - type (complaint) -> form kepuasan - id - date - name - email - phone - job - typeof_service - evaluation1 - evaluation2 - evaluation3 - evaluation4 - evaluation5 - evaluation6 - evaluation7 - evaluation8 - evaluation9 - evaluation10 - suggestion - type (satisfaction) rekap form_information - id - name - phone - job (nullable) -> permohonan, keberatan, kepuasan - address (nullable) -> permohonan, keberatan, pengaduan - email - image (nullable) -> permohonan, keberatan, pengaduan - information (nullable) -> permohonan, keberatan, pengaduan - type (enum [request, objection, complaint, satisfaction]) PERMONAN - purpose (nullable) - howtoget_information (nullable) - howtocopy_information (nullable) KEBERATAN - description (nullable) - reason (nullable) PENGADUAN - nameof_reported (nullable) - witness (enum [ya, tidak], nullable) - reported_identity (nullable) KEPUASAN - date (nullable) - typeof_service (nullable) - evaluation1 (nullable) - evaluation2 (nullable) - evaluation3 (nullable) - evaluation4 (nullable) - evaluation5 (nullable) - evaluation6 (nullable) - evaluation7 (nullable) - evaluation8 (nullable) - evaluation9 (nullable) - evaluation10 (nullable) - suggestion (nullable) ALL IS DONE