File: /home/imensosw/www/amanda/app/Http/Controllers/TipHistoryController.php
<?php
namespace App\Http\Controllers;
use App\Tip_history;
use Illuminate\Http\Request;
class TipHistoryController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$limit = config('constants.limit');
$search = $request->search;
$tip_history = Tip_history::
join('users','users.id','tip_history.user_id')
->where(function($q) use ($search)
{
$q->orWhere('tip_history.amount', 'like', '%' . $search . '%');
})
->select("users.name as user_name","tip_history.amount","tip_history.created_at")
->orderBy('tip_history.id','desc')
->paginate($limit);
return response()->json($tip_history,200);
// $tip = Tip::paginate(5);
// return response()->json(Tip::all(),200);
}
public function search(Request $request)
{
$limit = config('constants.limit');
$search = $request->search;
$tip_history = Tip_history::
join('users','users.id','tip_history.user_id')
->where(function($q) use ($search)
{
$q->orWhere('users.name', 'like', '%' . $search . '%');
})
->select("users.name as user_name","tip_history.amount","tip_history.created_at")
->orderBy('tip_history.id','desc')
->paginate($limit);
return response()->json($tip_history,200);
}
}