PO Numbers on Invoices, Searchable in Orders.
 

I've been asked to include this modification for people who want to have order-based Purchase Order Numbers, pulling that info from the encrypted field and making it searchable in the admin Orders section. This mod also includes PO Numbers on invoices.

Caveat: In this mod, the new PO Number field is not encrypted. If that's important, then you must modify further to include encryption.

This has been tested on X-Cart 4.1.7. You may wish to modify further for other versions of X-Cart.


Don't forget -- Step One is to create a new field in the database. Steps Two through Ten follow in the next post.


Step 1: Create a new database field with phpMyAdmin or another method in the xcart_orders table directly after "extra," called po_number. (Varchar(50), not null).

see next post for more... :D

Re: PO Numbers on Invoices, Searchable in Orders.
 

Step 2: Add this to the bottom of xcart_root_folder/include/func/func.db.php: --(See reply #6 for a fix.)



Step 3: The above will not work if there are spaces in the PO Number, so modify xcart_root_folder/skin1/customer/main/payment_po.tpl:
Add this script after the "required fields" script (just before the table tag):
and change this line:
to this:


Step 4: Find the array in xcart_root_folder/include/func/func_order.php that begins:
and insert "po_number" at the end of it (around line 579) by replacing this:
with the following, so that the last two lines in the array read:


Step 5: Modify xcart_root_folder/include/orders.php:

Find the array:
and replace it with this to add "po_number" so that it reads:

In the same file, find:
and change it to include "po_number" as well, to read:

Then, find this "if" clause (around line 182):
keep it there and add another search clause below it, (before "# Search by shipping method"):

The last mod on this file is to find this case (around line 420):
keep it there and add this case below it:


Step 6: In the file xcart_root_folder/admin/order.php, find this line (around line 190):
and add this line directly under it:


Step 7: Edit the file xcart_root_folder/skin1/mail/html/order_invoice.tpl:

Find this line:
and change it to:


Step 8: Edit the file xcart_root_folder/skin1/main/order_info.tpl:

After the table row:
add this new table row:


Step 9: Edit the file xcart_root_folder/skin1/main/order_list.tpl:

Find the section:
and replace it with this:

Find this line:
and add this line directly under it:


Step 10: Edit the file xcart_root_folder/skin1/main/orders.tpl:

Find the line:
and at the end of that entire array insert:
after the 'posted_data[status]' line.

Now find the table row:
and add this row after it:


That's it. :D

Re: PO Numbers on Invoices, Searchable in Orders.
 

Hello ...
This is great :) It's working fine ... apart from just one thing ..

I'm not sure if it's the function getPONum() but as well as attaching the PO Number is also grabbing the first word of the next line (In this case it's Company Name)

So when i look at the database the po_number field is showing "5361 Company"
(5361 is the actual po number i entered)

Any ideas ?

Thanks A Lot ...

Regards

Shafiq :sK

Re: PO Numbers on Invoices, Searchable in Orders.
 

Oh, yes...

We removed the Company name and Name of purchaser from our po orders, so, no wonder this didn't come up! My function finds spaces, but not line returns. So here's a possible fix:

Try this function instead in your file x-cart_root/include/func/func.db.php:

Let me know if that one works! :D

Re: PO Numbers on Invoices, Searchable in Orders.
 

Hello ... Just tried this ... But no joy :(

Any other ideas ?

Thanks & Regards

Shafiq :sK

Re: PO Numbers on Invoices, Searchable in Orders.
 

Ugh. :roll:

We've got to find how your system registers line breaks.

So, try this function at the bottom of x-cart_root/include/func/func.db.php instead:

Does that do it? I hope so! :D

Re: PO Numbers on Invoices, Searchable in Orders.
 

Excellent :D !!

That did the trick ... Thanks very much !!!

Regards

Shafiq :sK

Re: PO Numbers on Invoices, Searchable in Orders.
 

Hooray! :D

Now it's a pretty nifty mod for 4.1.x.

Cheers,

Re: PO Numbers on Invoices, Searchable in Orders.
 

I tried this on 4.2 ... yikes ... all kinds of stuff is broken now ... I think i backed up all the files but one :( So now to try to undo it all...

Re: PO Numbers on Invoices, Searchable in Orders.
 

Nevermind, I screwed up a step, it works fine!