- Posts: 12
- Thank you received: 0
Others Subscription Manager filters
- Carlos José
- Topic Author
- Offline
- New Member
-
Less
More
9 years 2 months ago #76881
by Carlos José
Others Subscription Manager filters was created by Carlos José
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?
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?
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 2 months ago #76929
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Others Subscription Manager filters
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
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
Please Log in or Create an account to join the conversation.
- Carlos José
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 12
- Thank you received: 0
9 years 2 months ago #77000
by Carlos José
Replied by Carlos José on topic Others Subscription Manager filters
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.
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.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 2 months ago #77053
by Tuan Pham Ngoc
=> Yes. Look at export method inside that file
What date filter you are talking about ?
Tuan
Replied by Tuan Pham Ngoc on topic Others Subscription Manager filters
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
Please Log in or Create an account to join the conversation.
- Carlos José
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 12
- Thank you received: 0
9 years 2 months ago #77090
by Carlos José
Replied by Carlos José on topic Others Subscription Manager filters
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!
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!
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.