<%@ page language="java" contentType="text/html;charset=iso-8859-1" %> <%@ page import="java.lang.*,java.sql.*,java.util.*" %> <%@ page import="com.neusoft.unieap.util.winclient.SqlUtil" %> <%@ page import="com.neusoft.unieap.util.datastore.ValueDataSet" %> <%@ include file="../../../include/common/unencode.inc"%> <%@ page import ="java.util.Date"%> <%@ page import ="java.text.SimpleDateFormat"%> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="oracle.jdbc.driver.OracleResultSet" %> <%@ page import="oracle.sql.CLOB" %> <%@ page import="com.neusoft.unieap.config.EAPConfigHelper" %> <%@ include file="../webshop/opendatabase.inc"%> <% String adminUserName = ""+session.getValue("adminUserName"); String webPath=request.getContextPath(); String sql=""; ValueDataSet rs=null; String strSno = request.getParameter("strSno"); //ID String webshopid = request.getParameter("webshopid"); //ID String shop_name="",faq_web="",img_web="",email_img="",htmlname=""; sql=" select SHOP_NAME,FAQ_WEB,IMG_WEB,EMAIL_IMG,HTML_NAME FROM T_GEN_SHOP WHERE SHOP_ID='"+webshopid+"'"; rs= SqlUtil.getInstance().executeQuery(sql); if(rs.getRowCount()>0){ rs.moveTo(1); shop_name=nullcode(rs.getString("SHOP_NAME")); faq_web=nullcode(rs.getString("FAQ_WEB")); img_web=nullcode(rs.getString("IMG_WEB")); email_img=nullcode(rs.getString("EMAIL_IMG")); htmlname=nullcode(rs.getString("HTML_NAME")); } sql=" select ROW_ID, PRODUCT_CODE, PRODUCT_NAME,DEPLOY_NAME,DEPLOY_IMG,DEPLOY_NAMEB,DEPLOY_NAMEC,DEPLOY_NAMED,DEPLOY_NAMEE,DEPLOY_NAMEF,DEPLOY_NAMEG,DEPLOY_NAMEH,DEPLOY_NAMEI,DEPLOY_NAMEJ, "; sql+=" C1B_IMG, C2B_IMG, C3B_IMG, C4B_IMG, C5B_IMG, C6B_IMG, C1S_IMG, C2S_IMG, C3S_IMG, C4S_IMG, C5S_IMG, C6S_IMG,"; sql+=" PRODUCTCONDITION, WARRANTY, WARRANTY_URL, COMBINESHIPPING, COMBINESHIPPING_URL,COMBINESHIPPING_S, COMBINESHIPPINGS_URL,"; sql+=" SHIPPINGCOST,SHIPPINGCOST_LIST, SHIPPINGCOST_URL,SHIPPINGCOST_S,SHIPPINGCOSTS_LIST,"; sql+=" SHIPPINGCOSTS_URL,EBAYLIST,EBAYLIST_URL,EBAYLISTS,EBAYLISTS_URL,FREESHIPPING,FREESHIPPING_IMG,FREESHIPPING_URL,"; sql+=" QUESTION_LINK_IMG, QUESTION_LINK_URL, TERMSCONDITIONS, PAYMENTTAX, SHIPPINGHANDLING,SHIPPINGDETAILS,SHIPPINGDETAILS_S,"; sql+=" WARRANTYRETURN, CONTACT_US, ARROW_IMG,WEBNOTE,SMESSAGE1_URL,SMESSAGE2_URL,SMESSAGE1_LIST,"; sql+=" OUR_PROD_NAME1,OUR_PROD_IMG1,OUR_PROD_URL1,OUR_PROD_NAME2,OUR_PROD_IMG2,OUR_PROD_URL2,"; sql+=" OUR_PROD_NAME3,OUR_PROD_IMG3,OUR_PROD_URL3,OUR_PROD_NAME4,OUR_PROD_IMG4,OUR_PROD_URL4,"; sql+=" OUR_PROD_NAME5,OUR_PROD_IMG5,OUR_PROD_URL5,OUR_PROD_NAME6,OUR_PROD_IMG6,OUR_PROD_URL6,"; sql+=" OUR_PROD_NAME7,OUR_PROD_IMG7,OUR_PROD_URL7,OUR_PROD_NAME8,OUR_PROD_IMG8,OUR_PROD_URL8,"; sql+=" LOTS_IMG5,LOTS_URL5,LOTS_IMG10,LOTS_URL10,LOTS_IMG20,LOTS_URL20,LOTS_IMG50,LOTS_URL50,LOTS_IMG100,LOTS_URL100 "; sql+=" from T_GEN_PRODUCT WHERE ROW_ID='"+strSno+"' "; String codea=""; String namea=""; String deploy_name="",deploy_nameb=""; String deploy_img=""; String deploy_namec=""; String deploy_named=""; String deploy_namee=""; String c1b_img=""; String c2b_img=""; String c3b_img=""; String c4b_img=""; String c5b_img=""; String c6b_img=""; String c1s_img=""; String c2s_img=""; String c3s_img=""; String c4s_img=""; String c5s_img=""; String c6s_img=""; String ProductCondition=""; String Warranty=""; String Warranty_url=""; String CombineShipping=""; String CombineShipping_url=""; String CombineShippings=""; String CombineShippings_url=""; String ShippingCost=""; String ShippingCost_list=""; String ShippingCost_url=""; String ShippingCosts=""; String ShippingCosts_list=""; String ShippingCosts_url=""; String ebaylist=""; String ebaylist_url=""; String ebaylists=""; String ebaylists_url=""; String freeshipping=""; String freeshipping_img=""; String freeshipping_url=""; //String freeshippingb=""; //String freeshippingb_img=""; //String freeshippingb_url=""; String question_link_img=""; String question_link_url=""; String MainDescription=""; String TermsConditions=""; String PaymentTax=""; String ShippingHandling=""; String shippingDetails=""; String shippingDetails_s=""; String WarrantyReturn=""; String contact_us=""; String contact_us_url=""; String arrow_img=""; String webnote=""; String smessage1url=""; String smessage2url=""; String wholesale=""; String lots_img5="",lots_url5="",lots_img10="",lots_url10=""; String lots_img20="",lots_url20="",lots_img50="",lots_url50="",lots_img100="",lots_url100=""; String our_prod_name1="",our_prod_img1="",our_prod_url1=""; String our_prod_name2="",our_prod_img2="",our_prod_url2=""; String our_prod_name3="",our_prod_img3="",our_prod_url3=""; String our_prod_name4="",our_prod_img4="",our_prod_url4=""; String our_prod_name5="",our_prod_img5="",our_prod_url5=""; String our_prod_name6="",our_prod_img6="",our_prod_url6=""; String our_prod_name7="",our_prod_img7="",our_prod_url7=""; String our_prod_name8="",our_prod_img8="",our_prod_url8=""; rs= SqlUtil.getInstance().executeQuery(sql); if(rs.getRowCount()>0){ rs.moveTo(1); codea=nullcode(rs.getString("PRODUCT_CODE")); namea=nullcode(rs.getString("PRODUCT_NAME")); deploy_name=nullcode(rs.getString("DEPLOY_NAME")); deploy_img=nullcode(rs.getString("DEPLOY_IMG")); deploy_nameb=nullcode(rs.getString("DEPLOY_NAMEB")); deploy_namec=nullcode(rs.getString("DEPLOY_NAMEC")); deploy_named=nullcode(rs.getString("DEPLOY_NAMED")); deploy_namee=nullcode(rs.getString("DEPLOY_NAMEE")); c1b_img=nullcode(rs.getString("C1B_IMG")); c2b_img=nullcode(rs.getString("C2B_IMG")); c3b_img=nullcode(rs.getString("C3B_IMG")); c4b_img=nullcode(rs.getString("C4B_IMG")); c5b_img=nullcode(rs.getString("C5B_IMG")); c6b_img=nullcode(rs.getString("C6B_IMG")); c1s_img=nullcode(rs.getString("C1S_IMG")); c2s_img=nullcode(rs.getString("C2S_IMG")); c3s_img=nullcode(rs.getString("C3S_IMG")); c4s_img=nullcode(rs.getString("C4S_IMG")); c5s_img=nullcode(rs.getString("C5S_IMG")); c6s_img=nullcode(rs.getString("C6S_IMG")); ProductCondition=rs.getString("PRODUCTCONDITION"); Warranty=rs.getString("WARRANTY"); Warranty_url=rs.getString("WARRANTY_URL"); CombineShipping=nullcode(rs.getString("COMBINESHIPPING")); CombineShipping_url=nullcode(rs.getString("COMBINESHIPPING_URL")); CombineShippings=nullcode(rs.getString("COMBINESHIPPING_S")); CombineShippings_url=rs.getString("COMBINESHIPPINGS_URL"); ShippingCost=rs.getString("SHIPPINGCOST"); ShippingCost_list=rs.getString("SHIPPINGCOST_LIST"); ShippingCost_url=rs.getString("SHIPPINGCOST_URL"); ShippingCosts=rs.getString("SHIPPINGCOST_S"); ShippingCosts_list=rs.getString("SHIPPINGCOSTS_LIST"); ShippingCosts_url=rs.getString("SHIPPINGCOSTS_URL"); ebaylist=rs.getString("EBAYLIST"); ebaylist_url=rs.getString("EBAYLIST_URL"); ebaylists=rs.getString("EBAYLISTS"); ebaylists_url=rs.getString("EBAYLISTS_URL"); freeshipping=nullcode(rs.getString("FREESHIPPING")); freeshipping_img=nullcode(rs.getString("FREESHIPPING_IMG")); freeshipping_url=nullcode(rs.getString("FREESHIPPING_URL")); question_link_img=nullcode(rs.getString("QUESTION_LINK_IMG")); question_link_url=nullcode(rs.getString("QUESTION_LINK_URL")); TermsConditions=nullcode(rs.getString("TERMSCONDITIONS")); PaymentTax=nullcode(rs.getString("PAYMENTTAX")); ShippingHandling=nullcode(rs.getString("SHIPPINGHANDLING")); shippingDetails =nullcode(rs.getString("SHIPPINGDETAILS")); shippingDetails_s =nullcode(rs.getString("SHIPPINGDETAILS_S")); WarrantyReturn=nullcode(rs.getString("WARRANTYRETURN")); contact_us=nullcode(rs.getString("CONTACT_US")); arrow_img=nullcode(rs.getString("ARROW_IMG")); webnote=nullcode(rs.getString("WEBNOTE")); smessage1url=nullcode(rs.getString("SMESSAGE1_URL")); smessage2url=nullcode(rs.getString("SMESSAGE2_URL")); wholesale = nullcode(rs.getString("SMESSAGE1_LIST")); lots_img5=nullcode(rs.getString("LOTS_IMG5")); lots_url5=nullcode(rs.getString("LOTS_URL5")); lots_img10=nullcode(rs.getString("LOTS_IMG10")); lots_url10=nullcode(rs.getString("LOTS_URL10")); lots_img20=nullcode(rs.getString("LOTS_IMG20")); lots_url20=nullcode(rs.getString("LOTS_URL20")); lots_img50=nullcode(rs.getString("LOTS_IMG50")); lots_url50=nullcode(rs.getString("LOTS_URL50")); lots_img100=nullcode(rs.getString("LOTS_IMG100")); lots_url100=nullcode(rs.getString("LOTS_URL100")); our_prod_name1=nullcode(rs.getString("OUR_PROD_NAME1")); our_prod_img1=nullcode(rs.getString("OUR_PROD_IMG1")); our_prod_url1=nullcode(rs.getString("OUR_PROD_URL1")); our_prod_name2=nullcode(rs.getString("OUR_PROD_NAME2")); our_prod_img2=nullcode(rs.getString("OUR_PROD_IMG2")); our_prod_url2=nullcode(rs.getString("OUR_PROD_URL2")); our_prod_name3=nullcode(rs.getString("OUR_PROD_NAME3")); our_prod_img3=nullcode(rs.getString("OUR_PROD_IMG3")); our_prod_url3=nullcode(rs.getString("OUR_PROD_URL3")); our_prod_name4=nullcode(rs.getString("OUR_PROD_NAME4")); our_prod_img4=nullcode(rs.getString("OUR_PROD_IMG4")); our_prod_url4=nullcode(rs.getString("OUR_PROD_URL4")); our_prod_name5=nullcode(rs.getString("OUR_PROD_NAME5")); our_prod_img5=nullcode(rs.getString("OUR_PROD_IMG5")); our_prod_url5=nullcode(rs.getString("OUR_PROD_URL5")); our_prod_name6=nullcode(rs.getString("OUR_PROD_NAME6")); our_prod_img6=nullcode(rs.getString("OUR_PROD_IMG6")); our_prod_url6=nullcode(rs.getString("OUR_PROD_URL6")); our_prod_name7=nullcode(rs.getString("OUR_PROD_NAME7")); our_prod_img7=nullcode(rs.getString("OUR_PROD_IMG7")); our_prod_url7=nullcode(rs.getString("OUR_PROD_URL7")); our_prod_name8=nullcode(rs.getString("OUR_PROD_NAME8")); our_prod_img8=nullcode(rs.getString("OUR_PROD_IMG8")); our_prod_url8=nullcode(rs.getString("OUR_PROD_URL8")); } //MainDescription = MainDescription.replaceAll("&apos", "'"); //MainDescription = MainDescription.replaceAll(""", "\""); namea = namea.replaceAll("&apos", "'"); namea = namea.replaceAll(""", "\""); deploy_name = deploy_name.replaceAll("&apos", "'"); deploy_name = deploy_name.replaceAll(""", "\""); deploy_nameb = deploy_nameb.replaceAll("&apos", "'"); deploy_nameb = deploy_nameb.replaceAll(""", "\""); deploy_namec = deploy_namec.replaceAll("&apos", "'"); deploy_namec = deploy_namec.replaceAll(""", "\""); deploy_named = deploy_named.replaceAll("&apos", "'"); deploy_named = deploy_named.replaceAll(""", "\""); deploy_namee = deploy_namee.replaceAll("&apos", "'"); deploy_namee = deploy_namee.replaceAll(""", "\""); TermsConditions = TermsConditions.replaceAll("&apos", "'"); TermsConditions = TermsConditions.replaceAll(""", "\""); //TermsConditions = TermsConditions.replaceAll(" ", " "); PaymentTax = PaymentTax.replaceAll("&apos", "'"); PaymentTax = PaymentTax.replaceAll(""", "\""); //PaymentTax = PaymentTax.replaceAll(" ", " "); ShippingHandling = ShippingHandling.replaceAll("&apos", "'"); ShippingHandling = ShippingHandling.replaceAll(""", "\""); //ShippingHandling = ShippingHandling.replaceAll(" ", " "); shippingDetails = shippingDetails.replaceAll("&apos", "'"); shippingDetails = shippingDetails.replaceAll(""", "\""); //shippingDetails = shippingDetails.replaceAll(" ", " "); shippingDetails_s = shippingDetails_s.replaceAll("&apos", "'"); shippingDetails_s = shippingDetails_s.replaceAll(""", "\""); //shippingDetails_s = shippingDetails_s.replaceAll(" ", " "); WarrantyReturn = WarrantyReturn.replaceAll("&apos", "'"); WarrantyReturn = WarrantyReturn.replaceAll(""", "\""); //WarrantyReturn = WarrantyReturn.replaceAll(" ", " "); contact_us = contact_us.replaceAll("&apos", "'"); contact_us = contact_us.replaceAll(""", "\""); //contact_us = contact_us.replaceAll(" ", " "); freeshipping = freeshipping.replaceAll("&apos", "'"); freeshipping = freeshipping.replaceAll(""", "\""); //freeshipping = freeshipping.replaceAll(" ", " "); our_prod_name1 = our_prod_name1.replaceAll("&apos", "'"); our_prod_name1 = our_prod_name1.replaceAll(""", "\""); our_prod_name2 = our_prod_name2.replaceAll("&apos", "'"); our_prod_name2 = our_prod_name2.replaceAll(""", "\""); our_prod_name3 = our_prod_name3.replaceAll("&apos", "'"); our_prod_name3 = our_prod_name3.replaceAll(""", "\""); our_prod_name4 = our_prod_name4.replaceAll("&apos", "'"); our_prod_name4 = our_prod_name4.replaceAll(""", "\""); our_prod_name5 = our_prod_name5.replaceAll("&apos", "'"); our_prod_name5 = our_prod_name5.replaceAll(""", "\""); our_prod_name6 = our_prod_name6.replaceAll("&apos", "'"); our_prod_name6 = our_prod_name6.replaceAll(""", "\""); our_prod_name7 = our_prod_name7.replaceAll("&apos", "'"); our_prod_name7 = our_prod_name7.replaceAll(""", "\""); our_prod_name8 = our_prod_name8.replaceAll("&apos", "'"); our_prod_name8 = our_prod_name8.replaceAll(""", "\""); //clob try{ Statement stmt=con.createStatement(); sql="select MAINDESCRIPTION from T_GEN_PRODUCT where ROW_ID='"+strSno+"'"; ResultSet rsclob=stmt.executeQuery(sql); if(rsclob.next()){ CLOB clob = ((OracleResultSet)rsclob).getCLOB(1); if(clob!=null && clob.length()>0 ){ MainDescription = clob.getSubString((long)1,(int)clob.length()); } } rsclob.close(); rsclob=null; stmt.close(); con.close(); con=null; }catch(Exception ee){ System.out.println("query:"+ee); } MainDescription = MainDescription.replaceAll("&apos", "'"); MainDescription = MainDescription.replaceAll(""", "\""); //MainDescription = MainDescription.replaceAll(" ", " "); java.util.Date currData = new java.util.Date(); out.print(""); out.print(""); if(!deploy_namec.equals("")){ out.print(""); } if(!deploy_named.equals("")){ out.print(""); } if(!deploy_namee.equals("")){ out.print(""); } out.print(""); out.print(""); %>
<%=codea%> <%=smessage1url%> <%=smessage2url%>
 
Contact Us
Customer Satisfaction is invaluable for us. Any questions, please let us know first.
Live Chat:
Email to us:
Please send your email directly to support@ibrook.net, We will reply all you questions in one working day.
Call us:
(925)461-2828 ibrook (Gallop Fulfillment Inc)
 
 
<%=MainDescription%>
FAQ
Q: How long will it be before I receive my order?
A: For USPS Priority Mail, you should receive your order within 2-3 business days. Please allow additional time for shipments to U.S. Territories, PO Boxes, or Military APO/FPO addresses.

Q: What do you charge for USPS Priority Mail Shipping an order?
A: All orders shipped to a destination within the United States, U.S. Territories, or to Military APO/FPO addresses are shipped $4.75 of charge.

Q: Can I expedite my shipping?
A: The following shipping options are available when you check out. Expedited orders placed before 1 PM Pacific on a business day will be shipped out the same day. All other orders will be shipped out the next business day.
  • 1-Business Day (Over night) Shipping and Handling:$19.75
  • 2-3 Business Day Gallop Standard Shipping and Handling: $4.75

    • *Sorry, expedited shipping is not available for shipments to Hawaii, Alaska, U.S. Territories, PO Boxes, or Military APO/FPO addresses. Please allow additional time for orders shipped to these addresses.

    Q: I just placed an order online, when will I get my order?
    A: Depending on the shipping options that you have chosen, your delivery day will fall into one of these catergories:
    *All expedited orders placed after 1pm PST, please allow 1 additional business day for delivery.

    Ordered On

    1 Business Day Shipping *
    2-3 Business Day Gallop Standard Shipping *
    nbsp;
    Expected Delivery
    Expected Delivery
    Monday
    Tuesday
    Wednesday-Thursday
    Tuesday
    Wednesday
    Thursday-Friday
    Wednesday
    Thursday
    Friday-Monday
    Thursday
    Friday
    Monday-Tuesday
    Friday
    Monday
    Tuesday-Wednesday
    Saturday
    Tuesday
    Wednesday-Thursday
    Sunday
    Tuesday
    Wednesday-Thursday


    Q: Do you ship to addresses outside the United States?
    A: Sorry. We only ship to all U.S. States, U.S. Territories and Military APO/FPO addresses.

    Q: Do you ship to PO Boxes or Military APO/FPO addresses?
    A: Shipments can be sent to both PO Boxes and Military APO/FPO addresses. Please allow additional time for orders shipped to these addresses.

    Q: Do you offer combine shipping?
    A: Sorry, We don't offer combine shipping.

    Q: How can I track my order?
    A: Once an order has shipped out, we will send you an email with the tracking number. Just click on the link and it will take you to the UPS, FedEx or USPS website, depending on who shipped your package.

    Q: Will I have to sign for my package?
    A: Typically, we do not require a signature when we ship your package. However, there are instances when the delivery driver may decide to choose this option, which is at their discretion.

    Q: I just received an email with my tracking number and the number shows my order was delivered. How is that possible?
    A: UPS recycles all of their tracking numbers. Sometimes, for a full day after a tracking number is assigned to a new package, the information available will pertain to a previous order that traveled -- sometimes months ago -- under that same number.
    When this happens, please rest assured that your tracking information will be available within a short period of time and should indicate the correct delivery date. Once the package is scanned by UPS, you will also be able to click the "view package progress" link, and the updated tracking detail will be reflected.

    Q: What are the shipping charges for returning an order?
    A: If your return is not the result of our error, all return shipping costs will be paid by yourself.
     
    		 

  • <%=codea%>
    •
  • <%=smessage1url%> <%=smessage2url%>