Default page

Viewing : Tp.php

<?php

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

class Tp extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Tahun Pelajaran';
        $data['li_1']   = 'Daftar Tahun Pelajaran';
        $data['body']   = 'Modules\Tp\Views\list';
        $data['sp'] = $this->db->table('sp')->get()->getResult();
        $sp = $this->db->table('tp');
        $sp->select('tp.*, sp.nama as nm_lembaga')->join('sp', 'on tp.id_sp = sp.id', 'left');
        if(session()->has('id_sp') && session('id_sp') != '0'){
            $sp->where(['id_sp' => session('id_sp')]);
        }
        $data['data']  = $sp->get()->getResult();
        return view('template', $data);
    }

    public function add(){
        $p = $this->request->getPost();
        $rules = [
            'kode' => [
                'label'  => 'Kode Tahun Pelajaran',
                '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.',
                ],
            ],
            'nama' => [
                'label'  => 'Nama Tahun Pelajaran',
                '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.',
                ],
            ],
            'tahun' => [
                'label'  => 'Tahun Pelajaran',
                'rules'  => 'required|numeric|min_length[4]|max_length[4]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                    'numeric'    => '{field} Hanya karakter angka yang diizinkan.',
                ],
            ],
            'id_lembaga' => [
                'label'  => 'lembaga',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ]
        ];

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

        $id = Uuid::uuid4()->toString();
        $d = [
            'id' => $id,
            'kode' => $p['kode'],
            'nama' => $p['nama'],
            'tahun'    => $p['tahun'],
            'id_sp'    => $p['id_lembaga'],
        ];

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

    }

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

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

    public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'kode' => [
                'label'  => 'Kode Tahun Pelajaran',
                '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.',
                ],
            ],
            'nama' => [
                'label'  => 'Nama Tahun Pelajaran',
                '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.',
                ],
            ],
            'tahun' => [
                'label'  => 'Tahun Pelajaran',
                'rules'  => 'required|numeric|min_length[4]|max_length[4]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'id_lembaga' => [
                'label'  => 'lembaga',
                'rules'  => 'required',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                ],
            ]
        ];

        if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('tp'));
        }
        $d = [
            'kode' => $p['kode'],
            'nama' => $p['nama'],
            'tahun'    => $p['tahun'],
            'id_sp'    => $p['id_lembaga'],
        ];

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

    public function get_all($id = null){
        $db = $this->db->table('tp');
        if($id != '0'){
            $db->where('id_sp', $id);
        }
        
        $d = $db->get()->getResult();
        return json_encode($d);
    }

    public function set_sesi($id = null){
        if($id != '0'){
            $tp = $this->db->table('tp')->where('id_sp', $id)->where('aktif', '1')->get()->getRow();

            if(isset($tp->id)){
                session()->set('id_tp', $tp->id);
            }else{
                session()->set('id_tp', '');
            }
            session()->set('id_sp', $id);
            session()->setFlashData(success("Berhasil Merubah Sesi (".$id.")"));
        }else{
            session()->remove('id_sp');
            session()->remove('id_tp');
            session()->setFlashData(success("Berhasil Menghapus Sesi"));

        }
        return json_encode("OK");
    }

    public function set_tp($id = null){
        if($id != '0'){
            session()->set('id_tp', $id);
        }else{
            session()->remove('id_tp');
        }
        return json_encode("OK");
    }

    public function set_aktif($id = null){
        $db = $this->db->table('tp');
        $clear = $db->update(['aktif' => '0']);
        
        $set = $db->where('id', $id)->update(['aktif' => '1']);
        
        session()->setFlashData(success('Berhasil Menyimpan Data'));
        return redirect()->back(); 
    }
}