59 lines
1.3 KiB
PHP
Executable File
59 lines
1.3 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
class Exclusioncollege extends Modele {
|
|
|
|
public function exclure($id_exclusioncollege, $idCollege, $codeActe, $choix)
|
|
{
|
|
$codeUtilisateur = $_SESSION['login'];
|
|
|
|
if ($choix=='0')
|
|
{
|
|
$sql = 'DELETE FROM exclusioncollege WHERE (id=?)';
|
|
$this->executerRequete($sql, array($id_exclusioncollege));
|
|
}
|
|
else
|
|
{
|
|
$sql = 'insert into exclusioncollege (
|
|
codeSociete,
|
|
idCollege,
|
|
idPolice,
|
|
numeroPolice,
|
|
codeActe,
|
|
user
|
|
)
|
|
select
|
|
codeSociete,
|
|
id as idCollege,
|
|
idPolice,
|
|
numeroPolice,
|
|
?,
|
|
?
|
|
from college where (id=?)';
|
|
|
|
$this->executerRequete($sql, array($codeActe, $codeUtilisateur, $idCollege));
|
|
}
|
|
}
|
|
|
|
public function getExclusionCollege($idCollege)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_exclusions_college(?, ?);';
|
|
|
|
$exclusions = $this->executerRequete($sql, array($codeSociete, $idCollege));
|
|
|
|
return $exclusions->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getExclusionFamille($idCollege)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_exclusions_famille(?, ?);';
|
|
|
|
$exclusions = $this->executerRequete($sql, array($codeSociete, $idCollege));
|
|
|
|
return $exclusions->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
}
|