<?php

namespace App\Models;

use CodeIgniter\Model;

class Academic_model extends Model
{
    // <<<----moderen_lab---->>>
    public function getmodren_lab()
    {
        $query = $this->db->query("SELECT * FROM m_moderen_lab ");
        return $query->getResultArray();
    }
    public function getmodrenlabdata($modr_lab_id)
    {
        $query = $this->db->query("SELECT * FROM m_modrenlab_content WHERE modren_lab_id = $modr_lab_id");
        return $query->getResultArray();
    }
    public function getmodrenlabdata_info($modr_lab_id, $row_id)
    {
        $query = $this->db->query("SELECT * FROM m_modrenlab_content WHERE modren_lab_id = $modr_lab_id AND id =$row_id");
        return $query->getRowArray();
    }
    public function insertmodrenlab_section($modrenlab_data)
    {
        return $this->db->table('m_modrenlab_content')->insert($modrenlab_data);
    }
    public function updatemodrenlab_section($row_id, $modrenlab_id, $data)
    {
        return $this->db->table('m_modrenlab_content')
            ->where('id', $row_id)
            ->where('modren_lab_id', $modrenlab_id)
            ->update($data);
    }


    public function deletemodrenlab_section($id)
    {
        $sql = "DELETE FROM `m_modrenlab_content` WHERE `id` = ?";
        $this->db->query($sql, [$id]);
        return ($this->db->affectedRows() > 0);
    }




    // <<<----classroom---->>>

    public function getclassroom()
    {
        $query = $this->db->query("SELECT * FROM m_classroom");
        return $query->getResultArray();
    }

    public function updateclassroom_data($row_id, $data)
    {
        return $this->db->table('m_classroom')
            ->where('id', $row_id)

            ->update($data);
    }

    public function insertclassroom_data($claasroom_data)
    {
        return $this->db->table('m_classroom')->insert($claasroom_data);
    }

    public function deleteclassroom_data($id)
    {
        $sql = "DELETE FROM `m_classroom` WHERE `id` = ?";
        $this->db->query($sql, [$id]);
        return ($this->db->affectedRows() > 0);
    }

    // <<<----library---->>>

    public function getlibrary()
    {
        $query = $this->db->query("SELECT * FROM m_library");
        return $query->getResultArray();
    }

    public function updatelibrary_data($row_id, $data)
    {
        return $this->db->table('m_library')
            ->where('id', $row_id)

            ->update($data);
    }

    public function insertlibrary_data($claasroom_data)
    {
        return $this->db->table('m_library')->insert($claasroom_data);
    }

    public function deletelibrary_data($id)
    {
        $sql = "DELETE FROM `m_library` WHERE `id` = ?";
        $this->db->query($sql, [$id]);
        return ($this->db->affectedRows() > 0);
    }


    // <<<----why gmn---->>>

    public function getwhygmnDataById($id)
    {
        return $this->db->table('m_whygmn_content')
            ->where('whygmn_id', $id)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getwhygmnNameById($id)
    {
        return $this->db->table('m_whygmn')
            ->select('sections')
            ->where('id', $id)
            ->get()
            ->getRowArray();
    }
    public function getwhygmn()
    {
        $query = $this->db->query("SELECT * FROM m_whygmn WHERE status='1'");
        return $query->getResultArray();
    }
    public function getwhygmndata($whygmn_id)
    {
        $query = $this->db->query("SELECT * FROM `m_whygmn_content` WHERE whygmn_id = $whygmn_id");
        return $query->getResultArray();
    }
    public function getwhygmndata_info($whygmn_id, $row_id)
    {
        $query = $this->db->query("SELECT * FROM `m_whygmn_content` WHERE whygmn_id = $whygmn_id AND id =$row_id");
        return $query->getRowArray();
    }
    public function insertwhygmn_section($whygmn_data)
    {
        return $this->db->table('m_whygmn_content')->insert($whygmn_data);
    }
    public function updatewhygmn_section($row_id, $whygmn_id, $data)
    {
        return $this->db->table('m_whygmn_content')
            ->where('id', $row_id)
            ->where('whygmn_id', $whygmn_id)
            ->update($data);
    }


    public function deletewhygmn_section($id)
    {
        $sql = "DELETE FROM `m_whygmn_content` WHERE `id` = ?";
        $this->db->query($sql, [$id]);
        return ($this->db->affectedRows() > 0);
    }
    // <<<----why lifeatgmn---->>>

    public function getlifeatgmnDataById($id)
    {
        return $this->db->table('m_lifeatgmn_content')
            ->where('lifeatgmn_id', $id)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }

    public function getlifeatgmn()
    {
        $query = $this->db->query("SELECT * FROM m_lifeatgmn WHERE status='1'");
        return $query->getResultArray();
    }

    public function getlifeatgmndata($lifeatgmn_id)
    {
        $query = $this->db->query("SELECT * FROM `m_lifeatgmn_content` WHERE lifeatgmn_id = $lifeatgmn_id");
        return $query->getResultArray();
    }
    public function getlifeatgmndata_info($lifeatgmn_id, $row_id)
    {
        $query = $this->db->query("SELECT * FROM `m_lifeatgmn_content` WHERE lifeatgmn_id = $lifeatgmn_id AND id =$row_id");
        return $query->getRowArray();
    }
    public function insertlifeatgmn_section($lifeatgmn_data)
    {
        return $this->db->table('m_lifeatgmn_content')->insert($lifeatgmn_data);
    }
    public function updatelifeatgmn_section($row_id, $lifeatgmn_id, $data)
    {
        return $this->db->table('m_lifeatgmn_content')
            ->where('id', $row_id)
            ->where('lifeatgmn_id', $lifeatgmn_id)
            ->update($data);
    }


    public function deletelifeatgmn_section($id)
    {
        $sql = "DELETE FROM `m_lifeatgmn_content` WHERE `id` = ?";
        $this->db->query($sql, [$id]);
        return ($this->db->affectedRows() > 0);
    }

    // <<<----why lifeatgmn---->>>


    public function getcelebr_Data()
    {
        return $this->db->table('m_celebration')
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getcelebr()
    {
        return $this->db->table('m_celebration')->get()->getResultArray();
    }

    public function updatecelebr($gallery_id, $data)
    {
        return $this->db->table('m_celebration')
            ->where('id', $gallery_id)
            ->update($data);
    }
    public function insertcelebr($data)
    {
        return $this->db->table('m_celebration')->insert($data);
    }
    public function deletecelebr($gallery_id)
    {
        $sql = "DELETE FROM `m_celebration` WHERE `id` = ?";
        $this->db->query($sql, [$gallery_id]);
        return ($this->db->affectedRows() > 0);
    }

    // <<<----funtion to get data of all pages---->>>
    public function getnurfound_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 1)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getpreclin_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 2)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getmatechild_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 3)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }

    public function getmatenur_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 4)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getnutrin_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 5)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getcommhealth_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 6)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getavaid_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 7)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getcomlab_Data()
    {
        return $this->db->table('m_modrenlab_content')
            ->where('modren_lab_id', 8)
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getclassroom_Data()
    {
        return $this->db->table('m_classroom')
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }
    public function getlibrary_Data()
    {
        return $this->db->table('m_library')
            ->where('status', 1)
            ->get()
            ->getResultArray();
    }


    // <------contact info--->

    // <<<----classroom---->>>

    public function getcontactinfo()
    {
        $query = $this->db->query("SELECT * FROM m_contactinfo");
        return $query->getResultArray();
    }

    public function updatecontactinfo($row_id, $data)
    {
        return $this->db->table('m_contactinfo')
            ->where('id', $row_id)

            ->update($data);
    }
}