| |
 | My
IPF |
|
| |
You, as a Registered User/Business Visitor, are our focus. Providing more and more user-friendly services that make you feel comfortable and convenient on this portal is our goal. As an extension of this customer-focused approach, it is an on-going process at
www.ipfonline.com to conceptualize and facilitate add-on services, translating mundane tasks into unique experiences that are feature-rich and user-friendly.
Explore My IPF - It's absolutely free and offers many services under a single window |
| |
| View/Organize Trade Enquiries Sent/Received by you. View Product Profiles and Industrial Storefront of your firm/company. Select the product in which you are interested and start receiving Product Alerts, automatically. Add product profiles and information that grabs your attention in My Clippings for future reference. Change/update your User Profile and keep us posted... |
| |
<%if (shpp !=null && !shpp.equals("")) {%>
<%
String SQL=null, SQL1=null, SQL2=null, SQL3=null, SQL4=null, SQL5=null;
int EnquiryReceived = 0, SFE_EnquiryReceived = 0, EnquirySent = 0, MyProducts = 0, MyClippings = 0;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
int i=1;
try {
con = com.ipf.global.app.IPFDBUtils.getConnection();
stmt = con.createStatement();
//My Enquiries Received
SQL1="select count(*) from EmpEnquiry where Date(ENQUIREDON)>'09-01-2004' and (MfrPub is null or Ltrim(Rtrim(MfrPub))='') and Merchant="+shpp;
//My Enquiries Sent
SQL2="select count(*) from EmpEnquiry, Product where Date(ENQUIREDON)>'09-01-2004' and Product=PRRFNBR and (PRSPECIAL is null or Ltrim(Rtrim(PRSPECIAL))='' ) and (UsrPub is null or Ltrim(Rtrim(UsrPub))='') and Shopper="+shpp;
//My Products
SQL3="Select count(*) FROM PRODUCT WHERE PRPRFNBR is Not Null And (Prpub=1 or Prpub=7)And PRMENBR="+shpp;
//My Clippings
SQL4="select count(*) from Clippings where Upper(ClipPub)='S' and ClipShopper="+shpp;
//My Enquiries Received (SFE_EnquiryReceived - Storefront)
SQL5="select count(*) from StorefrontEnquiry, Product where Date(PostingDate)>'09-01-2004' and (SFEFIELD1 is null or Ltrim(Rtrim(SFEFIELD1))='') and ProductNumber=Prrfnbr and Prmenbr="+shpp;
SQL = "("+SQL1+") UNION ALL ("+SQL2+") UNION ALL ("+SQL3+") UNION ALL ("+SQL4+") UNION ALL ("+SQL5+")";
rs=stmt.executeQuery(SQL);
while (rs.next()) {
if (i==1){EnquiryReceived = rs.getInt(1);}
if (i==2){EnquirySent = rs.getInt(1);}
if (i==3){MyProducts = rs.getInt(1);}
if (i==4){MyClippings = rs.getInt(1);}
if (i==5){SFE_EnquiryReceived = rs.getInt(1);}
i++;}
EnquiryReceived = EnquiryReceived + SFE_EnquiryReceived;
if (rs != null) {rs.close();}
if (stmt != null) {stmt.close();}
if (con != null) {con.close();}
} catch(Exception e){
if (rs != null) {rs.close();}
if (stmt != null) {stmt.close();}
if (con != null) {con.close();}%> <%=e%> <%
} %>
<%}else{%>
Please login to use this feature
<%}%>
|
|
|
|
