echo $bug['bug_id'];
?>
</a></td>
<td><a href="bug.php?bug_id=<?php
echo $bug['bug_id'];
?>
"><?php
echo $bug['bug_name'];
?>
</a></td>
<td><?php
echo $bug['cat_name'];
?>
</td>
<td><?php
echo getprioritytext($bug['priority']);
?>
</td>
<td><?php
echo $bug['assign_to'];
?>
</td>
<td><?php
echo getstatetext($bug['state']);
?>
</td>
<td><?php
echo fundatetime($bug['submitted_date']);
?>
</td>
<td><?php
$priority = $_POST['priority'];
$cat_id = $_POST['cat_id'];
$assign_to = $_POST['assign_to'];
$now = time();
if ($bug_name != '' && $bug_text != '') {
$reponse = $conn->query('INSERT INTO bugs(bug_name, bug_text, submitted_by, submitted_date, last_date, priority, state, cat_id, assign_to) VALUES("' . $bug_name . '", "' . $bug_text . '", "' . $submitted_by . '", ' . $now . ', ' . $now . ', ' . $priority . ', 0, ' . $cat_id . ', ' . $assign_to . ');');
$reponse = 'ok';
$bug_id = $conn->query('SELECT MAX(bug_id) AS opened_bug_id FROM bugs');
$bug_id = mysqli_fetch_assoc($bug_id);
$bug_id = $bug_id['opened_bug_id'];
$mail_pref = $conn->query('SELECT email, notification FROM users WHERE user_id=' . $assign_to . ' LIMIT 1;');
$mail_pref = mysqli_fetch_assoc($mail_pref);
if ($mail_pref['notification'] == 1) {
$mail_to = $mail_pref['email'];
$mail_subject = "LSB - Nouveau : {$bug_name}";
$mail_text = "Bonjour, <br /> Un nouveau bug vient d'être créé !<br />Sujet : {$bug_name} <br />Priorité : " . getprioritytext($priority);
sendmail($mail_to, $mail_subject, $mail_text);
}
// Fin if ( $mail_pref['notification'] == 1 )
} else {
$reponse = 'Les champs sont vides';
}
} else {
$reponse = 'Tous les champs ne sont pas parvenus';
}
//echo json_encode(['reponse' => $reponse]);
echo json_encode(['reponse' => $reponse, 'bug_id' => $bug_id]);
}
// Fin if ($_POST['function'] == "ajouterlien")
if ($_POST['function'] == "addcomm") {
if (isset($_POST['comm_text']) && isset($_POST['bug_id']) && is_numeric($_POST['bug_id']) && is_numeric($_SESSION['user_id'])) {
?>
</select>
</td></tr>
<tr><td align="right">
<label>Priorité : </label>
</td><td>
<select name="priority">
<?php
for ($i = 1; $i <= 5; $i++) {
?>
<option value="<?php
echo $i;
?>
"><?php
echo getprioritytext($i);
?>
</option>
<?php
}
?>
</select>
</td></tr>
<tr><td colspan="2" align="center" ><input type="submit" value="Valider le bug" /></td></tr>
</table>
</form>
</div>
