Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
Api	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
Auth	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
ripcord	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
AddressController.php	4.36 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingFloorsController.php	1.9 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingTypesController.php	1.88 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingsController.php	4.48 KB	-rwxrwxrwx	2022-04-21 13:43
CalendarController.php	467 B	-rwxrwxrwx	2022-04-21 13:43
CarHistoryController.php	3.01 KB	-rwxrwxrwx	2022-04-21 13:43
CarsController.php	2.78 KB	-rwxrwxrwx	2022-04-21 13:43
CheckInController.php	1.74 KB	-rwxrwxrwx	2022-04-21 13:43
Controller.php	361 B	-rwxrwxrwx	2022-04-21 13:43
CustomersController.php	4.75 KB	-rwxrwxrwx	2022-04-21 13:43
DevisController.php	4.99 KB	-rwxrwxrwx	2022-04-21 13:43
DevisLinesController.php	2 KB	-rwxrwxrwx	2022-04-21 13:43
DocumentsController.php	2.14 KB	-rwxrwxrwx	2022-04-21 13:43
HomeController.php	2.54 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionAddressesController.php	2.07 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionBuildingsController.php	2.07 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionContactsController.php	2.04 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionStatusController.php	2 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionsController.php	15.03 KB	-rwxrwxrwx	2022-04-21 13:43
OddoController.php	6.5 KB	-rwxrwxrwx	2022-06-02 16:29
PassesController.php	1.72 KB	-rwxrwxrwx	2022-04-21 13:43
ProfileController.php	1.1 KB	-rwxrwxrwx	2022-04-21 13:43
RulesController.php	1.69 KB	-rwxrwxrwx	2022-04-21 13:43
StatusController.php	1.72 KB	-rwxrwxrwx	2022-04-21 13:43
TeamHistoryController.php	3.09 KB	-rwxrwxrwx	2022-04-21 13:43
TeamLogsController.php	1.76 KB	-rwxrwxrwx	2022-04-21 13:43
TeamMembersController.php	1.83 KB	-rwxrwxrwx	2022-04-21 13:43
TeamsController.php	6.69 KB	-rwxrwxrwx	2022-04-21 13:43
UserController.php	4.55 KB	-rwxrwxrwx	2022-04-21 13:43

Rename

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;

class HomeController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware('auth');
    }

/**
     * Show the application dashboard.
     *
     * @return \Illuminate\View\View
     */
    public function index()
    {
      $actualDay = date("Y-m-d");
      $day = date('w');
      $week_start = date('Y-m-d', strtotime('-' . ($day + 1) . ' days'));
      $week_end = date('Y-m-d', strtotime('+' . (7 - $day) . ' days'));

$numberTeams = DB::table('teams')
        ->count();

$numberTeamsActive = DB::table('team_histories')
        ->where('start_date', '<', $actualDay)
        ->where('end_date', '>', $actualDay)
        ->distinct('team_id')
        ->count();

$openedInterventions = DB::table('interventions')
        ->where('start_date', '<', $actualDay)
        ->where('end_date', '>', $actualDay)
        ->distinct('team_id')
        ->count();

$closedInterventions = DB::table('interventions')
        ->where('status_id', '=', 3) //TODO: edit value depending the value in status table
        ->count();

$toInvoiceInterventions = DB::table('interventions')
        ->where('status_id', '=', 4) //TODO: edit value depending the value in status table
        ->count();

$workerActive = DB::table('team_histories')
        ->where('start_date', '<', $actualDay)
        ->where('end_date', '>', $actualDay)
        ->distinct('team_member_id')
        ->count();

$weeklyInterventions = DB::table('interventions')
        ->where('start_date', '>', $week_start)
        ->where('end_date', '<', $week_end)
        ->get();

//fetch address of interventions
      $n = 0;
      foreach ($weeklyInterventions as $inter) {
        $address = DB::table("addresses")
          ->join('intervention_addresses', 'intervention_addresses.address_id', "=", "addresses.id")
          ->where('intervention_id', '=', $inter->id)
          ->get('address');
        $weeklyInterventions[$n]->address = $address[0]->address;
        $n++;
      }

return view('dashboard', [
        'numberTeams' => $numberTeams,
        'workerActive' => $workerActive,
        'numberTeamsActive' => $numberTeamsActive,
        'openedInterventions' => $openedInterventions,
        'closedInterventions' => $closedInterventions,
        'weeklyInterventions' => $weeklyInterventions,
        'toInvoiceInterventions' => $toInvoiceInterventions
      ]);
    }
}