younggee_s_api/service/s_project.go

package service

import (
	"context"
	"fmt"
	"github.com/issue9/conv"
	log "github.com/sirupsen/logrus"
	"strconv"
	"strings"
	"time"
	"youngee_b_api/db"
	"youngee_b_api/model/common_model"
	"youngee_b_api/model/gorm_model"
	"youngee_b_api/model/http_model"
)

var SProject *sProject

type sProject struct {
}

// CreateSProject 新建服务商加入商单后的公开种草任务
func (*sProject) CreateSProject(ctx context.Context, request http_model.AddToListRequest) error {

	// 1. 建立SProject信息
	// 1.1. 根据传入的ProjectId去Project表查找信息补全SProject
	var operatorType int
	if request.SubAccountId == 0 {
		operatorType = 1
	} else {
		operatorType = 2
	}
	newSProject := gorm_model.SProjectInfo{
		EnterpriseId:   request.EnterpriseId,
		SupplierId:     request.SupplierId,
		ProjectId:      request.ProjectId,
		SubAccountId:   request.SubAccountId,
		OperatorType:   operatorType,
		SProjectStatus: 2,
		StrategyStatus: 1,
	}
	projectInfo, projectErr := db.GetProjectDetail(ctx, request.ProjectId)
	if projectErr != nil {
		return projectErr
	}
	if projectInfo != nil {
		var currentTime time.Time
		currentTime = time.Now()
		newSProject.ProjectStatus = projectInfo.ProjectStatus
		newSProject.ProjectForm = projectInfo.ProjectForm
		newSProject.ContentType = projectInfo.ContentType
		newSProject.ProjectPlatform = projectInfo.ProjectPlatform
		newSProject.CreateTime = &currentTime
		newSProject.ProjectType = 1
		newSProject.ProductId = projectInfo.ProductID
		newSProject.ProjectName = projectInfo.ProjectName
	}
	sProjectId, err := db.CreateSProject(ctx, newSProject)
	if err != nil {
		log.Infof("[CreateEnterpriseSubUser] fail,err:%+v", err)
		return err
	}
	fmt.Println("创建SProject信息成功")

	// 2. 建立新的recruitStrategy
	// 2.1. 根据projectId去查找原来的recruitStrategy
	recruitStrategys, strategyErr := db.GetRecruitStrategyByProjectId(ctx, request.ProjectId)
	if strategyErr != nil {
		return strategyErr
	}
	// 2.2. 设置新的结构体以写入
	var currRecruitStrategys []gorm_model.RecruitStrategy
	for _, strategy := range recruitStrategys {
		var currStrategy gorm_model.RecruitStrategy
		currStrategy.StrategyID = strategy.StrategyID
		currStrategy.QuoteRecruitStrategyId = int(strategy.RecruitStrategyID)
		currStrategy.FeeForm = strategy.FeeForm
		currStrategy.FollowersLow = strategy.FollowersLow
		currStrategy.FollowersUp = strategy.FollowersUp
		currStrategy.RecruitNumber = strategy.RecruitNumber
		currStrategy.Offer = strategy.Offer
		currStrategy.TOffer = strategy.TOffer
		currStrategy.ProjectID = "0"
		currStrategy.ServiceCharge = strategy.ServiceCharge
		currStrategy.ServiceRate = strategy.ServiceRate
		currStrategy.SProjectId = sProjectId
		currStrategy.StrategyType = 2
		currRecruitStrategys = append(currRecruitStrategys, currStrategy)
	}
	// 2.3. 写入
	createStrategyErr := db.CreateSpecialStrategy(ctx, currRecruitStrategys)
	if createStrategyErr != nil {
		return createStrategyErr
	}
	fmt.Println("创建招募策略成功")
	return nil
}

// GetSProjectList 查找服务商加入商单的种草任务列表
func (*sProject) GetSProjectList(ctx context.Context, supplierId int, pageSize, pageNum int32, condition *common_model.SProjectCondition) (*http_model.SProjectData, error) {
	var SProjectList *http_model.SProjectData
	SProjectList = &http_model.SProjectData{}

	// 1. 加入商单后的种草任务基本信息
	sProjects, total, err := db.GetSProjectList(ctx, supplierId, pageSize, pageNum, condition)
	if err != nil {
		return nil, err
	}
	SProjectList.Total = total

	// 2. 商品信息填入
	for _, sProjectInfo := range sProjects {
		var currSProject *http_model.SProjectListReview
		currSProject = &http_model.SProjectListReview{}
		currSProject.SProjectId = sProjectInfo.SProjectId
		currSProject.ProjectId = sProjectInfo.ProjectId
		currSProject.ProjectName = sProjectInfo.ProjectName
		currSProject.ProjectPlatform = sProjectInfo.ProjectPlatform
		currSProject.ContentType = sProjectInfo.ContentType
		currSProject.ProjectForm = sProjectInfo.ProjectForm
		currSProject.ProjectStatus = sProjectInfo.ProjectStatus
		currSProject.SupplierId = sProjectInfo.SupplierId
		currSProject.SubAccountId = sProjectInfo.SubAccountId
		currSProject.OperatorType = sProjectInfo.OperatorType
		if sProjectInfo.OperatorType == 1 {
			currSProject.AddToListOperator = conv.MustString(sProjectInfo.SupplierId)
		} else {
			currSProject.AddToListOperator = conv.MustString(sProjectInfo.SubAccountId)
		}
		currSProject.CreateTime = conv.MustString(sProjectInfo.CreateTime)[0:19]
		currSProject.ApplyNum = sProjectInfo.ApplyNum
		currSProject.RecruitNum = sProjectInfo.RecruitNum
		currSProject.SettleNum = sProjectInfo.SettleNum
		currSProject.ServiceChargeActual = sProjectInfo.ServiceChargeActual
		currSProject.ServiceCharge = sProjectInfo.ServiceCharge
		currSProject.ServiceChargeSettle = sProjectInfo.ServiceChargeSettle

		// 2.2. 商品信息
		productInfo, productErr := db.GetProductByID(ctx, sProjectInfo.ProductId)
		if productErr != nil {
			return nil, productErr
		}
		if productInfo != nil {
			currSProject.ProductId = productInfo.ProductID
			currSProject.ProductPrice = productInfo.ProductPrice
			currSProject.ProductName = productInfo.ProductName
		}

		// 2.3. 商品图片信息
		productPhotoInfo, productPhotoErr := db.GetProductPhotoByProductID(ctx, sProjectInfo.ProductId)
		if productPhotoErr != nil {
			return nil, productPhotoErr
		}
		if productPhotoInfo != nil {
			for _, photo := range productPhotoInfo {
				fmt.Println(photo)
				if photo.Symbol == 1 {
					currSProject.ProductPhotoSymbol = 1
					currSProject.ProductPhotoUrl = photo.PhotoUrl
					currSProject.ProductPhotoUid = photo.PhotoUid
				}
			}
		}
		SProjectList.SProjectList = append(SProjectList.SProjectList, currSProject)
	}
	return SProjectList, nil
}

// GetSProjectDetail 查找服务商种草任务详情
func (*sProject) GetSProjectDetail(ctx context.Context, sProjectId int) (*http_model.ShowSProjectData, error) {
	var sProjectData *http_model.ShowSProjectData
	sProjectData = &http_model.ShowSProjectData{}

	// 1. 取出服务商种草表中的信息
	sProjectInfo, err := db.GetSProjectDetail(ctx, sProjectId)
	if err != nil {
		return nil, err
	}
	if sProjectInfo != nil {
		sProjectData.ProjectStatus = sProjectInfo.ProjectStatus
		sProjectData.ProjectType = sProjectInfo.ProjectType
		sProjectData.SProjectId = sProjectInfo.SProjectId
		sProjectData.ProjectName = sProjectInfo.ProjectName
		sProjectData.ProjectID = sProjectInfo.ProjectId
		sProjectData.ProjectType = sProjectInfo.ProjectType
		sProjectData.ProjectPlatform = sProjectInfo.ProjectPlatform
		sProjectData.ProjectForm = sProjectInfo.ProjectForm
		sProjectData.ContentType = sProjectInfo.ContentType
		sProjectData.EnterpriseID = sProjectInfo.EnterpriseId
		sProjectData.CreateAt = conv.MustString(sProjectInfo.CreateTime)[0:19]

		// 2. 取出商家发布的种草任务表中的信息作为补充
		projectInfo, projectErr := db.GetProjectDetail(ctx, sProjectInfo.ProjectId)
		if projectErr != nil {
			return nil, projectErr
		}
		if projectInfo != nil {
			//sProjectData.TalentType = projectInfo.TalentType
			parts := strings.Split(projectInfo.TalentType, ",")
			var result []int
			for _, part := range parts {
				num, strErr := strconv.Atoi(strings.TrimSpace(part))
				if strErr != nil {
					return nil, strErr
				}
				result = append(result, num)
			}
			fmt.Println(result)

			talentTypeCategory, talentTypeErr := db.GetTalentCategory(ctx, result)
			if talentTypeErr != nil {
				return nil, talentTypeErr
			}
			if talentTypeCategory != nil {
				categories := make([]string, 0, len(talentTypeCategory))
				for _, talentType := range talentTypeCategory {
					categories = append(categories, talentType.Category)
				}
				sProjectData.TalentType = strings.Join(categories, ",")
			}
			sProjectData.RecruitDdl = conv.MustString(projectInfo.RecruitDdl)[0:19]
			sProjectData.ProjectDetail = projectInfo.ProjectDetail
			if projectInfo.PayAt != nil {
				sProjectData.PayAt = conv.MustString(projectInfo.PayAt)[0:19]
			}
			sProjectData.ProjectDetail = projectInfo.ProjectDetail
			sProjectData.EstimatedCost = 0.0
			sProjectData.ServiceChargeRate = projectInfo.ServiceChargeRate
			sProjectData.PassAt = conv.MustString(projectInfo.PassAt)[0:19]

			autoTaskInfo, autoTaskErr := db.GetAutoTaskById(ctx, int(projectInfo.AutoTaskID))
			if autoTaskErr != nil {
				return nil, autoTaskErr
			}
			if autoTaskInfo != nil {
				newTime := projectInfo.PassAt.Add(time.Duration(autoTaskInfo.Invalid) * time.Hour)
				sProjectData.AutoFailAt = conv.MustString(newTime)[0:19]
			}

			// 3. 取出招募策略并聚合达人数量信息
			recruitStrategy, recruitErr := db.GetRecruitStrategyBySProjectId(ctx, sProjectData.SProjectId)
			if recruitErr != nil {
				return nil, recruitErr
			}
			if recruitStrategy != nil {
				for _, strategy := range recruitStrategy {
					// fmt.Println("recruitStrategy: ", strategy)
					selectedNumber, countTaskErr := db.CountTaskNumByStrategyIdAndSProjectId(ctx, sProjectData.SProjectId, strategy.StrategyID)
					if countTaskErr != nil {
						return nil, countTaskErr
					}
					sProjectData.EstimatedCost += strategy.Offer * float64(strategy.RecruitNumber)
					showStrategy := http_model.ShowSRecruitStrategy{
						StrategyID:     strategy.StrategyID,
						FeeForm:        strategy.FeeForm,
						FollowersLow:   strategy.FollowersLow,
						FollowersUp:    strategy.FollowersUp,
						RecruitNumber:  strategy.RecruitNumber,
						ServiceCharge:  projectInfo.ServiceChargeRate,
						SelectedNumber: selectedNumber,
						Offer:          strategy.Offer,
					}
					sProjectData.SRecruitStrategys = append(sProjectData.SRecruitStrategys, showStrategy)
				}
			}

			// 4. 取出种草任务创建者用户信息
			if projectInfo.OperatorType == 1 {
				// fmt.Println("商家用户")
				enterpriseInfo, enterpriseErr := db.GetEnterpriseByEnterpriseID(ctx, projectInfo.EnterpriseID)
				if enterpriseErr != nil {
					return nil, enterpriseErr
				}
				sProjectData.CreatorName = enterpriseInfo.BusinessName
				sProjectData.CreatorCompany = enterpriseInfo.BusinessName
				sProjectData.CreatorType = 1
				sProjectData.Phone = enterpriseInfo.BusinessName
			} else if projectInfo.OperatorType == 2 {
				// fmt.Println("商家子账号")
				enterpriseInfo, enterpriseErr := db.GetEnterpriseByEnterpriseID(ctx, projectInfo.EnterpriseID)
				if enterpriseErr != nil {
					return nil, enterpriseErr
				}
				sProjectData.CreatorCompany = enterpriseInfo.BusinessName
				subAccountInfo, SubAccountErr := db.FindSubAccountById(ctx, projectInfo.SubAccountId)
				if SubAccountErr != nil {
					return nil, SubAccountErr
				}
				sProjectData.Phone = subAccountInfo.PhoneNumber
				jobInfo, jobErr := db.FindJobByJobId(ctx, subAccountInfo.JobId)
				if jobErr != nil {
					return nil, jobErr
				}
				sProjectData.CreatorType = 2
				sProjectData.CreatorName = jobInfo.JobName
			}

			// 5. 商品信息
			// 5.1. 取出商品信息并聚合
			productInfo, productErr := db.GetProductByID(ctx, projectInfo.ProductID)
			if productErr != nil {
				return nil, productErr
			}
			if productInfo != nil {
				sProjectData.ProductID = productInfo.ProductID
				sProjectData.ProductName = productInfo.ProductName
				sProjectData.ProductType = productInfo.ProductType
				sProjectData.ProductPrice = productInfo.ProductPrice
				sProjectData.ProductCategory = productInfo.ProductCategory
				sProjectData.ProductCreateAt = conv.MustString(projectInfo.CreatedAt)[0:19]
			}
			// 5.2. 聚合商品图片信息
			productPhotoInfo, productPhotoErr := db.GetProductPhotoByProductID(ctx, projectInfo.ProductID)
			if productPhotoErr != nil {
				return nil, productPhotoErr
			}
			if productPhotoInfo != nil {
				for _, p := range productPhotoInfo {
					if p.Symbol == 1 {
						sProjectData.ProductMainPhotoUrl = p.PhotoUrl
						sProjectData.ProductMainPhotoUid = p.PhotoUid
						sProjectData.Symbol = 1
					}
				}
			}

			// 6. 执行要求Brief和素材
			// 6.1. Brief
			projectBrief, briefErr := db.FindProjectBriefByProjectId(ctx, sProjectData.ProjectID)
			if briefErr != nil {
				return nil, briefErr
			}
			if projectBrief != nil {
				sProjectData.ProjectBriefInfo = projectBrief
			}

			// 6.2. 素材
			projectMaterial, materialErr := db.FindProjectMaterialByProjectId(ctx, sProjectData.ProjectID)
			if materialErr != nil {
				return nil, materialErr
			}
			if projectMaterial != nil {
				sProjectData.ProjectMaterial = projectMaterial
			}
		}
	}
	return sProjectData, nil
}

// GetSpecialProjectList 查找服务商加入商单前的定向种草任务列表
func (*sProject) GetSpecialProjectList(ctx context.Context, supplierId int, pageSize, pageNum int32, condition *common_model.SpecialSProjectCondition) (*http_model.SpecialProjectListData, error) {
	var specialProjectListData *http_model.SpecialProjectListData
	specialProjectListData = &http_model.SpecialProjectListData{}

	// 1. 定向种草任务基本信息填入
	specialProjects, total, err := db.GetSpecialProjectList(ctx, supplierId, pageSize, pageNum, condition, 1)
	if err != nil {
		return nil, err
	}
	if specialProjects != nil {
		specialProjectListData.Total = total
		for _, specialProject := range specialProjects {
			var currSpecialProject *http_model.SpecialProjectResponse
			currSpecialProject = &http_model.SpecialProjectResponse{}
			currSpecialProject.ProjectId = specialProject.ProjectId
			currSpecialProject.ProjectName = specialProject.ProjectName
			currSpecialProject.ProjectStatus = int(specialProject.ProjectStatus)
			currSpecialProject.SProjectId = specialProject.SProjectId
			currSpecialProject.ProjectPlatform = specialProject.ProjectPlatform
			currSpecialProject.ProjectForm = specialProject.ProjectForm
			currSpecialProject.ContentType = specialProject.ContentType
			currSpecialProject.SProjectStatus = specialProject.SProjectStatus

			// 2. 定向种草任务商品信息填入
			// 2.1. 商品信息
			productInfo, productErr := db.GetProductByID(ctx, specialProject.ProductId)
			if productErr != nil {
				return nil, productErr
			}
			if productInfo != nil {
				currSpecialProject.ProductId = productInfo.ProductID
				currSpecialProject.ProductName = productInfo.ProductName
				currSpecialProject.ProductPrice = productInfo.ProductPrice
			}

			// 2.2. 商品图片信息
			productPhotoInfo, productPhotoErr := db.GetProductPhotoByProductID(ctx, specialProject.ProductId)
			if productPhotoErr != nil {
				return nil, productPhotoErr
			}
			if productPhotoInfo != nil {
				for _, p := range productPhotoInfo {
					if p.Symbol == 1 {
						currSpecialProject.ProductPhotoUrl = p.PhotoUrl
						currSpecialProject.ProductPhotoUid = p.PhotoUid
						currSpecialProject.ProductPhotoSymbol = 1
					}
				}
			}

			// 3. 招募策略信息
			recruitStrategy, recruitErr := db.GetRecruitStrategyByProjectId(ctx, specialProject.ProjectId)
			if recruitErr != nil {
				return nil, recruitErr
			}
			if recruitStrategy != nil {
				for _, strategy := range recruitStrategy {
					showStrategy := http_model.EasyRecruitStrategy{
						FeeForm:       strategy.FeeForm,
						RecruitNumber: strategy.RecruitNumber,
						StrategyId:    strategy.StrategyID,
					}
					currSpecialProject.RecruitStrategy = append(currSpecialProject.RecruitStrategy, showStrategy)
				}
			}

			// 4. 原种草任务信息
			projectInfo, projectErr := db.GetProjectDetail(ctx, specialProject.ProjectId)
			if projectErr != nil {
				return nil, projectErr
			}
			if projectInfo != nil {
				currSpecialProject.Tools = projectInfo.Tools
			}
			specialProjectListData.SpecialProjectInfo = append(specialProjectListData.SpecialProjectInfo, currSpecialProject)
		}
	} else {
		specialProjectListData.Total = 0
	}
	return specialProjectListData, nil
}

// GetSpecialSProjectList 查找服务商加入商单后的定向种草任务列表
func (*sProject) GetSpecialSProjectList(ctx context.Context, supplierId int, pageSize, pageNum int32, condition *common_model.SpecialSProjectCondition) (*http_model.SpecialSProjectListData, error) {
	var specialProjectListData *http_model.SpecialSProjectListData
	specialProjectListData = &http_model.SpecialSProjectListData{}
	specialProjects, total, err := db.GetSpecialProjectList(ctx, supplierId, pageSize, pageNum, condition, 2)
	if err != nil {
		return nil, err
	}
	if specialProjects != nil {
		specialProjectListData.Total = total
		// 1. 定向种草任务基本信息填入
		for _, specialProject := range specialProjects {
			var currSpecialProject *http_model.SpecialSProjectResponse
			currSpecialProject = &http_model.SpecialSProjectResponse{}
			currSpecialProject.ProjectId = specialProject.ProjectId
			currSpecialProject.ProjectName = specialProject.ProjectName
			currSpecialProject.ProjectStatus = int(specialProject.ProjectStatus)
			currSpecialProject.SProjectId = specialProject.SProjectId
			currSpecialProject.ProjectPlatform = specialProject.ProjectPlatform
			currSpecialProject.ProjectForm = specialProject.ProjectForm
			currSpecialProject.ContentType = specialProject.ContentType
			currSpecialProject.SProjectStatus = specialProject.SProjectStatus
			currSpecialProject.StrategyStatus = specialProject.StrategyStatus
			currSpecialProject.ApplyNum = specialProject.ApplyNum
			currSpecialProject.RecruitNum = specialProject.RecruitNum
			currSpecialProject.SettleNum = specialProject.SettleNum

			// 加入商单操作人信息
			if specialProject.OperatorType == 1 {
				supplierInfo, supplierErr := db.GetSupplierById(ctx, supplierId)
				if supplierErr != nil {
					return nil, supplierErr
				}
				if supplierInfo != nil {
					currSpecialProject.AddToListOperate = supplierInfo.SupplierName
				}
			} else if specialProject.OperatorType == 2 {
				subAccountInfo, subAccountErr := db.FindSubAccountById(ctx, specialProject.SubAccountId)
				if subAccountErr != nil {
					return nil, subAccountErr
				}
				if subAccountInfo != nil {
					currSpecialProject.AddToListOperate = subAccountInfo.SubAccountName
				}
			}

			// 2. 定向种草任务商品信息填入
			// 2.1. 商品信息
			productInfo, productErr := db.GetProductByID(ctx, specialProject.ProductId)
			if productErr != nil {
				return nil, productErr
			}
			if productInfo != nil {
				currSpecialProject.ProductId = productInfo.ProductID
				currSpecialProject.ProductName = productInfo.ProductName
				currSpecialProject.ProductPrice = productInfo.ProductPrice
			}

			// 2.2. 商品图片信息
			productPhotoInfo, productPhotoErr := db.GetProductPhotoByProductID(ctx, specialProject.ProductId)
			if productPhotoErr != nil {
				return nil, productPhotoErr
			}
			if productPhotoInfo != nil {
				for _, p := range productPhotoInfo {
					if p.Symbol == 1 {
						currSpecialProject.ProductPhotoUrl = p.PhotoUrl
						currSpecialProject.ProductPhotoUid = p.PhotoUid
						currSpecialProject.ProductPhotoSymbol = 1
					}
				}
			}

			// 3. 招募策略信息
			// recruitStrategy, recruitErr := db.GetRecruitStrategyByProjectId(ctx, specialProject.ProjectId)
			// if recruitErr != nil {
			// 	return nil, recruitErr
			// }
			// if recruitStrategy != nil {
			// 	for _, strategy := range recruitStrategy {
			// 		showStrategy := http_model.EasyRecruitStrategy{
			// 			FeeForm:       strategy.FeeForm,
			// 			RecruitNumber: strategy.RecruitNumber,
			// 			StrategyId:    strategy.StrategyID,
			// 		}
			// 		currSpecialProject.RecruitStrategy = append(currSpecialProject.RecruitStrategy, showStrategy)
			// 	}
			// }

			// 4. 原种草任务信息
			projectInfo, projectErr := db.GetProjectDetail(ctx, specialProject.ProjectId)
			if projectErr != nil {
				return nil, projectErr
			}
			if projectInfo != nil {
				currSpecialProject.Tools = projectInfo.Tools
			}
			specialProjectListData.SpecialProjectInfo = append(specialProjectListData.SpecialProjectInfo, currSpecialProject)
		}
	} else {
		specialProjectListData.Total = 0
	}
	return specialProjectListData, nil
}

// UpdateSProject 更新SProject信息
func (*sProject) UpdateSProject(ctx context.Context, request *http_model.SpecialSProjectAddToListRequest) error {
	updateSProjectErr := db.UpdateSProjectStatus(ctx, request)
	if updateSProjectErr != nil {
		return updateSProjectErr
	}
	return nil
}

// CreateSpecialStrategy 添加服务商招募策略
func (*sProject) CreateSpecialStrategy(ctx context.Context, request *http_model.SpecialAddStrategyRequest) error {
	// 1. 添加服务商招募策略
	// 1.1. 整理数据
	var recruitStrategys []gorm_model.RecruitStrategy
	for _, strategy := range request.RecruitStrategys {
		var recruitStrategy *gorm_model.RecruitStrategy
		recruitStrategy = &gorm_model.RecruitStrategy{}

		recruitStrategy.StrategyID = strategy.StrategyID
		recruitStrategy.QuoteRecruitStrategyId = strategy.QuoteRecruitStrategyId
		recruitStrategy.FeeForm = strategy.FeeForm
		recruitStrategy.StrategyID = strategy.StrategyID
		recruitStrategy.FollowersLow = strategy.FollowersLow
		recruitStrategy.FollowersUp = strategy.FollowersUp
		recruitStrategy.RecruitNumber = strategy.RecruitNumber
		recruitStrategy.Offer = strategy.Offer
		recruitStrategy.ServiceCharge = strategy.ServiceCharge
		recruitStrategy.StrategyType = 2
		recruitStrategy.QuoteRecruitStrategyId = strategy.QuoteRecruitStrategyId

		// 一口价需要计算服务费率和达人所见报价
		if strategy.FeeForm == 3 {
			recruitStrategy.ServiceRate = strategy.ServiceRate
		} else {
			recruitStrategy.ServiceRate = int(strategy.ServiceCharge / strategy.Offer)
		}
		recruitStrategy.TOffer = strategy.Offer - strategy.ServiceCharge
		recruitStrategy.ProjectID = "0"
		recruitStrategy.SProjectId = request.SProjectId
		recruitStrategys = append(recruitStrategys, *recruitStrategy)
	}

	createErr := db.CreateSpecialStrategy(ctx, recruitStrategys)
	if createErr != nil {
		return createErr
	}

	// 2. 修改sProject中的字段
	updateErr := db.UpdateSProjectStrategyStatus(ctx, request)
	if updateErr != nil {
		return updateErr
	}
	return nil
}

// FullSProjectBillList 种草任务账单列表
func (*sProject) FullSProjectBillList(ctx context.Context, request *http_model.FullSProjectBillListRequest) (*http_model.FullSProjectBillData, error) {
	var currSProjectBillData *http_model.FullSProjectBillData
	currSProjectBillData = &http_model.FullSProjectBillData{}

	// 1. 根据SupplierId和账单状态查询数据
	fullSProjectBillData, total, err := db.GetFullSProjectBillList(ctx, request.SupplierId, request.ProjectPlatform, request.ProjectStatus, request.PageSize, request.PageNum)
	if err != nil {
		return nil, err
	}
	if fullSProjectBillData != nil {
		currSProjectBillData.Total = total
		for _, b := range fullSProjectBillData {
			var billData *http_model.FullSProjectBillListData
			billData = &http_model.FullSProjectBillListData{}
			billData.SProjectId = b.SProjectId
			billData.ProjectId = b.ProjectId
			billData.ProjectPlatform = b.ProjectPlatform
			billData.ProjectForm = b.ProjectForm
			billData.ContentType = b.ContentType
			billData.ProjectStatus = b.ProjectStatus
			billData.EnterpriseId = b.EnterpriseId
			billData.SupplierId = b.SupplierId
			billData.SubAccountId = b.SubAccountId
			billData.ServiceChargeActual = b.ServiceChargeActual
			billData.ServiceChargeSettle = b.ServiceChargeSettle

			// 1.2. 补充商品信息
			productInfo, productErr := db.GetProductByID(ctx, b.ProductId)
			if productErr != nil {
				return nil, productErr
			}
			if productInfo != nil {
				billData.ProductId = productInfo.ProductID
				billData.ProductPrice = productInfo.ProductPrice
				billData.ProductName = productInfo.ProductName
			}

			// 1.3. 商品图片信息
			productPhotoInfo, productPhotoErr := db.GetProductPhotoByProductID(ctx, b.ProductId)
			if productPhotoErr != nil {
				return nil, productPhotoErr
			}
			if productPhotoInfo != nil {
				for _, photo := range productPhotoInfo {
					//fmt.Println(photo)
					if photo.Symbol == 1 {
						billData.ProductPhotoSymbol = 1
						billData.ProductPhotoUrl = photo.PhotoUrl
						billData.ProductPhotoUid = photo.PhotoUid
					}
				}
			}
			currSProjectBillData.SProjectList = append(currSProjectBillData.SProjectList, billData)
		}
	}
	return currSProjectBillData, nil
}

// FullSProjectTaskBillList 种草子任务账单列表
func (*sProject) FullSProjectTaskBillList(ctx context.Context, request *http_model.FullSProjectTaskBillListRequest) (*http_model.FullSProjectTaskBillData, error) {
	var currSProjectTaskBillData *http_model.FullSProjectTaskBillData
	currSProjectTaskBillData = &http_model.FullSProjectTaskBillData{}
	currSProjectTaskBillData.DraftFee = 0
	currSProjectTaskBillData.DraftFeeSettle = 0

	// 1. 查找子任务
	taskList, total, taskListErr := db.GetSProjectTaskList(ctx, request.SProjectId, request.TalentId, request.PageSize, request.PageNum)
	if taskListErr != nil {
		return nil, taskListErr
	}
	if taskList != nil {
		currSProjectTaskBillData.Total = total
		for _, task := range taskList {
			var curr *http_model.FullSProjectTaskBillListData
			curr = &http_model.FullSProjectTaskBillListData{}
			curr.TaskId = task.TaskID
			curr.ServiceCharge = task.ServiceCharge
			curr.ViewNum = 0
			curr.VoteNum = 0
			curr.CommitNum = 0
			curr.CollectNum = 0
			curr.ServiceCharge = task.ServiceCharge
			curr.DraftFee = task.DraftFee
			curr.DelayRate = task.ScriptBreakRate + task.SketchBreakRate + task.LinkBreakRate + task.DataBreakRate
			curr.RealServiceCharge = task.RealPayment - task.SettleAmount
			curr.SettleAmount = task.SettleAmount
			curr.SettleTime = conv.MustString(task.CompleteDate)
			currSProjectTaskBillData.DraftFee += curr.DraftFee
			currSProjectTaskBillData.DraftFeeSettle += curr.SettleAmount
			currSProjectTaskBillData.SProjectTaskList = append(currSProjectTaskBillData.SProjectTaskList, curr)
		}

		// 2. 补充任务信息
		sProjectInfo, sProjectErr := db.GetSProjectDetail(ctx, request.SProjectId)
		if sProjectErr != nil {
			return nil, sProjectErr
		}
		if sProjectInfo != nil {
			currSProjectTaskBillData.SettleNum = sProjectInfo.SettleNum
			currSProjectTaskBillData.ChooseNum = sProjectInfo.ApplyNum
			currSProjectTaskBillData.ServiceCharge = sProjectInfo.ServiceCharge
			currSProjectTaskBillData.ServiceChargeSettle = sProjectInfo.ServiceChargeSettle
		}
	}
	return currSProjectTaskBillData, nil
}