One Hat Cyber Team

View File Name : Invoice.php

<?php

namespace App\Models;

use App\Repositories\InvoiceRepository;
use App\Traits\PopulateTenantID;
use Eloquent as Model;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use PDF;
use Stancl\Tenancy\Database\Concerns\BelongsToTenant;
use Storage;
use Str;

/**
 * Class Invoice
 *
 * @version February 24, 2020, 5:51 am UTC
 *
 * @property int $id
 * @property int $patient_id
 * @property Carbon $invoice_date
 * @property float $amount
 * @property bool $status
 * @property Carbon|null $created_at
 * @property Carbon|null $updated_at
 * @property-read Collection|InvoiceItem[] $invoiceItems
 * @property-read int|null $invoice_items_count
 * @property-read Patient $patient
 *
 * @method static Builder|Invoice newModelQuery()
 * @method static Builder|Invoice newQuery()
 * @method static Builder|Invoice query()
 * @method static Builder|Invoice whereAmount($value)
 * @method static Builder|Invoice whereCreatedAt($value)
 * @method static Builder|Invoice whereId($value)
 * @method static Builder|Invoice whereInvoiceDate($value)
 * @method static Builder|Invoice wherePatientId($value)
 * @method static Builder|Invoice whereStatus($value)
 * @method static Builder|Invoice whereUpdatedAt($value)
 *
 * @mixin Model
 *
 * @property-read mixed $status_label
 * @property float $discount
 *
 * @method static Builder|Invoice whereDiscount($value)
 *
 * @property string $invoice_id
 *
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Invoice whereInvoiceId($value)
 *
 * @property int $is_default
 *
 * @method static Builder|Invoice whereIsDefault($value)
 */
class Invoice extends Model
{
    use BelongsToTenant, PopulateTenantID;

    public const PENDING = 0;

    public const PAID = 1;

    public const STATUS_ALL = 2;

    public const STATUS_ARR = [
        self::STATUS_ALL => 'All',
        self::PENDING => 'Pending',
        self::PAID => 'Paid',
    ];

    public const FILTER_STATUS_ARR = [
        0 => 'Pending',
        1 => 'Paid',
        2 => 'All',
    ];

    /**
     * Validation rules
     *
     * @var array
     */
    public static $rules = [
        'patient_id' => 'required',
        'invoice_date' => 'required|date',
        'discount' => 'required|regex:/^\d+(\.\d{1,2})?$/',
    ];

    public static $messages = [
        'patient_id.required' => 'The patient field is required.',
        'invoice_date.required' => 'The invoice date field is required.',
    ];

    public $table = 'invoices';

    public $appends = ['status_label'];

    public $fillable = [
        'patient_id',
        'invoice_date',
        'invoice_id',
        'amount',
        'discount',
        'status',
    ];

    /**
     * Get the attributes that should be cast.
     *
     * @return array<string, string>
     */
    protected function casts(): array
    {
        return [
            'id' => 'integer',
            'patient_id' => 'integer',
            'invoice_date' => 'date',
            'amount' => 'double',
            'discount' => 'double',
            'status' => 'boolean',
        ];
    }

    public function getStatusLabelAttribute()
    {
        return self::STATUS_ARR[$this->status];
    }

    public function patient(): BelongsTo
    {
        return $this->belongsTo(Patient::class, 'patient_id');
    }

    public function invoiceItems(): HasMany
    {
        return $this->hasMany(InvoiceItem::class);
    }

    public static function generateUniqueInvoiceId(): string
    {
        $invoiceId = mb_strtoupper(Str::random(6));
        while (true) {
            $isExist = self::whereInvoiceId($invoiceId)->exists();
            if ($isExist) {
                self::generateUniqueInvoiceId();
            }
            break;
        }

        return $invoiceId;
    }

    public function prepareInvoiceItem()
    {
        $data = [];
        foreach ($this->invoiceItems as $invoice_item) {
            $data[] = [
                'id' => $invoice_item->id,
                'account_name' => $invoice_item->account->name,
                'description' => $invoice_item->description ?? __('messages.common.n/a'),
                'quantity' => $invoice_item->quantity,
                'price' => $invoice_item->price,
                'total' => $invoice_item->quantity * $invoice_item->price,
            ];
        }

        return $data;
    }

    public function prepareInvoice()
    {
        return [
            'id' => $this->id,
            'invoice_id' => $this->invoice_id ?? __('messages.common.n/a'),
            'invoice_date' => \Carbon\Carbon::parse($this->invoice_date)->format('d M, Y') ?? __('messages.common.n/a'),
            'amount' => $this->discount ? number_format($this->amount - ($this->amount * $this->discount / 100), 2) : number_format($this->amount, 2),
            'status' => $this->status ?? __('messages.common.n/a'),
            'currency' => getAPICurrencySymbol() ?? __('messages.common.n/a'),
        ];
    }

    public function prepareInvoiceDetails()
    {
        return [
            'id' => $this->id,
            'invoice_id' => $this->invoice_id ?? __('messages.common.n/a'),
            'invoice_date' => \Carbon\Carbon::parse($this->invoice_date)->format('d M, Y') ?? __('messages.common.n/a'),
            'patient_name' => $this->patient->patientUser->full_name ?? __('messages.common.n/a'),
            'issued_by' => getAppName() ?? __('messages.common.n/a'),
            'hospital_address' => Setting::where('key', '=', 'hospital_address')->first()->value ?? __('messages.common.n/a'),
            'address' => $this->patient->address ? $this->patient->address->address1.','.$this->patient->address->address2 : __('messages.common.n/a'),
            'city' => $this->patient->address->city ?? __('messages.common.n/a'),
            'zip' => $this->patient->address->zip ?? __('messages.common.n/a'),
            'currencySymbol' => getAPICurrencySymbol() ?? __('messages.common.n/a'),
            'invoice_download' => $this->convertToPdf($this->id),
            'invoice_items' => $this->prepareInvoiceItem(),
            'sub_total' => number_format($this->amount, 2) ?? __('messages.common.n/a'),
            'discount' => $this->discount ? number_format(($this->amount * $this->discount / 100), 2) : number_format(0, 2),
            'total_amount' => $this->discount ? number_format($this->amount - ($this->amount * $this->discount / 100), 2) : number_format($this->amount, 2),
        ];
    }

    public function convertToPdf($id)
    {
        $invoice = Invoice::with(['invoiceItems', 'patient'])->find($id);
        $data = App()->make(InvoiceRepository::class)->getSyncListForCreateForPDF($id);
        $data['invoice'] = $invoice;
        $data['currencySymbol'] = getAPICurrencySymbol() ?? __('messages.common.n/a');
        if (Storage::disk(config('app.media_disc'))->exists('invoices/Invoice-'.$invoice->invoice_id.'.pdf')) {
            Storage::disk(config('app.media_disc'))->delete('invoices/Invoice-'.$invoice->invoice_id.'.pdf');
        }
        $pdf = PDF::loadView('invoices.invoice_pdf', $data);
        Storage::disk(config('app.media_disc'))->put('invoices/Invoice-'.$invoice->invoice_id.'.pdf', $pdf->output());
        $url = Storage::disk(config('app.media_disc'))->url('invoices/Invoice-'.$invoice->invoice_id.'.pdf');

        return $url ?? __('messages.common.n/a');
    }
}