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

class Mlease extends CI_Model {

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

    }

    public function saveLeaseData($data) {
        // Insert data into database
        $this->db->insert('register_lease_master', $data);
        // Check if data inserted successfully
        if ($this->db->affected_rows() > 0) {
            // Return the insert ID
            return $this->db->insert_id();
        } else {
            return false;
        }
    }

    public function get_all_leases() {
        // Retrieve all leases from the database
        $query = $this->db->get('register_lease_master');
        return $query->result_array();
    }


       public function updateLease($lease_id, $data) {
        // Update lease data in the database
        $this->db->where('register_lessee_id', $lease_id);
        return $this->db->update('register_lease_master', $data);
    }

    public function getLeaseById($lease_id) {
        // Fetch lease data from the database based on lease ID
        $query = $this->db->get_where('register_lease_master', array('register_lessee_id' => $lease_id));
        
        // Check if lease data exists
        if ($query->num_rows() > 0) {
            return $query->row_array(); // Return lease data as an associative array
        } else {
            return false; // No lease data found
        }   
    }
}