<?php
  
  namespace App\Http\Controllers;

  use App\Models\Area;

  use App\Models\format_area;

  use App\Models\House;
  use App\Models\News;

  use App\Models\Partners;

  use App\Models\type_area;

  use Illuminate\Http\Request;

  use App\Classes\RusDate;

  use PhpParser\Node\Stmt\Switch_;

  use Illuminate\Support\Facades\Response;

  
  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'));

      }
  
      /*

       * Фильтр ajax в каталоге
       */
      public function catalog_ajax_filter(Request $request) {
          $Res = Array();
          if (!empty($request->area)) {
              $area_table = Area::where('id', '=', $request->area)->get();
              $Res[] = $area_table[0]->name_area;
          } else {
              $Res[] = "Все объекты";
          }
  
          if (!empty($request->type_area)) {
              $type_area_table = type_area::where('id', '=', $request->type_area)->get();
              $Res[] = $type_area_table[0]->name_type;
          } else {
              $Res[] = "Тип недвижимости";
          }
  
          if (!empty($request->format_area)) {
              $format_area_table = format_area::where('id', '=', $request->format_area)->get();
              $Res[] = $format_area_table[0]->name_format;
          } else {
              $Res[] = "Формат недвижимости";
          }
  
           return json_encode($Res);
      }
  
      /*

       * Страница ЖК
       */

      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('price');break;
                  case 2: $house_arenda = $house_arenda->orderByDesc('price');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('price')->

                                             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('price');break;
                  case 2: $house_arendovannie = $house_arendovannie->orderByDesc('price');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('price')->

              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 Category_ajax($cat, Request $request) {
          return $cat;
      }

      /*

       * Категории каталога Аренда/Продажа/Бизнес
       */

      public function Category($cat, Request $request) {

          switch ($cat) {
              case 'arenda':
                  $title = "Аренда торговых помещениий";
                  $format_house = 'Аренда';
              break;
              case 'sale':
                  $title = "Продажа торговых помещений";
                  $format_house = 'Продажа';
                  break;
              case 'bussiness':
                  $title = "Арендый бизнес";
                  $format_house = 'Бизнес';
              break;
              default:
                  $title = "Аренда торговых помещениий";
                  $format_house = 'Аренда';
                  break;
          }
  
          $houses = House::with('areas')->

                          where('format_house', '=', $format_house);
          //->appends(request()->query());
         /*
          if (!empty($request->area)) {
              $houses = $houses->where('area_id', '=', $request->area);
          }
          // условия поиска по типу недвижимости
          if (!empty($request->type_area)) {
              $houses = $houses->where('type_area_id', '=', $request->type_area);
          }
          // условия поиска по формату недвижимости
          if (!empty($request->format_area)) {
              $houses = $houses->where('format_area_id', '=', $request->format_area);
          }
          // условия поиска по площади - минимальная площадь
          if (!empty($request->area_m2_min)) {
              $houses = $houses->where('area', '>', $request->area_m2_min);
          }
          // условия поиска по площади - максимальная площадь
          if (!empty($request->area_m2_max)) {
              $houses = $houses->where('area', '<', $request->area_m2_max);
          }
          // условия поиска по цене - минимальная цена
          if (!empty($request->price_min)) {
              $houses = $houses->where('price', '>', $request->price_min);
          }
          // условия поиска по цене - максимальная цена
          if (!empty($request->price_max)) {
              $houses = $houses->where('price', '<', $request->price_max);
          }
          // условия поиска по адресу
          if (!empty($request->address)) {
              $houses = $houses->where('address', 'LIKE', "%".$request->address."%");
          }
  
          if (!empty($request->sort_price)) {
              switch ($request->sort_price) {
                  case 1: $houses = $houses->orderBy('price');break;
                  case 2: $houses = $houses->orderByDesc('price');break;
              }
              switch ($request->sort_new) {
                  case 1: $houses = $houses->orderByDesc('created_at');break;
                  case 2: $houses = $houses->orderBy('created_at');break;
              }
              switch ($request->sort_area) {
                  case 1: $houses = $houses->orderByDesc('area')->get();break;
                  case 2: $houses = $houses->orderBy('area')->get();break;
              }
          } else {
              $houses = $houses->orderBy('price')->
              orderByDesc('created_at')->
              orderByDesc('area');
          }
  */
          $houses = $houses->paginate(4);
  
          if ($request->ajax()) {
              return view('ajax.complex.category', compact('houses'));
          }

          return view('category_catalog', compact('title', 'cat', 'houses'));

      }
  
  
      /*

       * Каталог
       */

      public function Catalog(Request $request) {
  
          //////////раздел аренда/////////////////////////////////////////////////////////////////
          $house_arenda = House::with('areas')->
          where('format_house', '=', 'Аренда');
         // условия поиска по объектам комплексов
          if (!empty($request->area)) {
              $house_arenda = $house_arenda->where('area_id', '=', $request->area);
          }
          // условия поиска по типу недвижимости
          if (!empty($request->type_area)) {
              $house_arenda = $house_arenda->where('type_area_id', '=', $request->type_area);
          }
          // условия поиска по формату недвижимости
          if (!empty($request->format_area)) {
              $house_arenda = $house_arenda->where('format_area_id', '=', $request->format_area);
          }
          // условия поиска по площади - минимальная площадь
          if (!empty($request->area_m2_min)) {
              $house_arenda = $house_arenda->where('area', '>', $request->area_m2_min);
          }
          // условия поиска по площади - максимальная площадь
          if (!empty($request->area_m2_max)) {
              $house_arenda = $house_arenda->where('area', '<', $request->area_m2_max);
          }
          // условия поиска по цене - минимальная цена
          if (!empty($request->price_min)) {
              $house_arenda = $house_arenda->where('price', '>', $request->price_min);
          }
          // условия поиска по цене - максимальная цена
          if (!empty($request->price_max)) {
              $house_arenda = $house_arenda->where('price', '<', $request->price_max);
          }
          // условия поиска по адресу
          if (!empty($request->address)) {
              $house_arenda = $house_arenda->where('address', 'LIKE', "%".$request->address."%");
          }
  
          if ($request->view == 'arenda') {
              switch ($request->sort_price) {
                  case 1: $house_arenda = $house_arenda->orderBy('price');break;
                  case 2: $house_arenda = $house_arenda->orderByDesc('price');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('price')->
              orderByDesc('created_at')->
              orderByDesc('area')->get();
          }
  
          ////////раздел продажа//////////////////////////////////////////////////////////////////
          $house_prodaja = House::with('areas')->
          where('format_house', '=', 'Продажа');
  
          // условия поиска по объектам комплексов
          if (!empty($request->area)) {
              $house_prodaja = $house_prodaja->where('area_id', '=', $request->area);
          }
          // условия поиска по типу недвижимости
          if (!empty($request->type_area)) {
              $house_prodaja = $house_prodaja->where('type_area_id', '=', $request->type_area);
          }
          // условия поиска по формату недвижимости
          if (!empty($request->format_area)) {
              $house_prodaja = $house_prodaja->where('format_area_id', '=', $request->format_area);
          }
          // условия поиска по площади - минимальная площадь
          if (!empty($request->area_m2_min)) {
              $house_prodaja = $house_prodaja->where('area', '>', $request->area_m2_min);
          }
          // условия поиска по площади - максимальная площадь
          if (!empty($request->area_m2_max)) {
              $house_prodaja = $house_prodaja->where('area', '<', $request->area_m2_max);
          }
          // условия поиска по цене - минимальная цена
          if (!empty($request->price_min)) {
              $house_prodaja = $house_prodaja->where('price', '>', $request->price_min);
          }
          // условия поиска по цене - максимальная цена
          if (!empty($request->price_max)) {
              $house_prodaja = $house_prodaja->where('price', '<', $request->price_max);
          }
          // условия поиска по адресу
          if (!empty($request->address)) {
              $house_prodaja = $house_prodaja->where('address', 'LIKE', "%".$request->address."%");
          }
  
          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('format_house', '=', 'Бизнес');
          //orderByDesc('created_at')->get();
  
          // условия поиска по объектам комплексов
          if (!empty($request->area)) {
              $house_bissnes = $house_bissnes->where('area_id', '=', $request->area);
          }
          // условия поиска по типу недвижимости
          if (!empty($request->type_area)) {
              $house_bissnes = $house_bissnes->where('type_area_id', '=', $request->type_area);
          }
          // условия поиска по формату недвижимости
          if (!empty($request->format_area)) {
              $house_bissnes = $house_bissnes->where('format_area_id', '=', $request->format_area);
          }
          // условия поиска по площади - минимальная площадь
          if (!empty($request->area_m2_min)) {
              $house_bissnes = $house_bissnes->where('area', '>', $request->area_m2_min);
          }
          // условия поиска по площади - максимальная площадь
          if (!empty($request->area_m2_max)) {
              $house_bissnes = $house_bissnes->where('area', '<', $request->area_m2_max);
          }
          // условия поиска по цене - минимальная цена
          if (!empty($request->price_min)) {
              $house_bissnes = $house_bissnes->where('price', '>', $request->price_min);
          }
          // условия поиска по цене - максимальная цена
          if (!empty($request->price_max)) {
              $house_bissnes = $house_bissnes->where('price', '<', $request->price_max);
          }
          // условия поиска по адресу
          if (!empty($request->address)) {
              $house_bissnes = $house_bissnes->where('address', 'LIKE', "%".$request->address."%");
          }
  
          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('format_house', '=', 'Арендованные');
          //orderByDesc('created_at')->get();
  
          // условия поиска по объектам комплексов
          if (!empty($request->area)) {
              $house_arendovannie = $house_arendovannie->where('area_id', '=', $request->area);
          }
          // условия поиска по типу недвижимости
          if (!empty($request->type_area)) {
              $house_arendovannie = $house_arendovannie->where('type_area_id', '=', $request->type_area);
          }
          // условия поиска по формату недвижимости
          if (!empty($request->format_area)) {
              $house_arendovannie = $house_arendovannie->where('format_area_id', '=', $request->format_area);
          }
          // условия поиска по площади - минимальная площадь
          if (!empty($request->area_m2_min)) {
              $house_arendovannie = $house_arendovannie->where('area', '>', $request->area_m2_min);
          }
          // условия поиска по площади - максимальная площадь
          if (!empty($request->area_m2_max)) {
              $house_arendovannie = $house_arendovannie->where('area', '<', $request->area_m2_max);
          }
          // условия поиска по цене - минимальная цена
          if (!empty($request->price_min)) {
              $house_arendovannie = $house_arendovannie->where('price', '>', $request->price_min);
          }
          // условия поиска по цене - максимальная цена
          if (!empty($request->price_max)) {
              $house_arendovannie = $house_arendovannie->where('price', '<', $request->price_max);
          }
          // условия поиска по адресу
          if (!empty($request->address)) {
              $house_arendovannie = $house_arendovannie->where('address', 'LIKE', "%".$request->address."%");
          }
  
          if ($request->view == 'arendovannie') {
              switch ($request->sort_price) {
                  case 1: $house_arendovannie = $house_arendovannie->orderBy('price');break;
                  case 2: $house_arendovannie = $house_arendovannie->orderByDesc('price');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('price')->
              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;
              }
          }
          if (session('message') == 'Искать') {
              session()->flash('message', 'Сброс');
          } else {
              session()->flash('message', 'Искать');
          }
  
          if (empty($request)) {
              session()->flash('message', 'Искать');
          }
  
          return view('catalog', compact(
                                       'house_arenda',
                                      'house_prodaja',
                                                 'house_bissnes',
                                                 'house_arendovannie'
                                                 ));

      }
  
      /*
       * Новости
       */
      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'));
      }

  }