droboticflow/internal/api/production_quality.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})
}