forked from longtao.wu/droboticflow
168 lines
6.2 KiB
Go
168 lines
6.2 KiB
Go
package api
|
|
|
|
import (
|
|
"context"
|
|
"droboticflow/internal/domain"
|
|
"droboticflow/internal/outputsnapshot"
|
|
"droboticflow/internal/workforcestats"
|
|
"encoding/csv"
|
|
"errors"
|
|
"net/http"
|
|
"strconv"
|
|
"time"
|
|
)
|
|
|
|
func productionQualityDates(r *http.Request, now time.Time) (time.Time, time.Time, *time.Location, error) {
|
|
copy := r.Clone(r.Context())
|
|
u := *r.URL
|
|
copy.URL = &u
|
|
values := u.Query()
|
|
zone := values.Get("timeZone")
|
|
if zone == "" {
|
|
zone = "Asia/Shanghai"
|
|
}
|
|
loc, e := workforcestats.ReportingLocation(zone)
|
|
if e != nil {
|
|
return time.Time{}, time.Time{}, nil, e
|
|
}
|
|
today := now.In(loc)
|
|
end := time.Date(today.Year(), today.Month(), today.Day(), 0, 0, 0, 0, loc)
|
|
first := time.Date(end.Year(), end.Month(), 1, 0, 0, 0, 0, loc).AddDate(0, -1, 0)
|
|
day := end.Day()
|
|
last := first.AddDate(0, 1, -1).Day()
|
|
if day > last {
|
|
day = last
|
|
}
|
|
start := time.Date(first.Year(), first.Month(), day, 0, 0, 0, 0, loc)
|
|
if values.Get("from") == "" {
|
|
values.Set("from", start.Format("2006-01-02"))
|
|
}
|
|
if values.Get("to") == "" {
|
|
values.Set("to", end.Format("2006-01-02"))
|
|
}
|
|
explicitEnd, e := time.ParseInLocation("2006-01-02", values.Get("to"), loc)
|
|
if e != nil {
|
|
return time.Time{}, time.Time{}, nil, e
|
|
}
|
|
values.Set("to", explicitEnd.AddDate(0, 0, -1).Format("2006-01-02"))
|
|
u.RawQuery = values.Encode()
|
|
return outputDateRange(copy, now)
|
|
}
|
|
func (s *server) handleProductionQuality(w http.ResponseWriter, r *http.Request) {
|
|
p, ok := currentPrincipal(r)
|
|
if !ok {
|
|
renderJSON(w, 401, map[string]string{"error": "请先登录"})
|
|
return
|
|
}
|
|
admin := isOrganizationAdmin(p)
|
|
vendor := p.User.Role == domain.UserRoleSupplierManager
|
|
if !admin && !vendor && p.User.Role != domain.UserRoleAnnotator && p.User.Role != domain.UserRoleQualityReviewer && p.User.Role != domain.UserRoleAcceptanceReviewer {
|
|
renderJSON(w, 403, map[string]string{"error": "无权访问"})
|
|
return
|
|
}
|
|
roleFilter := r.URL.Query().Get("role")
|
|
if roleFilter != "" && roleFilter != "annotation" && roleFilter != "quality" && roleFilter != "acceptance" {
|
|
renderJSON(w, 400, map[string]string{"error": "角色无效"})
|
|
return
|
|
}
|
|
from, to, loc, err := productionQualityDates(r, time.Now())
|
|
if err != nil {
|
|
renderError(w, 400, err)
|
|
return
|
|
}
|
|
page, size, err := outputPagination(r, "people")
|
|
if err != nil {
|
|
renderError(w, 400, err)
|
|
return
|
|
}
|
|
sp, ss, err := outputPagination(r, "suppliers")
|
|
if err != nil {
|
|
renderError(w, 400, err)
|
|
return
|
|
}
|
|
q := workforcestats.OutputQuery{ProductionQuality: true, ReportRole: r.URL.Query().Get("role"), From: from, To: to, Location: loc, ProjectID: r.URL.Query().Get("projectId"), SupplierID: r.URL.Query().Get("supplierId"), UserID: r.URL.Query().Get("userId")}
|
|
audience := "platform"
|
|
if vendor {
|
|
audience = "vendor"
|
|
q.MatchSupplier = true
|
|
q.ScopeSupplierID = p.User.SupplierID
|
|
} else if !admin {
|
|
audience = "self"
|
|
q.MatchUser = true
|
|
q.ScopeUserID = p.User.ID
|
|
if q.ReportRole == "" {
|
|
q.ReportRole = map[domain.UserRole]string{domain.UserRoleAnnotator: "annotation", domain.UserRoleQualityReviewer: "quality", domain.UserRoleAcceptanceReviewer: "acceptance"}[p.User.Role]
|
|
}
|
|
}
|
|
ctx, cancel := context.WithTimeout(r.Context(), 25*time.Second)
|
|
defer cancel()
|
|
org := s.requestOrganizationID(r)
|
|
ids, err := s.annotationOutputProjectScope(ctx, org)
|
|
if err != nil {
|
|
renderError(w, 500, err)
|
|
return
|
|
}
|
|
if vendor && p.User.SupplierID == "" {
|
|
ids = []string{}
|
|
}
|
|
s.outputOnce.Do(func() { s.outputReader = s.newOutputSnapshotReader() })
|
|
report, info, err := s.outputReader.Query(ctx, org, ids, r.URL.Query().Get("snapshotId"), q)
|
|
if errors.Is(err, outputsnapshot.ErrExpired) {
|
|
renderJSON(w, 409, map[string]string{"code": "snapshot_expired", "error": "数据已更新,请重试"})
|
|
return
|
|
}
|
|
if err != nil {
|
|
renderJSON(w, 503, map[string]string{"error": "看板加载失败,请重试"})
|
|
return
|
|
}
|
|
w.Header().Set("Cache-Control", "no-store")
|
|
if report == nil {
|
|
w.Header().Set("Retry-After", "2")
|
|
renderJSON(w, 202, map[string]any{"status": "building", "retryAfterMs": 2000})
|
|
return
|
|
}
|
|
result := report.Production
|
|
format := r.URL.Query().Get("format")
|
|
if format != "" && format != "csv" {
|
|
renderError(w, 400, errors.New("invalid export format"))
|
|
return
|
|
}
|
|
role := r.URL.Query().Get("role")
|
|
people := filterOutputDays(result.People, func(row workforcestats.ProductionPerson) bool { return role == "" || row.Role == role })
|
|
if format == "csv" {
|
|
if len(people) > 100000 {
|
|
renderError(w, 400, errors.New("请缩小导出范围"))
|
|
return
|
|
}
|
|
w.Header().Set("Content-Type", "text/csv; charset=utf-8")
|
|
w.Header().Set("Content-Disposition", `attachment; filename="production-quality.csv"`)
|
|
w.Header().Set("X-Output-Snapshot", info.ID)
|
|
_, _ = w.Write([]byte{0xef, 0xbb, 0xbf})
|
|
csvw := csv.NewWriter(w)
|
|
defer csvw.Flush()
|
|
_ = csvw.Write([]string{"供应商", "人员", "角色", "提交或审查秒数", "最终验收通过秒数", "返工中秒数", "可交付秒数", "首轮通过率", "一次返工通过率", "未闭环返工占比", "平均返工次数", "误判率"})
|
|
number := func(v *float64) string {
|
|
if v == nil {
|
|
return ""
|
|
}
|
|
return strconv.FormatFloat(*v, 'f', 3, 64)
|
|
}
|
|
for _, person := range people {
|
|
row := []string{person.SupplierName, person.Name, person.Role, number(person.Totals.Submitted.Seconds), number(person.Totals.Acceptance.Seconds), number(person.Totals.Rework.Seconds), number(person.Deliverable.Seconds)}
|
|
quality := person.Quality
|
|
if quality == nil {
|
|
quality = &workforcestats.QualityPerson{}
|
|
}
|
|
row = append(row, number(quality.FirstPass.Value), number(quality.FirstReworkPass.Value), number(quality.OpenRework.Value), number(quality.MeanReworks.Value), number(quality.Misreport.Value))
|
|
for i := range row {
|
|
row[i] = outputCSVCell(row[i])
|
|
}
|
|
if csvw.Write(row) != nil {
|
|
return
|
|
}
|
|
}
|
|
return
|
|
}
|
|
renderJSON(w, 200, map[string]any{"snapshot": info, "audienceScope": audience, "from": from.In(loc).Format("2006-01-02"), "to": to.In(loc).Format("2006-01-02"), "totals": result.Totals, "deliverable": result.Deliverable, "quality": result.Quality, "suppliers": paginateOutput(result.Suppliers, sp, ss), "people": paginateOutput(people, page, size), "projects": result.Projects, "supplierOptions": result.SupplierOptions, "users": result.Users})
|
|
}
|