# Subject Model
| DB Table Name | {wp_db_prefix}_fc_meta |
|---|---|
| Schema | Check Schema |
| Source File | fluent-crm/app/Models/Subject.php |
| Name Space | FluentCrm\App\Models |
| Class | FluentCrm\App\Models\Subject |
# Attributes
| Attribute | Data Type | Comment |
|---|---|---|
| id | Integer | |
| object_type | String | |
| object_id | Integer | |
| key | String | |
| value | Text | |
| created_at | Date Time | |
| updated_at | Date Time |
# Usage
Please check Model Basic for Common methods.
# Accessing Attributes
$subject = FluentCrm\App\Models\Subject::find(1);
$subject->id; // returns id
$subject->value; // returns subject value
.......
1
2
3
4
5
6
2
3
4
5
6
# Fillable Attributes
'object_type',
'object_id',
'key',
'value'
1
2
3
4
5
2
3
4
5
# Relations
This model has the following relationships that you can use
# campaign
Access the associated campaign of a model
- return
FluentCrm\App\Models\CampaignModel Collections
# Example:
// Accessing Campaign
$campaign = $subject->campaign;
// For Filtering by campaign relationship
// Get Subjects which has campaign title 'My First Campaign'
$subjects = FluentCrm\App\Models\Subject::whereHas('campaign', function($query) {
$query->where('title', 'My First Campaign');
})->get();
// Get Subjects which does not have campaign title 'My First Campaign'
$subjects = FluentCrm\App\Models\Subject::whereDoesntHave('campaign', function($query) {
$query->where('title', 'My First Campaign');
})->get();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# emails
Access the associated emails of a model
- return
FluentCrm\App\Models\CampaignEmailModel Collections
# Example:
// Accessing Campaign
$emails = $subject->emails;
// For Filtering by emails relationship
// Get Subjects which has emails email_subject 'Hello world'
$subjects = FluentCrm\App\Models\Subject::whereHas('emails', function($query) {
$query->where('email_subject', 'Hello world');
})->get();
// Get Subjects which does not have emails email_subject 'Hello world'
$subjects = FluentCrm\App\Models\Subject::whereDoesntHave('emails', function($query) {
$query->where('email_subject', 'Hello world');
})->get();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15