Anyone have the Source Code? I need some SQL . . .

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Anyone have the Source Code? I need some SQL . . .

Post by Mike718NY » Tue Jan 06, 2009 10:41 am

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.

User avatar
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 . . .

Post by jmestep » Tue Jan 06, 2009 12:32 pm

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

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: Anyone have the Source Code? I need some SQL . . .

Post by Mike718NY » Tue Jan 06, 2009 2:10 pm

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.

User avatar
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 . . .

Post by jmestep » Tue Jan 06, 2009 4:48 pm

It definitely will be if you're going to try to do it with SQL.
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

webhead
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Sun Aug 24, 2008 2:01 pm

Re: Anyone have the Source Code? I need some SQL . . .

Post by webhead » Fri Jan 09, 2009 5:16 pm

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

Post Reply