summaryrefslogtreecommitdiff
path: root/src/web/_controller/_util
diff options
context:
space:
mode:
authorFreya Murphy <freya@freyacat.org>2024-12-23 11:13:27 -0500
committerFreya Murphy <freya@freyacat.org>2024-12-23 11:13:27 -0500
commit5a2ba9c2e7605bb788bc406184547d22c6436867 (patch)
treecbd988d534e8a8593a31d70571222443f80da0b3 /src/web/_controller/_util
parentfix about modal (diff)
downloadxssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.tar.gz
xssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.tar.bz2
xssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.zip
v2.1.0, refactor w/ crimson
Diffstat (limited to 'src/web/_controller/_util')
-rw-r--r--src/web/_controller/_util/post.php212
1 files changed, 0 insertions, 212 deletions
diff --git a/src/web/_controller/_util/post.php b/src/web/_controller/_util/post.php
deleted file mode 100644
index 5346497..0000000
--- a/src/web/_controller/_util/post.php
+++ /dev/null
@@ -1,212 +0,0 @@
-<?php /* Copyright (c) 2024 Freya Murphy */
-class Post_controller extends Controller {
-
- // the request model
- private $request_model;
-
- // the caceh model
- private $cache_model;
-
- // page size
- private $page_size;
-
- function __construct($load) {
- parent::__construct($load);
- $this->request_model = $this->load->model('request');
- $this->cache_model = $this->load->model('cache');
- $this->page_size = 10;
- }
-
- public function index(): void {
- $this->view('template/posts');
- }
-
- public function post(): void {
- $pid = $this->request_model->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->cache_model->get_users([$post]);
- $uid = $post['user_id'];
-
- if (!array_key_exists($uid, $users)) {
- return;
- }
-
- $user = $users[$uid];
-
- $data = array(
- 'user' => $user,
- 'page_size' => $this->page_size,
- 'post' => $post
- );
- $this->view('template/post', $data);
- }
-
- /**
- * @return array<string,mixed>
- */
- public function posts(): array {
- $page = $this->request_model->get_int('page', 0);
- $max = $this->request_model->get_int('max');
- $offset = $page * $this->page_size;
- $filter_uid = $this->request_model->get_int('user_id', FALSE);
-
- $user = $this->main->user();
- $uid = isset($user) ? $user['id'] : NULL;
-
- $query = $this->db;
-
- $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($this->page_size)
- ->offset($offset)
- ->rows();
-
- $users = $this->cache_model->get_users($posts);
- $max = 0;
-
- foreach ($posts as $post) {
- $max = max($max, $post['id']);
- $data = array();
- $data['page_size'] = $this->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' => $this->page_size,
- 'max' => $max,
- 'filter_uid' => $filter_uid
- );
- }
-
- public function comment(): void {
- $cid = $this->request_model->get_int('id', 0);
-
- $comment = $this->db
- ->select('*')
- ->from('api.comment')
- ->where('id')
- ->eq($cid)
- ->row();
-
- if (!$comment) {
- return;
- }
-
- $users = $this->cache_model->get_users([$comment]);
- $uid = $comment['user_id'];
-
- if (!array_key_exists($uid, $users)) {
- return;
- }
-
- $user = $users[$uid];
-
- $data = array(
- 'user' => $user,
- 'comment' => $comment
- );
- $this->view('template/comment', $data);
- }
-
- /**
- * @return array<string,mixed>
- */
- public function comments(): array {
- $page = $this->request_model->get_int('page', 0);
- $max = $this->request_model->get_int('max');
- $id = $this->request_model->get_int('id', 0);
- $offset = $page * $this->page_size;
-
- $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($this->page_size)
- ->offset($offset)
- ->rows();
-
- $users = $this->cache_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 &&
- $this->main->session === NULL
- ) {
- echo '<hr>';
- }
-
- foreach ($comments as $comment) {
- $max = max($max, $comment['id']);
- $data = array();
- $data['user'] = $users[$comment['user_id']];
- $data['comment'] = $comment;
- $this->view('template/comment', $data);
- }
-
- return array(
- 'loaded' => count($comments),
- 'page_size' => $this->page_size,
- 'max' => $max,
- );
- }
-}