Code:
<?php
<?php
require('includes/application_top.php');
if (isset($_GET['action']) || isset($_POST['action'])) {
$action = (isset($_POST['action'])) ? zen_db_prepare_input($_POST['action']) : zen_db_prepare_input($_GET['action']);
$action = preg_replace("/[^a-z0-9\-\_]+/i", "", $action);
} else {
$action = "";
} // End of if statement.
//// Tax Row
$tax_class_array = array();
$tax_class_query = $db->Execute("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");
$tax_class = new objectInfo($tax_class_query->fields);
while ($tax_class->EOF) {
$tax_class_array[] = array('id' => $tax_class->tax_class_id, 'text' => $tax_class->tax_class_title);
$tax_class->MoveNext();
}
////Info Row
$manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER));
$manufacturers_query = $db->Execute("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
$nanufacturers = new objectInfo($manufacturers_query->fields);
$manufacturers_array[] = array('id' => $manufacturers->manufacturers_id, 'text' => $manufacturers->manufacturers_name);
}
##// Update database
switch ($action) {
case 'add' :
$products_added = 0;
$product_name = (isset($_POST['product_name'])) ? zen_db_prepare_input($_POST['product_name']) : '';
$product_image = (isset($_POST['product_image'])) ? zen_db_prepare_input($_POST['product_image']) : '';
$product_quantity = (isset($_POST['product_quantity'])) ? zen_db_prepare_input($_POST['product_quantity']) : 0;
$product_model = (isset($_POST['product_model'])) ? zen_db_prepare_input($_POST['product_model']) : '';
$product_price = (isset($_POST['product_price'])) ? zen_db_prepare_input($_POST['product_price']) : '';
$product_weight = (isset($_POST['product_weight'])) ? zen_db_prepare_input($_POST['product_weight']) : '';
$product_status = (isset($_POST['product_status'])) ? zen_db_prepare_input($_POST['product_status']) : '';
$product_tax = (isset($_POST['product_tax'])) ? zen_db_prepare_input($_POST['product_tax']) : '';
$product_manufacturer = (isset($_POST['product_manufacturer'])) ? zen_db_prepare_input($_POST['product_manufacturer']) : '';
$product_categories = (isset($_POST['product_categories'])) ? zen_db_prepare_input($_POST['product_categories']) : '';
$product_description = (isset($_POST['product_description'])) ? zen_db_prepare_input($_POST['product_description']) : '';
for ($i = 1; $i <= MAX_PRODUCTS; $i++) {
$valid = false; $product_exist = false;
if(isset($product_name) && $product_name[$i]){
foreach($product_name[$i] as $id => $product_language_name){
if($product_language_name != ''){
if(!$product_exist){
if(strrchr($product_name][$i], '\\'))$image = substr(strrchr($product_image][$i])), '\\', 1;else $image = substr(strrchr($product_image][$i])), '/', 1;
$db->Execute("INSERT INTO " . TABLE_PRODUCTS . " (products_quantity, products_model, products_image, products_price, products_weight, products_status, products_tax_class_id, manufacturers_id) VALUES (" . $product_quantity[$i] . ", '" . $product_model[$i] . "', '" . $image . "', " . $product_price[$i] . ", " . $product_weight[$i] . ", ". $product_status[$i] . ", " . $product_tax[$i] . ", " . $product_manufacturer[$i] . ");");
$products_id_query = $db->Execute("SELECT products_id from " . TABLE_PRODUCTS . " WHERE products_quantity=" . $product_quantity[$i] ." and products_model='" . $product_model[$i] ."' and products_price=" . $product_price[$i] . " and products_weight=" . $product_weight[$i] . " and products_image='" . $image . "' and products_status=" . $product_status[$i] . " and products_tax_class_id=" . $product_tax[$i] . " and manufacturers_id=" . $product_manufacturer[$i] . ";");
$products_id = new objectInfo($products_id_query->fields);
$db->Execute("INSERT INTO " . TABLE_PRODUCTS_TO_CATEGORIES . " VALUES ('" . $products_id->products_id . "', '" . $product_categories[$i] . "');");
}
$db->Execute("INSERT INTO " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description) VALUES ('" . $products_id->products_id . "', '" . $languages[$i][$id] . "', '" . $product_language_name . "', '" . $product_description[$i][$id] . "');");
$product_exist = true;
$valid = true;
}
}
}
if($valid)$products_added++;
}
$messageStack->add($products_added . ' ' . TEXT_PRODUCTS_ADDED , 'success');
break;
}
##// Let's start displaying page with forms
?>
<!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 //-->
<script language="javascript">
<!--
var browser_family;
var up = 1;
if (document.all && !document.getElementById)
browser_family = "dom2";
else if (document.layers)
browser_family = "ns4";
else if (document.getElementById)
browser_family = "dom2";
else
browser_family = "other";
function display_ttc(action, prix, taxe, up){
if(action == 'display'){
if(up != 1)
valeur = Math.round((prix + (taxe / 100) * prix) * 100) / 100;
}else{
if(action == 'keyup'){
valeur = Math.round((parseFloat(prix) + (taxe / 100) * parseFloat(prix)) * 100) / 100;
}else{
valeur = '0';
}
}
switch (browser_family){
case 'dom2':
document.getElementById('descDiv').innerHTML = 'TTC : '+valeur;
break;
case 'ie4':
document.all.descDiv.innerHTML = 'TTC : '+valeur;
break;
case 'ns4':
document.descDiv.document.descDiv_sub.document.wri te(valeur);
document.descDiv.document.descDiv_sub.document.clo se();
break;
case 'other':
break;
}
}
-->
</script>
<!-- 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" colspan="3" valign="top"><?php echo HEADING_TITLE . "<br><br>"; ?></td>
</tr>
</table></td></tr>
<tr><td align="center">
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr align="center">
<form name="add" method="POST" action="<?php echo "$PHP_SELF?action=add"; ?>">
<td class="smalltext" align="middle"><?php echo WARNING_MESSAGE; ?> </td>
<?php echo "<td class=\"pageHeading\" align=\"right\">" . '<script language="javascript"><!--
switch (browser_family)
{
case "dom2":
case "ie4":
document.write(\'<div id="descDiv">\');
break;
default:
document.write(\'<ilayer id="descDiv"><layer id="descDiv_sub">\');
break;
}
-->
</script>' . "</td>\n";
?>
<td align="right" valign="middle"><?php echo zen_draw_image_submit('button_update.gif', IMAGE_UPDATE, "action=add");?></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 class="dataTableHeadingRow">
<td class="dataTableHeadingContent" align="left" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_MODEL ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="middle" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_PRODUCTS ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_STATUS ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_WEIGHT ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_QUANTITY ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_IMAGE ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_MANUFACTURERS ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_CATEGORIES ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_PRICE ."</td>"; ?>
</tr>
</table>
</td>
<td class="dataTableHeadingContent" align="center" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<?php echo "<td class=\"dataTableHeadingContent\" align=\"center\" valign=\"middle\">" .TABLE_HEADING_TAX ."</td>"; ?>
</tr>
</table>
</td>
</tr>
<tr class="datatableRow">
<?php
for ($i = 1; $i <= MAX_PRODUCTS; $i++) {
echo '<tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';t his.style.cursor=\'hand\'" onmouseout="'; if(DISPLAY_TVA_OVER == 'true'){echo 'display_ttc(\'delete\');';} echo 'this.className=\'dataTableRow\'">';
echo "<td class=\"smallText\" align=\"center\"><input type=\"text\" size=\"10\" name=\"product_model[".$i."]\"></td>\n";
// The name in all languages.
echo "<td class=\"smallText\" align=\"center\">";
echo '<table border="0" cellspacing="0" cellpadding="0">';
$languages_query = $db->Execute("select languages_id, name, image, directory from " . TABLE_LANGUAGES . " order by sort_order ASC");
$languages = new objectInfo($languages_query->fields);
while($languages->EOF){
echo '<tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';t his.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'"><td class="smallText" align="center">';
echo "<input type=\"text\" size=\"25\" name=\"product_name[".$i."][".$languages->languages_id."]\">" . ' ' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages->directory . '/images/' . $languages->image, $languages->name) . " <input type=\"text\" size=\"25\" name=\"product_description[".$i."][".$languages->languages_id."]\">" . ' ' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages->directory . '/images/' . $languages->image, $languages->name);
echo zen_draw_hidden_field('languages['.$i.']['.$languages->languages_id . ']',$languages->languages_id);
echo '</td></tr>';
$languages->MoveNext();
}
echo "</table></td>\n";
echo "<td class=\"smallText\" align=\"center\"><input type=\"radio\" name=\"product_status[".$i."]\" value=\"0\" ><input type=\"radio\" name=\"product_status[".$i."]\" value=\"1\" checked ></td>\n";
echo "<td class=\"smallText\" align=\"center\"><input type=\"text\" size=\"4\" name=\"product_weight[".$i."]\" value=0.00></td>\n";
echo "<td class=\"smallText\" align=\"center\"><input type=\"text\" size=\"2\" name=\"product_quantity[".$i."]\" value=0></td>\n";
echo "<td class=\"smallText\" align=\"center\">" . zen_draw_input_field('product_image['.$i.']') . " </td>\n";
echo "<td class=\"smallText\" align=\"center\">" . zen_draw_pull_down_menu("product_manufacturer[".$i."]", $manufacturers_array, $products_id->manufacturers_id)."</td>\n";
echo "<td class=\"smallText\" align=\"center\">" . zen_draw_pull_down_menu("product_categories[".$i."]", zen_get_category_tree());
echo "<td class=\"smallText\" align=\"center\"> <input type=\"text\" size=\"6\" name=\"product_price[".$i."]\" value=0.0000 "; if(DISPLAY_TVA_UP == 'true'){ echo "onKeyUp=\"display_ttc('keyup', this.value" . ", " . ALL_INCLUDED_TAX_VALUE . ", 1);\"";} echo "></td>\n";
echo "<td class=\"smallText\" align=\"center\">" . zen_draw_pull_down_menu("product_tax[".$i."]", $tax_class_array, $products_id->products_tax_class_id)."</td>\n";
}
echo "</table>\n";
?>
</td>
</tr>
<tr>
<td align="right">
<?php
echo zen_image_submit('button_update.gif', IMAGE_UPDATE);
echo ' <a href="' . zen_href_link(FILENAME_QUICK_ADD_PRODUCTS) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';
?>
</td>
</tr>
</form>
</table>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
</tr>
</table>
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Bookmarks