<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Models\Banner;
use App\Models\Service;

class ServiceController extends Controller
{
    //
    public function sale()
    {
        // Banner
        $data['banner'] = collect(DB::select("SELECT * FROM `banners` WHERE `banner_id` = 3 && `banner_status` = 1"))->first();

        // CMS
        $data['sec_1'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 14 && `cms_status` = 1"))->first();
        $data['sec_2'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 15 && `cms_status` = 1"))->first();
        return view('sale',$data);
    }

    public function performance()
    {
        // Banner
        $data['banner'] = collect(DB::select("SELECT * FROM `banners` WHERE `banner_id` = 4 && `banner_status` = 1"))->first();

        // CMS
        $data['sec_1'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 17 && `cms_status` = 1"))->first();
        $data['sec_2'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 18 && `cms_status` = 1"))->first();
        $data['sec_3'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 19 && `cms_status` = 1"))->first();
        return view('performace',$data);
    }

    public function membership()
    {
        // Banner
        $data['banner'] = collect(DB::select("SELECT * FROM `banners` WHERE `banner_id` = 5 && `banner_status` = 1"))->first();

        // CMS
        $data['sec_1'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 20 && `cms_status` = 1"))->first();
        $data['sec_2'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 21 && `cms_status` = 1"))->first();
        $data['sec_3'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 23 && `cms_status` = 1"))->first();
        $data['sec_4'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 24 && `cms_status` = 1"))->first();
        $data['sec_5'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 25 && `cms_status` = 1"))->first();
        return view('membership',$data);
    }

    public function custom()
    {
        // Banner
        $data['banner'] = collect(DB::select("SELECT * FROM `banners` WHERE `banner_id` = 6 && `banner_status` = 1"))->first();

        // CMS
        $data['sec_1'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 26 && `cms_status` = 1"))->first();
        $data['sec_2'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 27 && `cms_status` = 1"))->first();
        $data['sec_3'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 28 && `cms_status` = 1"))->first();
        $data['sec_4'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 29 && `cms_status` = 1"))->first();
        $data['sec_5'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 30 && `cms_status` = 1"))->first();
        $data['sec_6'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 31 && `cms_status` = 1"))->first();
        $data['sec_7'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 32 && `cms_status` = 1"))->first();

        // Services
        $data['services'] = Service::all();
        return view('custom',$data);
    }

    public function key_note()
    {
        // Banner
        $data['banner'] = collect(DB::select("SELECT * FROM `banners` WHERE `banner_id` = 7 && `banner_status` = 1"))->first();

        // CMS
        $data['sec_1'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 33 && `cms_status` = 1"))->first();
        $data['sec_2'] = collect(DB::select("SELECT * FROM `cms` WHERE `cms_id` = 35 && `cms_status` = 1"))->first();

        // Testimonials
        $data['testimonial'] = DB::select("SELECT * FROM `testimonials` WHERE `testimonial_status` = 1 && `client_image` IS NULL");
        return view('keynote',$data);
    }

    public function coming_soon()
    {
        return view('coming_soon');
    }
}