Module: Exceler

Defined in:
lib/exceler.rb,
lib/exceler/version.rb

Defined Under Namespace

Classes: Item, ScanOption

Constant Summary collapse

XLS = 
"xls"
XLSX = 
"xlsx"
EXT_PATTERNS = 
[ XLS , XLSX ]
DEFAULT_CSS = 
"<style type='text/css'>
	.exceler-title h3 {
	color : blue;
}
.exceler-table {
	border-collapse: collapse;
	background-color: #ccf;
	width : 100%;
	border : 1px solid #888;
}
.exceler-table tr {
	border : 1px solid #888;
}
.exceler-table td {
	border : 1px solid #888;
}
</style>"
VERSION = 
"0.9.4"

Class Method Summary collapse

Class Method Details

.export_item_html(items, title, subtitle) ⇒ Object

タスクの状況をHTMLにする。transform task status to html string.

Args

items

アイテムの配列

Return

HTML Content



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
 
# File 'lib/exceler.rb', line 299

def self.export_item_html( items , title , subtitle )
	s=""
	if( title != nil )
		puts "!!"
		s+="<p class='exceler-title'><h3>"+title+ "-"
		if( subtitle != nil )
			s+=subtitle+ ":" + items.length.to_s
		end
		s+="</h3><br>"
	end
	s += "<table class='exceler-table'>"
	for item in items
		s+="<tr>"
		if( item.file != nil )
			s+=( "<td>"+ item.file + "</td>" )
		end
		if( item.content != nil )
			s+=( "<td>"+ item.content.to_s + "</td>" )
		end
		if( item.limit != nil )
			s+=( "<td>"+ item.limit.to_s + "</td>" )
		end
		s+="</td>"
	end
	s+= "</table>"
	s+= "</p>"	
	# puts "------"
	# puts s	
	return s
end

.list_assigned_person(items) ⇒ Object

渡されたアイテムのうち、割り当てられた人を一覧します。

list item assigned person.

Args

items

アイテムの配列

Return

担当に割あたっている人の配列



219
220
221
222
223
224
225
226
227
 
# File 'lib/exceler.rb', line 219

def self.list_assigned_person( items )
	pl = {}
	for item in items
		if( item.assign != nil )
			pl[item.assign] = item
		end
	end
	return pl.keys
end

.list_files(dir) ⇒ Object

指定されたディレクトリからファイル(.xls,.xlsx)を取得しますfind Excel files from the specified directory

Args

dir

エクセルファイルを検索するディレクトリ

Return

エクセルファイルの名前の配列



84
85
86
87
88
89
90
91
92
93
94
 
# File 'lib/exceler.rb', line 84

def self.list_files( dir )
	ret = [];
	for ext in EXT_PATTERNS
		filepattern = dir+File::SEPARATOR+"*."+ext;
		Dir[filepattern].each do |file|  
#				puts "founds " + file
			ret.push( file )
		end
	end
	return ret
end

.pickup_assigned(items, assign) ⇒ Object

渡されたアイテムのうち、特定の人に割り当てられたアイテムをピックアップします。

pickup specified person assigned items from the specified items

Args

items

アイテムの配列

assign

担当

Return

担当に割あたっているアイテムの配列



239
240
241
242
243
244
245
246
247
 
# File 'lib/exceler.rb', line 239

def self.pickup_assigned( items , assign )
	ret = []
	for item in items
		if( item.assign == assign )
			ret.push( item )
		end
	end
	return ret
end

.pickup_expired(items) ⇒ Object

期限切れのアイテムを探しますpickup limit exceeded items from the specified items

Args

items

アイテムの配列

Return

期限切れになっているアイテムの配列



275
276
277
278
279
280
281
282
283
284
285
286
287
288
 
# File 'lib/exceler.rb', line 275

def self.pickup_expired( items )
	ret = []
	current = Date.today
	incomplete = pickup_incomplete( items )
	for item in incomplete
		if( item.limit != nil )
			# puts item.limit.strftime("%Y/%m/%d")+"-"+current.strftime("%Y/%m%d")
			if( item.limit < current )
				ret.push(item)
			end
		end
	end
	return ret
end

.pickup_incomplete(items) ⇒ Object

渡されたアイテムのうち未完了のアイテムをピックアップします。pickup incompleted items from the specified items

Args

items

アイテムの配列

Return

未完了アイテムの配列



257
258
259
260
261
262
263
264
265
 
# File 'lib/exceler.rb', line 257

def self.pickup_incomplete( items )
	ret = []
	for item in items
		if( item.state == Item::INCOMPLETE )
			ret.push( item )
		end
	end
	return ret
end

.scan_items(files, opt) ⇒ Object

Args

files

エクセルファイルの配列

opt

検索時のオプション、ScanOptionオブジェクト

Return

アイテムの配列



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
 
# File 'lib/exceler.rb', line 129

def self.scan_items( files , opt )
	ret = []
	if( opt == nil )
		return nil
	end
	for file in files
		puts file
		re = Regexp.new( XLS+"$" )
		if( file =~ re ) # XLS file
			# puts "XLS file scan " + file
			s = Roo::Excel.new(file)
		else	#XLSX file
			# puts "XLSX file scan"+file
			s = Roo::Excelx.new(file) 
		end

		for sheet in s.sheets
			# if sheet option is nil then scan all sheets
			# else scan only one sheet that has the specified sheet name. 
			if( opt.sheet != nil )
				if( opt.sheet != sheet )
					next
				end
			end

			s.default_sheet = sheet
			if( s.first_row == nil )
				next
			else
				header = s.first_row
			end
			if( opt.header >= header )
				header = opt.header
			end
			(header..s.last_row).each do |num|
				c = s.cell( opt.id_row , num )
				if( c != nil )
					i = Item.new
					i.file = file
					i.id = s.cell( opt.id_row, num )
					if( opt.content_row != nil )
						i.content = s.cell( opt.content_row ,num )
					end
					if( opt.assign_row != nil )
						i.assign = s.cell( opt.assign_row , num )
						i.assign.strip!
					end
					if( opt.start_row != nil )
						i.start = s.cell( opt.start_row , num )
					end
					if( opt.limit_row != nil )
						i.limit = s.cell( opt.limit_row , num )
					end
					if( opt.state_row != nil )
						puts opt.state_row
						if( opt.state_condition == nil )
							if( s.cell( opt.state_row , num ) != nil )
								i.state = Item::COMPLETE
							else
								i.state = Item::INCOMPLETE
							end
						else
							if( s.cell( opt.state_row ,num ) == opt.state_condition )
								i.state = Item::COMPLETE
							else
								i.state = Item::INCOMPLETE
							end
						end
					end
					show_item( i )
					ret.push( i )
				else
					puts "skip!!"
				end
			end
		end
	end
	return ret
end

.show_item(item) ⇒ Object 



99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
 
# File 'lib/exceler.rb', line 99

def self.show_item( item )
	s = ""
	if( item.assign != nil )
		s += ("assign:" + item.assign + "," )
	end
	if( item.start != nil )
		s += ( "start:" + item.start.strftime("%Y/%m/%d") + "," )
	end
	if( item.limit != nil )
		s += ( "limit:" + item.limit.strftime("%Y/%m/%d") + "," )
	end
	if( item.state != nil )
		if( item.state == Item::COMPLETE )
			s += ( "state: complete ")
		else
			s += "state: incomplete"
		end
	end
	puts s
end

.write_csv_file(file, map) ⇒ Object

マップオブジェクトをCSVをにして保存します。

Args

file

output file

content

Content of the file

Return

HTML Content



375
376
377
378
379
380
381
382
383
384
385
386
387
388
 
# File 'lib/exceler.rb', line 375

def self.write_csv_file( file , map )
	keys = map.keys
	ks = ""
	vs = ""
	for key in keys
			ks += (key	 + ",")
			vs += (map[key].to_s + "," )
	end
	f = open( file , "w" )
	f.puts( ks )
	f.puts( vs )
	f.flush()
	f.close()
end

.write_html_file(file, content, css) ⇒ Object

作成したHTMLファイルコンテンツにCSSを埋め込んで保存します。

Args

file

output file

content

Content of the file

Return

HTML Content



356
357
358
359
360
361
362
363
364
365
 
# File 'lib/exceler.rb', line 356

def self.write_html_file( file , content , css )
	f = open( file , "w" )
	if( css == nil )
		css = DEFAULT_CSS
	end
	f.puts( DEFAULT_CSS )
	f.puts( content )
	f.flush()
	f.close()
end