• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > eCommerce Factory Suite for Joomla CMS. > Auction Factory > ordering auctions on custom fields through URL
Pages: [1]
« previous next »
  Print  
Author Topic: ordering auctions on custom fields through URL  (Read 449 times)
hathwaytech
Newbie
*
Posts: 10


View Profile
ordering auctions on custom fields through URL
« on: March 09, 2010, 12:46:49 am »

Hello,
is it possible to pass parameters to the search function to order on custom fields. I thought I had it working but now it is not functioning.
Here is a URL I am trying to pass:
the custom field is called - year

/index.php?option=com_bids&task=showSearchResults&Itemid=65&filter_order_asc=1&filter_order=year&limit=20

Thank you
Logged
clothestree
Newbie
*
Posts: 11


View Profile
Re: ordering auctions on custom fields through URL
« Reply #1 on: October 09, 2011, 08:58:10 pm »

I would like to do a similar thing. Any ideas???
Logged
cokb18
Full Member
***
Posts: 195


View Profile
Re: ordering auctions on custom fields through URL
« Reply #2 on: October 11, 2011, 12:35:00 am »

Yes this should be possible. I actually did something similar to this to separate auction groups (see http://gronlineauction.com/upcoming-auctions.



First you will have to pass an input with the value you are searching for. So for you example add a drop-down with the years you want to search for to: /components/templates/default/snippets/t_search_header.tpl.



You will then have to modify /components/com_bids/models/auctions.php to add retrieval of the filter and customizing the search query to suite.



So here is my example for searching for auctions ending on a specific date:

Code:
$this->_filters->set('exactd', $app->getUserStateFromRequest($context . '.exactd', 'exactd'));



Then customize the query around line 530, here is what I used:

Code:
if ($filters->get('exactd')) {
$where[] = " a.end_date LIKE '" . $db->getEscaped($filters->get('exactd')) . "%' ";
}


You can obviously pass any information you like because it is simply an SQL query you are modifying.

Good luck!
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script