1. mik-towers
  2. Presales Question
  3. Tuesday, January 08 2019, 10:53 PM
Hi
I'm trying to integrate with membership pro.
I need to list members from each plan in several neighborhood
Some context:
I have a list of masotherapist (users), and some of them had two or more offices (consulting room) in different neighborhoods. I need to list them in each neighborhood.
Is it possible to do with this plugin?
mik-towers Accepted Answer
And also, need to filter users by location.
Is it possible to list users by geolocation? Example, users near me, or users near a suggested location
  1. more than a month ago
  2. Presales Question
  3. # 1
admin Accepted Answer
Admin
Hi,
I need to list members from each plan in several neighborhood
For a menu item of type Easy Profile->Users List you can set a parameter called "Custom SQL Where", this parameter allow you add a static filter for each list with a SQL syntax, so you are able to add condition also for other DB tables (for example Membership Pro subscription table).
Example:
To retrieve online users you can data from Joomla session table with a syntax like:
user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0)

other examples at http://docs.easy-profile.com/index.php/article/sql-custom-where

Is it possible to list users by geolocation? Example, users near me, or users near a suggested location
This is partially possible with Easy Profile Google Map field, here an example where you will see the users near you (your position is based on your value in a specific Easy Profile Google Map field) at https://www.easy-profile.com/support/please-help-gmaps-radius-swap-radius-by-member-postal-code-entered-by-visitor-search-filter.html
Of course you can use same Custom SQL Where with a static latitude and longitude of your suggested location.
  1. more than a month ago
  2. Presales Question
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.