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

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

<?php

namespace App\Http\Controllers\front;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\Faq;
use App\Models\Page;
use App\Models\Movie;
use App\Models\Category;
use App\Models\HomeConfigWork;
use App\Models\Media;
use App\Models\Entertain;
use App\Models\Review;
use App\Models\Payment;
use App\Models\User;
use App\Models\Sport;
use App\Models\Music;
use App\Models\MusicMania;
use Validator;
use DB;

class HomeController extends Controller
{
    public function index()
    {
        $data['home_page_data'] = Page::where('page_slug','home')->where('status','active')->first();
        $data['home_page_section_title_arr'] = json_decode($data['home_page_data']->home_section_title);

/*if (isset($data['home_page_data']->home_section_title) && !empty($data['home_page_data']->home_section_title)) {
            //return "done";

//prx($home_page_section_title_arr);
        }
        else{
            return "error";
        }*/

$data['faqs'] = Faq::orderBy('created_at', 'desc')->get();
        $data['categories'] = Category::where('is_featured','1')->where('status','active')->orderBy('created_at','desc')->get();
        $data['sports'] = Sport::where('is_featured','1')->where('status','active')->orderBy('created_at','desc')->get();

$data['music'] = MusicMania::where('is_featured','1')->where('status','active')->orderBy('created_at','desc')->get();
        // dd($data['music']->count());

$data['movies'] = Movie::whereHas('categories', function($query){
            $query->where('categories.status','active');
        })->where('is_featured','1')->where('status','active')->orderBy('created_at','desc')->get();

$data['home_config_works'] = HomeConfigWork::where('status','active')->orderBy('ordering','asc')->get();

$data['medias'] = Media::orderBy('created_at', 'desc')->get();
        $data['entertains'] = Entertain::orderBy('created_at', 'desc')->get();

//prx($data['movies']);
    	return view('front.home',$data);
    }

public function categoryList(Request $request)
    {
        //prx($request->all());
        $slug = $request->slug;
       // prx($category_id);

$data['sigle_category'] = Category::where('slug',$slug)->first();

if($slug){
            $data['category_header'] = Movie::inRandomOrder()->whereHas('categories', function($query)use($slug){
                $query->where('categories.slug',$slug);
                $query->where('categories.status','active');
            })->where('movies.is_featured',1)->where('movies.status','active')->orderByDesc('movies.created_at')->first();
        }else{
            $data['category_header'] = Movie::inRandomOrder()->where('is_featured',1)->where('status','active')->orderByDesc('created_at')->first();
        }

$data['selected_category'] = $slug;

//DB::enableQueryLog();
        $query = Movie::latest();

if ($slug) {
            if(!isset($data['sigle_category']) || $data['sigle_category']->status == "inactive"){
                abort(404, 'Page Not Found');
            }

$query->whereHas('categories', function ($join) use($slug) {
                $join->where('categories.slug',$slug);
                $join->where('movies.status','active');
                $join->where('categories.status','active');
            });

$data['movies'] = $query->paginate(20);

// $data['category_header'] = Movie::inRandomOrder()->where('is_featured',1)->where('status','active')->orderByDesc('created_at')->first();

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

/*else{
            abort(404, 'Page Not Found');
        }*/

//dd($data['movies']->count());

// $data['category_header'] = Category::where('id',14)->first();//it not will be fixed
        //it not will be fixed

$data['categories'] = Category::where('status','active')->orderBy('created_at','desc')->get();

return view('front.category-list',$data)->with('slug',$slug);

}
    public function singleCategoryList($slug)
    {
        $data['category'] = Category::where('slug',$slug)->first();
        if(!isset($data['category']) || $data['category']->status == "inactive"){
           abort(404, 'Page Not Found');
        }
        $data['movies'] = $data['category']->movies->paginate(20);   // it should be 22 to 25th
        return view('front.single-category-list',$data);
    }
    public function sportList(Request $request)
    {
        $data['sports'] = Sport::where('status',1)->paginate(20);
           // it should be 22 to 25th
        return view('front.sport-list',$data);
    }

public function movieDetails($slug)
    {
        $data['user'] = auth()->user();
        //$data['movie'] = Movie::where('slug',$slug)->first();

$data['movie'] = Movie::whereHas('categories', function($query){
            $query->where('categories.status','active');
        })->where('slug',$slug)->first();

if(!isset($data['movie']) || $data['movie']->status == "inactive"){
            abort(404, 'Page Not Found');
        }

//dd($data['movie']->categories);
       // prx($data['movie']->categories);
        $category_id_arr = [];
        foreach ($data['movie']->categories as $value) {
          array_push($category_id_arr,$value->id);
        }

$data['related_movies'] = Movie::whereHas('categories', function ($join) use($category_id_arr) {
            $join->whereIn('categories.id',$category_id_arr);
            $join->where('movies.status','active');
            $join->where('categories.status','active');
        })->inRandomOrder()->take(20)->where('id','!=', $data['movie']->id)->get();

$data['star_cast'] = json_decode($data['movie']->star_cast);

$data['reviews'] = Review::where('movie_id',$data['movie']->id)->where('status','active')->orderByDesc('created_at')->get();
        $data['rating_sum'] = Review::where('movie_id',$data['movie']->id)->where('status','active')->sum('rating');

/*$query = DB::select( DB::raw('SELECT ((SELECT COUNT(*) AS Total FROM `reviews` WHERE `rating` > 4 AND movie_id = '.$data['movie']->id.') / COUNT(*)) * 100 AS Excellent,
         ((SELECT COUNT(*) AS Total FROM `reviews` WHERE (`rating` < 5 AND `rating` >= 4) AND movie_id = '.$data['movie']->id.') / COUNT(*)) * 100 AS Good,
          ((SELECT COUNT(*) AS Total FROM `reviews` WHERE (`rating` < 4 AND `rating` >= 3) AND movie_id = '.$data['movie']->id.') / COUNT(*)) * 100 AS Average,
           ((SELECT COUNT(*) AS Total FROM `reviews` WHERE `rating` < 3 AND movie_id = '.$data['movie']->id.') / COUNT(*)) * 100 AS BelowAverage
            FROM `reviews` WHERE `movie_id` = '.$data['movie']->id.' ') );*/

$data['average'] = DB::select( DB::raw("SELECT
         ((SELECT COUNT(*) AS Total FROM `reviews` WHERE `rating` > 4 AND movie_id = ".$data['movie']->id.") / COUNT(*)) * 100 AS excellent,
         ((SELECT COUNT(*) AS Total FROM `reviews` WHERE (`rating` < 5 AND `rating` >= 4) AND movie_id = ".$data['movie']->id.") / COUNT(*)) * 100 AS good,
         ((SELECT COUNT(*) AS Total FROM `reviews` WHERE (`rating` < 4 AND `rating` >= 3) AND movie_id = ".$data['movie']->id.") / COUNT(*)) * 100 AS average,
         ((SELECT COUNT(*) AS Total FROM `reviews` WHERE `rating` < 3 AND movie_id = ".$data['movie']->id.") / COUNT(*)) * 100 AS belowaverage
            FROM `reviews` WHERE `movie_id` = ".$data['movie']->id." ") );

//prx($data['average'][0]->Excellent);

if (auth()->user()) {
           $data['verified_purches'] = Payment::where('user_id',$data['user']->id)
            ->where('movie_id',$data['movie']->id)
            ->first();
        }
        else{
            $data['verified_purches'] = '';
        }

if ($data['reviews']->count() > 0) { //slove error if no review
            $data['rating_value'] = $data['rating_sum'] / $data['reviews']->count();
        }
        else{
            $data['rating_value'] = 0;
        }
        if (auth()->user()) {
            $data['exists_review'] = Review::where('user_id',$data['user']->id)->where('movie_id',$data['movie']->id)->first();
        }
        else{
            $data['exists_review'] = '';
        }

return view('front.movie-details',$data);
    }

public function sportDetails($slug)
    {
        // dd("hi");
        $data['user'] = auth()->user();
        $data['sport'] = Sport::where('slug',$slug)->first();

// $data['movie'] = Movie::whereHas('categories', function($query){
        //     $query->where('categories.status','active');
        // })->where('slug',$slug)->first();
        // if (auth()->user()) {
        //     $data['verified_purches'] = Payment::where('user_id',$data['user']->id)
        //      ->where('movie_id',$data['movie']->id)
        //      ->first();
        //  }
        //  else{
        //      $data['verified_purches'] = '';
        //  }

//  if ($data['reviews']->count() > 0) { //slove error if no review
        //      $data['rating_value'] = $data['rating_sum'] / $data['reviews']->count();
        //  }
        //  else{
        //      $data['rating_value'] = 0;
        //  }
        //  if (auth()->user()) {
        //      $data['exists_review'] = Review::where('user_id',$data['user']->id)->where('movie_id',$data['movie']->id)->first();
        //  }
        //  else{
        //      $data['exists_review'] = '';
        //  }

if(!isset($data['sport']) || $data['sport']->status == "inactive"){
            abort(404, 'Page Not Found');
        }
        return view('front.sport-details',$data);
    }

public function musicDetails($slug)
    {
        // dd("hi");
        $data['user'] = auth()->user();
        $data['music'] = MusicMania::where('slug',$slug)->first();
       $data['musics']=Music::where('music_mania_id',  $data['music']->id)->where('status','active')->get();

if(!isset($data['music']) || $data['music']->status == "inactive"){
            abort(404, 'Page Not Found');
        }
        return view('front.music-details',$data);
    }

public function musicCategoryList(Request $request)
    {
        //prx($request->all());
        $slug = $request->slug;
       // prx($category_id);

$data['sigle_category'] = MusicMania::where('slug',$slug)->first();

if($slug){
            $data['category_header'] = Music::inRandomOrder()->whereHas('music_manias', function($query)use($slug){
                $query->where('music_manias.slug',$slug);
                $query->where('music_manias.status','active');
                $query->where('music_manias.is_featured','1');
            })->where('music.status','active')->orderByDesc('music.created_at')->first();
        }else{
            $data['category_header'] = Music::inRandomOrder()->where('status','active')->orderByDesc('created_at')->first();
        }

// $data['selected_category'] = $slug;

// //DB::enableQueryLog();
        // $query = Movie::latest();

if ($slug) {
            if(!isset($data['sigle_category']) || $data['sigle_category']->status == "inactive"){
                abort(404, 'Page Not Found');
            }

// $query->whereHas('categories', function ($join) use($slug) {
            //     $join->where('categories.slug',$slug);
            //     $join->where('movies.status','active');
            //     $join->where('categories.status','active');
            // });

$data['music'] = $query->paginate(20);

// $data['category_header'] = Movie::inRandomOrder()->where('is_featured',1)->where('status','active')->orderByDesc('created_at')->first();

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

/*else{
            abort(404, 'Page Not Found');
        }*/

//dd($data['movies']->count());

// $data['category_header'] = Category::where('id',14)->first();//it not will be fixed
        //it not will be fixed

$data['categories'] = MusicMania::where('status','active')->orderBy('created_at','desc')->get();

return view('front.music-category-list',$data)->with('slug',$slug);

}

public function moviePreviewDetails($slug)
    {
        $data['user'] = auth()->user();
        $data['movie'] = Movie::where('slug',$slug)->first();

if(!isset($data['movie']) || $data['movie']->status == "inactive"){
            abort(404, 'Page Not Found');
        }

$data['related_movies'] = Movie::whereHas('categories', function ($join) use($category_id_arr) {
            $join->whereIn('categories.id',$category_id_arr);
            $join->where('movies.status','active');
        })->inRandomOrder()->take(20)->where('id','!=', $data['movie']->id)->get();

$data['star_cast'] = json_decode($data['movie']->star_cast);

//prx($data['average'][0]->Excellent);

return view('front.movie-details',$data);
    }
    public function addReview(Request $request)
    {
        $movie_id = $request->input('movie_id');
        $user_id = auth()->id();

$movie_check = Movie::where('id',$movie_id)->where('status','active')->first();

if($movie_check){
            $verified_purches = Payment::where('user_id',$user_id)->where('movie_id',$movie_id)->first();
            $verified_purches_30_days = User::where('id',$user_id)->whereNotNull('stripe_id')->first();
            if ($verified_purches || $verified_purches_30_days) {

$exists_review = Review::where('user_id',$user_id)->where('movie_id',$movie_id)->first();
                if ($exists_review) {
                    // $exists_review->fill($request->only(['rating','description']));
                    // $exists_review->update();
                    return redirect()->back()->with('warning',"Oops || You have already reviewed this movie");
                }
                else{
                    $request->validate([
                        'description' => 'required|string',
                        'rating' => 'required|string',
                    ]);
                    $review = new Review;
                    $review->fill($request->all());
                    $review->user_id = $user_id;
                    $review->save();
                }
                return redirect()->back()->with('success',"Thank you for review this movie");

}
            else{
                return redirect()->back()->with('error',"Sorry !! You don't have to review this movie with out purches");
            }

}
        else{
            return redirect()->back()->with('error','This movie has no exists!!');
        }

//prx($user_id);

}

public function searchMovie(Request $request){
        $search_keyword = $request->search_keyword;
        $data = Movie::where('title', 'like', '%' . $search_keyword . '%')->get();
        //prx($data);

return response()->json($data);

//prx($request->all());
    }

// public function checkPasscode(Request $request)
    // {

//     $valid = Validator::make($request->all(), [
    //          'passcode' => 'required|string'
    //     ]);

//     if (!$valid->passes()) //if ($validator->fails())
    //     {
    //         return response()
    //             ->json(['status' => 'required', 'required' => $valid->errors()
    //             ->toArray() ]);
    //     }

//     $user_id = auth()->id();
    //     $movie_id = $request->input('movie_id');

//     $db_passcode = Payment::where('user_id',$user_id)->where('movie_id',$movie_id)->latest('created_at')->first();

//     if ($db_passcode->passcode == trim($request->input('passcode'))) {
    //         return response()->json(['status' => 'success']);
    //     }
    //     else{
    //         return response()->json(['status' => 'error', 'error' => "Sorry || This passcode hasn't matched!!"]);
    //     }
    // }

}

[-] ProfileController.php [edit]
[+] ..
[-] ChatController.php [edit]
[-] SubscribeController.php [edit]
[-] WatchListController.php [edit]
[-] ContactFromController.php [edit]
[-] SiteController.php [edit]
[-] DashboardController.php [edit]
[-] HomeController.php [edit]