RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / app / Models /
Filename : SPWallet.php
back
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * must be accessed and saved inside "SPWalletController" only.
 */
class SPWallet extends Model
{
    use SoftDeletes;

    protected $table = 'sp_wallet';

    protected $primaryKey = 'sp_wallet_id';

    /**
     * The attributes that are mass assignable.
     *
     * @var array
    */
    protected $fillable = [
        'user_id', 
        'wallet_name', 
        'wallet_uid',
        'created_at', 
        'updated_at', 
        'deleted_at'
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
    */
    protected $hidden = [
        'deleted_at'
    ];

    public function getEarnedSp(){
        return SPWalletTransaction::where('sp_wallet_id', $this->sp_wallet_id)
                ->whereNull('deleted_at')
                ->sum('sp_debit');
    }
}