products_attributes_v.php

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

                
              </tr>
              <tr bgcolor="<?=ALTBG2?>">
                <td align="center">&nbsp;<?php echo $values_values['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values['products_options_values_id']; ?>">&nbsp;</td>
                <td align="center">&nbsp;<?php echo "\n"; ?><select name="option_id">
<?php
        $options = $db->query("select products_options_id, products_options_name from $table_products_options where language_id = '" . (int)$languages_id . "' order by products_options_name");
        while ($options_values = $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>&nbsp;</td>
                <td><?php echo $inputs; ?></td>
</tr>
</table></td></tr></table>
<br>
<center><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?>&nbsp;<?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a>&nbsp;</center>
</form>
<?php
     break;
  }
}else{
?>
<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>
<?
    $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 = '" . (int)$languages_id . "' order by pov.products_options_values_id";
    if (!isset($value_page)) {
      $value_page = 1;
    }
    $prev_value_page = $value_page - 1;
    $next_value_page = $value_page + 1;

    $value_query = $db->query($values);

    $value_page_start = ($per_page * $value_page) - $per_page;
    $num_rows = $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";

    if ($prev_value_page)  {
        echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> &lt;&lt; </a> | ';
    }

    for ($i = 1; $i <= $num_pages; $i++) {
       if ($i != $value_page) {
           echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&'.(isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $i) . '">' . $i . '</a> | ';
       } else {
           echo '<b><font color=red>' . $i . '</font></b> | ';
       }
    }

    if ($value_page != $num_pages) {
        echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&'.(isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $next_value_page) . '"> &gt;&gt;</a> ';
    }
?>
                </td>
              </tr>
</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>&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>
                <td align="center">&nbsp;<?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
              </tr>
<?php
    $next_id = 1;
    $rows = 0;
    $values = $db->query($values);
    while ($values_values = $db->fetch_array($values)) {
       $options_name = tep_options_name($values_values['products_options_id']);
       $values_name = $values_values['products_options_values_name'];
       $rows++;
?>
              <tr bgcolor="<?=ALTBG2?>">
<?php

?>
                <td align="center">&nbsp;<?php echo $values_values["products_options_values_id"]; ?>&nbsp;</td>
                <td align="center">&nbsp;<?php echo $options_name; ?>&nbsp;</td>
                <td>&nbsp;<?php echo $values_name; ?>&nbsp;</td>
                <td align="center">&nbsp;<?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&type=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') . '">'; ?><?=IMAGE_UPDATE?></a>&nbsp;&nbsp;<?php echo '<a href="' . tep_href_link('admincp.php', 'act=products_attributes_v&type=delete_option_value&value_id=' . $values_values['products_options_values_id'], 'NONSSL') , '">'; ?><?=IMAGE_DELETE?></a>&nbsp;</td>
<?php

       $max_values_id_query = $db->query("select max(products_options_values_id) + 1 as next_id from $table_products_options_values");
       $max_values_id_values = $db->fetch_array($max_values_id_query);
       $next_id = $max_values_id_values['next_id'];
    }
?>
              </tr>
              <tr bgcolor="<?=ALTBG2?>">
<?php
      echo '<form name="values" action="' . tep_href_link('admincp.php', 'act=products_attributes_v&action=add_product_option_values&value_page=' . $value_page, 'NONSSL') . '" method="post">';
?>
                <td align="center" class="smallText">&nbsp;<?php echo $next_id; ?>&nbsp;</td>
                <td align="center" class="smallText">&nbsp;<select name="option_id">
<?php
      $options = $db->query("select products_options_id, products_options_name from $table_products_options where language_id = '" . $languages_id . "' order by products_options_name");
      while ($options_values = $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 = '';
      for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
          $inputs .= $languages[$i]['code'] . ':&nbsp;<input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15">&nbsp;<br>';
      }
?>
                </select>&nbsp;</td>
                <td class="smallText"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs; ?></td>
                <td align="center" class="smallText">&nbsp;</td>
              </tr>
</table></td></tr></table>  
<br>
<center>&nbsp;<?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?>&nbsp;</center>
</form>           
<?php
}    
?>