I was able to utilize overlib to help create pop up windows for selected rows of data. However not all of the pop ups are working, my guess is that some of the information in the select statement is causing an issue.
Mysql code:
// The below query is used for category searches
switch($search)
{
case 'category' :
$query_asset_details="SELECT itc_tickets.ticket_nbr, itc_tickets.ticket_status, itc_tickets.ticket_category, itc_tickets.ticket_priority, itc_tickets.issued_by, itc_tickets.assigned_to, itc_tickets.lastupdt_date, itc_tickets.create_date, itc_tickets.description FROM itc_tickets, itc_priority_listing, itc_status_listing WHERE itc_tickets.ticket_category = '$category' AND itc_tickets.ticket_priority = itc_priority_listing.priority_name AND itc_tickets.ticket_status = itc_status_listing.status_name ORDER BY itc_status_listing.status_level ASC, itc_tickets.create_date DESC, itc_priority_listing.priority_level ASC, itc_tickets.ticket_nbr ASC";
break;
case 'keyword' :
$query_asset_details="SELECT itc_tickets.ticket_nbr, itc_tickets.ticket_status, itc_tickets.ticket_category, itc_tickets.ticket_priority, itc_tickets.issued_by, itc_tickets.assigned_to, itc_tickets.lastupdt_date, itc_tickets.create_date, itc_tickets.description FROM itc_tickets, itc_priority_listing, itc_status_listing WHERE itc_tickets.description LIKE $val AND itc_tickets.ticket_priority = itc_priority_listing.priority_name AND itc_tickets.ticket_status = itc_status_listing.status_name ORDER BY itc_status_listing.status_level ASC, itc_tickets.create_date DESC, itc_priority_listing.priority_level ASC, itc_tickets.ticket_nbr ASC";
if($result = mysql_query($query_asset_details)){
if(mysql_num_rows($result) > 0){
break;
}else{
$query_asset_details="SELECT itc_tickets.ticket_nbr, itc_tickets.ticket_status, itc_tickets.ticket_category, itc_tickets.ticket_priority, itc_tickets.issued_by, itc_tickets.assigned_to, itc_tickets.lastupdt_date, itc_tickets.create_date, itc_tickets.description FROM itc_tickets, itc_priority_listing, itc_status_listing, itc_tickets_notes WHERE itc_tickets_notes.notes_body LIKE $val AND itc_tickets.ticket_nbr = itc_tickets_notes.ticket_nbr AND itc_tickets.ticket_priority = itc_priority_listing.priority_name AND itc_tickets.ticket_status = itc_status_listing.status_name ORDER BY itc_status_listing.status_level ASC, itc_tickets.create_date DESC, itc_priority_listing.priority_level ASC, itc_tickets.ticket_nbr ASC";
}
}
break;
case 'user':
// The below query is for user searches
$query_asset_details="SELECT itc_tickets.ticket_nbr, itc_tickets.ticket_status, itc_tickets.ticket_category, itc_tickets.ticket_priority, itc_tickets.issued_by, itc_tickets.assigned_to, itc_tickets.lastupdt_date, itc_tickets.create_date, itc_tickets.description FROM itc_tickets, itc_priority_listing, itc_status_listing WHERE itc_tickets.issued_by LIKE '$user' AND itc_tickets.ticket_priority = itc_priority_listing.priority_name AND itc_tickets.ticket_status = itc_status_listing.status_name ORDER BY itc_status_listing.status_level ASC, itc_tickets.create_date DESC, itc_priority_listing.priority_level ASC, itc_tickets.ticket_nbr ASC";
break;
}
$asset_details = mysql_query($query_asset_details, $itc_admin) or die(mysql_error());
$row_asset_details = mysql_fetch_assoc($asset_details);
if (!$row_asset_details) {
// Do something when data wasn't found
$errorMessage .="No tickets found for that search criteria.<br>";
include 'search.php'; // Show the form again!
exit;
}
$totalRows_asset_details = mysql_num_rows($asset_details);
here is the page info:
<table width="100%" border="1" cellspacing="0" cellpadding="1">
<?php if($row_asset_details['ticket_status']==NULL) { ?>
<tr bordercolor="#CECFCE" bgcolor="#FF9900" class="style7">
<td colspan="7"><div align="center">
<p> </p>
<p>[ No tickets found in the database ]</p>
<p> </p>
</div></td>
<tr>
<?php } else { ?>
<tr bordercolor="#CECFCE" bgcolor="#FF9900" class="style7">
<td bgcolor="#FF9900"><div align="center">Ticket Number </div></td>
<td bgcolor="#FF9900"><div align="center">Ticket Priority </div></td>
<td bgcolor="#FF9900"><div align="center">Issued By </div></td>
<td bgcolor="#FF9900"><div align="center">Category</div></td>
<td bgcolor="#FF9900"><div align="center">Assigned to </div></td>
<td bgcolor="#FF9900"><div align="center">Ticket Created </div></td>
<td bgcolor="#FF9900"><div align="center">Last Updated </div></td>
<td bgcolor="#CCCCCC"> </td>
</tr>
<?php do { ?>
<tr bordercolor="#CECFCE" bgcolor="#FF9A00" class="style7">
<?php $TFM_nest = $row_asset_details['ticket_status'];
if ($lastTFM_nest != $TFM_nest) {
$lastTFM_nest = $TFM_nest; ?>
<td colspan="8" bgcolor="#CC6600"><div align="left" class="style1"><strong>> <?php echo ucfirst($row_asset_details['ticket_status']); ?> Tickets</strong></div></td>
<?php } //End of Basic-UltraDev Simulated Nested Repeat?>
</tr>
<tr <?php
// technocurve arc 3 php mv block2/3 start
echo " style=\"background-color:$mocolor\" onMouseOver=\"this.style.backgroundColor='$mocolor3'\" onMouseOut=\"this.style.backgroundColor='$mocolor'\"";
// technocurve arc 3 php mv block2/3 end
?> valign="top" bordercolor="#CECFCE" bgcolor="#CCCCCC" class="style7" >
<td><a href="javascript:void(0);" onmouseover="return overlib('<?php echo $row_asset_details['description'] ?>');" onmouseout="return nd();"><div align="center"><?php echo $row_asset_details['ticket_nbr']; ?></div></a></td>
<td><div align="center"><?php echo $row_asset_details['ticket_priority']; ?></div></td>
<td align="center"><?php echo $row_asset_details['issued_by']; ?></td>
<td align="center"><?php echo $row_asset_details['ticket_category']; ?></td>
<td align="center"><?php echo $row_asset_details['assigned_to']; ?></td>
<td align="center"><?php echo date('m/d/Y',strtotime($row_asset_details['create_date'])); ?></td>
<td>
<div align="left">
<!-- Table used in a column for viewing Last Updated field -->
<table width="100%" bordercolor="Blue" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="left">
<?php if($row_asset_details['lastupdt_date']=="0000-00-00 00:00:00") { echo "<div align='center'><font color='#ff0000'>Never</font></div>"; } else { echo date('D, m/d/y',strtotime($row_asset_details['lastupdt_date'])); ?>
</div></td>
<td><div align="right"><?php echo date('g:i A',strtotime($row_asset_details['lastupdt_date'])); } ?></div></td>
</tr>
</table>
</div></td>
<td><div align="center"><a href="../tickets/view_ticket.php?ticket_nbr=<?php echo $row_asset_details['ticket_nbr']; ?>">View/Edit</a></div></td>
</tr>
<?php
// technocurve arc 3 php mv block3/3 start
if ($mocolor == $mocolor1) {
$mocolor = $mocolor2;
} else {
$mocolor = $mocolor1;
}
// technocurve arc 3 php mv block3/3 end
?>
<?php } while ($row_asset_details = mysql_fetch_assoc($asset_details)); ?>
</table>
</td>
<?php } ?>
</tr>
</table>
Below is two samples of description that will and will not show:
Will not show -
Hi Shireen, I was just showing Connie and Linda E how to Release IN Batches for OM in Screen 10-400-00 as per our conversation earlier this morning, and neither one of them have rights. May you please approve access to this screen for both of them? Thank You... Sarah
Will show:
Sarah was looking for a report to help with the status of work orders. She needs to verify that they are in WIP(work in progress) status and not invoiced. There is a report in SD > reports > Activity Reports and under the Report tab there is a report by Service ID. This should be the report she needs.
Please let me know if more information is needed. I'm trying to learn php enough to redo our current ticket tracking system. I think this would be a great way to becoming a php developer, of course I'm just a beginner.
Thanks,
