Zh OpenStreetMap Visualization - Revision history

Admin: /* Variables */

2020-06-23T11:28:46Z

Variables

← Older revision		Revision as of 11:28, 23 June 2020
Line 297:		Line 297:
	</pre>		</pre>

	In this case variable will be replaced with current user ID		In this case variable will be replaced with current user ID value

	== Conclusion ==		== Conclusion ==

2020-06-23T11:23:01Z

Variables

← Older revision		Revision as of 11:23, 23 June 2020
Line 290:		Line 290:
	For example, here SQL text for getting placemarks		For example, here SQL text for getting placemarks

	<~~code~~>		<pre>
	SELECT latitude as lat, longitude as lng, createddate, title, description, descriptionhtml, icontype		SELECT latitude as lat, longitude as lng, createddate, title, description, descriptionhtml, icontype
	FROM demo_zhosmmaps_markers as t		FROM demo_zhosmmaps_markers as t
	WHERE t.mapid = 2		WHERE t.mapid = 2
	and t.createdbyuser=:userid		and t.createdbyuser=:userid
	</~~code~~>		</pre>

	In this case variable will be replaced with current user ID		In this case variable will be replaced with current user ID


	== Conclusion ==		== Conclusion ==

2020-06-23T11:22:44Z

Conclusion

← Older revision		Revision as of 11:22, 23 June 2020
Line 281:		Line 281:

	[[File:Visualization-Date-Result2.png]]		[[File:Visualization-Date-Result2.png]]

			== Variables ==

			You can pass some parameters to your SQL clause.

			Today it is done for used ID, if you want to restrict by user, you can use ''':userid''' variable

			For example, here SQL text for getting placemarks

			<code>
			SELECT latitude as lat, longitude as lng, createddate, title, description, descriptionhtml, icontype
			FROM demo_zhosmmaps_markers as t
			WHERE t.mapid = 2
			and t.createdbyuser=:userid
			</code>

			In this case variable will be replaced with current user ID


	== Conclusion ==		== Conclusion ==

2020-02-12T09:46:35Z

Data Source

← Older revision		Revision as of 09:46, 12 February 2020
Line 25:		Line 25:
	You can use for table names as full names, as names in joomla notation (ie starting from #__)		You can use for table names as full names, as names in joomla notation (ie starting from #__)

	And '''don't forget about ORDER BY clause in SELECT statement'''		And '''don't forget about ORDER BY clause in SELECT statement''' to get correct coordinates order for your lines or polygons

	== Examples ==		== Examples ==

2020-02-12T09:45:02Z

Data Source

← Older revision		Revision as of 09:45, 12 February 2020
Line 25:		Line 25:
	You can use for table names as full names, as names in joomla notation (ie starting from #__)		You can use for table names as full names, as names in joomla notation (ie starting from #__)

	And '''don't forget about ~~order by~~ clause in ~~select~~ statement'''		And '''don't forget about ORDER BY clause in SELECT statement'''

	== Examples ==		== Examples ==

2020-02-12T09:44:02Z

Data Source

← Older revision		Revision as of 09:44, 12 February 2020
Line 25:		Line 25:
	You can use for table names as full names, as names in joomla notation (ie starting from #__)		You can use for table names as full names, as names in joomla notation (ie starting from #__)

			And '''don't forget about order by clause in select statement'''

	== Examples ==		== Examples ==

2019-11-15T09:12:31Z

Add date of creation

← Older revision		Revision as of 09:12, 15 November 2019
Line 271:		Line 271:
	[[File:Visualization-Date-Override.png]]		[[File:Visualization-Date-Override.png]]

	Enter format, save it		Enter format (it is datetime format for PHP, just search the net for details), save it.

	After that go to your map details again, open ''Advanced settings'' tab. Scroll down to find ''Map override'' field.		After that go to your map details again, open ''Advanced settings'' tab. Scroll down to find ''Map override'' field.

2019-11-15T09:05:47Z

← Older revision		Revision as of 09:05, 15 November 2019
Line 228:		Line 228:
	After all out manipulations we have result		After all out manipulations we have result

			[[File:Visualization-Line-Result.png]]


			=== Add date of creation ===

			In some cases we need to add date to out popups.

			In our data source we have date to show.

			Lets do little changes

			In Data Source will add '''createddate''', it is column where our date is

			[[File:Visualization-Date-DataSQL.png]]

			In Structure will add our column name to definition

			[[File:Visualization-Date-Structure.png]]

			After that we need to enable showing placemarks date of creation in map properties.

			Go to your map details, ''placemarks'' tab

			[[File:Visualization-Date-Map.png]]

			Last field ''Show placemark creation'' set to '''Date of creation'''.

			It is common way to show this date, not only for this two placemarks.

			Check what we get

			[[File:Visualization-Date-Result1.png]]

			Date will be displayed only it is defined.

			Lets change date format. It can be done by map override.

			Go to map overrides and create new one.

			Define title, after that we need do settings for placemark, therefore go to ''Placemark'' tab

			[[File:Visualization-Date-Override.png]]

			Enter format, save it

			After that go to your map details again, open ''Advanced settings'' tab. Scroll down to find ''Map override'' field.

			Select your map override.

			And now we get

			[[File:Visualization-Date-Result2.png]]

	== Conclusion ==		== Conclusion ==

2019-11-15T08:32:28Z

@@ Line 181: / Line 181: @@
 [[File:Visualization-Server.png]]
 And assign it to Data Source
 [[File:Visualization-Data-Server.png]]
 == Conclusion ==

2019-11-13T19:54:25Z

Server

← Older revision		Revision as of 19:54, 13 November 2019
Line 177:		Line 177:
	In some cases you need to connect to external database servers		In some cases you need to connect to external database servers

	In this case you should create server configuration ~~and~~ assign it to Data Source		In this case you should create server configuration

			[[File:Visualization-Server.png]]


			And assign it to Data Source

	[[File:Visualization-Data-Server.png]]		[[File:Visualization-Data-Server.png]]


	== Conclusion ==		== Conclusion ==