/** * This method supplies a human readable string representation of this object. for example * "Country is Romania"... so an representation of this object could be displayed on the page. * * @return A human readable representation of an object. */ public String toHumanString() { StringBuffer ret = new StringBuffer(); if (((null != searchString) || (null != searchStringMin && null != searchStringMax)) && null != relationOp) { if (0 == SEARCH_AREA.compareTo(searchType)) { ret.append( Utilities.prepareHumanString( "size <strong>" + (relationOp.intValue() == Utilities.OPERATOR_IS.intValue() ? "" : "is"), searchString, searchStringMin, searchStringMax, relationOp) + "</strong> ha"); } if (0 == SEARCH_LENGTH.compareTo(searchType)) { ret.append( Utilities.prepareHumanString( "length <strong>" + (relationOp.intValue() == Utilities.OPERATOR_IS.intValue() ? "" : "is"), searchString, searchStringMin, searchStringMax, relationOp) + "</strong> m"); } } if (null != country) { // AND C.AREA_NAME_EN='FRANCE' ret.append(", in country <strong>" + country + "</strong>"); } if (yearMin != null && yearMax != null) { ret.append( ", and year between: <strong>" + yearMin + "</strong> and <strong>" + yearMax + "</strong>"); } else { if (null != yearMin) { ret.append(", and year greater than <strong>" + yearMin + "</strong>"); } if (null != yearMax) { ret.append(", and year smaller that <strong>" + yearMax + "</strong>"); } } // Search in results if (null != criteriaSearch && null != criteriaType && null != oper) { ret.append( Utilities.prepareHumanString( (String) humanMappings.get(criteriaType), criteriaSearch, oper)); } return ret.toString(); }
/** * This method implements a procedure from morphing the object into an web page FORM * representation. What I meant to say is that I can say about an object for example: < INPUT * type='hidden" name="searchCriteria" value="natrix"> < INPUT type='hidden" name="oper" * value="1"> < INPUT type='hidden" name="searchType" value="1">. * * @return Web page FORM representation of the object. */ public String toFORMParam() { StringBuffer res = new StringBuffer(); if (null != searchType) { res.append(Utilities.writeFormParameter("searchType", searchType.toString())); } if (null != searchString) { res.append(Utilities.writeFormParameter("searchString", searchString)); } if (null != relationOp) { res.append(Utilities.writeFormParameter("relationOp", relationOp.toString())); } if (null != searchStringMin) { res.append(Utilities.writeFormParameter("searchStringMin", searchStringMin)); } if (null != searchStringMax) { res.append(Utilities.writeFormParameter("searchStringMax", searchStringMax)); } if (null != country) { res.append(Utilities.writeFormParameter("country", country)); } if (null != yearMin) { res.append(Utilities.writeFormParameter("yearMin", yearMin)); } if (null != yearMax) { res.append(Utilities.writeFormParameter("yearMax", yearMax)); } // Search in results if (null != criteriaSearch) { res.append(Utilities.writeFormParameter("criteriaSearch", criteriaSearch)); } if (null != criteriaType) { res.append(Utilities.writeFormParameter("criteriaType", criteriaType.toString())); } if (null != oper) { res.append(Utilities.writeFormParameter("oper", oper.toString())); } return res.toString(); }
/** * Transform this object into an SQL representation. * * @return SQL string representing this object. */ public String toSQL() { StringBuffer sql = new StringBuffer(); // System.out.println("searchString = " + searchString); if (((null != searchString) || (null != searchStringMin && null != searchStringMax)) && null != relationOp) { sql.append("("); if (0 == SEARCH_AREA.compareTo(searchType)) { sql.append( Utilities.prepareSQLOperator( "A.AREA", searchString, searchStringMin, searchStringMax, relationOp)); } if (0 == SEARCH_LENGTH.compareTo(searchType)) { sql.append( Utilities.prepareSQLOperator( "A.LENGTH", searchString, searchStringMin, searchStringMax, relationOp)); } sql.append(")"); if (null != country) { // AND C.AREA_NAME_EN='FRANCE' sql.append(" AND (C.AREA_NAME_EN='" + country + "')"); } if (null != yearMin) { sql.append(" AND (LENGTH(DESIGNATION_DATE) > 0) "); sql.append( " AND (CAST(CONCAT(IF(A.source_db='BIOGENETIC',left(designation_date,4),''), " + "IF(A.source_db='CDDA_INTERNATIONAL',right(designation_date,4),''), " + "IF(A.source_db='CDDA_NATIONAL',right(designation_date,4),''), " + "IF(A.source_db='EMERALD',right(designation_date,4),''), " + "IF(A.source_db='DIPLOMA',right(designation_date,4),''), " + "IF(A.source_db='NATURA2000',right(designation_date,4),''), " + "IF(A.source_db='CORINE',right(designation_date,4),''), " + "IF(A.source_db='NATURENET',right(designation_date,4),'')) AS SIGNED) >= " + yearMin + ") " + " AND A.DESIGNATION_DATE IS NOT NULL" + " AND A.DESIGNATION_DATE <> ''"); } if (null != yearMax) { sql.append(" AND (LENGTH(DESIGNATION_DATE) > 0) "); sql.append( " AND (CAST(CONCAT(IF(A.source_db='BIOGENETIC',left(designation_date,4),''), " + "IF(A.source_db='CDDA_INTERNATIONAL',right(designation_date,4),''), " + "IF(A.source_db='CDDA_NATIONAL',right(designation_date,4),''), " + "IF(A.source_db='EMERALD',right(designation_date,4),''), " + "IF(A.source_db='DIPLOMA',right(designation_date,4),''), " + "IF(A.source_db='NATURA2000',right(designation_date,4),''), " + "IF(A.source_db='CORINE',right(designation_date,4),''), " + "IF(A.source_db='NATURENET',right(designation_date,4),'')) AS SIGNED) <= " + yearMax + ") " + " AND A.DESIGNATION_DATE IS NOT NULL" + " AND A.DESIGNATION_DATE <> ''"); } } // Search in results if (null != criteriaSearch && null != criteriaType && null != oper) { if (0 == criteriaType.compareTo(CRITERIA_SOURCE_DB)) { sql.append( Utilities.prepareSQLOperator( (String) sqlMappings.get(criteriaType), SitesSearchUtility.translateSourceDBInvert(criteriaSearch), oper)); } else { sql.append( Utilities.prepareSQLOperator( (String) sqlMappings.get(criteriaType), criteriaSearch, oper)); } } return sql.toString(); }
/** * This method supplies a human readable string representation of this object. for example * "Country is Romania"... so an representation of this object could be displayed on the page. * * @return A human readable representation of an object. */ public String toHumanString() { StringBuffer sql = new StringBuffer(); // if sql where condition contains another conditions, will be put 'and' before the new // condition witch will be // attached to the sql where condition Vector put_and = new Vector(); // Main search criteria if (null != author && null != relationOpAuthor) { if (!author.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareHumanString("Author", author, relationOpAuthor)); } } if (((null != date && !date.equalsIgnoreCase("") && !date.equalsIgnoreCase("null")) || (null != date1 && !date1.equalsIgnoreCase("") && !date1.equalsIgnoreCase("null"))) && null != relationOpDate) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } Integer relationOpForDate = relationOpDate; if (relationOpDate.compareTo(Utilities.OPERATOR_BETWEEN) == 0) { if (date == null || (date != null && date.equalsIgnoreCase(""))) { relationOpForDate = Utilities.OPERATOR_SMALLER_OR_EQUAL; } if (date1 == null || (date1 != null && date1.equalsIgnoreCase(""))) { relationOpForDate = Utilities.OPERATOR_GREATER_OR_EQUAL; } if (date != null && date1 != null && !date.equalsIgnoreCase("") && !date1.equalsIgnoreCase("")) { relationOpForDate = Utilities.OPERATOR_BETWEEN; } } sql.append( Utilities.prepareHumanString( "Year", (date == null || date.equalsIgnoreCase("") ? date1 : date), date, date1, relationOpForDate)); } if (null != title && null != relationOpTitle) { if (!title.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareHumanString("Title", title, relationOpTitle)); } } if (null != editor && null != relationOpEditor) { if (!editor.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareHumanString("Editor", editor, relationOpEditor)); } } if (null != publisher && null != relationOpPublisher) { if (!publisher.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareHumanString("Publisher", publisher, relationOpPublisher)); } } // Search in results if (null != criteriaSearch && null != criteriaType && null != oper) { sql.append( Utilities.prepareHumanString( (String) humanMappings.get(criteriaType), criteriaSearch, oper)); } return sql.toString(); }
/** * This method implements a procedure from morphing the object into an web page FORM * representation. What I meant to say is that I can say about an object for example: < INPUT * type='hidden" name="searchCriteria" value="natrix"> < INPUT type='hidden" name="oper" * value="1"> < INPUT type='hidden" name="searchType" value="1">. * * @return Web page FORM representation of the object. */ public String toFORMParam() { StringBuffer form = new StringBuffer(); if (null != author) { form.append(Utilities.writeFormParameter("author", author)); } if (null != relationOpAuthor) { form.append(Utilities.writeFormParameter("relationOpAuthor", relationOpAuthor.toString())); } if (null != date) { form.append(Utilities.writeFormParameter("date", date)); } if (null != date1) { form.append(Utilities.writeFormParameter("date1", date1)); } if (null != relationOpDate) { form.append(Utilities.writeFormParameter("relationOpDate", relationOpDate.toString())); } if (null != title) { form.append(Utilities.writeFormParameter("title", title)); } if (null != relationOpTitle) { form.append(Utilities.writeFormParameter("relationOpTitle", relationOpTitle.toString())); } if (null != editor) { form.append(Utilities.writeFormParameter("editor", editor)); } if (null != relationOpEditor) { form.append(Utilities.writeFormParameter("relationOpEditor", relationOpEditor.toString())); } if (null != publisher) { form.append(Utilities.writeFormParameter("publisher", publisher)); } if (null != relationOpPublisher) { form.append( Utilities.writeFormParameter("relationOpPublisher", relationOpPublisher.toString())); } // Search in results if (null != criteriaSearch) { form.append(Utilities.writeFormParameter("criteriaSearch", criteriaSearch)); } if (null != criteriaType) { form.append(Utilities.writeFormParameter("criteriaType", criteriaType.toString())); } if (null != oper) { form.append(Utilities.writeFormParameter("oper", oper.toString())); } return form.toString(); }
/** * Transform this object into an SQL representation. * * @return SQL string representing this object. */ public String toSQL() { StringBuffer sql = new StringBuffer(); if (part.equalsIgnoreCase("ReferencesPart")) { // if sql where condition contains another conditions, will be put 'and' before the new // condition witch will be // attached to the sql where condition Vector put_and = new Vector(); // Main search criteria if (null != author && null != relationOpAuthor) { if (!author.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareSQLOperator("A.SOURCE", author, relationOpAuthor)); } } if (((null != date && !date.equalsIgnoreCase("") && !date.equalsIgnoreCase("null")) || (null != date1 && !date1.equalsIgnoreCase("") && !date1.equalsIgnoreCase("null"))) && null != relationOpDate) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } if (relationOpDate.compareTo(Utilities.OPERATOR_BETWEEN) == 0) { if (date == null || (date != null && date.equalsIgnoreCase(""))) { sql.append(" A.CREATED <=" + date1 + " "); } if (date1 == null || (date1 != null && date1.equalsIgnoreCase(""))) { sql.append(" A.CREATED >=" + date + " "); } if (date != null && date1 != null && !date.equalsIgnoreCase("") && !date1.equalsIgnoreCase("")) { sql.append(" A.CREATED >=" + date + " AND A.CREATED<=" + date1 + " "); } } else { sql.append(Utilities.prepareSQLOperator("A.CREATED", date, relationOpDate)); } } if (null != title && null != relationOpTitle) { if (!title.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareSQLOperator("A.TITLE", title, relationOpTitle)); } } if (null != editor && null != relationOpEditor) { if (!editor.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareSQLOperator("A.EDITOR", editor, relationOpEditor)); } } if (null != publisher && null != relationOpPublisher) { if (!publisher.equalsIgnoreCase("")) { if (put_and.contains("true")) { sql.append(" AND "); } else { put_and.addElement("true"); } sql.append(Utilities.prepareSQLOperator("A.PUBLISHER", publisher, relationOpPublisher)); } } } else { // Search in results if (null != criteriaSearch && null != criteriaType && null != oper) { sql.append( Utilities.prepareSQLOperator( (String) sqlMappings.get(criteriaType), criteriaSearch, oper)); } } return sql.toString(); }