Experience latitude / longitude Coordinates

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"