I created a custom field to measure the distance from where the user is to a customer's home. However, I need to include the user's username in the query. I'm using <?php echo CurrentUserName() ?>
and it doesn't work.
((SELECT
6371 * 2 *
ASIN(
SQRT(
POWER(SIN((RADIANS(LocalizacaoLog.Latitude) - RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', 1), '(', -1))) / 2), 2) +
COS(RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', 1), '(', -1))) * COS(RADIANS(LocalizacaoLog.Latitude)) *
POWER(SIN((RADIANS(LocalizacaoLog.Longitude) - RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', -1), ')', 1))) / 2), 2)
)
)
FROM LocalizacaoLog
WHERE LocalizacaoLog.Usuario = '<?php echo CurrentUserName() ?>'
LIMIT 1
))
When I use Administrator, it works. However, I need to know the distance from the user who is logged in.
((SELECT
6371 * 2 *
ASIN(
SQRT(
POWER(SIN((RADIANS(LocalizacaoLog.Latitude) - RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', 1), '(', -1))) / 2), 2) +
COS(RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', 1), '(', -1))) * COS(RADIANS(LocalizacaoLog.Latitude)) *
POWER(SIN((RADIANS(LocalizacaoLog.Longitude) - RADIANS(SUBSTRING_INDEX(SUBSTRING_INDEX(lideranca.geo, ',', -1), ')', 1))) / 2), 2)
)
)
FROM LocalizacaoLog
WHERE LocalizacaoLog.Usuario = 'Administrator'
LIMIT 1
))