��Root Mod By V1rus

Viewing: Table.php

<?php

namespace App\Livewire\Admin\Pages\Table\Order;

use Livewire\Component;
use Livewire\WithPagination;  
use Masmerise\Toaster\Toaster;
use Illuminate\Http\Request;
use App\Models\UserServices; 
use App\Models\Order; 
use App\Models\User; 
use App\Models\OrderStatus; 
use App\Models\ServiceStatus; 
use Illuminate\Support\Facades\Auth;

class Table extends Component
{
    use WithPagination; 
    protected $listeners = ['filterSearch' => 'filterDate', 'refreshOrder' => '$refresh'];
    public $order_number;
    public $mode='cutunix';
    public $user_id;
    public $start;
    public $end;
    public $search;
    public  $services_status=[];
    public  $order_status=[];
    public  $order_type;
    public  $services_status_val;
    public  $order_status_val;

    public function filterDate($date,Request $request){
        if(isset($date[0])){
            $this->start=$date[0];
        }
        if(isset($date[1])){
            $this->end=$date[1];   
        } 
        $this->dispatch('refreshTable'); 
    } 
    public function mount()
    { 
        $this->order_status=OrderStatus::orderBy('sort','asc')->get();
        $this->services_status=ServiceStatus::orderBy('sort','asc')->get(); 
    }
    public function render()
    {
        $result=Order::  
        when($this->user_id,function($q){
            $q->where('orders.user_id',$this->user_id);
        })  
        ->when($this->mode,function($q){
            $q->where('mode', $this->mode);
        }) 
        ->when($this->order_number,function($q){
            $q->where('orders.number', 'like', '%'.$this->order_number.'%');
        }) 
        ->when($this->search,function($q){
            $value = $this->search;
            if($value){ 
                if($this->user_id){
                    if(auth()->user()->can( 'admin') || auth()->user()->can( 'secretary')){
                        $check=UserServices::
                        where(function($q) use ($value){ 
                           $q->where('user_services.first_name', 'like', '%'.$value.'%')
                           ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                           ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                       })
                       ->pluck('id');
                    }else{ 
                        $check=UserServices::
                        where(function($q) use ($value){ 
                           $q->where('user_services.first_name', 'like', '%'.$value.'%')
                           ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                           ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                       })
                       ->where('user_services.user_id',$this->user_id)->pluck('id');
                    }
                }else{ 
                    if(!auth()->user()->can('secretary') && !auth()->user()->can('admin') && !auth()->user()->can('manager_order') ){
                        $check=UserServices:: 
                        where(function($q) use ($value){ 
                            $q->where('user_services.first_name', 'like', '%'.$value.'%')
                            ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                            ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                        })
                        ->pluck('id');
                    }elseif(auth()->user()->can( 'admin')){ 
                        $check=UserServices:: 
                        where(function($q) use ($value){ 
                            $q->where('user_services.first_name', 'like', '%'.$value.'%')
                            ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                            ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                        }) ->pluck('id');
                    }elseif(auth()->user()->can( 'services')){ 
                        $check=UserServices:: 
                        where(function($q) use ($value){ 
                            $q->where('user_services.first_name', 'like', '%'.$value.'%')
                            ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                            ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                        })
                        ->where('user_services.services_id',auth()->user()->id)->pluck('id');
                    }else{
                        $check=UserServices:: 
                        where(function($q) use ($value){ 
                            $q->where('user_services.first_name', 'like', '%'.$value.'%')
                            ->orWhere('user_services.last_name', 'like', '%'.$value.'%')
                            ->orWhereRaw('CONCAT(first_name," ",last_name) LIKE \''.$value.'%\'');
                        })
                        ->where('user_services.services_id',auth()->user()->parent)->pluck('id');
                    }
                }
            }
            if($check){
                $q->whereIn('orders.customer_id',$check);
            }else{
                $q->where('orders.customer_id',0);
            }
        }) 
        ->when(auth()->user()->can( 'manager_order') ,function($q){
            $q->where('orders.services_id',auth()->user()->parent);
        })  
        ->when(!auth()->user()->can('admin') && !auth()->user()->can( 'secretary') && !auth()->user()->can( 'manager_order'),function($q){
            $q->where('orders.services_id',auth()->user()->id);
        }) 
        ->where('orders.status','send') 
        ->when($this->start,function($q){
            $q->where('orders.created_at', '>=', $this->start);
        })
        ->when($this->end,function($q){
            $q->where('orders.created_at', '<=', $this->end);
        })
        ->when($this->services_status_val && $this->services_status_val != '0',function($q){
            $q->where('orders.status_em_services', 'like', '%'.$this->services_status_val.'%');
        })   
        ->when($this->order_status_val && $this->order_status_val != '0',function($q){
            $q->where('orders.status_services', 'like', '%'.$this->order_status_val.'%');
        })   
        ->when($this->order_type && $this->order_type != '0',function($q){ 
            if ($this->order_type ==  '1') {
                $q->where('orders.type', 'chat');
            } elseif ($this->order_type  == 'empty') {
                $q->whereNull('orders.type');
            }
            
        })   
        ->orderBy('orders.id','desc')
        ->paginate(20);  
        return view('livewire.admin.pages.table.order.table',['result'=>$result]);
    }
}
User / IP	: 216.73.216.158
Host / Server	: 195.214.235.115 / npln.ir
System	: Linux damavand.pws-dns.net 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64
���Root Mod By V1rus_Alfa

Viewing: Table.php

��Root Mod By V1rus_Alfa
