parent: 0c289de3 | 补丁 | 提交 | show whitespace
yujian
2019-06-12 c007868c62c7da5c9ce1bf0e77d9e5f8619826e4 
查询默认有效调整
2个文件已修改
4 ■■■■■ 已修改文件
fanli/src/main/java/com/yeshi/fanli/controller/client/v1/HomeNavbarController.java 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fanli/src/main/java/com/yeshi/fanli/mapping/homemodule/HomeNavbarMapper.xml 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 fanli/src/main/java/com/yeshi/fanli/controller/client/v1/HomeNavbarController.java


@@ -33,7 +33,7 @@


     */



    @RequestMapping(value = "gethomenavbar", method = RequestMethod.POST)



    public void gethomenavbar(AcceptData acceptData, PrintWriter out) {



        List<HomeNavbar> listNavbar = homeNavbarService.listQueryEffectiveNavbar();



        List<HomeNavbar> listNavbar = homeNavbarService.listQueryDefaultNavbar();



        if (listNavbar == null) {



            listNavbar = new ArrayList<HomeNavbar>();



        }





 fanli/src/main/java/com/yeshi/fanli/mapping/homemodule/HomeNavbarMapper.xml


@@ -66,7 +66,7 @@


      


   <select id="listQueryEffective" resultMap="BaseResultMap">


      SELECT * FROM    yeshi_ec_home_navbar 


      WHERE br_state = 1 AND br_is_default = 1


      WHERE br_state = 1


              AND IF(br_start_time IS NULL,TRUE, br_start_time<![CDATA[<=]]> NOW()) 


              AND IF(br_end_time IS NULL,TRUE, br_end_time <![CDATA[>=]]> NOW())


      ORDER BY br_orderby