package org.wcb.gui.forms.report;
   
   import org.wcb.model.bd.LogbookDelegate;
   import org.wcb.model.bd.AircraftDelegate;
   import org.wcb.model.util.SpringUtil;
   import org.wcb.model.service.IServicesConstants;
   import org.wcb.model.vo.hibernate.Logbook;
   import org.wcb.model.vo.hibernate.AircraftTypeBO;
   import org.wcb.model.vo.hibernate.AircraftBO;
  import org.jfree.chart.ChartPanel;
  import org.jfree.chart.JFreeChart;
  import org.jfree.chart.ChartFactory;
  import org.jfree.chart.renderer.category.BarRenderer;
  import org.jfree.chart.axis.NumberAxis;
  import org.jfree.chart.axis.CategoryLabelPositions;
  import org.jfree.chart.axis.CategoryAxis;
  import org.jfree.chart.plot.PlotOrientation;
  import org.jfree.chart.plot.CategoryPlot;
  import org.jfree.data.category.CategoryDataset;
  import org.jfree.data.category.DefaultCategoryDataset;
  import org.jfree.data.UnknownKeyException;
  
  import javax.swing.*;
  import java.awt.*;
  
  
  /**
   * <small>
   * <p/>
   * Copyright (C)  2006  wbogaardt.
   * This library is free software; you can redistribute it and/or
   * modify it under the terms of the GNU Lesser General Public
   * License as published by the Free Software Foundation; either
   * version 2.1 of the License, or (at your option) any later version.
   * <p/>
   * This library is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
   * Lesser General Public License for more details.
   * <p/>
   * You should have received a copy of the GNU Lesser General Public
   * License along with this library; if not, write to the Free Software
   * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
   * <p/>
   * $File:  $ <br>
   * $Change:  $ submitted by $Author: wbogaardt $ at $DateTime: Nov 21, 2006 12:28:22 PM $ <br>
   * </small>
   *
   * @author wbogaardt
   *         This is to display a report that shows all the makes and models flown
   * broken down by total time and pilot in command time for each make and model. This is
   * a bar chart for easy readability.
   */
  
  public class AircraftMakeModelReportForm extends JPanel implements ReportRefresh {
  
      private LogbookDelegate delegate;
      private AircraftDelegate aircrafts;
      private ChartPanel chartPanel;
  
      public AircraftMakeModelReportForm() {
          delegate = (LogbookDelegate) SpringUtil.getApplicationContext().getBean(IServicesConstants.LOGBOOK_DELEGATE);
          aircrafts = (AircraftDelegate) SpringUtil.getApplicationContext().getBean(IServicesConstants.AIRCRAFT_DELEGATE);
          initComponents();
      }
  
      public void refresh() {
          CategoryDataset dataset = createDataSet();
  
  // create the chart...
          JFreeChart chart = ChartFactory.createBarChart(
                  "AircraftBO by Make/Model",       // chart title
                  "Make/Model",               // domain axis label
                  "Time",                  // range axis label
                  dataset,                  // data
                  PlotOrientation.VERTICAL, // orientation
                  true,                     // include legend
                  true,                     // tooltips?
                  false                     // URLs?
          );
  
          chart.setBackgroundPaint(Color.white);
          // get a reference to the plot for further customisation...
          CategoryPlot plot = chart.getCategoryPlot();
          plot.setBackgroundPaint(Color.lightGray);
          plot.setDomainGridlinePaint(Color.white);
          plot.setDomainGridlinesVisible(true);
          plot.setRangeGridlinePaint(Color.white);
  
          // set the range axis to display integers only...
          final NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis();
          rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
  
          // disable bar outlines...
          BarRenderer renderer = (BarRenderer) plot.getRenderer();
          renderer.setDrawBarOutline(false);
  
          // set up gradient paints for series...
          GradientPaint gp0 = new GradientPaint(0.0f, 0.0f, Color.blue,
                 0.0f, 0.0f, new Color(0, 0, 64));
         GradientPaint gp1 = new GradientPaint(0.0f, 0.0f, Color.green,
                 0.0f, 0.0f, new Color(0, 64, 0));
         GradientPaint gp2 = new GradientPaint(0.0f, 0.0f, Color.red,
                 0.0f, 0.0f, new Color(64, 0, 0));
         renderer.setSeriesPaint(0, gp0);
         renderer.setSeriesPaint(1, gp1);
         renderer.setSeriesPaint(2, gp2);
 
         CategoryAxis domainAxis = plot.getDomainAxis();
         domainAxis.setCategoryLabelPositions(
                 CategoryLabelPositions.createUpRotationLabelPositions(
                         Math.PI / 6.0));
         chartPanel.setChart(chart);
 
     }
 
     private CategoryDataset createDataSet() {
         DefaultCategoryDataset dataset = new DefaultCategoryDataset();
 
         java.util.List<AircraftBO> aircraftsList = aircrafts.getAllAircraft();
         for(AircraftBO item: aircraftsList) {
             AircraftTypeBO type = aircrafts.getAircraftType(item.getTypeId());
             this.getTotalForAircraft(dataset,type.getManufacturer() + "/" +type.getModel(), item.getRegistrationNumber());
 
         }
         return dataset;
     }
 
     private void getTotalForAircraft(DefaultCategoryDataset dataset, String makeModel, String registration) {
         java.util.List<Logbook> rows = delegate.findByRegistration(registration);
         Double pic = 0.0;
         Double totalTime = 0.0;
         for(Logbook item : rows) {
             if(item.getFlightDuration() > 0) {
                 totalTime = totalTime + item.getFlightDuration();
                 pic = pic + item.getPic();
             } else {
                 //must be a PCATD device
                 totalTime = totalTime + item.getConditionFlightSim();
                 pic = pic + item.getConditionFlightSim();
             }
         }
         try {
             Number numTotal = dataset.getValue("Total Time", makeModel);
             Number numPIC = dataset.getValue("PIC Time", makeModel);
             totalTime = numTotal.doubleValue() + totalTime;
             pic = numPIC.doubleValue() + pic;
         } catch (UnknownKeyException uke) {
             //unknown key problem is because it hasn't been set so
             //we need to just create default values;
             dataset.addValue(totalTime, "Total Time", makeModel);
             dataset.addValue(pic, "PIC Time", makeModel);
         }
         dataset.setValue(totalTime, "Total Time", makeModel);
         dataset.setValue(pic, "PIC Time", makeModel);
     }
 
     private void initComponents() {
         CategoryDataset dataset = createDataSet();
 
 // create the chart...
         JFreeChart chart = ChartFactory.createBarChart(
                 "Bar Chart Demo 1",       // chart title
                 "Category",               // domain axis label
                 "Value",                  // range axis label
                 dataset,                  // data
                 PlotOrientation.VERTICAL, // orientation
                 true,                     // include legend
                 true,                     // tooltips?
                 false                     // URLs?
         );
 
         chart.setBackgroundPaint(Color.white);
         // get a reference to the plot for further customisation...
         CategoryPlot plot = chart.getCategoryPlot();
         plot.setBackgroundPaint(Color.lightGray);
         plot.setDomainGridlinePaint(Color.white);
         plot.setDomainGridlinesVisible(true);
         plot.setRangeGridlinePaint(Color.white);
 
 // set the range axis to display integers only...
         final NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis();
         rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
 
         CategoryAxis domainAxis = plot.getDomainAxis();
         domainAxis.setCategoryLabelPositions(
                 CategoryLabelPositions.createUpRotationLabelPositions(
                         Math.PI / 6.0));
         chartPanel = new ChartPanel(chart);
         add(chartPanel);
     }
 }