Default page

Viewing : Guru.php

<?php

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

class Guru extends BaseController
{
    
    public function index()
    {
        $data['title']  = 'Guru';
        $data['li_1']   = 'Daftar Guru';
        $data['body']   = 'Modules\Guru\Views\list';
        $db = $this->db->table('guru');                         
        if(session()->has('id_sp') && session('id_sp') != '0'){
            $db->where(['guru.id_sp' => session('id_sp')]);
        }
        $data['data']  = $db->get()->getResult();;

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

    public function verifikasi(){
        $db = $this->db->table('sp');
        $db->where(['id' => session('id_sp')]);
        $data['sp'] = $db->get()->getResult();

        $data['tp'] = $this->db->table('tp')->where(['id_sp' => session('id_sp')])->get()->getResult();
        // Validasi file yang diunggah
        $validationRule = [
            'upload' => [
                'label' => 'File Upload',
                'rules' => 'uploaded[upload]|ext_in[upload,xls,xlsx]',
                'errors' => [
                    'uploaded' => 'Harus ada file yang diupload.',
                    'ext_in' => 'File harus berekstensi XLS atau XLSX.'
                ],
            ],
        ];

        if (! $this->validate($validationRule)) {
            session()->setFlashData(gagal(form_error($this->validator->getErrors())));
            return redirect()->to(base_url('guru'));
        }

        // Ambil file yang diunggah
        $file = $this->request->getFile('upload');

        // Pastikan file berhasil diunggah dan tidak ada error
        if ($file->isValid() && ! $file->hasMoved()) {
            // Pindahkan file sementara ke lokasi yang bisa diakses oleh PhpSpreadsheet
            // Disarankan untuk memindahkan ke direktori writable, contoh: writable/uploads
            $newName = $file->getRandomName(); // Buat nama unik untuk file
            $file->move(WRITEPATH . 'uploads', $newName); // Pindahkan file

            $filePath = WRITEPATH . 'uploads/' . $newName;

            try {
                // Muat file spreadsheet menggunakan IOFactory
                $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($filePath);

                // Ambil sheet aktif
                $sheet = $spreadsheet->getActiveSheet();

                // Konversi data sheet menjadi array
                // toArray() akan mengembalikan semua sel di sheet sebagai array 2D
                $dt = $sheet->toArray();

                // Hapus file sementara setelah dibaca
                unlink($filePath);
                $data['title']  = 'Verifikasi Data';
                $data['li_1']   = 'Verifikasi Data';
                $data['body']   = 'Modules\Guru\Views\verifikasi';
                $data['data']  = $dt;

                return view('template', $data);
            } catch (\PhpOffice\PhpSpreadsheet\Reader\Exception $e) {
                // Tangani error jika terjadi masalah saat membaca file
                session()->setFlashData(gagal($e->getMessage()));
                return redirect()->to(base_url('guru'));
            }
        } else {
            // Tangani jika ada masalah dengan proses upload
            session()->setFlashData(gagal($file->getErrorString()));
            return redirect()->to(base_url('guru'));
        }
    }

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

        if($p['id_lembaga'] == '' || $p['id_lembaga'] == null){
            session()->setFlashData(gagal("Pilih ID Lembaga Dulu"));
            return redirect('guru');
        }

        $db = $this->db->table('guru');
        
        $db->where(['id_sp' => $p['id_lembaga']])->delete();
        $insert = [];
        $input = FALSE;
        for($i=0; $i < count($p['nip']); $i++){
            $input = TRUE;
            $id = Uuid::uuid4()->toString();
            $insert[] = [
                'id' => $id,
                'id_sp' => $p['id_lembaga'],
                'nama' => $p['nama'][$i],
                'nip'    => $p['nip'][$i],
            ];
        }

        if($input){
            $db->insertBatch($insert);
        }
        session()->setFlashData(success('Berhasil menambah '.count($insert).' Data '));
        return redirect('guru');
    }

    public function edit(){
        $p = $this->request->getPost();
        $rules = [
            'nip' => [
                'label'  => 'Nip',
                'rules'  => 'required|max_length[10]',
                'errors' => [
                    'required'      => '{field} tidak boleh kosong.',
                    'max_length'    => '{field} maksimal {param} karakter.',
                ],
            ],
            'nama' => [
                'label'  => 'Nama',
                '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('guru'));
        }
        $update = [
            'nip'    => $p['nip'],
            'nama'  => $p['nama'],
        ];

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

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

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

    public function generate_pass(){
        $pw = $this->haspw(8, true);
        $update = [
            'pass' => $pw,
            'password' => password_hash($pw, PASSWORD_DEFAULT),
        ];
        if($this->db->table('guru')->where('id_sp', session('id_sp'))->update($update)){
            session()->setFlashData(success('Berhasil Menyimpan Data'));
            return redirect()->to(base_url('guru'));            
        }else{
            session()->setFlashData(gagal('Masalah Koneksi Database'));
            return redirect()->to(base_url('guru'));    
        }
    }

    public function generate_token(){
        $id_sp = session('id_sp');
        $t = $this->db->table('guru');
        $d = $t->where('id_sp', $id_sp)->get()->getResult();
        foreach ($d as $k) {
            $pw = $this->haspw(100, false);
            $u = $t->where('id', $k->id)->update(['token' => $pw]);
        }
        session()->setFlashData(success('Berhasil Menyimpan Data'));
        return redirect()->back();  
    }

    public function haspw($length = 10, $jenis = false)
    {
        // Karakter yang akan digunakan untuk membuat password
        if($jenis){
            $chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$&*';
        }else{
            $chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';            
        }
        
        $password = '';
        // Ambil karakter secara acak sebanyak $length
        for ($i = 0; $i < $length; $i++) {
            $password .= $chars[rand(0, strlen($chars) - 1)];
        }
        
        // Contoh: Mengirim sebagai JSON
        return $password;
    }
}