doubt on ID's, problem with module that doesn't show markers with SQL, other...
- Dima
- Offline
- Platinum Member
Less
More
4 years 9 months ago #13032
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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.
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
Less
More
- Posts: 44
- Thank you received: 0
4 years 9 months ago - 4 years 9 months ago #13033
by gix
Replied by gix on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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)
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 9 months ago by gix.
Please Log in or Create an account to join the conversation.
- gix
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 44
- Thank you received: 0
4 years 9 months ago - 4 years 9 months ago #13034
by gix
Replied by gix on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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
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
Last edit: 4 years 9 months ago by gix.
Please Log in or Create an account to join the conversation.
- Dima
- Offline
- Platinum Member
4 years 9 months ago - 4 years 9 months ago #13036
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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
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 9 months ago by Dima.
Please Log in or Create an account to join the conversation.
- Dima
- Offline
- Platinum Member
4 years 9 months ago #13038
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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.
- Dima
- Offline
- Platinum Member
4 years 9 months ago #13044
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
Replied by Dima on topic doubt on ID's, problem with module that doesn't show markers with SQL, other...
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.203 seconds