Jump to content

gaspower

Members
  • Content count

    453
  • Joined

  • Last visited

Posts posted by gaspower


  1. Hello,

    Below is what I get whn I click on the invoice buttonunder order view.

     

    webpage.jpg

     

    I did add a directory catalog/admin and uploaded all corresponding files? When I click on one of the broken images as a view image, I get;

     

    http://www.domain.com/images/borders/maingrey_02.gif

     

    But should be;

     

    http://www.domain.com/catalog/images/borders/maingrey_02.gif

     

    Some reason it is not putting "catalog"??

     

    Thanks JR


  2. Hello,

    I am trying to install Fancier Invoice, but having a little issue with getting the border images to show. I am sure it is because I do not have the path set correctly in configure.php. My complete path to catalog from root is:

     

    /var/www/domain.com/htdocs/catalog (catalog)

    /var/www/domain.com/htdocs/admin (admin)

     

    Fancier Invoice asks for absolute, can someone tell me what the correct path may be.

     

    // Folder Definitions

    define('DIR_FS_ADMIN', '/htdocs/admin/'); // absolute path required

    define('EMAIL_INVOICE_DIR', 'email_invoice/');

    define('INVOICE_TEMPLATE_DIR', 'templates/');

     

    // Email Invoice File Definitions

    define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');

    define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');

    define('FILENAME_ORDERS_INVOICE', 'invoice.php');

     

    Thanks JR


  3. Hello,

    I have installed the Fancier contribution, but for some reason the image borders are not showing. I am assuming that this is because I do not have the absolute path set correctly? I guess I need help with the absolute path, from root my path to catalog shows /var/www/xxxxxx.com/htdocs/catalog.

     

    Also, just curious should configure.php be in both catalog and admin? Or just catalog side.

     

    Thanks JR


  4. Hello,

    I have installed quick_priceupdates contribution and margin report contibution which puts a cost field in the database. I can add cost to a product through the regular admin screen, but would like to add a cost field to quick price. Below I have included my code, and where I have the table text box for cost denoted by <!-- Begin Products Cost //-->, but I am missing something that allows it to right to database. Also read from database. Any help would be greatly appreciated.

     

    Thanks JR

     

    <?php

    /*

    $Id: server_info.php,v 1.3 2002/03/16 01:36:56 hpdl Exp $

     

    osCommerce, Open Source E-Commerce Solutions

    http://www.oscommerce.com

     

    Copyright © 2002 osCommerce

     

    Released under the GNU General Public License

     

    Original Author: Mattice <mattice@xs4all.nl>

    Adaptations By: Mike Lessar <mlessar@bluetruck.net>

    Dustin Chambers <info@dllmodz.com>

    */

     

    require('includes/application_top.php');

     

    /// optional parameter to set max products per row:

    $max_cols = 3; //default 3

     

    /// optional parameter to set width of product & info display

    $width = 200; //default 200

     

    ?>

    <!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">

    <!-- 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">Quick Price Update</td>

     

    </tr>

    </table></td>

    </tr>

    <tr>

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

    <tr>

    <td>

     

    <table style="border:none" border="0" width="90%" align="center" class="none"><tr><td>

    <?php

    // we've done nothing cool yet...

    $msg_stack = 'Queried products from category';

     

    // Product Price (NET) BOC

    if ($HTTP_POST_VARS['price_update']) {

     

    //set counter

    $stock = 0;

    $status_a = 0;

    $status_d = 0;

     

     

    while (list($key, $value) = each($price_update)) {

     

    // update the quatity in stock

    $update = tep_db_query("UPDATE products SET products_price = $value WHERE products_id = $key");

    $stock_i++;

    }

    $msg_stack = '<br>Updated <br>"Products Price (Net)"</b>';

    }

    // Product Price (NET) EOC

     

    // Stock Update) BOC

    if ($HTTP_POST_VARS['stock_update']) {

     

    //set counter

    $stock_i = 0;

    $status_a = 0;

    $status_d = 0;

     

     

    while (list($key, $value) = each($stock_update)) {

     

    // update the quatity in stock

    $update = tep_db_query("UPDATE products SET products_quantity = $value WHERE products_id = $key");

    $stock_i++;

     

    // we're de-re-activating the selected products

    if ($HTTP_POST_VARS['update_status']) {

    if ($value >= 1 ) {

    $dereac = tep_db_query("UPDATE products SET products_status = 1 WHERE products_id = $key");

    $status_a++;

    }else{

    $dereac = tep_db_query("UPDATE products SET products_status = 0 WHERE products_id = $key");

    $status_d++;

    }

    }

    }

    $msg_stack = '<br>Total Products: ' . $stock_i . '<br># Active: ' . $status_a . '<br># Not Active: ' . $status_d;

    }

    // Stock Update EOC

     

    ?>

    <br><form method="post" action="quick_priceupdates.php">

    <?php

     

    // first select all categories that have 0 as parent:

    $sql = tep_db_query("SELECT c.categories_id, cd.categories_name from categories c, categories_description cd WHERE c.parent_id = 0 AND c.categories_id = cd.categories_id AND cd.language_id = 1");

    echo '<table border="0" align="center"><tr>';

    while ($parents = tep_db_fetch_array($sql)) {

    // check if the parent has products

    $check = tep_db_query("SELECT products_id FROM products_to_categories WHERE categories_id = '" . $parents['categories_id'] . "'");

     

    if (tep_db_num_rows($check) > 0) {

    echo "<!-- number of rows is greater than 0 -->\n";

    $tree = tep_get_category_tree();

    $dropdown= tep_draw_pull_down_menu('cat_id', $tree, '', 'onChange="this.form.submit();"'); //single

    $all_list = '<form method="post" action="quick_priceupdates.php"><th class="smallText" align="left" valign="top">All categories:<br>' . $dropdown . '</form></th>';

    } else {

    // get the tree for that parent

    $tree = tep_get_category_tree($parents['categories_id']);

    // draw a dropdown with it:

    $dropdown = tep_draw_pull_down_menu('cat_id', $tree, '', 'onChange="this.form.submit();"');

    $list .= '<form method="post" action="quick_priceupdates.php"><th class="smallText" align="left" valign="top">' . $parents['categories_name'] . '<br>' . $dropdown . '</form></th>';

    }

    }

    if($all_list){

    echo $all_list;

    }else{

    echo $list;

    }

    echo '</form></tr></table><p>';

     

    // see if there is a category ID:

     

    if ($HTTP_POST_VARS['cat_id']) {

     

    // start the table

    echo '<form method="post" action="quick_priceupdates.php"><table border="0" width="100%"><tr>';

    $i = 0;

     

    // get all active prods in that specific category

     

    $sql2 = tep_db_query("SELECT p.products_id,

    p.products_quantity,

    p.products_status,

    p.products_image,

    p.products_model,

    p.products_status,

    p.products_price,

    pd.products_name from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and language_id = $languages_id and ptc.categories_id = '" . $HTTP_POST_VARS['cat_id'] . "'");

     

    while ($results = tep_db_fetch_array($sql2)) {

    $i++;

     

    echo '<td width="'. $width . '" align="left" style="padding-top: 20px;">' . tep_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $results['products_image'], $results['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>';

    echo '<span class="smallText"><a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_POST_VARS['cat_id'] . '&pID=' . $results['products_id'] . '&action=new_product') . '">' . $results['products_name'] . '</a></span><br>';

    echo '<table>

    <tr>

    <td><span class="smallText">Products Model#: </span></td>

    <td><span class="smallText">' . $results['products_model'] . '</span></td>

    </tr>

     

     

    <tr>

    <td><span class="smallText">Products Price (Net): </span></td>

    <td>$<input type="text" size="7" name="price_update[' . $results['products_id'] . ']" value="' . $results['products_price'] . '"></td>

    </tr>

     

     

     

     

     

     

     

     

     

    <!-- Begin Products Cost //-->

    <tr>

    <td><span class="smallText">Products Price (Cost): </span></td>

    <td>$<input type="text" size="7" name="products_cost[' . $results['products_id'] . ']" value="' . $results['products_cost'] . '"></td>

     

    </tr>

     

    <!-- End Products Cost //-->

     

     

    <tr>

    <td><span class="smallText">Stock:</span></td>

    <td><input type="text" size="7" name="stock_update[' . $results['products_id'] . ']" value="' . $results['products_quantity'] . '"></td>

    </tr>

    <tr>

    <td><span class="smallText">Status:</span></td>

    <td><span class="smallText">' . (($results['products_status'] == 0) ? '<font color="ff0000"><b>Not Active</b></font>' : '<font color="009933"><b>Active</b></font>') . '</span></td>

    </tr>

    <tr>

    <td></td>

    <td></td>

    </tr>

    </table>

    <i></td>';

    echo '</i></td>';

    if ($i == $max_cols) {

    echo '</tr><tr>';

    $i =0;

    }

    }

    echo '<input type="hidden" name="cat_id" value="' . $HTTP_POST_VARS['cat_id'] . '">';

    echo '</tr><td align="center" colspan="10">';

    echo '<input type="checkbox" name="update_status"><span class="smallText">Confirm Status Change (active/not active)</span><p>';

    echo '<input type="submit" value="Update"></td></tr><td colspan="30" align="left"><font color="333333"><br><b>Last performed action:</b><br>' . $msg_stack . '</b></font></td></tr></form>';

    } //if

    ?>

    </tr></table>

     

     

    </td>

    </tr>

    </table></td>

    </tr>

    <tr>

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

    </tr>

    </table></td>

    <!-- body_text_eof //-->

    </tr>

    </table>

    <!-- body_eof //-->

     

    <!-- footer //-->

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

    <!-- footer_eof //-->

    <br>

    </body>

    </html>

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


  5. Hello,

    I have installed the quick price update contribution and it works fine, but I want to add a cost field to it. I already have a cost field in the standard admin layout and works fine if I enter a cost, it shows up and stays in the field. But I have added the below statement to the quick_priceupdates.php, and it do no add cost to database nor if I enter a cost in admin will it show up in the quick price?? Thanks for the help

     

    <tr>

    <td><span class="smallText">Products Price (Cost): </span></td>

    <td>$<input type="text" size="7" name="products_cost[' . $results['products_id'] . ']" value="' . $results['products_cost'] . '"></td>

     

    </tr>


  6. Hello,

    I have installed low stock level contribution, and it works fine, list all items and highlights items on low level. Was wondering if someone can help me change a few things. One, is it possible to only have it show items that are low level, verse showing all items. Also can it also print a report for ordering, listed by manufacures it items listed below for ordering.

     

    Thanks JR

×