function to_row($contactrow) { global $now, $updateid, $CONFIG, $dbg; $str = ''; if (($contactrow['expirydate'] < $now or $contactrow['term'] == 'yes') and $contactrow['expirydate'] != -1) { $class = 'expired'; } else { $class = "shade2"; } $incidents_remaining = $contactrow['incident_quantity'] - $contactrow['incidents_used']; $str = "<tr class='{$class}'>"; if ($contactrow['expirydate'] < $now and $contactrow['expirydate'] != '-1') { $str .= "<td>{$GLOBALS['strExpired']}</td>"; } elseif ($contactrow['term'] == 'yes') { $str .= "<td>{$GLOBALS['strTerminated']}</td>"; } elseif ($contactrow['incident_quantity'] >= 1 and $contactrow['incidents_used'] >= $contactrow['incident_quantity']) { $str .= "<td class='expired'>{$GLOBALS['strZeroRemaining']} ({$contactrow['incidents_used']}/{$contactrow['incident_quantity']} {$strUsed})</td>"; } else { $str .= "<td><a href=\"{$_SERVER['PHP_SELF']}?action=incidentform&type=support&"; $str .= "contactid=" . $contactrow['contactid'] . "&maintid=" . $contactrow['maintid']; $str .= "&producttext=" . urlencode($contactrow['productname']) . "&productid="; $str .= $contactrow['productid'] . "&updateid={$updateid}&siteid=" . $contactrow['siteid']; $str .= "&win={$win}\" onclick=\"return confirm_support();\">{$GLOBALS['strAddIncident']}</a> "; if ($contactrow['incident_quantity'] == 0) { $str .= "({$GLOBALS['strUnlimited']})"; } else { $str .= "(" . sprintf($GLOBALS['strRemaining'], $incidents_remaining) . ")"; } } $str .= "</td>"; $str .= '<td>' . $contactrow['forenames'] . ' ' . $contactrow['surname'] . '</td>'; $str .= '<td>' . $contactrow['name'] . '</td>'; $str .= '<td>' . $contactrow['productname'] . '</td>'; $str .= '<td>' . servicelevel_id2tag($contactrow['servicelevelid']) . '</td>'; if ($contactrow['expirydate'] == '-1') { $str .= "<td>{$GLOBALS['strUnlimited']}</td>"; } else { $str .= '<td>' . ldate($CONFIG['dateformat_date'], $contactrow['expirydate']) . '</td>'; } $str .= "</tr>\n"; return $str; }
echo "<tr><th>{$strProduct} <sup class='red'>*</sup></th><td>"; if ($_SESSION['formdata']['add_contract']['product'] != '') { echo product_drop_down("product", $_SESSION['formdata']['add_contract']['product']) . "</td></tr>\n"; } else { echo product_drop_down("product", 0) . "</td></tr>\n"; } echo "<tr><th>{$strServiceLevel}</th><td>"; if ($_SESSION['formdata']['add_contract']['servicelevelid'] != '') { $slid = $_SESSION['formdata']['add_contract']['servicelevelid']; } else { $slid = 0; // Default to first service level } echo servicelevel_drop_down('servicelevelid', $slid, TRUE, "onchange=\"addcontract_sltimed(\$F('servicelevelid'));\"") . "</td></tr>\n"; // check the initially selected service level to decide whether to show the extra hiddentimed section $sltag = servicelevel_id2tag($slid); $timed = servicelevel_timed($sltag); echo "<tr><th colspan='2' style='text-align: left;'><br />{$strServicePeriod}</th></tr>\n"; echo "<tr><th>{$strStartDate}</th>"; echo "<td><input type='text' name='startdate' id='startdate' size='10' value='" . date('Y-m-d', $now) . "' /> "; echo date_picker('add_contract.startdate'); echo "</td></tr>\n"; echo "<tr><th>{$strExpiryDate}</th>"; echo "<td><input class='required' name='expiry' size='10' "; if ($_SESSION['formdata']['add_contract']['expiry'] != '') { echo "value='{$_SESSION['formdata']['add_contract']['expiry']}'"; } echo "/> " . date_picker('add_contract.expiry'); echo "<input type='checkbox' name='noexpiry' "; if ($_SESSION['formdata']['add_contract']['noexpiry'] == "on") { echo "checked='checked' ";
$content = cleanvar($_REQUEST['content']); if ($userid == $_SESSION['userid']) { if ($draftid == -1) { $sql = "INSERT INTO `{$dbDrafts}` (userid,incidentid,type,meta,content,lastupdate) VALUES ('{$userid}','{$incidentid}','{$type}','{$meta}','{$content}','{$now}')"; } else { $sql = "UPDATE `{$dbDrafts}` SET content = '{$content}', meta = '{$meta}', lastupdate = '{$now}' WHERE id = {$draftid}"; } $result = mysql_query($sql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_ERROR); } echo mysql_insert_id(); } break; case 'servicelevel_timed': $sltag = servicelevel_id2tag(cleanvar($_REQUEST['servicelevel'])); if (servicelevel_timed($sltag)) { echo "TRUE"; } else { echo "FALSE"; } break; case 'contexthelp': $context = cleanvar($_REQUEST['context']); $helpfile = APPLICATION_HELPPATH . "{$_SESSION['lang']}" . DIRECTORY_SEPARATOR . "{$context}.txt"; // Default back to english if language helpfile isn't found if (!file_exists($helpfile)) { $helpfile = APPLICATION_HELPPATH . "{$_SESSION['lang']}" . DIRECTORY_SEPARATOR . "en-GB/{$context}.txt"; } if (file_exists($helpfile)) { $fp = fopen($helpfile, 'r', TRUE);
$site_notes = ''; } unset($site); if (!empty($incident->contactnotes)) { $contact_notes = icon('contact', 16) . " <strong>{$strContactNotes}</strong><br />" . nl2br($incident->contactnotes); } else { $contact_notes = ''; } $product_name = product_name($incident->product); if ($incident->softwareid > 0) { $software_name = software_name($incident->softwareid); } $servicelevel_id = maintenance_servicelevel($incident->maintenanceid); $servicelevel_tag = $incident->servicelevel; if ($servicelevel_tag == '') { $servicelevel_tag = servicelevel_id2tag(maintenance_servicelevel($incident->maintenanceid)); } $servicelevel_name = servicelevel_name($servicelevelid); if ($incident->closed == 0) { $closed = time(); } else { $closed = $incident->closed; } $opened_for = format_seconds($closed - $incident->opened); $priority = $incident->priority; // Lookup the service level times $slsql = "SELECT * FROM `{$dbServiceLevels}` WHERE tag='{$servicelevel_tag}' AND priority='{$incident->priority}' "; $slresult = mysql_query($slsql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING); }
echo "</textarea></td></tr>"; echo "</table>"; echo "<input name='contractid' value='{$contractid}' type='hidden' />"; echo "<input name='productid' value='{$productid}' type='hidden' />"; echo "<p align='center'><input type='submit' value='{$strAddIncident}' /></p>"; echo "</form>"; include APPLICATION_INCPATH . 'htmlfooter.inc.php'; } else { $contactid = $_SESSION['contactid']; $contractid = cleanvar($_REQUEST['contractid']); $software = cleanvar($_REQUEST['software']); $incidenttitle = cleanvar($_REQUEST['title']); $probdesc = cleanvar($_REQUEST['probdesc']); $workarounds = cleanvar($_REQUEST['workarounds']); $reproduction = cleanvar($_REQUEST['reproduction']); $servicelevel = servicelevel_id2tag(maintenance_servicelevel($contractid)); $productid = cleanvar($_REQUEST['productid']); $_SESSION['formdata']['portaladdincident'] = $_POST; $errors = 0; if (empty($incidenttitle)) { $_SESSION['formerrors']['portaladdincident'] .= user_alert(sprintf($strFieldMustNotBeBlank, "'{$strIncidentTitle}'"), E_USER_ERROR); $errors = 1; } if (empty($probdesc)) { $_SESSION['formerrors']['portaladdincident'] .= user_alert(sprintf($strFieldMustNotBeBlank, "'{$strProblemDescription}'"), E_USER_ERROR); $errors = 1; } foreach ($_POST as $key => $value) { if (substr($key, 0, 5) == 'pinfo' and empty($value)) { $id = intval(str_replace("pinfo", "", $key)); $sql = "SELECT information FROM `{$dbProductInfo}` ";
$updated = "<em class='updatedveryrecently'>" . sprintf($strAgo, format_seconds($now - $incidents['lastupdated'])) . "</em>"; } elseif ($incidents['lastupdated'] > $now - 3600) { $updated = "<em class='updatedrecently'>" . sprintf($strAgo, format_seconds($now - $incidents['lastupdated'])) . "</em>"; } elseif (date('dmy', $incidents['lastupdated']) == date('dmy', $now)) { $updated = "{$strToday} @ " . ldate($CONFIG['dateformat_time'], $incidents['lastupdated']); } elseif (date('dmy', $incidents['lastupdated']) == date('dmy', $now - 86400)) { $updated = "{$strYesterday} @ " . ldate($CONFIG['dateformat_time'], $incidents['lastupdated']); } elseif ($incidents['lastupdated'] < $now - 86400 and $incidents['lastupdated'] > $now - 86400 * 6) { $updated = ldate('l', $incidents['lastupdated']) . " @ " . ldate($CONFIG['dateformat_time'], $incidents['lastupdated']); } else { $updated = ldate($CONFIG['dateformat_datetime'], $incidents["lastupdated"]); } // Fudge for old ones $tag = $incidents['servicelevel']; if ($tag == '') { $tag = servicelevel_id2tag(maintenance_servicelevel($incidents['maintenanceid'])); } $slsql = "SELECT * FROM `{$dbServiceLevels}` WHERE tag='{$tag}' AND priority='{$incidents['priority']}' "; $slresult = mysql_query($slsql); if (mysql_error()) { trigger_error("mysql query error " . mysql_error(), E_USER_WARNING); } $servicelevel = mysql_fetch_object($slresult); if (mysql_num_rows($slresult) < 1) { trigger_error("could not retrieve service level ({$slsql})", E_USER_WARNING); } // Get Last Update list($update_userid, $update_type, $update_currentowner, $update_currentstatus, $update_body, $update_timestamp, $update_nextaction, $update_id) = incident_lastupdate($incidents['id']); // Get next target $target = incident_get_next_target($incidents['id']); $working_day_mins = ($CONFIG['end_working_day'] - $CONFIG['start_working_day']) / 60;