Attributes not showing on all invoices

[puddlesofpaint]

This problem has been there from the beginning (03/01/2014).

The problem is not all attributes are showing up on all invoices.

If shipping is free, all attributes DO display on emails, invoices, and packing slips.

If shipping is not free, attributes DO show up on emails only, but all attributes DO NOT display on invoices and packing slips. Only some attributes display on the invoices and packing slips, but we need ALL attributes to display on all invoices!

I believe the only missing attributes are text files.

Any suggestions please?

OUR INFORMATION:
Database: MySQL 5.0.96
PHP Version: 5.2.17

We are using Version 1.5.1. Our site has not been upgraded from a previous version. One plugin installed for county taxes. Also we have integrated with FedEx, Authorize.net, Paypal, and USPS.

www.cookiegramsofga.com

Thank you.

[twitchtoo]

The order I placed displayed in the cart and the order confirmation email correctly.

I assume it displays correctly in admin yes?

[twitchtoo]

The order I placed displayed in the cart and the order confirmation email correctly.

I assume it displays correctly in admin yes?

My second order included shipping and displayed correctly on the client side, all the attributes, shipping and text boxes. Is this the case in admin?

[puddlesofpaint]

Darn I thought I had isolated the problem to just orders with shipping. Your 2 orders appear correct.

However the one just before your order shows this:

1 x Dr. Bag Rx: Enjoy Crate Box
- How Many Cookies?: 3 Dozen Cookies ($30.80)
- Choose up to 4 kinds of Cookies:: Chocolate Chip
- Choose up to 4 kinds of Cookies:: Peanut Butter
- Choose up to 4 kinds of Cookies:: Sugar Cinnamon
- Choose up to 4 kinds of Cookies:: White Chocolate Macadamia
- Delivery Date or Pickup Date:
- Recipient's (or Contact's: 404-XXX-XXXX
- COOKIEGRAM®
CARD MESSAGE<: Get Well Soon Mary! Praying for a Speedy Recovery!
Love You, Johnna and Carl Simpson
################################################################################ ####################_

The delivery/pick up date is mandatory. The date that the customer fills in shows up on our emailed copy of the order ... but it does not show up on the invoice or packing slip (see above -- as blank) in admin.

################################################################################ ########################

This is what shows up on the order that is emailed:
Products
------------------------------------------------------
1 x Dr. Bag Rx: Enjoy Crate Box = $30.80
How Many Cookies? 3 Dozen Cookies
Choose up to 4 kinds of Cookies: Chocolate Chip
Choose up to 4 kinds of Cookies: Peanut Butter
Choose up to 4 kinds of Cookies: Sugar Cinnamon
Choose up to 4 kinds of Cookies: White Chocolate Macadamia
Delivery Date or Pickup DateExample: Monday 4/28/14) Wednesday 6/4/14
Recipient's (or Contact's) Phone #Example: xxx-xxx-xxxx) 404-XXX-XXXX
COOKIEGRAM&reg;CARD MESSAGE& SIGNATURE: Get Well Soon Mary! Praying for a
Speedy Recovery!
Love You, Johnna and Carl Simpson
------------------------------------------------------

[twitchtoo]

That would mean the field is not being loaded, then displayed on the admin-> invoice.php, same for the packing slip.

Who custom coded all the extra fields? They missed the output code on those two pages.

(The date can be converted to a dropdown calendar with some java... once you get this field data fixed.)

[puddlesofpaint]

Sorry for those frownie faces- they were just parentheses in the script but turned into frownies in this post above. LOL

[puddlesofpaint]

I added all those extra fields myself through attributes in admin. What is the output code and can I fix that myself in the php part?

[twitchtoo]

Sorry for those frownie faces- they were just parentheses in the script but turned into frownies in this post above. LOL

Squirrel! ;)

[twitchtoo]

That's classified php code... but I think if you had some coffee, time on a sunny afternoon and a charitable donation to some guy named Twitch he would ask you to:

- make sure the new fields are being recorded to the database in the order table or table of your choice (it's likely considering I received an email with the data in it)

- open admin/invoice.php look to see that the field data is being loaded with a sql query then output to html like this:

<?php // bof Twitch Delivery Information ?>
<table id="deliveryInformation">
<?php     $orders_history = $db->Execute("select orders_status_id, date_added, twi_delivery_date, twi_delivery_time, twi_delivery_phone, twi_delivery_card_message
                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
                                    where orders_id = '" . zen_db_input($oID) . "'
                                    order by date_added");
                                    ?>
        <tr>
           <td class="main"><strong><?php echo 'Delivery Information: '; ?></strong></td>
        </tr>
        <tr>
           <td class="main"><?php echo 'Order to be delivered on: '; ?></td>
           <td class="deliveryText"><?php echo $orders_history->fields['twi_delivery_date']; ?></td>
        </tr>
        <tr>
           <td class="main"><?php echo 'Preferred delivery time: '; ?></td>
           <td class="deliveryText"><?php echo $orders_history->fields['twi_delivery_time']; ?></td>
        </tr>
        <tr>
           <td class="main"><?php echo 'Recipient\'s phone number: '; ?></td>
           <td class="deliveryText"><?php echo $orders_history->fields['twi_delivery_phone']; ?></td>
        </tr>
        <tr>
           <td class="main"><?php echo 'Flower card message: '; ?></td>
           <td class="deliveryText"><?php echo $orders_history->fields['twi_delivery_card_message']; ?></td>
        </tr>
</table>
<?php // eof Twitch Delivery Information ?>

In this example the delivery date, time phone and card message are pulled from the db table TABLE_ORDERS_STATUS_HISTORY and spit out on the admin invoice page.

Do the same for the packing slip once you get the invoice working.

Ask more questions cause occasionally Twitch will answer them in code.

[puddlesofpaint]

That's classified php code... but I think if you had some coffee, time on a sunny afternoon and a charitable donation to some guy named Twitch............

............Ask more questions cause occasionally Twitch will answer them in code.

Thanks for your prompt replies! I thought you were already talking in code... you mean it gets worse if I ask more questions? Man, I'm going to need 3 cups of coffee!!!!!!!!!

By the way I have to scoot out to an appointment at 2ish but will return at supper time (EST) to give this a whirl. Will you please check back with me later to see what I've messed up by then?

Okay so... I don't see the whole table thing in my invoice.php that you show above, so I suppose I need to add that whole thing? Here is what I have in that same area:

<?php
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "' and customer_notified >= 0
order by date_added");

if ($orders_history->RecordCount() > 0) {
$count_comments=0;
while (!$orders_history->EOF) {
$count_comments++;
echo ' <tr>' . "\n" .
' <td class="smallText" align="center" valign="top">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n";
echo ' <td class="smallText" valign="top">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
echo ' <td class="smallText" valign="top">' . ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) . '&nbsp;</td>' . "\n" .

' </tr>' . "\n";

$orders_history->MoveNext();
if (ORDER_COMMENTS_INVOICE == 1 && $count_comments >= 1) {
break;
}
}
} else {
echo ' <tr>' . "\n" .
' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
</table></td>
</tr>
<?php