InformasiController.php 6.16 KB
<?php

namespace App\Http\Controllers\Frontend;

use App\Http\Controllers\Controller;
use App\Models\Monografi;
use App\Models\Tematik;
use App\Models\Yuriprudensi;
use App\Models\Peraturan;
use App\Models\Publikasi;
use App\Models\Dih;
use App\Models\Kategori;
use App\Models\Berita;
use Illuminate\Support\Facades\DB;

use Illuminate\Http\Request;

class InformasiController extends Controller
{
    public function fberita()
    {
        $beritas = Berita::all();
        return view ('frontend.page.berita.berita', compact('beritas'));
    }

    public function fsimplifikasi()
    {
        return view ('frontend.page.informasi.fsimplifikasi');
    }

    public function finfografis()
    {
        return view ('frontend.page.informasi.finfografis');
    }

    public function ftematik()
    {
        $ftematik = Kategori::all();
        return view ('frontend.page.informasi.ftematik', compact('ftematik'));
    }

    public function ftematik_detail($id)
    {
        // if(!is_null($id))

        $peraturan = Peraturan::whereKategori($id)->get();

        return view ('frontend.page.informasi.ftematik_detail', compact('peraturan'));
    }

    public function fdirektori()
    {
        $fdirektori = Peraturan::all();
        // $fdirektori = Peraturan::whereYear('tahun',2019)->get();

        // $fdirektori = (DB::table('peraturan')
        //                 ->count('id'),
        //                 ->whereTahun(2019)
        //                 ->get();

        // $fdirektori = DB::select("SELECT (CASE
        //         WHEN tahun BETWEEN 1945 AND 1950 then 'less than 45'
        //         WHEN tahun BETWEEN 1950 AND 1955 then 'between 50-55'
        //         WHEN tahun BETWEEN 1955 AND 1960 then 'between 55-60'
        //         WHEN tahun BETWEEN 1960 AND 1965 then 'between 60-65'
        //         WHEN tahun BETWEEN 1965 AND 1970 then 'between 65-70'
        //         WHEN tahun BETWEEN 1970 AND 1975 then 'between 70-75'
        //         WHEN tahun BETWEEN 1975 AND 1980 then 'between 75-80'
        //         WHEN tahun BETWEEN 1980 AND 1985 then 'between 80-85'
        //         WHEN tahun BETWEEN 1985 AND 1990 then 'between 85-90'
        //         WHEN tahun BETWEEN 1990 AND 1995 then 'between 90-95'
        //         WHEN tahun BETWEEN 1995 AND 2000 then 'between 95-00'
        //         WHEN tahun BETWEEN 2000 AND 2005 then 'between 00-05'
        //         WHEN tahun BETWEEN 2005 AND 2010 then 'between 05-10'
        //         WHEN tahun BETWEEN 2010 AND 2015 then 'between 10-15'
        //         WHEN tahun BETWEEN 2015 AND 2020 then 'between 15-20'
        //         WHEN tahun BETWEEN 2020 AND 2025 then 'between 20-25'
        //             END) AS tahun_range, COUNT(*) as count
        //         FROM peraturans
        //         GROUP BY tahun_range
        //         ORDER BY MIN(tahun);
        // ");

        $fdirektori1 = DB::table('peraturans')
            ->whereBetween('tahun', [1945, 1949])
            ->count();

        $fdirektori2 = DB::table('peraturans')
            ->whereBetween('tahun', [1950, 1954])
            ->count();

        $fdirektori3 = DB::table('peraturans')
            ->whereBetween('tahun', [1955, 1959])
            ->count();

        $fdirektori4 = DB::table('peraturans')
            ->whereBetween('tahun', [1960, 1964])
            ->count();

        $fdirektori5 = DB::table('peraturans')
            ->whereBetween('tahun', [1965, 1969])
            ->count();

        $fdirektori6 = DB::table('peraturans')
            ->whereBetween('tahun', [1970, 1974])
            ->count();

        $fdirektori7 = DB::table('peraturans')
            ->whereBetween('tahun', [1975, 1979])
            ->count();

        $fdirektori8 = DB::table('peraturans')
            ->whereBetween('tahun', [1980, 1984])
            ->count();

        $fdirektori9 = DB::table('peraturans')
            ->whereBetween('tahun', [1985, 1989])
            ->count();

        $fdirektori10 = DB::table('peraturans')
            ->whereBetween('tahun', [1990, 1994])
            ->count();

        $fdirektori11 = DB::table('peraturans')
            ->whereBetween('tahun', [1995, 1999])
            ->count();

        $fdirektori12 = DB::table('peraturans')
            ->whereBetween('tahun', [2000, 2004])
            ->count();

        $fdirektori13 = DB::table('peraturans')
            ->whereBetween('tahun', [2005, 2009])
            ->count();

        $fdirektori14 = DB::table('peraturans')
            ->whereBetween('tahun', [2010, 2014])
            ->count();

        $fdirektori15 = DB::table('peraturans')
            ->whereBetween('tahun', [2015, 2019])
            ->count();

        $fdirektori16 = DB::table('peraturans')
            ->whereBetween('tahun', [2020, 2024])
            ->count();

        $fdirektori16_ = DB::table('peraturans')
        ->select('dih_id','kategori','nama','nomor','tahun','tentang','file','status_peraturan','peraturan_terkait','deskripsi_fisik')
        ->whereBetween('tahun', [2020, 2024])
        ->get();

        // dd($fdirektori16, $fdirektori16_);
        return view ('frontend.page.informasi.fdirektori', compact('fdirektori','fdirektori1','fdirektori2','fdirektori3','fdirektori4','fdirektori5','fdirektori6','fdirektori7','fdirektori8','fdirektori9','fdirektori10','fdirektori11','fdirektori12','fdirektori13','fdirektori14','fdirektori15','fdirektori16','fdirektori16_'));
    }

    public function fdirektori_detail($tahunAwal, $tahunAkhir)
    {
        $fdirektori_detail = DB::table('peraturans')
                ->select('dih_id','kategori','nama','nomor','tahun','tentang','file','status_peraturan','peraturan_terkait','deskripsi_fisik')
                ->whereBetween('tahun', [$tahunAwal,$tahunAkhir])
                ->get();
        // dd($fdirektori_detail);
        return view('frontend.page.informasi.fdirektori_detail', compact('fdirektori_detail'));


    }

    public function download($id)
    {
        $peraturan = Peraturan::find($id);
        return $peraturan->file_download;
    }

    public function fstat_rule()
    {
        return view ('frontend.page.informasi.fstat_rule');
    }

    public function fstat_visit()
    {
        return view ('frontend.page.informasi.fstat_visit');
    }
}