jyps/xlsx/highBidding.go

package main

import (
	"fmt"
	"github.com/xuri/excelize/v2"
	util "jygit.jydev.jianyu360.cn/data_processing/common_utils"
	"jygit.jydev.jianyu360.cn/data_processing/common_utils/mongodb"
	"log"
)

func HighBidding() {
	f, err := excelize.OpenFile("./售后组测试企业_20240201_1683.xlsx")
	if err != nil {
		fmt.Println(err)
		return
	}
	defer func() {
		if err := f.Close(); err != nil {
			fmt.Println(err)
		}
	}()

	rows, err := f.GetRows("详细数据")
	if err != nil {
		fmt.Println(err)
		return
	}

	Mgo := &mongodb.MongodbSim{
		//MongodbAddr: "172.17.189.140:27080",
		MongodbAddr: "127.0.0.1:27083",
		Size:        10,
		DbName:      "qfw_high",
		UserName:    "SJZY_RWbid_ES",
		Password:    "SJZY@B4i4D5e6S",
		Direct:      true,
	}
	Mgo.InitPool()

	count := 0
	for i := 1; i < len(rows); i++ {
		s := rows[i][25]
		if len(s) == 0 {
			continue
		}
		se := util.SimpleEncrypt{Key: "topJYBX2019"}
		id := se.DecodeString(s)

		data, _ := Mgo.FindById("ibidding", id, nil)
		if len(*data) > 0 {
			count++
		}
		//fmt.Println(id)
	}

	log.Print(count)
}