← All changes | app/Models/Agent.php +38 -0 1.10.2 → 2.4.0 View file →

		@@ -26,8 +26,26 @@
26	26	public function getSearchableFields(){
27	27	return $this->searchable;
28	28	}
29	29
	30	+ /**
	31	+ * Agent ids, resolved once per request. Reporting filters on this list
	32	+ * rather than whereHas('person', ...), which drove those queries off
	33	+ * fs_persons (no person_type index) and cost them their date range.
	34	+ *
	35	+ * @return array
	36	+ */
	37	+ public static function getAgentIds()
	38	+ {
	39	+ static $agentIds = null;
	40	+
	41	+ if (is_null($agentIds)) {
	42	+ $agentIds = array_map('intval', static::query()->pluck('id')->all());
	43	+ }
	44	+
	45	+ return $agentIds;
	46	+ }
	47	+
30	48	public static function boot()
31	49	{
32	50	parent::boot();
33	51
		@@ -54,7 +72,27 @@
54	72
55	73	return $this->hasMany(
56	74	$class, $foreign_key, 'id'
57	75	);
	76	+ }
	77	+
	78	+ public function groups()
	79	+ {
	80	+ return $this->belongsToMany(
	81	+ AgentGroup::class, 'fs_tag_pivot', 'source_id', 'tag_id'
	82	+ )->wherePivot('source_type', 'agent_group');
	83	+ }
	84	+
	85	+ public function scopeMentionBy($query, $search)
	86	+ {
	87	+ if (!$search) {
	88	+ return $query;
	89	+ }
	90	+
	91	+ return $query->where(function ($q) use ($search) {
	92	+ $q->where('first_name', 'LIKE', '%' . $search . '%')
	93	+ ->orWhere('last_name', 'LIKE', '%' . $search . '%')
	94	+ ->orWhere('email', 'LIKE', '%' . $search . '%');
	95	+ });
58	96	}
59	97
60	98	}