<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Mindustrial extends CI_Model {

    public function __construct() {
        parent::__construct();

    }

    public function get_active_districts() {
        // Fetch active districts where is_active = 1
        $this->db->select('*');
        $this->db->from('district_master');
        $this->db->where('is_active', 1);
        $query = $this->db->get();
        return $query->result_array();
    }

    public function submit_park($data) {
        // Insert data into the industrial park table
        return $this->db->insert('industrial_park_master', $data);
    }

    public function get_park_by_id($industrial_park_id) {
        // Fetch industrial park details by ID
        $this->db->where('industrial_park_id', $industrial_park_id);
        $query = $this->db->get('industrial_park_master');
        return $query->row_array();
    }

    public function update_park($industrial_park_id, $data) {
        // Update industrial park data in the database
        $this->db->where('industrial_park_id', $industrial_park_id);
        return $this->db->update('industrial_park_master', $data);

    }

     // Method to fetch all industrial parks
     public function get_all_parks() {
        // Initialize parks array
        $parks = array();

        // Fetch data from industrial park table
        $this->db->select('industrial_park_master.*, district_master.district_name');
        $this->db->from('industrial_park_master');
        $this->db->join('district_master', 'industrial_park_master.location_id = district_master.district_id', 'left');
        $this->db->order_by('industrial_park_master.industrial_park_id', 'DESC');
        $query = $this->db->get();

        // Check if query returned results
        if ($query->num_rows() > 0) {
            // Assign results to parks array
            $parks = $query->result_array();
        }

        // Return parks array
        return $parks;
    }

    public function search_industrial_parks($search_keyword = '', $status = 'all') {
        // Start building the query
        $this->db->select('industrial_park_master.*, district_master.district_name');
        $this->db->from('industrial_park_master');
        $this->db->join('district_master', 'industrial_park_master.location_id = district_master.district_id', 'left');

        // Apply search keyword filter if provided
        if (!empty($search_keyword)) {
            $this->db->like('industrial_park_master.park_name', $search_keyword);
        }
        
        // Apply status filter if provided
        if ($status != 'all') {
            $status_value = ($status == 'active') ? 1 : 0;
            $this->db->where('industrial_park_master.is_active', $status_value);
        }
    
        // Execute the query and return results
        $query = $this->db->get();
        return $query->result_array();
    }
    

}