Package org.worldbank.transport.tamt.shared

Examples of org.worldbank.transport.tamt.shared.RoadLengthReport


  }

  public String downloadRoadLengthReport(String regionid) {
   
    // fetch the report
    RoadLengthReport report = getRoadLengthReport();
   
    // now format it for CSV download
    String output = "";
   
    StringBuffer sb = new StringBuffer();
    sb.append("REGION,TAG,VKT\n");
   
    // pull out the report values
    ArrayList<ArrayList> reportValues = report.getReportValues();
   
    // loop through the records
    for (Iterator iterator = reportValues.iterator(); iterator.hasNext();) {
      ArrayList row = (ArrayList) iterator.next();
      sb.append(row.get(0) + ",");
View Full Code Here


     * - for the current study region
     * - return a report with an array of values in the report
     * - [0] = tagname (based on tagid and regionid)
     * - [1] = distance (km)
     */
    RoadLengthReport report = new RoadLengthReport();
    ArrayList<ArrayList> reportValues = new ArrayList<ArrayList>();

    try {
      Connection connection = getConnection();
      Statement s = connection.createStatement();
      String sql = "select r.name as region, " +
          "t.name as tag, " +
          "round(d.vkt, 3) " +
          "from " +
          "totaldistancebytag d, " +
          "tagdetails t, " +
          "studyregion r " +
          "where d.tag_id = t.id " +
          "and " +
          "r.id = t.region " +
          "and " +
          "r.id = (SELECT id FROM studyregion WHERE iscurrentregion IS TRUE)";
      logger.debug("SQL=" + sql);
      ResultSet r = s.executeQuery(sql);
      while( r.next() ) {
            /*
            * Retrieve the geometry as an object then cast it to the geometry type.
            * Print things out.
            */
          String region = r.getString(1);
            String tag = r.getString(2);
            String vkt = r.getString(3);
           
            ArrayList<String> thisRow = new ArrayList<String>();
            thisRow.add(region);
            thisRow.add(tag);
            thisRow.add(vkt);
           
            reportValues.add(thisRow);
           
      }
      connection.close(); // returns connection to the pool
    }
      catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
   
    report.setReportValues(reportValues);
    return report;
  }
View Full Code Here

TOP

Related Classes of org.worldbank.transport.tamt.shared.RoadLengthReport

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.