Jump to content
xt:Commerce Community Forum

Search the Community

Showing results for tags 'optionswerte'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • xt:Commerce - Professionelle eCommerce Shopsoftware
    • Fragen zur Software
    • xt:Commerce Plugins
    • xt:Commerce 4 Sprachen
    • xt:Commerce Online Handbuch
    • Häufige Fragen (FAQ)
    • Fragen zur Software (Pre Sale)
    • Anleitungen - Patches - Downloads
  • xt:Commerce Office - Shop & Warenwirtschaft
    • Allgemeine Fragen
  • xt:Commerce Allgemein
  • xt:Commerce 3 Shopsoftware Community Area (nur Lesen)
    • Allgemeine Diskussionen
    • Installation und Konfiguration
    • Shopbereich
    • Admininterface
    • Modul Entwicklung
    • Template System
    • xt:Commerce Schnittstellen ERP Systeme
    • PHP & MysQL Forum
    • HTML & CSS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


ICQ


Yahoo


Jabber


Skype


Location


Interests


Biografie


Wohnort


Interessen


Beruf

Found 10 results

  1. Habt ihr eine Lösung? Wir haben die Kategorie HOSEN mit den Untergruppen JEANS und LEINEN. Jede Untergruppe hat die MODELLE A / B / C ... und jedes MODELL hat die Gr. S / M / L ... wir haben also: GRÖSSE als Artikelmerkmal und die entsprechenden Optionswerte Gr. S / Gr. M / Gr. L Innerhalb jedes MODELLS wird für jede GRÖSSE eine Artikelnummer eingegeben: Jeans - MODELL A - GRÖSSE S = ModA/GrS ... ... Jeans - MODELL B - GRÖSSE S = ModB/GrS ... ... Jetzt unser Problem: Bestellt der Kunde die Jeans - MODELL B - GRÖSSE S ... alos Artikelnummer ModB/GrS wird in der Bestellung die Artikelnummer von MODELL A ... also ModA/GrS dargestellt/gedruckt. Habt Ihr eine Lösung? Danke für die Hilfe - speiche
  2. Hallo, ich habe folgendes Modul im Einsatz. funktioniert auch. Allerdings hätte ich gerne, dass im Adminbereich unter Artikelmerkmale Optionwerte die hochgeladenen Bilder als Vorschau in der Tabelle erscheinen. Kann mir jemand helfen? ######### <?php /* -------------------------------------------------------------- $Id: products_attributes.php 1155 2005-08-13 15:47:33Z matthias $ XT-Commerce - community made shopping xt:Commerce - Shopsoftware für Onlineshops - Webshop kostenlos downloaden Copyright © 2003 XT-Commerce -------------------------------------------------------------- based on: © 2000-2001 The Exchange Project (earlier name of osCommerce) © 2002-2003 osCommerce(products_attributes.php,v 1.48 2002/11/22); osCommerce, Open Source Online Shop E-Commerce Solutions © 2003 nextcommerce (products_attributes.php,v 1.10 2003/08/18); nextcommerce.org Released under the GNU General Public License --- 26.07.2005 Copyright © 2005 Sergej Stroh http://www.*****************************************************************************.de - Einfügen von kurzen Beschreibung - Zuweisen eine Attributbildes --------------------------------------------------------------*/ require('includes/application_top.php'); $languages = xtc_get_languages(); if ($_GET['action']) { $page_info = 'option_page=' . $_GET['option_page'] . '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $_GET['attribute_page']; switch($_GET['action']) { case 'add_product_options': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = $_POST['option_name']; xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . $_POST['products_options_id'] . "', '" . $option_name[$languages[$i]['id']] . "', '" . $languages[$i]['id'] . "')"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'add_product_option_values': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $value_name = $_POST['value_name']; $value_desc = $_POST['value_desc']; if ($image = &xtc_try_upload('value_image'.$i, DIR_FS_CATALOG_IMAGES.'product_options/')) { $paname_arr = explode('.',$image -> filename); $pnsuffix = array_pop($paname_arr); $value_image_name = $_POST['value_id'].'_'. $i .'.' . $pnsuffix; @unlink(DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); rename(DIR_FS_CATALOG_IMAGES.'product_options/'.$image -> filename, DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); } xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name, products_options_values_desc, products_options_values_image) values ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . $value_name[$languages[$i]['id']] . "', '" . $value_desc[$languages[$i]['id']] . "', '" . $value_image_name . "')"); } xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . $_POST['option_id'] . "', '" . $_POST['value_id'] . "')"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'add_product_attributes': xtc_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $_POST['products_id'] . "', '" . $_POST['options_id'] . "', '" . $_POST['values_id'] . "', '" . $_POST['value_price'] . "', '" . $_POST['price_prefix'] . "')"); $products_attributes_id = xtc_db_insert_id(); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { xtc_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . $products_attributes_id . ", '" . $_POST['products_attributes_filename'] . "', '" . $_POST['products_attributes_maxdays'] . "', '" . $_POST['products_attributes_maxcount'] . "')"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_option_name': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = $_POST['option_name']; xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $option_name[$languages[$i]['id']] . "' where products_options_id = '" . $_POST['option_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_value': $value_name = $_POST['value_name']; $value_desc = $_POST['value_desc']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { if($_FILES['value_image'.$i]['name'] != '') { if ($image = &xtc_try_upload('value_image'.$i, DIR_FS_CATALOG_IMAGES.'product_options/')) { $paname_arr = explode('.',$image -> filename); $pnsuffix = array_pop($paname_arr); $value_image_name = $_POST['value_id'].'_'. $i .'.' . $pnsuffix; @unlink(DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); rename(DIR_FS_CATALOG_IMAGES.'product_options/'.$image -> filename, DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); // sql update ergaenzen $image_sql = ', products_options_values_image =\''. $value_image_name . '\''; } } elseif($_POST['del_value_image'. $i] == true) { // bild loeschen $image_sql = ', products_options_values_image = \'\''; } else { $image_sql = ''; } xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . $value_name[$languages[$i]['id']] . "', products_options_values_desc = '" . $value_desc[$languages[$i]['id']] . "' ". $image_sql ." where products_options_values_id = '" . $_POST['value_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); } xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " set products_options_id = '" . $_POST['option_id'] . "' where products_options_values_id = '" . $_POST['value_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_product_attribute': xtc_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id = '" . $_POST['products_id'] . "', options_id = '" . $_POST['options_id'] . "', options_values_id = '" . $_POST['values_id'] . "', options_values_price = '" . $_POST['value_price'] . "', price_prefix = '" . $_POST['price_prefix'] . "' where products_attributes_id = '" . $_POST['attribute_id'] . "'"); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { xtc_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " set products_attributes_filename='" . $_POST['products_attributes_filename'] . "', products_attributes_maxdays='" . $_POST['products_attributes_maxdays'] . "', products_attributes_maxcount='" . $_POST['products_attributes_maxcount'] . "' where products_attributes_id = '" . $_POST['attribute_id'] . "'"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_option': $del_options = xtc_db_query("select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); while($del_options_values = xtc_db_fetch_array($del_options)){ xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['option_id'] . "'"); } xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_value': xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_attribute': xtc_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . $_GET['attribute_id'] . "'"); // Added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled xtc_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $_GET['attribute_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; } } ?> <!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 $_SESSION['language_charset']; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script type="text/javascript"><!-- function go_option() { if (document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value != "none") { location = "<?php echo xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . ($_GET['option_page'] ? $_GET['option_page'] : 1)); ?>&option_order_by="+document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value; } } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td class="columnLeft2" 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 class="boxCenter" width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <!-- options and values//--> <tr> <td width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="top" class="main" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <!-- options //--> <?php if ($_GET['action'] == 'delete_product_option') { // delete product option $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'"); $options_values = xtc_db_fetch_array($options); ?> <tr> <td class="pageHeading"> <?php echo $options_values['products_options_name']; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $products = xtc_db_query("select p.products_id, pd.products_name, pov.products_options_values_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pov.language_id = '" . $_SESSION['languages_id'] . "' and pd.language_id = '" . $_SESSION['languages_id'] . "' and pa.products_id = p.products_id and pa.options_id='" . $_GET['option_id'] . "' and pov.products_options_values_id = pa.options_values_id order by pd.products_name"); if (xtc_db_num_rows($products)) { ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php while ($products_values = xtc_db_fetch_array($products)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> <td class="smallText"> <?php echo $products_values['products_options_values_name']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr> <td colspan="3" class="main"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td> </tr> <tr> <td align="right" colspan="3" class="main"><br /><?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_OK_TO_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option&option_id=' . $_GET['option_id'], 'NONSSL'));?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&order_by=' . $order_by . '&page=' . $page, 'NONSSL'));?> </td> </tr> <?php } ?> </table></td> </tr> <?php } else { if ($_GET['option_order_by']) { $option_order_by = $_GET['option_order_by']; } else { $option_order_by = 'products_options_id'; } ?> <tr> <td colspan="2" class="pageHeading"> <?php echo HEADING_TITLE_OPT; ?> </td> <td align="right"><br /><form name="option_order_by" action="<?php echo FILENAME_PRODUCTS_ATTRIBUTES; ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td> </tr> <tr> <td colspan="3" class="smallText"> <?php $per_page = MAX_ROW_LISTS_OPTIONS; $options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by " . $option_order_by; if (!$option_page) { $option_page = 1; } $prev_option_page = $option_page - 1; $next_option_page = $option_page + 1; $option_query = xtc_db_query($options); $option_page_start = ($per_page * $option_page) - $per_page; $num_rows = xtc_db_num_rows($option_query); if ($num_rows <= $per_page) { $num_pages = 1; } else if (($num_rows % $per_page) == 0) { $num_pages = ($num_rows / $per_page); } else { $num_pages = ($num_rows / $per_page) + 1; } $num_pages = (int) $num_pages; $options = $options . " LIMIT $option_page_start, $per_page"; // Previous if ($prev_option_page) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $prev_option_page) . '"> << </a> | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $option_page) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $i) . '">' . $i . '</a> | '; } else { echo '<b><font color=red>' . $i . '</font></b> | '; } } // Next if ($option_page != $num_pages) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $next_option_page) . '"> >> </a>'; } ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $next_id = 1; $options = xtc_db_query($options); while ($options_values = xtc_db_fetch_array($options)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php if (($_GET['action'] == 'update_option') && ($_GET['option_id'] == $options_values['products_options_id'])) { echo '<form name="option" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_name', 'NONSSL') . '" method="post">'; $inputs = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = xtc_db_query("select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_values['products_options_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); $option_name = xtc_db_fetch_array($option_name); $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20" value="' . $option_name['products_options_name'] . '"> <br />'; } ?> <td align="center" class="smallText"> <?php echo $options_values['products_options_id']; ?><input type="hidden" name="option_id" value="<?php echo $options_values['products_options_id']; ?>"> </td> <td class="smallText"><?php echo $inputs; ?></td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_UPDATE); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL'));?> </td> <?php echo '</form>' . "\n"; } else { ?> <td align="center" class="smallText"> <?php echo $options_values["products_options_id"]; ?> </td> <td class="smallText"> <?php echo $options_values["products_options_name"]; ?> </td> <td align="center" class="smallText"> <?php echo xtc_button_link(BUTTON_EDIT, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option&option_id=' . $options_values['products_options_id'] . '&option_order_by=' . $option_order_by . '&option_page=' . $option_page, 'NONSSL'));?> <?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_product_option&option_id=' . $options_values['products_options_id'], 'NONSSL'));?> </td> <?php } ?> </tr> <?php $max_options_id_query = xtc_db_query("select max(products_options_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS); $max_options_id_values = xtc_db_fetch_array($max_options_id_query); $next_id = $max_options_id_values['next_id']; } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php if ($_GET['action'] != 'update_option') { ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php echo '<form name="options" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_options&option_page=' . $option_page, 'NONSSL') . '" method="post"><input type="hidden" name="products_options_id" value="' . $next_id . '">'; $inputs = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20"> <br />'; } ?> <td align="center" class="smallText"> <?php echo $next_id; ?> </td> <td class="smallText"><?php echo $inputs; ?></td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_INSERT); ?> </td> <?php echo '</form>'; ?> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php } } ?> </table></td> <!-- options eof //--> </tr><tr></tr> <td valign="top" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <!-- value //--> <?php if ($_GET['action'] == 'delete_option_value') { // delete product option value $values = xtc_db_query("select products_options_values_id, products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'"); $values_values = xtc_db_fetch_array($values); ?> <tr> <td colspan="3" class="pageHeading"> <?php echo $values_values['products_options_values_name']; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $products = xtc_db_query("select p.products_id, pd.products_name, po.products_options_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS . " po, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and po.language_id = '" . $_SESSION['languages_id'] . "' and pa.products_id = p.products_id and pa.options_values_id='" . $_GET['value_id'] . "' and po.products_options_id = pa.options_id order by pd.products_name"); if (xtc_db_num_rows($products)) { ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php while ($products_values = xtc_db_fetch_array($products)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> <td class="smallText"> <?php echo $products_values['products_options_name']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_OK_TO_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_value&value_id=' . $_GET['value_id'], 'NONSSL')); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&option_page=' . $option_page . '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } ?> </table></td> </tr> <?php } else { ?> <tr> <td colspan="3" class="pageHeading"> <?php echo HEADING_TITLE_VAL; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td colspan="4" class="smallText"> <?php $per_page = MAX_ROW_LISTS_OPTIONS; $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '" . $_SESSION['languages_id'] . "' order by pov.products_options_values_id"; if (!$_GET['value_page']) { $_GET['value_page'] = 1; } $prev_value_page = $_GET['value_page'] - 1; $next_value_page = $_GET['value_page'] + 1; $value_query = xtc_db_query($values); $value_page_start = ($per_page * $_GET['value_page']) - $per_page; $num_rows = xtc_db_num_rows($value_query); if ($num_rows <= $per_page) { $num_pages = 1; } else if (($num_rows % $per_page) == 0) { $num_pages = ($num_rows / $per_page); } else { $num_pages = ($num_rows / $per_page) + 1; } $num_pages = (int) $num_pages; $values = $values . " LIMIT $value_page_start, $per_page"; // Previous if ($prev_value_page) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> << </a> | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $_GET['value_page']) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $i) . '">' . $i . '</a> | '; } else { echo '<b><font color=red>' . $i . '</font></b> | '; } } // Next if ($_GET['value_page'] != $num_pages) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $next_value_page) . '"> >></a> '; } ?> </td> </tr> <!-- === ATTRIBUTS, IMAGE, DESCRIPTION, *****************************************************************************.de ============================ --> <tr class="attributs_header"> <td class="attributs_content" width="5%"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="attributs_content"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> <td class="attributs_content"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> <td class="attributs_content" align="center" width="30%"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $next_id = 1; $values = xtc_db_query($values); while ($values_values = xtc_db_fetch_array($values)) { $options_name = xtc_options_name($values_values['products_options_id']); $values_name = $values_values['products_options_values_name']; $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php if (($_GET['action'] == 'update_option_value') && ($_GET['value_id'] == $values_values['products_options_values_id'])) { echo '<form name="values" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_value', 'NONSSL') . '" method="post" enctype="multipart/form-data">'; $inputs = ''; $inputs_desc = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $value_name = xtc_db_query("select products_options_values_name, products_options_values_desc, products_options_values_image from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $values_values['products_options_values_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); $value_name = xtc_db_fetch_array($value_name); $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="50" value="' . $value_name['products_options_values_name'] . '"> <br />'; if($value_name['products_options_values_image'] != '') { $inputs_image .= xtc_image(DIR_WS_CATALOG_IMAGES.'product_options/'. $value_name['products_options_values_image'], 'Optionsimage').'<br />'; $inputs_image .= xtc_draw_selection_field('del_value_image'. $i, 'checkbox', 'value_image'. $i) .' '. TABLE_TEXT_DELETE .'<br /><br />'; } $inputs_image .= $languages[$i]['code'] . ': '. xtc_draw_file_field('value_image'. $i). ' <br />'; $inputs_desc .= $languages[$i]['code'] . ': <textarea name="value_desc[' . $languages[$i]['id'] . ']" cols="50" rows="4">' . $value_name['products_options_values_desc'] . '</textarea> <br />'; } ?> <td align="left" class="smallText" colspan="4"> <!-- update optionaname, image and description --> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr class="attributs_new"> <td class="attributs_new" width="4%"> <?php echo $values_values['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values['products_options_values_id']; ?>"> </td> <td class="attributs_new" width="20%"> <strong><?php echo TABLE_HEADING_OPT_NAME; ?></strong> </td> <td class="attributs_new" width="40%"> <?php echo "\n"; ?><select name="option_id"> <?php $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by products_options_name"); while ($options_values = xtc_db_fetch_array($options)) { echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '"'; if ($values_values['products_options_id'] == $options_values['products_options_id']) { echo ' selected'; } echo '>' . $options_values['products_options_name'] . '</option>'; } ?> </select> </td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_UPDATE); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL')); ?> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsname --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_VALUE; ?></strong> </td> <td class="attributs_name"><?php echo $inputs; ?></td> </tr> </table> <!-- optionsname EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsimage --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_IMAGE; ?></strong> </td> <td class="attributs_name"><?php echo $inputs_image; ?></td> </tr> </table> <!-- optionsimage EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsdescription --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_DESC; ?></strong> </td> <td class="attributs_name"><?php echo $inputs_desc; ?></td> </tr> </table> <!-- optionsdescription EOF --> </td> </tr> </table> <!-- update optionaname, image and description EOF --> </td> <?php echo '</form>'; } else { // attributanzeige ?> <td align="center" class="smallText"> <?php echo $values_values["products_options_values_id"]; ?> </td> <td align="center" class="smallText"> <?php echo $options_name; ?> </td> <td class="smallText"> <?php echo $values_name; ?> </td> <td align="center" class="smallText"> <?php echo xtc_button_link(BUTTON_EDIT, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_value&value_id=' . $values_values['products_options_values_id'] . '&value_page=' . $_GET['value_page'], 'NONSSL')); ?> <?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option_value&value_id=' . $values_values['products_options_values_id'], 'NONSSL')); ?> </td> <?php } $max_values_id_query = xtc_db_query("select max(products_options_values_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS_VALUES); $max_values_id_values = xtc_db_fetch_array($max_values_id_query); $next_id = $max_values_id_values['next_id']; } ?> </tr> <tr> <td colspan="4"><?php echo xtc_black_line(); ?></td> </tr> <?php if ($_GET['action'] != 'update_option_value') { ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php echo '<form name="values" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_option_values&value_page=' . $_GET['value_page'], 'NONSSL') . '" method="post" enctype="multipart/form-data">'; ?> <td align="left" class="smallText" colspan="4"> <!-- optionaname, image and description --> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr class="attributs_new"> <td class="attributs_new" width="5%"> <?php echo $next_id; ?> </td> <td class="attributs_new" width="20%"> <strong><?php echo TABLE_HEADING_OPT_NAME; ?></strong> </td> <td class="attributs_new" width="55%"> <select name="option_id"> <?php $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by products_options_name"); while ($options_values = xtc_db_fetch_array($options)) { echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>'; } $inputs = ''; $inputs_desc = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15"> <br />'; $inputs_image .= $languages[$i]['code'] . ': '. xtc_draw_file_field('value_image'. $i). ' <br />'; $inputs_desc .= $languages[$i]['code'] . ': <textarea name="value_desc[' . $languages[$i]['id'] . ']" cols="50" rows="4"></textarea> <br />'; } ?> </select> </td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_INSERT); ?> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsname --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_VALUE; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs; ?></td> </tr> </table> <!-- optionsname EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsimage --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_IMAGE; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs_image; ?></td> </tr> </table> <!-- optionsimage EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsdescription --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_DESC; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs_desc; ?></td> </tr> </table> <!-- optionsdescription EOF --> </td> </tr> </table> <!-- optionaname, image and description EOF --> </td> <?php echo '</form>'; ?> </tr> <tr> <td colspan="4"><?php echo xtc_black_line(); ?></td> </tr> <?php } } ?> </table></td> </tr> </table></td> <!-- option value eof //--> </tr> </table></td> <!-- products_attributes_eof //--> </tr> </table> <!-- body_text_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  3. Hallo zusammen. wir haben zu unserem veyton das freitextmodul mit geordert. allerdings haben wir ein kleines "problem" in unserem fall werden wir computer verkaufen. das freitextmodul dient dazu, dass der benutzer sein betriebssystem aussuchen kann. das sind zur zeit 11 oder 12 stück. es steht also immer das gleiche unter den computern. nun kann man aber beim freitextmodul nicht die preise direkt für einen optionswert festlegen, sondern muss dies immer in den einzelnen artikeln an den einzelnen optionswerten tun. da im IT-Geschäft die preise allerdings stark schwanken (tagespreise) müssten wir dann bei jedem computersystem fast täglich alle preise aktualisieren. bei 40 computern mit je 12 optionen wären das dann 480 optionen, wo täglich die preise aktualisiert werden müssten... gibt es keine möglichkeit, dass das einfacher geht? oder man einzelne Artikel (in dem fall betriebssysteme) als optionswert nimmt. so dass alle preise dann angepasst werden? oder gibt es diese funktion bereits und ich habe sie übersehen? danke im voraus phil
  4. Hallo, ich habe 276 Optionswerte auf 24 Seiten, nur leider bin ich mit der Handhabung so unzufrieden, daß ich denke, irgendetwas falsch zumachen. Um einen bestimmten OPwert zu suchen klicke ich mich durch diese 24 Seiten!!! Das dauert natürlich und muß doch einfacher machbar sein. Kann man die nicht sortieren? Ich kann mir schlecht merken (oder gar aufschreiben) wann ich welchen Wert eingegeben habe, um in etwa zu schätzen, auf welcher Seite er sich befindet. Es würde reichen wenn mir 50 oder 100 Werte gleichzeitig angezeigt werden, dann könnte man sich durch scrollen. Umgekehrt ist es in der Attributverwaltung, hier zeigt er mir alle 276 Werte an. Das Laden dauert ewig, nur um ein Häckchen zu ändern. Also liebe Leute, ich mach's mir bestimmt zu umständlich, helft mir doch einfach, ich checks eben nicht...(blutiger Anfänger!!!) annett
  5. Wo kann ich das ändern, wie viel Artikelmerkmale & Optionswerte er pro seite anzeigt? Es wird schnell unübersichtlich - es wäre besser, wenn er einfach 50 pro seite anzeigt, dann kann man einfach mit strg + f suchen... Oder gibts ein kostenloses modul, welches das schon umstickt? Danke für Eure Hilfe Christoph
  6. Hallo, in unserem Shop haben wir jetzt einige Optionswerte angelegt. Nun möchte ich die Optionswerte bearbeiten, aber nach drücken der Taste Bearbeiten läd XTC die Seite neu - andere Optionen erscheinen - und ich kann meine ausgewählte Option nicht ändern. Die neu geladenen Optionen lassen sich ändern - was die Funktion als solche zeigt wie sie eigentlich gehen sollte. Nur hilft das nicht weiter für das ändern der eigentlichen Option. Das Problem ist anscheinend schon lange bekannt - doch leider findet man keine Lösung dazu. Wo liegt das Problem? Grüße Major
  7. Hallo. Wann wird es ein Plugin geben, mit dem ich z.B. Stoff ganz einfach in verschiedenen Farben verkaufen kann, OHNE den Master/Slave-Schnickschnack? Ist doch doof, wenn ich 10 identische Artikel mit nur anderer Farbe anlegen muss! Verbessert die Kategorie-Übersicht auch nicht unbedingt ... Im Grunde das gleiche wie in meinem alten xt:commerce Shop ... Brauch ich wirklich dringend! Danke.
  8. Hallo, ich habe bis jetzt 276 OPWerte gelistet. Diese werden mir auf 23 Seiten dargestellt. Wenn ich nun ein bestimmtes suche, dauert es natürlich eine gewisse Zeit. Umgedreht ist es in der Artikelverwaltung, dort werden alle 276 Werte auf einmal dargestellt, das dauert wiederum seine Zeit. Gibt es ein Module was mir hilft und vieleich besteimmte Werte einfach ausschaltet? annett
  9. Hallo zusammen. haben gestern den ganzen Forumj durchwühlt. Leider keine Lösung gefunden. Im Adminbereich unter Artikelmerkmale würde ich gerne die Optionswerte nach Optionsname sortieren lassen. Es gehte aber leider nur mit products_options_values_id oder products_options_values. Wenn ich in admin/products_atributes.php zeile 408 am Enden auf products_options_name ändere, kommt es zu einer Fehlermeldung. Kann mir bitte jemand helfen?
  10. Hallo, ich habe das Problem, dass die Maske f?r die Anlage neuer Optionswerte f?r die Artikelmerkmale keine Strukturierung der Anzeige bietet. In unserem Shop gibt es aktuell 18 verschiedene Artikelmerkmale mit zusammen 240 Werten. Da die Merkmale immer erst bei Bedarf angelegt werden ist die Reihenfolge inzwischen nat?rlich sch?n un?bersichtlich durcheinander. Ich w?rde bei Maske f?r neue Optionswerte gerne jeweils nur die Werte eines zuvor gew?hlten Artikelmerkmals gezeigt bekommen, um einen ?berblick zu haben. geht das irgendwie??
×
×
  • Create New...