App\Http\Controllers\HomeController::index()

Complexity

Conditions	1
Paths	1

Size

Total Lines	40
Code Lines	31

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function index()
    {
        $dateStart = date('Y-m-d', mktime(0, 0, 0, date('m')-1 , 1 , date('Y')));

date('Y') of type string is incompatible with the type integer expected by parameter $year of mktime().

        $dateEnd = date('Y-m-d', mktime(23, 59, 59, date('m'), date("t"), date('Y')));

date('t') of type string is incompatible with the type integer expected by parameter $day of mktime().

date('m') of type string is incompatible with the type integer expected by parameter $month of mktime().

        $billPays = auth()->user()->bill_pays()->selectRaw('bill_pays.*, categories.name as category_name')
            ->join('categories', 'categories.id', '=', 'bill_pays.category_id')
            ->whereBetween('date_launch', [$dateStart, $dateEnd])
            ->where('status', '1')
            ->get();

        $billReceives = auth()->user()->bill_receives()->selectRaw('bill_receives.*, categories.name as category_name')
            ->join('categories', 'categories.id', '=', 'bill_receives.category_id')
            ->whereBetween('date_launch', [$dateStart, $dateEnd])
            ->where('status', '1')
            ->get();

        $collection = new Collection(array_merge_recursive($billPays->toArray(), $billReceives->toArray()));
        $statements = $collection->sortByDesc('date_launch');

        $total_pays = $billPays->sum('value');
        $total_receives = $billReceives->sum('value');

        $categoriesPay = auth()->user()->categories()->selectRaw('categories.name, sum(value) as value')
            ->join('bill_pays', 'bill_pays.category_id', '=', 'categories.id')
            ->whereBetween('date_launch', [$dateStart, $dateEnd])
            ->whereNotNull('bill_pays.category_id')
            ->groupBy('categories.name')
            ->where('status', '1')
            ->get();

        $categoriesReceive = auth()->user()->categories()->selectRaw('categories.name, sum(value) as value')
            ->join('bill_receives', 'bill_receives.category_id', '=', 'categories.id')
            ->whereBetween('date_launch', [$dateStart, $dateEnd])
            ->whereNotNull('bill_receives.category_id')
            ->groupBy('categories.name')
            ->where('status', '1')
            ->get();

        return view('home', compact('billPays','billReceives','total_pays','total_receives','categoriesPay','categoriesReceive','dateStart','dateEnd','statements'));

The expression return view('home', compact('billPays', 'billReceives', 'total_pays', 'total_receives', 'categoriesPay', 'categoriesReceive', 'dateStart', 'dateEnd', 'statements')) returns the type Illuminate\View\View which is incompatible with the documented return type Illuminate\Http\Response.

    }