#acupoftea - frochicken.com

System	:	Linux ts5.whitelabelverse.com 5.14.0-570.23.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jun 24 11:27:16 EDT 2025 x86_64
Software	:	LiteSpeed
Server	:	103.163.247.115
Domains	:	Cant read /etc/named.conf
Permission	:	[ drwxr-xr-x ]
	:	/ home / ezzecare / app.logiq.digital / app / Livewire /

216.73.216.80

Home

File QuotesTable.php

<?php

/**
 * Invoice Ninja (https://invoiceninja.com).
 *
 * @link https://github.com/invoiceninja/invoiceninja source repository
 *
 * @copyright Copyright (c) 2025. Invoice Ninja LLC (https://invoiceninja.com)
 *
 * @license https://www.elastic.co/licensing/elastic-license
 */

namespace App\Livewire;

use App\Libraries\MultiDB;
use App\Models\Company;
use App\Models\Quote;
use Livewire\Component;
use Livewire\WithPagination;

class QuotesTable extends Component
{
    use WithPagination;

public int $per_page = 10;

public array $status = [];

public string $sort = 'status_id';

public bool $sort_asc = true;

public int $company_id;

public string $db;

public function mount()
    {
        MultiDB::setDb($this->db);
    }

public function sortBy($field)
    {
        $this->sort === $field
            ? $this->sort_asc = ! $this->sort_asc
            : $this->sort_asc = true;

$this->sort = $field;
    }

public function render()
    {
        $query = Quote::query()
            ->with('client.contacts', 'company')
            // ->orderBy($this->sort, $this->sort_asc ? 'asc' : 'desc');
            ->when($this->sort == 'number', function ($q){
                $q->orderByRaw("REGEXP_REPLACE(number,'[^0-9]+','')+0 " . ($this->sort_asc ? 'desc' : 'asc'));
            })
            ->when($this->sort != 'number', function ($q){
                $q->orderBy($this->sort, ($this->sort_asc ? 'desc' : 'asc'));
            });

if (count($this->status) > 0) {
            /* Special filter for expired*/
            if (in_array('-1', $this->status)) {
                $query->where(function ($query) {
                    $query->whereDate('due_date', '<=', now()->startOfDay())
                          ->whereNotNull('due_date')
                          ->where('status_id', '<>', Quote::STATUS_CONVERTED);
                });
            }

if (in_array('2', $this->status)) {
                $query->where(function ($query) {
                    $query->whereDate('due_date', '>=', now()->startOfDay())
                          ->orWhereNull('due_date');
                })->where('status_id', Quote::STATUS_SENT);
            }

if (in_array('3', $this->status)) {
                $query->whereIn('status_id', [Quote::STATUS_APPROVED, Quote::STATUS_CONVERTED]);
            }
        }

$query = $query
            ->where('company_id', auth()->guard('contact')->user()->company_id)
            ->where('client_id', auth()->guard('contact')->user()->client_id)
            ->where('is_deleted', 0)
            ->where('status_id', '<>', Quote::STATUS_DRAFT)
            ->withTrashed()
            ->paginate($this->per_page);

return render('components.livewire.quotes-table', [
            'quotes' => $query,
        ]);
    }
}

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
..	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
BillingPortal	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
Flow2	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
PaymentMethods	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
Profile	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
RecurringInvoices	DIR	-	drwxr-xr-x	2025-03-01 09:11:52
BillingPortalPurchase.php	text/x-php	17.35 KB	-rw-r--r--	2025-03-01 09:11:52
BillingPortalPurchasev2.php	text/x-php	23.14 KB	-rw-r--r--	2025-03-01 09:11:52
CreditsTable.php	text/x-php	1.78 KB	-rw-r--r--	2025-03-01 09:11:52
DocumentsTable.php	text/x-php	5.36 KB	-rw-r--r--	2025-03-01 09:11:52
InvoicesTable.php	text/x-php	3.01 KB	-rw-r--r--	2025-03-01 09:11:52
PayNowDropdown.php	text/x-php	778 B	-rw-r--r--	2025-03-01 09:11:52
PaymentMethodsTable.php	text/x-php	1.14 KB	-rw-r--r--	2025-03-01 09:11:52
PaymentsTable.php	text/x-php	1.79 KB	-rw-r--r--	2025-03-01 09:11:52
PdfSlot.php	text/x-php	11.7 KB	-rw-r--r--	2025-03-01 09:11:52
PurchaseOrdersTable.php	text/x-php	1.98 KB	-rw-r--r--	2025-03-01 09:11:52
QuotesTable.php	text/x-php	2.79 KB	-rw-r--r--	2025-03-01 09:11:52
RecurringInvoiceCancellation.php	text/x-php	1.07 KB	-rw-r--r--	2025-03-01 09:11:52
RecurringInvoicesTable.php	text/x-php	1.48 KB	-rw-r--r--	2025-03-01 09:11:52
RequiredClientInfo.php	text/x-php	14.85 KB	-rw-r--r--	2025-03-01 09:11:52
SubscriptionPlanSwitch.php	text/x-php	5.2 KB	-rw-r--r--	2025-03-01 09:11:52
SubscriptionRecurringInvoicesTable.php	text/x-php	1.33 KB	-rw-r--r--	2025-03-01 09:11:52
SubscriptionsTable.php	text/x-php	1.34 KB	-rw-r--r--	2025-03-01 09:11:52
TasksTable.php	text/x-php	1.64 KB	-rw-r--r--	2025-03-01 09:11:52

~ ACUPOFTEA - frochicken.com