Super Orders v3.0 Support Thread (for ZC v1.3.9)

Thanks for the quick response! If I click on super orders and have my list of orders displayed and try entering the PO# in the search fields to search all the orders it does not seem to pickup the PO# assigned in the orders. I can view it in order detail.

Quote:

---

Originally Posted by maxter

I have this error when I try to insert and send message for customer. Any idea to resolve o where I take look for?

1064 You have an error in your SQL syntax; ...

---

This is probably due to you having included an apostrophe/single quote in the message. There should be a routine in the SO code to escape this, but it seems there isn't.

If it is an installation issue, I'd like to know about it, so I can fix it, but I think it is a simple bug.

Quote:

---

Originally Posted by hairydog

This is probably due to you having included an apostrophe/single quote in the message. There should be a routine in the SO code to escape this, but it seems there isn't.

If it is an installation issue, I'd like to know about it, so I can fix it, but I think it is a simple bug.

---

Simple bug.. It's in the release package I have, but as I JUST posted today, the new release is partially complete (got stuck working out fixes in the batch status update files).. Workaround for now is to not use single or double quotes in comments..

Quote:

---

Originally Posted by jpietrowiak

Thanks for the quick response! If I click on super orders and have my list of orders displayed and try entering the PO# in the search fields to search all the orders it does not seem to pickup the PO# assigned in the orders. I can view it in order detail.

---

From my reply posted today..

Quote:

---

Originally Posted by DivaVocals

There already are search fields in Super Orders to locate orders (both in the order detail and the order list).. If you looking for a way to search for the PO numbers the customer paid with, Super Orders doesn't support this or searching for any otherform of payment by the payment number.

---

Thanks. Saves looking for an installation mess-up, and there is a workaround until the new version comes out: don't use apostrophes. Or should I say "do not use apostrophes" :smile:

For those interested.. Here's what was left on my to-do list for the Super Orders release I've been working on:

1. Language Support for Super Payment Types
   Needs to support payment types for all languages used in the shop. Because of the way credit card auto payments work in Super Orders, the payment type code for American Express, Visa, Matercard, Diners Club, Discover, Maestro, SOLO, and JCB must be identical for all languages.
   (See admin/includes/classes/super_order.php starting at line 275)
2. Update comments using “Batch Status Update” not working correctly.
   Comments in “Batch Status Update” should work the same way default order comments work. (support for e-mail, no e-mail, or hidden comments) . If working properly should allow shop owner to create batch hidden order comments.
   
   Currently does not create the correct comment type. Hidden comments and no e-mail comments are not e-mailed to the customer, but they are stored and displayed in the store as if they are e-mail comments.
3. PDF Packing Slip incorrectly displays the “Balance Due” Amount
4. PDF Packing Slip needs to support wrapping display long attributes names
   Word wrapping works for product names and models, but not attributes.
5. PDF Packing Slip does not print all order comments
   Seems to only print the 1st comment. Should print comments the same way comments print on the regular invoice.
6. PDF Packing Slip - Symbols are displayed incorrectly.
   Most notably currency symbols, copyright and trademark symbols, etc..

This is where I left things the last time I was able to work on this.. If anyone wants to volunteer to help wrap this up, I would appreciate a hand...

Quote:

---

Originally Posted by DivaVocals

2. Update comments using “Batch Status Update” not working correctly.
Comments in “Batch Status Update” should work the same way default order comments work. (support for e-mail, no e-mail, or hidden comments) . If working properly should allow shop owner to create batch hidden order comments.

Currently does not create the correct comment type. Hidden comments and no e-mail comments are not e-mailed to the customer, but they are stored and displayed in the store as if they are e-mail comments.

---

I have the batch status working. I can send you the mods

super_batch_status.php around line 310:

Code:

---

                <td class="smallText" colspan="2"><?php
                  echo ENTRY_NOTIFY_CUSTOMER . zen_draw_radio_field('notify', '1', true) . '-' . TEXT_EMAIL . ' ' . zen_draw_radio_field('notify', '0', FALSE) . '-' . TEXT_NOEMAIL . ' ' . zen_draw_radio_field('notify', '-1', FALSE) . '-' . TEXT_HIDE . '<br>';
                  echo zen_draw_checkbox_field('notify_comments', 'on', true); echo '&nbsp;' . ENTRY_NOTIFY_COMMENTS;
                  ?><br><br>
                  &nbsp;<input value="<?php echo BUTTON_UPDATE_STATUS; ?>" type="submit">

---

and around line 411:

Code:

---

    if ($notify == '1') {

---

I also modified admin\includes\languages\english\super_batch_status.php as:
('ENTRY_NOTIFY_COMMENTS', 'Append Comments to email?');

I've also taken a pass at #5 on the PDF packing slips, to include the capability for hidden comments. I've sent this along separately.

Carl.. you are a doll!!!!:hug:

Quote:

---

Originally Posted by carlvt88

I have the batch status working. I can send you the mods

super_batch_status.php around line 310:

Code:

---

                <td class="smallText" colspan="2"><?php
                  echo ENTRY_NOTIFY_CUSTOMER . zen_draw_radio_field('notify', '1', true) . '-' . TEXT_EMAIL . ' ' . zen_draw_radio_field('notify', '0', FALSE) . '-' . TEXT_NOEMAIL . ' ' . zen_draw_radio_field('notify', '-1', FALSE) . '-' . TEXT_HIDE . '<br>';
                  echo zen_draw_checkbox_field('notify_comments', 'on', true); echo '&nbsp;' . ENTRY_NOTIFY_COMMENTS;
                  ?><br><br>
                  &nbsp;<input value="<?php echo BUTTON_UPDATE_STATUS; ?>" type="submit">

---

and around line 411:

Code:

---

    if ($notify == '1') {

---

---

Quote:

---

Originally Posted by carlvt88

I also modified admin\includes\languages\english\super_batch_status.php as:
('ENTRY_NOTIFY_COMMENTS', 'Append Comments to email?');

I've also taken a pass at #5 on the PDF packing slips, to include the capability for hidden comments. I've sent this along separately.

---

Hidden comments shouldn't appear on th ePDF invoices at all.. These are meant to be "admin only" comments.. They do not appear on the standard invoices.. or perhaps I misunderstood what you mean..

Just my poor communication. I should have said " the ability to support hidden comments". I followed the same code as invoice.php. It prints out all non-hidden comments, whether there was a comment, or just a status update. One thing though (same as invoice.php), if the last status change was hidden, it doesn't print. This means that the current status won't show on the packing slip.