Forum GestSup

Code : Tout sélectionner

//check if subject has a category between []
$sujetCategory = '';
$categoryId = 0; //default category
if(preg_match('/\[(.*?)\]/', $subject, $sujetCategory) == 1)  
{
	//get categorys 
	$qry=$db->prepare("SELECT `id`,`name` FROM `tcategory`");
	$qry->execute();
	$rows=$qry->fetchAll();

	//search if category of the subject is in the categorys
	foreach($rows as $row)
	{
		if($sujetCategory[1] == $row['name']) // if the first occurence found in the subject matches, get the category id
		{
			$categoryId = $row['id'];
			break;
		}
	}
}

$qry=$db->prepare("INSERT INTO `tincidents` (`user`,`technician`,`title`,`description`,`date_create`,`techread`,`state`,`criticality`,`disable`,`place`,`creator`,`category`) 
VALUES (:user,'0',:title,'',:date_create,'0',:state,'4','0','0',:creator,:category)");
$qry->execute(array('user' => $user_id,'title' => $subject,'date_create' => $datetime,'state' => $rparameters['ticket_default_state'],'creator' => $user_id, 'category' => $categoryId));