/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws DataSecurityAccessDeniedException
* @throws ValueIDMissingException
*/
public static function list_versions($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
if ($get_array) {
$_GET = unserialize($get_array);
}
$argument_array = json_decode($json_argument_array);
$value_id = $argument_array[1];
if (is_numeric($value_id)) {
$value_obj = Value::get_instance($value_id);
if ($value_obj->is_read_access()) {
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = Data_Wrapper::list_value_versions($value_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$paramquery = $_GET;
$paramquery['action'] = "value_detail";
$paramquery['version'] = $list_array[$key]['internal_revision'];
$params = http_build_query($paramquery, '', '&');
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='images/icons/value.png' alt='N' border='0' />";
$tmp_name = $list_array[$key]['name'];
unset($list_array[$key]['name']);
$list_array[$key]['name']['link'] = $params;
$list_array[$key]['name']['content'] = $tmp_name;
$datetime_handler = new DatetimeHandler($list_array[$key]['datetime']);
$list_array[$key]['datetime'] = $datetime_handler->get_datetime(false);
$user = new User($list_array[$key]['owner_id']);
$list_array[$key]['user'] = $user->get_full_name(false);
$value_version_obj = clone $value_obj;
$value_version_obj->open_internal_revision($value['internal_revision']);
if ($value_version_obj->is_current() == true) {
$list_array[$key]['version'] = $value_version_obj->get_version() . " <span class='italic'>current</span>";
} else {
$list_array[$key]['version'] = $value_version_obj->get_version();
}
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new DataSecurityAccessDeniedException();
}
} else {
throw new ValueIDMissingException();
}
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
*/
public static function list_batches($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$datetime_handler_end = new DatetimeHandler();
$datetime_handler_end->sub_day(7);
$datetime_handler_create = new DatetimeHandler();
$datetime_handler_create->sub_day(30);
$list_array = Batch_Wrapper::list_batches($datetime_handler_create->get_formatted_string("Y-m-d H:i:s"), $datetime_handler_end->get_formatted_string("Y-m-d H:i:s"), $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$datetime_handler = new DatetimeHandler($list_array[$key]['created_at']);
$list_array[$key]['created_at'] = $datetime_handler->get_datetime(false);
$user = new User($list_array[$key]['user_id']);
$list_array[$key]['user'] = $user->get_full_name(true);
switch ($list_array[$key]['status']) {
case "0":
$list_array[$key]['symbol'] = "<img src='images/icons/job_queue.png' alt='' />";
$list_array[$key]['status'] = "created";
break;
case "1":
$list_array[$key]['symbol'] = "<img src='images/icons/job_queue.png' alt='' />";
$list_array[$key]['status'] = "in queue";
break;
case "2":
$list_array[$key]['symbol'] = "<img src='images/icons/job_running.png' alt='' />";
$list_array[$key]['status'] = "running";
break;
case "3":
$list_array[$key]['symbol'] = "<img src='images/icons/job_finished.png' alt='' />";
$list_array[$key]['status'] = "finished";
break;
case "4":
$list_array[$key]['symbol'] = "<img src='images/icons/job_error.png' alt='' />";
$list_array[$key]['status'] = "error";
break;
default:
$list_array[$key]['symbol'] = "<img src='images/icons/job_unknown.png' alt='' />";
$list_array[$key]['status'] = "unknow status";
break;
}
}
} else {
$list_request->empty_message("<span class='italic'>No Batches in the last 7 days</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws BaseUserAccessDeniedException
*/
public static function list_templates($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
global $user;
if ($user->is_admin()) {
if ($get_array) {
$_GET = unserialize($get_array);
}
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = Data_Wrapper::list_parameter_templates($sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$paramquery = $_GET;
$paramquery['id'] = $list_array[$key]['id'];
$paramquery['action'] = "edit";
unset($paramquery['sortvalue']);
unset($paramquery['sortmethod']);
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
$name = $list_array[$key]['name'];
unset($list_array[$key]['name']);
$list_array[$key]['name']['link'] = $params;
$list_array[$key]['name']['content'] = $name;
$internal_name = $list_array[$key]['internal_name'];
unset($list_array[$key]['internal_name']);
$list_array[$key]['internal_name']['link'] = $params;
$list_array[$key]['internal_name']['content'] = $internal_name;
$user = new User($list_array[$key]['created_by']);
$list_array[$key]['created_by'] = $user->get_full_name(true);
$datetime_handler = new DatetimeHandler($list_array[$key]['datetime']);
$list_array[$key]['datetime'] = $datetime_handler->get_datetime(false);
if (ParameterTemplate::is_deletable($list_array[$key]['id']) === true) {
$list_array[$key]['delete'] = "<a title='delete' style='cursor: pointer;' id='DataParameterTemplateDeleteButton" . $list_array[$key]['id'] . "' class='DataParameterTemplateDeleteButton'><img src='images/icons/delete.png' alt='D' /></a>";
} else {
$list_array[$key]['delete'] = "";
}
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new BaseUserAccessDeniedException();
}
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws BaseUserAccessDeniedException
*/
public static function list_users($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
global $user;
if ($user->is_admin()) {
if ($get_array) {
$_GET = unserialize($get_array);
}
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = User_Wrapper::list_users($sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$user = new User($list_array[$key]['id']);
$paramquery = $_GET;
$paramquery['action'] = "detail";
$paramquery['id'] = $list_array[$key]['id'];
$params = http_build_query($paramquery, '', '&');
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='images/icons/user.png' alt='' style='border: 0;' />";
unset($list_array[$key]['username']);
$list_array[$key]['username']['link'] = $params;
$list_array[$key]['username']['content'] = $user->get_username();
$list_array[$key]['fullname'] = $user->get_full_name(false);
$list_array[$key]['groups'] = Group::get_number_of_groups_by_user_id($list_array[$key]['id']);
$paramquery = $_GET;
$paramquery['action'] = "delete";
$paramquery['id'] = $list_array[$key]['id'];
$params = http_build_query($paramquery, '', '&');
if ($list_array[$key]['id'] == 1) {
$list_array[$key]['delete'] = "<img src='images/icons/delete_user_na.png' alt='' style='border: 0;' />";
} else {
$list_array[$key]['delete']['link'] = $params;
$list_array[$key]['delete']['content'] = "<img src='images/icons/delete_user.png' alt='' style='border: 0;' />";
}
}
} else {
$list_request->empty_message("<span class='italic'>No users found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new BaseUserAccessDeniedException();
}
}
public static function list_system_messages()
{
define(SYSTEM_MESSAGE_ENTRIES_PER_PAGE, 6);
$system_message_array = SystemMessage::list_entries();
if (!$_GET['page']) {
$page = 1;
} else {
$page = $_GET['page'];
}
$entry_count = count($system_message_array);
$number_of_pages = ceil($entry_count / SYSTEM_MESSAGE_ENTRIES_PER_PAGE);
$template = new HTMLTemplate("base/list_system_messages.html");
if (is_array($system_message_array) and count($system_message_array) >= 1) {
$template->set_var("no_entry", false);
$result = array();
$counter = 0;
if (count($system_message_array) < $page * SYSTEM_MESSAGE_ENTRIES_PER_PAGE) {
$max_for = count($system_message_array) % SYSTEM_MESSAGE_ENTRIES_PER_PAGE - 1;
} else {
$max_for = SYSTEM_MESSAGE_ENTRIES_PER_PAGE - 1;
}
for ($i = 0; $i <= $max_for; $i++) {
$entry = $page * SYSTEM_MESSAGE_ENTRIES_PER_PAGE + $i - SYSTEM_MESSAGE_ENTRIES_PER_PAGE;
// Erzeugt Entry-ID
$value = $system_message_array[$entry];
$system_message = new SystemMessage($value);
$user = new User($system_message->get_user_id());
$datetime_handler = new DatetimeHandler($system_message->get_datetime());
$content = str_replace("\n", "<br />", $system_message->get_content());
$content = str_replace("\\", "", $content);
$result[$counter]['user'] = $user->get_full_name(false);
$result[$counter]['datetime'] = $datetime_handler->get_date() . " at " . $datetime_handler->get_time();
$result[$counter]['content'] = $content;
$counter++;
}
$template->set_var("message_array", $result);
} else {
$template->set_var("no_entry", true);
}
if ($number_of_pages > 1) {
$template->set_var("page_bar", Common_IO::page_bar($page, $number_of_pages, $_GET));
} else {
$template->set_var("page_bar", "");
}
$template->output();
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws SampleIDMissingException
* @throws SampleSecurityAccessDeniedException
*/
public static function list_user_permissions($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
global $user;
if ($get_array) {
$_GET = unserialize($get_array);
}
$argument_array = json_decode($json_argument_array);
$sample_id = $argument_array[1];
if (is_numeric($sample_id)) {
$sample = new Sample($sample_id);
if ($sample->get_owner_id() == $user->get_user_id() or $user->is_admin() == true) {
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = Sample_Wrapper::list_sample_users($sample_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$list_array[$key]['symbol'] = "<img src='images/icons/user.png' alt='' style='border:0;' />";
if ($list_array[$key]['user']) {
$user = new User($list_array[$key]['user']);
} else {
$user = new User(1);
}
$list_array[$key]['username'] = $user->get_username();
$list_array[$key]['name'] = $user->get_full_name(false);
if ($list_array[$key]['read'] == 't') {
$list_array[$key]['read'] = "<img src='images/icons/permission_ok_active.png' alt='' />";
} else {
$list_array[$key]['read'] = "<img src='images/icons/permission_denied_active.png' alt='' />";
}
if ($list_array[$key]['write'] == 't') {
$list_array[$key]['write'] = "<img src='images/icons/permission_ok_active.png' alt='' />";
} else {
$list_array[$key]['write'] = "<img src='images/icons/permission_denied_active.png' alt='' />";
}
$delete_paramquery = $_GET;
$delete_paramquery['run'] = "admin_permission_user_delete";
$delete_paramquery['id'] = $list_array[$key]['user'];
unset($delete_paramquery['sure']);
$delete_params = http_build_query($delete_paramquery, '', '&');
if ($sample->get_owner_id() == $list_array[$key]['user']) {
$list_array[$key]['delete']['link'] = "";
$list_array[$key]['delete']['content'] = "";
} else {
$list_array[$key]['delete']['link'] = $delete_params;
$list_array[$key]['delete']['content'] = "delete";
}
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new SampleSecurityAccessDeniedException();
}
} else {
throw new SampleIDMissingException();
}
}
//Store the user's UID in a session variable for easy access
$_SESSION['uid'] = $result['uID'];
//Now assign the user their roles
$query = "SELECT role FROM Roles WHERE idUsers = :idUser";
$stmt = $dbh->prepare($query);
$stmt->bindParam(':idUser', intval($result['idUsers']), PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
//Now add the user's roles to the User object
foreach ($result as $row) {
echo "I'm adding this: " . $row['role'];
$user->add_role($row['role']);
}
//Add the user to a session variable and get their full name in one too
$_SESSION['user'] = $user;
$_SESSION['full_name'] = $user->get_full_name();
//If the user was trying to access a page, send them there
if (isset($_SESSION['requestedPage'])) {
$requestedPage = $_SESSION['requestedPage'];
unset($_SESSION['requestedPage']);
header($requestedPage);
} else {
header('Location: projectMain.php');
}
} else {
$_SESSION['registered'] = false;
$_SESSION['badUserPass'] = true;
}
} else {
$_SESSION['registered'] = false;
$_SESSION['badUserPass'] = true;
/**
* @param string $get_array
* @throws SampleIDMissingException
*/
public static function get_sample_information($get_array)
{
global $user;
if ($get_array) {
$_GET = unserialize($get_array);
}
if ($_GET['sample_id']) {
$sample_security = new SampleSecurity($_GET['sample_id']);
if ($sample_security->is_access(1, false)) {
$sample = new Sample($_GET['sample_id']);
$owner = new User($sample->get_owner_id());
$template = new HTMLTemplate("sample/ajax/detail_information.html");
$template->set_var("id", $sample->get_formatted_id());
$template->set_var("name", $sample->get_name());
$template->set_var("owner", $owner->get_full_name(false));
$template->set_var("template", $sample->get_template_name());
$template->set_var("permissions", $sample_security->get_access_string());
$datetime = new DatetimeHandler($sample->get_datetime());
$template->set_var("datetime", $datetime->get_datetime());
if ($sample->get_date_of_expiry()) {
$date_of_expiry = new DatetimeHandler($sample->get_date_of_expiry());
$template->set_var("date_of_expiry", $date_of_expiry->get_date());
} else {
$template->set_var("date_of_expiry", false);
}
if ($sample->get_current_location_name()) {
$template->set_var("location", $sample->get_current_location_name());
} else {
$template->set_var("location", false);
}
if ($sample->get_manufacturer_id()) {
$manufacturer = new Manufacturer($sample->get_manufacturer_id());
$template->set_var("manufacturer", $manufacturer->get_name());
} else {
$template->set_var("manufacturer", false);
}
if ($sample->get_availability() == true) {
$template->set_var("status", "available");
} else {
$template->set_var("status", "not available");
}
if ($sample->get_owner_id() == $user->get_user_id() or $user->is_admin() == true) {
$template->set_var("is_owner", true);
} else {
$template->set_var("is_owner", false);
}
if ($user->is_admin() == true) {
$template->set_var("is_admin", true);
} else {
$template->set_var("is_admin", false);
}
$owner_paramquery = array();
$owner_paramquery['username'] = $_GET['username'];
$owner_paramquery['session_id'] = $_GET['session_id'];
$owner_paramquery['nav'] = "sample";
$owner_paramquery['run'] = "common_dialog";
$owner_paramquery['dialog'] = "user_detail";
$owner_paramquery['id'] = $sample->get_owner_id();
$owner_params = http_build_query($owner_paramquery, '', '&');
$template->set_var("owner_params", $owner_params);
$location_history_paramquery = $_GET;
$location_history_paramquery['run'] = "location_history";
$location_history_params = http_build_query($location_history_paramquery, '', '&');
$template->set_var("location_history_params", $location_history_params);
$template->output();
}
} else {
throw new SampleIDMissingException();
}
}
echo "<h1>CANNOT LOGIN!</h1> <p>Reason: Password or name is empty. If your page doesn't refresh, <a href='login.php?action=loginFailed&reason=empty'>click here to back</a></p>";
} else {
if (empty($_POST['username']) || empty($_POST['password'])) {
header("Refresh: 3 URL=\"login.php?action=loginFailed&reason=empty\"");
echo "<h1>CANNOT LOGIN!</h1> <p>Reason: Password or name is empty. If your page doesn't refresh, <a href='login.php?action=loginFailed&reason=empty'>click here to back</a></p>";
} else {
include_once "config/opendb.php";
include_once 'classes/AAA.php';
$user = addslashes($_POST['username']);
$pass = $_POST['password'];
$userCheck = new User();
if ($userCheck->authenticate_user($user, $pass)) {
$userID = $userCheck->get_user_id_by_user_name($user);
$newUser = new User($userID);
$access = $newUser->get_access_level();
$full = $newUser->get_full_name();
$newUser->update_last_login(getIP());
session_start();
$_SESSION['username'] = $user;
$_SESSION['fullname'] = $full;
$_SESSION['password'] = $pass;
$_SESSION['access'] = $access;
$_SESSION['userid'] = $userID;
$_SESSION['action'] = "";
header("Location: index.php");
echo "Login complete.";
} else {
?>
<form method='post' name="errorForm" action='login.php?action=loginFailed'>
<input type='hidden' name='error' value="<?php
echo $userCheck->get_error();
/**
* @throws ProjectTaskIDMissingException
* @throws ProjectSecuriyAccessDeniedException
*/
public static function detail()
{
global $user, $project_security;
if ($_GET['id']) {
if ($project_security->is_access(1, false) == true) {
$project_task = new ProjectTask($_GET['id']);
$project_task_owner = new User($project_task->get_owner_id());
if ($project_task->get_start_time()) {
$project_task_start = new DatetimeHandler($project_task->get_start_date() . " " . $project_task->get_start_time());
} else {
$project_task_start = new DatetimeHandler($project_task->get_start_date() . " 00:00:00");
}
if ($project_task->get_uf_end_time() != -1) {
$project_task_end = new DatetimeHandler($project_task->get_end_date() . " " . $project_task->get_end_time());
} else {
$project_task_end = new DatetimeHandler($project_task->get_end_date() . " 23:59:59");
}
$project_task_created_at = new DatetimeHandler($project_task->get_created_at());
$template = new HTMLTemplate("project/tasks/detail.html");
switch ($project_task->get_type()) {
case 1:
$template->set_var("type", "Status Related Task");
$template->set_var("task_type", "1");
$template->set_var("progress", $project_task->get_progress() . "%");
$project_status = new ProjectStatus($project_task->get_begin_status_id());
$template->set_var("begin_status", $project_status->get_name());
break;
case 2:
$template->set_var("type", "Task");
$template->set_var("task_type", "2");
$template->set_var("progress", $project_task->get_progress() . "%");
break;
case 3:
$template->set_var("type", "Milestone");
$template->set_var("task_type", "3");
break;
default:
$template->set_var("type", "Undefined");
$template->set_var("task_type", "0");
break;
}
$template->set_var("owner", $project_task_owner->get_full_name(false));
$template->set_var("start", $project_task_start->get_formatted_string("l, jS F Y H:i"));
$template->set_var("end", $project_task_end->get_formatted_string("l, jS F Y H:i"));
if ($project_task->get_auto_connect() == true) {
$template->set_var("auto_connect", "Yes");
} else {
$template->set_var("auto_connect", "No");
}
$template->set_var("created_at", $project_task_created_at->get_formatted_string("l, jS F Y H:i"));
$template->set_var("name", $project_task->get_name());
if ($user->get_user_id() == $project_task->get_owner_id() or $user->is_admin()) {
$template->set_var("task_admin", true);
$paramquery = $_GET;
$paramquery['run'] = "task_edit_start";
$params = http_build_query($paramquery, '', '&');
$template->set_var("task_edit_start_params", $params);
$paramquery = $_GET;
$paramquery['run'] = "task_edit_end";
$params = http_build_query($paramquery, '', '&');
$template->set_var("task_edit_end_params", $params);
$paramquery = $_GET;
$paramquery['run'] = "task_delete";
$params = http_build_query($paramquery, '', '&');
$template->set_var("delete_params", $params);
} else {
$template->set_var("task_admin", false);
}
$template->output();
} else {
throw new ProjectSecuriyAccessDeniedException();
}
} else {
throw new ProjectTaskIDMissingException();
}
}
/**
* @throws FolderIDMissingException
*/
public static function change_owner()
{
if ($_GET['file_id'] or $_GET['value_id'] or $_GET['parameter_id'] or $_GET['folder_id']) {
if ($_GET['file_id']) {
$id = $_GET['file_id'];
$object = File::get_instance($id);
$type = "file";
$title = $object->get_name();
}
if ($_GET['value_id']) {
$id = $_GET['value_id'];
$object = Value::get_instance($id);
$type = "value";
$title = $object->get_type_name();
}
if ($_GET['parameter_id']) {
$id = $_GET['parameter_id'];
$object = Parameter::get_instance($id);
$type = "parameter";
$title = $object->get_name();
}
if ($_GET['folder_id']) {
$id = $_GET['folder_id'];
$object = Folder::get_instance($id);
$type = "folder";
$title = $object->get_name();
}
} else {
throw new FolderIDMissingException();
}
if ($object->is_control_access() == true) {
$data_permission = new DataPermission($type, $id);
if (!$_GET['nextpage']) {
$template = new HTMLTemplate("data/data_change_owner.html");
$paramquery = $_GET;
$paramquery['nextpage'] = "1";
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
$template->set_var("title", $title);
$template->set_var("error", "");
$user_array = User::list_entries();
$result = array();
$counter = 0;
foreach ($user_array as $key => $value) {
$user = new User($value);
$result[$counter]['value'] = $value;
$result[$counter]['content'] = $user->get_username() . " (" . $user->get_full_name(false) . ")";
$counter++;
}
$template->set_var("option", $result);
$paramquery = $_GET;
$paramquery['action'] = "permission";
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
$template->set_var("back_link", $params);
$template->output();
} else {
$paramquery = $_GET;
$paramquery['action'] = "permission";
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
if ($data_permission->set_owner_id($_POST['user']) == true) {
Common_IO::step_proceed($params, "Permission: " . $title . "", "Changes saved succesful", null);
} else {
Common_IO::step_proceed($params, "Permission: " . $title . "", "Operation failed", null);
}
}
} else {
throw new DataSecuriyAccessDeniedException();
}
}
/**
* @throws SystemLogIDMissingException
*/
public static function ip_info()
{
if ($_GET['id']) {
$ip = $_GET['id'];
$successful_logins = SystemLog::count_ip_successful_logins($ip);
$failed_logins = SystemLog::count_ip_failed_logins($ip);
$template = new HTMLTemplate("base/admin/system_log/ip_info.html");
$template->set_var("ip", $ip);
if ($successful_logins) {
$template->set_var("successful_logins", $successful_logins);
} else {
$template->set_var("successful_logins", 0);
}
if ($failed_logins) {
$template->set_var("failed_logins", $failed_logins);
} else {
$template->set_var("failed_logins", 0);
}
$user_array = SystemLog::list_ip_users($ip);
$user_content_array = array();
$counter = 0;
if (is_array($user_array) and count($user_array) >= 1) {
foreach ($user_array as $key => $value) {
$user = new User($value);
$user_content_array[$counter]['username'] = $user->get_username();
$user_content_array[$counter]['fullname'] = $user->get_full_name(false);
$counter++;
}
$template->set_var("no_user", false);
} else {
$template->set_var("no_user", true);
}
$template->set_var("user", $user_content_array);
$template->output();
} else {
throw new SystemLogIDMissingException();
}
}
<?php
require_once '../includes/database.php';
require_once '../includes/user.php';
$user = new User($db);
$my_user = $user->find_by_id(1);
echo $my_user->get_full_name();
echo "<hr />";
$users = $user->find_all();
foreach ($users as $user) {
echo "User: "******"<br />";
echo "Name: " . $user->get_full_name() . "<br /><br />";
echo "<hr />";
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws BaseUserAccessDeniedException
* @throws OrganisationUnitIDMissingException
*/
public static function list_quality_managers($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
global $user;
if ($user->is_admin()) {
if ($get_array) {
$_GET = unserialize($get_array);
}
$argument_array = json_decode($json_argument_array);
$organisation_unit_id = $argument_array[1];
if (is_numeric($organisation_unit_id)) {
$type_id = $argument_array[1];
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = OrganisationUnit_Wrapper::list_organisation_unit_quality_managers($organisation_unit_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$user = new User($value['id']);
$list_array[$key]['symbol'] = "<img src='images/icons/user.png' alt='' />";
$list_array[$key]['username'] = $user->get_username();
$list_array[$key]['fullname'] = $user->get_full_name(false);
$list_array[$key]['delete'] = "<a href='#' class='OrganisationUnitAdminListDelete' id='OrganisationUnitAdminListDelete" . $list_array[$key]['id'] . "'><img src='images/icons/delete.png' alt='' style='border: 0;' /></a>";
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new OrganisationUnitIDMissingException();
}
} else {
throw new BaseUserAccessDeniedException();
}
}
/**
* @param string $get_array
* @return string
* @throws ProjectSecurityAccessDeniedException
* @throws ProjectIDMissingException
*/
public static function get_project_admin_menu($get_array)
{
global $user;
if ($get_array) {
$_GET = unserialize($get_array);
}
if ($_GET['project_id']) {
$project = new Project($_GET['project_id']);
$project_security = new ProjectSecurity($_GET['project_id']);
$project_owner = new User($project->get_owner_id());
$organisation_unit_id = $project->get_organisation_unit_id();
$parent_project_id = $project->get_project_toid();
if ($user->get_user_id() == $project->get_owner_id() or $project_security->is_access(2, false) == true or $project_security->is_access(3, false) == true or $project_security->is_access(4, false) == true or $project_security->is_access(5, false) == true or $project_security->is_access(6, false) == true or $project_security->is_access(7, false) == true) {
if ($organisation_unit_id) {
$organisation_unit = new OrganisationUnit($organisation_unit_id);
$parent = $organisation_unit->get_name();
$parent_type = "Organisation Unit";
} else {
$parent_project = new Project($parent_project_id);
$parent = $parent_project->get_name();
$parent_type = "Project";
}
$template = new HTMLTemplate("project/ajax/admin/menu.html");
$template->set_var("name", $project->get_name());
$template->set_var("owner", $project_owner->get_full_name(false));
$template->set_var("parent", $parent);
$template->set_var("parent_type", $parent_type);
if ($user->is_admin()) {
$template->set_var("admin", true);
} else {
$template->set_var("admin", false);
}
if ($project_security->is_access(7, false) == true or $project->get_owner_id() == $user->get_user_id()) {
$template->set_var("owner_permission", true);
} else {
$template->set_var("owner_permission", false);
}
if ($project_security->is_access(6, false) == true) {
$template->set_var("delete", true);
} else {
$template->set_var("delete", false);
}
if ($project_security->is_access(3, false) == true) {
$template->set_var("write", true);
} else {
$template->set_var("write", false);
}
if ($project->get_current_status_id() == 0) {
$template->set_var("project_canceled", true);
} else {
$template->set_var("project_canceled", false);
}
if ($project->get_deleted() == true) {
$template->set_var("project_deleted", true);
} else {
$template->set_var("project_deleted", false);
}
if ($project->get_quota() == 0) {
$template->set_var("quota", "unlimited");
} else {
$template->set_var("quota", Convert::convert_byte_1024($project->get_quota()));
}
$permission_paramquery = $_GET;
$permission_paramquery['run'] = "admin_permission";
unset($permission_paramquery['nextpage']);
unset($permission_paramquery['sure']);
$permission_params = http_build_query($permission_paramquery, '', '&');
$template->set_var("permission_params", $permission_params);
$rename_paramquery = $_GET;
$rename_paramquery['run'] = "admin_rename";
unset($rename_paramquery['nextpage']);
unset($rename_paramquery['sure']);
$rename_params = http_build_query($rename_paramquery, '', '&');
$template->set_var("rename_params", $rename_params);
$chown_paramquery = $_GET;
$chown_paramquery['run'] = "admin_chown";
unset($chown_paramquery['nextpage']);
unset($chown_paramquery['sure']);
$chown_params = http_build_query($chown_paramquery, '', '&');
$template->set_var("chown_params", $chown_params);
$move_paramquery = $_GET;
$move_paramquery['run'] = "admin_move";
unset($move_paramquery['nextpage']);
unset($move_paramquery['sure']);
$move_params = http_build_query($move_paramquery, '', '&');
$template->set_var("move_params", $move_params);
$chquota_paramquery = $_GET;
$chquota_paramquery['run'] = "admin_quota";
unset($chquota_paramquery['nextpage']);
unset($chquota_paramquery['sure']);
$chquota_params = http_build_query($chquota_paramquery, '', '&');
$template->set_var("chquota_params", $chquota_params);
return $template->get_string();
} else {
throw new ProjectSecurityAccessDeniedException();
}
} else {
throw new ProjectIDMissingException();
}
}
/**
* @throws EquipmentTypeIDMissingException
*/
public static function type_detail($type_id, $owner_id)
{
if (is_numeric($type_id)) {
$equipment_type = new EquipmentType($type_id);
$equipment_owner = new User($owner_id);
$template = new HTMLTemplate("equipment/detail.html");
$template->set_var("name", $equipment_type->get_name());
$template->set_var("category", $equipment_type->get_cat_name());
if ($equipment_type->get_location_id() == null) {
$template->set_var("location", "<span class='italic'>none</span>");
} else {
$location = new Location($equipment_type->get_location_id());
$template->set_var("location", $location->get_name(true));
}
$template->set_var("owner", $equipment_owner->get_full_name(false));
if ($equipment_type->get_description()) {
$template->set_var("description", $equipment_type->get_description());
} else {
$template->set_var("description", "<span class='italic'>none</span>");
}
$user_array = $equipment_type->list_users();
$user_content_array = array();
$counter = 0;
if (is_array($user_array) and count($user_array) >= 1) {
foreach ($user_array as $key => $value) {
$user = new User($value);
$user_content_array[$counter]['username'] = $user->get_username();
$user_content_array[$counter]['fullname'] = $user->get_full_name(false);
$counter++;
}
$template->set_var("no_user", false);
} else {
$template->set_var("no_user", true);
}
$template->set_var("user", $user_content_array);
$ou_array = $equipment_type->list_organisation_units();
$ou_content_array = array();
$counter = 0;
if (is_array($ou_array) and count($ou_array) >= 1) {
foreach ($ou_array as $key => $value) {
$organisation_unit = new OrganisationUnit($value);
$ou_content_array[$counter]['name'] = $organisation_unit->get_name();
$counter++;
}
$template->set_var("no_ou", false);
} else {
$template->set_var("no_ou", true);
}
$template->set_var("ou", $ou_content_array);
$template->output();
} else {
throw new EquipmentTypeIDMissingException();
}
}
/**
* @param string $sql
* @param integer $item_id
* @param object $pdf
* @return object
*/
public static function get_data_item_report($sql, $item_id, $pdf)
{
global $regional;
if ($sql and is_object($pdf)) {
// Values
$value_array = Data_Wrapper::list_item_values($sql);
if (is_array($value_array) and count($value_array) >= 1) {
foreach ($value_array as $key => $value) {
$value_object = Value::get_instance($value['id']);
$value_object_value_array = $value_object->get_value_content(false);
$pdf->addPage();
$pdf->SetFont('dejavusans', 'B', 14, '', true);
$pdf->Write(0, 'Value - ' . $value_object->get_name() . '', '', 0, 'C', true, 0, false, false, 0);
$pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0);
$pdf->SetFont('dejavusans', '', 12, '', true);
if (is_array($value_object_value_array) and count($value_object_value_array) >= 1) {
foreach ($value_object_value_array as $sub_key => $sub_value) {
$sub_value['content'][0] = str_replace("\n", "<br />", $sub_value['content'][0]);
if ($sub_value['type'] == "textarea") {
$pdf->SetFont('dejavusans', 'B', 12, '', true);
$pdf->MultiCell(190, 9, $sub_value['title'], 1, 'L', 1, 1, '', '', true, 0, true, true, 0, "T");
$pdf->SetFont('dejavusans', '', 12, '', true);
$string_height = $pdf->getStringHeight(110, $sub_value['content'][0], true, true, '', 1);
$pdf->MultiCell(190, $string_height, $sub_value['content'][0], 1, 'L', 1, 1, '', '', true, 0, true, true, 0, "T");
} else {
$pdf->SetFont('dejavusans', 'B', 12, '', true);
$string_height1 = $pdf->getStringHeight(80, $sub_value['title'], true, true, '', 1);
$pdf->SetFont('dejavusans', '', 12, '', true);
$string_height2 = $pdf->getStringHeight(110, $sub_value['content'][0], true, true, '', 1);
if ($string_height1 > $string_height2) {
$height = $string_height1;
} else {
$height = $string_height2;
}
$pdf->SetFont('dejavusans', 'B', 12, '', true);
$pdf->MultiCell(80, $height, $sub_value['title'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0, "T");
$pdf->SetFont('dejavusans', '', 12, '', true);
$pdf->MultiCell(110, $height, $sub_value['content'][0], 1, 'L', 1, 1, '', '', true, 0, true, true, 0, "T");
}
}
}
$value_object_version_array = $value_object->get_value_internal_revisions();
if (is_array($value_object_version_array) and count($value_object_version_array) >= 1) {
$pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0);
$header_array = array(array("name" => "name", "title" => "Name", "width" => 60), array("name" => "version", "title" => "Version", "width" => 25), array("name" => "datetime", "title" => "Date/Time", "width" => 55), array("name" => "user", "title" => "User", "width" => 50));
$report_table = new ReportTable_IO($pdf, '', '12');
$report_table->add_header($header_array);
foreach ($value_object_version_array as $sub_key => $sub_value) {
$value_version = clone $value_object;
$value_version->open_internal_revision($sub_value);
$datetime_handler = new DatetimeHandler($value_version->get_datetime());
$owner = new User($value_version->get_version_owner_id());
$line_array = array(array("name" => "name", "content" => $value_version->get_name()), array("name" => "version", "content" => $value_version->get_version()), array("name" => "datetime", "content" => $datetime_handler->get_datetime(false)), array("name" => "user", "content" => $owner->get_full_name(true)));
$report_table->add_line($line_array);
}
}
$pdf = $report_table->get_pdf();
}
}
// Files
$file_array = Data_Wrapper::list_item_files($sql, null, null, null, null);
if (is_array($file_array) and count($file_array) >= 1) {
$pdf->addPage();
$pdf->SetFont('dejavusans', 'B', 14, '', true);
$pdf->Write(0, 'Files', '', 0, 'C', true, 0, false, false, 0);
$pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0);
$pdf->SetFont('dejavusans', '', 14, '', true);
$header_array = array(array("name" => "name", "title" => "Name", "width" => 62), array("name" => "version", "title" => "Version", "width" => 25), array("name" => "datetime", "title" => "Date/Time", "width" => 55), array("name" => "user", "title" => "User", "width" => 48));
$report_table = new ReportTable_IO($pdf, '', '12');
$report_table->add_header($header_array);
foreach ($file_array as $key => $value) {
$file = File::get_instance($value['id']);
$owner = new User($value['owner_id']);
$datetime_handler = new DatetimeHandler($value['datetime']);
$line_array = array(array("name" => "name", "content" => $value['name']), array("name" => "version", "content" => $file->get_version()), array("name" => "datetime", "content" => $datetime_handler->get_datetime(false)), array("name" => "user", "content" => $owner->get_full_name(true)));
$report_table->add_line($line_array);
}
$pdf = $report_table->get_pdf();
}
// Parameters
$parameter_array = Data_Wrapper::list_item_parameters($sql);
if (is_array($parameter_array) and count($parameter_array) >= 1) {
foreach ($parameter_array as $key => $value) {
$parameter_object = Parameter::get_instance($value['id']);
$parameter_template = new ParameterTemplate($parameter_object->get_template_id());
$parameter_template_field_array = $parameter_template->get_fields();
$parameter_template_limit_array = $parameter_template->get_limits();
$parameter_value_array = $parameter_object->get_values();
$parameter_method_array = $parameter_object->get_methods();
$parameter_status_array = $parameter_object->get_status();
$parameter_limit_array = $parameter_object->geT_limits();
$pdf->addPage();
$pdf->SetFont('dejavusans', 'B', 14, '', true);
$pdf->Write(0, '' . $parameter_object->get_name() . '', '', 0, 'L', true, 0, false, false, 0);
$pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0);
$pdf->SetFont('dejavusans', '', 12, '', true);
$header_array = array(array("name" => "parameter", "title" => "Parameter", "width" => 44), array("name" => "value", "title" => "Value", "width" => 25), array("name" => "unit", "title" => "Unit", "width" => 25), array("name" => "min", "title" => "Min", "width" => 20), array("name" => "max", "title" => "Max", "width" => 20), array("name" => "method", "title" => "Method", "width" => 30), array("name" => "status", "title" => "Status", "width" => 25));
$report_table = new ReportTable_IO($pdf, '', '12');
$report_table->add_header($header_array);
if (is_array($parameter_template_field_array) and count($parameter_template_field_array) >= 1) {
foreach ($parameter_template_field_array as $key => $value) {
if (is_numeric($parameter_value_array[$value['pk']])) {
$regionalized_value = str_replace(".", $regional->get_decimal_separator(), $parameter_value_array[$value['pk']]);
} else {
$regionalized_value = "";
}
if (is_numeric($value['unit'])) {
if ($value['unit_exponent'] < 0) {
$unit_exponent = $value['unit_exponent'] * -1;
$unit_prefix = MeasuringUnit::get_prefix($unit_exponent, false);
} else {
$unit_prefix = MeasuringUnit::get_prefix($value['unit_exponent'], true);
}
$measuring_unit = new MeasuringUnit($value['unit']);
$unit = $unit_prefix[1] . "" . $measuring_unit->get_unit_symbol();
} elseif (is_numeric($value['unit_ratio'])) {
$measuring_unit_ratio = new MeasuringUnitRatio($value['unit_ratio']);
$unit = $measuring_unit_ratio->get_symbol();
} else {
$unit = "";
}
if ($parameter_limit_array[$value['pk']]) {
if (is_numeric($parameter_limit_array[$value['pk']]['usl'])) {
$usl = $parameter_limit_array[$value['pk']]['usl'];
} else {
$usl = "";
}
if (is_numeric($parameter_limit_array[$value['pk']]['lsl'])) {
$lsl = $parameter_limit_array[$value['pk']]['lsl'];
} else {
$lsl = "";
}
} else {
if (is_numeric($parameter_template_limit_array[0]['usl'][$key])) {
$usl = $parameter_template_limit_array[0]['usl'][$key];
} else {
$usl = "";
}
if (is_numeric($parameter_template_limit_array[0]['lsl'][$key])) {
$lsl = $parameter_template_limit_array[0]['lsl'][$key];
} else {
$lsl = "";
}
}
if ($parameter_method_array[$key]) {
$method = $parameter_method_array[$key];
} else {
$method = "none";
}
if ($parameter_status_array[$value['pk']]) {
switch ($parameter_status_array[$value['pk']]) {
case "max":
$status = ">max";
break;
case "min":
$status = "<min";
break;
default:
$status = "OK";
break;
}
} else {
$status = "none";
}
$line_array = array(array("name" => "parameter", "content" => $value['name']), array("name" => "value", "content" => $regionalized_value), array("name" => "unit", "content" => $unit), array("name" => "min", "content" => $lsl), array("name" => "max", "content" => $usl), array("name" => "method", "content" => $method), array("name" => "status", "content" => $status));
$report_table->add_line($line_array);
unset($regionalized_value);
unset($unit);
unset($lsl);
unset($usl);
unset($method);
unset($status);
}
}
$pdf = $report_table->get_pdf();
}
}
return $pdf;
} else {
return null;
}
}
/**
* @throws ProjectIDMissingException
* @throws ProjectSecuriyAccessDeniedException
*/
public static function structure()
{
global $project_security;
if ($_GET['project_id']) {
if ($project_security->is_access(1, false) == true) {
$project = new Project($_GET['project_id']);
$project_structure_array = $project->get_project_tree();
$template = new HTMLTemplate("project/structure.html");
if (is_array($project_structure_array) and count($project_structure_array) >= 1) {
$result = array();
$counter = 0;
foreach ($project_structure_array as $key => $value) {
$project = new Project($value['id']);
$project_security = new ProjectSecurity($value['id']);
$project_owner = new User($project->get_owner_id());
$paramquery['username'] = $_GET['username'];
$paramquery['session_id'] = $_GET['session_id'];
$paramquery['nav'] = "project";
$paramquery['run'] = "detail";
$paramquery['project_id'] = $value['id'];
$params = http_build_query($paramquery, '', '&');
$result[$counter]['link'] = $params;
$result[$counter]['name'] = $project->get_name();
$result[$counter]['status'] = $project->get_current_status_name();
$result[$counter]['template'] = $project->get_template_name();
$result[$counter]['owner'] = $project_owner->get_full_name(false);
$involved_array = $project_security->list_involved_users();
if (is_array($involved_array) and count($involved_array) >= 1) {
foreach ($involved_array as $involved_key => $involved_value) {
$involved_user = new User($involved_value);
if ($result[$counter]['involved'] == "") {
$result[$counter]['involved'] = $involved_user->get_full_name(false);
} else {
$result[$counter]['involved'] .= ", " . $involved_user->get_full_name(false);
}
}
} else {
$result[$counter]['involved'] = "";
}
$subproject_paramquery = $_GET;
$subproject_paramquery['run'] = "new_subproject";
$subproject_paramquery['id'] = $value['id'];
unset($subproject_paramquery['nextpage']);
$subproject_params = http_build_query($subproject_paramquery, '', '&');
$result[$counter]['add_subproject'] = $subproject_params;
$result[$counter]['padding'] = $value['layer'];
$counter++;
}
$template->set_var("structure", $result);
}
$template->output();
} else {
throw new ProjectSecurityAccessDeniedException();
}
} else {
throw new ProjectIDMissingException();
}
}
/**
* @todo remove code; merge with IO permission function (GET <-> POST)
* @return string
* @throws FolderIDMissingException
*/
public static function permission_window()
{
global $user;
if ($_POST['file_id'] or $_POST['value_id'] or $_POST['parameter_id'] or $_POST['folder_id']) {
if ($_POST['file_id']) {
$id = $_POST['file_id'];
$object = File::get_instance($id);
$type = "file";
$title = $object->get_name();
}
if ($_POST['value_id']) {
$id = $_POST['value_id'];
$object = Value::get_instance($id);
$type = "value";
$title = $object->get_type_name();
}
if ($_POST['parameter_id']) {
$id = $_POST['parameter_id'];
$object = Parameter::get_instance($id);
$type = "parameter";
$title = $object->get_name();
}
if ($_POST['folder_id']) {
$id = $_POST['folder_id'];
$object = Folder::get_instance($id);
$type = "folder";
$title = $object->get_name();
}
} else {
throw new FolderIDMissingException();
}
$data_permission = new DataPermission($type, $id);
$template = new HTMLTemplate("data/data_permission_window.html");
$template->set_var("title", $title);
$user = new User($data_permission->get_owner_id());
$group = new Group($data_permission->get_owner_group_id());
$template->set_var("owner", $user->get_full_name(false));
$template->set_var("owner_group", $group->get_name());
if ($object->can_set_automatic()) {
$disable_automatic = false;
} else {
$disable_automatic = true;
}
if ($object->can_set_data_entity()) {
$disable_project = false;
} else {
$disable_project = true;
}
if ($object->can_set_control()) {
$disable_control = false;
} else {
$disable_control = true;
}
if ($object->can_set_remain()) {
$disable_remain = false;
} else {
$disable_remain = true;
}
if ($disable_automatic == true) {
$template->set_var("disabled_automatic", "disabled='disabled'");
} else {
$template->set_var("disabled_automatic", "");
}
if ($data_permission->get_automatic() == true) {
$template->set_var("checked_automatic", "checked='checked'");
if ($disable_automatic == true) {
$template->set_var("hidden_automatic", "<input type='hidden' name='automatic' value='1' />");
} else {
$template->set_var("hidden_automatic", "");
}
} else {
$template->set_var("checked_automatic", "");
$template->set_var("hidden_automatic", "");
}
$permission_array = $data_permission->get_permission_array();
for ($i = 1; $i <= 4; $i++) {
for ($j = 1; $j <= 4; $j++) {
$checked_name = "checked_" . $i . "_" . $j;
$disabled_name = "disabled_" . $i . "_" . $j;
$hidden_name = "hidden_" . $i . "_" . $j;
if ($i == 3 and $disable_project == true) {
$template->set_var($disabled_name, "disabled='disabled'");
$disabled = true;
} else {
if (($j == 3 or $j == 4) and $disable_control == true) {
$template->set_var($disabled_name, "disabled='disabled'");
$disabled = true;
} else {
if ($disable_remain == true) {
$template->set_var($disabled_name, "disabled='disabled'");
$disabled = true;
} else {
$template->set_var($disabled_name, "");
$disabled = false;
}
}
}
if ($permission_array[$i][$j] == true) {
$template->set_var($checked_name, "checked='checked'");
if ($disabled == true) {
$template->set_var($hidden_name, "<input type='hidden' name='" . $checked_name . "' value='1' />");
} else {
$template->set_var($hidden_name, "");
}
} else {
$template->set_var($checked_name, "");
$template->set_var($hidden_name, "");
}
$disabled = false;
}
}
$paramquery = $_GET;
$paramquery['nav'] = "data";
unset($paramquery['action']);
$params = http_build_query($paramquery, '', '&');
return $template->get_string();
}
/**
* @throws EquipmentTypeIDMissingException
*/
public static function add_user()
{
if ($_GET['id']) {
if ($_GET['nextpage'] == 1) {
if (is_numeric($_POST['user'])) {
$equipment_type = new EquipmentType($_GET['id']);
if ($equipment_type->is_user_responsible($_POST['user']) == true) {
$page_1_passed = false;
$error = "The user is already responsible for this equipment.";
} else {
$page_1_passed = true;
}
} else {
$page_1_passed = false;
$error = "You must select an user.";
}
} elseif ($_GET['nextpage'] > 1) {
$page_1_passed = true;
} else {
$page_1_passed = false;
$error = "";
}
if ($page_1_passed == false) {
$template = new HTMLTemplate("equipment/admin/equipment_type/add_user.html");
$paramquery = $_GET;
$paramquery['nextpage'] = "1";
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
$template->set_var("error", $error);
$user_array = User::list_entries();
$result = array();
$counter = 0;
foreach ($user_array as $key => $value) {
$user = new User($value);
$result[$counter]['value'] = $value;
$result[$counter]['content'] = $user->get_username() . " (" . $user->get_full_name(false) . ")";
$counter++;
}
$template->set_var("option", $result);
$template->output();
} else {
$equipment_type = new EquipmentType($_GET['id']);
$paramquery = $_GET;
$paramquery['action'] = "detail";
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
if ($equipment_type->add_responsible_person($_POST['user'])) {
Common_IO::step_proceed($params, "Equipment Type", "Operation Successful", null);
} else {
Common_IO::step_proceed($params, "Equipment Type", "Operation Failed", null);
}
}
} else {
throw new EquipmentTypeIDMissingException();
}
}
/**
* @throws GroupIDMissingException
*/
public static function add_user()
{
if ($_GET['id']) {
if ($_GET['nextpage'] == 1) {
if (is_numeric($_POST['user'])) {
$group = new Group($_GET['id']);
if ($group->is_user_in_group($_POST['user']) == true) {
$page_1_passed = false;
$error = "This user is already member of the group.";
} else {
$page_1_passed = true;
}
} else {
$page_1_passed = false;
$error = "You must select an user.";
}
} elseif ($_GET['nextpage'] > 1) {
$page_1_passed = true;
} else {
$page_1_passed = false;
$error = "";
}
if ($page_1_passed == false) {
$template = new HTMLTemplate("base/user/admin/group/add_user.html");
$paramquery = $_GET;
$paramquery['nextpage'] = "1";
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
$template->set_var("error", $error);
$user_array = User::list_entries();
$result = array();
$counter = 0;
foreach ($user_array as $key => $value) {
$user = new User($value);
$result[$counter]['value'] = $value;
$result[$counter]['content'] = $user->get_username() . " (" . $user->get_full_name(false) . ")";
$counter++;
}
$template->set_var("option", $result);
$template->output();
} else {
$group = new Group($_GET['id']);
$paramquery = $_GET;
$paramquery['action'] = "detail";
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
if ($group->create_user_in_group($_POST['user'])) {
Common_IO::step_proceed($params, "Add User", "Operation Successful", null);
} else {
Common_IO::step_proceed($params, "Add User", "Operation Failed", null);
}
}
} else {
throw new GroupIDMissingException();
}
}
/**
* @param string $get_array
* @param intger $page
* @return integer
* @throws ProjectSecurityAccessDeniedException
* @throws ProjectIDMissingException
*/
public static function get_list($get_array, $page)
{
global $project_security, $user;
if ($get_array) {
$_GET = unserialize($get_array);
}
if ($_GET['project_id']) {
if ($project_security->is_access(1, false) == true) {
$project_log_array = ProjectLog::list_entries_by_project_id($_GET['project_id']);
if (!$page) {
$page = 1;
}
$entry_count = count($project_log_array);
$number_of_pages = ceil($entry_count / constant("PROJECT_LOG_ENTRIES_PER_PAGE"));
$template = new HTMLTemplate("project/ajax/log.html");
$template->set_var("get_array", $get_array);
$template->set_var("page", $page);
$template->set_var("number_of_pages", $number_of_pages);
if (is_array($project_log_array) and count($project_log_array) >= 1) {
$template->set_var("no_log", false);
$result = array();
$counter = 0;
if (count($project_log_array) < $page * PROJECT_LOG_ENTRIES_PER_PAGE) {
$max_for = count($project_log_array) % PROJECT_LOG_ENTRIES_PER_PAGE - 1;
} else {
$max_for = PROJECT_LOG_ENTRIES_PER_PAGE - 1;
}
for ($i = 0; $i <= $max_for; $i++) {
$entry = $page * PROJECT_LOG_ENTRIES_PER_PAGE + $i - PROJECT_LOG_ENTRIES_PER_PAGE;
// Erzeugt Entry-ID
$value = $project_log_array[$entry];
$project_log = new ProjectLog($value);
$user = new User($project_log->get_owner_id());
$result[$counter]['id'] = $value;
$result[$counter]['show_more'] = false;
$datetime_handler = new DatetimeHandler($project_log->get_datetime());
$result[$counter]['date'] = $datetime_handler->get_date();
$result[$counter]['time'] = $datetime_handler->get_time();
$result[$counter]['user'] = $user->get_full_name(false);
if (($content = $project_log->get_content()) != null) {
$content = str_replace("\n", "<br />", $content);
if (strlen($content) > 500) {
$content = substr($content, 0, 500) . "...";
$result[$counter]['show_more'] = true;
}
$result[$counter]['content'] = $content;
} else {
$result[$counter]['content'] = false;
}
$status_id = $project_log->get_status_id();
if ($status_id != null) {
$project_status = new ProjectStatus($status_id);
$result[$counter]['status'] = $project_status->get_name();
} else {
$result[$counter]['status'] = false;
}
if ($project_log->get_important() == true) {
$result[$counter]['important'] = true;
} else {
$result[$counter]['important'] = false;
}
$item_array = $project_log->list_items();
$number_of_items = count($item_array);
if ($number_of_items == 0) {
$result[$counter]['items'] = false;
} else {
if ($number_of_items == 1) {
$result[$counter]['items'] = $number_of_items . " Item was added";
} else {
$result[$counter]['items'] = $number_of_items . " Items were added";
}
}
$detail_paramquery = $_GET;
$detail_paramquery['run'] = "log_detail";
$detail_paramquery['id'] = $value;
$detail_params = http_build_query($detail_paramquery, '', '&');
$result[$counter]['detail_params'] = $detail_params;
if ($user->is_admin()) {
$result[$counter]['delete'] = true;
} else {
$result[$counter]['delete'] = false;
}
$counter++;
}
$template->set_var("log_array", $result);
} else {
$template->set_var("no_log", true);
}
if ($number_of_pages > 1) {
$pagebar = "<div id='ProjectLogActionSelect'></div><div class='ResultNextPageBar' id='ProjectLogPageBar'></div>";
$template->set_var("page_bar", $pagebar);
} else {
$template->set_var("page_bar", "");
}
$template->output();
} else {
throw new ProjectSecurityAccessDeniedException();
}
} else {
throw new ProjectIDMissingException();
}
}
/**
* @todo rebuild with List and JS operations
* @todo move to admin
* @throws UserIDMissingException
*/
public static function list_user_admin_organisation_units($user_id)
{
if (is_numeric($user_id)) {
$template = new HTMLTemplate("organisation_unit/admin/dialog/list_user_admin.html");
$current_user = new User($user_id);
$template->set_var("username", $current_user->get_username());
$template->set_var("fullname", $current_user->get_full_name(false));
$paramquery = $_GET;
$paramquery['action'] = "add_organisation_unit";
$params = http_build_query($paramquery, '', '&');
$template->set_var("add_ou_params", $params);
$organisation_unit_array = OrganisationUnit::list_entries_by_user_id($user_id);
$organisation_unit_content_array = array();
$counter = 0;
if (is_array($organisation_unit_array) and count($organisation_unit_array) >= 1) {
foreach ($organisation_unit_array as $key => $value) {
$organisation_unit = new OrganisationUnit($value);
$paramquery = $_GET;
$paramquery['action'] = "delete_organisation_unit";
$paramquery['key'] = $value;
$params = http_build_query($paramquery, '', '&');
$organisation_unit_content_array[$counter]['name'] = $organisation_unit->get_name();
$organisation_unit_content_array[$counter]['delete_params'] = $params;
$counter++;
}
$template->set_var("no_ou", false);
} else {
$template->set_var("no_ou", true);
}
$template->set_var("ou", $organisation_unit_content_array);
$template->output();
} else {
throw new UserIDMissingException();
}
}
foreach ($batchusers as $batchuser) {
$user = User::get_by_id($batchuser->userid);
if (!$user) {
$user = new User();
}
$school = School::get_by_id($batchuser->schoolid);
if (!$school) {
$school = new School();
}
$batch = Batch::get_by_id($batchuser->batchid);
if (!$batch) {
$batch = new Batch();
}
$s .= "<row id='" . $batchuser->id . "'>";
$s .= "<cell></cell>";
$s .= "<cell>" . $batchuser->id . "</cell>";
$s .= "<cell>" . $school->id . "</cell>";
$s .= "<cell>" . $school->name . "</cell>";
$s .= "<cell>" . $batch->id . "</cell>";
$s .= "<cell>" . $batch->get_batchyear() . "</cell>";
$s .= "<cell>" . $user->id . "</cell>";
$s .= "<cell>" . $user->get_full_name() . "</cell>";
$s .= "<cell>" . $batchuser->level . "</cell>";
$s .= "<cell>" . $batchuser->date . "</cell>";
$s .= "<cell>" . $batchuser->pending . "</cell>";
$s .= "<cell>" . $batchuser->enabled . "</cell>";
$s .= "<cell></cell>";
$s .= "</row>";
}
$s .= "</rows>";
echo $s;
/**
* @throws ProjectIDMissingException
* @throws ProjectSecurityAccessDeniedException
*/
public static function chown()
{
global $project_security;
if ($_GET['project_id']) {
if ($project_security->is_access(7, false) == true) {
$project_id = $_GET['project_id'];
$project = new Project($project_id);
if ($_GET['nextpage'] == 1) {
if (is_numeric($_POST['user'])) {
$page_1_passed = true;
} else {
$page_1_passed = false;
$error = "You must select an user";
}
} else {
$page_1_passed = false;
$error = "";
}
if ($page_1_passed == false) {
$template = new HTMLTemplate("project/admin/chown.html");
$paramquery = $_GET;
$paramquery['nextpage'] = "1";
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
$template->set_var("error", $error);
$user_array = User::list_entries();
$result = array();
$counter = 0;
foreach ($user_array as $key => $value) {
$user = new User($value);
$result[$counter]['value'] = $value;
$result[$counter]['content'] = $user->get_username() . " (" . $user->get_full_name(false) . ")";
$counter++;
}
$template->set_var("option", $result);
$template->output();
} else {
$paramquery = $_GET;
unset($paramquery['nextpage']);
$paramquery['run'] = "admin";
$params = http_build_query($paramquery);
if ($project->set_owner_id($_POST['user'])) {
Common_IO::step_proceed($params, "Change Project Owner", "Operation Successful", null);
} else {
Common_IO::step_proceed($params, "Change Project Owner", "Operation Failed", null);
}
}
} else {
throw new ProjectSecurityAccessDeniedException();
}
} else {
throw new ProjectIDMissingException();
}
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $get_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws OrganisationUnitIDMissingException
*/
public static function list_quality_managers($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
if ($get_array) {
$_GET = unserialize($get_array);
}
$argument_array = json_decode($json_argument_array);
$organisation_unit_id = $argument_array[1];
if (is_numeric($organisation_unit_id)) {
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = OrganisationUnit_Wrapper::list_organisation_unit_quality_managers($organisation_unit_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
$module_link_array = ModuleLink::list_links_by_type("ou_navigation");
foreach ($list_array as $key => $value) {
$user = new User($value['id']);
$list_array[$key]['symbol'] = "<img src='images/icons/user.png' alt='' />";
$list_array[$key]['username'] = $user->get_username();
$list_array[$key]['fullname'] = $user->get_full_name(false);
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new OrganisationUnitIDMissingException();
}
}
<!-- Profile Info and Notifications --> <div class="col-md-6 col-sm-8 clearfix"> <ul class="user-info pull-left pull-none-xsm"> <!-- Profile Info --> <li class="profile-info dropdown"><!-- add class "pull-right" if you want to place this from right --> <a href="#" class="dropdown-toggle" data-toggle="dropdown"> <img src="assets/images/profile_pic/<?php echo $user->profile_pic; ?> " width="44" height="44" class="img-circle" /> <?php echo $user->get_full_name(); ?> </a> <ul class="dropdown-menu"> <!-- Reverse Caret --> <li class="caret"></li> <!-- Profile sub-links --> <li> <a href="edit-profile"> <i class="entypo-user"></i> Edit Profile </a> </li>
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws ItemIDMissingException
*/
public static function list_projects_by_item_id($json_column_array, $json_argument_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
global $user;
$argument_array = json_decode($json_argument_array);
$item_id = $argument_array[0][1];
if (is_numeric($item_id)) {
$list_request = new ListRequest_IO();
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
if ($argument_array[2][1] == true) {
$list_array = Project_Wrapper::list_projects_by_item_id($item_id, $user->is_admin(), $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
} else {
$list_array = Project_Wrapper::list_projects_by_item_id($item_id, $user->is_admin(), $sortvalue, $sortmethod, 0, null);
}
$list_request->set_column_array($json_column_array);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$tmp_name = trim($list_array[$key]['name']);
unset($list_array[$key]['name']);
$list_array[$key]['name']['label'] = $tmp_name;
$list_array[$key]['name']['content'] = $tmp_name;
$tmp_template = trim($list_array[$key]['template']);
unset($list_array[$key]['template']);
$list_array[$key]['template']['label'] = $tmp_template;
$list_array[$key]['template']['content'] = $tmp_template;
$tmp_status = trim($list_array[$key]['status']);
unset($list_array[$key]['status']);
$list_array[$key]['status']['label'] = $tmp_status;
$list_array[$key]['status']['content'] = $tmp_status;
if ($list_array[$key]['deleted'] == "t") {
$list_array[$key]['name']['content'] = "<span class='crossed'>" . $list_array[$key]['name']['content'] . "</span>";
$list_array[$key]['template']['content'] = "<span class='crossed'>" . $list_array[$key]['template']['content'] . "</span>";
$list_array[$key]['status']['content'] = "<span class='crossed'>" . $list_array[$key]['status']['content'] . "</span>";
}
if ($argument_array[1][1] == true) {
$column_array = json_decode($json_column_array);
if (is_array($column_array) and count($column_array) >= 1) {
foreach ($column_array as $row_key => $row_value) {
if ($row_value[1] == "checkbox") {
if ($row_value[4]) {
$checkbox_class = $row_value[4];
break;
}
}
}
}
if ($checkbox_class) {
$list_array[$key]['checkbox'] = "<input type='checkbox' name='parent-project-" . $list_array[$key]['id'] . "' value='1' class='" . $checkbox_class . "' />";
} else {
$list_array[$key]['checkbox'] = "<input type='checkbox' name='parent-project-" . $list_array[$key]['id'] . "' value='1' />";
}
$list_array[$key]['symbol'] = "<img src='images/icons/project.png' alt='' style='border:0;' />";
} else {
$project_id = $list_array[$key]['id'];
$project_security = new ProjectSecurity($project_id);
if ($project_security->is_access(1, false)) {
$paramquery = array();
$paramquery['username'] = $_GET['username'];
$paramquery['session_id'] = $_GET['session_id'];
$paramquery['nav'] = "project";
$paramquery['run'] = "detail";
$paramquery['project_id'] = $project_id;
$params = http_build_query($paramquery, '', '&');
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='images/icons/project.png' alt='' style='border:0;' />";
$list_array[$key]['name']['link'] = $params;
} else {
$list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=images/icons/project.png' alt='N' border='0' />";
}
}
$datetime_handler = new DatetimeHandler($list_array[$key]['datetime']);
$list_array[$key]['datetime'] = $datetime_handler->get_datetime(false);
if ($list_array[$key]['owner']) {
$user = new User($list_array[$key]['owner']);
} else {
$user = new User(1);
}
$list_array[$key]['owner'] = $user->get_full_name(true);
}
} else {
$list_request->empty_message("<span class='italic'>No Projects found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new ItemIDMissingException();
}
}
/**
* @throws FileIDMissingException
* @throws DataSecurityAccessDeniedException
*/
public static function detail()
{
global $regional;
if ($_GET['file_id']) {
$file = File::get_instance($_GET['file_id']);
if ($file->is_read_access()) {
$template = new HTMLTemplate("data/file_detail.html");
$folder = Folder::get_instance($file->get_parent_folder_id());
if ($_GET['version'] and is_numeric($_GET['version'])) {
$file->open_internal_revision($_GET['version']);
$internal_revision = $_GET['version'];
} else {
$internal_revision = $file->get_internal_revision();
}
$template = new HTMLTemplate("data/file_detail.html");
$folder = Folder::get_instance($file->get_parent_folder_id());
$user = new User($file->get_owner_id());
$file_version_array = $file->get_file_internal_revisions();
if (is_array($file_version_array) and count($file_version_array) > 0) {
$result = array();
$counter = 1;
$result[0]['version'] = 0;
$result[0]['text'] = "----------------------------------------------";
$file_version = File::get_instance($_GET['file_id'], true);
foreach ($file_version_array as $key => $value) {
$file_version->open_internal_revision($value);
$version_datetime_handler = new DatetimeHandler($file_version->get_datetime());
$result[$counter]['version'] = $file_version->get_internal_revision();
$result[$counter]['text'] = "Version " . $file_version->get_version() . " - " . $version_datetime_handler->get_datetime();
$counter++;
}
$template->set_var("version_option", $result);
}
$result = array();
$counter = 0;
foreach ($_GET as $key => $value) {
if ($key != "version") {
$result[$counter]['value'] = $value;
$result[$counter]['key'] = $key;
$counter++;
}
}
$template->set_var("get", $result);
$template->set_var("version", $file->get_version());
$paramquery = $_GET;
$paramquery['action'] = "file_history";
$params = http_build_query($paramquery, '', '&');
$template->set_var("version_list_link", $params);
$template->set_var("title", $file->get_name());
$template->set_var("name", $file->get_name());
$template->set_var("path", $folder->get_object_path());
$template->set_var("size", Convert::convert_byte_1024($file->get_size()));
$template->set_var("size_in_byte", $regional->format_number($file->get_size()));
$create_datetime_handler = new DatetimeHandler($file->get_datetime());
$version_datetime_handler = new DatetimeHandler($file->get_version_datetime());
$template->set_var("creation_datetime", $create_datetime_handler->get_datetime());
$template->set_var("version_datetime", $version_datetime_handler->get_datetime());
$template->set_var("mime_type", $file->get_mime_type());
$template->set_var("owner", $user->get_full_name(false));
$template->set_var("checksum", $file->get_checksum());
$template->set_var("permission", $file->get_permission_string());
$template->set_var("comment", "");
if ($file->is_image() == true) {
$template->set_var("thumbnail_image", "<img src='image.php?session_id=" . $_GET['session_id'] . "&file_id=" . $_GET['file_id'] . "&max_width=340&max_height=350' alt='' />");
} else {
$template->set_var("thumbnail_image", "");
}
$paramquery = array();
$paramquery['username'] = $_GET['username'];
$paramquery['session_id'] = $_GET['session_id'];
$paramquery['file_id'] = $_GET['file_id'];
if ($_GET['version']) {
$paramquery['version'] = $_GET['version'];
}
$params = http_build_query($paramquery, '', '&');
$template->set_var("download_params", $params);
$paramquery = $_GET;
$paramquery['action'] = "file_update";
$paramquery['version'] = $internal_revision;
$paramquery['retrace'] = Retrace::create_retrace_string();
$params = http_build_query($paramquery, '', '&');
$template->set_var("update_params", $params);
$paramquery = $_GET;
$paramquery['action'] = "file_update_minor";
$paramquery['version'] = $file->get_internal_revision();
$paramquery['retrace'] = Retrace::create_retrace_string();
$params = http_build_query($paramquery, '', '&');
$template->set_var("update_minor_params", $params);
$paramquery = $_GET;
$paramquery['action'] = "permission";
$params = http_build_query($paramquery, '', '&');
$template->set_var("set_permission_params", $params);
$template->set_var("write_access", $file->is_write_access());
if ($file->is_control_access() == true or $file->get_owner_id() == $user->get_user_id()) {
$template->set_var("change_permission", true);
} else {
$template->set_var("change_permission", false);
}
$template->set_var("delete_access", $file->is_delete_access());
$paramquery = $_GET;
$paramquery['action'] = "file_delete";
unset($paramquery['sure']);
$params = http_build_query($paramquery, '', '&');
$template->set_var("delete_file_params", $params);
$paramquery = $_GET;
$paramquery['action'] = "file_delete_version";
$paramquery['version'] = $internal_revision;
unset($paramquery['sure']);
$params = http_build_query($paramquery, '', '&');
$template->set_var("delete_file_version_params", $params);
$paramquery = $_GET;
unset($paramquery['file_id']);
unset($paramquery['version']);
unset($paramquery['action']);
$params = http_build_query($paramquery, '', '&');
$template->set_var("back_link", $params);
$template->output();
} else {
throw new DataSecurityAccessDeniedException();
}
} else {
throw new FileIDMissingException();
}
}
/**
* @param string $json_column_array
* @param string $json_argument_array
* @param string $css_page_id
* @param string $css_row_sort_id
* @param string $entries_per_page
* @param string $page
* @param string $sortvalue
* @param string $sortmethod
* @return string
* @throws BaseAjaxArgumentMissingException
*/
public static function list_data($json_column_array, $json_argument_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod)
{
$argument_array = json_decode($json_argument_array);
if (is_array($argument_array)) {
$folder_id = $argument_array[0][1];
$name = $argument_array[1][1];
$list_request = new ListRequest_IO();
$list_request->set_column_array($json_column_array);
if (!is_numeric($entries_per_page) or $entries_per_page < 1) {
$entries_per_page = 20;
}
$list_array = Data_Wrapper::list_search_ffv($folder_id, $name, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page);
if (is_array($list_array) and count($list_array) >= 1) {
foreach ($list_array as $key => $value) {
$datetime_handler = new DatetimeHandler($list_array[$key]['datetime']);
$list_array[$key]['datetime'] = $datetime_handler->get_datetime(false);
$owner = new User($value['owner']);
$list_array[$key]['owner'] = $owner->get_full_name(true);
if (is_numeric($value['file_id'])) {
$file = File::get_instance($value['file_id']);
$paramquery = $_GET;
$paramquery['nav'] = "data";
$paramquery['action'] = "file_detail";
$paramquery['file_id'] = $value['file_id'];
unset($paramquery['sortvalue']);
unset($paramquery['sortmethod']);
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
$tmp_name = $value['name'];
unset($list_array[$key]['name']);
$list_array[$key]['name']['content'] = $tmp_name;
if ($file->is_read_access() == true) {
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='" . File::get_icon_by_name($value['name']) . "' alt='' style='border:0;' />";
$list_array[$key]['name']['link'] = $params;
} else {
$list_array[$key]['symbol']['link'] = "";
$list_array[$key]['symbol']['content'] = "<img src='core/images/denied_overlay.php?image=" . File::get_icon_by_name($value['name']) . "' alt='' border='0' />";
$list_array[$key]['name']['link'] = "";
}
$list_array[$key]['type'] = "File";
$list_array[$key]['version'] = $file->get_version();
$list_array[$key]['size'] = Convert::convert_byte_1024($file->get_size());
$list_array[$key]['permission'] = $file->get_permission_string();
}
if (is_numeric($value['value_id'])) {
$value_obj = Value::get_instance($value['value_id']);
$paramquery = $_GET;
$paramquery['nav'] = "data";
$paramquery['action'] = "value_detail";
$paramquery['value_id'] = $value['value_id'];
unset($paramquery['sortvalue']);
unset($paramquery['sortmethod']);
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
$tmp_name = $value['name'];
unset($list_array[$key]['name']);
$list_array[$key]['name']['content'] = $tmp_name;
if ($value_obj->is_read_access() == true) {
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='images/fileicons/16/unknown.png' alt='' style='border: 0;'>";
$list_array[$key]['name']['link'] = $params;
} else {
$list_array[$key]['symbol']['link'] = "";
$list_array[$key]['symbol']['content'] = "<img src='core/images/denied_overlay.php?image=images/fileicons/16/unknown.png' alt='' border='0' />";
$list_array[$key]['name']['link'] = "";
}
$list_array[$key]['type'] = "Value";
$list_array[$key]['version'] = $value_obj->get_version();
$list_array[$key]['permission'] = $value_obj->get_permission_string();
}
if (is_numeric($value['folder_id'])) {
$folder = Folder::get_instance($value['folder_id']);
$paramquery = $_GET;
$paramquery['nav'] = "data";
$paramquery['folder_id'] = $value['folder_id'];
unset($paramquery['run']);
unset($paramquery['sortvalue']);
unset($paramquery['sortmethod']);
unset($paramquery['nextpage']);
$params = http_build_query($paramquery, '', '&');
$tmp_name = $value['name'];
unset($list_array[$key]['name']);
$list_array[$key]['name']['content'] = $tmp_name;
if ($folder->is_read_access() == true) {
$list_array[$key]['symbol']['link'] = $params;
$list_array[$key]['symbol']['content'] = "<img src='images/icons/folder.png' alt='' style='border: 0;'>";
$list_array[$key]['name']['link'] = $params;
} else {
$list_array[$key]['symbol']['link'] = "";
$list_array[$key]['symbol']['content'] = "<img src='core/images/denied_overlay.php?image=images/icons/folder.png' alt='' border='0' />";
$list_array[$key]['name']['link'] = "";
}
$list_array[$key]['type'] = "Folder";
$list_array[$key]['permission'] = $folder->get_permission_string();
}
}
} else {
$list_request->empty_message("<span class='italic'>No results found!</span>");
}
$list_request->set_array($list_array);
return $list_request->get_page($page);
} else {
throw new BaseAjaxArgumentMissingException();
}
}
