Tấn Trần Thanh · @tantt · Hoang Phuc Do · Hoang Phuc Do · Hoang Phuc Do · Tấn Trần Thanh
--- a/plugins/workflow_report/README.rdoc 0 → 100755
+++ b/plugins/workflow_report/README.rdoc 0 → 100755
+= workflow_report
+
+Description goes here
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+class WorkflowReportController < ApplicationController
+
+  def index
+    @thead = ['root_id', 'project', 'subject', 'target_version', ' created_on ', ' closed_on ', ' due_date ', ' status ', ' Estimated_hours (*final version) ', 'Actual time', 'Diff', 'Estimated_hours (*Initial version)',
+              'Number of estimation changes', 'Note of estimation changes', '1. Requirement', '2. Design', '3. Coding', '4. Testing', '5. Bug fixing', '6. Release', 'Others', '1. Requirement', '2. Design', '3. Coding',
+              '4. Testing', '5. Bug fixing', '6. Release', 'Others', 'testcases', 'vn STG bug', 'Jp STG bug', 'Production', 'Issue', 'Issue comment', 'PR comment', 'Review comment', 'Commits', 'File changed', 'Addtion', 'Deletetion']
+    github = Github.new oauth_token: "your github token"
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+class WorkflowReportController < ApplicationController
+
+  def index
+    @thead = ['root_id', 'project', 'subject', 'target_version', ' created_on ', ' closed_on ', ' due_date ', ' status ', ' Estimated_hours (*final version) ', 'Actual time', 'Diff', 'Estimated_hours (*Initial version)',
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+class WorkflowReportController < ApplicationController
+
+  def index
+    @thead = ['root_id', 'project', 'subject', 'target_version', ' created_on ', ' closed_on ', ' due_date ', ' status ', ' Estimated_hours (*final version) ', 'Actual time', 'Diff', 'Estimated_hours (*Initial version)',
+              'Number of estimation changes', 'Note of estimation changes', '1. Requirement', '2. Design', '3. Coding', '4. Testing', '5. Bug fixing', '6. Release', 'Others', '1. Requirement', '2. Design', '3. Coding',
+              '4. Testing', '5. Bug fixing', '6. Release', 'Others', 'testcases', 'vn STG bug', 'Jp STG bug', 'Production', 'Issue', 'Issue comment', 'PR comment', 'Review comment', 'Commits', 'File changed', 'Addtion', 'Deletetion']
+    github = Github.new oauth_token: "your github token"
+    kuruma_project_ids = [139, 138, 94, 90, 93, 120, 128, 147, 121, 116]
+    @result = Array.new(@thead.length)
+    root_ids = Issue.select('issues.root_id')
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+                             DateTime.new(2023, 3).beginning_of_day,
+                             DateTime.new(2023, 3, -1).end_of_day])
+                    .distinct.pluck(:root_id)
+    return unless root_ids.length.positive?
+
+    sum_hours_records = Issue.select('issues.root_id, sum(time_entries.hours) as hours, max(IFNULL(c1.value,-1)) as testcases, max(IFNULL(c2.value,-1)) as bugs,max(IFNULL(stg.value,-1)) as stg_bugs, max(IFNULL(prod.value,-1)) as prod_bugs')
+                             .joins('INNER JOIN time_entries ON issues.id = time_entries.issue_id')
+                             .joins('LEFT OUTER JOIN custom_values c1 ON c1.customized_id = issues.id and c1.custom_field_id=22')
+                             .joins('LEFT OUTER JOIN custom_values c2 ON c2.customized_id = issues.id and c2.custom_field_id=23')
+                             .joins('LEFT OUTER JOIN custom_values stg ON stg.customized_id = issues.id and stg.custom_field_id=27')
+                             .joins('LEFT OUTER JOIN custom_values prod ON prod.customized_id = issues.id and prod.custom_field_id=28')
+                             .where("issues.root_id IN (#{root_ids.join(',')})")
+                             .where('issues.tracker_id <> 1')
+                             .group('issues.root_id')
+
+    raw_tasks_records = Issue.select('issues.root_id, issues.id, tracker_id, issues.subject, issues.due_date, issues.created_on, issues.closed_on, estimated_hours, issue_statuses.name as status, versions.name as target_version, projects.name as project, pr.value as pr, jr.value as jp_request')
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+
+    sum_hours_records = Issue.select('issues.root_id, sum(time_entries.hours) as hours, max(IFNULL(c1.value,-1)) as testcases, max(IFNULL(c2.value,-1)) as bugs,max(IFNULL(stg.value,-1)) as stg_bugs, max(IFNULL(prod.value,-1)) as prod_bugs')
+                             .joins('INNER JOIN time_entries ON issues.id = time_entries.issue_id')
+                             .joins('LEFT OUTER JOIN custom_values c1 ON c1.customized_id = issues.id and c1.custom_field_id=22')
+                             .joins('LEFT OUTER JOIN custom_values c2 ON c2.customized_id = issues.id and c2.custom_field_id=23')
+                             .joins('LEFT OUTER JOIN custom_values stg ON stg.customized_id = issues.id and stg.custom_field_id=27')
+                             .joins('LEFT OUTER JOIN custom_values prod ON prod.customized_id = issues.id and prod.custom_field_id=28')
+                             .where("issues.root_id IN (#{root_ids.join(',')})")
+                             .where('issues.tracker_id <> 1')
+                             .group('issues.root_id')
+
+    raw_tasks_records = Issue.select('issues.root_id, issues.id, tracker_id, issues.subject, issues.due_date, issues.created_on, issues.closed_on, estimated_hours, issue_statuses.name as status, versions.name as target_version, projects.name as project, pr.value as pr, jr.value as jp_request')
+                             .joins('INNER JOIN projects ON projects.id = issues.project_id')
+                             .joins('INNER JOIN issue_statuses ON issue_statuses.id = issues.status_id')
+                             .joins('LEFT JOIN versions ON issues.fixed_version_id = versions.id')
+                             .joins('LEFT OUTER JOIN custom_values jr ON jr.customized_id = issues.id and jr.custom_field_id=16')
--- a/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+++ b/plugins/workflow_report/app/controllers/workflow_report_controller.rb 0 → 100755
+                             .joins('LEFT OUTER JOIN custom_values stg ON stg.customized_id = issues.id and stg.custom_field_id=27')
+                             .joins('LEFT OUTER JOIN custom_values prod ON prod.customized_id = issues.id and prod.custom_field_id=28')
+                             .where("issues.root_id IN (#{root_ids.join(',')})")
+                             .where('issues.tracker_id <> 1')
+                             .group('issues.root_id')
+
+    raw_tasks_records = Issue.select('issues.root_id, issues.id, tracker_id, issues.subject, issues.due_date, issues.created_on, issues.closed_on, estimated_hours, issue_statuses.name as status, versions.name as target_version, projects.name as project, pr.value as pr, jr.value as jp_request')
+                             .joins('INNER JOIN projects ON projects.id = issues.project_id')
+                             .joins('INNER JOIN issue_statuses ON issue_statuses.id = issues.status_id')
+                             .joins('LEFT JOIN versions ON issues.fixed_version_id = versions.id')
+                             .joins('LEFT OUTER JOIN custom_values jr ON jr.customized_id = issues.id and jr.custom_field_id=16')
+                             .joins('LEFT OUTER JOIN custom_values pr ON pr.customized_id = issues.id and pr.custom_field_id=18')
+                             .where("issues.root_id IN (#{root_ids.join(',')})")
+                             .where('issues.tracker_id <> 1')
+                             .order('issues.root_id')
+    @result.map! { |item| item = [] }
--- a/plugins/workflow_report/lib/workflow_report.rb 0 → 100755
+++ b/plugins/workflow_report/lib/workflow_report.rb 0 → 100755
+                  'Number of estimation changes', 'Note of estimation changes', '1. Requirement', '2. Design', '3. Coding', '4. Testing', '5. Bug fixing', '6. Release', 'Others', '1. Requirement', '2. Design', '3. Coding',
+                  '4. Testing', '5. Bug fixing', '6. Release', 'Others', 'testcases', 'vn STG bug', 'Jp STG bug', 'Production', 'Issue', 'Issue comment', 'PR comment', 'Review comment', 'Commits', 'File changed', 'Addtion', 'Deletetion']
+  KURUMA_PROJECT_IDS = [139, 138, 94, 90, 93, 120, 128, 147, 121, 116]
+  TESTCASE_FIELD_ID = 22
+  BUGS_FIELD_ID = 23
+  STG_BUGS_FIELD_ID = 27
+  PROD_BUGS_FIELD_ID = 28
+  PR_FIELD_ID = 18
+  JP_REQUEST_FIELD_ID = 16
+  EST_DETAIL_FIRST_COL = 14
+  ACTUAL_TIME_DETAIL_FIRST_COL = 21
+
+  class << self
+    def build_report(year, month, project_ids)
+      github = Github.new oauth_token: $workflow_report_config['github_token']
+      result =  TABLE_HEADER.length.times.map{[]}
--- a/plugins/workflow_report/lib/workflow_report.rb 0 → 100755
+++ b/plugins/workflow_report/lib/workflow_report.rb 0 → 100755
+      end
+      name.strip
+    end
+
+    def find_root_ids(year: 2023, month: 3, project_ids: [])
+      Issue.joins(:project, project: :enabled_modules)
+           .joins('LEFT OUTER JOIN time_entries ON issues.id = time_entries.issue_id')
+           .where.not(projects: { status: 9 })
+           .where(projects: { id: project_ids }, enabled_modules: { name: 'time_tracking' })
+           .where(['((time_entries.spent_on IS NOT NULL AND time_entries.tyear = ? AND time_entries.tmonth = ?) OR (issues.closed_on BETWEEN ? AND ?))',
+                   year, month, DateTime.new(year, month).beginning_of_day, DateTime.new(year, month, -1).end_of_day])
+           .distinct.pluck(:root_id)
+    end
+
+    def find_sum_hours_records(root_ids)
+      Issue.select(:root_id, 'sum(time_entries.hours) as hours', 'max(IFNULL(c1.value,-1)) as testcases', 'max(IFNULL(c2.value,-1)) as bugs', 'max(IFNULL(stg.value,-1)) as stg_bugs', 'max(IFNULL(prod.value,-1)) as prod_bugs')