Ajout code postal dans la liste des candidates

Ajout du code postal dans la liste des candidats

Issue : #1 (closed)

application/engine/bo/CandidateBo.php

@@ -97,10 +97,11 @@ class CandidateBo {
 		if (!$filters) $filters = array();
 		$args = array();
 
-		$query = "	SELECT *
+		$query = "	SELECT c.*, ifnull(a.add_zip_code, '00000') as add_zip_code
 						, (SELECT GROUP_CONCAT(cpo_position) FROM candidature_positions WHERE cpo_candidature_id = can_id) as can_positions 
 						, (SELECT GROUP_CONCAT(cci_circonscription) FROM candidature_circonscriptions WHERE cci_candidature_id = can_id) as can_circos
-					FROM $this->TABLE
+					FROM $this->TABLE c
+					LEFT JOIN addresses a on can_address_id = add_id
 					WHERE
 						1 = 1 \n";