/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$data['mem_limit'] = ini_get('memory_limit');
$data['english_words'] = Word::where('language_id', '1')->count();
$data['danish_words'] = Word::where('language_id', '2')->count();
$data['pashto_words'] = Word::where('language_id', '3')->count();
$data['unique_users'] = User::count();
$data['users'] = User::limit(4)->get();
$data['words'] = Word::with(['language', 'user'])->limit(8)->orderBy('created_at', 'desc')->get();
$used_mem = memory_get_peak_usage(false);
$data['mem_using'] = round($used_mem / 1024 / 1024, 1) . 'M';
return view('admin.dashboard', $data);
}
public function getWordsAjax(Request $request)
{
//print_r($request->all());
if (!$request->ajax()) {
return response()->json(['response' => 'reject', 'msg' => 'request Not Allowed', 'searchWord' => $request->searchWord, 'language' => $request->languageName, 'Ajax' => $request->ajax(), 'Request' => $request->method()]);
}
$languageName = $request->languageName;
$searchWord = $request->searchWord;
$language = new Language();
$languageList = $language->lists('name')->all();
$words = Word::with(['user', 'language']);
if (!in_array($languageName, $languageList)) {
$languageName = '';
} else {
$language_id = $language->where('name', '=', $languageName)->value('id');
$words->where('language_id', '=', $language_id);
}
if ($searchWord != null) {
$words->where('word', 'LIKE', $searchWord . '%');
}
return $words->orderBy('word', 'asc')->limit(15)->get();
}
