<%@ include file="_____ConfiguratorDisplay.jsp" %>
">
<%
ccitems.CcItemNavigation xin = new ccitems.CcItemNavigation();
xin.setNavSeq(navSeq);
xin.setLanguage(language);
xin.setOrganisation(organisation);
String ZOOM_LINK_BASE = ndlr.renderLink(xin,false)+NavigationDispatcherLinkRenderer.ZOOM_LINK_TAG;
boolean globalZuschlag=false;
sA ="1";
if((!sV.equals("") && !sC.equals(""))|| sA.equals("1"))
{
out.flush();
if(!sV.equals("") && !sC.equals(""))
{
queryString = "SELECT * FROM articledata LIMIT 1";
rsA = dbconnection.sqlQuery(queryString);
ResultSetMetaData rsmd = rsA.getMetaData();
StringTokenizer tokensColumns = new StringTokenizer(sC,",");
StringTokenizer tokensColumnsValues = new StringTokenizer(sV,",");
Vector columnNames = new Vector();
Vector columnValues = new Vector();
StringBuffer dynQuery = new StringBuffer();
while (tokensColumns.hasMoreTokens())
{
int columnNumber = 0;
try
{
columnNumber = Integer.parseInt(tokensColumns.nextToken());
}
catch(NumberFormatException e)
{
System.out.println(baseContext+"\nReparse of ColumnNumbers command failed, qualifyer NAN");
e.printStackTrace();
}
if(columnNumber!=0)
{
columnNames.add(rsmd.getColumnName(columnNumber));
}
}
String actualToken;
while (tokensColumnsValues.hasMoreTokens())
{
actualToken = tokensColumnsValues.nextToken();
if(!"0".equals(actualToken))
{
columnValues.add(actualToken);
}
}
for (int i=0;i
SHOW ALL
<%
while(rsA.next())
{
zuschlagValue=0;
zuschlagValueString="";
zuschlagShort = rsA.getString("teuerungszuschlag");
if(zuschlagShort!=null && !zuschlagShort.equals("0") &&textSnippets.getProperty("wwwOptionsShowZuschlag")!=null && textSnippets.getProperty("wwwOptionsShowZuschlag").equals("true") )
{
zuschlagValueString = textSnippets.getProperty("shopTeuerungsZuschlag"+zuschlagShort);
if(zuschlagValueString != null)
{
try
{
zuschlagValue = Double.parseDouble(zuschlagValueString);
localZuschlag=true;
globalZuschlag = true;
}
catch(NumberFormatException e)
{
System.out.println("KEIN numerischer wert 0.00 für: shopTeuerungsZuschlag"+zuschlagShort);
zuschlagValue=0;
}
}
}
else
{
localZuschlag=false;
zuschlagValue=0;
}
colorName = rsA.getString(5);
colorName = (colorName!=null && !colorName.equals("null")?colorName:"");
queryString = "SELECT artp_value, artp_count FROM articleprice WHERE art_seq="+rsA.getString(1)+" AND organisation='"+organisation+"' and artp_value>0 order by artp_count ASC";
rsB = dbconnection.sqlQuery(queryString);
articlePreisNetto=new Vector();
articleCount=new Vector();
articlePreisBrutto=new Vector();
if(rsB.isBeforeFirst())
{
while(rsB.next())
{
netPrice = rsB.getDouble(1);
netPrice = netPrice+((netPrice/100)*zuschlagValue);
grossPrice = ((netPrice/100f)*vatValue)+netPrice;
articleCount.add(rsB.getString(2));
articlePreisNetto.add(new Double(netPrice));
articlePreisBrutto.add(new Double(grossPrice));
}
}
else
{
netPrice = 0d;
grossPrice = 0d;
}
i++;
actualPreviewPicture ="";
queryString = "SELECT pcd_filename, pcc_seq, pcd_width, pcd_height from picturedata, connectpicturearticlerep where connectpicturearticlerep.artrep_seq='"+rsA.getString(7)+"' AND cpa_sort=1 AND picturedata.pcd_seq=connectpicturearticlerep.pcd_seq AND connectpicturearticlerep.language='"+language+"' and connectpicturearticlerep.organisation='"+organisation+"' AND picturedata.language='"+language+"' and picturedata.organisation='"+organisation+"'";
rsB = dbconnection.sqlQuery(queryString);
if(rsB.next())
{
actualPreviewPicture = rsB.getString(1);
picCatPathWeb =picCatEngn.getCatTreePathWeb(rsB.getString(2),language,organisation);
formatPortrait = (rsB.getInt(4)>rsB.getInt(3)?true:false);
}
else
{
actualPreviewPicture="";
picCatPathWeb="";
formatPortrait=false;
}
queryString = "SELECT artn_text FROM articlename WHERE art_seq ='"+rsA.getString(1)+"' AND language='"+language+"' AND organisation='"+organisation+"'";
rsC = dbconnection.sqlQuery(queryString);
String[] artnSplit=null;
if(rsC.next())
{
artn_text = rsC.getString(1);
if(artn_text.indexOf(",")>-1 && "false".equals(textSnippets.getProperty("wwwOptions.showArticleRep")))
{
artnSplit = artn_text.split(",\\s*");
}
else
{
artnSplit = new String[]{};
}
}
else
{
artn_text = rsA.getString("artbez");
artnSplit = new String[]{};
}
sb = new StringBuffer();
sb.append(rsA.getString(1));
sb.append("_");
sb.append(artnSplit.length>0?artnSplit[0]:artn_text);
sb.append("_");
sb.append(rsA.getString(6));
String zoomHref = UrlCleaner.cleanup(sb.toString())+".html";
//zoomHref = ZOOM_LINK_BASE+ndlr.clearUrl(zoomHref);
%>
<%if(false)//!rsA.isFirst() || showConfig)
{%>
<%
}
if (i%2 == 0)
{
%>
<%
}
else
{
%>
<%
}
%>
<%
if(!actualPreviewPicture.equals(""))
{
%>
<%= textSnippets.getProperty("shopTextNoPicture") %>
<%
}
%>
<%
//Artikelüberschrift
if(!artn_text.equals("") && artn_text != null)
{
if(artn_text.indexOf(",")>-1 && "false".equals(textSnippets.getProperty("wwwOptions.showArticleRep")))
{
//String[] artnSplit = artn_text.split(",\\s*");
if(artnSplit.length>0)
{
%>
<%= artnSplit[0] %> <%= rsA.getString(6) %>
<%
}
else
{
%>
<%= artn_text %>
<%
}
}
else
{
%>
<%= artn_text %>
<%
}
}
else
{
%>
<%= rsA.getString(4) %>
<%
}
if(!artn_text.equals("") && artn_text != null && "false".equals(textSnippets.getProperty("wwwOptions.showArticleRep")))
{
if(artn_text.indexOf(",")>-1)
{
//String[] artnSplit = artn_text.split(",\\s*");
if(artnSplit.length>1)
{
%>
<%
for(int iRunArtn=1;iRunArtn");
out.write(artnSplit[iRunArtn]);
out.write("");
}
%>
<%
}
else
{
%>
<%= artn_text %>
<%
}
}
}
else
{
%>
<%= repParser.parseRepView(rsA.getString(2),rsA.getString(1)) %>
<%
}
%>
<%= textSnippets.getProperty("ShopProductNumber") %> <%= rsA.getString(6) %>
<%= textSnippets.getProperty("ShopButtonZoom") %> <%= textSnippets.getProperty("ShopButtonNotice") %>
<%= textSnippets.getProperty("ShopProductListColor") %>
<%= (textSnippets.getProperty("ShopProductColors-"+colorName)!=null?textSnippets.getProperty("ShopProductColors-"+colorName):colorName) %>
<%
if (textSnippets.getProperty("ShopProductColors.Html."+colorName)!=null)
{
%>
;width:28px;height:28px;margin-top:4px;">
<%
}
if(rsA.getInt("lieferzeit")>0 && textSnippets.getProperty("wwwOptionsShowLieferzeit")!=null && textSnippets.getProperty("wwwOptionsShowLieferzeit").equals("true"))
{
%>
<%= textSnippets.getProperty("ShopProductListDeliveryTime") %>
<%
String lieferDisplay="";
String lieferUnit="";
int actualTime = rsA.getInt("lieferzeit");
if (actualTime<=72)
{
lieferDisplay = String.valueOf(actualTime);
lieferUnit = textSnippets.getProperty("ShopProductListDeliveryTimeUnit.hours");
}
else if (actualTime<= 144)
{
actualTime=(int)Math.round((actualTime/24d));
lieferDisplay = ""+actualTime;
lieferUnit = textSnippets.getProperty("ShopProductListDeliveryTimeUnit.days");
}
else if (actualTime>144)
{
actualTime=(int)Math.round((actualTime/24d)/7d);
lieferDisplay = ""+actualTime;
lieferUnit = textSnippets.getProperty("ShopProductListDeliveryTimeUnit.weeks");
}
%>
<%= lieferDisplay %> <%= lieferUnit %>
<%
}
else if(textSnippets.getProperty("ShopProductListDeliveryTimeStandard")!=null)
{
%>
<%= textSnippets.getProperty("ShopProductListDeliveryTime") %>
<%= textSnippets.getProperty("ShopProductListDeliveryTimeStandard") %>
<%
}
%>
<%= textSnippets.getProperty("ShopProductPrice") %>
<%
if(articlePreisNetto.size()==0)
{%>
<%= textSnippets.getProperty("noPriceAvailable") %> <%= nf.format(((Double)articlePreisNetto.get(0)).doubleValue()) %> <%= textSnippets.getProperty("ShopCurrencyShort") %><%= (localZuschlag?"* ":"") %> <%= textSnippets.getProperty("ShopWithoutVAT") %>
<%
if(textSnippets.getProperty("wwwOptionsShowBrutto")==null || textSnippets.getProperty("wwwOptionsShowBrutto").equals("true"))
{
%>
<%
if(articlePreisNetto.size()==0)
{%>
<%= textSnippets.getProperty("noPriceAvailable") %> <%= nf.format(((Double)articlePreisBrutto.get(0)).doubleValue()) %> <%= textSnippets.getProperty("ShopCurrencyShort") %><%= (localZuschlag?"* ":"") %> <%= textSnippets.getProperty("ShopWithVAT") %>
<%
}
if(articlePreisNetto.size()>1)
{%>
<%= textSnippets.getProperty("ShopScalePrice") %> <%= textSnippets.getProperty("ShopScalePriceText1") %> <%= (String)articleCount.get(runPrice) %> <%= textSnippets.getProperty("ShopPackingUnit") %> <%= textSnippets.getProperty("ShopScalePriceText2") %> <%= nf.format(((Double)articlePreisNetto.get(runPrice)).doubleValue()) %> <%= textSnippets.getProperty("ShopCurrencyShort") %>
<%
}
%>
<%
}
if(articlePreisNetto.size()!=0)
{%>
<%}%>
<%
//Alte Abfrage
//if(textSnippets.getProperty("wwwOptionsPriceBanner")!=null && localZuschlag)
//{%>
<%--
" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" bgcolor="#AECDCC" menu="false" quality="high" width="90" height="25">
<% //if(globalZuschlag){%><%//= textSnippets.getProperty("shopTeuerungsZuschlagText") %> <%//}%>
<%
}
%>
<%
}
%>
100<%= picCatPathWeb %><%= actualPreviewPicture %>" alt="<%= actualPreviewPicture %>" border="0" width="100">
<%
}
else
{
%>
