/* 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"]; } }