Jump to content
Sign in to follow this  
marretjeca

Vendors Products Report

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'); ?>

Share this post


Link to post
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.

Share this post


Link to post
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

 

 

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

I am having the same problem here as well! No Vendor Reports. I also can not find anything in the forum.

 

Best

Zeno

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×