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?

New member

Posts

Joined
Fri Dec 02, 2016 10:28 pm

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
---
Image
---
Ernie

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


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

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 :)

New member

Posts

Joined
Fri Dec 02, 2016 10:28 pm

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'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by danijr » 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.....

New member

Posts

Joined
Fri Dec 02, 2016 10:28 pm

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

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

User avatar
Newbie

Posts

Joined
Sun Feb 04, 2018 4:06 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 ..????

User avatar
Newbie

Posts

Joined
Sun Feb 04, 2018 4:06 pm

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? :)

Newbie

Posts

Joined
Fri Jun 08, 2018 4:26 pm

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

It's incredible sometimes when people wants to find a solution on an old OC version in … series.

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

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 104 guests