Redmine

  def issues_burndown_chart_data(version)

    return nil if version.visible_fixed_issues.empty?

    chart_start_date = (version.start_date || version.created_on).to_date

    chart_end_date = [version.due_date, version.visible_fixed_issues.maximum(:due_date), version.visible_fixed_issues.maximum(:updated_on)].compact.max.to_date

    line_end_date = [User.current.today, chart_end_date].min

    step_size = ((chart_start_date..chart_end_date).count.to_f / 90).ceil

    issues = version.visible_fixed_issues

    return nil if step_size < 1

    total_closed = chart_start_date.step(line_end_date, step_size).collect{|d| {:t => d.to_s, :y => issues.where("#{Issue.table_name}.closed_on IS NULL OR #{Issue.table_name}.closed_on>=?", d.end_of_day).count}}

    open = chart_start_date.step(line_end_date, step_size).collect{|d| {:t => d.to_s, :y => issues.where("#{Issue.table_name}.created_on<=?", d.end_of_day).count - issues.open(false).where("#{Issue.table_name}.closed_on<=?", d.end_of_day).count}}

    chart_data = {

      :labels => chart_start_date.step(chart_end_date, step_size).collect{|d|d.to_s},

      :datasets => [

        {:label => l(:label_ideal), :data => [{:t => chart_start_date.to_s, :y => total_closed.first[:y]}, {:t => chart_end_date.to_s, :y => 0}],

         :backgroundColor => "rgba(0, 0, 0, 0)",

         :lineTension => 0, :borderWidth => 2, :borderDash => [5, 2], :spanGaps => true},

        {:label => l(:label_total_substract_closed), :data => total_closed,

         :borderColor => "rgba(186, 224, 186, 1)", :backgroundColor => "rgba(0, 0, 0, 0)", :pointBackgroundColor => "rgba(186, 224, 186, 1)",

         :lineTension => 0, :borderWidth => 2, :borderDash => [5, 2]},

        {:label => l(:label_open), :data => open,

         :borderColor => "rgba(186, 224, 186, 1)", :backgroundColor => "rgba(186, 224, 186, 0.1)", :pointBackgroundColor => "rgba(186, 224, 186, 1)",

         :lineTension => 0, :borderWidth => 2}

      ]

    }

    return chart_data

  end

<div class="version-report-graph">

  <canvas id="version_chart"></canvas>

</div>

<% if chart_data = issues_burndown_chart_data(@version) %>

  <%= javascript_tag do %>

  function renderChart(canvas_id, title, y_label, chartData){

    new Chart($(canvas_id), {

      type: 'line',

      data: chartData,

      options: {

        responsive: true,

        legend: {

          position: 'right',

          labels: { boxWidth: 20, fontSize: 10, padding: 10 }

        },

        title: { display: true, text: title },

        tooltips: {

          callbacks: {

            title: function(tooltipItem, data) { return '' }

          }

        },

        scales: {

          xAxes: [{

            type: "time",

            time: { unit: "day", displayFormats: { day: 'YYYY-MM-DD' } },

            gridLines: { borderDash: [6, 4] },

            ticks: { source: 'labels', autoSkip: true }

          }],

          yAxes: [{

            scaleLabel: { display: true, labelString: y_label },

            gridLines: { borderDash: [6, 4] },

            ticks: { min: 0, max: <%= @version.fixed_issues.count %>, stepSize: 1 }

          }]

        }

      }

    });

  }

  $(document).ready(function(){

    var title = "<%= l(:label_issues_burndown) %>";

    var y_label = "<%= l(:label_issues_burndown_y_label) %>";

    var chartData = <%= chart_data.to_json.html_safe %>;

    renderChart("#version_chart", title, y_label, chartData);

  });

  <% end %>

  <% content_for :header_tags do %>

    <%= javascript_include_tag "Chart.bundle.min" %>

  <% end %>

<% end %>

  label_issues_burndown: burndown

  label_issues_burndown_y_label: Number of Issues

  label_ideal: Ideal

  label_total_substract_closed: Total - Closed

  label_open: Open

body.controller-versions.action-show div#roadmap .version-report-graph { width: 70%; margin: 2em 0 }

  body.controller-versions.action-show div#roadmap .version-report-graph {width:100%;}

           :enumerations,

  def test_issues_burndown_chart_data_should_return_chart_data

    User.any_instance.stubs(:today).returns(3.days.after.to_date)

    version = Version.create!(:project => Project.find(1), :name => 'test', :due_date => 5.days.after.to_date)

    issue = Issue.create!(:project => version.project, :fixed_version => version,

                          :priority => IssuePriority.find_by_name('Normal'),

                          :tracker => version.project.trackers.first, :subject => 'text', :author => User.current,

                          :start_date => 1.days.after.to_date)

    chart_data = {

      :labels => (1.days.after.to_date..5.days.after.to_date).map { |d| d.to_s },

      :datasets => [

        {:label => l(:label_ideal), :data => [{:t => 1.days.after.to_date.to_s, :y => 1}, {:t => 5.days.after.to_date.to_s, :y => 0}],

         :backgroundColor => "rgba(0, 0, 0, 0)",

         :lineTension => 0, :borderWidth => 2, :borderDash => [5, 2], :spanGaps => true},

         {:label => l(:label_total_substract_closed), :data => [{:t => 1.days.after.to_date.to_s, :y => 1}, {:t => 2.days.after.to_date.to_s, :y => 1}, {:t => 3.days.after.to_date.to_s, :y => 1}],

         :borderColor => "rgba(186, 224, 186, 1)", :backgroundColor => "rgba(0, 0, 0, 0)", :pointBackgroundColor => "rgba(186, 224, 186, 1)",

         :lineTension => 0, :borderWidth => 2, :borderDash => [5, 2]},

         {:label => l(:label_open), :data => [{:t => 1.days.after.to_date.to_s, :y => 1}, {:t => 2.days.after.to_date.to_s, :y => 1}, {:t => 3.days.after.to_date.to_s, :y => 1}],

         :borderColor => "rgba(186, 224, 186, 1)", :backgroundColor => "rgba(186, 224, 186, 0.1)", :pointBackgroundColor => "rgba(186, 224, 186, 1)",

         :lineTension => 0, :borderWidth => 2}

      ]

    }

    assert_equal chart_data, issues_burndown_chart_data(version)

  end

  def test_issues_burndown_chart_data_should_return_nil_when_visible_fixed_issues_empty

    version = Version.create!(:project => Project.find(1), :name => 'test')

    version.visible_fixed_issues.destroy_all

    assert_empty version.visible_fixed_issues

    assert_nil issues_burndown_chart_data(version)

  end

  def test_issues_burndown_chart_data_should_return_nil_when_order_of_start_date_and_due_date_is_reversed

    version = Version.create!(:project => Project.find(1), :name => 'test', :due_date => 10.days.after)

    issue = Issue.create!(:project => version.project, :fixed_version => version,

                          :priority => IssuePriority.find_by_name('Normal'),

                          :tracker => version.project.trackers.first, :subject => 'text', :author => User.current,

                          :start_date => 11.days.after)

    assert_nil issues_burndown_chart_data(version)

  end