package www.com.tencent.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import www.com.tencent.pojo.fourthgenerationentity.commonality.OrderEntity;
import www.com.tencent.pojo.fourthgenerationentity.list.APm4GGroupDataListTopD;
import www.com.tencent.pojo.fourthgenerationentity.voice.APm4GGroupVolteLowfeEntity;

import java.util.List;

//低感知小区--4G语音低感知数据同步接口 Dao层
@Mapper
public interface APm4GGroupVolteDao extends BaseMapper<APm4GGroupVolteLowfeEntity> {
    @Select("select distinct on (\"oid\")* from  app_screen.a_pm_4g_group_volte_lowfell_m where \"oid\" =#{eci} and sdate =(select max(sdate) from app_screen.a_pm_4g_group_volte_lowfell_m) ")
    APm4GGroupVolteLowfeEntity selectByVolteEci(String eci);

    //集团反馈回单拿work去语音抵质感集团表查
    @Select("select * from app_screen.a_pm_4g_group_volte_lowfell_m where\"oid\"=#{workId} and sdate=#{sdate}")
    OrderEntity selectByOrderId(@Param("workId") String workId,@Param("sdate")String sdate);
   //用工单编号查询什么时候加Yes
    @Update("update app_screen.a_pm_4g_group_volte_lowfell_m  set send_flag ='Yes' where order_id =#{orderId}")
    void updateFlag(String orderId);
}