} else {
$sql = "SELECT * FROM `{$dbFeedbackForms}` WHERE id='{$formid}'";
$result = mysql_query($sql);
if (mysql_error()) {
trigger_error(mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($result) < 1) {
echo "<h2>{$strError}</h2>";
echo "<p>{$strNoFeedBackFormToCompleteHere}</p>";
echo "\n\n<!-- f: {$formid} r:{$respondent} rr:{$responseref} dh:{$decodehash} hc:{$hashcode} -->\n\n";
} else {
$reqd = 0;
while ($form = mysql_fetch_object($result)) {
echo "<form action='feedback.php' method='post'>\n";
echo "<h2>{$form->name}</h2>\n";
echo "<p>{$strRelatingToIncident} <strong>#{$incidentid}</strong> — <strong>" . incident_title($incidentid) . "</strong><br />";
echo sprintf($strOpenedbyXonY, contact_realname(incident_contact($incidentid)), ldate($CONFIG['dateformat_date'], db_read_column('opened', $dbIncidents, $incidentid)));
echo ' ';
echo sprintf($strClosedOnX, ldate($CONFIG['dateformat_date'], db_read_column('closed', $dbIncidents, $incidentid))) . ".</p>";
if (!empty($_REQUEST['error'])) {
echo "<p style='color: red'>{$strErrorRequiredQuestionsNotCompleted}</p>";
}
echo nl2br($form->introduction);
$qsql = "SELECT * FROM `{$dbFeedbackQuestions}` ";
$qsql .= "WHERE formid='{$form->id}' ";
$qsql .= "ORDER BY taborder ASC";
$qresult = mysql_query($qsql);
if (mysql_error()) {
trigger_error(mysql_error(), E_USER_WARNING);
}
while ($question = mysql_fetch_object($qresult)) {
while ($resp = mysql_fetch_object($result)) {
$respondentarr = explode('-', $resp->respondent);
$responserefarr = explode('-', $resp->responseref);
$hashtext = urlencode($resp->formid) . "&&" . urlencode($resp->contactid) . "&&" . urlencode($resp->incidentid);
// $hashcode=urlencode(trim(base64_encode(gzcompress(str_rot13($hashtext)))));
$hashcode4 = str_rot13($hashtext);
$hashcode3 = gzcompress($hashcode4);
$hashcode2 = base64_encode($hashcode3);
$hashcode1 = trim($hashcode2);
$hashcode = urlencode($hashcode1);
echo "<tr class='{$shade}'>";
echo "<td>" . ldate($CONFIG['dateformat_datetime'], mysqlts2date($resp->created)) . "</td>";
echo "<td><a href='contact_details.php?id={$resp->contactid}' title='{$resp->email}'>" . contact_realname($resp->contactid) . "</a></td>";
echo "<td><a href=\"javascript:incident_details_window('{$resp->incidentid}','incident{$resp->incidentid}')\">";
echo "{$strIncident} [{$resp->incidentid}]</a> - ";
echo incident_title($resp->incidentid) . "</td>";
$url = "feedback.php?ax={$hashcode}";
if ($resp->multi == 'yes') {
$url .= "&rr=1";
}
echo "<td>";
if ($resp->completed == 'no') {
echo "<a href='{$url}' title='{$url}' target='_blank'>URL</a>";
}
$eurl = urlencode($url);
$eref = urlencode($resp->responseref);
if ($resp->completed == 'no') {
//if ($resp->remind<1) echo "<a href='formactions.php?action=remind&id={$resp->respid}&url={$eurl}&ref={$eref}' title='Send a reminder by email'>Remind</a>";
//elseif ($resp->remind==1) echo "<a href='formactions.php?action=remind&id={$resp->respid}&url={$eurl}&ref={$eref}' title='Send a Second reminder by email'>Remind Again</a>";
//elseif ($resp->remind==2) echo "<a href='formactions.php?action=callremind&id={$resp->respid}&url={$eurl}&ref={$eref}' title='Send a Third reminder by phone call, click here when its done'>Remind by Phone</a>";
//else echo "<strike title='Already sent 3 reminders'>Remind</strike>";
// Find out whether the service level in use allows reopening
$slsql = "SELECT allow_reopen FROM `{$dbServiceLevels}` ";
$slsql .= "WHERE tag = '{$incident->servicelevel}' ";
$slsql .= "AND priority = '{$incident->priority}' LIMIT 1";
$slresult = mysql_query($slsql);
if (mysql_error()) {
trigger_error(mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($slresult) > 0) {
$allow_reopen_obj = mysql_fetch_object($slresult);
}
$allow_reopen = $allow_reopen_obj->allow_reopen;
if ($allow_reopen == 'yes') {
if (empty($submit)) {
// No submit detected show update form
$incident_title = incident_title($id);
$title = "{$strReopen}: " . $id . " - " . $incident_title;
include APPLICATION_INCPATH . 'incident_html_top.inc.php';
echo "<h2>{$strReopenIncident}</h2>";
if (!empty($updateid)) {
$action = "&updateid={$updateid}";
}
echo "<form action='{$_SERVER['PHP_SELF']}?id={$id}{$action}' method='post'>";
if (empty($updateid)) {
echo "<table class='vertical'>";
echo "<tr><th>{$strUpdate}</th><td><textarea name='bodytext' rows='20' ";
echo "cols='60'></textarea></td></tr>";
echo "<tr><th>{$strStatus}</th><td>" . incidentstatus_drop_down("newstatus", 1);
echo "</td></tr>\n";
echo "</table>";
} else {
while ($related = mysql_fetch_object($rresult)) {
if ($related->relatedid == $id) {
if ($related->relation == 'child') {
$linktitle = 'Child';
} else {
$linktitle = 'Sibling';
}
$linktitle .= ": " . incident_title($related->incidentid);
echo "<a href='incident_details.php?id={$related->incidentid}' title='{$linktitle}'>{$related->incidentid}</a> ";
} else {
if ($related->relation == 'child') {
$linktitle = 'Parent';
} else {
$linktitle = 'Sibling';
}
$linktitle .= ": " . incident_title($related->relatedid);
echo "<a href='incident_details.php?id={$related->relatedid}' title='{$linktitle}'>{$related->relatedid}</a> ";
}
echo " ";
}
echo "</td></tr>";
}
echo "</table>";
plugin_do('incident_details');
echo "</div>\n\n";
$offset = cleanvar($_REQUEST['offset']);
if (empty($offset)) {
$offset = 0;
}
/**
* @author Ivan Lucas
echo "<table summary='Related Incidents' align='center'>";
echo "<tr><th>{$strIncidentID}</th><th>{$strTitle}</th>";
echo "<th>{$strRelationship}</th><th>{$strCreatedBy}</th>";
echo "<th>{$strAction}</th></tr>\n";
while ($related = mysql_fetch_object($rresult)) {
echo "<tr>";
if ($related->relatedid == $id) {
$incidenttitle = incident_title($related->incidentid);
if ($related->relation == 'child') {
$relationship = 'Child';
} else {
$relationship = 'Sibling';
}
echo "<td><a href='incident_details.php?id={$related->incidentid}'>{$related->incidentid}</a></td>";
} else {
$incidenttitle = incident_title($related->relatedid);
if ($related->relation == 'child') {
$relationship = 'Parent';
} else {
$relationship = 'Sibling';
}
echo "<td><a href='incident_details.php?id={$related->relatedid}'>{$related->relatedid}</a></td>";
}
echo "<td>{$incidenttitle}</td>";
echo "<td>{$relationship}</td>";
echo "<td>" . user_realname($related->owner, TRUE) . "</td>";
echo "<td><a href='incident_relationships.php?id={$id}&rid={$related->id}&action=delete'>{$strRemove}</a></td>";
echo "</tr>\n";
}
echo "</table>";
} else {
