Kineo\Model\ResultsModel::getResults()

Complexity

Conditions	3
Paths	2

Size

Total Lines	23
Code Lines	9

Duplication

Lines	23
Ratio	100 %

Importance

Changes	3
Bugs	0	Features	0

<?php
	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;
		}
	}
}