The Vendor Notification email template generates a list of items (see attached).
I need the SQL (if that is used) that generates that.
If someone has the source code and can find thoses SQL statements
and post them here, I would really appreciate it.
Anyone have the Source Code? I need some SQL . . .
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Anyone have the Source Code? I need some SQL . . .
That's a pretty complex piece of code there are around 18 classes in the source code for order items- is there a certain part of the order item that you need?
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Anyone have the Source Code? I need some SQL . . .
I was hoping to use that as a starting point to do this: viewtopic.php?f=42&t=9422
But I'm guessing that code is not just one big SQL statement but a bunch
of classes being used together to produce it.
I'm playing around with the SQL, but the product options are the tricky part:
SELECT [Name],[OptionList],[VariantName] ,[Sku] ,[Quantity]
FROM ac_Orders
INNER JOIN ac_OrderItems ON ac_Orders.OrderId = ac_OrderItems.OrderId
WHERE ac_Orders.OrderID = 18
I think this is going to be harder than I think.
But I'm guessing that code is not just one big SQL statement but a bunch
of classes being used together to produce it.
I'm playing around with the SQL, but the product options are the tricky part:
SELECT [Name],[OptionList],[VariantName] ,[Sku] ,[Quantity]
FROM ac_Orders
INNER JOIN ac_OrderItems ON ac_Orders.OrderId = ac_OrderItems.OrderId
WHERE ac_Orders.OrderID = 18
Code: Select all
Name OptionList VariantName Sku Quantity
-------------------------- ------------------ ------------- ----------- --------
AbleCommerce T-shirt 74,76,0,0,0,0,0,0 Male, Small Able-grey 1
Choose your own Gift Card 9,0,0,0,0,0,0,0 VIP Card 888 1
New Chapter Super Critical NULL NULL 10184 3
Garden of Life Clear Energ NULL NULL 9226 1
Free Shipping - Orders NULL NULL NULL 1
I think this is going to be harder than I think.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Anyone have the Source Code? I need some SQL . . .
It definitely will be if you're going to try to do it with SQL.
What about snagging something out of ConLib/Utility/OrderItemDetail ?
What about snagging something out of ConLib/Utility/OrderItemDetail ?
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Anyone have the Source Code? I need some SQL . . .
Mike,
privately pm me on this and i will explain it, there are some here trying to help who have no idea what they are doing.
Steve
privately pm me on this and i will explain it, there are some here trying to help who have no idea what they are doing.
Steve