<?php

namespace App;

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

class Leads extends Model
{

    use SoftDeletes;

    protected $table = 'leads';

    protected $fillable = ['firm', 'sector_id', 'business', 'address', 'state_id', 'city', 'pincode', 'monthly_sales_value', 'monthly_sales_volume', '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\LeadStatus','id','status');
    }

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

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

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

    public function logs(){
        return $this->hasMany('App\LeadLogs','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\LeadActions','lead_id','id');
    }
}