find:
Code: Select all
SUM(o.total) AS `total`
Code: Select all
SUM((SELECT SUM(ot.value) FROM `" . DB_PREFIX . "order_total` ot WHERE ot.order_id = o.order_id AND `ot`.`code` IN ('sub_total') AND o.order_status_id > '0' GROUP BY ot.order_id)) AS `total`
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I have made the change you re saying BUT I am taking
Parse error: syntax error, unexpected 'ModelSaleOrder' (T_STRING) in /home/sitename/public_html/admin/model/sale/order.php on line 1
I have upload the file with your modification if you can check it whats going wrong
Thanks fro helping.
Attachments
Modified admin/model/sale/order.php
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Or just check the file I have attach.
Thanks
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Did you install it on any installation and it worked?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thanks BUT again I am taking the same error .
Please if you can test your change first at any installation to be sure its working and let me know if you made it .
Upload the file with the fix here after you made it .
Thanks
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thanks for trying.
Finally I am not taking the error now BUT its not working !
I am taking the same amount as before : http://prntscr.com/hocn0y
Are you sure we re modifying the correct file ? Its not the /public_html/admin/model/report/sale.php we have to modify ?
Thanks
Attachments
Sales Report - sales-report.png (43.03 KiB) Viewed 1966 times
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The file and path are indicated on the very first line of this post: viewtopic.php?f=190&p=707305&sid=b2827b ... 3f#p707220 ...
The code is outdated but the file and path aren't ...
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
My first first post was referring to a post that was old but it was the same propose.
The thing is my friend with your suggestion we dont have what I want.
Thanks
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
You re saying that with your instructions we are changing the Sales report from total to sub_total ? That you are saying ?
If YES then I am saying you that its not working.
Is this working for you ?
Thanks
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: No registered users and 107 guests