package org.jeecg.modules.arj.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.jeecg.modules.arj.entity.FeipinGuan;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
/**
|
* <p>
|
* 印铁废品 前端控制器
|
* </p>
|
*
|
* @author hyy
|
* @since 2022-11-30
|
*/
|
@Mapper
|
@Repository
|
public interface FeipinGuanMapper extends BaseMapper<FeipinGuan>{
|
|
/**
|
* @return
|
*/
|
@Select("select * from feipin_guan a, head b where a.head_id = b.id and head_id in (select id " +
|
"from (select d.*," +
|
" row_number() over (partition by date(reportTime) order by reportTime desc) as seqnum" +
|
" from head d where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(reportTime)" +
|
" ) d " +
|
"where seqnum = 1) order by reportTime ")
|
//@Select("select * from feipin_guan a, head b where a.head_id = b.id and head_id in (select id from head where week(reportTime) = week(now()))")
|
List<FeipinGuan> queryWeek();
|
|
@Select("select * from feipin_guan a, head b where a.head_id = b.id and head_id in (select id from head where month(reportTime) = month(now()))")
|
List<FeipinGuan> queryMonth();
|
|
@Select("select * from feipin_guan a, head b where a.head_id = b.id and head_id in (select id from head where month(reportTime) = #{n})")
|
List<FeipinGuan> queryMonthN(int n);
|
}
|
