%@ page contentType="text/html;charset=MS932" %> <% /** * Copyright (c) 2003-2004 System Integrator Corporation. * All Rights Reserved. * @version $Id : index.jsp,v 1.0 2004/01/11 Exp $ * @author : Jinwang Chen * @Description : フロントのトップ画面 * @History * Author Date Reason * ============ ========== =========================== * J.W.Chen 2004/01/11 Original * J.K.Fei 2007/04/11 Update * M.Teng 2007/04/17 update * M.Teng 2007/04/18 update * P.X.He 2007/04/21 update * M.Teng 2007/05/24 update * P.X.He 2007/05/30 update * S.P.Bao 2007/05/31 update * S.P.Bao 2007/06/04 update * J.K.Fei 2007/06/07 Update * M.Teng 2007/06/07 Update * J.K.Fei 2007/06/08 Update * M.Teng 2007/06/08 Update * P.X.He 2007/06/08 Update * P.X.He 2007/06/11 Update * zhangyy 2007/06/18 リンクタグを追加します、リンク先は決まっていませんので、仮の先を書いた * zhangyy 2007/06/21 リンク設定 * zhangyy 2007/06/22 カテゴリ条件エリア * zhangyy 2007/06/22 表示条件エリア * zhangyy 2007/06/25 検索プルダウンにショップカテゴリを追加 * P.X.He 2007/07/02 Update * zhangyy 2007/07/10 sessionきれの対応 * zhangyy 2007/07/11 検索プルダウンに「店舗名」「店舗名カナ」「キャッチコピー」を追加 * zhangyy 2007/07/16 リンク設定 * zhangyy 2007/07/16 デザイン最終チェック * zhangyy 2007/07/20 トップ画面の効率 */ %> <%/**タグのセクション*/%> <%@ taglib uri="/WEB-INF/webshop.tld" prefix="webshop" %> <%@ taglib uri="/WEB-INF/taglibs-input.tld" prefix="input" %> <%@ taglib uri="/WEB-INF/taglibs-application.tld" prefix="app" %> <%@ taglib uri="/WEB-INF/taglibs-request.tld" prefix="request" %> <%@ taglib uri="/WEB-INF/taglibs-datetime.tld" prefix="datetime" %> <%@ taglib uri="/WEB-INF/taglibs-i18n.tld" prefix="i18n" %> <%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %> <%/**エラー遷移先の定義のセクション*/%> <%@ page errorPage="../util/error.jsp" %> <%/**クラスのインポートのセクション*/%> <%@ page import="java.util.*"%> <%@ page import="java.sql.*"%> <%@ page import="org.apache.log4j.Category"%> <%@ page import="jp.co.sint.database.*"%> <%@ page import="jp.co.sint.basic.*"%> <%@ page import="jp.co.sint.tools.*"%> <%@ page import="jp.co.sint.config.*"%> <%@ page import="jp.co.sint.beans.front.*"%> <%@ page import="jp.co.sint.beans.mallmgr.*"%> <% session.removeAttribute("preview"); session.removeAttribute("isPreview"); //ログ用のインスタンスの生成(common) Category log=Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME); //本画面に関わるbeansのデータ UIUserLogin userLoginID=(UIUserLogin)session.getAttribute(SIConfig.SISESSION_USER_LOGIN_NAME); if (userLoginID==null)userLoginID=new UIUserLogin(); UIMain mainID=(UIMain)session.getAttribute(SIConfig.SISESSION_MAIN_LIST_NAME); if (mainID==null)mainID=new UIMain(); //各フロント画面に共通(common) SISrchKey srchKeyList=mainID.getSrchKey(); String currCtgryCode = mainID.getCtgryCodeTxt(); //データベースへのコネンクション(common) SIDatabaseConnection databaseConnection=new SIDatabaseConnection(); Statement stmt1 = null; ResultSet rs1 = null; Statement stmtLev1 = null; ResultSet rsLev1 = null; try{ Connection connection=databaseConnection.getConnection(); //テロップデータの取得(common) Collection opaqueColl=new SIOpaqueManager(connection).getCollection(); //お知らせのデータの取得(common) //カテゴリコードの取得(common) SICtgryManager ctgryMan=new SICtgryManager(connection,currCtgryCode); //店舗のデータの取得(common) Collection srchShopColl=ctgryMan.getShopCollection(connection); //検索項目リスト(common) Collection[] srchKeyNameColl=ctgryMan.getCollection(connection); //バナーを取得 SICmdty bnrCmdty=(new UIBanner()).getBanner(connection,null); //プライバシーについてを取得 SIMsgTemp msgTemp = new SIMsgTemp(); msgTemp.reset(connection,SIConfig.SIMALL_MALLSHOPCODE,SIConfig.SIMSG_TEMPLATE_PRIVACY); //各サイトの設定(common) String webshopSite=SIHTMLUtil.getRootPath(request); String mainSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.main"); String searchSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.cmdtysearch"); String shopSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.shop.info")+"?ctc="+SIHTMLUtil.URLEncode(currCtgryCode); String loginSrvSite=SIURLMap.getHttpsUrl(request,"webshop.servlet.front.user.login")+"?ctc="+currCtgryCode; String userSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.customer")+"?ctc="+currCtgryCode; String bannerSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.commodity")+"?ctc=&backURL="+mainSrvSite; String cmdtyImageSite=SIHTMLUtil.getUploadFolder(request,SIConfig.SIUPLOAD_INX_CMDTY); int spaceNum=18; String returnmainSrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.returnmain"); String sSearchByShop = request.getParameter("searchByShop"); //カテゴリの条件SQL文の設定 mainID.setCtgryConditionSQL(ctgryMan.getConditionSQLL("c2",mainID.getCtgryCodeTxt())); SIUserInfo userLogin=SIHTMLUtil.getUserInfo(request); String cmdtySrvSite=SIURLMap.getUrl(request,"webshop.servlet.front.commodity")+"?ctc="+currCtgryCode; // カテゴリ商品一覧表示 int possion=0; String discountRate="0"; if(userLogin.isLogin()){ discountRate = userLogin.getDiscountRate(); } String rsrvSrvSite=SIURLMap.getHttpsUrl(request,"webshop.servlet.front.reserve"); String searchword = (String)session.getAttribute("searchword"); if (searchword==null)searchword=""; int lRecordCount=mainID.getRecordCount(); int pageSize=mainID.getPageSize(); int num=(Integer.parseInt(mainID.getPageNumberTxt())-1)*pageSize; stmt1=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql1="select ctgrycode,ctgryname from ctgrymtbl where branch_level=1 and shopcode='0' order by sortlevel asc, ctgrycode asc"; rs1=stmt1.executeQuery(sql1); String flag=(String)session.getAttribute("flag"); // ページクッリクの集計 String pageUrl =request.getRequestURI(); SIFrontPageCount.setCount(request,pageUrl,""); session.setAttribute("clickURl",pageUrl); session.removeAttribute("preview"); session.setAttribute("BackOrFront","Front"); int cmcIndex=0; int shopIndex=0; if(flag!=null&&flag.equals("1")){ stmtLev1=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); String sqlLev1="select ctgrycode,ctgryname from ctgrymtbl where branch_level=1 and shopcode='0'"; rsLev1=stmtLev1.executeQuery(sqlLev1); } SICtgryManager ctgryMan2=new SICtgryManager(connection,currCtgryCode); HashMap hash=ctgryMan2.CreateTopCatgry(currCtgryCode,connection); %>