opms_backend/opms_parent/app/service/opsdev/delivery_project.go

package opsdev

import (
	"context"
	contractmodel "dashoo.cn/opms_parent/app/model/contract"
	"errors"
	"fmt"
	"strconv"
	"strings"

	"dashoo.cn/common_definition/comm_def"
	eventdao "dashoo.cn/opms_parent/app/dao/opsdev"
	opsdevmodel "dashoo.cn/opms_parent/app/model/opsdev"
	"dashoo.cn/opms_parent/app/service"

	"github.com/gogf/gf/database/gdb"
	"github.com/gogf/gf/frame/g"
	"github.com/gogf/gf/os/gtime"
)

// DeliveryProjectService 交付项目服务
type DeliveryProjectService struct {
	*service.ContextService
	Dao *eventdao.OpsDeliveryProjectDao
}

// NewDeliveryProjectService 初始化服务
func NewDeliveryProjectService(ctx context.Context) (*DeliveryProjectService, error) {
	svc := &DeliveryProjectService{}
	var err error
	if svc.ContextService, err = svc.Init(ctx); err != nil {
		return nil, err
	}
	svc.Dao = eventdao.NewOpsDeliveryProjectDao(svc.Tenant)
	return svc, nil
}

// GetList 获取列表（带权限校验）
func (s *DeliveryProjectService) GetList(req *opsdevmodel.OpsDeliveryProjectSearchReq) (int64, []*opsdevmodel.OpsDeliveryProject, error) {
	m := s.Dao.Ctx(s.Ctx)

	// 过滤已删除数据
	m = m.Where("deleted_time IS NULL")

	// 权限控制
	where := s.buildPermissionWhere()
	if where != "" {
		m = m.Where(where)
	}

	// 项目状态筛选（支持多选，逗号分隔）
	if req.ProjectStatus != "" {
		statusList := strings.Split(req.ProjectStatus, ",")
		if len(statusList) > 0 {
			m = m.Where("project_status", statusList)
		}
	}

	// 项目名称模糊查询
	if req.ProjectName != "" {
		m = m.Where("project_name like ?", "%"+req.ProjectName+"%")
	}

	// 销售负责人模糊查询
	if req.SalesUserName != "" {
		m = m.Where("sales_user_name like ?", "%"+req.SalesUserName+"%")
	}

	// 交付负责人模糊查询
	if req.DeliveryUserName != "" {
		m = m.Where("delivery_user_name like ?", "%"+req.DeliveryUserName+"%")
	}

	// 关键词搜索（项目名称、合同编号）
	if req.KeyWords != "" {
		m = m.Where("project_name like ? OR contract_no like ?", "%"+req.KeyWords+"%", "%"+req.KeyWords+"%")
	}

	// 其他查询条件
	if req.Status != "" {
		m = m.Where("project_status", req.Status)
	}
	if req.ProductLine != "" {
		productLineList := strings.Split(req.ProductLine, ",")
		m = m.Where("product_line", productLineList)
	}
	if req.DeliveryUserId > 0 {
		m = m.Where("delivery_user_id", req.DeliveryUserId)
	}
	if req.SalesUserId > 0 {
		m = m.Where("sales_user_id", req.SalesUserId)
	}
	if req.OpsManagerUserId > 0 {
		m = m.Where("attribute4", req.OpsManagerUserId)
	}
	if req.OpsManagerUserName != "" {
		m = m.Where("attribute3 like ?", "%"+req.OpsManagerUserName+"%")
	}

	// 获取总数
	total, err := m.Count()
	if err != nil {
		return 0, nil, err
	}

	// 分页查询
	if req.PageNum <= 0 {
		req.PageNum = 1
	}
	if req.PageSize <= 0 {
		req.PageSize = 20
	}

	// 排序
	orderBy := "created_time desc"
	if req.SortField != "" && req.SortOrder != "" {
		orderBy = req.SortField + " " + req.SortOrder
	}

	var list []*opsdevmodel.OpsDeliveryProject
	err = m.Page(req.PageNum, req.PageSize).Order(orderBy).Scan(&list)
	if err != nil {
		return 0, nil, err
	}

	// 确保空列表返回 [] 而非 nil
	if list == nil {
		list = make([]*opsdevmodel.OpsDeliveryProject, 0)
	}

	return int64(total), list, nil
}

// GetListAll 获取所有项目列表（不带权限校验，仅用于下拉选择等场景）
func (s *DeliveryProjectService) GetListAll(req *opsdevmodel.OpsDeliveryProjectSearchReq) (int64, []*opsdevmodel.OpsDeliveryProject, error) {
	m := s.Dao.Ctx(s.Ctx)

	// 过滤已删除数据
	m = m.Where("deleted_time IS NULL")

	// 项目状态筛选（支持多选，逗号分隔）
	if req.ProjectStatus != "" {
		statusList := strings.Split(req.ProjectStatus, ",")
		if len(statusList) > 0 {
			m = m.Where("project_status", statusList)
		}
	}

	// 项目名称模糊查询
	if req.ProjectName != "" {
		m = m.Where("project_name like ?", "%"+req.ProjectName+"%")
	}

	// 销售负责人模糊查询
	if req.SalesUserName != "" {
		m = m.Where("sales_user_name like ?", "%"+req.SalesUserName+"%")
	}

	// 交付负责人模糊查询
	if req.DeliveryUserName != "" {
		m = m.Where("delivery_user_name like ?", "%"+req.DeliveryUserName+"%")
	}

	// 关键词搜索（项目名称、合同编号）
	if req.KeyWords != "" {
		m = m.Where("project_name like ? OR contract_no like ?", "%"+req.KeyWords+"%", "%"+req.KeyWords+"%")
	}

	// 其他查询条件
	if req.Status != "" {
		m = m.Where("project_status", req.Status)
	}
	if req.ProductLine != "" {
		productLineList := strings.Split(req.ProductLine, ",")
		m = m.Where("product_line", productLineList)
	}
	if req.DeliveryUserId > 0 {
		m = m.Where("delivery_user_id", req.DeliveryUserId)
	}
	if req.SalesUserId > 0 {
		m = m.Where("sales_user_id", req.SalesUserId)
	}
	if req.OpsManagerUserId > 0 {
		m = m.Where("attribute4", req.OpsManagerUserId)
	}
	if req.OpsManagerUserName != "" {
		m = m.Where("attribute3 like ?", "%"+req.OpsManagerUserName+"%")
	}

	// 获取总数
	total, err := m.Count()
	if err != nil {
		return 0, nil, err
	}

	// 分页查询
	if req.PageNum <= 0 {
		req.PageNum = 1
	}
	if req.PageSize <= 0 {
		req.PageSize = 20
	}

	// 排序
	orderBy := "created_time desc"
	if req.SortField != "" && req.SortOrder != "" {
		orderBy = req.SortField + " " + req.SortOrder
	}

	var list []*opsdevmodel.OpsDeliveryProject
	err = m.Page(req.PageNum, req.PageSize).Order(orderBy).Scan(&list)
	if err != nil {
		return 0, nil, err
	}

	// 确保空列表返回 [] 而非 nil
	if list == nil {
		list = make([]*opsdevmodel.OpsDeliveryProject, 0)
	}

	return int64(total), list, nil
}

// GetDelegatedProjectList 获取委托项目列表（自己负责 + 被授权）
func (s *DeliveryProjectService) GetDelegatedProjectList(req *opsdevmodel.OpsDeliveryProjectDelegatedSearchReq) (int64, []*opsdevmodel.OpsDeliveryProject, error) {
	userId := s.GetCxtUserId()
	if userId <= 0 {
		return 0, nil, errors.New("无法获取当前用户信息")
	}

	m := s.Dao.Ctx(s.Ctx)

	// 过滤已删除数据
	m = m.Where("deleted_time IS NULL")

	allVisibleRoles := []string{
		"GeneralManager",
		"SalesDirector",
		"ResearchAndDevelopmentDirector",
		"ResearchAndDevelopmentSupervisor",
		"PersonnelDirector",
		"SysAdmin",
		"GeneralManagerAssistant",
	}

	hasAllVisible := false
	for _, role := range allVisibleRoles {
		if service.StringsContains(s.CxtUser.Roles, role) {
			hasAllVisible = true
			break
		}
	}

	if !hasAllVisible {
		conditions := []string{}

		if service.StringsContains(s.CxtUser.Roles, "RegionalManager") {
			conditions = append(conditions, fmt.Sprintf(
				"EXISTS (SELECT 1 FROM base_region_auth WHERE base_region_auth.user_id = %d AND base_region_auth.city_id = ops_delivery_project.sales_region_id)",
				userId,
			))
		}

		if service.StringsContains(s.CxtUser.Roles, "SalesEngineer") {
			conditions = append(conditions, fmt.Sprintf("ops_delivery_project.sales_user_id = %d", userId))
		}

		if service.StringsContains(s.CxtUser.Roles, "ProjectManager") ||
			service.StringsContains(s.CxtUser.Roles, "ProjectDeliveryManager") {
			conditions = append(conditions, fmt.Sprintf(
				"(ops_delivery_project.delivery_user_id = %d OR EXISTS (SELECT 1 FROM ops_delivery_project_delegate WHERE ops_delivery_project_delegate.user_id = %d AND ops_delivery_project_delegate.project_id = ops_delivery_project.id))",
				userId, userId,
			))
		}

		if service.StringsContains(s.CxtUser.Roles, "OperationsEngineer") {
			conditions = append(conditions, fmt.Sprintf("ops_delivery_project.attribute4 = %d", userId))
		}

		if len(conditions) > 0 {
			m = m.Where(fmt.Sprintf("(%s)", strings.Join(conditions, " OR ")))
		} else {
			m = m.Where("1=0")
		}
	}

	// 项目状态筛选（支持多选，逗号分隔）
	if req.ProjectStatus != "" {
		statusList := strings.Split(req.ProjectStatus, ",")
		if len(statusList) > 0 {
			m = m.Where("project_status", statusList)
		}
	}

	// 项目名称模糊查询
	if req.ProjectName != "" {
		m = m.Where("project_name like ?", "%"+req.ProjectName+"%")
	}

	// 销售负责人模糊查询
	if req.SalesUserName != "" {
		m = m.Where("sales_user_name like ?", "%"+req.SalesUserName+"%")
	}

	// 交付负责人模糊查询
	if req.DeliveryUserName != "" {
		m = m.Where("delivery_user_name like ?", "%"+req.DeliveryUserName+"%")
	}

	// 关键词搜索（项目名称、合同编号）
	if req.KeyWords != "" {
		m = m.Where("project_name like ? OR contract_no like ?", "%"+req.KeyWords+"%", "%"+req.KeyWords+"%")
	}

	// 其他查询条件
	if req.Status != "" {
		m = m.Where("project_status", req.Status)
	}
	if req.ProductLine != "" {
		productLineList := strings.Split(req.ProductLine, ",")
		m = m.Where("product_line", productLineList)
	}

	// 获取总数
	total, err := m.Count()
	if err != nil {
		return 0, nil, err
	}

	// 分页查询
	if req.PageNum <= 0 {
		req.PageNum = 1
	}
	if req.PageSize <= 0 {
		req.PageSize = 20
	}

	// 排序
	orderBy := "created_time desc"
	if req.SortField != "" && req.SortOrder != "" {
		orderBy = req.SortField + " " + req.SortOrder
	}

	var list []*opsdevmodel.OpsDeliveryProject
	err = m.Page(req.PageNum, req.PageSize).Order(orderBy).Scan(&list)
	if err != nil {
		return 0, nil, err
	}

	// 确保空列表返回 [] 而非 nil
	if list == nil {
		list = make([]*opsdevmodel.OpsDeliveryProject, 0)
	}

	return int64(total), list, nil
}

// intSliceToSqlIn 将整数切片转为 SQL IN 子句字符串
func intSliceToSqlIn(ids []int) string {
	if len(ids) == 0 {
		return ""
	}
	strIds := make([]string, len(ids))
	for i, id := range ids {
		strIds[i] = strconv.Itoa(id)
	}
	return strings.Join(strIds, ",")
}

// buildPermissionWhere 构建权限条件
func (s *DeliveryProjectService) buildPermissionWhere() string {
	return service.BuildProjectPermissionWhere(s.CxtUser.Id, s.CxtUser.Roles)
}

// GetEntityById 根据ID获取详情
func (s *DeliveryProjectService) GetEntityById(req *comm_def.IdReq) (*opsdevmodel.OpsDeliveryProject, error) {
	if req.Id <= 0 {
		return nil, errors.New("ID不能为空")
	}

	var entity *opsdevmodel.OpsDeliveryProject
	err := s.Dao.Where("id", req.Id).Scan(&entity)
	if err != nil {
		return nil, err
	}

	if entity == nil {
		return nil, errors.New("记录不存在")
	}

	return entity, nil
}

// Create 创建
func (s *DeliveryProjectService) Create(req *opsdevmodel.OpsDeliveryProjectReq) error {
	// 设置默认值
	if req.ProjectStatus == "" {
		req.ProjectStatus = "10" // 默认待交付
	}

	data := g.Map{
		"project_name":       req.ProjectName,
		"project_status":     req.ProjectStatus,
		"contract_id":        req.ContractId,
		"contract_no":        req.ContractNo,
		"cust_id":            req.CustId,
		"cust_name":          req.CustName,
		"product_line":       req.ProductLine,
		"delivery_user_id":   req.DeliveryUserId,
		"delivery_user_name": req.DeliveryUserName,
		"sales_user_id":      req.SalesUserId,
		"sales_user_name":    req.SalesUserName,
		"sales_region_id":    req.SalesRegionId,
		"delivery_node":      req.DeliveryNode,
		"remark":             req.Remark,
		"created_time":       gtime.Now(),
		"updated_time":       gtime.Now(),
	}

	// 处理计划交付时间
	if req.PlanDeliveryTime != "" {
		data["plan_delivery_time"] = req.PlanDeliveryTime
	}

	// 处理计划验收时间
	if req.PlanAcceptTime != "" {
		data["plan_accept_time"] = req.PlanAcceptTime
	}

	_, err := s.Dao.Data(data).Insert()
	return err
}

// CreateProjectByContract 合同审批通过后，按合同信息自动创建交付项目
func CreateProjectByContract(tx *gdb.TX, tenant string, contract *contractmodel.CtrContract) error {
	if contract == nil {
		return errors.New("合同信息不能为空")
	}
	projectDao := eventdao.NewOpsDeliveryProjectDao(tenant)

	// 审批回调可能重复触发，按合同ID幂等创建
	count, err := projectDao.TX(tx).Where("contract_id = ? AND deleted_time IS NULL", contract.Id).Count()
	if err != nil {
		return err
	}
	if count > 0 {
		return nil
	}

	data := g.Map{
		"project_name":    contract.ContractName,
		"project_status":  "10",
		"contract_id":     contract.Id,
		"contract_no":     contract.ContractCode,
		"cust_id":         strconv.Itoa(contract.CustId),
		"cust_name":       contract.CustName,
		"product_line":    contract.ProductLine,
		"sales_user_id":   contract.InchargeId,
		"sales_user_name": contract.InchargeName,
		"sales_region_id": contract.CustCityId,
		"delivery_node":   "05",
		"created_time":    gtime.Now(),
		"updated_time":    gtime.Now(),
	}
	_, err = projectDao.TX(tx).Data(data).Insert()
	return err
}

// UpdateById 更新
func (s *DeliveryProjectService) UpdateById(req *opsdevmodel.OpsDeliveryProjectUpdateReq) error {
	if req.Id <= 0 {
		return errors.New("ID不能为空")
	}

	// 权限校验：交付负责人和运维负责人的变更需要研发总监或研发主管角色
	hasManageRole := service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentDirector") ||
		service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentSupervisor")

	if !hasManageRole && (req.DeliveryUserId > 0 || req.Attribute4 > 0) {
		return errors.New("只有研发总监或研发主管才能变更交付负责人或运维负责人")
	}

	data := g.Map{
		"project_name":       req.ProjectName,
		"project_status":     req.ProjectStatus,
		"contract_id":        req.ContractId,
		"contract_no":        req.ContractNo,
		"cust_id":            req.CustId,
		"cust_name":          req.CustName,
		"product_line":       req.ProductLine,
		"delivery_user_id":   req.DeliveryUserId,
		"delivery_user_name": req.DeliveryUserName,
		"sales_user_id":      req.SalesUserId,
		"sales_user_name":    req.SalesUserName,
		"sales_region_id":    req.SalesRegionId,
		"delivery_node":      req.DeliveryNode,
		"remark":             req.Remark,
		"updated_time":       gtime.Now(),
	}

	// 处理计划交付时间（允许清空）
	if req.PlanDeliveryTime != "" {
		data["plan_delivery_time"] = req.PlanDeliveryTime
	} else {
		data["plan_delivery_time"] = nil
	}

	// 处理计划验收时间（允许清空）
	if req.PlanAcceptTime != "" {
		data["plan_accept_time"] = req.PlanAcceptTime
	} else {
		data["plan_accept_time"] = nil
	}

	if req.Attribute4 > 0 {
		data["attribute4"] = req.Attribute4
		data["attribute3"] = req.Attribute3
	}

	_, err := s.Dao.Where("id", req.Id).Data(data).Update()
	return err
}

// DeleteByIds 批量删除
func (s *DeliveryProjectService) DeleteByIds(req *comm_def.IdsReq) error {
	if len(req.Ids) == 0 {
		return errors.New("ID不能为空")
	}

	_, err := s.Dao.WhereIn("id", req.Ids).Delete()
	return err
}

// AssignDeliveryUser 指派/改派交付负责人
func (s *DeliveryProjectService) AssignDeliveryUser(req *opsdevmodel.AssignDeliveryUserReq) error {
	if req.ProjectId <= 0 {
		return errors.New("项目ID不能为空")
	}

	// 权限校验：指派/改派交付负责人需要研发总监或研发主管角色
	hasManageRole := service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentDirector") ||
		service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentSupervisor")

	if !hasManageRole {
		return errors.New("只有研发总监或研发主管才能指派或改派交付负责人")
	}

	// 查询项目是否存在
	project, err := s.Dao.Where("id", req.ProjectId).FindOne()
	if err != nil {
		return err
	}
	if project == nil {
		return errors.New("项目不存在")
	}

	// 构建更新数据
	data := g.Map{
		"delivery_user_id":   req.DeliveryUserId,
		"delivery_user_name": req.DeliveryUserName,
		"updated_time":       gtime.Now(),
	}

	// 首次指派时更新状态和节点
	if !req.IsReassign {
		if req.ProjectStatus != "" {
			data["project_status"] = req.ProjectStatus
		}
		if req.DeliveryNode != "" {
			data["delivery_node"] = req.DeliveryNode
		}
		if req.AssignedTime != "" {
			data["assigned_time"] = req.AssignedTime
		}
		if req.PlanDeliveryTime != "" {
			data["plan_delivery_time"] = req.PlanDeliveryTime
		}
		if req.PlanAcceptTime != "" {
			data["plan_accept_time"] = req.PlanAcceptTime
		}
	}

	// 追加备注
	if req.Remark != "" {
		oldRemark := project.Remark
		if oldRemark != "" {
			data["remark"] = oldRemark + "\n" + req.Remark
		} else {
			data["remark"] = req.Remark
		}
	}

	_, err = s.Dao.Where("id", req.ProjectId).Data(data).Update()
	return err
}

// GetDelegatesByProjectId 获取项目授权人列表
func (s *DeliveryProjectService) GetDelegatesByProjectId(req *opsdevmodel.OpsDeliveryProjectDelegateListReq) ([]*opsdevmodel.OpsDeliveryProjectDelegate, error) {
	delegateModel := eventdao.NewOpsDeliveryProjectDelegateDao(s.Tenant).Ctx(s.Ctx)
	var list []*opsdevmodel.OpsDeliveryProjectDelegate
	if err := delegateModel.Where("project_id", req.ProjectId).Scan(&list); err != nil {
		return nil, err
	}
	return list, nil
}

// AddDelegate 添加授权人
func (s *DeliveryProjectService) AddDelegate(req *opsdevmodel.OpsDeliveryProjectDelegateAddReq) error {
	if req.ProjectId <= 0 {
		return errors.New("项目ID不能为空")
	}
	if req.UserId <= 0 {
		return errors.New("被授权人ID不能为空")
	}

	// 权限校验
	hasManageRole := service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentDirector") ||
		service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentSupervisor")
	if !hasManageRole {
		return errors.New("只有研发总监或研发主管才能管理授权人")
	}

	// 检查项目是否存在
	project, err := s.Dao.Where("id", req.ProjectId).FindOne()
	if err != nil {
		return err
	}
	if project == nil {
		return errors.New("项目不存在")
	}

	// 检查是否已授权
	delegateModel := eventdao.NewOpsDeliveryProjectDelegateDao(s.Tenant).Ctx(s.Ctx)
	existing, err := delegateModel.Where("project_id", req.ProjectId).Where("user_id", req.UserId).FindOne()
	if err != nil {
		return err
	}
	if existing != nil {
		return errors.New("该用户已被授权")
	}

	// 确定项目名称
	projectName := req.ProjectName
	if projectName == "" {
		projectName = project.ProjectName
	}

	userId := s.GetCxtUserId()
	userName := s.GetCxtUserName()

	data := g.Map{
		"project_id":   req.ProjectId,
		"project_name": projectName,
		"user_id":      req.UserId,
		"user_name":    req.UserName,
		"created_by":   userId,
		"created_name": userName,
		"created_time": gtime.Now(),
		"updated_time": gtime.Now(),
	}
	_, err = delegateModel.Data(data).Insert()
	return err
}

// RemoveDelegate 移除授权人
func (s *DeliveryProjectService) RemoveDelegate(req *opsdevmodel.OpsDeliveryProjectDelegateDeleteReq) error {
	if req.Id <= 0 {
		return errors.New("ID不能为空")
	}

	// 权限校验
	hasManageRole := service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentDirector") ||
		service.StringsContains(s.CxtUser.Roles, "ResearchAndDevelopmentSupervisor")
	if !hasManageRole {
		return errors.New("只有研发总监或研发主管才能管理授权人")
	}

	delegateModel := eventdao.NewOpsDeliveryProjectDelegateDao(s.Tenant).Ctx(s.Ctx)
	_, err := delegateModel.Where("id", req.Id).Delete()
	return err
}