Kineo\Model\ResultsModel

Complexity

Total Complexity

4

Size/Duplication

Total Lines	35
Duplicated Lines	100 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	3
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	4	4	1
A	getResults()	23	23	3

<?php
namespace Kineo\Model;

use Kineo\Component\Database;

class ResultsModel extends BaseModel 

This class seems to be duplicated in your project.

{
	protected $db;
	
	public $results = array();
	
	public function __construct(Database $db)
	{
		$this->db = $db;
	}
	
	public function getResults() 
	{
		$stmt = $this->db->query(
			"SELECT a.name, a.party, a.constituency_id, c.name AS constituency, COUNT(*) AS count 
			FROM tblCandidates AS a
			INNER JOIN tblVotes AS b
			ON a.id = b.candidate_id
			LEFT JOIN tblConstituencies AS c
			ON a.constituency_id = c.id
			GROUP BY b.candidate_id
			ORDER BY count DESC, constituency ASC"
		);
		
		$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
		
		if(is_array($result) && !empty($result)) {
			$this->results = $result;
			
			return $this->results;
		} else {
			return false;
		}
	}
}