$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";
