{source}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="/css/style.css">
<title>PHP Form</title>
</head>
<body>
<main>
<?php 

$superutilisateur=8;

$enregistre = 2 ;

$editeur = 5;

$adherent = 10;

$public = 1 ;

$invite = 9 ;

$user = JFactory::getUser();


if (in_array($superutilisateur,$user->groups)) : ?>

<?php if ($_SERVER['REQUEST_METHOD'] === 'GET') : ?>


<form action="<?php htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="post">



Envoi de SMS aux inscrits de l'évènement <br/><br>



Compte SMS :



<select name="compte">




<option value="sms-dd12909-1">A Pedibus</option>




<option value="sms-dd12909-2">RandoTourves</option>



</select><br />



Login :



<select name="login">




<option value="daniel">Daniel</option>




<option value="michel">Michel</option>




<option value="jean-yves">Jean-Yves</option>




<option value="christine">Christine</option>




<option value="paul">Paul</option>



</select><br />



<div>




<label for="password"Mot de Passe:</label>




<input type="password" name="password" required="required" placeholder="Enter your password" />



</div>



Expéditeur :



<select name="from">




<option value="APEDIBUS.FR">A Pedibus</option>




<option value="randtourves">RandoTourves</option>



</select><br />








Message :<br />



<textarea name="message" cols="20" rows="7" placeholder="Ceci est le message à envoyer"></textarea><br />



<div>




<input type="checkbox" id="simulation" name="simulation" checked>




<label for="horns">Simulation SMS</label>



</div>



<!--<div>



<INPUT type="checkbox" id="choix" name="choix1" value="name"> Nom



<INPUT type="checkbox" id="choix" name="choix2" value="email"> Email



<INPUT type="checkbox" id="choix" name="choix3" value="phone"> Téléphone



<INPUT type="checkbox" id="choix" name="choix4" value="people"> Personnes



</div>



-->



<br/>



<button type="submit">Soumettre</button>


</form>

<?php else : ?>


<?php


//---------------------------------------------


// WARNING: this doesn't include sanitization


// and validation


//---------------------------------------------


function control_tel($arg_1)


{



//echo '<br/>---'.$arg_1.' ';



if ((strlen($arg_1) == 12) and ($arg_1[0] == '+')) {




//echo $arg_1.'+++<br/>';




return $arg_1;




}



else {




$arg_1 = '+33' . substr($arg_1,-9);




//echo $arg_1.'++++<br/>';




return $arg_1;



}


} 


function enleve_accent($chaine=''){


$accent = array('%C3%80'=>'A','%C3%81'=>'A','%C3%82'=>'A','%C3%83'=>'A','%C3%84'=>'A','%C3%85'=>'A','%C3%A0'=>'a','%C3%A1'=>'a','%C3%A2'=>'a','%C3%A3'=>'a','%C3%A4'=>'a','%C3%A5'=>'a','%C3%92'=>'O','%C3%93'=>'O','%C3%94'=>'O','%C3%95'=>'O','%C3%96'=>'O','%C3%98'=>'O','%C3%B2'=>'o','%C3%B3'=>'o','%C3%B4'=>'o','%C3%B5'=>'o','%C3%B6'=>'o','%C3%B8'=>'o','%C3%88'=>'E','%C3%89'=>'E','%C3%8A'=>'E','%C3%8B'=>'E','%C3%A8'=>'e','%C3%A9'=>'e','%C3%AA'=>'e','%C3%AB'=>'e','%C3%87'=>'C','%C3%A7'=>'c','%C3%8C'=>'I','%C3%8D'=>'I','%C3%8E'=>'I','%C3%8F'=>'I','%C3%AC'=>'i','%C3%AD'=>'i','%C3%AE'=>'i','%C3%AF'=>'i','%C3%99'=>'U','%C3%9A'=>'U','%C3%9B'=>'U','%C3%9C'=>'U','%C3%B9'=>'u','%C3%BA'=>'u','%C3%BB'=>'u','%C3%BC'=>'u','%C3%BF'=>'y','%C3%91'=>'N','%C3%B1'=>'n');


$chaine = urlencode($chaine);


foreach ($accent as $key => $value) {



$chaine = str_replace($key,$value,$chaine);


}


return urldecode($chaine);


}


error_reporting(E_ALL);


//setlocale(LC_CTYPE, 'fr_FR.UTF-8');


//echo '<b>Variables</b> :<br />';


//echo '<pre>';


//print_r($_POST);


//echo '</pre>';


//echo htmlspecialchars($_SERVER['PHP_SELF']).'<br/>';


if (isset($_POST['password'], $_POST['login'])) {



$name = htmlspecialchars($_POST['name']);



$email = htmlspecialchars($_POST['email']);








$user = JFactory::getUser();



$databasePrefix = $database->getPrefix();



$glue = implode (",", $user->groups);



//var_dump($glue);



//var_dump( $user->groups);



//echo $user->groups;
var_dump(JFactory::getApplication()->input->get('id'));
//exit();



$query = "select * from ".$databasePrefix."icagenda_registration WHERE eventid=".(int)JFactory::getApplication()->input->get('id')." order by ".$databasePrefix."icagenda_registration.name";
//var_dump($query);



$database->setQuery( $query );



//echo eventid, (int)JRequest::getInt(id), JV3_icagenda_registration.id, Parent_id ;



$rows_registration = $database->loadObjectList();



//var_dump($rows_registration);



//echo '_______________________'.$rows_registration['0']->userid;








$query = $database->getQuery(true);



$query->select($databasePrefix.'comprofiler.id,







user_id,







cb_tlphoneportable,'







.$databasePrefix.'users.id,







email');



$query->from($databasePrefix.'comprofiler INNER JOIN '.$databasePrefix.'users ON '.$databasePrefix.'comprofiler.id = '.$databasePrefix.'users.id');



/*$query->where (






//$database->quoteName('id')." != '' AND ".






//$database->quoteName('next')." >= '".$date_debut."' AND ".






//$database->quoteName('next')." <= '".$date_fin."' AND ".






//$database->quoteName('state')." = 1 AND (".






//$database->quoteName('access')." = 1 OR ".






//$database->quoteName('access')." = 2 OR ".






//$database->quoteName('access')." = 3 OR ".






//$database->quoteName('access')." = 4 OR ".






//$database->quoteName('access')." = 5 OR ".






//$database->quoteName('access')." = 6 OR ".






//$database->quoteName('access')." = 7 OR ".






//$database->quoteName('access')." = 8 OR ".






//$database->quoteName('access')." = 9 OR ".






//$database->quoteName('access')." = 10 OR ".






$database->quoteName($databasePrefix.'comprofiler.cb_fonction')." != 'Figurant'");*/



$query->order($databasePrefix."comprofiler.lastname ASC");



//$query->group('title');




//echo $query;



$database->setQuery( $query );



//var_dump($query->__toString());



$rows = $database->loadObjectList();



//var_dump($rows);



$date_actuelle = strtotime("now");



$date_report = $date_actuelle + (int) (3600*.25); 








$liste_phone = array();



foreach ($rows_registration as $row_registration) {




//echo $row_registration->phone.' '.gettype($row_registration->phone).' '.strlen($row_registration->phone)."<br/>";





if (strlen($row_registration->phone) == 0) {






foreach ($rows as $row) {







//echo $row_registration->userid.' '.$row->id.' '.$row->cb_tlphoneportable.' '.$row->cb_tlphoneportable."<br/>";







if ($row_registration->userid == $row->id) {







$liste_phone[] = $row->cb_tlphoneportable;







}






}





















}





else {$liste_phone[] = control_tel($row_registration->phone);}



}



//print_r ($liste_phone);



//$destinataire = "



if ($_POST['simulation'] == 'on') $destinataire = "



else $destinataire = "



$message = $_POST['message'];



//$message = mb_convert_encoding($message,"ISO-8859-1");



//$message = mb_strtoupper($message);



//$message = iconv('UTF-8', 'ISO-8859-15//TRANSLIT//IGNORE', $message);



$message = enleve_accent ($message);



$message = substr($message,0,150);



//echo $message;



$expediteur = "



$headers = 'MIME-Version: 1.0' . "\n"; // Version MIME



$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";



$headers .= 'Reply-To: '.$expediteur."\n"; // Mail de reponse



$headers .= 'From: '.$expediteur."\n"; // Expediteur



$liste_phone_str = '';



for ($i=0;$i<sizeof($liste_phone);$i++) {




$liste_phone_str .= $liste_phone[$i].',';




if (($i % 5) == 4) {





$objet = "Account=".$_POST['compte'].":Login=".$_POST['login'].":Password=".$_POST['password'].":From=".$_POST['from'].":To=".$liste_phone_str.":Deferred=".date("HidmY",$date_report).":NoStop=1";





$liste_phone_str = '';





$retval = mb_send_mail($destinataire, $objet, $message.$i, $headers);





//echo $i.' ++'.($i % 5).' '.$objet."<br/>" ;




}



}



if (strlen($liste_phone_str)!=0) {




$objet = "Account=".$_POST['compte'].":Login=".$_POST['login'].":Password=".$_POST['password'].":From=".$_POST['from'].":To=".$liste_phone_str.":Deferred=".date("HidmY",$date_report).":NoStop=1";




//$objet = "Account=".$_POST['compte'].":Login=".$_POST['login'].":Password=".$_POST['password'].":From=".$_POST['from'].":To=".$liste_phone_str.":Deferred=".date("HidmY",$date_report).":NoStop=1";










$retval = mb_send_mail($destinataire, $objet, $message, $headers);




//echo $i.' --'.($i % 5).' '.$objet."<br/>" ;



}





//mail($mail,$sujet,$liste_phone,$header);




} else {





echo 'You need to provide your login and password.';




}


?>

<?php endif ?>
<?php endif ?>
</main>
</body>
</html>
{/source}
{sooource file=MyFiles/TraitementSMSInscription.php}{/source}