| [ Index ] |
|
Code source de osCommerce 2.2ms2-060817 |
1 <?php 2 /* 3 $Id: products_attributes.php,v 1.52 2003/07/10 20:46:01 dgw_ Exp $ 4 5 osCommerce, Open Source E-Commerce Solutions 6 http://www.oscommerce.com 7 8 Copyright (c) 2003 osCommerce 9 10 Released under the GNU General Public License 11 */ 12 13 require ('includes/application_top.php'); 14 $languages = tep_get_languages(); 15 16 $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); 17 18 if (tep_not_null($action)) { 19 $page_info = ''; 20 if (isset($HTTP_GET_VARS['option_page'])) $page_info .= 'option_page=' . $HTTP_GET_VARS['option_page'] . '&'; 21 if (isset($HTTP_GET_VARS['value_page'])) $page_info .= 'value_page=' . $HTTP_GET_VARS['value_page'] . '&'; 22 if (isset($HTTP_GET_VARS['attribute_page'])) $page_info .= 'attribute_page=' . $HTTP_GET_VARS['attribute_page'] . '&'; 23 if (tep_not_null($page_info)) { 24 $page_info = substr($page_info, 0, -1); 25 } 26 27 switch ($action) { 28 case 'add_product_options': 29 $products_options_id = tep_db_prepare_input($HTTP_POST_VARS['products_options_id']); 30 $option_name_array = $HTTP_POST_VARS['option_name']; 31 32 for ($i=0, $n=sizeof($languages); $i<$n; $i ++) { 33 $option_name = tep_db_prepare_input($option_name_array[$languages[$i]['id']]); 34 35 tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "')"); 36 } 37 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 38 break; 39 case 'add_product_option_values': 40 $value_name_array = $HTTP_POST_VARS['value_name']; 41 $value_id = tep_db_prepare_input($HTTP_POST_VARS['value_id']); 42 $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']); 43 44 for ($i=0, $n=sizeof($languages); $i<$n; $i ++) { 45 $value_name = tep_db_prepare_input($value_name_array[$languages[$i]['id']]); 46 47 tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . (int)$value_id . "', '" . (int)$languages[$i]['id'] . "', '" . tep_db_input($value_name) . "')"); 48 } 49 50 tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . (int)$option_id . "', '" . (int)$value_id . "')"); 51 52 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 53 break; 54 case 'add_product_attributes': 55 $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); 56 $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']); 57 $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']); 58 $value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']); 59 $price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']); 60 61 tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); 62 63 if (DOWNLOAD_ENABLED == 'true') { 64 $products_attributes_id = tep_db_insert_id(); 65 66 $products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']); 67 $products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']); 68 $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']); 69 70 if (tep_not_null($products_attributes_filename)) { 71 tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . (int)$products_attributes_id . ", '" . tep_db_input($products_attributes_filename) . "', '" . tep_db_input($products_attributes_maxdays) . "', '" . tep_db_input($products_attributes_maxcount) . "')"); 72 } 73 } 74 75 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 76 break; 77 case 'update_option_name': 78 $option_name_array = $HTTP_POST_VARS['option_name']; 79 $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']); 80 81 for ($i=0, $n=sizeof($languages); $i<$n; $i ++) { 82 $option_name = tep_db_prepare_input($option_name_array[$languages[$i]['id']]); 83 84 tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . tep_db_input($option_name) . "' where products_options_id = '" . (int)$option_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'"); 85 } 86 87 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 88 break; 89 case 'update_value': 90 $value_name_array = $HTTP_POST_VARS['value_name']; 91 $value_id = tep_db_prepare_input($HTTP_POST_VARS['value_id']); 92 $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']); 93 94 for ($i=0, $n=sizeof($languages); $i<$n; $i ++) { 95 $value_name = tep_db_prepare_input($value_name_array[$languages[$i]['id']]); 96 97 tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . tep_db_input($value_name) . "' where products_options_values_id = '" . tep_db_input($value_id) . "' and language_id = '" . (int)$languages[$i]['id'] . "'"); 98 } 99 100 tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " set products_options_id = '" . (int)$option_id . "' where products_options_values_id = '" . (int)$value_id . "'"); 101 102 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 103 break; 104 case 'update_product_attribute': 105 $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); 106 $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']); 107 $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']); 108 $value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']); 109 $price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']); 110 $attribute_id = tep_db_prepare_input($HTTP_POST_VARS['attribute_id']); 111 112 tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id = '" . (int)$products_id . "', options_id = '" . (int)$options_id . "', options_values_id = '" . (int)$values_id . "', options_values_price = '" . tep_db_input($value_price) . "', price_prefix = '" . tep_db_input($price_prefix) . "' where products_attributes_id = '" . (int)$attribute_id . "'"); 113 114 if (DOWNLOAD_ENABLED == 'true') { 115 $products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']); 116 $products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']); 117 $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']); 118 119 if (tep_not_null($products_attributes_filename)) { 120 tep_db_query("replace into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " set products_attributes_id = '" . (int)$attribute_id . "', products_attributes_filename = '" . tep_db_input($products_attributes_filename) . "', products_attributes_maxdays = '" . tep_db_input($products_attributes_maxdays) . "', products_attributes_maxcount = '" . tep_db_input($products_attributes_maxcount) . "'"); 121 } 122 } 123 124 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 125 break; 126 case 'delete_option': 127 $option_id = tep_db_prepare_input($HTTP_GET_VARS['option_id']); 128 129 tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$option_id . "'"); 130 131 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 132 break; 133 case 'delete_value': 134 $value_id = tep_db_prepare_input($HTTP_GET_VARS['value_id']); 135 136 tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$value_id . "'"); 137 tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$value_id . "'"); 138 tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . (int)$value_id . "'"); 139 140 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 141 break; 142 case 'delete_attribute': 143 $attribute_id = tep_db_prepare_input($HTTP_GET_VARS['attribute_id']); 144 145 tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . (int)$attribute_id . "'"); 146 147 // added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled 148 tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . (int)$attribute_id . "'"); 149 150 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); 151 break; 152 } 153 } 154 ?> 155 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 156 <html <?php echo HTML_PARAMS; ?>> 157 <head> 158 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 159 <title><?php echo TITLE; ?></title> 160 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> 161 <script language="javascript"><!-- 162 function go_option() { 163 if (document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value != "none") { 164 location = "<?php echo tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . ($HTTP_GET_VARS['option_page'] ? $HTTP_GET_VARS['option_page'] : 1)); ?>&option_order_by="+document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value; 165 } 166 } 167 //--></script> 168 </head> 169 <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> 170 <!-- header //--> 171 <?php require(DIR_WS_INCLUDES . 'header.php'); ?> 172 <!-- header_eof //--> 173 174 <!-- body //--> 175 <table border="0" width="100%" cellspacing="2" cellpadding="2"> 176 <tr> 177 <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> 178 <!-- left_navigation //--> 179 <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> 180 <!-- left_navigation_eof //--> 181 </table></td> 182 <!-- body_text //--> 183 <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 184 <!-- options and values//--> 185 <tr> 186 <td width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0"> 187 <tr> 188 <td valign="top" width="50%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> 189 <!-- options //--> 190 <?php 191 if ($action == 'delete_product_option') { // delete product option 192 $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$HTTP_GET_VARS['option_id'] . "' and language_id = '" . (int)$languages_id . "'"); 193 $options_values = tep_db_fetch_array($options); 194 ?> 195 <tr> 196 <td class="pageHeading"> <?php echo $options_values['products_options_name']; ?> </td> 197 <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> 198 </tr> 199 <tr> 200 <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> 201 <tr> 202 <td colspan="3"><?php echo tep_black_line(); ?></td> 203 </tr> 204 <?php 205 $products = tep_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 = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "' and pa.products_id = p.products_id and pa.options_id='" . (int)$HTTP_GET_VARS['option_id'] . "' and pov.products_options_values_id = pa.options_values_id order by pd.products_name"); 206 if (tep_db_num_rows($products)) { 207 ?> 208 <tr class="dataTableHeadingRow"> 209 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> 210 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> 211 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> 212 </tr> 213 <tr> 214 <td colspan="3"><?php echo tep_black_line(); ?></td> 215 </tr> 216 <?php 217 $rows = 0; 218 while ($products_values = tep_db_fetch_array($products)) { 219 $rows++; 220 ?> 221 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 222 <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> 223 <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> 224 <td class="smallText"> <?php echo $products_values['products_options_values_name']; ?> </td> 225 </tr> 226 <?php 227 } 228 ?> 229 <tr> 230 <td colspan="3"><?php echo tep_black_line(); ?></td> 231 </tr> 232 <tr> 233 <td colspan="3" class="main"><br><?php echo TEXT_WARNING_OF_DELETE; ?></td> 234 </tr> 235 <tr> 236 <td align="right" colspan="3" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['value_page']) ? 'value_page=' . $HTTP_GET_VARS['value_page'] . '&' : '') . (isset($HTTP_GET_VARS['attribute_page']) ? 'attribute_page=' . $HTTP_GET_VARS['attribute_page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td> 237 </tr> 238 <?php 239 } else { 240 ?> 241 <tr> 242 <td class="main" colspan="3"><br><?php echo TEXT_OK_TO_DELETE; ?></td> 243 </tr> 244 <tr> 245 <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option&option_id=' . $HTTP_GET_VARS['option_id'], 'NONSSL') . '">'; ?><?php echo tep_image_button('button_delete.gif', ' delete '); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['order_by']) ? 'order_by=' . $HTTP_GET_VARS['order_by'] . '&' : '') . (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td> 246 </tr> 247 <?php 248 } 249 ?> 250 </table></td> 251 </tr> 252 <?php 253 } else { 254 if (isset($HTTP_GET_VARS['option_order_by'])) { 255 $option_order_by = $HTTP_GET_VARS['option_order_by']; 256 } else { 257 $option_order_by = 'products_options_id'; 258 } 259 ?> 260 <tr> 261 <td colspan="2" class="pageHeading"> <?php echo HEADING_TITLE_OPT; ?> </td> 262 <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> 263 </tr> 264 <tr> 265 <td colspan="3" class="smallText"> 266 <?php 267 $per_page = MAX_ROW_LISTS_OPTIONS; 268 $options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by " . $option_order_by; 269 if (!isset($option_page)) { 270 $option_page = 1; 271 } 272 $prev_option_page = $option_page - 1; 273 $next_option_page = $option_page + 1; 274 275 $option_query = tep_db_query($options); 276 277 $option_page_start = ($per_page * $option_page) - $per_page; 278 $num_rows = tep_db_num_rows($option_query); 279 280 if ($num_rows <= $per_page) { 281 $num_pages = 1; 282 } else if (($num_rows % $per_page) == 0) { 283 $num_pages = ($num_rows / $per_page); 284 } else { 285 $num_pages = ($num_rows / $per_page) + 1; 286 } 287 $num_pages = (int) $num_pages; 288 289 $options = $options . " LIMIT $option_page_start, $per_page"; 290 291 // Previous 292 if ($prev_option_page) { 293 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $prev_option_page) . '"> << </a> | '; 294 } 295 296 for ($i = 1; $i <= $num_pages; $i++) { 297 if ($i != $option_page) { 298 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $i) . '">' . $i . '</a> | '; 299 } else { 300 echo '<b><font color=red>' . $i . '</font></b> | '; 301 } 302 } 303 304 // Next 305 if ($option_page != $num_pages) { 306 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $next_option_page) . '"> >> </a>'; 307 } 308 ?> 309 </td> 310 </tr> 311 <tr> 312 <td colspan="3"><?php echo tep_black_line(); ?></td> 313 </tr> 314 <tr class="dataTableHeadingRow"> 315 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td> 316 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> 317 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> 318 </tr> 319 <tr> 320 <td colspan="3"><?php echo tep_black_line(); ?></td> 321 </tr> 322 <?php 323 $next_id = 1; 324 $rows = 0; 325 $options = tep_db_query($options); 326 while ($options_values = tep_db_fetch_array($options)) { 327 $rows++; 328 ?> 329 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 330 <?php 331 if (($action == 'update_option') && ($HTTP_GET_VARS['option_id'] == $options_values['products_options_id'])) { 332 echo '<form name="option" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_name', 'NONSSL') . '" method="post">'; 333 $inputs = ''; 334 for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { 335 $option_name = tep_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'] . "'"); 336 $option_name = tep_db_fetch_array($option_name); 337 $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20" value="' . $option_name['products_options_name'] . '"> <br>'; 338 } 339 ?> 340 <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> 341 <td class="smallText"><?php echo $inputs; ?></td> 342 <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td> 343 <?php 344 echo '</form>' . "\n"; 345 } else { 346 ?> 347 <td align="center" class="smallText"> <?php echo $options_values["products_options_id"]; ?> </td> 348 <td class="smallText"> <?php echo $options_values["products_options_name"]; ?> </td> 349 <td align="center" class="smallText"> <?php echo '<a href="' . tep_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 tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_product_option&option_id=' . $options_values['products_options_id'], 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td> 350 <?php 351 } 352 ?> 353 </tr> 354 <?php 355 $max_options_id_query = tep_db_query("select max(products_options_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS); 356 $max_options_id_values = tep_db_fetch_array($max_options_id_query); 357 $next_id = $max_options_id_values['next_id']; 358 } 359 ?> 360 <tr> 361 <td colspan="3"><?php echo tep_black_line(); ?></td> 362 </tr> 363 <?php 364 if ($action != 'update_option') { 365 ?> 366 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 367 <?php 368 echo '<form name="options" action="' . tep_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 . '">'; 369 $inputs = ''; 370 for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { 371 $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20"> <br>'; 372 } 373 ?> 374 <td align="center" class="smallText"> <?php echo $next_id; ?> </td> 375 <td class="smallText"><?php echo $inputs; ?></td> 376 <td align="center" class="smallText"> <?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?> </td> 377 <?php 378 echo '</form>'; 379 ?> 380 </tr> 381 <tr> 382 <td colspan="3"><?php echo tep_black_line(); ?></td> 383 </tr> 384 <?php 385 } 386 } 387 ?> 388 </table></td> 389 <!-- options eof //--> 390 <td valign="top" width="50%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> 391 <!-- value //--> 392 <?php 393 if ($action == 'delete_option_value') { // delete product option value 394 $values = tep_db_query("select products_options_values_id, products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$HTTP_GET_VARS['value_id'] . "' and language_id = '" . (int)$languages_id . "'"); 395 $values_values = tep_db_fetch_array($values); 396 ?> 397 <tr> 398 <td colspan="3" class="pageHeading"> <?php echo $values_values['products_options_values_name']; ?> </td> 399 <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> 400 </tr> 401 <tr> 402 <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> 403 <tr> 404 <td colspan="3"><?php echo tep_black_line(); ?></td> 405 </tr> 406 <?php 407 $products = tep_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 = '" . (int)$languages_id . "' and po.language_id = '" . (int)$languages_id . "' and pa.products_id = p.products_id and pa.options_values_id='" . (int)$HTTP_GET_VARS['value_id'] . "' and po.products_options_id = pa.options_id order by pd.products_name"); 408 if (tep_db_num_rows($products)) { 409 ?> 410 <tr class="dataTableHeadingRow"> 411 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> 412 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> 413 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> 414 </tr> 415 <tr> 416 <td colspan="3"><?php echo tep_black_line(); ?></td> 417 </tr> 418 <?php 419 while ($products_values = tep_db_fetch_array($products)) { 420 $rows++; 421 ?> 422 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 423 <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> 424 <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> 425 <td class="smallText"> <?php echo $products_values['products_options_name']; ?> </td> 426 </tr> 427 <?php 428 } 429 ?> 430 <tr> 431 <td colspan="3"><?php echo tep_black_line(); ?></td> 432 </tr> 433 <tr> 434 <td class="main" colspan="3"><br><?php echo TEXT_WARNING_OF_DELETE; ?></td> 435 </tr> 436 <tr> 437 <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['value_page']) ? 'value_page=' . $HTTP_GET_VARS['value_page'] . '&' : '') . (isset($HTTP_GET_VARS['attribute_page']) ? 'attribute_page=' . $attribute_page : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td> 438 </tr> 439 <?php 440 } else { 441 ?> 442 <tr> 443 <td class="main" colspan="3"><br><?php echo TEXT_OK_TO_DELETE; ?></td> 444 </tr> 445 <tr> 446 <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_value&value_id=' . $HTTP_GET_VARS['value_id'], 'NONSSL') . '">'; ?><?php echo tep_image_button('button_delete.gif', ' delete '); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&option_page=' . $option_page . (isset($HTTP_GET_VARS['value_page']) ? '&value_page=' . $value_page : '') . (isset($HTTP_GET_VARS['attribute_page']) ? '&attribute_page=' . $attribute_page : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td> 447 </tr> 448 <?php 449 } 450 ?> 451 </table></td> 452 </tr> 453 <?php 454 } else { 455 ?> 456 <tr> 457 <td colspan="3" class="pageHeading"> <?php echo HEADING_TITLE_VAL; ?> </td> 458 <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> 459 </tr> 460 <tr> 461 <td colspan="4" class="smallText"> 462 <?php 463 $per_page = MAX_ROW_LISTS_OPTIONS; 464 $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 = '" . (int)$languages_id . "' order by pov.products_options_values_id"; 465 if (!isset($value_page)) { 466 $value_page = 1; 467 } 468 $prev_value_page = $value_page - 1; 469 $next_value_page = $value_page + 1; 470 471 $value_query = tep_db_query($values); 472 473 $value_page_start = ($per_page * $value_page) - $per_page; 474 $num_rows = tep_db_num_rows($value_query); 475 476 if ($num_rows <= $per_page) { 477 $num_pages = 1; 478 } else if (($num_rows % $per_page) == 0) { 479 $num_pages = ($num_rows / $per_page); 480 } else { 481 $num_pages = ($num_rows / $per_page) + 1; 482 } 483 $num_pages = (int) $num_pages; 484 485 $values = $values . " LIMIT $value_page_start, $per_page"; 486 487 // Previous 488 if ($prev_value_page) { 489 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> << </a> | '; 490 } 491 492 for ($i = 1; $i <= $num_pages; $i++) { 493 if ($i != $value_page) { 494 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $i) . '">' . $i . '</a> | '; 495 } else { 496 echo '<b><font color=red>' . $i . '</font></b> | '; 497 } 498 } 499 500 // Next 501 if ($value_page != $num_pages) { 502 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $next_value_page) . '"> >></a> '; 503 } 504 ?> 505 </td> 506 </tr> 507 <tr> 508 <td colspan="4"><?php echo tep_black_line(); ?></td> 509 </tr> 510 <tr class="dataTableHeadingRow"> 511 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td> 512 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> 513 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> 514 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> 515 </tr> 516 <tr> 517 <td colspan="4"><?php echo tep_black_line(); ?></td> 518 </tr> 519 <?php 520 $next_id = 1; 521 $rows = 0; 522 $values = tep_db_query($values); 523 while ($values_values = tep_db_fetch_array($values)) { 524 $options_name = tep_options_name($values_values['products_options_id']); 525 $values_name = $values_values['products_options_values_name']; 526 $rows++; 527 ?> 528 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 529 <?php 530 if (($action == 'update_option_value') && ($HTTP_GET_VARS['value_id'] == $values_values['products_options_values_id'])) { 531 echo '<form name="values" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_value', 'NONSSL') . '" method="post">'; 532 $inputs = ''; 533 for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { 534 $value_name = tep_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$values_values['products_options_values_id'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'"); 535 $value_name = tep_db_fetch_array($value_name); 536 $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15" value="' . $value_name['products_options_values_name'] . '"> <br>'; 537 } 538 ?> 539 <td align="center" class="smallText"> <?php echo $values_values['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values['products_options_values_id']; ?>"> </td> 540 <td align="center" class="smallText"> <?php echo "\n"; ?><select name="option_id"> 541 <?php 542 $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_name"); 543 while ($options_values = tep_db_fetch_array($options)) { 544 echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '"'; 545 if ($values_values['products_options_id'] == $options_values['products_options_id']) { 546 echo ' selected'; 547 } 548 echo '>' . $options_values['products_options_name'] . '</option>'; 549 } 550 ?> 551 </select> </td> 552 <td class="smallText"><?php echo $inputs; ?></td> 553 <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td> 554 <?php 555 echo '</form>'; 556 } else { 557 ?> 558 <td align="center" class="smallText"> <?php echo $values_values["products_options_values_id"]; ?> </td> 559 <td align="center" class="smallText"> <?php echo $options_name; ?> </td> 560 <td class="smallText"> <?php echo $values_name; ?> </td> 561 <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_value&value_id=' . $values_values['products_options_values_id'] . (isset($HTTP_GET_VARS['value_page']) ? '&value_page=' . $HTTP_GET_VARS['value_page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option_value&value_id=' . $values_values['products_options_values_id'], 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td> 562 <?php 563 } 564 $max_values_id_query = tep_db_query("select max(products_options_values_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS_VALUES); 565 $max_values_id_values = tep_db_fetch_array($max_values_id_query); 566 $next_id = $max_values_id_values['next_id']; 567 } 568 ?> 569 </tr> 570 <tr> 571 <td colspan="4"><?php echo tep_black_line(); ?></td> 572 </tr> 573 <?php 574 if ($action != 'update_option_value') { 575 ?> 576 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 577 <?php 578 echo '<form name="values" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_option_values&value_page=' . $value_page, 'NONSSL') . '" method="post">'; 579 ?> 580 <td align="center" class="smallText"> <?php echo $next_id; ?> </td> 581 <td align="center" class="smallText"> <select name="option_id"> 582 <?php 583 $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name"); 584 while ($options_values = tep_db_fetch_array($options)) { 585 echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>'; 586 } 587 588 $inputs = ''; 589 for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { 590 $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15"> <br>'; 591 } 592 ?> 593 </select> </td> 594 <td class="smallText"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs; ?></td> 595 <td align="center" class="smallText"> <?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?> </td> 596 <?php 597 echo '</form>'; 598 ?> 599 </tr> 600 <tr> 601 <td colspan="4"><?php echo tep_black_line(); ?></td> 602 </tr> 603 <?php 604 } 605 } 606 ?> 607 </table></td> 608 </tr> 609 </table></td> 610 <!-- option value eof //--> 611 </tr> 612 <!-- products_attributes //--> 613 <tr> 614 <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 615 <tr> 616 <td class="pageHeading"> <?php echo HEADING_TITLE_ATRIB; ?> </td> 617 <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> 618 </tr> 619 </table></td> 620 </tr> 621 <tr> 622 <?php 623 if ($action == 'update_attribute') { 624 $form_action = 'update_product_attribute'; 625 } else { 626 $form_action = 'add_product_attributes'; 627 } 628 629 if (!isset($attribute_page)) { 630 $attribute_page = 1; 631 } 632 $prev_attribute_page = $attribute_page - 1; 633 $next_attribute_page = $attribute_page + 1; 634 ?> 635 <td><form name="attributes" action="<?php echo tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=' . $form_action . '&option_page=' . $option_page . '&value_page=' . $value_page . '&attribute_page=' . $attribute_page); ?>" method="post"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 636 <tr> 637 <td colspan="7" class="smallText"> 638 <?php 639 $per_page = MAX_ROW_LISTS_OPTIONS; 640 $attributes = "select pa.* from " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pa.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name"; 641 $attribute_query = tep_db_query($attributes); 642 643 $attribute_page_start = ($per_page * $attribute_page) - $per_page; 644 $num_rows = tep_db_num_rows($attribute_query); 645 646 if ($num_rows <= $per_page) { 647 $num_pages = 1; 648 } else if (($num_rows % $per_page) == 0) { 649 $num_pages = ($num_rows / $per_page); 650 } else { 651 $num_pages = ($num_rows / $per_page) + 1; 652 } 653 $num_pages = (int) $num_pages; 654 655 $attributes = $attributes . " LIMIT $attribute_page_start, $per_page"; 656 657 // Previous 658 if ($prev_attribute_page) { 659 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'attribute_page=' . $prev_attribute_page) . '"> << </a> | '; 660 } 661 662 for ($i = 1; $i <= $num_pages; $i++) { 663 if ($i != $attribute_page) { 664 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'attribute_page=' . $i) . '">' . $i . '</a> | '; 665 } else { 666 echo '<b><font color="red">' . $i . '</font></b> | '; 667 } 668 } 669 670 // Next 671 if ($attribute_page != $num_pages) { 672 echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'attribute_page=' . $next_attribute_page) . '"> >> </a>'; 673 } 674 ?> 675 </td> 676 </tr> 677 <tr> 678 <td colspan="7"><?php echo tep_black_line(); ?></td> 679 </tr> 680 <tr class="dataTableHeadingRow"> 681 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td> 682 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> 683 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> 684 <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> 685 <td class="dataTableHeadingContent" align="right"> <?php echo TABLE_HEADING_OPT_PRICE; ?> </td> 686 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_OPT_PRICE_PREFIX; ?> </td> 687 <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> 688 </tr> 689 <tr> 690 <td colspan="7"><?php echo tep_black_line(); ?></td> 691 </tr> 692 <?php 693 $next_id = 1; 694 $attributes = tep_db_query($attributes); 695 while ($attributes_values = tep_db_fetch_array($attributes)) { 696 $products_name_only = tep_get_products_name($attributes_values['products_id']); 697 $options_name = tep_options_name($attributes_values['options_id']); 698 $values_name = tep_values_name($attributes_values['options_values_id']); 699 $rows++; 700 ?> 701 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 702 <?php 703 if (($action == 'update_attribute') && ($HTTP_GET_VARS['attribute_id'] == $attributes_values['products_attributes_id'])) { 704 ?> 705 <td class="smallText"> <?php echo $attributes_values['products_attributes_id']; ?><input type="hidden" name="attribute_id" value="<?php echo $attributes_values['products_attributes_id']; ?>"> </td> 706 <td class="smallText"> <select name="products_id"> 707 <?php 708 $products = tep_db_query("select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' order by pd.products_name"); 709 while($products_values = tep_db_fetch_array($products)) { 710 if ($attributes_values['products_id'] == $products_values['products_id']) { 711 echo "\n" . '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '" SELECTED>' . $products_values['products_name'] . '</option>'; 712 } else { 713 echo "\n" . '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_name'] . '</option>'; 714 } 715 } 716 ?> 717 </select> </td> 718 <td class="smallText"> <select name="options_id"> 719 <?php 720 $options = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name"); 721 while($options_values = tep_db_fetch_array($options)) { 722 if ($attributes_values['options_id'] == $options_values['products_options_id']) { 723 echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '" SELECTED>' . $options_values['products_options_name'] . '</option>'; 724 } else { 725 echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>'; 726 } 727 } 728 ?> 729 </select> </td> 730 <td class="smallText"> <select name="values_id"> 731 <?php 732 $values = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where language_id ='" . $languages_id . "' order by products_options_values_name"); 733 while($values_values = tep_db_fetch_array($values)) { 734 if ($attributes_values['options_values_id'] == $values_values['products_options_values_id']) { 735 echo "\n" . '<option name="' . $values_values['products_options_values_name'] . '" value="' . $values_values['products_options_values_id'] . '" SELECTED>' . $values_values['products_options_values_name'] . '</option>'; 736 } else { 737 echo "\n" . '<option name="' . $values_values['products_options_values_name'] . '" value="' . $values_values['products_options_values_id'] . '">' . $values_values['products_options_values_name'] . '</option>'; 738 } 739 } 740 ?> 741 </select> </td> 742 <td align="right" class="smallText"> <input type="text" name="value_price" value="<?php echo $attributes_values['options_values_price']; ?>" size="6"> </td> 743 <td align="center" class="smallText"> <input type="text" name="price_prefix" value="<?php echo $attributes_values['price_prefix']; ?>" size="2"> </td> 744 <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&attribute_page=' . $attribute_page, 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td> 745 <?php 746 if (DOWNLOAD_ENABLED == 'true') { 747 $download_query_raw ="select products_attributes_filename, products_attributes_maxdays, products_attributes_maxcount 748 from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " 749 where products_attributes_id='" . $attributes_values['products_attributes_id'] . "'"; 750 $download_query = tep_db_query($download_query_raw); 751 if (tep_db_num_rows($download_query) > 0) { 752 $download = tep_db_fetch_array($download_query); 753 $products_attributes_filename = $download['products_attributes_filename']; 754 $products_attributes_maxdays = $download['products_attributes_maxdays']; 755 $products_attributes_maxcount = $download['products_attributes_maxcount']; 756 } 757 ?> 758 <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>"> 759 <td> </td> 760 <td colspan="5"> 761 <table> 762 <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>"> 763 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DOWNLOAD; ?> </td> 764 <td class="smallText"><?php echo TABLE_TEXT_FILENAME; ?></td> 765 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_filename', $products_attributes_filename, 'size="15"'); ?> </td> 766 <td class="smallText"><?php echo TABLE_TEXT_MAX_DAYS; ?></td> 767 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxdays', $products_attributes_maxdays, 'size="5"'); ?> </td> 768 <td class="smallText"><?php echo TABLE_TEXT_MAX_COUNT; ?></td> 769 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td> 770 </tr> 771 </table> 772 </td> 773 <td> </td> 774 </tr> 775 <?php 776 } 777 ?> 778 <?php 779 } elseif (($action == 'delete_product_attribute') && ($HTTP_GET_VARS['attribute_id'] == $attributes_values['products_attributes_id'])) { 780 ?> 781 <td class="smallText"> <b><?php echo $attributes_values["products_attributes_id"]; ?></b> </td> 782 <td class="smallText"> <b><?php echo $products_name_only; ?></b> </td> 783 <td class="smallText"> <b><?php echo $options_name; ?></b> </td> 784 <td class="smallText"> <b><?php echo $values_name; ?></b> </td> 785 <td align="right" class="smallText"> <b><?php echo $attributes_values["options_values_price"]; ?></b> </td> 786 <td align="center" class="smallText"> <b><?php echo $attributes_values["price_prefix"]; ?></b> </td> 787 <td align="center" class="smallText"> <b><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_attribute&attribute_id=' . $HTTP_GET_VARS['attribute_id']) . '">'; ?><?php echo tep_image_button('button_confirm.gif', IMAGE_CONFIRM); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&option_page=' . $option_page . '&value_page=' . $value_page . '&attribute_page=' . $attribute_page, 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </b></td> 788 <?php 789 } else { 790 ?> 791 <td class="smallText"> <?php echo $attributes_values["products_attributes_id"]; ?> </td> 792 <td class="smallText"> <?php echo $products_name_only; ?> </td> 793 <td class="smallText"> <?php echo $options_name; ?> </td> 794 <td class="smallText"> <?php echo $values_name; ?> </td> 795 <td align="right" class="smallText"> <?php echo $attributes_values["options_values_price"]; ?> </td> 796 <td align="center" class="smallText"> <?php echo $attributes_values["price_prefix"]; ?> </td> 797 <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_attribute&attribute_id=' . $attributes_values['products_attributes_id'] . '&attribute_page=' . $attribute_page, 'NONSSL') . '">'; ?><?php echo tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_product_attribute&attribute_id=' . $attributes_values['products_attributes_id'] . '&attribute_page=' . $attribute_page, 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td> 798 <?php 799 } 800 $max_attributes_id_query = tep_db_query("select max(products_attributes_id) + 1 as next_id from " . TABLE_PRODUCTS_ATTRIBUTES); 801 $max_attributes_id_values = tep_db_fetch_array($max_attributes_id_query); 802 $next_id = $max_attributes_id_values['next_id']; 803 ?> 804 </tr> 805 <?php 806 } 807 if ($action != 'update_attribute') { 808 ?> 809 <tr> 810 <td colspan="7"><?php echo tep_black_line(); ?></td> 811 </tr> 812 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> 813 <td class="smallText"> <?php echo $next_id; ?> </td> 814 <td class="smallText"> <select name="products_id"> 815 <?php 816 $products = tep_db_query("select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' order by pd.products_name"); 817 while ($products_values = tep_db_fetch_array($products)) { 818 echo '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_name'] . '</option>'; 819 } 820 ?> 821 </select> </td> 822 <td class="smallText"> <select name="options_id"> 823 <?php 824 $options = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name"); 825 while ($options_values = tep_db_fetch_array($options)) { 826 echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>'; 827 } 828 ?> 829 </select> </td> 830 <td class="smallText"> <select name="values_id"> 831 <?php 832 $values = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where language_id = '" . $languages_id . "' order by products_options_values_name"); 833 while ($values_values = tep_db_fetch_array($values)) { 834 echo '<option name="' . $values_values['products_options_values_name'] . '" value="' . $values_values['products_options_values_id'] . '">' . $values_values['products_options_values_name'] . '</option>'; 835 } 836 ?> 837 </select> </td> 838 <td align="right" class="smallText"> <input type="text" name="value_price" size="6"> </td> 839 <td align="right" class="smallText"> <input type="text" name="price_prefix" size="2" value="+"> </td> 840 <td align="center" class="smallText"> <?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?> </td> 841 </tr> 842 <?php 843 if (DOWNLOAD_ENABLED == 'true') { 844 $products_attributes_maxdays = DOWNLOAD_MAX_DAYS; 845 $products_attributes_maxcount = DOWNLOAD_MAX_COUNT; 846 ?> 847 <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>"> 848 <td> </td> 849 <td colspan="5"> 850 <table> 851 <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>"> 852 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DOWNLOAD; ?> </td> 853 <td class="smallText"><?php echo TABLE_TEXT_FILENAME; ?></td> 854 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_filename', $products_attributes_filename, 'size="15"'); ?> </td> 855 <td class="smallText"><?php echo TABLE_TEXT_MAX_DAYS; ?></td> 856 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxdays', $products_attributes_maxdays, 'size="5"'); ?> </td> 857 <td class="smallText"><?php echo TABLE_TEXT_MAX_COUNT; ?></td> 858 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td> 859 </tr> 860 </table> 861 </td> 862 <td> </td> 863 </tr> 864 <?php 865 } // end of DOWNLOAD_ENABLED section 866 ?> 867 <?php 868 } 869 ?> 870 <tr> 871 <td colspan="7"><?php echo tep_black_line(); ?></td> 872 </tr> 873 </table></form></td> 874 </tr> 875 </table></td> 876 <!-- products_attributes_eof //--> 877 </tr> 878 </table> 879 <!-- body_text_eof //--> 880 <!-- footer //--> 881 <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> 882 <!-- footer_eof //--> 883 </body> 884 </html> 885 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Mon Nov 26 19:48:25 2007 | par Balluche grâce à PHPXref 0.7 |
|
|