package base_from_yongyi_v2 import ( "eta/eta_data_analysis/models" "eta/eta_data_analysis/utils" "fmt" "github.com/xuri/excelize/v2" "strings" ) func getClassifySortMap() map[string]int { classifyMap := map[string]int{ "日度-商品猪出栏价": 1, "日度-商品猪标肥价差": 2, "日度-商品猪全国均价和宰量": 3, "日度-屠宰企业屠宰量": 4, "历史猪价": 5, "周度-商品猪出栏价": 6, "周度-体重": 7, "周度-屠宰厂宰前活猪重": 8, "周度-各体重段价差": 9, "二育成本": 10, "二育销量": 11, "育肥栏舍利用率": 12, "周度-养殖利润最新": 13, "周度-当期、预期成本": 14, "周度-育肥全价料出厂价": 15, "周度-成本计算附件": 16, "周度-毛白价差": 17, "周度-50公斤二元母猪价格": 18, "周度-规模场15公斤仔猪出栏价": 19, "仔猪、母猪": 20, "周度-河南屠宰白条成本": 21, "周度-淘汰母猪价格": 22, "周度-宰后结算价": 23, "周度-冻品库存": 24, "周度-冻品库存多样本": 25, "周度-鲜销率": 26, "周度-猪肉价（前三等级白条均价）": 27, "周度-猪肉产品价格": 28, "周度-屠宰企业日度屠宰量": 29, "周度-屠宰新2022.10.28": 30, "月度出栏完成率": 31, "月度计划出栏量": 32, "月度-淘汰母猪屠宰厂宰杀量": 33, "月度-猪料销量": 34, "月度-屠宰企业开工率": 35, "月度-屠宰厂公母比例": 36, "月度-生产指标（2021.5.7新增）": 37, "月度-生产指标2": 38, "月度-二元三元能繁比例": 39, "月度-能繁母猪存栏（2020年2月新增）": 40, "月度-小猪存栏（2020年5月新增）": 41, "月度-中猪存栏（2020年5月新增）": 42, "月度-大猪存栏（2020年5月新增）": 43, "月度-商品猪出栏量": 44, "月度-能繁母猪存栏量": 45, "月度-原种场二元后备母猪销量及出栏日龄": 46, "涌益样本测算": 47, } return classifyMap } var YongyiWeeklySheetMap5 map[string]*models.YongyiSheet var YongyiWeeklySheetMap6 map[string]*models.YongyiSheet var YongyiWeeklySheetMap9 map[string]*models.YongyiSheet var YongyiBaseInfoMap map[string]*models.YongyiSheet func init() { YongyiWeeklySheetMap5 = map[string]*models.YongyiSheet{ "周度-50公斤二元母猪价格": {"50公斤二元母猪价格", "周度-50公斤二元母猪价格", "周度", "元/头"}, "周度-规模场15公斤仔猪出栏价": {"规模场15公斤仔猪出栏价", "周度-规模场15公斤仔猪出栏价", "周度", "元/头"}, "周度-宰后结算价": {"宰后结算价", "周度-宰后结算价", "周度", "元/公斤"}, "周度-冻品库存": {"冻品库存", "周度-冻品库存", "周度", "%"}, "周度-猪肉价（前三等级白条均价）": {"前三等级白条均价", "周度-猪肉价（前三等级白条均价）", "周度", "元/公斤"}, } YongyiWeeklySheetMap6 = map[string]*models.YongyiSheet{ "周度-冻品库存多样本": {"冻品库存多样本", "周度-冻品库存多样本", "周度", "%"}, "月度出栏完成率": {"出栏完成率", "月度出栏完成率", "旬度", "%"}, } YongyiWeeklySheetMap9 = map[string]*models.YongyiSheet{ "月度-小猪存栏（2020年5月新增）": {"50kg以下小猪存栏量", "月度-小猪存栏（2020年5月新增）", "月度", "头"}, "月度-中猪存栏（2020年5月新增）": {"中猪存栏量", "月度-中猪存栏（2020年5月新增）", "月度", "头"}, "月度-大猪存栏（2020年5月新增）": {"大猪存栏量", "月度-大猪存栏（2020年5月新增）", "月度", "头"}, } YongyiBaseInfoMap = map[string]*models.YongyiSheet{ "出栏价": {"商品猪出栏价", "日度-商品猪出栏价", "日度", "元/公斤"}, "标肥价差": {"", "日度-商品猪标肥价差", "日度", "元/公斤"}, "价格+宰量": {"", "日度-商品猪全国均价和宰量", "日度", "元/公斤"}, "屠宰企业日度屠宰量": {"商品猪日屠宰量", "日度-屠宰企业屠宰量", "日度", "头"}, "周度-商品猪出栏价": {"商品猪出栏价", "周度-商品猪出栏价", "周度", "元/公斤"}, "周度-体重": {"商品猪出栏体重", "周度-体重", "周度", "公斤"}, "周度-屠宰厂宰前活猪重": {"商品猪宰前活猪重", "周度-屠宰厂宰前活猪重", "周度", "公斤"}, "周度-各体重段价差": {"", "周度-各体重段价差", "周度", "元/斤"}, "周度-50公斤二元母猪价格": {"50公斤二元母猪价格", "周度-50公斤二元母猪价格", "周度", "元/头"}, "周度-规模场15公斤仔猪出栏价": {"规模场15公斤仔猪出栏价", "周度-规模场15公斤仔猪出栏价", "周度", "元/头"}, "周度-宰后结算价": {"宰后结算价", "周度-宰后结算价", "周度", "元/公斤"}, "周度-冻品库存": {"冻品库存", "周度-冻品库存", "周度", "%"}, "周度-冻品库存多样本": {"冻品库存多样本", "周度-冻品库存多样本", "周度", "%"}, "周度-猪肉价（前三等级白条均价）": {"前三等级白条均价", "周度-猪肉价（前三等级白条均价）", "周度", "元/公斤"}, "月度出栏完成率": {"出栏完成率", "月度出栏完成率", "旬度", "%"}, "月度计划出栏量": {"月度计划出栏量环比", "月度计划出栏量", "月度", "%"}, "月度-能繁母猪存栏（2020年2月新增）": {"能繁母猪存栏量", "月度-能繁母猪存栏（2020年2月新增）", "月度", "头"}, "月度-小猪存栏（2020年5月新增）": {"50kg以下小猪存栏量", "月度-小猪存栏（2020年5月新增）", "月度", "头"}, "月度-中猪存栏（2020年5月新增）": {"中猪存栏量", "月度-中猪存栏（2020年5月新增）", "月度", "头"}, "月度-大猪存栏（2020年5月新增）": {"大猪存栏量", "月度-大猪存栏（2020年5月新增）", "月度", "头"}, "月度-商品猪出栏量": {"商品猪出栏量", "月度-商品猪出栏量", "月度", "头"}, "历史猪价": {"历史猪价", "历史猪价", "月度", "元/公斤"}, "二育成本": {"", "二育成本", "周度", "kg"}, //单位有四种kg、无， 元/kg， 元 "二育销量": {"二育销量", "二育销量", "周度", "%"}, "育肥栏舍利用率": {"育肥栏舍利用率", "育肥栏舍利用率", "旬度", "%"}, "周度-养殖利润最新": {"出栏肥猪利润", "周度-养殖利润最新", "周度", "元/头"}, "周度-当期、预期成本": {"", "周度-当期、预期成本", "周度", "元/kg"}, "育肥全价料出厂价": {"育肥全价料出厂均价参考", "育肥全价料出厂价", "周度", "元/吨"}, "周度-成本计算附件": {"", "周度-成本计算附件", "周度", "元/头"}, //多个单位：元/头，%，kg，元 "周度-毛白价差": {"毛白价差", "周度-毛白价差", "周度", "元/公斤"}, "仔猪、母猪": {"仔猪价", "仔猪、母猪", "周度", "元/头"}, //多个前缀，仔猪价，二元母猪价 "周度-河南屠宰白条成本": {"河南屠宰白条成本", "周度-河南屠宰白条成本", "周度", "元/kg"}, //多个单位：kg，元/kg，元/头 "周度-淘汰母猪价格": {"淘汰母猪价格", "周度-淘汰母猪价格", "周度", "元/斤"}, "鲜销率": {"鲜销率", "鲜销率", "周度", "%"}, "周度-猪肉产品价格": {"猪肉产品价格", "周度-猪肉产品价格", "周度", "元/公斤"}, "周度-屠宰企业日度屠宰量": {"屠宰企业日度屠宰量", "周度-屠宰企业日度屠宰量", "周度", "头"}, "周度-屠宰新2022.10.28": {"不同规模屠宰厂宰杀量", "周度-屠宰新2022.10.28", "周度", "头"}, "月度-淘汰母猪屠宰厂宰杀量": {"淘汰母猪屠宰厂宰杀量", "月度-淘汰母猪屠宰厂宰杀量", "月度", "头"}, "月度-猪料销量": {"饲料销量（环比）", "月度-猪料销量", "月度", "头"}, //todo 单位有问题 "月度-屠宰企业开工率": {"", "月度-屠宰企业开工率", "月度", "%"}, "月度-屠宰厂公母比例": {"屠宰厂", "月度-屠宰厂公母比例", "月度", "头"}, //多个单位：头，% "月度-生产指标（2021.5.7新增）": {"生产指标", "月度-生产指标（2021.5.7新增）", "月度", "头"}, //多个单位：头，% "月度-生产指标2": {"生产指标", "月度-生产指标2", "月度", "头"}, //多个单位：头，% "月度-二元三元能繁比例": {"能繁母猪存栏量", "月度-二元三元能繁比例", "月度", "%"}, //多个单位：头，% "月度-能繁母猪存栏量": {"能繁母猪存栏量", "月度-能繁母猪存栏量", "月度", "头"}, "月度-原种场二元后备母猪销量及出栏日龄": {"原种场二元后备母猪销量及出栏日龄", "月度-原种场二元后备母猪销量及出栏日龄", "月度", "头"}, "涌益样本测算": {"涌益样本测算", "涌益样本测算", "月度", "窝"}, //多个单位：头，%，窝，公斤，元/公斤 } } func GetBaseInfo(sheetName string) (classifyName string, classifySort int, frequency string, unit string, namePrefix string, namePrefixPingin string) { // 获取指标分类 info, ok := YongyiBaseInfoMap[sheetName] if !ok { return } classifyName = info.ClassifyName classifyMap := getClassifySortMap() classifySort, _ = classifyMap[classifyName] frequency = info.Frequency unit = info.Unit namePrefix = info.NamePrefix namePrefixPingin = "yyzx" + utils.GetFirstPingYin(namePrefix) return } func GetMergeCells(f *excelize.File, sheet string) (mergeCellMap map[int]map[int]string, err error) { mergedCells, err := f.GetMergeCells(sheet) if err != nil { fmt.Println(err) return } mergeCellMap = make(map[int]map[int]string) // 遍历所有合并单元格范围 for _, cellRange := range mergedCells { fmt.Println("Merged Cell Range:", cellRange) cellVal := cellRange.GetCellValue() // 解析合并单元格范围，例如 "A1:B2" startCell, endCell := cellRange.GetStartAxis(), cellRange.GetEndAxis() if err != nil { fmt.Println(err) continue } // 解析起始单元格的下标 startCol, startRow, err := excelize.CellNameToCoordinates(startCell) if err != nil { fmt.Println(err) continue } // 解析结束单元格的下标 endCol, endRow, err := excelize.CellNameToCoordinates(endCell) if err != nil { fmt.Println(err) continue } // 打印合并单元格的起始和结束下标 fmt.Printf("Start: Row %d, Col %d\n", startRow, startCol) fmt.Printf("End: Row %d, Col %d\n", endRow, endCol) //把合并的单元格整理成单个单元格，用于计算 for i := startRow; i <= endRow; i++ { cellMap, ok := mergeCellMap[i-1] if !ok { cellMap = make(map[int]string) } for j := startCol; j <= endCol; j++ { cellMap[j-1] = strings.TrimSpace(cellVal) } mergeCellMap[i-1] = cellMap } } return } // GetWeekly13IndexName 二育成本指标名称处理 func GetWeekly13IndexName(name, level string) string { switch { case strings.Contains(name, "二育主流采购体重段"): return fmt.Sprintf("二育主流%s采购体重段", level) case strings.Contains(name, "计划出栏体重"): return fmt.Sprintf("计划%s出栏体重", level) case strings.Contains(name, "料肉比"): return fmt.Sprintf("%s料肉比", level) case strings.Contains(name, "采购成本"): return fmt.Sprintf("%s采购成本", level) case strings.Contains(name, "运费+损耗"): return fmt.Sprintf("%s运费+损耗", level) case strings.Contains(name, "增重饲料成本"): return fmt.Sprintf("%s增重饲料成本", level) case strings.Contains(name, "二育成本"): return fmt.Sprintf("%s二育成本", level) } return name } // GetWeekly13IndexUnit 二育成本指标名称处理 func GetWeekly13IndexUnit(name string) string { switch { case strings.Contains(name, "二育主流采购体重段") || strings.Contains(name, "计划出栏体重"): return "kg" case strings.Contains(name, "料肉比"): return "无" case strings.Contains(name, "采购成本") || strings.Contains(name, "运费+损耗") || strings.Contains(name, "二育成本"): return "元/kg" case strings.Contains(name, "增重饲料成本"): return "元" } return name }