View of orders for a given employee

[ravspw1]

Hello,

Attempts to limit the order list view for a given employee.

I managed to make a constraint for a given order status:

in the file: 

controllers/admin/AdminOrdersController.php

if($this->context->employee->id_profile == 6)
        {
            $this->_where .= ' AND os.id_order_state = 2';
            
        
        
           
        }

This works, but I'd like to further restrict based on the city:

 $this->_where .= ' AND os.id_order_state = 2' AND (a.`city` LIKE "Janniehaven%");

but it doesn't work 😕

[lordignus]

You've got a quote in the wrong place there...

$this->_where .= ' AND os.id_order_state = 2' AND (a.`city` LIKE "Janniehaven%");

Should be:

$this->_where .= ' AND os.id_order_state = 2 AND (a.`city` LIKE "Janniehaven%")';

[ravspw1]

@lordignus Thank you very much,

I'd like to do that for products as well

but

$this->_where .= ' AND id_product = 20'; not work