Auto fill new ticket details

kyle4812

I've got the drop down box setup working which pulls users details from AD.

But what im really after is osticket to auto fill the details on the new ticket form.

I'm sure someone that knows a little about php could point me in the right direction.

I've currently got php to conenct via ldap to AD, the issue im having is pulling the currently logged in users details and filling the input boxes.

all details, name/email/number are all filled out in AD so it wouldn't be an issue once i got the script correct.

Can anyone assist ?

Thanks

kyle4812

Looks like i've solved this one myself.

Took some time but got there.

AzNWiLL5o4

Looks like i've solved this one myself.
Took some time but got there.

Hi Kyle,

May I asked how did you accomplished this as I am trying to do the exact same thing. I have been at it for a month now with no resolution.

Thanks!

kyle4812

I thought someone might ask!

I also spent a few weeks on this with having close to no php knowledge.

I used a combination of adLDAP and mod_auth_sspi with this code, its not the best but it works well/

<?php require('c:/xampp/htdocs/includes/adLDAP.php'); ?>

<?php

$cred = explode('\\',$_SERVER);

if (count($cred) == 1) array_unshift($cred, "(no domain info – perhaps SSPIOmitDomain is On)");

list($domain, $user) = $cred;

$ldap=new adLDAP($options);

if (1){

$result = $ldap->user_info($user,array("displayname"));

$_SESSION = $result;

$fullname = $_SESSION;

$splitname = explode(',', $fullname);

$resultm = $ldap->user_info($user,array("mail"));

$mail = $resultm;

$resultt = $ldap->user_info($user,array("telephonenumber"));

$tele = $resultt;

echo $splitname

echo $mail

echo $tele

}

?>

AzNWiLL5o4

I thought someone might ask!
I also spent a few weeks on this with having close to no php knowledge.
I used a combination of adLDAP and mod_auth_sspi with this code, its not the best but it works well/
<?php require('c:/xampp/htdocs/includes/adLDAP.php'); ?>
<?php
$cred = explode('\\',$_SERVER);
if (count($cred) == 1) array_unshift($cred, "(no domain info – perhaps SSPIOmitDomain is On)");
list($domain, $user) = $cred;
$ldap=new adLDAP($options);
if (1){

$result = $ldap->user_info($user,array("displayname"));
$_SESSION = $result;
$fullname = $_SESSION;
$splitname = explode(',', $fullname);
$resultm = $ldap->user_info($user,array("mail"));
$mail = $resultm;
$resultt = $ldap->user_info($user,array("telephonenumber"));
$tele = $resultt;
echo $splitname
echo $mail
echo $tele
}
?>

Kyle, I am sorry to ask such a noobie question, but where would you put this piece of code at? Is it possible to have a little bit more details when you have some time.

Thanks!

kyle4812

This will be brief, but i hope it helps.

Download and install per instructions ADLDAP 2.1 (http://adldap.sourceforge.net/download.php)

Edit adldap.php and put in your AD details.

Install mod_auth_sspi-1.0.4-2.2.2 per instructions into the php folder and make sure you add it to your apache config.

LoadModule sspi_auth_module modules/mod_auth_sspi.so

In \include\client\open.inc.php

add the above code to the head of the file.

and create a new ticket, on the new ticket page it should display your details.

It might look a bit messed up but if they are there then its a good start.

If there is nothing listed of the page doesn’t load correctly then you have and issue and you might want to go back a few steps and check through the docos.

Comment out the echo lines and go down to your input boxes and enter the echo line(without 'echo') into the values.

Do this for name, email and phone.

<td><input type="text" name="phone" size="25" value="<?=$tele?>">

Let me know if you need any other help, and ill try and get some time to write something up!

fredrikivansson

I have solved this by creating a LDAP lookup script which is called from a onchange event on the client side of open.inc.php.

I have created a new field called "userid" in the system which is the AD id for the user.

open.inc.php:

" onchange="updateUsername();" onblur="updateUsername();">

And at the end of the same file a javascript function using jquery which is called from the above:

function updateUsername(){

var returnldapdata;

var inputuserid = document.getElementById("userid").value;

var dataString = 'include/GetUserFromLdap.php?signum='+ inputsignum;

$.ajax({

type: "POST",

url: dataString,

success: function(returnedData) {

returnldapdata = $.parseJSON(returnedData); // store the data values inside the data var.

if ( returnldapdata.Error ) {

alert(returnldapdata.Error + ": " + inputuserid + " does not exists, please try again!");

document.getElementById("userid").value = "";

document.getElementById("name").value = "";

document.getElementById("email").value = "";

}

else {

document.getElementById("name").value = returnldapdata.fullname+"";

document.getElementById("email").value = returnldapdata.email+"";

}

});

}

I have the Name & Email fields still visible in the page but they are set to readonly.