Mod: DB populated drop down

PleXy

Hey there!

I'm currently adding a MOD called "How to add a db populated drop down and admin interface" on my osTicket.

You can find it on http://www.tmib.net/content/osticket-16-how-add-db-populated-drop-down-and-admin-interface-version-10(http://www.tmib.net/content/osticket-16-how-add-db-populated-drop-down-and-admin-interface-version-10)

Everything's good but I want to add this info to the open tickets overview (tickets.inc.php)

Though I can't get it to work... I added the same code as on the viewticket one:

<?

// need to take $ticket->getAgency and convert it into its name from the ost_agencies table

$agencies= db_query('SELECT agency FROM ost_agencies WHERE id='.$ticket->getAgency().'');

$agency = db_fetch_row($agencies); ?>

<?=Format:($agency);?><? }?>

But it messes up the table and it won't show any info...

Anyone got a clue on how I should do?

Thanks!

PleXy

Anyone please?

Beardy

What are you wanting the drop-down list to be populated with? The code in your post is attempting to grab an ID from the $ticket variable, which isn't set on tickets.inc.php.

PleXy

Heya,

I don't really want it to populate with anything.

I'm just jusing it for having an extra drop-down that the customers can choose.

I want the chosen drop-down to be seen in the open tickets overview.

It shows which drop-down the agent chose on the SCP viewticket. But when I add the same code into open tickets it just won't work.

Thanks for the help!

PleXy

I tried to just add <?=Format:($row)?> and I got no error. Though it only showed the ID's of the agencies.

So you're right, I need the $ticket variable set on tickets.inc.php to be be able to convert the ID to its name.

I would be really happy if you could help me with what I should write in my tickets.inc.php.

Thanks alot!

PleXy

Bump.......

ntozier

Have you put anything into the ost_agencies table and made all the changes listed?

PleXy

Heya,

Yes I did all those changes. And everything works, the drop down Agencies work fine.

Except that I want it to show up on the Open tickets table for each ticket. That's what I can't get to work :(

Thanks

PleXy

Anyone? :/

PleXy

Bump..... :)

PleXy

Bump...

I tried this:

<? $agencies=$ticket->getAgency();

if ( $agencies == 1 ) { ?> ASD <?} ?>

But this doesn't work either...

Anyone who can guide me?

PleXy

I solved it with this code, not the best but at least it works. :)

<? $arendestatus = Format:($row);

if ( $arendestatus == 1 ) { ?> Ej vald <?}

elseif ( $arendestatus == 2 ) { ?> Inväntar svar från DHL <?}

elseif ( $arendestatus == 3 ) { ?> Inväntar svar från kund <?}

elseif ( $arendestatus == 5 ) { ?> Inväntar svar från leverantör <?}

elseif ( $arendestatus == 6 ) { ?> Inväntar svar från produktchef <?}

elseif ( $arendestatus == 7 ) { ?> Inväntar svar från inköp <?}

elseif ( $arendestatus == 8 ) { ?> Inväntar svar från lager <?}

elseif ( $arendestatus == 9 ) { ?> Inväntar faktura <?}

elseif ( $arendestatus == 10 ) { ?> Inväntar kredit fr leverantör <?}

elseif ( $arendestatus == 11 ) { ?> Inväntar svar från lager <?}

else { ?>Ej vald<? }

?>

PleXy

I was thinking about this function in class.ticket.php.

Though it doesn't work, anyone have a clue?

function getAgencyname() {

$agencies= db_query('SELECT agency FROM ost_agencies WHERE id='.$ticket->getAgency().'');

$agency = db_fetch_row($agencies);

Format:($agency);

}

If I can solve this the "proper" way it means alot less coding...

Thanks in advance.

ntozier

What does your mysql error log say the error is?

It could be as simple as you using a different table prefix (ie not the ost_ prefix).

PleXy

What does your mysql error log say the error is?
It could be as simple as you using a different table prefix (ie not the ost_ prefix).

Thanks for your reply!

Strange thing is that I don't get any error in the log at all.

When I use the code below it just won't show anything at all after this code, all the HTML and PHP codes are gone.

<?=$ticket->getSaljkanalnamn()?>

PleXy

Bump! Anyone?