Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. protected function _renderFiltersBefore() {
  2. $joinTable = $this->getTable('sales_order');
  3. $this->getSelect()->joinLeft($joinTable,
  4. 'main_table.entity_id = sales_order.entity_id', ['coupon_code']);
  5. $joinTableItem = $this->getTable('sales_order_item');
  6. $this->getSelect()->join($joinTableItem,
  7. 'main_table.entity_id = sales_order_item.order_id',
  8. ['sku','price','qty_ordered']);
  9. parent::_renderFiltersBefore();
  10. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement