Shipping Status v. 1.0 for 2.2ms2

goldencrown · February 25, 2005

since there was no fourm for this contribution i though i start one.

here is the link for the contribution

Shipping Status

So i have made some changes to this contribution.

this is for dhl portion

I have made some small modfications to the project. these corrections are for dhl

1. the dhl fix was not working for me. so i made some corrections.

from this:

<?php echo '<a href="http://track.dhl-usa.com/TrackByNbr.asp=' . $order->shipping['tracking_no'] . '"

TARGET="_blank">' . tep_image_button('button_dhltrack.gif', IMAGE_ORDERS_TRACKING) . '</a>'; ?>

<?php echo '<a href="' . tep_href_link(FILENAME_ORDERS,

tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>';

?></td>

to this:

<?php echo '<a href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=' . $order->shipping['tracking_no']

. '" TARGET="_blank">' . tep_image_button('button_dhltrack.gif', IMAGE_ORDERS_TRACKING) . '</a>'; ?>

2. And then i changed the account_history_info file to make the tracking number a click able link

so from this:

<td class="main"><?php echo $order->shipping['tracking_no']; ?></td>

to this:

<td class="main"><a href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php

echo $order->shipping['tracking_no']; ?>" target="_blank"><?php echo $order->shipping['tracking_no'];

?></td>

March 13, 2005

Hello, I have a few questions:

#1 How would I change the code so Modification 2 will work with fedex.

#2 How can I add more boxes for shipping tracking number for multiple packages? And for them to correspond with the account history box.

#3 How would I modify the code so a user doesn?t get a email with blank text if I didn?t fill out the comments box or date delivery, etc.

#4 Lastly, how can i insert the date as default into the date shipped box in orders.php, and select the process of in transit by default?

Thanks

Danny

pickupman · March 17, 2005

#3 How would I modify the code so a user doesn?t get a email with blank text if I didn?t fill out the comments box or date delivery, etc.

In /catalog/admin/orders.php find where the email updates are sent by the tep_mail() function. You should see where the plain text message is started with a $email_order =

Add the code below carefully. Pay attention to ending the orginal line with a ; then the code below. Then add $email_order.= (The rest of the mail).

if ($orders_status_array[$status]=='Shipped'){
             $email_order.=EMAIL_TEXT_SHIP_DATE . $ship_date."\n";
              }

Which is IF the order status is Shipped THEN add to the email the ship date

lipix · April 8, 2005

I just installed the Shipping Status v. 1.0 for 2.2ms2 mod, but I get this error when checking my account history:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kindredp/public_html/catalog/includes/functions/database.php on line 99

That line of code (line 99 in database.php) is original to the base install of osC ms2 without any mods.

I think there maybe a conflict between this mod and the PayPal_Shopping_Cart_IPN_v3.1.5 mod sence they both modify some of the same code. I was woundering if anyone knows how to fix this. I'd really appreciate it. Thanks.

pickupman · April 8, 2005

I just installed the Shipping Status v. 1.0 for 2.2ms2 mod, but I get this error when checking my account history:
That line of code (line 99 in database.php) is original to the base install of osC ms2 without any mods.

I think there maybe a conflict between this mod and the PayPal_Shopping_Cart_IPN_v3.1.5 mod sence they both modify some of the same code. I was woundering if anyone knows how to fix this. I'd really appreciate it. Thanks.

<{POST_SNAPBACK}>

Usually the error comes from the line prior to the line it says. Like forgetting to place a ; at the end of a line in php. PHP parses the code doesn't get a ; and so the next line the is bad, which PHP reports. Double check the syntax of line above line 98.

I have PayPal IPN too, so they should work together.

lipix · April 8, 2005

Usually the error comes from the line prior to the line it says. Like forgetting to place a ; at the end of a line in php. PHP parses the code doesn't get a ; and so the next line the is bad, which PHP reports. Double check the syntax of line above line 98.
I have PayPal IPN too, so they should work together.

<{POST_SNAPBACK}>

I think maybe I need to go through the install process again for the mod to find where I may have messed up the code. Because neither mod requires changes to the database.php file and the code just before and after is still original as shown below:

  function tep_db_fetch_array($db_query) {
   return mysql_fetch_array($db_query, MYSQL_ASSOC);
 }

It is good to know that you have the 2 mods working together. Now I just need to figure out where I went wrong. Thanks for the help. If you think of anything else please let me know.

lipix · April 11, 2005

All better. I just whent back to my back up and installed it again. Not sure what I did wrong before, but as my Network Enginer Husband would say:

It looks like you have a DEU error.

(DEU = Dumb End User) :P

aresman · April 11, 2005

Hello, I have a few questions:

#1 How would I change the code so Modification 2 will work with fedex.

#2 How can I add more boxes for shipping tracking number for multiple packages? And for them to correspond with the account history box.

#3 How would I modify the code so a user doesn?t get a email with blank text if I didn?t fill out the comments box or date delivery, etc.

#4 Lastly, how can i insert the date as default into the date shipped box in orders.php, and select the process of in transit by default?

Thanks

Danny

<{POST_SNAPBACK}>

I'd like to know the answers to #2 as well -- anyone figure it out?

aresman · April 11, 2005

1) Any way to make the tracking number clickable in the Email and in the account history - to automatically track the package?

2) How do I edit the Email content?

Thanks.

ADivotMaker · April 12, 2005

Great contribution....It's all working fine, but I can't figure out how to change the sort order for the Status field. Currently the order is "Pending, Delivered, Processing, Shipped". Just a minor thing, so I'm hoping it's not too difficult. Thanks.

pickupman · April 12, 2005

1) Any way to make the tracking number clickable in the Email and in the account history - to automatically track the package?

2) How do I edit the Email content?

Thanks.

<{POST_SNAPBACK}>

Answer to question 1.

Edit /catalog/account_history_info.php below

  <td class="main"><b><?php echo HEADING_SHIP_DATE; ?></b></td>

	 <td class="main"><?php echo $order->shipping['ship_date']; ?></td>

   </tr>

Add

<?php

         }

   if (tep_not_null($order->shipping['tracking_no'])) {

?>

         <tr>

	 <td class="main"><b><?php echo HEADING_TRACKING_NO; ?></b></td>

	 <td class="main"><FORM ACTION="http://wwwapps.ups.com/etracking/tracking.cgi" METHOD="GET"  target="_blank">

   <INPUT TYPE="HIDDEN" NAME="tracknums_displayed" VALUE="5">

   <INPUT TYPE="HIDDEN" NAME="TypeOfInquiryNumber" VALUE="T">

   <INPUT TYPE="HIDDEN" NAME="HTMLVersion" VALUE="4.0">

   <INPUT TYPE="HIDDEN" NAME="sort_by" VALUE="status">

   <INPUT TYPE="HIDDEN" NAME="InquiryNumber1" VALUE="<?php echo $order->shipping['tracking_no']; ?> ">

   <input name="submit" type="submit" value="<?php echo $order->shipping['tracking_no']; ?>"></form></td>

   </tr>

<?php


         }
?>

That's for UPS tracking. you can edit for other shipping carriers.

For your question 2. Read the above posts. It's already been answered.

Dont Mess With Texas · May 12, 2005

Im trying to install this mod and when running the SQL i get this error.

#1062 - Duplicate entry '3-1' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

Dont Mess With Texas · May 12, 2005

Can anyone help?

Dont Mess With Texas · May 13, 2005

Anyone know why im getting this error when trying to run the SQL

#1062 - Duplicate entry '3-1' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

pickupman · May 13, 2005

Anyone know why im getting this error when trying to run the SQL

#1062 - Duplicate entry '3-1' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

<{POST_SNAPBACK}>

The sql file doesn't delete the table. It tries to add the values that entry is already in the order_status table. Try this as your sql file.:

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ) 
VALUES (
'4', '1', 'Delivered'
);

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ) 
VALUES (
'4', '2', 'Geliefert'
);

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ) 
VALUES (
'4', '3', 'Entregado'
);

ALTER TABLE `orders` ADD `tracking_no` TEXT;

ALTER TABLE `orders` ADD `ship_date` TEXT;

ALTER TABLE `orders` ADD `delivery_date` TEXT;

Butterfly Princess · May 14, 2005

Hello,

I am also getting the same error and tried the fix above and now getting this error.

#1062 - Duplicate entry '4-1' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 685

Im not good with troubleshooting database errors. Is thier anyone who could give me a hand?

Thanks

Butterfly Princess · May 14, 2005

Forgot to add it mentioned this in the install.txt but i dont kow what it means:

IMPORTANT!!! I changed Delivery status from ID 3 to ID 4 in the database. I did it manually b/c it was quicker than writing a query for it (only 3 instances, 1 for each language). You need to delete the 3 Delivery status entries from the DB ... orders_status.order_status_id Shipping status is ID 3 in the code below. It only made sense that it came before Delivery, right? ;)

OK, that said ... I take no credit for any of the code. I simply changed some minor things as listed below. Sorry for being a perfectionist, but I'm anal that way. ;)

Changes to original mod:

- Modified SQL file to include other languages and to properly sort status in Admin CP (DELETE DELIVERY STATUS ID FIRST and then Optimize Table, then run SQL)

- Changed Delivery and Shipped status IDs

Can anyone tell me what that means? Here is also the orignal SQL: