package safeluck.drive.evaluation.DB.failitems;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
import androidx.room.Delete;
import androidx.room.Insert;
import androidx.room.OnConflictStrategy;
import androidx.room.Query;

import java.util.List;

/**
 * MyApplication2
 * Created by lzw on 2019/11/26. 18:08:08
 * 邮箱：632393724@qq.com
 * All Rights Saved! Chongqing AnYun Tech co. LTD
 */
@Dao
public interface FailProjDao {

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    void insert(FailedProj proj);


    /**
     * 查询 suoyou 失败项目 （多表查询）
     * @return
     */
    @Query("SELECT emp_id,stu_id, utc ,sn ,deducting_reason,score_deducting,item_content from criteria INNER JOIN fail_projects ON  criteria.item_id= fail_projects.emp_id where fail_projects.stu_id=:stu_id and fail_projects.subject=999")
    LiveData<List<FailedProj_select>> getFailedProjects(long stu_id);

    /**
     * 获取失败项目条数
     * @param subject_id
     * @return
     */
    @Query("SELECT COUNT(*)  from fail_projects where subject=:subject_id")
    LiveData<Integer> getSubject(int subject_id);

    @Query("delete from fail_projects")
    void deleteAll();


}