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
defined('BASEPATH') OR exit('No direct script access allowed');
class User_model extends CI_Model {
public function create($data = array())
{
return $this->db->insert('user', $data);
}
public function read()
{
return $this->db->select("
user.*,
CONCAT_WS(' ', firstname, lastname) AS fullname
")
->from('user')
->order_by('id', 'desc')
->get()
->result();
}
public function single($id = null)
{
return $this->db->select('*')
->from('user')
->where('id', $id)
->get()
->row();
}
public function update($data = array())
{
return $this->db->where('id', $data["id"])
->update("user", $data);
}
public function delete($id = null)
{
return $this->db->where('id', $id)
->where_not_in('is_admin',1)
->delete("user");
}
public function dropdown()
{
$data = $this->db->select("id, CONCAT_WS(' ', firstname, lastname) AS fullname")
->from("user")
->where('status', 1)
->where_not_in('is_admin', 1)
->get()
->result();
$list[''] = display('select_option');
if (!empty($data)) {
foreach($data as $value)
$list[$value->id] = $value->fullname;
return $list;
} else {
return false;
}
}
}