01: /***************************************************************
02: * This file is part of the [fleXive](R) project.
03: *
04: * Copyright (c) 1999-2008
05: * UCS - unique computing solutions gmbh (http://www.ucs.at)
06: * All rights reserved
07: *
08: * The [fleXive](R) project is free software; you can redistribute
09: * it and/or modify it under the terms of the GNU General Public
10: * License as published by the Free Software Foundation;
11: * either version 2 of the License, or (at your option) any
12: * later version.
13: *
14: * The GNU General Public License can be found at
15: * http://www.gnu.org/copyleft/gpl.html.
16: * A copy is found in the textfile GPL.txt and important notices to the
17: * license from the author are found in LICENSE.txt distributed with
18: * these libraries.
19: *
20: * This library is distributed in the hope that it will be useful,
21: * but WITHOUT ANY WARRANTY; without even the implied warranty of
22: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23: * GNU General Public License for more details.
24: *
25: * For further information about UCS - unique computing solutions gmbh,
26: * please see the company website: http://www.ucs.at
27: *
28: * For further information about [fleXive](R), please see the
29: * project website: http://www.flexive.org
30: *
31: *
32: * This copyright notice MUST APPEAR in all copies of the file!
33: ***************************************************************/package com.flexive.core.search.mysql;
34:
35: import com.flexive.core.DatabaseConst;
36: import com.flexive.core.search.PropertyEntry;
37: import com.flexive.shared.exceptions.FxSqlSearchException;
38: import com.flexive.shared.structure.FxDataType;
39: import com.flexive.shared.FxContext;
40: import com.flexive.sqlParser.Property;
41:
42: /**
43: * Selector for ACL's
44: *
45: * @author Gregor Schober (gregor.schober@flexive.com), UCS - unique computing solutions gmbh (http://www.ucs.at)
46: * @version $Rev: 256 $
47: */
48: public class MySQLACLSelector extends MySQLGenericSelector {
49: public MySQLACLSelector() {
50: super (DatabaseConst.TBL_ACLS, "id");
51: }
52:
53: /**
54: * {@inheritDoc}
55: */
56: @Override
57: public void apply(Property prop, PropertyEntry entry,
58: StringBuffer statement) throws FxSqlSearchException {
59: if (prop.getField().equals("LABEL")) {
60: statement.delete(0, statement.length());
61: String _tbl = DatabaseConst.TBL_ACLS + DatabaseConst.ML;
62: final long lang = FxContext.get().getTicket().getLanguage()
63: .getId();
64: statement
65: .append(("ifnull(\n"
66: + "(select acl.label from "
67: + _tbl
68: + " acl, "
69: + DatabaseConst.TBL_CONTENT
70: + " ct where ct.id=filter.id and "
71: + "ct.ver=filter.ver and ct.acl=acl.id and lang="
72: + lang
73: + " limit 1) ,\n"
74: + "(select acl.label from "
75: + _tbl
76: + " acl, "
77: + DatabaseConst.TBL_CONTENT
78: + " ct where ct.id=filter.id and "
79: + "ct.ver=filter.ver and ct.acl=acl.id and deflang=true limit 1) \n" + ")"));
80: entry.overrideDataType(FxDataType.String1024);
81: return;
82: }
83: super .apply(prop, entry, statement);
84: }
85:
86: /**
87: * {@inheritDoc}
88: */
89: @Override
90: public String getAllowedFields() {
91: return super .getAllowedFields() + ",label";
92: }
93: }
|