Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Invoice


dlsodders

Recommended Posts

Cany anyone tell me where in the code below I have an error?

 

 

 require('includes/application_top.php');



 require(DIR_WS_CLASSES . 'currencies.php');

 $currencies = new currencies();



 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

 $orders_query = tep_db_query(" select orders_id from " . TABLE_ORDERS . "where orders_id = '" . (int)$oID . "'");

 

 

When I try to view invoice I get the following error.

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '= '11'' at line 1

 

select orders_id from orderswhere orders_id = '11'

 

[TEP STOP]

 

Thanks,

David

Link to comment
Share on other sites

I put a space in there and Im getting this now...

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

select products_description as desc_info from products_description where products_id =

 

[TEP STOP]

Link to comment
Share on other sites

<?php

/*

 $Id: invoice.php,v 1.6 2003/06/20 00:37:30 hpdl 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');



 require(DIR_WS_CLASSES . 'currencies.php');

 $currencies = new currencies();



 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

 $orders_query = tep_db_query(" select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");



 include(DIR_WS_CLASSES . 'order.php');

 $order = new order($oID);

?>

<!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 TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">



<!-- body_text //-->

<table border="0" width="100%" cellspacing="0" cellpadding="2">

 <tr>

   <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

     <tr>

       <td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td>

       <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td>

     </tr>

   </table></td>

 </tr>

 <tr>

   <td><table width="100%" border="0" cellspacing="0" cellpadding="2">

     <tr>

       <td colspan="2"><?php echo tep_draw_separator(); ?></td>

     </tr>

     <tr>

       <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

         <tr>

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

         </tr>

         <tr>

           <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>

         </tr>

         <tr>

           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

         </tr>

         <tr>

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

         </tr>

         <tr>

           <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>

         </tr>

       </table></td>

       <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

         <tr>

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

         </tr>

         <tr>

           <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>

         </tr>

       </table></td>

     </tr>

   </table></td>

 </tr>

 <tr>

   <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

 </tr>

 <tr>

   <td><table border="0" cellspacing="0" cellpadding="2">

     <tr>

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

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

     </tr>

   </table></td>

 </tr>

 <tr>

   <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

 </tr>

 <tr>

   <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

     <tr class="dataTableHeadingRow">

       <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>

       <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>

       <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>

     </tr>

<?php

   for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {



if ($order->products[$i]['name'] == "Custom Computer"){

   echo ' <tr class="dataTableRow">' . "\n" .

        ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

        ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'] . '<small><i>' . $order->products[$i]['description'] . '</small></i>';

   }else{

     echo '      <tr class="dataTableRow">' . "\n" .

          '        <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

          '        <td class="dataTableContent" 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 class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";

     echo '        <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .

          '        <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

          '        <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

          '        <td class="dataTableContent" 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" .

          '        <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";

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

   }

?>

     <tr>

       <td align="right" colspan="8"><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">' . $order->totals[$i]['title'] . '</td>' . "\n" .

        '            <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .

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

 }

?>

       </table></td>

     </tr>

   </table></td>

 </tr>

</table>

<!-- body_text_eof //-->



<br>

</body>

</html>

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

 

Here is the invoice.php file in the admin directory. I get the same problem with the packaging slip file too.

 

However, If I look at the invoice for the returns mod it pulls the data.

 

I really appreciate your help.

 

David

Link to comment
Share on other sites

Okay, I did that. See the results below...

 

SQL-query

 

SQL-query : [Edit] [Create PHP Code]

REPAIR TABLE `products_description`

 

 

 

 

Table Op Msg_type Msg_text

worldofc_products.products_description repair status OK

 

SQL-query

 

SQL-query : [Edit] [Create PHP Code]

REPAIR TABLE `orders`

 

 

 

 

Table Op Msg_type Msg_text

worldofc_products.orders repair status OK

 

 

Still getting this error when trying to view them.

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

select products_description as desc_info from products_description where products_id =

 

[TEP STOP]

 

Thanks

Link to comment
Share on other sites

Well I decided to re-install the system. Recreated an account. Ran a test purchase. When I went into the admin, checked the order everything looked fine.

 

Clicked on invoice, and Im getting the same error. In the URL it says http://www.worldofcomputersinc.com/product...gslip.php?oID=1

 

If I change the number 1 to number 2 I can se the invoice.

 

Hope that helps! I really need to get all of these bugs worked out as I go live at the end of may.

 

Thanks again for your help

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...