[Skip to main content](#vessel-content)
# Profile for iptronica
##
[](/forum/user/82820-iptronica "View iptronica's Profile")
**[ Offline](/forum/user/82820-iptronica)**
- **User Type:** User
- **Register Date:** 08 Oct 2024
- **Last login:** 8 months 1 week ago
- **Time Zone:** UTC +0:00
- **Local Time:** 01:38
- **Posts:** 1
- **Profile views:** 35
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# iptronica's recent posts (1 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/54-auction-how-to/908907-show-auctions-in-a-module-custom-filtered#364611) | [Show auctions in a module custom filtered](/forum/54-auction-how-to/908907-show-auctions-in-a-module-custom-filtered#364611 "-- HikaShop version -- : 5.1.1 -- HikaAuction version -- : 4.0.0 -- Joomla version -- : 5.2.1 -- PHP version -- : 8.2 Hi, I need to show in front page of my site, in a module, all current auctions, ordered by end date, bur only the auctions that have some bids... Normal hikashop product content model don't have enougth configuration fields to do it. How can I do it... (I have php programing skills) Thanks") Category: [Auction: How to?](/forum/54-auction-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question about HikaAuction here.") Topic started 1 year 11 months ago, by [iptronica](/forum/user/82820-iptronica "View iptronica's Profile") [Last Post](/forum/54-auction-how-to/908907-show-auctions-in-a-module-custom-filtered#364613 "Hi, You'll want to: - create a HikaShop content module via the Joomla modules manager. You'll be able to have it display the products and sort them based on the "product_sale_end" (in the "ordering column" setting). - develop a plugin of the group "hikashop" and implement the onBeforeProductListingLoad event: www.hikashop.com/support/documentation/6...reProductListingLoad In it, you first want to check $order so that you skip if $order doesn't contain product_sale_end (that way you only add the custom condition on your module products listing, and not on other product listings). Then, you can run a MySQL query to get all the distinct auction_product_id from the hikaauction_auction table, and then you can add a filter to the $filters parameter like so: I would recommend to sort by descending auction_created and limit the ids to a couple thousands maximum. Otherwise, you might en up with too much product_ids (supposing that you have a store with tens of thousands of auction products) in the condition you're adding to the product loading MySQL query.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:944 | [Last Post](/forum/54-auction-how-to/908907-show-auctions-in-a-module-custom-filtered#364613 "Hi, You'll want to: - create a HikaShop content module via the Joomla modules manager. You'll be able to have it display the products and sort them based on the "product_sale_end" (in the "ordering column" setting). - develop a plugin of the group "hikashop" and implement the onBeforeProductListingLoad event: www.hikashop.com/support/documentation/6...reProductListingLoad In it, you first want to check $order so that you skip if $order doesn't contain product_sale_end (that way you only add the custom condition on your module products listing, and not on other product listings). Then, you can run a MySQL query to get all the distinct auction_product_id from the hikaauction_auction table, and then you can add a filter to the $filters parameter like so: I would recommend to sort by descending auction_created and limit the ids to a couple thousands maximum. Otherwise, you might en up with too much product_ids (supposing that you have a store with tens of thousands of auction products) in the condition you're adding to the product loading MySQL query.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.127 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)