Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
Admin.php	608 B	-rw-r--r--	2023-07-25 13:22
Blog.php	518 B	-rw-r--r--	2023-07-25 13:22
CustomCss.php	267 B	-rw-r--r--	2023-07-25 23:21
DepositMethod.php	757 B	-rw-r--r--	2023-07-25 23:21
EmailTemplate.php	218 B	-rw-r--r--	2023-07-16 12:56
Gateway.php	444 B	-rw-r--r--	2023-07-25 23:21
Invest.php	1.45 KB	-rw-r--r--	2023-07-25 23:21
Kyc.php	208 B	-rw-r--r--	2023-07-16 12:56
LandingContent.php	219 B	-rw-r--r--	2023-07-31 14:10
LandingPage.php	216 B	-rw-r--r--	2023-07-16 12:56
Language.php	213 B	-rw-r--r--	2023-07-16 12:56
LevelReferral.php	231 B	-rw-r--r--	2023-07-25 13:22
LogActivity.php	337 B	-rw-r--r--	2023-07-25 13:22
LoginActivities.php	1.01 KB	-rw-r--r--	2023-07-25 23:21
Message.php	461 B	-rw-r--r--	2023-07-25 13:22
Navigation.php	597 B	-rw-r--r--	2023-07-31 00:09
Notification.php	308 B	-rw-r--r--	2023-07-25 13:22
Page.php	209 B	-rw-r--r--	2023-07-19 23:53
PageSetting.php	216 B	-rw-r--r--	2023-07-16 12:56
Plugin.php	211 B	-rw-r--r--	2023-07-16 12:56
PushNotificationTemplate.php	242 B	-rw-r--r--	2023-07-25 13:22
Ranking.php	212 B	-rw-r--r--	2023-07-16 12:56
Referral.php	439 B	-rw-r--r--	2023-07-16 12:56
ReferralLink.php	1.3 KB	-rw-r--r--	2023-07-25 23:21
ReferralProgram.php	250 B	-rw-r--r--	2023-07-16 12:56
ReferralRelationship.php	251 B	-rw-r--r--	2023-07-16 12:56
ReferralTarget.php	219 B	-rw-r--r--	2023-07-16 12:56
Schedule.php	213 B	-rw-r--r--	2023-07-16 12:56
ScheduledTask.php	195 B	-rw-r--r--	2023-07-25 23:21
Schema.php	928 B	-rw-r--r--	2023-07-31 01:08
SetTune.php	189 B	-rw-r--r--	2023-07-25 13:22
Setting.php	4.79 KB	-rw-r--r--	2023-07-25 23:21
SmsTemplate.php	334 B	-rw-r--r--	2023-07-25 13:22
Social.php	211 B	-rw-r--r--	2023-07-16 12:56
Subscription.php	385 B	-rw-r--r--	2023-07-16 12:56
Theme.php	427 B	-rw-r--r--	2023-07-25 13:22
Ticket.php	795 B	-rw-r--r--	2023-07-25 13:22
Transaction.php	3.9 KB	-rw-r--r--	2023-07-31 16:13
User.php	6.89 KB	-rw-r--r--	2023-07-31 00:09
WithdrawAccount.php	420 B	-rw-r--r--	2023-07-16 12:56
WithdrawMethod.php	394 B	-rw-r--r--	2023-07-25 13:22
WithdrawalSchedule.php	275 B	-rw-r--r--	2023-07-25 13:22

Rename

<?php

namespace App\Models;

use App\Enums\TxnStatus;
use App\Enums\TxnType;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Casts\Attribute;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Laravel\Scout\Searchable;

class Transaction extends Model
{
    use HasFactory, Searchable;

protected $guarded = ['id'];

protected $appends = ['day'];

protected $casts = [
        'type' => TxnType::class,
        'status' => TxnStatus::class,
        'pay_amount' => 'double',
        'amount' => 'double',
    ];

protected $searchable = [
        'amount',
        'tnx',
        'type',
        'method',
        'description',
        'status',
        'created_at',
    ];

public function toSearchableArray(): array
    {
        return [
            'amount' => $this->amount,
            'tnx' => $this->tnx,
            'type' => $this->type,
            'method' => $this->method,
            'description' => $this->description,
            'status' => $this->status,
        ];
    }

public function getCreatedAtAttribute(): string
    {
        return Carbon::parse($this->attributes['created_at'])->format('M d Y h:i');
    }

public function getDayAttribute(): string
    {
        return Carbon::parse($this->attributes['created_at'])->format('d M');
    }

public function scopeTnx($query, $tnx)
    {
        return $query->where('tnx', $tnx)->first();
    }

public function referral()
    {
        return $this->referrals()->where('type', '=', $this->target_type);
    }

public function referrals()
    {
        return $this->hasMany(Referral::class, 'referral_target_id', 'target_id')->where('type', '=', $this->target_type);
    }

public function target()
    {
        return $this->belongsTo(ReferralTarget::class, 'target_id');
    }

public function level()
    {
        return $this->belongsTo(LevelReferral::class, 'target_id', 'the_order');
    }

public function user()
    {
        return $this->belongsTo(User::class)->withDefault();
    }

public function invest()
    {
        return $this->hasOne(Invest::class, 'transaction_id');
    }

public function totalDeposit()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('type', TxnType::ManualDeposit)
                ->orWhere('type', TxnType::Deposit);
        });
    }

public function totalWithdraw()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('type', TxnType::Withdraw)
                ->orWhere('type', TxnType::WithdrawAuto);
        });
    }

public function totalInvestment()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('type', TxnType::Investment);
        });
    }

public function totalProfit()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('type', TxnType::Interest)
                ->orWhere('type', TxnType::Bonus)
                ->orWhere('type', TxnType::SignupBonus);
        });
    }

public function totalDepositBonus()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('target_id', '!=', null)
                ->where('target_type', 'deposit')
                ->where('type', TxnType::Referral);
        })->sum('amount');
    }

public function totalInvestBonus()
    {
        return $this->where('status', TxnStatus::Success)->where(function ($query) {
            $query->where('target_id', '!=', null)
                ->where('target_type', 'investment')
                ->where('type', TxnType::Referral);
        })->sum('amount');
    }

protected function method(): Attribute
    {
        return new Attribute(
            get: fn ($value) => ucwords($value),
        );
    }
}