CommentController::initialize() - Code Metrics - ejessyp/flowerflow - Measure and Improve Code Quality continuously with Scrutinizer

CommentController::initialize() A
last analyzed 2021-01-15 18:38 UTC

↳ Parent: CommentController

Complexity

Conditions	2
Paths	2

Size

Total Lines	13
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	8
nc	2
nop	0
dl	0
loc	13
c	1
b	0
f	0
cc	2
rs	10

<?php

namespace Pan\Comment;

use Anax\Commons\ContainerInjectableInterface;
use Anax\Commons\ContainerInjectableTrait;


// use Anax\Route\Exception\ForbiddenException;
// use Anax\Route\Exception\NotFoundException;
// use Anax\Route\Exception\InternalErrorException;

/**
 * A sample controller to show how a controller class can be implemented.
 */
class CommentController implements ContainerInjectableInterface
{
    use ContainerInjectableTrait;



    /**
     * @var $data description

     */
    private $currentUser;
    private $db;
    private $userId;



    // /**
    //  * The initialize method is optional and will always be called before the
    //  * target method/action. This is a convienient method where you could
    //  * setup internal properties that are commonly used by several methods.
    //  *
    //  * @return void
    //  */
    public function initialize() : void
    {
        // Get the current user from session
        $session = $this->di->get("session");
        // var_dump($_SESSION);
        $this->currentUser = $session->get("username");
        // Connect the database
        $this->db = $this->di->get("db");
        $this->db->connect();
        if ($this->currentUser !=null) {
            $sql = "SELECT id from users where username = ?;";
            $res = $this->db->executeFetchAll($sql, [$this->currentUser]);
            $this->userId = $res[0]->id;
        }
    }


    public function createActionPost(int $id) : object
    {
        $request = $this->di->get("request");
        $response = $this->di->get("response");
        $submit = $request->getPost("submit") ?: null;
        if ($this->currentUser) {
            if ($submit) {
                $comment = $request->getPost("comment") ?: null;
                $sql = "INSERT INTO comments (comment, post_id, user_id, answer) VALUES (?, ?, ?, ?);";
                $this->db->execute($sql, [$comment, $id, $this->userId, 0]);
                return $response->redirect("post/show/$id");
            }
        }
        $response = $this->di->get("response");
        return $response->redirect("user/login");
    }

    public function uppvoteAction(int $id, int $post_id) : object
    {
        $page = $this->di->get("page");

        if ($this->currentUser) {
            $sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
            $this->db->execute($sql, [1, $id, $this->userId]);

            $response = $this->di->get("response");
            return $response->redirect("post/show/$post_id");
        }
        $response = $this->di->get("response");
        return $response->redirect("user/login");
    }

    public function downvoteAction(int $id, int $post_id) : object
    {
        $page = $this->di->get("page");

        if ($this->currentUser) {
            $sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
            $this->db->execute($sql, [-1, $id, $this->userId]);

            $response = $this->di->get("response");
            return $response->redirect("post/show/$post_id");
        }
        $response = $this->di->get("response");
        return $response->redirect("user/login");
    }

    /**
     * Handler to change the status of answer accepted or unaccepted
     *
     * @return object as a response object
     */
    public function acceptAction(int $id, int $post_id) : object
    {
        $page = $this->di->get("page");

        //get the status of this answer
        $sql = "select accepted from comments where post_id=? and id=?;";
        $res = $this->db->executeFetchAll($sql, [$post_id, $id]);

        if ($res[0]->accepted==0) {
            $accepted =1;
        } elseif ($res[0]->accepted==1) {
            $accepted=0;
        }
        //change the status of this answer
        $sql = "update comments set accepted=? where post_id=? and id=?;";
        $this->db->execute($sql, [$accepted, $post_id, $id]);

        $response = $this->di->get("response");
        return $response->redirect("post/show/$post_id");
    }

    /**
     * Handler with form to reply a comment.
     *
     * @param int $id the id to answer.
     *
     * @return object as a response object
     */
    public function replyActionPost(int $id, int $post_id) : object
    {
        $request = $this->di->get("request");
        $response = $this->di->get("response");
        $submit = $request->getPost("submit") ?: null;
        if ($this->currentUser) {
            if ($submit) {
                $comment = $request->getPost("comment") ?: null;
                $sql = "INSERT INTO comments (comment, comment_reply_id, post_id, user_id, answer) VALUES (?, ?, ?, ?, ?);";
                $this->db->execute($sql, [$comment, $id, $post_id, $this->userId, 0]);
                return $response->redirect("post/show/$post_id");
            }
        }
        $response = $this->di->get("response");
        return $response->redirect("user/login");
    }
}


1			<?php
2
3			namespace Pan\Comment;
4
5			use Anax\Commons\ContainerInjectableInterface;
6			use Anax\Commons\ContainerInjectableTrait;
7
8
9			// use Anax\Route\Exception\ForbiddenException;
10			// use Anax\Route\Exception\NotFoundException;
11			// use Anax\Route\Exception\InternalErrorException;
12
13			/**
14			* A sample controller to show how a controller class can be implemented.
15			*/
16			class CommentController implements ContainerInjectableInterface
17			{
18			use ContainerInjectableTrait;
19
20
21
22			/**
23			* @var $data description
			0 ignored issues – show Documentation Bug introduced 2021-01-14 15:05 UTC by Report Bug Copy Issue Report The doc comment `$data` at position `0` could not be parsed: Unknown type name '$data' at position 0 in $data. Loading history...
24			*/
25			private $currentUser;
26			private $db;
27			private $userId;
28
29
30
31			// /**
32			// * The initialize method is optional and will always be called before the
33			// * target method/action. This is a convienient method where you could
34			// * setup internal properties that are commonly used by several methods.
35			// *
36			// * @return void
37			// */
38			public function initialize() : void
39			{
40			// Get the current user from session
41			$session = $this->di->get("session");
42			// var_dump($_SESSION);
43			$this->currentUser = $session->get("username");
44			// Connect the database
45			$this->db = $this->di->get("db");
46			$this->db->connect();
47			if ($this->currentUser !=null) {
48			$sql = "SELECT id from users where username = ?;";
49			$res = $this->db->executeFetchAll($sql, [$this->currentUser]);
50			$this->userId = $res[0]->id;
51			}
52			}
53
54
55			public function createActionPost(int $id) : object
56			{
57			$request = $this->di->get("request");
58			$response = $this->di->get("response");
59			$submit = $request->getPost("submit") ?: null;
60			if ($this->currentUser) {
61			if ($submit) {
62			$comment = $request->getPost("comment") ?: null;
63			$sql = "INSERT INTO comments (comment, post_id, user_id, answer) VALUES (?, ?, ?, ?);";
64			$this->db->execute($sql, [$comment, $id, $this->userId, 0]);
65			return $response->redirect("post/show/$id");
66			}
67			}
68			$response = $this->di->get("response");
69			return $response->redirect("user/login");
70			}
71
72			public function uppvoteAction(int $id, int $post_id) : object
73			{
74			$page = $this->di->get("page");
			0 ignored issues – show Unused Code introduced 2021-01-15 14:55 UTC by Report Bug Copy Issue Report The assignment to `$page` is dead and can be removed. Loading history...
75			if ($this->currentUser) {
76			$sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
77			$this->db->execute($sql, [1, $id, $this->userId]);
78
79			$response = $this->di->get("response");
80			return $response->redirect("post/show/$post_id");
81			}
82			$response = $this->di->get("response");
83			return $response->redirect("user/login");
84			}
85
86			public function downvoteAction(int $id, int $post_id) : object
87			{
88			$page = $this->di->get("page");
			0 ignored issues – show Unused Code introduced 2021-01-15 14:55 UTC by Report Bug Copy Issue Report The assignment to `$page` is dead and can be removed. Loading history...
89			if ($this->currentUser) {
90			$sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
91			$this->db->execute($sql, [-1, $id, $this->userId]);
92
93			$response = $this->di->get("response");
94			return $response->redirect("post/show/$post_id");
95			}
96			$response = $this->di->get("response");
97			return $response->redirect("user/login");
98			}
99
100			/**
101			* Handler to change the status of answer accepted or unaccepted
102			*
103			* @return object as a response object
104			*/
105			public function acceptAction(int $id, int $post_id) : object
106			{
107			$page = $this->di->get("page");
			0 ignored issues – show Unused Code introduced 2021-01-14 15:05 UTC by Report Bug Copy Issue Report The assignment to `$page` is dead and can be removed. Loading history...
108			//get the status of this answer
109			$sql = "select accepted from comments where post_id=? and id=?;";
110			$res = $this->db->executeFetchAll($sql, [$post_id, $id]);
111
112			if ($res[0]->accepted==0) {
113			$accepted =1;
114			} elseif ($res[0]->accepted==1) {
115			$accepted=0;
116			}
117			//change the status of this answer
118			$sql = "update comments set accepted=? where post_id=? and id=?;";
119			$this->db->execute($sql, [$accepted, $post_id, $id]);
			0 ignored issues – show Comprehensibility Best Practice introduced 2021-01-14 15:05 UTC by Report Bug Copy Issue Report The variable `$accepted` does not seem to be defined for all execution paths leading up to this point. Loading history...
120			$response = $this->di->get("response");
121			return $response->redirect("post/show/$post_id");
122			}
123
124			/**
125			* Handler with form to reply a comment.
126			*
127			* @param int $id the id to answer.
128			*
129			* @return object as a response object
130			*/
131			public function replyActionPost(int $id, int $post_id) : object
132			{
133			$request = $this->di->get("request");
134			$response = $this->di->get("response");
135			$submit = $request->getPost("submit") ?: null;
136			if ($this->currentUser) {
137			if ($submit) {
138			$comment = $request->getPost("comment") ?: null;
139			$sql = "INSERT INTO comments (comment, comment_reply_id, post_id, user_id, answer) VALUES (?, ?, ?, ?, ?);";
140			$this->db->execute($sql, [$comment, $id, $post_id, $this->userId, 0]);
141			return $response->redirect("post/show/$post_id");
142			}
143			}
144			$response = $this->di->get("response");
145			return $response->redirect("user/login");
146			}
147			}
148

ejessyp / flowerflow

CommentController::initialize() A last analyzed 2021-01-15 18:38 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CommentController::initialize() A
last analyzed 2021-01-15 18:38 UTC