huanghongfa
2021-01-11 0273c333ed5c86822be1f56623e3e6bab90ec2f7
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbDynDAO.java
@@ -9,6 +9,7 @@
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
@@ -18,7 +19,16 @@
 **/
@Mapper
public interface ComPbDynDAO extends BaseMapper<ComPbDynDO> {
//    @Select("<script> " +
//            " <where>" +
//            "<if test='nameCn != null and nameCn.trim() != &quot;&quot;'>" +
//            " </if> " +
//            "<if test='nameCn != null and nameCn.trim() != &quot;&quot;'>" +
//            " </if> " +
//            "<if test='nameCn != null and nameCn.trim() != &quot;&quot;'>" +
//            " </if> " +
//            " </where>" +
//            "</script>")
    @Select("<script> " +
            "SELECT\n" +
@@ -51,4 +61,6 @@
            "ORDER BY d.create_at desc"+
            "</script>")
    IPage<PartyBuildingComPbDynVO> pageYnamic(Page page, @Param("partyBuildingComPbDynVO") PartyBuildingComPbDynVO partyBuildingComPbDynVO);
    @Update("update com_pb_dyn set `status`=(if(DATEDIFF(SYSDATE(),publish_at)>0,2,1)) WHERE `status`=1")
    int timedTaskPartyBuildingStatus();
}