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/template/models/ |
<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Template_model extends CI_Model {
public function notifications($id = null)
{
return $this->db->select("COUNT(receiver_id) as total")
->from('message')
->where('receiver_id', $id)
->where('receiver_status', 0)
->group_by('receiver_status')
->get()
->row();
}
public function messages($id = null)
{
return $this->db->select("
message.id,
message.subject,
message.message,
message.datetime,
user.image,
IF (ISNULL(user.firstname) || ISNULL(user.lastname), 'Unauthorized', CONCAT_WS(' ', user.firstname, user.lastname)) AS sender_name
")
->from("message")
->join('user', 'user.id = message.sender_id','left')
->where('message.receiver_id', $id)
->where('message.receiver_status', 0)
->order_by('message.datetime','desc')
->get()
->result();
}
public function setting()
{
return $this->db->get('soft_setting')->row_array();
}
}