documentation/zencart/orders__status_8php_source.html

00001 <?php
00010   require('includes/application_top.php');
00011
00012   $action = (isset($_GET['action']) ? $_GET['action'] : '');
00013
00014   if (zen_not_null($action)) {
00015     switch ($action) {
00016       case 'insert':
00017       case 'save':
00018         if (isset($_GET['oID'])) $orders_status_id = zen_db_prepare_input($_GET['oID']);
00019
00020         $languages = zen_get_languages();
00021         for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
00022           $orders_status_name_array = $_POST['orders_status_name'];
00023           $language_id = $languages[$i]['id'];
00024
00025           $sql_data_array = array('orders_status_name' => zen_db_prepare_input($orders_status_name_array[$language_id]));
00026
00027           if ($action == 'insert') {
00028             if (empty($orders_status_id)) {
00029               $next_id = $db->Execute("select max(orders_status_id)
00030                                              as orders_status_id from " . TABLE_ORDERS_STATUS . "");
00031
00032               $orders_status_id = $next_id->fields['orders_status_id'] + 1;
00033             }
00034
00035             $insert_sql_data = array('orders_status_id' => $orders_status_id,
00036                                      'language_id' => $language_id);
00037
00038             $sql_data_array = array_merge($sql_data_array, $insert_sql_data);
00039
00040             zen_db_perform(TABLE_ORDERS_STATUS, $sql_data_array);
00041           } elseif ($action == 'save') {
00042             zen_db_perform(TABLE_ORDERS_STATUS, $sql_data_array, 'update', "orders_status_id = '" . (int)$orders_status_id . "' and language_id = '" . (int)$language_id . "'");
00043           }
00044         }
00045
00046         if (isset($_POST['default']) && ($_POST['default'] == 'on')) {
00047           $db->Execute("update " . TABLE_CONFIGURATION . "
00048                         set configuration_value = '" . zen_db_input($orders_status_id) . "'
00049                         where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
00050         }
00051
00052         zen_redirect(zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $orders_status_id));
00053         break;
00054       case 'deleteconfirm':
00055         // demo active test
00056         if (zen_admin_demo()) {
00057           $_GET['action']= '';
00058           $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
00059           zen_redirect(zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page']));
00060         }
00061         $oID = zen_db_prepare_input($_POST['oID']);
00062
00063         $orders_status = $db->Execute("select configuration_value
00064                                        from " . TABLE_CONFIGURATION . "
00065                                        where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
00066
00067         if ($orders_status->fields['configuration_value'] == $oID) {
00068           $db->Execute("update " . TABLE_CONFIGURATION . "
00069                         set configuration_value = ''
00070                         where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
00071         }
00072
00073         $db->Execute("delete from " . TABLE_ORDERS_STATUS . "
00074                       where orders_status_id = '" . zen_db_input($oID) . "'");
00075
00076         zen_redirect(zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page']));
00077         break;
00078       case 'delete':
00079         $oID = zen_db_prepare_input($_GET['oID']);
00080
00081         $status = $db->Execute("select count(*) as count
00082                                 from " . TABLE_ORDERS . "
00083                                 where orders_status = '" . (int)$oID . "'");
00084
00085         $remove_status = true;
00086         if ($oID == DEFAULT_ORDERS_STATUS_ID) {
00087           $remove_status = false;
00088           $messageStack->add(ERROR_REMOVE_DEFAULT_ORDER_STATUS, 'error');
00089         } elseif ($status->fields['count'] > 0) {
00090           $remove_status = false;
00091           $messageStack->add(ERROR_STATUS_USED_IN_ORDERS, 'error');
00092         } else {
00093           $history = $db->Execute("select count(*) as count
00094                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
00095                                    where orders_status_id = '" . (int)$oID . "'");
00096
00097           if ($history->fields['count'] > 0) {
00098             $remove_status = false;
00099             $messageStack->add(ERROR_STATUS_USED_IN_HISTORY, 'error');
00100           }
00101         }
00102         break;
00103     }
00104   }
00105 ?>
00106 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
00107 <html <?php echo HTML_PARAMS; ?>>
00108 <head>
00109 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
00110 <title><?php echo TITLE; ?></title>
00111 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
00112 <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
00113 <script language="javascript" src="includes/menu.js"></script>
00114 <script language="javascript" src="includes/general.js"></script>
00115 <script type="text/javascript">
00116   <!--
00117   function init()
00118   {
00119     cssjsmenu('navbar');
00120     if (document.getElementById)
00121     {
00122       var kill = document.getElementById('hoverJS');
00123       kill.disabled = true;
00124     }
00125   }
00126   // -->
00127 </script>
00128 </head>
00129 <body onload="init()">
00130 <!-- header //-->
00131 <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
00132 <!-- header_eof //-->
00133
00134 <!-- body //-->
00135 <table border="0" width="100%" cellspacing="2" cellpadding="2">
00136   <tr>
00137 <!-- body_text //-->
00138     <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00139       <tr>
00140         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
00141           <tr>
00142             <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
00143             <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
00144           </tr>
00145         </table></td>
00146       </tr>
00147       <tr>
00148         <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
00149           <tr>
00150             <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00151               <tr class="dataTableHeadingRow">
00152                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ORDERS_STATUS; ?></td>
00153                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
00154               </tr>
00155 <?php
00156   $orders_status_query_raw = "select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$_SESSION['languages_id'] . "' order by orders_status_id";
00157   $orders_status_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_status_query_raw, $orders_status_query_numrows);
00158   $orders_status = $db->Execute($orders_status_query_raw);
00159   while (!$orders_status->EOF) {
00160     if ((!isset($_GET['oID']) || (isset($_GET['oID']) && ($_GET['oID'] == $orders_status->fields['orders_status_id']))) && !isset($oInfo) && (substr($action, 0, 3) != 'new')) {
00161       $oInfo = new objectInfo($orders_status->fields);
00162     }
00163
00164     if (isset($oInfo) && is_object($oInfo) && ($orders_status->fields['orders_status_id'] == $oInfo->orders_status_id)) {
00165       echo '                  <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id . '&action=edit') . '\'">' . "\n";
00166     } else {
00167       echo '                  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $orders_status->fields['orders_status_id']) . '\'">' . "\n";
00168     }
00169
00170     if (DEFAULT_ORDERS_STATUS_ID == $orders_status->fields['orders_status_id']) {
00171       echo '                <td class="dataTableContent"><b>' . $orders_status->fields['orders_status_name'] . ' (' . TEXT_DEFAULT . ')</b></td>' . "\n";
00172     } else {
00173       echo '                <td class="dataTableContent">' . $orders_status->fields['orders_status_name'] . '</td>' . "\n";
00174     }
00175 ?>
00176                 <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders_status->fields['orders_status_id'] == $oInfo->orders_status_id)) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $orders_status->fields['orders_status_id']) . '">' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>&nbsp;</td>
00177               </tr>
00178 <?php
00179     $orders_status->MoveNext();
00180   }
00181 ?>
00182               <tr>
00183                 <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00184                   <tr>
00185                     <td class="smallText" valign="top"><?php echo $orders_status_split->display_count($orders_status_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS_STATUS); ?></td>
00186                     <td class="smallText" align="right"><?php echo $orders_status_split->display_links($orders_status_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?></td>
00187                   </tr>
00188 <?php
00189   if (empty($action)) {
00190 ?>
00191                   <tr>
00192                     <td colspan="2" align="right"><?php echo '<a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&action=new') . '">' . zen_image_button('button_insert.gif', IMAGE_INSERT) . '</a>'; ?></td>
00193                   </tr>
00194 <?php
00195   }
00196 ?>
00197                 </table></td>
00198               </tr>
00199             </table></td>
00200 <?php
00201   $heading = array();
00202   $contents = array();
00203
00204   switch ($action) {
00205     case 'new':
00206       $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_ORDERS_STATUS . '</b>');
00207
00208       $contents = array('form' => zen_draw_form('status', FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&action=insert'));
00209       $contents[] = array('text' => TEXT_INFO_INSERT_INTRO);
00210
00211       $orders_status_inputs_string = '';
00212       $languages = zen_get_languages();
00213       for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
00214         $orders_status_inputs_string .= '<br>' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . zen_draw_input_field('orders_status_name[' . $languages[$i]['id'] . ']');
00215       }
00216
00217       $contents[] = array('text' => '<br>' . TEXT_INFO_ORDERS_STATUS_NAME . $orders_status_inputs_string);
00218       $contents[] = array('text' => '<br>' . zen_draw_checkbox_field('default') . ' ' . TEXT_SET_DEFAULT);
00219       $contents[] = array('align' => 'center', 'text' => '<br>' . zen_image_submit('button_insert.gif', IMAGE_INSERT) . ' <a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page']) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
00220       break;
00221     case 'edit':
00222       $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_ORDERS_STATUS . '</b>');
00223
00224       $contents = array('form' => zen_draw_form('status', FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id  . '&action=save'));
00225       $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);
00226
00227       $orders_status_inputs_string = '';
00228       $languages = zen_get_languages();
00229       for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
00230         $orders_status_inputs_string .= '<br>' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . zen_draw_input_field('orders_status_name[' . $languages[$i]['id'] . ']', htmlspecialchars(zen_get_orders_status_name($oInfo->orders_status_id, $languages[$i]['id']), ENT_COMPAT, CHARSET, TRUE));
00231       }
00232
00233       $contents[] = array('text' => '<br>' . TEXT_INFO_ORDERS_STATUS_NAME . $orders_status_inputs_string);
00234       if (DEFAULT_ORDERS_STATUS_ID != $oInfo->orders_status_id) $contents[] = array('text' => '<br>' . zen_draw_checkbox_field('default') . ' ' . TEXT_SET_DEFAULT);
00235       $contents[] = array('align' => 'center', 'text' => '<br>' . zen_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
00236       break;
00237     case 'delete':
00238       $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDERS_STATUS . '</b>');
00239
00240       $contents = array('form' => zen_draw_form('status', FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&action=deleteconfirm') . zen_draw_hidden_field('oID', $oInfo->orders_status_id));
00241       $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
00242       $contents[] = array('text' => '<br><b>' . $oInfo->orders_status_name . '</b>');
00243       if ($remove_status) $contents[] = array('align' => 'center', 'text' => '<br>' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
00244       break;
00245     default:
00246       if (isset($oInfo) && is_object($oInfo)) {
00247         $heading[] = array('text' => '<b>' . $oInfo->orders_status_name . '</b>');
00248
00249         $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id . '&action=edit') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->orders_status_id . '&action=delete') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
00250
00251         $orders_status_inputs_string = '';
00252         $languages = zen_get_languages();
00253         for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
00254           $orders_status_inputs_string .= '<br>' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . zen_get_orders_status_name($oInfo->orders_status_id, $languages[$i]['id']);
00255         }
00256
00257         $contents[] = array('text' => $orders_status_inputs_string);
00258       }
00259       break;
00260   }
00261
00262   if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) {
00263     echo '            <td width="25%" valign="top">' . "\n";
00264
00265     $box = new box;
00266     echo $box->infoBox($heading, $contents);
00267
00268     echo '            </td>' . "\n";
00269   }
00270 ?>
00271           </tr>
00272         </table></td>
00273       </tr>
00274     </table></td>
00275 <!-- body_text_eof //-->
00276   </tr>
00277 </table>
00278 <!-- body_eof //-->
00279
00280 <!-- footer //-->
00281 <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
00282 <!-- footer_eof //-->
00283 <br>
00284 </body>
00285 </html>
00286 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>