36 lines
1.1 KiB
PHP
Executable File
36 lines
1.1 KiB
PHP
Executable File
<?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);
|
|
|
|
}
|
|
|
|
} |