<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title>سیستم تیکت پشتیبانی - ارسال تیکت جدید</title>
</head>
<body dir="rtl" bgcolor="#FFFFCC">
<div class="content" style="background-color:#FFC; border:none;"><a href="list-ticket.php"><input type="button" style="height:50px; width:200px;" value="لیست تیکت های ارسال شده" /></a></div>
<div class="content">
<form method="post">
<table>
<tr>
لطفا واحد سازمانی خود را به دقت انتخاب نمایید:
<br>
<select name="organ">
<option value="1">اداری</option>
<option value="2">مالی</option>
<option value="3">آموزش</option>
</select>
</tr>
<br>
<tr>
: نوع خدمات مورد درخواست
</tr>
<tr>
<br>
<input type="checkbox" name="request[]" value="internet">Internet
<br>
<input type="checkbox" name="request[]" value="software">Software
<br>
<input type="checkbox" name="request[]" value="hardware">Harware
<br>
<input type="checkbox" name="request[]" value="network">Network
<br>
<input type="checkbox" name="request[]" value="trouble">Troubleshooting
</tr>
<tr>
<td> سایر موارد با توضیحات کامل: </td>
</tr>
<tr>
<td>عنوان</td>
<td><input type="text" name="txt_subject"/></td>
</tr>
<tr>
<td>پیام</td>
<td><textarea name="txt_message"></textarea></td>
</tr>
</table>
<center>
<input class="button" name="submit" type="submit" value="ارسال" />
<input class="button" type="reset" value="پاک کردن" />
</center>
<br />
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['submit'])){
include ('../connection.php');
$subject = $_POST['txt_subject'];
$message = $_POST['txt_message'];
$organ = $_POST['organ'];
$checkbox1 = $_POST['request'];
$chk="";
foreach($checkbox1 as $chk1)
{
$chk.= $chk1.",";
}
session_start();
$email = $_SESSION['email'];
$sql = "select NumberTicket from ticket where email='".$email."' Order By NumberTicket " ;
$q = $connection -> query($sql);
$q -> setFetchMode(PDO::FETCH_ASSOC);
while($r = $q->Fetch()):
$NumberTicket = $r['NumberTicket'];
endwhile;
$NumberTicket++;
$sql = "INSERT INTO ticket(NumberTicket,email,subject,message,organ,re quest) VALUES ('$NumberTicket','$email','$subject','$message','$ organ','$chk') " ;
$connection -> exec($sql);
?>
<script type="text/javascript">alert("پیام شما با موفقیت ارسال شد")</script>
<?php
}
?>