Default page

Viewing : Sp.php

<?php

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

class Sp extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Satuan Pendidikan';
        $data['li_1']   = 'Daftar Satuan Pendidikan';
        $data['body']   = 'Modules\Sp\Views\list';
        $d = $this->db->table('user')->get()->getResult();

        $i=0;
        //$level = ['', 'Super Admin', 'Operator', 'Keuangan', 'Wali/Siswa'];
        foreach ($d as $u) {
            if($u->level == '2'){
                $data['op'][$i]['id'] = $u->id;
                $data['op'][$i]['nama'] = $u->nama;
            }elseif($u->level == '3'){
                $data['tu'][$i]['id'] = $u->id;
                $data['tu'][$i]['nama'] = $u->nama;
            }
            $i++;
            $data['nama_user'][$u->id] = $u->nama; 
        }

        $sp = $this->db->table('sp');
        if(session()->has('id_sp') && session('id_sp') != '0'){
            $sp->where(['id' => session('id_sp')]);
        }
        $data['data']  = $sp->get()->getResult();
        return view('template', $data);
    }

    public function add(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Nama Lengkap',
                '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_kepala' => [
                'label'  => 'Nama Kepala',
                '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_keuangan' => [
                'label'  => 'Nama Pejabat Keuangan',
                '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_operator' => [
                'label'  => 'Nama Operator',
                '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.',
                ],
            ],
            'alamat' => [
                'label'  => 'Nama Lengkap',
                'rules'  => 'required|min_length[3]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                ],
            ],
        ];

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

        $id = Uuid::uuid4()->toString();
        $d = [
            'id' => $id,
            'nama' => $p['nama'],
            'nama_kepala'    => $p['nama_kepala'],
            'nama_operator'  => $p['nama_operator'],
            'nama_keuangan' => $p['nama_keuangan'],
            'alamat' => $p['alamat'],
        ];

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

    }

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

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

    public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Nama Lengkap',
                '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_kepala' => [
                'label'  => 'Nama Kepala',
                '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_keuangan' => [
                'label'  => 'Nama Pejabat Keuangan',
                '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_operator' => [
                'label'  => 'Nama Operator',
                '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.',
                ],
            ],
            'alamat' => [
                'label'  => 'Nama Lengkap',
                'rules'  => 'required|min_length[3]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'min_length'    => '{field} minimal {param} karakter.',
                ],
            ],
        ];

        if (! $this->validateData($p,$rules)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('sp'));
        }
        $d = [
            'nama' => $p['nama'],
            'nama_kepala'    => $p['nama_kepala'],
            'nama_operator'  => $p['nama_operator'],
            'nama_keuangan' => $p['nama_keuangan'],
            'alamat' => $p['alamat'],
        ];

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