<?php

use Restserver\Libraries\REST_Controller;

defined('BASEPATH') or exit('No direct script access allowed');

require APPPATH . 'libraries/REST_Controller.php';
require APPPATH . 'libraries/Format.php';

class Admin extends REST_Controller
{
    public function __construct()
    {
        parent::__construct();
        is_logged_in();
        $this->load->model('Danggota_model');
        $this->load->model('Setoran_model');
        $this->load->model('Pinjaman_model');
    }
    public function index_get()
    {
        $data['title'] = 'Dashboard';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['all'] = $this->Danggota_model->getAllAnggota();
        $data['totalP'] = $this->Pinjaman_model->total_pinjaman();
        $data['totalB'] = $this->Pinjaman_model->totalBayar();
        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/index', $data);
        $this->load->view('templates/footer');
    }
    public function role_get()
    {
        $data['title'] = 'Role Management';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['role'] = $this->db->get('user_role')->result_array();
        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/role', $data);
        $this->load->view('templates/footer');
    }
    public function delete_role($id)
    {
        $this->load->model('Drole_model', 'admin');
        $this->admin->deleteRole($id);
        $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Role Dihapus </div>');
        redirect('admin/role');
    }
    public function roleAccess_get($role_id)
    {
        $data['title'] = 'Role Access';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['role'] = $this->db->get_where('user_role', ['id' => $role_id])->row_array();
        $this->db->where('id !=', 1);
        $data['menu'] = $this->db->get('user_menu')->result_array();

        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/role-access', $data);
        $this->load->view('templates/footer');
    }
    public function changeAccess()
    {
        $menu_id = $this->input->post('menuId');
        $role_id = $this->input->post('roleId');

        $data = [
            'role_id' => $role_id,
            'menu_id' => $menu_id
        ];

        $result = $this->db->get_where('user_access_menu', $data);
        if ($result->num_rows() < 1) {
            $this->db->insert('user_access_menu', $data);
        } else {
            $this->db->delete('user_access_menu', $data);
        }
        $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Access telah diubah ! </div>');
    }
    public function dataanggota_get()
    {
        $data['title'] = 'Data Anggota';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['dataanggota'] = $this->db->get('data_anggota')->result_array();

        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/dataanggota', $data);
        $this->load->view('templates/footer');
    }
    public function dataanggota_post()
    {
        $this->form_validation->set_rules('name', 'Nama', 'required');
        $this->form_validation->set_rules('alamat', 'Alamat', 'required');
        $this->form_validation->set_rules('jenis_kelamin', 'Jenis Kelamin', 'required');
        $this->form_validation->set_rules('telpon', 'Telepon', 'required|numeric');

        if ($this->form_validation->run() == TRUE) {
            $data = [
                'name' => $this->input->post('name'),
                'alamat' => $this->input->post('alamat'),
                'jenis_kelamin' => $this->input->post('jenis_kelamin'),
                'telpon' => $this->input->post('telpon'),
            ];
            $this->db->insert('data_anggota', $data);
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Anggota Baru Ditambahkan </div>');
            redirect('admin/dataanggota');
            $this->response([
                'status' => TRUE,
                'message' => 'Data Anggota Baru Ditambahkan'
            ], REST_Controller::HTTP_CREATED);
        } else {
            $this->session->set_flashdata('message', '<div class="alert alert-danger" role="alert">Data Anggota Baru Gagal Ditambahkan </div>');
            redirect('admin/dataanggota');
            $this->response([
                'status' => FALSE,
                'message' => 'Data Anggota Gagal Ditambahkan'
            ], REST_Controller::HTTP_BAD_REQUEST);
        }
    }
    public function dataanggota_delete()
    {
        $id = $this->delete('id');
        if ($id === null) {
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Gagal menghapus Data Anggota</div>');
            redirect('admin/dataanggota');
            $this->response([
                'status' => FALSE,
                'message' => 'Id ihapus'
            ], REST_Controller::HTTP_BAD_REQUEST);
        } else {
            $this->Danggota_model->deleteAnggota($id);
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Anggota Dihapus </div>');
            redirect('admin/dataanggota');
            $this->response([
                'status' => TRUE,
                'message' => 'Id ihapus'
            ], REST_Controller::HTTP_OK);
        }
    }
    public function detail_anggota_get($id)
    {
        $data['title'] = 'Detail Anggota';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['dataanggota'] = $this->Danggota_model->getAnggotaById($id);
        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/detail-anggota', $data);
        $this->load->view('templates/footer');
    }
    public function edit_anggota($id)
    {
        $data['title'] = 'Ubah Data Anggota';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['dataanggota'] = $this->Danggota_model->getAnggotaById($id);
        $this->form_validation->set_rules('name', 'Nama', 'required');
        $this->form_validation->set_rules('alamat', 'Alamat', 'required');
        $this->form_validation->set_rules('jenis_kelamin', 'Jenis Kelamin', 'required');
        $this->form_validation->set_rules('telpon', 'Telepon', 'required|numeric');

        if ($this->form_validation->run() == false) {
            $this->load->view('templates/header', $data);
            $this->load->view('templates/sidebar', $data);
            $this->load->view('templates/topbar', $data);
            $this->load->view('admin/edit-anggota', $data);
            $this->load->view('templates/footer');
        } else {
            $data['dataanggota'] = $this->Danggota_model->editAnggota();
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Anggota Berhasil Diubah </div>');
            redirect('admin/dataanggota');
        }
    }
    public function setoran_get()
    {
        $data['title'] = 'Setoran';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['setoran'] = $this->db->get('setoran')->result_array();


        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/setoran', $data);
        $this->load->view('templates/footer');
    }
    public function setoran_post()
    {
        $this->form_validation->set_rules('setoran_id', 'Setoran ID', 'required');
        $this->form_validation->set_rules('name', 'Nama', 'required');
        $this->form_validation->set_rules('nominal', 'Nominal', 'required');
        $this->form_validation->set_rules('tanggal', 'Tanggal', 'required');

        if ($this->form_validation->run() == TRUE) {
            $data = [
                'setoran_id' => $this->input->post('setoran_id'),
                'name' => $this->input->post('name'),
                'nominal' => $this->input->post('nominal'),
                'tanggal' => $this->input->post('tanggal'),
            ];
            $this->db->insert('setoran', $data);
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Setoran Baru Ditambahkan </div>');
            redirect('admin/setoran');
            $this->response([
                'status' => TRUE,
                'message' => 'Data Pinjaman Baru Ditambahkan'
            ], REST_Controller::HTTP_CREATED);
        } else {
            $this->session->set_flashdata('message', '<div class="alert alert-danger" role="alert">Data Setoran Baru Gagal Ditambahkan </div>');
            redirect('admin/setoran');
            $this->response([
                'status' => FALSE,
                'message' => 'Data Setoran Gagal Ditambahkan'
            ], REST_Controller::HTTP_BAD_REQUEST);
        }
    }
    public function edit_setoran($id)
    {
        $data['title'] = 'Ubah Data Setoran';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['setoran'] = $this->Setoran_model->getSetoranById($id);
        $this->form_validation->set_rules('setoran_id', 'Setoran ID', 'required');
        $this->form_validation->set_rules('name', 'Nama Penyetor', 'required');
        $this->form_validation->set_rules('nominal', 'Nominal', 'required|numeric');
        $this->form_validation->set_rules('tanggal', 'Tanggal', 'required');

        if ($this->form_validation->run() == false) {
            $this->load->view('templates/header', $data);
            $this->load->view('templates/sidebar', $data);
            $this->load->view('templates/topbar', $data);
            $this->load->view('admin/edit-setoran', $data);
            $this->load->view('templates/footer');
        } else {
            $data['setoran'] = $this->Setoran_model->editSetoran();
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Setoran Berhasil Diubah</div>');
            redirect('admin/setoran');
        }
    }
    public function delete_setoran($id)
    {
        $this->Setoran_model->deleteSetoran($id);
        $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Setoran Dihapus </div>');
        redirect('admin/setoran');
    }
    public function pinjaman_get()
    {
        $data['title'] = 'Data Pinjaman';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['pinjaman'] = $this->db->get('pinjaman')->result_array();

        $this->load->view('templates/header', $data);
        $this->load->view('templates/sidebar', $data);
        $this->load->view('templates/topbar', $data);
        $this->load->view('admin/pinjaman', $data);
        $this->load->view('templates/footer');
    }
    public function pinjaman_post()
    {
        $this->form_validation->set_rules('name_peminjam', 'Nama', 'required');
        $this->form_validation->set_rules('jml_pinjam', 'Jumlah Pinjam', 'required');
        $this->form_validation->set_rules('bunga', 'Suku Bunga', 'required');
        $this->form_validation->set_rules('angsuran', 'Angsuran', 'required');
        $this->form_validation->set_rules('jatuh_tempo', 'Tempo', 'required');

        if ($this->form_validation->run() == TRUE) {
            $post_data = $this->input->post();

            $cicilan = ($post_data['jml_pinjam'] * $post_data['bunga']) / $post_data['angsuran'];
            $total_bayar = $post_data['angsuran'] * $cicilan;

            $data = [
                'name_peminjam' => $this->input->post('name_peminjam'),
                'jml_pinjam' => $this->input->post('jml_pinjam'),
                'bunga' => $this->input->post('bunga'),
                'angsuran' => $this->input->post('angsuran'),
                'cicilan_bln' => $cicilan,
                'jatuh_tempo' => $this->input->post('jatuh_tempo'),
                'total_bayar' => $total_bayar,
            ];
            $this->db->insert('pinjaman', $data);
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Pinjaman Baru Ditambahkan </div>');
            redirect('admin/pinjaman');
            $this->response([
                'status' => TRUE,
                'message' => 'Data Pinjaman Baru Ditambahkan'
            ], REST_Controller::HTTP_CREATED);
        } else {
            $this->session->set_flashdata('message', '<div class="alert alert-danger" role="alert">Data Pinjaman Baru Gagal Ditambahkan </div>');
            redirect('admin/pinjaman');
            $this->response([
                'status' => FALSE,
                'message' => 'Data Pinjaman Gagal Ditambahkan'
            ], REST_Controller::HTTP_BAD_REQUEST);
        }
    }
    public function delete_pinjaman($id)
    {
        $this->Pinjaman_model->getPinjamanById($id);
        $this->Pinjaman_model->deletePinjaman($id);
        $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Pinjaman Dihapus </div>');
        redirect('admin/pinjaman');
    }
    public function edit_Pinjaman($id)
    {
        $data['title'] = 'Ubah Data Pinjaman';
        $data['user'] = $this->db->get_where('user', ['email' => $this->session->userdata('email')])->row_array();
        $data['pinjaman'] = $this->Pinjaman_model->getPinjamanById($id);

        $this->form_validation->set_rules('name_peminjam', 'Nama Peminjam', 'required');
        $this->form_validation->set_rules('jml_pinjam', 'Jumlah Pinjam', 'required');
        $this->form_validation->set_rules('bunga', 'Suku Bunga', 'required');
        $this->form_validation->set_rules('angsuran', 'Angsuran', 'required');
        $this->form_validation->set_rules('jatuh_tempo', 'Tempo', 'required');

        if ($this->form_validation->run() == false) {
            $this->load->view('templates/header', $data);
            $this->load->view('templates/sidebar', $data);
            $this->load->view('templates/topbar', $data);
            $this->load->view('admin/edit-pinjaman', $data);
            $this->load->view('templates/footer');
        } else {

            $data['pinjaman'] = $this->Pinjaman_model->editPinjaman($id);
            $this->session->set_flashdata('message', '<div class="alert alert-success" role="alert">Data Pinjaman Berhasil Diubah</div>');
            redirect('admin/pinjaman');
        }
    }
}