<?php
require_once 'Framework/Modele.php';

class Envoimail extends Modele {

    public function ajoutermailgenererbon($typeMail, $codeTypeBon, $noDepart, $noFin, $receptionnaire, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, codeTypeBon, noDepart, noFin, receptionnaire, codePrestataire, codeUtilisateur) 
		values (?, ?, ?, ?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $codeTypeBon, $noDepart, $noFin, $receptionnaire, $codePrestataire, $user));
    }	

    public function ajouterrefusderogation($typeMail, $idDemandederogation, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandederogation, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandederogation, $codePrestataire, $user));
    }	

    public function ajouteraccordderogation($typeMail, $idDemandederogation, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandederogation, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandederogation, $codePrestataire, $user));
    }	

//

    public function ajouterrefusententeprealable($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	

    public function ajouteraccordententeprealable($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	

    public function ajouterdemandefraisfuneraire($typeMail, $idBeneficiaire, $montantApayer)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idBeneficiaire, montant, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idBeneficiaire, $montantApayer, $user));
    }	

    public function ajouterrefusacteexclu($typeMail, $idDemandeautorisation)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeautorisation, codeUtilisateur) values(?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeautorisation, $user));
    }	

    public function ajouteraccordacteexclu($typeMail, $idDemandeautorisation)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeautorisation, codeUtilisateur) values(?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeautorisation, $user));
    }	
	
	//
    public function ajouteraccordententeprealablepha($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	
	
    public function ajouterrefusententeprealablepha($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	
	//
	
    public function ajouteraccordententeprealableopt($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	
	
    public function ajouterrefusententeprealableopt($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	

    public function ajouteraccordententeprealablemont($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	
	
    public function ajouterrefusententeprealablemont($typeMail, $idDemandeententeprealable, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandeententeprealable, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandeententeprealable, $codePrestataire, $user));
    }	

    public function logenvoisms($destinataires, $message)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into logenvoisms (destinataires, message, codeUtilisateur) values(?, ?, ?)';
        $sortie =  $this->executerRequete($sql, array($destinataires, $message, $user));
    }	
	
    public function ajoutersms($destinataires, $message)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoisms (destinataires, message, codeUtilisateur) values(?, ?, ?)';
        $sortie =  $this->executerRequete($sql, array($destinataires, $message, $user));
    }	

    public function ajoutermailadherent($email, $objet, $message)
	{
		$user = $_SESSION['login'];
		$sql = 'INSERT INTO p_envoimailadherent (email, objet, message, codeUtilisateur) values(?, ?, ?, ?)';		
        $sortie =  $this->executerRequete($sql, array($email, $objet, $message, $user));
    }	
	
	// 02/06/2021
	 public function ajouteraccordsubstititionpha($typeMail, $idDemandesubstitution, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandesubstitution, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandesubstitution, $codePrestataire, $user));
    }	

	 public function ajouterrefussubstitutionpha($typeMail, $idDemandesubstitution, $codePrestataire)
	{
		$user = $_SESSION['login'];
		$sql = 'insert into envoimail (typeMail, idDemandesubstitution, codePrestataire, codeUtilisateur) values(?, ?, ?, ?)';
        $this->executerRequete($sql, array($typeMail, $idDemandesubstitution, $codePrestataire, $user));
    }	
}