JFIF$        dd7 

Viewing File: /home/vanquishholdings/public_html/src/app/Services/Investment/MatrixInvestmentService.php

<?php

namespace App\Services\Investment;

use App\Actions\MatrixHandler;
use App\Enums\Matrix\InvestmentStatus;
use App\Enums\Transaction\Source;
use App\Enums\Transaction\Type;
use App\Enums\Transaction\WalletType;
use App\Models\MatrixInvestment;
use App\Models\Matrix;
use App\Models\User;
use App\Notifications\MatrixInvestmentNotification;
use App\Services\Payment\TransactionService;
use App\Services\Payment\WalletService;
use Carbon\Carbon;
use Carbon\CarbonPeriod;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Http\Request;
use Illuminate\Pagination\AbstractPaginator;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;

class MatrixInvestmentService
{
    public function __construct(
        protected TransactionService $transactionService,
        protected WalletService $walletService,
    )
    {

    }

    /**
     * @param Matrix $matrix
     * @param int $userId
     * @return array
     */
    public function prepParams(Matrix $matrix, int $userId): array
    {
        $level = [
            'matrix_levels' => array_map(fn($item) => [
                'level' => $item['level'],
                'amount' => getAmount($item['amount']),
            ], $matrix->matrixLevel->toArray()),
        ];

        return [
            'uid' => Str::random(),
            'user_id' => $userId,
            'plan_id' => $matrix->id,
            'name' => $matrix->name,
            'trx' => getTrx(),
            'price' => $matrix->amount,
            'referral_reward' => $matrix->referral_reward,
            'meta' => $level,
            'status' => InvestmentStatus::RUNNING->value,
        ];
    }

    /**
     * @param array $params
     * @return MatrixInvestment
     */
    public function save(array $params): MatrixInvestment
    {
        return MatrixInvestment::create($params);
    }

    /**
     * @param Request $request
     * @param Matrix $matrix
     * @param User $user
     * @return void
     */
    public function executeEnrolledScheme(Request $request, Matrix $matrix, User $user): void
    {
        DB::transaction(function () use ($request, $matrix, $user) {
            $matrixHandler = new MatrixHandler($user, $matrix);
            $matrixHandler->store();

            $invest = $this->save($this->prepParams($matrix, (int)$user->id));
            $invest->notify(new MatrixInvestmentNotification());

            $wallet = $user->wallet;
            $wallet->primary_balance -= $matrix->amount;
            $wallet->save();

            $this->transactionService->save($this->transactionService->prepParams([
                'user_id' => (int)$user->id,
                'amount' => $matrix->amount,
                'type' => Type::MINUS,
                'trx' => getTrx(),
                'details' => "Enrollment in the {$matrix->name} Matrix plan.",
                'wallet' => $this->walletService->findBalanceByWalletType(WalletType::PRIMARY->value, $wallet),
                'source' => Source::INVESTMENT->value
            ]));
        });
    }

    /**
     * @param int $userId
     * @return MatrixInvestment|null
     */
    public function findByUserId(int $userId): ?MatrixInvestment
    {
        return MatrixInvestment::where('user_id', $userId)->first();
    }

    /**
     * @return AbstractPaginator
     */
    public function getEnrolledByPaginate(): AbstractPaginator
    {
        return MatrixInvestment::filter(request()->all())
            ->with(['user'])
            ->paginate(getPaginate());
    }


    public function latestMatrix(array $with = [], int $limit = 5): Collection
    {
        return  MatrixInvestment::query()
            ->with($with)
            ->latest('id')
            ->take($limit)->get();
    }

    public function getMatrixReport(int|string $userId = null)
    {
        $now = now()->toDateString();
        $query = MatrixInvestment::query();

        if (!is_null($userId)) {
            $query->where('user_id', $userId);
        }

        return $query->selectRaw('
        COALESCE(SUM(price), 0) as total,
        COALESCE(SUM(CASE WHEN DATE(created_at) = ? THEN price ELSE 0 END), 0) as today,
        COALESCE(SUM(referral_commissions), 0) as referral,
        COALESCE(SUM(level_commissions), 0) as level,
        COALESCE(SUM(level_commissions + referral_commissions), 0) as commission
    ', [$now])->first();
    }

    /**
     * @return array
     */
    public function monthlyReport(): array
    {
        $report = [
            'months' => collect(),
            'invest_month_amount' => collect(),
        ];

        $startOfLast12Months = Carbon::now()->subMonths(11)->startOfMonth();

        $logs = MatrixInvestment::where('created_at', '>=', $startOfLast12Months)
            ->selectRaw("DATE_FORMAT(created_at, '%M-%Y') as months, SUM(price) as invest_amount")
            ->orderBy('months')
            ->groupBy('months')
            ->get();

        $last12Months = collect(CarbonPeriod::create($startOfLast12Months, '1 month', Carbon::now()->endOfMonth()))
            ->map(function ($date) {
                return $date->format('F-Y');
            });

        $last12Months->each(function ($month) use (&$report, $logs) {
            $logDataForMonth = $logs->firstWhere('months', $month);

            $report['months']->push($month);
            $report['invest_month_amount']->push(optional($logDataForMonth)->invest_amount ?? 0);
        });

        return [
            $report['months']->values()->all(),
            $report['invest_month_amount']->values()->all(),
        ];

    }



}
Back to Directory  nL+D550H?Mx ,D"v]qv;6*Zqn)ZP0!1 A "#a$2Qr D8 a Ri[f\mIykIw0cuFcRı?lO7к_f˓[C$殷WF<_W ԣsKcëIzyQy/_LKℂ;C",pFA:/]=H  ~,ls/9ć:[=/#f;)x{ٛEQ )~ =𘙲r*2~ a _V=' kumFD}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo(3=M(zȰ+i*NAr6KnSl)!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\͔]ޒS߼Jȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtfh9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N+0e2]]9VTPO׮7h(F*癈'=QVZDF,d߬~TX G[`le69CR(!S2!P <0x<!1AQ "Raq02Br#SCTb ?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ τV׸YTD I62'8Y27'\TP.6d&˦@Vqi|8-OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL u"TÙM=6(^"7r}=6YݾlCuhquympǦ GjhsǜNlɻ}o7#S6aw4!OSrD57%|?x>L |/nD6?/8w#[)L7+6〼T ATg!%5MmZ/c-{1_Je"|^$'O&ޱմTrb$w)R$& N1EtdU3Uȉ1pM"N*(DNyd96.(jQ)X 5cQɎMyW?Q*!R>6=7)Xj5`J]e8%t!+'!1Q5 !1 AQaqё#2"0BRb?Gt^## .llQT $v,,m㵜5ubV =sY+@d{N! dnO<.-B;_wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc.WDtA$j@:) -# u c1<@ۗ9F)KJ-hpP]_x[qBlbpʖw q"LFGdƶ*s+ډ_Zc"?%t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi`]uJVoVDG< SB6ϏQ@ TiUlyOU0kfV~~}SZ@*WUUi##; s/[=!7}"WN]'(L! ~y5g9T̅JkbM' +s:S +B)v@Mj e Cf jE 0Y\QnzG1д~Wo{T9?`Rmyhsy3!HAD]mc1~2LSu7xT;j$`}4->L#vzŏILS ֭T{rjGKC;bpU=-`BsK.SFw4Mq]ZdHS0)tLg