<?php /* Copyright (c) 2024 Freya Murphy */
class _post_controller extends XSS_Controller {

	private $auth_model;

	function __construct() {
		parent::__construct();
		$this->auth_model = $this->load_model('auth');
		$this->load_lang('post');
	}

	public function index(): void {
		$this->view('_template/posts');
	}

	public function post(): void {
		$pid = $this->get_int('id', 0);

		$post = $this->db()
			->select('p.*, l.id as like_id')
			->from('api.post p')
			->join('api.like l', 'p.id = l.post_id AND l.user_id')
			->eq($pid)
			->where('p.id')
			->eq($pid)
			->row();

		if (!$post)
			return;

		$users = $this->model->get_users([$post]);
		$uid = $post['user_id'];

		if (!isset($users[$uid]))
			return;

		$user = $users[$uid];

		$data = $this->model->get_data();
		$data['user'] = $user;
		$data['page_size'] = POST_PAGE_SIZE;
		$data['post'] = $post;
		$this->view('_template/post', $data);
	}

    /**
     * @return array<string,mixed>
     */
    public function posts(): array {
		$page = $this->get_int('page', 0);
		$max = $this->get_int('max');
		$offset = $page * POST_PAGE_SIZE;
		$filter_uid = $this->get_int('user_id', FALSE);

		$user = $this->auth_model->session();
		$uid = isset($user) ? $user['id'] : NULL;

		$query = $this->db()
			->select('p.*, l.id as like_id')
			->from('api.post p')
			->join('api.like l', 'p.id = l.post_id AND l.user_id')
			->eq($uid);

		if ($max) {
			$query = $query
				->where('p.id')->le($max);
		}

		if ($filter_uid) {
			$query = $query
				->where('p.user_id')->eq($filter_uid);
		}

		$posts = $query
			->order_by('p.id', 'DESC')
			->limit(POST_PAGE_SIZE)
			->offset($offset)
			->rows();

		$users = $this->model->get_users($posts);
		$max = 0;

		foreach ($posts as $post) {
			$max = max($max, $post['id']);
			$data = $this->model->get_data();
			$data['page_size'] = POST_PAGE_SIZE;
			$data['user'] = $users[$post['user_id']];
			$data['post'] = $post;
			$this->view('_template/post', $data);
		}

		$query = $this->db()
			->select('COUNT(p.id) as pc')
			->from('api.post p');

		if ($filter_uid) {
			$query = $query
				->where('p.user_id')->eq($filter_uid);
		}

		$pc = $query
			->row()['pc'];

		return array(
			'loaded' => count($posts),
			'total' => $pc,
			'page_size' => POST_PAGE_SIZE,

			'max' => $max,
			'filter_uid' => $filter_uid
		);
	}

	public function comment(): void {
		$cid = $this->get_int('id', 0);

		$comment = $this->db()
			->select('*')
			->from('api.comment')
			->where('id')
			->eq($cid)
			->row();

		if (!$comment) {
			return;
		}

		$users = $this->model->get_users([$comment]);
		$uid = $comment['user_id'];

		if (!array_key_exists($uid, $users)) {
			return;
		}

		$user = $users[$uid];

		$data = $this->model->get_data();
		$data['user'] = $user;
		$data['comment'] = $comment;
		$this->view('_template/comment', $data);
	}

    /**
     * @return array<string,mixed>
     */
    public function comments(): array {
		$page = $this->get_int('page', 0);
		$max = $this->get_int('max');
		$id = $this->get_int('id', 0);
		$offset = $page * COMMENT_PAGE_SIZE;

		$user = $this->auth_model->session();

		$query = $this->db()
			->select('*')
			->from('api.comment')
			->where('post_id')
			->eq($id);

		if ($max) {
			$query = $query
				->and()
				->where('id')
				->le($max);
		}

		$comments = $query
			->order_by('id', 'ASC')
			->limit(COMMENT_PAGE_SIZE)
			->offset($offset)
			->rows();

		$users = $this->model->get_users($comments);
		$max = 0;

		// only add this hr when not logged in
		// otherwise its added automatically by
		// the like and comment buttons
		if (
			count($comments) &&
				$page == 0 &&
				$user === NULL
		) {
			echo '<hr>';
		}

		foreach ($comments as $comment) {
			$max = max($max, $comment['id']);
			$data = $this->model->get_data();
			$data['user'] = $users[$comment['user_id']];
			$data['comment'] = $comment;
			$this->view('_template/comment', $data);
		}

		return array(
			'loaded' => count($comments),
			'page_size' => COMMENT_PAGE_SIZE,
			'max' => $max,
		);
	}
}