package com.ltkj.hosp.mapper;

import java.util.Date;
import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 体检记录Mapper接口
 *
 * @author ltkj
 * @date 2022-11-21
 */
@Mapper
public interface TjOrderMapper extends BaseMapper<TjOrder> {
    /**
     * 查询体检记录
     *
     * @param orderId 体检记录主键
     * @return 体检记录
     */
    public TjOrder selectTjOrderByOrderId(Long orderId);

    /**
     * 查询体检记录列表
     *
     * @param tjOrder 体检记录
     * @return 体检记录集合
     */
    public List<TjOrder> selectTjOrderList(TjOrder tjOrder);


    public List<TjOrder> selectExportOrderList(TjOrder tjOrder);

//    /*
//    * 根据tjNumber查询体检记录
//    * */
//    public List<TjOrder> selectTjOrderListByTjNumber(Long tjNumber);

    /**
     * 新增体检记录
     *
     * @param tjOrder 体检记录
     * @return 结果
     */
    public int insertTjOrder(TjOrder tjOrder);

    /**
     * 修改体检记录
     *
     * @param tjOrder 体检记录
     * @return 结果
     */
    public int updateTjOrder(TjOrder tjOrder);

    /**
     * 删除体检记录
     *
     * @param orderId 体检记录主键
     * @return 结果
     */
    public int deleteTjOrderByOrderId(Long orderId);

    /**
     * 批量删除体检记录
     *
     * @param orderIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjOrderByOrderIds(Long[] orderIds);


    List<TjOrder> getOrderList(Integer cusId);


    List<TjOrder> getOrderList1();

    @Select("select aa.date,\n" +
            "      sum(if(c.tj_type='团队', ifnull(c.coun,0),0)) as tdcoun,\n" +
            "      sum(if(c.tj_type='个人', ifnull(c.coun,0),0)) as grcoun,\n" +
            "      sum(if(c.tj_type='报告', ifnull(c.coun,0),0)) as bgcoun \n" +
            "  from (\n" +
            "      SELECT date_sub(CURDATE(),interval @i:=@i+1 day) as date\n" +
            "      from (select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
            "            select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all   \n" +
            "            select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all  \n" +
            "            select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all  \n" +
            "            select 1 union all select 1) as a,\n" +
            "            (select @i:= -1) b) aa \n" +
            "  left join (\n" +
            "      select date_format(create_time, '%Y-%m-%d') dat, tj_type, count(*) coun\n" +
            "      from tj_order where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
            "      group by date_format(create_time, '%Y-%m-%d'),tj_type\n" +
            "      union\n" +
            "      select date_format(report_time, '%Y-%m-%d') dat, '报告' tj_type, count(*) coun\n" +
            "      from tj_order where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
            "      group by date_format(report_time, '%Y-%m-%d')\n" +
            "      ) c on c.dat =aa.date\n" +
            "group by aa.date")
    List<Map<Object, Object>> getLine();


    @Select("SELECT * FROM tj_order WHERE tj_number RLIKE #{tjNum} AND deleted='0' ORDER BY create_time DESC")
    public List<TjOrder> getOrderListByLikeTjNum(@Param("tjNum") String tjNum);


    @Select("SELECT * FROM tj_order WHERE user_id = #{cusId} AND deleted='0' ORDER BY create_time DESC")
    public List<TjOrder> getOrderListByCusId(@Param("cusId") String cusId);

    @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted='0' ")
    public TjOrder getOrderByTjNum(String tjNum);

    List<TjOrder> getTjOrderList(@Param("tjNum")String tjNum,
                                 @Param("checkStatus")Integer checkStatus,
                                 @Param("compId")Long compId,
                                 @Param("beginTime") Date beginTime,
                                 @Param("endTime") Date endTime);


    List<TjOrder> getWCsTjOrderList(@Param("tjNum")String tjNum,
                                 @Param("compId")Long compId,
                                 @Param("beginTime") Date beginTime,
                                 @Param("endTime") Date endTime);

    List<TjOrder> getYCsTjOrderList(@Param("tjNum")String tjNum,
                                    @Param("compId")Long compId,
                                    @Param("beginTime") Date beginTime,
                                    @Param("endTime") Date endTime);


    List<TjOrder> getCsTjOrderList1(@Param("tjNum")String tjNum,
                                   @Param("checkStatus")Integer checkStatus,
                                   @Param("compId")Long compId,
                                   @Param("beginTime") Date beginTime,
                                   @Param("endTime") Date endTime);

    @Select("SELECT * FROM tj_order WHERE  deleted='0' and user_id = #{userId}  AND !ISNULL(finish_time)")
    List<TjOrder> getTjOrderListByCusId(Long userId);

    @Select("SELECT * FROM tj_order WHERE  deleted='0' and user_id = #{userId}  AND !ISNULL(finish_time)")
    List<TjOrder> getCsTjOrderListByCusId(Long userId);


    @Select("SELECT * FROM tj_order WHERE  deleted='0' and  user_id = #{userId}  AND !ISNULL(finish_time) " +
            "and !ISNULL(confirm_time) ")
    List<TjOrder> getCsTjOrderListByCusId1(Long userId);
}