Java Code Examples for org.nutz.dao.Cnd#and()
The following examples show how to use
org.nutz.dao.Cnd#and() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: WxUserController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询微信用户列表 */ @RequiresPermissions("wx:wxUser:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return wxUserService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 2
Source File: MasterController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询主人列表 */ @RequiresPermissions("test:master:list") @At @Ok("json") public Object list(@Param("pageNum")int pageNum, @Param("pageSize")int pageSize, @Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return masterService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 3
Source File: PetController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询宠物列表 */ @RequiresPermissions("test:pet:list") @At @Ok("json") public Object list(@Param("pageNum")int pageNum, @Param("pageSize")int pageSize, @Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return petService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,"master"); }
Example 4
Source File: CategoryServiceImpl.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询数据树 * @param parentId * @param name * @return */ @Override public List<Map<String, Object>> selectTree(String parentId, String name) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(name)) { //cnd.and("name", "like", "%" + name + "%"); } if (Strings.isNotBlank(parentId)) { cnd.and("parent_id", "=", parentId); } //cnd.and("status", "=", false).and("del_flag", "=", false); cnd.asc("sort"); List<Category> list = this.query(cnd); List<Map<String, Object>> trees = new ArrayList<Map<String, Object>>(); trees = getTrees(list); return trees; }
Example 5
Source File: CategoryController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询栏目列表 */ @At @Ok("json") @RequiresPermissions("cms:category:list") public Object list(@Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } cnd.asc("sort"); return categoryService.query(cnd); }
Example 6
Source File: SiteController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询站点列表 */ @RequiresPermissions("cms:site:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return siteService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 7
Source File: WxMenuServiceImpl.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询数据树 * @param parentId * @param name * @return */ @Override public List<Map<String, Object>> selectTree(String parentId, String name) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(name)) { //cnd.and("name", "like", "%" + name + "%"); } if (Strings.isNotBlank(parentId)) { cnd.and("parent_id", "=", parentId); } //cnd.and("status", "=", false).and("del_flag", "=", false); List<WxMenu> list = this.query(cnd); List<Map<String, Object>> trees = new ArrayList<Map<String, Object>>(); trees = getTrees(list); return trees; }
Example 8
Source File: WxMenuController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询微信菜单列表 */ @At @Ok("json") @RequiresPermissions("wx:menu:list") public Object list(@Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return wxMenuService.query(cnd); }
Example 9
Source File: MaterialController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询微信素材列表 */ @RequiresPermissions("wx:material:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String name, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } if(Lang.isNotEmpty(beginTime)){ cnd.and("create_time",">=", beginTime); } if(Lang.isNotEmpty(endTime)){ cnd.and("create_time","<=", endTime); } return materialService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 10
Source File: DeptServiceImpl.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询数据树 * @param parentId * @param name * @return */ @Override public List<Map<String, Object>> selectTree(String parentId, String name) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(name)) { cnd.and("dept_name", "like", "%" + name + "%"); } if (Strings.isNotBlank(parentId)) { cnd.and("parent_id", "=", parentId); } cnd.and("status", "=", false).and("del_flag", "=", false); List<Dept> deptList = this.query(cnd); List<Map<String, Object>> trees = new ArrayList<Map<String, Object>>(); trees = getTrees(deptList); return trees; }
Example 11
Source File: RoleController.java From NutzSite with Apache License 2.0 | 6 votes |
@At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("roleName") String roleName, @Param("roleKey") String roleKey, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(roleName)){ cnd.and("role_name", "like", "%" + roleName +"%"); } if (!Strings.isBlank(roleKey)){ cnd.and("role_key", "=", roleKey); } return roleService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 12
Source File: DictController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询字典列表 */ @RequiresPermissions("sys:dict:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String name, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ //cnd.and("name", "like", "%" + name +"%"); } cnd.and("del_flag","=",false); return dictService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 13
Source File: AreaServiceImpl.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询数据树 * @param parentId * @param name * @return */ @Override public List<Map<String, Object>> selectTree(String parentId, String name) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(name)) { //cnd.and("name", "like", "%" + name + "%"); } if (Strings.isNotBlank(parentId)) { cnd.and("parent_id", "=", parentId); } // cnd.and("status", "=", false).and("del_flag", "=", false); List<Area> list = this.query(cnd); List<Map<String, Object>> trees = new ArrayList<Map<String, Object>>(); trees = getTrees(list); return trees; }
Example 14
Source File: UserOnlineController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询在线用户记录列表 */ @RequiresPermissions("monitor:online:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String ipaddr, @Param("loginName") String loginName, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(ipaddr)){ cnd.and("ipaddr", "=", ipaddr); } if (!Strings.isBlank(loginName)){ cnd.and("login_name", "=", loginName); } return userOnlineService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc,null); }
Example 15
Source File: MenuServiceImpl.java From NutzSite with Apache License 2.0 | 6 votes |
@Override public boolean checkMenuUnique(String id, String parentId, String menuName) { Cnd cnd =Cnd.NEW(); if(Strings.isNotBlank(id)){ cnd.and("id","!=",id); } if(Strings.isNotBlank(parentId)){ cnd.and("parent_id","=",parentId); } if(Strings.isNotBlank(menuName)){ cnd.and("menu_name", "=", menuName); } List<Menu> list = this.query(cnd); if (Lang.isEmpty(list)) { return true; } return false; }
Example 16
Source File: OperLogController.java From NutzSite with Apache License 2.0 | 6 votes |
/** * 查询操作日志记录列表 */ @RequiresPermissions("monitor:operLog:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("title") String name, @Param("operName") String uid, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)){ cnd.and("tg", "like", "%" + name +"%"); } if (!Strings.isBlank(uid)){ cnd.and("u_name", "=", uid); } return operLogService.tableList(pageNum,pageSize,cnd,orderByColumn,isAsc); }
Example 17
Source File: DeptController.java From NutzSite with Apache License 2.0 | 5 votes |
@At @Ok("json") public Object list(@Param("deptName") String deptName, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(deptName)) { cnd.and("dept_name", "like", "%" + deptName + "%"); } cnd.and("del_flag", "=", false); return deptService.query(cnd); }
Example 18
Source File: MenuController.java From NutzSite with Apache License 2.0 | 5 votes |
@At @Ok("json") public Object list(@Param("menuName") String menuName, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (Strings.isNotBlank(menuName)) { cnd.and("menu_name", "like", "%" + menuName + "%"); } cnd.orderBy("order_num","asc"); return menuService.query(cnd); }
Example 19
Source File: UserController.java From NutzSite with Apache License 2.0 | 5 votes |
/** * 查询用户列表 */ @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("deptId") String deptId, @Param("loginName") String loginName, @Param("phonenumber") String phonenumber, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(loginName)) { cnd.and("user_name", "like", "%" + loginName + "%"); } if (!Strings.isBlank(phonenumber)) { cnd.and("phonenumber", "=", phonenumber); } if (Lang.isNotEmpty(beginTime)) { cnd.and("create_time", ">=", beginTime); } if (Lang.isNotEmpty(endTime)) { cnd.and("create_time", "<=", endTime); } if (!Strings.isBlank(deptId)) { cnd.where().andInBySql("dept_id", "SELECT id FROM sys_dept WHERE FIND_IN_SET ('%s',ancestors)", deptId) .or("dept_id", "=", deptId); } return userService.tableList(pageNum, pageSize, cnd, orderByColumn, isAsc, "dept"); }
Example 20
Source File: ArticleController.java From NutzSite with Apache License 2.0 | 5 votes |
/** * 查询文章列表 */ @RequiresPermissions("cms:article:list") @At @Ok("json") public Object list(@Param("pageNum")Integer pageNum, @Param("pageSize")Integer pageSize, @Param("name") String name, @Param("categoryId") String categoryId, @Param("beginTime") Date beginTime, @Param("endTime") Date endTime, @Param("orderByColumn") String orderByColumn, @Param("isAsc") String isAsc, HttpServletRequest req) { Cnd cnd = Cnd.NEW(); if (!Strings.isBlank(name)) { //cnd.and("name", "like", "%" + name +"%"); } if (!Strings.isBlank(categoryId)){ //cnd.and("category_id", "=", categoryId); cnd.where().andInBySql("category_id","SELECT id FROM cms_category WHERE FIND_IN_SET ('%s',parent_ids)", categoryId) .or("category_id","=", categoryId); } if (Lang.isNotEmpty(beginTime)) { cnd.and("create_time", ">=", beginTime); } if (Lang.isNotEmpty(endTime)) { cnd.and("create_time", "<=", endTime); } return articleService.tableList(pageNum, pageSize, cnd, orderByColumn, isAsc, "category"); }