private Division getDivision(String divisionId, String divisionName) {
Division division = divisionNavigator.getDivision(divisionId, divisionName);
for (Club club : division.getClubs()) {
clubNavigator.updateClubDetails(club);
clubNavigator.loadClubPlayers(club);
refreshClubPlayers(club);
}
Collections.sort(division.getClubs(), DugoutUtils.CLUB_FIRST_11_COMPARATOR);
return division;
}
/*
* Add a new record to the Organization table,
* creates an admin account when SA creates a new consulting company
* @param OrganizationCode (based on Company Name)
* @param OrganizationName (based on Company Description)
* @param FKCompanyID
* @param NameSequence
* @param PKUser
* @param nomRater
* @throws SQLException
* @throws Exception
* @author: Mark Oei
* @since v.1.3.12.63 09 Mar 2010
*/
public boolean addOrganisationByCons(
String OrganizationCode,
String OrganizationName,
int FKCompanyID,
int NameSequence,
int PKUser,
String nomRater)
throws SQLException, Exception {
Connection con = null;
Statement st = null;
boolean bIsAdded = false;
String sql =
"INSERT INTO tblOrganization (OrganizationCode, OrganizationName, FKCompanyID, NameSequence, NominationModule)";
sql =
sql
+ " VALUES ('"
+ OrganizationCode
+ "', '"
+ OrganizationName
+ "', "
+ FKCompanyID
+ ", "
+ NameSequence
+ ", '"
+ Boolean.parseBoolean(nomRater)
+ "')";
try {
con = ConnectionBean.getConnection();
st = con.createStatement();
int iSuccess = st.executeUpdate(sql);
System.out.println(iSuccess);
if (iSuccess != 0) bIsAdded = true;
} catch (Exception E) {
System.err.println("Organization.java - AddRecord - " + E);
} finally {
ConnectionBean.closeStmt(st); // Close statement
ConnectionBean.close(con); // Close connection
}
System.out.println("1. Add Organization");
// add default under the organization.
String defaultName = "NA";
int FKOrganization = checkOrgExist(OrganizationCode, OrganizationName, FKCompanyID);
// Change to disable print statement. Used for debugging only
// Mark Oei 19 Mar 2010
// System.out.println("testing " + FKOrganization);
System.out.println("2. Check Organization Exist");
if (FKOrganization != 0) {
// Add Division
div.addRecord(defaultName, FKOrganization, PKUser);
System.out.println("3. Add Division");
// Add Department
dept.addRecord(defaultName, FKOrganization, PKUser);
System.out.println("4. Add Department");
// Add Group
G.addRecord(defaultName, FKOrganization, PKUser);
System.out.println("5. Add Group");
// Check whether exists
int FKDivision = div.checkDivExist(defaultName, FKOrganization);
int FKDepartment = dept.checkDeptExist(defaultName, FKOrganization);
int FKGroup = G.checkGroupExist(defaultName, FKOrganization);
// Create links
dept.linkDepartment(FKDivision, FKDepartment);
G.linkGroup(FKDepartment, FKGroup);
// Establish new admin account and password
Date timeStamp = new java.util.Date();
SimpleDateFormat dFormat = new SimpleDateFormat("ddMMyyHHmmss");
String temp = dFormat.format(timeStamp);
String loginName = OrganizationCode + "admin";
String password = OrganizationCode + temp;
int userType = 6;
// Insert record into database
U.addRecord(
FKDepartment,
FKDivision,
userType,
"Admin",
"Admin",
loginName,
"NA",
"NA",
FKGroup,
password,
1,
FKCompanyID,
FKOrganization,
"NA",
PKUser);
System.out.println("6. Add User");
int userExist =
U.checkUserExist(
FKDepartment,
FKDivision,
userType,
"Admin",
"Admin",
loginName,
"NA",
"NA",
FKGroup,
password,
1,
FKCompanyID,
FKOrganization);
System.out.println(
"FKDivision = "
+ FKDivision
+ ", FKDepartment = "
+ FKDepartment
+ ", FKGroup = "
+ FKGroup
+ " and User Exist = "
+ userExist);
if (userExist != 0) {
try {
U.insertRelation(userExist, userExist, 0);
} catch (SQLException SE) {
System.out.println(SE.getMessage());
}
// Send email notification
String content = template.ForgotPass_temp(loginName, password);
String email = "*****@*****.**";
// Edited By Roger 13 June 2008
Email.sendMail(
server.getAdminEmail(),
email,
"New Admin Assignment for " + OrganizationName,
content,
FKOrganization);
}
System.out.println("8. Add User Relation");
}
sDetail = detail.getUserDetail(PKUser);
ev.addRecord("Insert", itemName, OrganizationName, sDetail[2], sDetail[11], sDetail[10]);
return bIsAdded;
} // End Method for addOrganisationByCons
@Override
public void addBody(Body body)
throws SAXException, WingException, UIException, SQLException, IOException,
AuthorizeException {
Request request = ObjectModelHelper.getRequest(objectModel);
DSpaceObject dso = HandleUtil.obtainHandle(objectModel);
// Set up the major variables
// Collection collection = (Collection) dso;
// Build the collection viewer division.
// Make sure we get our results
queryResults = getQueryResponse(dso);
if (this.queryResults != null) {
Map<String, List<DiscoverResult.FacetResult>> facetFields =
this.queryResults.getFacetResults();
if (facetFields == null) {
facetFields = new LinkedHashMap<String, List<DiscoverResult.FacetResult>>();
}
// facetFields.addAll(this.queryResults.getFacetDates());
if (facetFields.size() > 0) {
String facetField =
String.valueOf(facetFields.keySet().toArray(new String[facetFields.size()])[0]);
java.util.List<DiscoverResult.FacetResult> values = facetFields.get(facetField);
if (values != null && 0 < values.size()) {
Division results = body.addDivision("browse-by-" + facetField + "-results", "primary");
results.setHead(
message(
"xmlui.ArtifactBrowser.AbstractSearch.type_"
+ request.getParameter(FACET_FIELD)
+ "_browse"));
// Find our faceting offset
int offSet = queryArgs.getFacetOffset();
if (offSet == -1) {
offSet = 0;
}
// Only show the nextpageurl if we have at least one result following our current results
String nextPageUrl = null;
if (values.size() == (DEFAULT_PAGE_SIZE + 1)) {
nextPageUrl = getNextPageURL(request);
}
results.setSimplePagination(
(int) queryResults.getDspaceObjects().size(),
offSet + 1,
(offSet + (values.size() - 1)),
getPreviousPageURL(request),
nextPageUrl);
Table singleTable =
results.addTable(
"browse-by-" + facetField + "-results",
(int) (queryResults.getDspaceObjects().size() + 1),
1);
List<String> filterQueries = new ArrayList<String>();
if (request.getParameterValues("fq") != null) {
filterQueries = Arrays.asList(request.getParameterValues("fq"));
}
for (int i = 0; i < values.size(); i++) {
DiscoverResult.FacetResult value = values.get(i);
String displayedValue = value.getDisplayedValue();
String filterQuery = value.getAsFilterQuery();
// if(field.getGap() != null){
// //We have a date get the year so we can display it
// DateFormat simpleDateformat = new
// SimpleDateFormat("yyyy");
// displayedValue =
// simpleDateformat.format(SolrServiceImpl.toDate(displayedValue));
// filterQuery =
// ClientUtils.escapeQueryChars(value.getFacetField().getName()) + ":" + displayedValue
// + "*";
// }
Cell cell = singleTable.addRow().addCell();
// No use in selecting the same filter twice
if (filterQueries.contains(filterQuery)) {
cell.addContent(displayedValue + " (" + value.getCount() + ")");
} else {
cell.addXref(
contextPath
+ (dso == null ? "" : "/handle/" + dso.getHandle())
+ "/discover?"
+ "&fq="
+ URLEncoder.encode(filterQuery, "UTF-8")
+ (request.getQueryString() != null ? "&" + request.getQueryString() : ""),
displayedValue + " (" + value.getCount() + ")");
}
}
}
}
}
// DSpaceObject dso = HandleUtil.obtainHandle(objectModel);
/*
if (dso != null)
{
if (dso instanceof Collection)
{
browseContext.addItem().addXref(contextPath + "/discovery/?q=search.resourcetype%3A2+AND+location%3Al" + dso.getID(), T_head_this_collection );
}
if (dso instanceof Community)
{
browseContext.addItem().addXref(contextPath + "/discovery/?q=search.resourcetype%3A2+AND+location%3Am" + dso.getID(), T_head_this_community );
}
}
browseGlobal.addItem().addXref(contextPath + "/discovery/?q=search.resourcetype%3A2", T_head_all_of_dspace );
*/
}
/** Sherpa romeo submission support */
public void make_sherpaRomeo_submission(Item item, Division divIn) throws WingException {
if (ConfigurationManager.getBooleanProperty(
"webui.submission.sherparomeo-policy-enabled", true)) {
SHERPASubmitService sherpaSubmitService =
new DSpace().getSingletonService(SHERPASubmitService.class);
if (sherpaSubmitService.hasISSNs(context, item)) {
List div = divIn.addList("submit-upload-new", List.TYPE_FORM);
div.setHead(T_sherpa_title);
// Since sherpa web service doesn't work reliable with more than 1 issn, perform the service
// for each issn
Set<String> issns = sherpaSubmitService.getISSNs(context, item);
Iterator<String> issnsIterator = issns.iterator();
int i = 0;
while (issnsIterator.hasNext()) {
SHERPAResponse shresp =
sherpaSubmitService.searchRelatedJournalsByISSN(issnsIterator.next());
java.util.List<SHERPAJournal> journals = shresp.getJournals();
java.util.List<SHERPAPublisher> publishers = shresp.getPublishers();
if (CollectionUtils.isNotEmpty(journals)) {
for (SHERPAJournal journ : journals) {
SHERPAPublisher pub = publishers.get(0);
List sherpaList = div.addList("sherpaList" + (i + 1), "simple", "sherpaList");
sherpaList
.addItem()
.addFigure(
contextPath + "/static/images/" + (i == 0 ? "romeosmall" : "clear") + ".gif",
"http://www.sherpa.ac.uk/romeo/",
"sherpaLogo");
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_journal);
sherpaList.addItem(journ.getTitle() + " (" + journ.getIssn() + ")");
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_publisher);
sherpaList.addItemXref(pub.getHomeurl(), pub.getName());
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_colour);
sherpaList
.addItem()
.addHighlight("sherpaStyle " + pub.getRomeocolour())
.addContent(message("xmlui.aspect.sherpa.submission." + pub.getRomeocolour()));
sherpaList
.addItem()
.addXref(
"http://www.sherpa.ac.uk/romeo/search.php?issn=" + journ.getIssn(),
T_sherpa_more,
"sherpaMoreInfo");
i = i + 1;
}
}
}
List sherpaList = div.addList("sherpaListEnd", "simple", "sherpaList");
sherpaList.addItem(T_sherpa_consult);
}
}
}
public void addBody(Body body)
throws SAXException, WingException, UIException, SQLException, IOException,
AuthorizeException {
// If we are actually editing information of an uploaded file,
// then display that body instead!
if (this.editFile != null) {
editFile.addBody(body);
return;
}
// Get a list of all files in the original bundle
Item item = submission.getItem();
Collection collection = submission.getCollection();
String actionURL =
contextPath + "/handle/" + collection.getHandle() + "/submit/" + knot.getId() + ".continue";
boolean disableFileEditing =
(submissionInfo.isInWorkflow())
&& !ConfigurationManager.getBooleanProperty("workflow", "reviewer.file-edit");
Bundle[] bundles = item.getBundles("ORIGINAL");
Bitstream[] bitstreams = new Bitstream[0];
if (bundles.length > 0) {
bitstreams = bundles[0].getBitstreams();
}
// Part A:
// First ask the user if they would like to upload a new file (may be the first one)
Division div =
body.addInteractiveDivision(
"submit-upload", actionURL, Division.METHOD_MULTIPART, "primary submission");
div.setHead(T_submission_head);
addSubmissionProgressList(div);
List upload = null;
if (!disableFileEditing) {
// Only add the upload capabilities for new item submissions
upload = div.addList("submit-upload-new", List.TYPE_FORM);
upload.setHead(T_head);
addRioxxVersionSection(upload, item);
File file = upload.addItem().addFile("file");
file.setLabel(T_file);
file.setHelp(T_file_help);
file.setRequired();
// if no files found error was thrown by processing class, display it!
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_NO_FILES_ERROR) {
file.addError(T_file_error);
}
// if an upload error was thrown by processing class, display it!
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_UPLOAD_ERROR) {
file.addError(T_upload_error);
}
// if virus checking was attempted and failed in error then let the user know
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_VIRUS_CHECKER_UNAVAILABLE) {
file.addError(T_virus_checker_error);
}
// if virus checking was attempted and a virus found then let the user know
if (this.errorFlag == org.dspace.submit.step.UploadStep.STATUS_CONTAINS_VIRUS) {
file.addError(T_virus_error);
}
Text description = upload.addItem().addText("description");
description.setLabel(T_description);
description.setHelp(T_description_help);
Button uploadSubmit = upload.addItem().addButton("submit_upload");
uploadSubmit.setValue(T_submit_upload);
}
make_sherpaRomeo_submission(item, div);
// Part B:
// If the user has already uploaded files provide a list for the user.
if (bitstreams.length > 0 || disableFileEditing) {
Table summary = div.addTable("submit-upload-summary", (bitstreams.length * 2) + 2, 7);
summary.setHead(T_head2);
Row header = summary.addRow(Row.ROLE_HEADER);
header.addCellContent(T_column0); // primary bitstream
header.addCellContent(T_column1); // select checkbox
header.addCellContent(T_column2); // file name
header.addCellContent(T_column3); // size
header.addCellContent(T_column4); // description
header.addCellContent(T_column5); // format
header.addCellContent(T_column6); // edit button
for (Bitstream bitstream : bitstreams) {
int id = bitstream.getID();
String name = bitstream.getName();
String url = makeBitstreamLink(item, bitstream);
long bytes = bitstream.getSize();
String desc = bitstream.getDescription();
String algorithm = bitstream.getChecksumAlgorithm();
String checksum = bitstream.getChecksum();
Row row = summary.addRow();
// Add radio-button to select this as the primary bitstream
Radio primary = row.addCell().addRadio("primary_bitstream_id");
primary.addOption(String.valueOf(id));
// If this bitstream is already marked as the primary bitstream
// mark it as such.
if (bundles[0].getPrimaryBitstreamID() == id) {
primary.setOptionSelected(String.valueOf(id));
}
if (!disableFileEditing) {
// Workflow users can not remove files.
CheckBox remove = row.addCell().addCheckBox("remove");
remove.setLabel("remove");
remove.addOption(id);
} else {
row.addCell();
}
row.addCell().addXref(url, name);
row.addCellContent(bytes + " bytes");
if (desc == null || desc.length() == 0) {
row.addCellContent(T_unknown_name);
} else {
row.addCellContent(desc);
}
BitstreamFormat format = bitstream.getFormat();
if (format == null) {
row.addCellContent(T_unknown_format);
} else {
int support = format.getSupportLevel();
Cell cell = row.addCell();
cell.addContent(format.getMIMEType());
cell.addContent(" ");
switch (support) {
case 1:
cell.addContent(T_supported);
break;
case 2:
cell.addContent(T_known);
break;
case 3:
cell.addContent(T_unsupported);
break;
}
}
Button edit = row.addCell().addButton("submit_edit_" + id);
edit.setValue(T_submit_edit);
Row checksumRow = summary.addRow();
checksumRow.addCell();
Cell checksumCell = checksumRow.addCell(null, null, 0, 6, null);
checksumCell.addHighlight("bold").addContent(T_checksum);
checksumCell.addContent(" ");
checksumCell.addContent(algorithm + ":" + checksum);
}
if (!disableFileEditing) {
// Workflow users can not remove files.
Row actionRow = summary.addRow();
actionRow.addCell();
Button removeSeleceted =
actionRow.addCell(null, null, 0, 6, null).addButton("submit_remove_selected");
removeSeleceted.setValue(T_submit_remove);
}
upload = div.addList("submit-upload-new-part2", List.TYPE_FORM);
}
// Part C:
// add standard control/paging buttons
addControlButtons(upload);
}
