$block1->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]); } if ($comptListHours == "1") { $block1->contentRow("", "1 " . $strings["match"]); } if ($comptListHours > "1") { $block1->contentRow("", $comptListHours . " " . $strings["matches"]); } $block0->closeContent(); $heading_text = $strings['reporthours']; if ($s_sdate2 != "") { $heading_text = "{$heading_text} {$strings['reports_from']} {$s_sdate2} {$strings['reports_to']} {$s_edate2}"; } $heading_text = $heading_text . ': ' . ($comptListHours == 1 ? "{$comptListHours} {$strings['match']}" : "{$comptListHours} {$strings['matches']}"); // set up the header string $block1->heading($heading_text); // initialize counters $totalMemHours = 0; $block1->openPaletteIcon(); $block1->paletteIcon(0, "export", $strings["export"]); $block1->closePaletteIcon(); if ($comptListHours != "0") { $block1->openResults($checkbox = "false"); $block1->labels($labels = array(0 => $strings["organization"], 1 => $strings["project"], 2 => $strings["name"], 3 => $strings["date"], 4 => $strings["type"], 5 => $strings["service"], 6 => $strings["hours"]), "true"); for ($i = 0; $i < $comptListHours; $i++) { $block1->openRow(); $block1->checkboxRow($listHours->tim_id[$i], $checkbox = "false"); $block1->cellRow($listHours->tim_org_name[$i]); $block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listHours->tim_project[$i], $listHours->tim_pro_name[$i], LINK_INSIDE)); $block1->cellRow($listHours->tim_mem_name[$i]); $block1->cellRow($listHours->tim_date[$i]);
} $bodyCommand = "onLoad=\"document.assignment_commentForm.acomm.focus();\""; include '../themes/' . THEME . '/header.php'; $tmpquery = "WHERE tas.id = '{$task}'"; $taskDetail = new request(); $taskDetail->openTasks($tmpquery); $tmpquery = "WHERE pro.id = '" . $taskDetail->tas_project[0] . "'"; $projectDetail = new request(); $projectDetail->openProjects($tmpquery); $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)); $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["assignment_comment"]); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->form = "assignment_comment"; $block1->openForm("../tasks/assignmentcomment.php?action=update&id={$id}&task={$task}&" . session_name() . "=" . session_id()); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } $block1->heading($strings["assignment_comment"]); $block1->openContent(); $block1->contentTitle($strings["assignment_comment_info"]); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["task"] . " :</td><td>" . $taskDetail->tas_name[0] . "</td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><input style=\"width: 400px;\" maxlength=\"128\" size=\"44\" name=\"acomm\"></input></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["save"] . "\"></td></tr>"; $block1->closeContent(); $block1->closeForm(); include '../themes/' . THEME . '/footer.php';
$comptProjectDetail = count($projectDetail->pro_id); if ($comptProjectDetail == "0") { headerFunction("../projects/listprojects.php?msg=blank&" . session_name() . "=" . session_id()); exit; } 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)); $blockPage->itemBreadcrumbs($strings["team_members"]); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->form = "saM"; $block1->openForm("../teams/listusers.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block1->form . "Anchor"); $block1->heading($strings["team_members"]); $block1->openPaletteIcon(); if ($idSession == $projectDetail->pro_owner[0] || $profilSession == "5") { $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); if ($sitePublish == "true") { $block1->paletteIcon(2, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]); } } $block1->paletteIcon(4, "info", $strings["view"]); $block1->paletteIcon(5, "email", $strings["email"]); $block1->closePaletteIcon(); $block1->sorting("team", $sortingUser->sor_team[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected", 5 => "tea.published")); $tmpquery = "WHERE tea.project = '{$id}' AND mem.profil != '3' ORDER BY {$block1->sortingValue}"; $listTeam = new request();
} echo ' </select></td> </tr>'; if ($ld == '') { $ld = $date; } $block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\" \r\nsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>"); echo "\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n</tr>\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n</tr>\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'> </td>\r\n <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n</tr>"; $block1->closeContent(); $block1->closeForm(); // This will display time log detail for the current meeting $block2 = new block(); $block2->form = "ahT"; $block2->openForm("../meetings/addmeetingtime.php?id={$id}#" . $block2->form . "Anchor"); $block2->heading($strings["meeting_time"] . ' : ' . $strings["details"]); $block2->openPaletteIcon(); $block2->paletteIcon(0, "remove", $strings["delete"]); $block2->paletteIcon(1, "edit", $strings["edit"]); $block2->closePaletteIcon(); $block2->borne = $blockPage->returnBorne("1"); $block2->rowsLimit = "20"; $block2->sorting('meetings_time', $sortingUser->sor_meetings_time[0], 'mti.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mti.date', 2 => 'mti.hours', 3 => 'mti.created', 4 => 'mti.modified', 5 => 'mti.comments')); $tmpquery = "WHERE mti.meeting = '{$id}' ORDER BY {$block2->sortingValue}"; $block2->recordsTotal = compt($initrequest["meetings_time"] . " " . $tmpquery); $listMeetingTimes = new request(); $listMeetingTimes->openMeetingTime($tmpquery, $block2->borne, $block2->rowsLimit); $comptListMeetingTimes = count($listMeetingTimes->mti_id); if ($comptListMeetingTimes != "0") { $block2->openResults(); $block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
} else { if ($supportType == "admin") { $blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/support.php?", $strings["support_management"], in)); $blockPage->itemBreadcrumbs($strings["support_requests"]); } } $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "srs"; $block1->openForm("../support/listrequests.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block1->form . "Anchor"); $block1->heading($strings["support_requests"]); if ($teamMember == "true" || $profilSession == "0") { $block1->openPaletteIcon(); //$block1->paletteIcon(0,"add",$strings["add"]); $block1->paletteIcon(1, "edit", $strings["edit_status"]); $block1->paletteIcon(2, "remove", $strings["delete"]); $block1->paletteIcon(3, "info", $strings["view"]); $block1->closePaletteIcon(); } $block1->sorting("support_requests", $sortingUser->sor_support_requests[0], "sr.id ASC", $sortingFields = array(0 => "sr.id", 1 => "sr.subject", 2 => "sr.priority", 3 => "sr.status", 4 => "sr.date_open", 5 => "sr.date_close")); /*$tmpquery = "WHERE mem.id = '$idSession'"; $userDetail = new request(); $userDetail->openMembers($tmpquery);*/ $tmpquery = "WHERE sr.project = '{$id}' ORDER BY {$block1->sortingValue}"; $listRequests = new request(); $listRequests->openSupportRequests($tmpquery);
exit; } if ($action == "create") { $tmpquery = "UPDATE " . $tableCollab["projects"] . " SET published='0' WHERE id = '{$id}'"; connectSql("{$tmpquery}"); headerFunction("../projects/viewprojectsite.php?id={$id}&msg=createProjectSite&" . session_name() . "=" . session_id()); exit; } 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={$id}", $projectDetail->pro_name[0], in)); $blockPage->itemBreadcrumbs($strings["create_projectsite"]); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->form = "csdD"; $block1->openForm("../projects/addprojectsite.php?action=create&id={$id}&" . session_name() . "=" . session_id()); $block1->heading($strings["create_projectsite"]); $block1->openContent(); $block1->contentTitle($strings["details"]); $block1->contentRow($strings["project"], $blockPage->buildLink("../projects/viewproject.php?id={$id}", $projectDetail->pro_name[0], in)); if ($projectDetail->pro_org_id[0] == "1") { $block1->contentRow($strings["organization"], $strings["none"]); } else { $block1->contentRow($strings["organization"], $blockPage->buildLink("../clients/viewclient.php?id=" . $projectDetail->pro_org_id[0], $projectDetail->pro_org_name[0], in)); } $block1->contentRow("", "<input type=\"SUBMIT\" value=\"" . $strings["create"] . "\">"); $block1->closeContent(); $block1->closeForm(); include '../themes/' . THEME . '/footer.php';
$checkSession = "true"; include_once '../includes/library.php'; include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["organizations"], in)); $blockPage->itemBreadcrumbs($strings["organizations"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "clientList"; $block1->openForm("../clients/listclients.php?" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor"); $block1->heading($strings["organizations"]); $block1->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.phone", 2 => "org.url")); $tmpquery = "WHERE org.id != '1' ORDER BY {$block1->sortingValue}"; $listOrganizations = new request(); $listOrganizations->openOrganizations($tmpquery); $comptListOrganizations = count($listOrganizations->org_id); if ($comptListOrganizations != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false"); for ($i = 0; $i < $comptListOrganizations; $i++) { $block1->openRow(); $block1->checkboxRow($listOrganizations->org_id[$i]); $block1->cellRow($blockPage->buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], in)); $block1->cellRow($listOrganizations->org_phone[$i]); $block1->cellRow($blockPage->buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], out)); $block1->closeRow();
** ** ----------------------------------------------------------------------------- ** Please refer to license, copyright, and credits in README.TXT ** ** ----------------------------------------------------------------------------- ** FILE: license.php ** ** DESC: Screen: print GNU/GPL license ** ** HISTORY: ** 2003-10-23 - added new document info ** ----------------------------------------------------------------------------- ** TO-DO: ** ** ============================================================================= */ $checkSession = "false"; include_once '../includes/library.php'; $notLogged = "true"; include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs(" "); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->heading($setTitle . " : License"); $block1->openContent(); $block1->contentTitle("License"); $block1->contentRow("", "<pre>" . recupFile("../docs/copying.txt") . "</pre>"); $block1->closeContent(); include '../themes/' . THEME . '/footer.php';
require_once "../_addon/addon_header_light.php"; } else { require_once "../themes/" . THEME . "/header.php"; } $blockPage = new block(); $blockPage->bornesNumber = "1"; $block1 = new block(); //Form $block1->form = "TaskTime_{$form_type}"; $popup_addon = ""; if ($window == "popup") { $popup_addon = "?window=popup"; } $block1->openForm("{$form_type}.php{$popup_addon}"); //--- title ------ $block1->heading($title_type); $block1->heading_close(); $block1->openContent(); $block1->contentTitle("Données"); //$block1->contentRow("Test", "tmp"); //*** Client *** //$tmpquery = "WHERE tea.project = '" . $projectDetail->pro_id[0] . "' ORDER BY org.name"; $tmpquery = " ORDER BY org.name"; $clients = new request(); $clients->openOrganizations($tmpquery); $comptClients = count($clients->org_id); echo "\n\t<tr class='odd'>\n\t <td valign='top' class='leftvalue'>" . $strings['clients'] . " :</td>\n\t <td><select name='client_id' onChange='this.form.submit()'>"; // get Clients listing for ($i = 0; $i < $comptClients; $i++) { $selected = ""; if ($client_id == $clients->org_id[$i]) {
if ($teamMember == "false" && $projectsFilter == "true") { header("Location:../general/permissiondenied.php"); 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[] = $strings["meetings"]; require_once "../themes/" . THEME . "/header.php"; // ----- content -------------------------------- $blockPage = new block(); $blockPage->bornesNumber = "1"; $block1 = new block(); $block1->form = "saM"; $block1->openForm("../meetings/listmeetings.php?project={$project}#" . $block1->form . "Anchor"); $block1->heading($strings["meetings"]); $block1->openPaletteIcon(); if ($teamMember == "true") { $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->paletteIcon(2, "copy", $strings["copy"]); // $block1->paletteIcon(3,"export",$strings["export"]); if ($sitePublish == "true") { $block1->paletteIcon(4, "add_projectsite", $strings["add_project_site"]); $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"]);
} else { if ($action == "open") { $breadcrumbs[] = $strings["open_requests"]; } else { if ($action == "complete") { $breadcrumbs[] = $strings["closed_requests"]; } } } require_once "../themes/" . THEME . "/header.php"; //--- content --- $block1 = new block(); $block1->form = "srs"; $block1->openForm("../support/support.php?action={$action}&project={$project}#" . $block1->form . "Anchor"); if ($action == "new") { $block1->heading($strings["new_requests"]); } elseif ($action == "open") { $block1->heading($strings["open_requests"]); } elseif ($action == "complete") { $block1->heading($strings["closed_requests"]); } if ($teamMember == "true" || $_SESSION['profilSession'] == "0") { $block1->openPaletteIcon(); // $block1->paletteIcon(0,"add",$strings["add"]); $block1->paletteIcon(1, "edit", $strings["edit_status"]); $block1->paletteIcon(2, "remove", $strings["delete"]); $block1->paletteIcon(3, "info", $strings["view"]); $block1->closePaletteIcon(); } else { $block1->heading_close(); }
headerFunction("../administration/admin.php?msg=update&" . session_name() . "=" . session_id()); } } } include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in)); $blockPage->itemBreadcrumbs($strings["edit_settings"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->heading($strings["edit_settings"]); $block1->openContent(); $block1->contentTitle("General"); $block1->form = "settings"; $block1->openForm("../administration/updatesettings.php?action=generate&" . session_name() . "=" . session_id()); if (substr($ftpRoot, -1) == "/") { $ftpRoot = substr($ftpRoot, 0, -1); } $tablePrefix = substr($tableCollab["projects"], 0, -8); echo "\t<input value='{$tablePrefix}' name='tablePrefixNew' type='hidden' />\n\t\t<input value='{$databaseType}' name='databaseTypeNew' type='hidden' />\n\t\t<input value='" . MYSERVER . "' name='myserverNew' type='hidden' />\n\t\t<input value='" . MYLOGIN . "' name='myloginNew' type='hidden' />\n\t\t<input value='" . MYPASSWORD . "' name='mypasswordNew' type='hidden' />\n\t\t<input value='" . MYDATABASE . "' name='mydatabaseNew' type='hidden' />\n\t\t<input value='" . $tablePrefix . "assignments' name='table_assignments' type='hidden' />\n\t\t<input value='" . $tablePrefix . "calendar' name='table_calendar' type='hidden' />\n\t\t<input value='" . $tablePrefix . "files' name='table_files' type='hidden' />\n\t\t<input value='" . $tablePrefix . "logs' name='table_logs' type='hidden' />\n\t\t<input value='" . $tablePrefix . "members' name='table_members' type='hidden' />\n\t\t<input value='" . $tablePrefix . "notes' name='table_notes' type='hidden' />\n\t\t<input value='" . $tablePrefix . "notifications' name='table_notifications' type='hidden' />\n\t\t<input value='" . $tablePrefix . "organizations' name='table_organizations' type='hidden' />\n\t\t<input value='" . $tablePrefix . "posts' name='table_posts' type='hidden' />\n\t\t<input value='" . $tablePrefix . "projects' name='table_projects' type='hidden' />\n\t\t<input value='" . $tablePrefix . "reports' name='table_reports' type='hidden' />\n\t\t<input value='" . $tablePrefix . "sorting' name='table_sorting' type='hidden' />\n\t\t<input value='" . $tablePrefix . "tasks' name='table_tasks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "teams' name='table_teams' type='hidden' />\n\t\t<input value='" . $tablePrefix . "topics' name='table_topics' type='hidden' />\n\t\t<input value='" . $tablePrefix . "phases' name='table_phases' type='hidden' />\n\t\t<input value='" . $tablePrefix . "support_requests' name='table_support_requests' type='hidden' />\n\t\t<input value='" . $tablePrefix . "support_posts' name='table_support_posts' type='hidden' />\n\t\t<input value='" . $tablePrefix . "subtasks' name='table_subtasks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "updates' name='table_updates' type='hidden' />\n\t\t<input value='" . $tablePrefix . "bookmarks' name='table_bookmarks' type='hidden' />\n\t\t<input value='" . $tablePrefix . "bookmarks_categories' name='table_bookmarks_categories' type='hidden' />\n\t\t<input value='" . $tablePrefix . "invoices' name='table_invoices' type='hidden' />\n\t\t<input value='" . $tablePrefix . "invoices_items' name='table_invoices_items' type='hidden' />\n\t\t<input value='" . $tablePrefix . "services' name='table_services' type='hidden' />\n\t\t<input value='" . $tablePrefix . "newsdeskcomments' name='table_newsdeskcomments' type='hidden' />\n\t\t<input value='" . $tablePrefix . "newsdeskposts' name='table_newsdeskposts' type='hidden' />\n\n<input value=\"{$loginMethod}\" name=\"loginMethodNew\" type=\"hidden\">"; if ($version == $versionNew) { if ($versionOld == "") { $versionOld = $version; } echo "<input value=\"{$versionOld}\" name=\"versionOldNew\" type=\"hidden\">"; } else {
** ** HISTORY: ** 2003-10-23 - added new document info ** ----------------------------------------------------------------------------- ** TO-DO: ** move to the render engine ** ** ============================================================================= */ $checkSession = "true"; include_once '../includes/library.php'; if ($profilSession != "0") { headerFunction('../general/permissiondenied.php?' . session_name() . '=' . session_id()); exit; } $setTitle .= " : DB Administraton"; include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in)); $blockPage->itemBreadcrumbs($strings["database"] . " " . MYDATABASE); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->heading($strings["database"] . " " . MYDATABASE); $block1->openContent(); $block1->contentTitle("Backup database"); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>\n<form method=\"post\" action=\"../includes/phppgadmin/db_dump.php\">View dump (schema) of database<br/>\n<table>\n <tr>\n <td>\n <input type=\"radio\" name=\"what\" value=\"structure\">Structure only </td>\n <td>\n <input type=\"checkbox\" name=\"drop\" value=\"1\">Add 'drop table' </td>\n <td colspan=\"2\">\n <input type=\"submit\" value=\"Go\">\n </td>\n </tr>\n <tr>\n <td>\n <input type=\"radio\" name=\"what\" value=\"data\" checked>Structure and data </td>\n <td>\n <input type=\"checkbox\" name=\"asfile\" value=\"sendit\">send </td>\n </tr>\n</table>\n<input type=\"hidden\" name=\"server\" value=\"1\">\n<input type=\"hidden\" name=\"db\" value=\"" . MYDATABASE . "\">\n<input type=\"hidden\" name=\"table\" value=\"y_updates\">\n</form>\n" . $blockPage->buildLink("http://phppgadmin.sourceforge.net", "phpPgAdmin", powered) . "</a></td></tr>"; $block1->contentTitle("Restore database from sql file"); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>\n <form method=\"post\" action=\"../includes/phpmyadmin/read_dump.php\" enctype=\"multipart/form-data\">\n <input type=\"hidden\" name=\"is_js_confirmed\" value=\"0\" />\n <input type=\"hidden\" name=\"lang\" value=\"en\" />\n <input type=\"hidden\" name=\"server\" value=\"1\" />\n <input type=\"hidden\" name=\"db\" value=\"" . MYDATABASE . "\" />\n <input type=\"hidden\" name=\"pos\" value=\"0\" />\n <input type=\"hidden\" name=\"goto\" value=\"db_details.php\" />\n <input type=\"hidden\" name=\"zero_rows\" value=\"Your SQL-query has been executed successfully\" />\n <input type=\"hidden\" name=\"prev_sql_query\" value=\"\" /><br />\n Location of sql file :<br />\n <div style=\"margin-bottom: 5px\">\n <input type=\"file\" name=\"sql_file\" /><br />\n </div>\n \n <input type=\"submit\" name=\"SQL\" value=\"Go\" />\n </form>\n" . $blockPage->buildLink("http://phpwizard.net/projects/phpMyAdmin", "phpMyAdmin", powered) . "</a>\n</td></tr>\n</table>\n</td></tr>"; $block1->closeContent(); include '../themes/' . THEME . '/footer.php';
$block1->closeContent(); $block1->block_close(); $block1->closeForm(); if ($_SESSION['idSession'] == $projectDetail->pro_owner[0] || $_SESSION['profilSession'] == '5') { $block1->openPaletteScript(); $block1->paletteScript(0, 'remove', '../projects/deleteprojectsite.php?project=' . $id, 'true,true,true', $strings['delete']); // $block1->paletteScript(1,'template','addtemplate.php','true,true,true',$strings['template']); // $block1->paletteScript(1,'template','editprojectsite.php','true,true,false',$strings['template']); $block1->closePaletteScript('', ''); } //--- client permitted users ----------------------- if ($projectDetail->pro_organization[0] != '' && $projectDetail->pro_organization[0] != '1') { $block2 = new block(); $block2->form = 'csU'; $block2->openForm('../projects/viewprojectsite.php?id=' . $projectDetail->pro_id[0] . '#' . $block2->form . 'Anchor'); $block2->heading($strings['permitted_client']); if ($_SESSION['idSession'] == $projectDetail->pro_owner[0] || $_SESSION['profilSession'] == '5') { $block2->openPaletteIcon(); $block2->paletteIcon(0, 'add', $strings['add']); $block2->paletteIcon(1, 'remove', $strings['delete']); if ($sitePublish == 'true') { $block2->paletteIcon(2, 'add_projectsite', $strings['add_project_site']); $block2->paletteIcon(3, 'remove_projectsite', $strings['remove_project_site']); } $block2->closePaletteIcon(); } else { $block2->headingToggle_close(); } $block2->openContent(); $block2->sorting('team', $sortingUser->sor_team[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.title', 2 => 'mem.login', 3 => 'mem.phone_work', 4 => 'log.connected', 5 => 'tea.published')); $tmpquery = "WHERE tea.project = '{$id}' AND mem.profil = '3' ORDER BY {$block2->sortingValue}";
} $breadcrumbs[] = buildLink('../administration/admin.php', $strings['administration'], LINK_INSIDE); $breadcrumbs[] = $strings['holidays']; $pageSection = 'admin'; require_once '../themes/' . THEME . '/header.php'; //--- content ----- $block1 = new block(); $block1->headingForm($strings['new_holiday']); $block1->openContent(); $block1->form = 'hoT'; $block1->openForm("../administration/listholidays.php?action=add&d=" . $d . "&c=" . $c . "#" . $block1->form . "Anchor"); $block1->contentRow($strings["date"], "<input type=\"text\" style=\"width: 150px;\" name=\"d\" id=\"sel1\" size=\"20\" value=\"{$sd}\"><button type=\"reset\" id=\"trigger_a\">...</button><script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>"); $block1->contentRow($strings["comments"], "<textarea rows=\"10\" style=\"width: 400px; height: 160px;\" name=\"c\" cols=\"47\">{$c}</textarea>"); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["save"] . "\"></td></tr>"; $block1->closeContent(); $block1->heading($strings["holidays"]); $block1->openPaletteIcon(); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $tmpquery = " ORDER BY hol.date DESC"; $holidayList = new request(); $holidayList->openHoliday($tmpquery); $comptHolidayList = count($holidayList->hol_id); $block1->recordsTotal = $comptHolidayList; if ($comptHolidayList > 0) { $block1->openResults(); $block1->labels($labels = array(0 => $strings['date'], 1 => $strings['comments']), 'true', $sorting = false, $sortingOff = array(0 => '0', 1 => 'DESC')); for ($i = 0; $i < $comptHolidayList; $i++) { $block1->openRow($holidayList->hol_id[$i]); $block1->checkboxRow($holidayList->hol_id[$i]); $block1->cellRow($holidayList->hol_date[$i]);
$blockPage->itemBreadcrumbs($strings["edit_newsdesk"]); } $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } if ($action != 'remove') { if ($id == "") { echo "\t<a name='" . $block1->form . "Anchor'></a>\n <form accept-charset='UNKNOWN' method='POST' action='../newsdesk/editnews.php?action=add&" . session_name() . "=" . session_id() . "' name='ecDForm'>\n"; $block1->heading($strings["add_newsdesk"]); } else { echo "\t<a name='" . $block1->form . "Anchor'></a>\n <form accept-charset='UNKNOWN' method='POST' action='../newsdesk/editnews.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "' name='ecDForm'>\n"; $block1->heading($strings["edit_newsdesk"] . " : " . $newsDetail->news_title[0]); } $block1->openContent(); $block1->contentTitle($strings["details"]); // add if ($id == "") { $block1->contentRow($strings["author"], "<input type='hidden' name='author' value='{$idSession}'><b>{$nameSession}</b>"); } else { $tmpquery_user = "******" . $newsDetail->news_author[0] . "' "; $newsAuthor = new request(); $newsAuthor->openMembers($tmpquery_user); $block1->contentRow($strings["author"], "<input type='hidden' name='author' value='" . $newsDetail->news_author[0] . "'><b>" . $newsAuthor->mem_name[0] . "</b>"); }
} include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["clients"], in)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/viewclient.php?id=" . $detailOrganization->org_id[0], $detailOrganization->org_name[0], in)); $blockPage->itemBreadcrumbs($strings["delete_users"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "client_user_delete"; $block1->openForm("../users/deleteclientusers.php?organization={$organization}&action=delete&" . session_name() . "=" . session_id()); $block1->heading($strings["delete_users"]); $block1->openContent(); $block1->contentTitle($strings["delete_following"]); $id = str_replace("**", ",", $id); $tmpquery = "WHERE mem.id IN({$id}) ORDER BY mem.name"; $listMembers = new request(); $listMembers->openMembers($tmpquery); $comptListMembers = count($listMembers->mem_id); for ($i = 0; $i < $comptListMembers; $i++) { echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>" . $listMembers->mem_login[$i] . " (" . $listMembers->mem_name[$i] . ")</td></tr>"; } $tmpquery = "SELECT tas.id FROM " . $tableCollab["tasks"] . " tas WHERE tas.assigned_to IN({$id})"; compt($tmpquery); $totalTasks = $countEnregTotal; $block1->contentTitle($strings["reassignment_clientuser"]); echo "<tr class='odd'><td valign='top' class='leftvalue'> </td><td>" . $strings["there"] . " {$totalTasks} " . $strings["tasks"] . " " . $strings["owned_by"] . "</td></tr>\n<tr class='odd'><td valign='top' class='leftvalue'> </td><td><b>" . $strings["reassign_to"] . " : </b> ";
$blockPage->itemBreadcrumbs($strings["updates_task"]); } $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "tdP"; $block1->openForm(""); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } if ($type == "1") { $block1->heading($strings["task"] . " : " . $taskDetail->tas_name[0]); } if ($type == "2") { $block1->heading($strings["subtask"] . " : " . $subtaskDetail->subtas_name[0]); } $block1->openContent(); $block1->contentTitle($strings["details"]); $tmpquery = "WHERE upd.type='{$type}' AND upd.item = '{$item}' ORDER BY upd.created DESC"; $listUpdates = new request(); $listUpdates->openUpdates($tmpquery); $comptListUpdates = count($listUpdates->upd_id); for ($i = 0; $i < $comptListUpdates; $i++) { if (preg_match('|\\[status:([0-9])\\]|', $listUpdates->upd_comments[$i])) { preg_match('|\\[status:([0-9])\\]|i', $listUpdates->upd_comments[$i], $matches); $listUpdates->upd_comments[$i] = preg_replace('|\\[status:([0-9])\\]|', '', $listUpdates->upd_comments[$i] . '<br/>'); $listUpdates->upd_comments[$i] .= $strings["status"] . ' ' . $status[$matches[1]];
} $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)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../notes/listnotes.php?project=" . $projectDetail->pro_id[0], $strings["notes"], in)); $blockPage->itemBreadcrumbs($noteDetail->note_subject[0]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "tdD"; $block1->openForm("../notes/viewnote.php?" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor"); $block1->heading($strings["note"] . " : " . $noteDetail->note_subject[0]); if ($teamMember == "true" && $idSession == $noteDetail->note_owner[0]) { $block1->openPaletteIcon(); $block1->paletteIcon(0, "remove", $strings["delete"]); //$block1->paletteIcon(1,"export",$strings["export"]); if ($sitePublish == "true") { $block1->paletteIcon(2, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]); } $block1->paletteIcon(4, "edit", $strings["edit"]); $block1->closePaletteIcon(); } if ($projectDetail->pro_org_id[0] == "1") { $projectDetail->pro_org_name[0] = $strings["none"]; } $block1->openContent();
$block1->contentRow("", $comptListProjects . " " . $strings["matches"]); } $block0->closeContent(); /* $block1->openPaletteIcon(); $block1->paletteIcon(0,"export",$strings["export"]); $block1->closePaletteIcon(); $block1->openPaletteScript(); $block1->paletteScript(0,"export","../reports/exportcompleted.php?s_date2=$s_date2&","true,false,false",$strings["export"]); $block1->closePaletteScript($comptListOrganizations,$listOrganizations->org_id); */ // set up the header string $headerString = $strings['project_breakdown']; $headerString .= ': ' . ($comptListProjects == 1 ? "{$comptListProjects} {$strings['match']}" : "{$comptListProjects} {$strings['matches']}"); $block1->heading($headerString); $block1->heading_close(); if ($comptListProjects != "0") { $block1->openResults($checkbox = "false"); $block1->labels($labels = array(0 => $strings["owner"], 1 => $strings["project"], 2 => $strings["organization"], 3 => $strings["status"]), "false"); for ($i = 0; $i < $comptListProjects; $i++) { $idStatus = $listProjects->pro_status[$i]; $block1->openRow(); $block1->checkboxRow($listProjects->pro_id[$i], $checkbox = "false"); if ($listProjects->pro_owner[$i] == "0") { $block1->cellRow($strings["unassigned"]); } else { $block1->cellRow(buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_name[$i], LINK_MAIL)); } $block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], LINK_INSIDE)); $block1->cellRow(buildLink("../clients/viewclient.php?id=" . $listProjects->pro_org_id[$i], $listProjects->pro_org_name[$i], LINK_INSIDE));
* 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. */ $checkSession = true; require_once "../includes/library.php"; $breadcrumbs[] = buildLink("../reports/createreport.php?", $strings["reports"], LINK_INSIDE); $breadcrumbs[] = $strings["my_reports"]; $pageSection = 'reports'; require_once "../themes/" . THEME . "/header.php"; //---- content ------ $block1 = new block(); $block1->form = "wbSe"; $block1->openForm("../reports/listreports.php#" . $block1->form . "Anchor"); $block1->heading($strings["my_reports"]); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $block1->sorting("reports", $sortingUser->sor_reports[0], "rep.name ASC", $sortingFields = array(0 => "rep.name", 1 => "rep.created")); $tmpquery = "WHERE rep.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}"; $listReports = new request(); $listReports->openReports($tmpquery); $comptListReports = count($listReports->rep_id); if ($comptListReports != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["created"]), "false"); for ($i = 0; $i < $comptListReports; $i++) { $block1->openRow($listReports->rep_id[$i]); $block1->checkboxRow($listReports->rep_id[$i]);
//--- header---- $breadcrumbs[] = buildLink("../calendar/viewcalendar.php?type=monthPreview", $strings["calendar"], LINK_INSIDE); $breadcrumbs[] = buildLink("../calendar/viewcalendar.php?viewCalend={$viewCalend}&type=monthPreview&dateCalend={$dateCalend}", "{$monthName} {$year}", LINK_INSIDE); $breadcrumbs[] = "{$dayName} {$day} {$monthName} {$year}"; $pageSection = 'calendar'; require_once "../themes/" . THEME . "/header.php"; //--- content-------- $block1 = new block(); $block1->form = "calendList"; $block1->openForm("../calendar/viewcalendar.php?viewCalend={$viewCalend}&type={$type}&dateCalend={$dateCalend}#" . $block1->form . "Anchor"); if ($viewCalend == 0) { $heading_posfix = "(" . $strings['cal_personal'] . $strings['calendar'] . ")"; } else { $heading_posfix = "(" . $strings['project'] . $strings['calendar'] . "-" . $listTeam->tea_pro_name[0] . ")"; } $block1->heading("{$dayName} {$day} {$monthName} {$year}" . $heading_posfix); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->paletteIcon(2, "info", $strings["view"]); $block1->paletteIcon(3, "edit", $strings["edit"]); $block1->closePaletteIcon(); $block1->sorting("calendar", $sortingUser->sor_calendar[0], "cal.date_end DESC", $sortingFields = array(0 => "cal.shortname", 1 => "cal.subject", 2 => "cal.date_start", 3 => "cal.date_end")); $dayRecurr = _dayOfWeek(mktime(12, 12, 12, $month, $day, $year)); if ($viewCalend == 0) { $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname"; } else { $tmpquery = "WHERE cal.project = '{$viewCalend}' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname"; } // $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' ORDER BY $block1->sortingValue"; $listCalendar = new request();
$block1->closeContent(); $block1->headingForm_close(); $block1->closeFormResults(); if ($fileDetail->mat_owner[0] == $_SESSION['idSession']) { $block1->openPaletteScript(); $block1->paletteScript(0, "remove", "../meetings/deletefiles.php?project=" . $fileDetail->mat_project[0] . "&meeting=" . $fileDetail->mat_meeting[0] . "&sendto=filedetails", "false,true,true", $strings["ifc_delete_version"]); $block1->paletteScript(1, "add_projectsite", "../meetings/viewfile.php?addToSiteFile=true&file=" . $fileDetail->mat_id[0] . "&action=publish", "true,true,true", $strings["add_project_site"]); $block1->paletteScript(2, "remove_projectsite", "../meetings/viewfile.php?removeToSiteFile=true&file=" . $fileDetail->mat_id[0] . "&action=publish", "true,true,true", $strings["remove_project_site"]); $block1->closePaletteScript($comptFileDetail, $fileDetail->mat_id); } if ($peerReview == "true") { // Revision list block $block2 = new block(); $block2->form = "tdC"; $block2->openForm("../meetings/viewfile.php?id={$id}#" . $block2->form . "Anchor"); $block2->heading($strings["ifc_revisions"]); if ($fileDetail->mat_owner[0] == $_SESSION['idSession']) { $block2->openPaletteIcon(); $block2->paletteIcon(0, "remove", $strings["ifc_delete_review"]); $block2->closePaletteIcon(); } if ($error2 != "") { $block2->headingError($strings["errors"]); $block2->contentError($error2); } $block2->openContent(); $block2->contentTitle($strings["details"]); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"></td><td><br>"; $tmpquery = "WHERE mat.vc_parent = '{$id}' AND mat.vc_status != '3' ORDER BY mat.date"; $listReviews = new request(); $listReviews->openMeetingsAttachment($tmpquery);
if ($comptTotal == "1") { echo "1 " . $strings["match"]; } if ($comptTotal > "1" || $comptTotal == "0") { echo "{$comptTotal} " . $strings["matches"]; } if ($comptTotal == "0") { echo "<br>" . $strings["no_results_search"]; } else { } echo "</td></tr>"; $block0->closeContent(); if ($comptListProjects != "0") { $block1->form = "ProjectForm"; $block1->openForm("../search/resultssearch.php?searchfor={$searchfor}&heading={$heading}#" . $block1->form . "Anchor"); $block1->heading($strings["search_results"] . " : " . $strings["projects"] . " ({$block1->recordsTotal})"); $block1->openPaletteIcon(); $block1->paletteIcon(0, "export", $strings["export"]); $block1->closePaletteIcon(); $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["published"]), "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($listProjects->pro_id[$i]); $block1->checkboxRow($listProjects->pro_id[$i]); $block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_id[$i], LINK_INSIDE)); $block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], LINK_INSIDE));
// Phrase Editing Form $translations = load_translations($sellang); $block1->form = "langedit"; $block1->openForm("../administration/edit_language.php?action=save&language=" . $sellang . "&count=" . count($translations) . "&offset=" . $offset); // build page links $numpages = count($translations) / $pagesize; $pagestr = ""; for ($i = 0; $i < $numpages; $i++) { $pagestr .= ' '; if ($offset / $pagesize != $i) { $pagestr .= buildLink('../administration/edit_language.php?offset=' . $i * $pagesize . '&language=' . $sellang, $i + 1); } else { $pagestr .= $i + 1; } } $block1->heading(text("Phrases") . " ( " . $pagestr . " )"); $block1->openPaletteIcon(); $block1->paletteIcon(1, "remove", text("delete")); $block1->closePaletteIcon(); // ok, now to list up all the phrases $block1->openResults(); $block1->labels($labels = array(0 => text('Label'), 1 => text('Translation')), $published = "true", "true", $sortingOff = array(0 => '0', 1 => 'DESC')); reset($translations); $id = 0; $checkboxes = array(); foreach ($translations as $key => $value) { if ($id >= $offset && $id < $offset + $pagesize) { $block1->openRow($id); $block1->checkboxRow($id); $block1->cellRow(htmlspecialchars($key, ENT_QUOTES)); $block1->cellRow("<input type='hidden' name='key" . $id . "' value=\"" . htmlspecialchars($key, ENT_QUOTES) . "\">" . "<input size='80' name='trans" . $id . "' value=\"" . htmlspecialchars($value, ENT_QUOTES) . "\">", 100);
$blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); if ($id != "") { $block1->form = "invoice"; $block1->openForm("../invoicing/editinvoice.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor"); } if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } if ($id != "") { $block1->heading($strings["edit_invoice"] . " : " . $detailInvoice->inv_id[0]); } $block1->openContent(); $block1->contentTitle($strings["details"]); $block1->contentRow($strings["header_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"header_note\" cols=\"47\">{$header_note}</textarea>"); $block1->contentRow($strings["footer_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"footer_note\" cols=\"47\">{$footer_note}</textarea>"); $tmpquery = "WHERE invitem.invoice = '{$id}' AND invitem.active = '1' ORDER BY invitem.position ASC"; $listInvoicesItems = new request(); $listInvoicesItems->openInvoicesItems($tmpquery); $comptListInvoicesItems = count($listInvoicesItems->invitem_id); $selectStatus = "<select name=\"st\">"; $comptSta = count($invoiceStatus); if ($detailInvoice->inv_status[0] == "0") { $begin = "0"; } else { $begin = "1";
} echo ' </select></td> </tr>'; if ($ld == '') { $ld = $date; } $block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\"\r\n\tsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n\t<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>"); echo "\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n\t <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n\t <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'> </td>\r\n\t <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n\t</tr>"; $block1->closeContent(); $block1->block_close(); $block1->closeForm(); $block2 = new block(); $block2->form = "ahT"; $block2->openForm("../tasks/addtasktime.php?id={$id}#" . $block2->form . "Anchor"); $block2->heading($strings["task_time"] . ' : ' . $strings["details"]); $block2->openPaletteIcon(); $block2->paletteIcon(0, "remove", $strings["delete"]); $block2->paletteIcon(1, "edit", $strings["edit"]); $block2->closePaletteIcon(); $block2->borne = $blockPage->returnBorne("1"); $block2->rowsLimit = "20"; $block2->sorting('tasks_time', $sortingUser->sor_tasks_time[0], 'tim.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'tim.date', 2 => 'tim.hours', 3 => 'tim.created', 4 => 'tim.modified', 5 => 'tim.comments')); $tmpquery = "WHERE tim.task = '{$id}' ORDER BY {$block2->sortingValue}"; $block2->recordsTotal = compt($initrequest["tasks_time"] . " " . $tmpquery); $listTaskTimes = new request(); $listTaskTimes->openTaskTime($tmpquery, $block2->borne, $block2->rowsLimit); $comptListTaskTimes = count($listTaskTimes->tim_id); if ($comptListTaskTimes != "0") { $block2->openResults(); $block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
function prj_displayAllProjects(&$blockPage) { global $_TABLES, $_CONF, $_USER, $subTaskImg, $progress, $priority, $strings, $labels, $_PRJCONF, $_COOKIE; $limitbase = $_COOKIE['allprjmin']; if ($limitbase == '') { $limitbase = 0; } if (isset($_USER['uid'])) { $userid = $_USER['uid']; } else { $userid = 1; } if ($blockPage == NULL or $blockPage == '') { $blockPage = new block(); } $filter = COM_applyFilter($_COOKIE['filter']); $category_string = substr("{$filter}", 0, 3); // Get a list of groups user is a member of and setup to be used in SQL to test user can view project $groups = SEC_getUserGroups($uid); foreach ($groups as $id) { $aGroups[] = $id; } $prjPermGroups = implode(',', $aGroups); if (SEC_inGroup('Root')) { $querycolumns = "SELECT DISTINCT a.pid, a.progress_id, a.status_id, a.priority_id, a.name, "; $querycolumns .= "a.last_updated_date, a.lhs, a.rhs, a.parent_id "; $queryfrom = "FROM {$_TABLES['prj_projects']} a"; $querywhere = " WHERE 1=1 "; } else { $querycolumns = "SELECT DISTINCT a.pid, a.progress_id, a.status_id, a.priority_id, a.name, "; $querycolumns .= "a.last_updated_date, a.lhs, a.rhs, a.parent_id "; $queryfrom = "FROM {$_TABLES['prj_projects']} a, {$_TABLES['prj_projPerms']} b "; $querywhere .= "WHERE b.pid =a.pid"; $querywhere .= " AND b.taskID=0 AND (b.uid={$userid} OR b.gid in ({$prjPermGroups})) "; } switch ($category_string) { case 'cat': $needle = substr("{$filter}", 3, 3); $queryfrom = $queryfrom . ", {$_TABLES['prj_category']} c "; $querywhere = $querywhere . "AND c.pid=a.pid AND c.category_id={$needle} "; $header = nexlistOptionList('view', '', $_PRJCONF['nexlist_category'], 0, $needle); break; case 'loc': $needle = substr("{$filter}", 3, 3); $queryfrom = $queryfrom . ", {$_TABLES['prj_location']} c "; $querywhere = $querywhere . "AND c.pid=a.pid AND c.location_id={$needle} "; $header = nexlistOptionList('view', '', $_PRJCONF['nexlist_locations'], 0, $needle); break; case 'dep': $needle = substr("{$filter}", 3, 3); $queryfrom = $queryfrom . ", {$_TABLES['prj_department']} c "; $querywhere = $querywhere . "AND c.pid=a.pid AND c.department_id={$needle} "; $header = nexlistOptionList('view', '', $_PRJCONF['nexlist_departments'], 0, $needle); break; case 'pri': $needle = substr("{$filter}", 3, 3); $querywhere = $querywhere . " AND a.priority_id={$needle} "; $header = $strings["filter_priority"] . $priority[$needle]; break; case 'pro': $needle = substr("{$filter}", 3, 3); $querywhere = $querywhere . " AND a.progress_id={$needle} "; $header = $strings["filter_progress"] . $progress[$needle]; break; case 'sta': $needle = substr("{$filter}", 3, 3); $querywhere = $querywhere . " AND a.status_id={$needle} "; $header = $strings["filter_status"] . $status[$needle]; break; case 'ctm': if (SEC_inGroup('Root')) { $querycolumns = "SELECT DISTINCT {$_TABLES['prj_projects']}.pid, {$_TABLES['prj_projects']}.progress_id, {$_TABLES['prj_projects']}.status_id, {$_TABLES['prj_projects']}.priority_id, {$_TABLES['prj_projects']}.name, "; $querycolumns .= "{$_TABLES['prj_projects']}.last_updated_date, {$_TABLES['prj_projects']}.lhs, {$_TABLES['prj_projects']}.rhs, {$_TABLES['prj_projects']}.parent_id "; $querywhere = ""; } else { $querycolumns = "SELECT DISTINCT {$_TABLES['prj_projects']}.pid, {$_TABLES['prj_projects']}.progress_id, {$_TABLES['prj_projects']}.status_id, {$_TABLES['prj_projects']}.priority_id, {$_TABLES['prj_projects']}.name, "; $querycolumns .= "{$_TABLES['prj_projects']}.last_updated_date, {$_TABLES['prj_projects']}.lhs, {$_TABLES['prj_projects']}.rhs, {$_TABLES['prj_projects']}.parent_id, {$_TABLES['prj_projPerms']}.viewRead "; $querywhere = "WHERE b.pid =a.pid"; $querywhere .= " AND b.taskID=0 AND (b.uid={$userid} OR b.gid in ({$prjPermGroups})) "; } $needle = substr("{$filter}", 3, 3); $customFilter = prj_constructFilter($needle); $queryfrom = $customFilter['clause']; $header = $strings["filter_custom"] . $customFilter['name']; break; default: $needle = ''; $customFilter = ''; $header = ''; } $block1 = new block(); $block1->form = "allP"; $block1->openForm($_CONF['site_url'] . "/nexproject/projects.php?" . "#" . $block1->form . "Anchor"); if ($header != '') { $headingTitle = $strings["projects"] . " - {$header}"; } else { $headingTitle = "{$strings['projects']} - {$strings['allprojects']} "; $headingTitle .= "(<a href=\"{$_CONF['site_url']}/nexproject/index.php?mode=add\">{$strings['add']}</a>)"; } $headingStatusArea = '<span id="ajaxstatus_myprojects" class="pluginInfo" style="display:none"> </span>'; $block1->heading($headingTitle, $headingStatusArea); $block1->borne = $blockPage->returnBorne("1"); $block1->rowsLimit = $_PRJCONF['project_block_rows']; if ($category_string == 'ctm') { $queryend = " ORDER BY {$_TABLES['prj_projects']}.lhs"; } else { $queryend = " ORDER BY a.lhs"; } $lim = $limitbase * $block1->rowsLimit; $query = $querycolumns . $queryfrom . $querywhere . $queryend; $countRes = DB_query($query); $block1->recordsTotal = DB_numrows($countRes); $query .= " LIMIT {$lim}, {$block1->rowsLimit} "; $result = DB_query($query); echo '<!--startMyProjects-->'; echo '<div id="divMyProjects" style="padding-bottom:0px;">'; $comptListProjects = DB_numrows($result); if ($comptListProjects != "0") { $block1->openResults('false'); $block1->labels($labels = array(0 => $strings["project"], 1 => $strings["priority"], 2 => $strings["lastupdated"], 3 => $strings["owner"]), false, "false"); for ($i = 0; $i < DB_numrows($result); $i++) { list($id, $idProgress, $idStatus, $idPriority, $projectName, $lastupdated, $lhs, $rhs, $parent_id) = DB_fetchArray($result); $pArray = prj_getProjectPermissions($id, $userid); //based on the projectID, fetch the permissions for this user... if ($pArray['monitor'] == '1' || $pArray['teammember'] == '1' || $pArray['full'] == '1') { $fullname = $projectName; $owner_uid = DB_getItem($_TABLES['prj_users'], 'uid', "pid={$id} AND role='o'"); if ($owner_uid >= 2) { $projectOwner = DB_getItem($_TABLES['users'], 'fullname', "uid={$owner_uid}"); if (strlen($projectOwner) > 15) { $projectOwner = substr($projectOwner, 0, 12) . ".."; } } $block1->openRow(); // $block1->checkboxRow($id); $block1->cellProgress($progress[$idProgress]); $indent = ''; //we need to determine if the user has access to the parent that this item is related to. //we do this by determining which project is on its left hand side. $testparent = DB_getItem($_TABLES['prj_projects'], "parent_id", "pid={$id}"); $aGroups = array(); $groups = SEC_getUserGroups($uid); foreach ($groups as $gid) { $aGroups[] = $gid; } $prjPermGroups = implode(',', $aGroups); $testsql = "SELECT a.* "; $testsql .= "FROM {$_TABLES['prj_projPerms']} a "; $testsql .= "WHERE a.pid={$testparent} "; $testsql .= " AND a.taskID=0 AND (a.uid={$_USER['uid']} OR a.gid in ({$prjPermGroups})) "; $testres = DB_query($testsql); $testrows = DB_numRows($testres); if ($testrows > 0 && $testparent > 0) { if ($parent_id != 0) { $level = prj_getProjectLevel($id); for ($z = 1; $z < $level; $z++) { $indent .= ' '; } $indent .= $subTaskImg; } } if (strlen($projectName) > $_PRJCONF['project_name_length']) { $span = "<span title=\"{$projectName}\">"; $projectName = substr($projectName, 0, $_PRJCONF['project_name_length']) . "...."; $projectName = $span . $projectName . "</span>"; } $block1->cellRow($indent . $blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?pid={$id}", $projectName, "context", $fullname, $id)); $block1->cellRow($priority[$idPriority]); //$block1->cellProgress($status[$idStatus]); $block1->cellRow(strftime("%Y/%m/%d %H:%M", $lastupdated)); $block1->cellRow($projectOwner); $block1->closeRow(); } } //end for $block1->closeResults(); //$block1->bornesFooter("1", $blockPage->bornesNumber, "", "typeProjects=$typeProjects"); $pages = intval($block1->recordsTotal / $block1->rowsLimit); if (fmod($block1->recordsTotal, $block1->rowsLimit) > 0) { $pages += 1; } if ($pages > 1) { for ($pagecntr = 0; $pagecntr < $pages; $pagecntr++) { echo '<span style="text-decoration:underline;cursor: hand" onclick=\'setCookie("allprjmin","'; echo $pagecntr; echo '","","");prj_getMyProjects("", "", "allprojects")\'>'; if ($limitbase == $pagecntr) { echo '<span style="color:red">'; echo $pagecntr + 1; echo '</span>'; } else { echo $pagecntr + 1; } echo '</span> '; } } } else { $block1->noresults(); } echo '</div>'; echo '<!--endMyProjects-->'; //$block1->closeToggle(); $block1->closeFormResults(); }
$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); } $block1 = new block(); $block1->form = "saC"; $block1->openForm("../linkedcontent/deletefiles.php?project={$project}&task={$task}&action=delete&id={$id}&sendto={$sendto}&" . session_name() . "=" . session_id()); $block1->heading($strings["unlink_files"]); $block1->openContent(); $block1->contentTitle($strings["delete_following"]); $id = str_replace("**", ",", $id); $tmpquery = "WHERE fil.id IN({$id}) ORDER BY fil.name"; $listFiles = new request(); $listFiles->openFiles($tmpquery); $comptListFiles = count($listFiles->fil_id); for ($i = 0; $i < $comptListFiles; $i++) { echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>" . $listFiles->fil_name[$i] . "</td></tr>"; } echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\"> <input type=\"BUTTON\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\"></td></tr>"; $block1->closeContent(); $block1->closeForm(); include '../themes/' . THEME . '/footer.php';
//--- header ------------ $breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["clients"], LINK_INSIDE); $breadcrumbs[] = buildLink("../clients/viewclient.php?id={$organization}", $detailClient->org_name[0], LINK_INSIDE); $breadcrumbs[] = $userDetail->mem_login[0]; $pageSection = 'clients'; $pageTitle = '<span class="type">' . $strings["client_user"] . '</span><br><span class="name">' . $userDetail->mem_name[0] . '</span>'; require_once "../themes/" . THEME . "/header.php"; //--- content ------------ $block1 = new block(); $block1->form = "cuserD"; $block1->openForm("../users/viewclientuser.php#" . $block1->form . "Anchor"); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } $block1->heading($strings["client_user"]); $block1->openPaletteIcon(); if ($_SESSION['profilSession'] == "0" || $_SESSION['profilSession'] == "1") { $block1->paletteIcon(0, "remove", $strings["delete"]); $block1->paletteIcon(1, "edit", $strings["edit"]); } $block1->paletteIcon(2, "export", $strings["export"]); $block1->closePaletteIcon(); $block1->openContent(); $block1->contentTitle($strings["user_details"]); $block1->contentRow($strings["user_name"], $userDetail->mem_login[0]); $block1->contentRow($strings["full_name"], $userDetail->mem_name[0]); $block1->contentRow($strings["organization"], $userDetail->mem_org_name[0]); $block1->contentRow($strings["email"], $userDetail->mem_email_work[0]); $block1->contentRow($strings["work_phone"], $userDetail->mem_phone_work[0]); $block1->contentRow($strings["home_phone"], $userDetail->mem_phone_home[0]);