private void initData() {
typeData.clear();
typeData.addAll(ToolType.allToolTypes());
List<ToolsTray> bandejaList =
dao.query(ToolsTray.class, Cnd.where("toolType", "=", C.TOOL_TYPE_TRAY_FOLDER));
superData.clear();
ToolsTray bandeja1 = new ToolsTray();
bandeja1.setId(C.ROOT_PARENT_ID);
bandeja1.setTrayName("--无父目录--");
superData.add(bandeja1);
superData.addAll(bandejaList);
searchData.clear();
ToolsTray bandeja = new ToolsTray();
bandeja.setTrayName("--全部--");
searchData.add(bandeja);
searchData.add(bandeja1);
searchData.addAll(bandejaList);
tableData.clear();
tableData.addAll(dao.query(ToolsTray.class, null));
}
public void search(ActionEvent event) {
ToolsTray bandeja = (ToolsTray) searchCombo.getSelectionModel().getSelectedItem();
List<ToolsTray> bandejaList;
if (null == bandeja || null == bandeja.getId()) {
bandejaList = dao.query(ToolsTray.class, null);
} else {
bandejaList = dao.query(ToolsTray.class, Cnd.where("parentId", "=", bandeja.getId()));
}
tableData.clear();
tableData.addAll(bandejaList);
}
@Override
public void init(NutConfig config) {
Ioc ioc = config.getIoc();
Dao dao = ioc.get(Dao.class);
// 若必要的数据表不存在，则初始化数据库
if (!dao.exists(User.class)) {
dao.create(User.class, true);
dao.create(Role.class, true);
dao.create(Permission.class, true);
FileSqlManager fm = new FileSqlManager("init_system_h2.sql");
List<Sql> sqlList = fm.createCombo(fm.keys());
dao.execute(sqlList.toArray(new Sql[sqlList.size()]));
// 初始化用户密码（全部都是123）及salt
List<User> userList = dao.query(User.class, null);
for (User user : userList) {
RandomNumberGenerator rng = new SecureRandomNumberGenerator();
String salt = rng.nextBytes().toBase64();
String hashedPasswordBase64 = new Sha256Hash("123", salt, 1024).toBase64();
user.setSalt(salt);
user.setPassword(hashedPasswordBase64);
dao.update(user);
}
}
// 设置 Shiro 的 securityManager
SecurityManager securityManager = ioc.get(SecurityManager.class);
SecurityUtils.setSecurityManager(securityManager);
}
@At
@Ok("json")
public JDataGrid list_grid(
@Attr(scope = Scope.SESSION, value = "account") Account acc,
@Param("::columns") List<?> columns,
@Param("::search") Map<?, ?> search,
int draw,
int start,
int length) {
start = start / length;
Pager pager = new Pager();
pager.setPageNumber(start + 1);
pager.setPageSize(length);
Cnd cnd = Cnd.where("accountid", "=", acc.accountid);
if (!Lang.isEmpty(search.get("value")) && !search.get("value").toString().equals("")) {
cnd.and("name", "like", search.get("value"));
}
List<?> aaData = dao.query(Store.class, cnd);
pager.setRecordCount(dao.count(Store.class, cnd));
JDataGrid ret = new JDataGrid();
ret.draw = draw;
ret.data = aaData;
ret.recordsTotal = pager.getRecordCount();
ret.recordsFiltered = pager.getRecordCount();
return ret;
}
private void resourceRelationFull(Resource resource) {
List<Tag> tags;
Sql sql_resource =
Sqls.create(
"select * from tag as t, resource_tag as rt where rt.resource_id = "
+ resource.getId()
+ " and rt.tag_id = t.id");
sql_resource.setCallback(Sqls.callback.entities());
sql_resource.setEntity(dao.getEntity(Tag.class));
dao.execute(sql_resource);
tags = sql_resource.getList(Tag.class);
List<UserInfo> user = dao.query(UserInfo.class, Cnd.where("id", "=", resource.getAuthor()));
if (user.size() > 0) {
resource.setUserInfo(user.get(0));
} else {
System.out.print("resourceservice:用户id无效");
}
String tagString = ""; // 资源tag回填
for (int i = 0; i < tags.size(); i++) {
if (i < (tags.size() - 1)) {
tagString = tagString + tags.get(i).getName() + ",";
} else {
tagString = tagString + tags.get(i).getName();
}
}
resource.setTags(tagString);
resource.setTagEntityList(tags);
}
@At
@Ok("json")
public Object list(@Attr(scope = Scope.SESSION, value = "account") Account acc) {
Cnd cnd = Cnd.where("accountid", "=", acc.accountid);
List<?> aaData = dao.query(Store.class, cnd);
return aaData;
}
@At("/list_goodid/?")
@Ok("json")
public Object list_goodid(int id, @Attr(scope = Scope.SESSION, value = "account") Account acc) {
Cnd cnd = Cnd.where("accountid", "=", acc.accountid);
if (id != 0) {
cnd.and(new Static("id in (select store_id from m_typelist where id=" + id + ")"));
}
List<?> aaData = dao.query(Store.class, cnd);
return aaData;
}
/**
* 分页查找 resource
*
* @param categoryId 分类id好好
* @param order
* @param pager
* @return
*/
public List<Resource> search(Integer categoryId, Integer tagId, String order, Pager pager) {
List<Resource> query = null;
if (categoryId != null) {
query = dao.query(Resource.class, Cnd.where("categoryId", "=", categoryId).desc("id"), pager);
if (pager != null) {
pager.setRecordCount(dao.count(Resource.class, Cnd.where("categoryId", "=", categoryId)));
}
} else {
query = dao.query(Resource.class, Cnd.orderBy().desc("id"), pager);
if (pager != null) {
pager.setRecordCount(dao.count(Resource.class));
}
}
for (Resource resource : query) {
resourceRelationFull(resource);
}
return query;
}
@Override
public List<Item> listSameItems(long itemId) {
Item item = dao.fetch(Item.class, itemId);
if (null == item) {
throw new AppRuntimeException("木有找到该item");
}
return dao.query(
Item.class,
Cnd.where("oid", "=", item.getOid()).and("skuMoreId", "=", item.getSkuMoreId()));
}
public List<Topic> getRecentTopics(int userId, Pager pager) {
List<Topic> recent_topics =
dao.query(Topic.class, Cnd.where("userId", "=", userId).desc("createTime"), pager);
Map<Integer, UserProfile> authors = new HashMap<Integer, UserProfile>();
if (!recent_topics.isEmpty()) {
for (Topic topic : recent_topics) {
fillTopic(topic, authors);
}
}
pager.setRecordCount(dao.count(Topic.class, Cnd.where("userId", "=", userId)));
return recent_topics;
}
/**
* 分页查找 resource
*
* @param categoryId 分类id好好
* @param order
* @param pager
* @return
*/
public List<Resource> search(Integer categoryId, String order, Pager pager, Integer userId) {
List<Resource> query = null;
Cnd cnd = Cnd.NEW();
if (userId != null) {
cnd = cnd.and("author", "=", userId);
}
if (categoryId != null && categoryId != 0) {
cnd = cnd.and("categoryId", "=", categoryId);
}
if (pager != null) {
pager.setRecordCount(dao.count(Resource.class, cnd));
}
query = dao.query(Resource.class, cnd.desc("id"), pager);
for (Resource resource : query) {
resourceRelationFull(resource);
}
return query;
}