��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\CategoryOrder; 
use App\Models\OrderStatus; 
use App\Models\ServiceStatus; 
use Illuminate\Support\Facades\Auth;
use Livewire\Attributes\Url;

class Table extends Component
{
    use WithPagination; 
    protected $listeners = ['filterSearch' => 'filterDate', 'refreshOrder' => '$refresh'];
    #[Url] 
    public $order_number; 
    #[Url] 
    public $user_id; 
    #[Url] 
    public $start; 
    #[Url] 
    public $end; 
    #[Url] 
    public  $design_status_val;
    #[Url] 
    public  $order_status_val;
    #[Url] 
    public  $designer_id;
    #[Url] 
    public $search;
    #[Url] 
    public $category_id;
    public  $design_status=[];
    public  $order_status=[];
    public  $designers=[];
 
    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'); 
        $this->dispatch('filterAdd'); 
    } 
    public function mount()
    { 
        $this->design_status=OrderStatus::orderby('performance_sort','asc')->where('performance_dashboard','true')->get();
        $this->order_status=OrderStatus::orderby('order_sort','asc')->where('order_dashboard','true')->get();
        $this->designers=User::where('roll','manager_designer')->get();
    }
    public function render()
    {
        $result=Order::  
        when($this->user_id,function($q){
            $q->where('orders.user_id',$this->user_id);
        }) 
        ->when($this->order_number,function($q){
            $q->where('orders.number', 'like', '%'.$this->order_number.'%');
            $this->dispatch('filterAdd'); 
        }) 
        ->when($this->search,function($q){
            $value = $this->search;
            if($value){ 
                if($this->user_id){
                    if(Auth::user()->roll == 'ADMIN' || Auth::user()->roll == '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()->roll != 'ADMIN' && Auth::user()->roll != 'secretary' && Auth::user()->roll != '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()->roll == '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);
            }
            $this->dispatch('filterAdd'); 
        }) 
        ->when(Auth::user()->roll == 'manager_order' ,function($q){
            $q->where('orders.services_id',Auth::user()->parent);
        })  
        ->when(Auth::user()->roll != 'ADMIN' && Auth::user()->roll != 'secretary' && Auth::user()->roll != '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);
            $this->dispatch('filterAdd'); 
        })
        ->when($this->end,function($q){
            $q->where('orders.created_at', '<=', $this->end);
            $this->dispatch('filterAdd'); 
        })
        ->when($this->design_status_val && $this->design_status_val != '0',function($q){
            $q->where('orders.status_em_services', 'like', '%'.$this->design_status_val.'%');
            $this->dispatch('filterAdd'); 
        })   
        ->when($this->order_status_val && $this->order_status_val != '0',function($q){
            $q->where('orders.status_services', 'like', '%'.$this->order_status_val.'%');
            $this->dispatch('filterAdd'); 
        })    
        ->when($this->category_id && $this->category_id != '0',function($q){
            $q->where('orders.category_id', $this->category_id );
            $this->dispatch('filterAdd'); 
        })   
        ->when($this->designer_id && $this->designer_id != '0',function($q){
            $q->where('orders.employe_id', $this->designer_id);
            $this->dispatch('filterAdd'); 
        })   
        ->orderBy('orders.id','desc')
        ->paginate(20);  
        $categories=CategoryOrder::orderBy('id','desc')->get();
        return view('livewire.admin.pages.table.order.table',['result'=>$result,'categories'=>$categories]);
    }
}
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
