One Hat Cyber Team

Your IP: 216.73.216.23
Server IP: 178.33.27.10
Server: Linux cpanel.dev-unit.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Server Software: Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
PHP Version: 8.2.11
Buat File | Buat Folder
Dir : ~/home/id/crm.dev-unit.com/app/Http/Livewire/
View File Name : Tickets.php

<?php

namespace App\Http\Livewire;

use App\Models\Ticket;
use App\Models\TicketStatus;
use App\Repositories\TicketRepository;
use Illuminate\Contracts\Foundation\Application;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
use Illuminate\Contracts\View\Factory;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Str;

class Tickets extends SearchableComponent
{
    public $searchTickets = '';

    public $filterTicketByStatus = '';

    public $ticketPriorityFilter = '';

    public $customer;

    /**
     * @var string[]
     */
    protected $listeners = [
        'refresh' => '$refresh',
        'deleteTicket',
        'filterTicketByStatus',
        'filterTicketPriority',
    ];

    /**
     * @return string
     */
    public function model()
    {
        return Ticket::class;
    }

    /**
     * @return string[]
     */
    public function searchableFields()
    {
        return [
            'subject',
        ];
    }

    /**
     * @return Application|Factory
     */
    public function render()
    {
        $tickets = $this->searchTickets();
        $ticketRepo = app(TicketRepository::class);
        $statusCounts = $ticketRepo->getTicketStatusCounts();
        $customer = $this->customer;
        $ticketStatusArr = [];
        if (! empty($customer)) {
            $ticketStatusArr = TicketStatus::pluck('name', 'id');
        }

        return view('livewire.tickets', compact('tickets', 'statusCounts', 'customer', 'ticketStatusArr'));
    }

    /**
     * @return LengthAwarePaginator
     */
    public function searchTickets()
    {
        $this->setQuery($this->getQuery()->with('contact', 'user.media', 'ticketStatus', 'department', 'ticketPriority',
            'service', 'media'));

        $this->getQuery()->where(function (Builder $query) {
            $this->filterResults();
        });

        $this->getQuery()->when($this->filterTicketByStatus !== '', function (Builder $q) {
            $q->where('ticket_status_id', $this->filterTicketByStatus);
        });

        $this->getQuery()->when($this->ticketPriorityFilter !== '', function (Builder $query) {
            $query->where('priority_id', $this->ticketPriorityFilter);
        });

        $this->getQuery()->when($this->customer != null, function (Builder $query) {
            $query->whereHas('contact', function (Builder $q) {
                $q->where('customer_id', $this->customer);
            });
        });

        return $this->paginate();
    }

    /**
     * @return Builder
     */
    public function filterResults()
    {
        $searchableFields = $this->searchableFields();
        $search = $this->search;

        $this->getQuery()->when(! empty($search), function (Builder $q) use ($search, $searchableFields) {
            $this->getQuery()->where(function (Builder $q) use ($search, $searchableFields) {
                $searchString = '%'.$search.'%';
                foreach ($searchableFields as $field) {
                    if (Str::contains($field, '.')) {
                        $field = explode('.', $field);
                        $q->orWhereHas($field[0], function (Builder $query) use ($field, $searchString) {
                            $query->whereRaw("lower($field[1]) like ?", $searchString);
                        });
                    } else {
                        $q->orWhereRaw("lower($field) like ?", $searchString);
                    }
                }
            });
        });

        return $this->getQuery();
    }

    /**
     * @param $status
     */
    public function filterTicketByStatus($status)
    {
        $this->filterTicketByStatus = $status;
        $this->resetPage();
    }

    /**
     * @param $id
     */
    public function filterTicketPriority($id)
    {
        $this->ticketPriorityFilter = $id;
        $this->resetPage();
    }

    public function updatingSearch()
    {
        $this->resetPage();
    }
}