Delete_EP($PId, $EId);
include 'view/project.php';
break;
case 'AddEmpPro':
$EId = $_POST['EId'];
$PId = $_POST['PId'];
$Position = $_POST['Position'];
$SpH = $_POST['SpH'];
AddEmpPro($EId, $PId, $Position, $SpH);
include 'view/project.php';
break;
case 'add_project':
$DId = $_POST['DId'];
$Name = $_POST['Name'];
$Info = $_POST['Info'];
add_project($DId, $Name, $Info);
include 'view/project.php';
break;
case 'delete_project':
$PId = $_POST['PId'];
delete_project($PId);
include 'view/project.php';
break;
case 'show_employee':
include 'view/list.php';
break;
case 'delete_employee':
$EId = $_POST['EId'];
delete_employee($EId);
include 'view/list.php';
break;
create_entry($person_id, $project_id, $startdate);
} elseif ($_POST['action'] == 'update') {
$entry_id = $_REQUEST['entry_id'];
$project_id = $_REQUEST['project_id'];
$startdate = $_REQUEST['startdate'];
update_entry($entry_id, $project_id, $startdate);
} elseif ($_POST['action'] == 'delete') {
$entry_id = $_REQUEST['entry_id'];
delete_entry($entry_id);
} elseif ($_POST['action'] == 'reorder') {
$new_order = $_REQUEST['new_order'];
reorder_entries($new_order);
} elseif ($_POST['action'] == 'add_project') {
$project_name = $_REQUEST['project_name'];
$project_url = $_REQUEST['project_url'];
add_project($project_name, $project_url);
} elseif ($_POST['action'] == 'park_project') {
$project_id = $_REQUEST['project_id'];
park_project($project_id);
} elseif ($_POST['action'] == 'unpark_project') {
$project_id = $_REQUEST['project_id'];
unpark_project($project_id);
} elseif ($_GET['project_id']) {
$project_id = $_REQUEST['project_id'];
require_once 'edit_project.php';
} elseif ($_POST['action'] == 'edit_project') {
$project_id = $_REQUEST['project_id'];
$new_name = $_POST['project_name'];
$new_url = $_POST['project_url'];
$new_parked = $_POST['parked'];
edit_project($project_id, $new_name, $new_url, $new_parked);
function Draw_Page($Page_Type)
{
// Read only pages - these pages don't strictly require user authentication.
// Therefore, to enable permit-all page viewing, comment out the call
// to rejectIfNotAuthenticated() in the relevant case block. Note, some of
// these pages will replace sensitive info such as telephone/email with
// the string 'PROTECTED'
// ************************************************************************
switch ($Page_Type) {
case "default":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/start_page.php';
startPage();
break;
case "View_Service_Endpoint":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/view_service_endpoint.php';
view_endpoint();
break;
case "Service_Groups":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/view_all.php';
showAllServiceGroups();
break;
case "Service_Group":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/view_sgroup.php';
showServiceGroup();
break;
case "Site":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/view_site.php';
view_site();
break;
case "NGI":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/ngi/view_ngi.php';
view_ngi();
break;
case "Service":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/view_service.php';
view_se();
break;
case "Services":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/view_all.php';
drawSEs();
break;
case "NGIs":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/ngi/view_ngis.php';
view_ngis();
break;
case "Sites":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/view_all.php';
showAllSites();
break;
case "Projects":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/view_all.php';
show_all_projects();
break;
case "Project":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/view_project.php';
show_project();
break;
case "Scope_Help":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/scope_help.php';
show_help();
break;
case "Site_Geo_xml":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/sitesForGoogleMapXML.php';
show_xml();
break;
case "Error_Redirect":
//rejectIfNotAuthenticated();
show_view('error.php', $_REQUEST['error']);
break;
case "Static_HTML":
//rejectIfNotAuthenticated();
Draw_Static_HTML();
break;
case "Search":
//rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/search.php';
search();
break;
// CrUD Pages - These pages MUST have authentication enabled so
// the calls to rejectIfNotAuthenticated() must be used.
// *********************************************************************
// CrUD Pages - These pages MUST have authentication enabled so
// the calls to rejectIfNotAuthenticated() must be used.
// *********************************************************************
case "Revoke_Role":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/political_role/revoke_request.php';
view_revoke_request();
break;
case "Accept_Role_Request":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/political_role/accept_request.php';
view_accept_request();
break;
case "Deny_Role_Request":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/political_role/deny_request.php';
view_deny_request();
break;
case "Role_Requests":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/political_role/view_requests.php';
view_requests();
break;
case "Request_Role":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/political_role/request_role.php';
request_role();
break;
case "Edit_Site":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/edit_site.php';
edit_site();
break;
case "Edit_Service":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/edit_service.php';
edit_service();
break;
case "SE_Downtimes":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/se_downtimes.php';
se_downtimes();
break;
case "Add_Service":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/add_service.php';
add_service();
break;
case "Add_Service_Endpoint":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/add_service_endpoint.php';
add_service_endpoint();
break;
case "Delete_Service":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/delete_service.php';
delete();
break;
case "Edit_User":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/user/edit_user.php';
edit_user();
break;
case "User":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/user/view_user.php';
view_user();
break;
case "Downtime":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/view_downtime.php';
view();
break;
case "My_Sites":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/my_sites.php';
my_sites();
break;
case "Edit_NGI":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/ngi/edit_ngi.php';
edit_ngi();
break;
case "Edit_Service_Group":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/edit_service_group.php';
edit_service_group();
break;
case "Add_Service_Group_SEs":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/add_ses.php';
add_ses();
break;
case "Search_SEs":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/search_ses.php';
search_ses();
break;
case "Remove_Service_Group_SEs":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/remove_ses.php';
remove_ses();
break;
case "Add_Site":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/add_site.php';
add_site();
break;
case "SGroup_Downtimes":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/view_sgroup_downtimes.php';
view_sgroup_downtimes();
break;
case "Add_Service_Group":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/add_service_group.php';
add_service_group();
break;
case "Site_Downtimes":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/site_downtimes.php';
site_downtimes();
break;
case "Register":
rejectIfNotAuthenticated('Access denied - ' . 'you need to be pre-authenticated before you can register a new account');
require_once __DIR__ . '/controllers/user/register.php';
register();
break;
case "Add_Downtime":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/add_downtime.php';
//require_once __DIR__.'/controllers/downtime/add_downtime_old.php';
add();
break;
case "Edit_Downtime":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/edit_downtime.php';
//require_once __DIR__.'/controllers/downtime/edit_downtime_old.php';
edit();
break;
case "End_Downtime":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/end_downtime.php';
endDt();
break;
case "Downtime_view_endpoint_tree":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/view_endpoint_tree.php';
getServiceandEndpointList();
break;
case "Edit_Downtime_view_endpoint_tree":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/view_endpoint_tree.php';
editDowntimePopulateEndpointTree();
break;
case "Downtime_View_Services":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/view_services.php';
getSitesServices();
break;
case "Delete_Site":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/delete_site.php';
delete();
break;
case "Delete_Downtime":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/delete_downtime.php';
delete();
break;
case "Downtimes_Overview":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/downtime/downtimes_overview.php';
view();
break;
case "Delete_Service_Group":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/delete_service_group.php';
delete();
break;
case "Delete_User":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/user/delete_user.php';
delete();
break;
case "Edit_Certification_Status":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/edit_cert_status.php';
edit();
break;
case "Retrieve_Account":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/user/retrieve_account.php';
retrieve();
break;
case "Remove_Project_NGIs":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/remove_ngis.php';
remove_ngis_project();
break;
case "Add_Project_NGIs":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/add_ngis.php';
add_ngis_to_project();
break;
case "Edit_Project":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/edit_project.php';
edit_project();
break;
case "Delete_Project":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/project/delete_project.php';
delete_project();
break;
case "Admin_Move_Site":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/move_site.php';
move_site();
break;
case "Admin_Move_SEP":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/move_service_end_point.php';
move_service_end_point();
break;
case "Admin_Service_Types":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/view_service_types.php';
show_all();
break;
case "Admin_Service_Type":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/view_service_type.php';
view_service_type();
break;
case "Admin_Edit_Service_Type":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/edit_service_type.php';
edit_type();
break;
case "Admin_Add_Service_Type":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/add_service_type.php';
add_type();
break;
case "Admin_Delete_Service_Type":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/delete_service_type.php';
delete_service_type();
break;
case "Admin_Delete_Service_Type_Denied":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/delete_service_type_denied.php';
deny_delete_type();
break;
case "Admin_Add_NGI":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/add_ngi.php';
add_ngi();
break;
case "Admin_Users":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/users.php';
show_users();
break;
case "Admin_Edit_User_DN":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/edit_user_dn.php';
edit_dn();
break;
// case "Admin_Change_User_Admin_Status":
// rejectIfNotAuthenticated();
// require_once __DIR__.'/controllers/admin/edit_user_isadmin.php';
// make_admin();
// break;
// case "Admin_Change_User_Admin_Status":
// rejectIfNotAuthenticated();
// require_once __DIR__.'/controllers/admin/edit_user_isadmin.php';
// make_admin();
// break;
case "Admin_Add_Project":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/add_project.php';
add_project();
break;
case "Admin_Scopes":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/scopes.php';
show_scopes();
break;
case "Admin_Remove_Scope":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/delete_scope.php';
remove_scope();
break;
case "Admin_Add_Scope":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/add_scope.php';
add_scope();
break;
case "Admin_Scope":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/scope.php';
view_scope();
break;
case "Admin_Edit_Scope":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/edit_scope.php';
edit_scope();
break;
case "Admin_Delete_NGI":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/admin/delete_ngi.php';
delete_ngi();
break;
case "User_Validate_DN_Change":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/user/retrieve_account_user_validate.php';
validate_dn_change();
break;
case "Add_Site_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/add_site_property.php';
add_site_property();
break;
case "Add_Service_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/add_service_property.php';
add_service_property();
break;
case "Add_Endpoint_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/add_endpoint_property.php';
add_endpoint_property();
break;
case "Delete_Site_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/delete_site_property.php';
delete();
break;
case "Delete_Service_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/delete_service_property.php';
delete();
break;
case "Delete_Endpoint_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/delete_endpoint_property.php';
delete();
break;
case "Edit_Site_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/site/edit_site_property.php';
edit_property();
break;
case "Edit_Service_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/edit_service_property.php';
edit_property();
break;
case "Edit_Endpoint_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/edit_endpoint_property.php';
edit_property();
break;
case "Add_Service_Group_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/add_service_group_property.php';
add_service_group_property();
break;
case "Edit_Service_Group_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/edit_service_group_property.php';
edit_property();
break;
case "Delete_Service_Group_Property":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service_group/delete_service_group_property.php';
delete();
break;
case "Delete_Service_Endpoint":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/delete_service_endpoint.php';
delete_endpoint();
break;
case "Edit_Service_Endpoint":
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/service/edit_service_endpoint.php';
edit_endpoint();
break;
default:
// require auth by default
rejectIfNotAuthenticated();
require_once __DIR__ . '/controllers/start_page.php';
startPage();
break;
}
}
<?php
require_once '../include.php';
$handler_type = $_GET['op'];
switch ($handler_type) {
case "add":
add_project();
break;
case "bounds":
get_bounds_projects();
break;
case "project":
get_one_project();
break;
}
exit;
//新增项目
function add_project()
{
$project = array();
$project['name'] = empty($_POST['name']) ? '' : $_POST['name'];
$project['type'] = empty($_POST['type']) ? '' : $_POST['type'];
$project['description'] = empty($_POST['description']) ? '' : $_POST['description'];
$project['lng'] = empty($_POST['lng']) ? '' : $_POST['lng'];
$project['lat'] = empty($_POST['lat']) ? '' : $_POST['lat'];
$project['zoom'] = empty($_POST['zoom']) ? '' : $_POST['zoom'];
$_project = new Project();
$ret = $_project->add($project);
if ($ret) {
$response = "success";
} else {
#
#
#
#
#
# get settings
require "settings.php";
require_lib("pgsql");
foreach ($_GET as $each => $own) {
$_POST[$each] = $own;
}
# decide what to do
if (isset($_POST["key"])) {
switch ($_POST["key"]) {
case "add":
$OUTPUT = add_project($_POST);
break;
default:
$OUTPUT = enter();
}
} else {
$OUTPUT = enter();
}
$OUTPUT .= "\n\t\t\t\t<p>\n\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='project-add.php'>Add Project</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='projects-edit.php'>View/Edit Project Information</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='costcenter-add.php'>Add Cost Center</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='costcenter-view.php'>View Cost Centers</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t";
# display output
require "template.php";
# enter new data
function enter($err = "")
{
db_connect();
if (!isset($project1)) {
if ($page == "account_registration_invite") {
if (logged_in()) {
//check if the user has submitted data in the form
if (isset($_POST['email'])) {
account_registration_invite($_POST['email']);
}
require "templates/admin/account_registration_invite.php";
} else {
header("location:index.php?page=login&redirect=account_registration_invite");
}
} else {
if ($page == "add_project") {
if (logged_in()) {
//check if the user has submitted data in the form
if (isset($_POST['title']) && isset($_POST['type']) && isset($_POST['text'])) {
add_project($_POST['title'], $_POST['type'], $_POST['text']);
}
require "templates/admin/add_project.php";
} else {
header("location:index.php?page=login&redirect=add_project");
}
} else {
if ($page == "edit") {
if (logged_in()) {
//check if the user has submitted data in the form
if (isset($_POST['content'])) {
edit_website_info($_GET['what_to_edit'], $_POST['content']);
}
require "templates/admin/edit.php";
} else {
header("location:index.php?page=login");
