EVOLUTION-MANAGER
Edit File: Enquiry.php
<?php namespace App; use Sofa\Eloquence\Eloquence; use Illuminate\Database\Eloquent\Model; class Enquiry extends Model { //Eloquence Search mapping use Eloquence; use createdByUser, updatedByUser; protected $table = 'mst_enquiries'; protected $fillable = [ 'name', 'DOB', 'email', 'address', 'status', 'gender', 'contact', 'pin_code', 'occupation', 'start_by', 'interested_in', 'aim', 'source', 'created_by', 'updated_by', ]; protected $searchableColumns = [ 'name' => 20, 'email' => 20, 'contact' => 20, ]; public function Followups() { return $this->hasMany('App\Followup'); } public function scopeIndexQuery($query, $sorting_field, $sorting_direction, $drp_start, $drp_end) { $sorting_field = ($sorting_field != null ? $sorting_field : 'created_at'); $sorting_direction = ($sorting_direction != null ? $sorting_direction : 'desc'); if ($drp_start == null or $drp_end == null) { return $query->select('id', 'name', 'contact', 'email', 'address', 'gender', 'created_at', 'status')->orderBy($sorting_field, $sorting_direction); } return $query->select('id', 'name', 'contact', 'email', 'address', 'gender', 'created_at', 'status')->whereBetween('created_at', [ $drp_start, $drp_end, ])->orderBy($sorting_field, $sorting_direction); } public function scopeOnlyLeads($query) { return $query->where('status', '=', \constEnquiryStatus::Lead)->orderBy('created_at', 'desc')->take(10); } }