ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / omvstudio.com / app / Http / Controllers / Admin

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;

use App\Models\User;
use App\Models\ReferralPayment;
use Storage;
use Validator;
use Hash;
use DB;

class UserController extends Controller
{
    public function index(Request $request)
    {
        // echo $request->filter;
        // echo '<br>';

// $users = User::orderBy('created_at', 'desc')
        //     ->where('role_id', '!=', '1')
        //     ->paginate(10);

$subscribed_users = '';
        $one_time_users = '';
        $is_subscribed = '';
        $filter = '';

$data['all_users'] = User::where('role_id', '!=', 1)->get();
        $data['mongthly_registered_users'] = User::where('role_id', '!=', 1)->where('is_one_time', '=', 0)->get();
        $data['one_time_registered_users'] = User::where('role_id', '!=', 1)->where('is_one_time', 1);

//->orderByDesc('created_at')->paginate(10)
        
        $subscribed_users = new User;

if (!empty($request->filter)) {
            $subscribed_users = $subscribed_users->where(function ($query) use ($request) {
                $query->orWhere(DB::raw('CONCAT(first_name, " ", last_name)'), 'LIKE', '%' . $request['filter'] . '%')
                    // ->orWhere('first_name', 'LIKE', "%{$request['filter']}%")
                    // ->orWhere('last_name', 'LIKE', "%{$request['filter']}%")
                    ->orWhere('email', 'LIKE', "%{$request['filter']}%");
            })->where('role_id', '!=', 1);

$filter = $request->filter;
        }

if (!empty($request->get_user) && $request->get_user != 'ALL') {
             $subscribed_users = $subscribed_users->where('role_id', '!=', 1)->where('is_one_time', '=', $request->get_user == 'ONE_TIME' ? 1 : 0)->orderByDesc('created_at')->paginate(10);
            
        } else {
           $subscribed_users = $subscribed_users->where('role_id', '!=', 1)->orderByDesc('created_at')->paginate(10);
        }

$is_subscribed = !empty($request->get_user) ? $request->get_user : 'ALL';

return view('admin.user.user-list', compact('subscribed_users', 'is_subscribed', 'filter'), $data);
    }

public function userDetails(Request $request, $id)
    {
        $user = User::findOrFail($id);
        return view('admin.user.user-details', compact('user'));
    }
    public function editUserDetails(Request $request, $id)
    {
        $user = User::findOrFail($id);
        return view('admin.user.edit-user-details', compact('user'));
    }
    public function updateUserDetails(Request $request, $id)
    {
        $user = User::findOrFail($id);
        $validate = Validator::make($request->all(), [
            'first_name' => 'required',
            'last_name' => 'required',
            'email' => 'required|email|unique:users,email,' . $user->id,
            'phone_number' => 'required',
            'profile_picture' => 'nullable|mimes:jpg,png,jpeg',
            'new_password' => 'nullable',
            'confirm_password' => 'nullable|same:new_password',

])->validate();

if ($request->hasFile('profile_picture')) {

if (Storage::exists('public/profiles/' . $user->profile_picture)) {
                Storage::delete('public/profiles/' . $user->profile_picture);
            }

$profile_picture_name = $request->file('profile_picture');
            $ext = $profile_picture_name->extension();
            $profile_picture_filename = uniqid() . '.' . $ext;
            $profile_picture_name->storeAs('public/profiles/', $profile_picture_filename);
            $user->profile_picture = $profile_picture_filename;
        }
        $user->fill($request->except('profile_picture'));
        if ($request->new_password) {
            $user->password = Hash::make($request->new_password);
        }

$result = $user->save();

if ($result) {
            return redirect()->back()->with('success', 'Profile has been updated successfully!!');
        } else {
            return redirect()->back()->with('error', 'Unable to updated profile');
        }
    }
    public function showInvoiceDetails(Request $request, $id)
    {
        $user = User::findOrFail($id);

$invoices = $user->invoices();

return view('admin.user.show-invoice', compact('invoices'));
    }

public function exportCsv(Request $request)
    {
        $fileName = 'users.csv';
        $tasks = User::where('role_id', '!=', '1')->get();

$headers = array(
            "Content-type"        => "text/csv",
            "Content-Disposition" => "attachment; filename=$fileName",
            "Pragma"              => "no-cache",
            "Cache-Control"       => "must-revalidate, post-check=0, pre-check=0",
            "Expires"             => "0"
        );

$columns = array('Name', 'Email', 'User Name', 'Contact No.', 'Subscription Plan Type', 'Date Of Joining');

$callback = function () use ($tasks, $columns) {
            $file = fopen('php://output', 'w');
            fputcsv($file, $columns);

foreach ($tasks as $task) {
                $row['Name']  = $task->first_name . " " . $task->last_name;
                $row['Email']    = $task->email;
                $row['User Name']    = $task->username;
                $row['Contact No.']  = $task->phone_number;
                if ($task->is_one_time == 1) {
                    $row['Subscription Plan Type']  = "One Time";
                } else {
                    $row['Subscription Plan Type']  = "Monthly";
                }

// $row['Date Of Joining']  = date('Y-m-d',strtotime($task->created_at));
                $row['Date Of Joining']  = $task->created_at;

fputcsv($file, array($row['Name'], $row['Email'], $row['User Name'], $row['Contact No.'], $row['Subscription Plan Type'], $row['Date Of Joining'],));
            }

fclose($file);
        };

return response()->stream($callback, 200, $headers);
    }

public function showReferralBonusDetails($user_id)
    {
        $user = User::findOrFail($user_id);

$referral_payments_recived = $user->receivedReferralPayments;

return view('admin.user.referral-commission-details', compact('referral_payments_recived', 'user'));
    }
    public function showReferralBonusList(Request $request)
    {

$referral_payments = ReferralPayment::whereHas('referralPaymentsReceiver', function ($query) use ($request) {

if(!empty($request->referral_filter_name)){
                $query->where(DB::raw('CONCAT(first_name, " ", last_name)'), 'LIKE', '%' . $request->referral_filter_name . '%');

}

if (!empty($request->referral_filter_from) && !empty($request->referral_filter_to)) {
         
                $query->whereBetween('referral_payments.created_at', [$request->referral_filter_from, $request->referral_filter_to]);
            }
            else if (!empty($request->referral_filter_from)) {

$query->where('referral_payments.created_at','>=',$request->referral_filter_from);
            }
            else if (!empty($request->referral_filter_to)) {

$query->whereBetween('referral_payments.created_at','<=' , $request->referral_filter_to);
            }
            /*$query->where(DB::raw('CONCAT(first_name, " ", last_name)'), 'LIKE', '%' . $request->referral_filter_name . '%');
            $query->whereBetween('referral_payments.created_at', [$request->referral_filter_from, $request->referral_filter_to]);*/

})->get();

$referral_filter_name = '';
        $referral_filter_from = '';
        $referral_filter_to = '';

if (!empty($request->referral_filter_name)) {

$referral_filter_name = $request->referral_filter_name;
            
        }
        if (!empty($request->referral_filter_from) && !empty($request->referral_filter_to)) {

$referral_filter_from = $request->referral_filter_from;
            $referral_filter_to = $request->referral_filter_to;
        }
        else if (!empty($request->referral_filter_from)) {

$referral_filter_from = $request->referral_filter_from;
        }
        else if (!empty($request->referral_filter_to)) {
           
            $referral_filter_to = $request->referral_filter_to;
        }

/*->orWhereHas('referralPaymentsReceiver', function($querys) use($request){

$querys->where('referral_payments.created_at','>=', $request->referral_filter_from); 
                $querys->where('referral_payments.created_at','<=', $request->referral_filter_to);

})*/

//dd(DB::getQueryLog());

//$filter = $request->filter;

//dd($referral_payments);
        return view('admin.referral_commission.referral-commission-list', compact('referral_payments','referral_filter_name','referral_filter_from','referral_filter_to'));
    }
}

[-] CategoryController.php [edit]
[-] MovieController_bkp.php [edit]
[-] PageBannerController.php [edit]
[+] ..
[-] UserController.php [edit]
[-] SiteSettingController.php [edit]
[-] AdminProfileController.php [edit]
[-] MusicController.php [edit]
[-] PageController.php [edit]
[-] HomeConfigWorkController.php [edit]
[-] MovieController.php [edit]
[-] ContactController.php [edit]
[-] FaqController.php [edit]
[-] LoginController.php [edit]
[-] MusicManiaController.php [edit]
[-] ReviewController.php [edit]
[-] MediaController.php [edit]
[-] DashboardController.php [edit]
[-] EntertainController.php [edit]
[-] MenuController.php [edit]
[-] SportController.php [edit]