Default page

Edit File: Kelompok.php

<?php

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

class Kelompok extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Kelompok Riset';
        $data['li_1']   = 'Daftar Kelompok';
        $data['body']   = 'Modules\Kelompok\Views\list';
        $data['data']   = $this->db->table('kelompok')
                            ->select('kelompok.*, tahun.nama as tahun, file.nama as nama_sk')
                            ->join('tahun', 'kelompok.id_tahun = tahun.kode')
                            ->join('file', 'kelompok.id_sk = file.id')
                            ->where('kelompok.id_tahun', session('tahun'))
                            ->get()->getResult();

$data['tahun']  = $this->db->table('tahun')
                            ->get()->getResult();
        $data['file']  = $this->db->table('file')
                            ->get()->getResult();
        return view('backend', $data);
    }

public function detail($id=null){
        $data['title']  = 'Detail Kelompok';
        $data['li_1']   = 'Detail Kelompok';
        $data['body']   = 'Modules\Kelompok\Views\detail';
        $data['kelompok']   = $this->db->table('kelompok')
                            ->where('id', $id)->get()->getRow();

$data['anggota_dosen']   = $this->db->table('anggota')
            ->select('anggota.*, dosen.nama, dosen.nip, dosen.id_dosen')
            ->join('dosen', 'anggota.id_anggota = dosen.id_dosen')
            ->join('kelompok', 'kelompok.id = anggota.id_kelompok')
            ->where('kelompok.id', $id)
            ->orderBy('anggota.ketua', 'DESC')
            ->get()->getResult();

$data['anggota_mhs']   = $this->db->table('anggota')
            ->select('anggota.*, mhs.nama, mhs.nim, mhs.id_mhs')
            ->join('mhs', 'anggota.id_anggota = mhs.id_mhs')
            ->join('kelompok', 'kelompok.id = anggota.id_kelompok')
            ->where('kelompok.id', $id)
            ->orderBy('anggota.ketua', 'DESC')
            ->get()->getResult();

$data['kk'] = 'Belum Di set';

foreach ($data['anggota_mhs'] as $k) {
            if($k->ketua == 'Ketua'){
                $data['kk'] = $k->nama;
            }
        }

foreach ($data['anggota_dosen'] as $k) {
            if($k->ketua == 'Ketua'){
                $data['kk'] = $k->nama;
            }
        }
        $data['dosen']   = $this->db->table('dosen')->where('homebase !=', 0)->get()->getResult();
        $data['mhs']   = $this->db->table('mhs')->get()->getResult();
        return view('backend', $data);
    }

public function setKk($id, $id_kelompok){
        $db = $this->db->table('anggota');
        $db->where('id_kelompok', $id_kelompok)->update(['ketua' => "Anggota"]);
        $db->where('id', $id)->update(['ketua' => "Ketua"]);
        session()->setFlashData(success('Berhasil Menyimpan Data'));
        return redirect()->back();
    }

public function tambah_anggota(){
        $p = $this->request->getPost();
        $jml = count($p['id_anggota']);
        $exe = FALSE;
        for($i=0; $i<$jml; $i++){
            $id = Uuid::uuid4()->toString();
            $input[] = [
                "id" => $id, 
                "id_kelompok" => $p['data_id'],
                "tahun" => session('tahun'),
                "id_anggota" => $p['id_anggota'][$i],
                "jenis" => $p['jenis'][$i],
                "ketua" => 'Anggota'
            ];
            $exe = TRUE;
        }
        $this->db->table('anggota')->insertBatch($input);
        session()->setFlashData(success('Berhasil Menyimpan Data'));
        return redirect()->back();
    }

public function hapus_anggota($id = null){
        $this->db->table('anggota')->where(["id" => $id])->delete();
        session()->setFlashData(success('Berhasil Menghapus Data'));
        return redirect()->back();
    }

public function add(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Nama Kelompok Riset',
                '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.',
                ],
            ],
            'tema' => [
                'label'  => 'Tema Riset',
                'rules'  => 'required|min_length[3]',
                'errors' => [
                    'required'    => '{field} tidak boleh kosong.',
                    'min_length'  => '{field} minimal {param} karakter.',
                ],
            ],
            'tahun' => [
                'label'  => 'Tahun',
                'rules'  => 'required|numeric|min_length[5]|max_length[5]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'numeric' => '{field} hanya boleh berisi huruf dan angka.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'file' => [
                'label'  => 'Tahun',
                '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('admin/kelompok'));
        }

$id = Uuid::uuid4()->toString();
        $d = [
            'id' => $id,
            'nama' => $p['nama'],
            'tema'    => $p['tema'],
            'id_sk'    => $p['file'],
            'id_tahun'  => $p['tahun'],
        ];

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

}

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

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

public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'nama' => [
                'label'  => 'Nama Kelompok Riset',
                '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.',
                ],
            ],
            'tema' => [
                'label'  => 'Tema Riset',
                'rules'  => 'required|min_length[3]',
                'errors' => [
                    'required'    => '{field} tidak boleh kosong.',
                    'min_length'  => '{field} minimal {param} karakter.',
                ],
            ],
            'tahun' => [
                'label'  => 'Tahun',
                'rules'  => 'required|numeric|min_length[5]|max_length[5]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'numeric' => '{field} hanya boleh berisi huruf dan angka.',
                    'min_length'    => '{field} minimal {param} karakter.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'file' => [
                'label'  => 'Tahun',
                '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('admin/kelompok'));
        }
        $d = [
            'nama' => $p['nama'],
            'tema'    => $p['tema'],
            'id_sk'    => $p['file'],
            'id_tahun'  => $p['tahun'],
        ];

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