modules\comment\admin\controller\AdminComment

Complexity

Total Complexity

10

Size/Duplication

Total Lines	92
Duplicated Lines	10.87 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getValues()	0	3	1
A	getAllTable()	0	19	4
A	getAllComment()	10	20	3
A	getNbCheckedComment()	0	8	1
A	setValues()	0	3	1

<?php
	namespace modules\comment\admin\controller;
	
	use core\App;
	use modules\comment\app\controller\Comment;
	
	class AdminComment extends Comment {
		private $values = [];
		
		//-------------------------- BUILDER ----------------------------------------------------------------------------//
		//-------------------------- END BUILDER ----------------------------------------------------------------------------//
		
		
		//-------------------------- GETTER ----------------------------------------------------------------------------//
		/**
		 * @return array
		 * function to get values out of the class
		 */
		public function getValues(){
			return ["comment" => $this->values];
		}
		
		/**
		 * function that get a list of all table_name wich are in comment module
		 */
		public function getAllTable() {
			$dbc = App::getDb();
			
			$query = $dbc->select("table_name, ID_in_table")->from("_comment_all")->groupBy("ID_in_table, table_name")->get();
			
			if ((is_array($query)) && (count($query) > 0)) {
				$values = [];
				foreach ($query as $obj) {
					$values[] = [
						"table_name" => str_replace("_", " ", $obj->table_name),
						"id_in_table" => $obj->ID_in_table,
						"nb_checked_comment" => $this->getNbCheckedComment($obj->table_name, 1),
						"nb_unchecked_comment" => $this->getNbCheckedComment($obj->table_name, 0),
					];
				}
				
				$this->setValues($values);
			}
		}
		
		/**
		 * @param $table
		 * @param $id_in_table
		 * function to get all comments of a table with an id
		 */
		public function getAllComment($table, $id_in_table) {
			$dbc = App::getDb();
			
			$query = $dbc->select()->from("_comment_all")->where("table_name", "=", $table, "AND")
				->where("ID_in_table", "=", $id_in_table)->orderBy("checked", "DESC")->get();
			
			$values = [];
			if (count($query) > 0) {

This code seems to be duplicated across your project.

				foreach ($query as $obj) {
					$values[] = [
						"comment" => $obj->comment,
						"date" => $obj->date,
						"pseudo" => $obj->pseudo,
						"id_identite" => $obj->ID_identite,
					];
				}
			}
			
			$this->setValues($values);
		}
		
		/**
		 * @param $table_name
		 * @param $checked
		 * @return int
		 * function that get number of checked or unchecked comment for a table_name
		 */
		private function getNbCheckedComment($table_name, $checked) {
			$dbc = App::getDb();
			
			$query = $dbc->select("ID_comment")->from("_comment_all")->where("table_name", "=", $table_name, "AND")
				->where("checked", "=", $checked)->get();
			
			return count($query);
		}
		//-------------------------- END GETTER ----------------------------------------------------------------------------//
		
		
		//-------------------------- SETTER ----------------------------------------------------------------------------//
		/**
		 * @param $values
		 * function to set all values and sort it in future
		 */
		public function setValues($values) {
			$this->values = array_merge($this->values, $values);
		}
		//-------------------------- END SETTER ----------------------------------------------------------------------------//    
	}