I need to sort products in category by 2 parameters, for example, by availability in stock (~amount) and by price, in order to display not-in-stock products on last pages, but sort all by price simultaneously. How to do it?
1条回答 默认 最新
- dsbowmvth16379079 2014-03-07 06:57关注
It is not possible to make it via an add-on, but you can do it by modifying the app/functions/fn.catalog.php file.
Find this function: fn_get_products There is "sorting" code:
$sorting = db_sort($params, $sortings);
The sorting variable after processing looks like
ORDER BY products.price DESC
You can extend it by your code. For example:
if (!empty($sorting)) { $sorting .= ', my_field ASC'; }
You will get something like this
ORDER BY products.price DESC, my_field ASC
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 Llama如何调用shell或者Python
- ¥20 eclipse连接sap后代码跑出来空白
- ¥20 谁能帮我挨个解读这个php语言编的代码什么意思?
- ¥15 win10权限管理,限制普通用户使用删除功能
- ¥15 minnio内存占用过大,内存没被回收(Windows环境)
- ¥65 抖音咸鱼付款链接转码支付宝
- ¥15 ubuntu22.04上安装ursim-3.15.8.106339遇到的问题
- ¥15 blast算法(相关搜索:数据库)
- ¥15 请问有人会紧聚焦相关的matlab知识嘛?
- ¥15 网络通信安全解决方案