|
|
Base de Datos de Licitaciones
<%
try {
int dataSourceId0 = Integer.parseInt("35");
//Creating query request
com.nivaria.consulta.QueryRequest qrequest0 = new com.nivaria.consulta.QueryRequest(request,dataSourceId0);
String pref0 = qrequest0.getParameterPrefix();
String step = qrequest0.getParameter("step")!=null?qrequest0.getParameter("step"):"1";
String adv = qrequest0.getParameter("advanced")!=null?qrequest0.getParameter("advanced"):"0";
String valLateral = null; //Array para items con lateral
if(qrequest0.getParameter("PRDID")==null && "1".equals(step) && true) { %>
<%@ page import="com.nivaria.consulta.*,com.nivaria.consulta.impl.*,com.nivaria.consulta.impl.ncm.*, com.nivaria.commerce.*"%>
<%
try {
int dataSourceId = Integer.parseInt("35");
com.nivaria.core.CoreManager cm = (com.nivaria.core.CoreManager)application.getAttribute("com.nivaria.core");
//Creating Query request
com.nivaria.consulta.QueryRequest qrequest = new com.nivaria.consulta.QueryRequest(request,dataSourceId);
String pref = qrequest.getParameterPrefix();
String srchBy = qrequest.getParameter("srchBy")!=null?qrequest.getParameter("srchBy"):"";
String srch = qrequest.getParameter("srch")!=null?qrequest.getParameter("srch"):"";
String desde = qrequest.getParameter("desde")!=null?qrequest.getParameter("desde"):"";
String hasta = qrequest.getParameter("hasta")!=null?qrequest.getParameter("hasta"):"";
String pageNum = "0";
java.util.List fields = new java.util.ArrayList();
boolean inPreview = false;
if (currentIssue==null){
currentIssue= (com.nivaria.epress.Issue)ep.getActiveIssue();
}
fields.add(new Field_s("Nombre","NAME","false","TEXT","false","false"));
fields.add(new Field_s("País","COUNTRY","false","LIST923","false","false"));
fields.add(new Field_s("Tipo de contrato","CONTRACTTYPE","false","LIST933","false","false"));
fields.add(new Field_s("Fecha","LIMITDATE","false","DATE","false","false"));
fields.add(new Field_s("Tipo de anuncio","TYPE","false","LIST938","false","false"));
fields.add(new Field_s("Sector","SECTOR","false","LIST918","false","false"));
com.nivaria.data.DataSourceManager dsm = new com.nivaria.data.DataSourceManager(cm);
com.nivaria.data.DataSource ds = dsm.getDataSource(dataSourceId);
int conType = Integer.parseInt((String)ds.getDataValue("TYPE",langId));
boolean con_db = conType==com.nivaria.data.DataSourceManager.TYPE_DB;
%>
<% } catch(Exception srchEx) {throw srchEx;} %>
<% } else if(qrequest0.getParameter("PRDID")!=null || "3".equals(step)) { %>
<%@ page import="com.nivaria.consulta.*,com.nivaria.consulta.impl.*,com.nivaria.consulta.impl.ncm.*"%>
<%@ page import="com.nivaria.commerce.domain.*"%>
<%
try {
com.nivaria.core.CoreManager cm = (com.nivaria.core.CoreManager)application.getAttribute("com.nivaria.core");
/*com.nivaria.epress.EPressManager ep = (com.nivaria.epress.EPressManager) application.getAttribute("com.nivaria.epress");*/
CObject prd = null;
int dataSourceId = Integer.parseInt("35");
//Creating query request
com.nivaria.consulta.QueryRequest qrequest = new com.nivaria.consulta.QueryRequest(request,dataSourceId);
String pref = qrequest.getParameterPrefix();
/*com.nivaria.epress.Issue currentIssue= ep.getIssue(5);*/
if (currentIssue== null){
currentIssue= (com.nivaria.epress.Issue)ep.getActiveIssue();
}
java.util.List fields = new java.util.ArrayList();
fields.add(new Field_s("Name","NAME","false","TEXT","false","false"));
fields.add(new Field_s("Tipo de anuncio","TYPE","false","LIST938","false","true"));
fields.add(new Field_s("Referencia","REFERENCE","false","TEXT","false","true"));
fields.add(new Field_s("Sector","SECTOR","false","LIST918","false","true"));
fields.add(new Field_s("Agencia ejecutora","ENTITY","false","TEXT","false","true"));
fields.add(new Field_s("País","COUNTRY","false","LIST923","false","true"));
fields.add(new Field_s("Fecha","LIMITDATE","false","DATE","false","true"));
fields.add(new Field_s("Descripción","DESCRIPTION","false","TEXT","false","true"));
fields.add(new Field_s("Financiación","FINANCE","false","LIST928","false","true"));
fields.add(new Field_s("Tipo de contrato","CONTRACTTYPE","false","LIST933","false","true"));
fields.add(new Field_s("Más información","INFO","false","EMAIL","false","true"));
fields.add(new Field_s("Observaciones","OBSERVATION","false","TEXT","false","true"));
if(qrequest.getParameter("PRDID")!=null && !qrequest.getParameter("PRDID").equals("")) {
java.util.Map pmap = (java.util.Map)session.getAttribute(pref+"PRDMAP");
if (pmap!=null)
prd = (CObject)pmap.get(qrequest.getParameter("PRDID"));
if (prd==null) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.commerce.CommerceInterface item = cf.getProduct(Integer.parseInt(qrequest.getParameter("PRDID")));
if (item!=null) {
prd = new CObjectNCM(item);
}
}
} else if(qrequest.getParameter("ID")!=null && !qrequest.getParameter("ID").equals("")) {
java.util.Map pmap = (java.util.Map)session.getAttribute(pref+"PRDMAP");
if (pmap!=null)
prd = (CObject)pmap.get(qrequest.getParameter("ID"));
if (prd==null) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.commerce.CommerceInterface item = cf.getProduct(Integer.parseInt(qrequest.getParameter("ID")));
if (item!=null) {
prd = new CObjectNCM(item);
}
}
} else if(qrequest.getParameter("PROID")!=null && !qrequest.getParameter("PROID").equals("")) {
java.util.Map pmap = (java.util.Map)session.getAttribute(pref+"PRDMAP");
if (pmap!=null)
prd = (CObject)pmap.get(qrequest.getParameter("PROID"));
if (prd==null) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.commerce.CommerceInterface item = cf.getProduct(Integer.parseInt(qrequest.getParameter("PROID")));
if (item!=null) {
prd = new CObjectNCM(item);
}
}
} else if(qrequest.getParameter("CATID")!=null && !qrequest.getParameter("CATID").equals("")) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.commerce.CommerceInterface cat = cf.getCategory(Integer.parseInt(qrequest.getParameter("CATID")));
if(cat!=null) {
prd = new CObjectNCM(cat);
}
} else if(qrequest.getParameter("SECID")!=null && !qrequest.getParameter("SECID").equals("")) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.commerce.CommerceInterface sec = cf.getSection(Integer.parseInt(qrequest.getParameter("SECID")));
if(sec!=null) {
prd = new CObjectNCM(sec);
}
} else if(qrequest.getParameter("pid")!=null && !qrequest.getParameter("pid").equals("")) {
CObject[] prds = (CObject[]) session.getAttribute(pref+"COBJECTS");
prd = prds[Integer.parseInt(qrequest.getParameter("pid"))];
}
int counterZebra = 0;
int complexObjects=0;
boolean tableClossed=false;
boolean tableStarted=false;
boolean prevObjComplex=false;
if(prd!=null) {%>
<% String valImg = null;
boolean isAviso = false;
if(prd instanceof CObjectNCM) {
com.nivaria.commerce.CommerceInterface cprd = (com.nivaria.commerce.CommerceInterface)((CObjectNCM)prd).getNode();
isAviso = "ITEM_AVISO".equalsIgnoreCase(cprd.getDataType().getName());
}
String imgAlign="";
for(int j=0;j ";
}else{
valImg = "";
}
String furl = com.nivaria.util.FilePath.getRelativePath("licitaciones.jsp", (String)file.getDataValue("URL",langId));
furl= com.nivaria.util.FilePath.pathToWeb(furl);
valImg += " ![\""+((file.getDataValue("ALT",langId)!=null?(String)file.getDataValue("ALT",langId):""))+"\"](\""+furl+"\" "\\"\"+((file.getDataValue(\"ALT\",langId)!=null?(String)file.getDataValue(\"ALT\",langId):\"\"))+\"\\"") ";
if((String)file.getDataValue("FOOT",langId)!= null && (!((String)file.getDataValue("FOOT",langId)).equals(""))) {
valImg += " "+((String)file.getDataValue("FOOT",langId))+" ";
}
valImg += " <%=val%>
<% tableStarted=true;
} else {
if (!tableStarted){%>
<% }
val.trim();%>
<% if(fld.getDt().equals("FILE")) {
if (!tableClossed){%>
<% tableClossed=true;
}
if (complexObjects==0){%>
<% }%>
<%
Object[] files = prd.getDataValueList(fld.getTitle_org(),langId);
String[] extentionsArray = {"css" ,"exe","divx","doc","gif","gz","iso","jpeg","jpg","js","mov","mp3","mpg","pdf","png","ppt","ps","rar","rtf","swf","tar","tgz","txt","wav","xls","xml","zip"};
java.util.Arrays.sort(extentionsArray);
String className="";
int zebraCounter=0;
String extention="";
String contentType="";
boolean hasHead = false;
for(int k=0;files!=null && k
<%=fld.getTitle()%>
A list of web resources
| Archivos |
Tipo
| Tamaño
|
<% hasHead = true;
}
String fsize = (String)file.getDataValue("FILESIZE",langId);
if(fsize!=null && !fsize.trim().equals("")) {
fsize = com.nivaria.util.Files.getFileSize(fsize);
} else {
fsize = "";
}
String fname = (String)file.getDataValue("NAME",langId);
String ftitle = (String)file.getDataValue("TITLE",langId);
if(ftitle==null || ftitle.trim().equals("")) {
ftitle = fname;
}
className=(zebraCounter%2)==0?"even":"odd";
zebraCounter++;
extention = fname.substring(fname.lastIndexOf(".")+1);
int indA = java.util.Arrays.binarySearch(extentionsArray,extention);
contentType="contentType iconified ";
if(indA>=0) {
contentType += extentionsArray[indA]+"Content";
} else {
contentType += "unknownContent";
} %>
| <%=ftitle%> |
<%="."+extention%> |
<%=fsize%> |
<% }
}
}
if(hasHead) { %>
<% }
%>
<% complexObjects++;
prevObjComplex=true;
}else{
if (prevObjComplex){%>
<% prevObjComplex=false;
tableClossed=false;
}%>
<% if(!(fld.getDt().equals("IMAGE"))) { %>
|
<% if(fld.showTitle()) { %>
<% if(fld.getTitle_org().equals("LIMITDATE")) { %>
<% } %>
<%=(isAviso && fld.getTitle_org().equals("LIMITDATE")?"Fecha prevista":fld.getTitle())%>:
<% if(fld.getTitle_org().equals("LIMITDATE")) { %>
<% } %>
<% } %>
|
<% if(fld.getTitle_org().equals("LIMITDATE")) { %>
<% } %>
<%=val%>
<% if(fld.getTitle_org().equals("LIMITDATE")) { %>
<% } %>
|
<% }%>
<% } %>
<% } %>
<% } %>
<% } %>
<% if (!tableClossed){%>
<%}%>
<%
if(prd instanceof CObjectNCM) {
com.nivaria.commerce.domain.CommerceFacade cf = new com.nivaria.commerce.domain.CommerceFacade(cm);
com.nivaria.edit.Property node = ((CObjectNCM)prd).getNode();
com.nivaria.commerce.CommerceInterface[] relprds = null;
if(node instanceof Product) {
// relprds = cf.getPublishedProducts((Product)node,false);
relprds = cf.getProducts((Product)node);
if (!false && relprds!=null && relprds.length>0){
List list = new ArrayList();
for (int k=0; k0) { %>
Relacionados
<% for(int ri=0;ri
-
<% String prdName = relPrd.getName(); %>
<% prdName = irelprd.getDataType().getDescription()+": "+prdName;%>
<%=prdName%>
<% } %>
<% } %>
<% }
}
%>
Volver
<% } %>
<% } catch(Exception srchEx) {throw srchEx;} %>
<% } else if("2".equals(step) || false) { %>
<%@ page import="com.nivaria.consulta.*,com.nivaria.consulta.impl.*,com.nivaria.consulta.impl.ncm.*"%>
<%
try {
int dataSourceId = Integer.parseInt("35");
com.nivaria.core.CoreManager cm = (com.nivaria.core.CoreManager)application.getAttribute("com.nivaria.core");
/*com.nivaria.epress.EPressManager ep = (com.nivaria.epress.EPressManager) application.getAttribute("com.nivaria.epress");*/
/*com.nivaria.commerce.domain.CommerceFacade shp = new com.nivaria.commerce.domain.CommerceFacade(cm);*/
//Creating Query request
com.nivaria.consulta.QueryRequest qrequest = new com.nivaria.consulta.QueryRequest(request,dataSourceId);
String pref = qrequest.getParameterPrefix();
String srchBy = qrequest.getParameter("srchBy")!=null?qrequest.getParameter("srchBy"):"";
String srch = qrequest.getParameter("srch")!=null?qrequest.getParameter("srch"):"";
String desde = qrequest.getParameter("desde")!=null?qrequest.getParameter("desde"):"";
String hasta = qrequest.getParameter("hasta")!=null?qrequest.getParameter("hasta"):"";
String pageNum = "0";
boolean inPreview = false;
/*com.nivaria.epress.Issue currentIssue= ep.getIssue(5);*/
if (currentIssue== null) {
currentIssue= (com.nivaria.epress.Issue)ep.getActiveIssue();
}
java.util.List fields = new java.util.ArrayList();
String srchByDt = "";
fields.add(new Field_s("Name","NAME","false","TEXT","false","false"));
if(srchBy.equals("NAME"))
srchByDt = "TEXT";
fields.add(new Field_s("País","COUNTRY","false","LIST923","false","false"));
if(srchBy.equals("COUNTRY"))
srchByDt = "LIST923";
fields.add(new Field_s("Tipo de anuncio","TYPE","false","LIST938","false","false"));
if(srchBy.equals("TYPE"))
srchByDt = "LIST938";
fields.add(new Field_s("Fecha","LIMITDATE","false","DATE","false","false"));
if(srchBy.equals("LIMITDATE"))
srchByDt = "DATE";
fields.add(new Field_s("Referencia","REFERENCE","false","TEXT","false","false"));
if(srchBy.equals("REFERENCE"))
srchByDt = "TEXT";
fields.add(new Field_s("Observaciones","OBSERVATION","false","TEXT","false","false"));
if(srchBy.equals("OBSERVATION"))
srchByDt = "TEXT";
fields.add(new Field_s("Sector","SECTOR","false","LIST918","false","false"));
if(srchBy.equals("SECTOR"))
srchByDt = "LIST918";
com.nivaria.data.DataSourceManager dsm = new com.nivaria.data.DataSourceManager(cm);
com.nivaria.data.DataSource ds = dsm.getDataSource(dataSourceId);
int conType = Integer.parseInt((String)ds.getDataValue("TYPE",langId));
boolean categorize = conType==com.nivaria.data.DataSourceManager.TYPE_CATEGORIZE;
boolean con_db = conType==com.nivaria.data.DataSourceManager.TYPE_DB;
%>
<% } catch(Exception srchEx) {} %>
<% }
} catch(Exception ups106341) {} %>
|
|
|
