$blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in)); if ($task != "0") { $blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/listtasks.php?project=" . $projectDetail->pro_id[0], $strings["tasks"], in)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/viewtask.php?id=" . $taskDetail->tas_id[0], $taskDetail->tas_name[0], in)); } $blockPage->itemBreadcrumbs($strings["unlink_files"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "saC"; $block1->openForm("../linkedcontent/deletefiles.php?project={$project}&task={$task}&action=delete&id={$id}&sendto={$sendto}&" . session_name() . "=" . session_id()); $block1->heading($strings["unlink_files"]); $block1->openContent(); $block1->contentTitle($strings["delete_following"]); $id = str_replace("**", ",", $id); $tmpquery = "WHERE fil.id IN({$id}) ORDER BY fil.name"; $listFiles = new request(); $listFiles->openFiles($tmpquery); $comptListFiles = count($listFiles->fil_id); for ($i = 0; $i < $comptListFiles; $i++) { echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>" . $listFiles->fil_name[$i] . "</td></tr>"; } echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\"> <input type=\"BUTTON\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\"></td></tr>"; $block1->closeContent(); $block1->closeForm(); include '../themes/' . THEME . '/footer.php';
if ($existFile == "true") { echo " <a href=\"clientaccessfile.php?{$transmitSid}&mode=download&id=" . $listVersions->fil_id[$i] . "\">" . $strings["save"] . "</a>"; } else { echo $strings["missing_file"]; } echo "</td><td>" . $strings["date"] . " : " . $listVersions->fil_date[$i] . "</td></tr>"; } echo "</table></td></tr><br/>"; echo "</table></td></tr>\n\t</table>\t\t\t\t\t \n </td>\n </tr>\n</table>"; if ($peerReview == "true") { // Table 2 - LIST OF REVIEWS TABLE. echo "<table cellpadding=20 cellspacing=0 border=0 width=\"100%\">\n <tr>\n <td><h1 class=\"heading\">" . $strings["ifc_revisions"] . "</h1>\n\t<table cellspacing=\"0\" width=\"90%\" border=\"0\" cellpadding=\"3\" cols=\"4\">\n\t<tr height=\"15\"><th width=\"100%\" class=\"ModuleColumnHeaderSort\"><img src=\"../themes/" . THEME . "/spacer.gif\" width=\"1\" height=\"1\" border=\"0\"></th></tr>\n\t<tr><td width=\"40%\"><table cellpadding =\"0\" width=\"100%\" border=\"0\" cellpadding=\"0\">"; echo "<tr class=\"odd\"><td align=\"center\"><br/>"; $tmpquery = "WHERE fil.vc_parent = '{$id}' AND fil.vc_status != '3' ORDER BY fil.date"; $listReviews = new request(); $listReviews->openFiles($tmpquery); $comptListReviews = count($listReviews->fil_vc_parent); for ($i = 0; $i < $comptListReviews; $i++) { //Sort odds and evens for bg color if (!($i % 2)) { $class = "odd"; $highlightOff = $oddColor; } else { $class = "odd"; $highlightOff = $oddColor; } //Calculate a revision number for display for each listing $displayrev = $i + 1; echo "<table width=\"550\" cellpadding=\"0\" cellspacing=\"0\" class=\"tableRevision\" onmouseover=\"this.style.backgroundColor='" . $highlightOn . "'\" onmouseout=\"this.style.backgroundColor='" . $highlightOff . "'\">\n\t<tr class=\"reviewHeader\" height=\"25\"><td>"; echo " </td>\n\t<td colspan=\"3\">{$displayname} "; if ($listReviews->fil_task[$i] != "0") {
* the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. */ $checkSession = true; require_once "../includes/library.php"; if ($action == "update") { $commentField = convertData($commentField); $tmpquery1 = "UPDATE " . $tableCollab["files"] . " SET comments_approval='{$commentField}',date_approval='{$dateheure}',approver='" . $_SESSION['idSession'] . "',status='{$statusField}' WHERE id = '{$id}'"; connectSql("{$tmpquery1}"); $msg = "updateFile"; header("Location: doclists.php"); exit; } $tmpquery = "WHERE fil.id = '{$id}'"; $fileDetail = new request(); $fileDetail->openFiles($tmpquery); if ($fileDetail->fil_published[0] == "1" || $fileDetail->fil_project[0] != $_SESSION['projectSession']) { header("Location: index.php"); exit; } $bouton[4] = "over"; $titlePage = $strings["approval_tracking"]; require_once "include_header.php"; echo "<form accept-charset=\"UNKNOWN\" method=\"post\" action=\"../projects_site/docitemapproval.php?action=update\" name=\"documentitemapproval\" enctype=\"application/x-www-form-urlencoded\">"; echo "<table cellspacing=\"0\" width=\"90%\" border=\"0\" cellpadding=\"3\">\n<tr><th colspan=\"2\">" . $strings["approval_tracking"] . " :</th></tr>\n<tr><th>" . $strings["document"] . " :</th><td><a href=\"clientfiledetail.php?id=" . $fileDetail->fil_id[0] . "\">" . $fileDetail->fil_name[0] . "</a></td></tr>\n<tr><th>" . $strings["status"] . " :</th><td><select name=\"statusField\">"; $comptSta = count($statusFile); for ($i = 0; $i < $comptSta; $i++) { if ($fileDetail->fil_status[0] == $i) { echo "<option value=\"{$i}\" selected>{$statusFile[$i]}</option>"; } else { echo "<option value=\"{$i}\">{$statusFile[$i]}</option>";
** ** DESC: Screen: notification class ** ** HISTORY: ** 26/01/2004 - file notification ** 11/10/2004 - fix bug http://phpcollab.sourceforge.net/viewtopic.php?t=1642 ** 23/12/2004 - fix notification for linked content ** ----------------------------------------------------------------------------- ** TO-DO: ** ** ** ============================================================================= */ $tmpquery = "WHERE fil.id = '{$num}'"; $detailFile = new request(); $detailFile->openFiles($tmpquery); $tmpquery = "WHERE pro.id = '{$project}'"; $projectDetail = new request(); $projectDetail->openProjects($tmpquery); $tmpquery = "WHERE tea.project = '{$project}' AND tea.member != '{$idSession}' ORDER BY mem.id"; $listTeam = new request(); $listTeam->openTeams($tmpquery); $comptListTeam = count($listTeam->tea_id); for ($i = 0; $i < $comptListTeam; $i++) { $posters .= $listTeam->tea_member[$i] . ","; } // echo $posters; if (substr($posters, -1) == ",") { $posters = substr($posters, 0, -1); } if ($posters != "") {
$filesPublished = new request(); $filesPublished->openFiles($tmpquery); $comptFilesPublished = count($filesPublished->fil_id); if ($comptFilesPublished != "0") { for ($i = 0; $i < $comptFilesPublished; $i++) { $filesPublishedValue .= $filesPublished->fil_id[$i]; if ($i != $comptFilesPublished - 1) { $filesPublishedValue .= ","; } } $tmpquery1 = "UPDATE " . $tableCollab["files"] . " SET published='0' WHERE vc_parent IN ({$filesPublishedValue})"; connectSql("{$tmpquery1}"); } $tmpquery = "WHERE fil.published = '1'"; $filesPublishedNo = new request(); $filesPublishedNo->openFiles($tmpquery); $comptFilesPublishedNo = count($filesPublishedNo->fil_id); if ($comptFilesPublishedNo != "0") { for ($i = 0; $i < $comptFilesPublishedNo; $i++) { $filesPublishedNoValue .= $filesPublishedNo->fil_id[$i]; if ($i != $comptFilesPublishedNo - 1) { $filesPublishedNoValue .= ","; } } $tmpquery1 = "UPDATE " . $tableCollab["files"] . " SET published='1' WHERE vc_parent IN ({$filesPublishedNoValue})"; connectSql("{$tmpquery1}"); } echo "fixed :o)"; } ?>