<?php

class User_model extends MY_Model
{
	public function count_all_by_login()
	{
		if ($this->session->userdata('user_id') != '') {
			if ($this->session->userdata('user_id') == 1) {
				$query = $this->db->get($this->_table);
				return $query->num_rows();
			} else {
				$query = $this->db->where('admin_id', $this->session->userdata('user_id'))->get($this->_table);
				return $query->num_rows();
			}
		}
	}

	public function getadmin()
	{
		$query = $this->db->where('admin_group_id', 2)->get('admin_users');
		return $query->result();
	}

	// ===================================================
	public function check_permission_posts_count($user_id, $admin_id = NULL, $tag_id = NULL)
	{
		$this->db->select('users.id');
		$this->db->join('admin_users as au', 'au.id = users.admin_id');

		if (!empty($admin_id)) {
			$this->db->where('users.admin_id', $admin_id);
		}

		if (!empty($tag_id)) {
			$this->db->like('users.tag_id', $tag_id, 'both');
		}

		if (!empty($user_id)) {
			$this->db->where('users.id', $user_id);
		}

		$query = $this->db->get('users');

		if ($query->num_rows() > 0) {
			return $query->num_rows();
		}

		return 0;
	}

	public function check_permission_posts($limit, $start, $col, $dir, $user_id, $admin_id = NULL, $tag_id = NULL)
	{
		$this->db->select('users.*, au.username as admin');
		$this->db->join('admin_users as au', 'au.id = users.admin_id');

		if (!empty($admin_id)) {
			$this->db->where('users.admin_id', $admin_id);
		}

		if (!empty($user_id)) {
			$this->db->where('users.id', $user_id);
		}

		if (!empty($tag_id)) {
			$this->db->like('users.tag_id', $tag_id, 'both');
		}

		$this->db->limit($limit, $start);
		$this->db->order_by($col, $dir);
		$query = $this->db->get('users');

		if ($query->num_rows() > 0) {
			return $query->result();
		}

		return [];
	}

	function check_permission_posts_search($limit, $start, $search, $col, $dir, $user_id, $admin_id = NULL, $tag_id = NULL)
	{
		$this->db->select('users.*, au.username as admin');
		$this->db->join('admin_users as au', 'au.id = users.admin_id');

		if (!empty($admin_id)) {
			$this->db->where('users.admin_id', $admin_id);
		}

		if (!empty($user_id)) {
			$this->db->where('users.id', $user_id);
		}

		if (!empty($tag_id)) {
			$this->db->like('users.tag_id', $tag_id, 'both');
		}

		if (!empty($search)) {
			$this->db->like('users.username', $search);
			$this->db->or_like('users.email', $search);
			$this->db->or_like('users.phone', $search);
			$this->db->or_like('users.first_name', $search);
			$this->db->or_like('users.registration_code', $search);
		}

		$this->db->limit($limit, $start);
		$this->db->order_by($col, $dir);
		$query = $this->db->get('users');

		if ($query->num_rows() > 0) {
			return $query->result();
		} else {
			return [];
		}
	}

	public function check_permission_posts_search_count($search, $user_id, $admin_id = NULL, $tag_id = NULL)
	{
		$this->db->select('users .id');
		$this->db->join('admin_users as au', 'au.id = users.admin_id');

		if (!empty($admin_id)) {
			$this->db->where('users.admin_id', $admin_id);
		}

		if (!empty($user_id)) {
			$this->db->where('users.user_id', $user_id);
		}

		if (!empty($tag_id)) {
			$this->db->like('users.tag_id', $tag_id, 'both');
		}

		if (!empty($search)) {
			$this->db->like('users.username', $search);
			$this->db->or_like('users.email', $search);
			$this->db->or_like('users.phone', $search);
			$this->db->or_like('users.first_name', $search);
			$this->db->or_like('users.registration_code', $search);
		}

		$query = $this->db->get('users');

		if ($query->num_rows() > 0) {
			return $query->num_rows();
		}

		return 0;
	}
}