function taskNotification($pAssigneeID, $pTaskID, $pTypeOfChange)
{
if ($num == '') {
$num = $id;
}
$tmpquery = "WHERE tas.id IN({$pTaskID})";
$taskNoti = new request();
$taskNoti->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '{$project}'";
$projectNoti = new request();
$projectNoti->openProjects($tmpquery);
$tmpquery = "WHERE noti.member IN ({$pAssigneeID})";
$listNotifications = new request();
$listNotifications->openNotifications($tmpquery);
$comptListNotifications = count($listNotifications->not_id);
if ($listNotifications->not_taskassignment[0] == "0") {
$this->getUserinfo($idSession, "from");
$this->partSubject = $strings["noti_taskassignment1"];
$this->partMessage = $strings["noti_taskassignment2"];
if ($projectNoti->pro_org_id[0] == "1") {
$projectNoti->pro_org_name[0] = $strings["none"];
}
$complValue = $taskNoti->tas_completion[0] > 0 ? $taskNoti->tas_completion[0] . "0 %" : $taskNoti->tas_completion[0] . " %";
$idStatus = $taskNoti->tas_status[0];
$idPriority = $taskNoti->tas_priority[0];
$body = $this->partMessage . "\n\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . "\n" . $strings["start_date"] . " : " . $taskNoti->tas_start_date[0] . "\n" . $strings["due_date"] . " : " . $taskNoti->tas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $taskNoti->tas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
if ($taskNoti->tas_mem_organization[0] == "1") {
$body .= "{$root}/general/login.php?url=tasks/viewtask.php%3Fid={$num}";
} else {
if ($taskNoti->tas_mem_organization[0] != "1" && $projectNoti->pro_published[0] == "0" && $taskNoti->tas_published[0] == "0") {
$body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $projectNoti->pro_id[0];
}
}
$body .= "\n\n" . $this->footer;
$subject = $this->partSubject . " " . $taskNoti->tas_name[0];
$this->Subject = $subject;
if ($taskNoti->tas_priority[0] == "4" || $taskNoti->tas_priority[0] == "5") {
$this->Priority = "1";
} else {
$this->Priority = "3";
}
$this->Body = $body;
$this->AddAddress($listNotifications->not_mem_email_work[0], $listNotifications->not_mem_name[0]);
$this->Send();
$this->ClearAddresses();
}
}
connectSql("{$tmpquery1}");
if ($sendto == "filedetails") {
headerFunction("../linkedcontent/viewfile.php?id=" . $listFiles->fil_vc_parent[0] . "&msg=deleteFile&" . session_name() . "=" . session_id());
} else {
if ($task != "0") {
headerFunction("../tasks/viewtask.php?id={$task}&msg=deleteFile&" . session_name() . "=" . session_id());
exit;
} else {
headerFunction("../projects/viewproject.php?id={$project}&msg=deleteFile&" . session_name() . "=" . session_id());
exit;
}
}
}
$tmpquery = "WHERE pro.id = '{$project}'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
if ($task != "0") {
$tmpquery = "WHERE tas.id = '{$task}'";
$taskDetail = new request();
$taskDetail->openTasks($tmpquery);
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$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"]);
<?php
$tmpquery = "WHERE tas.id IN({$id})";
$taskNoti = new request();
$taskNoti->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '{$project}'";
$projectNoti = new request();
$projectNoti->openProjects($tmpquery);
$tmpquery = "WHERE noti.member IN({$at})";
$listNotifications = new request();
$listNotifications->openNotifications($tmpquery);
$comptListNotifications = count($listNotifications->not_id);
if ($listNotifications->not_statustaskchange[0] == "0") {
$mail = new notification();
$mail->getUserinfo($idSession, "from");
$mail->partSubject = $strings["noti_prioritytaskchange1"];
$mail->partMessage = $strings["noti_prioritytaskchange2"];
if ($projectNoti->pro_org_id[0] == "1") {
$projectNoti->pro_org_name[0] = $strings["none"];
}
$complValue = $taskNoti->tas_completion[0] > 0 ? $taskNoti->tas_completion[0] . "0 %" : $taskNoti->tas_completion[0] . " %";
$idStatus = $taskNoti->tas_status[0];
$idPriority = $taskNoti->tas_priority[0];
$body = $mail->partMessage . "\n\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . "\n" . $strings["start_date"] . " : " . $taskNoti->tas_start_date[0] . "\n" . $strings["due_date"] . " : " . $taskNoti->tas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $taskNoti->tas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
if ($taskNoti->tas_mem_organization[0] == "1") {
$body .= "{$root}/general/login.php?url=tasks/viewtask.php%3Fid={$id}";
} else {
if ($taskNoti->tas_mem_organization[0] != "1" && $projectNoti->pro_published[0] == "0" && $taskNoti->tas_published[0] == "0") {
$body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $projectNoti->pro_id[0];
}
}
if ($at == "0") {
$atProject = "1";
} else {
$atProject = $at;
}
$id = str_replace("**", ",", $id);
$tmpquery1 = "DELETE FROM " . $tableCollab["members"] . " WHERE id IN({$id})";
$tmpquery2 = "UPDATE " . $tableCollab["projects"] . " SET owner='{$atProject}' WHERE owner IN({$id})";
$tmpquery3 = "UPDATE " . $tableCollab["tasks"] . " SET assigned_to='{$at}' WHERE assigned_to IN({$id})";
$tmpquery4 = "UPDATE " . $tableCollab["assignments"] . " SET assigned_to='{$at}',assigned='{$dateheure}' WHERE assigned_to IN({$id})";
$tmpquery5 = "DELETE FROM " . $tableCollab["sorting"] . " WHERE member IN({$id})";
$tmpquery6 = "DELETE FROM " . $tableCollab["notifications"] . " WHERE member IN({$id})";
$tmpquery7 = "DELETE FROM " . $tableCollab["teams"] . " WHERE member IN({$id})";
$tmpquery = "WHERE pro.owner IN({$id})";
$listProjects = new request();
$listProjects->openProjects($tmpquery);
$comptListProjects = count($listProjects->pro_id);
for ($i = 0; $i < $comptListProjects; $i++) {
$listTeams->tea_id = "";
$listTeams->tea_project = "";
$listTeams->tea_member = "";
$listTeams->tea_published = "";
$listTeams->tea_authorized = "";
$listTeams->tea_mem_login = "";
$listTeams->tea_pro_id = "";
$tmpquery = "WHERE tea.project = '" . $listProjects->pro_id[$i] . "' AND tea.member = '{$atProject}'";
$listTeams = new request();
$listTeams->openTeams($tmpquery);
$comptListTeams = count($listTeams->tea_id);
if ($comptListTeams == "0") {
$tmpquery = "INSERT INTO " . $tableCollab["teams"] . "(project,member,published,authorized) VALUES('" . $listProjects->pro_id[$i] . "','{$atProject}','1','0')";
if ($i < $comptSuppTeamClient - 1) {
$membersTeam .= ',';
}
if ($htaccessAuth == 'true') {
$Htpasswd->initialize('../files/' . $id . '/.htpasswd');
$Htpasswd->deleteUser($suppTeamClient->mem_login[$i]);
}
}
$tmpquery4 = 'DELETE FROM ' . $tableCollab['teams'] . " WHERE project = '{$id}' AND member IN({$membersTeam})";
connectSql($tmpquery4);
}
}
// -------------------------------------------------------------------------------------------------
$tmpquery = "WHERE pro.id = '{$id}'";
$targetProject = new request();
$targetProject->openProjects($tmpquery);
// Delete old or unused phases
if ($targetProject->pro_phase_set[0] != $thisPhase) {
$tmpquery = 'DELETE FROM ' . $tableCollab['phases'] . " WHERE project_id = {$id}";
connectSql($tmpquery);
}
// Create new Phases
if ($targetProject->pro_phase_set[0] != $thisPhase) {
$comptThisPhase = count($phaseArraySets[$thisPhase]);
for ($i = 0; $i < $comptThisPhase; $i++) {
$tmpquery = 'INSERT INTO ' . $tableCollab['phases'] . "(project_id,order_num,status,name) VALUES('{$id}','{$i}','0','" . $phaseArraySets[$thisPhase][$i] . "')";
connectSql($tmpquery);
}
// Get a listing of project tasks and files and re-assign them to new phases if the phase set of a project is changed.
$tmpquery = "WHERE tas.project = '" . $targetProject->pro_id[0] . "'";
$listTasks = new request();
if ($validProjects == "true") {
$block1->recordsTotal = compt($initrequest["projects"] . " " . $tmpquery);
$listProjects = new request();
$listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListProjects = count($listProjects->pro_id);
// echo "$tmpquery<br>";
}
$block2 = new block();
$block2->borne = $blockPage->returnBorne("2");
$block2->rowsLimit = "10";
$block2->sorting("home_tasks", $sortingUser->sor_home_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.name", 1 => "tas.priority", 2 => "tas.status", 3 => "tas.due_date", 4 => "mem.login", 5 => "tas.project", 6 => "tas.published"));
if ($projectsFilter == "true") {
$tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
$tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '" . $_SESSION['idSession'] . "' ORDER BY pro.id";
$listProjectsFilter = new request();
$listProjectsFilter->openProjects($tmpquery);
$comptListProjectsFilter = count($listProjectsFilter->pro_id);
if ($comptListProjectsFilter != "0") {
for ($i = 0; $i < $comptListProjectsFilter; $i++) {
$filterResults .= $listProjectsFilter->pro_id[$i];
if ($comptListProjectsFilter - 1 != $i) {
$filterResults .= ",";
}
}
}
}
if ($projectsFilter == "true") {
if ($comptListProjectsFilter != "0") {
$tmpquery = "{$searchTasks} AND pro.id IN({$filterResults}) ORDER BY {$block2->sortingValue}";
} else {
$validTasks = "false";
$selected = "";
if ($client_id == $clients->org_id[$i]) {
$selected = " selected";
}
echo "<option value='" . $clients->org_id[$i] . "'" . $selected . ">" . $clients->org_name[$i] . "{$clientUser}</option>";
}
echo "</select><input type='SUBMIT' value='update'>" . "</td></tr>";
//*** Projet ***
if ($client_id == 0 || $client_id == "") {
$client_id = 0;
}
$tmpquery = " WHERE org.id = " . $client_id;
$tmpquery .= $project_query_type;
$tmpquery .= " ORDER BY pro.name";
$projets = new request();
$projets->openProjects($tmpquery);
$comptProjects = count($projets->pro_id);
echo "\n\t<tr class='even'>\n\t <td valign='top' class='leftvalue'>" . $strings['projects'] . " :</td>\n\t <td><select name='project_id' ";
if ($comptProjects <= 1) {
$event = "Blur";
} else {
$event = "Change";
}
echo "on" . $event . "='this.form.submit();'>";
// get Clients listing
for ($i = 0; $i < $comptProjects; $i++) {
$selected = "";
if ($project_id == $projets->pro_id[$i]) {
$selected = " selected";
}
echo "<option value='" . $projets->pro_id[$i] . "'" . $selected . ">" . $projets->pro_name[$i] . "{$clientUser}</option>";
}
}
if ($enableHelpSupport != "true") {
header("Location: ../general/permissiondenied.php");
exit;
}
if ($supportType == "admin") {
if ($_SESSION['profilSession'] != "0") {
header("Location: ../general/permissiondenied.php");
exit;
}
}
if ($supportType == "team") {
$tmpquery = "WHERE pro.id = '{$project}'";
$requestProject = new request();
$requestProject->openProjects($tmpquery);
}
//--- header ---
$pageSection = 'projects';
if ($supportType == "team") {
$breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $requestProject->pro_id[0], $requestProject->pro_name[0], LINK_INSIDE);
$breadcrumbs[] = buildLink("../support/listrequests.php?id=" . $requestProject->pro_id[0], $strings["support_requests"], LINK_INSIDE);
} else {
if ($supportType == "admin") {
$breadcrumbs[] = buildLink("../administration/admin.php?", $strings["administration"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../administration/support.php?", $strings["support_management"], LINK_INSIDE);
}
}
if ($action == "new") {
$breadcrumbs[] = $strings["new_requests"];
} else {
$tmpquery = "WHERE pro.status IN(0,1,4) ORDER BY {$block1->sortingValue}";
}
} else {
if ($typeProjects == "active") {
if ($projectsFilter == "true") {
$tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
$tmpquery .= "WHERE pro.status IN(2,3) AND teams.member = '{$idSession}' ORDER BY {$block1->sortingValue}";
} else {
$tmpquery = "WHERE pro.status IN(2,3) ORDER BY {$block1->sortingValue}";
}
}
}
$block1->recordsTotal = compt($initrequest["projects"] . " " . $tmpquery);
$listProjects = new request();
$listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListProjects = count($listProjects->pro_id);
if ($comptListProjects != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["id"], 1 => $strings["project"], 2 => $strings["priority"], 3 => $strings["organization"], 4 => $strings["status"], 5 => $strings["owner"], 6 => $strings["project_site"]), "true");
for ($i = 0; $i < $comptListProjects; $i++) {
if ($listProjects->pro_org_id[$i] == "1") {
$listProjects->pro_org_name[$i] = $strings["none"];
}
$idStatus = $listProjects->pro_status[$i];
$idPriority = $listProjects->pro_priority[$i];
$block1->openRow();
$block1->checkboxRow($listProjects->pro_id[$i]);
$block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_id[$i], in));
$block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], in));
$block1->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);
}
if ($_GET['action'] == "removeToSite") {
$tmpquery1 = "UPDATE " . $tableCollab["topics"] . " SET published='1' WHERE id = '" . $_GET['id'] . "'";
connectSql("{$tmpquery1}");
$msg = "removeToSite";
}
$tmpquery = "WHERE topic.id = '{$id}'";
$detailTopic = new request();
$detailTopic->openTopics($tmpquery);
$tmpquery = "WHERE pos.topic = '" . $detailTopic->top_id[0] . "' ORDER BY pos.created DESC";
$listPosts = new request();
$listPosts->openPosts($tmpquery);
$comptListPosts = count($listPosts->pos_id);
$tmpquery = "WHERE pro.id = '" . $detailTopic->top_project[0] . "'";
$detailProject = new request();
$detailProject->openProjects($tmpquery);
$teamMember = "false";
$tmpquery = "WHERE tea.project = '" . $detailTopic->top_project[0] . "' AND tea.member = '" . $_SESSION['idSession'] . "'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == "0") {
$teamMember = "false";
} else {
$teamMember = "true";
}
if ($teamMember == "false" && $projectsFilter == "true") {
header("Location:../general/permissiondenied.php");
exit;
}
if ($detailProject->pro_org_id[0] == "1") {
$block1->openPaletteIcon();
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
//$block1->paletteIcon(0,"add",$strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
}
$block1->paletteIcon(2, "info", $strings["view"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
$block1->paletteIcon(3, "edit", $strings["edit"]);
}
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "20";
$block1->sorting("invoices", $sortingUser->sor_invoices[0], "inv.id ASC", $sortingFields = array(0 => "inv.id", 1 => "pro.name", 2 => "inv.total_inc_tax", 3 => "inv.date_sent", 4 => "inv.published"));
$tmpquery = "WHERE pro.owner = '{$idSession}' ORDER BY pro.id";
$projectsTest = new request();
$projectsTest->openProjects($tmpquery);
$comptProjectsTest = count($projectsTest->pro_id);
if ($comptProjectsTest == "0") {
$listProjects = "false";
} else {
for ($i = 0; $i < $comptProjectsTest; $i++) {
$projectsOk .= $projectsTest->pro_id[$i];
if ($comptProjectsTest - 1 != $i) {
$projectsOk .= ",";
}
}
if ($projectsOk == "") {
$listProjects = "false";
} else {
$tmpquery = "WHERE inv.project IN({$projectsOk}) AND inv.active = '1' AND inv.status = '{$status}' ORDER BY {$block1->sortingValue}";
}
