<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\normaluseraddress;
use App\Models\shippingcity;
use App\Models\selectedCountries;
use App\Models\selectedShippingCities;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Session;


class addressController extends Controller
{
    // App =========================================================================================
    public function getaddresess(Request $request)
    {
        $normalUser_id = $request->input('userid');
        if ($addressData  =  DB::select("SELECT * FROM normaluseraddress
        INNER JOIN normalusers ON normalusers.normalUser_id = $normalUser_id
        AND normaluseraddress.normaluserAddress_userid = $normalUser_id
        INNER JOIN shippingcities ON shippingcities.normaluserAddress_cityID = normaluseraddress.normaluserAddress_cityID")) {

            echo json_encode(['status' => 'exists', 'addressData' => $addressData]);
        } else {
            echo json_encode(['status' => 'No addresses', 'addressData' => $addressData]);
        }
    }


    public function addAddress(Request $request)
    {
        $normaluserAddress_userid = $request->input('normaluserAddress_userid');
        $normaluserAddress_Name = $request->input('normaluserAddress_Name');
        $normaluserAddress_city = $request->input('normaluserAddress_city');
        $normaluserAddress_street = $request->input('normaluserAddress_street');
        $normaluserAddress_phone = $request->input('normaluserAddress_phone');
        $normaluserAddress_Notes = $request->input('normaluserAddress_Notes');


        if (
            normaluseraddress::create([
                'normaluserAddress_userid' => $normaluserAddress_userid,
                'normaluserAddress_Name' => $normaluserAddress_Name,
                'normaluserAddress_cityID' => $normaluserAddress_city,
                'normaluserAddress_street' => $normaluserAddress_street,
                'normaluserAddress_phone' => $normaluserAddress_phone,
                'normaluserAddress_Notes' => $normaluserAddress_Notes,
            ])
        ) {
            echo json_encode("Address Added");
        } else {
            echo json_encode("Address Add failed");
        }
    }
    // App =========================================================================================

    // Web =========================================================================================
    public function addressView(Request $request)
    {
        $normalUser_id = Session::get('userID');
        $websiteID = Session::get('website_id');
        $addressData  =  DB::select("SELECT * FROM normaluseraddress
        INNER JOIN normalusers ON normalusers.normalUser_id = $normalUser_id
        AND normaluseraddress.normaluserAddress_userid = $normalUser_id
        INNER JOIN selected_shipping_cities ON selected_shipping_cities.selected_shipping_city_id = normaluseraddress.normaluserAddress_cityID
        WHERE normaluserAddress_vendor_id = $websiteID
        ");

        return view('address.addresses')->with(['addressData' => $addressData]);
    }
    public function addaddressWeb(Request $request)
    {
        $normalUser_id = Session::get('userID');

        $countries = selectedCountries::where(['selected_Country_vendor_id' => Session::get('website_id'), 'selected_Country_state' => "1"])->with(['vendor', 'country'])->get();


        return view('address.addaddress')->with(['countries' => $countries]);
    }
    public function addaddressWebSuccess(Request $request)
    {
        $normalUser_id = Session::get('userID');

        $validate = $request->validate([
            'normaluserAddress_Name' => ['required'],
            'normaluserAddress_street' => ['required'],
            'normaluserAddress_phone' => ['required'],
        ]);


        $normaluserAddress_Name = $request->input('normaluserAddress_Name');
        $normaluserAddress_city = $request->input('normaluserAddress_city');
        $normaluserAddress_street = $request->input('normaluserAddress_street');
        $normaluserAddress_phone = $request->input('normaluserAddress_phone');
        $normaluserAddress_Notes = $request->input('normaluserAddress_Notes');



        normaluseraddress::create([
            'normaluserAddress_userid' => $normalUser_id,
            'normaluserAddress_Name' => $normaluserAddress_Name,
            'normaluserAddress_cityID' => $normaluserAddress_city,
            'normaluserAddress_street' => $normaluserAddress_street,
            'normaluserAddress_phone' => $normaluserAddress_phone,
            'normaluserAddress_Notes' => $normaluserAddress_Notes,
            'normaluserAddress_vendor_id' => Session::get('website_id'),
        ]);



        return redirect()->route('addressView');
    }
    public function editaddressWeb(Request $request)
    {
        $adressid = $request->segment(6);
        $query = normaluseraddress::where('normaluserAddress_id', $adressid)->get();
        $normalUser_id = Session::get('userID');

        $city = shippingcity::all();
        $countries = selectedCountries::where(['selected_Country_vendor_id' => Session::get('website_id'), 'selected_Country_state' => "1"])->with(['vendor', 'country'])->get();


        return view('address.editaddress')->with([
            'city' => $city,
            'address' => $query,
            'countries' => $countries
        ]);
    }
    public function editaddressWebSuccess(Request $request)
    {
        $adressid = $request->segment(3);
        $normalUser_id = Session::get('userID');

        $validate = $request->validate([
            'normaluserAddress_Name' => ['required'],
            'normaluserAddress_street' => ['required'],
            'normaluserAddress_phone' => ['required'],
            'normaluserAddress_Notes' => ['required'],
        ]);


        $normaluserAddress_Name = $request->input('normaluserAddress_Name');
        $normaluserAddress_city = $request->input('normaluserAddress_city');
        $normaluserAddress_street = $request->input('normaluserAddress_street');
        $normaluserAddress_phone = $request->input('normaluserAddress_phone');
        $normaluserAddress_Notes = $request->input('normaluserAddress_Notes');



        normaluseraddress::where('normaluserAddress_id', $adressid)->update([
            'normaluserAddress_Name' => $normaluserAddress_Name,
            'normaluserAddress_cityID' => $normaluserAddress_city,
            'normaluserAddress_street' => $normaluserAddress_street,
            'normaluserAddress_phone' => $normaluserAddress_phone,
            'normaluserAddress_Notes' => $normaluserAddress_Notes,
            'normaluserAddress_vendor_id' => Session::get('website_id'),

        ]);



        return redirect()->route('addressView');
    }


    public function addressDeleteWeb(Request $request)
    {
        $adressid = $request->segment(2);
        $normalUser_id = Session::get('userID');
        $deleteQuery = normaluseraddress::where(['normaluserAddress_id' => $adressid, 'normaluserAddress_userid' => $normalUser_id])->delete();
        return redirect()->route('addressView');
    }



    // Web =========================================================================================


    // AJAX =========================================================================================
    public function getCities(Request $request)
    {
        $countryid = $request->input('countryid');
        $query = selectedShippingCities::where(
            [
                'selected_city_vendor_id' => Session::get('website_id'),
                'selected_city_Country' => $countryid,
                'selected_Country_state' => "1"
            ]
        )->with(['vendor', 'city'])->get();

        foreach ($query as $city) {
            echo   "<option value=>" . translate("Choose City", "إختر محافظة") . "</option>
                <option value=$city->selected_shipping_city_id>
                " .   translate($city->city['shippingCity_Name'], $city->city['shippingCity_NameAr']) . " 
                </option>";
        }
    }
    public function getCityInfo(Request $request)
    {
        $cityid = $request->input('cityid');
        $query = selectedShippingCities::where(
            ['selected_shipping_city_id' => $cityid,]
        )->with(['vendor', 'city', 'country'])->get();

        foreach ($query as $city) {
            echo   "<label  class=col-sm-12 col-form-label id=country> " . $city->country['country_NameAR'] . " </label>
         <div class=col-sm-12>
             <label  class=col-sm-12 col-form-label id=city>" . $city->city['shippingCity_NameAr'] . "</label>
         </div>
         <div class=col-sm-12>
             <label  class=col-sm-12 col-form-label id=cost>" . convertCurrency($city->selected_shipping_city_Cost, $city->country->country_currency_en, Session::get('currency')) . Session::get('currency') . "</label>
         </div>
         <div class=col-sm-12>
             <label  class=col-sm-12 col-form-label id=time>" . $city->selected_shipping_city_Time . "</label>
         </div>";
        }
    }

    // AJAX =========================================================================================

}
