Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Our_location extends CI_Model {
public function __construct()
{
parent::__construct();
}
//Our Location List
public function our_location_list()
{
$this->db->select('*');
$this->db->from('our_location');
$this->db->order_by('location_id','asc');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Our Location Search Item
public function our_location_search_item($our_location_id)
{
$this->db->select('*');
$this->db->from('our_location');
$this->db->where('our_location_id',$our_location_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Our Location entry
public function our_location_entry($data)
{
$this->db->insert('our_location',$data);
return TRUE;
}
//Retrieve Our Location Edit Data
public function retrieve_our_location_editdata($position)
{
$this->db->select('*');
$this->db->from('our_location');
$this->db->where('position',$position);
$this->db->order_by('language_id');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Update Our Location
public function update_our_location($data,$position,$language_id)
{
$this->db->set('headline',$data['headline']);
$this->db->set('details',$data['details']);
$this->db->where('language_id',$language_id);
$this->db->where('position',$position);
$result = $this->db->update('our_location');
if (array_key_exists("position",$data)) {
$this->db->set('position',$data['position']);
$this->db->where('position',$position);
$result = $this->db->update('our_location');
}
if ($result) {
return true;
}
return false;
}
// Delete Our Location Item
public function delete_our_location($position)
{
$this->db->where('position',$position);
$this->db->delete('our_location');
return true;
}
}