<?php

namespace App\Modules\Company\Whiteboard\Project;

use App\Models\ProjectExpenses;

class ProjectExpense
{
    public function getData($id)
    {
        $projectExpensesData = ProjectExpenses::select(
            'project_expenses.inhouse',
            'project_expenses.external')
            ->where('project_expenses.project_id', $id)
            ->first();

        $inhouseExpense = 0;
        $externalExpense = 0;

        if ($projectExpensesData) {
            $inhouseExpense = $projectExpensesData->inhouse;
            $externalExpense = $projectExpensesData->external;
        }

        $totalExpense = $inhouseExpense + $externalExpense;

        return [
            'totalExpense' => $totalExpense,
            'inhouseExpense' => $inhouseExpense,
            'externalExpense' => $externalExpense,
        ];
    }
}