Codice PHP:
<?php
/**
* Page Template
*
* Loaded automatically by index.php?main_page=advanced_search_result.
* Displays results of advanced search
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license [url]http://www.zen-cart.com/license/2_0.txt[/url] GNU Public License V2.0
* @version $Id: tpl_advanced_search_result_default.php 4182 2006-08-21 02:11:37Z ajeh $
*/
?>
<div class="centerColumn" id="advSearchResultsDefault">
<h1 id="advSearchResultsDefaultHeading"><span class="title-left-bg"><span class="title-right-bg"><?php echo HEADING_TITLE; ?></span></span></h1>
<?php
if ($do_filter_list || PRODUCT_LIST_ALPHA_SORTER == 'true') {
// $form = zen_draw_form('filter', zen_href_link(FILENAME_ADVANCED_SEARCH_RESULT), 'get') . '<label class="inputLabel">' .TEXT_SHOW . '</label>';
$form = zen_draw_form('filter', zen_href_link(FILENAME_ADVANCED_SEARCH_RESULT), 'get');
?>
<?php echo $form; ?>
<?php
echo zen_hide_session_id();
/* Re-Get all GET'ed variables */
$hidden_get_variables = '';
reset($_GET);
while (list($key, $value) = each($_GET)) {
if ( ($key != 'currency') && ($key != zen_session_name()) && ($key != 'x') && ($key != 'y') ) {
$hidden_get_variables .= zen_draw_hidden_field($key, $value);
}
}
echo $hidden_get_variables;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_PRODUCT_LISTING_ALPHA_SORTER));
?>
</form>
<?php
}
?>
<?php echo zen_draw_form('quick_find_header', zen_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get');
echo zen_draw_hidden_field('main_page',FILENAME_ADVANCED_SEARCH_RESULT);
echo zen_draw_hidden_field('search_in_description', '1') . zen_hide_session_id();?>
<?php
$k = trim($_GET['keyword']); ?>
<?php
function taxes($pri){
$sql = mysql_query("SELECT tax_rate WHERE tax_class_id = 1");
while ($r = mysql_fetch_array($sql)){
$tax = $r['tax_rate'];
}
$pr_tx = $pri * 20/100;
$p = $pri + $pr_tx;
return $p;
}
$query = mysql_query("SELECT pd.products_id, p.products_id,
(p.products_price_sorter*1.2) as pr,
p.products_tax_class_id, p.products_model from " . TABLE_PRODUCTS_DESCRIPTION . " as pd,
" . TABLE_PRODUCTS ." as p
WHERE pd.products_name LIKE '%$k%' AND
pd.language_id = '".$_SESSION['languages_id']."'
and (p.products_price_sorter*1.2) >= '$pfrom' and (p.products_price_sorter*1.2) <= '$pto'
and pd.products_id = p.products_id");
$count = mysql_num_rows($query);
while($r = mysql_fetch_array($query)){
$pm[] = $r['products_id'];
}
function quant_pr($val1, $val2){
$k = trim($_GET['keyword']);
$query = mysql_query("SELECT pd.products_id, p.products_id,
(p.products_price_sorter*1.2) as pr,
p.products_tax_class_id, p.products_model from " . TABLE_PRODUCTS_DESCRIPTION . " as pd,
" . TABLE_PRODUCTS ." as p
WHERE pd.products_name LIKE '%$k%' AND
pd.language_id = '".$_SESSION['languages_id']."'
and (p.products_price_sorter*1.2) >= '$val1' and (p.products_price_sorter*1.2) <= '$val2'
and pd.products_id = p.products_id");
$count = mysql_num_rows($query);
return $count;
}
?>
<?php echo zen_draw_hidden_field('keyword', '', 'value="' . $k . '"');
$n1 = '1 - 9 (' . quant_pr(1,9) . ')';
$n2 = '10 - 24 (' . quant_pr(10,24) . ')';
$n3 = '25 - 49 (' . quant_pr(25,49) . ')';
$n4 = '50 - 99 (' . quant_pr(50,99) . ')';
$n5 = '100 - 149 (' . quant_pr(100,149) . ')';
$n6 = '150 - 199 (' . quant_pr(150,199) . ')';
$n7 = '200 - 299 (' . quant_pr(200,299) . ')';
$n8 = '300 - 449 (' . quant_pr(300,449) . ')';
$n9 = '450 - 699 (' . quant_pr(450,699) . ')';
$n10 = '700 - 999 (' . quant_pr(700,999) . ')';
$pre = array("$n1" => "1-9", "$n2" => "10-24", "$n3" => "25-49", "$n4" => "50-99", "$n5" => "100-149", "$n6" => "150-199", "$n7" => "200-299", "$n8" => "300-449", "$n9" => "450-699", "$n10" => "700-999");
foreach($pre as $key => $value){
$price_ar[] = array('id' => $value, 'text' => $key);
}
?>
//codice da vedere
<select name="prezzo" >
<option value="1-9&pfrom=1&pto=9">1 - 9</option>
<option value="10-24&pfrom=10&pto=24">10 - 24</option>
<option value="25-49&pfrom=25&pto=49">25 - 49</option>
<option value="50-99&pfrom=50&pto=99">50 - 99</option>
<option value="100-149&pfrom=100&pto=149">100 - 149</option>
<option value="150-199&pfrom=150&pto=199">150 - 199</option>
<option value="200-299&pfrom=200&pto=299">200 - 299</option>
</select>
//fine codice da vedere
<input type="submit">
<?php echo $count;
echo '
';
foreach($pm as $m){
echo $m;
echo '
';
}
?>
</form>
<?php
/**
* Used to collate and display products from advanced search results
*/
require($template->get_template_dir('tpl_modules_product_listing.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_product_listing.php');
?>
<div class="buttonRow back"><?php echo '[url="' . zen_href_link(FILENAME_ADVANCED_SEARCH, zen_get_all_get_params(array('sort', 'page', 'x', 'y')), 'NONSSL', true, false) . '"]' . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '[/url]'; ?></div>
</div>