@php
// $in_progress_total=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Progress')->sum('ProjectAmount');
// $in_review_total=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Review')->sum('ProjectAmount');
$in_pending_total=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','Pending')->sum('ProjectAmount');
$available_total=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','Available')->sum('ProjectAmount');
// $in_progress_count=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Progress')->count();
// $in_review_count=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Review')->count();
$in_pending_count=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','Pending')->count();
$available_count=App\Models\Projects::whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','Available')->count();
// $gw_in_progresses=App\Models\Projects::where('SourceID',6)->whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Progress')->orderBy('ProjectID','desc')->get();
// $gw_in_reviews=App\Models\Projects::where('SourceID',6)->whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Review')->orderBy('ProjectID','desc')->get();
$gw_in_pendings = App\Models\Projects::where('SourceID', 6)
->whereDate('created_at', '>=', $start_date)
->whereDate('created_at', '<=', $end_date)
->whereDoesntHave('invoices', function ($query) {
$query->where('Is_Invoiced', 'Yes');
})
->orderBy('ProjectID', 'desc')
->with('invoices')
->get();
$gw_availables=App\Models\Projects::where('SourceID', 6)
->whereDate('created_at', '>=', $start_date)
->whereDate('created_at', '<=', $end_date)
->whereHas('invoice', function ($query) {
$query->where('Is_Invoiced', 'Yes');
})
->orderBy('ProjectID', 'desc')
->with('invoice')
->get();
// $tsw_in_progresses=App\Models\Projects::where('SourceID',5)->whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Progress')->orderBy('ProjectID','desc')->get();
// $tsw_in_reviews=App\Models\Projects::where('SourceID',5)->whereDate('created_at','>=',$start_date)->whereDate('created_at','<=',$end_date)->where('invoice','In Review')->orderBy('ProjectID','desc')->get();
$tsw_in_pendings=App\Models\Projects::where('SourceID', 5)
->whereDate('created_at', '>=', $start_date)
->whereDate('created_at', '<=', $end_date)
->whereDoesntHave('invoices', function ($query) {
$query->where('Is_Invoiced', 'Yes');
})
->orderBy('ProjectID', 'desc')
->with('invoices')
->get();
$tsw_availables=App\Models\Projects::where('SourceID', 5)
->whereDate('created_at', '>=', $start_date)
->whereDate('created_at', '<=', $end_date)
->whereHas('invoices', function ($query) {
$query->where('Is_Invoiced', 'Yes');
})
->orderBy('ProjectID', 'desc')
->with('invoices')
->get();
@endphp
{{--
| Project ID |
Project Title |
Project Upwork ID |
Amount |
@php
$total=0;
@endphp
@forelse($gw_in_progresses as $in_progress)
| {{$in_progress->ProjectID }} |
{{$in_progress->Title}} |
{{$in_progress->upwork_id}} |
${{$in_progress->ProjectAmount}} |
@php
$total=$total+$in_progress->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
Total |
${{$total}} |
| Project ID |
Project Title |
Project Upwork ID |
Amount |
@php
$total=0;
@endphp
@forelse($tsw_in_progresses as $in_progress)
| {{$in_progress->ProjectID }} |
{{$in_progress->Title}} |
{{$in_progress->upwork_id}} |
{{$in_progress->ProjectAmount}} |
@php
$total=$total+$in_progress->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
Total |
${{$total}} |
| Project ID |
Project Title |
Project Upwork ID |
Amount |
@php
$total=0;
@endphp
@forelse ($gw_in_reviews as $in_review)
| {{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
Total |
${{$total}} |
| Project ID |
Project Title |
Project Upwork ID |
Amount |
@php
$total=0;
@endphp
@forelse ($tsw_in_reviews as $in_review)
| {{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
Total |
${{$total}} |
--}}
| Project Date |
Project ID |
Project Title |
Project Upwork ID |
Is Invoiced |
Amount |
@php
$total=0;
@endphp
@forelse ($gw_in_pendings as $in_review)
| {{ \Carbon\Carbon::parse($in_review->ProjectEnteredDate)->format('Y-m-d') }} |
{{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->invoice->Is_Invoiced ?? 'Null' }} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
|
|
Total |
${{$total}} |
| Project Date |
Project ID |
Project Title |
Project Upwork ID |
Is Invoiced |
Amount |
@php
$total=0;
@endphp
@forelse ($tsw_in_pendings as $in_review)
| {{ \Carbon\Carbon::parse($in_review->ProjectEnteredDate)->format('Y-m-d') }} |
{{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->invoice->Is_Invoiced ?? 'Null' }} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
|
|
Total |
${{$total}} |
| Project Date |
Project ID |
Project Title |
Project Upwork ID |
Is Invoiced |
Amount |
@php
$total=0;
@endphp
@forelse ($gw_availables as $in_review)
| {{ \Carbon\Carbon::parse($in_review->ProjectEnteredDate)->format('Y-m-d') }} |
{{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->invoice->Is_Invoiced ?? 'Null' }} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
|
|
Total |
${{$total}} |
| Project Date |
Project ID |
Project Title |
Project Upwork ID |
Is Invoiced |
Amount |
@php
$total=0;
@endphp
@forelse ($tsw_availables as $in_review)
| {{ \Carbon\Carbon::parse($in_review->ProjectEnteredDate)->format('Y-m-d') }} |
{{$in_review->ProjectID }} |
{{$in_review->Title}} |
{{$in_review->upwork_id}} |
{{$in_review->invoice->Is_Invoiced ?? 'Null' }} |
{{$in_review->ProjectAmount}} |
@php
$total=$total+$in_review->ProjectAmount;
@endphp
@empty
@endforelse
| |
|
|
|
Total |
${{$total}} |