| | |
|---|
| | | f.SetCellValue("Sheet1", "E"+column, v.Unit) |
|---|
| | | f.SetCellValue("Sheet1", "F"+column, v.SalePrice) |
|---|
| | | |
|---|
| | | slf.FillDealerTypeToExcel(v.InputItems, inputStart, i+3, inputTypes, f) |
|---|
| | | slf.FillDealerTypeToExcel(v.OutputItems, outputStart, i+3, outputTypes, f) |
|---|
| | | slf.FillDealerTypeToExcel(v.InputItems, inputStart, i+3, inputTypes, f, constvar.InputTotalHeader) |
|---|
| | | slf.FillDealerTypeToExcel(v.OutputItems, outputStart, i+3, outputTypes, f, constvar.OutPutTotalHeader) |
|---|
| | | } |
|---|
| | | |
|---|
| | | fileName := fmt.Sprintf("%s月度统计报表%s.xlsx", "仓库", time.Now().Format("2006-01-02-1504")) |
|---|
| | |
|---|
| | | return sum |
|---|
| | | } |
|---|
| | | |
|---|
| | | func (slf *WarehouseMonthFormsService) FillDealerTypeToExcel(items []*models.WarehouseStatsItems, startIndex int, column int, dealerTypes []string, f *excelize.File) { |
|---|
| | | func (slf *WarehouseMonthFormsService) FillDealerTypeToExcel(items []*models.WarehouseStatsItems, startIndex int, column int, dealerTypes []string, f *excelize.File, totalHeader string) { |
|---|
| | | columnStr := strconv.Itoa(column) |
|---|
| | | sum := slf.SumItems(items) |
|---|
| | | detailMap := models.WarehouseStatsItemMap(items) |
|---|
| | |
|---|
| | | var amount decimal.Decimal |
|---|
| | | if detailMap[dealerTypes[i]] != nil { |
|---|
| | | amount = detailMap[dealerTypes[i]].Amount |
|---|
| | | } else if dealerTypes[i] == constvar.InputTotalHeader { |
|---|
| | | } else if dealerTypes[i] == totalHeader { |
|---|
| | | amount = sum |
|---|
| | | } |
|---|
| | | f.SetCellValue("Sheet1", getColumnAlphabet(startIndex+i)+columnStr, amount) |
|---|
