Add a column to Sales View in Backend

Hi,

Sorry but could you give back more details ?
Do you still have the same custom fields published ?
Were the modification done in an override ? And not directly in a view ?

You have maybe lost the code you implemented before.

Hello Xavier and thanks,
I upgraded to HikaShop recently businnes, previously used HikaShop essencial 2.0.0.
We perform modifications with your help. To change the view of orders. We got the results will be shown as seen in the image below:




Once the update has disappeared field code corresponding to order_product_code.
I wish to appear again.
Currently the screen is as shown below.

I followed all the steps in the previous time in view.html.php file. But the result is always the same, the column where it should go product code, is empty.

Thanks

Hello Nicolas,
I followed the steps , this way
1.And add the line:

2.verify "order listing"

3. add ",d.*"

4. Add "d.order_product_code"


The result is the " product_code " column blank








thanks

Hello Jerome,
I have made ​​the following changes.

1.- modify d.* by e.*

2.- modify d.order_product_code by e.order_product_code



3.- result, all fields blank

Hi Jerome ,

Thanks for your patience and your knowledge .
this is the error:
JDatabaseMySQL::query: 1051 - Unknown table 'f' SQL=SELECT a.*,b.*,c.*,f.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM keap_hikashop_order AS b LEFT JOIN keap_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN keap_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN keap_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

I placed the line:

$tables = ' INNER JOIN '.hikashop_table('order_product').' AS f ON b.order_id = f.order_id';

Just after:

$tables= ' '

And working properly. I do not know if it's the right solution.

Thank you so much, Jerome.

Hi,

It seems to be the correct solution.

Hi Xavier,

When you upgrade Hikashop 3, this solution has stopped working correctly.
When selecting payment methods or statements, the result is not appropriate.

In payment methods, only results appear when you mark "all payment methods".
The rest goes blank.

In the case of status, they only appear in the case of enrollment (paid), as of the day of the update.
There are also results in reinstatement and in the waiting and waiting list.

In unrealized and accredited payment, they do not show results.

Is it possible to recover that functionality?

Best regards and thanks.

Hi Nicolas,

how I can replace the column "method of payment" for "product code" and that at the top:


echo $ this-> payment-> display ("filter_payment", $ this-> PageInfo-> filter-> filter_payment, false);


To output the filter by "Product Code" instead of "payment method".

My orders only have one product for each of them.

With the new version does not work the differentiator the sliding tabs as you can see in the attached image.

Of the previous post.

thanks

Hi, Jerome

My partner has explained himself wrong. The changes that have been made in the panel are as follows:

- Added a column with the product code. As you can see in the following image.

- The top filter works properly.



The error happens when you select the payment method and the status on the sliders in the top right of the panel:



In the first case only appear: all forms of payment. The rest of the selections result in a blank page.



In the second case only appear:

- some results that are the post-upgrade in Enrollment.



- some results that are the ones after the update in Payment not realized.

- all results in reintegrated.



- all results on waiting list

- all the results in derelict

- all results in admission

- no results on requested

Thanks very much Jerome