Server : Apache System : Linux 145.162.205.92.host.secureserver.net 5.14.0-611.45.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Apr 1 05:56:53 EDT 2026 x86_64 User : tradze ( 1001) PHP Version : 8.1.34 Disable Function : NONE Directory :  /home/tradze/www/app/Modules/Users/Http/Controllers/Frontend/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
namespace App\Modules\Users\Http\Controllers\Frontend;

use App\Http\Controllers\SiteController;
use App\Modules\Vouchers\Models\Voucher;
use App\Modules\Vouchers\Repositories\VoucherRepository;
use Illuminate\Http\Request;;
use Illuminate\Support\Facades\Auth;

class AccountVouchersController extends SiteController
{
    /**
     * User address book
     *
     * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
     */
    public function index()
    {
        //get loggedin user and his vouchers codes
        $user = Auth::user();

        //get vouchers
        $vouchers = Voucher::where('is_active',1)
                            ->where(function($query) use ($user){
                                $query->where(function($q) use ($user){
                                    return $q->where('email',$user->email)
                                        ->orWhere('user_id',$user->id);
                                });
//                                $query->orWhere(function($query){
//                                    return $query->where('only_with_service',0)
//                                                 ->where('only_with_user',0)
//                                                 ->where('only_with_email',0);
//                                });
                                $query->orderBy('isValid','desc');

                                return $query;
                            })
                            ->get();

        $data['vouchers'] = $vouchers->sortByDesc('max_no_usage')->sortByDesc('date_end');

        //render page
        return view('users::frontend_new.vouchers_list',$data);
    }

}