/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // // $name = Auth::user()->email; // return view('dashboard'); $user = Auth::user()->name; $userId = Auth::user()->id; $locateInDbUser = App\User::find($userId); $locateInDbItems = App\Items::find($userId); $locateInDbWatchlist = App\Watchlist::find($userId); $itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count(); $itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count(); $benefit = $locateInDbUser->benefits; $auction_wins = $locateInDbUser->auction_wins; $itemsOnWatchlist = DB::table('watchlists')->where('user_id', '=', $userId)->get(); if ($itemsOnWatchlist == []) { $queryWatchlist = ''; return view('dashboard')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsOnWatchlist', $itemsOnWatchlist)->with('queryWatchlist', $queryWatchlist); } else { $queryWatchlist = DB::table('items'); foreach ($itemsOnWatchlist as $itemOnWatchlist) { $queryWatchlist->orWhere('id', '=', $itemOnWatchlist->item_id); } $queryWatchlist = $queryWatchlist->get(); // return $queryWatchlist; return view('dashboard')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsOnWatchlist', $itemsOnWatchlist)->with('queryWatchlist', $queryWatchlist); } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $user = Auth::user()->name; $userId = Auth::user()->id; $locateInDbUser = App\User::find($userId); $locateInDbItems = App\Items::find($userId); $locateInDbWatchlist = App\Watchlist::find($userId); $itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count(); $itemsSelect = DB::table('items')->where('betting_status', '=', 1)->where('users_id', '=', $userId)->orderBy('id', 'asc')->lists('item_name'); $itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count(); $benefit = $locateInDbUser->benefits; $auction_wins = $locateInDbUser->auction_wins; return view('retrieveOffer')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsSelect', $itemsSelect); }
public function searchItemForm() { $itemToSearchName = Input::get('itemName'); $itemToSearchSelect = Input::get('userChosen'); $itemToSearchSelect2 = Input::get('categoryChosen'); $user = Auth::user()->name; $userId = Auth::user()->id; // $itemsToId=DB::table('items') // ->where('item_name','=',$itemToOffer) // ->where('users_id','=',$userId) // ->first(); $query = DB::table('items'); $query->where('users_id', '<>', $userId); $query->where('betting_status', '=', 1); if ($itemToSearchSelect != 'Any user') { // $query->where('user') $usersSelect = DB::table('users')->where('email', '=', $itemToSearchSelect)->first(); $query->where('users_id', '=', $usersSelect->id); } if ($itemToSearchSelect2 != 'Any category') { // $query->where('user') // $catSelect=DB::table('categories') // ->where('catname','=',$itemToSearchSelect2) // ->first(); $query->where('category1', '=', $itemToSearchSelect2); } if ($itemToSearchName != '') { $query->where('item_name', 'LIKE', '%' . $itemToSearchName . '%'); } $rows = $query->get(); if ($rows == []) { Session::flash('messageErrorDate', "No match, redefine your search terms"); return redirect('searchItem'); } else { $rows = $query->paginate(10); $user = Auth::user()->name; $userId = Auth::user()->id; $locateInDbUser = App\User::find($userId); $locateInDbItems = App\Items::find($userId); $locateInDbWatchlist = App\Watchlist::find($userId); $itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count(); $usersTable = DB::table('users'); $itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count(); $benefit = $locateInDbUser->benefits; $auction_wins = $locateInDbUser->auction_wins; Session::flash('messageOkSearch', ""); return view('searchResults')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('rowsSearch', $rows)->with('usersTable', $usersTable); } // return $rows; }
public function FinalItembet($idItem) { $user = Auth::user()->name; $userId = Auth::user()->id; $locateInDbUser = App\User::find($userId); $locateInDbItems = App\Items::find($userId); $locateInDbWatchlist = App\Watchlist::find($userId); $itemId = explode('X', $idItem); $itemId = intval($itemId[0]); $itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count(); $itemsName = DB::table('items')->where('id', '=', $itemId)->value('item_name'); $itemsDescription = DB::table('items')->where('id', '=', $itemId)->value('description'); $itemsMin = DB::table('items')->where('id', '=', $itemId)->value('minimalPrice'); $itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count(); $benefit = $locateInDbUser->benefits; $auction_wins = $locateInDbUser->auction_wins; // return view('FinalItembet')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsDescription', $itemsDescription)->with('itemsMin', $itemsMin)->with('itemId', $itemId)->with('itemsName', $itemsName); }