Author: sshyrkov
Date: Thu May 31 13:37:26 2007
New Revision: 17414
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17414&repname=
=3Djahia
Log:
CONE-29: Added new method for retrieving page ID based on the page URL key =
and site ID
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aPagesDAO.java
branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/manager/=
JahiaPagesManager.java
branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageBaseService.java
branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageService.java
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/da=
o/JahiaPagesDAO.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/java/org/jahia/hibernate/dao/JahiaPagesDAO.java&rev=3D1741=
4&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aPagesDAO.java (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aPagesDAO.java Thu May 31 13:37:26 2007
@@ -19,6 +19,12 @@
*/
package org.jahia.hibernate.dao;
=
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+
import org.apache.commons.collections.FastArrayList;
import org.apache.commons.collections.FastHashMap;
import org.jahia.content.ContentPageKey;
@@ -26,12 +32,11 @@
import org.jahia.hibernate.model.JahiaPagesDataPK;
import org.jahia.hibernate.model.JahiaPagesProp;
import org.jahia.hibernate.model.JahiaPagesPropPK;
-import org.jahia.services.version.EntryLoadRequest;
import org.jahia.services.pages.ContentPage;
+import org.jahia.services.pages.PageProperty;
+import org.jahia.services.version.EntryLoadRequest;
import org.springframework.orm.hibernate3.HibernateTemplate;
=
-import java.util.*;
-
/**
* Created by IntelliJ IDEA.
* User: Rincevent
@@ -536,5 +541,31 @@
"from JahiaPagesProp p, JahiaPagesData data "=
+
"where p.value=3D? and p.comp_id.pageId=3Ddat=
a.comp_id.id and data.site.id=3D?",new Object[]{propertyValue,siteID});
}
-}
=
+ /**
+ * Returns the page ID with the specified URL key value for the given
sit=
e.
+ * =
+ * @param pageURLKey
+ * the page URL key value to search for
+ * @param siteID
+ * the target site ID
+ * @return the page ID with the specified URL key value for the given
site
+ */
+ public int getPageIDByURLKeyAndSiteID(String pageURLKey, Integer
siteID) {
+ final HibernateTemplate template =3D getHibernateTemplate();
+ template.setCacheQueries(true);
+ template.setFlushMode(HibernateTemplate.FLUSH_NEVER);
+ List items =3D template
+ .find(
+ "select p.comp_id.pageId "
+ + "from
JahiaPagesProp p, JahiaPagesData data "
+ + "where
p.comp_id.name=3D'"
+ +
PageProperty.PAGE_URL_KEY_PROPNAME
+ + "' and
p.value=3D? and p.comp_id.pageId=3Ddata.comp_id.id and da=
ta.site.id=3D?",
+ new Object[] { pageURLKey,
siteID });
+ if (items.size() > 0)
+ return ((Integer) items.get(0)).intValue();
+ else
+ return 0;
+ }
+}
\ No newline at end of file
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/ma=
nager/JahiaPagesManager.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/java/org/jahia/hibernate/manager/JahiaPagesManager.java&re=
v=3D17414&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/manager/=
JahiaPagesManager.java (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/manager/=
JahiaPagesManager.java Thu May 31 13:37:26 2007
@@ -714,5 +714,18 @@
}
return properties;
}
+
+ /**
+ * Returns the page ID with the specified URL key value for the given
sit=
e.
+ * =
+ * @param pageURLKey
+ * the page URL key value to search for
+ * @param siteID
+ * the target site ID
+ * @return the page ID with the specified URL key value for the given
site
+ */
+ public int getPageIDByURLKeyAndSiteID(String pageURLKey, int siteID) {
+ return dao.getPageIDByURLKeyAndSiteID(pageURLKey, new
Integer(siteID));
+ }
}
=
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pag=
es/JahiaPageBaseService.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/java/org/jahia/services/pages/JahiaPageBaseService.java&re=
v=3D17414&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageBaseService.java (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageBaseService.java Thu May 31 13:37:26 2007
@@ -2250,4 +2250,9 @@
public int getParentPageFieldId(int pageId,EntryLoadRequest loadReques=
t) {
return pageManager.getPageFieldID(pageId, loadRequest);
}
+
+ public int getPageIDByURLKeyAndSiteID(String pageURLKey, int siteID) {
+ return pageManager.getPageIDByURLKeyAndSiteID(pageURLKey,
siteID);
+ }
+
}
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pag=
es/JahiaPageService.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/java/org/jahia/services/pages/JahiaPageService.java&rev=3D=
17414&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageService.java (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/services/pages/Jah=
iaPageService.java Thu May 31 13:37:26 2007
@@ -815,4 +815,15 @@
public abstract List getPagePropertiesByValueAndSiteID(String pageURLK=
ey, int siteID) throws JahiaException;
=
public abstract int getParentPageFieldId(int pageId,EntryLoadRequest l=
oadRequest);
+
+ /**
+ * Returns the page ID with the specified URL key value for the given
sit=
e.
+ * =
+ * @param pageURLKey
+ * the page URL key value to search for
+ * @param siteID
+ * the target site ID
+ * @return the page ID with the specified URL key value for the given
site
+ */
+ public abstract int getPageIDByURLKeyAndSiteID(String pageURLKey, int
sit=
eID);
}
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
