/** * @param string $sql * @param integer $item_id * @param object $pdf * @return object */ public static function get_equipment_item_report($sql, $item_id, $pdf) { if ($sql and is_object($pdf)) { $result_array = Equipment_Wrapper::list_item_equipments($sql, null, null, null, null); if (is_array($result_array) and count($result_array) >= 1) { $pdf->addPage(); $pdf->SetFont('dejavusans', 'B', 14, '', true); $pdf->Write(0, 'Equipment', '', 0, 'C', true, 0, false, false, 0); $pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0); $pdf->MultiCell(70, 0, "Equipment Name", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, "Category", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, "Date/Time", 1, 'L', 1, 1, '', '', true, 0, false, true, 0); $pdf->SetFont('dejavusans', '', 14, '', true); foreach ($result_array as $key => $value) { $datetime_handler = new DatetimeHandler($result_array[$key]['datetime']); $result_array[$key]['datetime'] = $datetime_handler->get_datetime(false); $pdf->MultiCell(70, 0, $result_array[$key]['name'], 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, $result_array[$key]['category'], 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, $result_array[$key]['datetime'], 1, 'L', 1, 1, '', '', true, 0, false, true, 0); } } return $pdf; } else { return null; } }
/** * @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 BaseAjaxArgumentMissingException */ public static function list_system_log($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); if (is_array($argument_array)) { $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 = SystemFE_Wrapper::list_system_log($type_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) { $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); $paramquery = $_GET; $paramquery['id'] = $list_array[$key]['id']; $paramquery['action'] = "detail"; unset($paramquery['sortvalue']); unset($paramquery['sortmethod']); unset($paramquery['nextpage']); $params = http_build_query($paramquery, '', '&'); $tmp_datetime = $list_array[$key]['datetime']; unset($list_array[$key]['datetime']); $list_array[$key]['datetime']['link'] = $params; $list_array[$key]['datetime']['content'] = $tmp_datetime; $paramquery = $_GET; $paramquery['id'] = $list_array[$key]['ip']; $paramquery['action'] = "ip_info"; unset($paramquery['sortvalue']); unset($paramquery['sortmethod']); unset($paramquery['nextpage']); $params = http_build_query($paramquery, '', '&'); $tmp_ip = $list_array[$key]['ip']; unset($list_array[$key]['ip']); $list_array[$key]['ip']['link'] = $params; $list_array[$key]['ip']['content'] = $tmp_ip; } } 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(); } } else { throw new BaseUserAccessDeniedException(); } }
/** * @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_items($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)) { $string = $argument_array[0][1]; $item_type_array = $argument_array[1][1]; $language_id = $argument_array[2][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 = Item_Wrapper::list_fulltext_search($string, $item_type_array, $language_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page); if (is_array($list_array) and count($list_array) >= 1) { $item_type_array = Item::list_types(); foreach ($list_array as $key => $value) { $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); $sample_paramquery = array(); $sample_paramquery['username'] = $_GET['username']; $sample_paramquery['session_id'] = $_GET['session_id']; $sample_paramquery['nav'] = "sample"; $sample_paramquery['run'] = "detail"; $sample_paramquery['sample_id'] = $value['sample_id']; $sample_params = http_build_query($sample_paramquery, '', '&'); $tmp_sample_name = $list_array[$key]['sample_name']; unset($list_array[$key]['sample_name']); $list_array[$key]['sample_name']['content'] = $tmp_sample_name; $list_array[$key]['sample_name']['link'] = $sample_params; if (is_array($item_type_array) and count($item_type_array) >= 1) { foreach ($item_type_array as $item_key => $item_value) { if ($value[$item_key . "_id"] != null) { $list_array[$key]['type'] = $item_value::get_generic_name($item_key, null); $tmp_item_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_item_name; $list_array[$key]['name']['link'] = $item_value::get_generic_link($item_key, $value[$item_key . "_id"]); $list_array[$key]['symbol']['content'] = $item_value::get_generic_symbol($item_key, $value[$item_key . "_id"]); $list_array[$key]['symbol']['link'] = $item_value::get_generic_link($item_key, $value[$item_key . "_id"]); } } } } } 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(); } }
/** * @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 $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_projects($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)) { $name = $argument_array[0][1]; $template_array = $argument_array[1][1]; $organisation_unit_array = $argument_array[2][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 = Project_Wrapper::list_search_projects_without_subprojects($name, $template_array, $organisation_unit_array, $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/project.png' alt='N' border='0' />"; $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); $proejct_paramquery = array(); $project_paramquery['username'] = $_GET['username']; $project_paramquery['session_id'] = $_GET['session_id']; $project_paramquery['nav'] = "project"; $project_paramquery['run'] = "detail"; $project_paramquery['project_id'] = $value['id']; $project_params = http_build_query($project_paramquery, '', '&'); $tmp_project_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_project_name; $list_array[$key]['name']['link'] = $project_params; } } 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(); } }
/** * @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 FolderIDMissingException */ public static function list_data_browser($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); } if ($json_argument_array) { $argument_array = json_decode($json_argument_array); } $folder_id = $argument_array[0][1]; $virtual_folder_id = $argument_array[1][1]; if (!$folder_id and !$virtual_folder_id) { $data_path = new DataPath(null, null); $folder_id = $data_path->get_folder_id(); } if (is_numeric($folder_id) or is_numeric($virtual_folder_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 = DataBrowser::get_data_browser_array($folder_id, $virtual_folder_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page); if ($folder_id) { $data_path = new DataPath($folder_id, null); } elseif ($virtual_folder_id) { $data_path = new DataPath(null, $virtual_folder_id); } else { $data_path = new DataPath(null, null); } if ($folder_id != 1 or $virtual_folder_id != null) { if ($data_path->get_previous_entry_virtual() == true) { $paramquery = $_GET; $paramquery['vfolder_id'] = $data_path->get_previous_entry_id(); unset($paramquery['folder_id']); unset($paramquery['nextpage']); unset($paramquery['page']); $params = http_build_query($paramquery, '', '&'); } else { $paramquery = $_GET; $paramquery['folder_id'] = $data_path->get_previous_entry_id(); unset($paramquery['nextpage']); unset($paramquery['vfolder_id']); unset($paramquery['page']); $params = http_build_query($paramquery, '', '&'); } $first_line_array['symbol']['link'] = $params; $first_line_array['symbol']['content'] = "<img src='images/icons/parent_folder.png' alt='' style='border:0;' />"; $first_line_array['name']['link'] = $params; $first_line_array['name']['content'] = Language::get_message("DataGeneralTitleParentFolder", "general"); $first_line_array['type'] = Language::get_message("DataGeneralDataTypeParentFolder", "general"); $first_line_array['version'] = ""; $first_line_array['datetime'] = ""; $first_line_array['size'] = ""; $first_line_array['owner'] = ""; $first_line_array['permission'] = ""; $list_request->add_first_line($first_line_array, "DataBrowserParentFolderRow"); } if (is_array($list_array) and count($list_array) >= 1) { foreach ($list_array as $key => $value) { // Common $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); if ($list_array[$key]['owner_id']) { $user = new User($list_array[$key]['owner_id']); } else { $user = new User(1); } $list_array[$key]['owner'] = $user->get_full_name(true); // Special if ($list_array[$key]['file_id']) { $file = File::get_instance($list_array[$key]['file_id']); if ($file->is_read_access() == true) { $paramquery = $_GET; $paramquery['nav'] = $_GET['nav']; $paramquery['file_id'] = $list_array[$key]['file_id']; $paramquery['action'] = "file_detail"; $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['link'] = $params; $list_array[$key]['symbol']['content'] = "<img src='" . $file->get_icon() . "' alt='' style='border:0;' />"; $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['class'] = "DataBrowserIsFile"; } else { $list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=" . $file->get_icon() . "' alt='' border='0' />"; } $list_array[$key]['type'] = Language::get_message("DataGeneralDataTypeFile", "general"); $list_array[$key]['version'] = $file->get_version(); $list_array[$key]['size'] = Convert::convert_byte_1024($list_array[$key]['size']); $list_array[$key]['permission'] = $file->get_permission_string(); if ($file->is_delete_access()) { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name=''></input>"; } else { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name='' disabled='disabled'></input>"; } } elseif ($list_array[$key]['value_id']) { $value = Value::get_instance($list_array[$key]['value_id']); if ($value->is_read_access() == true) { $paramquery = $_GET; $paramquery['nav'] = $_GET['nav']; $paramquery['value_id'] = $list_array[$key]['value_id']; $paramquery['action'] = "value_detail"; $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['link'] = $params; $list_array[$key]['symbol']['content'] = "<img src='images/fileicons/16/unknown.png' alt='' style='border:0;' />"; $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['class'] = "DataBrowserIsValue"; } else { $list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=images/fileicons/16/unknown.png' alt='' border='0' />"; } $list_array[$key]['type'] = Language::get_message("DataGeneralDataTypeValue", "general"); $list_array[$key]['version'] = $value->get_version(); $list_array[$key]['permission'] = $value->get_permission_string(); if ($value->is_delete_access()) { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name=''></input>"; } else { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name='' disabled='disabled'></input>"; } } elseif ($list_array[$key]['parameter_id']) { $parameter = ParameterTemplateParameter::get_instance($list_array[$key]['parameter_id']); if ($parameter->is_read_access() == true) { $paramquery = $_GET; $paramquery['nav'] = $_GET['nav']; $paramquery['parameter_id'] = $list_array[$key]['parameter_id']; $paramquery['action'] = "parameter_detail"; $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['link'] = $params; $list_array[$key]['symbol']['content'] = "<img src='images/fileicons/16/unknown.png' alt='' style='border:0;' />"; $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['class'] = "DataBrowserIsParameter"; } else { $list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=images/fileicons/16/unknown.png' alt='' border='0' />"; } $list_array[$key]['type'] = Language::get_message("DataGeneralDataTypeParameter", "general"); $list_array[$key]['version'] = $parameter->get_version(); $list_array[$key]['permission'] = $parameter->get_permission_string(); if ($parameter->is_delete_access()) { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name=''></input>"; } else { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name='' disabled='disabled'></input>"; } } elseif ($list_array[$key]['folder_id']) { $sub_folder = Folder::get_instance($list_array[$key]['folder_id']); if ($sub_folder->is_read_access() == true) { $paramquery = $_GET; $paramquery['folder_id'] = $list_array[$key]['folder_id']; unset($paramquery['nextpage']); unset($paramquery['vfolder_id']); unset($paramquery['page']); $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['content'] = "<img src='images/icons/folder.png' alt='' style='border:0;' />"; $list_array[$key]['symbol']['link'] = $params; $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['class'] = "DataBrowserIsFolder"; } else { $list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=images/icons/folder.png' alt='' border='0' />"; } $list_array[$key]['type'] = Language::get_message("DataGeneralDataTypeFolder", "general"); $list_array[$key]['permission'] = $sub_folder->get_permission_string(); if ($sub_folder->is_delete_access()) { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name=''></input>"; } else { $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name='' disabled='disabled'></input>"; } } elseif ($list_array[$key]['virtual_folder_id']) { $paramquery = $_GET; $paramquery['vfolder_id'] = $list_array[$key]['virtual_folder_id']; unset($paramquery['nextpage']); $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['content'] = "<img src='images/icons/virtual_folder.png' alt='' style='border:0;' />"; $list_array[$key]['symbol']['link'] = $params; $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['class'] = "DataBrowserIsVirtualFolder"; $list_array[$key]['type'] = Language::get_message("DataGeneralDataTypeVirtualFolder", "general"); $list_array[$key]['permission'] = "automatic"; $list_array[$key]['delete_checkbox'] = "<input type='checkbox' class='DataBrowserDeleteCheckbox' value='' name='' disabled='disabled'></input>"; } } } 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 FolderIDMissingException(); } }
/** * @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 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 $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(); } }
/** * @param object $value * @param string $target_params * @param boolean $display_header * @throws ValueIDMissingException * @throws DataSecurityAccessDeniedException */ public static function detail($value = null, $target_params = null, $display_header = true) { global $user, $regional; if (is_object($value) and $target_params) { $retrace = "index.php?" . $target_params; } elseif (is_numeric($_GET['value_id'])) { $value_id = $_GET['value_id']; $value = Value::get_instance($value_id); $paramquery = $_GET; unset($paramquery['action']); unset($paramquery['value_id']); $params = http_build_query($paramquery); $retrace = "index.php?" . $params; if ($_GET['version'] and is_numeric($_GET['version'])) { $value->open_internal_revision($_GET['version']); } } else { throw new ValueIDMissingException(); } if ($value->is_read_access()) { if ($value->get_type_id() == 2) { $template = new HTMLTemplate("data/value_description_detail.html"); } else { $template = new HTMLTemplate("data/value_detail.html"); } $template->set_var("display_header", $display_header); $template->set_var("decimal_separator", $regional->get_decimal_separator()); $template->set_var("thousand_separator", $regional->get_thousand_separator()); $value_version_array = $value->get_value_internal_revisions(); if (is_array($value_version_array) and count($value_version_array) > 0) { $result = array(); $counter = 1; $result[0]['version'] = 0; $result[0]['text'] = "----------------------------------------------"; $value_version = Value::get_instance($_GET['value_id'], true); foreach ($value_version_array as $key => $fe_value) { $value_version->open_internal_revision($fe_value); $version_datetime_handler = new DatetimeHandler($value_version->get_version_datetime()); $result[$counter]['version'] = $value_version->get_internal_revision(); $result[$counter]['text'] = "Version " . $value_version->get_version() . " - " . $version_datetime_handler->get_datetime(); $counter++; } $template->set_var("version_option", $result); } $result = array(); $counter = 0; foreach ($_GET as $key => $fe_value) { if ($key != "version") { $result[$counter]['value'] = $fe_value; $result[$counter]['key'] = $key; $counter++; } } $template->set_var("get", $result); $template->set_var("version", $value->get_version()); $version_datetime_handler = new DatetimeHandler($value->get_version_datetime()); $template->set_var("version_datetime", $version_datetime_handler->get_datetime()); $paramquery = $_GET; $paramquery['action'] = "permission"; unset($paramquery['nextpage']); $params = http_build_query($paramquery, '', '&'); $template->set_var("change_permission_params", $params); if ($value->is_control_access() == true or $value->get_owner_id() == $user->get_user_id()) { $template->set_var("change_permission", true); } else { $template->set_var("change_permission", false); } if ($value->is_write_access() == true or $value->get_owner_id() == $user->get_user_id()) { $template->set_var("write_permission", true); } else { $template->set_var("write_permission", false); } $paramquery = $_GET; $paramquery['action'] = "value_history"; $params = http_build_query($paramquery, '', '&'); $template->set_var("version_list_link", $params); $template->set_var("title", $value->get_type_name()); $template->set_var("retrace", $retrace); if ($value->get_type_id() == 2) { $value_string = unserialize($value->get_value()); $template->set_var("description", $value_string); } else { require_once "value_form.io.php"; $value_form_io = new ValueFormIO($value->get_id()); $value_form_io->set_field_class("DataValueUpdateValues"); $template->set_var("value", $value_form_io->get_content()); } $template->set_var("session_id", $_GET['session_id']); $template->set_var("internal_revision", $value->get_internal_revision()); $template->set_var("value_id", $value->get_id()); $paramquery = $_GET; unset($paramquery['action']); unset($paramquery['value_id']); $params = http_build_query($paramquery); $template->set_var("retrace", "index.php?" . $params); $template->output(); } else { throw new DataSecurityAccessDeniedException(); } }
/** * @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(); } }
/** * @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(); } }
/** * @param string $sql * @param integer $item_id * @param object $pdf * @return object */ public static function get_sample_item_report($sql, $item_id, $pdf) { if ($sql and is_object($pdf)) { $new_page = false; $child_sample_array = Sample_Wrapper::list_item_samples($sql, null, null, null, null); if (is_array($child_sample_array) and count($child_sample_array) >= 1) { $pdf->addPage(); $new_page = true; $pdf->SetFont('dejavusans', 'B', 14, '', true); $pdf->Write(0, 'Samples', '', 0, 'C', true, 0, false, false, 0); $pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0); $pdf->MultiCell(35, 0, "ID", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, "Name", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(50, 0, "Date/Time", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(45, 0, "User", 1, 'L', 1, 1, '', '', true, 0, false, true, 0); $pdf->SetFont('dejavusans', '', 14, '', true); foreach ($child_sample_array as $key => $value) { $datetime_handler = new DatetimeHandler($value['datetime']); $value['datetime'] = $datetime_handler->get_datetime(false); $value['id'] = "S" . str_pad($value['id'], 8, '0', STR_PAD_LEFT); $owner = new User($value['owner']); $pdf->MultiCell(35, 0, $value['id'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(60, 0, $value['name'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(50, 0, $value['datetime'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(45, 0, $owner->get_full_name(true), 1, 'L', 1, 1, '', '', true, 0, true, true, 0); } } if ($item_id) { $parent_sample_array = Sample_Wrapper::list_samples_by_item_id($item_id, null, null, null, null); if (is_array($parent_sample_array) and count($parent_sample_array) >= 1) { if ($new_page == false) { $pdf->addPage(); } else { $pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0); $pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0); } $pdf->SetFont('dejavusans', 'B', 14, '', true); $pdf->Write(0, 'Parent Samples', '', 0, 'C', true, 0, false, false, 0); $pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0); $pdf->MultiCell(35, 0, "ID", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(60, 0, "Name", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(50, 0, "Date/Time", 1, 'L', 1, 0, '', '', true, 0, false, true, 0); $pdf->MultiCell(45, 0, "User", 1, 'L', 1, 1, '', '', true, 0, false, true, 0); $pdf->SetFont('dejavusans', '', 14, '', true); foreach ($parent_sample_array as $key => $value) { $datetime_handler = new DatetimeHandler($value['datetime']); $value['datetime'] = $datetime_handler->get_datetime(false); $value['id'] = "S" . str_pad($value['id'], 8, '0', STR_PAD_LEFT); $owner = new User($value['owner']); $pdf->MultiCell(35, 0, $value['id'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(60, 0, $value['name'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(50, 0, $value['datetime'], 1, 'L', 1, 0, '', '', true, 0, true, true, 0); $pdf->MultiCell(45, 0, $owner->get_full_name(true), 1, 'L', 1, 1, '', '', true, 0, true, true, 0); } } } return $pdf; } else { return null; } }
/** * @throws SystemLogIDMissingException */ public static function detail() { if ($_GET['id']) { $system_log = new SystemLog($_GET['id']); $user = new User($system_log->get_user_id()); $datetime_handler = new DatetimeHandler($system_log->get_datetime()); $template = new HTMLTemplate("base/admin/system_log/detail.html"); $template->set_var("datetime", $datetime_handler->get_datetime(false)); if ($system_log->get_user_id()) { $template->set_var("username", $user->get_username() . " (" . $user->get_full_name(false) . ")"); } else { $template->set_var("username", ""); } if ($system_log->get_ip()) { $template->set_var("ip", $system_log->get_ip()); } else { $template->set_var("ip", ""); } if ($system_log->get_file()) { $template->set_var("file", $system_log->get_file()); } else { $template->set_var("file", ""); } if ($system_log->get_line()) { $template->set_var("line", $system_log->get_line()); } else { $template->set_var("line", ""); } if ($system_log->get_content_int()) { $template->set_var("content_int", $system_log->get_content_int()); } else { $template->set_var("content_int", ""); } if ($system_log->get_content_string()) { $template->set_var("content_string", $system_log->get_content_string()); } else { $template->set_var("content_string", ""); } if ($system_log->get_link()) { $unserialized_string = unserialize($system_log->get_link()); if (is_array($unserialized_string)) { if (count($unserialized_string) >= 1) { $string = ""; foreach ($unserialized_string as $key => $value) { $string .= $key . " => " . $value . "<br />"; } $template->set_var("get", $string); } else { $template->set_var("get", ""); } } else { $template->set_var("get", $system_log->get_link()); } } else { $template->set_var("get", ""); } $template->output(); } else { throw new SystemLogIDMissingException(); } }
/** * @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_samples($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)) { $name = $argument_array[0][1]; $organisation_unit_array = $argument_array[1][1]; $template_array = $argument_array[2][1]; $in_id = $argument_array[3][1]; $in_name = $argument_array[4][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 = Sample_Wrapper::list_sample_search($name, $organisation_unit_array, $template_array, $in_id, $in_name, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page); if (is_array($list_array) and count($list_array) >= 1) { $today_end = new DatetimeHandler(date("Y-m-d") . " 23:59:59"); foreach ($list_array as $key => $value) { $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); if ($list_array[$key]['av'] == "f") { $list_array[$key]['av'] = "<img src='images/icons/grey_point.png' alt='' />"; } else { if ($list_array[$key]['date_of_expiry'] and $list_array[$key]['expiry_warning']) { $date_of_expiry = new DatetimeHandler($list_array[$key]['date_of_expiry'] . " 23:59:59"); $warning_day = clone $date_of_expiry; $warning_day->sub_day($list_array[$key]['expiry_warning']); if ($date_of_expiry->distance($today_end) > 0) { $list_array[$key]['av'] = "<img src='images/icons/red_point.png' alt='' />"; } else { if ($warning_day->distance($today_end) > 0) { $list_array[$key]['av'] = "<img src='images/icons/yellow_point.png' alt='' />"; } else { $list_array[$key]['av'] = "<img src='images/icons/green_point.png' alt='' />"; } } } else { $list_array[$key]['av'] = "<img src='images/icons/green_point.png' alt='' />"; } } $sample_id = $list_array[$key]['id']; $sample_security = new SampleSecurity($sample_id); if ($sample_security->is_access(1, false)) { $paramquery = array(); $paramquery['username'] = $_GET['username']; $paramquery['session_id'] = $_GET['session_id']; $paramquery['nav'] = "sample"; $paramquery['run'] = "detail"; $paramquery['sample_id'] = $sample_id; $params = http_build_query($paramquery, '', '&'); $list_array[$key]['symbol']['link'] = $params; $list_array[$key]['symbol']['content'] = "<img src='images/icons/sample.png' alt='' style='border:0;' />"; unset($list_array[$key]['id']); $list_array[$key]['id']['link'] = $params; $list_array[$key]['id']['content'] = "S" . str_pad($sample_id, 8, '0', STR_PAD_LEFT); $sample_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['content'] = $sample_name; } else { $list_array[$key]['symbol'] = "<img src='core/images/denied_overlay.php?image=images/icons/sample.png' alt='N' border='0' />"; $list_array[$key]['id'] = "S" . str_pad($sample_id, 8, '0', STR_PAD_LEFT); } } } 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(); } }
/** * @throws ProjectIDMissingException * @throws ProjectSecuriyAccessDeniedException */ public static function detail() { global $project_security; if ($_GET['project_id']) { if ($project_security->is_access(1, false) == true) { $project = new Project($_GET['project_id']); $project_owner = new User($project->get_owner_id()); $template = new HTMLTemplate("project/detail.html"); $template->set_var("get_array", serialize($_GET)); $template->set_var("title", $project->get_name()); $template->set_var("owner", $project_owner->get_full_name(false)); $create_datetime = new DatetimeHandler($project->get_datetime()); $template->set_var("created_at", $create_datetime->get_datetime()); $template->set_var("template", $project->get_template_name()); $template->set_var("permissions", ""); $template->set_var("size", Convert::convert_byte_1024($project->get_filesize())); $template->set_var("quota", Convert::convert_byte_1024($project->get_quota())); $owner_paramquery = array(); $owner_paramquery['username'] = $_GET['username']; $owner_paramquery['session_id'] = $_GET['session_id']; $owner_paramquery['nav'] = "project"; $owner_paramquery['run'] = "common_dialog"; $owner_paramquery['dialog'] = "user_detail"; $owner_paramquery['id'] = $project->get_owner_id(); $owner_params = http_build_query($owner_paramquery, '', '&'); $template->set_var("owner_params", $owner_params); $template->output(); } else { throw new ProjectSecurityAccessDeniedxception(); } } else { throw new ProjectIDMissingException(); } }
public static function detail($parameter = null, $target_params = null, $display_header = true) { global $regional; if (is_object($parameter) and $target_params) { $retrace = "index.php?" . $target_params; $parameter_id = $parameter->get_id(); } elseif (is_numeric($_GET['parameter_id'])) { $parameter_id = $_GET['parameter_id']; $parameter = ParameterTemplateParameter::get_instance($parameter_id); $paramquery = $_GET; unset($paramquery['action']); unset($paramquery['parameter_id']); $params = http_build_query($paramquery); $retrace = "index.php?" . $params; if ($_GET['version'] and is_numeric($_GET['version'])) { $parameter->open_internal_revision($_GET['version']); } } else { throw new ParameterIDMissingException(); } if ($parameter->is_read_access()) { $parameter_template_id = $parameter->get_template_id(); $parameter_template = new ParameterTemplate($parameter_template_id); $parameter_template_field_array = $parameter_template->get_fields(); $parameter_template_limit_array = $parameter_template->get_limits(); $parameter_possible_methods_array = $parameter_template->get_methods(); $parameter_value_array = $parameter->get_values(); $parameter_method_array = $parameter->get_methods(); $parameter_limit_array = $parameter->get_limits(); $output_template_limit_array = array(); $output_template_limit_counter = 0; if (is_array($parameter_template_limit_array) and count($parameter_template_limit_array) >= 1) { $current_limit = $parameter->get_limit_id(); foreach ($parameter_template_limit_array as $key => $value) { $output_template_limit_array[$output_template_limit_counter]['value'] = $value['pk']; $output_template_limit_array[$output_template_limit_counter]['content'] = $value['name']; if ($value['pk'] == $current_limit) { $output_template_limit_array[$output_template_limit_counter]['selected'] = "selected='selected'"; } else { $output_template_limit_array[$output_template_limit_counter]['selected'] = ""; } $output_template_limit_counter++; } } $output_template_field_array = array(); $output_template_field_counter = 0; if (is_array($parameter_template_field_array) and count($parameter_template_field_array) >= 1) { foreach ($parameter_template_field_array as $key => $value) { $output_template_field_array[$output_template_field_counter]['id'] = $key; $output_template_field_array[$output_template_field_counter]['pk'] = $value['pk']; $output_template_field_array[$output_template_field_counter]['name'] = $value['name']; if (is_numeric($parameter_value_array[$value['pk']])) { $regionalized_value = str_replace(".", $regional->get_decimal_separator(), $parameter_value_array[$value['pk']]); $output_template_field_array[$output_template_field_counter]['value'] = $regionalized_value; } else { $output_template_field_array[$output_template_field_counter]['value'] = ""; } if (is_numeric($value['min'])) { $output_template_field_array[$output_template_field_counter]['min'] = $value['min']; } else { $output_template_field_array[$output_template_field_counter]['min'] = ""; } if (is_numeric($value['max'])) { $output_template_field_array[$output_template_field_counter]['max'] = $value['max']; } else { $output_template_field_array[$output_template_field_counter]['max'] = ""; } if ($parameter_limit_array[$value['pk']]) { if (is_numeric($parameter_limit_array[$value['pk']]['usl'])) { $output_template_field_array[$output_template_field_counter]['usl'] = $parameter_limit_array[$value['pk']]['usl']; } else { $output_template_field_array[$output_template_field_counter]['usl'] = ""; } if (is_numeric($parameter_limit_array[$value['pk']]['lsl'])) { $output_template_field_array[$output_template_field_counter]['lsl'] = $parameter_limit_array[$value['pk']]['lsl']; } else { $output_template_field_array[$output_template_field_counter]['lsl'] = ""; } } else { if (is_numeric($parameter_template_limit_array[0]['usl'][$key])) { $output_template_field_array[$output_template_field_counter]['usl'] = $parameter_template_limit_array[0]['usl'][$key]; } else { $output_template_field_array[$output_template_field_counter]['usl'] = ""; } if (is_numeric($parameter_template_limit_array[0]['lsl'][$key])) { $output_template_field_array[$output_template_field_counter]['lsl'] = $parameter_template_limit_array[0]['lsl'][$key]; } else { $output_template_field_array[$output_template_field_counter]['lsl'] = ""; } } if ($key == 1) { $output_template_field_array[$output_template_field_counter]['class'] = "odd"; } else { if ($output_template_field_counter % 2 == 0) { $output_template_field_array[$output_template_field_counter]['class'] = "odd DataParameterTemplateField"; } else { $output_template_field_array[$output_template_field_counter]['class'] = "evan DataParameterTemplateField"; } } 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']); $output_template_field_array[$output_template_field_counter]['unit'] = $unit_prefix[1] . "" . $measuring_unit->get_unit_symbol(); } elseif (is_numeric($value['unit_ratio'])) { $measuring_unit_ratio = new MeasuringUnitRatio($value['unit_ratio']); $output_template_field_array[$output_template_field_counter]['unit'] = $measuring_unit_ratio->get_symbol(); } else { $output_template_field_array[$output_template_field_counter]['unit'] = ""; } $method_counter = 1; $output_template_field_array[$output_template_field_counter][0]['value'] = "0"; $output_template_field_array[$output_template_field_counter][0]['content'] = "none"; if (is_array($parameter_possible_methods_array) and is_array($parameter_possible_methods_array[$value['pk']]) and count($parameter_possible_methods_array[$value['pk']]) >= 1) { foreach ($parameter_possible_methods_array[$value['pk']] as $method_key => $method_value) { $output_template_field_array[$output_template_field_counter][$method_counter]['value'] = $method_key; $output_template_field_array[$output_template_field_counter][$method_counter]['content'] = $method_value; if ($parameter_method_array[$value['pk']] == $method_key) { $output_template_field_array[$output_template_field_counter][$method_counter]['selected'] = " selected='selected'"; } else { $output_template_field_array[$output_template_field_counter][$method_counter]['selected'] = ""; } $method_counter++; } } $output_template_field_counter++; } } $template = new HTMLTemplate("data/parameter_detail.html"); $parameter_version_array = $parameter->get_parameter_internal_revisions(); if (is_array($parameter_version_array) and count($parameter_version_array) > 0) { $result = array(); $counter = 1; $result[0]['version'] = 0; $result[0]['text'] = "----------------------------------------------"; $parameter_version = Parameter::get_instance($_GET['parameter_id'], true); foreach ($parameter_version_array as $key => $fe_value) { $parameter_version->open_internal_revision($fe_value); $version_datetime_handler = new DatetimeHandler($parameter_version->get_version_datetime()); $result[$counter]['version'] = $parameter_version->get_internal_revision(); $result[$counter]['text'] = "Version " . $parameter_version->get_version() . " - " . $version_datetime_handler->get_datetime(); $counter++; } $template->set_var("version_option", $result); } $result = array(); $counter = 0; foreach ($_GET as $key => $fe_value) { if ($key != "version") { $result[$counter]['value'] = $fe_value; $result[$counter]['key'] = $key; $counter++; } } $template->set_var("get", $result); $template->set_var("version", $parameter->get_version()); $version_datetime_handler = new DatetimeHandler($parameter->get_version_datetime()); $template->set_var("version_datetime", $version_datetime_handler->get_datetime()); $paramquery = $_GET; $paramquery['action'] = "permission"; unset($paramquery['nextpage']); $params = http_build_query($paramquery, '', '&'); $template->set_var("change_permission_params", $params); if ($parameter->is_control_access() == true or $parameter->get_owner_id() == $user->get_user_id()) { $template->set_var("change_permission", true); } else { $template->set_var("change_permission", false); } if ($parameter->is_write_access() == true or $parameter->get_owner_id() == $user->get_user_id()) { $template->set_var("write_permission", true); } else { $template->set_var("write_permission", false); } $paramquery = $_GET; $paramquery['action'] = "parameter_history"; $params = http_build_query($paramquery, '', '&'); $template->set_var("version_list_link", $params); $template->set_var("display_header", $display_header); $template->set_var("session_id", $_GET['session_id']); $template->set_var("parameter_id", $parameter_id); $template->set_var("type_id", $parameter_template_id); $template->set_var("thousand_separator", $regional->get_thousand_separator()); $template->set_var("decimal_separator", $regional->get_decimal_separator()); $template->set_var("name", $parameter_template->get_name()); $template->set_var("limits", $output_template_limit_array); $template->set_var("fields", $output_template_field_array); $template->set_var("retrace", $retrace); $template->output(); } else { throw new DataSecurityAccessDeniedException(); } }
/** * @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 $page * @param string $sortvalue * @param string $sortmethod * @return string */ public static function list_equipment_items($json_column_array, $json_argument_array, $get_array, $css_page_id, $css_row_sort_id, $page, $sortvalue, $sortmethod) { if ($get_array) { $_GET = unserialize($get_array); } if ($json_argument_array) { $argument_array = json_decode($json_argument_array); } $handling_class = Item::get_holder_handling_class_by_name($argument_array[0][1]); if ($handling_class) { $sql = $handling_class::get_item_list_sql($argument_array[1][1]); } if ($sql) { $list_request = new ListRequest_IO(); if ($argument_array[2][1] == true) { $list_array = Equipment_Wrapper::list_item_equipments($sql, $sortvalue, $sortmethod, $page * 20 - 20, $page * 20); } else { $list_array = Equipment_Wrapper::list_item_equipments($sql, $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) { if ($argument_array[3][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='equipment-" . $list_array[$key]['item_id'] . "' value='1' class='" . $checkbox_class . "' checked='checked' />"; } else { $list_array[$key]['checkbox'] = "<input type='checkbox' name='equipment-" . $list_array[$key]['item_id'] . "' value='1' checked='checked' />"; } $list_array[$key]['symbol'] = "<img src='images/icons/equipment.png' alt='N' border='0' />"; } else { $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/equipment.png' alt='N' border='0' />"; $equipment_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['link'] = $params; $list_array[$key]['name']['content'] = $equipment_name; } $datetime_handler = new DatetimeHandler($list_array[$key]['datetime']); $list_array[$key]['datetime'] = $datetime_handler->get_datetime(false); } } else { $list_request->empty_message("<span class='italic'>No Equipment found!</span>"); } $list_request->set_array($list_array); return $list_request->get_page($page); } else { // Error } }