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

[mooomers]

Ah got it, you aren't allowed to do this via the SQL tool that is build into the admin, or at least that functionality is not build into it.
From the help file: UPDATE (just a single table)

So if you want these queries to run succesful, you will need to execute them directly via dbadmin if you have access to it.
Remember to add your table pre-fix to the 2 tablenames if you run it from there.

Cheers,
Jeroen

ok, hmm. does that mean no hope for me if i don't know how to do that?

[nagelkruid]

Fixing textarea so it displays correctly in Internet Explorer (confirmed display bug in versions 6, 7, & 8 of IE)

textarea {
width:auto;
/*width: 80%;*/
}
seems to work without editing anything else in my shop.
You can also choose to add this only to super_stylesheet.css and not edit the stylesheet.css so it won't affect other areas of the site

Jeroen

[nagelkruid]

ok, hmm. does that mean no hope for me if i don't know how to do that?

don't know, what do you think?

[DivaVocals]

textarea {
width:auto;
/*width: 80%;*/
}
seems to work without editing anything else in my shop.
You can also choose to add this only to super_stylesheet.css and not edit the stylesheet.css so it won't affect other areas of the site

Jeroen

Tried that and tested it, but that change alone does NOT work in IE versions 6, 7 or 8. Moving the checkboxes to a seperate row however did work.

I did some playing around and if this page was using a tableless layout then there would be NO issue whatsoever. (which is what the sources I found had to say about the real solution to this bug) I however, do not have the time to tackle that right now..

http://www.phoboslab.org/log/2007/10...-100-width-bug

From another source (http://msittig.wubi.org/test/ie-textarea.html):

The solution is to add a <fieldset> tag around the comment box in your post template. Best to do it around the outside of the paragraph tags that surround the <textarea>. You can also use CSS to remove the border and padding from the <fieldset>.

[nagelkruid]

Tried that and tested it, but that change alone does NOT work in IE versions 6, 7 or 8. Moving the checkboxes to a seperate row however did work.

I did some playing around and if this page was using a tableless layout then there would be NO issue whatsoever. (which is what the sources I found had to say about the real solution to this bug) I however, do not have the time to tackle that right now..

Funny that it works for me.
It's an amazing browser isn't it

BTW just editing the superstylesheet will not fix it for the superbatch, only for the superorders page.
Did you try and play with setting the fieldsets & div's as mentioned in the links?
Seems like a nice way to deal with the problem?

[DivaVocals]

Funny that it works for me.
It's an amazing browser isn't it

BTW just editing the superstylesheet will not fix it for the superbatch, only for the superorders page.

The issue with the texarea display is only showing itself on the super_batch_status.php and my fix is directed at that page only. The textarea element on the super_orders.php order details pages displays just fine in IE (versions 6, 7 & 8). I'm sure it's structured slightly differently than the super_batch_status.php page and that might be why.. I didn't bother to compare the two to see exactly why the two pages display differently in IE.

Did you try and play with setting the fieldsets & div's as mentioned in the links?
Seems like a nice way to deal with the problem?

Yes, I did a simple test to validate that this solution resolved the issue. However, as I've said, I believe the right way to do this would be to re-write the whole page and eliminate the tables altogether.. This is more work than I want to do at this time. My down and dirty solution works fine.. I may tackle going tableless at some point in the future..

[DivaVocals]

[FONT=Century Gothic]So I’ve been inspired by my good friend ckosloff (who recently did something similar with IH2) to submit a new version of Super Orders which includes a all of the fixes that have been posted in various threads throughout this support thread. To be clear, the intent of this exercise is not to re-write Super Orders (‘cause I certainly ain’t qualified for that!). My intent is to bundle up all the various “fixes” for Super Orders that have been posted here and apply them to the Super Orders install files. This way folks won’t have to hunt through this support thread looking for 2-3 years worth of fixes and patches and painfully applying and testing them.[/FONT]

[FONT=Century Gothic]I am thinking that if I decide to tackle this little operation that the plan should also include cleaning up the readme just a little bit, along with the addition of an “Optional Edits” set of files. These files would contain files that include most of the edits outlined in the the “Optional Edits” section of the Super Orders readme as well as other a few additional optional edits that have been posted by other members here in this support thread. The changes I am planning on including in this version of Super Orders would be based on the following threads:[/FONT]

• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=456907&postcount=720 [/FONT]
  [FONT=Century Gothic]Items 1-5 are all various fixes which corrects the shipping display to show the full shipping description (carrier and shipping service) on the following files: super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php. The default Zen Cart packingslip, invoice, orders, and datasheet all display the FULL shipping description while Super Orders has always used the short shipping descriptions. (It is likely that this is because this was a requirement of the client for whom this mod was originally built)[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=474959&postcount=777[/FONT]
  [FONT=Century Gothic]See Item #1 for description information[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495850&postcount=851[/FONT]
  [FONT=Century Gothic]See Item #1 for description information[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495850&postcount=851[/FONT]
  [FONT=Century Gothic]See Item #1 for description information[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495949&postcount=853 [/FONT]
  [FONT=Century Gothic]See Item #1 for description information[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=573887&postcount=1079 [/FONT]
  [FONT=Century Gothic]For products with text attributes that include multiple lines and line breaks entered by the customer, the default Zen Cart Orders invoice prints out the text entered by the customer fine, and retains the multiple lines and line breaks entered by the customer. However, the Super Orders invoice, packing list, etc does not. This fix addresses that issue. Applied this fix to super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php)[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=621110&postcount=1126[/FONT]
  [FONT=Century Gothic]Corrects an issue where Super Orders fails to update the "last modified date" when updating the order status using the batch status update function[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=636329&postcount=1146 [/FONT]
  [FONT=Century Gothic]Includes an optional edit for the default state of the "Notify Customer" checkbox (this should be included as an "Optional Edit")[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=639013&postcount=1147[/FONT]
  [FONT=Century Gothic]Addresses another error in Append Comments & Notify Customer as well as a clarification on how these features are SUPPOSED to work.[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=734090&postcount=1316 [/FONT]
  [FONT=Century Gothic]Fixes the issue with packing list images displaying distorted[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=793720&postcount=1436[/FONT]
  [FONT=Century Gothic]Options for how the number of images are displayed on packing list (this should be included as an "Optional Edit")[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=803476&postcount=1474 [/FONT]
  [FONT=Century Gothic]Fixes issue with Batch Status Updating & Batch Printing which throws errors when you search for orders using the following options: = equals) or < less than. As there is an issue with the = equals) option not working on decimal values (ie: $2.50), the = equals) option will be disabled from the dropdown and only the issue with the <less than option will be corrected.[/FONT]
• [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=804899&postcount=1487[/FONT]
  [FONT=Century Gothic]Fixes the textarea element on super_batch_status.php so it displays correctly in Internet Explorer. This is a bug with the way Internet Explorer displays textarea elements. Blindside the original author of this mod posted a hint regarding this issue here: ([/FONT][FONT=Verdana]http://www.zen-cart.com/forum/showpost.php?p=292293&postcount=289[/FONT][FONT=Century Gothic])[/FONT]

[FONT=Century Gothic]I’d love to hear any feedback from the community on this..[/FONT]

[nagelkruid]

[FONT=Century Gothic]My intent is to bundle up all the various “fixes” for Super Orders that have been posted here and apply them to the Super Orders install files. This way folks won’t have to hunt through this support thread looking for 2-3 years worth of fixes and patches and painfully applying and testing them.[/FONT]

Excellent initiative, i didn't like reading the entire thread for my fixes, so if you can arrange it for others to skip that, that's great.
Before you upload it, let me rewrite the sql that comes with the install, unless you allready have it.
It should really be modified so the configuration id isn't hard coded to 28 (or is that allready fixed?)

I'll have an exam tomorrow, after that i may have some time to do the javascript for the print error, think those fixes should be nice to include as well.

Jeroen

[DivaVocals]

Excellent initiative, i didn't like reading the entire thread for my fixes, so if you can arrange it for others to skip that, that's great.
Before you upload it, let me rewrite the sql that comes with the install, unless you allready have it.
It should really be modified so the configuration id isn't hard coded to 28 (or is that allready fixed?)

I'll have an exam tomorrow, after that i may have some time to do the javascript for the print error, think those fixes should be nice to include as well.

Jeroen

You sooo rock!!! Nothing I'm undertaking does anything to the SQL that comes with the install, so I'm HAPPY to accept any and all help in this venture!! and the include of your javascript fix would be an AWESOME addition!!!

[nagelkruid]

Nothing I'm undertaking does anything to the SQL that comes with the install

Here is an uninstall script for previous versions and versions up to 47.

The SQL install included inserts at a free configuration_group_id, and not the static 28. As an effect, the configuration_group_id may vary over installs so you need the new uninstall to properly delete it if you want to go back.

Cheers,
Jeroen