<?php
require_once 'include/functions.php';
function increment_field($project_index, $field)
{
$projects = load_projects();
$projects[$project_index][$field] = isset($projects[$project_index][$field]) ? $projects[$project_index][$field] + 1 : 1;
file_put_contents('json/projects.json', json_encode($projects));
}
if (isset($_POST['stat'])) {
if (!(isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest')) {
die('What are you doing bro ? Only AJAX is allowed to do that !');
}
if (!isset($_POST['category']) || !isset($_POST['project'])) {
die('Missing parameter(s) : category or project.');
}
$project = get_project($_POST['category'], $_POST['project']);
if ($project == null) {
die('Project not valid.');
}
$project_index = get_project_index($project);
if ($_POST['stat'] == 0) {
increment_field($project_index, 'linkClicks');
die(true);
}
if ($_POST['stat'] == 1) {
increment_field($project_index, 'projectClicks');
die(true);
}
die('Invalid parameter : stat.');
}
continue;
}
$projects = remove($projects, null, $i, null, false);
$projects_changed = true;
}
if ($projects_changed) {
finish($projects, 'projects', null);
}
}
} else {
if ($_POST['method'] == 5) {
$categories[$_POST['category']] = $_POST['newname'];
finish($categories, 'categories', PP_MESSAGE_CATEGORYRENAMED);
} else {
if ($_POST['method'] == 6) {
if (get_project($_POST['category'], $_POST['name']) != null) {
echo message(PP_MESSAGE_SAMENAMEEXISTS, 'alert-danger');
} else {
$_POST['link'] = correct_link($_POST['link']);
$projects = merge($projects, 'projects', array(array('name' => htmlspecialchars($_POST['name']), 'description' => htmlspecialchars($_POST['description']), 'link' => htmlspecialchars($_POST['link']), 'category' => htmlspecialchars($_POST['category']))), PP_MESSAGE_PROJECTADDED, true, true);
}
} else {
if ($_POST['method'] == 7) {
$projects = remove($projects, 'projects', $_POST['project'], PP_MESSAGE_PROJECTREMOVED);
} else {
if ($_POST['method'] == 8) {
if ($_POST['old-category'] != $_POST['category']) {
foreach ($projects as $project) {
if ($project['name'] != $_POST['name']) {
continue;
}
<?php
include_once "_common.php";
//echo $wr_id;
$str_wr_id = $_GET['wr_id'];
if (substr($str_wr_id, 0, 2) == "01") {
$temp_domains = explode(".", $_SERVER[HTTP_HOST]);
$project_code = "mcard";
if (count($temp_domains) == 3) {
$project_code = $temp_domains[0];
}
$project = get_project($project_code);
//echo "[[".$project_code."]]".PHP_EOL;
//$proejct['code'] = $proejct['wr_1'];
//var_dump($project);
//echo $project['wr_1'];
//echo $_GET['wr_id'];
//var_dump($project);
//exit;
//첫페이지일 경우
//if($project) {
if ($project['wr_1']) {
//echo "Location:"."/bbs/board.m.php?bo_table=i01_menu_".$project['code']."&wr_id=1&is_intro=true&mb_id={$wr_id}";
//echo "프로젝트 존재";
//exit;
header("Location:" . "/bbs/board.m.php?bo_table=i01_menu_" . $project['wr_1'] . "&wr_id=1&is_intro=true&mb_id={$str_wr_id}");
return;
} else {
//echo "프로젝트 미존재";
//exit;
alert("존재하지 않는 프로젝트 입니다", "http://" . $_SERVER[HTTP_HOST] . "/bbs/board.php?bo_table=i01_project");
while($row=mysqli_fetch_array($admin_searchmin_date)){
$admin_searchmin_date_value=$row["UARD_DATE"];
$admin_min_date = date('d-m-Y',strtotime($admin_searchmin_date_value));
}
$admin_searchmax_date=mysqli_query($con,"SELECT MAX(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS where ULD_ID='$ADM_uld_id' ");
while($row=mysqli_fetch_array($admin_searchmax_date)){
$admin_searchmax_date_value=$row["UARD_DATE"];
$admin_max_date= date('d-m-Y',strtotime($admin_searchmax_date_value));
}
$min_date=mysqli_query($con,"SELECT UA_JOIN_DATE FROM USER_ACCESS where ULD_ID='$ADM_uld_id' ");
while($row=mysqli_fetch_array($min_date)){
$mindate_array=$row["UA_JOIN_DATE"];
$min_date = date('d-m-Y',strtotime($mindate_array));
}
$get_project_array=get_project($ADM_uld_id);
$finalvalue=array($admin_min_date,$admin_max_date,$min_date,$get_project_array);
echo JSON_ENCODE($finalvalue);
}
$ure_values=array();
if($_REQUEST['option']=='DATERANGE')
{
$sdate = $_REQUEST['start_date'];
$edate = $_REQUEST['end_date'];
$ure_uld_id=$_REQUEST['actionloginid'];
$startdate = date('Y-m-d',strtotime($sdate));
$enddate = date('Y-m-d',strtotime($edate));
$date= mysqli_query($con,"SELECT UARD_ID,UARD_REPORT,UARD_REASON,UARD_DATE,b.AC_DATA as UARD_PERMISSION, c.AC_DATA as UARD_ATTENDANCE,UARD.UARD_PSID,G.AC_DATA AS UARD_AM_SESSION,H.AC_DATA AS UARD_PM_SESSION,I.ULD_LOGINID AS ULD_ID,DATE_FORMAT(CONVERT_TZ(UARD.UARD_TIMESTAMP,'+00:00','+08:00'), '%d-%m-%Y %T') AS UARD_TIMESTAMP, UARD.UARD_FILE_ID ,ULD.ULD_LOGINID as UARD_USERSTAMP_ID,ABSENT_FLAG FROM USER_ADMIN_REPORT_DETAILS UARD
LEFT JOIN ATTENDANCE_CONFIGURATION b ON b.AC_ID=UARD.UARD_PERMISSION
left JOIN ATTENDANCE_CONFIGURATION c on c.AC_ID=UARD.UARD_ATTENDANCE
@copyright: 2013 by Alessandro Pasotti <*****@*****.**>
@license: GNU AGPL, see COPYING for details.
*/
require_once dirname(__FILE__) . '/config.php';
require_once dirname(__FILE__) . '/helpers.php';
// Params
$map = get_map_path(@$_REQUEST['map']);
// Name of the layer to query
$layername = @$_REQUEST['layer'];
// Field name from where unique values are read
$field = @$_REQUEST['field'];
if (!$field) {
err500('field parameter missing');
}
// Get project
$project = get_project($map);
// Get layer
$layer = get_layer($layername, $project);
try {
$dbh = get_connection($layer, $project, $map);
$ds_parms = get_layer_info($layer, $project);
$_field = preg_replace('/[^A-z0-9_-]]/', '', $field);
$stmt = $dbh->prepare("SELECT DISTINCT {$_field} FROM {$ds_parms['table']} ORDER BY {$_field}");
$stmt->execute();
while ($row = $stmt->fetchColumn()) {
$result[] = $row;
}
$json_result = json_encode($result);
header('Content-type: application/json');
header('Content-length: ' . strlen($json_result));
echo $json_result;
<div id="page-content">
<!-- Breadcrumb -->
<!-- You can have the breadcrumb stick on scrolling just by adding the following attributes with their values (data-spy="affix" data-offset-top="250") -->
<!-- You can try it on other elements too :-), the sticky position and style can be adjusted in the css/main.css with .affix class -->
<ul class="breadcrumb" data-spy="affix" data-offset-top="250">
<li>
<a href="index.php"><i class="glyphicon-display"></i></a> <span class="divider"><i class="icon-angle-right"></i></span>
</li>
<li class="active"><a href="">Dự án</a></li>
</ul>
<!-- END Breadcrumb -->
<!-- Default Tabs Block -->
<?php
$name = get_project();
$get_nv = get_em();
$dep_auth = get_dep_auth($_SESSION['is_valid']);
foreach ($name as $i) {
echo '<div class="block block-themed">';
echo '<div class="block-title">';
echo '<h4>' . $i['Name'] . '</h4>';
echo '</div>';
echo '<div class="label label-inverse">Thông tin dự án</div>';
echo '<p>' . $i['Info'] . '</p>';
echo '<div class="label label-inverse">Phòng quản lý</div>';
$x = dep_name($i['PId']);
echo '<p>' . $x . '</p>';
if (checkEP($_SESSION['is_valid'], $i['PId']) != 0) {
echo '<div class="label label-inverse">Mức lương của bạn</div>';
echo '<p>' . checkEPMoney($_SESSION['is_valid'], $i['PId'])['SpH'] . '</p>';
function create_rand_data($project_id)
{
$project = get_project($project_id);
$name_limit = $project['faction_qty'] * CHARACTER_LIMIT;
$rand_names = get_random_names($name_limit);
$character_num = 1;
$faction_num = 1;
foreach ($rand_names as $name) {
if ($character_num > CHARACTER_LIMIT) {
$character_num = 1;
$faction_num++;
}
mysql_query("INSERT INTO `characters` (`character_name`,`faction`,`character_number`,`project_id`) VALUES ('{$name}', '{$faction_num}', '{$character_num}', '{$project_id}')");
$character_num++;
}
}
function rest_get()
{
$response = array();
$Project = get_project($response);
if (!$Project) {
echo json_encode($response);
return;
}
$response['project'] = $Project->ConvertToJSON();
echo json_encode($response);
http_response_code(200);
}
session_start();
//error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
require 'database.php';
require 'site_config.php';
require 'functions/password.php';
// BCRYPT hashing library
require 'functions/general.php';
require 'functions/users.php';
require 'functions/project.php';
$current_file = explode('/', $_SERVER['SCRIPT_NAME']);
$current_file = end($current_file);
if (is_logged_in() === true) {
$session_user_id = $_SESSION['user_id'];
$user_data = get_user_data($session_user_id, 'user_id', 'username', 'password', 'first_name', 'last_name', 'email', 'password_recover', 'type', 'allow_email', 'profile', 'beta', 'active_project', 'viewed_tutorial');
//lets me use the user data in other functions
if (is_user_active($user_data['username']) === false) {
//logs a user out if their account is disabled, even if they are browsing at the time
session_destroy();
echo '<meta HTTP-EQUIV="REFRESH" content="0; url=index.php">';
exit;
} else {
if ($current_file !== 'change_password.php' && $current_file !== 'logout.php' && $user_data['password_recover'] == 1) {
echo '<meta HTTP-EQUIV="REFRESH" content="0; url=change_password.php?force">';
}
}
}
if (!empty($user_data['active_project'])) {
$activeProject = get_project($user_data['active_project']);
}
$errors = array();
function get_changes($num_changes = 20)
{
$query = "SELECT * FROM changes ORDER BY change_id DESC LIMIT {$num_changes}";
$results = array();
if ($result = mysql_query($query)) {
while ($row = mysql_fetch_array($result)) {
array_push($results, $row);
}
} else {
die("<p>could not get changes because:<br>" . mysql_error() . "<br>the query was {$query}.</p>");
}
$changes = array();
foreach ($results as $key => $record) {
$change = array();
$change['timestamp'] = date('n/j/Y', strtotime($record['timestamp']));
$change['instigator'] = $record['instigator'];
$change['verb'] = $record['verb'];
$person = get_person($record['person_id']);
$change['person'] = $person['person_name'];
$change['preposition'] = $record['preposition'];
$project = get_project($record['project_id']);
$change['project'] = $project['project_name'];
$change['week'] = $record['week'];
array_push($changes, $change);
}
return $changes;
}
<body>
<?php
create_nav_bar();
?>
<div class="container" style="max-width: 750px;">
<h1>Project Summary</h1>
<?php
$project = get_project($_GET['projId']);
echo '<div class="panel panel-default">';
echo '<div class="panel-heading">';
echo '<h3>' . $project->name . ' <a href="edit_project.php?projId=' . $project->projectID . '" title="Edit"><span class="glyphicon glyphicon-pencil"></span></a></h3>';
echo "<p>{$project->description}</p>";
echo '</div>';
$experiments = get_experiments_in_project($project->projectID);
echo '<div class="table-responsive">';
echo '<table class="table">';
echo '<tr>';
echo '<th>Name</th>';
echo '<th>Application</th>';
echo '<th>Time</th>';
echo '<th>Status</th>';
echo '</tr>';
foreach ($experiments as $experiment) {
<?php
require_once 'header.php';
$project = get_project($project_id);
?>
<p><a href="<?php
echo HOME;
?>
"> < back to The Board</a></p>
<?php
if ($_REQUEST['updated'] == 'true') {
?>
<p class="flash-message">Project updated</p>
<?php
}
?>
<form action="<?php
echo HOME;
?>
" method="post">
<input type="hidden" name="action" value="edit_project" />
<input type="hidden" name="project_id" value="<?php
echo $project_id;
?>
" />
<p>Project #<?php
echo $project_id;
if (!empty($_GET['tag'])) {
$items = get_items_tagged($_GET['tag']);
print "<h1>" . $_GET['tag'] . "</h1>\n";
foreach ($items as $item) {
print get_marked_up_todo($item);
}
} else {
if (!empty($_GET['days'])) {
$items = get_items_due($_GET['days'], $_GET['inclusive']);
print "<h1>" . $_GET['title'] . "</h1>\n";
foreach ($items as $item) {
print get_marked_up_todo($item);
}
} else {
if (!empty($_GET['title'])) {
$project = get_project($_GET['title']);
print get_marked_up_todo($project);
} else {
if (!empty($_GET['toggle'])) {
$with_done = toggle_done($_GET['todo']);
$current = explode(":", $_GET['current']);
if ($current[0] == "tag") {
header("Location: " . $self . "?tag=" . $current[1]);
}
if ($current[0] == "title") {
header("Location: " . $self . "?title=" . $current[1] . ":");
}
echo get_marked_up_todo($with_done);
} else {
if (!empty($_GET['ajax'])) {
echo get_marked_up_todo(file_get_contents($file));
//echo "[[[".$bo_table."]]]";
//echo "[[[".$wr_id."]]]";
//echo "[[[".$project_code."]]]";
//echo "[[[".$project_id."]]]";
if ($_SESSION['location_home'] && $project_code == "") {
$project_code = $_SESSION['location_home'];
}
/*if($project_code) $project_write = sql_fetch(" select * from {$g4['write_prefix']}{$grid}_project where wr_1 = '{$project_code}' ");
if($project_id) $project_write = sql_fetch(" select * from {$g4['write_prefix']}{$grid}_project where wr_id = '{$project_id}' ");
$project_board = array();
$project_board = sql_fetch(" select * from {$g4['board_table']} where bo_table = '{$grid}_project' ");
$project_board_skin_path = '';
if (isset($project_board['bo_skin'])) $project_board_skin_path = "{$g4['path']}/skin/board/{$store_board['bo_skin']}"; // 게시판 스킨 경로
$project_view = get_view($project_write, $project_board, $project_board_skin_path, 255);*/
$project_view = get_project($project_code);
if ($project_code) {
set_session("ss_project_code", $project_code);
set_session("ss_project_name", $project_view['wr_subject']);
if ($project_view['wr_6'] && $project_view['wr_7'] && $project_view['wr_8']) {
$payapp_userid = $project_view['wr_6'];
$payapp_linkkey = $project_view['wr_7'];
$payapp_linkval = $project_view['wr_8'];
}
}
$project_modules = array();
//기본 모듈
$project_modules[] = array('menu', '메뉴');
$project_modules[] = array('page', '페이지');
$project_modules[] = array('list', '리스트');
$project_modules[] = array('banner', '배너');
error_reporting(0);
include 'core/init.php';
if (!empty($_REQUEST['project_id'])) {
if (set_active_project($_REQUEST['project_id'])) {
header("Location: load.php");
}
}
$projects = get_project_list();
if (empty($projects)) {
//redirects if there's no active project for the user (if they've not created one)
header("Location: new_project.php");
exit;
}
if (!empty($_GET) && isset($_GET['id']) && isset($_GET['action']) && $_GET['action'] == 'delete') {
$deleteProject = get_project($_GET['id']);
if (empty($deleteProject)) {
$_SESSION['delete-project-message'] = "No project with that ID exists.";
header("Location: load.php");
exit;
}
if ($deleteProject['user_id'] != $_SESSION['user_id']) {
$_SESSION['delete-project-message'] = "You do not have access to that project.";
header("Location: load.php");
exit;
}
if ($deleteProject['project_id'] == $activeProject['project_id']) {
$_SESSION['delete-project-message'] = "Unable to delete active project. Switch to a different project to delete this one.";
header("Location: load.php");
exit;
}
// while($row=mysqli_fetch_array($user_uld_id)){
// $uld_id=$row["ULD_ID"];
// }
$select_wfh = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ure_uld_id}");
while ($row = mysqli_fetch_array($select_wfh)) {
$wfh_flag = $row['WFHA_FLAG'];
}
$values_array = array($get_permission_array, $get_project_array, $min_date, $error_array, $ure_empname, $wfh_flag);
// echo $values_array;
echo JSON_ENCODE($values_array);
}
if ($_REQUEST["option"] == "user_search_update") {
$get_permission_array = get_permission();
$ure_uld_id = get_uldid();
$ure_empname = get_empname();
$get_project_array = get_project($ure_uld_id);
$error = '3,4,5,6,7,8,16,17,18,67,83,98';
$error_array = get_error_msg($error);
$min_date = get_joindate($ure_uld_id);
$user_searchmin_date = mysqli_query($con, "SELECT MIN(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS where ULD_ID='{$ure_uld_id}' ");
while ($row = mysqli_fetch_array($user_searchmin_date)) {
$user_searchmin_date_value = $row["UARD_DATE"];
$user_searchmin_date_value = date('d-m-Y', strtotime($user_searchmin_date_value));
}
$user_searchmax_date = mysqli_query($con, "SELECT MAX(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS where ULD_ID='{$ure_uld_id}' ");
while ($row = mysqli_fetch_array($user_searchmax_date)) {
$user_searchmax_date_value = $row["UARD_DATE"];
$user_searchmax_date_value = date('d-m-Y', strtotime($user_searchmax_date_value));
}
$select_wfh = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ure_uld_id}");
while ($row = mysqli_fetch_array($select_wfh)) {
}
}
} else {
$img_url = $prev_project[0]['img_url'];
}
$project_edited = update_project($prev_title, $title, $description, $category, $target_funds, $start_date, $end_date, $img_url);
if ($project_edited) {
$success = "Successfully updated your project!";
} else {
$error = "Error updating project. Please try again!";
}
} else {
if (isset($req_params['edit']) || isset($req_params['delete'])) {
$project_title = htmlspecialchars($req_params['title']);
$project_owner = htmlspecialchars($req_params['owner']);
$project = get_project($project_title, $project_owner);
$rewards = get_rewards($project_title, $project_owner);
$title = $project[0]['title'];
$description = $project[0]['description'];
$category = $project[0]['category'];
$target_funds = $project[0]['target_funds'];
$start_date = $project[0]['start_date'];
$end_date = $project[0]['end_date'];
$img_url = $project[0]['img_url'];
} else {
if (isset($req_params['publish'])) {
$project_title = htmlspecialchars($req_params['title']);
$project_owner = htmlspecialchars($req_params['owner']);
publish_project($project_title, $project_owner);
} else {
if (isset($_POST['submit']) && $_POST['submit'] == "Delete") {
<div class="container" style="max-width: 750px;">
<?php
$project = get_project($_GET['projId']);
if (isset($_POST['save'])) {
$updatedProject = new Project();
$updatedProject->owner = $_SESSION['username'];
$updatedProject->name = $_POST['project-name'];
$updatedProject->description = $_POST['project-description'];
update_project($project->projectID, $updatedProject);
$project = get_project($project->projectID);
}
//$transport->close();
?>
<h1>Edit Project</h1>
<form action="<?php
echo $_SERVER['PHP_SELF'] . '?projId=' . $_GET['projId'];
?>
" method="post" role="form">
<div class="form-group">
$project_result = mysqli_query($con, "SELECT PS.PS_REC_VER FROM PROJECT_DETAILS PD JOIN PROJECT_STATUS PS WHERE PD.PD_ID=PS.PD_ID and PD.PD_PROJECT_NAME='{$REV_recversion}'");
$REV_project_recver = array();
while ($row = mysqli_fetch_array($project_result)) {
$REV_project_recver[] = $row["PS_REC_VER"];
}
// ACTIVE EMPLOYEE LIST
$REV_active_emp = get_active_emp_id();
// NON ACTIVE EMPLOYEE LIST
$REV_active_nonemp = get_nonactive_emp_id();
$final_values = array($REV_projectlist, $REV_project_array, $REV_active_emp, $REV_active_nonemp, $REV_errmsg, $REV_project_recver);
echo JSON_ENCODE($final_values);
}
//SPECICIFIED PROJECT NAM EFOR ACTINE ND NONACTIVE EMP
if ($_REQUEST['option'] == "SPECICIFIED_PROJECT_NAME") {
$REV_loginid = $_REQUEST['login_id'];
$REV_prjct_name = get_project($REV_loginid);
$final_values = array($REV_prjct_name);
echo JSON_ENCODE($final_values);
}
//SETTING MIN ND MAX DATE FUNCTION FOR NON ACTIVE EMPLOYEE BY DATE RANGE
if ($_REQUEST['option'] == "login_id") {
$recver_id = $_REQUEST['project_recverss'];
$prje_name = $_REQUEST['project_namess'];
$select_ps_id = mysqli_query($con, "select PS_ID from PROJECT_DETAILS PD ,PROJECT_STATUS PS where PD_PROJECT_NAME='{$prje_name}' AND PD.PD_ID=PS.PD_ID AND PS.PS_REC_VER='{$recver_id}'");
while ($row = mysqli_fetch_array($select_ps_id)) {
$REV_ps_id = $row["PS_ID"];
}
$REV_loginid = $_REQUEST['REV_loginids'];
// $uld_id=mysqli_query($con,"select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='$REV_loginid'");
// while($row=mysqli_fetch_array($uld_id)){
// $REV_uld_id=$row["ULD_ID"];
<body>
<?php
create_nav_bar();
?>
<div class="container" style="max-width: 750px;">
<?php
$experiment = get_experiment($_GET['expId']);
$project = get_project($experiment->projectID);
$experimentStatus = $experiment->experimentStatus;
$experimentState = $experimentStatus->experimentState;
$experimentStatusString = ExperimentState::$__names[$experimentState];
$experimentTimeOfStateChange = $experimentStatus->timeOfStateChange;
$userConfigData = $experiment->userConfigurationData;
$scheduling = $userConfigData->computationalResourceScheduling;
//var_dump($experiment);
switch ($experimentStatusString) {
case 'CREATED':
case 'VALIDATED':
case 'SCHEDULED':
case 'CANCELED':
case 'FAILED':
case 'UNKNOWN':
$editable = true;
$OUTPUT = writeedit($_POST);
break;
case "remove":
$OUTPUT = remove($_POST);
break;
case "writeremove":
$OUTPUT = writeremove($_POST);
break;
case "showedit":
$OUTPUT = enter($_POST);
break;
default:
$OUTPUT = get_project();
}
} else {
$OUTPUT = get_project();
}
$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";
function get_project()
{
db_connect();
$get_pro = "SELECT * FROM projects WHERE project_name != 'No Project' ORDER BY project_name";
$run_pro = db_exec($get_pro) or errDie("Unable to get project information.");
if (pg_numrows($run_pro) < 1) {
return "<li class='err'>No Projects Found. Please Add One.</li>";
} else {
$pro_drop = "<select name='project'>";
$pro_drop .= "<option value='' disabled selected>Select Project</option>";
while ($parr = pg_fetch_array($run_pro)) {
