package com.ltkj.mall.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.common.core.domain.entity.MallSchedulingTime;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* 预约时间Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-07-18
|
*/
|
@Mapper
|
public interface MallSchedulingTimeMapper extends BaseMapper<MallSchedulingTime> {
|
/**
|
* 查询预约时间
|
*
|
* @param id 预约时间主键
|
* @return 预约时间
|
*/
|
public MallSchedulingTime selectMallSchedulingTimeById(Long id);
|
|
/**
|
* 查询预约时间列表
|
*
|
* @param mallTimeConfig 预约时间
|
* @return 预约时间集合
|
*/
|
public List<MallSchedulingTime> selectMallSchedulingTimeList(MallSchedulingTime mallTimeConfig);
|
|
/**
|
* 新增预约时间
|
*
|
* @param mallTimeConfig 预约时间
|
* @return 结果
|
*/
|
public int insertMallSchedulingTime(MallSchedulingTime mallTimeConfig);
|
|
/**
|
* 修改预约时间
|
*
|
* @param mallTimeConfig 预约时间
|
* @return 结果
|
*/
|
public int updateMallSchedulingTime(MallSchedulingTime mallTimeConfig);
|
|
/**
|
* 删除预约时间
|
*
|
* @param id 预约时间主键
|
* @return 结果
|
*/
|
public int deleteMallSchedulingTimeById(Long id);
|
|
/**
|
* 批量删除预约时间
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteMallSchedulingTimeByIds(Long[] ids);
|
|
|
|
@Select("SELECT\n" +
|
" date_add( date_sub(#{startTime},interval 1 day), INTERVAL ( cast( help_topic_id AS signed INTEGER ) + 1 ) day ) day \n" +
|
"FROM\n" +
|
" mysql.help_topic \n" +
|
"WHERE\n" +
|
" help_topic_id < DATEDIFF(#{endTime},date_sub(#{startTime},interval 1 day))\n" +
|
"ORDER BY\n" +
|
" help_topic_id")
|
List<Date> getDateListByBetweenTime(@Param("startTime") String startTime,@Param("endTime") String endTime);
|
}
|
