0
I have this file below to do a mass price update for SPPC groups. I am using OSC2.31, but for some reason it is not updating the database tables? I am not getting any errors. If the file looks correct, can the database permissions be set incorrectly?
Thanks JR
<?php
require('includes/application_top.php');
?>
<!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" onload="SetFocus();">
<div id="popupcalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'template_top.php'); ?>
<!-- header_eof //-->
<?php
if (isset($_POST['Update']))
{
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
if ($sppc["customers_group_name"] != "Retail"){
//$sppc['customers_group_id']
$c = "CG_".$sppc['customers_group_id'];
$tmp = $_POST[$c];
if ($tmp != 0)
{
$p = (100-$_POST[$c])/100;
tep_db_query("delete from products_groups where customers_group_id = ".$sppc['customers_group_id']);
tep_db_query ("insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p");
} //if not 0
} //if not Retail
}
}
?>
<!-- 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">
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo "Special Pricing Discount Setup"; ?></td>
<td class="specialPrice" align="right"> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" align="left">
<?php
if (isset($_POST['Update']))
{
echo "<center>Updated!</center>";
}
?>
</td>
</tr>
<?php
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
?>
<tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
<td class="dataTableContent" align="left">
<?php
if ($sppc["customers_group_name"] != "Retail"){
echo $sppc["customers_group_name"];
}
if (isset($_POST['Update']))
{
if ($sppc["customers_group_name"] != "Retail"){
$c = "CG_".$sppc['customers_group_id'];
$tmp = $_POST[$c];
echo " Current Discount is $tmp%" ;
}
}
?>
</td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr>
<td valign="top">
<form action="" method="post">
<table border="0" width="40%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText" align="left"> </td>
<td> </td>
</tr>
<?php
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
if ($sppc["customers_group_name"] != "Retail"){
?>
<tr>
<td class="smallText" align="left">Set New Percentage (%) Discount for <?=$sppc["customers_group_name"]?> :</td>
<td><input name="CG_<?=$sppc['customers_group_id']?>" type="text" size="5" value="0"></td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="2" align="center"><input type="submit" name="Update" value="Update"></td>
</tr>
</table>
</form>
</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'); ?>
