Gecko [ ap.oishifashion.com ]

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

Rename

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Transaction extends Model
{
    //Transaction types = ['purchase','sell','expense','stock_adjustment','sell_transfer','purchase_transfer','opening_stock','sell_return','opening_balance','purchase_return', 'payroll', 'expense_refund', 'sales_order', 'purchase_order']

//Transaction status = ['received','pending','ordered','draft','final', 'in_transit', 'completed']

/**
     * The attributes that aren't mass assignable.
     *
     * @var array
     */
    protected $guarded = ['id'];

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

/**
     * The table associated with the model.
     *
     * @var string
     */
    protected $table = 'transactions';

public function purchase_lines()
    {
        return $this->hasMany(\App\PurchaseLine::class);
    }

public function sell_lines()
    {
        return $this->hasMany(\App\TransactionSellLine::class);
    }

public function contact()
    {
        return $this->belongsTo(\App\Contact::class, 'contact_id');
    }

public function delivery_person_user()
    {
        return $this->belongsTo(\App\User::class, 'delivery_person');
    }

public function payment_lines()
    {
        return $this->hasMany(\App\TransactionPayment::class, 'transaction_id');
    }

public function location()
    {
        return $this->belongsTo(\App\BusinessLocation::class, 'location_id');
    }

public function business()
    {
        return $this->belongsTo(\App\Business::class, 'business_id');
    }

public function tax()
    {
        return $this->belongsTo(\App\TaxRate::class, 'tax_id');
    }

public function stock_adjustment_lines()
    {
        return $this->hasMany(\App\StockAdjustmentLine::class);
    }

public function sales_person()
    {
        return $this->belongsTo(\App\User::class, 'created_by');
    }

public function sale_commission_agent()
    {
        return $this->belongsTo(\App\User::class, 'commission_agent');
    }

public function return_parent()
    {
        return $this->hasOne(\App\Transaction::class, 'return_parent_id');
    }

public function return_parent_sell()
    {
        return $this->belongsTo(\App\Transaction::class, 'return_parent_id');
    }

public function table()
    {
        return $this->belongsTo(\App\Restaurant\ResTable::class, 'res_table_id');
    }

public function service_staff()
    {
        return $this->belongsTo(\App\User::class, 'res_waiter_id');
    }

public function recurring_invoices()
    {
        return $this->hasMany(\App\Transaction::class, 'recur_parent_id');
    }

public function recurring_parent()
    {
        return $this->hasOne(\App\Transaction::class, 'id', 'recur_parent_id');
    }

public function price_group()
    {
        return $this->belongsTo(\App\SellingPriceGroup::class, 'selling_price_group_id');
    }

public function types_of_service()
    {
        return $this->belongsTo(\App\TypesOfService::class, 'types_of_service_id');
    }

/**
     * Retrieves documents path if exists
     */
    public function getDocumentPathAttribute()
    {
        $path = ! empty($this->document) ? asset('/uploads/documents/'.$this->document) : null;

return $path;
    }

/**
     * Removes timestamp from document name
     */
    public function getDocumentNameAttribute()
    {
        $document_name = ! empty(explode('_', $this->document, 2)[1]) ? explode('_', $this->document, 2)[1] : $this->document;

return $document_name;
    }

public function subscription_invoices()
    {
        return $this->hasMany(\App\Transaction::class, 'recur_parent_id');
    }

/**
     * Shipping address custom method
     */
    public function shipping_address($array = false)
    {
        $addresses = ! empty($this->order_addresses) ? json_decode($this->order_addresses, true) : [];

$shipping_address = [];

if (! empty($addresses['shipping_address'])) {
            if (! empty($addresses['shipping_address']['shipping_name'])) {
                $shipping_address['name'] = $addresses['shipping_address']['shipping_name'];
            }
            if (! empty($addresses['shipping_address']['company'])) {
                $shipping_address['company'] = $addresses['shipping_address']['company'];
            }
            if (! empty($addresses['shipping_address']['shipping_address_line_1'])) {
                $shipping_address['address_line_1'] = $addresses['shipping_address']['shipping_address_line_1'];
            }
            if (! empty($addresses['shipping_address']['shipping_address_line_2'])) {
                $shipping_address['address_line_2'] = $addresses['shipping_address']['shipping_address_line_2'];
            }
            if (! empty($addresses['shipping_address']['shipping_city'])) {
                $shipping_address['city'] = $addresses['shipping_address']['shipping_city'];
            }
            if (! empty($addresses['shipping_address']['shipping_state'])) {
                $shipping_address['state'] = $addresses['shipping_address']['shipping_state'];
            }
            if (! empty($addresses['shipping_address']['shipping_country'])) {
                $shipping_address['country'] = $addresses['shipping_address']['shipping_country'];
            }
            if (! empty($addresses['shipping_address']['shipping_zip_code'])) {
                $shipping_address['zipcode'] = $addresses['shipping_address']['shipping_zip_code'];
            }
        }

if ($array) {
            return $shipping_address;
        } else {
            return implode(', ', $shipping_address);
        }
    }

/**
     * billing address custom method
     */
    public function billing_address($array = false)
    {
        $addresses = ! empty($this->order_addresses) ? json_decode($this->order_addresses, true) : [];

$billing_address = [];

if (! empty($addresses['billing_address'])) {
            if (! empty($addresses['billing_address']['billing_name'])) {
                $billing_address['name'] = $addresses['billing_address']['billing_name'];
            }
            if (! empty($addresses['billing_address']['company'])) {
                $billing_address['company'] = $addresses['billing_address']['company'];
            }
            if (! empty($addresses['billing_address']['billing_address_line_1'])) {
                $billing_address['address_line_1'] = $addresses['billing_address']['billing_address_line_1'];
            }
            if (! empty($addresses['billing_address']['billing_address_line_2'])) {
                $billing_address['address_line_2'] = $addresses['billing_address']['billing_address_line_2'];
            }
            if (! empty($addresses['billing_address']['billing_city'])) {
                $billing_address['city'] = $addresses['billing_address']['billing_city'];
            }
            if (! empty($addresses['billing_address']['billing_state'])) {
                $billing_address['state'] = $addresses['billing_address']['billing_state'];
            }
            if (! empty($addresses['billing_address']['billing_country'])) {
                $billing_address['country'] = $addresses['billing_address']['billing_country'];
            }
            if (! empty($addresses['billing_address']['billing_zip_code'])) {
                $billing_address['zipcode'] = $addresses['billing_address']['billing_zip_code'];
            }
        }

if ($array) {
            return $billing_address;
        } else {
            return implode(', ', $billing_address);
        }
    }

public function cash_register_payments()
    {
        return $this->hasMany(\App\CashRegisterTransaction::class);
    }

public function media()
    {
        return $this->morphMany(\App\Media::class, 'model');
    }

public function transaction_for()
    {
        return $this->belongsTo(\App\User::class, 'expense_for');
    }

/**
     * Returns preferred account for payment.
     * Used in download pdfs
     */
    public function preferredAccount()
    {
        return $this->belongsTo(\App\Account::class, 'prefer_payment_account');
    }

/**
     * Returns the list of discount types.
     */
    public static function discountTypes()
    {
        return [
            'fixed' => __('lang_v1.fixed'),
            'percentage' => __('lang_v1.percentage'),
        ];
    }

public static function transactionTypes()
    {
        return  [
            'sell' => __('sale.sale'),
            'purchase' => __('lang_v1.purchase'),
            'sell_return' => __('lang_v1.sell_return'),
            'purchase_return' => __('lang_v1.purchase_return'),
            'opening_balance' => __('lang_v1.opening_balance'),
            'payment' => __('lang_v1.payment'),
            'ledger_discount' => __('lang_v1.ledger_discount'),
        ];
    }

public static function getPaymentStatus($transaction)
    {
        $payment_status = $transaction->payment_status;

if (in_array($payment_status, ['partial', 'due']) && ! empty($transaction->pay_term_number) && ! empty($transaction->pay_term_type)) {
            $transaction_date = \Carbon::parse($transaction->transaction_date);
            $due_date = $transaction->pay_term_type == 'days' ? $transaction_date->addDays($transaction->pay_term_number) : $transaction_date->addMonths($transaction->pay_term_number);
            $now = \Carbon::now();
            if ($now->gt($due_date)) {
                $payment_status = $payment_status == 'due' ? 'overdue' : 'partial-overdue';
            }
        }

return $payment_status;
    }

/**
     * Due date custom attribute
     */
    public function getDueDateAttribute()
    {
        $transaction_date = \Carbon::parse($this->transaction_date);
        if (! empty($this->pay_term_type) && ! empty($this->pay_term_number)) {
            $due_date = $this->pay_term_type == 'days' ? $transaction_date->addDays($this->pay_term_number) : $transaction_date->addMonths($this->pay_term_number);
        } else {
            $due_date = $transaction_date->addDays(0);
        }

return $due_date;
    }

public static function getSellStatuses()
    {
        return ['final' => __('sale.final'), 'draft' => __('sale.draft'), 'quotation' => __('lang_v1.quotation'), 'proforma' => __('lang_v1.proforma')];
    }

/**
     * Attributes to be logged for activity
     */
    public function getLogPropertiesAttribute()
    {
        $properties = [];

if (in_array($this->type, ['sell_transfer'])) {
            $properties = ['status'];
        } elseif (in_array($this->type, ['sell'])) {
            $properties = ['type', 'status', 'sub_status', 'shipping_status', 'payment_status', 'final_total'];
        } elseif (in_array($this->type, ['purchase'])) {
            $properties = ['type', 'status', 'payment_status', 'final_total'];
        } elseif (in_array($this->type, ['expense'])) {
            $properties = ['payment_status'];
        } elseif (in_array($this->type, ['sell_return'])) {
            $properties = ['type', 'payment_status', 'final_total'];
        } elseif (in_array($this->type, ['purchase_return'])) {
            $properties = ['type', 'payment_status', 'final_total'];
        }

return $properties;
    }

public function scopeOverDue($query)
    {
        return $query->whereIn('transactions.payment_status', ['due', 'partial'])
                    ->whereNotNull('transactions.pay_term_number')
                    ->whereNotNull('transactions.pay_term_type')
                    ->whereRaw("IF(transactions.pay_term_type='days', DATE_ADD(transactions.transaction_date, INTERVAL transactions.pay_term_number DAY) < CURDATE(), DATE_ADD(transactions.transaction_date, INTERVAL transactions.pay_term_number MONTH) < CURDATE())");
    }

public static function sell_statuses()
    {
        return [
            'final' => __('sale.final'),
            'draft' => __('sale.draft'),
            'quotation' => __('lang_v1.quotation'),
            'proforma' => __('lang_v1.proforma'),
        ];
    }

public static function sales_order_statuses($only_key_value = false)
    {
        if ($only_key_value) {
            return [
                'ordered' => __('lang_v1.ordered'),
                'partial' => __('lang_v1.partial'),
                'completed' => __('restaurant.completed'),
            ];
        }

return [
            'ordered' => [
                'label' => __('lang_v1.ordered'),
                'class' => 'bg-info',
            ],
            'partial' => [
                'label' => __('lang_v1.partial'),
                'class' => 'bg-yellow',
            ],
            'completed' => [
                'label' => __('restaurant.completed'),
                'class' => 'bg-green',
            ],
        ];
    }

public function salesOrders()
    {
        $sales_orders = null;
        if (! empty($this->sales_order_ids)) {
            $sales_orders = Transaction::where('business_id', $this->business_id)
                                ->where('type', 'sales_order')
                                ->whereIn('id', $this->sales_order_ids)
                                ->get();
        }

return $sales_orders;
    }

}