/**
* @param rundata
* @param context
* @return
*/
private SelectQuery<TurbineUser> getSelectQuery(RunData rundata, Context context) {
SelectQuery<TurbineUser> query = null;
String word = searchWord.getValue();
String transWord =
ALStringUtil.convertHiragana2Katakana(ALStringUtil.convertH2ZKana(searchWord.getValue()));
query = Database.query(TurbineUser.class);
Expression exp_exclude_my_group =
ExpressionFactory.matchExp(
TurbineUser.TURBINE_USER_GROUP_ROLE_PROPERTY
+ "."
+ TurbineUserGroupRole.TURBINE_GROUP_PROPERTY
+ "."
+ TurbineGroup.OWNER_ID_PROPERTY,
1);
Expression exp01 = ExpressionFactory.matchExp(TurbineUser.DISABLED_PROPERTY, "F");
query.setQualifier(exp01);
Expression exp02 =
ExpressionFactory.noMatchDbExp(TurbineUser.USER_ID_PK_COLUMN, Integer.valueOf(1));
Expression exp03 =
ExpressionFactory.noMatchDbExp(TurbineUser.USER_ID_PK_COLUMN, Integer.valueOf(2));
Expression exp04 =
ExpressionFactory.noMatchDbExp(TurbineUser.USER_ID_PK_COLUMN, Integer.valueOf(3));
query.andQualifier(exp02.andExp(exp03).andExp(exp04));
Expression exp11 = ExpressionFactory.likeExp(TurbineUser.FIRST_NAME_PROPERTY, "%" + word + "%");
Expression exp12 = ExpressionFactory.likeExp(TurbineUser.LAST_NAME_PROPERTY, "%" + word + "%");
Expression exp13 =
ExpressionFactory.likeExp(TurbineUser.FIRST_NAME_KANA_PROPERTY, "%" + word + "%");
Expression exp14 =
ExpressionFactory.likeExp(TurbineUser.LAST_NAME_KANA_PROPERTY, "%" + word + "%");
Expression exp15 = ExpressionFactory.likeExp(TurbineUser.EMAIL_PROPERTY, "%" + word + "%");
Expression exp16 =
ExpressionFactory.likeExp(
TurbineUser.TURBINE_USER_GROUP_ROLE_PROPERTY
+ "."
+ TurbineUserGroupRole.TURBINE_GROUP_PROPERTY
+ "."
+ TurbineGroup.GROUP_ALIAS_NAME_PROPERTY,
"%" + word + "%");
exp16 = exp16.andExp(exp_exclude_my_group);
Expression exp21 =
ExpressionFactory.likeExp(TurbineUser.OUT_TELEPHONE_PROPERTY, "%" + word + "%");
Expression exp22 =
ExpressionFactory.likeExp(TurbineUser.IN_TELEPHONE_PROPERTY, "%" + word + "%");
Expression exp23 =
ExpressionFactory.likeExp(TurbineUser.CELLULAR_PHONE_PROPERTY, "%" + word + "%");
Expression exp31 =
ExpressionFactory.likeExp(TurbineUser.FIRST_NAME_PROPERTY, "%" + transWord + "%");
Expression exp32 =
ExpressionFactory.likeExp(TurbineUser.LAST_NAME_PROPERTY, "%" + transWord + "%");
Expression exp33 =
ExpressionFactory.likeExp(TurbineUser.FIRST_NAME_KANA_PROPERTY, "%" + transWord + "%");
Expression exp34 =
ExpressionFactory.likeExp(TurbineUser.LAST_NAME_KANA_PROPERTY, "%" + transWord + "%");
Expression exp35 =
ExpressionFactory.likeExp(
TurbineUser.TURBINE_USER_GROUP_ROLE_PROPERTY
+ "."
+ TurbineUserGroupRole.TURBINE_GROUP_PROPERTY
+ "."
+ TurbineGroup.GROUP_ALIAS_NAME_PROPERTY,
"%" + transWord + "%");
exp35 = exp35.andExp(exp_exclude_my_group);
Expression exp36 = ExpressionFactory.likeExp(TurbineUser.CODE_PROPERTY, "%" + transWord + "%");
if (word != null && !"".equals(word)) {
query.andQualifier(
exp11
.orExp(exp12)
.orExp(exp13)
.orExp(exp14)
.orExp(exp15)
.orExp(exp16)
.orExp(exp21)
.orExp(exp22)
.orExp(exp23)
.orExp(exp31)
.orExp(exp32)
.orExp(exp33)
.orExp(exp34)
.orExp(exp35)
.orExp(exp36));
}
query.distinct();
return query;
}
/**
* セッションで指定されたアドレスIDを持つアドレス情報を取得する。
*
* @param rundata
* @param context
* @return
*/
public static EipMAddressbook getEipMAddressbook(RunData rundata, Context context) {
// セッションから指定された アドレスID を取得
String addressid = ALEipUtils.getTemp(rundata, context, ALEipConstants.ENTITY_ID);
try {
if (addressid == null || Integer.valueOf(addressid) == null) {
logger.debug("[AddressBook] Address ID...");
return null;
}
SelectQuery<EipMAddressbook> query = Database.query(EipMAddressbook.class);
Expression exp11 =
ExpressionFactory.matchDbExp(
EipMAddressbook.ADDRESS_ID_PK_COLUMN, Integer.valueOf(addressid));
query.setQualifier(exp11);
Expression exp21 = ExpressionFactory.matchExp(EipMAddressbook.PUBLIC_FLAG_PROPERTY, "T");
Expression exp22 =
ExpressionFactory.matchExp(
EipMAddressbook.OWNER_ID_PROPERTY, ALEipUtils.getUserId(rundata));
Expression exp23 = ExpressionFactory.matchExp(EipMAddressbook.PUBLIC_FLAG_PROPERTY, "F");
query.andQualifier(exp21.orExp(exp22.andExp(exp23)));
List<EipMAddressbook> addresses = query.fetchList();
if (addresses == null || addresses.size() == 0) {
logger.debug("[AddressBook] Not found Address ID...");
return null;
}
return addresses.get(0);
} catch (Exception ex) {
logger.error("AddressBookUtils.getEipMAddressbook", ex);
return null;
}
}
private SelectQuery<EipTTodo> getSelectQueryForTodo(RunData rundata, Context context) {
Integer uid = Integer.valueOf(userid);
SelectQuery<EipTTodo> query = Database.query(EipTTodo.class);
Expression exp1 =
ExpressionFactory.noMatchExp(EipTTodo.STATE_PROPERTY, Short.valueOf((short) 100));
query.setQualifier(exp1);
Expression exp01 = ExpressionFactory.matchDbExp(TurbineUser.USER_ID_PK_COLUMN, uid);
Expression exp02 = ExpressionFactory.noMatchDbExp(TurbineUser.USER_ID_PK_COLUMN, uid);
Expression exp03 = ExpressionFactory.matchExp(EipTTodo.PUBLIC_FLAG_PROPERTY, "T");
Expression exp04 = ExpressionFactory.matchExp(EipTTodo.ADDON_SCHEDULE_FLG_PROPERTY, "T");
query.andQualifier(exp01.orExp(exp02.andExp(exp03)).andExp(exp04));
// 終了日時
Expression exp11 =
ExpressionFactory.greaterOrEqualExp(EipTTodo.END_DATE_PROPERTY, getViewDate().getValue());
// 開始日時
Expression exp12 =
ExpressionFactory.lessOrEqualExp(EipTTodo.START_DATE_PROPERTY, getViewDate().getValue());
// 開始日時のみ指定されている ToDo を検索
Expression exp21 =
ExpressionFactory.lessOrEqualExp(EipTTodo.START_DATE_PROPERTY, getViewDate().getValue());
Expression exp22 =
ExpressionFactory.matchExp(EipTTodo.END_DATE_PROPERTY, ToDoUtils.getEmptyDate());
// 終了日時のみ指定されている ToDo を検索
Expression exp31 =
ExpressionFactory.greaterOrEqualExp(EipTTodo.END_DATE_PROPERTY, getViewDate().getValue());
Expression exp32 =
ExpressionFactory.matchExp(EipTTodo.START_DATE_PROPERTY, ToDoUtils.getEmptyDate());
query.andQualifier((exp11.andExp(exp12)).orExp(exp21.andExp(exp22)).orExp(exp31.andExp(exp32)));
return query;
}
/**
* 掲示板カテゴリをデータベースから読み出します。 <br>
*
* @param rundata
* @param context
* @param msgList
* @return
*/
@Override
protected boolean loadFormData(RunData rundata, Context context, List<String> msgList)
throws ALPageNotFoundException, ALDBErrorException {
try {
String loginUserStatus = null;
int uid = (int) login_user.getUserId().getValue();
// オブジェクトモデルを取得
EipTMsgboardCategory category = MsgboardUtils.getEipTMsgboardCategory(rundata, context, true);
if (category == null) {
return false;
}
// カテゴリ名
category_name.setValue(category.getCategoryName());
// メモ
note.setValue(category.getNote());
// 公開区分
boolean public_flag =
(MsgboardUtils.PUBLIC_FLG_VALUE_PUBLIC).equals(category.getPublicFlag());
// このカテゴリを共有しているメンバーを取得
SelectQuery<EipTMsgboardCategoryMap> mapquery = Database.query(EipTMsgboardCategoryMap.class);
Expression mapexp =
ExpressionFactory.matchDbExp(
EipTMsgboardCategory.CATEGORY_ID_PK_COLUMN, category.getCategoryId());
mapquery.setQualifier(mapexp);
List<EipTMsgboardCategoryMap> list = mapquery.fetchList();
List<Integer> users = new ArrayList<Integer>();
int size = list.size();
for (int i = 0; i < size; i++) {
EipTMsgboardCategoryMap map = list.get(i);
users.add(map.getUserId());
if (uid == map.getUserId().intValue()) {
loginUserStatus = map.getStatus();
}
}
SelectQuery<TurbineUser> query = Database.query(TurbineUser.class);
Expression exp = ExpressionFactory.inDbExp(TurbineUser.USER_ID_PK_COLUMN, users);
Expression nonDisabledexp = ExpressionFactory.noMatchExp(TurbineUser.DISABLED_PROPERTY, "T");
query.setQualifier(exp.andExp(nonDisabledexp));
memberList.addAll(ALEipUtils.getUsersFromSelectQuery(query));
if (public_flag) {
if ((MsgboardUtils.STAT_VALUE_ALL).equals(loginUserStatus)) {
access_flag.setValue(MsgboardUtils.ACCESS_PUBLIC_ALL);
is_member = false;
} else {
access_flag.setValue(MsgboardUtils.ACCESS_PUBLIC_MEMBER);
is_member = true;
}
} else {
if ((MsgboardUtils.STAT_VALUE_ALL).equals(loginUserStatus)) {
access_flag.setValue(MsgboardUtils.ACCESS_SEACRET_SELF);
is_member = false;
} else {
access_flag.setValue(MsgboardUtils.ACCESS_SEACRET_MEMBER);
is_member = true;
}
}
} catch (Exception e) {
logger.error("[MsgboardFormData]", e);
throw new ALDBErrorException();
}
return true;
}
/**
* フォームに入力されたデータの妥当性検証を行います。 <br>
*
* @param msgList
* @return TRUE 成功 FALSE 失敗
*/
@Override
protected boolean validate(List<String> msgList) {
String tmp_acl_role_name = acl_role_name.getValue();
if (tmp_acl_role_name != null && !"".equals(tmp_acl_role_name)) {
// ロール名の重複をチェックする
try {
SelectQuery<EipTAclRole> query = Database.query(EipTAclRole.class);
if (ALEipConstants.MODE_INSERT.equals(getMode())) {
Expression exp =
ExpressionFactory.matchExp(EipTAclRole.ROLE_NAME_PROPERTY, tmp_acl_role_name);
query.setQualifier(exp);
} else if (ALEipConstants.MODE_UPDATE.equals(getMode())) {
Expression exp1 =
ExpressionFactory.matchExp(EipTAclRole.ROLE_NAME_PROPERTY, tmp_acl_role_name);
query.setQualifier(exp1);
Expression exp2 =
ExpressionFactory.noMatchDbExp(
EipTAclRole.ROLE_ID_PK_COLUMN, Integer.valueOf(acl_role_id));
query.andQualifier(exp2);
}
if (query.fetchList().size() != 0) {
msgList.add(
ALLocalizationUtils.getl10nFormat(
"ACCESSCTL_ALERT_ALREADY_CREATED", acl_role_name.toString()));
}
} catch (Exception ex) {
logger.error("AccessControlFormData.validate", ex);
return false;
}
}
// ロール名
acl_role_name.validate(msgList);
// メモ
note.validate(msgList);
acllist.validate(msgList);
acldetail.validate(msgList);
aclinsert.validate(msgList);
aclupdate.validate(msgList);
acldelete.validate(msgList);
aclexport.validate(msgList);
// アクセス権限
if (acllist.getValue() == 0
&& acldetail.getValue() == 0
&& aclinsert.getValue() == 0
&& aclupdate.getValue() == 0
&& acldelete.getValue() == 0
&& aclexport.getValue() == 0) {
msgList.add(ALLocalizationUtils.getl10n("ACCESSCTL_ALERT_NO_FEATURE_SELECTED"));
}
// 所属メンバー
if (memberList.size() == 0) {
msgList.add(ALLocalizationUtils.getl10n("ACCESSCTL_ALERT_NO_MEMBER_SELECTED"));
} else {
try {
// 同一機能の他ロールには所属できないようにする
List<Integer> uids = new ArrayList<Integer>();
int msize = memberList.size();
for (int i = 0; i < msize; i++) {
ALEipUser user = memberList.get(i);
uids.add(Integer.valueOf((int) user.getUserId().getValue()));
}
SelectQuery<EipTAclRole> rolequery = Database.query(EipTAclRole.class);
Expression exp11 =
ExpressionFactory.matchDbExp(
EipTAclRole.EIP_TACL_PORTLET_FEATURE_PROPERTY
+ "."
+ EipTAclPortletFeature.FEATURE_ID_PK_COLUMN,
Integer.valueOf((int) feature_id.getValue()));
Expression exp12 =
ExpressionFactory.inDbExp(
EipTAclRole.EIP_TACL_USER_ROLE_MAPS_PROPERTY
+ "."
+ EipTAclUserRoleMap.TURBINE_USER_PROPERTY
+ "."
+ TurbineUser.USER_ID_PK_COLUMN,
uids);
rolequery.setQualifier(exp11.andExp(exp12));
if (ALEipConstants.MODE_UPDATE.equals(getMode())) {
Expression exp13 =
ExpressionFactory.noMatchDbExp(
EipTAclRole.ROLE_ID_PK_COLUMN, Integer.valueOf(acl_role_id));
rolequery.andQualifier(exp13);
}
List<EipTAclRole> roleList = rolequery.fetchList();
if (roleList != null && roleList.size() != 0) {
msgList.add(ALLocalizationUtils.getl10n("ACCESSCTL_ALERT_OTHER_ROLE"));
}
} catch (Exception ex) {
logger.error("AccessControlFormData.validate", ex);
return false;
}
}
return (msgList.size() == 0);
}
