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.regionalization.APm4GPoorTopBackinfoD;

@Mapper
public interface Apm4GTopBackinfoDao extends BaseMapper<APm4GPoorTopBackinfoD> {
    @Select("select count (*) from app_screen.a_pm_4g_poor_top_backinfo_d where  work_id=#{workId} ")
    int selectByCout(String workId);

    @Select("select * from app_screen.a_pm_4g_poor_top_backinfo_d where work_id=#{workId} ")
    APm4GPoorTopBackinfoD selectbyWorkId( String workId);

   @Update("update app_screen.a_pm_4g_poor_top_backinfo_d set prob_type=#{probType}," +
           "solution=#{solution}," +
           "detail_info=#{detailInfo},close_time=#{closeTime},cell_name=#{cellName} where sdate=#{sdate} and work_id=#{workId}")
    int updateByIdWork(APm4GPoorTopBackinfoD aPm4GPoorTopBackinfoD1);

   //查找4g回单数据库中是否有工单编号已经回单了
   @Select("select count(*) from  app_screen.a_pm_4g_poor_top_backinfo_d where work_id =#{workId}")
    int selectIsWordId(String workId);
    //查找5g回单数据库中是否有工单编号已经回单了
    @Select("select count(*) from  app_screen.a_pm_5g_poor_top_backinfo_d where work_id =#{workId}")
    int select5gIsWordId(String workId);
}