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(); } }
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"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel);
$block9->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']); } $block9->closePaletteScript($comptListMilestones, $listMilestones->tas_id); $block10 = new block(); //--- block header ---- $block10->form = 'wbTuuC'; $block10->openForm("../phases/listphases.php?id={$id}#" . $block10->form . "Anchor"); $block10->sorting('tasks_closed', $sortingUser->sor_tasks_closed[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'tas.parent_phase', 'mem.login', 'tas.published')); $block10->borne = $blockPage->returnBorne('1'); $block10->rowsLimit = '20'; //--- get data from sql --------- $tmpquery = "WHERE tas.project = '{$id}' AND tas.status NOT IN(0,2,3) AND tas.milestone = '1' ORDER BY {$block10->sortingValue}"; $block10->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery); //--- list --------- $listTasks = new request(); $listTasks->openTasks($tmpquery, $block10->borne, $block10->rowsLimit); $comptListTasks = count($listTasks->tas_id); $block10->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>'); $block10->openPaletteIcon(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block10->paletteIcon(0, 'add', $strings['add']); $block10->paletteIcon(1, 'remove', $strings['delete']); $block10->paletteIcon(2, 'copy', $strings['copy']); // $block10->paletteIcon(3,'export',$strings['export']); if ($sitePublish == 'true') { $block10->paletteIcon(4, 'add_projectsite', $strings['add_project_site']); $block10->paletteIcon(5, 'remove_projectsite', $strings['remove_project_site']); } } $block10->paletteIcon(6, 'info', $strings['view']); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
<?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]; } }
* Copyright (c) 2003 by the NetOffice developers * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. */ $projectSite = "true"; $checkSession = true; require_once "../includes/library.php"; $bouton[2] = "over"; $titlePage = $strings["team_tasks"]; require_once "include_header.php"; $tmpquery = "WHERE tas.project = '" . $_SESSION['projectSession'] . "' AND tas.assigned_to != '0' AND tas.published = '0' AND tas.milestone <> '0' AND mem.organization = '1' ORDER BY tas.name"; $listTasks = new request(); $listTasks->openTasks($tmpquery); $comptListTasks = count($listTasks->tas_id); $block1 = new block(); $block1->headingForm($strings["team_tasks"]); if ($comptListTasks != "0") { if ($activeJpgraph == "true") { // show the expanded or compact Gantt Chart if ($_GET['base'] == 1) { echo "<a href='showallteamtasks.php'>expand</a><br>"; } else { echo "<a href='showallteamtasks.php?base=1'>compact</a><br>"; } echo "<img src=\"graphtasks.php?project=" . $projectDetail->pro_id[0] . '&base=' . $_GET['base'] . "\" alt=\"\"><br>\r\n<span class=\"listEvenBold\">Powered by <a href=\"http://www.aditus.nu/jpgraph/\" target=\"_blank\">JpGraph</a></span><br><br>"; } echo "<table cellspacing=\"0\" width=\"90%\" border=\"0\" cellpadding=\"3\" cols=\"4\" class=\"listing\">\r\n<tr><th class=\"active\">" . $strings["name"] . "</th><th>" . $strings["description"] . "</th><th>" . $strings["status"] . "</th><th>" . $strings["due"] . "</th></tr>"; for ($i = 0; $i < $comptListTasks; $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>"; } echo "</select><input type='SUBMIT' value='update'>" . "</td></tr>"; //*** Tache *** if ($project_id == 0 || $project_id == "") { $project_id = 0; } $tmpquery = " WHERE tas.project = " . $project_id; $tmpquery .= $task_query_type; $tmpquery .= " ORDER BY tas.name"; $tasks = new request(); $tasks->openTasks($tmpquery); $comptTasks = count($tasks->tas_id); echo "\n\t<tr class='odd'>\n\t <td valign='top' class='leftvalue'>" . $strings['tasks'] . " :</td>\n\t <td><select name='task_id'>"; // get Clients listing for ($i = 0; $i < $comptTasks; $i++) { $selected = ""; if ($task_id == $tasks->tas_id[$i]) { $selected = " selected"; } echo "<option value='" . $tasks->tas_id[$i] . "'" . $selected . ">" . $tasks->tas_name[$i] . "</option>"; } //*** Travailleur *** $tmpquery = " WHERE mem.profil != 3 AND mem.profil!= 0"; $tmpquery .= " ORDER BY mem.name"; $projmem = new request(); $projmem->openMembers($tmpquery);
//--- block header ---- $block3->form = 'saTlC'; $block3->openForm("../tasks/listtasks.php?project={$project}#" . $block3->form . "Anchor"); if (isset($flag_phases) && $flag_phases == true) { $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[0], "tas.due_date ASC", $sortingFields = array("tas.priority", "tas.name", "tas.status", "tas.completion", "tas.due_date", 'tas.parent_phase', "mem.login", "tas.published")); } else { $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[0], "tas.due_date ASC", $sortingFields = array("tas.priority", "tas.name", "tas.status", "tas.completion", "tas.due_date", "mem.login", "tas.published")); } $block3->borne = $blockPage->returnBorne('1'); $block3->rowsLimit = '20'; //--- get data from sql --------- $tmpquery = "WHERE tas.project = '{$project}' AND tas.status NOT IN(0,2,3,5) AND tas.milestone = '1' ORDER BY {$block3->sortingValue}"; $block3->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery); //--- list --------- $listClosedTasks = new request(); $listClosedTasks->openTasks($tmpquery, $block3->borne, $block3->rowsLimit); $comptListTasks = count($listClosedTasks->tas_id); $block3->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>'); $block3->openPaletteIcon(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block3->paletteIcon(0, 'add', $strings['add']); $block3->paletteIcon(1, 'remove', $strings['delete']); $block3->paletteIcon(2, 'copy', $strings['copy']); // $block3->paletteIcon(3,'export',$strings['export']); if ($sitePublish == 'true') { $block3->paletteIcon(4, 'add_projectsite', $strings['add_project_site']); $block3->paletteIcon(5, 'remove_projectsite', $strings['remove_project_site']); } } $block3->paletteIcon(6, 'info', $strings['view']); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$listPhases = new request(); $listPhases->openPhases($queryPhase); $comptListPhases = count($listPhases->pha_id); $blockProject->openResults($checkbox = "false"); // $blockProject->labels($labels = array(0=>$strings["phase"],1=>$strings["status"],2=>$strings["total_tasks"],3=>$strings["uncomplete_tasks"],4=>$strings["date_start"],5=>$strings["date_end"],6=>$strings['completion']),"true"); $blockProject->labels($labels = array(0 => $strings["phase"], 1 => $strings["status"], 2 => $strings["total_tasks"], 3 => $strings["uncomplete_tasks"], 4 => $strings["date_start"], 5 => $strings["date_end"]), "true"); if ($comptListProjects != "0") { for ($i = 0; $i < $comptListPhases; $i++) { $phaseNum = $listPhases->pha_order_num[$i]; $phaseName = $listPhases->pha_name[$i]; $phaseStart = $listPhases->pha_date_start[$i]; $phaseEnd = $listPhases->pha_date_end[$i]; $tmpquery = "WHERE tas.project = '{$projectId}' "; $tmpquery .= "AND tas.parent_phase = '{$phaseNum}'"; $countPhaseTasks = new request(); $countPhaseTasks->openTasks($tmpquery); $comptlistTasks = count($countPhaseTasks->tas_id); $comptlistTasksRow = "0"; $comptUncompleteTasks = "0"; $phaseCompleted = 0; for ($k = 0; $k < $comptlistTasks; $k++) { if ($phaseNum == $countPhaseTasks->tas_parent_phase[$k]) { $comptlistTasksRow = $comptlistTasksRow + 1; if ($countPhaseTasks->tas_status[$k] == "2" || $countPhaseTasks->tas_status[$k] == "3" || $countPhaseTasks->tas_status[$k] == "4") { $comptUncompleteTasks = $comptUncompleteTasks + 1; } } if ($countPhaseTasks->tas_start_date[$k] != "--" and $countPhaseTasks->tas_start_date[$k] != "") { if ($phaseStart == "--" or $phaseStart == "") { $phaseStart = $countPhaseTasks->tas_start_date[$k]; }
echo "<option value='" . ALL_WORKERS . "' selected>-- " . $strings["all_workers"] . " --</option>"; for ($i = 0; $i < $comptProjmem; $i++) { $selected = ""; if (($worker_id == $projmem->mem_id[$i] || $worker_id == 0 && $_SESSION['idSession'] == $projmem->mem_id[$i]) && $worker_id != ALL_WORKERS) { $selected = " selected"; } echo "<option value='" . $projmem->mem_id[$i] . "'" . $selected . ">" . $projmem->mem_name[$i] . "{$clientUser}</option>"; } echo "</select>"; //" " . //buildLink("../_addon/timesheets_report.php?dateCalend=$dateCalend&worker_id=".ALL_WORKERS, $strings["all_workers"], LINK_INSIDE); //*** Off Type *** $tmpquery = " WHERE tas.id IN (" . implode(",", $aOffDayTypes) . ")"; $tmpquery .= " ORDER BY tas.name ASC"; $taskTypes = new request(); $taskTypes->openTasks($tmpquery); $comptTaskTypes = count($taskTypes->tas_id); echo " <select name='offType' onChange=\"this.form.submit();\">"; echo "<option value='" . ALL_OFF_TYPES . "' selected>-- " . $strings["all_off_types"] . " --</option>"; for ($i = 0; $i < $comptTaskTypes; $i++) { $selected = ""; if ($offType == $taskTypes->tas_id[$i] && $offType != ALL_OFF_TYPES) { $selected = " selected"; } echo "<option value='" . $taskTypes->tas_id[$i] . "'" . $selected . ">" . $taskTypes->tas_name[$i] . "</option>"; } echo "</select>"; //" " . //buildLink("../_addon/timesheets_report.php?dateCalend=$dateCalend&worker_id=".ALL_WORKERS, $strings["all_workers"], LINK_INSIDE); } echo "</form>";
$c = convertData($c); if ($st == 0) { $ed = "--"; } if ($st == 1) { $ed = "--"; } if ($st == 2 && $ed == "--") { $ed = date('Y-m-d'); } $tmpquery = "UPDATE " . $tableCollab["phases"] . " SET status='{$st}', date_start='{$sd}', date_end='{$ed}', comments='{$c}' WHERE id = '{$id}'"; connectSql("{$tmpquery}"); if ($st != 1) { $tmpquery = "WHERE tas.parent_phase = '{$id}' AND tas.status = '3'"; $changeTasks = new request(); $changeTasks->openTasks($tmpquery); $comptchangeTasks = count($changeTasks->tas_id); for ($i = 0; $i < $comptchangeTasks; $i++) { $taskID = $changeTasks->tas_id[$i]; $tmpquery = "UPDATE " . $tableCollab["tasks"] . " SET status='4' WHERE id = '{$taskID}'"; connectSql("{$tmpquery}"); } } header("Location: ../phases/viewphase.php?id={$id}"); exit; } //--- header --- $breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE); $breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], LINK_INSIDE); $breadcrumbs[] = $phaseDetail->pha_name[0]; require_once "../themes/" . THEME . "/header.php";
function getInitalOff($worker_id, $off_id = TASKTYPE_LEGAL_OFF) { global $default_days_off, $default_days_off_other, $dayHours, $strings, $year, $aOffDayTypes; global $remaining_off_hours, $off_hours_message; if ($worker_id) { $task_owner = $worker_id; } else { $task_owner = $_SESSION["idSession"]; } if ($off_id == ALL_OFF_TYPES) { $off_id_list = "("; for ($local_off_type = 0; $local_off_type <= count($aOffDayTypes); $local_off_type++) { $off_id_list .= "(tas.name LIKE '%- " . $aOffDayTypes[$local_off_type] . " -%')"; if ($local_off_type < count($aOffDayTypes)) { $off_id_list .= " OR "; } } $off_id_list .= ")"; } else { $off_id_list = "tas.name LIKE '%- " . $off_id . " -%'"; } $query = "WHERE (tas.name LIKE '%- {$task_owner} -%' AND {$off_id_list} AND tas.name LIKE '%- {$year} -%' AND pro.id = " . DAYSOFF_PROJECT . ")"; // echo $query."<br/>"; $off_hours = new request(); $off_hours->openTasks($query, "", 1); $comptOffHours = count($off_hours->tas_id); if ($comptOffHours > 0) { //Add all off day types $off_type_index = 0; $remaining_off_hours = 0; while ($off_type_index < count($off_hours->tas_estimated_time)) { $remaining_off_hours += $off_hours->tas_estimated_time[$off_type_index]; $off_type_index++; } $off_hours_message = $strings["specific"]; } else { if ($off_id == TASKTYPE_LEGAL_OFF) { $remaining_off_hours = $default_days_off * $dayHours; } else { if ($off_id == ALL_OFF_TYPES) { $remaining_off_hours = ($default_days_off + $default_days_off_other) * $dayHours; } else { $remaining_off_hours = $default_days_off_other * $dayHours; } } $off_hours_message = $strings["default"]; } }
function projectComputeCompletion($projectDetail, $tableProject) { $prj_name = $projectDetail->pro_name[0]; preg_match("/\\[([0-9 ]*\\/[0-9 ]*)\\]/", $prj_name, $findit); if ($findit[1] != "") { $prj_id = $projectDetail->pro_id[0]; $taskDetails = new request(); $tmpquery = "WHERE tas.project = '{$prj_id}'"; $taskDetails->openTasks($tmpquery); $tasksNumb = count($taskDetails->tas_id); $tasksCompleted = 0; foreach ($taskDetails->tas_status as $stat) { if ($stat == 1) { $tasksCompleted++; } } $prj_name = preg_replace("/\\[[0-9 ]*\\/[0-9 ]*\\]/", "[ {$tasksCompleted} / {$tasksNumb} ]", $prj_name); $tmpquery5 = "UPDATE " . $tableProject . " SET name='{$prj_name}' WHERE id = '{$prj_id}'"; $ad = connectSql($tmpquery5); } return $prj_name; }