Forum GestSup

Code : Tout sélectionner

//case send auto mail to tech when technician attribution
if(($rparameters['mail_auto_tech_attribution']==1) && (($_POST['send'] || $_POST['modify'] || $_POST['quit']) && (($globalrow['technician']!=$_POST['technician']) || ($t_group)) && ($_POST['technician']!=$_SESSION['user_id'])))
{
	//debug
	if($rparameters['debug']==1) {echo "<b>AUTO MAIL DETECT:</b>  FROM system TO tech  (Reason: mail_auto_tech_attribution ticket technician attribution is detected)<br> ";}
	
		if($rparameters['mail_from_adr']){$from=$rparameters['mail_from_adr'];} else {$from=$ruser['mail'];}
		
		//technician group detection
		if($t_group) 
		{
			$to='';
			//check group change or attribution
			if($t_group!=$globalrow['t_group'])
			{
				$qry2=$db->prepare("SELECT `tusers`.mail FROM `tusers`,`tgroups_assoc` WHERE `tusers`.id=`tgroups_assoc`.user and `tgroups_assoc`.group=:group");
				$qry2->execute(array('group' => $t_group));
				while($row2=$qry2->fetch()) {$to.=$row2['mail'].';';}
				$qry2->closeCursor();
			} 
		} else {
			//get tech mail 
			$qry = $db->prepare("SELECT * FROM tusers WHERE id=:id");
			$qry->execute(array('id' => $_POST['technician']));
			$techrow=$qry->fetch();
			$qry->closeCursor();
			$to=$techrow['mail'];
		}
        //find user name
        $qry = $db->prepare("SELECT * FROM tusers WHERE id=:id");
        $qry->execute(array('id' => $uid));
        $userrow=$qry->fetch();
        $qry->closeCursor();
		
		//check if tech have mail
		if($to) 
		{
			$object=T_('Le ticket').' n°'.$_GET['id'].': '.$_POST['title'].' '.T_('vous a été attribué');
			//remove single quote in post data
			$description = str_replace("'", "", $_POST['description']);
			$title = str_replace("'", "", $_POST['title']);
			$message = '
			'.T_('Le ticket').' n°'.$_GET['id'].' '.T_('a été déclaré par l\'utilisateur').' '.$userrow['lastname'].' '.$userrow['firstname'].'. <br />
			<br />
			<u>'.T_('Objet').':</u><br />
			'.$title.'<br />		
			<br />	
			<u>'.T_('Description').':</u><br />
			'.$description.'<br />
			<br />
			'.T_('Pour plus d\'informations vous pouvez consulter le ticket sur').' <a href="'.$rparameters['server_url'].'/index.php?page=ticket&id='.$_GET['id'].'">'.$rparameters['server_url'].'/index.php?page=ticket&id='.$_GET['id'].'</a>.
			';
			$mail_auto=true;
			require('./core/message.php');
		} else {if($rparameters['debug']==1) {echo "technician mail is empty or no technician associated or tech group no change on this ticket";}}

}