[MOD] Client's Phone Auto-Filled-In

masino_sinaga

Hi again,

I am currently using osTicket v1.6 RC4, and in this version, when a Staff add new ticket by typing some characters of client's email, there will be appear a pop-up list box that contains of list of client's email and name. And when a Staff click on one of some items in the list, the email and the name textbox on that form will be filled-in based on the item that Staff click. But not with the phone textbox! :(

So I made a modification in order the client's phone number also will be filled-in automatically based on the item that a Staff click on the pop-up list box. :)

As usual, let's getting started now!

Open \include\staff\newticket.inc.php file, and FIND:

<td><input type="text" name="phone" size="25"

REPLACE WITH:

<td><input type="text" id="phone" name="phone" size="25"

FIND:

callback: function (obj) { document.getElementById('email').value = obj.id; document.getElementById('name').value = obj.info; return false;}

REPLACE WITH:

callback: function (obj) {

document.getElementById('email').value = obj.id;

document.getElementById('name').value = obj.info.substring(0, obj.info.indexOf('|'));

document.getElementById('phone').value = obj.info.substring(obj.info.indexOf('|') + 1);

return false;

}

Open \include\ajax.tickets.php, and FIND:

$sql='SELECT DISTINCT email,name FROM '.TICKET_TABLE.' WHERE email LIKE \''.$input.'%\' ORDER BY created LIMIT '.$limit;

REPLACE WITH:

$sql='SELECT DISTINCT email,name,phone FROM '.TICKET_TABLE.' WHERE email LIKE \''.$input.'%\' ORDER BY created LIMIT '.$limit;

FIND:

while(list($email,$name)=db_fetch_row($resp)) {

REPLACE WITH:

while(list($email,$name,$phone)=db_fetch_row($resp)) {

FIND:

$items ='{"id": "'.$email.'", "value": "'.$email.'", "info": "'.$name.'"}';

REPLACE WITH:

$items ='{"id": "'.$email.'", "value": "'.$email.'", "info": "'.$name.'|'.$phone.'"}';

That's all, everyone.

Now test your "New Ticket" form from Staff Panel, and enjoy the result! I hope this will be helpful for all of you.

Cheers!

Best regards,

Masino Sinaga

rogden21

Great MOD

I love the use of the autosuggest. In another MOD, I've added a drop down table which I grab some name, email, and phone from as well as open tickets.

Do you have any suggestions as how to add autosuggest on the client side?

I've also placed a trigger in the database that will automatically add a name, email, and phone to the clients table. Keep in mind, I adjusted my clients table to receive full name, as opposed to firstname, lastname.

MySQL Trigger:

delimiter |

CREATE TRIGGER trig_add_client AFTER INSERT ON ost_ticket

FOR EACH ROW

BEGIN

DECLARE ex_client int;

SELECT COUNT(*) INTO ex_client FROM ost_clients WHERE email = NEW.email;

IF ex_client = 0 THEN

INSERT INTO ost_clients (email, name, phone, is_active) values(NEW.email, NEW.name, NEW.phone, 1);

END IF;

END|

delimiter ;

/include/ajax.tickets.php autosuggest query

$sql='SELECT DISTINCT email,name,phone FROM ost_clients WHERE email LIKE \'%'.$input.'%\'

UNION

SELECT DISTINCT email,name,phone

FROM '.TICKET_TABLE.'

WHERE email LIKE \''.$input.'%\'

ORDER BY email

LIMIT '.$limit;

$resp=db_query($sql);

if($resp && db_num_rows($resp)){

while(list($email,$name,$phone)=db_fetch_row($resp)) {

$name=(strpos($name,'@')===false)?$name:'';

$items ='{"id": "'.$email.'", "value": "'.$email.'", "info": "'.$name.'|'.$phone.'"}';

}

$result= '{"results": }';

return $result;

}

trbn

hey,

thank you for this MOD! It works!

How is it possible to add a third field which fills automatically?

If I insert the code a second time with another variable, it will not work correctly! It fills the 'phone field' with both variables instead of filling the right field for the other variable...:(

Any solution?

Thanks,

Torben

trbn

I'm sorry for pushing, but I need help with that...:

Thanks,

Torben