<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Fasil;
use App\Video;
use App\Berita;
use App\Galeri;
use App\Mitra;
use App\Kategori;
use App\Project;
use App\Profil;
use App\Jenis;
use App\User;

// use App\Hak;
class PagesController extends Controller
{
    public function beranda(Request $request)
    {
        $kays = $request->kays;
        $kategori = Kategori::withCount('Berita')->get();
        $berita = berita::latest()->where('judul', 'like', "%" . $kays . "%")->paginate(9);
        return view('frontend.index', compact('berita', 'kategori'));
    }

    public function produk(Request $request)
    {
        $kategori = Kategori::withCount('Project')->get();
        $produk = Project::latest()->where('kode_jenis', '11')->where('status', 'Aktif')->paginate(12);
        return view('frontend.produk', compact('produk', 'kategori'));
    }

    // TESTIMONI
    public function bukti(Request $request)
    {
        $kategori = Kategori::withCount('Project')->get();
        $bukti = Mitra::latest()->paginate(12);
        return view('frontend.bukti', compact('bukti', 'kategori'));
    }

    // Tampil Berita
    public function show(Berita $berita)
    {
        $berita_detail = $berita;
        $berita_terkait = Berita::latest()->get()->random(4);
        $berita_terbaru = Berita::latest()->limit(6)->get();
        $kategori = Kategori::withCount('Berita')->get();
        return view('frontend.detail', compact('berita_detail', 'kategori', 'berita_terkait', 'berita_terbaru'));
    }

    public function kategori_blog(Kategori $kategori)
    {

        // Menampilkan Kategori
        $kategori_all = $kategori;
        $berita_all = $kategori->Berita()->paginate(9);
        $kategori = Kategori::withCount('Berita')->get();
        return view('frontend.kategori', compact('berita_all', 'kategori', 'kategori_all'));
    }

    public function daftar_aplikasi(Request $request)
    {
        $S = $request->S;
        $kategori = Kategori::all();
        $jenis = Jenis::all();
        $profil = Profil::all();
        $jumlah_member = User::all();
        $member = User::limit(40)->get()->random(4);
        $member_akhir = User::latest()->limit(1)->get();
        $testi_awal = User::where([['status_testimoni', '=', 'Aktif']])->limit(1)->get();

        $moni = User::where([['status_testimoni', '=', 'Aktif']])->limit(50)->get()->random(4);

        $project = project::where('judul', 'like', "%" . $S . "%")->where('kode_jenis', '<>', 11)->where('status', 'Aktif')->paginate(40);

        return view('frontend.daftar_aplikasi', compact('project', 'kategori', 'profil', 'jenis', 'member', 'member_akhir', 'testi_awal', 'moni', 'jumlah_member'));
    }

    public function showaplikasi(Project $project)
    {
        $profil = Profil::all();
        $project_detail = $project;
        $project_terbaru = Project::latest()->limit(6)->where('kode_jenis', '<>', 11)->where('status', 'Aktif')->get();
        $jenis = Jenis::withCount('Project')->get();
        $kategori = Kategori::withCount('Project')->get();
        return view('frontend.detail_project', compact('project_detail', 'jenis', 'project_terbaru', 'kategori', 'profil'));
    }

    // login member
    public function login_member(Request $request)
    {
        $kays = $request->kays;
        $kategori = Kategori::all();
        $berita = berita::where('judul', 'like', "%" . $kays . "%")->paginate(9);
        return view('frontend.login_member', compact('berita', 'kategori'));
    }


    // registrasi
    public function registrasi_member(Request $request)
    {
        $kays = $request->kays;
        $kategori = Kategori::all();
        $profil = Profil::all();
        $berita = berita::where('judul', 'like', "%" . $kays . "%")->paginate(9);
        return view('frontend.registrasi_member', compact('berita', 'kategori','profil'));
    }

    public function cari(Request $request)
    {
        $s = $request->s;
        $kategori = Kategori::withCount('Berita')->get();
        $berita = berita::where('judul', 'like', "%" . $s . "%")->paginate(9);
        return view('frontend.cari', compact('berita', 'kategori'));
    }
}