package com.nuvole.four.mapper;
|
|
import com.nuvole.four.domain.ActivityDistributeRecord;
|
import com.nuvole.four.domain.dto.ActivityDistributeBudgetDto;
|
import com.nuvole.four.domain.query.ActivityDistributeRecordQuery;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
/**
|
* @Description 活动预算分配Mapper
|
* @Author dqh
|
* @Date 2024-04-13 21:36:24
|
*/
|
@Mapper
|
public interface ActivityDistributeRecordMapper {
|
int deleteByPrimaryKey(Long id);
|
|
int insert(ActivityDistributeRecord record);
|
|
int insertSelective(ActivityDistributeRecord record);
|
|
ActivityDistributeRecord selectByPrimaryKey(Long id);
|
|
int updateByPrimaryKeySelective(ActivityDistributeRecord record);
|
|
/**
|
* 根据activityId修改状态
|
*/
|
@Update("update activity_distribute_record set status = #{status} where activity_id = #{activityId}")
|
int updateByActivityId(ActivityDistributeRecord record);
|
|
int updateByPrimaryKey(ActivityDistributeRecord record);
|
|
/**
|
* 查询列表
|
*
|
* @param query
|
* @return 查询结果
|
*/
|
List<ActivityDistributeRecord> selectList(ActivityDistributeRecordQuery query);
|
|
/**
|
* 方法描述: 分配预算查询
|
* 查询orgId的下级分配记录
|
*
|
* @date 2024-04-14 13:26
|
**/
|
List<ActivityDistributeBudgetDto> getActivityDistributeRecordDetail(@Param("orgId") Long orgId, @Param("activityId") Long activityId);
|
|
/**
|
* 方法描述: 查询活动详情-活动预算分配列表
|
*
|
* @date 2024-04-15 13:35
|
**/
|
List<ActivityDistributeBudgetDto> getActivityDistributeRecordDetailByAId(@Param("activityId") Long activityId,@Param("orgCode") String orgCode);
|
|
/**
|
* 方法描述:分配预算保存
|
* 有id则进行更新;无则新增
|
*
|
* @date 2024-04-14 13:41
|
**/
|
Integer batchInsertOrUpdate(List<ActivityDistributeRecord> recordList);
|
|
@Select("select * from activity_distribute_record where deleted = 0 and activity_id = #{activityId} and org_id = #{orgId}")
|
ActivityDistributeRecord getFeeByCondition(@Param("activityId") Long activityId,@Param("orgId") Long orgId);
|
|
/**
|
* 方法描述:
|
*
|
* @date 2024-04-20 17:26
|
**/
|
List<ActivityDistributeRecord> selectAllByActivityIds(@Param("ids") List<Long> ids);
|
}
|