carsearchService = $carsearchService; // } public function __construct() { } public function index(Request $request) { // echo "search car";exit; $dataBag = array(); $dataBag['chMenu'] = 'carWashReportList'; $data = WashDetail::select('wash_details.id','wash_details.car_id','wash_details.entry_date','wash_details.wash_type_id','wash_details.body_type','wash_details.amount','wash_details.date_washed','wash_details.time_washed','wash_details.status','wash_details.payment_status','wash_details.payment_details','cwo_master.cwo_name','cwo_master.cwo_company','co_master.co_fname','co_master.co_lname','co_master.co_phone','users.email','co_car.car_registration_no','wash_categories.wash_name') ->join('co_car','co_car.id','=','wash_details.car_id') ->join('co_master','co_master.id','=','co_car.co_id') ->join('users','users.id','=','co_master.user_id') ->join('wash_categories','wash_categories.id','=','wash_details.wash_type_id') ->join('cwo_master','cwo_master.id','=','wash_categories.cwo_id') ->orderBy('co_car.id', 'desc'); $dataCnt = $data->count(); $data = $data->paginate(10); $dataBag['allRecords'] = $dataCnt; $dataBag['records'] = $data; // echo "

";print_r($dataBag['records']->toArray());exit;
        return view('washreport.list', $dataBag);
        
    }


    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request, string $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        //
    }
}