Default page

⚝ One Hat Cyber Team ⚝

Your IP: 192.168.31.6
Server IP: 192.168.1.11
Server: Linux pams 6.1.0-29-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.123-1 (2025-01-02) x86_64
PHP Version: 8.2.28
Buat File | Buat Folder

Dir : ~/var/www/pams/modules/Device/Controllers/

Edit File: Device.php

<?php

namespace Modules\Device\Controllers;
use App\Controllers\BaseController;
use Ramsey\Uuid\Uuid;

class Device extends BaseController
{
    
    public function index(): string
    {
        $data['title']  = 'Device';
        $data['li_1']   = 'Daftar Device';
        $data['body']   = 'Modules\Device\Views\list';
        $data['dt']  = $this->db->table('device')->get()->getResult();
        $data['toko']  = $this->db->table('toko')->get()->getResult();
        foreach ($data['toko'] as $k) {
            $data['nm_toko'][$k->id] = $k->nama;
        }

return view('template', $data);
    }

public function add(){
        $p = $this->request->getPost();
        $id = Uuid::uuid4()->toString();
        $rules = [
            'nama' => [
                'label'  => 'Nama Toko',
                'rules'  => 'required|min_length[3]|max_length[100]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'sn' => [
                'label'  => 'sn',
                'rules'  => 'required|alpha_numeric|max_length[14]|min_length[12]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'alpha_numeric' => '{field} hanya boleh angka.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
        ];
        if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('device'));
        }

$d = [
            'id' => $id,
            'nama' => $p['nama'],
            'sn' => $p['sn'],
            'id_toko' => $p['id_toko'],
        ];

if($this->db->table('device')->insert($d)){
            session()->setFlashData(success('Berhasil Menyimpan Data'));
            return redirect()->to(base_url('device'));            
        }else{
            session()->setFlashData(gagal('Masalah Koneksi Database'));
            return redirect()->to(base_url('device'));    
        }
    }

public function delete($id = null){
        if($this->db->table('device')->where('id', $id)->delete()){
            session()->setFlashData(success('Berhasil Mengapus Data'));
            return redirect()->to(base_url('device'));            
        }else{
            session()->setFlashData(gagal('Masalah Koneksi Database'));
            return redirect()->to(base_url('device'));    
        }
    }

public function get($id = null){
        $d = $this->db->table('device')->where('id', $id)->get()->getRow();
        return json_encode($d);
    }

public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Nama Toko',
                'rules'  => 'required|min_length[3]|max_length[100]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'sn' => [
                'label'  => 'sn',
                'rules'  => 'required|alpha_numeric|max_length[14]|min_length[12]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'alpha_numeric' => '{field} hanya boleh angka.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
        ];

if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('device'));
        }
        $d = [
            'nama' => $p['nama'],
            'sn' => $p['sn'],
            'id_toko' => $p['id_toko'],
        ];

if($this->db->table('device')->where('id', $p['id'])->update($d)){
            session()->setFlashData(success('Berhasil Menyimpan Data'));
            return redirect()->to(base_url('device'));            
        }else{
            session()->setFlashData(gagal('Masalah Koneksi Database'));
            return redirect()->to(base_url('device'));    
        }
    }

public function table(){
        $b = $this->db->table('device');
        $b->select('device.*, toko.nama as nama_toko');
        $b->join('toko', 'device.id_toko = toko.id', 'inner');
        $r = $b->get();
        $i=0;
        foreach ($r->getResult() as $k) {
            $dt[$i]['sn'] = $k->sn;
            $dt[$i]['nama'] = $k->nama;
            $dt[$i]['toko'] = $k->nama_toko;
            $dt[$i]['net'] = esc(status_mesin($k->stamp_op) ?? '0');
            $dt[$i]['aksi'] = '
                <a class="btn btn-sm btn-warning" onclick="add(`'.$k->id.'`)">Edit</a>&nbsp;
                <a class="btn btn-sm btn-danger" onclick="hapus(`device/delete/'.$k->id.'`)">Hapus</a>&nbsp;
                <a class="btn btn-sm btn-primary" href="'.base_url('device/detail/').$k->id.'">Detail</a>
            ';
            $i++;
        }

return $this->response->setJSON($dt);
    }

public function cek(){
        $d = $this->db->table('device')->get()->getResult();
        return json_encode($d);
    }

public function detail($id){
        $data['title']  = 'Device';
        $data['li_1']   = 'Detail Device';
        $data['li_1']   = 'Device/Detail Device';
        $data['body']   = 'Modules\Device\Views\detail';
        $data['dt']  = $this->db->table('device')->where(["id" => $id])->get()->getRow();
        $data['tugas']  = $this->db->table('tugas')->where(["id_toko" => $data['dt']->id_toko])->get()->getResult();

$fp = $this->db->query("SELECT id, COUNT(id) as jml FROM att_finger WHERE id IN(SELECT id FROM tugas WHERE id_toko='".$data['dt']->id_toko."') GROUP BY id")->getResult();
        foreach ($fp as $k) {
            $data['fp'][$k->id] = $k->jml;
        }

$face = $this->db->query("SELECT id, COUNT(id) as jml FROM att_face WHERE id IN(SELECT id FROM tugas WHERE id_toko='".$data['dt']->id_toko."') GROUP BY id")->getResult();
        foreach ($face as $k) {
            $data['fp'][$k->id] = $k->jml;
        }
        return view('template', $data);
    }

}