class GetLowonganList implements BusinessFunction{

    public function getDescription(){
        return "Mendapatkan Data Lowongan";
    }
    public function execute($dto){

        Log::debug("Dto");
        Log::debug($dto);
        $keyword = trim(strtoupper($dto["keyword"]));
        $limit = $dto['limit'];
        $offset = ($dto['offset']- 1) * $limit;
        $status = trim(strtoupper($dto["status"]));

        $params = [
                'limit'     => $limit,
                'offset'    => $offset
        ];
            $list_lowongan = DB::select(DB::Raw("SELECT A.lowongan_id, B.nama_pekerjaan,A.tanggal_berlaku, A.tanggal_akhir_berlaku, A.tipe_waktu, A.status_lowongan FROM m_lowongan A Join t_pekerjaan B ON A.pekerjaan_id = B.pekerjaan_id Where upper (B.nama_pekerjaan) LIKE Upper('%$keyword%') OR Upper(A.status_lowongan) LIKE Upper('%$status%') ORDER BY lowongan_id limit :limit offset :offset"), $params);

            return[
                'list_lowongan' => $list_lowongan
            ];

    }
     private function getTotalLowongan(){
            $totalItem = DB::select('
                SELECT COUNT(1)
                FROM m_lowongan');

            return $totalItem;
    }
}