TaskMapper.java

package com.youzan.pfcase.mapper;

import com.youzan.pfcase.domain.Task;
import com.youzan.pfcase.domain.Rank;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.Timestamp;
import java.util.List;
import java.util.Map;

/**
 * Created by sunjun on 16/8/12.
 */
@Repository
public interface TaskMapper {

    List<Task> getAllTask();
    List<Task> getAllTaskByUsername(@Param("username") String username);
    List<Task> getUnpreparedTasks();
    Task getTaskByTaskid(int taskid);
    int getTaskscore(@Param("taskid") int taskid);

    List<Task> getAllDoneTask();
    List<Task> getAllDoneTaskByUsername(@Param("username") String username);

    void insertTask(Task task);

    void updateTask(Task task);


    void updateTaskPrepared(int taskid);


    void updateTaskscore(@Param("taskid") int taskid, @Param("taskscore") int taskscore);


    void delTask(@Param("taskid") int taskid, @Param("modifier") String modifier, @Param("updatetime") Timestamp updatetime);

    //
    void insertRank(Rank rankForm);

    List<Map<String, String>> getTotalScores();

//    List<Map<String, String>> getExeTimes();
}