C. Lifecycle CRUD pada Mode Listing (`Models/Cms/CmsUpdate.php` & `CmsDetail.php`)

• Add Form (`/cms/{idnav}/insrt/add/{id_protab}/`):
• Ditangani oleh `CmsUpdate::addData()` (`CmsUpdate.php:130-236`).
• Merender field sesuai format `CmsFormatField::ininsert()`.
• Mengarahkan form action ke `POST /cms/{idnav}/recinsrt/{id_protab}`.
• Insert Execution (`/cms/{idnav}/recinsrt/{id_protab}`):
• Ditangani oleh `CmsUpdate::recinsrt()` (`CmsUpdate.php:368-400`).
• Setiap nilai POST dengan format `{id_protab}t_{field_name}` diekstrak dan disanitasi via `CmsFormatField::posvar_insert()`.
• Dieksekusi via `$this->db->table($table)->insert($arrinsert)`.
• Redirect kembali ke listing: `header("location: /cms/{idnav}")`.
• Edit Form (`/cms/{idnav}/update/{id_record}/`):
• Ditangani oleh `CmsUpdate::setupdate()` (`CmsUpdate.php:239-352`).
• Mengambil data eksisting via `outRow($table, [$id_key => $id_record])`.
• Mengisi nilai form via `CmsFormatField::inupdate()` dan action ke `POST /cms/{idnav}/recupdate/{id_record}`.
• Update Execution (`/cms/{idnav}/recupdate/{id_record}`):
• Ditangani oleh `CmsUpdate::recupdate()` (`CmsUpdate.php:402-440`).
• Mengekstrak `{id_protab}t_{field_name}` via `CmsFormatField::posvar_update()`.
• Menjalankan `$this->db->table($table)->update($arrUpdate, [$id_key => $id_update])`.
• Delete Action (`/cms/{idnav}/delete/{id_record}/`):
• Ditangani oleh `CmsUpdate::setdelete()` (`CmsUpdate.php:442-530`).
• Memeriksa apakah ada file/gambar terkait (`upload_image` / `upload_file`) untuk di-`unlink()` dari filesystem `imagebank/`.
• Menghapus record: `DELETE FROM $tabel WHERE $id_key = $idDelete`.
• Mengembalikan JSON `{valid: id}` jika request via AJAX atau redirect jika standard HTTP.
• Detail View (`/cms/{idnav}/detail/{id_record}/`):
• Ditangani oleh `CmsDetail::home()` (`CmsDetail.php:21-116`).
• Jika dipanggil via AJAX dengan suffix `/plain/1/`, mengembalikan respon JSON `{valid: 1, htm: $data}` untuk di-inject ke dalam Modal Bootstrap (`CmsDetail.php:113`).

3. PERMISI LEVEL & AUTENTIKASI (ACCESS CONTROL)

                  ┌───────────────────────────────┐
                  │ POST /cms login (uid + ulock) │
                  └───────────────┬───────────────┘
                                  │
                  ┌───────────────┴───────────────┐
                  ▼                               ▼
       [ Tabel user_admin ]            [ Tabel dts_user_petugas ]
                  │                               │
       ├─ password_verify / md5        ├─ password_verify / md5
       ├─ level_admin = admin.level    ├─ level_admin = petugas.level (def: 2)
       └─ Set Session User             └─ Set Session User
                  │                               │
                  └───────────────┬───────────────┘
                                  │
                                  ▼
                    ┌───────────────────────────┐
                    │ CI4 Session Storage       │
                    │ - log_id, user_id, level  │
                    │ - user_name, kode_di      │
                    └─────────────┬─────────────┘
                                  │
         ┌────────────────────────┴────────────────────────┐
         ▼                                                 ▼
[ CmsNavigation::home() ]                        [ CmsContent::home() ]
Filter Query Menu Navigasi:                      Pengecekan Otorisasi Konten:

Level 1: WHERE user_level IN (1, 2)            - outRow('cms_navigation', ...)
Level N: WHERE user_level = '$level'           - Jika gagal: Blokir akses + pesan error

3.1 Session Data yang Ditetapkan Saat Login (`CmsLogIn.php:100-145`)

php
$arrUser = array(
    'log_id'      => $user['id'],          // Primary key ID user
    'local'       => $user['local'] ?? 1,
    'kode_di'     => !empty($user['area_di']) ? $user['area_di'] : (env('id_di') ?? 1),
    'user_name'   => $user['user_name'],   // Nama lengkap user
    'user_id'     => $user['user_id'],     // Username login
    'level_admin' => $user['level_admin'], // Integer level hak akses
    'jabatan'     => $user['jabatan'],     // Jabatan struktural
    'web_id'      => $user['web_id'] ?? 1,
    'ip'          => $_SERVER['REMOTE_ADDR'],
    'his_log'     => $user['his_log'] ?? '',
    'demo'        => $user['on_demo'] ?? '',
);
$this->session->set($arrUser);

3.2 Hierarki Level Pengguna

3.3 Titik Penyaringan & Pembatasan Otorisasi

• Penyaringan Menu (`Models/Cms/CmsNavigation.php:23-28`):

php
   $level = $this->session->get('level_admin');
   if ($level == '1') {
       $query = $this->db->query("SELECT * FROM cms_navigation WHERE (user_level = '1' OR user_level = '2') AND sub_from_id = '0' ORDER BY lis");
   } else {
       $query = $this->db->query("SELECT * FROM cms_navigation WHERE user_level = '$level' AND sub_from_id = '0' ORDER BY lis");
   }
   

• Pencegahan Bypass URL Langsung (`Models/Cms/CmsContent.php:69-98`):

php
   if ($level == '1') {
       $proNav = outRow('cms_navigation', "id = '".$this->idnav."' AND (user_level = '1' OR user_level = '2')", '');
   } else {
       $proNav = outRow('cms_navigation', ['id' => $this->idnav, 'user_level' => $level], '');
   }
   if (empty($proNav['id'])) {
       return '<div class="info my-4 mx-auto border w-50 p-4 text-center"> You do not have the authority to add to this data property <br><i>~ Please check in permission level ' . $level . ' navid ' . $this->idnav . ' ~</i></div>';
   }
   

4. POLA ENDPOINT & AJAX ACTION (ROUTING & DATA EXCHANGE)

4.1 Mekanisme Chaining `urinext()`

4.2 Pola Routing Modular di `Controllers/Cms.php:57-69`

php
public function body_content(){ 
    $data = ''; 
    if (urinext('cms') == 'mdl') {
        // Memanggil Model pada namespace App\Models\Modul\Mdl_{nama}
        $mdl = model('App\Models\Modul\Mdl_' . urinext('mdl'));
        $data = $mdl->home();
    } else if (urinext('cms') == 'sip') {
        // Memanggil Model pada namespace App\Models\Sipasi\Mdl_{nama}
        $mdl = model('App\Models\Sipasi\Mdl_' . urinext('sip'));
        $data = $mdl->home();
    } else {
        // Default engine listing CMS
        $data = $this->cmsContent->home(); 
    }
    return $data;
}

4.3 Studi Kasus Pola AJAX: `Mdl_skema_jaringan.php` (`Models/Sipasi/Mdl_skema_jaringan.php:38-125`)

[ Frontend Javascript AJAX ]
       │
       │ POST: /cms/sip/skema_jaringan/simpan_giliran
       │ Data: { id, nama_giliran, total_durasi, data_json, ... }
       ▼
Controllers/Cms.php::body_content()
       │
       ├─► urinext('cms') == 'sip'
       └─► Instantiate: App\Models\Sipasi\Mdl_skema_jaringan -> home()
                │
                ▼
Models/Sipasi/Mdl_skema_jaringan.php::home()
       │
       ├─► urinext('skema_jaringan') == 'simpan_giliran'
       └─► Eksekusi simpan_giliran()
                │
                ├─ Validasi request method (POST)
                ├─ Validasi payload ($nama_giliran tidak kosong)
                ├─ Database Operation: $this->db->table('dd_giliran')->insert/update
                └─ Return Respon JSON:
                   exit(json_encode(['valid' => 1, 'id' => $new_id, 'message' => '...']));

Standar Format Respon JSON CMS SIPASI:

• Respon Berhasil:

json
  {
    "valid": 1,
    "id": 105,
    "message": "Data berhasil disimpan."
  }
  

• Respon Gagal / Validasi Eror:

json
  {
    "valid": 0,
    "error": "Nama giliran tidak boleh kosong."
  }
  

• Respon Modal Pop-up (HTML Plain):

json
  {
    "valid": 1,
    "htm": "<div class='detail-view'>...content...</div>"
  }
  

4.4 Generic Data Provider: `Mdl_db_ajax.php` (`Models/Modul/Mdl_db_ajax.php:21-99`)

• URL: `POST /cms/mdl/db_ajax`
• Parameter POST:
• `table`: Nama tabel (dilindungi regex whitelist `/^[a-zA-Z0-9_]+$/`).
• `fl`: Daftar kolom (misal: `id,name,id_key,last_update`).
• `wh`: Klausa filter sanitasi (misal: `status='Active'`).
• `opt`: Sorting/Limit tambahan (misal: `ORDER BY id DESC LIMIT 10`).
• Respon Output: `{"table": "...", "list": [...], "ttl": N}`.

5. RESEP PEMBUATAN MODUL BARU: 'MONITORING TELEMETRI & CCTV'

• Realtime Telemetri: Data sensor debit/TMA/baterai terakhir per device (`dd_device_in_minute` JOIN `dts_device_node`).
• Status Heartbeat: Indikator *Online / Offline* berdasarkan selisih waktu `last_update` terhadap interval `dtime` device.
• Galeri Snapshot CCTV: Menampilkan foto kamera terbaru dari tabel `dd_device_image`.
• Flatten Video .dav: Daftar arsip video `.dav` hasil flatten crawler storage.

5.1 Rekomendasi Arsitektur: Mode 'model'

5.2 Skrip SQL Registrasi Menu CMS (`cms_navigation`)

sql
-- 1. Ambil urutan lis terakhir pada sub_from_id = 27
-- 2. Insert menu 'Monitoring Telemetri & CCTV'
INSERT INTO `cms_navigation` (
  `lang_code`,
  `web_id`,
  `position`,
  `tabmenu`,
  `sub_from_id`,
  `lis`,
  `user_level`,
  `title`,
  `sub_title`,
  `id_protab`,
  `view_mode`,
  `val`,
  `inhome`,
  `lisinhome`,
  `icon`,
  `description`,
  `hidden`
) VALUES (
  'id',
  '1',
  'top',
  NULL,
  27,                                     -- sub_from_id = 27 (Induk: Monitoring)
  20,                                     -- lis = urutan tampilan
  2,                                      -- user_level = 2 (Admin & SuperAdmin)
  'Monitoring Telemetri & CCTV',          -- Title menu
  'Realtime Status, Sensor & CCTV Node',  -- Subtitle
  0,                                      -- id_protab = 0 (karena mode model)
  'model',                                -- view_mode = model
  'Sipasi\\Mdl_monitoring_telemetri',    -- val = Target Model CI4
  NULL,
  0,
  '<i class=\"fa-duotone fa-tower-broadcast fa-lg\"></i>', -- Icon
  'Modul monitoring terpadu telemetri, heartbeat status, dan visual CCTV',
  0
);

5.3 Skeleton & Implementasi Backend Model CI4

php
<?php

namespace App\Models\Sipasi;

use App\Controllers\BaseController;

helper('bassic');

class Mdl_monitoring_telemetri extends BaseController
{
    protected $db;
    protected $session;
    protected $request;
    protected $parser;
    protected $id_di;

    public function __construct()
    {
        $this->parser  = service('parser');
        $this->session = \Config\Services::session();
        $this->request = \Config\Services::request();
        $this->db      = \Config\Database::connect();
        $this->id_di   = env('id_di') ?? 1;
    }

    /**

Dispatcher utama modul

     */
    public function home()
    {
        // AJAX Endpoints
        if (urinext('monitoring_telemetri') === 'ajax_realtime') {
            return $this->ajax_realtime();
        }
        if (urinext('monitoring_telemetri') === 'ajax_cctv') {
            return $this->ajax_cctv();
        }
        if (urinext('monitoring_telemetri') === 'ajax_dav_videos') {
            return $this->ajax_dav_videos();
        }

        // Tampilan antarmuka utama
        return $this->render_dashboard();
    }

    /**

Render UI Utama Dashboard Monitoring

     */
    public function render_dashboard()
    {
        $arrData = [
            'BASE_URL'       => base_url(),
            'TITLE'          => 'Monitoring Telemetri & CCTV',
            'DEVICES_STATUS' => $this->get_devices_status(),
            'CCTV_GALLERY'   => $this->get_cctv_latest(),
            'DAV_VIDEOS'     => $this->get_dav_file_list(),
            'DATE_NOW'       => date('d F Y H:i:s'),
        ];

        return $this->parser->setData($arrData)->render('Sipasi/Monitoring_telemetri');
    }

    /**

a & b) Query Telemetri Terakhir + Perhitungan Heartbeat Status

     */
    public function get_devices_status()
    {
        // Query menggabungkan metadata node dengan data telemetri menit terakhir
        $sql = "
            SELECT 
                node.id,
                node.name AS device_name,
                node.id_key,
                node.device_type,
                node.dtime,
                node.location,
                node.last_update AS node_last_update,
                minute.last_update AS telemetry_last_update,
                minute.data_1 AS tma_level,
                minute.data_2 AS debit_val,
                minute.data_3 AS battery_volt,
                minute.data_4 AS signal_rssi,
                -- Perhitungan heartbeat: jika selisih waktu <= (dtime * 2.5) detik maka Online
                CASE 
                    WHEN node.last_update IS NULL THEN 'Offline'
                    WHEN TIMESTAMPDIFF(SECOND, node.last_update, NOW()) <= (COALESCE(node.dtime, 300) * 2.5) THEN 'Online'
                    ELSE 'Offline'
                END AS heartbeat_status,
                TIMESTAMPDIFF(SECOND, node.last_update, NOW()) AS last_seen_seconds
            FROM dts_device_node node
            LEFT JOIN (
                -- Subquery record telemetri paling baru per id_key
                SELECT m1.*
                FROM dd_device_in_minute m1
                INNER JOIN (
                    SELECT id_key, MAX(id) AS max_id
                    FROM dd_device_in_minute
                    GROUP BY id_key
                ) m2 ON m1.id = m2.max_id
            ) minute ON node.id_key = minute.id_key
            WHERE node.status = 'Active'
            ORDER BY node.name ASC
        ";

        return $this->db->query($sql)->getResultArray();
    }

    /**

c) Query Snapshot / CCTV Image Terbaru

     */
    public function get_cctv_latest()
    {
        $sql = "
            SELECT 
                img.id,
                img.id_key,
                img.bg_bagi,
                img.image,
                img.time_image,
                img.image_2,
                img.time_image_2,
                img.last_update,
                node.name AS device_name,
                node.location
            FROM dd_device_image img
            LEFT JOIN dts_device_node node ON img.id_key = node.id_key
            ORDER BY img.last_update DESC
        ";

        return $this->db->query($sql)->getResultArray();
    }

    /**

d) Scan Daftar File Video .dav Flatten

     */
    public function get_dav_file_list($limit = 30)
    {
        $videoDir = FCPATH . 'cctv_storage/videos/';
        $videoList = [];

        if (is_dir($videoDir)) {
            $files = glob($videoDir . '*.dav');
            if ($files) {
                // Urutkan file berdasarkan waktu modifikasi terbaru
                usort($files, function ($a, $b) {
                    return filemtime($b) - filemtime($a);
                });

                $files = array_slice($files, 0, $limit);
                foreach ($files as $file) {
                    $filename = basename($file);
                    $videoList[] = [
                        'filename'   => $filename,
                        'filesize'   => round(filesize($file) / (1024 * 1024), 2) . ' MB',
                        'filetime'   => date('Y-m-d H:i:s', filemtime($file)),
                        'video_url'  => base_url('cctv_storage/videos/' . $filename),
                    ];
                }
            }
        }

        return $videoList;
    }

    /**

AJAX Endpoint: Polling Realtime JSON

     */
    public function ajax_realtime()
    {
        $data = $this->get_devices_status();
        exit(json_encode([
            'valid'     => 1,
            'timestamp' => date('Y-m-d H:i:s'),
            'devices'   => $data,
        ]));
    }

    /**

AJAX Endpoint: CCTV Snapshot Gallery JSON

     */
    public function ajax_cctv()
    {
        $data = $this->get_cctv_latest();
        exit(json_encode([
            'valid'  => 1,
            'images' => $data,
        ]));
    }

    /**

AJAX Endpoint: Video .dav List JSON

     */
    public function ajax_dav_videos()
    {
        $data = $this->get_dav_file_list();
        exit(json_encode([
            'valid'  => 1,
            'videos' => $data,
        ]));
    }
}

5.4 Alternatif: Konfigurasi SQL untuk Mode 'Listing'

sql
-- 1. Insert ke cms_table_property
INSERT INTO `cms_table_property` (
  `admin_level`,
  `table_name`,
  `title`,
  `description`,
  `custom_where`,
  `order_by`,
  `entry_number`,
  `sending`,
  `id_key`,
  `action`,
  `property`,
  `plain_tpl`
) VALUES (
  '1',
  'dts_device_node',
  'Daftar Node Telemetri & CCTV',
  'Master data dan status node telemetri',
  'status = \'Active\'',
  'name',
  25,
  'asc',
  'id',
  ';Detail;',                       -- Read-only listing dengan tombol Detail
  'Search;;;;;Zebra',
  '0'
);

SET @new_protab_id = LAST_INSERT_ID();

-- 2. Insert Field Property ke cms_listing_field
INSERT INTO `cms_listing_field` (`id_table_property`, `listing`, `field_name`, `label`, `size`, `format`, `fvalue`, `in_list`, `in_update`) VALUES
(@new_protab_id, 1, 'id', 'ID', 60, 'text', '{"listing":{"cut":10}}', 0, '111'),
(@new_protab_id, 2, 'name', 'Nama Node / Stasiun', 240, 'text', '{"listing":{"cut":50}}', 1, '000'),
(@new_protab_id, 3, 'id_key', 'Device ID Key', 180, 'text', '{"listing":{"cut":40}}', 1, '000'),
(@new_protab_id, 4, 'device_type', 'Tipe Node', 120, 'text', '{"listing":{"cut":20}}', 1, '000'),
(@new_protab_id, 5, 'location', 'Lokasi Geografis', 180, 'text', '{"listing":{"cut":40}}', 1, '000'),
(@new_protab_id, 6, 'dtime', 'Interval (dtk)', 80, 'number', '{"listing":{"precision":0}}', 1, '000'),
(@new_protab_id, 7, 'last_update', 'Heartbeat Terakhir', 160, 'datetime', '{"listing":{"dateformat":"d-m-Y H:i:s"}}', 1, '110'),
(@new_protab_id, 8, 'status', 'Status Node', 100, 'radio', '{"property":{"rawdata":"Active;Disable|Active"}}', 1, '000');

6. TABEL REFERENSI PATH & BUKTI KODE