Date, Subject & Department out of wack.

wwilson

blank

Please take a look at the pic and see that my Date subject and Department are out of wack, can someone please tell me a fix?

PleXy

Hard to see without the code..

But it looks like you might have one too much within either the first or the second in the table

wwilson

What file would I need to look for and edit that in. Thank you! :)

PleXy

Hey,

Go to osticket/include/staff/tickets.inc.php.

Look for

<td nowrap><?=Format:($row,22,strpos($row,'@'))?> </td>

After that, add:

<td nowrap><?=($row) ? $row : ' ';?> <?=($row) ? $row : '';?></td>

Did that work out for you?

wwilson

Nope looks like at added another table to the right.

Here's my code.

<table>

<tr>

<td>Query: </td><td><input type="text" id="query" name="query" value="<?=Format:($_REQUEST)?>"></td>

<td>Dept:</td>

<td><select name="dept"><option value=0>All Departments</option>

<?

//Showing only departments the user has access to...

$sql='SELECT dept_id,dept_name FROM '.DEPT_TABLE;

if(!$thisuser->isadmin())

$sql.=' WHERE dept_id IN ('.implode(',',$thisuser->getDepts()).')';

$depts= db_query($sql);

while (list($deptId,$deptName) = db_fetch_row($depts)){

$selected = ($_GET==$deptId)?'selected':''; ?>

<option value="<?=$deptId?>"<?=$selected?>><?=$deptName?></option>

<?

}?>

</select>

</td>

<td>Status is:</td>

<td><select name="status">

<option value='any' selected >Any status</option>

<option value="open" <?=!strcasecmp($_REQUEST,'Open')?'selected':''?>>Open</option>

<option value="overdue" <?=!strcasecmp($_REQUEST,'overdue')?'selected':''?>>Overdue</option>

<option value="closed" <?=!strcasecmp($_REQUEST,'Closed')?'selected':''?>>Closed</option>

</select>

</td>

</tr>

</table>

<div>

Date Span:

 From <input id="sd" name="startDate" value="<?=Format:($_REQUEST)?>"

onclick="event.cancelBubble=true;calendar(this);" autocomplete=OFF>

<a href="#" onclick="event.cancelBubble=true;calendar(getObj('sd')); return false;"><img src='images/cal.png'border=0 alt=""></a>

   to   

<input id="ed" name="endDate" value="<?=Format:($_REQUEST)?>"

onclick="event.cancelBubble=true;calendar(this);" autocomplete=OFF >

<a href="#" onclick="event.cancelBubble=true;calendar(getObj('ed')); return false;"><img src='images/cal.png'border=0 alt=""></a>

  

</div>

<table>

<tr>

<td>Type:</td>

<td>

<select name="stype">

<option value="LIKE" <?=(!$_REQUEST || $_REQUEST == 'LIKE') ?'selected':''?>>Scan (%)</option>

<option value="FT"<?= $_REQUEST == 'FT'?'selected':''?>>Fulltext</option>

</select>

        </td>
       <td>Sort by:</td><td>
        <? 
         $sort=$_GET?$_GET:'date';
        ?>
        <select name="sort">
    	    <option value="ID" <?= $sort== 'ID' ?'selected':''?>>Ticket #</option>
            <option value="pri" <?= $sort == 'pri' ?'selected':''?>>Priority</option>
            <option value="date" <?= $sort == 'date' ?'selected':''?>>Date</option>
            <option value="dept" <?= $sort == 'dept' ?'selected':''?>>Dept.</option>
        </select>
        <select name="order">
            <option value="DESC"<?= $_REQUEST == 'DESC' ?'selected':''?>>Descending</option>
            <option value="ASC"<?= $_REQUEST == 'ASC'?'selected':''?>>Ascending</option>
        </select>
       </td>
        <td>Results Per Page:</td><td>
        <select name="limit">
        <?
         $sel=$_REQUEST?$_REQUEST;
         for ($x = 5; $x <= 25; $x += 5) {?>
            <option  value="<?=$x?>" <?=($sel==$x )?'selected':''?>><?=$x?></option>
        <?}?>
        </select>
     </td>
     <td>
     <input type="submit" name="advance_search" class="button" value="Search">
       &nbsp;
    </td>
  </tr>

</table>

PleXy

Hey again,

You pasted the wrong section of your file, that's the search form you pasted.

Please come back with the correct section of your code :)

wwilson

Yeah here it is.

<table width="100%" border="0" cellspacing=1 cellpadding=2>

<form action="tickets.php" method="POST" name='tickets' onSubmit="return checkbox_checker(this,1,0);">

<input type="hidden" name="a" value="mass_process" >

<input type="hidden" name="status" value="<?=$statusss?>" >

<tr><td>

<table width="100%" border="0" cellspacing=0 cellpadding=2 class="dtable" align="center">

<tr>

<?if($canDelete || $canClose) {?>

<th width="8px"> </th>

<?}?>

<th width="70" >

<a href="tickets.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket</a></th>

<th width="70">

<a href="tickets.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Date</a></th>

<th width="280">Subject</th>

<th width="120">

<a href="tickets.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>

<th width="70">

<a href="tickets.php?sort=pri&order=<?=$negorder?><?=$qstr?>" title="Sort By Priority <?=$negorder?>">Priority</a></th>

<th width="180" >From</th>

<th width="150">Progress</th>

</tr>

<?

$class = "row1";

$total=0;

if($tickets_res && ($num=db_num_rows($tickets_res))):

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

$tag=$row?'assigned':'openticket';

$flag=null;

if($row)

$flag='locked';

elseif($row)

$flag='assigned';

elseif($row)

$flag='overdue';

$tid=$row;

$subject = Format:($row,40);

if(!strcasecmp($row,'open') && !$row && !$row) {

$tid=sprintf('<b>%s</b>',$tid);

//$subject=sprintf('<b>%s</b>',Format:($row,40)); // Making the subject bold is too much for the eye

}

?>

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

<?if($canDelete || $canClose) {?>

<td align="center" class="nohover">

<input type="checkbox" name="tids" value="<?=$row?>" onClick="highLight(this.value,this.checked);">

</td>

<?}?>

<td align="center" title="<?=$row?>" nowrap>

<a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?> Ticket: <?=$row?>"

href="tickets.php?id=<?=$row?>"><?=$tid?></a></td>

<td nowrap >

<?=$status_arr[$row;?>

</td>

<td align="center" nowrap><?=Format:($row)?></td>

<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>

href="tickets.php?id=<?=$row?>"><?=$subject?></a>

 <?=$row?"<span class='Icon file'> </span>":''?></td>

<td nowrap><?=Format:($row,30)?></td>

<td class="nohover" align="center" style="background-color:<?=$row?>;"><?=$row?></td>

<td nowrap><?=Format:($row,22,strpos($row,'@'))?> </td>

<td nowrap><?=($row) ? $row : ' ';?> <?=($row) ? $row : '';?></td>

</tr>

<?

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

} //end of while.

else: //not tickets found!! ?>

<tr class="<?=$class?>"><td colspan=8><b>Query returned 0 results.</b></td></tr>

<?

endif; ?>

</table>

PleXy

It looks like this code:

<td nowrap >

<?=$status_arr[$row;?>

</td>

is on the wrong place.

(It's also wrong so that's why this column is empty)

Try this:

<table width="100%" border="0" cellspacing=1 cellpadding=2>

<form action="tickets.php" method="POST" name='tickets' onSubmit="return checkbox_checker(this,1,0);">

<input type="hidden" name="a" value="mass_process" >

<input type="hidden" name="status" value="<?=$statusss?>" >

<tr><td>

<table width="100%" border="0" cellspacing=0 cellpadding=2 class="dtable" align="center">

<tr>

<?if($canDelete || $canClose) {?>

<th width="8px"> </th>

<?}?>

<th width="70" >

<a href="tickets.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket</a></th>

<th width="70">

<a href="tickets.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Date</a></th>

<th width="280">Subject</th>

<th width="120">

<a href="tickets.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>

<th width="70">

<a href="tickets.php?sort=pri&order=<?=$negorder?><?=$qstr?>" title="Sort By Priority <?=$negorder?>">Priority</a></th>

<th width="180" >From</th>

<th width="150">Progress</th>

</tr>

<?

$class = "row1";

$total=0;

if($tickets_res && ($num=db_num_rows($tickets_res))):

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

$tag=$row?'assigned':'openticket';

$flag=null;

if($row)

$flag='locked';

elseif($row)

$flag='assigned';

elseif($row)

$flag='overdue';

$tid=$row;

$subject = Format:($row,40);

if(!strcasecmp($row,'open') && !$row && !$row) {

$tid=sprintf('<b>%s</b>',$tid);

//$subject=sprintf('<b>%s</b>',Format:($row,40)); // Making the subject bold is too much for the eye

}

?>

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

<?if($canDelete || $canClose) {?>

<td align="center" class="nohover">

<input type="checkbox" name="tids" value="<?=$row?>" onClick="highLight(this.value,this.checked);">

</td>

<?}?>

<td align="center" title="<?=$row?>" nowrap>

<a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?> Ticket: <?=$row?>"

href="tickets.php?id=<?=$row?>"><?=$tid?></a></td>

<td align="center" nowrap><?=Format:($row)?></td>

<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>

href="tickets.php?id=<?=$row?>"><?=$subject?></a>

 <?=$row?"<span class='Icon file'> </span>":''?></td>

<td nowrap><?=Format:($row,30)?></td>

<td class="nohover" align="center" style="background-color:<?=$row?>;"><?=$row?></td>

<td nowrap><?=Format:($row,22,strpos($row,'@'))?> </td>

<td nowrap><?=($row) ? $row : ' ';?> <?=($row) ? $row : '';?></td>

<td nowrap ><?=$status_arr[$row;?> </td>

</tr>

<?

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

} //end of while.

else: //not tickets found!! ?>

<tr class="<?=$class?>"><td colspan=8><b>Query returned 0 results.</b></td></tr>

<?

endif; ?>

</table>

wwilson

You did it! Thank you so much!

PleXy

Glad I could help. :)