Medical_ERP/controllers/stock_template.go

package controllers

import (
	"Medical_ERP/common/actions"
	"Medical_ERP/common/global"
	_ "Medical_ERP/common/response"
	"Medical_ERP/dto"
	"Medical_ERP/models"
	"Medical_ERP/services"
	"Medical_ERP/utils"
	"baliance.com/gooxml/color"
	"baliance.com/gooxml/document"
	"baliance.com/gooxml/measurement"
	"baliance.com/gooxml/schema/soo/wml"
	"errors"
	"fmt"
	context2 "github.com/beego/beego/v2/adapter/context"
	"github.com/beego/beego/v2/core/logs"
	"github.com/boombuler/barcode"
	"github.com/boombuler/barcode/code128"
	"github.com/ser163/png2j"
	"github.com/signintech/gopdf"
	"github.com/xuri/excelize/v2"
	"gogs.baozhida.cn/zoie/OAuth-core/pkg/jwtauth/beegouser"
	"image/jpeg"
	"log"
	"path"
	"strings"

	_ "image/jpeg"
	"image/png"
	"os"
	"time"
)

type StockTemplateController struct {
	BaseController
}

// StockTemplateIn 入库
// @Summary 入库
// @Description 入库
// @Tags 库存
// @Param body body dto.StockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateIn() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockRefundIn
	err := s.StockTemplateIn(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "入库成功")
}

// StockTemplateInScanCode 扫码入库
// @Summary 扫码入库
// @Description 扫码入库
// @Tags 库存
// @Param body body dto.StockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInScanCode() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockIn
	err := s.StockTemplateInScanCode(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "扫码入库成功")
}

// StockTemplateInEdit 修改入库
// @Summary 修改入库
// @Description 修改入库
// @Tags 库存
// @Param body body dto.StockTemplateInEditReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInEdit() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInEditReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetUpdateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	err := s.StockTemplateInEdit(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "修改入库信息成功")
}

// StockTemplateInDelete 删除入库
// @Summary 删除入库
// @Description 删除入库
// @Tags 库存
// @Param body body dto.StockTemplateInDeleteReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInDelete() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInDeleteReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetUpdateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	err := s.StockTemplateInDelete(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "删除入库信息成功")
}

// BatchStockTemplateIn 批量入库
// @Summary 批量入库
// @Description 批量入库
// @Tags 库存
// @Param body body dto.BatchStockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) BatchStockTemplateIn() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockIn
	err := s.BatchStockTemplateIn(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "入库成功")
}

// StockTemplateRefundIn 退货入库
// @Summary 退货入库
// @Description 退货入库
// @Tags 库存
// @Param body body dto.StockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundIn() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockRefundIn
	err := s.StockTemplateIn(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "入库成功")
}

// StockTemplateRefundInScanCode 扫码退货入库
// @Summary 扫码入库
// @Description 扫码入库
// @Tags 库存
// @Param body body dto.StockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundInScanCode() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockRefundIn
	err := s.StockTemplateInScanCode(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "扫码退货入库成功")
}

// BatchStockTemplateRefundIn 批量退货入库
// @Summary 批量退货入库
// @Description 批量退货入库
// @Tags 库存
// @Param body body dto.BatchStockTemplateInInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) BatchStockTemplateRefundIn() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateInInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockRefundIn
	err := s.BatchStockTemplateIn(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "入库成功")
}

// StockTemplateOut 出库
// @Summary 出库
// @Description 出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateOut() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockOut
	err := s.StockTemplateOut(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "出库成功")
}

// StockTemplateOutScanCode 扫码出库
// @Summary 扫码出库
// @Description 扫码出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateOutScanCode() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	logs.Debug("【扫码出库】请求信息 %v", reqData)

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockOut
	err := s.StockTemplateOutScanCode(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "扫码出库成功")
}

// StockTemplateOutEdit 修改入库
// @Summary 修改入库
// @Description 修改入库
// @Tags 库存
// @Param body body dto.StockTemplateOutEditReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateOutEdit() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutEditReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetUpdateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	err := s.StockTemplateOutEdit(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "修改出库信息成功")
}

// StockTemplateOutDelete 删除入库
// @Summary 删除入库
// @Description 删除入库
// @Tags 库存
// @Param body body dto.StockTemplateOutDeleteReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/in [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateOutDelete() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutDeleteReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetUpdateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	err := s.StockTemplateOutDelete(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "删除出库信息成功")
}

// BatchStockTemplateOut 批量出库
// @Summary 批量出库
// @Description 批量出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) BatchStockTemplateOut() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	reqData.State = models.StateStockOut
	err := s.BatchStockTemplateOut(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "出库成功")
}

// StockTemplateRefundOut 退货/报废出库
// @Summary 退货/报废出库
// @Description 退货/报废出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundOut() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	if reqData.State != models.StateStockRefundOut && reqData.State != models.StateStockScrapOut {
		err := errors.New("出库状态错误")
		c.Error(500, err, err.Error())
		return
	}
	err := s.StockTemplateOut(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(reqData.GetId(), "退货(报废)出库成功")
}

// StockTemplateOutScanRefundCode 扫码退货/报废出库
// @Summary 扫码退货/报废出库
// @Description 扫码退货/报废出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundOutScanCode() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	if reqData.State != models.StateStockRefundOut && reqData.State != models.StateStockScrapOut {
		err := errors.New("出库状态错误")
		c.Error(500, err, err.Error())
		return
	}
	err := s.StockTemplateOutScanCode(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "扫码退货(报废)出库成功")
}

// BatchStockTemplateRefundOut 批量退货/报废出库
// @Summary 批量退货/报废出库
// @Description 批量退货/报废出库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) BatchStockTemplateRefundOut() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	if reqData.State != models.StateStockRefundOut && reqData.State != models.StateStockScrapOut {
		err := errors.New("出库状态错误")
		c.Error(500, err, err.Error())
		return
	}
	err := s.BatchStockTemplateOut(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "退货(报废)出库成功")
}

// StockTemplateInList 入库列表
// @Summary 入库列表
// @Description 入库列表
// @Tags 库存
// @Param body body dto.StockTemplateInPageReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/in/list [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInList() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInPageReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, count, err := s.StockTemplateInList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(count), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockTemplateOutList 出库列表
// @Summary 出库列表
// @Description 出库列表
// @Tags 库存
// @Param body body dto.StockTemplateOutPageReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/out/list [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateOutList() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutPageReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, count, err := s.StockTemplateOutList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(count), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockTemplateInventoryList 收发记录
// @Summary 收发记录
// @Description 收发记录
// @Tags 库存
// @Param body body dto.StockTemplateInventoryPageReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/inventory/list [post]
// @Security Bearer—
func (c StockTemplateController) StockTemplateInventoryList() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInventoryPageReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, count, err := s.StockTemplateInventoryList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(count), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockTemplateInventoryExcel 收发登记表
// @Summary 收发登记表
// @Description 收发登记表
// @Tags 库存
// @Param body body dto.StockTemplateInventoryExcelReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInventoryExcel(reqData dto.StockTemplateInventoryExcelReq) {
	s := services.StockTemplate{}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)
	medicineInfo, _, err := s.GetMedicineInfo(deptId, map[string]interface{}{
		"product_id":    reqData.ProductID,
		"enterprise_id": reqData.EnterpriseID,
		"spec_id":       reqData.SpecId,
		"batch_number":  reqData.BatchNumber,
	})
	if err != nil {
		c.Error(global.BadRequest, err, "药品信息不存在")
		return
	}
	var productName, specName, unitName, dosageFormName string

	if id, ok := medicineInfo[models.FieldProductID]; ok {
		productName = models.Read_Product_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldSpecID]; ok {
		specName = models.Read_Spec_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldUnitID]; ok {
		unitName = models.Read_Unit_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldDosageFormID]; ok {
		dosageFormName = models.Read_DosageForm_Get(utils.ToInt(id))
	}

	list, err := s.StockTemplateInventoryExcel(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	f := excelize.NewFile() // 设置单元格的值
	StyleTitle, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Bold: true, Size: 20, Family: "宋体"},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"},
		})
	f.MergeCell("Sheet1", "A1", "O1")
	f.SetRowStyle("Sheet1", 1, 1, StyleTitle)
	f.SetRowHeight("Sheet1", 1, 50)
	var interval string
	if len(reqData.StartDate) > 0 && len(reqData.EndDate) > 0 {
		interval = fmt.Sprintf("%s至%s", reqData.StartDate, reqData.EndDate)
	}
	f.SetCellValue("Sheet1", "A1", fmt.Sprintf("%s收发登记表", interval))

	StyleLittleTitle, _ := f.NewStyle(
		&excelize.Style{
			Font: &excelize.Font{Size: 12, Family: "宋体"},
		})

	f.SetCellValue("Sheet1", "K2", fmt.Sprintf("制品名称：%s", productName))
	f.SetCellValue("Sheet1", "K3", fmt.Sprintf("剂型：%s  规格：%s  单位：%s", dosageFormName, specName, unitName))
	f.SetRowStyle("Sheet1", 2, 3, StyleLittleTitle)

	// 这里设置表头
	f.MergeCell("Sheet1", "A4", "A5")
	f.SetCellValue("Sheet1", "A4", "日期")

	f.MergeCell("Sheet1", "B4", "B5")
	f.SetCellValue("Sheet1", "B4", "购货/发货单位")

	f.MergeCell("Sheet1", "C4", "C5")
	f.SetCellValue("Sheet1", "C4", "生产企业")

	f.MergeCell("Sheet1", "D4", "D5")
	f.SetCellValue("Sheet1", "D4", "批准文号")

	f.MergeCell("Sheet1", "E4", "E5")
	f.SetCellValue("Sheet1", "E4", "批签发合格证编号")

	f.MergeCell("Sheet1", "F4", "H4")
	f.SetCellValue("Sheet1", "F4", "收入")
	f.SetCellValue("Sheet1", "F5", "数量")
	f.SetCellValue("Sheet1", "G5", "批号")
	f.SetCellValue("Sheet1", "H5", "失效日期")

	f.MergeCell("Sheet1", "I4", "K4")
	f.SetCellValue("Sheet1", "I4", "支出")
	f.SetCellValue("Sheet1", "I5", "数量")
	f.SetCellValue("Sheet1", "J5", "批号")
	f.SetCellValue("Sheet1", "K5", "失效日期")

	f.MergeCell("Sheet1", "L4", "N4")
	f.SetCellValue("Sheet1", "L4", "结余")
	f.SetCellValue("Sheet1", "L5", "数量")
	f.SetCellValue("Sheet1", "M5", "批号")
	f.SetCellValue("Sheet1", "N5", "失效日期")

	f.MergeCell("Sheet1", "O4", "O5")
	f.SetCellValue("Sheet1", "O4", "经办人签字")

	// 设置列宽
	f.SetColWidth("Sheet1", "A", "B", 10)
	f.SetColWidth("Sheet1", "B", "C", 14)
	f.SetColWidth("Sheet1", "C", "F", 12)
	f.SetColWidth("Sheet1", "F", "G", 8)
	f.SetColWidth("Sheet1", "G", "I", 12)
	f.SetColWidth("Sheet1", "I", "J", 8)
	f.SetColWidth("Sheet1", "J", "L", 12)
	f.SetColWidth("Sheet1", "L", "M", 8)
	f.SetColWidth("Sheet1", "M", "O", 12)
	f.SetColWidth("Sheet1", "O", "P", 12)

	line := 5

	// 循环写入数据
	for _, v := range list {
		line++
		f.SetCellValue("Sheet1", fmt.Sprintf("A%d", line), v["date"])
		f.SetCellValue("Sheet1", fmt.Sprintf("C%d", line), v[models.FieldEnterpriseName])
		f.SetCellValue("Sheet1", fmt.Sprintf("D%d", line), v[models.FieldApprovalNumber])
		f.SetCellValue("Sheet1", fmt.Sprintf("E%d", line), v[models.FieldQualificationNumber])
		if utils.ToInt(v["stock_in_id"]) > 0 {
			f.SetCellValue("Sheet1", fmt.Sprintf("B%d", line), v["forwarding_unit"])
			f.SetCellValue("Sheet1", fmt.Sprintf("F%d", line), utils.ToInt(v["total_in"]))
			f.SetCellValue("Sheet1", fmt.Sprintf("G%d", line), v[models.FieldApprovalNumber])
			f.SetCellValue("Sheet1", fmt.Sprintf("H%d", line), utils.ToDate(v[models.FieldExpiryDate]))
		}
		if utils.ToInt(v["stock_out_id"]) > 0 {
			f.SetCellValue("Sheet1", fmt.Sprintf("B%d", line), v["receiving_unit"])
			f.SetCellValue("Sheet1", fmt.Sprintf("I%d", line), utils.ToInt(v["total_out"]))
			f.SetCellValue("Sheet1", fmt.Sprintf("J%d", line), v[models.FieldApprovalNumber])
			f.SetCellValue("Sheet1", fmt.Sprintf("K%d", line), utils.ToDate(v[models.FieldExpiryDate]))
		}
		f.SetCellValue("Sheet1", fmt.Sprintf("L%d", line), utils.ToInt(v["balance"]))
		f.SetCellValue("Sheet1", fmt.Sprintf("M%d", line), v[models.FieldApprovalNumber])
		f.SetCellValue("Sheet1", fmt.Sprintf("N%d", line), utils.ToDate(v[models.FieldExpiryDate]))

		f.SetCellValue("Sheet1", fmt.Sprintf("O%d", line), v["operator"])

	}
	f.SetCellValue("Sheet1", fmt.Sprintf("A%d", line+1), "保管单位："+beegouser.GetDeptName(c.Ctx))
	f.SetRowStyle("Sheet1", line+1, line+1, StyleLittleTitle)

	Style1, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Size: 13, Family: "宋体", Bold: true},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center", WrapText: true},
			Border: []excelize.Border{
				{Type: "left", Color: "000000", Style: 1},
				{Type: "top", Color: "000000", Style: 1},
				{Type: "bottom", Color: "000000", Style: 1},
				{Type: "right", Color: "000000", Style: 1},
			},
		})
	f.SetCellStyle("Sheet1", "A4", "O5", Style1)
	Style2, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Size: 12, Family: "宋体"},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center", WrapText: true},
			Border: []excelize.Border{
				{Type: "left", Color: "000000", Style: 1},
				{Type: "top", Color: "000000", Style: 1},
				{Type: "bottom", Color: "000000", Style: 1},
				{Type: "right", Color: "000000", Style: 1},
			},
		})
	f.SetCellStyle("Sheet1", "A6", fmt.Sprintf("O%d", line), Style2)

	filename := "收发登记表" + time.Now().Format("20060102150405") + ".xlsx"
	// 保存文件
	if err := f.SaveAs("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)
}
func (c StockTemplateController) StockTemplateInventoryPdf(reqData dto.StockTemplateInventoryExcelReq) {
	s := services.StockTemplate{}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)
	medicineInfo, _, err := s.GetMedicineInfo(deptId, map[string]interface{}{
		"product_id":    reqData.ProductID,
		"enterprise_id": reqData.EnterpriseID,
		"spec_id":       reqData.SpecId,
		"batch_number":  reqData.BatchNumber,
	})
	if err != nil {
		c.Error(global.BadRequest, err, "药品信息不存在")
		return
	}
	var productName, specName, unitName, dosageFormName string

	if id, ok := medicineInfo[models.FieldProductID]; ok {
		productName = models.Read_Product_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldSpecID]; ok {
		specName = models.Read_Spec_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldUnitID]; ok {
		unitName = models.Read_Unit_Get(utils.ToInt(id))
	}
	if id, ok := medicineInfo[models.FieldDosageFormID]; ok {
		dosageFormName = models.Read_DosageForm_Get(utils.ToInt(id))
	}

	list, err := s.StockTemplateInventoryExcel(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	//cols := []float64{20, 24, 20, 18, 20, 12, 22, 20, 12, 22, 20, 12, 22, 20, 15}
	cols := []float64{58, 73, 59, 53, 53, 35, 65, 59, 40}
	cols1 := []float64{58, 73, 59, 53, 53, 35, 65, 59, 35, 65, 59, 35, 65, 59, 40}

	rows := [][]string{}
	for _, row := range list {
		temp := []string{}
		temp = append(temp, fmt.Sprintf("%v", row["date"]))

		if utils.ToInt(row["stock_in_id"]) > 0 {
			temp = append(temp, fmt.Sprintf("%s", row["forwarding_unit"]))
		} else if utils.ToInt(row["stock_out_id"]) > 0 {
			temp = append(temp, fmt.Sprintf("%s", row["receiving_unit"]))
		}
		temp = append(temp, fmt.Sprintf("%s", row[models.FieldEnterpriseName]))
		if row[models.FieldApprovalNumber] != nil {
			temp = append(temp, fmt.Sprintf("%s", row[models.FieldApprovalNumber]))
		} else {
			temp = append(temp, "")
		}
		if row[models.FieldQualificationNumber] != nil {
			temp = append(temp, fmt.Sprintf("%s", row[models.FieldQualificationNumber]))
		} else {
			temp = append(temp, "")
		}

		if utils.ToInt(row["stock_in_id"]) > 0 {
			temp = append(temp, fmt.Sprintf("%d", row["total_in"]))
			temp = append(temp, fmt.Sprintf("%s", row[models.FieldBatchNumber]))
			temp = append(temp, fmt.Sprintf("%s", utils.ToDate(row[models.FieldExpiryDate])))
		} else {
			temp = append(temp, "")
			temp = append(temp, "")
			temp = append(temp, "")
		}

		if utils.ToInt(row["stock_out_id"]) > 0 {
			temp = append(temp, fmt.Sprintf("%d", row["total_out"]))
			temp = append(temp, fmt.Sprintf("%s", row[models.FieldBatchNumber]))
			temp = append(temp, fmt.Sprintf("%s", utils.ToDate(row[models.FieldExpiryDate])))
		} else {
			temp = append(temp, "")
			temp = append(temp, "")
			temp = append(temp, "")
		}

		temp = append(temp, fmt.Sprintf("%d", row["balance"]))
		temp = append(temp, fmt.Sprintf("%s", row[models.FieldBatchNumber]))
		temp = append(temp, fmt.Sprintf("%s", utils.ToDate(row[models.FieldExpiryDate])))
		temp = append(temp, fmt.Sprintf("%s", row["operator"]))
		rows = append(rows, temp)
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 841.89, H: 595.28}})
	pdf.SetMarginTop(20)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")
	pdf.SetFont("simsun", "", 22)
	titleStr := "收发登记表"

	titleWd, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((842 / 2) - (titleWd / 2))
	pdf.SetY(70)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 10)
	x := 20.
	for i := 0; i < 9; i++ {
		x += cols1[i]
	}
	pdf.SetXY(x, 90)
	pdf.Text(fmt.Sprintf("制品名称：%s 编号", productName))
	pdf.SetXY(x, 110)
	pdf.Text(fmt.Sprintf("剂型：%s 规格：%s 单位：%s", dosageFormName, specName, unitName))

	curx := 16.
	header := []string{"日期", "购货/发货单位", "生产企业", "批准文号", "批签发合格证编号", "收入", "支出", "结余", "经办人签字"}
	h := 50.0
	pdf.SetFont("simsun", "", 11)
	x = curx
	y := 116.

	pdf.SetXY(curx, y)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 11, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		if header[i] == "收入" || header[i] == "支出" || header[i] == "结余" {
			utils.RectFillColorMultiCell(pdf, header[i], 11, x, y, cols[5]+cols[6]+cols[7], h/2, 0, 0, 0, gopdf.Center, gopdf.Middle)
			utils.RectFillColorMultiCell(pdf, "数量", 11, x, y+h/2, cols[5], h/2, 0, 0, 0, gopdf.Center, gopdf.Middle)
			utils.RectFillColorMultiCell(pdf, "批号", 11, x+cols[5], y+h/2, cols[6], h/2, 0, 0, 0, gopdf.Center, gopdf.Middle)
			utils.RectFillColorMultiCell(pdf, "效期", 11, x+cols[5]+cols[6], y+h/2, cols[7], h/2, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += cols[5] + cols[6] + cols[7]
		} else {
			x += cols[i]
		}
	}

	pdf.SetFont("simsun", "", 10)
	y += h
	pdf.SetXY(curx, y)
	h = 20.0
	for _, row := range rows {
		y = pdf.GetY()
		x = curx

		height := h

		for j, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols1[j])
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols1[j]-4)
				lineHt := h * float64(len(lineTexts)) * 0.8
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols1[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
	}

	filename := "收发登记表" + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err := pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)
}
func (c StockTemplateController) StockTemplateInventoryExport() {
	reqData := dto.StockTemplateInventoryExcelReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	if reqData.Type == "excel" {
		c.StockTemplateInventoryExcel(reqData)
	}
	if reqData.Type == "pdf" {
		c.StockTemplateInventoryPdf(reqData)
	}
}

func (c StockTemplateController) TransportRecordWord(reqData models.TransportRecord) {
	s := services.StockTemplate{}
	deptId := beegouser.GetDeptId(c.Ctx)

	list, err := s.StockTemplateTransportRecordWord(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}

	doc := document.New()
	// 获取文档的默认页面设置
	doc.BodySection().SetPageMargins(
		0.3*measurement.Inch,
		0.4*measurement.Inch,
		0.5*measurement.Inch,
		0.3*measurement.Inch,
		1*measurement.Inch,
		0.4*measurement.Inch,
		0.1*measurement.Inch)
	ftr := doc.AddFooter()
	para := ftr.AddParagraph()
	//para.Properties().AddTabStop(0.1*measurement.Inch, wml.ST_TabJcCenter, wml.ST_TabTlcNone)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run := para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddTab()
	run.AddText("第 ")
	run.AddFieldWithFormatting(document.FieldCurrentPage, "", false)
	run.AddText(" 页 / 共 ")
	run.AddFieldWithFormatting(document.FieldNumberOfPages, "", false)
	run.AddText(" 页")
	//doc.BodySection().SetFooter(ftr, wml.ST_HdrFtrDefault)

	para = doc.AddParagraph()
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetBold(true)
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(14)
	para.Properties().Spacing().SetLineSpacing(18*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run.AddText("表3-4 运输记录表")

	para = doc.AddParagraph()
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(12)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	para.Properties().Spacing().SetLineSpacing(30*measurement.Point, wml.ST_LineSpacingRuleAuto)

	run.AddText("（各级通用）")

	para = doc.AddParagraph()
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run.AddText("运输工具： □冷藏车  □运输车  □普通车辆  □无  □其他")
	run = para.AddRun()
	run.AddText("       ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)

	para = doc.AddParagraph()
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run.AddText("冷藏工具： □冷藏车  □车载冷藏箱  □冷藏箱或冷藏包  □其他")
	run = para.AddRun()
	run.AddText("       ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)

	para = doc.AddParagraph()
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run.AddText("配送方式： □本级配送（车牌号:")
	run = para.AddRun()
	run.AddText("              ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText(")  □下级自运（车牌号:")
	run = para.AddRun()
	run.AddText("              ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText(")")

	// --------------------运输情况
	para = doc.AddParagraph()
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetBold(true)
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("运输情况:")

	table := doc.AddTable()
	table.Properties().SetLayout(wml.ST_TblLayoutTypeFixed)
	table.Properties().SetWidthPercent(100)
	look := table.Properties().TableLook()
	look.SetFirstColumn(true)
	look.SetFirstRow(true)
	look.SetHorizontalBanding(true)

	// width of the page
	// with thick borers
	borders := table.Properties().Borders()
	//borders.SetBottom(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	//borders.SetLeft(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	//borders.SetRight(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	//borders.SetTop(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	borders.SetAll(wml.ST_BorderSingle, color.Auto, measurement.Zero)
	//borders.SetInsideVertical(wml.ST_BorderSingle, color.Auto, measurement.Zero)

	row := table.AddRow()
	row.Properties().SetHeight(0.35*measurement.Inch, wml.ST_HeightRuleExact)

	cell := row.AddCell()
	cell.Properties().SetWidthPercent(15)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("品名")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(12)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("生产企业")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("批准文号")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(15)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("批签发合格编号")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(13)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("规格(剂/支或粒)")

	//cell = row.AddCell()
	//cell.Properties().SetWidth(0.5 * measurement.Inch)
	//para = cell.AddParagraph()
	//cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	//para.Properties().SetAlignment(wml.ST_JcCenter)
	//run = para.AddRun()
	//run.Properties().SetFontFamily("宋体")
	//run.Properties().SetSize(8)
	//run.AddText("生产日期")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(12)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("批号")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("失效日期")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(6)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("数量")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(6)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(9)
	run.AddText("单位")

	models.InitBasicData(deptId)
	for _, medicineInfo := range list {
		row = table.AddRow()
		row.Properties().SetHeight(0.3*measurement.Inch, wml.ST_HeightRuleAtLeast)

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(15)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		productName := models.Read_Product_Get(utils.ToInt(medicineInfo[models.FieldProductID]))
		run.AddText(productName)

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(12)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		enterpriseName := models.Read_Enterprise_Get(utils.ToInt(medicineInfo[models.FieldEnterpriseID]))
		run.AddText(enterpriseName)

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(10)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		run.AddText(medicineInfo[models.FieldApprovalNumber].(string))

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(15)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		if medicineInfo[models.FieldQualificationNumber] != nil {
			run.AddText(medicineInfo[models.FieldQualificationNumber].(string))
		}

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(13)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		specName := models.Read_Spec_Get(utils.ToInt(medicineInfo[models.FieldSpecID]))
		run.AddText(specName)

		//cell = row.AddCell()
		//cell.Properties().SetWidth(0.5 * measurement.Inch)
		//para = cell.AddParagraph()
		//cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		//para.Properties().SetAlignment(wml.ST_JcCenter)
		//run = para.AddRun()
		//run.Properties().SetFontFamily("宋体")
		//run.Properties().SetSize(8)
		//run.AddText("生产日期")

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(12)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		run.AddText(medicineInfo[models.FieldBatchNumber].(string))

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(10)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		run.AddText(utils.ToDate(medicineInfo[models.FieldExpiryDate]))

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(6)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		run.AddText(fmt.Sprintf("%d", utils.ToInt(medicineInfo["quantity"])))

		cell = row.AddCell()
		cell.Properties().SetWidthPercent(6)
		para = cell.AddParagraph()
		cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
		para.Properties().SetAlignment(wml.ST_JcCenter)
		run = para.AddRun()
		run.Properties().SetFontFamily("宋体")
		run.Properties().SetSize(8)
		unitName := models.Read_Unit_Get(utils.ToInt(medicineInfo[models.FieldUnitID]))
		run.AddText(unitName)
	}

	if len(list) < 11 {
		for i := 0; i < 11-len(list); i++ {
			row = table.AddRow()
			row.Properties().SetHeight(0.3*measurement.Inch, wml.ST_HeightRuleAtLeast)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(15)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(12)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(10)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(15)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(13)

			//cell = row.AddCell()
			//cell.Properties().SetWidth(0.5 * measurement.Inch)
			//para = cell.AddParagraph()
			//cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
			//para.Properties().SetAlignment(wml.ST_JcCenter)
			//run = para.AddRun()
			//run.Properties().SetFontFamily("宋体")
			//run.Properties().SetSize(8)
			//run.AddText("生产日期")

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(12)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(10)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(6)

			cell = row.AddCell()
			cell.Properties().SetWidthPercent(6)

		}
	}

	// --------------------运输温度记录
	para = doc.AddParagraph()
	para.Properties().Spacing().SetLineSpacing(25*measurement.Point, wml.ST_LineSpacingRuleAtLeast)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetBold(true)
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("运输温度记录:")

	table = doc.InsertTableAfter(para)
	table.Properties().SetWidthPercent(100)
	table.Properties().SetAlignment(wml.ST_JcTableCenter)
	table.Properties().SetLayout(wml.ST_TblLayoutTypeAutofit)
	look = table.Properties().TableLook()
	look.SetFirstColumn(true)
	look.SetFirstRow(true)
	look.SetHorizontalBanding(true)

	borders = table.Properties().Borders()
	borders.SetBottom(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	borders.SetLeft(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	borders.SetRight(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	borders.SetTop(wml.ST_BorderSingle, color.Auto, 1*measurement.Point)
	borders.SetInsideHorizontal(wml.ST_BorderSingle, color.Auto, measurement.Zero)
	borders.SetInsideVertical(wml.ST_BorderSingle, color.Auto, measurement.Zero)

	//-----------------项目名称
	row = table.AddRow()
	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.AddText("")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(38)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("日期/时间")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(19)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(8)
	run.AddText("储存温度")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(17)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("冰排状态")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(16)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("环境温度")

	//------------------启运
	row = table.AddRow()
	row.Properties().SetHeight(0.4*measurement.Inch, wml.ST_HeightRuleAtLeast)
	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("启运")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(38)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("        ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("年")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("月")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("日")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("时")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("分")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(19)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(17)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run.AddText("")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(16)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	//------------------途中
	row = table.AddRow()
	row.Properties().SetHeight(0.8*measurement.Inch, wml.ST_HeightRuleAtLeast)
	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("途中")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(38)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("        ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("年")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("月")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("日")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("时")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("分")

	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("        ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("年")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("月")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("日")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("时")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("分")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(19)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(17)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetSize(5)
	run.AddText("————————")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(16)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	para.Properties().Spacing().SetLineSpacing(20*measurement.Point, wml.ST_LineSpacingRuleAuto)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	//------------------到达
	row = table.AddRow()
	row.Properties().SetHeight(0.4*measurement.Inch, wml.ST_HeightRuleAtLeast)
	cell = row.AddCell()
	cell.Properties().SetWidthPercent(10)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("到达")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(38)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("        ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("年")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("月")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("日")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("时")
	run = para.AddRun()
	run.AddText("      ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("分")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(19)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(17)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run.AddText("")

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(16)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcCenter)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("℃")

	para = doc.AddParagraph()
	para.Properties().Spacing().SetLineSpacing(25*measurement.Point, wml.ST_LineSpacingRuleExact)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("启运至到达行驶里程数:")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("               ")
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("千米。")

	table3 := doc.AddTable()
	table3.Properties().SetLayout(wml.ST_TblLayoutTypeFixed)
	table3.Properties().SetWidthPercent(100)
	look.SetFirstColumn(true)
	look.SetFirstRow(true)
	look.SetHorizontalBanding(true)
	look = table3.Properties().TableLook()

	borders3 := table3.Properties().Borders()
	borders3.SetAll(wml.ST_BorderUnset, color.Auto, measurement.Zero)

	row = table3.AddRow()
	row.Properties().SetHeight(0.36*measurement.Inch, wml.ST_HeightRuleExact)

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(50)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("发货单位：")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText(beegouser.GetDeptName(c.Ctx))
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(50)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("发货人签名：")
	run = para.AddRun()
	run.Properties().SetSize(5)
	run.AddText("________________________________________________________________")

	row = table3.AddRow()
	row.Properties().SetHeight(0.36*measurement.Inch, wml.ST_HeightRuleExact)

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(50)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("收货单位：")
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText(reqData.ReceivingUnit)
	run.Properties().SetUnderline(wml.ST_UnderlineSingle, color.Black)

	cell = row.AddCell()
	cell.Properties().SetWidthPercent(50)
	para = cell.AddParagraph()
	cell.Properties().SetVerticalAlignment(wml.ST_VerticalJcCenter)
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("收货人签名：")
	run = para.AddRun()
	run.Properties().SetSize(5)
	run.AddText("________________________________________________________________")

	para = doc.AddParagraph()
	para.Properties().SetAlignment(wml.ST_JcLeft)
	run = para.AddRun()
	run.Properties().SetFontFamily("宋体")
	run.Properties().SetSize(10)
	run.AddText("填表说明：本表供冷链配送企业、疾病预防控制机构、接种单位冷链运输时填写；出入库单号为单位编码+年月日+2位流水号；运输超过6小时需记录途中温度，间隔不超过6小时；使用无自动温度显示的冰排保冷设备时，只在启运和达到时填写冰排状态(冻结、冰水混合物、完全融化)。")
	doc.BodySection().SetFooter(ftr, wml.ST_HdrFtrDefault)

	filename := "运输记录表" + time.Now().Format("20060102150405") + ".docx"
	// 保存文件
	if err := doc.SaveToFile("ofile/" + filename); err != nil {
		fmt.Println(err)
	}

	// 保存为PDF文件
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)
}

func getImageBytes(filePath string) []byte {
	b, err := os.ReadFile(filePath)
	if err != nil {
		panic(err)
	}
	return b
}
func (c StockTemplateController) TransportRecordPdf(reqData models.TransportRecord) {
	s := services.StockTemplate{}
	imgSvc := services.MedicineImg{}
	barcodeServ := services.Barcode{}
	deptId := beegouser.GetDeptId(c.Ctx)

	p := actions.GetPermissionFromContext(c.Ctx)
	rootId, err := imgSvc.GetRootID((*context2.Context)(c.Ctx), p.DeptId)
	if err != nil {
		c.Error(global.BadRequest, err, err.Error())
		return
	}

	list, err := s.StockTemplateTransportRecordWord(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	reqData.DeptID = deptId
	reqData.DeptName = beegouser.GetDeptName(c.Ctx)
	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(deptId)
	code, err := barcodeServ.Insert(reqData)
	if err != nil {
		err = errors.New("生成条码失败")
		c.Error(500, err, err.Error())
		return
	}
	cs, _ := code128.Encode(code)
	// 创建一个要输出数据的文件
	imgPath := "ofile/img/" + code + ".png"
	file, _ := os.Create(imgPath)
	defer file.Close()

	// 设置图片像素大小
	qrCode, _ := barcode.Scale(cs, 205, 50)
	// 将code128的条形码编码为png图片
	png.Encode(file, qrCode)

	cols := []float64{83, 50, 55, 72, 72, 50, 66, 50, 27, 30}

	header := []string{"品种", "生产企业", "批准文号", "批签发合格编号", "规格(剂/支或粒)", "生产日期", "批号", "失效日期", "数量", "单位"}
	rows := [][]string{}
	imgList := []string{}

	for _, row := range list {
		temp := []string{}
		product := utils.ToString(row[models.FieldProductName])
		enterprise := utils.ToString(row[models.FieldEnterpriseName])
		spec := utils.ToString(row[models.FieldSpecName])
		batchNumber := utils.ToString(row[models.FieldBatchNumber])
		temp = append(temp, product)
		temp = append(temp, fmt.Sprintf("%s", enterprise))
		temp = append(temp, utils.ToString(row[models.FieldApprovalNumber]))
		temp = append(temp, utils.ToString(row[models.FieldQualificationNumber]))
		temp = append(temp, spec)
		temp = append(temp, utils.ToString(row[models.FieldProducedDate]))
		temp = append(temp, batchNumber)
		temp = append(temp, utils.ToString(row[models.FieldExpiryDate]))
		temp = append(temp, fmt.Sprintf("%d", utils.ToInt(row["quantity"])))
		temp = append(temp, utils.ToString(row[models.FieldUnitName]))
		rows = append(rows, temp)

		// 获取药品信息图片
		img, err := imgSvc.Get(deptId, rootId, product, enterprise, spec, batchNumber)
		if err == nil && img.Img != "" {
			imgList = append(imgList, img.Img)
		}
	}
	if len(list) < 11 {
		for i := 0; i < 11-len(list); i++ {
			rows = append(rows, []string{"", "", "", "", "", "", "", "", "", ""})
		}
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 595.28, H: 841.89}})
	pdf.SetMarginTop(40)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")

	pdf.SetMargins(2, 5, 5, 5)
	pdf.SetFont("simsun", "", 10)
	pdf.SetX(20)
	pdf.SetY(20)
	pdf.Text("[扫码入库]")
	pdf.SetX(20)
	pdf.SetY(32)
	pdf.Text("NO:" + code)

	imgPath2 := "ofile/img/" + code + ".jpg"
	png2j.Con2jpg(imgPath, imgPath2)
	pdf.Image(imgPath2, -5, 35, &gopdf.Rect{W: 175, H: 30})

	titleStr := "表3-4 运输记录表"
	pdf.SetFont("simsun", "", 22)
	textw, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((595 / 2) - (textw / 2))
	pdf.SetY(40)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 16)
	titleStr = "（各级通用）"
	textw, _ = pdf.MeasureTextWidth(titleStr)
	pdf.SetX((595 / 2) - (textw / 2))
	pdf.SetY(60)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 10)
	curx, y := 20., pdf.GetY()
	y += 35
	pdf.SetXY(curx, y)
	pdf.Text("运输工具： □冷藏车  □运输车  □普通车辆  □无  □其他")
	y += 16
	pdf.SetXY(curx, y)
	pdf.Text("冷藏工具： □冷藏车  □车载冷藏箱  □冷藏箱或冷藏包  □其他")
	y += 16
	pdf.SetXY(curx, y)
	pdf.Text("配送方式： □本级配送（车牌号:_______） □下级自运（车牌号:_______）")

	y += 20
	pdf.SetXY(curx, y)
	pdf.Text("运输情况：")
	y += 6
	pdf.SetXY(curx, y)
	h := 20.0
	x := curx
	pdf.SetFont("simsun", "", 9)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 9, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols[i]
	}
	y += h
	pdf.SetXY(curx, y)
	pdf.SetFont("simsun", "", 8)

	for _, row := range rows {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx

		height := h
		for i, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols[i])
			//lineHt := h * float64(len(lineTexts))
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols[i]-4)
				lineHt := h * float64(len(lineTexts)) * 0.6
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
		pdf.SetX(curx)
	}
	pdf.SetFont("simsun", "", 9)
	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.Text("运输温度记录：")
	header2 := []string{"", "日期/时间", "储存温度", "冰排状态", "环境温度"}
	cols2 := []float64{55, 210, 105, 94, 91}
	y = pdf.GetY()
	y += 5
	h = 35.0
	pdf.SetNewY(y, h)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	y = pdf.GetY()
	pdf.SetX(curx)
	x = curx
	for i := 0; i < len(header2); i++ {
		utils.RectFillColorMultiCell(pdf, header2[i], 9, x, y, cols2[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols2[i]
	}
	y += h
	pdf.SetNewY(y, h)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	row2 := [][]string{
		{"启运", "______年___月___日___时___分", "________℃", "", "________℃"},
		{"途中", "______年___月___日___时___分", "________℃", "————", "________℃"},
		{"到达", "______年___月___日___时___分", "________℃", "", "________℃"},
	}

	for j, row := range row2 {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx
		pdf.SetTextColor(0, 0, 0)

		height := h
		if j == 1 {
			height = height * 2
		}
		for i, txt := range row {
			width := cols2[i]
			txtWd, _ := pdf.MeasureTextWidth(txt)

			txtX := x + (width-txtWd)/2

			pdf.SetLineWidth(0.8)
			pdf.SetFillColor(255, 255, 255) //setup fill color
			pdf.SetLineType("")             // 线条样式
			pdf.RectFromUpperLeftWithStyle(x, y, width, height, "FD")

			if j == 1 {
				if i == 1 || i == 2 || i == 4 {
					txtY := y + height/5*2
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
					txtY = y + height/5*4
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
				} else {
					txtY := y + height/5*3
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
				}
			} else {
				txtY := y + height/3*2
				pdf.SetXY(txtX, txtY)
				pdf.Text(txt)
			}

			x += width
		}

		pdf.SetNewY(y+height, height)

		if pdf.GetY() < 30 || pdf.GetY() > 810 {
			pdf.SetY(30)
		}
		pdf.SetX(curx)
	}

	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetFont("simsun", "", 10)
	pdf.Text("启运至到达行驶里程数:_________千米")

	y = pdf.GetY()
	y += 25
	pdf.SetNewY(y, 25)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	y = pdf.GetY()
	pdf.Text("发货单位：")
	txtWd, _ := pdf.MeasureTextWidth("发货单位：")
	pdf.SetLineWidth(0.8)
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(beegouser.GetDeptName(c.Ctx))
	pdf.Line(60, y+3, 207, y+3)

	pdf.SetXY(300, y)
	pdf.Text("发货人签名：")
	txtWd, _ = pdf.MeasureTextWidth("发货人签名：")
	pdf.Line(348, y+3, 495, y+3)

	y = pdf.GetY()
	y += 25
	pdf.SetNewY(y, 25)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	y = pdf.GetY()
	pdf.Text("收货单位：")
	txtWd, _ = pdf.MeasureTextWidth("收货单位：")
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(reqData.ReceivingUnit)
	pdf.Line(60, y+3, 207, y+3)

	pdf.SetXY(300, y)
	pdf.Text("收货人签名：")
	txtWd, _ = pdf.MeasureTextWidth("收货人签名：")
	pdf.Line(348, y+3, 495, y+3)

	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetCharSpacing(0.5)
	txt := "填表说明：本表供冷链配送企业、疾病预防控制机构、接种单位冷链运输时填写；出入库单号为单位编码+年月日+2位流水号；运输超过6小时需记录途中温度，间隔不超过6小时；使用无自动温度显示的冰排保冷设备时，只在启运和达到时填写冰排状态(冻结、冰水混合物、完全融化)。"
	pdf.MultiCell(&gopdf.Rect{W: 555, H: 50}, txt)
	//imgList = append(imgList,
	//	"https://godownoss.coldbaozhida.com/UpImage/17115067977062dc7f-0354-4e70-aefe-3423338b44be.jpg",
	//	"https://godownoss.coldbaozhida.com/UpImage/17115068019adbd486-993e-48c5-8155-c2c30265638a.jpg",
	//)
	for _, v := range imgList {
		urlList := strings.Split(strings.Trim(v, ","), ",")
		for _, url := range urlList {
			pdf.AddPage()
			imgH, errImg := utils.GetImage(url)
			if errImg != nil {
				err = errors.New("获取图片失败")
				c.Error(500, err, err.Error())
				return
			}
			imgWidth := float64(imgH.Bounds().Dx())
			imgHeight := float64(imgH.Bounds().Dy())
			W, H := imgWidth, imgHeight
			if imgWidth >= imgHeight && imgWidth > 555 {
				W = 555
				H = 555 * float64(imgHeight) / float64(imgWidth)
			}

			if imgWidth < imgHeight && imgWidth > 760 {
				W = 760 * float64(imgWidth) / float64(imgHeight)
				H = 760
				if W > 555 {
					H = 555 * 760 / W
					W = 555
				}

			}

			if strings.Contains(url, ".png") {
				err = pdf.ImageFrom(imgH, (595-W)/2, (840-H)/2, &gopdf.Rect{W: W, H: H})
				if err != nil {
					err = errors.New("写入图片失败")
					c.Error(500, err, err.Error())
					return
				}
			} else {
				fileName := "./ofile/" + path.Base(url)
				f, _ := os.Create(fileName)
				defer f.Close()
				defer func() {
					os.Remove(fileName)
				}()
				jpeg.Encode(f, imgH, &jpeg.Options{100})
				err = pdf.Image(fileName, (595-W)/2, (840-H)/2, &gopdf.Rect{W: W, H: H})
				if err != nil {
					err = errors.New("写入图片失败")
					c.Error(500, err, err.Error())
					return
				}
			}

		}

	}

	for i := 0; i < pdf.GetNumberOfPages(); i++ {

	}

	filename := "运输记录表" + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err = pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
		os.Remove(imgPath)
		os.Remove(imgPath2)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)

}

// TransportRecordExport 运输记录表
// @Summary 收发登记表word
// @Description 收发登记表word
// @Tags 库存
// @Param body body dto.TransportRecordWordReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) TransportRecordExport() {
	reqData := models.TransportRecord{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	if reqData.Type == "pdf" {
		c.TransportRecordPdf(reqData)

	}

	if reqData.Type == "word" {
		c.TransportRecordWord(reqData)
	}

}

// TransportRecordExport 运输记录表
// @Summary 收发登记表word
// @Description 收发登记表word
// @Tags 库存
// @Param body body dto.TransportRecordWordReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) TransportRecordExportList() {
	s := services.StockTemplate{}
	reqData := models.TransportRecord{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	list, err := s.StockTemplateTransportRecordWord(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, 0, 0, 0, "查询成功")
}

// StockUnitList 获取收货单位，发货单位，收发单位
// @Summary 获取收货单位，发货单位，收发单位
// @Description 获取收货单位，发货单位，收发单位
// @Tags 库存
// @Param body body dto.StockUnitListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/unit/list [post]
// @Security Bearer
func (c StockTemplateController) StockUnitList() {
	s := services.StockTemplate{}
	reqData := dto.StockUnitListReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, err := s.StockUnitList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, 0, 0, 0, "查询成功")
}

// StockOperatorList 获取收货单位，发货单位，收发单位
// @Summary 获取收货单位，发货单位，收发单位
// @Description 获取收货单位，发货单位，收发单位
// @Tags 库存
// @Param body body dto.StockOperatorListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/unit/list [post]
// @Security Bearer
func (c StockTemplateController) StockOperatorList() {
	s := services.StockTemplate{}
	reqData := dto.StockOperatorListReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, err := s.StockOperatorList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, 0, 0, 0, "查询成功")
}

// StockInquiryList 库存查询
// @Summary 库存查询-每个商品、生产企业、规格、批号数量
// @Description 库存查询
// @Tags 库存
// @Param body body dto.StockStatListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/inquiry/list [post]
// @Security Bearer
func (c StockTemplateController) StockInquiryList() {
	s := services.StockTemplate{}
	reqData := dto.StockStatListReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, cnt, err := s.StockInquiryList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(cnt), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockInquiryExcel 导出库存信息表
// @Summary 库存信息表-每个商品、生产企业、规格、批号数量
// @Description 库存信息表
// @Tags 库存
// @Param body body dto.StockStatListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/stat/excel [post]
// @Security Bearer
func (c StockTemplateController) StockInquiryExcel() {
	s := services.StockTemplate{}
	reqData := dto.StockStatListReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, err := s.StockInquiryExcel(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	f := excelize.NewFile() // 设置单元格的值
	StyleTitle, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Bold: true, Size: 20, Family: "宋体"},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center"},
		})
	f.MergeCell("Sheet1", "A1", "K1")
	f.SetRowStyle("Sheet1", 1, 1, StyleTitle)
	f.SetRowHeight("Sheet1", 1, 50)
	f.SetCellValue("Sheet1", "A1", fmt.Sprintf("库存信息表（%s）", time.Now().Format("2006-01-02 15:04:05")))
	// 这里设置表头
	f.SetCellValue("Sheet1", "A2", "品名")
	f.SetCellValue("Sheet1", "B2", "生产企业")
	f.SetCellValue("Sheet1", "C2", "规格")
	f.SetCellValue("Sheet1", "D2", "剂型")
	f.SetCellValue("Sheet1", "E2", "单位")
	f.SetCellValue("Sheet1", "F2", "数量")
	f.SetCellValue("Sheet1", "G2", "单价")
	//f.SetCellValue("Sheet1", "H2", "销售单价")
	f.SetCellValue("Sheet1", "H2", "批号")
	f.SetCellValue("Sheet1", "I2", "失效日期")
	f.SetCellValue("Sheet1", "J2", "批准文号")
	f.SetCellValue("Sheet1", "K2", "批签发编号")
	// 设置列宽
	f.SetColWidth("Sheet1", "A", "A", 20)
	f.SetColWidth("Sheet1", "B", "C", 15)
	f.SetColWidth("Sheet1", "D", "F", 12)
	f.SetColWidth("Sheet1", "F", "G", 10)
	f.SetColWidth("Sheet1", "G", "I", 15)
	f.SetColWidth("Sheet1", "I", "J", 12)
	f.SetColWidth("Sheet1", "J", "K", 15)

	line := 2

	// 循环写入数据
	for _, v := range list {
		line++

		f.SetCellValue("Sheet1", fmt.Sprintf("A%d", line), v[models.FieldProductName])
		f.SetCellValue("Sheet1", fmt.Sprintf("B%d", line), v[models.FieldEnterpriseName])
		f.SetCellValue("Sheet1", fmt.Sprintf("C%d", line), v[models.FieldSpecName])
		f.SetCellValue("Sheet1", fmt.Sprintf("D%d", line), v[models.FieldDosageFormName])
		f.SetCellValue("Sheet1", fmt.Sprintf("E%d", line), v[models.FieldUnitName])
		f.SetCellValue("Sheet1", fmt.Sprintf("F%d", line), v["balance"])
		f.SetCellValue("Sheet1", fmt.Sprintf("G%d", line), utils.ToFloat64(v["unit_price"]))
		//f.SetCellValue("Sheet1", fmt.Sprintf("H%d", line), utils.ToFloat64(v["sales_unit_price"]))
		f.SetCellValue("Sheet1", fmt.Sprintf("H%d", line), v["batch_number"])
		f.SetCellValue("Sheet1", fmt.Sprintf("I%d", line), v[models.FieldExpiryDate])
		f.SetCellValue("Sheet1", fmt.Sprintf("J%d", line), v["approval_number"])
		f.SetCellValue("Sheet1", fmt.Sprintf("K%d", line), v["qualification_number"])

	}
	Style1, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Size: 12, Family: "宋体", Bold: true},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center", WrapText: true},
			Border: []excelize.Border{
				{Type: "left", Color: "000000", Style: 1},
				{Type: "top", Color: "000000", Style: 1},
				{Type: "bottom", Color: "000000", Style: 1},
				{Type: "right", Color: "000000", Style: 1},
			},
		})
	f.SetCellStyle("Sheet1", "A2", "K2", Style1)
	Style2, _ := f.NewStyle(
		&excelize.Style{
			Font:      &excelize.Font{Size: 12, Family: "宋体"},
			Alignment: &excelize.Alignment{Horizontal: "center", Vertical: "center", WrapText: true},
			Border: []excelize.Border{
				{Type: "left", Color: "000000", Style: 1},
				{Type: "top", Color: "000000", Style: 1},
				{Type: "bottom", Color: "000000", Style: 1},
				{Type: "right", Color: "000000", Style: 1},
			},
		})
	f.SetCellStyle("Sheet1", "A3", fmt.Sprintf("K%d", line), Style2)

	filename := "库存信息表" + time.Now().Format("20060102150405") + ".xlsx"
	// 保存文件
	if err := f.SaveAs("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)
}

// StockStat 库存统计
// @Summary 库存查询-每个商品数量（不区别生产企业）
// @Description 库存查询
// @Tags 库存
// @Param body body dto.StockStatListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/stat [post]
// @Security Bearer
func (c StockTemplateController) StockStat() {
	s := services.StockTemplate{}
	reqData := dto.StockStatReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	list, cnt, err := s.StockStat(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(cnt), 0, 0, "查询成功")
}

// StockHomeStat 首页出入库信息统计
// @Summary 首页出入库信息统计
// @Description 首页出入库信息统计
// @Tags 库存
// @Param body body dto.StockStatListReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock/stat [post]
// @Security Bearer
func (c StockTemplateController) StockHomeStat() {
	s := services.StockTemplate{}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, cnt, err := s.StockHomeStat(deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(cnt), 0, 0, "查询成功")
}

// StockTemplateInScanBarCode 扫条码入库
// @Summary 扫条码入库
// @Description 扫条码入库
// @Tags 库存
// @Param body body dto.StockTemplateOutInsertReq true "body"
// @Success 200 {object} response.Response "{"code": 200, "data": [...]}"
// @Router /stock-template/out [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateInScanBarCode() {
	s := services.StockTemplate{}
	reqData := dto.BatchStockTemplateOutInsertReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(beegouser.GetDeptId(c.Ctx))
	err := s.StockTemplateOutScanCode(&reqData)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.OK(nil, "扫码出库成功")
}

func (c StockTemplateController) GetTransportRecordBarCodeInfo() {
	barcodeSvc := services.Barcode{}
	s := services.StockTemplate{}
	//if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
	//	c.Error(global.ParseFormErr, err, err.Error())
	//	return
	//}
	codeStr := c.GetString("code")
	reqData := dto.GetBarCodeInfoReq{Code: codeStr}

	var code models.Barcode
	//数据权限检查
	err := barcodeSvc.Get(&reqData, &code)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}

	list, err := s.StockTemplateTransportRecordWord2(&code.Data, code.Data.DeptID)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	for _, v := range list {
		v["forwardingUnit"] = code.Data.DeptName
	}

	c.OK(list, "查询成功")
}

func (c StockTemplateController) StockRefundOutTransportRecordPdf(reqData models.TransportRecord) {
	s := services.StockTemplate{}
	imgSvc := services.MedicineImg{}
	barcodeServ := services.Barcode{}
	deptId := beegouser.GetDeptId(c.Ctx)

	p := actions.GetPermissionFromContext(c.Ctx)
	rootId, err := imgSvc.GetRootID((*context2.Context)(c.Ctx), p.DeptId)
	if err != nil {
		c.Error(global.BadRequest, err, err.Error())
		return
	}

	list, err := s.StockRefundOutTransportRecordPdf(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	reqData.DeptID = deptId
	reqData.DeptName = beegouser.GetDeptName(c.Ctx)
	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(deptId)
	code, err := barcodeServ.Insert(reqData)
	if err != nil {
		err = errors.New("生成条码失败")
		c.Error(500, err, err.Error())
		return
	}
	cs, _ := code128.Encode(code)
	// 创建一个要输出数据的文件
	imgPath := "ofile/img/" + code + ".png"
	file, _ := os.Create(imgPath)
	defer file.Close()

	// 设置图片像素大小
	qrCode, _ := barcode.Scale(cs, 205, 50)
	// 将code128的条形码编码为png图片
	png.Encode(file, qrCode)

	cols := []float64{83, 50, 55, 72, 72, 50, 66, 50, 27, 30}

	header := []string{"品种", "生产企业", "批准文号", "批签发合格编号", "规格(剂/支或粒)", "生产日期", "批号", "失效日期", "数量", "单位"}
	rows := [][]string{}
	imgList := []string{}

	for _, row := range list {
		temp := []string{}
		product := utils.ToString(row[models.FieldProductName])
		enterprise := utils.ToString(row[models.FieldEnterpriseName])
		spec := utils.ToString(row[models.FieldSpecName])
		batchNumber := utils.ToString(row[models.FieldBatchNumber])
		temp = append(temp, product)
		temp = append(temp, fmt.Sprintf("%s", enterprise))
		temp = append(temp, utils.ToString(row[models.FieldApprovalNumber]))
		temp = append(temp, utils.ToString(row[models.FieldQualificationNumber]))
		temp = append(temp, spec)
		temp = append(temp, utils.ToString(row[models.FieldProducedDate]))
		temp = append(temp, batchNumber)
		temp = append(temp, utils.ToString(row[models.FieldExpiryDate]))
		temp = append(temp, fmt.Sprintf("%d", utils.ToInt(row["quantity"])))
		temp = append(temp, utils.ToString(row[models.FieldUnitName]))
		rows = append(rows, temp)

		// 获取药品信息图片
		img, err := imgSvc.Get(deptId, rootId, product, enterprise, spec, batchNumber)
		if err == nil && img.Img != "" {
			log.Println("==============", img.Img)
			imgList = append(imgList, img.Img)
		}
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 595.28, H: 841.89}})
	pdf.SetMarginTop(40)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")

	pdf.SetMargins(2, 5, 5, 5)
	pdf.SetFont("simsun", "", 10)
	//pdf.SetX(20)
	//pdf.SetY(20)
	//pdf.Text("[退货出库]")
	pdf.SetX(420)
	pdf.SetY(60)
	pdf.Text(code)

	imgPath2 := "ofile/img/" + code + ".jpg"
	png2j.Con2jpg(imgPath, imgPath2)
	pdf.Image(imgPath2, 390, 15, &gopdf.Rect{W: 200, H: 35})

	titleStr := "退货出库运输温度记录表"
	pdf.SetFont("simsun", "", 22)
	textw, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((595 / 2) - (textw / 2) - 50)
	pdf.SetY(40)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 10)
	// 第一行
	curx, y := 20., pdf.GetY()
	y += 35
	pdf.SetXY(curx, y)
	pdf.Text("出/入库日期：")
	txtWd, _ := pdf.MeasureTextWidth("出/入库日期：")
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(reqData.Date)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+110, y+3)

	curx = 230
	pdf.SetXY(curx, y)
	pdf.Text("出/入库单号：")
	txtWd, _ = pdf.MeasureTextWidth("出/入库单号：")
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(code)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+130, y+3)

	// 第二行
	curx, y = 20., pdf.GetY()
	y += 25
	pdf.SetXY(curx, y)
	pdf.Text("运输工具：(1)冷藏车")
	txtWd, _ = pdf.MeasureTextWidth("运输工具：(1)冷藏车")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(reqData.Date)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+110, y+3)

	curx = 230
	pdf.SetXY(curx, y)
	pdf.Text("(2)运输车")
	txtWd, _ = pdf.MeasureTextWidth("(2)运输车")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(code)
	pdf.Line(curx+txtWd+2, y+3, curx+txtWd+130, y+3)

	curx = 410
	pdf.SetXY(curx, y)
	pdf.Text("(3)其他")
	txtWd, _ = pdf.MeasureTextWidth("(3)其他")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(code)
	pdf.Line(curx+txtWd+2, y+3, curx+txtWd+130, y+3)

	// 第三行
	curx, y = 20., pdf.GetY()
	y += 25
	pdf.SetXY(curx, y)
	pdf.Text("冷藏方式：(1)冷藏车")
	txtWd, _ = pdf.MeasureTextWidth("运输工具：(1)冷藏车")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(reqData.Date)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+110, y+3)

	curx = 230
	pdf.SetXY(curx, y)
	pdf.Text("(2)冷藏箱")
	txtWd, _ = pdf.MeasureTextWidth("(2)冷藏箱")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(code)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+130, y+3)

	curx = 410
	pdf.SetXY(curx, y)
	pdf.Text("(3)其他")
	txtWd, _ = pdf.MeasureTextWidth("(3)其他")
	pdf.SetXY(curx+txtWd, y)
	//pdf.Text(code)
	pdf.Line(curx+txtWd, y+3, curx+txtWd+130, y+3)

	curx = 20
	y += 20
	pdf.SetXY(curx, y)
	pdf.Text("运输情况：")
	y += 6
	pdf.SetXY(curx, y)
	h := 20.0
	x := curx
	pdf.SetFont("simsun", "", 9)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 9, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols[i]
	}
	y += h
	pdf.SetXY(curx, y)
	pdf.SetFont("simsun", "", 8)

	for _, row := range rows {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx

		height := h
		for i, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols[i])
			//lineHt := h * float64(len(lineTexts))
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols[i]-4)
				lineHt := h * float64(len(lineTexts)) * 0.6
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
		pdf.SetX(curx)
	}
	pdf.SetFont("simsun", "", 9)
	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetFont("simsun", "", 10)
	pdf.Text("运输温度记录：")
	header2 := []string{"项目", "日期/时间", "储存温度", "冰排状态", "环境温度"}
	cols2 := []float64{55, 210, 105, 94, 91}
	y = pdf.GetY()
	y += 5
	h = 35.0
	pdf.SetNewY(y, h)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	y = pdf.GetY()
	pdf.SetX(curx)
	x = curx
	pdf.SetFont("simsun", "", 9)
	for i := 0; i < len(header2); i++ {
		utils.RectFillColorMultiCell(pdf, header2[i], 9, x, y, cols2[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols2[i]
	}
	y += h
	pdf.SetNewY(y, h)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetFont("simsun", "", 9)

	row2 := [][]string{
		{"启运", "______年___月___日___时___分", "________℃", "", "________℃"},
		{"途中", "______年___月___日___时___分", "________℃", "————", "________℃"},
		{"到达", "______年___月___日___时___分", "________℃", "", "________℃"},
	}

	for j, row := range row2 {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx
		pdf.SetTextColor(0, 0, 0)

		height := h
		if j == 1 {
			height = height * 2
		}
		for i, txt := range row {
			width := cols2[i]
			txtWd, _ := pdf.MeasureTextWidth(txt)

			txtX := x + (width-txtWd)/2

			pdf.SetLineWidth(0.8)
			pdf.SetFillColor(255, 255, 255) //setup fill color
			pdf.SetLineType("")             // 线条样式
			pdf.RectFromUpperLeftWithStyle(x, y, width, height, "FD")

			if j == 1 {
				if i == 1 || i == 2 || i == 4 {
					txtY := y + height/5*2
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
					txtY = y + height/5*4
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
				} else {
					txtY := y + height/5*3
					pdf.SetXY(txtX, txtY)
					pdf.Text(txt)
				}
			} else {
				txtY := y + height/3*2
				pdf.SetXY(txtX, txtY)
				pdf.Text(txt)
			}

			x += width
		}

		pdf.SetNewY(y+height, height)

		if pdf.GetY() < 30 || pdf.GetY() > 810 {
			pdf.SetY(30)
		}
		pdf.SetX(curx)
	}

	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetFont("simsun", "", 10)

	pdf.Text("启运至到达行驶里程数:_________千米")

	y = pdf.GetY()
	y += 25
	pdf.SetNewY(y, 25)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	y = pdf.GetY()
	pdf.Text("发货单位：")
	txtWd, _ = pdf.MeasureTextWidth("发货单位：")
	pdf.SetLineWidth(0.8)
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(beegouser.GetDeptName(c.Ctx))
	pdf.Line(60, y+3, 207, y+3)

	pdf.SetXY(300, y)
	pdf.Text("发货人签名：")
	txtWd, _ = pdf.MeasureTextWidth("发货人签名：")
	pdf.Line(348, y+3, 495, y+3)

	y = pdf.GetY()
	y += 25
	pdf.SetNewY(y, 25)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	y = pdf.GetY()
	pdf.Text("收货单位：")
	txtWd, _ = pdf.MeasureTextWidth("收货单位：")
	pdf.SetXY(curx+txtWd, y)
	pdf.Text(reqData.ReceivingUnit)
	pdf.Line(60, y+3, 207, y+3)

	pdf.SetXY(300, y)
	pdf.Text("收货人签名：")
	txtWd, _ = pdf.MeasureTextWidth("收货人签名：")
	pdf.Line(348, y+3, 495, y+3)

	y = pdf.GetY()
	y += 20
	pdf.SetNewY(y, 20)
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	pdf.SetX(curx)
	pdf.SetCharSpacing(0.5)
	txt := "填表说明：本表供冷链配送企业、疾病预防控制机构、接种单位冷链运输时填写；出入库单号为单位编码+年月日+2位流水号；运输超过6小时需记录途中温度，间隔不超过6小时；使用无自动温度显示的冰排保冷设备时，只在启运和达到时填写冰排状态(冻结、冰水混合物、完全融化)。"
	pdf.MultiCell(&gopdf.Rect{W: 555, H: 50}, txt)
	//imgList = append(imgList,
	//	"https://godownoss.coldbaozhida.com/UpImage/17115067977062dc7f-0354-4e70-aefe-3423338b44be.jpg",
	//	"https://godownoss.coldbaozhida.com/UpImage/17115068019adbd486-993e-48c5-8155-c2c30265638a.jpg",
	//)
	for _, v := range imgList {
		urlList := strings.Split(strings.Trim(v, ","), ",")
		for _, url := range urlList {
			pdf.AddPage()
			imgH, errImg := utils.GetImage(url)
			if errImg != nil {
				err = errors.New("获取图片失败")
				c.Error(500, err, err.Error())
				return
			}
			imgWidth := float64(imgH.Bounds().Dx())
			imgHeight := float64(imgH.Bounds().Dy())
			W, H := imgWidth, imgHeight
			if imgWidth >= imgHeight && imgWidth > 555 {
				W = 555
				H = 555 * float64(imgHeight) / float64(imgWidth)
			}

			if imgWidth < imgHeight && imgWidth > 760 {
				W = 760 * float64(imgWidth) / float64(imgHeight)
				H = 760
				if W > 555 {
					H = 555 * 760 / W
					W = 555
				}

			}

			if strings.Contains(url, ".png") {
				err = pdf.ImageFrom(imgH, (595-W)/2, (840-H)/2, &gopdf.Rect{W: W, H: H})
				if err != nil {
					err = errors.New("写入图片失败")
					c.Error(500, err, err.Error())
					return
				}
			} else {
				fileName := "./ofile/" + path.Base(url)
				f, _ := os.Create(fileName)
				defer f.Close()
				defer func() {
					os.Remove(fileName)
				}()
				jpeg.Encode(f, imgH, &jpeg.Options{100})
				err = pdf.Image(fileName, (595-W)/2, (840-H)/2, &gopdf.Rect{W: W, H: H})
				if err != nil {
					err = errors.New("写入图片失败")
					c.Error(500, err, err.Error())
					return
				}
			}

		}

	}

	for i := 0; i < pdf.GetNumberOfPages(); i++ {

	}

	filename := "退货出库运输温度记录表" + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err = pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
		os.Remove(imgPath)
		os.Remove(imgPath2)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)

}

// StockRefundOutTransportRecordExport 退货出库运输登记表
// @Summary 退货出库运输登记表
// @Description 退货出库运输登记表
// @Tags 库存
// @Param body body dto.TransportRecordWordReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockRefundOutTransportRecordExport() {
	reqData := models.TransportRecord{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	if reqData.Type == "pdf" {
		c.StockRefundOutTransportRecordPdf(reqData)

	}

}

// TransportRecordExport 运输记录表
// @Summary 收发登记表word
// @Description 收发登记表word
// @Tags 库存
// @Param body body dto.TransportRecordWordReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockRefundOutTransportRecordExportList() {
	s := services.StockTemplate{}
	reqData := models.TransportRecord{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	list, err := s.StockRefundOutTransportRecordPdf(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, 0, 0, 0, "查询成功")
}

func (c StockTemplateController) GetRefundOutBarCodeInfo() {
	barcodeSvc := services.Barcode{}
	s := services.StockTemplate{}
	//if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
	//	c.Error(global.ParseFormErr, err, err.Error())
	//	return
	//}
	codeStr := c.GetString("code")
	reqData := dto.GetBarCodeInfoReq{Code: codeStr}

	var code models.Barcode
	//数据权限检查
	err := barcodeSvc.Get(&reqData, &code)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}

	list, err := s.GetRefundOutBarCodeInfo(&code.Data, code.Data.DeptID)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	for _, v := range list {
		v["forwardingUnit"] = code.Data.DeptName
	}

	c.OK(list, "查询成功")
}

// StockTemplateInList 入库列表
// @Summary 入库列表
// @Description 入库列表
// @Tags 库存
// @Param body body dto.StockTemplateInPageReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/in/list [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundInList() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateInPageReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, count, err := s.StockTemplateRefundInList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(count), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockTemplateOutList 出库列表
// @Summary 出库列表
// @Description 出库列表
// @Tags 库存
// @Param body body dto.StockTemplateOutPageReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/out/list [post]
// @Security Bearer
func (c StockTemplateController) StockTemplateRefundOutList() {
	s := services.StockTemplate{}
	reqData := dto.StockTemplateOutPageReq{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}

	deptId := beegouser.GetDeptId(c.Ctx)
	list, count, err := s.StockTemplateRefundOutList(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	c.PageOK(list, int(count), reqData.GetPageIndex(), reqData.GetPageSize(), "查询成功")
}

// StockRefundOutExport 退货出库单
// @Summary 退货出库运输登记表
// @Description 退货出库运输登记表
// @Tags 库存
// @Param body body dto.StockRefundOutExport true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockRefundOutExport() {
	reqData := dto.StockRefundOutExport{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	s := services.StockTemplate{}
	barcodeServ := services.Barcode{}

	list, err := s.StockRefundOutPdf(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	reqData.DeptId = deptId
	reqData.DeptName = beegouser.GetDeptName(c.Ctx)
	code, err := barcodeServ.InsertRefundOut(reqData)
	if err != nil {
		err = errors.New("生成条码失败")
		c.Error(500, err, err.Error())
		return
	}
	cs, _ := code128.Encode(code)
	// 创建一个要输出数据的文件
	imgPath := "ofile/img/" + code + ".png"
	file, _ := os.Create(imgPath)
	defer file.Close()

	// 设置图片像素大小
	qrCode, _ := barcode.Scale(cs, 205, 50)
	// 将code128的条形码编码为png图片
	png.Encode(file, qrCode)

	cols := []float64{160, 140, 45, 70, 70, 105, 105, 105}

	header := []string{"品种", "生产企业", "单位", "单价", "数量", "金额", "批号", "有效期"}
	rows := [][]string{}
	var totalMoney float64
	for _, row := range list {
		temp := []string{}
		product := utils.ToString(row[models.FieldProductName])
		enterprise := utils.ToString(row[models.FieldEnterpriseName])
		batchNumber := utils.ToString(row[models.FieldBatchNumber])
		temp = append(temp, product)
		temp = append(temp, fmt.Sprintf("%s", enterprise))
		temp = append(temp, utils.ToString(row[models.FieldUnitName]))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["unit_price"])))
		temp = append(temp, fmt.Sprintf("%d", utils.ToInt(row["quantity"])))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["money"])))
		temp = append(temp, batchNumber)
		temp = append(temp, utils.ToString(row[models.FieldExpiryDate]))

		rows = append(rows, temp)
		totalMoney += utils.ToFloat64(row["money"])
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 841.89, H: 595.28}})
	pdf.SetMarginTop(40)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")

	pdf.SetMargins(2, 5, 5, 5)
	pdf.SetFont("simsun", "", 12)
	//pdf.SetX(20)
	//pdf.SetY(20)
	//pdf.Text("[退货出库]")
	pdf.SetX(668)
	pdf.SetY(60)
	pdf.Text(code)

	imgPath2 := "ofile/img/" + code + ".jpg"
	png2j.Con2jpg(imgPath, imgPath2)
	pdf.Image(imgPath2, 640, 15, &gopdf.Rect{W: 200, H: 35})

	titleStr := reqData.DeptName + "退货单"
	pdf.SetFont("simsun", "", 25)
	textw, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((840 / 2) - (textw / 2))
	pdf.SetY(40)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 12)
	// 第一行
	curx, y := 30., pdf.GetY()
	y += 40
	pdf.SetXY(curx, y)
	pdf.Text("开票日期：" + time.Now().Format("2006-01-02"))

	// 第二行
	curx, y = 30., pdf.GetY()
	y += 20
	pdf.SetXY(curx, y)
	pdf.Text("退货原因：" + reqData.Reason)

	curx = 20
	y += 10
	pdf.SetXY(curx, y)
	h := 20.0
	x := curx
	pdf.SetFont("simsun", "", 10)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 9, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols[i]
	}
	y += h
	pdf.SetXY(curx, y)
	pdf.SetFont("simsun", "", 10)

	for _, row := range rows {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx

		height := h
		for i, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols[i])
			//lineHt := h * float64(len(lineTexts))
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols[i]-4)
				lineHt := h * float64(len(lineTexts)) * 0.6
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
		pdf.SetX(curx)
	}

	curx, y = pdf.GetX(), pdf.GetY()
	x = curx
	cols2 := []float64{160, 140, 45, 70, 70, 105, 210}
	row2 := []string{"", "", "", "", "合计：", fmt.Sprintf("%.02f", totalMoney), utils.AmountConvert(totalMoney, true)}
	for i, txt := range row2 {
		width := cols2[i]
		utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += width
	}

	pdf.SetFont("simsun", "", 12)
	// 第一行
	curx, y = 30., pdf.GetY()
	y += 25
	pdf.SetXY(curx, y)
	pdf.Text("制  单 人：" + beegouser.GetUserName(c.Ctx))
	curx = 265
	pdf.SetXY(curx, y)
	pdf.Text("经    办    人：")
	curx = 565
	pdf.SetXY(curx, y)
	pdf.Text("科室负责人：")

	// 第二行
	curx, y = 30., pdf.GetY()
	y += 30
	pdf.SetXY(curx, y)
	pdf.Text("分管主任：")
	curx = 265
	pdf.SetXY(curx, y)
	pdf.Text("财务部负责人：")
	curx = 565
	pdf.SetXY(curx, y)
	pdf.Text("单位负责人：")

	filename := titleStr + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err = pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)

}

// StockScrapOutExport 报废出库单
// @Summary 报废出库单
// @Description 报废出库单
// @Tags 库存
// @Param body body dto.StockRefundOutExport true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockScrapOutExport() {
	reqData := dto.StockRefundOutExport{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	s := services.StockTemplate{}

	list, err := s.StockRefundOutPdf(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	reqData.DeptId = deptId
	reqData.DeptName = beegouser.GetDeptName(c.Ctx)

	cols := []float64{160, 140, 45, 70, 70, 105, 105, 105}

	header := []string{"品种", "生产企业", "单位", "单价", "数量", "金额", "批号", "有效期"}
	rows := [][]string{}
	var totalMoney float64
	for _, row := range list {
		temp := []string{}
		product := utils.ToString(row[models.FieldProductName])
		enterprise := utils.ToString(row[models.FieldEnterpriseName])
		batchNumber := utils.ToString(row[models.FieldBatchNumber])
		temp = append(temp, product)
		temp = append(temp, fmt.Sprintf("%s", enterprise))
		temp = append(temp, utils.ToString(row[models.FieldUnitName]))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["unit_price"])))
		temp = append(temp, fmt.Sprintf("%d", utils.ToInt(row["quantity"])))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["money"])))
		temp = append(temp, batchNumber)
		temp = append(temp, utils.ToString(row[models.FieldExpiryDate]))

		rows = append(rows, temp)
		totalMoney += utils.ToFloat64(row["money"])
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 841.89, H: 595.28}})
	pdf.SetMarginTop(40)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")

	pdf.SetMargins(2, 5, 5, 5)
	pdf.SetFont("simsun", "", 12)

	titleStr := reqData.DeptName + "报废出库单"
	pdf.SetFont("simsun", "", 25)
	textw, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((840 / 2) - (textw / 2))
	pdf.SetY(40)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 12)
	// 第一行
	curx, y := 30., pdf.GetY()
	y += 40
	pdf.SetXY(curx, y)
	pdf.Text("开票日期：" + time.Now().Format("2006-01-02"))

	// 第二行
	curx, y = 30., pdf.GetY()
	y += 20
	pdf.SetXY(curx, y)
	pdf.Text("报废原因：" + reqData.Reason)

	curx = 20
	y += 10
	pdf.SetXY(curx, y)
	h := 20.0
	x := curx
	pdf.SetFont("simsun", "", 10)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 9, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols[i]
	}
	y += h
	pdf.SetXY(curx, y)
	pdf.SetFont("simsun", "", 10)

	for _, row := range rows {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx

		height := h
		for i, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols[i])
			//lineHt := h * float64(len(lineTexts))
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols[i]-4)
				lineHt := h * float64(len(lineTexts)) * 0.6
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
		pdf.SetX(curx)
	}

	curx, y = pdf.GetX(), pdf.GetY()
	x = curx
	cols2 := []float64{160, 140, 45, 70, 70, 105, 210}
	row2 := []string{"", "", "", "", "合计：", fmt.Sprintf("%.02f", totalMoney), utils.AmountConvert(totalMoney, true)}
	for i, txt := range row2 {
		width := cols2[i]
		utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += width
	}

	pdf.SetFont("simsun", "", 12)
	// 第一行
	curx, y = 30., pdf.GetY()
	y += 25
	pdf.SetXY(curx, y)
	pdf.Text("制  单 人：" + beegouser.GetUserName(c.Ctx))
	curx = 265
	pdf.SetXY(curx, y)
	pdf.Text("经    办    人：")
	curx = 565
	pdf.SetXY(curx, y)
	pdf.Text("科室负责人：")

	// 第二行
	curx, y = 30., pdf.GetY()
	y += 30
	pdf.SetXY(curx, y)
	pdf.Text("分管主任：")
	curx = 265
	pdf.SetXY(curx, y)
	pdf.Text("财务部负责人：")
	curx = 565
	pdf.SetXY(curx, y)
	pdf.Text("单位负责人：")

	filename := titleStr + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err = pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)

}

// TransportRecordExport 运输记录表
// @Summary 收发登记表word
// @Description 收发登记表word
// @Tags 库存
// @Param body body dto.TransportRecordWordReq true "body"
// @Success 200 {object} response.Page "{"code": 200, "data": [...]}"
// @Router /stock-template/inventory/list [post]
// @Security Bearer
func (c StockTemplateController) StockOutExport() {
	reqData := models.TransportRecord{}
	if err := c.ParseAndValidate(&c.Ctx.Input.RequestBody, &reqData); err != nil {
		c.Error(global.ParseFormErr, err, err.Error())
		return
	}
	deptId := beegouser.GetDeptId(c.Ctx)
	models.InitBasicData(deptId)

	s := services.StockTemplate{}
	barcodeServ := services.Barcode{}

	list, err := s.StockTemplateTransportRecordWord(&reqData, deptId)
	if err != nil {
		c.Error(500, err, err.Error())
		return
	}
	reqData.DeptID = deptId
	reqData.DeptName = beegouser.GetDeptName(c.Ctx)
	reqData.SetCreateBy(beegouser.GetUserId(c.Ctx))
	reqData.SetDeptId(deptId)
	code, err := barcodeServ.Insert(reqData)
	if err != nil {
		err = errors.New("生成条码失败")
		c.Error(500, err, err.Error())
		return
	}
	cs, _ := code128.Encode(code)
	// 创建一个要输出数据的文件
	imgPath := "ofile/img/" + code + ".png"
	file, _ := os.Create(imgPath)
	defer file.Close()

	// 设置图片像素大小
	qrCode, _ := barcode.Scale(cs, 205, 50)
	// 将code128的条形码编码为png图片
	png.Encode(file, qrCode)

	cols := []float64{100, 80, 85, 70, 70, 30, 35, 35, 50}

	header := []string{"品种", "生产企业", "规格", "批号", "有效期", "单位", "数量", "单价", "总价"}
	rows := [][]string{}
	var totalMoney float64
	var totalQuantity int
	for _, row := range list {
		temp := []string{}
		product := utils.ToString(row[models.FieldProductName])
		enterprise := utils.ToString(row[models.FieldEnterpriseName])
		spec := utils.ToString(row[models.FieldSpecName])
		batchNumber := utils.ToString(row[models.FieldBatchNumber])
		temp = append(temp, product)
		temp = append(temp, fmt.Sprintf("%s", enterprise))
		temp = append(temp, spec)
		temp = append(temp, batchNumber)
		temp = append(temp, utils.ToString(row[models.FieldExpiryDate]))
		temp = append(temp, utils.ToString(row[models.FieldUnitName]))
		temp = append(temp, fmt.Sprintf("%d", utils.ToInt(row["quantity"])))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["unit_price"])))
		temp = append(temp, fmt.Sprintf("%.01f", utils.ToFloat64(row["money"])))
		totalMoney += utils.ToFloat64(row["money"])
		totalQuantity += utils.ToInt(row["quantity"])
		rows = append(rows, temp)
	}

	pdf := &gopdf.GoPdf{}
	pdf.Start(gopdf.Config{PageSize: gopdf.Rect{W: 595.28, H: 841.89}})
	pdf.SetMarginTop(40)
	pdf.SetMarginBottom(40)

	pdf.AddPage()
	pdf.AddTTFFont("simsun", "static/fonts/MiSans-Medium.ttf")

	pdf.SetMargins(2, 5, 5, 5)
	pdf.SetFont("simsun", "", 10)
	//pdf.SetX(20)
	//pdf.SetY(20)
	//pdf.Text("[退货出库]")
	pdf.SetX(420)
	pdf.SetY(60)
	pdf.Text(code)

	imgPath2 := "ofile/img/" + code + ".jpg"
	png2j.Con2jpg(imgPath, imgPath2)
	pdf.Image(imgPath2, 390, 15, &gopdf.Rect{W: 200, H: 35})

	titleStr := reqData.DeptName + "出库单"
	pdf.SetFont("simsun", "", 22)
	textw, _ := pdf.MeasureTextWidth(titleStr)
	pdf.SetX((595 / 2) - (textw / 2) - 50)
	pdf.SetY(40)
	pdf.Text(titleStr)

	pdf.SetFont("simsun", "", 10)
	// 第一行
	curx, y := 20., pdf.GetY()
	y += 60
	pdf.SetXY(curx, y)
	pdf.Text("收货单位：" + reqData.ReceivingUnit)

	curx = 220
	pdf.SetXY(curx, y)
	pdf.Text("收货人/电话：")

	curx = 330
	pdf.SetXY(curx, y)
	pdf.Text("日期：" + reqData.Date)

	curx = 430
	pdf.SetXY(curx, y)
	pdf.Text("单据：" + code)

	curx = 20
	y += 10
	pdf.SetXY(curx, y)
	h := 20.0
	x := curx
	pdf.SetFont("simsun", "", 9)
	for i := 0; i < len(header); i++ {
		utils.RectFillColorMultiCell(pdf, header[i], 9, x, y, cols[i], h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += cols[i]
	}
	y += h
	pdf.SetXY(curx, y)
	pdf.SetFont("simsun", "", 8)

	for _, row := range rows {
		curx, y = pdf.GetX(), pdf.GetY()
		x = curx
		height := h
		for i, txt := range row {
			lineTexts, _ := pdf.SplitText(txt, cols[i])
			//lineHt := h * float64(len(lineTexts))
			if len(lineTexts) > 1 {
				lineTexts, _ = pdf.SplitText(txt, cols[i]-4)
				lineHt := h * float64(len(lineTexts)) * 0.6
				if lineHt > height {
					height = lineHt
				}
			}
		}

		for i, txt := range row {
			width := cols[i]
			utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, height, 0, 0, 0, gopdf.Center, gopdf.Middle)
			x += width
		}
		pdf.SetNewY(y+height, height)
		pdf.SetX(curx)
	}
	curx, y = 20, pdf.GetY()
	x = curx
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	rows2 := []string{"金额(大写)", utils.AmountConvert(totalMoney, true), fmt.Sprintf("%.1f", totalMoney)}
	cols2 := [3]float64{}
	cols2[0] = cols[0]
	cols2[1] = cols[1] + cols[2] + cols[3]
	cols2[2] = cols[4] + cols[5] + cols[6] + cols[7] + cols[8]
	for i, txt := range rows2 {
		width := cols2[i]
		utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += width
	}
	pdf.SetNewY(y, 20)
	pdf.SetX(curx)

	curx, y = 20, pdf.GetY()
	y += 20
	x = curx
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	rows3 := []string{"数量", fmt.Sprintf("%d", totalQuantity)}
	cols3 := [2]float64{}
	cols3[0] = cols[0]
	cols3[1] = cols[1] + cols[2] + cols[3] + cols[4] + cols[5] + cols[6] + cols[7] + cols[8]
	for i, txt := range rows3 {
		width := cols3[i]
		utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, h, 0, 0, 0, gopdf.Center, gopdf.Middle)
		x += width
	}
	pdf.SetNewY(y, 20)
	pdf.SetX(curx)

	curx, y = 20, pdf.GetY()
	y += 20
	x = curx
	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	rows4 := []string{"备注:"}
	cols4 := [1]float64{}
	cols4[0] = cols[0] + cols[1] + cols[2] + cols[3] + cols[4] + cols[5] + cols[6] + cols[7] + cols[8]
	for i, txt := range rows4 {
		width := cols4[i]
		utils.RectFillColorMultiCell(pdf, txt, 9, x, y, width, h, 0, 0, 0, gopdf.Left, gopdf.Middle)
		x += width
	}
	pdf.SetNewY(y, 20)

	if pdf.GetY() < 30 {
		pdf.SetY(30)
	}
	y = pdf.GetY()
	pdf.SetX(curx)
	y += 40
	pdf.SetFont("simsun", "", 10)
	curx = 40
	pdf.SetXY(curx, y)
	pdf.Text("主管：")

	curx = 200
	pdf.SetXY(curx, y)
	pdf.Text("制单：")

	curx = 400
	pdf.SetXY(curx, y)
	pdf.Text("库管：")

	filename := titleStr + time.Now().Format("20060102150405") + ".pdf"
	// 保存文件
	if err = pdf.WritePdf("ofile/" + filename); err != nil {
		fmt.Println(err)
	}
	defer func() {
		os.Remove("ofile/" + filename)
		os.Remove(imgPath)
		os.Remove(imgPath2)
	}()

	// 返回生成的 Excel 文件
	c.Ctx.Output.Download("ofile/" + filename)

}