$id = $meeting; } if ($removeToSiteFile == "true") { $id = str_replace("**", ",", $id); $tmpquery1 = "UPDATE " . $tableCollab["meetings_attachment"] . " SET published='1' WHERE id IN({$id}) OR vc_parent IN ({$id})"; connectSql("{$tmpquery1}"); $msg = "removeToSite"; $id = $meeting; } } if ($meeting != "" && $cheatCode == "true") { $id = $meeting; } $tmpquery = "WHERE mee.id = '{$id}'"; $meetingDetail = new request(); $meetingDetail->openMeetings($tmpquery); $tmpquery = "WHERE att.meeting = '{$id}'"; $attendantDetail = new request(); $attendantDetail->openAttendants($tmpquery); $comptAttendantDetail = count($attendantDetail->att_id); $tmpquery = "WHERE pro.id = '" . $meetingDetail->mee_project[0] . "'"; $projectDetail = new request(); $projectDetail->openProjects($tmpquery); $teamMember = "false"; $tmpquery = "WHERE tea.project = '" . $meetingDetail->mee_project[0] . "' AND tea.member = '" . $_SESSION['idSession'] . "'"; $memberTest = new request(); $memberTest->openTeams($tmpquery); $comptMemberTest = count($memberTest->tea_id); if ($comptMemberTest == "0") { $teamMember = "false"; } else {
for ($m = 0; $m < $comptListAttendants; $m++) { if ($meetingIdList != "") { $meetingIdList .= ", "; } $meetingIdList .= $listAttendants->att_meeting[$m]; } if ($meetingIdList == "") { $tmpquery = "WHERE mee.id = -1"; } else { $tmpquery = "WHERE mee.id IN (" . $meetingIdList . ") ORDER BY mee.name"; } } else { $tmpquery = "WHERE mee.project = '{$viewCalend}' ORDER BY mee.name"; } $listMeetings = new request(); $listMeetings->openMeetings($tmpquery); $comptListMeetings = count($listMeetings->mee_id); for ($g = 0; $g < $comptListTasks; $g++) { if (substr($listTasks->tas_start_date[$g], 0, 7) == substr($dateCalend, 0, 7)) { $gantt = "true"; } } for ($i = 1; $i < $daysmonth + $firstday; $i++) { $a = $i - $firstday + 1; $day = $i - $firstday + 1; if (strlen($a) == 1) { $a = "0{$a}"; } if (strlen($month) == 1) { $month = "0{$month}"; }
/** * $Id: noti_meetingassignment.php,v 1.2 2004/12/13 00:18:23 madbear Exp $ * * Copyright (c) 2004 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. */ if ($num == "") { $num = $id; } $tmpquery = "WHERE mee.id IN({$num})"; $meetingNoti = new request(); $meetingNoti->openMeetings($tmpquery); $tmpquery = "WHERE pro.id = '{$project}'"; $projectNoti = new request(); $projectNoti->openProjects($tmpquery); $tmpquery = "WHERE noti.member IN({$att_mem_id_list})"; $listNotifications = new request(); $listNotifications->openNotifications($tmpquery); $comptListNotifications = count($listNotifications->not_id); for ($i = 0; $i < $comptListNotifications; $i++) { if ($listNotifications->not_meetingassignment[$i] != "0") { continue; } $mail = new notification(); $mail->getUserinfo($_SESSION['idSession'], "from"); $mail->partSubject = $strings["noti_meetingassignment1"]; $mail->partMessage = $strings["noti_meetingassignment2"];
$block1->paletteIcon(5, "remove_projectsite", $strings["remove_project_site"]); } } $block1->paletteIcon(6, "info", $strings["view"]); if ($teamMember == "true") { $block1->paletteIcon(7, "edit", $strings["edit"]); $block1->paletteIcon(8, "timelog", $strings["loghours"]); } $block1->closePaletteIcon(); $block1->borne = $blockPage->returnBorne("1"); $block1->rowsLimit = "20"; $block1->sorting("meetings", $sortingUser->sor_meetings[0], 'mee.date DESC', $sortingFields = array(0 => 'mee.id', 1 => 'mee.name', 2 => 'mee.priority', 3 => 'mee.status', 4 => 'mee.date')); $tmpquery = "WHERE mee.project = '{$project}' ORDER BY {$block1->sortingValue}"; $block1->recordsTotal = compt($initrequest["meetings"] . " " . $tmpquery); $listMeetings = new request(); $listMeetings->openMeetings($tmpquery, $block1->borne, $block1->rowsLimit); $comptListMeetings = count($listMeetings->mee_id); if ($comptListMeetings != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings['id'], 1 => $strings['meeting'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['date']), 'true'); for ($i = 0; $i < $comptListMeetings; $i++) { $idStatus = $listMeetings->mee_status[$i]; $idPriority = $listMeetings->mee_priority[$i]; $idPublish = $listMeetings->mee_published[$i]; $block1->openRow($listMeetings->mee_id[$i]); $block1->checkboxRow($listMeetings->mee_id[$i]); $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_id[$i], LINK_INSIDE)); if ($idStatus == 1) { $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_STRIKE)); } else { $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_INSIDE));