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