<?php
require_once 'Framework/Modele.php';

class Societeuser extends Modele {

    public function getSocieteuser($codeSociete)
	{
		$sql = 'select A.codeSociete, A.nomSociete, A.adresseGeoSociete, A.adressePostSociete, 
		A.ville, A.telephoneSociete, A.emailSociete, A.faxSociete, A.codePays, 
		medecinConseil, emailMedecinConseil, telephoneMedecinConseil, 
		emailAdministrateurSysteme, telephoneAdministrateurSysteme, sigleSociete, A.registreCommerce
		from societeuser A
		left join pays B on (B.codeSociete=A.codeSociete) and (B.codePays=A.codePays)
		where (A.codeSociete=?)';

        $societe = $this->executerRequete($sql, array($codeSociete));
        return $societe->fetch(PDO::FETCH_ASSOC);
    }
	
    public function getVwSocieteuser($codeSociete)
	{
		$sql = 'select * from vw_societeuser where (codeSociete=?);';

        $societe = $this->executerRequete($sql, array($codeSociete));
        return $societe->fetch(PDO::FETCH_ASSOC);
    }

    public function enregistrermodif($idSocieteuser, $emailMedecinConseil, $emailGestionBon, $emailCcomptabilite, 
	$emailDerogation, $emailAccordPrealable, $emailFraudeFinger, $email_standard, $email_reply, $smsMedecinConseil, 
	$smsGestionBon, $smsDerogation, $smsAccordPrealable, $codeLangueSociete)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_modifier_parametresgeneraux(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idSocieteuser, $emailMedecinConseil, $emailGestionBon, $emailCcomptabilite, 
		$emailDerogation, $emailAccordPrealable, $emailFraudeFinger, $email_standard, $email_reply, $smsMedecinConseil, 
		$smsGestionBon, $smsDerogation, $smsAccordPrealable, $codeLangueSociete, $user));
    }
	
     public function enregistrermodifprod($idSocieteuser, $spMax, $fraisCarteAN, $fraisCarteREN, 
		$fraisCarteImp, $spAlertAdherent, $tauxRistourne, $seuilRistourne)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_modifier_parametres_prod(?, ?, ?, ?, ?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idSocieteuser, $spMax, $fraisCarteAN, $fraisCarteREN, 
		$fraisCarteImp, $spAlertAdherent, $tauxRistourne, $seuilRistourne, $user));
    }

     public function enregistrermodifsin($idSocieteuser, $accesAjoutPh, $ajoutPrescription, $ajoutPrescriptionExam, 
		$envoismsactif, $smsAssure, $smsmParFacture, $emailParFacture, $copieSmsPrestataireAssure, $filtreMedecin,
		$nbMedicamentMax, $seuilAlerteActif)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_modifier_parametres_sin(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idSocieteuser, $accesAjoutPh, $ajoutPrescription, $ajoutPrescriptionExam, 
		$envoismsactif, $smsAssure, $smsmParFacture, $emailParFacture, $copieSmsPrestataireAssure, $filtreMedecin,
		$nbMedicamentMax, $seuilAlerteActif, $user));
    }
		
    public function verifiermotpass($codeSociete, $mdp)
    {
		$sql = "call sp_get_mot_pass_reinit(?);";
		
		$resultat = $this->executerRequete($sql, array($codeSociete));
		
		if ($resultat->rowCount() == 1)
		{
			$user = $resultat->fetch(PDO::FETCH_ASSOC);
			$hash = $user['motPassReinit'];
			return (password_verify($mdp, $hash));
		}
		else 
		{
			return false;
		}
    }
		
    public function changerpass($codeSociete, $ancmdp, $nvmdp)
    {
		$user = $_SESSION['login'];
		
		$hash = password_hash($nvmdp, PASSWORD_DEFAULT);
		
		$sql = "CALL sp_r_changementmotpassreinit(?, ?, ?);";

		$this->executerRequete($sql, array($codeSociete, $hash, $user));
    }
		
    public function getSocieteSimple($codeSociete)
	{
		$sql = 'select * from societeuser where (codeSociete=?);';

        $societe = $this->executerRequete($sql, array($codeSociete));
		
        return $societe->fetch(PDO::FETCH_ASSOC);
    }

	public function getparamsgenerationpass()
	{
		$codeSociete = $_SESSION['codeSociete'];
		
		$sql = 'SELECT A.codeModeGenerationPass, B.libelle AS modegenerationpass, A.codeModeEnvoiPass FROM societeuser A
		LEFT JOIN modegenerationpass B ON (B.codeModeGenerationPass=A.codeModeGenerationPass) WHERE (A.codeSociete=?) LIMIT 1;';
		
        $resultat = $this->executerRequete($sql, array($codeSociete));;

		$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
		
		return $ligne;		
    }

	public function getmodeenvoipass()
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeModeEnvoiPass AS `code`, libelleEng AS libelle FROM modeenvoipass ORDER BY ordre;';
		}
		else
		{
			$sql = 'SELECT codeModeEnvoiPass AS `code`, libelle FROM modeenvoipass ORDER BY ordre;';
		}

        $resultat = $this->executerRequete($sql);

		return $resultat->fetchAll(PDO::FETCH_ASSOC);	
    }

	public function getmodegenerationpass()
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeModeGenerationPass AS `code`, libelleEng AS libelle FROM modegenerationpass ORDER BY ordre;';
		}
		else
		{
			$sql = 'SELECT codeModeGenerationPass AS `code`, libelle FROM modegenerationpass ORDER BY ordre;';
		}

        $resultat = $this->executerRequete($sql);

		return $resultat->fetchAll(PDO::FETCH_ASSOC);	
    }	

}