define('TEXT_INFO_SORT_BY','Řadit podle: ');

define('TEXT_INFO_SORT_BY','<strong>Řadit podle:</strong> ');

define('TEXT_SHOW', '<strong>Třídit podle:</strong> ');

define('TEXT_SHOW', '<strong>Filtr:</strong> ');

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
//       $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
          $listing_sql .= " order by p.products_sort_order, pd.products_name";
          break;
        }
      }

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
          //$listing_sql .= " order by p.products_sort_order desc, pd.products_name";
          //$listing_sql .= " order by p.products_sort_order, pd.products_name";
		  
          // bof: Sort-By
          $listing_sql .= $order_by; // Sort-By
          // eof: Sort-By
		  
		  break;
        }
      }

// always add quantity regardless of whether or not it is in the listing for add to cart buttons
  if (PRODUCT_LIST_QUANTITY < 1) {
    $select_column_list .= 'p.products_quantity, ';
  }

// bof: Sort-By
  if (!isset($_GET['disp_order'])) {
	  $_GET['disp_order'] = $disp_order_default;
	  $disp_order = $disp_order_default;
	} else {
	  $disp_order = $_GET['disp_order'];
	}
	
	switch (true) {
	  case ($_GET['disp_order'] == 0):
	  // reset and let reset continue
	  $_GET['disp_order'] = $disp_order_default;
	  $disp_order = $disp_order_default;
	  case ($_GET['disp_order'] == 1):
	  $order_by = " order by pd.products_name";
	  break;
	  case ($_GET['disp_order'] == 2):
	  $order_by = " order by pd.products_name DESC";
	  break;
	  case ($_GET['disp_order'] == 3):
	  $order_by = " order by p.products_price_sorter, pd.products_name";
	  break;
	  case ($_GET['disp_order'] == 4):
	  $order_by = " order by p.products_price_sorter DESC, pd.products_name";
	  break;
	  case ($_GET['disp_order'] == 5):
	  $order_by = " order by p.products_model";
	  break;
	  case ($_GET['disp_order'] == 6):
	  $order_by = " order by p.products_date_added DESC, pd.products_name";
	  break;
	  case ($_GET['disp_order'] == 7):
	  $order_by = " order by p.products_date_added, pd.products_name";
	  break;
	  default:
	  $order_by = " order by p.products_sort_order";
	  break;
	}
  // eof: Sort-By

<?php
  $check_for_alpha = $listing_sql;
  $check_for_alpha = $db->Execute($check_for_alpha);

  if ($check_for_alpha->RecordCount() > 0 && PRODUCT_LIST_ALPHA_SORTER == 'true') {
  $form = zen_draw_form('filter', zen_href_link(FILENAME_DEFAULT), 'get') . '<label class="inputLabel">' .TEXT_SHOW . '</label>';
?>

<?php
// bof: Sort-By
?>
<div id="sorter">
<label class="inputLabel" for="disp-order-sorter"><?php echo TEXT_INFO_SORT_BY; ?></label>
<?php
  echo zen_draw_form('sorter_form', zen_href_link($_GET['main_page']), 'get');
  echo zen_draw_hidden_field('main_page', FILENAME_DEFAULT);
  echo zen_draw_hidden_field('cPath', $cPath);
  
  if (isset($_GET['filter_id']) && $_GET['filter_id'] != '') {
	echo zen_draw_hidden_field('filter_id', $_GET['filter_id']);
  }
  
  if (isset($_GET['alpha_filter_id']) && $_GET['alpha_filter_id'] != '') {
	echo zen_draw_hidden_field('alpha_filter_id', $_GET['alpha_filter_id']);
  }
  echo zen_hide_session_id();
?>
    <select name="disp_order" onchange="this.form.submit();" id="disp-order-sorter">
<?php if ($disp_order != $disp_order_default) { ?>
    <option value="<?php echo $disp_order_default; ?>" <?php echo ($disp_order == $disp_order_default ? 'selected="selected"' : ''); ?>><?php echo PULL_DOWN_ALL_RESET; ?></option>
<?php } // reset to store default ?>
    <option value="1" <?php echo ($disp_order == '1' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_NAME; ?></option>
    <option value="2" <?php echo ($disp_order == '2' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_NAME_DESC; ?></option>
    <option value="3" <?php echo ($disp_order == '3' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_PRICE; ?></option>
    <option value="4" <?php echo ($disp_order == '4' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_PRICE_DESC; ?></option>
    <option value="5" <?php echo ($disp_order == '5' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_MODEL; ?></option>
    <option value="6" <?php echo ($disp_order == '6' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_DATE_DESC; ?></option>
    <option value="7" <?php echo ($disp_order == '7' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_DATE; ?></option>
    </select></form></div>

<br class="clearBoth" />
<?php
// eof: Sort-By
?>

<?php
  echo $form;
  echo zen_draw_hidden_field('main_page', FILENAME_DEFAULT);
  echo zen_hide_session_id();
?>

<?php
  echo $form;
  echo zen_draw_hidden_field('main_page', FILENAME_DEFAULT);
  
  // bof: Sort-By
  if (isset($_GET['disp_order']) && $_GET['disp_order'] != '') {
	echo zen_draw_hidden_field('disp_order', $_GET['disp_order']);
  }
  // eof: Sort-By
  
  echo zen_hide_session_id();
?>