1. Zh OpenStreetMap
  3. Module
  5. doubt on ID's, problem with module that doesn't show markers with SQL, other...

doubt on ID's, problem with module that doesn't show markers with SQL, other...

  • gix
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago - 4 years 1 month ago #13180 by gix
Replied by gix on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
don't understand where i have to define icon

i show you my configruation and doubt in parenthesis ()

in module
my module is a zh module called FleetPositionLast
nothing configured

in menu (that call module) i set value 1 in :
marker list
marker for center (is referred to the marker on the list taken from SQL or a marker added and configured in marker menu?)
action to center (1? name? where are defined?)

in STRUCTURE i empty fields:
type of icon (what i have to put here? a name? a link?)
html (i created field testohtml and put inside tags<html>test1234455</html> and error on line 4848 disappear)
populate description title and lat lng with fields from SQL (their are ok)

now map give errors (i think is one for each record that are 4)

Notice: Undefined index: in /var/www/vhosts/mysite/httpdocs/components/com_zhosmmap/views/zhosmmap/tmpl/display_map_data.php on line 4848
Notice: Undefined index: in /var/www/vhosts/mysite/httpdocs/components/com_zhosmmap/views/zhosmmap/tmpl/display_map_data.php on line 4848
Notice: Undefined index: in /var/www/vhosts/mysite/httpdocs/components/com_zhosmmap/views/zhosmmap/tmpl/display_map_data.php on line 4848
Notice: Undefined index: in /var/www/vhosts/mysite/httpdocs/components/com_zhosmmap/views/zhosmmap/tmpl/display_map_data.php on line 4848

edit:
in SQL i create a field testohtml populating with <html>test1234</html> and error on line 4848 disappear
if i put nothing in field, the error is thrown
Last edit: 4 years 1 month ago by gix.

Please Log in or Create an account to join the conversation.

More
4 years 1 month ago #13181 by Dima
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
I removed from structure value for icon type, because you override it by group and it doesn't matter.
In your structure described testohtml as adddition HTML feld for popup.
If you don't need it, just remove from structure. If you need it, you have to define it in SQL, therefore you got error about index.

The main thing it is error, which cause showing loading image.
Can you check your select in visualization SQL. I can see that 4 placemarks is created correctly, but after that something going wrong. Ie check placemark 5
Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

More
4 years 1 month ago #13182 by Dima
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
I found.
In menu definition you set
- placemark ID fro center:1
- plaemarks action: 1
Action is wrong.
Action - execute action when loaded map, you can enter comma separated values
* do not change - do not execute anything
* click - execute click action on center placemark.
* bounce - set animation for center placemark (bounce).
* elastic bounce - set animation for center placemark (elastic bounce).
* exclusive bounce - set animation for center placemark (bounce only one placemark).
* exclusive elastic bounce - set animation for center placemark (elastic bounce only one placemark)
* the other value means change icon to <value>.png

I'll check my docs and fix it
Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

More
4 years 1 month ago #13183 by Dima
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
And as result there was try to change icon for placemark 1 to 1.png, which is not exists. Or something else, I need to check code for actions
Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

  • gix
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago - 4 years 1 month ago #13184 by gix
Replied by gix on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
i modify only a bit sql (take the last time position of device/esn)
my sql is this (i added control for lat and long empty but result is the same as before)
SELECT esn, latitudine, longitudine, 'FLEET' as descrizione, "1" AS icontype, arrivo, "<html> - device for fleet</html>" AS testohtml FROM log JOIN ( SELECT log.esn, MAX(log.arrivo) as arrivo FROM log WHERE log.tipomsg="FLEET" and latitudine<>"" and longitudine <>"" GROUP BY log.esn) fleetlastmax USING (esn, arrivo)

result in phpmyadmin is this (html field is showed correctly in popup)
esn latitudine longitudine descrizione icontype arrivo testohtml
0-432190 45.893003940582 8.5200047492981 FLEET 1 2019-09-12 12:16:15 <html> - device for fleet</html>
0-432025 38.393139839172 -9.0193462371826 FLEET 1 2019-09-17 14:19:27 <html> - device for fleet</html>
0-427027 44.004224538803 9.6593856811523 FLEET 1 2019-12-10 14:10:21 <html> - device for fleet</html>
0-427726 44.09471154213 9.8661303520203 FLEET 1 2020-01-09 06:10:30 <html> - device for fleet</html>

i leave the rest of option unchanged until you finish
Last edit: 4 years 1 month ago by gix.

Please Log in or Create an account to join the conversation.

More
4 years 1 month ago - 4 years 1 month ago #13185 by Dima
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
But now I need to check why placemark list click is not correct do its action. Probably it is a bug.

And incorrect removing placemarks from list when you disable by group.
Don't forget support my developments: post review in JED , donate , help with translation ;)
Last edit: 4 years 1 month ago by Dima.

Please Log in or Create an account to join the conversation.

  1. Zh OpenStreetMap
  3. Module
  5. doubt on ID's, problem with module that doesn't show markers with SQL, other...
Time to create page: 0.151 seconds

Main Menu

Help

Donate

Login Form


Go to top