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.TjFlowingWater;
import com.ltkj.hosp.domain.TjOrderDetail;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 体检流水Mapper接口
 *
 * @author ltkj
 * @date 2022-11-25
 */
@Mapper
public interface TjFlowingWaterMapper extends BaseMapper<TjFlowingWater> {
    /**
     * 查询体检流水
     *
     * @param id 体检流水主键
     * @return 体检流水
     */
    public TjFlowingWater selectTjFlowingWaterById(String id);

    /**
     * 查询体检流水列表
     *
     * @param tjFlowingWater 体检流水
     * @return 体检流水集合
     */
    public List<TjFlowingWater> selectTjFlowingWaterList(TjFlowingWater tjFlowingWater);

    /**
     * 新增体检流水
     *
     * @param tjFlowingWater 体检流水
     * @return 结果
     */
    public int insertTjFlowingWater(TjFlowingWater tjFlowingWater);

    /**
     * 修改体检流水
     *
     * @param tjFlowingWater 体检流水
     * @return 结果
     */
    public int updateTjFlowingWater(TjFlowingWater tjFlowingWater);

    /**
     * 删除体检流水
     *
     * @param id 体检流水主键
     * @return 结果
     */
    public int deleteTjFlowingWaterById(String id);

    /**
     * 批量删除体检流水
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjFlowingWaterByIds(String[] ids);


    @Select("SELECT * FROM tj_order a LEFT JOIN\n" +
            "\n" +
            "    tj_flowing_water b ON a.order_id = b.order_id WHERE a.tj_number =#{tjNum} AND a.deleted='0' AND b.deleted='0'")
    List<String> getFlowingWaterIds(String tjNum);

    @Select("SELECT a.discount/10 FROM tj_flowing_water a WHERE 1=1 AND a.deleted =0 AND  a.order_id=#{orderId} AND a.discount !='/'AND a.is_addition='N' AND a.pay_stasus !=2 ")
    String getDiscount(String orderId);


//    @Select("\tSELECT GROUP_CONCAT(b.pro_name ) proname FROM tj_order_detail a \n" +
//            "    LEFT JOIN tj_project b ON a.pro_id=b.pro_id \n" +
//            "\t WHERE a.order_id=#{orderId}")
//    String getproNameByOrderId(String orderId);

    @Select("SELECT GROUP_CONCAT(a.pro_name ) proname FROM tj_charging_standard a WHERE a.tj_num=#{orderId}")
    String getproNameByOrderId(String orderId);


    @Select("\n" +
            "SELECT a.tj_serial_number FROM tj_flowing_water a " +
            "WHERE a.deleted=0 " +
            "AND a.toll_collector_id=#{userId}" +
            "AND ISNULL(a.is_checkout)" +
            "AND a.pay_stasus !=0 " +
            "AND a.update_time BETWEEN #{beginTime} AND #{endTime}")
    List<Long> getFlowingWaterIdList(@Param("userId") String userId,@Param("beginTime") Date beginTime,@Param("endTime") Date endTime);

    @Delete("  delete" +
            " from tj_flowing_water" +
            " where order_id = #{order}")
    public int deleteTjFlowingWaterByOrderId(String order);

    @Delete("  delete" +
            " from tj_flowing_water" +
            " where jxbz = #{bldh}")
    void deleteTjOrderDetailByjxbz(String bldh);

    @Select("call tj_bl(#{tjh,mode=IN})")
    void getTjBlCall(@Param("tjh") String tjh);


    //存储过程专用接口(获取团体结算人员情况信息)
    List<List<?>> gettuantijiesuanrenyuan(Map<String,Object> map);
}