edavis10 / redmine-customer-plugin

This is a Rails plugin for Redmine that can be used to track basic customer information

This URL has Read+Write access

redmine-customer-plugin / writeup.txt
100644 341 lines (267 sloc) 8.53 kb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
* Copy the sample plugin
* Clear out files
 
.
|-- README
|-- app
| |-- controllers
| |-- models
| `-- views
| `-- settings
|-- assets
| |-- images
| `-- stylesheets
|-- db
| `-- migrate
|-- init.rb
`-- lang
 
* Configure your basic init file
 
<pre>
# Redmine customer plugin
require 'redmine'
 
RAILS_DEFAULT_LOGGER.info 'Starting Customer plugin for RedMine'
 
Redmine::Plugin.register :customer do
  name 'Customer plugin'
  author 'Eric Davis'
  description 'This is a plugin for Redmine that can be used to track basic customer information'
  version '0.1.0'
end
</pre>
 
* Build your migration
* Migrate your database `rake db:migrate_plugins`
* Build a very basic Model so we can connect to the database
 
<pre>
class Customer < ActiveRecord::Base
end
</pre>
 
* Lets try the console and see if we can create a few customers
 
<pre>
$ script/console
Loading development environment (Rails 2.0.2)
GLoc v1.1 running in development mode. Strings can be modified at runtime.
>> Customer.create({:name => 'Eric Davis', :company => 'Little Stream Software', :address => 'Beaverton, OR', :phone => '888.499.2510', :website => 'http://www.littlestreamsoftware.com'})
=> #<Customer id: 2, name: "Eric Davis", company: "Little Stream Software", address: "Beaverton, OR", phone: "888.499.2510", email: nil, website: "http://www.littlestreamsoftware.com">
>> Customer.create({:name => 'Linux Torvalds', :company => 'Linux Foundation', :address => 'Portland, OR'})
=> #<Customer id: 3, name: "Linux Torvalds", company: "Linux Foundation", address: "Portland, OR", phone: nil, email: nil, website: nil>
>> exit
</pre>
 
* Lets hook up a controller to see who is assigned to a project. Index would work best
 
<pre>
class CustomersController < ApplicationController
  unloadable
  layout 'base'
  before_filter :find_project, :authorize
 
  def index
  end
 
  private
  def find_project
    @project=Project.find(params[:id])
  end
end
</pre>
 
* Need to add it to the Redmine init file now
 
<pre>
# Redmine customer plugin
require 'redmine'
 
RAILS_DEFAULT_LOGGER.info 'Starting Customer plugin for RedMine'
 
Redmine::Plugin.register :customer do
  name 'Customer plugin'
  author 'Eric Davis'
  description 'This is a plugin for Redmine that can be used to track basic customer information'
  version '0.1.0'
  
  project_module :customer_module do
    permission :index, {:customers => [:index]}, :public => true
  end
 
  menu :project_menu, "Customer", :controller => 'customers', :action => 'index'
end
</pre>
 
* Now we need a view file to render
  mkdir app/views/customers
 
<pre>
#app/views/customers/index.html.erb
<h1>Customer</h1>
 
</pre>
 
* Opps, we are missing the FKs from customers to projects. Since we can't modify the Project's file, we can only setup a HABTM relationship from one side.
 
<pre>
# Use rake db:migrate_plugins to migrate installed plugins
class LinkCustomersToProjects < ActiveRecord::Migration
  def self.up
    add_column :projects, :customer_id, :integer
  end
 
  def self.down
    remove_column :projects, :customer_id
  end
end
</pre>
 
<pre>
class Customer < ActiveRecord::Base
  has_many :projects
end
</pre>
 
* Migrate again to add the column
* Lets assign the customer to my project by hand. My customer id is 2
 
>> p = Project.find(16)
=> #<Project id: 16, name: "LSS - Business Time Tracking", description: "Business of running Little Stream, used to track t...", homepage: "", is_public: false, parent_id: nil, projects_count: 0, created_on: "2007-10-05 09:42:10", updated_on: "2007-10-10 20:13:22", identifier: "littlestream", status: 1, customer_id: nil>
>> p.customer_id = 2
=> 2
>> p.save
=> true
 
* Lets display it on our page now
 
<pre>
class CustomersController < ApplicationController
  unloadable
  layout 'base'
  before_filter :find_project, :authorize
 
  def index
    @customer = Customer.find_by_id(@project.customer_id)
  end
 
  private
  def find_project
    @project=Project.find(params[:id])
  end
end
</pre>
 
<pre>
<h1>Customer</h1>
 
<p> Name: <%= h @customer.name %> </p>
<p> Company: <%= h @customer.company %> </p>
<p> Address: <%= h @customer.address %> </p>
<p> Phone: <%= h @customer.phone %> </p>
<p> Website: <%= h @customer.website %> </p>
 
</pre>
(((redmine_customer_1.png)))
 
* It would be nice to be able to reassign the customer
<pre>
init.rb
    permission :edit, {:customers => [:edit]}, :public => true
</pre>
 
<pre>
  def edit
    case request.method
    when :post
      # Will fill out later
    when :get
      @customer = Customer.find_by_id(@project.customer_id)
    end
  end
</pre>
 
<pre>
<h3>Editing Customer</h3>
 
<% form_for :customer, :url =>{:action => 'edit', :id => @project} do |f| %>
 
<p>
  <label for="customer">Customer</label><br />
  <%= collection_select(:customer, :id, Customer.find(:all), :id, :name) -%>
</p>
 
<%= submit_tag "Save" -%>
 
<% end # form -%>
 
</pre>
 
* Now to hook up the reassignments
 
<pre>
  def edit
    case request.method
    when :post
      @project.customer_id = params[:customer][:id]
      if @project.save
        flash[:notice] = "Saved"
        redirect_to :action => "index", :id => params[:id]
      else
        flash[:notice] = "Could not save"
      end
    when :get
      @customer = Customer.find_by_id(@project.customer_id)
    end
  end
</pre>
 
* Add the ability to list and edit customer information itself
 
  project_module :customer_module do
    permission :index, {:customers => [:index]}, :public => true
    permission :edit, {:customers => [:edit]}, :public => true
    permission :list, {:customers => [:list]}, :public => true
    permission :edit_info, {:customers => [:edit_info]}, :public => true
  end
 
<p><%= link_to "Edit", :controller => 'customers', :action => 'edit', :id => @project -%></p>
<p><%= link_to "List", :controller => 'customers', :action => 'list', :id => @project -%></p>
 
 
  def list
    @customers = Customer.find(:all)
  end
 
<h1>Customer List</h1>
 
<ul>
<% @customers.each do |customer| -%>
<li><%= link_to customer.name, 'edit_info', :id => @project, :customer_id => customer.id -%> from <%= h customer.company -%></li>
<% end -%>
</ul>
 
* Editing a customer record
 
  def edit_info
    case request.method
    when :post
      # Will add later
    when :get
      @customer = Customer.find_by_id(params[:customer_id])
    end
  end
 
<h3>Editing Customer Information</h3>
 
<% form_for :customer, :url =>{:action => 'edit_info', :id => @project} do |f| %>
 
<%= f.hidden_field 'id' -%>
 
<p>
  <label for="customer_name">Name</label><br />
  <%= f.text_field 'name' -%>
</p>
<p>
  <label for="customer_company">Company</label><br />
  <%= f.text_field 'company' -%>
</p>
<p>
  <label for="customer_address">Address</label><br />
  <%= f.text_area 'address' -%>
</p>
<p>
  <label for="customer_phone">Phone</label><br />
  <%= f.text_field 'phone' -%>
</p>
<p>
  <label for="customer_email">Email</label><br />
  <%= f.text_field 'email' -%>
</p>
<p>
  <label for="customer_website">Website</label><br />
  <%= f.text_field 'website' -%>
</p>
 
             
<%= submit_tag "Save" -%>
 
<% end # form -%>
 
* Saving an edited customer record
 
  def edit_info
    case request.method
    when :post
      @customer = Customer.find_by_id(params[:customer][:id])
      if @customer.nil?
        # New record
        @customer = Customer.new(params[:customer])
      end
      if @customer.update_attributes(params[:customer])
        flash[:notice] = "Saved"
        redirect_to :action => "list", :id => params[:id]
      else
        flash[:notice] = "Could not save"
      end
 
    when :get
      @customer = Customer.find_by_id(params[:customer_id])
    end
  end
 
* Adding a new customer
 
<%= link_to "New Customer", :action => 'edit_info', :id => @project %>
 
* Security
 
  project_module :customer_module do
    permission :view_customer, {:customers => [:index]}
    permission :assign_customer, {:customers => [:edit]}
    permission :see_customer_list, {:customers => [:list]}
    permission :edit_customer, {:customers => [:edit_info]}
  end
 
link_to_if_authorized
 
* Simple menu
 
<%= render(:partial => 'menu') %>
 
 
<p>
  <strong>Menu:</strong>
  <%= link_to_if_authorized "View", :controller => 'customers', :action => 'index', :id => @project -%>
  <%= link_to_if_authorized "Assign", :controller => 'customers', :action => 'edit', :id => @project -%>
  <%= link_to_if_authorized "List", :controller => 'customers', :action => 'list', :id => @project -%>
  <%= link_to_if_authorized "New", :action => 'edit_info', :id => @project %>
</p>