opencart仅针对特定类别的排序顺序

Question

I have the default sort order for all categories by price low-high (p.date_added ASC) but for a specific category example "new products" I want the sort to be p.date_added DESC.

In `catalog/controller/product/category.php I have:

<?php class ControllerProductCategory extends Controller {
public function index() {
    $this->language->load('product/category');

    $this->load->model('catalog/category');

    $this->load->model('catalog/product');

    $this->load->model('tool/image');



    if (isset($this->request->get['filter'])) {
        $filter = $this->request->get['filter'];
    } else {
        $filter = '';
    }

    if (isset($this->request->get['sort'])) {
        $sort = $this->request->get['sort'];
    } else {
        $sort = 'p.price';
    }

    if (isset($this->request->get['order'])) {
        $order = $this->request->get['order'];
    } else {
        $order = 'ASC';
    }

How can I make for the category "new products" the sort p.date_added DESC?

I have tried:

if (isset($this->request->get['sort'])) {
    $sort = $this->request->get['sort'];
} else {
    $sort = 'p.price';
}

if (isset($this->request->get['sort'])) {  
    $sort = $this->request->get['sort'];
} else (isset($category_id) && $category_id == '109') {
    $sort = 'p.date_added';
}  

But doesn't work.

Thank You.

Answer 1

If you truly want to hard code this in to the controller, which is not something I would recommend, you can simply set the default sort depending on category. One way to do it would be create an array with settings and refer to it in the logic:

$categorySorts = array(
    'default'   => array('sort' => 'p.price', 'order' => 'ASC'),
    '109'       => array('sort' => 'p.date_added', 'order' => 'DESC')
);

$default = $categorySorts['default'];   
if (isset($this->request->get['path'])) {
    $parts = explode('_', (string)$this->request->get['path']);
    $category_id = (int)array_pop($parts);
    if (isset($categorySorts[$category_id])) {
        $default = $categorySorts[$category_id];
    }
}

if (isset($this->request->get['sort'])) {
    $sort = $this->request->get['sort'];
} else {
    $sort = $default['sort'];
}

if (isset($this->request->get['order'])) {
    $order = $this->request->get['order'];
} else {
    $order = $default['order'];
}

You could then add the your array for other categories in the future if you so desire:

$categorySorts = array(
    'default'   => array('sort' => 'p.price', 'order' => 'ASC'),
    '109'       => array('sort' => 'p.date_added', 'order' => 'DESC'),
    '110'       => array('sort' => 'p.sort_order', 'order' => 'DESC'),
    '111'       => array('sort' => 'rating', 'order' => 'DESC')
);

Personally, I would not go down this path. It will make your life difficult and the lives of other developers who may be cursed with having to work on this site. Instead, I advise you to dig a little deeper and create a setting for this in the admin panel. It will be a lot more work but in the long run you will learn a lot and your website will not become a tangles mess of hardcoded rules.