<?php

require_once 'Framework/Modele.php';

class Qrcodemodele extends Modele {
	
	public function getAncienChemin($matricule){
		
		$sql 		= "SELECT qr_code_path FROM beneficiaire WHERE numeroBeneficiaire = ?";
		$resultat 	= $this->executerRequete($sql, array($matricule))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['qr_code_path'];
	}
	
	public function majBeneficiaireQr($nomFichier, $matricule) {
        $sql 		= "UPDATE beneficiaire SET qr_code_path = ? WHERE numeroBeneficiaire = ?;";
		
		$this->executerRequete($sql, array($nomFichier, $matricule));
    }
	
	public function getMatriculesAssuresImportes()
	{
		$idPolice		= $_SESSION['idPolice_C'];
		$idAvenant 		= $_SESSION['idAvenantImport'];
		
		$sql 			= "SELECT A.numeroBeneficiaire as matricule
						   FROM beneficiaire A JOIN beneficiaireavenant B ON (A.idAvenant = B.idAvenant AND A.id = B.idBeneficiaire) 
						   WHERE A.idPolice = ? and B.idAvenant = ? AND A.qr_code_path = '';";
		
		$resultat 		= $this->executerRequete($sql, array($idPolice, $idAvenant));
		
		return $resultat->fetchAll(PDO::FETCH_COLUMN);
		
	}
    
}