@Override
public boolean delete(AppModel model) {
try {
LOG.d("DB Delete id", model.getId());
getRealDao().deleteById(model.getId());
} catch (SQLException e) {
LOG.e(e);
return false;
}
return true;
}
public List<AppModel> getAppById(String id) {
String cql = "SELECT * FROM app WHERE appid = '%s';";
cql = String.format(cql, id);
List<AppModel> apps = new ArrayList<AppModel>();
Iterator rows = this.bridge.excute(cql);
while (rows.hasNext()) {
AppModel app = new AppModel();
Row row = (Row) rows.next();
app.setAppid(row.getString("appid"));
app.setName(row.getString("name"));
app.setInstallUrl(row.getString("url"));
app.setProfile(row.getString("profile"));
app.setIsInnerApp(row.getString("isinnerapp"));
try {
JSONObject profile = JSONObject.fromObject(app.getProfile());
app.setImage(profile.getString("image"));
apps.add(app);
} catch (Exception e) {
log.error(e.getMessage());
e.printStackTrace();
}
}
return apps;
}
public Player getOpponent() {
if (opponent == null) {
if (!isOnTable()) {
opponent = null;
} else if (table.getBlackSeat() == AppModel.getInstance().getSelf()) {
opponent = table.getRedSeat();
} else if (table.getRedSeat() == AppModel.getInstance().getSelf()) {
opponent = table.getBlackSeat();
} else {
opponent = null;
}
}
return opponent;
}
public boolean hasUniqueName(String aName) {
TypeModel typeModel;
Collection c = appModel.getTypes();
for (Iterator x = c.iterator(); x.hasNext(); ) {
typeModel = (TypeModel) x.next();
if (typeModel.getName().equals(aName)) {
return false;
}
}
return true;
}
public void detach(AppModel anAppModel) {
Command command =
new DetachCommand(
Manager.getSingleton().getTransaction(),
anAppModel,
this,
(anAppModel == null) ? null : anAppModel.getTypes(),
"types",
"appModel");
command.execute();
}
public List<AppModel> getAppsByRole(String groupname) {
List<AppModel> apps = new ArrayList<AppModel>();
try {
String cql = "SELECT * FROM group_app_map WHERE groupname = '%s';";
cql = String.format(cql, groupname);
Iterator rows = this.bridge.excute(cql);
while (rows.hasNext()) {
Row row = (Row) rows.next();
AppModel app = this.getAppByid(row.getString("appid"));
if (app == null) {
continue;
}
app.setAppid(row.getString("appid"));
app.setProfile(row.getString("permissions"));
apps.add(app);
// apps.addAll(getAppById(row.getString("appid")));
}
} catch (Exception e) {
log.error(e.getMessage());
}
return apps;
}
public ExeModel getExeById(String appkey, String username, JSONObject sessionobj) {
String ip = sessionobj.getString("ip");
String cookie = sessionobj.getString("cookie");
ExeModel exe = new ExeModel();
try {
if ((!AppCache.getInstance().getFirstLevelCache().containsKey(appkey))
&& (!(AppCache.getInstance().getSecondLevelCache().containsKey(appkey)))) {
String cql = "SELECT * FROM app WHERE appid = '%s';";
cql = String.format(cql, appkey);
Iterator rows = this.bridge.excute(cql);
if (!rows.hasNext()) {
exe.setImage("images/icons/app-warning-icon.png");
exe.setLinkurl("");
exe.setName("Has uninstall");
exe.setWinsettings("{}");
return exe;
}
while (rows.hasNext()) {
Row row = (Row) rows.next();
AppModel temp = new AppModel();
temp.setName(row.getString("name"));
temp.setAppid(appkey);
temp.setProfile(row.getString("profile"));
JSONObject profile = JSONObject.fromObject(row.getString("profile"));
temp.setImage(profile.getString("image"));
temp.setInstallUrl(row.getString("url"));
temp.setIsInnerApp(row.getString("isinnerapp"));
AppCache.getInstance().getFirstLevelCache().put(appkey, temp);
}
}
AppModel temp = AppCache.getInstance().getById(appkey);
boolean isinner = temp.getIsInnerApp().equals("1");
exe.setName(temp.getName());
JSONObject profile = JSONObject.fromObject(temp.getProfile());
exe.setImage(profile.getString("image"));
exe.setWinsettings(profile.getString("winSettings"));
if (isinner) {
JSONArray arr = profile.getJSONArray("funcs");
for (Object func : arr) {
JSONObject funcobj = JSONObject.fromObject(func);
if (funcobj.getString("id").equals("1000")) {
exe.setLinkurl(funcobj.getString("url"));
}
}
} else {
exe.setLinkurl("/" + appkey + "/");
}
String roles_str = UserDB.getInstance().getUser(username).getRoles();
Object[] roles = null;
roles = JSONArray.fromObject(roles_str).toArray();
StringBuilder ids = new StringBuilder();
for (Object role : roles) {
String cql = "SELECT permissions FROM group_app_map WHERE appid = '%s' AND groupname='%s';";
cql = String.format(cql, appkey, role.toString());
Iterator rows = this.bridge.excute(cql);
if (rows.hasNext()) {
Row row = (Row) rows.next();
String permissions = row.getString("permissions");
try {
JSONArray perobj = JSONArray.fromObject(permissions);
for (int j = 0; j < perobj.size(); j++) {
JSONObject obj = perobj.getJSONObject(j);
ids.append(obj.get("id")).append("_");
}
} catch (Exception ex) {
ex.printStackTrace();
log.error(ex.getMessage());
}
}
}
if (ids.toString().equals("")) {
exe.setImage("");
exe.setName("No permissions");
exe.setLinkurl("");
return exe;
}
String perm = "id=" + ids.toString();
if (perm.lastIndexOf("_") != -1) {
perm = perm.substring(0, perm.lastIndexOf("_"));
}
exe.setLinkurl(
exe.getLinkurl()
+ "?"
+ perm
+ "&"
+ "username="******"&"
+ "appid="
+ appkey
+ "&ip="
+ ip
+ "&cookie="
+ cookie);
} catch (Exception e) {
exe.setImage("");
exe.setName("error");
exe.setLinkurl("");
e.printStackTrace();
log.error(e.getMessage());
return exe;
}
return exe;
}
private boolean isOnTable() {
return AppModel.getInstance().isOnTable();
}
