<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\vendorsSubscriptions;
use App\Models\subscription;
use App\Models\mainproducts;
use App\Models\maincategories;
use App\Models\admin;
use App\Models\vendor;

class VendorsSubscriptionsController extends Controller
{
    // Dashboard =========================================================================================================================================================

    public function VendorsSubscriptionsAdministrationindex(Request $request)
    {
        $vendorid = $request->segment(4);
        $vendor = vendor::where(['vendor_id' => $vendorid])->get();
        $vendorsSubscriptions = vendorsSubscriptions::where(['vendors_subscriptions_vendor_id' => $vendorid])->with(['vendor', 'subscription'])->get();
        $subscriptions = subscription::where(['subscription_State' => "1"])->get();

        $products = mainproducts::where(['mainProduct_vendor_id' => $vendorid])->count();
        $categories = maincategories::where(['mainCategory_vendor_id' => $vendorid])->count();
        $admins = admin::where(['admin_vendor_id' => $vendorid])->count();

        return view('administration.vendors.vendorsSubscriptions', [
            'vendorsSubscriptions' => $vendorsSubscriptions,
            'subscriptions' => $subscriptions,
            'products' => $products,
            'categories' => $categories,
            'admins' => $admins,
            'vendor' => $vendor]);
    }

    public function VendorsSubscriptionsAdministrationaddSuccess(Request $request)
    {

        $Subscription_id = $request->input('Subscription_id');
        $vendorid = $request->segment(4);
        $vendors_subscriptions_DateToBegin = $request->input('vendors_subscriptions_DateToBegin');
        $vendors_subscriptions_DateToEnd = $request->input('vendors_subscriptions_DateToEnd');
        $vendors_subscriptions_Products_limit = $request->input('vendors_subscriptions_Products_limit');
        $vendors_subscriptions_Admins_limit = $request->input('vendors_subscriptions_Admins_limit');
        $vendors_subscriptions_duration = $request->input('vendors_subscriptions_duration');


        $validate = $request->validate([
            'Subscription_id' => ['required'],
            'vendors_subscriptions_DateToBegin' => ['required'],
            'vendors_subscriptions_DateToEnd' => ['required'],
            'vendors_subscriptions_Products_limit' => ['required'],
            'vendors_subscriptions_Admins_limit' => ['required'],
            'vendors_subscriptions_duration' => ['required'],
        ]);


        $addQuery = vendorsSubscriptions::create([
            'Subscription_id' => $Subscription_id,
            'vendors_subscriptions_vendor_id' => $vendorid,
            'vendors_subscriptions_DateToBegin' => $vendors_subscriptions_DateToBegin,
            'vendors_subscriptions_DateToEnd' => $vendors_subscriptions_DateToEnd,
            'vendors_subscriptions_Products_limit' => $vendors_subscriptions_Products_limit,
            'vendors_subscriptions_Admins_limit' => $vendors_subscriptions_Admins_limit,
            'vendors_subscriptions_State' => "1",
            'vendors_subscriptions_PaymentState' => "1",
            'vendors_subscriptions_duration' => $vendors_subscriptions_duration,
        ]);


        if ($addQuery) {
            return redirect()->back()->with(['success' => 'تم تسجيل بيانات الإشتراك بنجاح']);
        } else {
            return redirect()->back()->with(['fail' => 'لم يتم تسجيل بيانات الإشتراك']);
        }
    }
        public function VendorsSubscriptionsAdministrationdelete(Request $request)
    {
        $id = $request->segment(4);

        $Query = vendorsSubscriptions::where(['vendors_subscriptions_id' => $id])->delete();

        return redirect()->back()->with(['success' => 'تم إزالة الإشتراك بنجاح']);
    }

    // public function adminsDashboardedit(Request $request)
    // {
    //     $adminid = $request->segment(4);
    //     $admin = admin::where(['admin_id' => $adminid])->get();
    //     $admins = admin::where(['admin_state' => 1])->get();
    //     return view('dashboard.admins.editadmin', ['admins' => $admins, 'admin' => $admin]);
    // }
    // public function adminsDashboardeditSuccess(Request $request)
    // {
    //     $adminid = $request->segment(4);

    //     if ($request->file('admin_photo')) {

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


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


    //     $admin_name = $request->input('admin_name');
    //     $admin_email = $request->input('admin_email');
    //     $admin_password = $request->input('admin_password');


    //     $validate = $request->validate([
    //         'admin_name' => ['required'],
    //         'admin_email' => ['required'],
    //         'admin_password' => ['required'],
    //     ]);


    //     $addQuery = admin::where(['admin_id' => $adminid])->update([
    //         'admin_name' => $admin_name,
    //         'admin_email' => $admin_email,
    //         'admin_photo' => $admin_photo == "" ? "" : "images/users/$admin_photo",
    //         'admin_password' => $admin_password ?? "",
    //         'admin_state' => "1",

    //     ]);


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


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


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

    // public function adminsSearch(Request $request)
    // {
    //     $name = $request->input('search');
    //     if ($name) {
    //         $admin = admin::where('admin_name', 'LIKE', '%' . $name . '%')
    //             ->orwhere('admin_email', 'LIKE', '%' . $name . '%')
    //             ->paginate(10);

    //         foreach ($admin as $admins) {
    //             echo "<tr>
    //                 <th scope='row'>

    //                 <label class='control control--checkbox'>
    //                 <input type='checkbox'>
    //                 <div class='control__indicator'></div>
    //                 </label>

    //                 </th>
    //                 <td>
    //                         $admins->admin_id
    //                 </td>

    //                 <td><img src='{{ url($admins->admin_photo) }}' alt='' class='img-fluid' width='10%' height='10%'></td>
    //                 <td>$admins->admin_name</td>
    //                 <td>

    //                 <a name='' id='' class='btn btn-success' href='admins/$admins->admin_id/edit' role='button'>تعديل</a>
    //                 <a name='' id='' class='btn btn-danger' href='admins/$admins->admin_id/delete' role='button'>حذف</a>

    //                 </td>
    //              </tr>";
    //         }
    //     }
    //     if ($name == "") {
    //         $user = admin::where('admin_state', 1)->get();

    //         foreach ($admin as $admins) {
    //             echo "<tr>
    //                 <th scope='row'>

    //                 <label class='control control--checkbox'>
    //                 <input type='checkbox'>
    //                 <div class='control__indicator'></div>
    //                 </label>

    //                 </th>
    //                 <td>
    //                         $admins->admin_id
    //                 </td>

    //                 <td><img src='{{ url($admins->admin_photo) }}' alt='' class='img-fluid' width='10%' height='10%'></td>
    //                 <td>$admins->admin_name</td>
    //                 <td>

    //                 <a name='' id='' class='btn btn-success' href='admins/$admins->admin_id/edit' role='button'>تعديل</a>
    //                 <a name='' id='' class='btn btn-danger' href='admins/$admins->admin_id/delete' role='button'>حذف</a>

    //                 </td>
    //              </tr>";
    //         }
    //     }
    // }

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

}
