how to get the affiliate name in the list of orders?

Post by danijr » Fri Dec 02, 2016 10:32 pm

Hail!
How to get affiliate name on order_id in orders list , who controller I need or model?

Post by IP_CAM » Tue Dec 06, 2016 7:06 am

this Extension seems to be able to do this:
Order List Total Filter
https://www.opencart.com/index.php?rout ... n_id=25340
---

---
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by danijr » Tue Dec 06, 2016 4:28 pm

This extension is perfect, bro
But I want to learn alone to earn this result database
If they do not embarrass please help

Post by IP_CAM » Wed Dec 07, 2016 1:25 am

Well, the Affiliate Name should exist, if everything is set and works, on some product lists, according to a posting I found, at least in v.1.5.x Versions, but I never played around with affiliates, and so cannot help, sorry!
Good Luck!
Ernie
---
Some informative Page on Affiliates:
viewtopic.php?f=20&t=163857#p623321
https://abstractcodify.snipt.net/openca ... heatsheet/
http://www.fastcomet.com/tutorials/open ... iate#step1
http://www.webhostinghub.com/help/learn ... nformation
---
and here are other paid Mods, I found on this, just in case...
Admin Order List Details & Columns
https://www.opencart.com/index.php?rout ... n_id=25110
---
Improved Admin Order List (AJAX) for OC 2.0
https://www.opencart.com/index.php?rout ... n_id=20301

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by danijr » Thu Dec 08, 2016 10:03 pm

Post by askxah » Wed Apr 18, 2018 4:25 pm

Post by askxah » Wed Apr 18, 2018 4:38 pm

danijr wrote: ↑

Thu Dec 08, 2016 10:03 pm

Hi!
function getOrders
http://pastebin.com/mJPJ0Hp4

My cod: " WHERE os.affiliate_id = o.affiliate_id GROUP BY os.affiliate_id

but not working.....

Daniji , Are you got the fully query for filter and display the affiliate in sale order_list ..?

Post by R3l4X » Fri Jun 22, 2018 3:28 pm

askxah wrote: ↑

Wed Apr 18, 2018 4:25 pm

I too.. need this.. Anyone help me, I need the sql query for that

did you find a solution for your issue?

Post by straightlight » Sat Jun 23, 2018 7:44 am

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester