Gecko [ fap.ae ]

Name	Size	Permission	Date
Category.php	480 B	-rwxrwxrwx	2024-09-20 09:00
Country.php	228 B	-rwxrwxrwx	2024-06-30 18:36
Link.php	2.13 KB	-rwxrwxrwx	2025-03-10 19:55
LinkAssign.php	295 B	-rwxrwxrwx	2024-09-18 17:58
LinkContent.php	601 B	-rwxrwxrwx	2024-11-02 07:56
LinkContentImage.php	543 B	-rwxrwxrwx	2024-09-17 11:18
LinkStatus.php	314 B	-rwxrwxrwx	2024-06-30 18:36
Order.php	1.54 KB	-rwxrwxrwx	2025-03-10 18:50
OrderStatus.php	299 B	-rwxrwxrwx	2024-09-17 16:05
Payment.php	1.43 KB	-rw-rw-r--	2025-03-10 18:53
PaymentDetail.php	724 B	-rw-rw-r--	2025-03-10 18:53
Service.php	356 B	-rw-rw-r--	2025-03-10 18:53
ServiceValue.php	381 B	-rw-rw-r--	2025-03-10 18:53
State.php	240 B	-rwxrwxrwx	2024-06-30 18:36
User.php	1.37 KB	-rwxrwxrwx	2024-11-01 16:02
UserCard.php	466 B	-rw-rw-r--	2025-03-10 18:54
UserDetail.php	663 B	-rwxrwxrwx	2024-10-28 18:27
current.php	22 B	-rw-r--r--	2026-04-01 01:39
error_log	8.43 KB	-rw-r--r--	2026-02-09 00:58

Rename

<?php

namespace App\Models;

use App\Models\Order;
use App\Models\Service;
use App\Models\Category;
use App\Models\LinkDetail;
use App\Models\LinkContent;
use App\Models\ServiceValue;
use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Factories\HasFactory;

class Link extends Model
{
    use HasFactory;

protected $table = 'links';

protected $fillable = [
        'order_id',
        'service_id',
        'service_value_id',
        'primary_category',
        'secondary_category',
        'anchor_text',
        'destination_url',
        'placement_url',
        'live_url',
        'live_da',
        'live_spam_score',
        'do_follow',
        'publish_date',
        'price',
        'status',
    ];

public function scopeFilter($query){
        if(request()->id){
            $query->where('id', request()->id);
        }
        if(request()->order_id){
            $query->where('order_id', request()->order_id);
        }
        if(request()->service){
            $query->whereHas('service', function($q){
                $q->where('name', request()->service);
            });
        }
        if(request()->serviceValue){
            $query->whereHas('serviceValue', function($q){
                $q->where('name', request()->serviceValue);
            });
        }
        if(request()->status){
            $query->where('status', request()->status);
        }
        if(request()->date){
            $query->where('created_at','>=',request()->date[0])
                  ->where('created_at','<=',request()->date[1]);
        }

return $query;
    }

public function order()
    {
        return $this->belongsTo(Order::class);
    }

public function service()
    {
        return $this->belongsTo(Service::class, 'service_id');
    }

public function serviceValue()
    {
        return $this->belongsTo(ServiceValue::class, 'service_value_id');
    }

public function category()
    {
        return $this->belongsTo(Category::class, 'primary_category');
    }

public function content()
    {
        return $this->hasOne(LinkContent::class, 'link_id');
    }
}