products_attributes_v.php

来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 278 行 · 第 1/2 页

<?php
/*
  [SOOBIC!] admin/products_attributes_add_a.php 

	Version: 1.5
	Author: Soolan ([e-mail])
	Copyright: soolan (www.soobic.com)
	Last Modified: 2005/4/8 10:00

*/
if(!defined('IN_SOOBIC')) {
        exit('Access Denied');
}

require('admin/languages/'.$language.'/products_attributes.php');

cpheader();
$languages = tep_get_languages();

if (tep_not_null($action)) {
    $page_info = '';
    if (isset($HTTP_GET_VARS['option_page'])) $page_info .= 'option_page=' . $HTTP_GET_VARS['option_page'] . '&';
    if (isset($HTTP_GET_VARS['value_page'])) $page_info .= 'value_page=' . $HTTP_GET_VARS['value_page'] . '&';
    if (isset($HTTP_GET_VARS['attribute_page'])) $page_info .= 'attribute_page=' . $HTTP_GET_VARS['attribute_page'] . '&';
    if (tep_not_null($page_info)) {
        $page_info = substr($page_info, 0, -1);
    }

    switch ($action) {
      case 'add_product_option_values':
         $value_name_array = $value_name;

         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
            $value_name = ($value_name_array[$languages[$i]['id']]);

            $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'] . "', '" . ($value_name) . "')");
         }
         $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 . "')");
         tep_redirect(tep_href_link('admincp.php', 'act=products_attributes_v&'.$page_info));
      break;
      case 'update_value':
         $value_name_array = $value_name;
         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
            $value_name = ($value_name_array[$languages[$i]['id']]);
            $db->query("update $table_products_options_values set products_options_values_name = '" . ($value_name) . "' where products_options_values_id = '" . ($value_id) . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
         }
         $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 . "'");
         tep_redirect(tep_href_link('admincp.php', 'act=products_attributes_v&'.$page_info));
      break;
      case 'delete_value':
        $db->query("delete from $table_products_options_values where products_options_values_id = '" . (int)$value_id . "'");
        $db->query("delete from $table_products_options_values_to_products_options where products_options_values_id = '" . (int)$value_id . "'");

        tep_redirect(tep_href_link('admincp.php', 'act=products_attributes_v&'.$page_info));
        break;
   }
}elseif (tep_not_null($type)) {
   
	 switch($type){
      case 'delete_option_value':
         $values = $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 . "'");
         $values_values = $db->fetch_array($values);
         $products = $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");
?>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr bgcolor="<?=ALTBG2?>"><td>选项名称：<?php echo $values_values['products_options_values_name']; ?></td>
</tr>
</table></td></tr></table>
<br>
<?
         if ($db->num_rows($products)) {
?>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
				          <tr class="header">
                    <td align="center">&nbsp;<?php echo TABLE_HEADING_ID; ?>&nbsp;</td>
                    <td>&nbsp;<?php echo TABLE_HEADING_PRODUCT; ?>&nbsp;</td>
                    <td>&nbsp;<?php echo TABLE_HEADING_OPT_NAME; ?>&nbsp;</td>
                  </tr>
<?php
             while ($products_values = $db->fetch_array($products)) {
                 $rows++;
?>
                  <tr bgcolor="<?=ALTBG2?>">
									  <td align="center">&nbsp;<?php echo $products_values['products_id']; ?>&nbsp;</td>
                    <td>&nbsp;<?php echo $products_values['products_name']; ?>&nbsp;</td>
                    <td>&nbsp;<?php echo $products_values['products_options_name']; ?>&nbsp;</td>
                  </tr>
<?php
             }
?>
</table></td></tr></table><br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7">Soobic! 提示</td></tr>
                  <tr bgcolor="<?=ALTBG2?>">
                    <td align="center"><br><?php echo TEXT_WARNING_OF_DELETE; ?><br><br><br><br><?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&'.(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>
                  </tr>
</table></td></tr></table>
<?
				 }else {
?>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7">Soobic! 提示</td></tr>
                  <tr bgcolor="<?=ALTBG2?>">
                    <td align="center"><br><?php echo TEXT_OK_TO_DELETE; ?><br><br><br><br><?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&action=delete_value&value_id=' . $HTTP_GET_VARS['value_id'], 'NONSSL') . '">'; ?><?php echo tep_image_button('button_delete.gif', ' delete '); ?></a>&nbsp;&nbsp;&nbsp;<?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&&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>
                  </tr>
</table></td></tr></table>   
<?php
         }
?>
</table></td></tr></table>
<?
      break;
			case 'update_option_value':
         $query=$db->query("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 . "' and pov.products_options_values_id='$value_id' order by pov.products_options_values_id");
         $values_values = $db->fetch_array($query);
			   echo '<form name="values" action="' . tep_href_link('admincp.php', 'act=products_attributes_v&action=update_value', 'NONSSL') . '" method="post">';
         $inputs = '';
         for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
             $value_name = $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'] . "'");
             $value_name = $db->fetch_array($value_name);
             $inputs .= $languages[$i]['code'] . ':&nbsp;<input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15" value="' . $value_name['products_options_values_name'] . '">&nbsp;<br>';
        }
?>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
              <tr class="header">
                <td>&nbsp;<?php echo TABLE_HEADING_ID; ?>&nbsp;</td>
                <td>&nbsp;<?php echo TABLE_HEADING_OPT_NAME; ?>&nbsp;</td>
                <td>&nbsp;<?php echo TABLE_HEADING_OPT_VALUE; ?>&nbsp;</td>