Seller Management

class Seller extends Model
{
    protected $with = ['user', 'user.shop'];

    public function user(){
        return $this->belongsTo(User::class);
    }

    public function payments(){
        return $this->hasMany(Payment::class);
    }

    public function seller_package(){
        return $this->belongsTo(SellerPackage::class);
    }
}

public function store(Request $request)
{
    if (User::where('email', $request->email)->first() != null) {
        flash(translate('Email already exists!'))->error();
        return back();
    }
    
    $user = new User;
    $user->name = $request->name;
    $user->email = $request->email;
    $user->user_type = "seller";
    $user->password = Hash::make($request->password);

    if ($user->save()) {
        if (get_setting('email_verification') != 1) {
            $user->email_verified_at = date('Y-m-d H:m:s');
        } else {
            $user->notify(new EmailVerificationNotification());
        }
        $user->save();

        $seller = new Seller;
        $seller->user_id = $user->id;

        if ($seller->save()) {
            $shop = new Shop;
            $shop->user_id = $user->id;
            $shop->slug = 'demo-shop-' . $user->id;
            $shop->save();

            flash(translate('Seller has been inserted successfully'))->success();
            return redirect()->route('sellers.index');
        }
    }
}

public function approve_seller($id)
{
    $shop = Shop::findOrFail($id);
    $shop->verification_status = 1;
    $shop->save();
    Cache::forget('verified_sellers_id');

    $users = User::findMany([
        $shop->user->id, 
        User::where('user_type', 'admin')->first()->id
    ]);
    Notification::send($users, new ShopVerificationNotification($shop, 'approved'));

    flash(translate('Seller has been approved successfully'))->success();
    return redirect()->route('sellers.index');
}

public function reject_seller($id)
{
    $shop = Shop::findOrFail($id);
    $shop->verification_status = 0;
    $shop->verification_info = null;
    $shop->save();
    Cache::forget('verified_sellers_id');

    $users = User::findMany([
        $shop->user->id, 
        User::where('user_type', 'admin')->first()->id
    ]);
    Notification::send($users, new ShopVerificationNotification($shop, 'rejected'));

    flash(translate('Seller verification request has been rejected successfully'))->success();
    return redirect()->route('sellers.index');
}

public function ban($id)
{
    $shop = Shop::findOrFail($id);

    if ($shop->user->banned == 1) {
        $shop->user->banned = 0;
        if ($shop->verification_info) {
            $shop->verification_status = 1;
        }
        flash(translate('Seller has been unbanned successfully'))->success();
    } else {
        $shop->user->banned = 1;
        $shop->verification_status = 0;
        flash(translate('Seller has been banned successfully'))->success();
    }
    
    $shop->save();
    $shop->user->save();
    return back();
}

public function login($id)
{
    $shop = Shop::findOrFail(decrypt($id));
    $user  = $shop->user;
    auth()->login($user, true);

    return redirect()->route('seller.dashboard');
}

public function destroy($id)
{
    $shop = Shop::findOrFail($id);
    Product::where('user_id', $shop->user_id)->delete();
    $orders = Order::where('user_id', $shop->user_id)->get();

    foreach ($orders as $key => $order) {
        OrderDetail::where('order_id', $order->id)->delete();
    }
    Order::where('user_id', $shop->user_id)->delete();

    User::destroy($shop->user->id);

    if (Shop::destroy($id)) {
        flash(translate('Seller has been deleted successfully'))->success();
        return redirect()->route('sellers.index');
    }
}

public function bulk_seller_delete(Request $request)
{
    if ($request->id) {
        foreach ($request->id as $shop_id) {
            $this->destroy($shop_id);
        }
    }
    return 1;
}

public function index(Request $request)
{
    $sort_search = null;
    $approved = null;
    $shops = Shop::whereIn('user_id', function ($query) {
        $query->select('id')
            ->from(with(new User)->getTable());
    })->latest();

    if ($request->has('search')) {
        $sort_search = $request->search;
        $user_ids = User::where('user_type', 'seller')
            ->where(function ($user) use ($sort_search) {
                $user->where('name', 'like', '%' . $sort_search . '%')
                     ->orWhere('email', 'like', '%' . $sort_search . '%');
            })->pluck('id')->toArray();
        $shops = $shops->where(function ($shops) use ($user_ids) {
            $shops->whereIn('user_id', $user_ids);
        });
    }
    
    if ($request->approved_status != null) {
        $approved = $request->approved_status;
        $shops = $shops->where('verification_status', $approved);
    }
    
    $shops = $shops->paginate(15);
    return view('backend.sellers.index', compact('shops', 'sort_search', 'approved'));
}

public function __construct()
{
    $this->middleware(['permission:view_all_seller'])->only('index');
    $this->middleware(['permission:view_seller_profile'])->only('profile_modal');
    $this->middleware(['permission:login_as_seller'])->only('login');
    $this->middleware(['permission:pay_to_seller'])->only('payment_modal');
    $this->middleware(['permission:edit_seller'])->only('edit');
    $this->middleware(['permission:delete_seller'])->only('destroy');
    $this->middleware(['permission:ban_seller'])->only('ban');
}