61 lines
1.6 KiB
PHP
Executable File
61 lines
1.6 KiB
PHP
Executable File
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Model;
|
|
|
|
class LevelContactModel extends Model
|
|
{
|
|
protected $table = 'level_contacts';
|
|
protected $primaryKey = 'id';
|
|
protected $allowedFields = [
|
|
"id",
|
|
"ref_id",
|
|
"contact_type",
|
|
"level",
|
|
"name",
|
|
"email",
|
|
"city",
|
|
"mobile",
|
|
"designation",
|
|
"created_by",
|
|
"updated_by",
|
|
"otp",
|
|
"is_active",
|
|
"token_time_out"
|
|
];
|
|
|
|
|
|
public function getContactForRFQ($insurer_id = null, $insurer_branch_id = null)
|
|
{
|
|
$query =
|
|
$this->db->table('level_contacts')
|
|
->select('
|
|
level_contacts.id,
|
|
insurers.short_name as insurer_name,
|
|
insurer_branch.branch_code,
|
|
level_contacts.name as contact_person_name,
|
|
level_contacts.email as contact_person_email
|
|
')
|
|
->join('insurer_branch', 'level_contacts.ref_id = insurer_branch.id')
|
|
->join('insurers', 'insurer_branch.insurer_id = insurers.id')
|
|
->where('level_contacts.contact_type', 'insurer')
|
|
->where('level_contacts.is_active', 1)
|
|
->where('insurer_branch.is_active', 1)
|
|
->where('insurers.is_active', 1);
|
|
|
|
if ($insurer_branch_id) {
|
|
$query->where('insurer_branch.id', $insurer_branch_id);
|
|
}
|
|
if ($insurer_id) {
|
|
$query->where('insurer_branch.insurer_id', $insurer_id);
|
|
}
|
|
|
|
$result = $query->get()->getResultArray();
|
|
return $result;
|
|
}
|
|
|
|
|
|
|
|
}
|