<?php

class InstansiSubTipeController extends BaseController
{
    public function index()
    {
        $getParams = $this->request->get();

        $getParams['limit'] = $this->getDefaultLimit($getParams);
        $getParams['offset'] = array_key_exists('offset', $getParams) ? $getParams['offset'] : 0;
        $getParams['keyword'] = array_key_exists('keyword', $getParams) ? $getParams['keyword'] : '';
        $getParams['order_by'] = $getParams['order_by'] ?? 'id';
        $getParams['order_direction'] = $getParams['order_direction'] ?? 'asc';

        $params = $this->validate(
            $getParams,
            [
                'limit' => ['validators' => ['digit']],
                'offset' => ['validators' => ['digit']],
                'keyword' => ['validators' => []],
                'id_tipe' => ['validators' => ['digit']],
                'order_by' => ['order_by' => []],
                'order_direction' => ['order_direction' => []]
            ]
        );

        $conditions = "nama ilike :keyword:";
        $bind = [
            'keyword' => '%' . $params['keyword'] . '%'
        ];

        if (!empty($params['id_tipe'])) {
            $conditions .= " AND id_tipe = :id_tipe:";
            $bind["id_tipe"] = $params['id_tipe'];
        }

        $instansi = InstansiSubTipe::find([
            'conditions' => $conditions,
            'bind' => $bind,
            'limit' => $params['limit'],
            'offset' => $params['offset'],
            'order' => $params['order_by'] . ' ' . $params['order_direction']
        ]);

        $total_record = InstansiSubTipe::count([
            'conditions' => $conditions,
            'bind' => $bind,
        ]);

        return new PaginatedResponse($instansi, $total_record, $params['limit'], $params['offset']);
    }

    public function detail($id)
    {
        $this->checkScopes(['admin.view']);

        /** @var InstansiSubTIpe $row */
        $row = InstansiSubTipe::findFirst($id);

        if (empty($row)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data tidak ditemukan');
        }

        return new SimpleResponse($row->toDetail());
    }

    public function create()
    {
        $this->checkScopes(['admin.view']);

        $rawBody = $this->request->getJsonRawBody(true);
        $params = $this->validate(
            $rawBody,
            [
                'nama' => ['validators' => ['required']],
                'id_tipe' => ['validators' => ['required', 'digit']],
            ]
        );

        $instansiTIpe = InstansiTipe::findFirst($params["id_tipe"]);
        if (empty($instansiTIpe)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, "Tipe Instansi tidak ditemukan.");
        }
        if (!empty($instansiTIpe->deleted_at)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, "Tipe Instansi telah dihapus.");
        }

        $row = new InstansiSubTipe();
        $row->nama = $params['nama'];
        $row->id_tipe = $params['id_tipe'];
        $status = $row->save();
        if (!$status) {
            $errors = $row->getMessages();
            $error_messages = [];

            foreach ($errors as $key => $error) :
                $error_messages[] = [
                    "field" => $error->getField(),
                    "message" => $error
                        ->getMessage()
                ];
            endforeach;

            throw new ValidationException($error_messages);
        } else {
            return new SimpleResponse($row);
        }
    }

    public function update($id)
    {
        $this->checkScopes(["admin.view"]);

        $rawBody =  $this->request->getJsonRawBody(true);
        $params =  $this->validate(
            $rawBody,
            [
                'nama' => ['validators' => ['required']],
                'id_tipe' => ['validators' =>  ['required', 'digit']]
            ]
        );

        /** @var InstansiSubTipe $row */
        $row = InstansiSubTipe::findFirst($id);
        if (empty($row)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data tidak ditemukan');
        }

        if (!empty($row->deleted_at)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data telah dihapus');
        }

        $row->nama = $params['nama'];
        $row->id_tipe = $params['id_tipe'];
        $status = $row->save();

        if (!$status) {
            $errors = $row->getMessage();
            $error_messages = [];

            foreach ($errors as $key => $error) {
                $error_messages[] = [
                    "field" => $error->getField(), "message" => $error->getMessage()
                ];
            }

            throw new ValidationException($error_messages);
        } else {
            return new SimpleResponse($row);
        }
    }

    public function delete($id)
    {
        $this->checkScopes(['admin.view']);

        $row = InstansiSubTipe::findFirst($id);

        if (empty($row)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data tidak ditemukan');
        }

        if (!empty($row->deleted_at)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data telah dihapus sebelumnya');
        }

        $date = date('Y-m-d H:i:s');
        $row->updated_at = $date;
        $row->deleted_at = $date;
        $status = $row->save();

        if (!$status) {
            $errors = $row->getMessage();
            $error_messages = [];
            foreach ($errors as $e) :
                $error_messages[] = [
                    'field' => $e->getField(),
                    'message' => $e->getMessage()
                ];
            endforeach;
        } else {
            return new SimpleResponse($row);
        }
    }

    public function restore($id)
    {
        $this->checkScopes(['admin.view']);

        $row = InstansiSubTipe::findFirst($id);

        if (empty($row)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data tidak ditemukan');
        }

        if (empty($row->deleted_at)) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Data belum dihapus sebelumnya');
        }

        $date = date('Y-m-d H:i:s');
        $row->updated_at = $date;
        $row->deleted_at = null;
        $status = $row->save();

        if (!$status) {
            $errors = $row->getMessage();
            $error_messages = [];
            foreach ($errors as $e) :
                $error_messages[] = [
                    'field' => $e->getField(),
                    'message' => $e->getMessage()
                ];
            endforeach;
        } else {
            return new SimpleResponse($row);
        }
    }

    public function listByTipe($idTipe) {
        $this->validate(["id_tipe" => $idTipe], ['id_tipe' => ['validators' => ['required', 'digit']]]);
        $rows = $instansi = InstansiSubTipe::find([
           "conditions" => "id_tipe = :id_tipe:",
           "bind" => ["id_tipe" => $idTipe]
        ]);

        return new CollectionPaginatedResponse($rows);
    }
}