rodineiti /
backend-api-frontend-laravel
| 1 | <?php |
||||||
| 2 | |||||||
| 3 | namespace App\Http\Controllers; |
||||||
| 4 | |||||||
| 5 | use Illuminate\Http\Request; |
||||||
| 6 | use Illuminate\Support\Collection; |
||||||
| 7 | |||||||
| 8 | class HomeController extends Controller |
||||||
| 9 | { |
||||||
| 10 | /** |
||||||
| 11 | * Create a new controller instance. |
||||||
| 12 | * |
||||||
| 13 | * @return void |
||||||
| 14 | */ |
||||||
| 15 | public function __construct() |
||||||
| 16 | { |
||||||
| 17 | $this->middleware('auth'); |
||||||
| 18 | } |
||||||
| 19 | |||||||
| 20 | /** |
||||||
| 21 | * Show the application dashboard. |
||||||
| 22 | * |
||||||
| 23 | * @return \Illuminate\Http\Response |
||||||
| 24 | */ |
||||||
| 25 | public function index() |
||||||
| 26 | { |
||||||
| 27 | $dateStart = date('Y-m-d', mktime(0, 0, 0, date('m')-1 , 1 , date('Y'))); |
||||||
|
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||||||
| 28 | $dateEnd = date('Y-m-d', mktime(23, 59, 59, date('m'), date("t"), date('Y'))); |
||||||
|
0 ignored issues
–
show
date('t') of type string is incompatible with the type integer expected by parameter $day of mktime().
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
date('m') of type string is incompatible with the type integer expected by parameter $month of mktime().
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
|
|||||||
| 29 | |||||||
| 30 | $billPays = auth()->user()->bill_pays()->selectRaw('bill_pays.*, categories.name as category_name') |
||||||
| 31 | ->join('categories', 'categories.id', '=', 'bill_pays.category_id') |
||||||
| 32 | ->whereBetween('date_launch', [$dateStart, $dateEnd]) |
||||||
| 33 | ->where('status', '1') |
||||||
| 34 | ->get(); |
||||||
| 35 | |||||||
| 36 | $billReceives = auth()->user()->bill_receives()->selectRaw('bill_receives.*, categories.name as category_name') |
||||||
| 37 | ->join('categories', 'categories.id', '=', 'bill_receives.category_id') |
||||||
| 38 | ->whereBetween('date_launch', [$dateStart, $dateEnd]) |
||||||
| 39 | ->where('status', '1') |
||||||
| 40 | ->get(); |
||||||
| 41 | |||||||
| 42 | $collection = new Collection(array_merge_recursive($billPays->toArray(), $billReceives->toArray())); |
||||||
| 43 | $statements = $collection->sortByDesc('date_launch'); |
||||||
| 44 | |||||||
| 45 | $total_pays = $billPays->sum('value'); |
||||||
| 46 | $total_receives = $billReceives->sum('value'); |
||||||
| 47 | |||||||
| 48 | $categoriesPay = auth()->user()->categories()->selectRaw('categories.name, sum(value) as value') |
||||||
| 49 | ->join('bill_pays', 'bill_pays.category_id', '=', 'categories.id') |
||||||
| 50 | ->whereBetween('date_launch', [$dateStart, $dateEnd]) |
||||||
| 51 | ->whereNotNull('bill_pays.category_id') |
||||||
| 52 | ->groupBy('categories.name') |
||||||
| 53 | ->where('status', '1') |
||||||
| 54 | ->get(); |
||||||
| 55 | |||||||
| 56 | $categoriesReceive = auth()->user()->categories()->selectRaw('categories.name, sum(value) as value') |
||||||
| 57 | ->join('bill_receives', 'bill_receives.category_id', '=', 'categories.id') |
||||||
| 58 | ->whereBetween('date_launch', [$dateStart, $dateEnd]) |
||||||
| 59 | ->whereNotNull('bill_receives.category_id') |
||||||
| 60 | ->groupBy('categories.name') |
||||||
| 61 | ->where('status', '1') |
||||||
| 62 | ->get(); |
||||||
| 63 | |||||||
| 64 | return view('home', compact('billPays','billReceives','total_pays','total_receives','categoriesPay','categoriesReceive','dateStart','dateEnd','statements')); |
||||||
|
0 ignored issues
–
show
|
|||||||
| 65 | } |
||||||
| 66 | } |
||||||
| 67 |