<?php

namespace App\Http\Controllers;

use App\Newsletter;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class NewsletterController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $limit = config('constants.limit');
        $search = $request->search;
        
        $inquiry = Newsletter::
                where(function($q) use ($search)
                {
                      $q->orWhere('new_letter.email', 'like', '%' . $search . '%');
                })
                ->orderBy('new_letter.id','desc')
                ->paginate($limit);
        return response()->json($inquiry,200);
  
    }

    public function search(Request $request)
    {
        $limit = config('constants.limit');
        $search = $request->search;
        $inquiry = Newsletter::
                where(function($q) use ($search)
                {
                      $q->orWhere('new_letter.email', 'like', '%' . $search . '%');
                })
                 ->orderBy('new_letter.id','desc')
                ->paginate($limit);
        return response()->json($inquiry,200);
    }

 

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {   
        $status = Newsletter::find($id)->delete();

        return response()->json([
            'status' => $status,
            'message' => $status ? 'Tip Deleted!' : 'Error Deleting Tip'
        ]);
    }


}