<?php

class KorsupgahPeriodeController extends BaseController
{

    public function list()
    {
        $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'] : '';

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

        $arr_query = [
            'conditions' => 'nama ilike :keyword: AND deleted_at is NULL',
            'bind' => [
                'keyword' => '%' . $params['keyword'] . '%'
            ],
            'limit' => $params['limit'],
            'offset' => $params['offset'],
            // 'order' => 'nama',
        ];

        $kp = KorsupgahPeriode::find($arr_query);

        $total_record = KorsupgahPeriode::count($arr_query);

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

    public function create()
    {
        $this->checkScopes(['korsupgah.admin']);
        $rawBody = $this->request->getJsonRawBody(true);
        $params = $this->validate(
            $rawBody,
            [
                'nama' => ['validators' => ['required']],
                'keterangan' => ['validators' => []],
                'started_at' => ['validators' => ['required', 'datetime']],
                'ended_at' => ['validators' => ['required', 'datetime']],
                'bpkp_kemdagri_verif_started_at' => ['validators' => ['required', 'datetime']],
                'bpkp_kemdagri_verif_ended_at' => ['validators' => ['required', 'datetime']],
                'korsupgah_verif_started_at' => ['validators' => ['required', 'datetime']],
                'korsupgah_verif_ended_at' => ['validators' => ['required', 'datetime']],
                'pic_verif_started_at' => ['validators' => ['required', 'datetime']],
                'pic_verif_ended_at' => ['validators' => ['required', 'datetime']],
            ]
        );

        $started_at = new DateTime($params['started_at']);
        $ended_at = new DateTime($params['ended_at']);

        $bpkp_kemdagri_verif_started_at = new DateTime($params['bpkp_kemdagri_verif_started_at']);
        $bpkp_kemdagri_verif_ended_at = new DateTime($params['bpkp_kemdagri_verif_ended_at']);

        $korsupgah_verif_started_at = new DateTime($params['korsupgah_verif_started_at']);
        $korsupgah_verif_ended_at = new DateTime($params['korsupgah_verif_ended_at']);

        $pic_verif_started_at = new DateTime($params['pic_verif_started_at']);
        $pic_verif_ended_at = new DateTime($params['pic_verif_ended_at']);

        if ($started_at >= $ended_at || $bpkp_kemdagri_verif_started_at >= $bpkp_kemdagri_verif_ended_at || $korsupgah_verif_started_at >= $korsupgah_verif_ended_at || $pic_verif_started_at >= $pic_verif_ended_at) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Tanggal mulai harus lebih awal dari tanggal akhir');
        }

        $kp = new KorsupgahPeriode();
        $kp->nama = $params['nama'];
        $kp->keterangan = $params['keterangan'];
        $kp->started_at = $params['started_at'];
        $kp->ended_at = $params['ended_at'];
        $kp->created_at = date('Y-m-d H:i:s');
        $kp->created_by = $this->shared->user->um_id;
        $kp->bpkp_kemdagri_verif_started_at = $params['bpkp_kemdagri_verif_started_at'];
        $kp->bpkp_kemdagri_verif_ended_at = $params['bpkp_kemdagri_verif_ended_at'];
        $kp->korsupgah_verif_started_at = $params['korsupgah_verif_started_at'];
        $kp->korsupgah_verif_ended_at = $params['korsupgah_verif_ended_at'];
        $kp->pic_verif_started_at = $params['pic_verif_started_at'];
        $kp->pic_verif_ended_at = $params['pic_verif_ended_at'];
        $status = $kp->save();

        if (!$status) {
            $errors = $kp->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 CollectionPaginatedResponse([$kp]);
        }
    }

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

        $kp = KorsupgahPeriode::findFirst($id);

        if (empty($kp)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'tidak ditemukan');
        endif;

        if (!empty($kp->deleted_at)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id ' . $id  . 'mungkin sudah terhapus');
        endif;

        $rawBody = $this->request->getJsonRawBody(true);
        $params = $this->validate(
            $rawBody,
            [
                'nama' => ['validators' => ['required']],
                'keterangan' => ['validators' => []],
                'started_at' => ['validators' => ['required', 'datetime']],
                'ended_at' => ['validators' => ['required', 'datetime']],
                'bpkp_kemdagri_verif_started_at' => ['validators' => ['required', 'datetime']],
                'bpkp_kemdagri_verif_ended_at' => ['validators' => ['required', 'datetime']],
                'korsupgah_verif_started_at' => ['validators' => ['required', 'datetime']],
                'korsupgah_verif_ended_at' => ['validators' => ['required', 'datetime']],
                'pic_verif_started_at' => ['validators' => ['required', 'datetime']],
                'pic_verif_ended_at' => ['validators' => ['required', 'datetime']],
            ]
        );

        $started_at = new DateTime($params['started_at']);
        $ended_at = new DateTime($params['ended_at']);

        $bpkp_kemdagri_verif_started_at = new DateTime($params['bpkp_kemdagri_verif_started_at']);
        $bpkp_kemdagri_verif_ended_at = new DateTime($params['bpkp_kemdagri_verif_ended_at']);

        $korsupgah_verif_started_at = new DateTime($params['korsupgah_verif_started_at']);
        $korsupgah_verif_ended_at = new DateTime($params['korsupgah_verif_ended_at']);

        $pic_verif_started_at = new DateTime($params['pic_verif_started_at']);
        $pic_verif_ended_at = new DateTime($params['pic_verif_ended_at']);

        if ($started_at >= $ended_at || $bpkp_kemdagri_verif_started_at >= $bpkp_kemdagri_verif_ended_at || $korsupgah_verif_started_at >= $korsupgah_verif_ended_at || $pic_verif_started_at >= $pic_verif_ended_at) {
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'Tanggal mulai harus lebih awal dari tanggal akhir');
        }

        $kp->nama = $params['nama'];
        $kp->keterangan = $params['keterangan'];
        $kp->started_at = $params['started_at'];
        $kp->ended_at = $params['ended_at'];
        $kp->updated_at = date('Y-m-d H:i:s');
        $kp->updated_by = $this->shared->user->um_id;
        $kp->bpkp_kemdagri_verif_started_at = $params['bpkp_kemdagri_verif_started_at'];
        $kp->bpkp_kemdagri_verif_ended_at = $params['bpkp_kemdagri_verif_ended_at'];
        $kp->korsupgah_verif_started_at = $params['korsupgah_verif_started_at'];
        $kp->korsupgah_verif_ended_at = $params['korsupgah_verif_ended_at'];
        $kp->pic_verif_started_at = $params['pic_verif_started_at'];
        $kp->pic_verif_ended_at = $params['pic_verif_ended_at'];
        $status = $kp->save();

        if (!$status) {
            $errors = $kp->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 CollectionPaginatedResponse([$kp]);
        }
    }

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

        $kp = KorsupgahPeriode::findFirst($id);

        if (empty($kp)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'tidak diketemukan');
        endif;
        if (!empty($kp->deleted_at)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'mungkin sudah terhapus');
        endif;

        $date = date('Y-m-d H:i:s');
        $kp->updated_at = $date;
        $kp->deleted_at = $date;
        $kp->updated_by = $this->shared->user->um_id;
        $status = $kp->save();

        if (!$status) {
            $errors = $kp->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 CollectionPaginatedResponse([$kp]);
        }
    }

    public function restore($id)
    {
        $this->checkScopes(['korsupgah.admin']);
        $kp = KorsupgahPeriode::findFirst($id);

        if (empty($kp)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'tidak diketemukan');
        endif;
        if (empty($kp->deleted_at)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'Sudah Aktif');
        endif;

        $date = date('Y-m-d H:i:s');
        $kp->updated_at = $date;
        $kp->deleted_at = null;
        $kp->updated_by = $this->shared->user->um_id;
        $status = $kp->save();

        if (!$status) {
            $errors = $kp->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 CollectionPaginatedResponse([$kp]);
        }
    }

    public function detail($id)
    {

        $kp = KorsupgahPeriode::findFirst($id);
        if (empty($kp)) :
            throw new CustomErrorException(BaseResponse::INVALID_REQUEST, 'id' . $id . 'tidak diketemukan');
        endif;

        $result = $kp->toDetail();
        return new CollectionPaginatedResponse([$result]);
    }
}