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/miu/modules/Jurusan/Controllers/

Edit File: Jurusan.php

<?php

namespace Modules\Jurusan\Controllers;
use App\Controllers\BaseController;
use Ramsey\Uuid\Uuid;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class Jurusan extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Jurusan';
        $data['li_1']   = 'Daftar Jurusan';
        $data['body']   = 'Modules\Jurusan\Views\list';
        $db = $this->db->table('jurusan')->select('jurusan.*, sp.nama as nm_lembaga')
                         ->join('sp', 'jurusan.id_sp = sp.id', 'inner');

if(session()->has('id_sp') && session('id_sp') != '0'){
            $db->where(['jurusan.id_sp' => session('id_sp')]);
        }
        
        $data['data']  = $db->get()->getResult();;

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

public function add(){
        $p = $this->request->getPost();

if($p['id_lembaga'] == '' || $p['id_lembaga'] == null){
            session()->setFlashData(gagal("Pilih ID Lembaga Dulu"));
            return redirect('jurusan');
        }
        $rules = [
            'nama' => [
                'label'  => 'Jurusan',
                'rules'  => 'required|max_length[255]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'singkatan' => [
                'label'  => 'Jurusan',
                'rules'  => 'required|max_length[60]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
        ];

if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('jurusan'));
        }

$db = $this->db->table('jurusan');
        $input = TRUE;
        $id = Uuid::uuid4()->toString();
        $insert = [
            'id' => $id,
            'id_sp' => $p['id_lembaga'],
            'nama'    => $p['nama'],
            'singkatan'  => $p['singkatan'],
        ];

if($input){
            $db->insert($insert);
        }

session()->setFlashData(success('Berhasil menambah  Data'));
        return redirect('jurusan');
    }

public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Jurusan',
                'rules'  => 'required|max_length[255]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'singkatan' => [
                'label'  => 'Jurusan',
                'rules'  => 'required|max_length[60]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
        ];

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

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

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

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