<?php

namespace App\Http\Controllers;

use App\About_us;
use Illuminate\Http\Request;
use App\MessagePurchaseHistory;
use App\User;
use Auth;

class MessagePurchaseHistoryController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $limit = config('constants.limit');
        $search = $request->search;
         $MessagePurchaseHistory = MessagePurchaseHistory::leftjoin('users','message_purchase_history.user_id','users.id')
            // ->where('message_purchase_history.user_id',Auth::user()->id)
                ->where(function($q) use ($search)
                {
                    $q->orWhere('users.name', 'like', '%' . $search . '%');
                    $q->orWhere('message_purchase_history.created_at', 'like', '%' . $search . '%');
                    $q->orWhere('message_purchase_history.quantity', 'like', '%' . $search . '%');  
                })
            ->select('message_purchase_history.*','users.name as user_name')
            ->groupBy('message_purchase_history.id')
             ->orderBy('message_purchase_history.id','desc')
            // ->get();
             ->paginate($limit);
        return response()->json($MessagePurchaseHistory,200);
    }
  



}