batch_pick_pack

[Xpajun]

version 1.0.8.20

I have in my batch_pick_pack an extra column called

Code: Select all

<th><?= PP_PARTS ?></th>

and

Code: Select all

<td><?= $order->products[$i]['parts'] ?></td>

however I'm not getting the information to fill the column.
The data is in orders_products TABLE as a 'products_parts' column -

Code: Select all

          <th><?= PP_OID ?></th>
          <th><?= PP_QTY ?></th>
          <th><?= PP_NAME ?></th>
          <th><?= PP_MODEL ?></th>
          <th><?= PP_OPTIONS ?></th>
          <th><?= PP_PARTS ?></th>

are all in orders_products TABLE so should not ['parts'] show as well?

[ecartz]

No, see https://github.com/CE-PhoenixCart/Phoen ... hp#L32-L41 for the list of columns that appear.

Code: Select all

class hook_admin_siteWide_parts {

  public function listen_databaseOrderProductColumns($parameters) {
    $parameters['column_keys']['parts'] = 'products_parts';
  }

}

[Xpajun]

No, see https://github.com/CE-PhoenixCart/Phoen ... hp#L32-L41 for the list of columns that appear.

Code: Select all

class hook_admin_siteWide_parts {

  public function listen_databaseOrderProductColumns($parameters) {
    $parameters['column_keys']['parts'] = 'products_parts';
  }

}

Thank you once again Matt
Just checking now - if I add

Code: Select all

          'parts' => 'products_parts',

to the public function on 1.0.7.10/database_order_builder.php will that be ok? Bearing in mind that it's only for my own store

[ecartz]

Yes, that will work.

But if you use the hook instead, then you won't have to keep reapplying the change every time we update that file.

[Xpajun]

Matt @ecartz Would this be something similar in orders.php where I am trying to add products to the output putting this

Code: Select all

      [
        'name' => TABLE_HEADING_PRODUCTS,
        'function' => function (&$row) {
          return ($row['products_quantity'] . 'x' . ['products_name']);
        },
      ],

in orders/view/defult.php
gives me this:

I realise that I need to select from orders_products and then define 'qty' and 'parts'
but every tie I try to do it on that file I get an unexpected end error

[ecartz]

You don't have products in the orders rows. You'd have to alter the query considerably in order to view product information. Or run a new query (or queries) to load that information.