OLD Super Orders 2.0 (See v3.0 thread instead)

[mooomers]

Thanks Philip!!!


i was wondering about that, but wasn't sure if i would interrupt how the module works.

[philip_clarke]

It's only a guess but at least the code would be available to the module if it needs it, if the payment module is installed, at least then the code is "in place" and so it should throw less errors in theory. The main problem with super orders is that it dates from 2005 in some cases and with later versions of ZC it does through some errors, the box that says "search is a payment is <=" doesn't work because security measures in recent versions of zencart have disabled it.

I keep on hoping for a volunteer to step up and upgrade this module but as you know, I maintain some already, so can only point out the more obvious errors.

Philip.

[mooomers]

well it's amazing all the time you and others put in to help all of us out!


do you happen to know if there is a way where i don't have to go back and enter in all 700 some of the payment information?

they all say balance due $xxx even though payment has already been made through credit card or paypal through the system.

[philip_clarke]

There would probably be a SQL update and I will look out for something over the next few days, best just to start using it and ignore everything below the line where payment isn't due.

Philip.

[mooomers]

ok! i will use it as is and sit tight to see what comes up.

thanks!

[carlvt88]

You could try something like this - but backup first and verify afterwards! I recommend the backup module in the add-ons section - makes it really easy to backup - messup - restore - try again

insert into zen_so_payments(orders_id, payment_amount) 
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

[philip_clarke]

You could try something like this - but backup first and verify afterwards! I recommend the backup module in the add-ons section - makes it really easy to backup - messup - restore - try again

insert into zen_so_payments(orders_id, payment_amount) 
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

That was a good starting point for the code but it throws a couple of errors

INSERT INTO so_payments ( orders_id, payment_amount ) select orders_id, value from orders_total zot where zot.sort_order=999

(I STILL MULLING THIS OVER THOUGH)

works in Install SQL patches because the previous code assumes that the tables are in default locations (whereas the patch program can alterthe table names to take into account different prefixes), the above code certainly populates the so_payments table but I am just trying to delve into super orders to check the exact criterea for the search that displays outstanding balances.

Philip.

[philip_clarke]

That was a good starting point for the code but it throws a couple of errors

INSERT INTO so_payments ( orders_id, payment_amount ) select orders_id, value from orders_total zot where zot.sort_order=999

(I STILL MULLING THIS OVER THOUGH)

works in Install SQL patches because the previous code assumes that the tables are in default locations (whereas the patch program can alterthe table names to take into account different prefixes), the above code certainly populates the so_payments table but I am just trying to delve into super orders to check the exact criterea for the search that displays outstanding balances.

Philip.

I think carlvt88 is certainly along the correct lines, although I am not sure why the sort order is 999, but looking through some test data it does appear correct. I'd say that as a minimum the code should be

insert into so_payments (orders_id, payment_amount) 
select orders_id, value from zen_orders_total zot where zot.sort_order=999;

Which puts a space inbetween so_payments and the first bracket but leaves zen_orders_total as the default name, because I don't think the Install SQL patches box can add the correct table prefix to the second table in a sub-select query. Oh and one would need MySQL 4+ as the database backend in case anyone has joined this conversation late.

For the newbie the above code adds all the payments from the table orders_total (default name is zen_orders_total), to the super orders payments table so_payments which may on your system have zen_ stuck in front of the table name. If there are any DB_prefix errors that turn up using the above code, try adding or removing zen_ in front of the table name. if you get this error

ERROR: Cannot execute because table zen_so_payments(orders_id, does not exist.

it's because there is not a space in between the word payments and the first bracket in carlvt88's otherwise excellent code.

Philip.

[weber]

how do i add a link to the product info page?

[torvista]

Hi,
so Super Orders is now unsupported/a community project!

I only installed it last week and so the doubt enters as to whether this will become a blind alley, which would be a shame.

It seems a monster piece of code and I certainly am not a good enough coder (and never will have the time to be) to bring it up to the minute as it seems is necessary as a result of the latest admin patch and legacy code.

From the people who have delved into this code, and anyone else wth experience, do you think this is worth the investment in time and effort to continue using and fixing it/bringing it up to date? Is it just a matter of searching and changing certain function calls, I have no idea?

Or are there other, supported contributions that can accomplish the same funcionality and are better written/have no legacy code?
(No offence to Mr. Blindside, this module is a stunning achievement.)

There is also the rumour of some of this functionality being available in Zen Cart 2.0, although I think this IS a rumour, I dont see any evidence of this in the details released so far: http://www.zen-cart.com/forum/showthread.php?t=116018

If it IS the best tool in the box and will continue to be so with ZC 2.0 (with compatibilty changes obviously) surely there would be interest in someone competent (hello Mr. Clarke) cleaning it up on one-off now for some renumeration/contributions which I think is perfectly reasonable. I imagine there are a lot of people using it and more who would if it was fixed.

What do people think? Are lots of people interested in keeping this alive or have they moved on already?

regards
Steve