org.turro.dossier.dw.DatawarehouseVM Class Reference

Collaboration diagram for org.turro.dossier.dw.DatawarehouseVM:

Public Member Functions
Date	getStart ()
void	setStart (Date start)
Date	getEnd ()
void	setEnd (Date end)
Category	getCategory ()
void	setCategory (Category category)
Dossier	getDossier ()
void	setDossier (Dossier dossier)
IContact	getContact ()
void	setContact (IContact contact)
void	init ()
void	update ()
void	selectEntity (@BindingParam("entity") Object entity)
void	selectContact (@BindingParam("contact") IContact contact)
void	selectReport (@BindingParam("type") DWReportType type)
List< DWChart >	getModel ()
DWChart	getIssuesByParticipant (IssueParticipantRole role)
DWChart	getByStatus (IssueParticipantRole role)
DWChart	getByType (IssueParticipantRole role)
DWChart	getByResolution (IssueParticipantRole role)
DWChart	getTimelineByResolution (IssueParticipantRole role)
DWChart	getTimelineByStatus (IssueParticipantRole role)
DWChart	getTimelineByType (IssueParticipantRole role)
DWChartEngine	getEngine ()

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 49 of file DatawarehouseVM.java.

Member Function Documentation

getByResolution()

DWChart org.turro.dossier.dw.DatawarehouseVM.getByResolution

(

IssueParticipantRole

role

)

Definition at line 231 of file DatawarehouseVM.java.

                                                            {
    SimplePieModel cm = new SimplePieModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select resolution, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "startDate", role);
    wc.addClause("group by resolution");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueResolution resolution = (IssueResolution) o[0];
      cm.setValue(resolution.toString(), (Number) o[1]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Resolutions");
    chart.setModel(cm);
    chart.setType("pie");
    chart.setHeight("300");
    chart.setWidth("500");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getByStatus()

DWChart org.turro.dossier.dw.DatawarehouseVM.getByStatus

(

IssueParticipantRole

role

)

Definition at line 187 of file DatawarehouseVM.java.

                                                        {
    SimplePieModel cm = new SimplePieModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select status, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "startDate", role);
    wc.addClause("group by status");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueStatus status = (IssueStatus) o[0];
      cm.setValue(status.toString(), (Number) o[1]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Status");
    chart.setModel(cm);
    chart.setType("pie");
    chart.setHeight("300");
    chart.setWidth("500");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getByType()

DWChart org.turro.dossier.dw.DatawarehouseVM.getByType

(

IssueParticipantRole

role

)

Definition at line 209 of file DatawarehouseVM.java.

                                                      {
    SimplePieModel cm = new SimplePieModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select type, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "startDate", role);
    wc.addClause("group by type");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueType type = (IssueType) o[0];
      cm.setValue(type.toString(), (Number) o[1]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Type");
    chart.setModel(cm);
    chart.setType("pie");
    chart.setHeight("300");
    chart.setWidth("500");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getCategory()

Category org.turro.dossier.dw.DatawarehouseVM.getCategory

(

)

Definition at line 75 of file DatawarehouseVM.java.

                                {
    return category;
  }

getContact()

IContact org.turro.dossier.dw.DatawarehouseVM.getContact

(

)

Definition at line 91 of file DatawarehouseVM.java.

                               {
    return contact;
  }

getDossier()

Dossier org.turro.dossier.dw.DatawarehouseVM.getDossier

(

)

Definition at line 83 of file DatawarehouseVM.java.

                              {
    return dossier;
  }

getEnd()

Date org.turro.dossier.dw.DatawarehouseVM.getEnd

(

)

Definition at line 67 of file DatawarehouseVM.java.

                       {
    return end;
  }

getEngine()

DWChartEngine org.turro.dossier.dw.DatawarehouseVM.getEngine

(

)

Definition at line 325 of file DatawarehouseVM.java.

                                   {
    return engine;
  }

getIssuesByParticipant()

DWChart org.turro.dossier.dw.DatawarehouseVM.getIssuesByParticipant

(

IssueParticipantRole

role

)

Definition at line 157 of file DatawarehouseVM.java.

                                                                   {
    SimpleCategoryModel cm = new SimpleCategoryModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select participantId, resolution, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where participantRole = :role");
    wc.addNamedValue("role", role);
    IContact temp = contact;
    contact = null;
    addFilter(wc, "startDate", null);
    contact = temp;
    wc.addClause("group by participantId, resolution");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IContact participant = Contacts.getContactById((String) o[0]);
      if(participant.isValid()) {
        IssueResolution resolution = (IssueResolution) o[1];
        cm.setValue(resolution.toString(), participant.getName(), (Number) o[2]);
      }
    }
    DWChart chart = new DWChart();
    chart.setTitle(role.toString());
    chart.setModel(cm);
    chart.setType("bar");
    chart.setOrient("horizontal");
    chart.setWidth("900");
    chart.setHeight((results.size() * 90 + 40) + "");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getModel()

List<DWChart> org.turro.dossier.dw.DatawarehouseVM.getModel

(

)

Definition at line 139 of file DatawarehouseVM.java.

                                  {
    charts.clear();
    if(report.equals(DWReportType.DW_TIMELINE)) {
      charts.add(getTimelineByStatus(null));
      charts.add(getTimelineByType(null));
      charts.add(getTimelineByResolution(null));
    } else if(report.equals(DWReportType.DW_PARTICIPANTS)) {
      charts.add(getIssuesByParticipant(IssueParticipantRole.ISSUE_RESPONSIBLE));
      charts.add(getIssuesByParticipant(IssueParticipantRole.ISSUE_REPORTER));
      charts.add(getIssuesByParticipant(IssueParticipantRole.ISSUE_QA));
    } else if(report.equals(DWReportType.DW_ISSUES)) {
      charts.add(getByStatus(null));
      charts.add(getByType(null));
      charts.add(getByResolution(null));
    }
    return charts;
  }

Here is the call graph for this function:

getStart()

Date org.turro.dossier.dw.DatawarehouseVM.getStart

(

)

Definition at line 59 of file DatawarehouseVM.java.

                         {
    return start;
  }

getTimelineByResolution()

DWChart org.turro.dossier.dw.DatawarehouseVM.getTimelineByResolution

(

IssueParticipantRole

role

)

Definition at line 253 of file DatawarehouseVM.java.

                                                                    {
    SimpleCategoryModel cm = new SimpleCategoryModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select concat(year(solvedDate), '-', month(solvedDate)), resolution, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "solvedDate", role);
    wc.addClause("group by concat(year(solvedDate), '-', month(solvedDate)), resolution");
    wc.addClause("order by concat(year(solvedDate), '-', month(solvedDate))");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueResolution resolution = (IssueResolution) o[1];
      String month = (String) o[0];
      cm.setValue(resolution.toString(), month, (Number) o[2]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Resolution");
    chart.setModel(cm);
    chart.setType("line");
    chart.setHeight("300");
    chart.setWidth((cm.getCategories().size() * 70 + 40) + "");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getTimelineByStatus()

DWChart org.turro.dossier.dw.DatawarehouseVM.getTimelineByStatus

(

IssueParticipantRole

role

)

Definition at line 277 of file DatawarehouseVM.java.

                                                                {
    SimpleCategoryModel cm = new SimpleCategoryModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select concat(year(startDate), '-', month(startDate)), status, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "startDate", role);
    wc.addClause("group by concat(year(startDate), '-', month(startDate)), status");
    wc.addClause("order by concat(year(startDate), '-', month(startDate))");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueStatus status = (IssueStatus) o[1];
      String month = (String) o[0];
      cm.setValue(status.toString(), month, (Number) o[2]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Status");
    chart.setModel(cm);
    chart.setType("line");
    chart.setHeight("300");
    chart.setWidth((cm.getCategories().size() * 70 + 40) + "");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getTimelineByType()

DWChart org.turro.dossier.dw.DatawarehouseVM.getTimelineByType

(

IssueParticipantRole

role

)

Definition at line 301 of file DatawarehouseVM.java.

                                                              {
    SimpleCategoryModel cm = new SimpleCategoryModel();
    WhereClause wc = new WhereClause();
    wc.addClause("select concat(year(startDate), '-', month(startDate)), type, count(distinct issueId)");
    wc.addClause("from DWIssue");
    wc.addClause("where 1=1");
    addFilter(wc, "startDate", role);
    wc.addClause("group by concat(year(startDate), '-', month(startDate)), type");
    wc.addClause("order by concat(year(startDate), '-', month(startDate))");
    List<Object[]> results = getDao().getResultList(wc);
    for(Object o[] : results) {
      IssueType type = (IssueType) o[1];
      String month = (String) o[0];
      cm.setValue(type.toString(), month, (Number) o[2]);
    }
    DWChart chart = new DWChart();
    chart.setTitle("Type");
    chart.setModel(cm);
    chart.setType("line");
    chart.setHeight("300");
    chart.setWidth((cm.getCategories().size() * 70 + 40) + "");
    return chart;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

init()

void org.turro.dossier.dw.DatawarehouseVM.init

(

)

Definition at line 100 of file DatawarehouseVM.java.

                     {
    engine = new DWChartEngine();
    start = new CheckDate().addYears(-5).setDay(1).getDate();
    end = new CheckDate().addMonths(1).setDay(31).getDate();
    charts = new ArrayList<>();
    report = DWReportType.DW_TIMELINE;
  }

selectContact()

void org.turro.dossier.dw.DatawarehouseVM.selectContact

(

@BindingParam("contact") IContact

contact

)

Definition at line 129 of file DatawarehouseVM.java.

                                                                       {
    setContact(contact);
  }

Here is the call graph for this function:

selectEntity()

void org.turro.dossier.dw.DatawarehouseVM.selectEntity

(

@BindingParam("entity") Object

entity

)

Definition at line 114 of file DatawarehouseVM.java.

                                                                  {
    if(entity instanceof Category) {
      this.category = (Category) entity;
      this.dossier = null;
    } else if(entity instanceof Dossier) {
      this.dossier = (Dossier) entity;
      this.category = null;
    } else {
      this.dossier = null;
      this.category = null;
    }
  }

selectReport()

void org.turro.dossier.dw.DatawarehouseVM.selectReport

(

@BindingParam("type") DWReportType

type

)

Definition at line 135 of file DatawarehouseVM.java.

                                                                    {
    this.report = type;
  }

setCategory()

void org.turro.dossier.dw.DatawarehouseVM.setCategory

(

Category

category

)

Definition at line 79 of file DatawarehouseVM.java.

                                             {
    this.category = category;
  }

setContact()

void org.turro.dossier.dw.DatawarehouseVM.setContact

(

IContact

contact

)

Definition at line 95 of file DatawarehouseVM.java.

                                           {
    this.contact = contact;
  }

Here is the caller graph for this function:

setDossier()

void org.turro.dossier.dw.DatawarehouseVM.setDossier

(

Dossier

dossier

)

Definition at line 87 of file DatawarehouseVM.java.

                                          {
    this.dossier = dossier;
  }

setEnd()

void org.turro.dossier.dw.DatawarehouseVM.setEnd

(

Date

end

)

Definition at line 71 of file DatawarehouseVM.java.

                               {
    this.end = end;
  }

setStart()

void org.turro.dossier.dw.DatawarehouseVM.setStart

(

Date

start

)

Definition at line 63 of file DatawarehouseVM.java.

                                   {
    this.start = start;
  }

update()

void org.turro.dossier.dw.DatawarehouseVM.update

(

)

Definition at line 110 of file DatawarehouseVM.java.

{}

---

The documentation for this class was generated from the following file:

• DatawarehouseVM.java