<?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;
    }
    
    
}