source: trunk/Modules/Map/Map.php@ 864

Last change on this file since 864 was 864, checked in by chronos, 5 years ago
  • Modified: Used embedded OpenStreetMaps as google maps v2 API is deprecated and v3 needs billing information.
File size: 11.2 KB
Line 
1<?php
2
3include_once(dirname(__FILE__).'/MapAPI.php');
4
5class PageNetworkMap extends Page
6{
7 var $FullTitle = 'Mapa sítě';
8 var $ShortTitle = 'Mapa sítě';
9 var $ParentClass = 'PagePortal';
10 //var $Load = 'initialize()';
11 //var $Unload = 'GUnload()';
12
13 function Show()
14 {
15 if(!$this->System->User->CheckPermission('Map', 'Show'))
16 return('Nemáte oprávnění');
17
18 if(count($this->System->PathItems) > 1)
19 {
20 if($this->System->PathItems[1] == 'show-position') return($this->ShowPosition());
21 else return(PAGE_NOT_FOUND);
22 } else return($this->ShowMain());
23 }
24
25 function ShowPosition()
26 {
27 $DbResult = $this->Database->select('MapPosition', '*', '`Id`='.$_GET['i']);
28 if($DbResult->num_rows > 0)
29 {
30 $DbRow = $DbResult->fetch_assoc();
31 $Pos = explode(';', $DbRow['Pos']);
32 $MapApi = new MapOpenStreetMaps($this->System);
33 $MapApi->Position = array('Lat' => $Pos[0], 'Lng' => $Pos[1]);
34 $MapApi->Zoom = 18;
35 $MapApi->Key = $this->System->Config['Map']['GoogleMapsApiKey'];
36 $MapApi->ShowMarker = true;
37 $Marker = new MapMarker();
38 $Marker->Text = $DbRow['Name'];
39 $Marker->Position = $MapApi->Position;
40 $MapApi->Markers[] = $Marker;
41 $Output = $MapApi->ShowPage($this);
42 return($Output);
43 } else return('Položka nenalezena');
44 }
45
46 function ShowMain()
47 {
48 $Map = new MapOpenStreetMaps($this->System);
49 $Map->Position = array('Lat' => $this->System->Config['Map']['DefaultLatitude'],
50 'Lng' => $this->System->Config['Map']['DefaultLongitude']);
51 $Map->Zoom = $this->System->Config['Map']['DefaultZoom'];
52 $Map->Key = $this->System->Config['Map']['GoogleMapsApiKey'];
53 //$Map->OnClickObject = $_GET['r'];
54 //$MapApi->ShowMarker = true;
55
56 $DbResult = $this->Database->query('SELECT GROUP_CONCAT(`NetworkDevice`.`Name` SEPARATOR ",") AS `Name`, '.
57 '`MapPosition`.`Pos` AS `Pos`, `MapPosition`.`Name` AS `NodeName` '.
58 'FROM `NetworkDevice` LEFT JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
59 'WHERE (`NetworkDevice`.`Used`=1) AND (`NetworkDevice`.`MapPosition` IS NOT NULL) '.
60 'GROUP BY `NetworkDevice`.`MapPosition`');
61 while($Device = $DbResult->fetch_assoc())
62 {
63 $Pos = explode(';', $Device['Pos']);
64 $Marker = new MapMarker();
65 $Marker->Position = array('Lat' => $Pos[0], 'Lng' => $Pos[1]);
66 $Marker->Text = $Device['NodeName'].': '.$Device['Name'];
67 $Map->Markers[] = $Marker;
68 }
69
70 $DbResult = $this->Database->query('SELECT * FROM `NetworkLink` WHERE (`Interface1` <> 0) AND (`Interface2` <> 0)');
71 while($Link = $DbResult->fetch_assoc())
72 {
73 $DbResult2 = $this->Database->query('SELECT `NetworkDevice`.`Used`, `MapPosition`.`Pos` FROM `NetworkDevice` '.
74 'JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
75 'WHERE `NetworkDevice`.`Id` = (SELECT `NetworkInterface`.`Device` FROM `NetworkInterface` WHERE `NetworkInterface`.`Id` = '.$Link['Interface1'].')');
76 $DbResult3 = $this->Database->query('SELECT `NetworkDevice`.`Used`, `MapPosition`.`Pos` FROM `NetworkDevice` '.
77 'JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
78 'WHERE `NetworkDevice`.`Id` = (SELECT `NetworkInterface`.`Device` FROM `NetworkInterface` WHERE `NetworkInterface`.`Id` = '.$Link['Interface2'].')');
79 if(($DbResult2->num_rows > 0) and ($DbResult3->num_rows > 0))
80 {
81 $Device1 = $DbResult2->fetch_assoc();
82 $Pos1 = explode(';', $Device1['Pos']);
83 $Device2 = $DbResult3->fetch_assoc();
84 $Pos2 = explode(';', $Device2['Pos']);
85 if(($Device1['Used'] == 1) and ($Device2['Used'] == 1))
86 {
87 $PolyLine = new MapPolyLine();
88 $PolyLine->Color = '#4F4FBF';
89 $PolyLine->Points[] = array('Lat' => $Pos1[0], 'Lng' => $Pos1[1]);
90 $PolyLine->Points[] = array('Lat' => $Pos2[0], 'Lng' => $Pos2[1]);
91 $Map->PolyLines[] = $PolyLine;
92 }
93 }
94 }
95
96 $Output = $Map->ShowPage($this);
97
98
99 /*
100 $Output = '<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key='.
101 $this->System->Config['Map']['GoogleMapsApiKey'].'"></script>';
102 $Output .= '<script type="text/javascript">
103
104 var map;
105 var tinyIcon;
106
107 function initialize()
108 {
109
110 //if (google.maps.BrowserIsCompatible())
111 {
112 map = new google.maps.Map(document.getElementById("map_canvas"));
113 map.setMapTypeId(\'satellite\');
114 map.setCenter(new google.maps.LatLng(49.260422, 18.081179), 15);
115 //map.setUIToDefault();
116 //map.addControl(new google.maps.OverviewMapControl(new google.maps.Size(128, 96)));
117
118
119// Create our "tiny" marker icon
120//var tinyIcon = new google.maps.Icon();
121//tinyIcon.image = "point.gif";
122//tinyIcon.shadow = "http://labs.google.com/ridefinder/images/mm_20_shadow.png";
123//tinyIcon.iconSize = new google.maps.Size(10, 10);
124//tinyIcon.shadowSize = new google.maps.Size(10, 10);
125//tinyIcon.iconAnchor = new google.maps.Point(5, 5);
126//tinyIcon.infoWindowAnchor = new google.maps.Point(5, 1);
127
128 toggleLabel(\'NetworkLinks\');
129 toggleLabel(\'NetworkDevices\');';
130
131 $Output .= '
132 }
133 }
134
135function toggleLabel(id)
136{
137 var ele = document.getElementById(id);
138 ele.checked = !ele.checked;
139 ele.onclick( );
140}
141
142 function UpdateNetworkLinks()
143 {
144 if ((document.getElementById("NetworkLinks")).checked == true)
145 {
146 NetworkLinks = [';
147 $DbResult = $this->Database->query('SELECT * FROM `NetworkLink` WHERE (`Interface1` <> 0) AND (`Interface2` <> 0)');
148 while($Link = $DbResult->fetch_assoc())
149 {
150 $DbResult2 = $this->Database->query('SELECT `NetworkDevice`.`Used`, `MapPosition`.`Pos` FROM `NetworkDevice` '.
151 'JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
152 'WHERE `NetworkDevice`.`Id` = (SELECT `NetworkInterface`.`Device` FROM `NetworkInterface` WHERE `NetworkInterface`.`Id` = '.$Link['Interface1'].')');
153 $DbResult3 = $this->Database->query('SELECT `NetworkDevice`.`Used`, `MapPosition`.`Pos` FROM `NetworkDevice` '.
154 'JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
155 'WHERE `NetworkDevice`.`Id` = (SELECT `NetworkInterface`.`Device` FROM `NetworkInterface` WHERE `NetworkInterface`.`Id` = '.$Link['Interface2'].')');
156 if(($DbResult2->num_rows > 0) and ($DbResult3->num_rows > 0))
157 {
158 $Device1 = $DbResult2->fetch_assoc();
159 $Pos1 = explode(';', $Device1['Pos']);
160 $Device2 = $DbResult3->fetch_assoc();
161 $Pos2 = explode(';', $Device2['Pos']);
162 if(($Device1['Used'] == 1) and ($Device2['Used'] == 1))
163 $Output .= 'new google.maps.Polyline([new google.maps.LatLng('.$Pos1[0].', '.
164 $Pos1[1].'),new google.maps.LatLng('.$Pos2[0].', '.$Pos2[1].')], "#4F4FBF", 3, 0.8), ';
165 }
166 }
167 $Output .= '];
168 for (var i in NetworkLinks)
169 {
170 map.addOverlay(NetworkLinks[i]);
171 }
172
173 } else { //checkbox turned off
174 for (var i in NetworkLinks)
175 {
176 map.removeOverlay(NetworkLinks[i]);
177 NetworkLinks[i] = null;
178 }
179 }
180}
181
182function toggleLabel(id)
183{
184 var ele = document.getElementById(id);
185 ele.checked = !ele.checked;
186 ele.onclick( );
187}
188
189 function UpdateNetworkDevices()
190 {
191 if ((document.getElementById("NetworkDevices")).checked == true)
192 {
193 NetworkDevices = [';
194
195 $DbResult = $this->Database->query('SELECT GROUP_CONCAT(`NetworkDevice`.`Name` SEPARATOR ",") AS `Name`, '.
196 '`MapPosition`.`Pos` AS `Pos`, `MapPosition`.`Name` AS `NodeName` '.
197 'FROM `NetworkDevice` LEFT JOIN `MapPosition` ON `MapPosition`.`Id` = `NetworkDevice`.`MapPosition` '.
198 'WHERE (`NetworkDevice`.`Used`=1) AND (`NetworkDevice`.`MapPosition` IS NOT NULL) '.
199 'GROUP BY `NetworkDevice`.`MapPosition`');
200 while($Device = $DbResult->fetch_assoc())
201 {
202 $Pos = explode(';', $Device['Pos']);
203 $Output .= 'new google.maps.Marker(new google.maps.LatLng('.$Pos[0].', '.
204 $Pos[1].'), {title: "'.$Device['NodeName'].': '.$Device['Name'].'", icon:\'point.gif\' }), ';
205 }
206 $Output .= '];
207 for (var i in NetworkDevices)
208 {
209 map.addOverlay(NetworkDevices[i]);
210 }
211
212 } else { //checkbox turned off
213 for (var i in NetworkDevices)
214 {
215 map.removeOverlay(NetworkDevices[i]);
216 NetworkDevices[i] = null;
217 }
218 }
219}
220
221 </script>';
222 $Output .= '<table style="margin-left: auto; margin-right: auto; width: 100%; height: 80%;">
223 <tr>
224 <td style="width: 80%; height: 100%;">
225 <div id="map_canvas" style="width: 100%; height: 100%;"></div></td>
226 <td style="width: 20%">
227 <form>
228 <input type="checkbox" id="NetworkLinks" onClick="UpdateNetworkLinks();">
229 <a href="" onClick="toggleLabel(\'NetworkLinks\');return false;">Ukázat spoje</a>
230 </input><br />
231 <input type="checkbox" id="NetworkDevices" onClick="UpdateNetworkDevices();">
232 <a href="" onClick="toggleLabel(\'NetworkDevices\');return false;">Ukázat zařízení</a>
233 </input>
234 </form></td>
235 </tr>
236 </table>';
237 */
238 return($Output);
239 }
240}
241
242class TypeMapPosition extends TypeString
243{
244 function OnEdit($Item)
245 {
246 $Output = parent::OnEdit($Item);
247 if($this->FormManager->ShowRelation)
248 $Output .= '<img src="'.$this->FormManager->Root.'/images/select.png" alf="Vybrat" language="javascript" '.
249 'onclick="return popupwindow(&quot;'.$this->FormManager->Root.'/is/?a=mapselect&amp;r='.
250 $Item['Name'].'&quot;,&quot;test&quot;);" style="cursor:hand;cursor:pointer"/>';
251 return($Output);
252 }
253}
254
255class ModuleMap extends AppModule
256{
257 function __construct($System)
258 {
259 parent::__construct($System);
260 $this->Name = 'Map';
261 $this->Version = '1.0';
262 $this->Creator = 'Chronos';
263 $this->License = 'GNU/GPL';
264 $this->Description = 'Show objects on Google maps';
265 $this->Dependencies = array('Network');
266 $this->SupportedModels = array();
267 }
268
269 function DoStart()
270 {
271 $this->System->Pages['map'] = 'PageNetworkMap';
272 $this->System->FormManager->Type->RegisterType('MapPosition', 'String', array());
273 $this->System->FormManager->RegisterClass('MapPosition', array(
274 'Title' => 'Pozice na mapě',
275 'Table' => 'MapPosition',
276 'Items' => array(
277 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
278 'Pos' => array('Type' => 'MapPosition', 'Caption' => 'Poloha', 'Default' => '0;0'),
279 ),
280 'ItemActions' => array(
281 array('Caption' => 'Ukázat na mapě', 'URL' => '/map/show-position?i=#RowId'),
282 ),
283 'Actions' => array(
284 array('Caption' => 'Ukázat mapu', 'URL' => '/map/'),
285 ),
286 ));
287 $this->System->FormManager->RegisterFormType('TMapPosition', array(
288 'Type' => 'Reference',
289 'Table' => 'MapPosition',
290 'Id' => 'Id',
291 'Name' => 'Name',
292 'Filter' => '1',
293 ));
294 }
295
296 function DoInstall()
297 {
298 $this->System->Database->query("CREATE TABLE IF NOT EXISTS `MapPosition` (
299 `Id` int(11) NOT NULL AUTO_INCREMENT,
300 `Name` varchar(255) NOT NULL,
301 `Pos` varchar(255) NOT NULL,
302 PRIMARY KEY (`Id`)
303) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
304 }
305
306 function DoUninstall()
307 {
308 $this->Database->query('DROP TABLE `MapPosition`');
309 }
310}
Note: See TracBrowser for help on using the repository browser.