PDA

View Full Version : modified client open ticket


jpowers40828
01-09-2008, 04:35 AM
I am planning on using osTicket for internal company support. I have created a query in order to fill a drop down list. The query fills the drop down list properly. However, I would like email and phone number information filled in automatically after selecting a user. I'm not sure on how to approach this at all. Any help at all is greatly appreciated. I'm also having a problem when I submit the ticket. The information shows up on the server, but the client never returns back to anything, it only leaves a blank page.

<?php
if(!defined('OSTCLIENTINC')) die('Kwaheri rafiki wangu?'); //Say bye to our friend..

$info=($_POST && $errors)?$_POST:array(); //on error...use the post data
?>
<div>
<?if($errors['err']) {?>
<p align="center" id="errormessage"><?=$errors['err']?></p>
<?}elseif($msg) {?>
<p align="center" id="infomessage"><?=$msg?></p>
<?}elseif($warn) {?>
<p id="warnmessage"><?=$warn?></p>
<?}?>
</div>
<div>Please fill in the form below to open a new ticket.</div><br>
<form action="open.php" method="POST" enctype="multipart/form-data">
<table align="left" cellpadding=2 cellspacing=1 width="90%">
<tr>
<th width="20%">Full Name:</th>
<td>
<select name="name">
<option value="0">Select One</option>
<?$services= db_query('SELECT firstname,lastname,email,phone FROM '.STAFF_TABLE.' WHERE isactive=1 ORDER BY firstname');
while (list($firstname,$lastname,$emailtmp,$phonetmp) = db_fetch_row($services)){?>
<option value="<?=$firstname?> <?=$lastname?>"><?=$firstname?> <?=$lastname?></option>
<?}?>
</select>
&nbsp;<font class="error">*&nbsp;<?=$errors['name']?></font>
</td>
</tr>
<tr>
<th nowrap >Email Address:</th>
<td>
<?if ($thisclient && ($email=$thisclient->getEmail())) {
?>
<input type="hidden" name="email" size="25" value="<?=$email?>"><?=$email?>
<?}else {?>
<input type="text" name="email" size="25" value="<?=$info['email']?>">
<?}?>
&nbsp;<font class="error">*&nbsp;<?=$errors['email']?></font>
</td>
</tr>
<tr>
<th>Help Topic:</th>
<td>
<select name="topicId">

<?
$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');
while (list($topicId,$topic) = db_fetch_row($services))
{
$selected = ($info['topicId']==$topicId)?'selected':''; ?>
<option value="<?=$topicId?>"<?=$selected?>><?=$topic?></option>
<?}?>

</select>
&nbsp;<font class="error">*&nbsp;<?=$errors['topicId']?></font>
</td>
</tr>
<tr>
<th>Subject:</th>
<td>
<input type="text" name="subject" size="35" value="<?=$_REQUEST[subject]?>">
&nbsp;<font class="error">*&nbsp;<?=$errors['subject']?></font>
</td>
</tr>
<tr>
<th valign="top">Message:</th>
<td>
<? if($errors['message']) {?> <font class="error"><b>&nbsp;<?=$errors['message']?></b></font><br/><?}?>
<textarea name="message" cols="35" rows="8" wrap="soft" style="width:85%"><?=$info['message']?></textarea></td>
</tr>
<?
if($cfg->allowPriorityChange() ) {
$sql='SELECT priority_id,priority_desc FROM '.TICKET_PRIORITY_TABLE.' WHERE ispublic=1 ORDER BY priority_urgency DESC';
if(($priorities=db_query($sql)) && db_num_rows($priorities)){ ?>
<tr>
<th>Priority:</th>
<td>
<select name="pri">
<?
while($row=db_fetch_array($priorities)){ ?>
<option value="<?=$row['priority_id']?>" <?=$info['pri']==$row['priority_id']?'selected':''?> ><?=$row['priority_desc']?></option>
<?}?>
</select>
</td>
</tr>
<? }
}?>

<?if(($cfg->allowOnlineAttachments() && !$cfg->allowAttachmentsOnlogin())
|| ($cfg->allowAttachmentsOnlogin() && ($thisclient && $thisclient->isValid()))){

?>
<tr>
<th>Attachment:</th>
<td>
<input type="file" name="attachment"><font class="error">&nbsp;<?=$errors['attachment']?></font>
</td>
</tr>
<?}?>
<tr height=2px><td align="left" colspan=2 >&nbsp;</td</tr>
<tr>
<td></td>
<td>
<input class="button" type="submit" name="submit_x" value="Create Ticket">
<input class="button" type="reset" value="Reset">
<input class="button" type="button" name="cancel" value="Cancel" onClick='window.location.href="index.php"'>
</td>
</tr>
</table>
</form>