redmine中增加查询三步走

假设有视图tasklists

(1)增加数据映射，在models中增加文件tasklist.rb:

class Tasklist < ActiveRecord::Base

end

(2)增加控制类及控制映射

A)controllers目录下增加tasklists_controller.rb:

class TasklistsController < ApplicationController

  # GET /monthworks

  # GET /monthworks.json

  def index

    

    @tasklists = Tasklist.find(:all)

    respond_to do |format|

      format.html # index.html.erb

      format.json { render json: @tasklists }

    end

  end

 end

B)routes.rb中增加控制映射

  resources :tasklists

（3）增加视图类

在views中tasklists增加文件index.html.erb

<h1>月度任务量</h1>

<table class="list issues">

  <tr>

    <th class="checkbox hide-when-print">人员</th>

    <th class="checkbox hide-when-print">总任务</th>

    <th class="checkbox hide-when-print">完成任务</th>

   <th class="checkbox hide-when-print">延迟任务</th>

   <th class="checkbox hide-when-print">计划工时</th>

   <th class="checkbox hide-when-print">实际工时</th>

   <th class="checkbox hide-when-print">任务完成质量</th>

  </tr>

<% @tasklists.each do |tasklist| %>

  <tr  class="hascontextmenu odd issue status-1 priority-2 priority-default created-by-me">

    <td  class="project"><%= tasklist.lastname %><%= tasklist.firstname %></td>

    <td class="project"><%= tasklist.tasknum %></td>

    <td class="project"><%= tasklist.donetasknum %></td>

    <td class="project"><%= tasklist.latetasknum %></td>

    <td class="project"><%= tasklist.sworktime %></td>

    <td class="project"><%= tasklist.aworktime %></td>

    <td class="project"><%= tasklist.taskq %></td>

  </tr>

<% end %>

</table>

<br />

 

OK，搞定，访问http://220.178.25.130:8088/redmine/tasklists即可看到成果