/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: noti_newrequest.php,v 1.2 2004/12/13 00:18:26 madbear Exp $
*
* Copyright (c) 2003 by the NetOffice developers
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
$mail = new notification();
$mail->getUserinfo($_SESSION['idSession'], "from");
$tmpquery = "WHERE sr.id = '{$num}'";
$requestDetail = new request();
$requestDetail->openSupportRequests($tmpquery);
if ($supportType == "team") {
$tmpquery = "WHERE tea.project = '" . $requestDetail->sr_project[0] . "'";
$listTeam = new request();
$listTeam->openTeams($tmpquery);
$comptListTeam = count($listTeam->tea_id);
for ($i = 0; $i < $comptListTeam; $i++) {
if ($_SESSION['idSession'] == $listTeam->tea_mem_id[$i]) {
$mail->partSubject = $strings["support"] . " " . $strings["support_id"];
$mail->partMessage = $strings["noti_support_request_new2"];
$subject = $mail->partSubject . ": " . $requestDetail->sr_id[0];
$body = $mail->partMessage . "";
$body .= "" . $requestDetail->sr_subject[0] . "";
} else {
$mail->partSubject = $strings["support"] . " " . $strings["support_id"];
$mail->partMessage = $strings["noti_support_team_new2"];
if ($msg != "") {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
if ($enableHelpSupport == "true") {
$tmpquery = "WHERE sr.status = '0'";
$listNewRequests = new request();
$listNewRequests->openSupportRequests($tmpquery);
$comptListNewRequests = count($listNewRequests->sr_id);
$tmpquery = "WHERE sr.status = '1'";
$listOpenRequests = new request();
$listOpenRequests->openSupportRequests($tmpquery);
$comptListOpenRequests = count($listOpenRequests->sr_id);
$tmpquery = "WHERE sr.status = '2'";
$listCompleteRequests = new request();
$listCompleteRequests->openSupportRequests($tmpquery);
$comptListCompleteRequests = count($listCompleteRequests->sr_id);
$block1 = new block();
$block1->form = "help";
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->heading($strings["support_requests"]);
$block1->openContent();
$block1->contentTitle($strings["information"]);
$block1->contentRow($strings["new_requests"], "{$comptListNewRequests} - " . $blockPage->buildLink("../support/support.php?action=new", $strings["manage_new_requests"], in) . "<br/><br/>");
$block1->contentRow($strings["open_requests"], "{$comptListOpenRequests} - " . $blockPage->buildLink("../support/support.php?action=open", $strings["manage_open_requests"], in) . "<br/><br/>");
$block1->contentRow($strings["closed_requests"], "{$comptListCompleteRequests} - " . $blockPage->buildLink("../support/support.php?action=complete", $strings["manage_closed_requests"], in) . "<br/><br/>");
$block1->closeContent();
}
$block1->heading($strings["support_requests"]);
if ($teamMember == "true" || $profilSession == "0") {
$block1->openPaletteIcon();
//$block1->paletteIcon(0,"add",$strings["add"]);
$block1->paletteIcon(1, "edit", $strings["edit_status"]);
$block1->paletteIcon(2, "remove", $strings["delete"]);
$block1->paletteIcon(3, "info", $strings["view"]);
$block1->closePaletteIcon();
}
$block1->sorting("support_requests", $sortingUser->sor_support_requests[0], "sr.id ASC", $sortingFields = array(0 => "sr.id", 1 => "sr.subject", 2 => "sr.priority", 3 => "sr.status", 4 => "sr.date_open", 5 => "sr.date_close"));
/*$tmpquery = "WHERE mem.id = '$idSession'";
$userDetail = new request();
$userDetail->openMembers($tmpquery);*/
$tmpquery = "WHERE sr.project = '{$id}' ORDER BY {$block1->sortingValue}";
$listRequests = new request();
$listRequests->openSupportRequests($tmpquery);
$comptListRequests = count($listRequests->sr_id);
if ($comptListRequests != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["id"], 1 => $strings["subject"], 2 => $strings["priority"], 3 => $strings["status"], 4 => $strings["date_open"], 5 => $strings["date_close"]), "false");
for ($i = 0; $i < $comptListRequests; $i++) {
$comptSta = count($requestStatus);
for ($sr = 0; $sr < $comptSta; $sr++) {
if ($listRequests->sr_status[$i] == $sr) {
$currentStatus = $requestStatus[$sr];
}
}
$comptPri = count($priority);
for ($rp = 0; $rp < $comptPri; $rp++) {
if ($listRequests->sr_priority[$i] == $rp) {
$requestPriority = $priority[$rp];
}
if ($action == "deleteR") {
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE sr.id IN({$id}) ORDER BY sr.subject";
$listRequest = new request();
$listRequest->openSupportRequests($tmpquery);
$comptListRequest = count($listRequest->sr_id);
} elseif ($action == "deleteP") {
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE sp.id IN({$id}) ORDER BY sp.id";
$listPost = new request();
$listPost->openSupportPosts($tmpquery);
$comptListPost = count($listPost->sp_id);
$tmpquery2 = "WHERE sr.id IN(" . $listPost->sp_request_id[0] . ") ORDER BY sr.subject";
$listRequest = new request();
$listRequest->openSupportRequests($tmpquery2);
$comptListRequest = count($listRequest->sr_id);
}
//--- header ---
$pageSection = 'projects';
if ($supportType == "team") {
$breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $listRequest->sr_project[0], $listRequest->sr_pro_name[0], LINK_INSIDE);
$breadcrumbs[] = buildLink("../support/listrequests.php?id=" . $listRequest->sr_project[0], $strings["support_requests"], LINK_INSIDE);
if ($action == "deleteR") {
$breadcrumbs[] = $strings["delete_request"];
} else {
if ($action == "deleteP") {
$breadcrumbs[] = $strings["delete_support_post"];
}
}
