package com.ltkj.hosp.mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjGroupingPro;
import com.ltkj.hosp.vodomain.AddNewReservationConfirm;
import org.apache.ibatis.annotations.*;

/**
 * 体检项目分组Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-08-07
 */
@Mapper
public interface TjGroupingProMapper extends BaseMapper<TjGroupingPro> {
    /**
     * 查询体检项目分组
     *
     * @param id 体检项目分组主键
     * @return 体检项目分组
     */
    public TjGroupingPro selectTjGroupingProById(String id);

    /**
     * 查询体检项目分组列表
     *
     * @param tjGroupingPro 体检项目分组
     * @return 体检项目分组集合
     */
    public List<TjGroupingPro> selectTjGroupingProList(TjGroupingPro tjGroupingPro);

    /**
     * 新增体检项目分组
     *
     * @param tjGroupingPro 体检项目分组
     * @return 结果
     */
    public int insertTjGroupingPro(TjGroupingPro tjGroupingPro);

    /**
     * 修改体检项目分组
     *
     * @param tjGroupingPro 体检项目分组
     * @return 结果
     */
    public int updateTjGroupingPro(TjGroupingPro tjGroupingPro);

    /**
     * 删除体检项目分组
     *
     * @param id 体检项目分组主键
     * @return 结果
     */
    public int deleteTjGroupingProById(String id);

    /**
     * 批量删除体检项目分组
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjGroupingProByIds(String[] ids);

    @Select("SELECT\n" +
            "\ta.grouping_id,\n" +
            "\ta.pro_id,\n" +
            "\ta.pro_name,\n" +
            "\tb.pro_id pid,\n" +
            "\tb.pro_name pnam,\n" +
            "\tb.pro_price, a.limits \n" +
            "FROM\n" +
            "\ttj_grouping_pro a\n" +
            "\tLEFT JOIN tj_project b ON a.pro_id = b.pro_parent_id \n" +
            "WHERE\n" +
            "\ta.deleted = 0 \n" +
            "\tAND a.grouping_id = #{groupingId} ")
    List<AddNewReservationConfirm> getAddNewReservationConfirm(String groupingId);


    @Delete("DELETE FROM tj_grouping_pro  WHERE grouping_id =#{groupingId}")
    void deletedTjGroupingProByGroupingId(String groupingId);


    @Update(" update tj_grouping_pro " +
            " SET " +
            " limits=#{limits}," +
            " ys_price=pro_price*(#{limits}/10)" +
            " where grouping_id=#{groupId} ")
    boolean updateGroupProLimitsByGroupId(@Param("groupId") String groupId,@Param("limits") String limits);
//
//    @Insert("")
//    boolean saveTjOrderDetailsByGroupId(@Param("groupingId") String groupingId,@Param("userName")  String userName,@Param("userId")  String userId,@Param("orderId")String orderId);

       @Select("SELECT aa.parent_pro_id xmid,(g.ys_price-aa.ys)cj FROM tj_grouping_pro g JOIN (\n" +
               "\n" +
               "SELECT a.parent_pro_id,SUM(a.now_price)ys  FROM tb_transition a WHERE a.cus_id=#{cusIdCard}  AND pac_id=#{groupingId} AND ISNULL(a.tj_num) GROUP BY a.parent_pro_id)aa\n" +
               "ON\n" +
               "g.pro_id=aa.parent_pro_id   AND g.grouping_id=#{groupingId} AND (g.ys_price-aa.ys)>0")
       List<Map<String,Object>> huoquxiangmuchajia(@Param("groupingId") String groupingId, @Param("cusIdCard") String cusIdCard);

}