<?php namespace App\Models;
 
use CodeIgniter\Model;

 
class Home_model extends Model{

    public function insertquery_data($data)
    {
        return $this->db->table('m_query')->insert($data);
    }
    public function insertstudentundertaking_data($data)
    {
        return $this->db->table('m_student_undertaking')->insert($data);
    }
    public function insertparentsundertaking_data($data)
    {
        return $this->db->table('m_parents_undertaking')->insert($data);
    }
    public function insertm_admission_leads($data)
    {
        return $this->db->table('m_admission_leads')->insert($data);
    }
    public function insert_hostel_application_main($data)
    {
        $this->db->table('m_hostel_application_main')->insert($data);
        return $this->db->insertID();
    }
    public function insert_hostel_application_additional($data)
    {
        return $this->db->table('m_hostel_application_additional')->insert($data);
    }
    public function insert_medical_cer_main($data)
    {
        $this->db->table('m_medical_exm_certificate_main')->insert($data);
        return $this->db->insertID();
    }
    public function insert_medical_cer_additional($data)
    {
        return $this->db->table('m_medical_exm_certificate_additional')->insert($data);
    }
    
    public function check_existing_record($email, $phone)
    {
        // Start a query builder instance
        $builder = $this->db->table('m_medical_exm_certificate_main');
        
        // Check if email or phone number exists
        $builder->where('email', $email);
        $builder->orWhere('phone', $phone);
        
        // Get the first result
        return $builder->get()->getRow();
    }
    public function check_existing_record_adm($email, $phone)
    {
        // Start a query builder instance
        $builder = $this->db->table('m_admission_form_main');
        
        // Check if email or phone number exists
        $builder->where('email', $email);
        $builder->orWhere('phone', $phone);
        
        // Get the first result
        return $builder->get()->getRow();
    }
    public function insert_admsn_form_main($data)
    {
        $this->db->table('m_admission_form_main')->insert($data);
        return $this->db->insertID();
    }
//     public function insert_admsn_form_additional($data)
//     {
//         return $this->db->table('m_admission_form_additional')->insert($data);
//     }


public function insert_admsn_form_additional($education_data)
{
    $builder = $this->db->table('admission_education');
    return $builder->insertBatch($education_data);
}
}