Support Departments Dropdown

[skshost]

I didn't like that extra step of selecting the department before you write up a ticket, so I just linked directly to: submitticket.php?step=2 from the homepage. I removed the hidden form input(deptid) and replaced where it showed the department with this:

<select name="deptid">
{foreach item=department from=$departments}
<option value ="{$department.id}">{$department.name}</option>
{/foreach}
</select>

 

Of course I had to pass it all to smarty first:

{php}

$i=0; 
$client_query = "SELECT * FROM tblticketdepartments WHERE hidden != 'on' ORDER BY id";
$result = mysql_query($client_query);
  while($row = mysql_fetch_array($result))
        {

        $tktdepart_array[$i]['id'] = $row['id'];
        $tktdepart_array[$i]['name'] = $row['name'];
        $i++;
        }

//Pass the values to smarty   
$this->assign('departments',$tktdepart_array); 


{/php} 

 

I just thought some here mite make some use of it.

[skshost]

Updated to not show hidden departments.

[Nathan123]

Updated to not show hidden departments.

 

This works great, Thanks SksHost.

[AVeal]

Where do you put the smarty code upon the page?

[skshost]

On supportticketsubmit-steptwo.tpl

[generic]

nice work, just wish it would show them in the same order as whmcs allows you to set them to, i tried a few changes, but cant get that to work.

[MACscr]

all you have to do is change the ORDER BY part in the mysql statement. I dont know off the top of my head what name of that field is though that does the ordering.

[mstorman]

Very nice... I think this should become part of the default installation.

 

Matthew.

[generic]

i tried using this, but it didnt work

 

{foreach key=num item=department from=$departments}

[SpookedOut]

Got your .tpl file? This is quite confusing for people who don't know how to do it!

 

Just my 2.34523424542 cents

[BionHostStan]

can I get a demo please?

[SpookedOut]

There is no demo currently. I do however, have a working example please PM me if you would like to see it

[Daniel]

Have I got this right?

 

It doesnt seem to show the drop down for me..

 

{if $errormessage}


<font color=#cc0000>{$LANG.clientareaerrors}</font></p>
<ul>
{$errormessage}
[/list]
{/if}

<form method="post" action="{$SERVER.PHP_SELF}?step=3" enctype="multipart/form-data">


<table>
<tr><td width=120>{$LANG.supportticketsclientname}</td><td>{if $loggedin}{$clientname}{else}<input type="text" name="name" size=30 value="{$name}">{/if}</td></tr>
<tr><td>{$LANG.supportticketsclientemail}</td><td>{if $loggedin}{$email}{else}<input type="text" name="email" size=50 value="{$email}">{/if}</td></tr>
{php}

$i=0;
$client_query = "SELECT * FROM tblticketdepartments WHERE hidden != 'on' ORDER BY id";
$result = mysql_query($client_query);
  while($row = mysql_fetch_array($result))
        {

        $tktdepart_array[$i]['id'] = $row['id'];
        $tktdepart_array[$i]['name'] = $row['name'];
        $i++;
        }

//Pass the values to smarty   
$this->assign('departments',$tktdepart_array);


{/php} 
<tr><td>{$LANG.supportticketsticketsubject}</td><td><input type="text" name="subject" size=60 value="{$subject}"></td></tr>
<tr><td>{$LANG.supportticketsticketurgency}</td><td><select name="urgency"><option value="Low">{$LANG.supportticketsticketurgencylow}<option value="Medium" selected>{$LANG.supportticketsticketurgencymedium}<option value="High">{$LANG.supportticketsticketurgencyhigh}</select></td></tr>
</table>




<textarea name="message" rows=12 style="width:100%">{$message}</textarea>



{if $customfields}<table>{/if}
{foreach key=num item=customfield from=$customfields}
<tr><td width=120>{$customfield.name}</td><td>{$customfield.input} {$customfield.required}</td></tr>
{/foreach}
{if $customfields}</table>
{/if}

{$LANG.supportticketsticketattachment}: <input type="file" name="attachment" style="width:80%">
({$LANG.supportticketsallowedextensions}: {$allowedfiletypes})

<P ALIGN="center"><input type="submit" value="{$LANG.supportticketsticketsubmit}"></P>

</form>

[angelcosta]

I just realized that if you use this as is, you wont be able to see the custom fields for each department.

Is there a fix?