From 221108b0e0416968ca8417513ebf65c8b5109662 Mon Sep 17 00:00:00 2001
From: lishihai <dslsh@dscom>
Date: 星期三, 26 六月 2024 11:40:47 +0800
Subject: [PATCH] 库存盘点应用按钮记录创建人，创建时间，应用时间、应用人员等信息；根据条形码查询产品详情；新增编辑产品增加条形码字段->添加条形码被使用验证
---
service/more_units.go | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 52 insertions(+), 0 deletions(-)
diff --git a/service/more_units.go b/service/more_units.go
index 8671ce3..3a4cf49 100644
--- a/service/more_units.go
+++ b/service/more_units.go
@@ -1,6 +1,7 @@
package service
import (
+ "errors"
"github.com/shopspring/decimal"
"github.com/xuri/excelize/v2"
"strconv"
@@ -33,3 +34,54 @@
}
return
}
+
+func SetExcelHeader(headers []interface{}, f *excelize.File) (err error) {
+ // 璁剧疆琛ㄥご
+ var i int
+ for _, h := range headers {
+ if v, ok := h.(string); ok {
+ err = f.SetCellValue("Sheet1", getColumnAlphabet(i)+"1", v)
+ if err != nil {
+ return
+ }
+ i++
+ } else if childHeaders, ok := h.(map[string][]string); ok {
+ for title, list := range childHeaders {
+ err = f.SetCellValue("Sheet1", getColumnAlphabet(i)+"1", title)
+ if err != nil {
+ return err
+ }
+ err = f.MergeCell("Sheet1", getColumnAlphabet(i)+"1", getColumnAlphabet(i-1+len(list))+"1") // 鍚堝苟鍗曞厓鏍�
+ for _, t := range list {
+ err = f.SetCellValue("Sheet1", getColumnAlphabet(i)+"2", t)
+ if err != nil {
+ return err
+ }
+ i++
+ }
+ }
+ } else {
+ return errors.New("unsupported header value")
+ }
+ }
+ return nil
+}
+
+func SetHeaderStyle(f *excelize.File) (styleInt int, err error) {
+ // 璁剧疆琛ㄥご鏍峰紡
+ style := &excelize.Style{
+ Border: nil,
+ Fill: excelize.Fill{
+ Type: "pattern",
+ Pattern: 1,
+ Shading: 0,
+ },
+ Font: &excelize.Font{
+ Bold: true,
+ },
+ Alignment: &excelize.Alignment{
+ Horizontal: "center",
+ },
+ }
+ return f.NewStyle(style)
+}
--
Gitblit v1.8.0