age_zentao/gis_mapper/src/main/java/com/gis/mapper/TaskMapper.java

package com.gis.mapper;


import com.gis.common.util.Result;
import com.gis.domain.entity.EffortEntity;
import com.gis.domain.entity.TaskEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;


@Component
@Mapper
public interface TaskMapper extends ZtBaseMapper<TaskEntity, Long> {


    @Select("select * from zt_task where deleted = '0' and assignedTo = #{account}")
    List<TaskEntity> myTask(String account);

    // 分组查询
    @Select("select id, project ,assignedTo from zt_task where deleted = '0' and project = #{projectId} group by assignedTo")
    List<TaskEntity> findAccountByProjectId(String projectId);

    // 按月份统计每个人的总工时 date: yyyy-MM-dd
    @Select("SELECT id,project,date,account, SUM(consumed) as consumed FROM zt_effort WHERE deleted = '0' AND  project = #{projectId} and DATE_FORMAT( date, '%Y%m' ) = DATE_FORMAT(#{date} , '%Y%m' ) GROUP BY account ")
    List<EffortEntity> sumEffortByMonth(String projectId, String date);
}