Custom related dropdown field with Admin Interface

sandeep.bodh

Following this link: http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st#comment-form(http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st#comment-form)

Please help

ntozier

Please help with what?

sandeep.bodh

How to create custom related dropdown fields in ticket form ?

I am following the link as mentioned but not getting it. Can you help me ?

ntozier

The link should be:

http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st(http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st)

But the one you put in works for me. Note: you have to be logged into that site to leave comments.

You have to go to the link and follow the directions step by step. It involves either

1. editing a handful of files

2. if you have not modified your osTicket files preciously using the included edited files.

Can you be more specific with what part of that you need assistance with?

sandeep.bodh

Dear ntozier,

Thanks for the reply.

I did it and found it working properly. But i cannot post it here because the steps are too large and the message space is limited. So tell me where to post it.

ntozier

Where should you post what?

I recommend posting things on the forums.

sandeep.bodh

Custom related dropdown field with Admin Interface - Sandeep Bodh

Follow this link: http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st#comment-form(http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st#comment-form)

Steps:

Suppose if you want to create a custom Area field and State field, follow these steps:

1. Create a table in database with the following query:

CREATE TABLE IF NOT EXISTS `ost_areas` (

`area_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`state_id` tinyint(3) unsigned NOT NULL DEFAULT '0',

`area` varchar(255) NOT NULL,

`addDate` datetime NOT NULL,

`isenabled` tinyint(1) unsigned NOT NULL,

`editor` varchar(25) DEFAULT NULL,

`upDate` datetime DEFAULT NULL,

`notes` varchar(255) NOT NULL,

PRIMARY KEY (`area_id`),

FULLTEXT KEY `area` (`area`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=11 ;

And Insert record in it:

INSERT INTO `ost_areas` (`area_id`, `state_id`, `area`, `addDate`, `isenabled`, `editor`, `upDate`, `notes`) VALUES

(10, 8, 'Area 2', '2013-08-06 09', 1, NULL, '2013-08-06 09', ''),

(9, 10, 'Area 1', '2013-08-06 09', 1, NULL, '2013-08-06 09', '');

Next we need to add a field to the ost_ticket table that will hold the area_id.

ALTER TABLE `DATABASENAME`.`ost_ticket` ADD COLUMN `area_id` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `updated`;

CREATE TABLE IF NOT EXISTS `ost_states` (

`state_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`state` varchar(255) NOT NULL,

`addDate` datetime NOT NULL,

`isenabled` tinyint(1) unsigned NOT NULL,

`editor` varchar(25) DEFAULT NULL,

`upDate` datetime DEFAULT NULL,

`notes` varchar(255) NOT NULL,

PRIMARY KEY (`state_id`),

FULLTEXT KEY `state` (`state`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=11 ;

INSERT INTO `ost_states` (`state_id`, `state`, `addDate`, `isenabled`, `editor`, `upDate`, `notes`) VALUES

(8, 'Mumbai', '2013-08-06 09', 1, NULL, '2013-08-06 09', ''),

(10, 'Delhi', '2013-08-06 09', 0, NULL, '2013-08-06 09', '');

2. Modify the files:

a. Edit /include/client/open.inc.php

State:

Select State

$states= db_query('SELECT state_id,state FROM '.TABLE_PREFIX.'states ORDER BY state');

while (list($stateId,$state) = db_fetch_row($states)){

$ck=($info==$stateId)?'selected':''; ?>

" <?=$ck?>><?=$state?>

}?>

* <?=$errors?>

Area:

Select Area

if ($info=='' || is_null($info)) { $info='0'; }

$areas= db_query('SELECT area_id,area FROM '.TABLE_PREFIX.'areas WHERE isenabled=1 AND state_id = '.$info.' ORDER BY area');

while (list($areaId,$area) = db_fetch_row($areas)){

$ck=($info==$areaId)?'selected':''; ?>

" <?=$ck?>><?=$area?>

}?>

* <?=$errors?>

b. edit /include/class.ticket.php

.' LEFT JOIN '.DEPT_TABLE.' dept ON (ticket.dept_id=dept.dept_id) '

Add after this

.' LEFT JOIN ost_areas area ON (ticket.area_id=area.area_id) '

.' LEFT JOIN ost_states state ON (ticket.state_id=state.state_id) '

function getNumber() {

return $this->number;

}

Add after this

function getArea() {

return $this->ht;

}

function getState() {

return $this->ht;

}

function getUpdateInfo() {

$info=array('name' => $this->getName(),

Add after this

'area' => $this->getArea(),

'state' => $this->getState(),

$fields = array('type'=>'email', 'required'=>1, 'error'=>'Valid email required');

Add after this

$fields = array('type'=>'string', 'required'=>1, 'error'=>'Area Name required');

$fields = array('type'=>'string', 'required'=>1, 'error'=>'State Name required');

$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '

Add after this

.' ,area_id='.db_input($vars)

.' ,state_id='.db_input($vars); // (remove ; if not adding in last)

$id=0;

$fields=array();

Add after this

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Area Name required');

$fields = array('type'=>'int', 'required'=>1, 'error'=>'State Name required');

$sql='INSERT INTO '.TICKET_TABLE.' SET created=NOW() '

Add after this

.' ,area_id='.db_input($vars)

.' ,state_id='.db_input($vars); // (check for ;)

c. edit /include/client/view.inc.php

Add this code where you want to display the field.

State:

$states= db_query('SELECT state FROM '.TABLE_PREFIX.'states WHERE state_id='.$ticket->getState().'');

$state = db_fetch_row($states);

<?=Format:($state);?>

Area:

$areas= db_query('SELECT area FROM '.TABLE_PREFIX.'areas WHERE area_id='.$ticket->getArea().'');

$area = db_fetch_row($areas);

<?=Format:($area);?>

d. edit /include/staff/ticket-open.inc.php

Add this code where you display the field in a ticket form.

State:

Select State

$states= db_query('SELECT state_id,state FROM '.TABLE_PREFIX.'states ORDER BY state');

while (list($stateId,$state) = db_fetch_row($states)){

$ck=($info==$stateId)?'selected':''; ?>

" <?=$ck?>><?=$state?>

}?>

* <?=$errors?>

Area:

Select Area

if ($info=='' || is_null($info)) { $info='0'; }

$areas= db_query('SELECT area_id,area FROM '.TABLE_PREFIX.'areas WHERE isenabled=1 AND state_id = '.$info.' ORDER BY area');

while (list($areaId,$area) = db_fetch_row($areas)){

$ck=($info==$areaId)?'selected':''; ?>

" <?=$ck?>><?=$area?>

}?>

* <?=$errors?>

Add this code after this:

function getXMLHTTP() { //fuction to return the xml http object

var xmlhttp=false;

try{

xmlhttp=new XMLHttpRequest();

}

catch(e) {

try{

xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");

}

catch(e){

try{

xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");

}

catch(e1){

xmlhttp=false;

}

return xmlhttp;

}

function getArea(strURL)

{

var req = getXMLHTTP(); // fuction to get xmlhttp object

if (req)

{

req.onreadystatechange = function()

{

if (req.readyState == 4) { //data is retrieved from server

if (req.status == 200) { // which reprents ok status

document.getElementById('areadiv').innerHTML=req.responseText;

}

else

{

alert("There was a problem while using XMLHTTP:\n");

}

req.open("GET", strURL, true); //open url using get method

req.send(null);

}

e. edit /include/staff/ticket-edit.inc.php

Repeat same step -d in this file.

f. edit /include/staff/ticket-view.inc.php

State:

$states= db_query('SELECT state FROM '.TABLE_PREFIX.'states WHERE state_id='.$ticket->getState().'');

$state = db_fetch_row($states); ?>

<?php echo Format:($state);?>

Area:

$areas= db_query('SELECT area FROM '.TABLE_PREFIX.'areas WHERE area_id='.$ticket->getArea().'');

$area = db_fetch_row($areas); ?>

<?php echo Format:($area);?>

For Admin Interface :

g. edit /include/class.nav.php

Search case 'manage':

Add after this $subnav=array('desc'=>'Areas','href'=>'areas.php','iconclass'=>'alert-settings');

$subnav=array('desc'=>'States','href'=>'states.php','iconclass'=>'alert-settings');

h. edit /upload/scp.php

change 'alerts' => 'Alerts and Notices Settings'); to 'alerts' => 'Alerts and Notices Settings',

Add next line

'states' => 'States',

'areas' => 'Areas');

To be continued................

See below mentioned steps to follow after this:

jose25886

No shows datas of table

The link should be:
http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st(http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st)
But the one you put in works for me. Note: you have to be logged into that site to leave comments.
You have to go to the link and follow the directions step by step. It involves either
1. editing a handful of files
or
2. if you have not modified your osTicket files preciously using the included edited files.
Can you be more specific with what part of that you need assistance with?

--------------------------------------------------------------------------

hello, thanks for your input, modify all files follow all the steps and did not work, when you load the page "NEW TICKET" appears AGENCY with Dropdown field but the data are not those of the database, when I deploy the field is "kbase" as an option, this is the part of the staff, and the client is in the AGENCY field shows "status" as an option, please can you tell me I'm doing wrong? Thanks in advance, and sorry for not mastered the English language, I speak Spanish apology.

sandeep.bodh

Custom related dropdown field with Admin Interface

3. Create new files and place inside staff directory:

a. Create file areaplan.inc.php and place this code:

<?php

if(!defined('OSTADMININC') || !$thisstaff || !$thisstaff->isAdmin()) die('Access Denied');

$info=array();

$qstr='';

if($area && $_REQUEST!='add'){

$title='Update Area';

$action='update';

$submit_text='Save Changes';

$info=$area->getInfo();

$info=$area->getId();

$qstr.='&id='.$area->getId();

}else {

$title='Add New Area';

$action='add';

$submit_text='Add Area';

$info=isset($info)?$info;

$qstr.='&a='.urlencode($_REQUEST);

}

$info=Format:(($errors && $_POST)?$_POST:$info);

" method="post" id="save">

<?php csrf_token(); ?>

Areas

<?php echo $title; ?>

Name:

* <?php echo $errors; ?>

Status:

>Active

>Disabled

Branch:

— Select Branch —

<?php

$sql='SELECT state_id,state FROM '.STATE_TABLE.' state ORDER by state';

if(($res=db_query($sql)) && db_num_rows($res)){

while(list($id,$name)=db_fetch_row($res)){

$selected=($info && $id==$info)?'selected="selected"':'';

echo sprintf('%s',$id,$selected,$name);

}

* <?php echo $errors; ?>

Admin Notes: Internal notes.

<?php echo $info; ?>

Create file stateplan.inc.php and place this code:

<?php

if(!defined('OSTADMININC') || !$thisstaff || !$thisstaff->isAdmin()) die('Access Denied');

$info=array();

$qstr='';

if($state && $_REQUEST!='add'){

$title='Update State';

$action='update';

$submit_text='Save Changes';

$info=$state->getInfo();

$info=$state->getId();

$qstr.='&id='.$state->getId();

}else {

$title='Add New State';

$action='add';

$submit_text='Add State';

$info=isset($info)?$info;

$qstr.='&a='.urlencode($_REQUEST);

}

$info=Format:(($errors && $_POST)?$_POST:$info);

" method="post" id="save">

<?php csrf_token(); ?>

States

<?php echo $title; ?>

Name:

* <?php echo $errors; ?>

Status:

>Active

>Disabled

Admin Notes: Internal notes.

<?php echo $info; ?>

sandeep.bodh

b. Create file areaplans.inc.php and place this code:

<?php

if(!defined('OSTADMININC') || !$thisstaff->isAdmin()) die('Access Denied');

$qstr='';

$sql='SELECT area.* '

.', state.state as state '

.' FROM '.AREA_TABLE.' area '

.' LEFT JOIN '.STATE_TABLE.' state ON (state.state_id=area.state_id) ';

$sql.=' WHERE 1';

$sortOptions=array('name'=>'area','status'=>'isenabled','state'=>'state','date'=>'addDate','updated'=>'upDate');

$orderWays=array('DESC'=>'DESC','ASC'=>'ASC');

$sort=($_REQUEST && $sortOptions[strtolower($_REQUEST)?strtolower($_REQUEST):'name';

//Sorting options...

if($sort && $sortOptions) {

$order_column =$sortOptions;

}

$order_column=$order_column?$order_column:'area';

if($_REQUEST && $orderWays[strtoupper($_REQUEST) {

$order=$orderWays[strtoupper($_REQUEST;

}

$order=$order?$order:'ASC';

if($order_column && strpos($order_column,',')){

$order_column=str_replace(','," $order,",$order_column);

}

$x=$sort.'_sort';

$$x=' class="'.strtolower($order).'" ';

$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM ost_areas area ');

$page=($_GET && is_numeric($_GET))?$_GET;

$pageNav=new Pagenate($total, $page, PAGE_LIMIT);

$pageNav->setURL('areas.php',$qstr.'&sort='.urlencode($_REQUEST).'&order='.urlencode($_REQUEST));

//Ok..lets roll...create the actual query

$qstr.='&order='.($order=='DESC'?'ASC':'DESC');

$query="$sql ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();

$res=db_query($query);

if($res && ($num=db_num_rows($res)))

$showing=$pageNav->showing().' Area';

else

$showing='No Area found!';

Areas

Add Area

<?php csrf_token(); ?>

<?php echo $showing; ?>

href="areas.php?<?php echo $qstr; ?>&sort=name">Name

href="areas.php?<?php echo $qstr; ?>&sort=status">Status

href="areas.php?<?php echo $qstr; ?>&sort=state">Branches

href="areas.php?<?php echo $qstr; ?>&sort=created">Date Added

href="areas.php?<?php echo $qstr; ?>&sort=updated">Last Updated

<?php

$total=0;

$ids=($errors && is_array($_POST))?$_POST;

if($res && db_num_rows($res)):

while ($row = db_fetch_array($res)) {

$sel=false;

if($ids && in_array($row,$ids))

$sel=true;

<?php echo $sel?'checked="checked"':''; ?>>

"><?php echo Format:($row); ?>

<?php echo $row?'Active':'Disabled'; ?>

"><?php echo $row; ?>

<?php echo Format:($row); ?>

<?php

} //end of while.

endif; ?>

<?php if($res && $num){ ?>

Select:

All

None

Toggle

<?php }else{

echo 'No Area found';

} ?>

<?php

if($res && $num): //Show options..

echo ' Page:'.$pageNav->getPageLinks().' ';

<?php

endif;

Please Confirm

Are you sure want to enable selected Area?

Are you sure want to disable selected Area?

Are you sure you want to DELETE selected Area?

Please confirm to continue.

sandeep.bodh

Create file stateplans.inc.php and place this code:

<?php

if(!defined('OSTADMININC') || !$thisstaff->isAdmin()) die('Access Denied');

$qstr='';

$sql='SELECT * FROM ost_states WHERE 1';

$sortOptions=array('name'=>'state','status'=>'isenabled','date'=>'addDate','updated'=>'upDate');

$orderWays=array('DESC'=>'DESC','ASC'=>'ASC');

$sort=($_REQUEST && $sortOptions[strtolower($_REQUEST)?strtolower($_REQUEST):'name';

//Sorting options...

if($sort && $sortOptions) {

$order_column =$sortOptions;

}

$order_column=$order_column?$order_column:'state';

if($_REQUEST && $orderWays[strtoupper($_REQUEST) {

$order=$orderWays[strtoupper($_REQUEST;

}

$order=$order?$order:'ASC';

if($order_column && strpos($order_column,',')){

$order_column=str_replace(','," $order,",$order_column);

}

$x=$sort.'_sort';

$$x=' class="'.strtolower($order).'" ';

$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM ost_states state ');

$page=($_GET && is_numeric($_GET))?$_GET;

$pageNav=new Pagenate($total, $page, PAGE_LIMIT);

$pageNav->setURL('states.php',$qstr.'&sort='.urlencode($_REQUEST).'&order='.urlencode($_REQUEST));

//Ok..lets roll...create the actual query

$qstr.='&order='.($order=='DESC'?'ASC':'DESC');

$query="$sql ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();

$res=db_query($query);

if($res && ($num=db_num_rows($res)))

$showing=$pageNav->showing().' State';

else

$showing='No State found!';

States

Add State

<?php csrf_token(); ?>

<?php echo $showing; ?>

href="states.php?<?php echo $qstr; ?>&sort=name">Name

href="states.php?<?php echo $qstr; ?>&sort=status">Status

href="states.php?<?php echo $qstr; ?>&sort=created">Date Added

href="states.php?<?php echo $qstr; ?>&sort=updated">Last Updated

<?php

$total=0;

$ids=($errors && is_array($_POST))?$_POST;

if($res && db_num_rows($res)):

while ($row = db_fetch_array($res)) {

$sel=false;

if($ids && in_array($row,$ids))

$sel=true;

<?php echo $sel?'checked="checked"':''; ?>>

"><?php echo Format:($row); ?>

<?php echo $row?'Active':'Disabled'; ?>

<?php echo Format:($row); ?>

<?php

} //end of while.

endif; ?>

<?php if($res && $num){ ?>

Select:

All

None

Toggle

<?php }else{

echo 'No State found';

} ?>

<?php

if($res && $num): //Show options..

echo ' Page:'.$pageNav->getPageLinks().' ';

<?php

endif;

Please Confirm

Are you sure want to enable selected State?

Are you sure want to disable selected State?

Are you sure you want to DELETE selected State?

Please confirm to continue.

sandeep.bodh

c. Create file settings-area.inc.php and place this code:

<?php

if(!defined('OSTSCPINC') or !is_object($thisuser) or !$thisuser->canManageKb()) die('Access Denied');

//List Products.

$select='SELECT * ';

$from='FROM ost_areas ';

//make sure the search query is 3 chars min...defaults to no query with warning message

if($_REQUEST=='search') {

if(!$_REQUEST || strlen($_REQUEST)

$errors='Search term must be more than 3 chars';

}else{

//fulltext search.

$search=true;

$qstr.='&a='.urlencode($_REQUEST);

$qstr.='&query='.urlencode($_REQUEST);

$where=' WHERE MATCH(area) AGAINST ('.db_input($_REQUEST).')';

//if($_REQUEST)

// $where.=' AND dept_id='.db_input($_REQUEST);

}

//I admit this crap sucks...but who cares??

$sortOptions=array('createdate'=>'addDate','updatedate'=>'upDate','title'=>'area');

$orderWays=array('DESC'=>'DESC','ASC'=>'ASC');

//Sorting options...

if($_REQUEST) {

$order_column =$sortOptions[$_REQUEST;

}

if($_REQUEST) {

$order=$orderWays[$_REQUEST;

}

$order_column=$order_column?$order_column:'area';

$order=$order?$order:'DESC';

$order_by=$search?'':" ORDER BY $order_column $order ";

$total=db_count('SELECT count(*) '.$from.' '.$where);

$pagelimit=$thisuser->getPageLimit();

$pagelimit=$pagelimit?$pagelimit; //true default...if all fails.

$page=($_GET && is_numeric($_GET))?$_GET;

$pageNav=new Pagenate($total,$page,$pagelimit);

$pageNav->setURL('area.php',$qstr.'&sort='.urlencode($_REQUEST).'&order='.urlencode($_REQUEST));

//Ok..lets roll...create the actual query

$query="$select $from $where $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();

//echo $query;

$replies = db_query($query);

$showing=db_num_rows($replies)?$pageNav->showing():'';

$results_type=($search)?'Search Results':'Areas';

$negorder=$order=='DESC'?'ASC':'DESC'; //Negate the sorting..

<?if($errors) {?>

<?=$errors?>

<?}elseif($msg) {?>

<?=$msg?>

<?}elseif($warn) {?>

<?=$warn?>

<?}?>

Search for: ">

<?=$result_type?> <?=$showing?>

<?=$qstr?>" title="Sort By Area <?=$negorder?>">Area

Status

Added On

<?=$qstr?>" title="Sort By Update Date <?=$negorder?>">Last Updated

$class = 'row1';

$total=0;

$grps=($errors && is_array($_POST))?$_POST;

if($replies && db_num_rows($replies)):

while ($row = db_fetch_array($replies)) {

$sel=false;

if($canned && in_array($row,$canned)){

$class="$class highlight";

$sel=true;

}elseif($replyID && $replyID==$row) {

$class="$class highlight";

}

" id="<?=$row?>">

" <?=$sel?'checked':''?>

onClick="highLight(this.value,this.checked);">

"><?=Format:(Format:($row,60))?>

<?=$row?'Active':'Disabled'?>

<?=Format:($row)?>

if($row == '0000-00-00 00') { echo " never "; }

else { echo "";?><?=Format:($row)?> <? } ?>

$class = ($class =='row2') ?'row1':'row2';

} //end of while.

else: //nothin' found!! ?>

">Query returned 0 results

endif; ?>

if(db_num_rows($replies)>0): //Show options..

Select:

All

Toggle

None

page:<?=$pageNav->getPageLinks()?>

onClick='return confirm("Are you sure you want to ENABLE selected entries?");'>

onClick='return confirm("Are you sure you want to DISABLE selected entries?");'>

onClick='return confirm("Are you sure you want to DELETE selected entries?");'>

endif;

sandeep.bodh

Create file settings-state.inc.php and place this code:

<?php

if(!defined('OSTSCPINC') or !is_object($thisuser) or !$thisuser->canManageKb()) die('Access Denied');

//List Products.

$select='SELECT * ';

$from='FROM ost_states ';

//make sure the search query is 3 chars min...defaults to no query with warning message

if($_REQUEST=='search') {

if(!$_REQUEST || strlen($_REQUEST)

$errors='Search term must be more than 3 chars';

}else{

//fulltext search.

$search=true;

$qstr.='&a='.urlencode($_REQUEST);

$qstr.='&query='.urlencode($_REQUEST);

$where=' WHERE MATCH(state) AGAINST ('.db_input($_REQUEST).')';

//if($_REQUEST)

// $where.=' AND dept_id='.db_input($_REQUEST);

}

//I admit this crap sucks...but who cares??

$sortOptions=array('createdate'=>'addDate','updatedate'=>'upDate','title'=>'state');

$orderWays=array('DESC'=>'DESC','ASC'=>'ASC');

//Sorting options...

if($_REQUEST) {

$order_column =$sortOptions[$_REQUEST;

}

if($_REQUEST) {

$order=$orderWays[$_REQUEST;

}

$order_column=$order_column?$order_column:'state';

$order=$order?$order:'DESC';

$order_by=$search?'':" ORDER BY $order_column $order ";

$total=db_count('SELECT count(*) '.$from.' '.$where);

$pagelimit=$thisuser->getPageLimit();

$pagelimit=$pagelimit?$pagelimit; //true default...if all fails.

$page=($_GET && is_numeric($_GET))?$_GET;

$pageNav=new Pagenate($total,$page,$pagelimit);

$pageNav->setURL('state.php',$qstr.'&sort='.urlencode($_REQUEST).'&order='.urlencode($_REQUEST));

//Ok..lets roll...create the actual query

$query="$select $from $where $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();

//echo $query;

$replies = db_query($query);

$showing=db_num_rows($replies)?$pageNav->showing():'';

$results_type=($search)?'Search Results':'States';

$negorder=$order=='DESC'?'ASC':'DESC'; //Negate the sorting..

<?if($errors) {?>

<?=$errors?>

<?}elseif($msg) {?>

<?=$msg?>

<?}elseif($warn) {?>

<?=$warn?>

<?}?>

Search for: ">

<?=$result_type?> <?=$showing?>

<?=$qstr?>" title="Sort By State <?=$negorder?>">State

Status

Added On

<?=$qstr?>" title="Sort By Update Date <?=$negorder?>">Last Updated

$class = 'row1';

$total=0;

$grps=($errors && is_array($_POST))?$_POST;

if($replies && db_num_rows($replies)):

while ($row = db_fetch_array($replies)) {

$sel=false;

if($canned && in_array($row,$canned)){

$class="$class highlight";

$sel=true;

}elseif($replyID && $replyID==$row) {

$class="$class highlight";

}

" id="<?=$row?>">

" <?=$sel?'checked':''?>

onClick="highLight(this.value,this.checked);">

"><?=Format:(Format:($row,60))?>

<?=$row?'Active':'Disabled'?>

<?=Format:($row)?>

if($row == '0000-00-00 00') { echo " never "; }

else { echo "";?><?=Format:($row)?> <? } ?>

$class = ($class =='row2') ?'row1':'row2';

} //end of while.

else: //nothin' found!! ?>

">Query returned 0 results

endif; ?>

if(db_num_rows($replies)>0): //Show options..

Select:

All

Toggle

None

page:<?=$pageNav->getPageLinks()?>

onClick='return confirm("Are you sure you want to ENABLE selected entries?");'>

onClick='return confirm("Are you sure you want to DISABLE selected entries?");'>

onClick='return confirm("Are you sure you want to DELETE selected entries?");'>

endif;

sandeep.bodh

d. Create file class.areas.php and place this code inside include folder:

<?php

class AREA {

var $id;

var $info;

function AREA($id) {

$this->id=0;

$this->load($id);

}

function load($id=0) {

if(!$id && !($id=$this->getId()))

return false;

$sql='SELECT * FROM ost_areas WHERE area_id='.db_input($id);

if(!($res=db_query($sql)) || !db_num_rows($res))

return false;

$this->ht=db_fetch_array($res);

$this->id=$this->ht;

return true;

}

function reload() {

return $this->load();

}

function getId() {

return $this->id;

}

function getStateId() {

return $this->ht;

}

function getarea() {

return $this->ht;

}

function getNotes() {

return $this->ht;

}

function getHashtable() {

return $this->ht;

}

function getInfo() {

return $this->getHashtable();

}

function isActive() {

return ($this->ht);

}

function update($vars,&$errors) {

if(!$this->save($this->getId(),$vars,$errors))

return false;

$this->reload();

return true;

}

function delete() {

global $cfg;

$sql='DELETE FROM ost_areas WHERE area_id='.db_input($this->getId()).' LIMIT 1';

if(db_query($sql) && ($num=db_affected_rows())) {

db_query('UPDATE '.DEPT_TABLE.' SET area_id=0 WHERE area_id='.db_input($this->getId()));

db_query('UPDATE '.TOPIC_TABLE.' SET area_id=0 WHERE area_id='.db_input($this->getId()));

db_query('UPDATE '.TICKET_TABLE.' SET area_id=0 WHERE area_id='.db_input($this->getId()));

}

return $num;

}

/** static functions **/

function create($vars,&$errors) {

return AREA:(0,$vars,$errors);

}

function getAREAs() {

$areas=array();

$sql='SELECT area_id, area, isenabled FROM ost_areas ORDER BY area';

if(($res=db_query($sql)) && db_num_rows($res)) {

while($row=db_fetch_array($res))

$areas[$row = sprintf('%s (%d hrs - %s)',

$row,

$row?'Active':'Disabled');

}

return $areas;

}

function getIdByarea($area) {

$sql='SELECT area_id FROM ost_areas WHERE area='.db_input($area);

if(($res=db_query($sql)) && db_num_rows($res))

list($id)=db_fetch_row($res);

return $id;

}

function lookup($id) {

return ($id && is_numeric($id) && ($sla= new AREA($id)) && $sla->getId()==$id)?$sla;

}

function save($id,$vars,&$errors) {

if(!$vars)

$errors='Area required';

elseif(($sid=AREA:($vars)) && $sid!=$id)

$errors='Area already exists';

if(!$vars)

$errors='Branch required';

if($errors) return false;

$sql=" `upDate`=NOW() ".

',isenabled='.db_input($vars).

',state_id='.db_input($vars).

',area='.db_input($vars).

//',editor='.db_input($thisstaff->getUserName()).

',notes='.db_input($vars);

if($id) {

$sql='UPDATE ost_areas SET '.$sql.' WHERE area_id='.db_input($id);

if(db_query($sql))

return true;

$errors='Unable to update Area. Internal error occurred';

}else{

$sql='INSERT INTO ost_areas SET '.$sql.',addDate=NOW() ';

if(db_query($sql) && ($id=db_insert_id()))

return $id;

$errors='Unable to add Area. Internal error';

}

return false;

}

d. Create file class.states.php and place this code inside include folder:

<?php

class STATE {

var $id;

var $info;

function STATE($id) {

$this->id=0;

$this->load($id);

}

function load($id=0) {

if(!$id && !($id=$this->getId()))

return false;

$sql='SELECT * FROM ost_states WHERE state_id='.db_input($id);

if(!($res=db_query($sql)) || !db_num_rows($res))

return false;

$this->ht=db_fetch_array($res);

$this->id=$this->ht;

return true;

}

function reload() {

return $this->load();

}

function getId() {

return $this->id;

}

function getstate() {

return $this->ht;

}

function getNotes() {

return $this->ht;

}

function getHashtable() {

return $this->ht;

}

function getInfo() {

return $this->getHashtable();

}

function isActive() {

return ($this->ht);

}

function update($vars,&$errors) {

if(!$this->save($this->getId(),$vars,$errors))

return false;

$this->reload();

return true;

}

function delete() {

global $cfg;

$sql='DELETE FROM ost_states WHERE state_id='.db_input($this->getId()).' LIMIT 1';

if(db_query($sql) && ($num=db_affected_rows())) {

db_query('UPDATE '.DEPT_TABLE.' SET state_id=0 WHERE state_id='.db_input($this->getId()));

db_query('UPDATE '.TOPIC_TABLE.' SET state_id=0 WHERE state_id='.db_input($this->getId()));

db_query('UPDATE '.TICKET_TABLE.' SET state_id=0 WHERE state_id='.db_input($this->getId()));

db_query('UPDATE '.AREA_TABLE.' SET state_id=0 WHERE state_id='.db_input($this->getId()));

}

return $num;

}

/** static functions **/

function create($vars,&$errors) {

return STATE:(0,$vars,$errors);

}

function getSTATEs() {

$states=array();

$sql='SELECT state_id, state, isenabled FROM ost_states ORDER BY state';

if(($res=db_query($sql)) && db_num_rows($res)) {

while($row=db_fetch_array($res))

$states[$row = sprintf('%s (%d hrs - %s)',

$row,

$row?'Active':'Disabled');

}

return $states;

}

function getIdBystate($state) {

$sql='SELECT state_id FROM ost_states WHERE state='.db_input($state);

if(($res=db_query($sql)) && db_num_rows($res))

list($id)=db_fetch_row($res);

return $id;

}

function lookup($id) {

return ($id && is_numeric($id) && ($sla= new STATE($id)) && $sla->getId()==$id)?$sla;

}

function save($id,$vars,&$errors) {

if(!$vars)

$errors='State required';

elseif(($sid=STATE:($vars)) && $sid!=$id)

$errors='State already exists';

if($errors) return false;

$sql=" `upDate`=NOW() ".

',isenabled='.db_input($vars).

',state='.db_input($vars).

//',editor='.db_input($thisstaff->getUserName()).

',notes='.db_input($vars);

if($id) {

$sql='UPDATE ost_states SET '.$sql.' WHERE state_id='.db_input($id);

if(db_query($sql))

return true;

$errors='Unable to update State. Internal error occurred';

}else{

$sql='INSERT INTO ost_states SET '.$sql.',addDate=NOW() ';

if(db_query($sql) && ($id=db_insert_id()))

return $id;

$errors='Unable to add State. Internal error';

}

return false;

}

sandeep.bodh

Just copy and paste the codes and follow as mentioned.

Hope you find it working properly.

Note* - Check for the variable names used in code.

Thanks to all.

sandeep.bodh

Custom related dropdown field with Admin Interface

--------------------------------------------------------------------------
hello, thanks for your input, modify all files follow all the steps and did not work, when you load the page "NEW TICKET" appears AGENCY with Dropdown field but the data are not those of the database, when I deploy the field is "kbase" as an option, this is the part of the staff, and the client is in the AGENCY field shows "status" as an option, please can you tell me I'm doing wrong? Thanks in advance, and sorry for not mastered the English language, I speak Spanish apology.

Hello,

Check the forum as I updated it. Sorry for not posting the full solution.

You just need to paste the code and follow the steps as mentioned. Hope you find a solution.

Sandeep Bodh

jose25886

operation by parts:

Hello,
Check the forum as I updated it. Sorry for not posting the full solution.
You just need to paste the code and follow the steps as mentioned. Hope you find a solution.
Sandeep Bodh

Sandeep.bodh Hi, thanks for replying, I commented I could do step by step what you indicate in the post but still not quite right up, I have attached some pictures to show which parts are in good working order and also those that still do not work all right, I would like to know what I'm doing wrong because when editing a ticke as staff if I can display the data in the table is stored in the database, but when I try to open a new ticket or a client tries to open a new ticket does not show the dropdown data, also attached the files I modified for better understanding, I am very grateful for answering my questions, thank you wholeheartedly.

PS: adding the agency by the staff (Control Panel) if you can do very well and also stored in the table stored in the database.

VIEW TICKET -STAFF.jpg

EDIT TICKET - STAFF.jpg

NEW TICKET - STAFF.jpg

OPEN NEW TICKET - CLIENT.jpg

VIEW TICKET - CLIENT.jpg

jose25886

Hello,
Check the forum as I updated it. Sorry for not posting the full solution.
You just need to paste the code and follow the steps as mentioned. Hope you find a solution.
Sandeep Bodh

I'm adding the modified files, thank you.

[files - osticket.zip](https://forum.osticket.com/assets/files/migrated/3/94cd92f0441cac83712ca3a57723c94.zip)