1727 lines
68 KiB
PHP
Executable File
1727 lines
68 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
class Garantiesbaremepriseencharge extends Modele {
|
|
|
|
public function getGarantiesDisponibles($idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql="SELECT *
|
|
FROM garantie
|
|
WHERE codeGarantie
|
|
NOT IN
|
|
(
|
|
SELECT codeGarantie
|
|
FROM garantiesbaremepriseencharge
|
|
WHERE codeSociete = ?
|
|
AND idBaremePriseEnCharge = ?
|
|
)
|
|
ORDER BY ordre;";
|
|
|
|
$liste = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getGarantiesAjoutees($idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "SELECT A.codeSociete, A.idBaremePriseEnCharge, A.codeGarantie,
|
|
B.libelle, B.libelleEng, B.plafondModifiable, B.ordre
|
|
FROM garantiesbaremepriseencharge A
|
|
JOIN garantie B on (A.codeGarantie = B.codeGarantie)
|
|
WHERE A.codeSociete = ?
|
|
AND A.idBaremePriseEnCharge = ?
|
|
GROUP BY A.codeSociete, A.idBaremePriseEnCharge, A.codeGarantie,
|
|
B.libelle, B.libelleEng, B.plafondModifiable, B.ordre
|
|
ORDER BY B.ordre";
|
|
|
|
//var_dump($codeSociete, $idBaremePriseEnCharge, $exercice); die();
|
|
|
|
$liste = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
|
|
public function ajouterToutesGarantiesBareme($idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_toutes_garantiesbaremepriseencharge(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $user));
|
|
}
|
|
|
|
public function ajouterUneGarantieBareme($idBaremePriseEnCharge, $codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_une_garantiebaremepriseencharge(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $user));
|
|
}
|
|
|
|
|
|
public function retirerToutesGarantiesBareme($idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_toutes_garantiesbaremepriseencharge(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $user));
|
|
}
|
|
|
|
public function retirerUneGarantieBareme($idBaremePriseEnCharge, $codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_une_garantiebaremepriseencharge(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $user));
|
|
}
|
|
|
|
|
|
public function getTauxForfait(){
|
|
if (est_anglophone()){
|
|
$sql = "SELECT id AS code, libelleEng AS libelle
|
|
FROM choixforfaittaux
|
|
where id='1';";
|
|
}else{
|
|
$sql = "SELECT id AS code, libelle
|
|
FROM choixforfaittaux
|
|
where id='1';";
|
|
}
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getRegle(){
|
|
if (est_anglophone()){
|
|
$sql = "SELECT codeRegle AS code, libelleEng AS libelle
|
|
FROM p_regle;";
|
|
}else{
|
|
$sql = "SELECT codeRegle AS code, libelle
|
|
FROM p_regle;";
|
|
}
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getObservationplafond(){
|
|
if (est_anglophone()){
|
|
$sql = "SELECT codeObservation AS code, libelleEng AS libelle
|
|
FROM observationsplafond order by libelle;";
|
|
}else{
|
|
$sql = "SELECT codeObservation AS code, libelle
|
|
FROM observationsplafond order by libelle;";
|
|
}
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getNomGarantie($codeGarantie)
|
|
{
|
|
$sql = 'SELECT codeGarantie, libelle, libelleEng FROM garantie
|
|
WHERE codeSociete = ? and codeGarantie=?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$codeGarantie));
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
///////////////////////////////////garantiebareme///////////////////////////////////
|
|
public function majgarantiebareme($codeGarantie){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'call sp_maj_garantiesbareme(?,?);';
|
|
$this->executerRequete($sql, array($codeGarantie, $idBaremePriseEnCharge));
|
|
|
|
}
|
|
|
|
|
|
public function majforfaitgarantie($codeGarantie, $forfait)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'update garantiesbaremepriseencharge set forfait=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($forfait, $codeGarantie, $idBaremePriseEnCharge));
|
|
}
|
|
|
|
public function majplafondgarantie($codeGarantie, $plafond, $choixForfait)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
if($choixForfait =="1"){
|
|
$sql = 'update garantiesbaremepriseencharge set
|
|
forfaitPlafond=?, tauxPlafond=0
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($plafond, $codeGarantie, $idBaremePriseEnCharge));
|
|
}else{
|
|
$sql = 'update garantiesbaremepriseencharge set
|
|
tauxPlafond=?, forfaitPlafond=0
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($plafond, $codeGarantie, $idBaremePriseEnCharge));
|
|
}
|
|
}
|
|
|
|
public function majnbretransactiongarantie($codeGarantie, $nbreTransaction)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'update garantiesbaremepriseencharge set nbreTransaction=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($nbreTransaction, $codeGarantie, $idBaremePriseEnCharge));
|
|
}
|
|
|
|
public function majperiodicitegarantie($codeGarantie, $codePeriodicite)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'update garantiesbaremepriseencharge set codePeriodicite=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($codePeriodicite, $codeGarantie, $idBaremePriseEnCharge));
|
|
}
|
|
|
|
public function majdelaicarencegarantie($codeGarantie, $delaiCarenceFamilleActe){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'update garantiesbaremepriseencharge set delaiCarenceFamilleActe=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($delaiCarenceFamilleActe, $codeGarantie, $idBaremePriseEnCharge));
|
|
|
|
}
|
|
|
|
public function majticketmoderateurgarantie($codeGarantie, $ticketModerateur)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$user = $_SESSION['login'];
|
|
$sql = 'update garantiesbaremepriseencharge
|
|
set ticketModerateur=?,
|
|
tauxPlafond = fn_taux_couverture_tm(?),
|
|
updateTicketModerateur = "1",
|
|
dateUpdateTicketModerateur = NOW(),
|
|
userUpdateTicketModerateur=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($ticketModerateur, $ticketModerateur, $codeGarantie, $user, $idBaremePriseEnCharge));
|
|
}
|
|
|
|
public function trouvelibelleobservationplafond($codeObservation){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
if (est_anglophone()){
|
|
$sql = 'SELECT id, libelleEng as libelle FROM observationsplafond WHERE (codeSociete=?) AND (codeObservation=?)';
|
|
}else{
|
|
$sql = 'SELECT id, libelle FROM observationsplafond WHERE (codeSociete=?) AND (codeObservation=?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeObservation));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majplafondlettregarantie($codeGarantie, $codeObservation)
|
|
{
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$plafondLettre = $this->trouvelibelleobservationplafond($codeObservation);
|
|
|
|
$sql = 'update garantiesbaremepriseencharge set plafondLettre=?, codeObservation=?
|
|
where (codeGarantie=?) and (idBaremePriseEnCharge=?);';
|
|
$this->executerRequete($sql, array($plafondLettre['libelle'], $codeObservation, $codeGarantie, $idBaremePriseEnCharge));
|
|
}
|
|
|
|
///////////////////////////////////familleacte///////////////////////////////////////////////
|
|
|
|
public function existeligne($idBaremePriseEnCharge){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$sql = 'SELECT id FROM familleactebaremepriseencharge
|
|
WHERE (codeSociete=?) and (idBaremePriseEnCharge=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $idBaremePriseEnCharge));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function majforfaitfamilleacte($idFamilleacte, $forfait)
|
|
{
|
|
$sql = 'update familleactebaremepriseencharge set forfait=? where (id=?)';
|
|
$this->executerRequete($sql, array($forfait, $idFamilleacte));
|
|
}
|
|
|
|
public function majplafondfamilleacte($idFamilleacte, $plafond, $choixForfait)
|
|
{
|
|
if($choixForfait =="1"){
|
|
$sql = 'update familleactebaremepriseencharge set forfaitPlafond=? where (id=?)';
|
|
$this->executerRequete($sql, array($plafond, $idFamilleacte));
|
|
}else{
|
|
$sql = 'update familleactebaremepriseencharge set tauxPlafond=? where (id=?)';
|
|
$this->executerRequete($sql, array($plafond, $idFamilleacte));
|
|
}
|
|
}
|
|
|
|
public function majnbretransactionfamilleacte($idFamilleacte, $nbreTransaction)
|
|
{
|
|
$sql = 'update familleactebaremepriseencharge set nbreTransaction=? where (id=?)';
|
|
$this->executerRequete($sql, array($nbreTransaction, $idFamilleacte));
|
|
}
|
|
|
|
public function majperiodicitefamilleacte($idFamilleacte, $codePeriodicite)
|
|
{
|
|
$sql = 'update familleactebaremepriseencharge set codePeriodicite=? where (id=?)';
|
|
$this->executerRequete($sql, array($codePeriodicite, $idFamilleacte));
|
|
}
|
|
|
|
public function majobservationfamilleacte($idFamilleacte, $codeObservation)
|
|
{
|
|
//var_dump($codeObservation);
|
|
if($codeObservation=="IL"){
|
|
$sql = 'update familleactebaremepriseencharge
|
|
set codeObservation=?,
|
|
forfaitPlafond =9999999999
|
|
where (id=?)';
|
|
}else{
|
|
$sql = 'update familleactebaremepriseencharge set codeObservation=? where (id=?)';
|
|
}
|
|
|
|
$this->executerRequete($sql, array($codeObservation, $idFamilleacte));
|
|
}
|
|
|
|
public function majdelaicarencefamilleacte($idFamilleacte, $delaiCarenceFamilleActe){
|
|
$sql = 'update familleactebaremepriseencharge set delaiCarenceFamilleActe=? where (id=?)';
|
|
$this->executerRequete($sql, array($delaiCarenceFamilleActe, $idFamilleacte));
|
|
|
|
}
|
|
|
|
|
|
public function majticketmoderateurfamilleacte($idFamilleacte, $ticketModerateur)
|
|
{
|
|
//var_dump($idFamilleacte);
|
|
//exit();
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'update familleactebaremepriseencharge
|
|
set ticketModerateur=?,
|
|
tauxPlafond = fn_taux_couverture_tm(?),
|
|
updateTicketModerateur = "1",
|
|
dateUpdateTicketModerateur = NOW(),
|
|
userUpdateTicketModerateur=?
|
|
where (id=?)';
|
|
$this->executerRequete($sql, array($ticketModerateur, $ticketModerateur, $user, $idFamilleacte));
|
|
}
|
|
|
|
|
|
////////////////////////////actes//////////////////////////////////
|
|
|
|
public function majforfaitacte($idActe, $forfait)
|
|
{
|
|
$sql = 'update actesbaremepriseencharge set forfait=? where (id=?)';
|
|
$this->executerRequete($sql, array($forfait, $idActe));
|
|
}
|
|
|
|
public function majplafondacte($idActe, $plafond, $choixForfait)
|
|
{
|
|
if($choixForfait =="1"){
|
|
$sql = 'update actesbaremepriseencharge set forfaitPlafond=? where (id=?)';
|
|
$this->executerRequete($sql, array($plafond, $idActe));
|
|
}else{
|
|
$sql = 'update actesbaremepriseencharge set tauxPlafond=? where (id=?)';
|
|
$this->executerRequete($sql, array($plafond, $idActe));
|
|
}
|
|
}
|
|
|
|
public function majnbretransactionacte($idActe, $nbreTransaction)
|
|
{
|
|
$sql = 'update actesbaremepriseencharge set nbreTransaction=? where (id=?)';
|
|
$this->executerRequete($sql, array($nbreTransaction, $idActe));
|
|
}
|
|
|
|
public function majperiodiciteacte($idActe, $codePeriodicite)
|
|
{
|
|
$sql = 'update actesbaremepriseencharge set codePeriodicite=? where (id=?)';
|
|
$this->executerRequete($sql, array($codePeriodicite, $idActe));
|
|
}
|
|
|
|
|
|
public function majobservationacte($idActe, $codeObservation)
|
|
{
|
|
if($codeObservation=="EP"){
|
|
$sql = 'update actesbaremepriseencharge set codeObservation=?, ententePrealable="1" where (id=?)';
|
|
}elseif($codeObservation=="IL"){
|
|
$sql = 'update actesbaremepriseencharge
|
|
set codeObservation=?,
|
|
ententePrealable="0",
|
|
forfaitPlafond =9999999999
|
|
where (id=?)';
|
|
}else{
|
|
$sql = 'update actesbaremepriseencharge set codeObservation=?, ententePrealable="0" where (id=?)';
|
|
}
|
|
|
|
$this->executerRequete($sql, array($codeObservation, $idActe));
|
|
}
|
|
|
|
public function majdelaicarenceacte($idActe, $delaiCarenceActe){
|
|
$sql = 'update actesbaremepriseencharge set delaiCarenceActe=? where (id=?)';
|
|
$this->executerRequete($sql, array($delaiCarenceActe, $idActe));
|
|
|
|
}
|
|
|
|
public function majticketmoderateuracte($idActe, $ticketModerateur)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'update actesbaremepriseencharge
|
|
set ticketModerateur=?,
|
|
tauxPlafond = fn_taux_couverture_tm(?),
|
|
updateTicketModerateur = "1",
|
|
dateUpdateTicketModerateur = NOW(),
|
|
userUpdateTicketModerateur=?
|
|
where (id=?);';
|
|
$this->executerRequete($sql, array($ticketModerateur, $ticketModerateur, $user, $idActe));
|
|
}
|
|
|
|
//////////////////////////////ToutFamilleacte///////////////////////////////////
|
|
|
|
public function majtoutforfaitfamilleacte($forfaitFamilleActe){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeLienParente = $_SESSION['codeLienParente'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'UPDATE familleactebaremepriseencharge SET forfait=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND
|
|
codeLienParente=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($forfaitFamilleActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
|
|
public function majtoutplafondfamilleacte($plafondFamilleActe, $choixForfait)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeLienParente = $_SESSION['codeLienParente'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
if($choixForfait =="1"){
|
|
$sql = 'update familleactebaremepriseencharge set forfaitPlafond=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($plafondFamilleActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}else{
|
|
$sql = 'update familleactebaremepriseencharge set tauxPlafond=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($plafondFamilleActe));
|
|
}
|
|
}
|
|
|
|
public function majtoutnbretransactionfamilleacte($nbreTransactionFamilleActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeLienParente = $_SESSION['codeLienParente'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update familleactebaremepriseencharge set nbreTransaction=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND
|
|
codeLienParente=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($nbreTransactionFamilleActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
|
|
public function majtoutperiodicitefamilleacte($codePeriodiciteFamilleActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeLienParente = $_SESSION['codeLienParente'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update familleactebaremepriseencharge set codePeriodicite=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND
|
|
codeLienParente=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($codePeriodiciteFamilleActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
public function majtoutdelaicarencefamilleacte($delaiCarenceFamilleActe){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeLienParente = $_SESSION['codeLienParente'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update familleactebaremepriseencharge set delaiCarenceFamilleActe=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND
|
|
codeLienParente=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($delaiCarenceFamilleActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
|
|
}
|
|
|
|
public function majtoutticketmoderateurfamilleacte($ticketModerateurFamilleActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'update familleactebaremepriseencharge set ticketModerateur=?,
|
|
updateTicketModerateur = "1",
|
|
dateUpdateTicketModerateur = NOW(),
|
|
userUpdateTicketModerateur=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=?
|
|
AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($ticketModerateurFamilleActe,$user, $codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
// 05-11-2020
|
|
|
|
public function viderfamilleacteproduitlienparente(){
|
|
$sql = 'DELETE FROM familleactebaremepriseencharge;';
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
public function videractecollegelienparente_temp(){
|
|
$sql = 'DELETE FROM actesbaremepriseencharge;';
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
//////////////////////////////Toutacte///////////////////////////////////
|
|
|
|
public function majtoutforfaitacte($forfaitActe){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set forfait=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($forfaitActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
|
|
public function majtoutplafondacte($plafondActe, $forfaitActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
//var_dump($forfaitActe);
|
|
//exit();
|
|
|
|
if($forfaitActe =="1"){
|
|
$sql = 'update actesbaremepriseencharge set forfaitPlafond=?, tauxPlafond=0
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($plafondActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}else{
|
|
$sql = 'update actesbaremepriseencharge set tauxPlafond=?, forfaitPlafond=0
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($plafondActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
}
|
|
|
|
public function majtoutnbretransactionacte($nbreTransactionActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set nbreTransaction=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($nbreTransactionActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
|
|
public function majtoutcodeperiodiciteacte($codePeriodiciteActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set codePeriodicite=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($codePeriodiciteActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
public function majtoutobservationacte($codeObservationActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set codeObservation=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($codeObservationActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
public function majtoutdelaicarenceacte($delaiCarenceActe){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set delaiCarenceActe=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($delaiCarenceActe,$codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
|
|
}
|
|
|
|
public function majtoutticketmoderateuracte($ticketModerateurActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'update actesbaremepriseencharge set ticketModerateur=?,
|
|
updateTicketModerateur = "1",
|
|
dateUpdateTicketModerateur = NOW(),
|
|
userUpdateTicketModerateur=?
|
|
WHERE (codeSociete=? AND idBaremePriseEnCharge=? AND codeGarantie=?);';
|
|
$this->executerRequete($sql, array($ticketModerateurActe,$user, $codeSociete,$idBaremePriseEnCharge,$codeGarantie));
|
|
}
|
|
|
|
public function existeFamilleacteBareme($codeGarantie,$codeProduit,$idBaremePriseEnCharge){
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$codeProduit = $this->getProduitBareme($idBaremePriseEnCharge);
|
|
|
|
$sql = 'SELECT id FROM familleactebaremepriseencharge
|
|
WHERE codeSociete = ?
|
|
AND codeGarantie = ?
|
|
AND codeProduit = ?
|
|
AND idBaremePriseEnCharge = ?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeGarantie, $codeProduit, $idBaremePriseEnCharge));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function getProduitBareme($idBaremePriseEnCharge){
|
|
$sql = "SELECT codeProduit
|
|
FROM baremepriseencharge
|
|
WHERE id=?;";
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['codeProduit'];
|
|
}
|
|
|
|
|
|
public function existeFamilleacteBaremeId($idBaremePriseEnCharge)
|
|
{
|
|
$sql = "SELECT COUNT(*) AS nbBareme
|
|
FROM familleactebaremepriseencharge
|
|
WHERE idBaremePriseEnCharge=?;";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
if($resultat['nbBareme'] > 0){
|
|
return true;
|
|
}else{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
|
|
public function majticketmoderateur($idBaremePriseEnCharge, $idTauxCouverture)
|
|
{
|
|
if($this->existeFamilleacteBaremeId($idBaremePriseEnCharge)){
|
|
|
|
$sql = "SELECT fn_tm_taux_couverture(?) AS ticketModerateur;";
|
|
$tm = $this->executerRequete($sql, array($idTauxCouverture))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$ticketModerateur = $tm['ticketModerateur'];
|
|
|
|
$sql = "Call sp_maj_ticketmoderateur_actes_bareme(?, ?);";
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge, $ticketModerateur));
|
|
}
|
|
}
|
|
|
|
public function majforfaitplafondFamilleacteBareme(){
|
|
|
|
$sql="UPDATE familleactebaremepriseencharge
|
|
SET forfaitPlafond = 9999999999
|
|
WHERE forfaitPlafond = 0;";
|
|
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
public function getFamilleActeGarantieBaremeInitial($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "SELECT * FROM garantiesbaremeinitial WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=? ORDER BY dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getFamilleActeGarantieBareme($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
$sql = "SELECT * FROM garantiesbaremepriseencharge WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=?
|
|
AND idCollege =? ORDER BY dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $idCollege));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getFamilleActeGarantieBaremeTemp($idBaremePriseEnCharge,$codeGarantie, $idCollegeTemp)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "SELECT * FROM garantiesbaremepriseencharge_temp WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=?
|
|
AND idCollegeTemp =? ORDER BY dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $idCollegeTemp));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function existeActesBareme($codeGarantie, $codeProduit, $idBaremePriseEnCharge){
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$codeProduit = $this->getProduitBareme($idBaremePriseEnCharge);
|
|
|
|
$sql = 'SELECT id FROM actesbaremepriseencharge
|
|
WHERE codeSociete = ?
|
|
AND codeGarantie = ?
|
|
AND codeProduit = ?
|
|
AND idBaremePriseEnCharge = ?
|
|
AND codeActe NOT IN
|
|
(
|
|
SELECT codeActe
|
|
FROM p_exclusionacteproduit
|
|
WHERE codeSociete = ?
|
|
AND codeProduit = ?
|
|
);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete,$codeGarantie,$codeProduit,$idBaremePriseEnCharge,$codeSociete,$codeProduit));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function getActe(){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
$codeProduit = $this->getProduitBareme($idBaremePriseEnCharge);
|
|
|
|
$sql = 'SELECT * FROM actesbaremepriseencharge
|
|
WHERE codeSociete = ?
|
|
AND codeGarantie = ?
|
|
AND codeProduit = ?
|
|
AND idBaremePriseEnCharge = ?
|
|
AND codeActe NOT IN
|
|
(
|
|
SELECT codeActe
|
|
FROM p_exclusionacteproduit
|
|
WHERE codeSociete = ?
|
|
AND codeProduit = ?
|
|
);
|
|
ORDER BY libelle;';
|
|
$resultat = $this->executerRequete($sql, array($codeSociete,$codeGarantie,$codeProduit,$idBaremePriseEnCharge,$codeSociete,$codeProduit));
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majforfaitplafondActesGarantieBareme(){
|
|
|
|
$sql="UPDATE actesbaremepriseencharge
|
|
SET forfaitPlafond = 9999999999
|
|
WHERE forfaitPlafond = 0;";
|
|
|
|
$this->executerRequete($sql);
|
|
}
|
|
|
|
public function getActesGarantieBaremeInitial($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremeinitial a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
ORDER BY b.libelle, a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActesGarantieBareme($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremepriseencharge a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
AND a.idCollege = ?
|
|
ORDER BY b.libelle, a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge,$idCollege));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActesGarantieBaremeTemp($idBaremePriseEnCharge,$codeGarantie,$idCollegeTemp)
|
|
{
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremepriseencharge_temp a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
AND a.idCollegeTemp = ?
|
|
ORDER BY b.libelle, a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge,$idCollegeTemp));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function supprimerActe($idActe){
|
|
|
|
$sql = 'DELETE FROM actesbaremepriseencharge
|
|
WHERE (id=?);';
|
|
|
|
$this->executerRequete($sql, array($idActe));
|
|
}
|
|
|
|
// 31-01-2023
|
|
public function getActesGarantieBaremeAdd($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$codeProduit = $this->getProduitBareme($idBaremePriseEnCharge);
|
|
|
|
|
|
|
|
if (est_anglophone()){
|
|
$sql = "CALL sp_actesgarantiebaremeadd_eng(?, ?, ?);";
|
|
}else{
|
|
$sql = "CALL sp_actesgarantiebaremeadd(?, ?, ?);";
|
|
}
|
|
|
|
//var_dump($codeGarantie, $codeSociete, $codeProduit);
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$codeSociete,$codeProduit));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function ajouteracteBareme($codeActe, $idBaremePriseEnCharge, $codeGarantie)
|
|
{
|
|
$codeProduit = $this->getProduitBareme($idBaremePriseEnCharge);
|
|
$idTauxCouverture = $_SESSION['idTauxCouverture'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouteracteBareme(?, ?, ?, ?, ?, ?);';
|
|
|
|
//var_dump($codeActe, $idBaremePriseEnCharge, $codeGarantie, $codeProduit, $idTauxCouverture, $user); die();
|
|
|
|
|
|
$this->executerRequete($sql, array($codeActe, $idBaremePriseEnCharge, $codeGarantie, $codeProduit, $idTauxCouverture, $user));
|
|
}
|
|
|
|
|
|
public function getGarantieLienParenteBaremeInitial($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "SELECT * FROM garantiesbaremeinitiallienparente WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=? ORDER BY codeLienParente, dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getGarantieLienParenteBareme($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
|
|
$sql = "SELECT * FROM garantiesbaremepriseenchargelienparente WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=? AND idCollege=?
|
|
ORDER BY codeLienParente, dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $idCollege));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getGarantieLienParenteBaremeTemp($idBaremePriseEnCharge,$codeGarantie,$idCollegeTemp)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "SELECT * FROM garantiesbaremepriseenchargelienparente_temp WHERE codeSociete=?
|
|
AND idBaremePriseEnCharge=? AND codeGarantie=? AND idCollegeTemp=?
|
|
ORDER BY codeLienParente, dateEffet DESC, id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBaremePriseEnCharge, $codeGarantie, $idCollegeTemp));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getLienParente(){
|
|
if (est_anglophone()){
|
|
$sql = "SELECT codeLienParente AS code, libelleEng AS libelle
|
|
FROM lienparente ORDER BY ordre;";
|
|
}else{
|
|
$sql = "SELECT codeLienParente AS code, libelle
|
|
FROM lienparente ORDER BY ordre;";
|
|
}
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//20-02-2023
|
|
public function getActesGarantieBaremeLienParenteInitial($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremeinitiallienparente a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
ORDER BY codeLienParente, b.libelle, a.dateEffet DESC, a.id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActesGarantieBaremeLienParente($idBaremePriseEnCharge,$codeGarantie)
|
|
{
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremepriseenchargelienparente a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
AND a.idCollege = ?
|
|
ORDER BY codeLienParente, b.libelle, a.dateEffet DESC, a.id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge, $idCollege));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActesGarantieBaremeLienParenteTemp($idBaremePriseEnCharge,$codeGarantie,$idCollegeTemp)
|
|
{
|
|
$sql = "SELECT a.*, b.libelle, b.libelleEng
|
|
FROM actesbaremepriseenchargelienparente_temp a
|
|
JOIN p_acte b ON (a.codeActe=b.codeActe)
|
|
WHERE a.codeGarantie = ?
|
|
AND a.idBaremePriseEnCharge = ?
|
|
AND a.idCollegeTemp = ?
|
|
ORDER BY codeLienParente, b.libelle, a.dateEffet DESC, a.id DESC;";
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie,$idBaremePriseEnCharge,$idCollegeTemp));
|
|
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
// 22-02-2023
|
|
|
|
public function insererGarantieBaremeInitial($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe, $forfaitTmGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebareme_initial(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe,$user, $forfaitTmGarantie));
|
|
}
|
|
|
|
|
|
public function insererGarantieBareme($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe, $forfaitTmGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebareme(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe,$user, $forfaitTmGarantie, $idCollege));
|
|
}
|
|
|
|
|
|
public function insererGarantieBaremeTemp($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe, $forfaitTmGarantie, $idCollegeTemp)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebareme_temp(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantie,$forfaitPlafondGarantieAdherent,
|
|
$codePeriodicitePlafondGarantieAdherent,$nbreTransactionGarantieAdherent,$codePeriodiciteGarantieAdherent,$forfaitPlafondGarantie,
|
|
$codePeriodicitePlafondGarantie,$nbreTransactionGarantie,$codePeriodiciteGarantie,$codeTypeRemboursement,$delaiCarenceFamilleActe,
|
|
$ticketModerateurFamilleActe,$ageMinimumFamilleActe,$ageMaximumFamilleActe,$actifFamilleActe,$user, $forfaitTmGarantie, $idCollegeTemp));
|
|
}
|
|
|
|
public function getTmBaremeInitial($idBaremePriseEnCharge){
|
|
|
|
$date = date('Y-m-d');
|
|
|
|
$sql="SELECT fn_ticket_moderateur_bareme_initial(?, ?) AS tmBareme ";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $date))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['tmBareme'];
|
|
}
|
|
|
|
|
|
public function getTmBareme($idBaremePriseEnCharge){
|
|
|
|
$date = date('Y-m-d');
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT fn_ticket_moderateur_bareme(?) AS tmBareme ";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['tmBareme'];
|
|
}
|
|
|
|
|
|
public function getTmBaremeTemp($idBaremePriseEnCharge, $idCollegeTemp){
|
|
|
|
$date = date('Y-m-d');
|
|
|
|
$sql="SELECT fn_ticket_moderateur_bareme_temp(?, ?, ?) AS tmBareme ";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $date, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['tmBareme'];
|
|
}
|
|
//23-02-2023
|
|
|
|
public function insererGarantieBaremeLienparenteInitial($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$forfaitTmGarantieLienParente)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebaremelienparente_initial(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$user, $forfaitTmGarantieLienParente));
|
|
}
|
|
|
|
|
|
public function insererGarantieBaremeLienparente($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$forfaitTmGarantieLienParente)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebaremelienparente(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$user, $forfaitTmGarantieLienParente,$idCollege));
|
|
|
|
|
|
}
|
|
|
|
public function insererGarantieBaremeLienparenteTemp($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$forfaitTmGarantieLienParente,$idCollegeTemp)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'CALL sp_ajoutergarantiebaremelienparente_temp(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$dateEffetGarantieLienParente,$codeLienParente,$forfaitPlafondGarantieLienParente,
|
|
$codePeriodicitePlafondGarantieLienParente,$nbreTransactionGarantieLienParente,$codePeriodiciteGarantieLienParente,$codeTypeRemboursementLienParente,
|
|
$delaiCarenceFamilleActeLienParente,$ticketModerateurFamilleActeLienParente,$ageMinimumFamilleActeLienParente,$ageMaximumFamilleActeLienParente,$actifFamilleActeLienParente,
|
|
$user, $forfaitTmGarantieLienParente,$idCollegeTemp));
|
|
|
|
|
|
}
|
|
|
|
public function insererActeBaremeInitial($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe, $forfaitTmActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremepriseencharge_initial(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe,$user,$forfaitTmActe));
|
|
}
|
|
|
|
|
|
public function insererActeBareme($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe, $forfaitTmActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremepriseencharge(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe,$user,$forfaitTmActe,$idCollege));
|
|
}
|
|
|
|
public function insererActeBaremeTemp($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe, $forfaitTmActe, $idCollegeTemp)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremepriseencharge_temp(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActe,$dateEffetActe,$forfaitPlafondActeAdherent,
|
|
$codePeriodicitePlafondActeAdherent,$nbreTransactionActeAdherent,$codePeriodiciteActeAdherent,$forfaitPlafondActe,
|
|
$codePeriodicitePlafondActe,$nbreTransactionActe,$codePeriodiciteActe,$codeTypeRemboursementActe,$delaiCarenceActe,
|
|
$ticketModerateurActe,$ageMinimumActe,$ageMaximumActe,$actifActe,$user,$forfaitTmActe,$idCollegeTemp));
|
|
}
|
|
|
|
public function insererActeBaremeLienParenteInitial($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$forfaitTmActeLienParente)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremelienparente_initial(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$user,$forfaitTmActeLienParente));
|
|
}
|
|
|
|
public function insererActeBaremeLienParente($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$forfaitTmActeLienParente)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremelienparente(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$user,$forfaitTmActeLienParente,
|
|
$idCollege));
|
|
}
|
|
|
|
public function insererActeBaremeLienParenteTemp($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$forfaitTmActeLienParente,
|
|
$idCollegeTemp)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouteractebaremelienparente_temp(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$dateEffetActeLienParente,$codeLienParenteActeLienParente,
|
|
$forfaitPlafondActeLienParente,$codePeriodicitePlafondActeLienParente,$nbreTransactionActeLienParente,$codePeriodiciteActeLienParente,$codeTypeRemboursementActeLienParente,
|
|
$delaiCarenceActeLienParente,$ticketModerateurActeLienParente,$ageMinimumActeLienParente,$ageMaximumActeLienParente,$actifActeLienParente,$user,$forfaitTmActeLienParente,
|
|
$idCollegeTemp));
|
|
}
|
|
|
|
public function getMaxDateEffetGarantieInitial($idBaremePriseEnCharge,$codeGarantie){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie FROM garantiesbaremeinitial
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetGarantie($idBaremePriseEnCharge,$codeGarantie){
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie
|
|
FROM garantiesbaremepriseencharge
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ?
|
|
AND idCollege = ? AND supprime !='1'
|
|
AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetGarantieTemp($idBaremePriseEnCharge, $codeGarantie, $idCollegeTemp){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie
|
|
FROM garantiesbaremepriseencharge_temp
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ?
|
|
AND idCollegeTemp = ? AND supprime !='1'
|
|
AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
//24-02-2023
|
|
public function getMaxDateEffetGarantieLienparenteInitial($idBaremePriseEnCharge,$codeGarantie,$codeLienParente){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie FROM garantiesbaremeinitiallienparente
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeLienParente = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeLienParente))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
}
|
|
|
|
|
|
public function getMaxDateEffetGarantieLienparente($idBaremePriseEnCharge,$codeGarantie,$codeLienParente){
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie FROM garantiesbaremepriseenchargelienparente
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeLienParente = ?
|
|
AND idCollege = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeLienParente, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
}
|
|
|
|
|
|
public function getMaxDateEffetGarantieLienparenteTemp($idBaremePriseEnCharge,$codeGarantie,$codeLienParente,$idCollegeTemp){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetGarantie FROM garantiesbaremepriseenchargelienparente_temp
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeLienParente = ?
|
|
AND idCollegeTemp = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeLienParente, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
}
|
|
|
|
|
|
public function getMaxDateEffetActeBareme($idBaremePriseEnCharge,$codeGarantie,$codeActe){
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremepriseencharge
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ?
|
|
AND idCollege = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActe, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
|
|
public function getMaxDateEffetActeBaremeTemp($idBaremePriseEnCharge,$codeGarantie,$codeActe,$idCollegeTemp){
|
|
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremepriseencharge_temp
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ?
|
|
AND idCollegeTemp = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActe, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetActeBaremeInitial($idBaremePriseEnCharge,$codeGarantie,$codeActe){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremeinitial
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActe))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetActeBaremeLienParenteInitial($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$codeLienParenteActeLienParente){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremeinitiallienparente
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ? AND codeLienParente = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActeLienParente, $codeLienParenteActeLienParente))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetActeBaremeLienParente($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$codeLienParenteActeLienParente){
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremepriseenchargelienparente
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ?
|
|
AND codeLienParente = ? AND idCollege = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActeLienParente, $codeLienParenteActeLienParente, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetActeBaremeLienParenteTemp($idBaremePriseEnCharge,$codeGarantie,$codeActeLienParente,$codeLienParenteActeLienParente,$idCollegeTemp){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffet FROM actesbaremepriseenchargelienparente_temp
|
|
WHERE idBaremePriseEnCharge = ? AND codeGarantie = ? AND codeActe = ?
|
|
AND codeLienParente = ? AND idCollegeTemp = ?
|
|
AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $codeActeLienParente, $codeLienParenteActeLienParente, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffet'];
|
|
|
|
}
|
|
|
|
//01-03-2023
|
|
public function getTypeRemboursement(){
|
|
|
|
if (est_anglophone()){
|
|
$sql = "SELECT codeTypeRemboursement AS `code`, codeTypeRemboursement AS libelle
|
|
FROM typeremboursement WHERE codeTypeRemboursement IN ('RDTP','RDE')
|
|
ORDER BY codeTypeRemboursement;";
|
|
}else{
|
|
$sql = "SELECT codeTypeRemboursement AS `code`, codeTypeRemboursement AS libelle
|
|
FROM typeremboursement WHERE codeTypeRemboursement IN ('RDTP','RDE')
|
|
ORDER BY codeTypeRemboursement;";
|
|
}
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getGarantiesProduitInitial($codeProduit, $idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "CALL sp_garantieproduitbareme_initial(?, ?, ?);";
|
|
|
|
//var_dump($codeSociete, $idBaremePriseEnCharge, $exercice); die();
|
|
|
|
$liste = $this->executerRequete($sql, array($codeSociete, $codeProduit, $idBaremePriseEnCharge));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getGarantiesProduit($codeProduit, $idBaremePriseEnCharge)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idCollege = $_SESSION['idCollege_C'];
|
|
|
|
$sql = "CALL sp_garantieproduitbareme(?, ?, ?, ?);";
|
|
|
|
$liste = $this->executerRequete($sql, array($codeSociete, $codeProduit, $idBaremePriseEnCharge, $idCollege));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getGarantiesProduitTemp($codeProduit, $idBaremePriseEnCharge, $idCollegeTemp)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = "CALL sp_garantieproduitbareme_temp(?, ?, ?, ?);";
|
|
|
|
$liste = $this->executerRequete($sql, array($codeSociete, $codeProduit, $idBaremePriseEnCharge, $idCollegeTemp));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//19-04-2023
|
|
public function supprimerGarantieBaremeInitial($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebareme_initial(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
public function supprimerGarantieBareme($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebareme(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
public function supprimerGarantieBaremeTemp($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebareme_temp(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
public function supprimerGarantieBaremeLienparenteInitial($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebaremelienparente_initial(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
|
|
public function supprimerGarantieBaremeLienparente($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebaremelienparente(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
|
|
public function supprimerGarantieBaremeLienparenteTemp($idGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimergarantiebaremelienparente_temp(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idGarantie, $user));
|
|
}
|
|
|
|
|
|
public function supprimerActeBaremeInitial($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebareme_initial(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
public function supprimerActeBareme($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebareme(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
public function supprimerActeBaremeTemp($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebareme_temp(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
public function supprimerActeBaremeLienparenteInitial($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebaremelienparente_initial(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
public function supprimerActeBaremeLienparente($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebaremelienparente(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
public function supprimerActeBaremeLienparenteTemp($idActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimeractebaremelienparente_temp(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idActe, $user));
|
|
}
|
|
|
|
//27-04-2023
|
|
|
|
public function getNbreLigneBaremeInitial($table){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
if($table!="detailbareme"){
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql="SELECT fn_nbre_ligne_bareme_newversion_initial(?, ?, ?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $table))->fetch(PDO::FETCH_ASSOC);
|
|
}else{
|
|
$sql="SELECT fn_nbre_ligne_detailbareme_newversion_initial(?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
return $resultat['nbreLigne'];
|
|
}
|
|
|
|
|
|
public function getNbreLigneBareme($table){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
if($table!="detailbareme"){
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql="SELECT fn_nbre_ligne_bareme_newversion(?, ?, ?, ?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $table, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
}else{
|
|
$sql="SELECT fn_nbre_ligne_detailbareme_newversion(?, ?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
return $resultat['nbreLigne'];
|
|
}
|
|
|
|
public function getNbreLigneBaremeTemp($table, $idCollegeTemp){
|
|
|
|
$idBaremePriseEnCharge = $_SESSION['idBaremePriseEnCharge'];
|
|
|
|
|
|
if($table!="detailbareme"){
|
|
$codeGarantie = $_SESSION['codeGarantie'];
|
|
|
|
$sql="SELECT fn_nbre_ligne_bareme_newversion_temp(?, ?, ?, ?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $codeGarantie, $table, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
}else{
|
|
$sql="SELECT fn_nbre_ligne_detailbareme_newversion_temp(?, ?) AS nbreLigne";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
return $resultat['nbreLigne'];
|
|
}
|
|
|
|
//09-05-2023
|
|
public function getMaxDateEffetBaremeInitial($idBaremePriseEnCharge){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetBareme FROM detailbaremeinitial
|
|
WHERE idBaremePriseEnCharge = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetBareme'];
|
|
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetBareme($idBaremePriseEnCharge){
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetBareme FROM detailbaremepriseencharge
|
|
WHERE idBaremePriseEnCharge = ? AND idCollege = ? AND supprime !='1'
|
|
AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetBareme'];
|
|
}
|
|
|
|
public function getMaxDateEffetBaremeTemp($idBaremePriseEnCharge, $idCollegeTemp){
|
|
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetBareme FROM detailbaremepriseencharge_temp
|
|
WHERE idBaremePriseEnCharge = ? AND idCollegeTemp = ? AND supprime !='1'
|
|
AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollegeTemp))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetBareme'];
|
|
}
|
|
|
|
public function getDetailBaremeInitial($idBaremePriseEnCharge)
|
|
{
|
|
$sql = "SELECT a.* FROM detailbaremeinitial a
|
|
WHERE a.idBaremePriseEnCharge = ?
|
|
ORDER BY a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getDetailBareme($idBaremePriseEnCharge)
|
|
{
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql = "SELECT a.* FROM detailbaremepriseencharge a
|
|
WHERE a.idBaremePriseEnCharge = ?
|
|
AND a.idCollege = ?
|
|
ORDER BY a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollege));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getDetailBaremeTemp($idBaremePriseEnCharge, $idCollegeTemp)
|
|
{
|
|
|
|
$sql = "SELECT a.* FROM detailbaremepriseencharge_temp a
|
|
WHERE a.idBaremePriseEnCharge = ?
|
|
AND a.idCollegeTemp = ?
|
|
ORDER BY a.dateEffet DESC, a.id desc;";
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge, $idCollegeTemp));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function insererBaremeInitial($idBaremePriseEnCharge,$dateEffetBareme,$ticketModerateurBareme)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouterdetailbareme_initial(?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge,$dateEffetBareme,
|
|
$ticketModerateurBareme, $user));
|
|
}
|
|
|
|
public function insererBareme($idBaremePriseEnCharge,$dateEffetBareme,$ticketModerateurBareme)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$idCollege = isset($_SESSION['idCollege']) ? $_SESSION['idCollege'] : $_SESSION['idCollege_C'];
|
|
|
|
$sql = 'CALL sp_ajouterdetailbareme(?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge, $dateEffetBareme,
|
|
$ticketModerateurBareme, $user, $idCollege));
|
|
}
|
|
|
|
public function insererBaremeTemp($idBaremePriseEnCharge,$dateEffetBareme,$ticketModerateurBareme, $idCollegeTemp)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouterdetailbareme_temp(?, ?, ?, ?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($idBaremePriseEnCharge, $dateEffetBareme,
|
|
$ticketModerateurBareme, $user, $idCollegeTemp));
|
|
}
|
|
|
|
public function supprimerBaremeInitial($idDetail)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimerdetailbareme_initial(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $user));
|
|
}
|
|
|
|
public function supprimerBareme($idDetail)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'CALL sp_supprimerdetailbareme(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $user));
|
|
}
|
|
|
|
public function supprimerBaremeTemp($idDetail)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimerdetailbareme_temp(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $user));
|
|
}
|
|
/*
|
|
public function getMaxDateEffetBaremeTemp($idBaremePriseEnCharge, $idCollegeTemp){
|
|
|
|
$sql="SELECT MAX(dateEffet) AS maxDateEffetBareme FROM detailbaremepriseencharge
|
|
WHERE idBaremePriseEnCharge = ? AND supprime !='1' AND DATE(dateEffet) <= CURDATE();";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBaremePriseEnCharge))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetBareme'];
|
|
}
|
|
*/
|
|
}
|