233 lines
6.9 KiB
Plaintext
233 lines
6.9 KiB
Plaintext
# encoding: utf-8
|
|
|
|
require 'nokogiri'
|
|
|
|
wb = xlsx_package.workbook
|
|
|
|
wb.add_worksheet(name: "News") do |sheet|
|
|
|
|
heading = sheet.styles.add_style(:b => true, :locked => true)
|
|
example = sheet.styles.add_style(:i => true)
|
|
row = []
|
|
row1 = []
|
|
row2 = []
|
|
|
|
row << t("category")
|
|
row1 << "select"
|
|
t = ""
|
|
categories = @module_app.categories.asc(:created_at)
|
|
categories.each_with_index do |cat,i|
|
|
t = t + "#{i}" + " -> " + cat.title + ", "
|
|
end
|
|
if categories.count > 0
|
|
t = t + " Example : 0"
|
|
else
|
|
t = "Leave this field blank"
|
|
end
|
|
row2 << t
|
|
|
|
row << t("tags")
|
|
row1 << "select"
|
|
t = ""
|
|
tags = @module_app.tags.asc(:created_at)
|
|
tags.each_with_index do |tag,i|
|
|
t = t + "#{i}" + " -> " + tag.name + ", "
|
|
end
|
|
if tags.count > 0
|
|
t = t + " Example : 0,1,2"
|
|
else
|
|
t = "Leave this field blank"
|
|
end
|
|
row2 << t
|
|
|
|
row << t("start_date")
|
|
row1 << "datetime"
|
|
row2 << "Format: YYYY/MM/DD hh:mm, Example: 2015/12/10 00:00"
|
|
|
|
row << t("end_date")
|
|
row1 << "datetime"
|
|
row2 << "Format: YYYY/MM/DD hh:mm, Example: 2015/12/12 00:00"
|
|
|
|
row << t("top")
|
|
row1 << "boolean"
|
|
row2 << "0 for false, 1 for true"
|
|
|
|
row << t("hot")
|
|
row1 << "boolean"
|
|
row2 << "0 for false, 1 for true"
|
|
|
|
row << t("hide")
|
|
row1 << "boolean"
|
|
row2 << "0 for false, 1 for true "
|
|
|
|
row << t("image")
|
|
row1 << "url"
|
|
row2 << "http://www.example.com/images/example.png"
|
|
|
|
row << t("image") + " " + t("description") + " - " + t("en")
|
|
row1 << "textfield"
|
|
row2 << ""
|
|
row << t("image") + " " + t("description") + " - " + t("zh_tw")
|
|
row1 << "textfield"
|
|
row2 << ""
|
|
|
|
row << t("title") + " - " + t("en")
|
|
row1 << "textfield"
|
|
row2 << ""
|
|
row << t("title") + " - " + t("zh_tw")
|
|
row1 << "textfield"
|
|
row2 << ""
|
|
|
|
row << t("subtitle") + " - " + t("en")
|
|
row1 << "textarea"
|
|
row2 << ""
|
|
row << t("subtitle") + " - " + t("zh_tw")
|
|
row1 << "textarea"
|
|
row2 << ""
|
|
|
|
row << t("content") + " - " + t("en")
|
|
row1 << "editor"
|
|
row2 << ""
|
|
row << t("content") + " - " + t("zh_tw")
|
|
row1 << "editor"
|
|
row2 << ""
|
|
|
|
row << t("link")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';'. Example: http://rulingcom.com; http://google.com"
|
|
|
|
row << t("link") + " " + t("url_alt") + " - " + t("en")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : Rulingcom official site; Google search engine"
|
|
row << t("link") + " " + t("url_alt") + " - " + t("zh_tw")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : Rulingcom official site; Google search engine"
|
|
|
|
row << t("file_")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';'. Example: http://www.example.com/images/example.png; http://www.example.com/images/example2.png"
|
|
|
|
row << t("file_") + " " + t("description") + " - " + t("en")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : Great view; Nice potrait"
|
|
row << t("file_") + " " + t("description") + " - " + t("zh_tw")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : Great view; Nice potrait"
|
|
|
|
row << t("file_") + " " + t("alternative") + " - " + t("en")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : example1; example2"
|
|
row << t("file_") + " " + t("alternative") + " - " + t("zh_tw")
|
|
row1 << "textfield"
|
|
row2 << "Seperate with ';' with respective to the links in the link columns. Example : example1; example2"
|
|
|
|
|
|
row << t("news.unit")
|
|
row1 << "textfield"
|
|
row2 << "Unit - Department"
|
|
|
|
row << t("view_count")
|
|
row1 << "integer"
|
|
row2 << ""
|
|
|
|
sheet.add_row row, :style => heading
|
|
sheet.add_row row1
|
|
sheet.add_row row2, :style => example
|
|
if @thread
|
|
all_count = @news.count
|
|
puts_every_count = [all_count * 3 / 100, 1].max
|
|
current_count = 0
|
|
finish_percent = 0
|
|
@thread.update(:status=>{:status=>'Processing','all_count'=>all_count,'current_count'=>current_count,'finish_percent'=>finish_percent})
|
|
end
|
|
@news.each do |anns|
|
|
row = []
|
|
row << categories.to_a.index(anns.category)
|
|
t = []
|
|
anns.tags.each do |tag|
|
|
t << tags.to_a.index(tag)
|
|
end
|
|
row << t.join(",")
|
|
row << (anns.postdate.strftime("%Y/%m/%d %H:%M") rescue "")
|
|
row << (anns.deadline.strftime("%Y/%m/%d %H:%M") rescue "")
|
|
row << (anns.is_top? ? 1 : 0)
|
|
row << (anns.is_hot? ? 1 : 0)
|
|
row << (anns.is_hidden? ? 1 : 0)
|
|
image_url = anns.image.url rescue ""
|
|
row << (image_url.blank? ? "" : (@host + image_url))
|
|
row << anns.image_description_translations["en"]
|
|
row << anns.image_description_translations["zh_tw"]
|
|
row << anns.title_translations["en"]
|
|
row << anns.title_translations["zh_tw"]
|
|
row << anns.subtitle_translations["en"]
|
|
row << anns.subtitle_translations["zh_tw"]
|
|
["en", "zh_tw"].each do |l|
|
|
text = anns.text_translations[l]
|
|
doc = Nokogiri::HTML.fragment(text)
|
|
doc.css('[src]').each do |el|
|
|
src = el.attributes['src'].value.to_s rescue ""
|
|
if src.match(/^\/([^\/]|$)/)
|
|
src = @host + src
|
|
el.attributes['src'].value = src
|
|
end
|
|
end
|
|
doc.css('[href]').each do |el|
|
|
href = el.attributes['href'].value.to_s rescue ""
|
|
if href.match(/^\/([^\/]|$)/)
|
|
href = @host + href
|
|
el.attributes['href'].value = href
|
|
end
|
|
end
|
|
row << doc.to_s
|
|
end
|
|
|
|
links = anns.news_bulletin_links.asc(:created_at)
|
|
t = links.collect{|l|l.url}
|
|
row << t.join(";")
|
|
t = links.collect{|l|l.title_translations["en"]}
|
|
row << t.join(";")
|
|
t = links.collect{|l|l.title_translations["zh_tw"]}
|
|
row << t.join(";")
|
|
|
|
files = anns.news_bulletin_files.asc(:created_at)
|
|
t = files.collect{|f|(@host + f.file.url rescue nil)}
|
|
t.delete(nil)
|
|
row << t.join(";")
|
|
t = files.collect{|l|l.description_translations["en"]}
|
|
row << t.join(";")
|
|
t = files.collect{|l|l.description_translations["zh_tw"]}
|
|
row << t.join(";")
|
|
t = files.collect{|l|l.title_translations["en"]}
|
|
row << t.join(";")
|
|
t = files.collect{|l|l.title_translations["zh_tw"]}
|
|
row << t.join(";")
|
|
|
|
tmp_unit = ""
|
|
Unit.where({:id => anns.unit_id}).each do |u|
|
|
tmp_unit += u.name
|
|
end
|
|
Department.where({:id => anns.department_id}).each do |d|
|
|
tmp_unit += "-#{d.name}"
|
|
end
|
|
row << tmp_unit
|
|
|
|
row << anns.view_count.to_s
|
|
|
|
sheet.add_row row
|
|
if @thread
|
|
current_count += 1
|
|
if current_count % puts_every_count == 0
|
|
finish_percent = (current_count * 100.0 / all_count).round(1)
|
|
@thread.update(:status=>{:status=>'Processing','all_count'=>all_count,'current_count'=>current_count,'finish_percent'=>finish_percent})
|
|
end
|
|
end
|
|
end
|
|
if @thread
|
|
finish_percent = 100
|
|
@thread.update(:status=>{:status=>'finish','all_count'=>all_count,'current_count'=>current_count,'finish_percent'=>finish_percent})
|
|
end
|
|
|
|
|
|
|
|
|
|
end |