|
Server IP : 172.26.0.195 / Your IP : 3.144.31.86 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/css/../../grievance/application/models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Model Class For Handling All DB Operations Related To Cities And States Info
*
* @author Softpro India Pvt. Ltd.
*/
defined('BASEPATH') OR exit('No direct script access allowed');
class LocationManagement extends CI_Model {
function __construct() {
parent::__construct();
$this->load->database();
}
function getAllStates(){
$this->db->select('*');
$this->db->from('states_mst');
$this->db->where('country_id = 101');
return $this->db->get();
}
function getAllActiveStates(){
$this->db->select('*');
$this->db->from('states_mst');
$this->db->where('country_id = 101');
$this->db->where('state_status','T');
return $this->db->get();
}
function getAllCities(){
$this->db->select('CM.id, CM.name cityName, SM.name stateName, CM.status');
$this->db->from('cities_mst CM');
$this->db->join('states_mst SM','CM.state_id = SM.id');
$this->db->where('SM.country_id = 101');
return $this->db->get();
}
function getActiveCitiesByState($state_id){
$this->db->select('*');
$this->db->from('cities_mst');
$this->db->where('status', 'T');
$this->db->where('state_id', $state_id);
return $this->db->get();
}
function getStateInfoBy($state_id){
$this->db->select("*");
$this->db->from('states_mst');
$this->db->where('id', $state_id);
$query = $this->db->get();
return $query;
}
function getCityInfoBy($city_id){
$this->db->select("CM.id, CM.name cityName, CM.status, SM.name stateName, SM.id stateId");
$this->db->from('cities_mst CM');
$this->db->join('states_mst SM','CM.state_id = SM.id');
$this->db->where('CM.id', $city_id);
$query = $this->db->get();
return $query;
}
}