<?php

namespace App\ProjectLead;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class ProjectLeads extends Model
{

    use SoftDeletes;

    protected $table = 'project_leads';

    protected $fillable = ['firm', 'sector_id', 'address', 'state_id', 'city', 'pincode', 'description', 'source', 'status', 'lead_generated_by', 'user_id', 'contacts', 'action_date','deleted_by'];

    public function sector()
    {
        return $this->hasOne('App\MerchantCategory','id','sector_id');
    }

    public function user()
    {
        return $this->hasOne('App\User','id','user_id')->select('id','name','mobile_number','email');
    }

    public function leadStatus(){
        return $this->hasOne('App\ProjectLead\ProjectLeadStatus','id','status');
    }

    public function currentStatus(){
        return $this->hasOne('App\ProjectLead\ProjectLeadLogs','lead_id','id')->orderBy('created_at','desc');
    }

    public function leadMails(){
        return $this->hasMany('App\ProjectLead\ProjectLeadMails','lead_id','id')->orderBy('created_at','desc');
    }

    public function logs(){
        return $this->hasMany('App\ProjectLead\ProjectLeadLogs','lead_id','id');
    }

    public function calls(){
        return $this->hasMany('App\CallLogs','_id','id')->where('id_type','lead_id');
    }

    public function leadActions(){
        return $this->hasMany('App\ProjectLead\ProjectLeadActions','lead_id','id');
    }
}