packagecom.reyun.repository;importcom.reyun.model.CampaignWechatAccount;importorg.springframework.data.jpa.repository.JpaRepository;importorg.springframework.data.jpa.repository.Modifying;importorg.springframework.data.jpa.repository.Query;importorg.springframework.transaction.annotation.Transactional;importjava.util.List;publicinterfaceCampaignWeChatAccountRepositoryextendsJpaRepository<CampaignWechatAccount,Long>{@Modifying@Transactional@Query(value="update campaign_wechat_account set mpaccesstoken = ?2,modify_time=?3 where id = ?1",nativeQuery=true)voidupdateTokenAndDateById(Longid,Stringmptoken,StringcurrentDateStr);@Query(value="select * from campaign_wechat_account where mpappid = ?1 and root_account_id = ?2 ",nativeQuery=true)CampaignWechatAccountfindByMpappid(Stringmpappid,Longroot_account_id);@Modifying@Transactional@Query(value="update campaign_wechat_account set mpaccess_token_url = ?1,mpappsecret=?2,modify_time=?4 where id = ?3",nativeQuery=true)voidupdateAccessTokenUrlAndMpappsecretById(Stringmpaccess_token_url,Stringmpappsecret,Longid,StringcurrentDateStr);@Query(value="select t1.appkey,t1.campaignid,t1.user_action_set_id,t2.mpaccesstoken from campaign_wechat_link t1 join campaign_wechat_account t2 on t1.mpappid=t2.mpappid where t1.status=0",nativeQuery=true)List<Object[]>findAllSynDDB();}