<?php
/* ----------------------------------------------------------------------
   $Id: products.php,v 1.7 2008/01/25 10:29:54 r23 Exp $

   OOS [OSIS Online Shop]
   http://www.oos-shop.de/

   Copyright (c) 2003 - 2008 by the OOS Development Team.
   ----------------------------------------------------------------------
   Based on:

   File: categories.php,v 1.146 2003/07/11 14:40:27 hpdl
         categories.php,v 1.138 2002/11/18 21:38:22 dgw_
   ----------------------------------------------------------------------
   osCommerce, Open Source E-Commerce Solutions
   http://www.oscommerce.com

   Copyright (c) 2003 osCommerce
   ----------------------------------------------------------------------
   Released under the GNU General Public License
   ---------------------------------------------------------------------- */

  define('OOS_VALID_MOD', 'yes');
  require 'includes/oos_main.php';

  require OOS_FUNCTIONS . 'function_categories.php';
  require OOS_FUNCTIONS . 'function_image_resize.php';

  require OOS_CLASSES . 'class_currencies.php';
  $currencies = new currencies();

  $action = (isset($_GET['action']) ? $_GET['action'] : '');

  if (!empty($action)) {
    switch ($action) {
      case 'insert_product':
      case 'update_product':

        if (NEW_PRODUCT_PREVIEW == 'false') {
          if ( ($_POST['products_image'] != 'none') && (isset($_FILES['products_image'])) ) {
            $products_image = oosGetUploadedFile('products_image');
            $image_directory = oosGetLocalPath(OOS_SHOP_PATH_IMAGES);
          }
          if (is_uploaded_file($products_image['tmp_name'])) {
            $products_image = oosCopyUploadedFile($products_image, $image_directory);
            if (OOS_IMAGE_SWF == 'true') {
              include OOS_CLASSES . 'class_image2swf.php';
              $swf = new Image2swf;
              $filename = split("[/\\.]", $products_image_name);
              $swf->Main(OOS_SHOP_PATH_IMAGES . $products_image_name, $filename[0]);  
            }
          } else {
            $products_image = oosDBPrepareInput($_POST['products_previous_image']);
          }

          // copy subimage1 only if modified
          if ( ($_POST['products_subimage1'] != 'none') && (isset($_FILES['products_subimage1'])) ) {
            $products_subimage1 = oosGetUploadedFile('products_subimage1');
            $subimage1_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage1['tmp_name'])) {
            $products_subimage1 = oosCopyUploadedFile($products_subimage1, $subimage1_directory);
          } else {
            $products_subimage1 = oosDBPrepareInput($_POST['products_previous_subimage1']);
          }

          // copy subimage2 only if modified
          if ( ($_POST['products_subimage2'] != 'none') && (isset($_FILES['products_subimage2'])) ) {
            $products_subimage2 = oosGetUploadedFile('products_subimage2');
            $subimage2_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage2['tmp_name'])) {
            $products_subimage2 = oosCopyUploadedFile($products_subimage2, $subimage2_directory);
          } else {
            $products_subimage2 = oosDBPrepareInput($_POST['products_previous_subimage2']);
          }

          // copy subimage3 only if modified
          if ( ($_POST['products_subimage3'] != 'none') && (isset($_FILES['products_subimage3'])) ) {
            $products_subimage3 = oosGetUploadedFile('products_subimage3');
            $subimage3_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage3['tmp_name'])) {
            $products_subimage3 = oosCopyUploadedFile($products_subimage3, $subimage3_directory);
          } else {
            $products_subimage3 = oosDBPrepareInput($_POST['products_previous_subimage3']);
          }

          // copy subimage4 only if modified
          if ( ($_POST['products_subimage4'] != 'none') && (isset($_FILES['products_subimage4'])) ) {
            $products_subimage4 = oosGetUploadedFile('products_subimage4');
            $subimage4_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage4['tmp_name'])) {
            $products_subimage4 = oosCopyUploadedFile($products_subimage4, $subimage4_directory);
          } else {
            $products_subimage4 = oosDBPrepareInput($_POST['products_previous_subimage4']);
          }

          // copy subimage5 only if modified
          if ( ($_POST['products_subimage5'] != 'none') && (isset($_FILES['products_subimage5'])) ) {
            $products_subimage5 = oosGetUploadedFile('products_subimage5');
            $subimage5_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage5['tmp_name'])) {
            $products_subimage5 = oosCopyUploadedFile($products_subimage5, $subimage5_directory);
          } else {
            $products_subimage5 = oosDBPrepareInput($_POST['products_previous_subimage5']);
          }

          // copy subimage6 only if modified
          if ( ($_POST['products_subimage6'] != 'none') && (isset($_FILES['products_subimage6'])) ) {
            $products_subimage6 = oosGetUploadedFile('products_subimage6');
            $subimage6_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
          }
          if (is_uploaded_file($products_subimage6['tmp_name'])) {
            $products_subimage6 = oosCopyUploadedFile($products_subimage6, $subimage6_directory);
          } else {
            $products_subimage6 = oosDBPrepareInput($_POST['products_previous_subimage6']);
          }
        }

        if (OOS_PRICE_IS_BRUTTO == 'true' && $_POST['products_price']){
          $tax_result = $db->Execute("SELECT tax_rate FROM " . $oosDBTable['tax_rates'] . " WHERE tax_class_id = '".$_POST['products_tax_class_id']."' ");
          $tax = $tax_result->fields;
          $_POST['products_price'] = ($_POST['products_price']/($tax[tax_rate]+100)*100);
          $_POST['products_price_list'] = ($_POST['products_price_list']/($tax[tax_rate]+100)*100);
          $_POST['products_discount1'] = ($_POST['products_discount1']/($tax[tax_rate]+100)*100);
          $_POST['products_discount2'] = ($_POST['products_discount2']/($tax[tax_rate]+100)*100);
          $_POST['products_discount3'] = ($_POST['products_discount3']/($tax[tax_rate]+100)*100);
          $_POST['products_discount4'] = ($_POST['products_discount4']/($tax[tax_rate]+100)*100);
        }
        if ( isset($_POST['edit_x']) || isset($_POST['edit_y']) ) {
          $action = 'new_product';
        } else {
          if ($_POST['delete_image'] == 'yes') {
            if (oosDuplicateProductImageCheck($products_image)) {
              oosRemoveProductImage($products_image);
            }
          }
          if ($_POST['delete_subimage1'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage1)) {
              oosRemoveProductSubimage($products_subimage1);
            }
          }
          if ($_POST['delete_subimage2'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage2)) {
              oosRemoveProductSubimage($products_subimage2);
            }
          }
          if ($_POST['delete_subimage3'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage3)) {
              oosRemoveProductSubimage($products_subimage3);
            }
          }
          if ($_POST['delete_subimage4'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage4)) {
              oosRemoveProductSubimage($products_subimage4);
            }
          }
          if ($_POST['delete_subimage5'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage5)) {
              oosRemoveProductSubimage($products_subimage5);
            }
          }
          if ($_POST['delete_subimage6'] == 'yes') {
            if (oosDuplicateProductSubimageCheck($products_subimage6)) {
              oosRemoveProductSubimage($products_subimage6);
            }
          }
          if ( ($_POST['delete_image'] == 'yes') || ($_POST['remove_image'] == 'yes') ) {
            $products_image = 'none';
          }
          if ( ($_POST['delete_subimage1'] == 'yes') || ($_POST['remove_subimage1'] == 'yes') ) {
            $products_subimage1 = 'none';
          }
          if ( ($_POST['delete_subimage2'] == 'yes') || ($_POST['remove_subimage2'] == 'yes') ) {
            $products_subimage2 = 'none';
          }
          if ( ($_POST['delete_subimage3'] == 'yes') || ($_POST['remove_subimage3'] == 'yes') ) {
            $products_subimage3 = 'none';
          }
          if ( ($_POST['delete_subimage4'] == 'yes') || ($_POST['remove_subimage4'] == 'yes') ) {
            $products_subimage4 = 'none';
          }
          if ( ($_POST['delete_subimage5'] == 'yes') || ($_POST['remove_subimage5'] == 'yes') ) {
            $products_subimage5 = 'none';
          }
          if ( ($_POST['delete_subimage6'] == 'yes') || ($_POST['remove_subimage6'] == 'yes') ) {
            $products_subimage6 = 'none';
          }

          $products_id = oosDBPrepareInput($_GET['pID']);
          $products_date_available = oosDBPrepareInput($_POST['products_date_available']);

          if (isset($_POST['products_base_price']) ) {
            $products_base_price = oosDBPrepareInput($_POST['products_base_price']);
            $products_product_quantity = oosDBPrepareInput($_POST['products_product_quantity']);
            $products_base_quantity = oosDBPrepareInput($_POST['products_base_quantity']);
            $products_base_unit = oosDBPrepareInput($_POST['products_base_unit']);
          } else {
            $products_base_price = 1.0;
            $products_product_quantity = 1.0;
            $products_base_quantity = 1.0;
            $products_base_unit = '';
          }
          $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';

          $sql_data_array = array('products_quantity' => oosDBPrepareInput($_POST['products_quantity']),
                                  'products_reorder_level' => oosDBPrepareInput($_POST['products_reorder_level']),
                                  'products_model' => oosDBPrepareInput($_POST['products_model']),
                                  'products_ean' => oosDBPrepareInput($_POST['products_ean']),
                                  'products_image' => (($products_image == 'none') ? '' : oosDBPrepareInput($products_image)),
                                  'products_subimage1' => (($products_subimage1 == 'none') ? '' : oosDBPrepareInput($products_subimage1)),
                                  'products_subimage2' => (($products_subimage2 == 'none') ? '' : oosDBPrepareInput($products_subimage2)),
                                  'products_subimage3' => (($products_subimage3 == 'none') ? '' : oosDBPrepareInput($products_subimage3)),
                                  'products_subimage4' => (($products_subimage4 == 'none') ? '' : oosDBPrepareInput($products_subimage4)),
                                  'products_subimage5' => (($products_subimage5 == 'none') ? '' : oosDBPrepareInput($products_subimage5)),
                                  'products_subimage6' => (($products_subimage6 == 'none') ? '' : oosDBPrepareInput($products_subimage6)),
                                  'products_price' => oosDBPrepareInput($_POST['products_price']),
                                  'products_base_price' => $products_base_price,
                                  'products_product_quantity' => $products_product_quantity,
                                  'products_base_quantity' => $products_base_quantity,
                                  'products_base_unit' => $products_base_unit,
                                  'products_date_available' => $products_date_available,
                                  'products_weight' => oosDBPrepareInput($_POST['products_weight']),
                                  'products_status' => oosDBPrepareInput($_POST['products_status']),
                                  'products_tax_class_id' => oosDBPrepareInput($_POST['products_tax_class_id']),
                                  'manufacturers_id' => oosDBPrepareInput($_POST['manufacturers_id']),
                                  'products_price_list' => oosDBPrepareInput($_POST['products_price_list']),
                                  'products_discount_allowed' => oosDBPrepareInput($_POST['products_discount_allowed']),
                                  'products_quantity_order_min' => oosDBPrepareInput($_POST['products_quantity_order_min']),
                                  'products_quantity_order_units' => oosDBPrepareInput($_POST['products_quantity_order_units']),
                                  'products_discount1' => oosDBPrepareInput($_POST['products_discount1']),
                                  'products_discount1_qty' => oosDBPrepareInput($_POST['products_discount1_qty']),
                                  'products_discount2' => oosDBPrepareInput($_POST['products_discount2']),
                                  'products_discount2_qty' => oosDBPrepareInput($_POST['products_discount2_qty']),
                                  'products_discount3' => oosDBPrepareInput($_POST['products_discount3']),
                                  'products_discount3_qty' => oosDBPrepareInput($_POST['products_discount3_qty']),
                                  'products_discount4' => oosDBPrepareInput($_POST['products_discount4']),
                                  'products_discount4_qty' => oosDBPrepareInput($_POST['products_discount4_qty']),
                                  'products_sort_order' => oosDBPrepareInput($_POST['products_sort_order']),
                                  );

          if ($action == 'insert_product') {
            $insert_sql_data = array('products_date_added' => 'now()');

            $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

            oosDBPerform($oosDBTable['products'], $sql_data_array);
            $products_id = $db->Insert_ID();

            if (MULTIPLE_CATEGORIES_USE == 'false') {
              $db->Execute("INSERT INTO " . $oosDBTable['products_to_categories'] . " (products_id, categories_id) VALUES ('" . $products_id . "', '" . $current_category_id . "')");
            }

          } elseif ($action == 'update_product') {
            $update_sql_data = array('products_last_modified' => 'now()');

            $sql_data_array = array_merge($sql_data_array, $update_sql_data);

            oosDBPerform($oosDBTable['products'], $sql_data_array, 'update', 'products_id = \'' . oosDBInput($products_id) . '\'');

            if (MULTIPLE_CATEGORIES_USE == 'true') {
              $db->Execute("DELETE FROM " . $oosDBTable['products_to_categories'] . " WHERE products_id = '". $products_id . "'");
            }
          }
          if (MULTIPLE_CATEGORIES_USE == 'true') {
            if (isset($_POST['categories_ids']) && !empty($_POST['categories_ids']) && is_array($_POST['categories_ids'])) {
              $selected_catids = $_POST['categories_ids'];
            } else {
              $selected_catids = array('0');
            }
            foreach ($selected_catids as $current_category_id)  {
              $db->Execute("INSERT INTO " . $oosDBTable['products_to_categories'] . " (products_id, categories_id) values ('" . $products_id . "', '" . $current_category_id . "')");
            }
          }
          if (!oosNotNull($_GET['cPath'])) {
            $cPath = $current_category_id;
          }

          $languages = oosGetLanguages();
          for ($i = 0, $n = count($languages); $i < $n; $i++) {
            $lang_id = $languages[$i]['id'];

            $sql_data_array = array('products_name' => oosDBPrepareInput($_POST['products_name'][$lang_id]),
                                    'products_description' => oosDBPrepareInput($_POST['products_description_' .$languages[$i]['id']]),
                                    'products_description_meta' => oosDBPrepareInput($_POST['products_description_meta_' .$languages[$i]['id']]),
                                    'products_keywords_meta' => oosDBPrepareInput($_POST['products_keywords_meta_' .$languages[$i]['id']]),
                                    'products_url' => oosDBPrepareInput($_POST['products_url'][$lang_id]));

            if ($action == 'insert_product') {
              $insert_sql_data = array('products_id' => $products_id,
                                       'products_languages_id' => $lang_id);

              $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

              oosDBPerform($oosDBTable['products_description'], $sql_data_array);
            } elseif ($action == 'update_product') {
              oosDBPerform($oosDBTable['products_description'], $sql_data_array, 'update', 'products_id = \'' . oosDBInput($products_id) . '\' and products_languages_id = \'' . $lang_id . '\'');
            }
          }
          oosRedirect(oosLink($aFilename['categories'], 'cPath=' . $cPath . '&pID=' . $products_id));
        }
        break;

    }
  }

// check if the catalog image directory exists
  if (is_dir(OOS_SHOP_PATH_IMAGES)) {
    if (!is_writeable(OOS_SHOP_PATH_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error');
  } else {
    $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error');
  }
  $no_js_general = true;
  require OOS_INCLUDES . 'oos_header.php';

?>
<script language="javascript"><!--
function popupImageWindow(url) {
  window.open(url,'popupImageWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
<div id="spiffycalendar" class="text"></div>
<!-- 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">
<?php require OOS_INCLUDES . 'oos_blocks.php'; ?>
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
  if ($action == 'new_product') {
    if (isset($_GET['pID']) && empty($_POST)) {
      $product_result = $db->Execute("SELECT 
                                         pd.products_name, pd.products_description, pd.products_url,
                                         pd.products_description_meta, pd.products_keywords_meta, p.products_id,
                                         p.products_quantity, p.products_reorder_level, p.products_model,
                                         p.products_ean, p.products_image, p.products_subimage1, 
                                         p.products_subimage2, p.products_subimage3, p.products_subimage4,
                                         p.products_subimage5, p.products_subimage6, 
                                         p.products_price, p.products_base_price, p.products_base_quantity,
                                         p.products_product_quantity, p.products_base_unit,
                                         p.products_weight, p.products_date_added, p.products_last_modified,
                                         date_format(p.products_date_available, '%Y-%m-%d') AS products_date_available,
                                         p.products_status, p.products_tax_class_id, p.manufacturers_id,
                                         p.products_price_list, p.products_discount_allowed,
                                         p.products_quantity_order_min, p.products_quantity_order_units,
                                         p.products_discount1, p.products_discount2, p.products_discount3,
                                         p.products_discount4, p.products_discount1_qty, p.products_discount2_qty,
                                         p.products_discount3_qty, p.products_discount4_qty, p.products_sort_order
                                     FROM 
                                         " . $oosDBTable['products'] . " p,
                                         " . $oosDBTable['products_description'] . " pd
                                     WHERE 
                                         p.products_id = '" . $_GET['pID'] . "' AND
                                         p.products_id = pd.products_id AND
                                         pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'");
      $product = $product_result->fields;

      $pInfo = new objectInfo($product);
    } elseif (oosNotNull($_POST)) {
      $pInfo = new objectInfo($_POST);
      $products_name = $_POST['products_name'];
      $products_description = $_POST['products_description'];
      $products_description_meta = $_POST['products_description_meta'];
      $products_keywords_meta = $_POST['products_keywords_meta'];
      $products_url = $_POST['products_url'];
    } else {
      $pInfo = new objectInfo(array());
      $pInfo->products_status = DEFAULT_PRODUTS_STATUS_ID;
      $pInfo->products_base_price = 1.0;
      $pInfo->products_product_quantity = 1.0;
      $pInfo->products_base_quantity = 1.0;
    }

    $manufacturers_array = array();
    $manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
    $manufacturers_result = $db->Execute("SELECT manufacturers_id, manufacturers_name FROM " . $oosDBTable['manufacturers'] . " ORDER BY manufacturers_name");
    while ($manufacturers = $manufacturers_result->fields) {
      $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],
                                     'text' => $manufacturers['manufacturers_name']);
      $manufacturers_result->MoveNext();
    }
    if (MULTIPLE_CATEGORIES_USE == 'true') {
      $categories_array_selected = array(array('id' => ''));
      if (isset($_GET['action']) && ($_GET['action'] == 'new_product') && (isset($_GET['cPath'])) )  {
        $categories_array_selected = array(array('id' => (int)$_GET['cPath']));
      }
      $categories_result_selected = $db->Execute("SELECT categories_id FROM " . $oosDBTable['products_to_categories'] . " WHERE products_id = '" . $_GET['pID'] . "'");
      while ($categories_selected = $categories_result_selected->fields) {
        $categories_array_selected[] = array('id' => $categories_selected['categories_id']);
        $categories_result_selected->MoveNext();
      }

      $categories_array = array(array('id' => '', 'text' => TEXT_NONE));
      $categories_array = oosGetCategoryTree();
    }

    $tax_class_array = array();
    $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $tax_class_result = $db->Execute("SELECT tax_class_id, tax_class_title FROM " . $oosDBTable['tax_class'] . " ORDER BY tax_class_title");
    while ($tax_class = $tax_class_result->fields) {
      $tax_class_array[] = array('id' => $tax_class['tax_class_id'],
                                 'text' => $tax_class['tax_class_title']);
      $tax_class_result->MoveNext();
    }

    $products_status_array = array();
    $products_status_array = array(array('id' => '0', 'text' => TEXT_PRODUCT_NOT_AVAILABLE));
    $products_status_result = $db->Execute("SELECT products_status_id, products_status_name FROM " . $oosDBTable['products_status'] . " WHERE products_status_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_status_id");
    while ($products_status = $products_status_result->fields) {
      $products_status_array[] = array('id' => $products_status['products_status_id'],
                                       'text' => $products_status['products_status_name']);
      $products_status_result->MoveNext();
    }

    $languages = oosGetLanguages();

    if (OOS_SPAW == 'true') {
      include OOS_CLASSES .'spaw/spaw_control.class.php';
    } elseif (OOS_SPAW == 'fck') {
      include OOS_CLASSES .'fckeditor/fckeditor.php';
    }

    $form_action = ($_GET['pID']) ? 'update_product' : 'insert_product';
    if (NEW_PRODUCT_PREVIEW == 'true') {
      $form_action = 'new_product_preview';
    }
?>
<link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css">
<script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript">
  var dateAvailable = new ctlSpiffyCalendarBox("dateAvailable", "new_product", "products_date_available","btnDate1","<?php echo $pInfo->products_date_available; ?>",scBTNMODE_CUSTOMBLUE);
</script>
<?php
  if (OOS_BASE_PRICE == 'true') {
?>
<script language="javascript"><!--

function doRound(x, places) {
  return Math.round(x * Math.pow(10, places)) / Math.pow(10, places);
}

function calcBasePriceFactor() { 
  var pqty = document.forms["new_product"].products_product_quantity.value;
  var bqty = document.forms["new_product"].products_base_quantity.value;
  
  if ((pqty != 0) || (bqty != 0)) {
     document.forms["new_product"].products_base_price.value = doRound(bqty / pqty, 6);
  } else {
     document.forms["new_product"].products_base_price.value = 1.000000;
  }

}
//--></script>
<?php
  }
?>
     <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading"><?php echo sprintf(TEXT_NEW_PRODUCT, oosOutputGeneratedCategoryPath($current_category_id)); ?></td>
            <td class="pageHeading" align="right"><?php echo oosDrawSeparator('trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
      </tr>
      <tr><?php echo oosDrawForm('new_product', $aFilename['products'], 'cPath=' . $cPath . '&pID=' . $_GET['pID'] . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"'); ?>
        <td><table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_STATUS; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawPullDownMenu('products_status', $products_status_array, $pInfo->products_status); ?></td>
          </tr>
<?php
   if (MULTIPLE_CATEGORIES_USE == 'true') {
?>
          <tr>
            <td class="main"><?php echo TEXT_CATEGORIES; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawMselectMenu('categories_ids[]', $categories_array, $categories_array_selected, 'size=10'); ?></td>
          </tr>
<?php
  }
?>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_DATE_AVAILABLE; ?><br /><small>(YYYY-MM-DD)</small></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;'; ?><script language="javascript">dateAvailable.writeControl(); dateAvailable.dateFormat="yyyy-MM-dd";</script></td>
          </tr>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_MANUFACTURER; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawPullDownMenu('manufacturers_id', $manufacturers_array, $pInfo->manufacturers_id); ?></td>
          </tr>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
<?php
    for ($i = 0, $n = count($languages); $i < $n; $i++) {
?>
          <tr>
            <td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_NAME; ?></td>
            <td class="main"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . '&nbsp;' . oosDrawInputField('products_name[' . $languages[$i]['id'] . ']', (($products_name[$languages[$i]['id']]) ? stripslashes($products_name[$languages[$i]['id']]) : oosGetProductsName($pInfo->products_id, $languages[$i]['id']))); ?></td>
          </tr>
<?php
    }
?>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
<?php
    for ($i = 0, $n = count($languages); $i < $n; $i++) {
?>
          <tr>
            <td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
            <td><table border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td class="main" valign="top"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']); ?>&nbsp;</td>
                <td class="main">

<?php 
      if (OOS_SPAW == 'true') {
        $sw = new SPAW_Wysiwyg('products_description_' . $languages[$i]['id'] /*name*/,(($_POST['products_description_' .$languages[$i]['id']]) ? stripslashes($_POST['products_description_' .$languages[$i]['id']]) : oosGetProductsDescription($pInfo->products_id, $languages[$i]['id'])) /*value*/,
                             $languages[$i]['iso_639_1'] /*language*/, 'sidetable' /*toolbar mode*/, 'default' /*theme*/,
                             '550px' /*width*/, '350px' /*height*/);
        $sw->show();
      } elseif (OOS_SPAW == 'fck') {
        $oFCKeditor = new FCKeditor('products_description_' . $languages[$i]['id']);
        $oFCKeditor->BasePath = OOS_CLASSES .'fckeditor/';
        $oFCKeditor->Config['AutoDetectLanguage'] = false;
        $oFCKeditor->Config['DefaultLanguage'] = $languages[$i]['iso_639_1'];
        $oFCKeditor->Width = '550';
        $oFCKeditor->Height = '350';
        $oFCKeditor->Config['SkinPath'] = 'skins/silver/' ;
        $oFCKeditor->ToolbarSet = 'Oos';
        $oFCKeditor->Value = (($_POST['products_description_' .$languages[$i]['id']]) ? stripslashes($_POST['products_description_' .$languages[$i]['id']]) : oosGetProductsDescription($pInfo->products_id, $languages[$i]['id']));
        $oFCKeditor->Create();
      } else {
        echo oosDrawTextareaField('products_description_' . $languages[$i]['id'], 'soft', '70', '15', ($_POST['products_description_' .$languages[$i]['id']] ? stripslashes($_POST['products_description_' .$languages[$i]['id']]) : oosGetProductsDescription($pInfo->products_id, $languages[$i]['id']))); 
      }
?>
                 </td>
              </tr>
            </table></td>
          </tr>
<?php
    }
    if (OOS_META_PRODUKT == "Meta Tag with article edit") {
      for ($i=0; $i < count($languages); $i++) {
?>
            <tr>
              <td class="main" width="100" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION_META; ?></td>
              <td><table border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td class="main" valign="top"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']); ?>&nbsp;</td>
                  <td class="main"><?php echo oosDrawTextareaField('products_description_meta_' . $languages[$i]['id'], 'soft', '70', '4', ($_POST['products_description_meta_' .$languages[$i]['id']] ? stripslashes($_POST['products_description_meta_' .$languages[$i]['id']]) : oosGetProductsDescriptionMeta($pInfo->products_id, $languages[$i]['id']))); 
?></td>
                </tr>
              </table></td>
            </tr>
<?php
      }
      for ($i=0; $i < count($languages); $i++) {
?>
            <tr>
              <td class="main" width="100" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_KEYWORDS_META; ?></td>
              <td><table border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td class="main" valign="top"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']); ?>&nbsp;</td>
                  <td class="main"><?php echo oosDrawTextareaField('products_keywords_meta_' . $languages[$i]['id'], 'soft', '70', '4', ($_POST['products_keywords_meta_' .$languages[$i]['id']] ? stripslashes($_POST['products_keywords_meta_' .$languages[$i]['id']]) : oosGetProductsKeywordsMeta($pInfo->products_id, $languages[$i]['id']))); 
?></td>
                </tr>
              </table></td>
            </tr>
<?php
      }
    }
?>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_quantity', $pInfo->products_quantity) . ' Min: ' . oosDrawInputField('products_quantity_order_min', ($pInfo->products_quantity_order_min==0 ? 1 : $pInfo->products_quantity_order_min)) . ' Units: ' . oosDrawInputField('products_quantity_order_units', $pInfo->products_quantity_order_units); ?></td>
          </tr>
<?php
  if (STOCK_CHECK == 'true') {
?>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_REORDER_LEVEL; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_reorder_level', $pInfo->products_reorder_level); ?></td> 
<?php
  }
?>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_MODEL; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_model', $pInfo->products_model); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_EAN; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_ean', $pInfo->products_ean); ?></td>
          </tr>
        </table><br />
        <table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_IMAGE; ?></td>
<?php 
   if (oosNotNull($pInfo->products_image)) {
     echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_image_product'], 'bimage=' . $pInfo->products_image) . '\')">' . oosImage(OOS_SHOP_IMAGES . $pInfo->products_image, $pInfo->products_name, '', '80') . '</a></td>';
     echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_image', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_image', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_image . '</span></td>';
   } else {
     echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
   }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_image') . oosDrawHiddenField('products_previous_image', $pInfo->products_image); ?></td>
          </tr>
<?php
  if (OOS_MO_PIC == 'true') {
?>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE1; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage1)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage1) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage1, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage1', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage1', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage1 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage1') . oosDrawHiddenField('products_previous_subimage1', $pInfo->products_subimage1); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE2; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage2)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage2) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage2, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage2', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage2', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage2 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage2') . oosDrawHiddenField('products_previous_subimage2', $pInfo->products_subimage2); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE3; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage3)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage3) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage3, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage3', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage3', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage3 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage3') . oosDrawHiddenField('products_previous_subimage3', $pInfo->products_subimage3); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE4; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage4)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage4) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage4, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage4', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage4', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage4 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage4') . oosDrawHiddenField('products_previous_subimage4', $pInfo->products_subimage4); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE5; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage5)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage5) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage5, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage5', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage5', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage5 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage5') . oosDrawHiddenField('products_previous_subimage5', $pInfo->products_subimage5); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SUBIMAGE6; ?></td>
<?php 
     if (oosNotNull($pInfo->products_subimage6)) {
       echo '            <td align="center"><a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_subimage_product'], 'bimage=' . $pInfo->products_subimage6) . '\')">' . oosImage(OOS_SHOP_SUBIMAGES . $pInfo->products_subimage6, $pInfo->products_name, '', '80') . '</a></td>';
       echo '            <td><span class="smallText">' . '&nbsp;' . oosDrawCheckboxField('remove_subimage6', 'yes') . TEXT_PRODUCTS_IMAGE_REMOVE . '<br />' . '&nbsp;' . oosDrawCheckboxField('delete_subimage6', 'yes') . TEXT_PRODUCTS_IMAGE_DELETE . '<br /><br />&nbsp;<b>' . TEXT_PRODUCTS_IMAGE . '</b>&nbsp;' .  $pInfo->products_subimage6 . '</span></td>';
     } else {
       echo '            <td colspan="2">' . oosDrawSeparator('trans.gif', '80', '1') . '</td>';
     }
?>
            <td class="main"><?php echo '&nbsp;' . oosDrawFileField('products_subimage6') . oosDrawHiddenField('products_previous_subimage6', $pInfo->products_subimage6); ?></td>
          </tr>
<?php
  }
?>
        </table><br />
        <table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
<?php
    for ($i = 0, $n = count($languages); $i < $n; $i++) {
?>
          <tr>
            <td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_URL . '<br /><small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?></td>
            <td class="main"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . '&nbsp;' . oosDrawInputField('products_url[' . $languages[$i]['id'] . ']', (($products_url[$languages[$i]['iso_639_2']]) ? stripslashes($products_url[$languages[$i]['id']]) : oosGetProductsUrl($pInfo->products_id, $languages[$i]['id']))); ?></td>
          </tr>
<?php
    }
?>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_PRICE; ?></td>
            <td class="main">
<?php
   $oosPrice = $pInfo->products_price; 
   if (OOS_PRICE_IS_BRUTTO == 'true'){
     $oosPriceNetto = round($oosPrice,TAX_DECIMAL_PLACES);
     $tax_result = $db->Execute("SELECT tax_rate FROM " . $oosDBTable['tax_rates'] . " WHERE tax_class_id = '" . $pInfo->products_tax_class_id . "' ");
     $tax = $tax_result->fields;
     $oosPrice = ($oosPrice*($tax[tax_rate]+100)/100);  
   }
   $oosPrice = round($oosPrice,TAX_DECIMAL_PLACES);
   echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_price', $oosPrice);
   if (OOS_PRICE_IS_BRUTTO == 'true') echo " - " . TEXT_TAX_INFO . $oosPriceNetto; 
?>
      </td>
    </tr>
    <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_LIST_PRICE; ?></td>
            <td class="main">
<?php
   $oosPriceList = $pInfo->products_price_list; 
   if (OOS_PRICE_IS_BRUTTO == 'true'){
     $oosPriceListNetto = round($oosPriceList,TAX_DECIMAL_PLACES);
     $oosPriceList = ($oosPriceList*($tax[tax_rate]+100)/100);  
   }
   $oosPriceList = round($oosPriceList,TAX_DECIMAL_PLACES);
   echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_price_list', $oosPriceList);
   if (OOS_PRICE_IS_BRUTTO == 'true') echo " - " . TEXT_TAX_INFO . $oosPriceListNetto; 
?> 
            </td>
          </tr>
<?php
  if (OOS_BASE_PRICE == 'true') {
?>
        </table><br />
        <table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_BASE_PRICE_FACTOR; ?></td>
            <td class="main"><table border="0">
                <tr>
                  <td class="main"><br><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_base_price', $pInfo->products_base_price); ?></td>
                  <td class="main"><br> <- </td>
                  <td class="main"><?php echo TEXT_PRODUCTS_PRODUCT_QUANTITY . '<br>' . oosDrawInputField('products_product_quantity', $pInfo->products_product_quantity, 'OnKeyUp="calcBasePriceFactor()"'); ?></td>
                  <td class="main"><?php echo TEXT_PRODUCTS_BASE_QUANTITY . '<br>' . oosDrawInputField('products_base_quantity', $pInfo->products_base_quantity, 'OnKeyUp="calcBasePriceFactor()"'); ?></td>
                </tr>
              </table>
            </td>
          </tr>
          <tr>
             <td class="main"><?php echo TEXT_PRODUCTS_BASE_UNIT; ?></td>
             <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_base_unit', $pInfo->products_base_unit); ?></td>
           </tr>
        </table><br />
        <table border="0" cellspacing="0" cellpadding="2">
<?php
  }
?>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
           <tr>
             <td class="main"><?php echo TEXT_PRODUCTS_DISCOUNT_ALLOWED; ?></td>
             <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_discount_allowed', number_format($pInfo->products_discount_allowed, 2)); ?> %</td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_DISCOUNTS_TITLE; ?></td>
            <td class="main">
               <table border='2'>
                 <tr>
                   <td colspan="5" class="main" align="center"><?php echo TEXT_DISCOUNTS_TITLE; ?></td>
                 </tr>
                   <td class="main" align="center" width="75"><?php echo TEXT_DISCOUNTS_BREAKS; ?></td>
                   <td class="main" align="center" width="75">1</td>
                   <td class="main" align="center" width="75">2</td>
                   <td class="main" align="center" width="75">3</td>
                   <td class="main" align="center" width="75">4</td>
                 <tr>
                 </tr>
                 <tr>
                   <td class="main" align="center" width="75"><?php echo TEXT_DISCOUNTS_QTY; ?><br /><?php echo TEXT_DISCOUNTS_PRICE; ?></td>
 <?php
   $oosDiscount1 = $pInfo->products_discount1; 
   $oosDiscount2 = $pInfo->products_discount2;
   $oosDiscount3 = $pInfo->products_discount3; 
   $oosDiscount4 = $pInfo->products_discount4;   
   if (OOS_PRICE_IS_BRUTTO == 'true'){
     $oosDiscount1 = ($oosDiscount1*($tax[tax_rate]+100)/100);
     $oosDiscount2 = ($oosDiscount2*($tax[tax_rate]+100)/100);
     $oosDiscount3 = ($oosDiscount3*($tax[tax_rate]+100)/100);
     $oosDiscount4 = ($oosDiscount4*($tax[tax_rate]+100)/100);
   }
   $oosDiscount1 = round($oosDiscount1,TAX_DECIMAL_PLACES);
   $oosDiscount2 = round($oosDiscount2,TAX_DECIMAL_PLACES);
   $oosDiscount3 = round($oosDiscount3,TAX_DECIMAL_PLACES);
   $oosDiscount4 = round($oosDiscount4,TAX_DECIMAL_PLACES);
 ?>
                   <td class="main" width="75"><?php echo oosDrawInputField('products_discount1_qty', $pInfo->products_discount1_qty, 'size="10"'); ?><br /><?php echo oosDrawInputField('products_discount1', $oosDiscount1, 'size="10"'); ?></td>
                   <td class="main" width="75"><?php echo oosDrawInputField('products_discount2_qty', $pInfo->products_discount2_qty, 'size="10"'); ?><br /><?php echo oosDrawInputField('products_discount2', $oosDiscount2, 'size="10"'); ?></td>
                   <td class="main" width="75"><?php echo oosDrawInputField('products_discount3_qty', $pInfo->products_discount3_qty, 'size="10"'); ?><br /><?php echo oosDrawInputField('products_discount3', $oosDiscount3, 'size="10"'); ?></td>
                   <td class="main" width="75"><?php echo oosDrawInputField('products_discount4_qty', $pInfo->products_discount4_qty, 'size="10"'); ?><br /><?php echo oosDrawInputField('products_discount4', $oosDiscount4, 'size="10"'); ?></td>
                  </tr>
               </table>
            </td>
          </tr>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_TAX_CLASS; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawPullDownMenu('products_tax_class_id', $tax_class_array, $pInfo->products_tax_class_id); ?></td>
          </tr>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_weight', $pInfo->products_weight); ?></td>
          </tr>
          <tr>
            <td colspan="2"><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_SORT_ORDER; ?></td>
            <td class="main"><?php echo oosDrawSeparator('trans.gif', '24', '15') . '&nbsp;' . oosDrawInputField('products_sort_order', $pInfo->products_sort_order); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
      </tr>
      <tr>
<?php
    if (NEW_PRODUCT_PREVIEW == 'true') {
?>
        <td class="main" align="right"><?php echo oosDrawHiddenField('products_date_added', (($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . oosImageSubmit('preview.gif', IMAGE_PREVIEW) . '&nbsp;&nbsp;<a href="' . oosLink($aFilename['categories'], 'cPath=' . $cPath . '&pID=' . $_GET['pID']) . '">' . oosImageButton('cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
<?php
    } else {
?>
        <td class="main" align="right"><?php echo oosDrawHiddenField('products_date_added', (($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . oosImageSubmit('save.gif', IMAGE_SAVE) . '&nbsp;&nbsp;<a href="' . oosLink($aFilename['categories'], 'cPath=' . $cPath . '&pID=' . $_GET['pID']) . '">' . oosImageButton('cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
<?php
    }
?>
      </form></tr>
<?php
  } elseif ($action == 'new_product_preview') {
    if (oosNotNull($_POST)) {
      $pInfo = new objectInfo($_POST);
      $products_name = $_POST['products_name'];
      $products_url = $_POST['products_url'];

      if ( ($_POST['products_image'] != 'none') && (isset($_FILES['products_image'])) ) {
         $products_image = oosGetUploadedFile('products_image');
         $image_directory = oosGetLocalPath(OOS_SHOP_PATH_IMAGES);
      }
      if (is_uploaded_file($products_image['tmp_name'])) {
        $products_image_name = oosCopyUploadedFile($products_image, $image_directory);
        if (OOS_IMAGE_SWF == 'true') {
          include OOS_CLASSES . 'class_image2swf.php';
          $swf = new Image2swf;
          $filename = split("[/\\.]", $products_image_name);
          $swf->Main(OOS_SHOP_PATH_IMAGES . $products_image_name, $filename[0]);   
        }
      } else {
        $products_image_name = $_POST['products_previous_image'];
      }

      // copy subimage1 only if modified
      if ( ($_POST['products_subimage1'] != 'none') && (isset($_FILES['products_subimage1'])) ) {
        $products_subimage1 = oosGetUploadedFile('products_subimage1');
        $subimage1_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage1['tmp_name'])) {
        $products_subimage1_name = oosCopyUploadedFile($products_subimage1, $subimage1_directory);
      } else {
        $products_subimage1_name = $_POST['products_previous_subimage1'];
      }

      // copy subimage2 only if modified
      if ( ($_POST['products_subimage2'] != 'none') && (isset($_FILES['products_subimage2'])) ) {
        $products_subimage2 = oosGetUploadedFile('products_subimage2');
        $subimage2_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage2['tmp_name'])) {
        $products_subimage2_name = oosCopyUploadedFile($products_subimage2, $subimage2_directory);
      } else {
        $products_subimage2_name = $_POST['products_previous_subimage2'];
      }

      // copy subimage3 only if modified
      if ( ($_POST['products_subimage3'] != 'none') && (isset($_FILES['products_subimage3'])) ) {
        $products_subimage3 = oosGetUploadedFile('products_subimage3');
        $subimage3_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage3['tmp_name'])) {
        $products_subimage3_name = oosCopyUploadedFile($products_subimage3, $subimage3_directory);
      } else {
        $products_subimage3_name = $_POST['products_previous_subimage3'];
      }

      // copy subimage4 only if modified
      if ( ($_POST['products_subimage4'] != 'none') && (isset($_FILES['products_subimage4'])) ) {
        $products_subimage4 = oosGetUploadedFile('products_subimage4');
        $subimage4_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage4['tmp_name'])) {
        $products_subimage4_name = oosCopyUploadedFile($products_subimage4, $subimage4_directory);
      } else {
        $products_subimage4_name = $_POST['products_previous_subimage4'];
      }

      // copy subimage5 only if modified
      if ( ($_POST['products_subimage5'] != 'none') && (isset($_FILES['products_subimage5'])) ) {
        $products_subimage5 = oosGetUploadedFile('products_subimage5');
        $subimage5_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage5['tmp_name'])) {
        $products_subimage5_name = oosCopyUploadedFile($products_subimage5, $subimage5_directory);
      } else {
        $products_subimage5_name = $_POST['products_previous_subimage5'];
      }

      // copy subimage6 only if modified
      if ( ($_POST['products_subimage6'] != 'none') && (isset($_FILES['products_subimage6'])) ) {
        $products_subimage6 = oosGetUploadedFile('products_subimage6');
        $subimage6_directory = oosGetLocalPath(OOS_SHOP_PATH_SUBIMAGES);
      }
      if (is_uploaded_file($products_subimage6['tmp_name'])) {
        $products_subimage6_name = oosCopyUploadedFile($products_subimage6, $subimage6_directory);
      } else {
        $products_subimage6_name = $_POST['products_previous_subimage6'];
      }

      $products_sort_order = $_POST['products_sort_order'];
    } else {   
      $product_result = $db->Execute("SELECT pd.products_name, pd.products_description, pd.products_description_meta, products_keywords_meta, pd.products_url, p.products_id, p.products_quantity, p.products_reorder_level, p.products_model, p.products_ean, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, p.products_price, p.products_base_price, p.products_base_unit, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_price_list, p.products_discount_allowed, p.products_quantity_order_min, p.products_quantity_order_units, p.products_discount1, p.products_discount2, p.products_discount3, p.products_discount4, p.products_discount1_qty, p.products_discount2_qty, p.products_discount3_qty, p.products_discount4_qty, p.products_sort_order FROM " . $oosDBTable['products'] . " p, " . $oosDBTable['products_description'] . " pd WHERE p.products_id = '" . $_GET['pID'] . "' and p.products_id = pd.products_id and pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'");
      $product = $product_result->fields;

      $pInfo = new objectInfo($product);
      $products_image_name = $pInfo->products_image;
      $products_subimage1_name = $pInfo->products_subimage1;
      $products_subimage2_name = $pInfo->products_subimage2;
      $products_subimage3_name = $pInfo->products_subimage3;
      $products_subimage4_name = $pInfo->products_subimage4;
      $products_subimage5_name = $pInfo->products_subimage5;
      $products_subimage6_name = $pInfo->products_subimage6;

    }

    $form_action = ($_GET['pID']) ? 'update_product' : 'insert_product';

    echo oosDrawForm($form_action, $aFilename['products'], 'cPath=' . $cPath . '&pID=' . $_GET['pID'] . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');

    $languages = oosGetLanguages();
    for ($i = 0, $n = count($languages); $i < $n; $i++) {
      if (isset($_GET['read']) && ($_GET['read'] == 'only')) {
        $pInfo->products_name = oosGetProductsName($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_description = oosGetProductsDescription($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_description_meta = oosGetProductsDescriptionMeta($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_keywords_meta = oosGetProductsKeywordsMeta($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_url = oosGetProductsUrl($pInfo->products_id, $languages[$i]['id']);
      } else {
        $pInfo->products_name = oosDBPrepareInput($products_name[$languages[$i]['id']]);
        $pInfo->products_description = oosDBPrepareInput($_POST['products_description_' .$languages[$i]['id']]);
        $pInfo->products_description_meta = oosDBPrepareInput($_POST['products_description_meta_' .$languages[$i]['id']]);
        $pInfo->products_keywords_meta = oosDBPrepareInput($_POST['products_keywords_meta_' .$languages[$i]['id']]);
        $pInfo->products_url = oosDBPrepareInput($products_url[$languages[$i]['id']]);
      }
?>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading"><?php echo oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . '&nbsp;' . $pInfo->products_name; ?></td>
<?php
  $oosPrice = $pInfo->products_price; 
  if (OOS_PRICE_IS_BRUTTO == 'true' && ($_GET['read'] == 'only' || $action != 'new_product_preview') ){
    $oosPriceNetto=round($oosPrice,TAX_DECIMAL_PLACES);
    $tax_result = $db->Execute("SELECT tax_rate FROM " . $oosDBTable['tax_rates'] . " WHERE tax_class_id = '" . $pInfo->products_tax_class_id . "' ");
    $tax = $tax_result->fields;
    $oosPrice= ($oosPrice*($tax[tax_rate]+100)/100);
  }
  $oosPrice=round($oosPrice,TAX_DECIMAL_PLACES);
?>
      <td class="pageHeading" align="right"><?php echo $currencies->format($oosPrice); ?></td>
          </tr>
          <tr>
            <td colspan="2" class="main" align="right"><?php echo TEXT_PRODUCTS_DISCOUNT_ALLOWED . ' ' . number_format($products_discount_allowed, 2); ?>%</td>
          </tr>
<?php
  include OOS_INCLUDES . 'categories_discounts_price.php'; 
?>
        </table></td>
      </tr>
      <tr>
        <td><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
      </tr>
      <tr>
        <td class="main">
<?php 
      if ( (!$delete_image) && (!$remove_image) ) {
        echo '<a href="javascript:popupImageWindow(\'' . oosLink($aFilename['popup_image_product'], 'bimage=' . $products_image_name) . '\')">' . (($products_image_name) ? oosImage(OOS_SHOP_IMAGES . $products_image_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a>';
      }
      echo $pInfo->products_description;
?></td>
      </tr>
<?php
      if ($pInfo->products_url) {
?>
      <tr>
        <td><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
      </tr>
      <tr>
        <td class="main"><?php echo sprintf(TEXT_PRODUCT_MORE_INFORMATION, $pInfo->products_url); ?></td>
      </tr>
<?php
      }
?>
          <tr>
            <td colspan="2" class="main" align="right">
<table align="center">
      <tr>
<?php
    if ( (!$delete_subimage1) && (!$remove_subimage1) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' . $products_subimage1_name) . '\')">' . (($products_subimage1_name) ? oosImage(OOS_SHOP_SUBIMAGES . $products_subimage1_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
    if ( (!$delete_subimage2) && (!$remove_subimage2) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' . $products_subimage2_name) . '\')">' . (($products_subimage2_name) ? oosImage(OOS_SHOP_SUBIMAGES . $products_subimage2_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
    if ( (!$delete_subimage3) && (!$remove_subimage3) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' .  $products_subimage3_name) . '\')">' . (($products_subimage3_name) ?oosImage(OOS_SHOP_SUBIMAGES . $products_subimage3_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
?>
      </tr>
      <tr>
<?php
    if ( (!$delete_subimage4) && (!$remove_subimage4) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' .  $products_subimage4_name) . '\')">' . (($products_subimage4_name) ? oosImage(OOS_SHOP_SUBIMAGES . $products_subimage4_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
    if ( (!$delete_subimage5) && (!$remove_subimage5) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' .  $products_subimage5_name) . '\')">' . (($products_subimage5_name) ? oosImage(OOS_SHOP_SUBIMAGES . $products_subimage5_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
    if ( (!$delete_subimage6) && (!$remove_subimage6) ) {
      echo '<td align="center" class="main"><a href="javascript:popupImageWindow(\''. oosLink($aFilename['popup_subimage_product'], 'bimage=' .  $products_subimage6_name) . '\')">' . (($products_subimage6_name) ? oosImage(OOS_SHOP_SUBIMAGES . $products_subimage6_name, $pInfo->products_name, '', '80', 'align="right" hspace="5" vspace="5"') : '') . '</a></td>';
    } else {
      echo '<td></td>';
    }
?>
      </tr>
</table>

          </td>
        </tr>
<?php
      if ($pInfo->products_date_available > date('Y-m-d')) {
?>
      <tr>
        <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, oosDateLong($pInfo->products_date_available)); ?></td>
      </tr>
<?php
      } else {
?>
      <tr>
        <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, oosDateLong($pInfo->products_date_added)); ?></td>
      </tr>
<?php
      }
?>
      <tr>
        <td><?php echo oosDrawSeparator('trans.gif', '1', '10'); ?></td>
      </tr>
<?php
    }
    if (isset($_GET['read']) && ($_GET['read'] == 'only')) {
      if (isset($_GET['origin'])) {
        $pos_params = strpos($_GET['origin'], '?', 0);
        if ($pos_params != false) {
          $back_url = substr($_GET['origin'], 0, $pos_params);
          $back_url_params = substr($_GET['origin'], $pos_params + 1);
        } else {
          $back_url = $_GET['origin'];
          $back_url_params = '';
        }
      } else {
        $back_url = $aFilename['categories'];
        $back_url_params = 'cPath=' . $cPath;
        if (oosNotNull($pInfo->products_id)) {
          $back_url_params .= '&pID=' . $pInfo->products_id;
        }
      }
?>
      <tr>
        <td align="right"><?php echo '<a href="' . oosLink($back_url, $back_url_params, 'NONSSL') . '">' . oosImageButton('back.gif', IMAGE_BACK) . '</a>'; ?></td>
      </tr>
<?php
    } else {
?>
      <tr>
        <td align="right" class="smallText">
<?php
/* Re-Post all POST'ed variables */
      reset($_POST);
      while (list($key, $value) = each($_POST)) {
        if (!is_array($_POST[$key])) {
          echo oosDrawHiddenField($key, htmlspecialchars(stripslashes($value)));
        }
      }
      $languages = oosGetLanguages();
      for ($i = 0, $n = count($languages); $i < $n; $i++) {
        echo oosDrawHiddenField('products_name[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_name[$languages[$i]['id']])));
        echo oosDrawHiddenField('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']])));
        echo oosDrawHiddenField('products_description_meta[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description_meta[$languages[$i]['id']])));
        echo oosDrawHiddenField('products_keywords_meta[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_keywords_meta[$languages[$i]['id']])));
        echo oosDrawHiddenField('products_url[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_url[$languages[$i]['id']])));
      }
      echo oosDrawHiddenField('products_image', stripslashes($products_image_name));
      echo oosDrawHiddenField('products_subimage1', stripslashes($products_subimage1_name));
      echo oosDrawHiddenField('products_subimage2', stripslashes($products_subimage2_name));
      echo oosDrawHiddenField('products_subimage3', stripslashes($products_subimage3_name));
      echo oosDrawHiddenField('products_subimage4', stripslashes($products_subimage4_name));
      echo oosDrawHiddenField('products_subimage5', stripslashes($products_subimage5_name));
      echo oosDrawHiddenField('products_subimage6', stripslashes($products_subimage6_name));

      if (isset($_POST['categories_ids'])) {
        $selected_catids = $_POST['categories_ids'];
        foreach ($selected_catids as $current_category_id)  {
          echo oosDrawHiddenField('categories_ids[]', stripslashes($current_category_id));
        }
      }

      echo oosImageSubmit('back.gif', IMAGE_BACK, 'name="edit"') . '&nbsp;&nbsp;';

      if (isset($_GET['pID'])) {
        echo oosImageSubmit('update.gif', IMAGE_UPDATE);
      } else {
        echo oosImageSubmit('insert.gif', IMAGE_INSERT);
      }
      echo '&nbsp;&nbsp;<a href="' . oosLink($aFilename['categories'], 'cPath=' . $cPath . '&pID=' . $_GET['pID']) . '">' . oosImageButton('cancel.gif', IMAGE_CANCEL) . '</a>';
?></td>
      </form></tr>
<?php
    }
  }
?>
    </table></td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->

<?php require OOS_INCLUDES . 'oos_footer.php'; ?>
<br />
</body>
</html>
<?php require OOS_INCLUDES . 'oos_nice_exit.php'; ?>