documentation/zencart/option__name_8php_source.html

00001 <?php
00009 ?>
00010 <?php
00011   require('includes/application_top.php');
00012
00013   // verify option names and values
00014   $chk_option_names = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id='" . (int)$_SESSION['languages_id'] . "' limit 1");
00015   if ($chk_option_names->RecordCount() < 1) {
00016     $messageStack->add_session(ERROR_DEFINE_OPTION_NAMES, 'caution');
00017     zen_redirect(zen_href_link(FILENAME_OPTIONS_NAME_MANAGER));
00018   }
00019
00020 //  if (!$lng_id) $_GET['lng_id'] = $_SESSION['languages_id'];
00021 //  if (!$_GET['lng_id']) $_GET['lng_id'] = $_SESSION['languages_id'];
00022
00023   $languages_array = array();
00024   $languages = zen_get_languages();
00025   $_GET['lng_exists'] = false;
00026   for ($i=0; $i<sizeof($languages); $i++) {
00027     if ($languages[$i]['id'] == $_GET['lng_id']) $_GET['lng_exists'] = true;
00028
00029     $languages_array[] = array('id' => $languages[$i]['id'],
00030                                'text' => $languages[$i]['name']);
00031   }
00032   if (!$_GET['lng_exists']==true) $_GET['lng_id'] = (int)$_SESSION['languages_id'];
00033
00034
00035 if ($_GET['action'] == "update_sort_order") {
00036     foreach($_POST['products_options_sort_order'] as $id => $new_sort_order) {
00037       $row++;
00038       $db->Execute("UPDATE " . TABLE_PRODUCTS_OPTIONS . " set products_options_sort_order= " . (int)$_POST['products_options_sort_order'][$id] . " where products_options_id=" . (int)$id . " and language_id=" . (int)$_GET['lng_id']);
00039     }
00040     $messageStack->add_session(SUCCESS_OPTION_SORT_ORDER, 'success');
00041     $_GET['action']='';
00042     zen_redirect(zen_href_link(FILENAME_PRODUCTS_OPTIONS_NAME, 'options_id=' . (int)$options_id . '&lng_id=' . (int)$_GET['lng_id']));
00043 }
00044
00045 ?>
00046 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
00047 <html <?php echo HTML_PARAMS; ?>>
00048 <head>
00049 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
00050 <title><?php echo TITLE; ?></title>
00051 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
00052 <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
00053 <script language="javascript" src="includes/menu.js"></script>
00054 <script language="javascript" src="includes/general.js"></script>
00055 <script type="text/javascript">
00056   <!--
00057   function init()
00058   {
00059     cssjsmenu('navbar');
00060     if (document.getElementById)
00061     {
00062       var kill = document.getElementById('hoverJS');
00063       kill.disabled = true;
00064     }
00065   }
00066   // -->
00067 </script>
00068 </head>
00069 <body onload="init()" marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
00070 <!-- header //-->
00071 <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
00072 <!-- header_eof //-->
00073
00074 <!-- body //-->
00075 <table border="0" width="100%" cellspacing="2" cellpadding="2">
00076   <tr>
00077 <!-- body_text //-->
00078     <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00079       <tr>
00080         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
00081           <tr>
00082             <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
00083             <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
00084           </tr>
00085         </table></td>
00086       </tr>
00087       <tr>
00088         <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
00089           <table border="1" cellspacing="3" cellpadding="2" bordercolor="gray">
00090             <tr class="dataTableHeadingRow">
00091               <td colspan="<?php echo ($_GET['lng_id']==$_SESSION['languages_id'] ? '5' : '8'); ?>" align="center" class="dataTableHeadingContent"><?php echo TEXT_EDIT_ALL; ?></td>
00092             </tr>
00093             <tr class="dataTableHeadingRow">
00094               <td colspan="3" align="center" class="dataTableHeadingContent"><?php echo ($_GET['lng_id'] !=$_SESSION['languages_id'] ? 'Current Language' : '&nbsp;'); ?></td>
00095               <?php echo zen_draw_form('lng', FILENAME_PRODUCTS_OPTIONS_NAME, '', 'get'); ?>
00096               <?php echo zen_hide_session_id(); ?>
00097               <td colspan="<?php echo ($_GET['lng_id']==$_SESSION['languages_id'] ? '2' : '5'); ?>" class="dataTableHeadingContent" align="center" valign="top"><?php echo  TEXT_SELECTED_LANGUAGE . zen_get_language_icon($_GET['lng_id']); ?>&nbsp;&nbsp;&nbsp;<?php echo zen_draw_pull_down_menu('lng_id', $languages_array, $_GET['lng_id'], 'onChange="this.form.submit();"'); ?></td>
00098               </form>
00099             </tr>
00100             <?php echo zen_draw_form('update', FILENAME_PRODUCTS_OPTIONS_NAME, 'action=update_sort_order&lng_id=' . $_GET['lng_id'], 'post'); ?>
00101 <?php
00102     echo '<tr class="dataTableHeadingRow">';
00103
00104     if ($_GET['lng_id'] != $_SESSION['languages_id']) {
00105     echo '  <td class="dataTableHeadingContent">&nbsp;</td>
00106             <td class="dataTableHeadingContent">' . TEXT_CURRENT_NAME . '</td>
00107             <td class="dataTableHeadingContent">' . TEXT_SORT_ORDER . '</td>';
00108     }
00109     echo '  <td class="dataTableHeadingContent">&nbsp;</td>
00110             <td class="dataTableHeadingContent">' . TEXT_OPTION_ID . '</td>
00111             <td class="dataTableHeadingContent">' . TEXT_OPTION_TYPE . '</td>
00112             <td class="dataTableHeadingContent">' . TEXT_OPTION_NAME . '</td>
00113             <td class="dataTableHeadingContent">' . TEXT_SORT_ORDER . '</td>
00114           </tr>
00115           <tr>';
00116     $row = $db->Execute("SELECT * FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE language_id = '" . (int)$_GET['lng_id'] . "' ORDER BY products_options_sort_order, products_options_id");
00117     while (!$row->EOF) {
00118       switch (true) {
00119         case ($row->fields['products_options_type']==PRODUCTS_OPTIONS_TYPE_RADIO):
00120           $the_attributes_type= '(RADIO)';
00121           break;
00122         case ($row->fields['products_options_type']==PRODUCTS_OPTIONS_TYPE_TEXT):
00123           $the_attributes_type= '(TEXT)';
00124           break;
00125         case ($row->fields['products_options_type']==PRODUCTS_OPTIONS_TYPE_FILE):
00126           $the_attributes_type= '(FILE)';
00127           break;
00128         case ($row->fields['products_options_type']==PRODUCTS_OPTIONS_TYPE_CHECKBOX):
00129           $the_attributes_type= '(CHECKBOX)';
00130           break;
00131         default:
00132           $the_attributes_type='(DROPDOWN)';
00133           break;
00134       }
00135
00136     if ($_GET['lng_id'] !=$_SESSION['languages_id']) {
00137             echo '<td align="center" class="dataTableContent">' . zen_get_language_icon($_SESSION['languages_id']) . '</td>' . "\n";
00138             echo '<td align="left" class="dataTableContent">' . zen_get_option_name_language($row->fields["products_options_id"], $_SESSION['languages_id']) . '</td>' . "\n";
00139             echo '<td align="right" class="dataTableContent">' . zen_get_option_name_language_sort_order($row->fields["products_options_id"], $_SESSION['languages_id']) . '&nbsp;&nbsp;</td>' . "\n";
00140     }
00141             echo '<td align="center" class="dataTableContent">' . zen_get_language_icon($_GET['lng_id']) . '</td>' . "\n";
00142             echo '<td align="right" class="dataTableContent">' . $row->fields["products_options_id"] . '</td>' . "\n";
00143             echo '<td class="dataTableContent" align="center">' . $the_attributes_type . '</td>' . "\n";
00144             echo '<td class="dataTableContent">' . $row->fields["products_options_name"] . '</td>' . "\n";
00145             echo '<td class="dataTableContent" align="center">' . "<input type=\"text\" name=\"products_options_sort_order[".$row->fields['products_options_id']."]\" value={$row->fields['products_options_sort_order']} size=\"4\">" . '</td>' . "\n";
00146             echo '</tr>' . "\n";
00147       $row->MoveNext();
00148     }
00149 ?>
00150             <tr class="dataTableHeadingRow">
00151               <td colspan="<?php echo ($_GET['lng_id']==$_SESSION['languages_id'] ? '1' : '4'); ?>" height="50" align="center" valign="middle" class="dataTableHeadingContent">&nbsp;</td>
00152               <td colspan="4" height="50" align="center" valign="middle" class="dataTableHeadingContent"><input type="submit" value="Update Sort Order"></td>
00153             </tr>
00154             </form>
00155           </table>
00156         </table></td>
00157       </tr>
00158     </table></td>
00159 <!-- body_text_eof //-->
00160   </tr>
00161 </table>
00162 <!-- body_eof //-->
00163
00164 <!-- footer //-->
00165 <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
00166 <!-- footer_eof //-->
00167 </body>
00168 </html>
00169 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>