$block6->sorting("notes", $sortingUser->sor_notes[0], "note.date DESC", $sortingFields = array(0 => "note.subject", 1 => "note.date", 2 => "mem.login", 3 => "note.published")); } if ($projectsFilter == "true") { if ($comptListProjectsFilter != "0") { $tmpquery = "{$searchNotes} AND note.project IN({$filterResults}) ORDER BY {$block6->sortingValue}"; } else { $validNotes = "false"; } } else { $tmpquery = "{$searchNotes} ORDER BY {$block6->sortingValue}"; } $comptListNotes = "0"; if ($validNotes == "true") { $block6->recordsTotal = compt($initrequest["notes"] . " " . $tmpquery); $listNotes = new request(); $listNotes->openNotes($tmpquery, $block6->borne, $block6->rowsLimit); $comptListNotes = count($listNotes->note_id); // echo "$tmpquery<br>"; } $comptTotal = $block1->recordsTotal + $block2->recordsTotal + $block3->recordsTotal + $block4->recordsTotal + $block5->recordsTotal + $block6->recordsTotal; $blockPage = new block(); $blockPage->bornesNumber = "6"; $block0 = new block(); $block0->openContent(); $block0->contentTitle($strings["results_for_keywords"] . " : <b>{$searchfor}</b>"); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>"; if ($comptTotal == "1") { echo "1 " . $strings["match"]; } if ($comptTotal > "1" || $comptTotal == "0") { echo "{$comptTotal} " . $strings["matches"];
if ($action == "publish") { if ($addToSite == "true") { $tmpquery1 = "UPDATE " . $tableCollab["notes"] . " SET published='0' WHERE id = '{$id}'"; connectSql("{$tmpquery1}"); $msg = "addToSite"; } if ($removeToSite == "true") { $tmpquery1 = "UPDATE " . $tableCollab["notes"] . " SET published='1' WHERE id = '{$id}'"; connectSql("{$tmpquery1}"); $msg = "removeToSite"; } } include '../themes/' . THEME . '/header.php'; $tmpquery = "WHERE note.id = '{$id}'"; $noteDetail = new request(); $noteDetail->openNotes($tmpquery); $tmpquery = "WHERE pro.id = '" . $noteDetail->note_project[0] . "'"; $projectDetail = new request(); $projectDetail->openProjects($tmpquery); $teamMember = "false"; $tmpquery = "WHERE tea.project = '" . $noteDetail->note_project[0] . "' AND tea.member = '{$idSession}'"; $memberTest = new request(); $memberTest->openTeams($tmpquery); $comptMemberTest = count($memberTest->tea_id); if ($comptMemberTest == "0") { $teamMember = "false"; } else { $teamMember = "true"; } $blockPage = new block(); $blockPage->openBreadcrumbs();
if ($action == "delete") { $id = str_replace("**", ",", $id); $tmpquery1 = "DELETE FROM " . $tableCollab["notes"] . " WHERE id IN({$id})"; connectSql("{$tmpquery1}"); header("Location: ../projects/viewproject.php?id={$project}&msg=delete"); exit; } //--- header --- $breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE); $breadcrumbs[] = $strings["delete_note"]; require_once "../themes/" . THEME . "/header.php"; //--- content --- $block1 = new block(); $block1->form = "saP"; $block1->openForm("../notes/deletenotes.php?project={$project}&action=delete&id={$id}"); $block1->headingForm($strings["delete_note"]); $block1->openContent(); $block1->contentTitle($strings["delete_following"]); $id = str_replace("**", ",", $id); $tmpquery = "WHERE note.id IN({$id}) ORDER BY note.subject"; $listNotes = new request(); $listNotes->openNotes($tmpquery); $comptListNotes = count($listNotes->note_id); for ($i = 0; $i < $comptListNotes; $i++) { $block1->contentRow("#" . $listNotes->note_id[$i], $listNotes->note_subject[$i]); } $block1->contentRow("", "<input type=\"submit\" name=\"delete\" value=\"" . $strings["delete"] . "\"> <input type=\"button\" name=\"cancel\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\">"); $block1->closeContent(); $block1->headingForm_close(); $block1->closeForm(); require_once "../themes/" . THEME . "/footer.php";