package api import ( "box-cost/db/model" "fmt" "github.com/xuri/excelize/v2" ) type PurchaseBillExcel struct { Offset int Title string //标题 Excel *excelize.File SheetName string AlignCenterStyle int Content *model.PurchaseBill } func (b *PurchaseBillExcel) drawTitle() error { tileIndex := b.Offset + 1 startCell := fmt.Sprintf("A%d", tileIndex) err := b.Excel.MergeCell(b.SheetName, startCell, fmt.Sprintf("I%d", tileIndex)) if err != nil { return err } style, err := b.Excel.NewStyle(&excelize.Style{ Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"}, Font: &excelize.Font{Bold: true, Size: 18}}) if err != nil { return err } err = b.Excel.SetCellStyle(b.SheetName, startCell, startCell, style) if err != nil { return err } b.Excel.SetRowHeight(b.SheetName, tileIndex, 23) b.Excel.SetCellValue(b.SheetName, startCell, b.Title) return nil } func (b *PurchaseBillExcel) drawSubTitles() error { row := b.Offset + 2 styleLeft, err := b.Excel.NewStyle(&excelize.Style{ Alignment: &excelize.Alignment{Horizontal: "left", Vertical: "center"}, Font: &excelize.Font{Size: 11}}) if err != nil { return err } styleRight, err := b.Excel.NewStyle(&excelize.Style{ Alignment: &excelize.Alignment{Horizontal: "right", Vertical: "center"}, Font: &excelize.Font{Size: 11}}) if err != nil { return err } var drawLeft = func(rowIndex int, value string) error { //左边1 left1Cell := fmt.Sprintf("A%d", rowIndex) err = b.Excel.MergeCell(b.SheetName, left1Cell, fmt.Sprintf("E%d", rowIndex)) if err != nil { return err } err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left1Cell, styleLeft) if err != nil { return err } b.Excel.SetCellValue(b.SheetName, left1Cell, value) return nil } var drawRight = func(rowIndex int, value string) error { right1Cell := fmt.Sprintf("F%d", rowIndex) err = b.Excel.MergeCell(b.SheetName, right1Cell, fmt.Sprintf("I%d", rowIndex)) if err != nil { return err } err = b.Excel.SetCellStyle(b.SheetName, right1Cell, right1Cell, styleRight) if err != nil { return err } b.Excel.SetCellValue(b.SheetName, right1Cell, value) return nil } //第一行 drawLeft(row, "类别:"+b.Content.Type) drawRight(row, "单号:"+b.Content.SerialNumber) b.Excel.SetRowHeight(b.SheetName, row, 21) //第二行 drawLeft(row+1, "供应商名称:"+b.Content.Supplier) timeformat := b.Content.CreateTime.Local().Format("2006年01月02号 15:04:05") drawRight(row+1, "下单时间:"+timeformat) b.Excel.SetRowHeight(b.SheetName, row+1, 21) //第三行 drawLeft(row+2, "产品名称:"+b.Content.ProductName) status := "" if b.Content.Status == "complete" { status = fmt.Sprintf("已完成(%d)", b.Content.ConfirmCount) } if b.Content.Status == "created" { status = "进行中" } drawRight(row+2, "状态:"+status) b.Excel.SetRowHeight(b.SheetName, row+2, 21) return nil } func (b *PurchaseBillExcel) drawTableTitle() error { row := b.Offset + 5 //A采购项目 B规格(克) 尺寸C-D 数量E 单价F-G 交货时间H 备注I var drawCol = func(prefix string, value string) error { left1Cell := fmt.Sprintf("%s%d", prefix, row) left2Cell := fmt.Sprintf("%s%d", prefix, row+1) err := b.Excel.MergeCell(b.SheetName, left1Cell, left2Cell) if err != nil { return err } err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left2Cell, b.AlignCenterStyle) if err != nil { return err } return b.Excel.SetCellValue(b.SheetName, left1Cell, value) } var drawCol2 = func(prefix1 string, prefix2 string, value1 string, value2 string, value3 string) error { left1Cell := fmt.Sprintf("%s%d", prefix1, row) left2Cell := fmt.Sprintf("%s%d", prefix2, row) err := b.Excel.MergeCell(b.SheetName, left1Cell, left2Cell) if err != nil { return err } if err != nil { fmt.Println(err) return err } err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left2Cell, b.AlignCenterStyle) if err != nil { return err } b.Excel.SetCellValue(b.SheetName, left1Cell, value1) val2Cel := fmt.Sprintf("%s%d", prefix1, row+1) b.Excel.SetCellStyle(b.SheetName, val2Cel, val2Cel, b.AlignCenterStyle) b.Excel.SetCellValue(b.SheetName, val2Cel, value2) val3Cel := fmt.Sprintf("%s%d", prefix2, row+1) b.Excel.SetCellStyle(b.SheetName, val3Cel, val3Cel, b.AlignCenterStyle) b.Excel.SetCellValue(b.SheetName, val3Cel, value3) return nil } drawCol("A", "采购项目") drawCol("B", "规格(克)") drawCol("H", "交货时间") drawCol("I", " 备注") drawCol("E", " 数量") drawCol2("C", "D", "尺寸(mm)", "长", "宽") drawCol2("C", "D", "尺寸(mm)", "长", "宽") unit1 := "-" unit2 := "-" if len(b.Content.Paper) > 0 { if b.Content.Paper[0].PriceUnit != "" { unit1 = b.Content.Paper[0].PriceUnit } else if b.Content.Paper[0].Price2Unit != "" { unit2 = b.Content.Paper[0].Price2Unit } else { unit1 = "元/张" unit2 = "元/吨" } if b.Content.Paper[0].PriceUnit != "" && b.Content.Paper[0].Price2Unit != "" { unit1 = b.Content.Paper[0].PriceUnit unit2 = b.Content.Paper[0].Price2Unit } } drawCol2("F", "G", "单价", unit1, unit2) return nil } func (b *PurchaseBillExcel) drawTableContent() error { row := b.Offset + 7 var DrawRow = func(rowIndex int, values ...string) { charas := []string{"A", "B", "C", "D", "E", "F", "G", "H", "I"} for i, c := range charas { v := "" if i < len(values) { v = values[i] } b.Excel.SetCellValue(b.SheetName, fmt.Sprintf("%s%d", c, rowIndex), v) val2Cel := fmt.Sprintf("%s%d", c, rowIndex) b.Excel.SetCellStyle(b.SheetName, val2Cel, val2Cel, b.AlignCenterStyle) b.Excel.SetRowHeight(b.SheetName, rowIndex, 21) } } papers := b.Content.Paper if len(papers) > 0 { for _, paper := range papers { deliveryTime := paper.DeliveryTime.Local().Format("2006-01-02") DrawRow(row, paper.Name, paper.Norm, paper.Height, paper.Width, fmt.Sprintf("%d", paper.Count), paper.Price, paper.Price2, deliveryTime, paper.Remark) row++ } } return nil } func (b *PurchaseBillExcel) drawTableFooter() error { row := b.Offset + 10 left1Cell := fmt.Sprintf("A%d", row) border := []excelize.Border{ {Type: "top", Style: 1, Color: "000000"}, {Type: "left", Style: 1, Color: "000000"}, {Type: "right", Style: 1, Color: "000000"}, {Type: "bottom", Style: 1, Color: "000000"}, } styleLeft, _ := b.Excel.NewStyle(&excelize.Style{ Alignment: &excelize.Alignment{Horizontal: "left", Vertical: "center"}, Border: border, }) b.Excel.SetCellStyle(b.SheetName, left1Cell, left1Cell, styleLeft) b.Excel.SetCellValue(b.SheetName, left1Cell, "送货地址") addCel := fmt.Sprintf("B%d", row) b.Excel.MergeCell(b.SheetName, addCel, fmt.Sprintf("E%d", row)) b.Excel.SetCellStyle(b.SheetName, addCel, fmt.Sprintf("E%d", row), styleLeft) b.Excel.SetCellValue(b.SheetName, addCel, b.Content.SendTo) sureCel := fmt.Sprintf("F%d", row) b.Excel.MergeCell(b.SheetName, sureCel, fmt.Sprintf("I%d", row)) b.Excel.SetCellStyle(b.SheetName, sureCel, fmt.Sprintf("I%d", row), styleLeft) b.Excel.SetCellValue(b.SheetName, sureCel, "供应商签字:") b.Excel.SetRowHeight(b.SheetName, row, 21) return nil } func (b *PurchaseBillExcel) Draws() { b.drawTitle() b.drawSubTitles() b.drawTableTitle() b.drawTableContent() b.drawTableFooter() } func NewPurchaseBill(f *excelize.File) *PurchaseBillExcel { border := []excelize.Border{ {Type: "top", Style: 1, Color: "000000"}, {Type: "left", Style: 1, Color: "000000"}, {Type: "right", Style: 1, Color: "000000"}, {Type: "bottom", Style: 1, Color: "000000"}, } styleLeft, _ := f.NewStyle(&excelize.Style{ Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"}, Border: border, Font: &excelize.Font{Size: 10}, }) b := &PurchaseBillExcel{ Title: "原材料采购单", SheetName: "Sheet1", Excel: f, Offset: 0, AlignCenterStyle: styleLeft, } f.SetColWidth(b.SheetName, "A", "A", 17) f.SetColWidth(b.SheetName, "B", "B", 13) f.SetColWidth(b.SheetName, "C", "G", 9.5) f.SetColWidth(b.SheetName, "H", "I", 12) f.SetPageMargins(b.SheetName, excelize.PageMarginTop(0), excelize.PageMarginLeft(0), excelize.PageMarginRight(0)) return b }