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.6"

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



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

def self.export_item_html( items , title , subtitle )
  s=""
  if( title != nil )
    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>" 
  return s
end

.list_assigned_person(items) ⇒ Object

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

list item assigned person.

Args

items

アイテムの配列

Return

array of the assigned persons 担当になっている人の配列



213
214
215
216
217
218
219
220
221
 
# File 'lib/exceler.rb', line 213

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
 
# 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|  
      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

array of the items which is asseigned to the sepecified person 担当に割あたっているアイテムの配列



233
234
235
236
237
238
239
240
241
 
# File 'lib/exceler.rb', line 233

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

array of the expired items 期限切れになっているアイテムの配列



270
271
272
273
274
275
276
277
278
279
280
281
282
283
 
# File 'lib/exceler.rb', line 270

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

array of the incomplete items 未完了アイテムの配列



252
253
254
255
256
257
258
259
260
 
# File 'lib/exceler.rb', line 252

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

アイテムの配列



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

def self.scan_items( files , opt )
  ret = []
  if( opt == nil )
    return nil
  end
  for file in files
    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 )
            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 )
        end
      end
    end
  end
  return ret
end

.show_item(item) ⇒ Object 



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

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
end

.write_csv_file(file, map) ⇒ Object

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

Args

file

output file

map

map object

Return

HTML Content



364
365
366
367
368
369
370
371
372
373
374
375
376
377
 
# File 'lib/exceler.rb', line 364

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



346
347
348
349
350
351
352
353
354
355
 
# File 'lib/exceler.rb', line 346

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