Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Fancier Invoice & Packingslip v1.0


PopTheTop

Recommended Posts

Maybe someone can help me! Everything works ok, except for printing.

 

I'm missing every horizontal bar (maingrey_02) when printing. If I press te print button I see the popup screen which shows every line. So you should think it will then print what you see, but that'doens't happen, it prints except for the maingrey_02.gif lines.

Link to comment
Share on other sites

Maybe someone can help me! Everything works ok, except for printing.

 

I'm missing every horizontal bar (maingrey_02) when printing. If I press te print button I see the popup screen which shows every line. So you should think it will then print what you see, but that'doens't happen, it prints except for the maingrey_02.gif lines.

 

If your browser, or any customer's for that matter, is set up to not print the background images or colors, then those images/colors won't appear on the printed copy.

Link to comment
Share on other sites

Hi

 

Got this great mod working :-)

 

Only one area left to solve now and it's to do with the emails that are sent to the customer.

 

1) When he checks out and the email goes to him all the info is there in the email but, there seems to be a load of broken image links

 

2) At the top of the email..just above the date...it shows some text like this INVOICE_TEXT_INVOICE INVOICE_TEXT_NUMBER_SIGN 5INVOICE_TEXT_DASH3

 

Anyone know how to get rid of the text and make the images show up in the email that are broken.

 

TIA for any help

Link to comment
Share on other sites

I just completed the Fancier Invoice & Packing slip upgrade and as I suspected it does not work because I missed something or placed something in the wrong file.

I am reviewing the instructions now to see what I missed.

 

I have 2 questions:

 

1. I entered the SQL data twice thinking that was my problem so now I have double the e-mail or duplicate e-mail options......How do I edit SQL to remove the extra lines in configuration.

 

2. When you have finished the instructions it says in e-mail options to change the 2 new settings for mime html to true.....I can only find mime html....what it the text of the other option to change??

 

thanks

 

jer37

Link to comment
Share on other sites

I just completed the Fancier Invoice & Packing slip upgrade and as I suspected it does not work because I missed something or placed something in the wrong file.

I am reviewing the instructions now to see what I missed.

 

I have 2 questions:

 

1. I entered the SQL data twice thinking that was my problem so now I have double the e-mail or duplicate e-mail options......How do I edit SQL to remove the extra lines in configuration.

 

2. When you have finished the instructions it says in e-mail options to change the 2 new settings for mime html to true.....I can only find mime html....what it the text of the other option to change??

 

thanks

 

jer37

Another problem has poped up...I am now getting the below error message when I make a test purchase and and try to complete the transaction.

 

Warning: main(includes/modules/email_invoice/email_invoice.php): failed to open stream: No such file or directory in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

 

Warning: main(includes/modules/email_invoice/email_invoice.php): failed to open stream: No such file or directory in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

 

Fatal error: main(): Failed opening required 'includes/modules/email_invoice/email_invoice.php' (include_path='.:/usr/lib/php/:/usr/share/pear/') in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

Link to comment
Share on other sites

Hi

 

Got this great mod working :-)

 

Only one area left to solve now and it's to do with the emails that are sent to the customer.

 

1) When he checks out and the email goes to him all the info is there in the email but, there seems to be a load of broken image links

 

2) At the top of the email..just above the date...it shows some text like this INVOICE_TEXT_INVOICE INVOICE_TEXT_NUMBER_SIGN 5INVOICE_TEXT_DASH3

 

Anyone know how to get rid of the text and make the images show up in the email that are broken.

 

TIA for any help

 

 

 

Got this working now :-)

 

The only problem I now have is that when an invoice is sent out to a customer, our company logo seems to be showing up as a broken link...looking at the source it shows the path as being;-

 

<td align="left"><img src="my_website_url/catalog//catalog/images/oscommerce.gif

 

Can anyone tell me why the extra /catalog is in the path betwen my web url and the image path?

 

I'm thinking that this is why my logo isn't showing up....prepared to be proved wrong though if anyone knows another reason ;-)

 

All other images show up fine, it's just in the emails.

 

Hopefully someone wil know the answer and then I'm finished

 

TIA for any help.

Link to comment
Share on other sites

I am getting this same error Did you find a fix? I haven't been able to find one on the form

 

Another problem has poped up...I am now getting the below error message when I make a test purchase and and try to complete the transaction.

 

Warning: main(includes/modules/email_invoice/email_invoice.php): failed to open stream: No such file or directory in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

 

Warning: main(includes/modules/email_invoice/email_invoice.php): failed to open stream: No such file or directory in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

 

Fatal error: main(): Failed opening required 'includes/modules/email_invoice/email_invoice.php' (include_path='.:/usr/lib/php/:/usr/share/pear/') in /home/domains/hpoawear.com/web/catalog/checkout_process.php on line 225

Link to comment
Share on other sites

Forgive me if this has already been answered...I've looked around and haven't found an answer myself. When a customer clicks on the Print Invoice button, a window pops up, but with no invoice information. The site shell looks fine, but there's no invoice content. Everything else seems to be working great.

 

I'm using Fancy Invoice V6.1

 

The URL that pops up when the mouse is over the Print Invoice Button is:

 

Run script "popupPrintReceipt('https://www.kimandjason.com/shop/print_my_invoice.php?order_id=9&osCsid=4ce407b7a6fee00e928f67dd0be6d42c')"

 

Also the breadcrumb trail at the top goes like this: Home >> Lemonade Stand >> NAVBAR_TITLE_1 >> NAVBAR_TITLE_2 >> NAVBAR_TITLE_3

 

Not sure what I missed but thanks in advance for your help!

 

Jason

Link to comment
Share on other sites

I am getting this same error Did you find a fix? I haven't been able to find one on the form

 

 

It is telling you that it can not find the file. Therefore, it is telling you to check your paths. Is your store in the sub folder called "catalog"? If not, then there is your problem.

 

Edit line number 255 and look at the path it is calling.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Forgive me if this has already been answered...I've looked around and haven't found an answer myself. When a customer clicks on the Print Invoice button, a window pops up, but with no invoice information. The site shell looks fine, but there's no invoice content. Everything else seems to be working great.

 

I'm using Fancy Invoice V6.1

 

The URL that pops up when the mouse is over the Print Invoice Button is:

 

Run script "popupPrintReceipt('https://www.kimandjason.com/shop/print_my_invoice.php?order_id=9&osCsid=4ce407b7a6fee00e928f67dd0be6d42c')"

 

Also the breadcrumb trail at the top goes like this: Home >> Lemonade Stand >> NAVBAR_TITLE_1 >> NAVBAR_TITLE_2 >> NAVBAR_TITLE_3

 

Not sure what I missed but thanks in advance for your help!

 

Jason

 

 

Look at the path/code being called for that pop-up page to be printed.

It is opening:

https://www.kimandjason.com/shop/print_my_invoice.php/order_id/14?osCsid=4ce407b7a6fee00e928f67dd0be6d42c

Instead of

https://www.kimandjason.com/shop/print_my_invoice.php?order_id=14&osCsid=4ce407b7a6fee00e928f67dd0be6d42c

 

Look at the bold.

 

 

 

By the way, in the catagory looking at the product lists, when you click on your BUY button, you get the following SQL error. To bypass it, you have to view the product and THEN hit add to wagon (cart).

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

QUOTE(jbirdink @ Aug 17 2005, 05:06 PM)

Forgive me if this has already been answered...I've looked around and haven't found an answer myself. When a customer clicks on the Print Invoice button, a window pops up, but with no invoice information. The site shell looks fine, but there's no invoice content. Everything else seems to be working great.

 

I'm using Fancy Invoice V6.1

 

The URL that pops up when the mouse is over the Print Invoice Button is:

 

Run script "popupPrintReceipt('https://www.kimandjason.com/shop/print_my_invoice.php?order_id=9&osCsid=4ce407b7a6fee00e928f67dd0be6d42c')"

 

Also the breadcrumb trail at the top goes like this: Home >> Lemonade Stand >> NAVBAR_TITLE_1 >> NAVBAR_TITLE_2 >> NAVBAR_TITLE_3

 

Not sure what I missed but thanks in advance for your help!

 

Jason

 

Look at the path/code being called for that pop-up page to be printed.

It is opening:

https://www.kimandjason.com/shop/print_my_invoice.php/order_id/14?osCsid=4ce407b7a6fee00e928f67dd0be6d42c

Instead of

https://www.kimandjason.com/shop/print_my_invoice.php?order_id=14&osCsid=4ce407b7a6fee00e928f67dd0be6d42c

 

Look at the bold.

 

Actually, the reason the URL was funky like that is because I had temporarily turned on the Search Engine Safe ULS in the Admin Panel. It's back to normal now, but I still can't get the print invoice button to work.

 

By the way, in the catagory looking at the product lists, when you click on your BUY button, you get the following SQL error. To bypass it, you have to view the product and THEN hit add to wagon (cart).

 

How exactly are you getting an error...and what is the error? I am not having any problems adding items to the cart when I click on the BUY button...

 

Thanks for looking into it- I really appreciate it.

Link to comment
Share on other sites

The SQL error is no longer there...

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Ok, I am having a small issue and can't seem to hunt it down. I changed the /languages/english/invoice.php and packingslip.php with our JPG logo. But when we go to the admin side and click on the packing slip and invoice, the logo does not show. the path is correct /admin/images/logo.jpg

 

i used to have our logo and renamed it oscommerce.gif and it worked. so do we need to make sure the logo is just named oscommerce.gif at all times?

Link to comment
Share on other sites

Good to hear.

Still no ideas on what's wrong with my Print Invoice function, huh?

 

Jason

 

 

No, not really. It should load the invoice. Try re-uploading the template files and the print_invoice file. If you want, I can send you a direct copy of mine for you to use. In fact, here it is anyway... try it out.

 

print_my_invoice.php

<?php
/*
 $Id: print_my_invoice.php,v 6.0 2005/06/01 23:03:52 PopTheTop Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 if (!tep_session_is_registered('customer_id')) {
   $navigation->set_snapshot();
   tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
 }

 if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) {
   tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }
 $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
 $customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'");
 $customer_info = tep_db_fetch_array($customer_info_query);
 if ($customer_info['customers_id'] != $customer_id) {
   tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_PRINTABLE_INFO);

 $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));
 $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 $breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ORDERS_PRINTABLE_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'));

 require(DIR_WS_CLASSES . 'order.php');
 $order = new order($HTTP_GET_VARS['order_id']);
 $date = date('M d, Y');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo STORE_NAME; ?> <?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id;; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onload="window.print();return false">
<!-- body_text //-->
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
  <td align="left"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '">'; ?></td>
  <TD ALIGN="right" VALIGN="top"><FONT COLOR="#006699" SIZE="2" FACE="Verdana"><strong><?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id; ?><BR><?php echo $date; ?></strong></font></TD>
</tr>
<tr>
  <td colspan="2">
    <table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <TD COLSPAN="2" ALIGN="right" class="smallAddressBlue_INVOICE"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></TD>
      </tr>
      <tr>
        <TD>
          <table width="100%" border="0" cellspacing="0" cellpadding="2">
            <tr>
              <td colspan="4">
                <table width="100%" border="0" cellspacing="0" cellpadding="2">
                  <tr>
                    <td width="10%"><hr size="2"></td>
                    <td align="center" class="pageHeading_INVOICE"><em><b><?php echo INVOICE_TEXT_INVOICE; ?></b></em></td>
                    <td width="100%"><hr size="2"></td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td>
            </tr>
            <tr>
              <td width="3"> </td>
              <td valign="top">
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
                    <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
                    <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
                  </tr>
                  <tr>
                    <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
                    <td align="center" bgcolor="#F2F2F2">
                      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main_INVOICE">
                        <tr>
                          <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SOLD_TO; ?></b></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>    '); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo $order->customer['telephone']; ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo $order->customer['email_address']; ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td>
                        </tr>
                    </table></td>
                    <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
                  </tr>
                  <tr>
                    <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
                    <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
                    <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
                  </tr>
              </table></td>
              <td width="45"> </td>
              <td valign="top">
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="11"><img src="images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td>
                    <td background="images/borders/mainwhite_02.gif"><img src="images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td>
                    <td width="19"><img src="images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td>
                  </tr>
                  <tr>
                    <td background="images/borders/mainwhite_04.gif"><img src="images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td>
                    <td align="center" bgcolor="#FFFFFF">
                      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE">
                        <tr>
                          <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SHIP_TO; ?></b></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>    '); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    </td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE">    </td>
                        </tr>
                        <tr>
                          <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td>
                        </tr>
                    </table></td>
                    <td background="images/borders/mainwhite_06.gif"><img src="images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td>
                  </tr>
                  <tr>
                    <td><img src="images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td>
                    <td background="images/borders/mainwhite_08.gif"><img src="images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td>
                    <td><img src="images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td>
                  </tr>
              </table></td>
            </tr>
        </table></TD>
      </tr>
      <tr>
        <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td>
      </tr>
      <tr>
        <TD COLSPAN="2">
          <table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="9"> </td>
              <td>
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
                    <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
                    <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
                  </tr>
                  <tr>
                    <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
                    <td align="center" bgcolor="#F2F2F2">
                      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE">
                        <tr>
                          <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_ORDER; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_COLON; ?></strong> <?php echo tep_db_input( $order_id); ?></td>
                          <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_DATE_OF_ORDER; ?><?php echo INVOICE_TEXT_COLON; ?> </strong><?php echo tep_date_short($order->info['date_purchased']); ?></td>
<?php
 if (tep_not_null($order->info['cc_number']))  {
   $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4);
?>
                          <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?> (<?php echo $order->info['cc_type']; ?>)<br>
                              <?php echo tep_draw_separator('pixel_trans.gif', '100%', '6'); ?><br>
                              <span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_CC_NUMBER; ?></b></span> <?php echo $this->cc_card_number_less_middle_digits; ?></td>
<?php
 } else {
?>
                          <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?></td>
<?php
 }
?>
                        </tr>
                        <tr>
                          <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
                        </tr>
                    </table></td>
                    <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
                  </tr>
                  <tr>
                    <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
                    <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
                    <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
                  </tr>
              </table></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td>
      </tr>
      <tr>
        <TD COLSPAN="2" align="center">
	 <table border="0" width="98%" cellspacing="0" cellpadding="2">
            <tr class="dataTableHeadingRow_INVOICE">
              <td colspan="2" class="dataTableHeadingContent_INVOICE"> <font color="#000000"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td>
              <td WIDTH="80" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></font></td>
              <td WIDTH="80" align="right" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td>
              <TD WIDTH="80" ALIGN="right" CLASS="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_TOTAL; ?></font> </TD>
            </tr>
<?php
  for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
  echo '      <tr class="dataTableRow_INVOICE">' . "\n" .
   '        <td class="dataTableContent_INVOICE" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
   '        <td class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['name'];

    if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {
      for ($j = 0; $j < $k; $j++) {
        echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
        if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
        echo '</i></small></nobr>';
      }
    }

    echo '          </td>' . "\n" .
         '          <td WIDTH="80" class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";
    echo '          <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" .
         '          <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ' </b></td>' . "\n";
    echo '         </tr>' . "\n";
  }
?>
            <tr>
              <td align="right" colspan="5">
                <table border="0" cellspacing="0" cellpadding="2">
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
  echo '         <tr>' . "\n" .
       '          <td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['title'] . '</td>' . "\n" .
       '          <td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['text'] . '</td>' . "\n" .
       '         </tr>' . "\n";
}
?>
              </table></td>
            </tr>
        </table></td>
      </tr>
  <!-- ORDER COMMENTS CODE STARTS HERE //-->
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td>
      </tr>
      <tr>
    	 <TD>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
   <tr>
              <td width="9"> </td>
              <td>
          <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
                <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
              <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
              <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
          </tr>
          <tr>
              <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
              <td align="center" bgcolor="#F2F2F2">
      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main">
<!-- backorder addition -->
<?php
 $orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'");
 $orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query);

 if (tep_not_null($orders_history_backorder['backorders'])) {
?>
               <tr>
                    <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td>
               </tr>
               <tr>
                    <td valign="top" class="product_infobox_data" width="114"><br>    <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td>
                    <td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td>
               </tr>
               <tr>
                    <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td>
               </tr>
<?php
 }
?>
<!-- end backorder addition -->
               <tr>
                    <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>ORDER COMMENTS:</b></td>
               </tr>
<?php
 $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, osh.backorders from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");
 while ($statuses = tep_db_fetch_array($statuses_query)) {
     echo '                <tr>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data" width="114"><br>    <strong>' . tep_date_short($statuses['date_added']) . '</strong></td>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data" width="85"><br>' . $statuses['orders_status_name'] . '</td>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data"><br>' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n";
     echo '                </tr>' . "\n";
 }
?>
               <tr>
                    <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
               </tr>
      </table>
      </td>
      <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
          </tr>
          <tr>
            <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
            <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
            <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
          </tr>
          </table>
          </td>
   </tr>
        </table>
<!-- ORDER COMMENTS CODE ENDS HERE //-->
<br>
<CENTER><span class="smallText_INVOIVE"><FONT FACE="Verdana" COLOR="#006699"><strong><?php echo INVOICE_TEXT_THANK_YOU; ?><BR><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></span></CENTER>
<!-- body_text_eof //-->

</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Ok, I am having a small issue and can't seem to hunt it down.? I changed the /languages/english/invoice.php and packingslip.php with our JPG logo.? But when we go to the admin side and click on the packing slip and invoice, the logo does not show.? the path is correct /admin/images/logo.jpg

 

i used to have our logo and renamed it oscommerce.gif and it worked.? so do we need to make sure the logo is just named oscommerce.gif at all times?

 

 

Try using the path catalog/admin/images/logo.jpg or images/logo.jpg

 

Chances are that images/logo.jpg is the one you need to use.

 

Take a look at the border paths and use the same path that they use.

 

This is my setting and my store is located at www.xxx.com/catalog/admin/...

 

//Change this to match your logo image and foler it is in
define('INVOICE_IMAGE', 'images/pop-the-top_logo1.gif');

Edited by PopTheTop

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

No, not really. It should load the invoice. Try re-uploading the template files and the print_invoice file. If you want, I can send you a direct copy of mine for you to use. In fact, here it is anyway... try it out.

 

print_my_invoice.php

<?php
/*
?$Id: print_my_invoice.php,v 6.0 2005/06/01 23:03:52 PopTheTop Exp $

?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

?Copyright (c) 2003 osCommerce

?Released under the GNU General Public License
*/

?require('includes/application_top.php');

?if (!tep_session_is_registered('customer_id')) {
? ?$navigation->set_snapshot();
? ?tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
?}

?if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) {
? ?tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
?}
?$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
?$customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'");
?$customer_info = tep_db_fetch_array($customer_info_query);
?if ($customer_info['customers_id'] != $customer_id) {
? ?tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
?}

?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_PRINTABLE_INFO);

?$breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));
?$breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
?$breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ORDERS_PRINTABLE_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'));

?require(DIR_WS_CLASSES . 'order.php');
?$order = new order($HTTP_GET_VARS['order_id']);
?$date = date('M d, Y');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo STORE_NAME; ?> <?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id;; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onload="window.print();return false">
<!-- body_text //-->
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
? <td align="left"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '">'; ?></td>
? <TD ALIGN="right" VALIGN="top"><FONT COLOR="#006699" SIZE="2" FACE="Verdana"><strong><?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id; ?><BR><?php echo $date; ?></strong></font></TD>
</tr>
<tr>
? <td colspan="2">
? ? <table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? <tr>
? ? ? ? <TD COLSPAN="2" ALIGN="right" class="smallAddressBlue_INVOICE"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></TD>
? ? ? </tr>
? ? ? <tr>
? ? ? ? <TD>
? ? ? ? ? <table width="100%" border="0" cellspacing="0" cellpadding="2">
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? <td colspan="4">
? ? ? ? ? ? ? ? <table width="100%" border="0" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td width="10%"><hr size="2"></td>
? ? ? ? ? ? ? ? ? ? <td align="center" class="pageHeading_INVOICE"><em><b><?php echo INVOICE_TEXT_INVOICE; ?></b></em></td>
? ? ? ? ? ? ? ? ? ? <td width="100%"><hr size="2"></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? </tr>
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td>
? ? ? ? ? ? </tr>
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? <td width="3"> </td>
? ? ? ? ? ? ? <td valign="top">
? ? ? ? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
? ? ? ? ? ? ? ? ? ? <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td align="center" bgcolor="#F2F2F2">
? ? ? ? ? ? ? ? ? ? ? <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main_INVOICE">
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SOLD_TO; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>    '); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo $order->customer['telephone']; ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo $order->customer['email_address']; ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? ? <td width="45"> </td>
? ? ? ? ? ? ? <td valign="top">
? ? ? ? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td width="11"><img src="images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/mainwhite_02.gif"><img src="images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td width="19"><img src="images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/mainwhite_04.gif"><img src="images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td align="center" bgcolor="#FFFFFF">
? ? ? ? ? ? ? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE">
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SHIP_TO; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>    '); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    </td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE">    </td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/mainwhite_06.gif"><img src="images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/mainwhite_08.gif"><img src="images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? </tr>
? ? ? ? </table></TD>
? ? ? </tr>
? ? ? <tr>
? ? ? ? <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td>
? ? ? </tr>
? ? ? <tr>
? ? ? ? <TD COLSPAN="2">
? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? <td width="9"> </td>
? ? ? ? ? ? ? <td>
? ? ? ? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
? ? ? ? ? ? ? ? ? ? <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td align="center" bgcolor="#F2F2F2">
? ? ? ? ? ? ? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE">
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_ORDER; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_COLON; ?></strong> <?php echo tep_db_input( $order_id); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ? <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_DATE_OF_ORDER; ?><?php echo INVOICE_TEXT_COLON; ?> </strong><?php echo tep_date_short($order->info['date_purchased']); ?></td>
<?php
?if (tep_not_null($order->info['cc_number'])) ?{
? ?$this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4);
?>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?> (<?php echo $order->info['cc_type']; ?>)<br>
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <?php echo tep_draw_separator('pixel_trans.gif', '100%', '6'); ?><br>
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_CC_NUMBER; ?></b></span> <?php echo $this->cc_card_number_less_middle_digits; ?></td>
<?php
?} else {
?>
? ? ? ? ? ? ? ? ? ? ? ? ? <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?></td>
<?php
?}
?>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? ? ? ? <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? ? <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? </tr>
? ? ? ? </table></td>
? ? ? </tr>
? ? ? <tr>
? ? ? ? <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td>
? ? ? </tr>
? ? ? <tr>
? ? ? ? <TD COLSPAN="2" align="center">
?	<table border="0" width="98%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? <tr class="dataTableHeadingRow_INVOICE">
? ? ? ? ? ? ? <td colspan="2" class="dataTableHeadingContent_INVOICE"> <font color="#000000"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td>
? ? ? ? ? ? ? <td WIDTH="80" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></font></td>
? ? ? ? ? ? ? <td WIDTH="80" align="right" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td>
? ? ? ? ? ? ? <TD WIDTH="80" ALIGN="right" CLASS="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_TOTAL; ?></font> </TD>
? ? ? ? ? ? </tr>
<?php
? for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
? echo ' ? ? ?<tr class="dataTableRow_INVOICE">' . "\n" .
? ?' ? ? ? ?<td class="dataTableContent_INVOICE" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
? ?' ? ? ? ?<td class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['name'];

? ? if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {
? ? ? for ($j = 0; $j < $k; $j++) {
? ? ? ? echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
? ? ? ? if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
? ? ? ? echo '</i></small></nobr>';
? ? ? }
? ? }

? ? echo ' ? ? ? ? ?</td>' . "\n" .
? ? ? ? ?' ? ? ? ? ?<td WIDTH="80" class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";
? ? echo ' ? ? ? ? ?<td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" .
? ? ? ? ?' ? ? ? ? ?<td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ' </b></td>' . "\n";
? ? echo ' ? ? ? ? </tr>' . "\n";
? }
?>
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? <td align="right" colspan="5">
? ? ? ? ? ? ? ? <table border="0" cellspacing="0" cellpadding="2">
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
? echo ' ? ? ? ? <tr>' . "\n" .
? ? ? ?' ? ? ? ? ?<td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['title'] . '</td>' . "\n" .
? ? ? ?' ? ? ? ? ?<td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['text'] . '</td>' . "\n" .
? ? ? ?' ? ? ? ? </tr>' . "\n";
}
?>
? ? ? ? ? ? ? </table></td>
? ? ? ? ? ? </tr>
? ? ? ? </table></td>
? ? ? </tr>
? <!-- ORDER COMMENTS CODE STARTS HERE //-->
? ? ? <tr>
? ? ? ? <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td>
? ? ? </tr>
? ? ? <tr>
? ? ?	<TD>
? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ?<tr>
? ? ? ? ? ? ? <td width="9"> </td>
? ? ? ? ? ? ? <td>
? ? ? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0">
? ? ? ? ? <tr>
? ? ? ? ? ? ? ? <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
? ? ? ? ? ? ? <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
? ? ? ? ? ? ? <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
? ? ? ? ? </tr>
? ? ? ? ? <tr>
? ? ? ? ? ? ? <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
? ? ? ? ? ? ? <td align="center" bgcolor="#F2F2F2">
? ? ? <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main">
<!-- backorder addition -->
<?php
?$orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'");
?$orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query);

?if (tep_not_null($orders_history_backorder['backorders'])) {
?>
? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td>
? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? <td valign="top" class="product_infobox_data" width="114"><br>    <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td>
? ? ? ? ? ? ? ? ? ? <td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td>
? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td>
? ? ? ? ? ? ? ?</tr>
<?php
?}
?>
<!-- end backorder addition -->
? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>ORDER COMMENTS:</b></td>
? ? ? ? ? ? ? ?</tr>
<?php
?$statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, osh.backorders from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");
?while ($statuses = tep_db_fetch_array($statuses_query)) {
? ? ?echo ' ? ? ? ? ? ? ? ?<tr>' . "\n";
? ? ?echo ' ? ? ? ? ? ? ? ? ? ? <td valign="top" class="product_infobox_data" width="114"><br>    <strong>' . tep_date_short($statuses['date_added']) . '</strong></td>' . "\n";
? ? ?echo ' ? ? ? ? ? ? ? ? ? ? <td valign="top" class="product_infobox_data" width="85"><br>' . $statuses['orders_status_name'] . '</td>' . "\n";
? ? ?echo ' ? ? ? ? ? ? ? ? ? ? <td valign="top" class="product_infobox_data"><br>' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n";
? ? ?echo ' ? ? ? ? ? ? ? ?</tr>' . "\n";
?}
?>
? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
? ? ? ? ? ? ? ?</tr>
? ? ? </table>
? ? ? </td>
? ? ? <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
? ? ? ? ? </tr>
? ? ? ? ? <tr>
? ? ? ? ? ? <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
? ? ? ? ? ? <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
? ? ? ? ? ? <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
? ? ? ? ? </tr>
? ? ? ? ? </table>
? ? ? ? ? </td>
? ?</tr>
? ? ? ? </table>
<!-- ORDER COMMENTS CODE ENDS HERE //-->
<br>
<CENTER><span class="smallText_INVOIVE"><FONT FACE="Verdana" COLOR="#006699"><strong><?php echo INVOICE_TEXT_THANK_YOU; ?><BR><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></span></CENTER>
<!-- body_text_eof //-->

</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

Ok, I re-uploaded the template files and replaced the code I had with the code you listed, and it solved the problem of the Print Invoice button not working. It now works, and the invoice shows up...however...

 

it doesn't show all of the invoice. At the bottom of the invoice I'm getting the following error:

 

1054 - Unknown column 'backorders' in 'field list'

 

select backorders from orders_status_history where orders_id = '11'

 

[TEP STOP]

 

Now what? Thanks for getting me this far...

Link to comment
Share on other sites

Ok, I re-uploaded the template files and replaced the code I had with the code you listed, and it solved the problem of the Print Invoice button not working. It now works, and the invoice shows up...however...

 

it doesn't show all of the invoice. At the bottom of  the invoice I'm getting the following error:

 

1054 - Unknown column 'backorders' in 'field list'

 

select backorders from orders_status_history where orders_id = '11'

 

[TEP STOP]

 

Now what? Thanks for getting me this far...

 

It looks like when you copied PopOnTop's code there was a mod you didn't have installed, namely the Back Orders mod. I don't know if it has anything to do with this mod (I am about to install it) but you should probably back up your file and remove the following:

 

<!-- backorder addition -->
<?php
$orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'");
$orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query);

if (tep_not_null($orders_history_backorder['backorders'])) {
?>
              <tr>
                   <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td>
              </tr>
              <tr>
                   <td valign="top" class="product_infobox_data" width="114"><br>    <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td>
                   <td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td>
              </tr>
              <tr>
                   <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td>
              </tr>
<?php
}
?>
<!-- end backorder addition -->

 

 

And Find and remove:

 

, osh.backorders

 

Hopefully that helps.

Link to comment
Share on other sites

It looks like when you copied PopOnTop's code there was a mod you didn't have installed, namely the Back Orders mod. I don't know if it has anything to do with this mod (I am about to install it) but you should probably back up your file and remove the following:

 

<!-- backorder addition -->
<?php
$orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'");
$orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query);

if (tep_not_null($orders_history_backorder['backorders'])) {
?>
? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ?<td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td>
? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ?<td valign="top" class="product_infobox_data" width="114"><br>    <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td>
? ? ? ? ? ? ? ? ? ?<td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td>
? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? ? ?<td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td>
? ? ? ? ? ? ? </tr>
<?php
}
?>
<!-- end backorder addition -->

And Find and remove:

 

, osh.backorders

 

Hopefully that helps.

 

 

Yep, that will do it for you.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Hello...Sorry to bother...I've worked a lot to install this contrib...I've messed some things, but finally got them together...It workes! Excpet for one thing. I'm sure it's something that I missed. I'm very tired and I can't think right now...maybe in the morning I'll se the problem better. But in case I'm totally stupid :D...could you help?

 

In the email, why does it look like deceasa.GIF this???

 

Thanks a lot in advance...

Link to comment
Share on other sites

Hello...Sorry to bother...I've worked a lot to install this contrib...I've messed some things, but finally got them together...It workes!  Excpet for one thing. I'm sure it's something that I missed. I'm very tired and I can't think right now...maybe in the morning I'll se the problem better. But in case I'm totally stupid :D...could you help?

 

In the email, why does it look like deceasa.GIF this???

 

Thanks a lot in advance...

 

 

Check your paths. Right-click on the missing images and look at the path they are calling through properties. If your store is not in the catalog sub folder, then this is probably your problem.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

For the Fancier Invoice & Packing slip V6.1 contribution I am having a little problem.

The packing slip looks and prints fine but the Invoice appears to be a little messed up. What I am getting is this:

=====================================================

INVOICE_TEXT_ORDER INVOICE_TEXT_NUMBER_SIGNINVOICE_TEXT_COLON 5 INVOICE_TEXT_DATE_OF_ORDERINVOICE_TEXT_COLON 08/21/2005 Payment Method: Check/Money Order

=====================================================

in the box that contains the order number, date and payment method info.

 

I have not edited or touched the invoice.php in any way, just did an up load from the contribution folder on my computer.

 

I have scaned the invoice.php but cant seem to find any problem and my eyes are getting tired...any help would be appreciated.

 

thanks

jer37

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...