Magento: Sort by discount percentage with dropdown menu

I am new to Magento and am facing a problem. In my categories, I need to add a sort by opti开发者_如何学Con in the dropdown menu. So far it is easy, except that it is a discount percentage which is not stored in the DB but the calculation of price and discount_price.

I found how to query with the calculation, I just don't know how to set the things together.

How to add a entry in the Dropdown menu? How to link that entry with a specific module (if needed)? What to override?

I am a bit confused and would really appreciate your inputs.

Edit

I have found a solution.

• Created a module that overrides Mage_Catalog_Block_Product_List_Toolbar
• Overrided setCollection method
• Added fields to select via Zend ($collection->getSelect()->columns())
• Created a new attribute in the backend whose keyword is the alias of our created field

That's pretty much it.

I have found a solution.

• Created a module that overrides Mage_Catalog_Block_Product_List_Toolbar
• Overrided setCollection method
• Added fields to select via Zend ($collection->getSelect()->columns())
• Created a new attribute in the backend which keyword is the alias of our created field

That's pretty much it.