 |
<% if(id!=null && !id.equals("")) { %>
|
<% } else { %>
<% } %>
<% if (cart.equals("yobi")) { %>
<% while(sess.hasMoreElements()) { %>
<%
String sess_name = (String) (sess.nextElement());
StringTokenizer tkn = new StringTokenizer(sess_name, "_");
if (tkn.countTokens() < 2) { continue; }
String sess_key = tkn.nextToken();
String cart_id = tkn.nextToken();
if (sess_key.equals("yobi")) {
query = "SELECT * FROM goods WHERE del is not true AND (start_date <= current_timestamp or start_date is null) AND (end_date >= current_timestamp or end_date is null) AND id = " + cart_id;
rs = db.select(query);
rs.next();
Integer count = (Integer)session.getAttribute(sess_name);
total += rs.getInt("price") * count.intValue();
row = rs.getRow();
%>
<% } %>
<% } %>
<% if (row < 1) { %>
現在メモに入っている商品はありません。
<% } %>
|
|
<% } else { %>
<% while(sess.hasMoreElements()) { %>
<%
String sess_name = (String) (sess.nextElement());
StringTokenizer tkn = new StringTokenizer(sess_name, "_");
if (tkn.countTokens() < 2) { continue; }
String sess_key = tkn.nextToken();
String cart_id = tkn.nextToken();
if (sess_key.equals("cart")) {
query = "SELECT * FROM goods WHERE del is not true AND (start_date <= current_timestamp or start_date is null) AND (end_date >= current_timestamp or end_date is null) AND id = " + cart_id;
rs = db.select(query);
rs.next();
Integer count = (Integer)session.getAttribute(sess_name);
total += rs.getInt("price") * count.intValue();
row = rs.getRow();
%>
<% } %>
<% } %>
<% if (row < 1) { %>
現在カートに入っている商品はありません。
<% } %>
|
<% if (total > 0) { %>
商品合計金額￥<%=NumFormat(String.valueOf(total))%>
(送料・手数料は含まれておりません) |
<% } %>
|
<% } %>
<%
query = "SELECT *, to_char (start_date, 'mm/dd') as sdate FROM comment WHERE del is not true AND (start_date <= current_timestamp OR start_date is null) ORDER BY id DESC LIMIT 1";
ResultSet comment = db.select(query);
%>
<% if(comment.next()) { %>
<% } %>
<%
query = "SELECT * FROM news WHERE del is not true AND (start_date <= current_timestamp OR start_date is null) AND (end_date >= current_timestamp OR end_date is null) ORDER BY id DESC LIMIT 3";
ResultSet news = db.select(query);
%>
<%if (news.getFetchSize() > 0){%>
 |
<% while(news.next()) { %>
| ● |
<%=StrConv("title", news.getString("title"))%> |
<% } %>
| |
>>詳しくはこちらへ |
|
<% } %>
<%
query = "SELECT *, to_char (start_date, 'mm月dd日') as sdate, to_char (end_date, 'mm月dd日') as edate FROM campaign WHERE del is not true AND (start_date <= current_timestamp or start_date is null) AND (end_date >= current_timestamp or end_date is null) AND status = 1";
ResultSet campaign = db.select(query);
%>
<% if(campaign.next()) { %>
 |
●<%=StrConv("title", campaign.getString("title"))%>
<% if(campaign.getString("sdate")!=null) { %>
<%=campaign.getString("sdate")%>
<% } %>
<% if(campaign.getString("edate")!=null) { %>
〜<%=campaign.getString("edate")%>
<% } %>
|
<%=StrConv("text_s", campaign.getString("text_s"))%>
詳しくはこちらへ |
|
|
|
<% } %>
<%
query = "SELECT * FROM shop_news WHERE del is not true AND (start_date <= current_timestamp OR start_date is null) AND (end_date >= current_timestamp OR end_date is null) ORDER BY id DESC LIMIT 3";
ResultSet snews = db.select(query);
%>
<%if (snews.getFetchSize() > 0){%>
 |
<% while(snews.next()) { %>
●<%=StrConv("shop", snews.getString("shop"))%>からのお知らせ
<%=StrConv("title", snews.getString("title"))%> |
<% } %>
| >>詳しくはこちらへ |
|
 |
|
<% } %>
|
新入荷商品
