module GetIssues

Constants

VERSION

Public Class Methods

init_header_style() click to toggle source

定义xlsx文件格式的头样式

# File lib/get_issues.rb, line 39
def self.init_header_style
  { height: 75, background_color: "458B00", color: "FFFFFF", align: :center, font_name: "Arial", font_size: 14, bold: false, italic: false, underline: false }
end
init_row_style() click to toggle source

定义xlsx文件的row样式

# File lib/get_issues.rb, line 44
def self.init_row_style
  { font_size: 12, align: :left }
end
start(prefix_url, private_token, project_name, mile_stone_title) click to toggle source
# File lib/get_issues.rb, line 7
def self.start(prefix_url, private_token, project_name, mile_stone_title)
  projects_string = `curl --header "PRIVATE-TOKEN: #{private_token}" "#{prefix_url}"`
  projects_json = JSON.parse(projects_string)
  project_json = projects_json.filter { |t| t["name"] == project_name }&.first
  project_id = project_json["id"]

  milestones_string = `curl --header "PRIVATE-TOKEN: #{private_token}" "#{prefix_url}/#{project_id}/milestones"`
  milestones_json = JSON.parse(milestones_string)
  mile_stone_json = milestones_json.filter { |t| t["title"] == mile_stone_title }&.first
  mile_stone_id = mile_stone_json["id"]

  issues_string = `curl --header "PRIVATE-TOKEN: #{private_token}" "#{prefix_url}/#{project_id}/milestones/#{mile_stone_id}/issues?per_page=10000"`
  issues_json = JSON.parse(issues_string)
  issues_json
end
to_xlsx(prefix_url, private_token, project_name, mile_stone_title) click to toggle source
# File lib/get_issues.rb, line 23
def self.to_xlsx(prefix_url, private_token, project_name, mile_stone_title)
  issues_json = start(prefix_url, private_token, project_name, mile_stone_title)
  data = []
  issues_json.each do |issue|
    assignes_names = issue["assignees"]&.map { |t| t["name"]&.split(" ")&.reverse&.join("") }&.join(",")
    milestone = issue["milestone"]["title"] rescue ""
    data << ["##{issue["iid"]}",issue["title"], assignes_names, issue["labels"]&.join(","), milestone]
  end
  headers = %w(编号 标题 负责人 标签 归属端)
  options = { headers: headers, data: data, header_style: init_header_style, row_style: init_row_style }
  file_data = SpreadsheetArchitect.to_xlsx(options)
  file = File.open("#{mile_stone_title}.xlsx".to_s, "wb+") do |f|
    f.write file_data
  end
end