Aronyu127

def export_school_student(file_path, school_name)
  CSV.open(file_path, "wb") do |csv|
    csv << ['學校', '學號', '姓名', 'email', '提交回報次數', '提交回報案數', '提交回報法官數']
    CourtObserver.where(school: "#{school_name}").each do |c|
      observer_array = [c.school, c.student_number, c.name, c.email, c.schedule_scores.count, c.schedule_scores.map(&:story_id).uniq.count, c.schedule_scores.map(&:judge_id).uniq.count]
      csv << observer_array
    end
  end
end

Aronyu127

class Transfer
  attr_reader :unknow_profile

  def initialize
    @educations_count = 0
    @careers_count = 0
    @licenses_count = 0
    @awards_count = 0
    @punishments_count = 0
    @reviews_count = 0

Aronyu127

total = Story.all.size
Story.find_each(batch_size: 2000).with_index do |s ,i|
  Story.reset_counters(s.id, :schedules)
  puts "#{i} / #{total}" if  i % 10000 == 0
end

Aronyu127

story_ids = Story.where(story_type: nil).pluck(:id)
success_story_ids = []
fail_story_ids = []


def get_story_type(story)
  url = story.verdict ? story.verdict.file.url : story.rules.last.file.url
  uri = URI.parse('https:' + url)
  str = uri.read
  nokogiri_data = Nokogiri::HTML(str.force_encoding('UTF-8'))

Aronyu127

verdict_ids = []

def get_hash(url)
  uri = URI.parse('https:' + url)
  str = uri.read
  eval(str.force_encoding(Encoding::UTF_8))
end

def generate_tempfile(data, file_name)
  file = Tempfile.new([file_name, ".json"], "#{Rails.root}/tmp/")

Aronyu127

Banner.all.map do |b|
  image_url = 'http:' + b.pic_l.url
  b.remote_pic_url = image_url
  b.title = '臨時標題'
  b.link = 'http//example.com'
  b.save
end