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