package com.hxzk.gps.mapper.Attendance;
|
|
import com.hxzk.gps.entity.Attendance.TbKaoqing;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzk.gps.entity.Attendance.TbRealkaoqing;
|
import com.hxzk.gps.entity.Track.TbGpsTrack;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author YuZhiTong
|
* @since 2025-05-27
|
*/
|
public interface TbKaoqingMapper extends BaseMapper<TbKaoqing> {
|
/**
|
* 考勤信息查询接口
|
* @param companyName
|
* @param time
|
* @return List<TbKaoqing>
|
* */
|
List<TbKaoqing> FindAttendanceInfo(@Param("company") String companyName, @Param("time")String time,@Param("name") String name, @Param("tagid")String tagid);
|
|
|
@Select("select count(*)AS tagid,area,now()AS name from tb_realkaoqing GROUP BY area")
|
List<TbRealkaoqing> findKaoQinQuYu();
|
|
}
|
