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

More
4 years 2 months ago #13032 by Dima
Hi
1 - driver I think should by in lower case
2 - I'm sorry, visualization works only for lines, ie I build polyline, ie in your case if all will be correct you should get one line (you set one object for all rows).

Visualization to create placemarks from external databases is only on development stage.

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 2 months ago - 4 years 2 months ago #13033 by gix
Hi

you mean i can't get a list of latlong from database and put as markers on map?
database is internal (the same of Joomla!)
if no:
for workaround, can i put paths with only1 coordinate using "one objet for each row" so i show only 1 markers for each path?

edit:
i explain better what i have to do
i have a list of gps device that trasmit position (every x time) and send in a database (this joomla database):
coordinates
deviceID
type of device
ship associated
type of message
...
I need to show markers for:
type of device
type of alarms
a specific device

functions:
-FLEET
are device that trasmit only positions and i want to show markers of last position of all devices(FLEET type) and/or the last X position of a choosen device (could be lines for each device showing last 10 position...START END )
-ALARM
a clock should stay in interface and every X seconds search in database if there are alarm (not yet MANAGED)
(clock should be clickable to say "verify now")
if there is an alarm (not yet MANAGED):
it should show a popup (or in a list on the left...or better show markers on map with color based on type of alarm EMERGENCY/ASSISTANCE) that show alarm with buttons "MANAGE ALARM" that put that alarm in state "MANAGED" and show on map.
Alarm position on map should show:
details of alarm (device, ship associated to device, name of captain of ship, phone ecc.)
and 2 buttons (in marker popup)
"RECOVERY GROUP"
"PORT AUTHORITIES"
that should show markers from other 2 tables and show markers of every record (centering map on alarm obviously)

- Alarm myust be showed immediately (after database reading)
- I must give the possibility to show the last X alarms and/or LAST/LAST 10...20...30 alarms of a specific device (or FROM DATE...TO dATE)

is this possible with your plugin?
if no, are you able to help me (with paying support obviously)
Last edit: 4 years 2 months ago by gix.

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

  • gix
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 2 months ago - 4 years 2 months ago #13034 by gix
i add some progress
now i can show a line for all devices but i can't show a line for each device (see images)
i need a line for each device (id is "esn" field)
how can i group every line for each esn device so i can show path history of each device separately?
"each row" doesn't show anything
Attachments:
Last edit: 4 years 2 months ago by gix.

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

More
4 years 2 months ago - 4 years 2 months ago #13036 by Dima
Lets step by step.
By visualization you can show line from other table than mine.
As I understand right you have attribute, which tell what device is.
For example
tabl1 (lat, lng, device_name, date_in)
And in this case you set where by device_name - and get line for your device.
One device -> one line -> one visualization->one path

Don't forget support my developments: post review in JED , donate , help with translation ;)
Last edit: 4 years 2 months ago by Dima.

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

More
4 years 2 months ago #13038 by Dima
Automatic grouping is not exists, because how I can use this grouping (attributes, popup content, colors and so on)

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 2 months ago #13044 by Dima
I can add new features, but you need to explain how you can manage it. New fields for grouping or something else

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.

Time to create page: 0.175 seconds

Donate


Go to top