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/Jadwal/Controllers/

Edit File: Jadwal.php

<?php

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

class Jadwal extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Jadwal';
        $data['li_1']   = 'Daftar Jadwal';
        $data['body']   = 'Modules\Jadwal\Views\list';
        $db = $this->db->table('jadwal');

$db->select('jadwal.*, mapel.kode, mapel.nama as nama_mapel, guru.nama as nama_guru, kelas.kelas, kelas.rombel')
        ->join('mapel', 'jadwal.id_mapel = mapel.id')
        ->join('guru', 'jadwal.id_guru = guru.id')
        ->join('kelas', 'jadwal.id_kelas = kelas.id');

if(session()->has('id_sp') && session('id_sp') != '0'){
            $db->where(['jadwal.id_sp' => session('id_sp')]);
            $db->where(['jadwal.id_tp' => session('id_tp')]);
        }else{
            session()->setFlashData(gagal("Pilih Lembaga dan Tahun Pelajaran Dulu"));
            return redirect('jadwal');
        }

$m = $this->db->table('mapel');
        $m->where(['mapel.id_sp' => session('id_sp')]);

$g = $this->db->table('guru');
        $g->where(['guru.id_sp' => session('id_sp')]);

$k = $this->db->table('kelas');
        $k->where(['kelas.id_sp' => session('id_sp')]);

$data['guru']  = $g->get()->getResult();
        $data['kelas']  = $k->get()->getResult();
        $data['mapel']  = $m->get()->getResult();
        $data['data']  = $db->get()->getResult();

//print_r($data['kelas']);

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('jadwal');
        }
        if($p['id_tp'] == '' || $p['id_tp'] == null){
            session()->setFlashData(gagal("Pilih Tahun Pelajaran Dulu"));
            return redirect('jadwal');
        }

$rules = [
            'mapel' => [
                'label'  => 'Mata Pelajaran',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'kelas' => [
                'label'  => 'Kelas',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'guru' => [
                'label'  => 'Guru',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'hari' => [
                'label'  => 'Hari',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'mulai' => [
                'label'  => 'Jam Mulai',
                'rules'  => 'required|regex_match[/^([01]?[0-9]|2[0-3]):[0-5][0-9]$/]',
                'errors' => [
                    'required'    => '{field} harus diisi.',
                    'regex_match' => 'Format {field} tidak valid. Gunakan format HH:MM (misalnya 14:30).'
                ]
            ],
            'sampai' => [
                'label'  => 'Jam Selesai',
                'rules'  => 'required|regex_match[/^([01]?[0-9]|2[0-3]):[0-5][0-9]$/]',
                'errors' => [
                    'required'    => '{field} harus diisi.',
                    'regex_match' => 'Format {field} tidak valid. Gunakan format HH:MM (misalnya 14:30).'
                ]
            ],
        ];

if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('jadwal'));
        }
        
        $db = $this->db->table('jadwal');
        
        $id = Uuid::uuid4()->toString();
        $insert = [
            'id' => $id,
            'id_sp' => $p['id_lembaga'],
            'id_tp' => $p['id_tp'],
            'id_mapel' => $p['mapel'],
            'id_guru' => $p['guru'],
            'id_kelas' => $p['kelas'],
            'hari'    => $p['hari'],
            'mulai'    => $p['mulai'],
            'selesai'    => $p['sampai'],
        ];
    
        $db->insert($insert);
        session()->setFlashData(success('Berhasil menambah Data'));
        return redirect('jadwal');
    }

public function edit(){
        $p = $this->request->getPost();
        
        $rules = [
            'mapel' => [
                'label'  => 'Mata Pelajaran',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'kelas' => [
                'label'  => 'Kelas',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'guru' => [
                'label'  => 'Guru',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'hari' => [
                'label'  => 'Hari',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ],
            'mulai' => [
                'label'  => 'Jam Mulai',
                'rules'  => 'required|regex_match[/^([01]?[0-9]|2[0-3]):[0-5][0-9]$/]',
                'errors' => [
                    'required'    => '{field} harus diisi.',
                    'regex_match' => 'Format {field} tidak valid. Gunakan format HH:MM (misalnya 14:30).'
                ]
            ],
            'sampai' => [
                'label'  => 'Jam Selesai',
                'rules'  => 'required|regex_match[/^([01]?[0-9]|2[0-3]):[0-5][0-9]$/]',
                'errors' => [
                    'required'    => '{field} harus diisi.',
                    'regex_match' => 'Format {field} tidak valid. Gunakan format HH:MM (misalnya 14:30).'
                ]
            ],
        ];

if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('jadwal'));
        }
        $update = [
            'id_sp' => $p['id_lembaga'],
            'id_tp' => $p['id_tp'],
            'id_mapel' => $p['mapel'],
            'id_guru' => $p['guru'],
            'id_kelas' => $p['kelas'],
            'hari'    => $p['hari'],
            'mulai'    => $p['mulai'],
            'selesai'    => $p['sampai'],
        ];

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

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

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