webshell

Ghost Exploiter Team Official

Directory >> /home/softsuitetech/public_html/DEMO/RCA-System/resources/views/budget/

File / Folder	Size	Action
.	-
.htaccess	0.27KB	edt ren
create.blade.php	23.53KB	edt ren
edit.blade.php	27.211KB	edt ren
index.blade.php	4.673KB	edt ren
show.blade.php	59.055KB	edt ren

@extends('layouts.admin')
@section('page-title')
 {{__('Budget Vs Actual')}}
@endsection
@section('breadcrumb')
 <li class="breadcrumb-item"><a href="{{route('dashboard')}}">{{__('Dashboard')}}</a></li>
 <li class="breadcrumb-item"><a href="{{route('budget.index')}}">{{__('Budget Planner')}}</a></li>
 <li class="breadcrumb-item">{{ $budget->name }}</li>
@endsection
@push('script-page')
 <script src="{{asset('js/jquery-ui.min.js')}}"></script>
 <script>
 //Income Total
 $(document).on('keyup', '.income_data', function () {
 //category wise total
 var el = $(this).parent().parent();
 var inputs = $(el.find('.income_data'));

var totalincome = 0;
 for (var i = 0; i < inputs.length; i++) {
 var price = $(inputs[i]).val();
 totalincome = parseFloat(totalincome) + parseFloat(price);
 }
 el.find('.totalIncome').html(totalincome);

// month wise total //
 var month_income = $(this).data('month');
 var month_inputs = $(el.parent().find('.' + month_income + '_income'));
 var month_totalincome = 0;
 for (var i = 0; i < month_inputs.length; i++) {
 var month_price = $(month_inputs[i]).val();
 month_totalincome = parseFloat(month_totalincome) + parseFloat(month_price);
 }
 var month_total_income = month_income + '_total_income';
 el.parent().find('.' + month_total_income).html(month_totalincome);

//all total //
 var total_inputs = $(el.parent().find('.totalIncome'));
 console.log(total_inputs)
 var income = 0;
 for (var i = 0; i < total_inputs.length; i++) {
 var price = $(total_inputs[i]).html();
 income = parseFloat(income) + parseFloat(price);
 }
 el.parent().find('.income').html(income);

})

//Expense Total
        $(document).on('keyup', '.expense_data', function () {
            //category wise total
            var el = $(this).parent().parent();
            var inputs = $(el.find('.expense_data'));

var totalexpense = 0;
 for (var i = 0; i < inputs.length; i++) {
 var price = $(inputs[i]).val();
 totalexpense = parseFloat(totalexpense) + parseFloat(price);
 }
 el.find('.totalExpense').html(totalexpense);

// month wise total //
 var month_expense = $(this).data('month');
 var month_inputs = $(el.parent().find('.' + month_expense + '_expense'));
 var month_totalexpense = 0;
 for (var i = 0; i < month_inputs.length; i++) {
 var month_price = $(month_inputs[i]).val();
 month_totalexpense = parseFloat(month_totalexpense) + parseFloat(month_price);
 }
 var month_total_expense = month_expense + '_total_expense';
 el.parent().find('.' + month_total_expense).html(month_totalexpense);

//all total //
 var total_inputs = $(el.parent().find('.totalExpense'));
 console.log(total_inputs)
 var expense = 0;
 for (var i = 0; i < total_inputs.length; i++) {
 var price = $(total_inputs[i]).html();
 expense = parseFloat(expense) + parseFloat(price);
 }
 el.parent().find('.expense').html(expense);

})

//Hide & Show
        $(document).on('change', '.period', function () {
            var period = $(this).val();

$('.budget_plan').removeClass('d-block');
            $('.budget_plan').addClass('d-none');
            $('#' + period).removeClass('d-none');
            $('#' + period).addClass('d-block');
        });

// trigger
        $('.period').trigger('change');

</script>
@endpush

@section('content')
 <div class="col-12 mt-4">
 <div class="card p-4 mb-4">
 <h6 class="report-text mb-0 text-center">{{__('Year :')}} {{ $budget->from }}</h6>
 </div>
 </div>
 <div class="row">
 <div class="col-12">
 <div class="card">
 <div class="card-body" style="overflow-x: auto">

{{-- Monthly Budget--}}
 @if($budget->period == 'monthly')
 <table class="table table-bordered table-item data">
 <thead>
 <tr>
 <td rowspan="2"></td>
 @foreach($monthList as $month)
 <th colspan="3" scope="colgroup" class="text-center br-1px">{{$month}}</th>
 @endforeach
 </tr>
 <tr>
 @foreach($monthList as $month)
 <th scope="col" class="br-1px">Budget</th>
 <th scope="col" class="br-1px">Actual</th>
 <th scope="col" class="br-1px">Over Budget</th>
 @endforeach
 </tr>
 </thead>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Income :')}}</th>
 </tr>

@php
                                $overBudgetTotal=[];
                            @endphp

@foreach ($incomeproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($monthList as $month)
 @php
 $budgetAmount= ($budget['income_data'][$productService->id][$month])?$budget['income_data'][$productService->id][$month]:0;
 $actualAmount=$incomeArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overBudgetTotal[$productService->id][$month]=$overBudgetAmount;
 @endphp
 <td class="income_data {{$month}}_income">{{!empty (\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($incomeArr[$productService->id][$month])}}
 {{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month])!=0) ? '('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month]).'%)') :'':''}}
 </td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['income_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}}" >{{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$overBudgetAmount) !=0) ?'('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$overBudgetAmount).'%)') :'':''}}

</td>
 @endforeach
 </tr>
 @endforeach

@php
 $overBudgetTotalArr = array();
 foreach($overBudgetTotal as $overBudget)
 {
 foreach($overBudget as $k => $value)
 {
 $overBudgetTotalArr[$k] = (isset($overBudgetTotalArr[$k]) ? $overBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp
 <tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @if(!empty($budgetTotal) )
 @foreach($monthList as $month)

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overBudgetTotalArr[$month]) }}
 $overBudgetAmount)? 'red-text':''}}">{{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Expense :')}}</th>
 </tr>
 @php
 $overExpenseBudgetTotal=[];
 @endphp

@foreach ($expenseproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($monthList as $month)
 @php
 $budgetAmount= ($budget['expense_data'][$productService->id][$month])?$budget['expense_data'][$productService->id][$month]:0;
 $actualAmount=$expenseArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overExpenseBudgetTotal[$productService->id][$month]=$overBudgetAmount;
 @endphp
 <td class="expense_data {{$month}}_expense">{{\Auth::user()->priceFormat(!empty($budget['expense_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['expense_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($expenseArr[$productService->id][$month])}}
 {{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month])!=0) ? '('.(\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month]).'%)') :'':''}}

</td>
 @endforeach
 </tr>
 @endforeach

@php
                                $overExpenseBudgetTotalArr = array();
                                  foreach($overExpenseBudgetTotal as $overExpenseBudget)
                                  {
                                      foreach($overExpenseBudget as $k => $value)
                                      {
                                          $overExpenseBudgetTotalArr[$k] = (isset($overExpenseBudgetTotalArr[$k]) ? $overExpenseBudgetTotalArr[$k] + $value : $value);
                                      }
                                  }
                            @endphp

<tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @if(!empty($budgetExpenseTotal) )
 @foreach($monthList as $month)
 <td class="text-dark {{$month}}_total_expense">{{\Auth::user()->priceFormat($budgetExpenseTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($expenseTotalArr[$month])}}
 {{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month]).'%)') :'':''}}
 </td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overExpenseBudgetTotalArr[$month]) }}
 $overExpenseBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>

<tfoot>
 <tr class="total">
 <td class="text-dark">{{__('NET PROFIT :')}}</td>
 @php
 // NET PROFIT OF OVER BUDGET
 $overbudgetprofit = [];
 $keys = array_keys($overBudgetTotalArr + $overExpenseBudgetTotalArr);
 foreach($keys as $v)
 {
 $overbudgetprofit[$v] = (empty($overBudgetTotalArr[$v]) ? 0 : $overBudgetTotalArr[$v]) - (empty($overExpenseBudgetTotalArr[$v]) ? 0 : $overExpenseBudgetTotalArr[$v]);
 }
 $data['overbudgetprofit'] = $overbudgetprofit;
 @endphp

@if(!empty($budgetprofit) )

@foreach($monthList as $month)
 <td class="text-dark">{{\Auth::user()->priceFormat($budgetprofit[$month]) }}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($actualprofit[$month]) }}
 {{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overbudgetprofit[$month]) }}
 {{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>
 </tfoot>

</table>

@elseif($budget->period == 'quarterly')
 <table class="table table-bordered table-item data">
 <thead>
 <tr>
 <td rowspan="2"></td> 
 @foreach($quarterly_monthlist as $month)
 <th colspan="3" scope="colgroup" class="text-center br-1px">{{$month}}</th>
 @endforeach
 </tr>
 <tr>
 @foreach($quarterly_monthlist as $month)
 <th scope="col" class="br-1px">Budget</th>
 <th scope="col" class="br-1px">Actual</th>
 <th scope="col" class="br-1px">Over Budget</th>
 @endforeach
 </tr>
 </thead>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Income :')}}</th>
 </tr>

@php
                                $overBudgetTotal=[];
                            @endphp

@foreach ($incomeproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($quarterly_monthlist as $month)
 @php
 $budgetAmount= ($budget['income_data'][$productService->id][$month])?$budget['income_data'][$productService->id][$month]:0;
 $actualAmount=$incomeArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overBudgetTotal[$productService->id][$month]=$overBudgetAmount;
 @endphp

<td class="income_data {{$month}}_income">{{!empty (\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($incomeArr[$productService->id][$month])}}
 {{-- @if($budget['income_data'][$productService->id][$month] )--}}
 {{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month])!=0) ? '('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month]).'%)') :'':''}}

</td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['income_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}}">{{($budget['income_data'][$productService->id][$month] !=0)? '('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$overBudgetAmount).'%)') :''}}
 </td>

@endforeach
 </tr>
 @endforeach
 @php
 $overBudgetTotalArr = array();
 foreach($overBudgetTotal as $overBudget)
 {
 foreach($overBudget as $k => $value)
 {
 $overBudgetTotalArr[$k] = (isset($overBudgetTotalArr[$k]) ? $overBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp
 <tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @if(!empty($budgetTotal) )

@foreach($quarterly_monthlist as $month)

<td class="text-dark {{$month}}_total_income">{{\Auth::user()->priceFormat($budgetTotal[$month])}}</td>
 <td>{{\Auth::user()->priceFormat($incomeTotalArr[$month])}}
 {{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month]) !=0)?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month]).'%)') :'':''}}
 </td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overBudgetTotalArr[$month]) }}
 $overBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetTotal[$month] !=0)? '('.(\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month]).'%)') :''}}
 </td>
 @endforeach
 @endif

</tr>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Expense :')}}</th>
 </tr>

@php
                                $overExpenseBudgetTotal=[];
                            @endphp

@foreach ($expenseproduct as $productService)
 <tr>

<td class="text-dark">{{$productService->name}}</td>
 @foreach($quarterly_monthlist as $month)
 @php
 $budgetAmount= ($budget['expense_data'][$productService->id][$month])?$budget['expense_data'][$productService->id][$month]:0;
 $actualAmount=$expenseArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overExpenseBudgetTotal[$productService->id][$month]=$overBudgetAmount;

@endphp
 <td class="expense_data {{$month}}_expense">{{\Auth::user()->priceFormat(!empty($budget['expense_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['expense_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($expenseArr[$productService->id][$month])}}
 {{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month]) !=0) ?'('.(\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month]).'%)') :'':''}}

</td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['expense_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}} ">{{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$overBudgetAmount)!=0) ? '('.(\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$overBudgetAmount)
 .'%)') :'':''}}
 </td>
 @endforeach
 @if(!empty($budgetExpenseTotal) )
 @php
 $overExpenseBudgetTotalArr = array();
 foreach($overExpenseBudgetTotal as $overExpenseBudget)
 {
 foreach($overExpenseBudget as $k => $value)
 {
 $overExpenseBudgetTotalArr[$k] = (isset($overExpenseBudgetTotalArr[$k]) ? $overExpenseBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp
 @endif

</tr>
 @endforeach

<tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>

@if(!empty($budgetExpenseTotal) )

@foreach($quarterly_monthlist as $month)

<td class="text-dark {{$month}}_total_expense">{{\Auth::user()->priceFormat($budgetExpenseTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($expenseTotalArr[$month])}}
 {{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overExpenseBudgetTotalArr[$month]) }}
 $overExpenseBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>

<tfoot>
 <tr class="total">
 <td class="text-dark">{{__('NET PROFIT :')}}</td>
 @if(!empty($overExpenseBudgetTotalArr) )

@php
                                        // NET PROFIT OF OVER BUDGET
                                         $overbudgetprofit = [];
                                         $keys   = array_keys($overBudgetTotalArr + $overExpenseBudgetTotalArr);
                                         foreach($keys as $v)
                                         {
                                             $overbudgetprofit[$v] = (empty($overBudgetTotalArr[$v]) ? 0 : $overBudgetTotalArr[$v]) - (empty($overExpenseBudgetTotalArr[$v]) ? 0 : $overExpenseBudgetTotalArr[$v]);
                                         }
                                         $data['overbudgetprofit']              = $overbudgetprofit;
                                    @endphp
                                @endif

@if(!empty($budgetprofit) )
 @foreach($quarterly_monthlist as $month)
 <td class="text-dark">{{\Auth::user()->priceFormat($budgetprofit[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($actualprofit[$month]) }}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overbudgetprofit[$month]) }}
 $overbudgetprofit[$month])? 'red-text':''}}">{{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month]).'%)') :'':''}}
 </td>
 @endforeach
 @endif

</tr>
 </tfoot>

</table>

@elseif($budget->period == 'half-yearly')
 <table class="table table-bordered table-item data">
 <thead>
 <tr>
 <td rowspan="2"></td>
 @foreach($half_yearly_monthlist as $month)
 <th colspan="3" scope="colgroup" class="text-center br-1px">{{$month}}</th>
 @endforeach
 </tr>
 <tr>
 @foreach($half_yearly_monthlist as $month)
 <th scope="col" class="br-1px">Budget</th>
 <th scope="col" class="br-1px">Actual</th>
 <th scope="col" class="br-1px">Over Budget</th>
 @endforeach
 </tr>
 </thead>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Income :')}}</th>
 </tr>

@php
                                $overBudgetTotal=[];
                            @endphp

@foreach ($incomeproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($half_yearly_monthlist as $month)
 @php
 $budgetAmount= ($budget['income_data'][$productService->id][$month])?$budget['income_data'][$productService->id][$month]:0;
 $actualAmount=$incomeArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overBudgetTotal[$productService->id][$month]=$overBudgetAmount;

@endphp

<td class="income_data {{$month}}_income">{{!empty (\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($incomeArr[$productService->id][$month])}}
 {{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month])!=0) ?'('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month]).'%)') :'':''}}

</td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['income_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}}">{{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$overBudgetAmount)!=0) ?'('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],
 $overBudgetAmount).'%)') :'':''}}

</td>
 @endforeach
 </tr>
 @endforeach
 @php
 $overBudgetTotalArr = array();
 foreach($overBudgetTotal as $overBudget)
 {
 foreach($overBudget as $k => $value)
 {
 $overBudgetTotalArr[$k] = (isset($overBudgetTotalArr[$k]) ? $overBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp

<tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @if(!empty($budgetTotal) )
 @foreach($half_yearly_monthlist as $month)

<td class="text-dark {{$month}}_total_income">{{\Auth::user()->priceFormat($budgetTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($incomeTotalArr[$month])}}
 {{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month]).'%)') :'':''}}
 </td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overBudgetTotalArr[$month]) }}
 $overBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Expense :')}}</th>
 </tr>

@php
                                $overExpenseBudgetTotal=[];
                            @endphp

@foreach ($expenseproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($half_yearly_monthlist as $month)
 @php
 $budgetAmount= ($budget['expense_data'][$productService->id][$month])?$budget['expense_data'][$productService->id][$month]:0;
 $actualAmount=$expenseArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overExpenseBudgetTotal[$productService->id][$month]=$overBudgetAmount;

@endphp
 <td class="expense_data {{$month}}_expense">{{\Auth::user()->priceFormat(!empty($budget['expense_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['expense_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($expenseArr[$productService->id][$month])}}
 {{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month])!=0) ?'('.(\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month]).'%)') :'':''}}

</td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['expense_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}}">{{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$overBudgetAmount)!=0)?'('.(\App\Models\Budget::percentage
 ($budget['expense_data'][$productService->id][$month],$overBudgetAmount).'%)') :'':''}}
 </td>
 @endforeach
 </tr>
 @endforeach
 @php
 $overExpenseBudgetTotalArr = array();
 foreach($overExpenseBudgetTotal as $overExpenseBudget)
 {
 foreach($overExpenseBudget as $k => $value)
 {
 $overExpenseBudgetTotalArr[$k] = (isset($overExpenseBudgetTotalArr[$k]) ? $overExpenseBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp

<tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @if(!empty($budgetExpenseTotal) )
 @foreach($half_yearly_monthlist as $month)

<td class="text-dark {{$month}}_total_expense">{{\Auth::user()->priceFormat($budgetExpenseTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($expenseTotalArr[$month])}}
 {{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overExpenseBudgetTotalArr[$month]) }}
 $overExpenseBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 @endif

</tr>
 <td></td>
 <tfoot>
 <tr class="total">
 <td class="text-dark">{{__('NET PROFIT :')}}</td>
 @php
 // NET PROFIT OF OVER BUDGET
 $overbudgetprofit = [];
 $keys = array_keys($overBudgetTotalArr + $overExpenseBudgetTotalArr);
 foreach($keys as $v)
 {
 $overbudgetprofit[$v] = (empty($overBudgetTotalArr[$v]) ? 0 : $overBudgetTotalArr[$v]) - (empty($overExpenseBudgetTotalArr[$v]) ? 0 : $overExpenseBudgetTotalArr[$v]);
 }
 $data['overbudgetprofit'] = $overbudgetprofit;
 @endphp
 @if(!empty($budgetprofit) )
 @foreach($half_yearly_monthlist as $month)
 <td class="text-dark">{{\Auth::user()->priceFormat($budgetprofit[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($actualprofit[$month]) }}
 {{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month]).'%)') :'':''}}
 </td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overbudgetprofit[$month]) }}
 $overbudgetprofit[$month])? 'red-text':''}}">{{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month]).'%)') :'':''}}
 </td>
 @endforeach
 @endif

</tr>
 </tfoot>
 </table>

{{-- Yearly Budget--}}
 @else
 <table class="table table-bordered table-item data">
 <thead>
 <tr>
 <td rowspan="2"></td> 
 @foreach($yearly_monthlist as $month)
 <th colspan="3" scope="colgroup" class="text-center br-1px">{{$month}}</th>
 @endforeach
 </tr>
 <tr>
 @foreach($yearly_monthlist as $month)
 <th scope="col" class="br-1px">Budget</th>
 <th scope="col" class="br-1px">Actual</th>
 <th scope="col" class="br-1px">Over Budget</th>
 @endforeach
 </tr>
 </thead>

<tr>
 <th colspan="37" class="text-dark light_blue">{{__('Income :')}}</th>
 </tr>

@php
                                $overBudgetTotal=[];
                            @endphp

@foreach ($incomeproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($yearly_monthlist as $month)
 @php
 $budgetAmount= ($budget['income_data'][$productService->id][$month])?$budget['income_data'][$productService->id][$month]:0;
 $actualAmount=$incomeArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overBudgetTotal[$productService->id][$month]=$overBudgetAmount;

@endphp

<td class="income_data {{$month}}_income">{{!empty (\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['income_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($incomeArr[$productService->id][$month])}}
 {{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month])!=0) ?'('.(\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$incomeArr[$productService->id][$month]).'%)') :'':''}}

</td>
 <td>{{\Auth::user()->priceFormat($overBudgetAmount)}}
 id][$month] < $overBudgetAmount)? 'green-text':''}} {{($budget['income_data'][$productService->id][$month] > $overBudgetAmount)? 'red-text':''}}">{{($budget['income_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['income_data'][$productService->id][$month],$overBudgetAmount)!=0) ?'('.(\App\Models\Budget::percentage
 ($budget['income_data'][$productService->id][$month],$overBudgetAmount).'%)') :'':''}}

</td>

@endforeach

</tr>
 @endforeach
 @php
 $overBudgetTotalArr = array();
 foreach($overBudgetTotal as $overBudget)
 {
 foreach($overBudget as $k => $value)
 {
 $overBudgetTotalArr[$k] = (isset($overBudgetTotalArr[$k]) ? $overBudgetTotalArr[$k] + $value : $value);
 }
 }
 @endphp

<tr class="total text-dark">
 <td class="">{{__('Total :')}}</td>
 @foreach($yearly_monthlist as $month)
 @php
 @endphp
 <td class="text-dark {{$month}}_total_income">{{\Auth::user()->priceFormat($budgetTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($incomeTotalArr[$month])}}
 {{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month])!=0)?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$incomeTotalArr[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overBudgetTotalArr[$month]) }}
 $overBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetTotal[$month],$overBudgetTotalArr[$month]).'%)') :'':''}}

</td>
 @endforeach
 </tr>

@foreach ($expenseproduct as $productService)
 <tr>
 <td class="text-dark">{{$productService->name}}</td>
 @foreach($yearly_monthlist as $month)
 @php
 $budgetAmount= ($budget['expense_data'][$productService->id][$month])?$budget['expense_data'][$productService->id][$month]:0;
 $actualAmount=$expenseArr[$productService->id][$month];
 $overBudgetAmount=$actualAmount-$budgetAmount;
 $overExpenseBudgetTotal[$productService->id][$month]=$overBudgetAmount;

@endphp
 <td class="expense_data {{$month}}_expense">{{\Auth::user()->priceFormat(!empty($budget['expense_data'][$productService->id][$month]))?\Auth::user()->priceFormat($budget['expense_data'][$productService->id][$month]):0}}</td>
 <td>{{\Auth::user()->priceFormat($expenseArr[$productService->id][$month])}}
 {{($budget['expense_data'][$productService->id][$month] !=0)? (\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month])!=0) ?'('.(\App\Models\Budget::percentage($budget['expense_data'][$productService->id][$month],$expenseArr[$productService->id][$month]).'%)') :'':''}}

<tr class="total">
 <td class="text-dark">{{__('Total :')}}</td>
 @foreach($yearly_monthlist as $month)
 @php
 @endphp
 <td class="text-dark {{$month}}_total_expense">{{\Auth::user()->priceFormat($budgetExpenseTotal[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($expenseTotalArr[$month])}}
 {{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$expenseTotalArr[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overExpenseBudgetTotalArr[$month]) }}
 $overExpenseBudgetTotalArr[$month])? 'red-text':''}}">{{($budgetExpenseTotal[$month] !=0)? (\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month])!=0) ? '('.(\App\Models\Budget::percentage($budgetExpenseTotal[$month],$overExpenseBudgetTotalArr[$month]).'%)') :'':''}}
 </td>
 @endforeach

@foreach($yearly_monthlist as $month)
 <td class="text-dark">{{\Auth::user()->priceFormat($budgetprofit[$month])}}</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($actualprofit[$month]) }}
 {{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetprofit[$month],$actualprofit[$month]).'%)') :'':''}}

</td>
 <td class="text-dark">{{\Auth::user()->priceFormat($overbudgetprofit[$month]) }}
 $overbudgetprofit[$month])? 'red-text':''}}">{{($budgetprofit[$month] !=0)? (\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month])!=0) ?'('.(\App\Models\Budget::percentage($budgetprofit[$month],$overbudgetprofit[$month]).'%)') :'':''}}
 </td>
 @endforeach

</tr>
 </tfoot>

</table>

@endif

</div>
 </div>
 </div>
 </div>

@endsection

<=Back