<?php
require_once "config.inc.php";
require_once "fonctions.php";
require_once "db.class.php";
require_once "log.php";
require_once "donnees.inc.php";
require_once "send_mail.php";

$db = new db("dolibarr");
$db2 = new db("dolibarr");
$query = "SELECT TIMESTAMPDIFF(MINUTE, '" . date('Y-m-d H:i:s') . "' , date_fin) as diff, titre, id_sondage, commentaires, sujet FROM llx_opensurvey_sondage WHERE status='1' ORDER BY date_fin";
$message = '';

$db->query($query);
if ( $db->result->num_rows !=0 )
{
	while( $sondage = $db->result->fetch_array() )
	{
		$diff = $sondage['diff'];
		$ateliers['lien'] = $base_url . "dbarr/public/opensurvey/studs.php?sondage=" . $sondage["id_sondage"];
		$ateliers["titre"] = $sondage["titre"];
		if ($diff < 0)
		{
			$query = "UPDATE llx_opensurvey_sondage SET STATUS='2' where id_sondage='" . $sondage['id_sondage'] . "'";
			$db2->query($query);
		}elseif ( $diff <= 2760 )
		{
			$query = "SELECT * FROM llx_opensurvey_user_studs WHERE id_sondage='" . $sondage["id_sondage"] . "'";
			$id = $sondage["id_sondage"];
			$r = explode(" ", $sondage['sujet'], 2);
			if ( trim( $r[0], " ") != "Atelier" and !empty($minimPart))
			{
				$minParticipants = $minimPart;
			}else
			{
				$minParticipants = 2;
			}
			$db2->query($query);
			// pour chaque vote on compte les résultats par atelier
			if ($db2->result->num_rows > 0)
			{
				$nom_atelier = explode( ",", $sondage["sujet"] );

				while( $reponse = $db2->result->fetch_array() )
				{
					$r = str_split( $reponse["reponses"] );
					$l = count( $r );
					for ($x=0; $x<$l; $x++)
					{
						if ( !isset($tab[$x]) )
						{
							$tab[$x] = 0;
						}
						$tab[$x] += $r[$x];
					}
				}

				//$ateliers["commentaire"] = $nom_atelier;
				arsort($tab);
				$ateliers["atelier"] = strstr($nom_atelier[key($tab)], "@checkbox" , true );
				if ( $tab[0] < $minParticipants )
				{
					echo "annulation\n";
					$ateliers['commentaires'] = annulation_atelier( $ateliers["titre"] );
				}else
				{
					$ateliers['commentaires'] = confirmation_atelier( $ateliers["titre"], $ateliers["atelier"] );
				}
			}else
			{
				echo "annulation\n";
				$ateliers['commentaires'] = annulation_atelier( $ateliers["titre"] );
			}
			/*if ( $diff <= 21600 )
			{
				$ateliers['titre'] = $sondage["titre"];
				$ateliers['commentaires'] .= $sondage["commentaires"];
			}
*/
		}
	}
	if ( !empty($ateliers['commentaires']) )
	{
		echo $ateliers['commentaires'];
		send_mail("all", 'dtux@free.fr', $ateliers['commentaires']);
		//print_r($ateliers);
	}
}

?>