Changing the Structure for my Webservice

[g2ktcf]

I have a similar issue to another Zenner on UPS Shipping Module. The product tables and the address book tables are missing some highly needed fields to properly make the UPS Webservice work as it supposed to.

However, I am very hesitant to change the MySQL dBase without asking the following question. If I add a new field and its supporting loading functions...are there any other issues I need to consider (as am I corrupting something else that is not obvious?). I have done this before with other dbs but this is a real healthy animal you have here I do not want to make it sick.

Items needed.

• products table...Length, Width and Height of cube surrounding product
• Volume Adjustment Factor....up or down adjustment of the calculated volume for non-rectangular items (will be an advanced change based on experience)
• Products table....small enum noting whether this can be considered a "large" package by UPS and USPS
• Address Book Table...small enum noting whether this address is Residential or Commercial (shippers now have a $2.50 residential delivery fee )

[lankeeyankee]

There are no issues with doing what you want. There is a mod called auction site attributes that add the dimensional factors into the product table with the fields added on the product creation page. I have added a ton of extra fields to the product table for various functions. Please share what you are working on so others may find benefit, this is particularly interesting for me for sure and I'd love to see what you are doing.

[g2ktcf]

The the first part is to add a field for the address book which i have done. It is currently setup as an enumerated field with the name xxx and the possible values of RES, COM and OTH. This may change but i think it should work.

Right now I am going over customers.php from the admin folders to verify how it works. This is one area that will need the code modified to handle a new variable.

Based on this field, I can then do some heavy modification on the UPS shipping module...plans are to make it work via SOAP. first off, I want to use UPS's webservice to validate that an address is what the customer says it is....if not, then build in an errror handler.

If so, then we can then get the proper shipping quotes based on the address type.


Now i am not sure if this is the place to ask questions but I do see some things in the php code that I have NEVER seen before I have found a few documented in the Wiki but some still make me go . Where is the proper place in the forum to ask specific questions like that?

[g2ktcf]

oops....XXXX above was supposed to be

entry_address_type

[g2ktcf]

okay...my first hick-up....

I am modifying customers.php. I have created the linked radio buttons to the correct field and they work. I created a define for ENTRY_ADDRESS_TYPE in english.php and set it to 'Address Type:'

but...the <?php echo ENTRY_ADDRESS_TYPE ?> does not work.

I get ENTRY_ADDRESS_TYPE instead of 'Address Type:'

Do all the defines get loaded at one time maybe? If so, when is the trigger?

thanks...just working all this through my head.

[g2ktcf]

next time I need to remember that there is more than one filename called english.php. I modified the on in /zencart/includes and NOT the one in /zencart/adminXXXXX/includes. Geez.

I have a new variable in the address book that can be viewed and edited from within the backoffice "customers" page. It also updates the database properly now as well.

Next step..repeat the above for the products tables.....here goes nothing!

[g2ktcf]

Well, I have MySQL Structure modified. I have the Admin pages modified to display and save the additional variables. I am working on some code to try and get the dimensional weight portion of UPS done.

[g2ktcf]

Well, I have worked on this project and made some very good progress...HOWEVER...I AM NOW STUMPED.

1. New Fields are in the Database.
2. Admin pages have been modified for the new fields.
3. A new XML version of UPS's shipping service is fully functional in isolation....but I have not been able to integrate it successfully into Zen-Cart yet.

The UPS class I create will handle multiple packages of different sizes and weights and even handle both residential and commercial addresses based on an address type. The new class works to display the UPS shipping options on the checkout shipping page. It is even returning UPS's "negotiated rates" and can be expanded to complete this.

The problem so far lies somewhere between the shipping checkout page and the payment page. If I add a simple "echo" statement to ups.php in the function "quote()", the server hangs. I cannot even add an include statement in this code right now without it hanging. It's not a syntax issue...looks more like variable being empty an the code not error trapping it.

Still looking for the needle in the haystack.

[lankeeyankee]

EDIT: saw your other thread

[g2ktcf]

EDIT: saw your other thread

yes...all I can say is "What an idiot" in the tone and sound of Hermione Grainger in Harry Potter!