Example #1
0
|
*/
Route::get('/', function () {
    return view('messages');
});
Route::get('home', 'DashboardController@index');
Route::get('messages', function (Request $request) {
    // we recover all the data sent by the ajax request
    $keys = $request::all();
    $query = "";
    // test of the query parameter
    if ($keys['query'] != "") {
        $query = Conversation::where("Title", "like", "%" . $keys['query'] . "%");
        //->skip($keys['offset']);//->get();
    } else {
        $query = Conversation::select("*");
    }
    //test of the offset parameter
    if ($keys['offset'] != 0) {
        $query = $query->take($keys['limit'])->skip($keys['offset'])->get();
    } else {
        $query = $query->get();
    }
    //else
    //{	// cannot use offset alone, so we take a limit very high
    //	$query=Conversation::select("*")->take(9999999)->skip($keys['offset'])->get();
    // we do not want so much be we still need to know how much answer we get
    //}
    $i = 0;
    $response = array();
    foreach ($query as $qry) {