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