$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 ($comptListProjects == "1") {
$blockPage->contentRow("", "1 " . $strings["match"]);
}
if ($comptListProjects > "1") {
$blockPage->contentRow("", $comptListProjects . " " . $strings["matches"]);
}
$block0->closeContent();
$block0->block_close();
if ($comptListProjects != "0") {
for ($j = 0; $j < $comptListProjects; $j++) {
$projectTitle = $listProjects->pro_name[$j];
$projectId = $listProjects->pro_id[$j];
$projectPriority = $listProjects->pro_priority[$j];
$blockProject = new block();
$blockProject->headingForm(buildLink("../projects/viewproject.php?id=" . $projectId, $projectTitle, LINK_INSIDE));
$blockProject->openContent();
// correct order????
$blockProject->contentTitle($strings["details"]);
$blockProject->contentRow($strings["priority"], "<img src=\"../themes/" . THEME . "/gfx_priority/" . $projectPriority . ".gif\" alt=\"\"> " . $priority[$projectPriority]);
$blockProject->contentRow($strings["created"], createDate($listProjects->pro_created[$j], $_SESSION['timezoneSession']));
$blockProject->contentRow($strings["modified"], createDate($listProjects->pro_modified[$j], $_SESSION['timezoneSession']));
if ($listProjects->pro_org_id[$j] == "1") {
$blockProject->contentRow($strings["organization"], $strings["none"]);
} else {
$blockProject->contentRow($strings["organization"], buildLink("../clients/viewclient.php?id=" . $listProjects->pro_org_id[$j], $listProjects->pro_org_name[$j], LINK_INSIDE));
}
$blockProject->contentRow($strings["status"], $status[$listProjects->pro_status[$j]]);
$queryTask = " WHERE tas.project = '{$projectId}'";
$tmpqueryTask = "{$queryTask} ORDER BY tas.due_date";
$blockProject->closeContent();
$blockProject->heading_close();
$block3->headingForm_close();
$block3->closeFormResults();
}
}
// Update file Block
if ($fileDetail->mat_owner[0] == $_SESSION['idSession']) {
$block4 = new block();
$block4->form = "filedetails";
echo "<a name=\"filedetailsAnchor\"></a>";
echo "<form accept-charset=\"UNKNOWN\" method=\"POST\" action=\"../meetings/viewfile.php?action=update&id=" . $fileDetail->mat_id[0] . "#filedetailsAnchor\" name=\"filedetailsForm\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"100000000\"><input type=\"hidden\" name=\"maxCustom\" value=\"" . $projectDetail->pro_upload_max[0] . "\">";
if ($error4 != "") {
$block4->headingError($strings["errors"]);
$block4->contentError($error4);
}
$block4->headingForm($strings["ifc_update_file"]);
$block4->openContent();
$block4->contentTitle($strings["details"]);
echo "\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"></td><td class=\"odd\">" . $strings["version_increm"] . "<br>\r\n\t<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n\t<tr><td align=\"right\">0.01</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"0.01\"></td></tr>\r\n\t<tr><td align=\"right\">0.1</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"0.1\" checked></td></tr>\r\n\t<tr><td align=\"right\">1.0</td><td width=\"30\" align=\"right\"><input name=\"change_file_version\" type=\"radio\" value=\"1.0\"></td></tr>\r\n\t</table>\r\n\t</td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["status"] . " :</td><td><select name=\"statusField\">";
$comptSta = count($statusFile);
for ($i = 0; $i < $comptSta; $i++) {
if ($i == "2") {
echo "<option value=\"{$i}\" selected>{$statusFile[$i]}</option>";
} else {
echo "<option value=\"{$i}\">{$statusFile[$i]}</option>";
}
}
echo "</select></td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">* " . $strings["upload"] . " :</td><td><input size=\"44\" style=\"width: 400px\" name=\"upload\" type=\"FILE\"></td></tr>\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><textarea rows=\"3\" style=\"width: 400px; height: 50px;\" name=\"c\" cols=\"43\">{$c}</textarea></td></tr>\r\n\t<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["ifc_update_file"] . "\"></td></tr>";
$block4->closeContent();
$block4->headingForm_close();
$block6->openRow($listNotes->note_id[$i]);
$block6->checkboxRow($listNotes->note_id[$i]);
$block6->cellRow(buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], LINK_INSIDE));
if ($comptTopic != "0") {
$block6->cellRow($topicNote[$listNotes->note_topic[$i]]);
}
$block6->cellRow($listNotes->note_date[$i]);
$block6->cellRow(buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], LINK_MAIL));
if ($sitePublish == "true") {
$block6->cellRow($statusPublish[$idPublish]);
}
$block6->closeRow();
}
$block6->closeResults();
$block6->bornesFooter("6", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}");
$block6->closeToggle();
$block3->headingForm_close();
$block6->closeFormResults();
/*$block6->openPaletteScript();
$block6->paletteScript(0,"export","../projects/exportproject.php?languageSession=" . $_SESSION['languageSession'] . "&type=project","false,true,false",$strings["export"]);
$block6->closePaletteScript($comptListNotes,$listNotes->note_id);*/
}
$block7 = new block();
$block7->form = "search";
$block7->openForm("../search/createsearch.php?action=search");
$block7->openContent();
$block7->contentTitle($strings["enter_keywords"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">* " . $strings["search_for"] . " :</td><td><input value=\"{$searchfor}\" type=\"text\" name=searchfor style=\"width: 200px;\" size=\"30\" maxlength=\"64\">\n<select name=\"heading\">\n\t\t<option selected value=\"ALL\" {$selectedAll}>" . $strings["all_content"] . "</option>\n\t\t<option value=\"notes\" {$selectedNotes}>" . $strings["notes"] . "</option>\n\t\t<option value=\"organizations\" {$selectedOrganizations}>" . $strings["organizations"] . "</option>\n\t\t<option value=\"projects\" {$selectedProjects}>" . $strings["projects"] . "</option>\n\t\t<option value=\"tasks\" {$selectedTasks}>" . $strings["tasks"] . "</option>\n\t\t<option value=\"discussions\" {$selectedDiscussions}>" . $strings["discussions"] . "</option>\n\t\t<option value=\"members\" {$selectedMembers}>" . $strings["users"] . "</option>\n</select>\n</td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["search"] . "\"></td></tr>";
$block7->closeContent();
$block7->closeForm();
require_once "../themes/" . THEME . "/footer.php";
echo " selected";
}
echo ">" . $strings['cal_personal'] . "</option>";
for ($t = 0; $t < $comptTeamList; $t++) {
echo "<option value=\"" . $teamList->tea_project[$t] . "\"";
if ($viewCalend == $teamList->tea_project[$t]) {
echo " selected";
}
echo ">" . $strings['project'] . ":" . $teamList->tea_pro_name[$t] . "</option>";
}
echo "</select></td></tr>";
$block9->closeForm();
//--- content -----
$block2 = new block();
$block2->headingForm("{$monthName} {$year}");
$block2->openContent();
echo "<tr><td>";
echo "<table border=0 cellpadding=0 cellspacing=2 width=100% class=listing><tr>";
for ($daynumber = 1; $daynumber < 8; $daynumber++) {
echo "<td width=14% class=calendDays> {$dayNameArray[$daynumber]}</td>";
}
echo "</tr>";
// Print the calendar
echo "<tr>";
if ($viewCalend == 0) {
$tmpquery = "WHERE tas.assigned_to = '" . $_SESSION['idSession'] . "' ORDER BY tas.name";
} else {
$tmpquery = "WHERE tas.project = '{$viewCalend}' ORDER BY tas.name";
}
$listTasks = new request();
$listTasks->openTasks($tmpquery);
$pageSection = 'reports';
require_once "../themes/" . THEME . "/header.php";
// start the first block
$block1 = new block();
$block1->form = "xwbT";
$block1->openForm("../reports/projectbreakdown.php#" . $block1->form . "Anchor");
$block1->openContent();
$block1->sorting("projects", $sortingUser->sor_projects[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "pro.name", 2 => "org.name", 3 => "pro.status"));
// $query = " WHERE pro.status = 1 ";
$tmpquery = "{$query} ORDER BY {$block1->sortingValue}";
// $tmpquery = $query;
$listProjects = new request();
$listProjects->openProjects($tmpquery);
$comptListProjects = count($listProjects->pro_id);
$block0 = new block();
$block0->openContent();
$block0->contentTitle($strings["report_results"]);
if ($comptListProjects == "0") {
$block1->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]);
}
if ($comptListProjects == "1") {
$block1->contentRow("", "1 " . $strings["match"]);
}
if ($comptListProjects > "1") {
$block1->contentRow("", $comptListProjects . " " . $strings["matches"]);
}
$block0->closeContent();
/*
$block1->openPaletteIcon();
$block1->paletteIcon(0,"export",$strings["export"]);
$block1->closePaletteIcon();
$p->set_var('VALUE_progress', '0');
$p->set_var('VALUE_start_date', date("Y/m/d"));
$p->set_var('VALUE_estimated_end_date', date("Y/m/d", mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"))));
$p->parse('output', 'task');
echo $p->finish($p->get_var('output'));
} else {
$block = new block();
$msg = 'permissiondenied';
include "includes/messages.php";
$block->messagebox($msgLabel);
if ($listTasks->parent_task[$i] == 0) {
$block->heading($strings["addTask"]);
} else {
$block->heading($strings["addSubtask"]);
}
$block->openContent();
$block->contentRow('', '<input type="button" name="goback" value="' . $strings['back'] . '" onClick="history.back();">');
$block->closeContent();
$block->closeForm();
}
echo COM_siteFooter();
exit;
break;
case 'view':
// View Task
$uid = $_USER[uid];
$taskrec = DB_fetchArray(DB_query("SELECT * FROM {$_TABLES['prj_tasks']} WHERE tid={$id}"));
$result = DB_query("SELECT pid, name FROM {$_TABLES['prj_projects']} WHERE pid={$taskrec['pid']}");
list($pid, $name) = DB_fetchArray($result);
//need to use the new permissions on this project here
$ownertoken = getTaskToken($id, $uid, "{$_TABLES['prj_task_users']}", "{$_TABLES['prj_tasks']}");
function upgrade2_4()
{
include "../languages/help_en.php";
$setTitle = "PhpCollab Upgrade";
$blank = "true";
include "../themes/" . THEME . "/block.class.php";
include '../themes/' . THEME . '/header.php';
//Get this file..
$script = "upgrade.php";
$step = getParameter('step');
if (empty($step)) {
$step = 1;
}
// Create new block and start the breadcrumbs
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs("<a href='../installation/{$script}'>Upgrade</a>");
//Content block
$block1 = new block();
if ($step == 1) {
$blockPage->itemBreadcrumbs("License");
$blockPage->closeBreadcrumbs();
$block1->heading("License");
$block1->openContent();
$block1->contentTitle(" ");
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n \t<pre>";
include "../docs/copying.txt";
echo "</pre>\n \t</td></tr>";
} elseif ($step == 2) {
$myError = null;
$blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=1'>License</a>");
$blockPage->itemBreadcrumbs("Check DB");
$blockPage->closeBreadcrumbs();
$block1->heading("Checking Database...");
$block1->openContent();
$block1->contentTitle("Database Requirements...");
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are currently checking the database to see if it needs to be updated... <br /><br /><b>Please wait...</b><br />\n \t</td></tr>";
flush();
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>";
if (checkDatabase($myError)) {
echo "<br />Database looks <font style='color: green'>good</font>. We are continuing the conversion...<br /><br />";
echo "<br />Continue on to <a href='../installation/{$script}?step=3&redirect=true'>Step 3</a>.<br /><br /><b>MAKE SURE SETTINGS.PHP IS WRITEABLE!!!</b><Br /><br />";
} else {
echo "<fieldset><legend style='font-weight: bold;font-size: large;padding: 5px;color: #ff3300'>";
echo "Error...</legend>";
echo "Sorry we could not upgrade your database at this time.. you will have to reinstall or do a manual upgrade...";
if (!empty($myError)) {
echo "<pre>{$myError}</pre>";
}
echo "</fieldset>";
}
echo "</td></tr>";
} elseif ($step == 3) {
$myError = null;
$blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=1'>License</a>");
$blockPage->itemBreadcrumbs("<a href='../installation/{$script}?step=2'>Check DB</a>");
$blockPage->itemBreadcrumbs("Conversion");
$blockPage->closeBreadcrumbs();
$block1->heading("Conversion and update");
$block1->openContent();
$block1->contentTitle("Checking Settings.php...");
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are making sure that settings.php is writeable, we can not continue if it's not writeable. <br /><br /><b>Please wait...</b><br />\n \t</td></tr>";
flush();
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>";
//TODO: Check file
$settingsFile = dirname(realpath(__FILE__)) . "/../includes/settings.php";
unset($goon);
$goon = false;
clearstatcache();
if (!is_writable($settingsFile)) {
echo "<fieldset><legend style='font-weight: bold;font-size: large;padding: 5px;color: #ff3300'>";
echo "Error...</legend>";
echo "Your settings file is not writeable. You need to either <b>chmod 666</b> the file or <b>chmod o+w</b> the file. Hit refresh to recheck.";
if (!empty($myError)) {
echo "<pre>{$myError}</pre>";
}
echo "</fieldset>";
} else {
echo "<br />Okay your settings.php file looks good, we are going to continue.<br />";
$goon = true;
}
echo "<br /></td></tr>";
if ($goon) {
//Next
$block1->contentTitle("Converting...");
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>\n We are now upgrading your database and writting the config file. <br /><br /><b>Please wait...</b><br />\n \t</td></tr>";
flush();
echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>";
if (convertDB()) {
echo "<br />Writting out new settings file...";
rewriteConfig($settingsFile, '2.5');
//Reload the Config so we can use the root
include $settingsFile;
echo "<b> done</b><br /><br />";
echo "<br /><B>Congratulations... if there was no error writting the file, you are done.<br />Click <a href=\"../\">here</a> to login.";
echo "<br><B>MAKE SURE TO DELETE UPGRADE.PHP!";
echo "</td></tr>";
echo "<h3>If you are upgrading from 2.4 to the latest version, please re-run this upgrade script to perform additi</h3>";
}
}
}
$block1->closeContent();
$stepNext = $step + 1;
if ($step < "2") {
echo "<form name='license' action='../installation/{$script}?step=2&redirect=true' method='post'><center><a href=\"javascript:document.license.submit();\"><br /><b>Step {$stepNext}</b></a><br /><br /></center></form><br/>";
}
$footerDev = "false";
include '../themes/' . THEME . '/footer.php';
//FOR DEBUG ****
exit;
// -----------------------
}
