Others Subscription Manager filters

Hello,
It's possible to to create others Subscription table filters?
i wanna payment_method, and one specific "osmembership_field_value" filters.
i found the code in administrator/components/com_osmembership/view/subscriptions/html.php and try do make payment_method exactly the same as existing published filter like:

$options = array();
$options[] = JHtml::_('select.option', -1, JText::_('OSM_ALL'));
$options[] = JHtml::_('select.option', 0, JText::_('OSM_PENDING'));
$options[] = JHtml::_('select.option', 1, JText::_('OSM_ACTIVE'));
$options[] = JHtml::_('select.option', 2, JText::_('OSM_EXPIRED'));
$options[] = JHtml::_('select.option', 3, JText::_('OSM_CANCELLED_PENDING'));
$options[] = JHtml::_('select.option', 4, JText::_('OSM_CANCELLED_REFUNDED'));
$this->lists = JHtml::_('select.genericlist', $options, 'published', ' class="input-box" onchange="submit();" ', 'value', 'text', $this->state->published);
$this->config = OSMembershipHelper::getConfig();

$options = array();
$options[] = JHtml::_('select.option', -1, 'Forma de pagamento');
$options[] = JHtml::_('select.option', 0, 'Offline');
$options[] = JHtml::_('select.option', 1, 'Pagseguro');
$options[] = JHtml::_('select.option', 2, 'Paypal');
$this->lists = JHtml::_('select.genericlist', $options, 'payment_method', ' class="inputbox" onchange="submit();" ', 'value', 'text', $this->state->payment_method);
$this->config = OSMembershipHelper::getConfig();

and create the row switch ($row->payment_method) in subscriptions/tmpl/default.joomla3.pgp

but something is wrong, page reload works, but the subscriptions continue the same.
Any idea?

Hi Carlos

It is just for displaying purpose. You will also need to modify code in the file administrator/components/com_osmembership/model/subscriptions.php to alter the SQL query which return the data (based on the payment method)

While payment method filter is easy, I am afraid of it is not easy to filter the value of a custom field

Tuan

Hi Tuan,
Payment method filter works, that's better to organize in backend.
But csv file continue exporting all payment methods ( if i change status filter, they modify excel too, for example). Where i change this? /controller/subscription.php ?

And i see date filter in model/subscriptions.php. But what controls this? button?

I will try the custom field and monthly filter too...

Thank you.

But csv file continue exporting all payment methods ( if i change status filter, they modify excel too, for example). Where i change this? /controller/subscription.php ?

=> Yes. Look at export method inside that file

And i see date filter in model/subscriptions.php. But what controls this? button?

What date filter you are talking about ?

Tuan

Hello Tuan
I got it, now i can filter tabs.

Custom field filter work's too, but with i determine leftJoin with one field (for more fields, table repeat users rows for each field)

What date filter you are talking about ?
I just see the dashboard "last subscribers" list. I not know it was this.

So, now I'll improve subscribers table, but i need to find a way to organize each field_value to corresponding row user.

Thank you!