Context Navigation

source: extensions/GMaps/gmaps_ajax.php @ 10915

Last change on this file since 10915 was 10915, checked in by grum, 13 years ago
fix bug:2304
File size: 44.1 KB

Rev	Line
[7054]	1	<?php
	2	/*
	3	* -----------------------------------------------------------------------------
	4	* Plugin Name: GMaps
	5	* -----------------------------------------------------------------------------
	6	* Author : Grum
	7	* email : grum@piwigo.org
	8	* website : http://photos.grum.fr
	9	* PWG user : http://forum.piwigo.org/profile.php?id=3706
	10	*
	11	* << May the Little SpaceFrog be with you ! >>
	12	*
	13	* -----------------------------------------------------------------------------
	14	*
	15	* See main.inc.php for release information
	16	*
	17	* manage all the ajax requests
	18	* -----------------------------------------------------------------------------
	19	*/
	20
[10551]	21	// in this case, PHPWG_ROOT_PATH must be declared as an absolute path...
[7054]	22	define('PHPWG_ROOT_PATH',dirname(dirname(dirname(__FILE__))).'/');
	23
	24	/*
	25	* set ajax module in admin mode if request is used for admin interface
	26	*/
	27	if(!isset($_REQUEST['ajaxfct'])) $_REQUEST['ajaxfct']='';
	28	if(preg_match('/^admin\./i', $_REQUEST['ajaxfct']))
	29	{
	30	define('IN_ADMIN', true);
	31	}
	32
	33	// the common.inc.php file loads all the main.inc.php plugins files
	34	include_once(PHPWG_ROOT_PATH.'include/common.inc.php' );
	35	include_once(PHPWG_PLUGINS_PATH.'GrumPluginClasses/classes/GPCAjax.class.inc.php');
	36	include_once('gmaps_root.class.inc.php');
	37
	38	load_language('plugin.lang', GMAPS_PATH);
	39
	40
	41	class GMaps_Ajax extends GMaps_root
	42	{
	43	/**
	44	* constructor
	45	*/
	46	public function __construct($prefixeTable, $filelocation)
	47	{
	48	parent::__construct($prefixeTable, $filelocation);
	49	$this->loadConfig();
	50	$this->checkRequest();
	51	$this->returnAjaxContent();
	52	}
	53
	54	/**
	55	* check the $_REQUEST values and set default values
	56	*
	57	*/
	58	protected function checkRequest()
	59	{
	60	global $user;
	61
	62	if(!isset($_REQUEST['ajaxfct'])) $_REQUEST['ajaxfct']='';
[7132]	63	if(!isset($_REQUEST['errcode'])) $_REQUEST['errcode']='';
[7054]	64
	65	// check if asked function is valid
	66	if(!($_REQUEST['ajaxfct']=='admin.maps.getList' or
	67	$_REQUEST['ajaxfct']=='admin.maps.setMap' or
	68	$_REQUEST['ajaxfct']=='admin.maps.getMap' or
[7125]	69	$_REQUEST['ajaxfct']=='admin.maps.deleteMap' or
	70	$_REQUEST['ajaxfct']=='admin.assoc.getList' or
	71	$_REQUEST['ajaxfct']=='admin.assoc.setAssoc' or
	72	$_REQUEST['ajaxfct']=='admin.assoc.getAssoc' or
	73	$_REQUEST['ajaxfct']=='admin.assoc.deleteAssoc' or
[7132]	74	$_REQUEST['ajaxfct']=='admin.kmlFiles.getList' or
	75	$_REQUEST['ajaxfct']=='admin.kmlFiles.setFile' or
	76	$_REQUEST['ajaxfct']=='admin.kmlFiles.getFile' or
	77	$_REQUEST['ajaxfct']=='admin.kmlFiles.deleteFile' or
[7125]	78
	79	$_REQUEST['ajaxfct']=='public.maps.init' or
[7308]	80	$_REQUEST['ajaxfct']=='public.maps.getMarkers'
[7054]	81	)) $_REQUEST['ajaxfct']='';
	82
	83	if(preg_match('/^admin\./i', $_REQUEST['ajaxfct']) and !is_admin()) $_REQUEST['ajaxfct']='';
	84
	85
	86	if($_REQUEST['ajaxfct']!='')
	87	{
	88	/*
[7125]	89	* no check for admin.maps.getList & admin.assoc.getList requests
[7054]	90	*/
	91
[7125]	92
[7054]	93	/*
[7132]	94	* check values for
	95	* admin.maps.getMap
	96	* admin.assoc.getAssoc
	97	* admin.kmlFiles.getFile
[7054]	98	*/
[7125]	99	if($_REQUEST['ajaxfct']=="admin.maps.getMap" or
[7132]	100	$_REQUEST['ajaxfct']=="admin.assoc.getAssoc" or
	101	$_REQUEST['ajaxfct']=="admin.kmlFiles.getFile")
[7054]	102	{
	103	if(!isset($_REQUEST['id']) or
	104	!is_numeric($_REQUEST['id']) or
	105	$_REQUEST['id']=='') $_REQUEST['ajaxfct']='';
	106	}
	107
	108	/*
[7132]	109	* check values for
	110	* admin.maps.deleteMap
	111	* admin.assoc.deleteAssoc
	112	* admin.kmlFiles.deleteFile
[7054]	113	*/
[7125]	114	if($_REQUEST['ajaxfct']=="admin.maps.deleteMap" or
[7132]	115	$_REQUEST['ajaxfct']=="admin.assoc.deleteAssoc" or
	116	$_REQUEST['ajaxfct']=="admin.kmlFiles.deleteFile")
[7054]	117	{
	118	if(!isset($_REQUEST['id']) or
	119	!is_numeric($_REQUEST['id']) or
	120	$_REQUEST['id']=='') $_REQUEST['ajaxfct']='';
	121	}
	122
	123	/*
[7125]	124	* check admin.maps.setMap values
[7054]	125	*/
	126	if($_REQUEST['ajaxfct']=="admin.maps.setMap")
	127	{
	128	if(!isset($_REQUEST['id']) or
	129	!isset($_REQUEST['datas']) or !is_array($_REQUEST['datas']))
	130	{
	131	$_REQUEST['ajaxfct']='';
	132	}
	133	else
	134	{
[7308]	135	if(!(isset($_REQUEST['datas']['displayType']) and
	136	isset($_REQUEST['datas']['sizeMode']) and
	137	isset($_REQUEST['datas']['name']) and
	138	isset($_REQUEST['datas']['width']) and
	139	isset($_REQUEST['datas']['height']) and
	140	isset($_REQUEST['datas']['zoomLevel']) and
	141	isset($_REQUEST['datas']['mapType']) and
	142	isset($_REQUEST['datas']['mapTypeControl']) and
	143	isset($_REQUEST['datas']['navigationControl']) and
	144	isset($_REQUEST['datas']['scaleControl']) and
	145	isset($_REQUEST['datas']['streetViewControl']) and
	146	isset($_REQUEST['datas']['style']) and
	147	isset($_REQUEST['datas']['zoomLevelMaxActivated'])
	148	))
[7054]	149	{
	150	$_REQUEST['ajaxfct']='';
	151	}
	152	else
	153	{
[7125]	154	if(!($_REQUEST['datas']['displayType']=='IC' or
	155	$_REQUEST['datas']['displayType']=='IP' or
	156	$_REQUEST['datas']['displayType']=='MP')) $_REQUEST['ajaxfct']='';
	157
	158	if(!($_REQUEST['datas']['sizeMode']=='A' or
	159	$_REQUEST['datas']['sizeMode']=='F')) $_REQUEST['ajaxfct']='';
	160
[7054]	161	if(!is_numeric($_REQUEST['datas']['width']) or
	162	$_REQUEST['datas']['width']<100 or
	163	$_REQUEST['datas']['width']>1280) $_REQUEST['datas']['width']=470;
	164
	165	if(!is_numeric($_REQUEST['datas']['height']) or
	166	$_REQUEST['datas']['height']<100 or
	167	$_REQUEST['datas']['height']>1280) $_REQUEST['datas']['height']=210;
	168
	169	if(!is_numeric($_REQUEST['datas']['zoomLevel']) or
	170	$_REQUEST['datas']['zoomLevel']<1 or
	171	$_REQUEST['datas']['zoomLevel']>20) $_REQUEST['datas']['zoomLevel']=4;
	172
	173	if(!($_REQUEST['datas']['mapType']=='hybrid' or
	174	$_REQUEST['datas']['mapType']=='terrain' or
	175	$_REQUEST['datas']['mapType']=='roadmap' or
	176	$_REQUEST['datas']['mapType']=='satellite')) $_REQUEST['datas']['mapType']='hybrid';
	177
	178	if(!is_numeric($_REQUEST['datas']['mapTypeControl']) or
	179	$_REQUEST['datas']['mapTypeControl']<-1 or
	180	$_REQUEST['datas']['mapTypeControl']>2) $_REQUEST['datas']['mapTypeControl']=0;
	181
	182	if(!is_numeric($_REQUEST['datas']['navigationControl']) or
	183	$_REQUEST['datas']['navigationControl']<-1 or
	184	$_REQUEST['datas']['navigationControl']>3) $_REQUEST['datas']['navigationControl']=0;
	185
	186	if(!($_REQUEST['datas']['scaleControl']=='y' or
	187	$_REQUEST['datas']['scaleControl']=='n')) $_REQUEST['datas']['scaleControl']='y';
[7177]	188
	189	if(!($_REQUEST['datas']['streetViewControl']=='y' or
	190	$_REQUEST['datas']['streetViewControl']=='n')) $_REQUEST['datas']['streetViewControl']='n';
[7308]	191
	192	if(!($_REQUEST['datas']['zoomLevelMaxActivated']=='y' or
	193	$_REQUEST['datas']['zoomLevelMaxActivated']=='n')) $_REQUEST['datas']['zoomLevelMaxActivated']='n';
[7054]	194	}
	195	}
	196	}
	197
	198
[7125]	199	/*
	200	* check admin.maps.setAssoc values
	201	*/
	202	if($_REQUEST['ajaxfct']=="admin.assoc.setAssoc")
	203	{
	204	if(!isset($_REQUEST['id']) or
	205	!isset($_REQUEST['datas']) or !is_array($_REQUEST['datas']))
	206	{
	207	$_REQUEST['ajaxfct']='';
	208	}
	209	else
	210	{
[7308]	211	if(!(isset($_REQUEST['datas']['categoryId']) and
	212	isset($_REQUEST['datas']['mapId']) and
	213	isset($_REQUEST['datas']['applySubCat']) and
	214	isset($_REQUEST['datas']['kmlFileId']) and
	215	isset($_REQUEST['datas']['kmlFileUrl']) and
	216	isset($_REQUEST['datas']['icon']) and
	217	isset($_REQUEST['datas']['marker']) and
[7125]	218	isset($_REQUEST['datas']['title']) ))
	219	{
	220	$_REQUEST['ajaxfct']='';
	221	}
	222	else
	223	{
	224	if($_REQUEST['datas']['categoryId']=='' or
	225	$_REQUEST['datas']['categoryId']<0) $_REQUEST['ajaxfct']='';
	226
	227	if($_REQUEST['datas']['mapId']=='') $_REQUEST['ajaxfct']='';
	228
	229	if(!($_REQUEST['datas']['applySubCat']=='y' or
	230	$_REQUEST['datas']['applySubCat']=='n')) $_REQUEST['datas']['applySubCat']='y';
[7479]	231
	232	if(!isset($_REQUEST['datas']['forceDisplay'])) $_REQUEST['datas']['forceDisplay']='n';
	233	if(!($_REQUEST['datas']['forceDisplay']=='y' or
	234	$_REQUEST['datas']['forceDisplay']=='n')) $_REQUEST['datas']['forceDisplay']='n';
[7125]	235	}
	236	}
	237	}
	238
	239
	240	/*
[7132]	241	* check admin.kmlFiles.setFile values
	242	*/
	243	if($_REQUEST['ajaxfct']=="admin.kmlFiles.setFile")
	244	{
	245	if(!isset($_REQUEST['id']) )
	246	{
	247	$_REQUEST['ajaxfct']='';
	248	}
	249	else
	250	{
	251	if($_REQUEST['id']=='')
	252	{
	253	if(!(isset($_FILES['file']['name']) and
	254	isset($_FILES['file']['tmp_name']))) $_REQUEST['ajaxfct']='';
	255	}
	256	}
	257	}
	258
	259
	260
	261	/*
[7125]	262	* check public.maps.getMarkers values
	263	*/
	264	if($_REQUEST['ajaxfct']=="public.maps.getMarkers")
	265	{
	266	if(!isset($_REQUEST['datas']) or
	267	!is_array($_REQUEST['datas']))
	268	{
	269	$_REQUEST['ajaxfct']='';
	270	}
	271	else
	272	{
[7308]	273	if(!(isset($_REQUEST['datas']['requestId']) and
	274	isset($_REQUEST['datas']['callId']) and
	275	isset($_REQUEST['datas']['bounds']) and
	276	isset($_REQUEST['datas']['width']) and
	277	isset($_REQUEST['datas']['height']) and
	278	isset($_REQUEST['datas']['distanceTreshold']) and
	279	isset($_REQUEST['datas']['bounds']['north']) and
	280	isset($_REQUEST['datas']['bounds']['south']) and
	281	isset($_REQUEST['datas']['bounds']['east']) and
[7125]	282	isset($_REQUEST['datas']['bounds']['west']) ))
	283	{
	284	$_REQUEST['ajaxfct']='';
	285	}
[7500]	286	if(!isset($_REQUEST['datas']['loadIndex'])) $_REQUEST['datas']['loadIndex']='';
[7125]	287	}
	288	}
	289
	290	/*
	291	* check public.maps.getMarkerInfos values
	292	*/
	293	if($_REQUEST['ajaxfct']=="public.maps.init")
	294	{
[7500]	295	if(!isset($_REQUEST['category'])) $_REQUEST['ajaxfct']='';
	296	if(!isset($_REQUEST['mapId'])) $_REQUEST['mapId']=null;
[7125]	297	}
[7054]	298	}
	299	} //checkRequest
	300
	301
	302	/**
	303	* return ajax content
	304	*/
	305	protected function returnAjaxContent()
	306	{
	307	$result="<p class='errors'>An error has occured</p>";
	308	switch($_REQUEST['ajaxfct'])
	309	{
	310	case 'admin.maps.getList':
	311	$result=$this->ajax_gmaps_admin_mapsGetList();
	312	break;
	313	case 'admin.maps.getMap':
	314	$result=$this->ajax_gmaps_admin_mapsGetMap($_REQUEST['id']);
	315	break;
	316	case 'admin.maps.setMap':
	317	$result=$this->ajax_gmaps_admin_mapsSetMap($_REQUEST['id'], $_REQUEST['datas']);
	318	break;
	319	case 'admin.maps.deleteMap':
	320	$result=$this->ajax_gmaps_admin_mapsDeleteMap($_REQUEST['id']);
	321	break;
[7125]	322	case 'admin.assoc.getList':
	323	$result=$this->ajax_gmaps_admin_assocGetList();
	324	break;
	325	case 'admin.assoc.getAssoc':
	326	$result=$this->ajax_gmaps_admin_assocGetAssoc($_REQUEST['id']);
	327	break;
	328	case 'admin.assoc.setAssoc':
	329	$result=$this->ajax_gmaps_admin_assocSetAssoc($_REQUEST['id'], $_REQUEST['datas']);
	330	break;
	331	case 'admin.assoc.deleteAssoc':
	332	$result=$this->ajax_gmaps_admin_assocDeleteAssoc($_REQUEST['id']);
	333	break;
[7132]	334	case 'admin.kmlFiles.getList':
	335	$result=$this->ajax_gmaps_admin_kmlFilesGetList();
	336	break;
	337	case 'admin.kmlFiles.getFile':
	338	$result=$this->ajax_gmaps_admin_kmlFilesGetFile($_REQUEST['id']);
	339	break;
	340	case 'admin.kmlFiles.setFile':
	341	$result=$this->ajax_gmaps_admin_kmlFilesSetFile($_REQUEST['id'], $_REQUEST['name']);
	342	break;
	343	case 'admin.kmlFiles.deleteFile':
	344	$result=$this->ajax_gmaps_admin_kmlFilesDeleteFile($_REQUEST['id']);
	345	break;
[7125]	346
[7132]	347
[7125]	348	case 'public.maps.init':
[7500]	349	$result=$this->ajax_gmaps_public_mapsInit($_REQUEST['category'], $_REQUEST['mapId']);
[7125]	350	break;
	351	case 'public.maps.getMarkers':
	352	$result=$this->ajax_gmaps_public_mapsGetMarkers($_REQUEST['datas']);
	353	break;
[7308]	354	case 'public.maps.getMarkersInfos':
	355	$result=$this->ajax_gmaps_public_mapsGetMarkersInfos($_REQUEST['datas']);
	356	break;
[7054]	357	}
	358	GPCAjax::returnResult($result);
	359	}
	360
	361
	362	/------------------------------------------------------------------------
	363	*
	364	* ADMIN FUNCTIONS
	365	*
	366	----------------------------------------------------------------------- /
	367
	368	/**
	369	* return a HTML list of defined maps
	370	*
	371	* @return String
	372	*/
	373	private function ajax_gmaps_admin_mapsGetList()
	374	{
	375	global $template;
	376
	377	$template->set_filename('list_page',
	378	dirname($this->getFileLocation()).'/admin/gmaps_maps_iListMaps.tpl');
	379
	380	$datas=Array();
	381
[7308]	382	$sql="SELECT id, name, displayType, sizeMode, width, height, zoomLevel,
	383	mapType, mapTypeControl, navigationControl, scaleControl,
	384	streetViewControl, zoomLevelMaxActivated
[7054]	385	FROM ".$this->tables['maps']."
[7125]	386	ORDER BY displayType ASC, name ASC";
[7054]	387	$result=pwg_query($sql);
	388	if($result)
	389	{
	390	while($row=pwg_db_fetch_assoc($result))
	391	{
[7125]	392	if($row['displayType']=='IC')
	393	{
	394	$row['zoomLevel']=l10n('gmaps_auto');
	395	}
[7054]	396
[7125]	397	$row['displayType']=l10n('gmaps_displayTypeShort'.$row['displayType']);
	398
	399	if($row['sizeMode']=='A')
	400	{
	401	$row['dimensions']=l10n('gmaps_auto');
	402	}
	403	else
	404	{
	405	$row['dimensions']=$row['width'].'x'.$row['height'];
	406	}
	407
[7054]	408	$row['mapType']=l10n('gmaps_googleMapType_'.$row['mapType']);
	409	$row['mapTypeControl']=l10n('gmaps_googleMapTypeControl_'.$row['mapTypeControl']);
	410	$row['navigationControl']=l10n('gmaps_googleMapNavigationControl_'.$row['navigationControl']);
	411	$row['scaleControl']=($row['scaleControl']=='y')?l10n('gmaps_display_visible'):l10n('gmaps_display_hidden');
[7177]	412	$row['streetViewControl']=($row['streetViewControl']=='y')?l10n('gmaps_display_visible'):l10n('gmaps_display_hidden');
[7054]	413	$datas[]=$row;
	414	}
	415	}
	416
	417	$template->assign('datas', $datas);
	418	return($template->parse('list_page', true));
	419	} //ajax_gmaps_admin_mapsGetList
	420
	421
	422	/**
	423	* set properties for a given map id ; if no map id is given, create a new
	424	* map
	425	*
	426	* @param String id : the map Id
	427	* @param Array datas : properties of the map (assuming array index were
	428	* checked by the checkRequest function)
	429	* @return String : the num id, or an error message
	430	*/
	431	private function ajax_gmaps_admin_mapsSetMap($id, $properties)
	432	{
	433	global $template;
	434
	435	if($id=='')
	436	{
	437	$sql="INSERT INTO ".$this->tables['maps']."
[7125]	438	VALUES ('', '".mysql_escape_string($properties['name'])."', '".
	439	$properties['displayType']."', '".
	440	$properties['sizeMode']."', '".
[7054]	441	$properties['width']."', '".
	442	$properties['height']."', '".
	443	$properties['zoomLevel']."', '".
	444	$properties['mapType']."', '".
	445	$properties['mapTypeControl']."', '".
	446	$properties['navigationControl']."', '".
	447	$properties['scaleControl']."', '".
[7177]	448	$properties['streetViewControl']."', '".
[7308]	449	mysql_escape_string($properties['style'])."', '".
	450	$properties['zoomLevelMaxActivated']."');";
[7054]	451	$result=pwg_query($sql);
	452	$id=pwg_db_insert_id();
	453	}
	454	else
	455	{
	456	$sql="UPDATE ".$this->tables['maps']."
[7125]	457	SET name='".mysql_escape_string($properties['name'])."', displayType='".
	458	$properties['displayType']."', sizeMode='".
	459	$properties['sizeMode']."', width='".
[7054]	460	$properties['width']."', height='".
	461	$properties['height']."', zoomLevel='".
	462	$properties['zoomLevel']."', mapType='".
	463	$properties['mapType']."', mapTypeControl='".
	464	$properties['mapTypeControl']."', navigationControl='".
	465	$properties['navigationControl']."', scaleControl='".
[7177]	466	$properties['scaleControl']."', streetViewControl='".
	467	$properties['streetViewControl']."', style='".
[7308]	468	mysql_escape_string($properties['style'])."', zoomLevelMaxActivated='".
	469	$properties['zoomLevelMaxActivated']."'
[7054]	470	WHERE id='$id';";
	471	$result=pwg_query($sql);
	472	}
	473
	474	return($id);
	475	} //ajax_gmaps_admin_mapsSetMap
	476
	477
	478	/**
	479	* get properties for a given map id
	480	*
	481	* @param String id : the map Id
	482	* @return String : data formatted in a JSON string
	483	*/
	484	private function ajax_gmaps_admin_mapsGetMap($id)
	485	{
	486	$returned=array(
	487	'id' => '',
	488	'name' => '',
[7125]	489	'displayType' => '',
	490	'sizeMode' => '',
[7054]	491	'width' => 470,
	492	'height' => 210,
	493	'zoomLevel' => 4,
	494	'mapType' => 'hybrid',
	495	'mapTypeControl' => 0,
	496	'navigationControl' => 0,
[7177]	497	'scaleControl' => 'y',
[7308]	498	'streetViewControl' => 'n',
	499	'zoomLevelMaxActivated' => 'n',
	500	'associations' => 0,
[7054]	501	);
	502
[7308]	503	$sql="SELECT pgmm.id, pgmm.displayType, pgmm.sizeMode, pgmm.name,
	504	pgmm.width, pgmm.height, pgmm.zoomLevel, pgmm.mapType,
	505	pgmm.mapTypeControl, pgmm.navigationControl,
	506	pgmm.scaleControl, pgmm.streetViewControl,
	507	pgmm.zoomLevelMaxActivated,
	508	COUNT(pgcm.id) AS nbAssoc
	509	FROM ".$this->tables['maps']." pgmm
	510	LEFT JOIN ".$this->tables['category_maps']." pgcm
	511	ON pgcm.mapId=pgmm.id
	512	WHERE pgmm.id='$id'
	513	GROUP BY pgmm.id;";
[7054]	514	$result=pwg_query($sql);
	515	if($result)
	516	{
	517	while($row=pwg_db_fetch_assoc($result))
	518	{
	519	$returned=$row;
	520	}
	521	}
	522
	523	return(json_encode($returned));
[7125]	524	} //ajax_gmaps_admin_mapsGetMap
[7054]	525
	526
	527
	528	/**
	529	* delete a map
	530	*
	531	* @param String id : if of the map to delete
	532	* @return String : ok or ko
	533	*/
	534	private function ajax_gmaps_admin_mapsDeleteMap($id)
	535	{
	536	$sql="DELETE FROM ".$this->tables['maps']."
	537	WHERE id='$id';";
	538	$result=pwg_query($sql);
	539	if($result)
	540	{
	541	$sql="DELETE FROM ".$this->tables['category_maps']."
	542	WHERE map_id='$id';";
	543	$result=pwg_query($sql);
	544	if($result) return('ok');
	545	}
	546
	547	return('ko!unknown error');
[7125]	548	} //ajax_gmaps_admin_mapsDeleteMap
	549
	550
	551
	552
	553
	554	/**
	555	* return a HTML list of defined associations
	556	*
	557	* @return String
	558	*/
	559	private function ajax_gmaps_admin_assocGetList()
	560	{
	561	global $template;
	562
	563	$template->set_filename('list_page',
	564	dirname($this->getFileLocation()).'/admin/gmaps_category_maps_iListMaps.tpl');
	565
	566	$datas=Array();
	567
	568	$sql="SELECT pgcm.id, pgcm.categoryId, pct.name AS catName,
	569	pgmm.name AS mapName, pgmm.displayType,
[7132]	570	pgcm.kmlFileId, pgcm.kmlFileUrl, pgcm.imgSort, pgcm.applySubCat, pgcm.icon,
[7479]	571	pgcm.title, pgkf.name AS kmlName, pgcm.forceDisplay
[7132]	572	FROM ((".$this->tables['category_maps']." pgcm
[7125]	573	LEFT JOIN ".CATEGORIES_TABLE." pct ON pct.id=pgcm.categoryId)
[7132]	574	LEFT JOIN ".$this->tables['maps']." pgmm ON pgcm.mapId = pgmm.id)
	575	LEFT JOIN ".$this->tables['kmlfiles']." pgkf ON pgkf.id = pgcm.kmlFileId
[7125]	576	ORDER BY pct.name, pgmm.displayType, pgcm.imgSort";
	577	$result=pwg_query($sql);
	578	if($result)
	579	{
	580	$keys=array(
	581	'prev' => '',
	582	'curr' => ''
	583	);
	584	while($row=pwg_db_fetch_assoc($result))
	585	{
	586	$keys['prev']=$keys['curr'];
	587
[7132]	588	if($row['kmlFileId']>0)
	589	{
	590	$mapKmlFile=$row['kmlName'];
	591	}
	592	elseif($row['kmlFileUrl']!='')
	593	{
	594	$mapKmlFile='URL';
	595	}
	596	else
	597	{
	598	$mapKmlFile='';
	599	}
	600
	601
[7125]	602	$tmp=array(
	603	'id' => $row['id'],
	604	'catName' => ($row['categoryId']==0)?l10n('gmaps_applyForAllTheGallery'):$row['catName'],
	605	'applySubCat' => l10n('gmaps_'.$row['applySubCat']),
	606	'mapName' => $row['mapName'],
[7132]	607	'mapKmlFile' => $mapKmlFile,
[7125]	608	'icon' => $row['icon'],
	609	'displayType' => l10n('gmaps_displayTypeShort'.$row['displayType']),
[7479]	610	'title' => $row['title'],
	611	'forceDisplay' => l10n('gmaps_'.$row['forceDisplay']),
[7125]	612	);
	613
	614	$keys['curr']=$row['categoryId'].$row['displayType'];
	615
	616	if($keys['curr']==$keys['prev'])
	617	{
	618	$tmp['catName']='';
	619	$tmp['displayType']='';
	620	$tmp['applySubCat']='';
	621	}
	622
	623	$datas[]=$tmp;
	624	}
	625	}
	626
	627	$template->assign('datas', $datas);
	628	return($template->parse('list_page', true));
	629	} //ajax_gmaps_admin_assocGetList
	630
	631
	632
	633
	634	/**
	635	* set properties for a given association id ; if no association id is given
	636	* create a new association
	637	*
	638	* @param String id : the association Id
	639	* @param Array datas : properties of the association (assuming array index
	640	* were checked by the checkRequest function)
	641	* @return String : the num id, or an error message
	642	*/
	643	private function ajax_gmaps_admin_assocSetAssoc($id, $properties)
	644	{
	645	global $template;
	646
	647	// if create a new assoc, get the last imgSort
	648	$db=array(
	649	'nbId' => 0,
	650	'displayType' => '',
	651	'maxImgSort' => 0
	652	);
	653
	654	$sql="SELECT MAX(imgSort) AS maxImgSort, pgmm.displayType, COUNT(pgcm.id) AS nbId
	655	FROM (".$this->tables['category_maps']." pgcm
	656	LEFT JOIN ".$this->tables['maps']." pgmm ON pgmm.id = pgcm.mapId)
	657	LEFT JOIN ".$this->tables['maps']." pgmm2 ON pgmm2.displayType=pgmm.displayType
	658
	659	WHERE categoryId='".$properties['categoryId']."'
	660	AND pgmm2.id='".$properties['mapId']."'
	661	GROUP BY pgmm.displayType;";
	662	$result=pwg_query($sql);
	663	if($result)
	664	{
	665	while($row=pwg_db_fetch_assoc($result))
	666	{
	667	$db=$row;
	668	}
	669	}
	670
	671	if($id=='' and
	672	($db['displayType']=='IC' or $db['displayType']=='IP') and
	673	$db['nbId']>0
	674	)
	675	{
	676	return('!'.l10n('gmaps_only_one_map_is_allowed_for_this_mode'));
	677	}
	678
	679
	680	if($id=='')
	681	{
	682	$sql="INSERT INTO ".$this->tables['category_maps']."
	683	VALUES ('', '".
	684	$properties['categoryId']."', '".
	685	$properties['mapId']."', '".
	686	($db['maxImgSort']+1)."', '".
	687	$properties['applySubCat']."', '".
[7132]	688	$properties['kmlFileId']."', '".
[7125]	689	$properties['kmlFileUrl']."', '".
[7147]	690	basename($properties['icon'])."', '".
	691	basename($properties['marker'])."', '".
[7479]	692	mysql_escape_string($properties['title'])."', '".
	693	$properties['forceDisplay']."');";
[7125]	694	$result=pwg_query($sql);
	695	$id=pwg_db_insert_id();
	696	}
	697	else
	698	{
	699	$sql="UPDATE ".$this->tables['category_maps']."
	700	SET categoryId='".
	701	$properties['categoryId']."', mapId='".
	702	$properties['mapId']."', applySubCat='".
	703	$properties['applySubCat']."', kmlFileUrl='".
[7132]	704	$properties['kmlFileUrl']."', kmlFileId='".
	705	$properties['kmlFileId']."', icon='".
[7147]	706	basename($properties['icon'])."', marker='".
	707	basename($properties['marker'])."', title='".
[7479]	708	mysql_escape_string($properties['title'])."', forceDisplay='".
	709	$properties['forceDisplay']."'
[7125]	710	WHERE id='$id';";
	711	$result=pwg_query($sql);
	712	}
	713
	714	return($id);
	715	} //ajax_gmaps_admin_assocSetAssoc
	716
	717
	718
	719
	720	/**
	721	* get properties for a given association id
	722	*
	723	* @param String id : the association Id
	724	* @return String : data formatted in a JSON string
	725	*/
	726	private function ajax_gmaps_admin_assocGetAssoc($id)
	727	{
	728	$returned=array(
	729	'id' => '',
	730	'categoryId' => 0,
	731	'mapId' => '',
	732	'applySubCat'=> 'y',
[7132]	733	'kmlFileId' => 0,
[7125]	734	'kmlFileUrl' => '',
	735	'icon' => '',
[7139]	736	'marker' => '',
[7479]	737	'title' => '',
	738	'forceDisplay' => 'n'
[7125]	739	);
	740
[7132]	741	$sql="SELECT id, categoryId, mapId, applySubCat, kmlFileId, kmlFileUrl,
[7479]	742	icon, marker, title, forceDisplay
[7125]	743	FROM ".$this->tables['category_maps']."
	744	WHERE id='$id';";
	745	$result=pwg_query($sql);
	746	if($result)
	747	{
	748	while($row=pwg_db_fetch_assoc($result))
	749	{
	750	$returned=$row;
	751	}
	752	}
	753
	754	return(json_encode($returned));
	755	} //ajax_gmaps_admin_assocGetAssoc
	756
	757
	758
	759
	760	/**
	761	* delete an association
	762	*
	763	* @param String id : if of the association to delete
	764	* @return String : ok or ko
	765	*/
	766	private function ajax_gmaps_admin_assocDeleteAssoc($id)
	767	{
	768	$sql="DELETE FROM ".$this->tables['category_maps']."
	769	WHERE id='$id';";
	770	$result=pwg_query($sql);
	771	if($result) return('ok');
	772
	773	return('ko!unknown error');
	774	} //ajax_gmaps_admin_assocDeleteAssoc
	775
	776
[7132]	777
[7125]	778	/**
[7132]	779	* return a HTML list of referenced kml files
	780	*
	781	* @return String
	782	*/
	783	private function ajax_gmaps_admin_kmlFilesGetList()
	784	{
	785	global $template;
	786
	787	$template->set_filename('list_page',
	788	dirname($this->getFileLocation()).'/admin/gmaps_kmlfiles_iListFiles.tpl');
	789
	790	$datas=Array();
	791
	792	$sql="SELECT pgkf.id, pgkf.file, pgkf.name, pgkf.fileDate, pgkf.fileSize, COUNT(pgcm.id) AS nbAssoc
	793	FROM ".$this->tables['kmlfiles']." pgkf
	794	LEFT JOIN ".$this->tables['category_maps']." pgcm ON pgcm.kmlFileId = pgkf.id
	795	GROUP BY pgkf.id
	796	ORDER BY pgkf.name";
	797
	798	$result=pwg_query($sql);
	799	if($result)
	800	{
	801	while($row=pwg_db_fetch_assoc($result))
	802	{
[7308]	803	$row['fileSize']=GPCCore::formatOctet($row['fileSize']);
[7132]	804	$datas[]=$row;
	805	}
	806	}
	807
	808	$template->assign('datas', $datas);
	809	return($template->parse('list_page', true));
	810	} //ajax_gmaps_admin_kmlFilesGetList
	811
	812
	813
	814
	815	/**
	816	* set properties for a given file id ; if no file id is given create a new
	817	* file
	818	*
	819	* @param String $id : the file Id
	820	* @param String $name : the name
	821	* @param String $file : the file name
	822	* @return String : the num id, or an error message
	823	*/
	824	private function ajax_gmaps_admin_kmlFilesSetFile($id, $name)
	825	{
	826	global $template;
	827
	828	if(isset($_FILES['file']['name']))
	829	{
	830	$file=$_FILES['file']['name'];
	831	}
	832	else
	833	{
	834	$file='';
	835	}
	836
	837	if($file=='' and $id!='')
	838	{
	839	// update name for an existing file
	840	$sql="UPDATE ".$this->tables['kmlfiles']."
	841	SET name='".mysql_escape_string($name)."'
	842	WHERE id='$id';";
	843	$result=pwg_query($sql);
	844	}
	845	elseif($file!='')
	846	{
	847	// check if this file is not already used by an another file id
	848	$sql="SELECT file
	849	FROM ".$this->tables['kmlfiles']."
	850	WHERE file='".mysql_escape_string($_FILES['file']['name'])."'";
	851	if($id!='') $sql.=" AND id!='$id'";
	852	$result=pwg_query($sql);
	853	if($result)
	854	{
	855	$ok='';
	856	while($row=pwg_db_fetch_assoc($result))
	857	{
	858	$ok=$row['file'];
	859	}
	860	if($ok!='')
	861	{
	862	//file already used by another file id
	863	header("Location: ".$_SERVER['HTTP_REFERER']."&errcode=aksf10");
	864	exit();
	865	}
	866	}
	867	else
	868	{
	869	//unknown error
	870	header("Location: ".$_SERVER['HTTP_REFERER']."&errcode=aksf01");
	871	exit();
	872	}
	873
[10915]	874	$file=GPCCore::getPiwigoSystemPath().'/'.PWG_LOCAL_DIR.self::KML_DIRECTORY.$file;
[7132]	875
	876	if(file_exists($file)) unlink($file);
	877	if($id!='')
	878	{
	879	$currentInfo=$this->ajax_gmaps_admin_kmlFilesGetFile($id, false);
[10915]	880	if(file_exists(GPCCore::getPiwigoSystemPath().'/'.PWG_LOCAL_DIR.self::KML_DIRECTORY.$currentInfo['file'])) unlink(GPCCore::getPiwigoSystemPath().'/'.PWG_LOCAL_DIR.self::KML_DIRECTORY.$currentInfo['file']);
[7132]	881	}
	882
	883
	884	if(!move_uploaded_file($_FILES['file']['tmp_name'], $file))
	885	{
	886	/*
	887	* something was wrong, previous file was deleted, so delete the file
	888	* from the database
	889	*/
	890	if($id!='') $this->ajax_gmaps_admin_kmlFilesDeleteFile($id);
	891	// error when trying to copy the uploaded file
	892	header("Location: ".$_SERVER['HTTP_REFERER']."&errcode=aksf02");
	893	exit();
	894	}
	895
	896	if($id!='')
	897	{
	898	// update file & name for an existing file
	899	$sql="UPDATE ".$this->tables['kmlfiles']."
	900	SET name='".mysql_escape_string($name)."',
	901	file='".mysql_escape_string($_FILES['file']['name'])."',
	902	fileSize=".filesize($file).",
	903	fileDate='".date('Y-m-d H:i:s', filemtime($file))."'
	904	WHERE id='$id';";
	905	$result=pwg_query($sql);
	906	}
	907	else
	908	{
	909	$sql="INSERT INTO ".$this->tables['kmlfiles']."
	910	VALUES ('', '".mysql_escape_string($_FILES['file']['name'])."',
	911	'".mysql_escape_string($name)."',
	912	'".date('Y-m-d H:i:s', filemtime($file))."',
	913	'".filesize($file)."')";
	914	$result=pwg_query($sql);
	915	$id=pwg_db_insert_id();
	916	}
	917
	918	header("Location: ".$_SERVER['HTTP_REFERER']);
	919	exit();
	920	}
	921
	922
	923
	924	return($id);
	925	} //ajax_gmaps_admin_kmlFilesSetFile
	926
	927
	928
	929	/**
	930	* get properties for a given file id
	931	*
	932	* @param String id : the file Id
	933	* @param Bool $json : if true, return a json string, otherwise an array
	934	* @return String : data formatted in a JSON string
	935	*/
	936	private function ajax_gmaps_admin_kmlFilesGetFile($id, $json=true)
	937	{
	938	$returned=array(
	939	'id' => '',
	940	'file' => '',
	941	'name' => '',
	942	'fileDate'=> '',
	943	'fileSize' => 0,
	944	'fileSizeUnits' => 0,
	945	);
	946
	947	$sql="SELECT id, file, name, fileDate, fileSize
	948	FROM ".$this->tables['kmlfiles']."
	949	WHERE id='$id';";
	950	$result=pwg_query($sql);
	951	if($result)
	952	{
	953	while($row=pwg_db_fetch_assoc($result))
	954	{
[7308]	955	$row['fileSizeUnits']=GPCCore::formatOctet($row['fileSize']);
[7132]	956	$returned=$row;
	957	}
	958	}
	959
	960	if($json)
	961	{
	962	return(json_encode($returned));
	963	}
	964	else
	965	{
	966	return($returned);
	967	}
	968	} //ajax_gmaps_admin_kmlFilesGetFile
	969
	970
	971
	972
	973	/**
	974	* delete a file
	975	*
	976	* @param String id : if of the file to delete
	977	* @return String : ok or ko
	978	*/
	979	private function ajax_gmaps_admin_kmlFilesDeleteFile($id)
	980	{
	981	$file='';
	982
	983	/*
	984	* before deleting record in the table, get the associated file name stored
	985	* on the server
	986	*/
	987	$sql="SELECT file
	988	FROM ".$this->tables['kmlfiles']."
	989	WHERE id='$id';";
	990	$result=pwg_query($sql);
	991	if($result)
	992	{
	993	while($row=pwg_db_fetch_assoc($result))
	994	{
	995	$file=$row['file'];
	996	}
	997	}
	998
	999	// reset kmlFileId for assocation
	1000	$sql="UPDATE ".$this->tables['category_maps']."
	1001	SET kmlFileId='0'
	1002	WHERE kmlFileId='$id'";
	1003	pwg_query($sql);
	1004
	1005	// delete the file
	1006	$sql="DELETE FROM ".$this->tables['kmlfiles']."
	1007	WHERE id='$id';";
	1008	$result=pwg_query($sql);
	1009	if($result)
	1010	{
[10915]	1011	if($file!='' and file_exists(GPCCore::getPiwigoSystemPath().'/'.PWG_LOCAL_DIR.self::KML_DIRECTORY.$file))
[7132]	1012	{
[10915]	1013	unlink(GPCCore::getPiwigoSystemPath().'/'.PWG_LOCAL_DIR.self::KML_DIRECTORY.$file);
[7132]	1014	}
	1015	return('ok');
	1016	}
	1017	return('ko!unknown error');
	1018	} //ajax_gmaps_admin_kmlFilesDeleteFile
	1019
	1020
	1021
	1022
	1023	/**
[7125]	1024	* prepare the cache for the user / category
	1025	*
	1026	*
	1027	* @param Integer $category : the category Id, 0 if want to init map for all
	1028	* the gallery
	1029	* @return String : the requestId
	1030	*/
[7500]	1031	private function ajax_gmaps_public_mapsInit($category, $mapId)
[7125]	1032	{
[7616]	1033	global $prefixeTable, $user;
[7125]	1034
[7177]	1035	$requestId='';
[7125]	1036
[7500]	1037	if($mapId==null)
	1038	{
	1039	$this->buildMapList($category, 'C', self::ID_MODE_CATEGORY);
	1040	}
[7125]	1041	if($category>0)
	1042	{
	1043	$sqlCatRestrict="AND FIND_IN_SET($category, pct.uppercats)!=0";
	1044	}
	1045	else
	1046	{
	1047	$sqlCatRestrict="";
	1048	}
	1049
[7500]	1050	if(count($this->maps)>0 or $mapId!=null)
[7125]	1051	{
	1052	$scripts=array();
	1053	$bounds=array(
	1054	'N' => -90,
	1055	'S' => 90,
	1056	'E' => -180,
	1057	'W' => 180
	1058	);
	1059
	1060	// there is some maps to display
[7616]	1061	$requestId=$this->getCacheRequestId();
[7125]	1062
[7616]	1063	$this->cleanCache();
[7125]	1064
	1065	// prepare the cache (same request in the 'GMaps_pip->displayCategoryPageMap' function)
[7616]	1066	$sql="SELECT DISTINCT pic.image_id, GROUP_CONCAT(DISTINCT pait.value ORDER BY pait.numID ASC SEPARATOR ';') AS coords
	1067	FROM (((".USER_CACHE_CATEGORIES_TABLE." pucc
[7125]	1068	LEFT JOIN ".CATEGORIES_TABLE." pct ON pucc.cat_id = pct.id)
	1069	LEFT JOIN ".IMAGE_CATEGORY_TABLE." pic ON pic.category_id = pucc.cat_id)
	1070	LEFT JOIN ".$prefixeTable."amd_images_tags pait ON pait.imageId = pic.image_id)
[7616]	1071	LEFT JOIN ".$prefixeTable."amd_used_tags paut ON pait.numId = paut.numId
[7125]	1072	WHERE pucc.user_id = '".$user['id']."'
	1073	AND (paut.tagId = 'magic.GPS.LatitudeNum' OR paut.tagId = 'magic.GPS.LongitudeNum')
	1074	AND pic.image_id IS NOT NULL
	1075	$sqlCatRestrict
	1076	GROUP BY pic.image_id";
	1077	/*
	1078	* get_sql_condition_FandF(
	1079	array
	1080	(
	1081	'forbidden_categories' => 'pic.category_id',
	1082	'visible_categories' => 'pic.category_id',
	1083	'visible_images' => 'pic.image_id'
	1084	),
	1085	'AND'
	1086	);
	1087	*/
[7453]	1088
[7125]	1089	$result=pwg_query($sql);
	1090	if($result)
	1091	{
	1092	$massInsert=array();
	1093
	1094	while($row=pwg_db_fetch_assoc($result))
	1095	{
	1096	$coords=explode(';', $row['coords']);
	1097	$this->updateBounds($bounds, array(
	1098	'lat' => $coords[0],
	1099	'lng' => $coords[1]
	1100	)
	1101	);
	1102
	1103	$massInsert[]=array(
	1104	'requestId' => $requestId,
	1105	'imageId' => $row['image_id'],
	1106	'latitude' => $coords[0],
[7616]	1107	'longitude' => $coords[1]
[7125]	1108	);
	1109	}
	1110
[7616]	1111	mass_inserts($this->tables['cache'], array('requestId', 'imageId', 'latitude', 'longitude'), $massInsert);
[7125]	1112
	1113	$returned=$requestId;
	1114	}
	1115	}
	1116
	1117	return($requestId);
[7054]	1118	}
	1119
	1120
[7125]	1121	/**
	1122	* returns a list of markers
	1123	*
	1124	*
	1125	* @param Array $datas : 'requestId' id of the request
	1126	* 'bounds' (north, east, west, south) : only markers
	1127	* inside the given bounds are returned
	1128	* 'width' : width of maps in pixels
	1129	* 'height' : height of maps in pixels
	1130	* @return Array\|String : a JSON string of an array of points (nbPictures, lat, lng)
	1131	*/
	1132	private function ajax_gmaps_public_mapsGetMarkers($datas)
	1133	{
[7616]	1134	global $user, $page, $conf;
[7054]	1135
[7128]	1136	$returned=array(
[7500]	1137	'loadIndex' => $datas['loadIndex'],
[7308]	1138	'callId' => $datas['callId'],
[7128]	1139	'markers' => array(),
	1140	'datas' => array(
	1141	'nbPhotos' => 0
	1142	)
	1143	);
[7125]	1144
[7616]	1145	$this->updateCacheRequestId($datas['requestId']);
	1146	$this->cleanCache();
	1147
[7125]	1148	/*
	1149	* the 'make_picture_url' function use the 'get_root_url' function which
	1150	* use the $page['root_path'] value
	1151	*
	1152	* here, this $page index doesn't exist, so we need to initialize it
	1153	*/
	1154	$page['root_path']='';
	1155
	1156	if($datas['bounds']['east']<$datas['bounds']['west'])
	1157	{
	1158	/* E = -xxx W = +xxx
	1159	* a(lng E:+x)
	1160	* b(lng W:-x)
	1161	*
	1162	* E +180/-180 W
	1163	* (+) (-)
	1164	* +-------------+---------+
	1165	* \| : \|
	1166	* \| : b \|
	1167	* \| a : \|
	1168	* \| : \|
	1169	* +-------------+---------+
	1170	*
	1171	*/
	1172	$lngClause="
	1173	longitude <= ".$datas['bounds']['east']."
	1174	OR longitude >= ".$datas['bounds']['west']." ";
	1175	}
	1176	else
	1177	{
	1178	/* E = -xxx W = +xxx
	1179	* a(lng W:-x)
	1180	* b(lng E:+x)
	1181	*
	1182	* W 0 E
	1183	* (-) (+)
	1184	* +-------------+---------+
	1185	* \| : \|
	1186	* \| : b \|
	1187	* \| a : \|
	1188	* \| : \|
	1189	* +-------------+---------+
	1190	*
	1191	*/
	1192	$lngClause="
	1193	longitude >= ".$datas['bounds']['west']."
	1194	AND longitude <= ".$datas['bounds']['east']." ";
	1195	}
	1196
[7616]	1197	$sql="SELECT DISTINCT pgc.latitude, pgc.longitude, pgc.imageId,
	1198	GROUP_CONCAT(DISTINCT pic.category_id ORDER BY pic.category_id SEPARATOR ';') AS imageCatsId,
	1199	GROUP_CONCAT(DISTINCT pct.name ORDER BY pct.id SEPARATOR ';') AS imageCatsNames,
	1200	GROUP_CONCAT(DISTINCT IF(pct.permalink IS NULL, CONCAT('*', pct.id), pct.permalink) ORDER BY pct.id SEPARATOR ';') AS imageCatsPLink,
	1201	pit.name AS imageName,
	1202	pit.path, pit.tn_ext
	1203	FROM (((".$this->tables['cache']." pgc
	1204	LEFT JOIN ".IMAGE_CATEGORY_TABLE." pic ON pic.image_id = pgc.imageId)
	1205	LEFT JOIN ".USER_CACHE_CATEGORIES_TABLE." pucc ON pucc.cat_id = pic.category_id)
	1206	LEFT JOIN ".CATEGORIES_TABLE." pct ON pucc.cat_id = pct.id)
	1207	LEFT JOIN ".IMAGES_TABLE." pit ON pit.id = pgc.imageId
	1208	WHERE pucc.user_id = '".$user['id']."'
[7125]	1209	AND requestId='".$datas['requestId']."'
	1210	AND ($lngClause)
	1211	AND latitude >= ".$datas['bounds']['south']."
	1212	AND latitude <= ".$datas['bounds']['north']."
[7616]	1213	GROUP BY pgc.imageId
[7125]	1214	ORDER BY latitude, longitude;";
	1215	$result=pwg_query($sql);
	1216	if($result)
	1217	{
	1218	// compute ratio map size / bound size
	1219	$ratioW=($datas['bounds']['east']-$datas['bounds']['west'])/$datas['width'];
	1220	$ratioH=($datas['bounds']['north']-$datas['bounds']['south'])/$datas['height'];
	1221	// works with the highest ratio
	1222	$ratio=max($ratioW, $ratioH);
[7308]	1223	$datas['distanceTreshold']=pow($datas['distanceTreshold']*$ratio,2);
[7125]	1224
	1225	$groups=array();
	1226
	1227	/*
	1228	* build groups
	1229	*/
[7308]	1230	while($row=pwg_db_fetch_assoc($result))
[7125]	1231	{
[7616]	1232	$row['imageName'] =GPCCore::getUserLanguageDesc($row['imageName']);
	1233	$row['imageTnFile']=dirname($row['path']).'/'.$conf['dir_thumbnail'].'/'.$conf['prefix_thumbnail'].get_filename_wo_extension(basename($row['path'])).'.'.$row['tn_ext'];
[7308]	1234	if(!$this->checkInGroup($row, $groups, $datas['distanceTreshold']))
[7125]	1235	{
[7308]	1236	$groups[]=array($row);
[7125]	1237	}
	1238	}
	1239
	1240	/*
	1241	* for each group, calculate coordinates for a unique representative
	1242	* point
	1243	*/
	1244	foreach($groups as $keyGroup => $group)
	1245	{
	1246	$coords=array(
[7128]	1247	'nbImgTxt' => '',
[7308]	1248	'nbImg' => 0,
[7128]	1249	'lat' => 0, // 'lat' rather than 'latitude'
	1250	'lng' => 0, // 'lng' rather than 'longitude'
	1251	'imgTn' => array(),
	1252	'imgCatsNames' => array(),
	1253	'imgName' => array(),
	1254	'imgCatsUrl' => array(),
[7125]	1255	);
	1256
	1257	foreach($group as $point)
	1258	{
	1259	$tmpCatsUrl=array();
	1260	$tmpCatsId=explode(';', $point['imageCatsId']);
	1261	$tmpCatsNames=explode(';', $point['imageCatsNames']);
	1262	$tmpCatsPLinks=explode(';', $point['imageCatsPLink']);
	1263
	1264	foreach($tmpCatsId as $key => $id)
	1265	{
	1266	$tmpCatsUrl[]=make_picture_url(
	1267	array(
	1268	'image_id' => $point['imageId'],
	1269	'category' => array(
	1270	'id' => $id,
[7308]	1271	'name' => GPCCore::getUserLanguageDesc($tmpCatsNames[$key]),
[7125]	1272	'permalink' => (substr($tmpCatsPLinks[$key],0,1)=='*')?'':$tmpCatsPLinks[$key],
	1273	)
	1274	)
	1275	);
	1276	}
	1277
[7128]	1278	if(count($tmpCatsId)<=1) $tmpCatsNames='';
	1279
[7308]	1280	$coords['nbImg']++;
[7128]	1281
	1282	$coords['lat']+=$point['latitude'];
	1283	$coords['lng']+=$point['longitude'];
	1284
[7479]	1285	$coords['imgTn'][]=$this->replaceImgRoot($point['imageTnFile']);
[7308]	1286	$coords['imgCatsNames'][]=$tmpCatsNames;
	1287	$coords['imgName'][]=GPCCore::getUserLanguageDesc($point['imageName']);
	1288	$coords['imgCatsUrl'][]=$tmpCatsUrl;
[7125]	1289	}
[7128]	1290	$coords['lat']=$coords['lat']/count($group);
	1291	$coords['lng']=$coords['lng']/count($group);
[7308]	1292	$coords['uId']=md5($coords['lat'].$coords['lng']);
[7125]	1293
[7308]	1294	if($coords['nbImg']==1)
[7125]	1295	{
[7128]	1296	$coords['nbImgTxt']=l10n('gmaps_1_picture');
[7125]	1297	}
	1298	else
	1299	{
[7308]	1300	$coords['nbImgTxt']=sprintf(l10n('gmaps_nb_pictures'), $coords['nbImg']);
[7125]	1301	}
	1302
[7128]	1303	$returned['markers'][]=$coords;
[7308]	1304	$returned['datas']['nbPhotos']+=$coords['nbImg'];
[7125]	1305	}
	1306	}
	1307
[7128]	1308	if($returned['datas']['nbPhotos']>1)
	1309	{
	1310	$returned['datas']['nbPhotos']=sprintf(l10n('gmaps_nb_pictures'), $returned['datas']['nbPhotos']);
	1311	}
[7132]	1312	elseif($returned['datas']['nbPhotos']==1)
[7128]	1313	{
	1314	$returned['datas']['nbPhotos']=l10n('gmaps_1_picture');
	1315	}
[7132]	1316	else
	1317	{
	1318	$returned['datas']['nbPhotos']=l10n('gmaps_0_picture');
	1319	}
[7128]	1320
[7125]	1321	return(json_encode($returned));
[7308]	1322	} //ajax_gmaps_public_mapsGetMarkers
[7125]	1323
[7308]	1324	/**
	1325	* check if a point is inside an existing group, and add it
	1326	* @param Array $point : the point
	1327	* @param Array &$groups : the groups
	1328	* @param Float $maxDist : maximum distance to be inside group
	1329	* @return Bool : true if added in a group, otherwise false
	1330	*/
	1331	private function checkInGroup($point, &$groups, $maxDist)
	1332	{
	1333	foreach($groups as $key=>$group)
[7132]	1334	{
[7308]	1335	$dist=pow($point['latitude']-$group[0]['latitude'],2) + pow($point['longitude']-$group[0]['longitude'],2);
[7132]	1336
[7308]	1337	if($dist<=$maxDist)
	1338	{
	1339	$groups[$key][]=$point;
	1340	return(true);
	1341	}
[7132]	1342	}
[7308]	1343	return(false);
	1344	}
[7132]	1345
[7453]	1346	/**
	1347	* replace the root directroy for image
	1348	* => './galleries/' becomes "G"
	1349	* => './upload/' becomes "U"
	1350	* => other case : no chnages
	1351	*
	1352	* @param String $value : path
	1353	* @returned String :
	1354	*/
	1355	private function replaceImgRoot($value)
	1356	{
	1357	if(preg_match('/^\.\/galleries\//i', $value)>0)
	1358	{
	1359	return("G".substr($value,12));
	1360	}
[7479]	1361	elseif(preg_match('/^\.\/upload\//i', $value)>0)
[7453]	1362	{
[7479]	1363	return("U".substr($value,9));
[7453]	1364	}
	1365	return($value);
	1366	}
	1367
[7054]	1368	} //class
	1369
	1370
	1371	$returned=new GMaps_Ajax($prefixeTable, __FILE__);
	1372	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: