[$mtext$]
select '
| Anzahl / Gruppe
| Beschreibung' where '[$showliste$]'='JA' or '[$wg$]'='';
select check_artlistcache('[$mandant$]')
select distinct on (wg)
'| ',
lpad(acount,3,'0'),' ',wg as wg1,'
| ',
doif(level>0 and '[$showlevel$]'='t','('||level||') ',' '),
'| ',
replace(substring('--------------',0,2*(0||artbez)::integer+1),
'-',' '),
' | ',
doif(acount>0,
''||wgktext|| '',''||wgktext||''),
-- doif(wgltext<>'','
',''),
-- wgltext,
' |
| ',
' '
from
-- artlist('[$mandant$]','',0,'t')
pgf_artlistcache
where '[$showliste$]'='JA'
--
--and position((substring(wg from 1 for 2)) in '[$wg$]')>0
--and position('[$wg$]' in wg)>0
and sub_search_or(replace('[$wg$]', ',' ,', '),wg||',')<>-1
and length(wg)<>0
and wgktext<>'' and man='[$mandant$]' order by wg;
select ' | ' where '[$showliste$]'='JA';
|
Ihre persönliche Kunden-Nummer: [$username$]
/shop/navi.whtml
/shop/rightSucheInc.whtml
|