Support

  1. mik-towers
  2. Presales Question
  3. Tuesday, January 08 2019, 10:53 PM
  4.  Subscribe via email
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
Pro
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
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.
  • Page :
  • 1


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

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.