byp4a55 professor6T9

Linux world-400.fr.planethoster.net 4.18.0-425.13.1.lve.el7h.x86_64 #1 SMP Mon Feb 27 14:44:55 UTC 2023 x86_64
Apache
10.195.0.10

File Name : FinanceDashboard.php

<?php

namespace App\Traits;

use App\Models\DashboardWidget;
use App\Models\Estimate;
use App\Models\Expense;
use App\Models\Invoice;
use App\Models\Payment;
use App\Models\Proposal;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;

/**
 *
 */
trait FinanceDashboard
{
    use CurrencyExchange, ClientDashboard;

/**
     *
     * @return void
     */
    public function financeDashboard()
    {
        abort_403($this->viewFinanceDashboard !== 'all');

$this->startDate  = (request('startDate') != '') ? Carbon::createFromFormat($this->company->date_format, request('startDate')) : now($this->company->timezone)->startOfMonth();
        $this->endDate = (request('endDate') != '') ? Carbon::createFromFormat($this->company->date_format, request('endDate')) : now($this->company->timezone);
        $startDate = $this->startDate->toDateString();
        $endDate = $this->endDate->toDateString();

$this->widgets = DashboardWidget::where('dashboard_type', 'admin-finance-dashboard')->get();
        $this->activeWidgets = $this->widgets->filter(function ($value, $key) {
            return $value->status == '1';
        })->pluck('widget_name')->toArray();

// count of paid invoices
        $this->totalPaidInvoice = Invoice::where('status', 'paid')
            ->whereBetween(DB::raw('DATE(`issue_date`)'), [$startDate, $endDate])
            ->select('id')
            ->count();

$this->totalUnPaidInvoice = Invoice::where(function ($query) {
            return $query->where('status', 'unpaid')
                ->orWhere('status', 'partial');
        })
            ->whereBetween(DB::raw('DATE(`issue_date`)'), [$startDate, $endDate])
             ->select('id')
            ->count();

// Total Expense
        $expenses = Expense::whereBetween(DB::raw('DATE(expenses.`purchase_date`)'), [$startDate, $endDate])
            ->join('currencies', 'currencies.id', '=', 'expenses.currency_id')
            ->select(
                'expenses.id',
                'expenses.price',
                'currencies.currency_code',
                'currencies.is_cryptocurrency',
                'currencies.usd_price',
                'currencies.exchange_rate'
            )
            ->where('expenses.status', 'approved')
            ->get();

$totalExpenses = 0;

foreach ($expenses as $expense) {
            if (isset($expense->currency) && $expense->currency->currency_code != $this->company->currency->currency_code && $expense->exchange_rate != 0) {
                if ($expense->currency->is_cryptocurrency == 'yes') {
                    $usdTotal = ($expense->price * $expense->currency->usd_price);
                        $totalExpenses += floor($usdTotal / $expense->exchange_rate);

} else {
                    $totalExpenses += floor($expense->price / $expense->currency->exchange_rate);
                }
            } else {
                $totalExpenses += round($expense->price, 2);
            }
        }

$this->totalExpenses = $totalExpenses;

// Total Earning
        $paymentsModal = Payment::whereBetween(DB::raw('DATE(payments.`paid_on`)'), [$startDate, $endDate]);

$payments = clone $paymentsModal;

$payments = $payments->join('currencies', 'currencies.id', '=', 'payments.currency_id')
            ->where('payments.status', 'complete')
            ->select(
                DB::raw('sum(payments.amount) as total'),
                'currencies.currency_code',
                'currencies.is_cryptocurrency',
                'currencies.usd_price',
                'currencies.exchange_rate'
            )
            ->get();

$totalEarnings = 0;

foreach ($payments as $payment) {
            if (isset($payment->currency) && $payment->currency->currency_code != $this->company->currency->currency_code && $payment->exchange_rate != 0) {
                if ($payment->currency->is_cryptocurrency == 'yes') {
                    $usdTotal = ($payment->total * $payment->currency->usd_price);
                    $totalEarnings += floor($usdTotal / $payment->currency->exchange_rate);

} else {
                    $totalEarnings += floor($payment->total / $payment->currency->exchange_rate);
                }
            } else {
                $totalEarnings += round($payment->total, 2);
            }
        }

$this->totalEarnings = $totalEarnings;

// Total Pending amount
        $invoices = Invoice::whereBetween(DB::raw('DATE(invoices.`issue_date`)'), [$startDate, $endDate])
            ->join('currencies', 'currencies.id', '=', 'invoices.currency_id')
            ->where(function ($q) {
                $q->where('invoices.status', 'unpaid');
                $q->orWhere('invoices.status', 'partial');
            })
            ->select(
                'invoices.*',
                'currencies.currency_code',
                'currencies.is_cryptocurrency',
                'currencies.usd_price',
                'currencies.exchange_rate'
            )
            ->get();

$totalPendingAmount = 0;

foreach ($invoices as $invoice) {
            if ($invoice->currency->currency_code != $this->company->currency->currency_code && $invoice->currency->exchange_rate != 0) {
                if ($invoice->currency->is_cryptocurrency == 'yes') {
                    $usdTotal = ($invoice->due_amount * $invoice->currency->usd_price);
                    $totalPendingAmount += floor($usdTotal / $invoice->currency->exchange_rate);

} else {
                    $totalPendingAmount += floor($invoice->due_amount / $invoice->currency->exchange_rate);
                }
            }
            else {
                $totalPendingAmount += round($invoice->due_amount, 2);
            }
        }

$this->totalPendingAmount = $totalPendingAmount;
        $this->invoiceOverviewChartData = $this->invoiceOverviewChartData($startDate, $endDate);
        $this->estimateOverviewChartData = $this->estimateOverviewChartData($startDate, $endDate);
        $this->proposalOverviewChartData = $this->proposalOverviewChartData($startDate, $endDate);
        $this->clientEarningChart = $this->clientEarningChart($startDate, $endDate);
        $this->projectEarningChartData = $this->projectEarningChartData($startDate, $endDate);

$this->view = 'dashboard.ajax.finance';
    }

public function invoiceOverviewChartData($startDate, $endDate)
    {
        $data['values'] = [];
        $data['colors'] = [];

$allInvoice = Invoice::whereBetween(DB::raw('DATE(`issue_date`)'), [$startDate, $endDate])->get();

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return $value->status == 'draft';
        })->count();
        $data['colors'][] = '#1d82f5';

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return $value->send_status == 0;
        })->count();
        $data['colors'][] = '#4d4f5c';

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return $value->status == 'unpaid';
        })->count();
        $data['colors'][] = '#D30000';

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return ($value->status == 'unpaid' || $value->status == 'partial') && $value->due_date->lessThan(now());
        })->count();
        $data['colors'][] = '#99A5B5';

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return $value->status == 'partial';
        })->count();
        $data['colors'][] = '#FCBD01';

$data['values'][] = $allInvoice->filter(function ($value, $key) {
            return $value->status == 'paid';
        })->count();
        $data['colors'][] = '#2CB100';

$data['labels'] = [__('modules.dashboard.invoiceDraft'), __('modules.dashboard.invoiceNotSent'), __('modules.dashboard.invoiceUnpaid'), __('modules.dashboard.invoiceOverdue'), __('modules.dashboard.invoicePartiallyPaid'), __('modules.dashboard.invoicePaid')];

return $data;
    }

public function estimateOverviewChartData($startDate, $endDate)
    {
        $data['values'] = [];
        $data['colors'] = [];

$allEstimate = Estimate::whereBetween(DB::raw('DATE(`valid_till`)'), [$startDate, $endDate])->get();

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->status == 'draft';
        })->count();
        $data['colors'][] = '#1d82f5';

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->send_status == 0;
        })->count();
        $data['colors'][] = '#4d4f5c';

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->send_status == 1;
        })->count();
        $data['colors'][] = '#FCBD01';

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->status == 'declined';
        })->count();
        $data['colors'][] = '#99A5B5';

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->status == 'waiting' && $value->valid_till->lessThan(now());
        })->count();
        $data['colors'][] = '#D30000';

$data['values'][] = $allEstimate->filter(function ($value, $key) {
            return $value->status == 'accepted';
        })->count();
        $data['colors'][] = '#2CB100';

$data['labels'] = [__('modules.dashboard.estimateDraft'), __('modules.dashboard.estimateNotSent'), __('modules.dashboard.estimateSent'), __('modules.dashboard.estimateDeclined'), __('modules.dashboard.estimateExpired'), __('modules.dashboard.estimateAccepted')];

return $data;
    }

public function proposalOverviewChartData($startDate, $endDate)
    {
        $data['values'] = [];
        $data['colors'] = [];

$allProposal = Proposal::whereBetween(DB::raw('DATE(`created_at`)'), [$startDate, $endDate])->get();

$data['values'][] = $allProposal->filter(function ($value, $key) {
            return $value->status == 'waiting';
        })->count();
        $data['colors'][] = '#FCBD01';

$data['values'][] = $allProposal->filter(function ($value, $key) {
            return $value->status == 'declined';
        })->count();
        $data['colors'][] = '#D30000';

$data['values'][] = $allProposal->filter(function ($value, $key) {
            return $value->status = 'waiting' && $value->valid_till->lessThan(now());
        })->count();
        $data['colors'][] = '#99A5B5';

$data['values'][] = $allProposal->filter(function ($value, $key) {
            return $value->status == 'accepted';
        })->count();
        $data['colors'][] = '#2CB100';

$data['values'][] = $allProposal->filter(function ($value, $key) {
            return $value->invoice_convert == 1;
        })->count();
        $data['colors'][] = '#1d82f5';

$data['labels'] = [__('modules.dashboard.proposalWaiting'), __('modules.dashboard.proposalDeclined'), __('modules.dashboard.proposalExpired'), __('modules.dashboard.proposalAccepted'), __('modules.dashboard.proposalConverted')];

return $data;
    }

public function projectEarningChartData($startDate, $endDate)
    {
        // earnings By Projects
        $paymentsModal = Payment::whereBetween(DB::raw('DATE(payments.`paid_on`)'), [$startDate, $endDate]);
        $projects = clone $paymentsModal;
        $projects->join('currencies', 'currencies.id', '=', 'payments.currency_id')
            ->join('projects', 'projects.id', '=', 'payments.project_id')
            ->where('payments.status', 'complete')
            ->orderBy('payments.paid_on', 'ASC')
            ->select(
                'payments.amount as total',
                'currencies.currency_code',
                'currencies.is_cryptocurrency',
                'currencies.usd_price',
                'currencies.exchange_rate',
                'projects.project_name'
            );

$invoices = clone $paymentsModal;
        $invoices = $invoices->join('currencies', 'currencies.id', '=', 'payments.currency_id')
            ->join('invoices', 'invoices.id', '=', 'payments.invoice_id')
            ->join('projects', 'projects.id', '=', 'invoices.project_id')
            ->where('payments.status', 'complete')
            ->orderBy('payments.paid_on', 'ASC')
            ->select(
                'payments.amount as total',
                'currencies.currency_code',
                'currencies.is_cryptocurrency',
                'currencies.usd_price',
                'currencies.exchange_rate',
                'projects.project_name as project_name'
            )
            ->union($projects)->get();

$earningsByProjects = array();

foreach ($invoices as $invoice) {
            if (!array_key_exists($invoice->project_name, $earningsByProjects)) {
                $earningsByProjects[$invoice->project_name] = 0;
            }

if (isset($invoice->currency) && $invoice->currency->currency_code != $this->company->currency->currency_code && $invoice->currency->exchange_rate != 0) {
                if ($invoice->currency->is_cryptocurrency == 'yes') {
                    $usdTotal = ($invoice->total * $invoice->currency->usd_price);
                    $earningsByProjects[$invoice->project_name] = $earningsByProjects[$invoice->project_name] + floor($usdTotal / $invoice->currency->exchange_rate);

} else {
                    $earningsByProjects[$invoice->project_name] = $earningsByProjects[$invoice->project_name] + floor($invoice->total / $invoice->currency->exchange_rate);
                }
            } else {
                $earningsByProjects[$invoice->project_name] = $earningsByProjects[$invoice->project_name] + round($invoice->total, 2);
            }
        }

$data['labels'] = array_keys($earningsByProjects);
        $data['values'] = array_values($earningsByProjects);
        $data['colors'] = [$this->appTheme->header_color];
        $data['name'] = __('app.earnings');

return $data;
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	pluszzsu/pluszzsu	0755	2023-03-12 08:26:54
..	dir	-	pluszzsu/pluszzsu	0755	2023-03-25 09:25:58
SuperAdmin	dir	-	pluszzsu/pluszzsu	0755	2023-03-01 09:22:50
ClientDashboard.php	text/x-php	8.7 KB	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
ClientPanelDashboard.php	text/x-php	3.19 KB	pluszzsu/pluszzsu	0644	2023-03-03 12:41:22
CurrencyExchange.php	text/x-php	2.27 KB	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
CustomFieldsRequestTrait.php	text/x-php	1.69 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
CustomFieldsTrait.php	text/x-php	5.54 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
EmployeeDashboard.php	text/x-php	29.49 KB	pluszzsu/pluszzsu	0644	2023-03-12 08:26:54
FinanceDashboard.php	text/x-php	13.89 KB	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
GoogleOAuth.php	text/x-php	434 B	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
HRDashboard.php	text/x-php	12.43 KB	pluszzsu/pluszzsu	0644	2023-02-13 01:41:30
HasCompany.php	text/x-php	367 B	pluszzsu/pluszzsu	0644	2022-11-09 12:50:18
IconTrait.php	text/x-php	2.38 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
ImportExcel.php	text/x-php	3.09 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
MakeOrderInvoiceTrait.php	text/x-php	2.31 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
MakePaymentTrait.php	text/x-php	1.77 KB	pluszzsu/pluszzsu	0644	2022-11-28 08:16:02
ModuleVerify.php	text/x-php	5.06 KB	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
OverviewDashboard.php	text/x-php	10.06 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
PaymentGatewayTrait.php	text/x-php	5.19 KB	pluszzsu/pluszzsu	0644	2022-11-28 08:16:02
ProjectDashboard.php	text/x-php	3.3 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
ProjectProgress.php	text/x-php	1.14 KB	pluszzsu/pluszzsu	0644	2022-11-25 11:56:22
SocialAuthSettings.php	text/x-php	1.59 KB	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
TicketDashboard.php	text/x-php	4.83 KB	pluszzsu/pluszzsu	0644	2023-03-01 09:22:50
UnitTypeSaveTrait.php	text/x-php	594 B	pluszzsu/pluszzsu	0644	2023-03-12 08:26:54
UniversalSearchTrait.php	text/x-php	611 B	pluszzsu/pluszzsu	0644	2022-10-13 05:36:16
pusherConfigTrait.php	text/x-php	737 B	pluszzsu/pluszzsu	0644	2023-03-12 08:26:54

Team Anon Force

https://t.me/Professor6T9x