@php
$sources= App\Models\ProjectSource::where('IsActive',1)->get();
@endphp
{{--
@php
$report_start= date('Y-m-1',strtotime($month));
$report_end= date('Y-m-t',strtotime($month));
$agency_gw_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',1)->count();
$agency_gw_reports=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',1)->latest()->get();
@endphp
@if($agency_gw_report_count>0)
@foreach ($agency_gw_reports as $report)
@php
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-GW\\Agency\\'.$report->image;
$image='';
if (file_exists($path)) {
$image = file_get_contents($path);
$image = base64_encode($image);
}
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif
@php
$freelance_gw_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',1)->count();
$freelance_gw_report=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',1)->latest()->get();
@endphp
@if($freelance_gw_report_count>0)
@foreach ($freelance_gw_report as $report)
@php
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-GW\\Freelancer\\'.$report->image;
$image='';
if (file_exists($path)) {
$image = file_get_contents($path);
$image = base64_encode($image);
}
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif
@php
$agency_tsw_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',2)->count();
$agency_tsw_report=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',2)->latest()->get();
@endphp
@if($agency_tsw_report_count>0)
@foreach ($agency_tsw_report as $report)
@php
$account_type=$report->account==1?'-GW':'-TSW';
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-TSW\\Agency\\'.$report->image;
$image='';
if (file_exists($path)) {
echo "pass";
$image = file_get_contents($path);
$image = base64_encode($image);
}
dd('reasd');
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif
@php
$freelance_tsw_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',2)->count();
$freelance_tsw_report=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',2)->latest()->get();
@endphp
@if($freelance_tsw_report_count>0)
@foreach ($freelance_tsw_report as $report)
@php
$account_type=$report->account==1?'-GW':'-TSW';
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-TSW\\Freelancer\\'.$report->image;
$image='';
if (file_exists($path)) {
$image = file_get_contents($path);
$image = base64_encode($image);
}
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif
@php
$report_start= date('Y-m-1',strtotime($month));
$report_end= date('Y-m-t',strtotime($month));
$agency_js_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',3)->count();
$agency_js_reports=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',2)->where('account',3)->latest()->get();
@endphp
@if($agency_js_report_count>0)
@foreach ($agency_js_reports as $report)
@php
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-JS\\Agency\\'.$report->image;
$image='';
if (file_exists($path)) {
$image = file_get_contents($path);
$image = base64_encode($image);
}
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif
@php
$freelance_js_report_count=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',3)->count();
$freelance_js_report=App\Models\SalesReport::whereDate('Date','>=',$report_start)->whereDate('Date','<=',$report_end)->where('type',1)->where('account',3)->latest()->get();
@endphp
@if($freelance_js_report_count>0)
@foreach ($freelance_js_report as $report)
@php
$path= get_path().'SalesReportData\\'.date('Y-m-d',strtotime($report->Date)).'-JS\\Freelancer\\'.$report->image;
$image='';
if (file_exists($path)) {
$image = file_get_contents($path);
$image = base64_encode($image);
}
@endphp
| Work in progress |
${{$report->wip}} |
| In review (work completed and invoice submitted) |
${{$report->inReview}} |
| Pending (payment cleared but in pending review) |
${{$report->pending}} |
| Cleared (cash account) |
${{$report->cleared}} |
| Withdrawn (from cash account) |
${{$report->withdrawn}} |
@endforeach
@endif