Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders not showing in admin


bluestallion

Recommended Posts

Posted

I just can't seemed to figure out why the order status is not showing in the admin section as shown below.

 

I have restored the database, replaced the entire admin section but it still doesn't show.

 

However, I can still receive the orders via emails and it is captured in the database.

 

What could be the problem?

 

adminscreenshot.gif

 

I would appreciate if anybody could help me on this.

Posted

My adminindex.php file has the related following code on that particular orders area:

 

<?php

 $heading = array();

 $contents = array();



 $heading[] = array('params' => 'class="menuBoxHeading"',

                    'text'  => 'osCommerce');



 $contents[] = array('params' => 'class="infoBox"',

                     'text'  => '<a href="http://www.oscommerce.com" target="_blank">' . BOX_ENTRY_SUPPORT_SITE . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/forum" target="_blank">' . BOX_ENTRY_SUPPORT_FORUMS . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/mlists" target="_blank">' . BOX_ENTRY_MAILING_LISTS . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/bugs" target="_blank">' . BOX_ENTRY_BUG_REPORTS . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/faq" target="_blank">' . BOX_ENTRY_FAQ . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/irc" target="_blank">' . BOX_ENTRY_LIVE_DISCUSSIONS . '</a><br>' .

                                '<a href="http://www.oscommerce.com/community.php/cvs" target="_blank">' . BOX_ENTRY_CVS_REPOSITORY . '</a><br>' .

                                '<a href="http://www.oscommerce.com/about.php/portal" target="_blank">' . BOX_ENTRY_INFORMATION_PORTAL . '</a>');



 $box = new box;

 echo $box->menuBox($heading, $contents);



 echo '<br>';



 $orders_contents = '';

 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");

 while ($orders_status = tep_db_fetch_array($orders_status_query)) {

   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");

   $orders_pending = tep_db_fetch_array($orders_pending_query);

   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';

 }

 $orders_contents = substr($orders_contents, 0, -4);



 $heading = array();

 $contents = array();



 $heading[] = array('params' => 'class="menuBoxHeading"',

                    'text'  => BOX_TITLE_ORDERS);



 $contents[] = array('params' => 'class="infoBox"',

                     'text'  => $orders_contents);



 $box = new box;

 echo $box->menuBox($heading, $contents);



 echo '<br>';



 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);

 $customers = tep_db_fetch_array($customers_query);

 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");

 $products = tep_db_fetch_array($products_query);

 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);

 $reviews = tep_db_fetch_array($reviews_query);



 $heading = array();

 $contents = array();



 $heading[] = array('params' => 'class="menuBoxHeading"',

                    'text'  => BOX_TITLE_STATISTICS);



 $contents[] = array('params' => 'class="infoBox"',

                     'text'  => BOX_ENTRY_CUSTOMERS . ' ' . $customers['count'] . '<br>' .

                                BOX_ENTRY_PRODUCTS . ' ' . $products['count'] . '<br>' .

                                BOX_ENTRY_REVIEWS . ' ' . $reviews['count']);



 $box = new box;

 echo $box->menuBox($heading, $contents);

?>

 

Is this the right code?

Archived

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

×
×
  • Create New...