Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Vendors Products Report


marretjeca

Recommended Posts

Hi after several days searching everywhere, I give up. I installed MVS1.1 and it is working fine except for the Vendors Products Report page and the Orders by Vendor Page. Nothing happens: the drop down falls back to none, and no vendors are being shown.Because the shop is heavenly modified I installed a new fresh clean instance from oscommerce and installed just MVS1.1. To my great surprise the same thing happened.

After reading this post I tried to turn on and off register global in php.ini, but that did not help either.

 

Who can help me out here?

 

 

Thanks, Marja

 

:)

blafrog

Mar 14 2007, 04:54 AM

I have the same problems, no orders in order list, no products in Vendors Products Report, no emails sent etc.. because I installed register global patch (cause mine is set "OFF").

I finally got it working, just set register global on in php.ini. Some contributions not working, now they seem all working fine like, anti robot reg, super contact us enhancement..

 

<?php
/*
  $ID: prods_by_vendor.php (for use with MVS)
  by Craig Garrison Sr, BluCollar Sales
 for MVS V1.0 2006/03/25 JCK/CWG
 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]

 Copyright © 2006 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();
 $sort_by_filter2 = $sort_by_filter;
 if (!isset($sort_by_filter)) {
 $sort_by_filter = 'p.products_price';
 }
 if ($sort_by_filter == 'prod') {
 $sort_by_filter = 'pd.products_name';
 } elseif ($sort_by_filter == 'vpid'){
 $sort_by_filter = 'p.vendors_prod_id';
 } elseif ($sort_by_filter == 'pid'){
 $sort_by_filter = 'p.products_id';
 } elseif ($sort_by_filter == 'qty'){
 $sort_by_filter = 'p.products_quantity';
 } elseif ($sort_by_filter == 'vprice'){
 $sort_by_filter = 'p.vendors_product_price';
 } elseif ($sort_by_filter == 'price'){
 $sort_by_filter = 'p.products_price';
 }

?>
<!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">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
       </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><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 HEADING_TITLE; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
          <table border="0" width="100%" cellspacing="0" cellpadding="2">
           <tr>
           <?php
           //vendors_email start
   $vendors_array = array(array('id' => '1', 'text' => 'NONE'));
   $vendors_query = tep_db_query("select vendors_id, vendors_name from " . TABLE_VENDORS . " order by vendors_name");
   while ($vendors = tep_db_fetch_array($vendors_query)) {
     $vendors_array[] = array('id' => $vendors['vendors_id'],
                                    'text' => $vendors['vendors_name']);
   }
         ?>
               <td class="main" align="left"><?php echo TABLE_HEADING_VENDOR_CHOOSE . ' '; ?><?php echo tep_draw_form('vendors_report', FILENAME_PRODS_VENDORS) . tep_draw_pull_down_menu('vendors_id', $vendors_array,'','onChange="this.form.submit()";');?></form></td>
               <td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS) . '"><b>Go To Vendors List</a>';?>
    <td></tr>
    <tr>

           <td class="main" align="left"><br>
           <?php
           if ($show_order == 'desc') {
            echo 'Click for <a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $sort_by_filter . '&show_order=asc') . '"><b>ascending order</b></a>';
            } else {
           echo 'Click for <a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $sort_by_filter . '&show_order=desc') . '"><b>descending order</b></a>';
           }
           ?>
           </div></td>
             </tr>
           </table><?php
 if (isset($vendors_id)) { ?>
           <?php
 // $vendors_id = $HTTP_POST_VARS['vendors_id'];
 $vend_query_raw = "select vendors_name as name from " . TABLE_VENDORS . " where vendors_id = '" . $vendors_id . "'";
 $vend_query = tep_db_query($vend_query_raw);
 $vendors = tep_db_fetch_array($vend_query); ?>
       <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="1">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_VENDOR; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=prod') . '">' . TABLE_HEADING_PRODUCTS_NAME . '</a>'; ?> </td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=vpid') . '">' . TABLE_HEADING_VENDORS_PRODUCT_ID . '</a>'; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=pid') . '">' .  TABLE_HEADING_PRODUCTS_ID . '</a>'; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=qty') . '">' .  TABLE_HEADING_QUANTITY . '</a>'; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=vprice') . '">' .  TABLE_HEADING_VENDOR_PRICE . '</a>'; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=price') . '">' .  TABLE_HEADING_PRICE . '</a>'; ?></td>
             </tr>
             <tr class="dataTableRow">
    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS, '&vendors_id=' . $vendors_id . '&action=edit') . '" TARGET="_blank"><b>' . $vendors['name'] . '</a></b>'; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>

<?php
// if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS;
 $rows = 0;
         if($show_order == 'desc') {
 $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . " desc";
         } elseif ($show_order  == 'asc') {
  $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . " asc";
         } else {
   $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . "";
   }
/*  $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
 Decide not to use SPLIT pages for the $vendors_id variable not being maintained.
 */

 $products_query = tep_db_query($products_query_raw);
 while ($products = tep_db_fetch_array($products_query)) {
   $rows++;

   if (strlen($rows) < 2) {
     $rows = '0' . $rows;
   }
?>
              <tr class="dataTableRow">
               <?php if($products['vendors_prod_id']=='') {
                   $products['vendors_prod_id']= 'None Specified';
                   } ?>
               <td class="dataTableContent"><?php echo ''; ?></td>
               <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' . $products['products_id']) . '" TARGET="_blank"><b>' . $products['products_name'] . '</a></b>'; ?></td>
               <td class="dataTableContent"><?php echo $products['vendors_prod_id']; ?></td>
               <td class="dataTableContent"><?php echo $products['products_id']; ?></td>
               <td class="dataTableContent" align="left"><?php echo $products['products_quantity']; ?> </td>
               <td class="dataTableContent"><?php echo $products['vendors_product_price']; ?></td>
               <td class="dataTableContent"><?php echo $products['products_price']; ?></td>
                 </tr>
<?php
 }
 }
?>
           </table></td>
         </tr>
         <tr>
           <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr>
               <td class="smallText" valign="top"><?php
            //   echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
               ?></td>
               <td class="smallText" align="right"><?php
             //   echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'].$vendors_id);
                ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

Did you use the MVS 1.1 from 1 Apr 2006? If not, back off and start over. If you did, take a look at the /admin/vendors.php fix on the MVS distribution page. If you're still having problems, try searching the MVS forum thread for "Vendors Products Report".

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

  • 2 weeks later...
Did you use the MVS 1.1 from 1 Apr 2006? If not, back off and start over. If you did, take a look at the /admin/vendors.php fix on the MVS distribution page. If you're still having problems, try searching the MVS forum thread for "Vendors Products Report".

 

Regards

Jim

 

 

Thanks for the response, Yes i did use the mvs from 1 april 2006, and yes I did replace the /admin/vendors.php fix from the MVS distribution page.

The strange thing is that it is happening on both a heavenly modified install an d a brand new sqeaky clean install of OsCommerce.

 

Regards, Marja

Link to comment
Share on other sites

I seem to remeber a patch for this problem, and I thought it was in one of the patch files on the distribution page. I could be wrong about that; it may have only been posted in the MVS thread. A search through that thread should pick up the discussion of the fix at least.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

  • 2 weeks later...

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...