$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)";
}
?>
