/**
* 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);
}
