find events in xray and radio

Value

Script

String goes = new String("");
sql_string = sql_base.replace("%start_date%",start_date);
sql_string = sql_string.replace("%stop_date%",stop_date);
if(goes_min.length() > 0) {
  goes = goes.concat(" AND xray_class > '"+goes_min+"'");
}
if (goes_max.length() > 0) {
   goes = goes.concat(" AND xray_class < '"+goes_max+"'");
}
sql_string = sql_string.replace("%goes%",goes);

Script

import java.io.StringReader;
import org.w3c.dom.*;
import org.xml.sax.InputSource;
import org.apache.xerces.parsers.DOMParser;

private void getPositions(){
  NodeList nodesVO = docVO.getElementsByTagName("FIELD");
  for(int i=0; i< nodesVO.getLength(); i++){
     Element voFieldNode = nodesVO.item(i);
     String name = voFieldNode.getAttribute("name");
     if(name.trim().equals("ntime_start")){
        pos_start_vo = i;
     } else if(name.trim().equals("ntime_end")){
        pos_end_vo = i;
     } else if(name.trim().equals("time_start")){
        pos_startA_vo = i;
     } else if(name.trim().equals("time_end")){
        pos_endA_vo = i;
     }
  }
}


private void findDates() {
  NodeList dataListVO = docVO.getElementsByTagName("TR");
  debug= debug.concat(" length " + dataListVO.getLength()+ "\n");
  for(int i = 0; i < dataListVO.getLength(); i++) {
     debug= debug.concat(" i " + i+ "datalength " + dataListVO.getLength() +"\n" );
     List date = new ArrayList();
     NodeList voDataChilds = dataListVO.item(i).getChildNodes();
     debug= debug.concat(" length2 " +voDataChilds.getLength()+ "\n");
     if(voDataChilds.item(pos_start_vo).getFirstChild()!= null) {
       date.add(voDataChilds.item(pos_start_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
       startDates.add(voDataChilds.item(pos_start_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
     } else {
       date.add(voDataChilds.item(pos_startA_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
       startDates.add(voDataChilds.item(pos_startA_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
     }
     if(voDataChilds.item(pos_end_vo).getFirstChild()!= null) {
       date.add(voDataChilds.item(pos_end_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
       endDates.add(voDataChilds.item(pos_end_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
     } else {
       date.add(voDataChilds.item(pos_endA_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
       endDates.add(voDataChilds.item(pos_endA_vo).getFirstChild().getNodeValue().replaceAll("\\.\\d",""));
     }
     date.add(i);
     positions.add(i);
     dateList.add(date);
     debug= debug.concat(" end " +i + " \n");
  }
}

List dateList = new ArrayList();
List startDates = new ArrayList();
List endDates = new ArrayList();
List positions = new ArrayList();
String debug = "debug";
StringReader reader2 = new StringReader(voTable);
InputSource source2 = new InputSource(reader2);
Document docVO;
int pos_start_vo;
int pos_end_vo;
int pos_startA_vo;
int pos_endA_vo;
try {
  DOMParser parser = new DOMParser();
  parser.parse(source2);
  docVO = parser.getDocument();
  this.getPositions();
  this.findDates();
  reader2.close();
  if(dateList.size()==0){
    dateList.add(new ArrayList());
  }
  if(endDates.size()==0){
    endDates.add("2008-00-00 00:00:01");
  }
  if(startDates.size()==0){
    startDates.add("2008-00-00 00:00:00");
  }
  if(positions.size()==0){
    positions.add("0");
  }
}
catch (Exception e){
}

Wsdl

Wsdl Operation

Value

Script

import java.io.StringReader;
import org.w3c.dom.*;
import org.xml.sax.InputSource;
import org.apache.xerces.parsers.DOMParser;
import java.util.Date;
import java.text.SimpleDateFormat;

private void getPositions(){
  NodeList nodesVO = docVO.getElementsByTagName("FIELD");
  for(int i=0; i< nodesVO.getLength(); i++){
     Element voFieldNode = nodesVO.item(i);
     String name = voFieldNode.getAttribute("name");
     if(name.trim().equals("time_peak")){
        posPeak = i;
     }
  }
}

private void findDates() {
  NodeList dataListVO = docVO.getElementsByTagName("TR");
  for(int i = 0; i < dataListVO.getLength(); i++) {
    NodeList voDataChilds = dataListVO.item(i).getChildNodes();
    String date=voDataChilds.item(posPeak).getFirstChild().getNodeValue().trim();
    startDate.add(date.replaceAll("..:..:....", "00:00:00"));
    endDate.add(date.replaceAll("..:..:....", "23:59:59"));

  }
}



List startDate = new ArrayList();
List endDate = new ArrayList();
debug = new String("debug\n");

StringReader reader2 = new StringReader(voTable);
InputSource source2 = new InputSource(reader2);
DOMParser parser2 = new DOMParser();
Document docVO;

int posPeak=-1;
parser2.parse(source2);
docVO = parser2.getDocument();
getPositions();
if(posPeak >= 0){
  findDates();
}
reader2.close();

Wsdl

Wsdl Operation

Script

import java.io.StringReader;
import org.w3c.dom.*;
import org.xml.sax.InputSource;
import org.apache.xerces.parsers.DOMParser;
import java.io.StringWriter;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.lang.*;

private void write(Node node, String indent) {
        // The output depends on the type of the node
        switch(node.getNodeType()) {
        case Node.DOCUMENT_NODE: {       // If its a Document node
            Document doc = (Document)node;
            out.write(indent + "\n");  // Output header
            Node child = doc.getFirstChild();   // Get the first node
            while(child != null) {              // Loop 'till no more nodes
                write(child, indent);           // Output node
                child = child.getNextSibling(); // Get next node
            }
            break;
        } 
        case Node.DOCUMENT_TYPE_NODE: {  // It is a  tag
            DocumentType doctype = (DocumentType) node;
            // Note that the DOM Level 1 does not give us information about
            // the the public or system ids of the doctype, so we can't output
            // a complete  tag here.  We can do better with Level 2.
            out.write("\n");
            break;
        }
        case Node.ELEMENT_NODE: {        // Most nodes are Elements
            Element elt = (Element) node;
            out.write(indent + "<" + elt.getTagName());   // Begin start tag
            NamedNodeMap attrs = elt.getAttributes();     // Get attributes
            for(int i = 0; i < attrs.getLength(); i++) {  // Loop through them
                Node a = attrs.item(i);
                out.write(" " + a.getNodeName() + "='" +  // Print attr. name
                          fixup(a.getNodeValue()) + "'"); // Print attr. value
            }
            out.write(">\n");                             // Finish start tag

            String newindent = indent + "    ";           // Increase indent
            Node child = elt.getFirstChild();             // Get child
            while(child != null) {                        // Loop 
                write(child, newindent);                  // Output child
                child = child.getNextSibling();           // Get next child
            }

            out.write(indent + "\n");
            break;
        }
        case Node.TEXT_NODE: {                   // Plain text node
            Text textNode = (Text)node;
            String text = textNode.getData().trim();   // Strip off space
            if ((text != null) && text.length() > 0)   // If non-empty
                out.write(indent + fixup(text)+"\n");     // print text
            break;
        }
        case Node.PROCESSING_INSTRUCTION_NODE: {  // Handle PI nodes
            ProcessingInstruction pi = (ProcessingInstruction)node;
            out.write(indent + "\n");
            break;
        }
        case Node.ENTITY_REFERENCE_NODE: {        // Handle entities
            out.write(indent + "&" + node.getNodeName() + ";\n");
            break;
        }
        case Node.CDATA_SECTION_NODE: {           // Output CDATA sections
            CDATASection cdata = (CDATASection)node;
            // Careful! Don't put a CDATA section in the program itself!
            out.write(indent + "<" + "![CDATA[" + cdata.getData() +
                        "]]" + ">\n");
            break;
        }
        case Node.COMMENT_NODE: {                 // Comments
            Comment c = (Comment)node;
            out.write(indent + "\n");
            break;
        }
        default:   // Hopefully, this won't happen too much!
            System.err.println("Ignoring node: " + node.getClass().getName());
            break;
        }
    }

    // This method replaces reserved characters with entities.
private String fixup(String s) {
        StringBuffer sb = new StringBuffer();
        int len = s.length();
        for(int i = 0; i < len; i++) {
            char c = s.charAt(i);
            switch(c) {
            default: sb.append(c); break;
            case '<': sb.append("<"); break;
            case '>': sb.append(">"); break;
            case '&': sb.append("&"); break;
            case '"': sb.append("""); break;
            case '\'': sb.append("'"); break;
            }
        }
        return sb.toString();
    }

private void addTableHeaders(List instrument, String prefix){
  NodeList nodes=null;
  StringReader reader;
  InputSource source;
  DOMParser parser = new DOMParser();
  Document doc;
  for(int i = 0; i < instrument.size(); i++) {
    reader = new StringReader(instrument.get(i));
    source = new InputSource(reader);
    parser.parse(source);
    doc=parser.getDocument();
    nodes = doc.getElementsByTagName("return");
    if(nodes!= null && nodes.getLength()>=1){
      break;
    } else {
      reader.close();
    }
  }

  NodeList nodesVO = docVO.getElementsByTagName("TABLE");
  if(nodesVO.getLength() >= 1){
    Node voTableNode = nodesVO.item(0);
    if(nodes != null && nodes.getLength()>= 1){
      Node observation = nodes.item(0);
      NodeList obsChilds = observation.getChildNodes();
      for(int i=0; i< obsChilds.getLength(); i++){
        Element voFieldNode = docVO.createElement("FIELD");
        voFieldNode.setAttribute("name",prefix.concat(obsChilds.item(i).getLocalName()));
        voFieldNode.setAttribute("datatype","char");
        voFieldNode.setAttribute("arraysize","3400");
        voTableNode.insertBefore(voFieldNode, voTableNode.getLastChild());
      }
    }
  }
  reader.close();
}

private void addTableHeaderValue(String value){
  NodeList nodesVO = docVO.getElementsByTagName("TABLE");
  if(nodesVO.getLength() >= 1){
    Node voTableNode = nodesVO.item(0);
    Element voFieldNode = docVO.createElement("FIELD");
    voFieldNode.setAttribute("name", value);
    voFieldNode.setAttribute("datatype","char");
    voFieldNode.setAttribute("arraysize","3400");
    voTableNode.insertBefore(voFieldNode, voTableNode.getLastChild());
  }
}

private writeExtraFields(Node nodeVO, Node nodeHessi) {
  String debug = new String("");
  NodeList listHessi = nodeHessi.getChildNodes();
  for(int i=0; i< listHessi.getLength(); i++) {
    Node newNode = nodeVO.getFirstChild().cloneNode(false);
    Text voTextNode = docVO.createTextNode(listHessi.item(i).getFirstChild().getNodeValue());
    newNode.appendChild(voTextNode);
    nodeVO.appendChild(newNode);
  }
} 

private writeSolarMonitor(Node nodeVO, int pos) {
  NodeList nodes=null;
  StringReader reader;
  InputSource source;
  Document docSM;
  DOMParser parserSM = new DOMParser();
  reader = new StringReader(solar_monitor_data.get(pos));
  source = new InputSource(reader);
  parserSM.parse(source);
  docSM=parserSM.getDocument();
  nodes = docSM.getElementsByTagName("urlPreview");
  if(nodes!= null && nodes.getLength()>=1){
      NodeList obsChilds = nodes.item(0).getChildNodes();
      Node newNode = nodeVO.getFirstChild().cloneNode(false);
      Text voTextNode = docVO.createTextNode(obsChilds.item(0).getNodeValue());
      newNode.appendChild(voTextNode);
      nodeVO.appendChild(newNode);
  } else {

    Node newNode = nodeVO.getFirstChild().cloneNode(false);
    Text voTextNode = docVO.createTextNode("");
    newNode.appendChild(voTextNode);
    nodeVO.appendChild(newNode);
  }
  nodes = docSM.getElementsByTagName("urlPreviewThumb");
  if(nodes!= null && nodes.getLength()>=1){
      NodeList obsChilds = nodes.item(0).getChildNodes();
      Node newNode = nodeVO.getFirstChild().cloneNode(false);
      Text voTextNode = docVO.createTextNode(obsChilds.item(0).getNodeValue());
      newNode.appendChild(voTextNode);
      nodeVO.appendChild(newNode);
  } else {

    Node newNode = nodeVO.getFirstChild().cloneNode(false);
    Text voTextNode = docVO.createTextNode("");
    newNode.appendChild(voTextNode);
    nodeVO.appendChild(newNode);
  }
   reader.close();
}

private String findOverlaps() {

  NodeList[] nodes = new NodeList[instrument_data.size()];
  StringReader[] reader = new StringReader[instrument_data.size()];
  InputSource[] source = new InputSource[instrument_data.size()];
  int[] position2 = new int[instrument_data.size()];
  NodeList[] dataList = new NodeList[instrument_data.size()];
  NodeList[] dataList2 = new NodeList[instrument_data.size()];
  DOMParser[] parser = new DOMParser[instrument_data.size()];
  long[] min = new long[instrument_data.size()];
  long[] max = new long[instrument_data.size()];
  String debug = new String("");
  NodeList tableListVO = docVO.getElementsByTagName("TABLEDATA");
  NodeList dataListVO = docVO.getElementsByTagName("TR");
  if(dataListVO == null) {
    debug="dataListVO = null";
    return debug;
  }
  SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'");

  for(int i =1; i< instrument_data.size(); i++){
    if(instrument_data.get(i-1).size() != instrument_data.get(i).size()) {
      throw new Exception("data list lengths different -> not from same periodes");
    }
  }

  // for all events;
  for(int i = instrument_data.get(0).size()-1; i>=0; i--) {
    //init
   // debug = debug.concat("instrument_data size " + instrument_data.get(0).size() + " " + i);
 
    for(int a = 0; a < instrument_data.size(); a++) {  
      parser[a] = new DOMParser();
      reader[a] = new StringReader(instrument_data.get(a).get(i));
      source[a] = new InputSource(reader[a]);
      parser[a].parse(source[a]);
      doc[a] = parser[a].getDocument();
      position2[a] = -1;
      min[a] = 0;
      max[a] = 0;


      dataList[a] = doc[a].getElementsByTagName("measurementStart");
      if(dataList[a] == null){
        dataList[a] = new NodeList();
      }
      dataList2[a] = doc[a].getElementsByTagName("measurementEnd");
      if(dataList2[a] == null){
        dataList2[a] = new NodeList();
      }
    }

    int pos = Integer.parseInt(position.get(i)); 

    Node voDataNode = dataListVO.item(pos);
    if(voDataNode == null)
    {
      for(int b = 0; b < instrument_data.size(); b++) {
        reader[b].close();
      }
      debug = debug.concat("voDataNode = null \n" + pos);
      return debug;
    }
    Node parent = voDataNode.getParentNode();    


    //matching


    // for dates in instrument 0 - compare base
    for(int b = 0; b0) {
        max[0] = date.parse(dataList2[0].item(b).getFirstChild().getNodeValue()).getTime();
      } else {
        max[0]=min[0];
      }
      position2[0]=b;
      
    for(int a = 1; a < instrument_data.size(); a++) { 
      for(int j = position2[a]+1; j < dataList[a].getLength(); j++) {
        position2[a]=-1;
        long start = date.parse(dataList[a].item(j).getFirstChild().getNodeValue()).getTime();
	long end=0;
        if(dataList2[a].getLength()>0){
          end = date.parse(dataList2[a].item(j).getFirstChild().getNodeValue()).getTime();
        } else{
          end =start;
        }
        if(start < max[a-1] && end> min[a-1]) {
          // overlap
          //debug=debug.concat(a+" " +dataList[a].item(j).getFirstChild().getNodeValue()+ " "); 
          position2[a]=j;
          if(min[a-1]>start) {
            min[a]=start;
          } else {
            min[a]=min[a-1];
          }
          if(max[a-1]

Wsdl

Wsdl Operation