Hi Tuan,
I've been asked to add a Distributor name field to each member profile. This field contains the name of the vendor who sold the subscription to the final user. This data has to be used in two ways:
- when sending subscription expiration reminders, this field shoudl be included in email content, like [FIRST_NAME], [LAST_NAME], ...to generate an email body like "Dear [FIRST_NAME], [LAST_NAME], your [DISTRIBUTOR] subscription plan [PLAN_TITLE] is going to expire in...
- when listing subscrbers in administration backend, it should be visible and queried, to filter whose user come from a specific distributor (a combo box listing distributors is really not needed here, just a mere plain query is suitable)
I've added a custom field to any user profile, using the custom field editor, and field shows up. When exporting data fields is correctly contained into CSV, but I'm wondering how to get it visible in email and subscriber list..
I modified
Code:
/administrator/components/com_osmembership/views/subscribers/tmpl/default.php
to remove the net gross column (which we don't need) and I used
to view contents of available view query: custom fields are not listed here. I saw also that in
Code:
/administrator/components/com_osmembership/controllers/subscribers.php
there is the query to export custom fields. I'm wondering where is the query to generate the subscriber list and how to modify it, and also how to get this field and add it to email.
Thanks in advance and regards
Stefano
