Would Like Add Field

gaspower · December 6, 2006

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

Released under the GNU General Public License

Original Author: Mattice <[email protected]>

Adaptations By: Mike Lessar <[email protected]>

Dustin Chambers <[email protected]>

*/

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

<head>

</head>

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

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

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

</table></td>

<tr>

<tr>

<td class="pageHeading">Quick Price Update</td>

</tr>

</table></td>

</tr>

<tr>

<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

?>

<?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 "\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>

</tr>

<tr>

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

</tr>

<tr>

<td><span class="smallText">Stock:</span></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>

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

</tr>

</table></td>

</tr>

</table>

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

<br>

</body>

</html>

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

Would Like Add Field

Recommended Posts

gaspower

Join the conversation

Browse

Activity