Exemplo n.º 1
0
 public function delete()
 {
     global $transaction;
     if ($this->parameter_method and $this->parameter_method_id) {
         $transaction_id = $transaction->begin();
         if (ParameterTemplate::delete_field_methods($this->parameter_method_id) === false) {
             if ($transaction_id != null) {
                 $transaction->rollback($transaction_id);
             }
             return false;
         }
         if ($this->parameter_method->delete() == true) {
             if ($transaction_id != null) {
                 $transaction->commit($transaction_id);
             }
             return true;
         } else {
             if ($transaction_id != null) {
                 $transaction->rollback($transaction_id);
             }
             return false;
         }
     } else {
         return false;
     }
 }
Exemplo n.º 2
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();
     }
 }
 /**
  * @see ParameterTemplateParameterInterface::get_name()
  * @return string
  */
 public function get_name()
 {
     if ($this->parameter_id) {
         $parameter_template = new ParameterTemplate($this->get_template_id());
         return $parameter_template->get_name();
     } else {
         return null;
     }
 }
Exemplo n.º 4
0
 /**
  * @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;
     }
 }
 /**
  * @param integer $internal_name
  * @return integer
  */
 public static function exist_internal_name($internal_name)
 {
     if (ParameterTemplate::exist_internal_name($internal_name) === true) {
         return 1;
     } else {
         return 0;
     }
 }
 public static function edit()
 {
     if (isset($_GET['id']) and is_numeric($_GET['id'])) {
         $parameter_template = new ParameterTemplate($_GET['id']);
         $template = new HTMLTemplate("data/admin/parameter_template/edit.html");
         $paramquery = $_GET;
         unset($paramquery['action']);
         unset($paramquery['id']);
         $params = http_build_query($paramquery, '', '&');
         $template->set_var("retrace", "index.php?" . $params);
         $template->set_var("session_id", $_GET['session_id']);
         $template->set_var("name", $parameter_template->get_name());
         $template->set_var("internal_name", $parameter_template->get_internal_name());
         $measuring_unit_array = MeasuringUnit::get_categorized_list();
         $parameter_template_field_array = $parameter_template->get_fields();
         $parameter_template_limit_array = $parameter_template->get_limits();
         $output_template_field_array = array();
         $output_template_field_counter = 0;
         $parameter_template_limit_json = json_encode($parameter_template_limit_array);
         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_array($measuring_unit_array) and count($measuring_unit_array) >= 1) {
                     $measuring_unit_counter = 0;
                     foreach ($measuring_unit_array as $measuring_unit_key => $measuring_unit_value) {
                         if ($measuring_unit_value['headline'] == true) {
                             $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['disabled'] = "disabled='disabled'";
                             $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['selected'] = "";
                         } else {
                             $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['disabled'] = "";
                             if ($measuring_unit_value['id'] == $value['unit'] and $measuring_unit_value['exponent'] == $value['unit_exponent']) {
                                 $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['selected'] = "selected='selected'";
                             } elseif ($measuring_unit_value['exponent'] == "" and $measuring_unit_value['id'] == $value['unit_ratio']) {
                                 $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['selected'] = "selected='selected'";
                             } else {
                                 $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['selected'] = "";
                             }
                         }
                         $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['value'] = $measuring_unit_value['id'] . "-" . $measuring_unit_value['exponent'];
                         $output_template_field_array[$output_template_field_counter][$measuring_unit_counter]['content'] = $measuring_unit_value['name'];
                         $measuring_unit_counter++;
                     }
                 }
                 if ($key == 1) {
                     $output_template_field_array[$output_template_field_counter]['deletable'] = false;
                 } else {
                     $output_template_field_array[$output_template_field_counter]['deletable'] = true;
                 }
                 $output_template_field_counter++;
             }
         }
         $template->set_var("fields", $output_template_field_array);
         $template->set_var("limit_json", $parameter_template_limit_json);
         $template->set_var("limit_counter", count($parameter_template_limit_array) - 1);
         $template->set_var("line_counter", count($parameter_template_field_array));
         $template->set_var("id", $_GET['id']);
         $template->output();
     } else {
         // Exception
     }
 }
Exemplo n.º 7
0
 /**
  * @see ItemListenerInterface::get_generic_name()
  * @param string $type
  * @param array $type_array
  * @return string
  */
 public static function get_generic_name($type, $type_array)
 {
     if ($type == "file") {
         return "File";
     } elseif ($type == "parameter") {
         if (is_array($type_array) and count($type_array) == 1) {
             $parameter_template_id = ParameterTemplate::get_id_by_internal_name($type_array[0]);
             if (is_numeric($parameter_template_id)) {
                 $parameter_template = new ParameterTemplate($parameter_template_id);
                 if (($parameter_name = $parameter_template->get_name()) != null) {
                     return "" . $parameter_name;
                 } else {
                     return "Parameter";
                 }
             } else {
                 return "Parameter";
             }
         } else {
             return "Parameter";
         }
     } else {
         if (is_array($type_array) and count($type_array) == 1) {
             $value_type = new ValueType($type_array[0]);
             if (($value_name = $value_type->get_name()) != null) {
                 return "" . $value_name;
             } else {
                 return "Value";
             }
         } else {
             return "Value";
         }
     }
 }
Exemplo n.º 8
0
 public static function get_limits($parameter_template_id, $parameter_limit_id)
 {
     if (is_numeric($parameter_template_id) and is_numeric($parameter_limit_id)) {
         $parameter_template = new ParameterTemplate($parameter_template_id);
         return json_encode($parameter_template->get_limits($parameter_limit_id));
     } else {
         throw new ParameterIDMissingException();
     }
 }