File Manager

X7ROOT File Manager

Current Path: /home/gfecatvj/sites/realesbar-X/app

home / gfecatvj / sites / realesbar-X / app /

📁 ..
📄 Agency.php(102 B)
📄 Agent.php(101 B)
📄 Article.php(306 B)
📄 Blogger.php(103 B)
📁 Console
📁 Exceptions
📄 Feedback.php(104 B)
📁 Http
📁 Mail
📄 Message.php(103 B)
📄 Pcomment.php(104 B)
📄 Property.php(2.09 KB)
📁 Providers
📄 Role.php(221 B)
📄 User.php(1.02 KB)

Editing: Property.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use DB;

class property extends Model
{
    public function features()
    {
        return $this->belongsToMany(Feature::class)->withTimestamps();
    }

public function user()
    {
        return $this->belongsTo(User::class,'agent_id');
    }
    
    public function comments()
    {
        return $this->morphMany('App\Comment', 'commentable');
    }

public function rating()
    {
        return $this->hasMany(Rating::class, 'property_id');
    }
    
    public function property_list_by_status($status=array())
    {
        $query = DB::table('properties')
            ->select('id', 'status', 'agent_id', 'date_added', 'last_updated', 'aqu_option', 'title', 'price', 'price_postfix', 'bedrooms', 'bathrooms', 'year_built', 'garages', 'area', 'area_postfix', 'type', 'property_status', 'description', 'img', 'floor_plan', 'video_link', 'country', 'region', 'city', 'address', 'amenities');
        $query->whereIn('status',$status);
        /*if(!empty($category_id)){
            $query->where('product.category_id',$category_id);
        }
        $query->join('product_category', 'product.category_id', '=', 'product_category.category_id');
        $query->join('product_subcategory', 'product_subcategory.subcategory_id', '=', 'product.subcategory_id');
        $query->join('users','users.id','=','product.user_id');
        $query->join('user_details','user_details.user_id','=','users.id');*/
        $result = $query->get();
        return $result;
    }
    
     public function property_details_by_id($id)
    {
        $result = DB::table('properties')
            ->select('*', 'status', 'agent_id', 'date_added', 'last_updated', 'aqu_option', 'title', 'price', 'price_postfix', 'bedrooms', 'bathrooms', 'year_built', 'garages', 'area', 'area_postfix', 'type', 'property_status', 'description', 'img', 'floor_plan', 'video_link', 'country', 'region', 'city', 'address', 'amenities')
        ->where('id',$id)->get();
        if(count($result) > 0){
            return $result[0];
        }else{
            return $result;
        }
    }
}

X7ROOT File Manager

Editing: Property.php

Upload File

Create Folder