Hi
We worked on a solution, good because simple and enough for us to finish working on the integration with Mapping integration of Solidres Property, Experience, Restaurant as I wrote above.
We are posting here info & files hoping you can add it by default on the next Solidres release.
Like in #_sr_reservation_assets andin #_rms_properties, I added (manually) into the #
_sr_experiences the 2 columns just after the base_location one::
lat / lng
- Type: DECIMAL
- Length/Values 10,6
- Default: none
- Null: not selected
About Length/Values decimals
- being that the number of relevant decimal places used in numbers seems does not affect performance
- the most used decimals value is 8 >
gis.stackexchange.com/a/8674
- latitude is 2 digits, while longitude is 3 >
dba.stackexchange.com/questions/107089/d...cation-data-in-mysql
- The Decimal point and (for negative numbers) the "-" sign are not counted >
mariadb.com/kb/en/decimal/
They can be:
Lat 10,8 -
Lng 11,8
I added the field code into the …/plugins/solidres/experience/administrator/components/com_solidres/models/forms/
experience.xml file, from
line 75
<field
type="text"
name="lat"
label="SR_EXP_BASE_LOCATION_LAT_LABEL"
description="SR_EXP_BASE_LOCATION_LAT_DESC"/>
<field
type="text"
name="lng"
label="SR_EXP_BASE_LOCATION_LNG_LABEL"
description="SR_EXP_BASE_LOCATION_LNG_DESC"/>
About type="text" - waiting for this report (point 3)
www.solidres.com/forum/report-bugs/11759...s-lat-lng-db-columns
- would be better "number" ?
I added the relative languages strings:
…/plugins/solidres/experience/language/en-GB/
en-GB.plg_solidres_experience.ini
; Since 1.7.8
SR_EXP_BASE_LOCATION_LAT_LABEL="Latitude"
SR_EXP_BASE_LOCATION_LAT_DESC="Enter your experience base location latitude"
SR_EXP_BASE_LOCATION_LNG_LABEL="Longitude"
SR_EXP_BASE_LOCATION_LNG_DESC="Enter your experience base location longitude"
…plugins/solidres/experience/language/es-ES/
es-ES.plg_solidres_experience.ini
; Desde 1.7.8
SR_EXP_BASE_LOCATION_LAT_LABEL="Latitud"
SR_EXP_BASE_LOCATION_LAT_DESC="Ingrese la latitud de la ubicación base de su experiencia"
SR_EXP_BASE_LOCATION_LNG_LABEL="Longitud"
SR_EXP_BASE_LOCATION_LNG_DESC="Ingrese la longitud de la ubicación base de su experiencia"
