public void list() {
SysRole model = getModelByAttr(SysRole.class);
SQLUtils sql = new SQLUtils(" from sys_role t where 1=1 ");
if (model.getAttrValues().length != 0) {
sql.setAlias("t");
// 查询条件
sql.whereLike("name", model.getStr("name"));
}
// 排序
String orderBy = getBaseForm().getOrderBy();
if (StrUtils.isEmpty(orderBy)) {
sql.append(" order by sort,id desc");
} else {
sql.append(" order by ").append(orderBy);
}
String sqlSelect =
"select t.* "
+ ",(select group_concat(m.name) from sys_role_menu rm left JOIN sys_menu m ON rm.menuid = m.id where rm.roleid = t.id ) as menus ";
Page<SysRole> page =
SysRole.dao.paginate(
getPaginator(),
sqlSelect, //
sql.toString().toString());
// 下拉框
setAttr("page", page);
setAttr("attr", model);
render(path + "list.html");
}
public void list() {
SysUser model = getModelByAttr(SysUser.class);
SQLUtils sql =
new SQLUtils(
" from sys_user t " //
+ " left join sys_department d on d.id = t.departid " //
+ " where 1 = 1 and userid != 1 ");
if (model.getAttrValues().length != 0) {
sql.whereLike("username", model.getStr("username"));
sql.whereLike("realname", model.getStr("realname"));
sql.whereEquals("usertype", model.getInt("usertype"));
sql.whereEquals("departid", model.getInt("departid"));
}
// 排序
String orderBy = getBaseForm().getOrderBy();
if (StrUtils.isEmpty(orderBy)) {
sql.append(" order by userid desc");
} else {
sql.append(" order by ").append(orderBy);
}
Page<SysUser> page =
SysUser.dao.paginate(
getPaginator(), "select t.*,d.name as departname ", sql.toString().toString());
// 下拉框
setAttr("departSelect", new DepartmentSvc().selectDepart(model.getInt("departid")));
setAttr("page", page);
setAttr("attr", model);
render(path + "list.html");
}
/** * 保存授权信息 * * <p>2015年4月28日 下午5:00:30 flyfox [email protected] * * @param roleid * @param menus */ public void saveAuth(int roleid, String menus, int update_id) { // 删除原有数据库 Db.update("delete from sys_role_menu where roleid = ? ", roleid); if (StrUtils.isNotEmpty(menus)) { String[] arr = menus.split(","); for (String menuid : arr) { SysRoleMenu roleMenu = new SysRoleMenu(); roleMenu.set("roleid", roleid); roleMenu.set("menuid", NumberUtils.parseInt(menuid)); // 日志添加 roleMenu.put("update_id", update_id); roleMenu.put("update_time", DateUtils.getNow(DateUtils.DEFAULT_REGEX_YYYY_MM_DD_HH_MIN_SS)); roleMenu.save(); } } }
public void save() {
Integer pid = getParaToInt();
SysUser model = getModel(SysUser.class);
// 日志添加
Integer userid = getSessionUser().getUserID();
String now = getNow();
model.put("update_id", userid);
model.put("update_time", now);
if (pid != null && pid > 0) { // 更新
model.update();
} else { // 新增
model.remove("userid");
if (StrUtils.isEmpty(model.getStr("password"))) {
model.put("password", JFlyFoxUtils.getDefaultPassword());
}
model.put("create_id", userid);
model.put("create_time", now);
model.save();
}
UserCache.init();
renderMessage("保存成功");
}