<?php

class Permission_model extends MY_Model
{

	public function check_permission_posts_count($course_id, $subject_id, $chapter_id, $admin_id, $e_type, $user_id)
	{
		$this->db->select('regfiles.*');
		$this->db->from('regfiles');
		$this->db->join('lectures', 'lectures.id = regfiles.lecture_id');
		$this->db->join('chapters', 'chapters.id = lectures.chapter_id');
		$this->db->join('subjects', 'subjects.id = chapters.subject_id');
		$this->db->join('courses', 'courses.id = subjects.course_id');
		$this->db->join('admin_users as au', 'au.id = regfiles.admin_id');

		if (!empty($admin_id)) {
			$this->db->where('regfiles.admin_id', $admin_id);
		}
		if (!empty($e_type)) {
			$this->db->where('lectures.e_type', $e_type);
		}
		if (!empty($course_id)) {
			$this->db->where('courses.id', $course_id);
		}
		if (!empty($subject_id)) {
			$this->db->where('subjects.id', $subject_id);
		}
		if (!empty($chapter_id)) {
			$this->db->where('chapters.id', $chapter_id);
		}
		if (!empty($user_id)) {
			$this->db->where('regfiles.user_id', $user_id);
		}
		$query = $this->db->count_all_results();
		return $query;
	}

	public function check_permission_posts($limit, $start, $order, $dir, $course_id, $subject_id, $chapter_id, $admin_id, $e_type, $user_id)
	{
		$this->db->select('regfiles.*,lectures.e_type, chapters.chapter,subjects.subject,courses.course, au.username as admin, lectures.file_name as lecture');
		$this->db->join('lectures', 'lectures.id = regfiles.lecture_id');
		$this->db->join('chapters', 'chapters.id = lectures.chapter_id');
		$this->db->join('subjects', 'subjects.id = chapters.subject_id');
		$this->db->join('courses', 'courses.id = subjects.course_id');
		$this->db->join('admin_users as au', 'au.id = regfiles.admin_id');

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

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

		if (!empty($course_id)) {
			$this->db->where('courses.id', $course_id);
		}
		if (!empty($subject_id)) {
			$this->db->where('subjects.id', $subject_id);
		}
		if (!empty($chapter_id)) {
			$this->db->where('chapters.id', $chapter_id);
		}

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

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

		return [];
	}

	function check_permission_posts_search($limit, $start, $search, $order, $dir, $course_id, $subject_id, $chapter_id,  $admin_id, $e_type, $user_id)
	{
		$this->db->select('regfiles.*,lectures.e_type, chapters.chapter, subjects.subject, courses.course, au.username as admin, lectures.file_name as lecture');
		$this->db->join('lectures', 'lectures.id = regfiles.lecture_id');
		$this->db->join('chapters', 'chapters.id = lectures.chapter_id');
		$this->db->join('subjects', 'subjects.id = chapters.subject_id');
		$this->db->join('courses', 'courses.id = subjects.course_id');
		$this->db->join('admin_users as au', 'au.id = regfiles.admin_id');

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

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

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

		if (!empty($course_id)) {
			$this->db->where('courses.id', $course_id);
		}
		if (!empty($subject_id)) {
			$this->db->where('subjects.id', $subject_id);
		}
		if (!empty($chapter_id)) {
			$this->db->where('chapters.id', $chapter_id);
		}

		if (!empty($search)) {
			$this->db->like('lectures.file_name', $search);
			$this->db->or_like('regfiles.user_id', $search);
		}

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

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

	public function check_permission_posts_search_count($search, $course_id, $subject_id, $chapter_id, $admin_id, $e_type, $user_id)
	{
		$this->db->select('regfiles.id');
		$this->db->join('lectures', 'lectures.id = regfiles.lecture_id');
		$this->db->join('chapters', 'chapters.id = lectures.chapter_id');
		$this->db->join('subjects', 'subjects.id = chapters.subject_id');
		$this->db->join('courses', 'courses.id = subjects.course_id');
		$this->db->join('admin_users as au', 'au.id = regfiles.admin_id');

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

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

		if (!empty($course_id)) {
			$this->db->where('courses.id', $course_id);
		}
		if (!empty($subject_id)) {
			$this->db->where('subjects.id', $subject_id);
		}
		if (!empty($chapter_id)) {
			$this->db->where('chapters.id', $chapter_id);
		}
		if (!empty($user_id)) {
			$this->db->where('regfiles.user_id', $user_id);
		}

		if (!empty($search)) {
			$this->db->like('lectures.file_name', $search);
			$this->db->or_like('regfiles.user_id', $search);
		}

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

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

		return 0;
	}
}