<?php

namespace App\Http\Controllers;

use App\Models\ad;
use App\Models\adCategory;
use App\Models\country;
use App\Models\mainproducts;
use App\Models\shippingcity;
use App\Models\normaluser;
use Illuminate\Http\Request;

class AdController extends Controller
{
    public function showAd(Request $request)
    {
        $ads = ad::with('country', 'governate')->get();
        $adID = $request->segment(2);
        $products = mainproducts::with('category')->get();
        $Query = ad::where(['ad_id' => $adID])->get();
        return view('ads.ad')->with(['ad' => $Query, 'products' => $products, 'ads' => $ads]);
    }
    public function addAD()
    {
        $categories = adCategory::get();
        $country = country::get();
        $cites = shippingcity::get();
        return view('ads.addad')->with(['categories' => $categories, 'cites' => $cites, 'country' => $country]);
    }
    public function addADSuccess(Request $request)
    {

        if ($request->file('adPhoto')) {

            $request->validate([
                'adPhoto' => 'required|mimes:jpeg,bmp,png,jpg'
            ]);


            $adPhoto = time() . '.' . $request->adPhoto->extension();
            $request->adPhoto->move(('images/ads'), $adPhoto);
        } else {
            $adPhoto = "";
        }


        $adTitleAR = $request->input('adTitleAR');
        $adTitleEN = $request->input('adTitleEN');
        $adDescAR = $request->input('adDescAR');
        $adDescEN = $request->input('adDescEN');
        $adPrice = $request->input('adPrice');
        $adPhone = $request->input('adPhone');
        $adcategories = $request->input('adcategories');
        $adCountry = $request->input('adCountry');
        $adCity = $request->input('adCity');
        $adAddressNote = $request->input('adAddressNote');
        $adZIPCode = $request->input('adZIPCode');



        $validate = $request->validate([
            'adTitleAR' => ['required'],
            'adTitleEN' => ['required'],
            'adPrice' => ['required'],
            'adPhone' => ['required'],
            'adcategories' => ['required'],
            'adCountry' => ['required'],
            'adCity' => ['required'],
            // 'adAddressNote' => ['required'],
        ]);


        $addQuery = ad::create([
            'ad_titleAR' => $adTitleAR,
            'ad_titleEN' => $adTitleEN,
            'ad_descriptionAR' => $adDescAR ?? "",
            'ad_descriptionEN' => $adDescEN ?? "",
            'ad_price' => $adPrice,
            'ad_photo' => $adPhoto == "" ? "" : "images/ads/$adPhoto",
            'ad_phone' => $adPhone,
            'ad_category' => $adcategories,
            'ad_country' => $adCountry,
            'ad_governorate' => $adCity,
            'ad_address' => $adAddressNote ?? "",
            'ad_ZipCode' => $adZIPCode ?? "",
        ]);


        if ($addQuery) {
            return view('ads.addaddSuccess')->with(['success' => 'تم تسجيل بيانات الدورة بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }


    public function ads(Request $request)
    {
        $AdCategory = adCategory::where('adcategoriesIsActivated', '1')->get();
        $adsLatest = ad::orderBy('created_at', 'DESC')->paginate(10);
        $adsOldest = ad::orderBy('created_at', 'ASC')->paginate(10);
        return view('ads.ads')->with(['AdCategory' => $AdCategory, 'adsLatest' => $adsLatest, 'adsOldest' => $adsOldest]);
    }

    public function AdCategory(Request $request)
    {
        $AdCategory = adCategory::where('adcategoriesIsActivated', '1')->get();
        $adsLatest = mainproducts::orderBy('created_at', 'DESC')->paginate(10);
        $adsOldest = mainproducts::orderBy('created_at', 'ASC')->paginate(10);
        return view('ads.ads')->with(['AdCategory' => $AdCategory, 'adsLatest' => $adsLatest, 'adsOldest' => $adsOldest]);
    }


    // Dashboard ===================================================================================================================================================================================
    public function adsDashboardIndex()
    {
        $ads = ad::paginate(10);
        return view('dashboard.ads.ads', ['ads' => $ads]);
    }

    public function adsDashboardadd()
    {
        $adCategory = adCategory::where(['adcategoriesIsActivated' => "1"])->get();
        $country = country::all();
        $cites = shippingcity::all();
        $users = normaluser::where(['normalUser_type' => "1", 'normalUser_approve' => "1"])->get();

        return view('dashboard.ads.addAd', ['adCategory' => $adCategory, 'country' => $country, 'cites' => $cites, 'users' => $users]);
    }
    public function adsDashboardaddSuccess(Request $request)
    {

        if ($request->file('adPhoto')) {

            $request->validate([
                'adPhoto' => 'required|mimes:jpeg,bmp,png,jpg'
            ]);


            $adPhoto = time() . '.' . $request->adPhoto->extension();
            $request->adPhoto->move(('images/ads'), $adPhoto);
        } else {
            $adPhoto = "";
        }


        $adTitleAR = $request->input('adTitleAR');
        $adTitleEN = $request->input('adTitleEN');
        $adDescAR = $request->input('adDescAR');
        $adDescEN = $request->input('adDescEN');
        $adPrice = $request->input('adPrice');
        $adPhone = $request->input('adPhone');
        $aduser = $request->input('aduser');
        $adcategories = $request->input('adcategories');
        $adCountry = $request->input('adCountry');
        $adCity = $request->input('adCity');
        $adAddressNote = $request->input('adAddressNote');
        $adZIPCode = $request->input('adZIPCode');



        $validate = $request->validate([
            'adTitleAR' => ['required'],
            'adTitleEN' => ['required'],
            'adPrice' => ['required'],
            'adPhone' => ['required'],
            'aduser' => ['required'],
            'adcategories' => ['required'],
            'adCountry' => ['required'],
            'adCity' => ['required'],
            // 'adAddressNote' => ['required'],
        ]);


        $addQuery = ad::create([
            'ad_titleAR' => $adTitleAR,
            'ad_titleEN' => $adTitleEN,
            'ad_descriptionAR' => $adDescAR ?? "",
            'ad_descriptionEN' => $adDescEN ?? "",
            'ad_price' => $adPrice,
            'ad_photo' => $adPhoto == "" ? "" : "images/ads/$adPhoto",
            'ad_phone' => $adPhone,
            'ad_user' => $aduser,
            'ad_category' => $adcategories,
            'ad_country' => $adCountry,
            'ad_governorate' => $adCity,
            'ad_address' => $adAddressNote ?? "",
            'ad_ZipCode' => $adZIPCode ?? "",
        ]);


        if ($addQuery) {
            return redirect()->route('dashboard.AdsDashboardIndex')->with(['success' => 'تم إضافة الإعلان بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }

    public function adsDashboardedit(Request $request)
    {
        $adid = $request->segment(4);
        $ad = ad::where(['ad_id' => $adid])->with('country','governate','user','category')->get();

        $adCategory = adCategory::where(['adcategoriesIsActivated' => "1"])->get();
        $country = country::all();
        $cites = shippingcity::all();
        $users = normaluser::where(['normalUser_type' => "1", 'normalUser_approve' => "1"])->get();

        return view('dashboard.ads.editAd', ['adCategory' => $adCategory, 'country' => $country, 'cites' => $cites, 'users' => $users, 'ad' => $ad]);
    }
    public function adsDashboardeditSuccess(Request $request)
    {
        $adid = $request->segment(4);

        if ($request->file('adPhoto')) {

            $request->validate([
                'adPhoto' => 'required|mimes:jpeg,bmp,png,jpg'
            ]);


            $adPhoto = time() . '.' . $request->adPhoto->extension();
            $request->adPhoto->move(('images/ads'), $adPhoto);
        } else {
            $adPhoto = "";
        }


        $adTitleAR = $request->input('adTitleAR');
        $adTitleEN = $request->input('adTitleEN');
        $adDescAR = $request->input('adDescAR');
        $adDescEN = $request->input('adDescEN');
        $adPrice = $request->input('adPrice');
        $adPhone = $request->input('adPhone');
        $aduser = $request->input('aduser');
        $adcategories = $request->input('adcategories');
        $adCountry = $request->input('adCountry');
        $adCity = $request->input('adCity');
        $adAddressNote = $request->input('adAddressNote');
        $adZIPCode = $request->input('adZIPCode');



        $validate = $request->validate([
            'adTitleAR' => ['required'],
            'adTitleEN' => ['required'],
            'adPrice' => ['required'],
            'adPhone' => ['required'],
            'aduser' => ['required'],
            'adcategories' => ['required'],
            'adCountry' => ['required'],
            'adCity' => ['required'],
            // 'adAddressNote' => ['required'],
        ]);


        $updateQuery = ad::where('ad_id',$adid)->update([
            'ad_titleAR' => $adTitleAR,
            'ad_titleEN' => $adTitleEN,
            'ad_descriptionAR' => $adDescAR ?? "",
            'ad_descriptionEN' => $adDescEN ?? "",
            'ad_price' => $adPrice,
            'ad_photo' => $adPhoto == "" ? "" : "images/ads/$adPhoto",
            'ad_phone' => $adPhone,
            'ad_user' => $aduser,
            'ad_category' => $adcategories,
            'ad_country' => $adCountry,
            'ad_governorate' => $adCity,
            'ad_address' => $adAddressNote ?? "",
            'ad_ZipCode' => $adZIPCode ?? "",
        ]);


        if ($updateQuery) {
            return redirect()->route('dashboard.AdsDashboardIndex')->with(['success' => 'تم تعديل الإعلان بنجاح']);
        } else {
            return redirect()->back()->with([]);
        }
    }

    // Dashboard ===================================================================================================================================================================================


}
