Kineo\Model\CandidatesModel

Complexity

Total Complexity

4

Size/Duplication

Total Lines	36
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	4
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
B	getCandidatesByConstituencyId()	0	24	3

<?php
namespace Kineo\Model;

use Kineo\Component\Database;

class CandidatesModel extends BaseModel 
{
	protected $db;
	
	public $candidates = array();
	
	public function __construct(Database $db)
	{
		$this->db = $db;
	}
	
	public function getCandidatesByConstituencyId($constituencyId) 
	{
		$stmt = $this->db->prepare(
			"SELECT a.id, a.name, a.party FROM `tblCandidates` AS a 
			LEFT JOIN `tblConstituencies` AS b 
			ON a.constituency_id = b.id 
			WHERE b.id = :id
			ORDER BY a.name ASC"
		);
		
		$stmt->bindValue(':id', $constituencyId, \PDO::PARAM_INT);
		
		$stmt->execute();
		
		$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
		
		if(is_array($result) && !empty($result)) {
			$this->candidates = $result;
			
			return $this->candidates;
		} else {
			return false;
		}
	}
}