<%
// Get each product in this catalog
if (SortBy.equals("t")) { SortBy = "prod_title"; }
else { SortBy = "fl_prod_price"; }
String sProdSuffix = "";
if (!sLang.equals("en")) sProdSuffix="_"+sLang;
sTemp = "Select fl_prod_download_only, p.fl_prod_id, trim(fl_prod_title"+sProdSuffix+") as prod_title, trim(fl_prod_title) as prod_title_fallback, fl_prod_type, fl_prod_title_script, fl_prod_price, fl_prod_code, "
+ "fl_prod_image_url, fl_prod_url_en, fl_prod_url_ps, fl_prod_url_fa, fl_prod_description, fl_prod_unit_count, fl_prod_language"+sProdSuffix+", "
+ "fl_prod_other_format, fl_prod_other_web_data, "
+ "fl_prod_downloadable, fl_prod_download_url, fl_type_units, fl_type_cat_id "
+ "from store.tb_products p inner join store.tb_type on fl_prod_type=fl_type_id inner join store.tb_product_suggestions s on p.fl_prod_id = s.fl_prod_id where fl_prod_hidden=False ";
sTemp += " order by s.fl_priority asc, " + SortBy + ";";
ppst = db.prepareStatement(sTemp);
rs = ppst.executeQuery();
bookcount = 0;
String sProductURL = "";
String sProductLang = "";
double dProductPrice = 0;
//DecimalFormat dfCurr = new DecimalFormat("#.00");
while (rs.next()) {
bookcount += 1;
ProductID = nullStr(rs.getString("fl_prod_id"));
ProductTitle = nullStr(rs.getString("prod_title"));
if (ProductTitle.equals("")) ProductTitle = nullStr(rs.getString("prod_title_fallback"));
ScriptTitle = nullStr(rs.getString("fl_prod_title_script"));
dProductPrice = rs.getDouble("fl_prod_price");
ProductPrice = NumberFormat.getCurrencyInstance(locale).format(rs.getFloat("fl_prod_price"));
ProductPriceCurrency = sCurrencyHtml + " " + dfCurr.format(rs.getFloat("fl_prod_price") * dCurrencyRate);
ProductCode = nullStr(rs.getString("fl_prod_code"));
ImageURL = nullStr(rs.getString("fl_prod_image_url"));
DownloadOnly = rs.getBoolean("fl_prod_download_only");
DownloadURL = nullStr(rs.getString("fl_prod_download_url"));
sProductURL = "/"+sLang+"/"+nullStr(rs.getString("fl_prod_url_"+sLang));
ProductDescription = HtmlStr(rs.getString("fl_prod_description"));
sProductLang = nullStr(rs.getString("fl_prod_language"+sProdSuffix));
OtherFormat = nullStr(rs.getString("fl_prod_other_format"));
OtherWebData = nullStr(rs.getString("fl_prod_other_web_data"));
ProductType = nullStr(rs.getString("fl_type_units"));
CatID = rs.getInt("fl_type_cat_id"); // need to retrieve for search
// Find other languages
/*
OtherLanguage = "";
st_lang = db.createStatement();
rs_lang = st_lang.executeQuery("Select fl_prod_language from store.tb_products where trim(fl_prod_title) = " + quotedStr(ProductTitle) + " "
+ "and fl_prod_id !=" + ProductID + " and fl_prod_hidden = false and fl_prod_type=" + rs.getInt("fl_prod_type") + ";");
while (rs_lang.next()) {
OtherLanguage += nullStr(rs_lang.getString("fl_prod_language")) + ", ";
}
rs_lang.close();
st_lang.close();
*/
/*
if (OtherLanguage.length() > 2) OtherLanguage = OtherLanguage.substring(0, OtherLanguage.length() - 2);
*/
if (nullStr(rs.getString("fl_prod_downloadable")).equals("f")) DownloadURL = "" ;
%>
Welcome to the Afghan Media Centre. The site is undergoing maintenance, please try again later, using the menu above to navigate the site.
<%
}
%>
<%
/* if (!ImageURL.equals("")) { */ %>
<% /* } */
%>
<%
}
rs.close();
ppst.close();
if (bookcount == 0) {
%>
<%= ProductTitle %>
<%=sProductLang%>
<% st_bullet = db.createStatement(); rs_bullet = st_bullet.executeQuery("select * from store.tb_product_bullets where fl_prod_id = "+ ProductID +" order by fl_order asc" ); iBullets = 0; while (rs_bullet.next()) { iBullets++; if (iBullets == 1) { %>- <%
}
%>
- <%=nullStr(rs_bullet.getString("fl_bullet_"+sLang))%> <% } if (iBullets>0) { %>
<%= ProductDescription %>
<% }
if (!(dProductPrice == 0.0)) { %>
<%= ProductPriceCurrency %>
<% } %>