gistfile1.txt

#* @vtlvariable name="portletNamespace" type="java.lang.String" *#
#* @vtlvariable name="portal" type="com.liferay.portal.util.Portal" *#
#* @vtlvariable name="getterUtil" type="com.liferay.portal.kernel.util.GetterUtil" *#
#* @vtlvariable name="stringUtil" type="com.liferay.portal.kernel.util.StringUtil" *#
#* @vtlvariable name="max-members" type="com.liferay.portlet.journal.util.TemplateNode" *#
#* @vtlvariable name="team-name" type="com.liferay.portlet.journal.util.TemplateNode" *#
#* @vtlvariable name="section-members" type="com.liferay.portlet.journal.util.TemplateNode" *#
#* @vtlvariable name="groupId" type="java.lang.String" *#
#* @vtlvariable name="sectionMembers" type="java.lang.String" *#
#* @vtlvariable name="locale" type="java.util.Locale" *#
#* @vtlvariable name="companyId" type="java.lang.String" *#
#* @vtlvariable name="scopeGroupId" type="java.lang.String" *#
#* @vtlvariable name="sectionName" type="java.lang.String" *#
#* @vtlvariable name="section-name" type="com.liferay.portlet.journal.util.TemplateNode" *#
#* @vtlvariable name="params" type="java.util.LinkedHashMap" *#
#* @vtlvariable name="users" type="java.util.List" *#
#* @vtlvariable name="user" type="com.liferay.portal.model.User" *#
#* @vtlvariable name="themeDisplay" type="com.liferay.portal.theme.ThemeDisplay" *#
#* @vtlvariable name="languageUtil" type="com.liferay.portal.kernel.language.LanguageUtil" *#
#* @vtlvariable name="request" type="java.util.Map" *#
#* @vtlvariable name="httpUtil" type="com.liferay.portal.kernel.util.HttpUtil" *#
#* @vtlvariable name="htmlUtil" type="com.liferay.portal.kernel.util.HtmlUtil" *#
#* @vtlvariable name="obc" type="com.liferay.portal.util.comparator.UserLastNameComparator" *#
#* @vtlvariable name="serviceLocator" type="com.liferay.portal.velocity.ServiceLocator" *#
#* @vtlvariable name="teamLocalService" type="com.liferay.portal.service.TeamLocalServiceUtil" *#
#* @vtlvariable name="mbMessageLocalService" type="com.liferay.portlet.messageboards.service.MBMessageLocalServiceUtil" *#
#* @vtlvariable name="imageToken" type="com.liferay.portal.kernel.servlet.ImageServletToken" *#
#* @vtlvariable name="userLocalService" type="com.liferay.portal.service.UserLocalServiceUtil" *#
#* @vtlvariable name="groupIdCriteria" type="com.liferay.portal.kernel.dao.orm.Criterion" *#
#* @vtlvariable name="groupIdProp" type="com.liferay.portal.kernel.dao.orm.Property" *#
#* @vtlvariable name="threadMap" type="java.util.Map<java.lang.Long, java.lang.Integer>" *#
#* @vtlvariable name="q" type="com.liferay.portal.kernel.dao.orm.DynamicQuery" *#
#* @vtlvariable name="msgs" type="java.util.List<com.liferay.portlet.messageboards.model.MBMessage>" *#

#set ($portletNamespace = $request.portlet-namespace)
#set ($scopeGroupId = $getterUtil.getLong($request.theme-display.scope-group-id))


#if ($request.lifecycle == "RENDER_PHASE")

<div id='${portletNamespace}map' style='height: 300px; margin-bottom: 1.5em; width: 100%;'><!-- --></div>

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">

	var ${portletNamespace}table = new Object();

	google.load("visualization", "1", {packages:["corechart"]});
	google.setOnLoadCallback(${portletNamespace}getTable);

	function ${portletNamespace}drawChart() {
		var data = new google.visualization.DataTable();
		data.addColumn('string', 'Year');
		data.addColumn('number', 'Sales');
		data.addColumn('number', 'Expenses');
		data.addRows([
			['2004', 1000, 400],
			['2005', 1170, 460],
			['2006', 660, 1120],
			['2007', 1030, 540]
		]);

		var options = {
			width: 400, height: 240,
			title: 'Company Performance',
			vAxis: {title: 'Year',  titleTextStyle: {color: 'red'}}
		};

		var chart = new google.visualization.BarChart(document.getElementById('${portletNamespace}map'));
		chart.draw(data, options);
	}

	function ${portletNamespace}getTable() {
		AUI().use(
			"aui-base", "aui-io-plugin", "aui-io-request",
			function(A) {
				A.io.request(
					'${request.resource-url}',
					{
						data: {
						},
						dataType: "json",
						on: {
							success: function(event, id, obj) {
								var responseData = this.get("responseData");

									${portletNamespace}table = responseData.jsonArray || [];

									${portletNamespace}drawChart();
							},
							failure: function(event, id, obj) {
							}
						}
					}
				);
			}
		);
	}

</script>
#elseif ($request.lifecycle == "RESOURCE_PHASE")
	#set ($logFactory = $portal.getClass().forName('com.liferay.portal.kernel.log.LogFactoryUtil'))
	#set ($log = $logFactory.getLog('mylog'))

	$log.error("In Resource Phase!")

	#set ($logFactory = $portal.getClass().forName("com.liferay.portal.kernel.log.LogFactoryUtil"))
	#set ($log = $logFactory.getLog("com.liferay.portal.util.PortalImpl"))
	#set ($portalBeanLocator = $portal.getClass().forName("com.liferay.portal.kernel.bean.PortalBeanLocatorUtil"))
	#set ($portletBeanLocator = $portal.getClass().forName("com.liferay.portal.kernel.bean.PortletBeanLocatorUtil"))

	#set ($fastDateFormatFactoryUtil = $portal.getClass().forName("com.liferay.portal.kernel.util.FastDateFormatFactoryUtil"))
	#set ($jsonFactory = $portalBeanLocator.locate("com.liferay.portal.kernel.json.JSONFactoryUtil"))
	#set ($permissionThreadLocal = $portal.getClass().forName("com.liferay.portal.security.permission.PermissionThreadLocal"))
	#set ($socialActivityInterpreterLocalService = $portalBeanLocator.locate("com.liferay.portlet.social.service.SocialActivityInterpreterLocalService.velocity"))
	#set ($socialActivityLocalService = $portalBeanLocator.locate("com.liferay.portlet.social.service.SocialActivityLocalService.velocity"))
	#set ($mbMessageLocalService = $portalBeanLocator.locate("com.liferay.portlet.messageboards.service.MBMessageLocalService.velocity"))
	#set ($userLocalService = $portalBeanLocator.locate("com.liferay.portal.service.UserLocalService.velocity"))

	#set ($dateFormatDateTime = $fastDateFormatFactoryUtil.getDateTime(1, 3, $locale, $timeZone))
	#set ($portalURL = $httpUtil.getProtocol($request.attributes.CURRENT_URL) + "://" + $getterUtil.getString($request.theme-display.portal-url))

	#set ($themeDisplay = $portal.getClass().forName("com.liferay.portal.theme.ThemeDisplay").newInstance())

	#set ($V = $themeDisplay.setLocale($locale))
	#set ($V = $themeDisplay.setPathImage($getterUtil.getString($request.theme-display.path-image)))
	#set ($V = $themeDisplay.setPathMain($getterUtil.getString($request.theme-display.path-main)))
	#set ($V = $themeDisplay.setPermissionChecker($permissionThreadLocal.getPermissionChecker()))
	#set ($V = $themeDisplay.setPortalURL($portalURL))
	#set ($V = $themeDisplay.setScopeGroupId($scopeGroupId))
	#set ($V = $themeDisplay.setTimeZone($request.theme-display.time-zone))
	#set ($V = $themeDisplay.setUser($userLocalService.getUserById($userId)))

	#set ($calClass = $portal.getClass().forName("java.util.Calendar"))
	#set ($mbMessageClass = $portal.getClass().forName("com.liferay.portlet.messageboards.model.MBMessage"))
	#set ($dqfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil"))
	#set ($rfu = $portal.getClass().forName("com.liferay.portal.kernel.dao.orm.RestrictionsFactoryUtil"))
	#set ($jsonFactory = $portal.getClass().forName('com.liferay.portal.kernel.json.JSONFactoryUtil'))

	#set ($now = $calClass.getInstance())
	#set ($monthago = $calClass.getInstance())
	#set ($V = $monthago.add($calClass.MONTH, -1))

	#set ($q = $dqfu.forClass($mbMessageClass))

	#set ($createDateCriteria = $rfu.between("createDate", $now.getTime(), $monthago.getTime()))
	#set ($V = $q.add($createDateCriteria))

	#set ($groupIdCriteria = $rfu.eq("groupId", $getterUtil.getLong($scopeGroupId)))
	#set ($V = $q.add($groupIdCriteria))

	#set ($companyIdCriteria = $rfu.eq("companyId", $getterUtil.getLong($companyId)))
	#set ($V = $q.add($companyIdCriteria))

	#set ($classPkCriteria = $rfu.eq("classPK", 0))
	#set ($V = $q.add($classPkCriteria))

	#set ($statusCriteria = $rfu.eq("status", 0))
	#set ($V = $q.add($statusCriteria))

	#set ($msgs = $mbMessageLocalService.dynamicQuery($q))
	
{
"jsonArray": $jsonFactory.serialize($msgs)
}
#end