<?php

namespace App\Http\Controllers;

use App\Models\Area;
use App\Models\House;
use App\Models\News;
use App\Models\Partners;
use Illuminate\Http\Request;
use App\Classes\RusDate;
use PhpParser\Node\Stmt\Switch_;

class MainController extends Controller
{
    /*
     * Главная страница проекта
     */
    public function index() {
       $houses = House::with('areas')->orderByDesc('created_at')->limit(8)->get();
       $news = News::query()->orderByDesc('created_at')->limit(8)->get();
       $partners = Partners::query()->limit(18)->get();
       return view('index', compact('houses', 'news', 'partners'));
    }

    /*
     * Страница ЖК
     */
    public function Complex(Area $area, Request $request) {
        //////////раздел аренда
        $house_arenda = House::with('areas')->
                               where('area_id', '=', $area->id)->
                               where('format_house', '=', 'Аренда');

        if ($request->view == 'arenda') {
            switch ($request->sort_price) {
                case 1: $house_arenda = $house_arenda->orderBy('rent_in_month');break;
                case 2: $house_arenda = $house_arenda->orderByDesc('rent_in_month');break;
            }
            switch ($request->sort_new) {
                case 1: $house_arenda = $house_arenda->orderByDesc('created_at');break;
                case 2: $house_arenda = $house_arenda->orderBy('created_at');break;
            }
            switch ($request->sort_area) {
                case 1: $house_arenda = $house_arenda->orderByDesc('area')->get();break;
                case 2: $house_arenda = $house_arenda->orderBy('area')->get();break;
            }
        } else {
            $house_arenda = $house_arenda->orderBy('rent_in_year')->
                                           orderByDesc('created_at')->
                                           orderByDesc('area')->get();
        }

        ////////раздел продажа
        $house_prodaja = House::with('areas')->
                                //where('area_id', '=', $area->id)->
                                where('format_house', '=', 'Продажа');

        if ($request->view == 'prodaja') {
            switch ($request->sort_price) {
                case 1: $house_prodaja = $house_prodaja->orderBy('price');break;
                case 2: $house_prodaja = $house_prodaja->orderByDesc('price');break;
            }
            switch ($request->sort_new) {
                case 1: $house_prodaja = $house_prodaja->orderByDesc('created_at');break;
                case 2: $house_prodaja = $house_prodaja->orderBy('created_at');break;
            }
            switch ($request->sort_area) {
                case 1: $house_prodaja = $house_prodaja->orderByDesc('area')->get();break;
                case 2: $house_prodaja = $house_prodaja->orderBy('area')->get();break;
            }
        } else {
            $house_prodaja = $house_prodaja->orderBy('price')->
                                            orderByDesc('created_at')->
                                            orderByDesc('area')->get();
        }

        //////////////// Раздел бизнеса
        $house_bissnes = House::with('areas')->
                                where('area_id', '=', $area->id)->
                                where('format_house', '=', 'Бизнес');
                                //orderByDesc('created_at')->get();

        if ($request->view == 'bissnes') {
            switch ($request->sort_price) {
                case 1: $house_bissnes = $house_bissnes->orderBy('price');break;
                case 2: $house_bissnes = $house_bissnes->orderByDesc('price');break;
            }
            switch ($request->sort_new) {
                case 1: $house_bissnes = $house_bissnes->orderByDesc('created_at');break;
                case 2: $house_bissnes = $house_bissnes->orderBy('created_at');break;
            }
            switch ($request->sort_area) {
                case 1: $house_bissnes = $house_bissnes->orderByDesc('area')->get();break;
                case 2: $house_bissnes = $house_bissnes->orderBy('area')->get();break;
            }
        } else {
            $house_bissnes = $house_bissnes->orderBy('price')->
                                             orderByDesc('created_at')->
                                             orderByDesc('area')->get();
        }

        //////////раздел арендованные
        $house_arendovannie = House::with('areas')->
                                     where('area_id', '=', $area->id)->
                                     where('format_house', '=', 'Арендованные');
                                     //orderByDesc('created_at')->get();

        if ($request->view == 'arendovannie') {
            switch ($request->sort_price) {
                case 1: $house_arendovannie = $house_arendovannie->orderBy('rent_in_month');break;
                case 2: $house_arendovannie = $house_arendovannie->orderByDesc('rent_in_month');break;
            }
            switch ($request->sort_new) {
                case 1: $house_arendovannie = $house_arendovannie->orderByDesc('created_at');break;
                case 2: $house_arendovannie = $house_arendovannie->orderBy('created_at');break;
            }
            switch ($request->sort_area) {
                case 1: $house_arendovannie = $house_arendovannie->orderByDesc('area')->get();break;
                case 2: $house_arendovannie = $house_arendovannie->orderBy('area')->get();break;
            }
        } else {
            $house_arendovannie = $house_arendovannie->orderBy('rent_in_year')->
            orderByDesc('created_at')->
            orderByDesc('area')->get();
        }

        if ($request->ajax()) {
            switch($request->view) {
                case 'arenda': return view('ajax.complex.arenda', compact('house_arenda')); break;
                case 'prodaja': return view('ajax.complex.prodaja', compact('house_prodaja'));break;
                case 'bissnes': return view('ajax.complex.bissnes', compact('house_bissnes')); break;
                case 'arendovannie': return view('ajax.complex.arendovannie', compact('house_arendovannie')); break;
            }
        }

        return view('complex', compact('area',
                                           'house_arenda',
                                                     'house_prodaja',
                                                     'house_bissnes',
                                                     'house_arendovannie'));

    }

    /*
     * О компании
     */
    public function About() {
        return view('about');
    }

    /*
     * Избранное
     */
    public function Favorite() {
        return view('favorite');
    }

    /*
     * Каталог
     */
    public function Catalog() {
        return view('catalog');
    }

    /*
     * Новости
     */
    public function News() {
        //$news = News::orderByDesc('created_at')->limit(1)->paginate();
        $news_ = News::query()->orderByDesc('created_at')->paginate(4);
        return view('news', compact('news_'));
    }

    /*
     * Контакты
     */
    public function Contact() {
        return view('contact');
    }

    /*
     * Карта объектов
     */
    public function MapsObj() {
        return view('mapsobj');
    }

    /*
     * Посмотр конктретного предложение офиса
     */
    public function Offer(House $house) {
        $houses = House::with('areas');
        $houses =  $houses->where('type_area_id', '=', $house->typearea->id);
        $houses = $houses->where('format_house', '=', $house->format_house);
        $houses = $houses->orderByDesc('created_at')->limit(8)->get();

        return view('house.post', compact('house', 'houses'));
    }

    /*
     * Просмотр детально конкретной новости
     */
    public function DetailNew(News $news) {
        $news_list = News::query()->orderByDesc('created_at')->limit(8)->get();
        return view('new.post', compact('news', 'news_list'));
    }
}