[comment] ui_template: Yes ui_template_name: leftright $Id: search-catalog.html,v 1.2 2001/11/21 21:27:43 bedinetz Exp $ [/comment] [tmp page_title]__COMPANY__ -- Such Ergebnisse[/tmp] [set page_cross_codes][/set] [control reset=1] [control-set] [component]search_box_small[/component] [/control-set] [control-set] [component]category_vertical[/component] [/control-set] [control-set] [component][/component] [/control-set] [control-set] [component][/component] [/control-set] [control-set] [component]cross[/component] [size]2[/size] [cols]2[/cols] [banner]Unsere Empfehlung[/banner] [/control-set] [control-set] [component]random[/component] [size]3[/size] [cols]1[/cols] [banner]Specials[/banner] [/control-set] [control reset=1] @_LEFTRIGHT_TOP_@
[if scratch did_order] [include file="templates/components/cart_display"] [/if] [set did_order][/set] [query sql=" select sku, description, price from products where shop_id = [scratch shop_id] and ( lower(description) like lower('%[cgi search_word]%') or lower(title) like lower('%[cgi search_word]%') or lower(comment) like lower('%[cgi search_word]%') ) order by category" type=list more=1 ml=10] [set munge_quantity] [calc] $Scratch->{did_order} = 1; @q = split /\0/, $CGI->{mv_order_quantity}; for (@q) { next unless length $_; $_ = "=$_"; } @parms = grep /^mv_oi\d+/ && $CGI->{$_}, keys %{$CGI}; # If we have parms, means an individual buy. If we don't # we want to strip empty items unless (@parms) { @i = split "\0", $CGI->{mv_order_item}; for(my $i = 0; $i < @i; $i++) { next if length($q[$i]); $i[$i] = ''; } @i = grep length($_), @i; @q = grep length($_), @q; $CGI_array->{mv_order_quantity} = \@q; $CGI->{mv_order_quantity} = join "\0", @q; $CGI_array->{mv_order_item} = \@i; $CGI->{mv_order_item} = join "\0", @i; return; } my $item = $parms[0]; $item =~ /(\d+)/ or return; my $idx = $1; $idx--; $CGI->{mv_order_item} = $CGI->{$item}; $CGI->{mv_order_quantity} = "$q[$idx]"; return; [/calc] [bounce href="[history-scan exclude=nothing]"] [/set] [tmp cross_sale][value-extended name=mv_searchspec index=0][/tmp] [on-match]
[/on-match] [list] [sql-change 1][condition][sql-field category][/condition] [/sql-change 1] [if type="scratch" term="std_item_shop_id" op="!=" compare="[scratch shop_id]"] [else] [/list]

 Produkt Artikelnummer Im Lager Preis Anzahl bestellen
 
 [either][value banner_text][or][sql-field category][/either]

[sql-description] [seti page_cross_codes] [scratch page_cross_codes] [sql-data merchandising cross_sell] [/seti] [tmp std_item_shop_id][sql-data products shop_id][/tmp] [if scratch std_debug] (debug) shop_id: [scratch std_item_shop_id] [if type="scratch" term="std_item_shop_id" op="!=" compare="[scratch shop_id]"] wrong shop [else] right shop [/else] [/if]
(debug) cross_codes: [scratch cross_codes]
(debug) page_cross_codes: [scratch page_cross_codes]
(debug) cross_sell: [sql-data merchandising cross_sell]
[/if]
[sql-code] [sql-calc] my $q = q{[sql-data inventory quantity]}; if($q > 0) { return <Y EOF } else { return <N EOF } [/sql-calc] nicht bestellbar[std_preis [sql-code]] [if session browser =~ /mac/] [else] [if scratch hide_price == 1] [else] [/else] [/if] [/else] [/if] [/else] [/if]
[if-sql-data options o_enable] [if-sql-data !options o_modular] [table-organize cols=4 table=' ' font="size=1" pretty=1] [sql-options td=1 label=1 bold=1 price=1] [/table-organize] [/if-sql-data] [/if-sql-data]

[on-match]

   
[/on-match] [no-match]

Sorry, no matches for [calc] my $joiner = ' AND '; $joiner = ' OR ' if defined $Search->{''}->{mv_orsearch}[0] and $Search->{''}->{mv_orsearch}[0]; my @str = grep /\D/, @{$Values->{mv_searchspec}}; return join $joiner, @str; [/calc] [if value mv_search_error]

Errors:
[value-extended name=mv_search_error joiner="
"]
[/if]

[/no-match]
[more-list]
Matches [matches] of [match-count] found.
[more]
[/more-list] [/query]
@_LEFTRIGHT_BOTTOM_@