Page 1 of 1
Anyone have the Source Code? I need some SQL . . .
Posted: Tue Jan 06, 2009 10:41 am
by Mike718NY
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.
Re: Anyone have the Source Code? I need some SQL . . .
Posted: Tue Jan 06, 2009 12:32 pm
by jmestep
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?
Re: Anyone have the Source Code? I need some SQL . . .
Posted: Tue Jan 06, 2009 2:10 pm
by Mike718NY
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
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.
Re: Anyone have the Source Code? I need some SQL . . .
Posted: Tue Jan 06, 2009 4:48 pm
by jmestep
It definitely will be if you're going to try to do it with SQL.
What about snagging something out of ConLib/Utility/OrderItemDetail ?
Re: Anyone have the Source Code? I need some SQL . . .
Posted: Fri Jan 09, 2009 5:16 pm
by webhead
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