Gecko [ ap.oishifashion.com ]

Name	Size	Permission	Date
Backup	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Charts	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Console	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Events	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Exceptions	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Exports	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Http	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Listeners	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Mail	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Notifications	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Providers	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Restaurant	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Rules	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Utils	[ DIR ]	drwxr-xr-x	2025-12-16 01:59
Account.php	3.89 KB	-rw-r--r--	2025-12-16 01:59
AccountTransaction.php	4.44 KB	-rw-r--r--	2025-12-16 01:59
AccountType.php	486 B	-rw-r--r--	2025-12-16 01:59
Barcode.php	221 B	-rw-r--r--	2025-12-16 01:59
Brands.php	1.01 KB	-rw-r--r--	2025-12-16 01:59
Business.php	2.78 KB	-rw-r--r--	2025-12-16 01:59
BusinessLocation.php	5.42 KB	-rw-r--r--	2025-12-16 01:59
CashDenomination.php	230 B	-rw-r--r--	2025-12-16 01:59
CashRegister.php	585 B	-rw-r--r--	2025-12-16 01:59
CashRegisterTransaction.php	237 B	-rw-r--r--	2025-12-16 01:59
Category.php	2.92 KB	-rw-r--r--	2025-12-16 01:59
Contact.php	12.51 KB	-rw-r--r--	2025-12-16 01:59
Currency.php	104 B	-rw-r--r--	2025-12-16 01:59
CustomerGroup.php	1016 B	-rw-r--r--	2025-12-16 01:59
DashboardConfiguration.php	111 B	-rw-r--r--	2025-12-16 01:59
Discount.php	483 B	-rw-r--r--	2025-12-16 01:59
DocumentAndNote.php	928 B	-rw-r--r--	2025-12-16 01:59
ExpenseCategory.php	811 B	-rw-r--r--	2025-12-16 01:59
GroupSubTax.php	213 B	-rw-r--r--	2025-12-16 01:59
InvoiceLayout.php	1.06 KB	-rw-r--r--	2025-12-16 01:59
InvoiceScheme.php	836 B	-rw-r--r--	2025-12-16 01:59
Media.php	6.31 KB	-rw-r--r--	2025-12-16 01:59
NotificationTemplate.php	17.09 KB	-rw-r--r--	2025-12-16 01:59
PaymentAccount.php	693 B	-rw-r--r--	2025-12-16 01:59
Printer.php	1.65 KB	-rw-r--r--	2025-12-16 01:59
Product.php	5.34 KB	-rw-r--r--	2025-12-16 01:59
ProductRack.php	225 B	-rw-r--r--	2025-12-16 01:59
ProductVariation.php	448 B	-rw-r--r--	2025-12-16 01:59
PurchaseLine.php	1.85 KB	-rw-r--r--	2025-12-16 01:59
ReferenceCount.php	228 B	-rw-r--r--	2025-12-16 01:59
SellingPriceGroup.php	1.58 KB	-rw-r--r--	2025-12-16 01:59
StockAdjustmentLine.php	474 B	-rw-r--r--	2025-12-16 01:59
System.php	2.33 KB	-rw-r--r--	2025-12-16 01:59
TaxRate.php	2.66 KB	-rw-r--r--	2025-12-16 01:59
Transaction.php	13.43 KB	-rw-r--r--	2025-12-16 01:59
TransactionPayment.php	3.16 KB	-rw-r--r--	2025-12-16 01:59
TransactionSellLine.php	2.61 KB	-rw-r--r--	2025-12-16 01:59
TransactionSellLinesPurchaseLines.php	375 B	-rw-r--r--	2025-12-16 01:59
TypesOfService.php	758 B	-rw-r--r--	2025-12-16 01:59
Unit.php	1.28 KB	-rw-r--r--	2025-12-16 01:59
User.php	8.89 KB	-rw-r--r--	2025-12-16 01:59
UserContactAccess.php	113 B	-rw-r--r--	2025-12-16 01:59
Variation.php	1.62 KB	-rw-r--r--	2025-12-16 01:59
VariationGroupPrice.php	819 B	-rw-r--r--	2025-12-16 01:59
VariationLocationDetails.php	238 B	-rw-r--r--	2025-12-16 01:59
VariationTemplate.php	401 B	-rw-r--r--	2025-12-16 01:59
VariationValueTemplate.php	419 B	-rw-r--r--	2025-12-16 01:59
Warranty.php	1.3 KB	-rw-r--r--	2025-12-16 01:59

Rename

<?php

namespace App;

use App\Utils\Util;
use DB;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Account extends Model
{
    use SoftDeletes;

protected $guarded = ['id'];

/**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'account_details' => 'array',
    ];

public static function forDropdown($business_id, $prepend_none, $closed = false, $show_balance = false)
    {
        $query = Account::where('business_id', $business_id);

$permitted_locations = auth()->user()->permitted_locations();
        $account_ids = [];
        if ($permitted_locations != 'all') {
            $locations = BusinessLocation::where('business_id', $business_id)
                            ->whereIn('id', $permitted_locations)
                            ->get();

foreach ($locations as $location) {
                if (! empty($location->default_payment_accounts)) {
                    $default_payment_accounts = json_decode($location->default_payment_accounts, true);
                    foreach ($default_payment_accounts as $key => $account) {
                        if (! empty($account['is_enabled']) && ! empty($account['account'])) {
                            $account_ids[] = $account['account'];
                        }
                    }
                }
            }

$account_ids = array_unique($account_ids);
        }

if ($permitted_locations != 'all') {
            $query->whereIn('accounts.id', $account_ids);
        }

$can_access_account = auth()->user()->can('account.access');
        if ($can_access_account && $show_balance) {
            // $query->leftjoin('account_transactions as AT', function ($join) {
            //     $join->on('AT.account_id', '=', 'accounts.id');
            //     $join->whereNull('AT.deleted_at');
            // })
            $query->select('accounts.name',
                    'accounts.id',
                    DB::raw("(SELECT SUM( IF(account_transactions.type='credit', amount, -1*amount) ) as balance from account_transactions where account_transactions.account_id = accounts.id AND deleted_at is NULL) as balance")
                );
        }

if (! $closed) {
            $query->where('is_closed', 0);
        }

$accounts = $query->get();

$dropdown = [];
        if ($prepend_none) {
            $dropdown[''] = __('lang_v1.none');
        }

$commonUtil = new Util;
        foreach ($accounts as $account) {
            $name = $account->name;

if ($can_access_account && $show_balance) {
                $name .= ' ('.__('lang_v1.balance').': '.$commonUtil->num_f($account->balance).')';
            }

$dropdown[$account->id] = $name;
        }

return $dropdown;
    }

/**
     * Scope a query to only include not closed accounts.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeNotClosed($query)
    {
        return $query->where('is_closed', 0);
    }

/**
     * Scope a query to only include non capital accounts.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    // public function scopeNotCapital($query)
    // {
    //     return $query->where(function ($q) {
    //         $q->where('account_type', '!=', 'capital');
    //         $q->orWhereNull('account_type');
    //     });
    // }

public static function accountTypes()
    {
        return [
            '' => __('account.not_applicable'),
            'saving_current' => __('account.saving_current'),
            'capital' => __('account.capital'),
        ];
    }

public function account_type()
    {
        return $this->belongsTo(\App\AccountType::class, 'account_type_id');
    }
}