/**
* @param string $id
* @return string
*/
public static function delete_measuring_unit_ratio($id)
{
if (is_numeric($id)) {
$measuring_unit_ratio = new MeasuringUnitRatio($id);
if ($measuring_unit_ratio->delete() == true) {
return "1";
} else {
return "0";
}
} else {
return "0";
}
}
/**
* @throws FolderIDMissingException
*/
public static function add_parameter_item($type_array, $category_array, $holder_class, $holder_id, $position_id)
{
global $regional;
if (class_exists($holder_class)) {
$item_holder = new $holder_class($holder_id);
if ($item_holder instanceof ItemHolderInterface) {
$folder_id = $item_holder->get_item_holder_value("folder_id", $position_id);
}
}
if (count($type_array) != 1 and $_POST['type_id']) {
$parameter_template_id = $_POST['type_id'];
} elseif (count($type_array) == 1 and $type_array[0] !== "") {
$parameter_template_id = ParameterTemplate::get_id_by_internal_name($type_array[0]);
} else {
$parameter_template_id = null;
}
if (!is_numeric($parameter_template_id)) {
$template = new HTMLTemplate("data/parameter_select_list.html");
$paramquery = $_GET;
$params = http_build_query($paramquery, '', '&');
$template->set_var("params", $params);
if (count($type_array) > 1) {
$template->set_var("select", ParameterTemplate::list_templates($type_array));
} else {
$template->set_var("select", ParameterTemplate::list_templates());
}
if ($_POST['keywords']) {
$template->set_var("keywords", $_POST['keywords']);
} else {
$template->set_var("keywords", "");
}
if ($_POST['description']) {
$template->set_var("description", $_POST['description']);
} else {
$template->set_var("description", "");
}
$template->output();
} else {
$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();
$output_template_limit_array = array();
$output_template_limit_counter = 0;
if (is_array($parameter_template_limit_array) and count($parameter_template_limit_array) >= 1) {
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]['selected'] = "";
$output_template_limit_array[$output_template_limit_counter]['content'] = $value['name'];
$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($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 (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;
$method_counter++;
}
}
$output_template_field_counter++;
}
}
$template = new HTMLTemplate("data/parameter_add.html");
if ($_GET['retrace']) {
$template->set_var("retrace", "index.php?" . http_build_query(Retrace::resolve_retrace_string($_GET['retrace'])));
} else {
$template->set_var("retrace", "index.php?username="******"&session_id=" . $_GET['session_id']);
}
$template->set_var("session_id", $_GET['session_id']);
$template->set_var("folder_id", $folder_id);
$template->set_var("type_id", $parameter_template_id);
$template->set_var("get_array", serialize($_GET));
$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->output();
}
}
/**
* @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;
}
}