bill-purchase-excel.go 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297
  1. package api
  2. import (
  3. "box-cost/db/model"
  4. "fmt"
  5. "github.com/xuri/excelize/v2"
  6. )
  7. type PurchaseBillExcel struct {
  8. Offset int
  9. Title string //标题
  10. Excel *excelize.File
  11. SheetName string
  12. AlignCenterStyle int
  13. Content *model.PurchaseBill
  14. }
  15. func (b *PurchaseBillExcel) drawTitle() error {
  16. tileIndex := b.Offset + 1
  17. startCell := fmt.Sprintf("A%d", tileIndex)
  18. err := b.Excel.MergeCell(b.SheetName, startCell, fmt.Sprintf("I%d", tileIndex))
  19. if err != nil {
  20. return err
  21. }
  22. style, err := b.Excel.NewStyle(&excelize.Style{
  23. Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"},
  24. Font: &excelize.Font{Bold: true, Size: 18}})
  25. if err != nil {
  26. return err
  27. }
  28. err = b.Excel.SetCellStyle(b.SheetName, startCell, startCell, style)
  29. if err != nil {
  30. return err
  31. }
  32. b.Excel.SetRowHeight(b.SheetName, tileIndex, 23)
  33. b.Excel.SetCellValue(b.SheetName, startCell, b.Title)
  34. return nil
  35. }
  36. func (b *PurchaseBillExcel) drawSubTitles() error {
  37. row := b.Offset + 2
  38. styleLeft, err := b.Excel.NewStyle(&excelize.Style{
  39. Alignment: &excelize.Alignment{Horizontal: "left", Vertical: "center"},
  40. Font: &excelize.Font{Size: 11}})
  41. if err != nil {
  42. return err
  43. }
  44. styleRight, err := b.Excel.NewStyle(&excelize.Style{
  45. Alignment: &excelize.Alignment{Horizontal: "right", Vertical: "center"},
  46. Font: &excelize.Font{Size: 11}})
  47. if err != nil {
  48. return err
  49. }
  50. var drawLeft = func(rowIndex int, value string) error {
  51. //左边1
  52. left1Cell := fmt.Sprintf("A%d", rowIndex)
  53. err = b.Excel.MergeCell(b.SheetName, left1Cell, fmt.Sprintf("E%d", rowIndex))
  54. if err != nil {
  55. return err
  56. }
  57. err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left1Cell, styleLeft)
  58. if err != nil {
  59. return err
  60. }
  61. b.Excel.SetCellValue(b.SheetName, left1Cell, value)
  62. return nil
  63. }
  64. var drawRight = func(rowIndex int, value string) error {
  65. right1Cell := fmt.Sprintf("F%d", rowIndex)
  66. err = b.Excel.MergeCell(b.SheetName, right1Cell, fmt.Sprintf("I%d", rowIndex))
  67. if err != nil {
  68. return err
  69. }
  70. err = b.Excel.SetCellStyle(b.SheetName, right1Cell, right1Cell, styleRight)
  71. if err != nil {
  72. return err
  73. }
  74. b.Excel.SetCellValue(b.SheetName, right1Cell, value)
  75. return nil
  76. }
  77. //第一行
  78. drawLeft(row, "类别:"+b.Content.Type)
  79. drawRight(row, "单号:"+b.Content.SerialNumber)
  80. b.Excel.SetRowHeight(b.SheetName, row, 21)
  81. //第二行
  82. drawLeft(row+1, "供应商名称:"+b.Content.Supplier)
  83. timeformat := b.Content.CreateTime.Local().Format("2006年01月02号 15:04:05")
  84. drawRight(row+1, "下单时间:"+timeformat)
  85. b.Excel.SetRowHeight(b.SheetName, row+1, 21)
  86. //第三行
  87. drawLeft(row+2, "产品名称:"+b.Content.ProductName)
  88. status := ""
  89. if b.Content.Status == "complete" {
  90. status = fmt.Sprintf("已完成(%d)", b.Content.ConfirmCount)
  91. }
  92. if b.Content.Status == "created" {
  93. status = "进行中"
  94. }
  95. drawRight(row+2, "状态:"+status)
  96. b.Excel.SetRowHeight(b.SheetName, row+2, 21)
  97. return nil
  98. }
  99. func (b *PurchaseBillExcel) drawTableTitle() error {
  100. row := b.Offset + 5
  101. //A采购项目 B规格(克) 尺寸C-D 数量E 单价F-G 交货时间H 备注I
  102. var drawCol = func(prefix string, value string) error {
  103. left1Cell := fmt.Sprintf("%s%d", prefix, row)
  104. left2Cell := fmt.Sprintf("%s%d", prefix, row+1)
  105. err := b.Excel.MergeCell(b.SheetName, left1Cell, left2Cell)
  106. if err != nil {
  107. return err
  108. }
  109. err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left2Cell, b.AlignCenterStyle)
  110. if err != nil {
  111. return err
  112. }
  113. return b.Excel.SetCellValue(b.SheetName, left1Cell, value)
  114. }
  115. var drawCol2 = func(prefix1 string, prefix2 string, value1 string, value2 string, value3 string) error {
  116. left1Cell := fmt.Sprintf("%s%d", prefix1, row)
  117. left2Cell := fmt.Sprintf("%s%d", prefix2, row)
  118. err := b.Excel.MergeCell(b.SheetName, left1Cell, left2Cell)
  119. if err != nil {
  120. return err
  121. }
  122. if err != nil {
  123. fmt.Println(err)
  124. return err
  125. }
  126. err = b.Excel.SetCellStyle(b.SheetName, left1Cell, left2Cell, b.AlignCenterStyle)
  127. if err != nil {
  128. return err
  129. }
  130. b.Excel.SetCellValue(b.SheetName, left1Cell, value1)
  131. val2Cel := fmt.Sprintf("%s%d", prefix1, row+1)
  132. b.Excel.SetCellStyle(b.SheetName, val2Cel, val2Cel, b.AlignCenterStyle)
  133. b.Excel.SetCellValue(b.SheetName, val2Cel, value2)
  134. val3Cel := fmt.Sprintf("%s%d", prefix2, row+1)
  135. b.Excel.SetCellStyle(b.SheetName, val3Cel, val3Cel, b.AlignCenterStyle)
  136. b.Excel.SetCellValue(b.SheetName, val3Cel, value3)
  137. return nil
  138. }
  139. drawCol("A", "采购项目")
  140. drawCol("B", "规格(克)")
  141. drawCol("H", "交货时间")
  142. drawCol("I", " 备注")
  143. drawCol("E", " 数量")
  144. drawCol2("C", "D", "尺寸(mm)", "长", "宽")
  145. drawCol2("C", "D", "尺寸(mm)", "长", "宽")
  146. unit1 := "-"
  147. unit2 := "-"
  148. if len(b.Content.Paper) > 0 {
  149. if b.Content.Paper[0].PriceUnit != "" {
  150. unit1 = b.Content.Paper[0].PriceUnit
  151. } else if b.Content.Paper[0].Price2Unit != "" {
  152. unit2 = b.Content.Paper[0].Price2Unit
  153. } else {
  154. unit1 = "元/张"
  155. unit2 = "元/吨"
  156. }
  157. if b.Content.Paper[0].PriceUnit != "" && b.Content.Paper[0].Price2Unit != "" {
  158. unit1 = b.Content.Paper[0].PriceUnit
  159. unit2 = b.Content.Paper[0].Price2Unit
  160. }
  161. }
  162. drawCol2("F", "G", "单价", unit1, unit2)
  163. return nil
  164. }
  165. func (b *PurchaseBillExcel) drawTableContent() error {
  166. row := b.Offset + 7
  167. var DrawRow = func(rowIndex int, values ...string) {
  168. charas := []string{"A", "B", "C", "D", "E", "F", "G", "H", "I"}
  169. for i, c := range charas {
  170. v := ""
  171. if i < len(values) {
  172. v = values[i]
  173. }
  174. b.Excel.SetCellValue(b.SheetName, fmt.Sprintf("%s%d", c, rowIndex), v)
  175. val2Cel := fmt.Sprintf("%s%d", c, rowIndex)
  176. b.Excel.SetCellStyle(b.SheetName, val2Cel, val2Cel, b.AlignCenterStyle)
  177. b.Excel.SetRowHeight(b.SheetName, rowIndex, 21)
  178. }
  179. }
  180. papers := b.Content.Paper
  181. if len(papers) > 0 {
  182. for _, paper := range papers {
  183. deliveryTime := paper.DeliveryTime.Local().Format("2006-01-02")
  184. DrawRow(row, paper.Name, paper.Norm, paper.Height, paper.Width, fmt.Sprintf("%d", paper.Count), paper.Price, paper.Price2, deliveryTime, paper.Remark)
  185. row++
  186. }
  187. }
  188. return nil
  189. }
  190. func (b *PurchaseBillExcel) drawTableFooter() error {
  191. row := b.Offset + 10
  192. left1Cell := fmt.Sprintf("A%d", row)
  193. border := []excelize.Border{
  194. {Type: "top", Style: 1, Color: "000000"},
  195. {Type: "left", Style: 1, Color: "000000"},
  196. {Type: "right", Style: 1, Color: "000000"},
  197. {Type: "bottom", Style: 1, Color: "000000"},
  198. }
  199. styleLeft, _ := b.Excel.NewStyle(&excelize.Style{
  200. Alignment: &excelize.Alignment{Horizontal: "left", Vertical: "center"},
  201. Border: border,
  202. })
  203. b.Excel.SetCellStyle(b.SheetName, left1Cell, left1Cell, styleLeft)
  204. b.Excel.SetCellValue(b.SheetName, left1Cell, "送货地址")
  205. addCel := fmt.Sprintf("B%d", row)
  206. b.Excel.MergeCell(b.SheetName, addCel, fmt.Sprintf("E%d", row))
  207. b.Excel.SetCellStyle(b.SheetName, addCel, fmt.Sprintf("E%d", row), styleLeft)
  208. b.Excel.SetCellValue(b.SheetName, addCel, b.Content.SendTo)
  209. sureCel := fmt.Sprintf("F%d", row)
  210. b.Excel.MergeCell(b.SheetName, sureCel, fmt.Sprintf("I%d", row))
  211. b.Excel.SetCellStyle(b.SheetName, sureCel, fmt.Sprintf("I%d", row), styleLeft)
  212. b.Excel.SetCellValue(b.SheetName, sureCel, "供应商签字:")
  213. b.Excel.SetRowHeight(b.SheetName, row, 21)
  214. return nil
  215. }
  216. func (b *PurchaseBillExcel) Draws() {
  217. b.drawTitle()
  218. b.drawSubTitles()
  219. b.drawTableTitle()
  220. b.drawTableContent()
  221. b.drawTableFooter()
  222. }
  223. func NewPurchaseBill(f *excelize.File) *PurchaseBillExcel {
  224. border := []excelize.Border{
  225. {Type: "top", Style: 1, Color: "000000"},
  226. {Type: "left", Style: 1, Color: "000000"},
  227. {Type: "right", Style: 1, Color: "000000"},
  228. {Type: "bottom", Style: 1, Color: "000000"},
  229. }
  230. styleLeft, _ := f.NewStyle(&excelize.Style{
  231. Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"},
  232. Border: border,
  233. Font: &excelize.Font{Size: 10},
  234. })
  235. b := &PurchaseBillExcel{
  236. Title: "原材料采购单",
  237. SheetName: "Sheet1",
  238. Excel: f,
  239. Offset: 0,
  240. AlignCenterStyle: styleLeft,
  241. }
  242. f.SetColWidth(b.SheetName, "A", "A", 17)
  243. f.SetColWidth(b.SheetName, "B", "B", 13)
  244. f.SetColWidth(b.SheetName, "C", "G", 9.5)
  245. f.SetColWidth(b.SheetName, "H", "I", 12)
  246. f.SetPageMargins(b.SheetName, excelize.PageMarginTop(0), excelize.PageMarginLeft(0), excelize.PageMarginRight(0))
  247. return b
  248. }