/** * Store a newly created resource in storage. * * @return Response */ public function accounts() { $accounts = Accounts::select('email', 'Accounts.CustomerID', 'GamePoints', 'GameDollars', 'UsersData.IsDeveloper', 'UsersData.AccountStatus')->join('UsersData', 'Accounts.CustomerID', '=', 'UsersData.CustomerID')->orderby('Accounts.CustomerID', 'asc')->paginate(20); //->get(); //dd($accounts); return view('accounts', compact('accounts')); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function find(Request $request) { $characters = Accounts::select('Accounts.CustomerID', 'UsersChars.CharID', 'UsersChars.Gamertag', 'UsersChars.Alive', 'UsersChars.Health', 'UsersChars.XP', 'UsersChars.Reputation')->join('UsersChars', 'Accounts.CustomerID', '=', 'UsersChars.CustomerID')->where('UsersChars.Gamertag', 'like', '%' . $request->input('search') . '%')->orderby('UsersChars.CharID', 'asc')->paginate(20); //->get(); //dd($accounts); return view('characters', compact('characters')); }