package se.idega.idegaweb.commune.childcare.business;
import java.rmi.RemoteException;
import java.sql.Date;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import java.util.Locale;
import java.util.Vector;
import javax.ejb.CreateException;
import javax.ejb.FinderException;
import javax.ejb.RemoveException;
import javax.transaction.SystemException;
import javax.transaction.UserTransaction;
import se.idega.idegaweb.commune.business.Constants;
import se.idega.idegaweb.commune.care.business.CareBusiness;
import se.idega.idegaweb.commune.care.business.PlacementHelper;
import se.idega.idegaweb.commune.care.data.AfterSchoolChoice;
import se.idega.idegaweb.commune.care.data.AfterSchoolChoiceHome;
import se.idega.idegaweb.commune.care.data.ChildCareApplication;
import se.idega.idegaweb.commune.childcare.data.AfterSchoolCareDays;
import se.idega.idegaweb.commune.childcare.data.AfterSchoolCareDaysHome;
import se.idega.idegaweb.commune.message.data.PrintedLetterMessage;
import se.idega.idegaweb.commune.message.data.PrintedLetterMessageHome;
import se.idega.idegaweb.commune.school.business.SchoolChoiceBusiness;
import com.idega.block.process.business.CaseBusiness;
import com.idega.block.process.business.CaseBusinessBean;
import com.idega.block.process.data.Case;
import com.idega.block.process.data.CaseStatus;
import com.idega.block.school.business.SchoolBusiness;
import com.idega.block.school.data.School;
import com.idega.block.school.data.SchoolCategory;
import com.idega.block.school.data.SchoolClass;
import com.idega.block.school.data.SchoolSeason;
import com.idega.block.school.data.SchoolType;
import com.idega.business.IBOLookup;
import com.idega.business.IBOLookupException;
import com.idega.business.IBORuntimeException;
import com.idega.core.file.data.ICFile;
import com.idega.data.IDOCreateException;
import com.idega.data.IDOException;
import com.idega.data.IDOLookup;
import com.idega.data.IDOLookupException;
import com.idega.data.IDORelationshipException;
import com.idega.data.IDOStoreException;
import com.idega.user.data.User;
import com.idega.util.IWTimestamp;
/**
* AfterSchoolBusinessBean
*
* @author aron
* @version 1.0
*/
public class AfterSchoolBusinessBean extends CaseBusinessBean implements CaseBusiness, AfterSchoolBusiness {
public String getBundleIdentifier() {
return Constants.IW_BUNDLE_IDENTIFIER;
}
private AfterSchoolChoiceHome getAfterSchoolChoiceHome() {
try {
return (AfterSchoolChoiceHome) IDOLookup.getHome(AfterSchoolChoice.class);
}
catch (IDOLookupException e) {
throw new IBORuntimeException(e.getMessage());
}
}
private AfterSchoolCareDaysHome getAfterSchoolCareDaysHome() {
try {
return (AfterSchoolCareDaysHome) IDOLookup.getHome(AfterSchoolCareDays.class);
}
catch (IDOLookupException e) {
throw new IBORuntimeException(e.getMessage());
}
}
public int getNumberOfApplications(SchoolSeason season) {
try {
String[] statuses = { getCaseStatusPreliminary().getStatus(), getCaseStatusReady().getStatus() };
return getAfterSchoolChoiceHome().getChoiceStatistics(season, statuses);
}
catch (IDOException ie) {
ie.printStackTrace();
return 0;
}
}
public AfterSchoolChoice getAfterSchoolChoice(Object afterSchoolChoiceID) throws FinderException {
return getAfterSchoolChoiceHome().findByPrimaryKey(afterSchoolChoiceID);
}
public Collection findChoicesByProvider(int providerID) {
try {
String[] caseStatus = { getCaseStatusInactive().getStatus(), getCaseStatusCancelled().getStatus(),
getCaseStatusDenied().getStatus(), getCaseStatusReady().getStatus(), getCaseStatusDeleted().getStatus() };
return getAfterSchoolChoiceHome().findAllCasesByProviderAndNotInStatus(providerID, caseStatus);
}
catch (FinderException e) {
return new ArrayList();
}
}
public Collection findChoicesByProvider(int providerID, String sorting) {
try {
String[] caseStatus = { getCaseStatusInactive().getStatus(), getCaseStatusCancelled().getStatus(),
getCaseStatusDenied().getStatus(), getCaseStatusReady().getStatus(), getCaseStatusDeleted().getStatus() };
return getAfterSchoolChoiceHome().findAllCasesByProviderAndNotInStatus(providerID, caseStatus, sorting);
}
catch (FinderException e) {
return new ArrayList();
}
}
public AfterSchoolChoice findChoicesByChildAndChoiceNumberAndSeason(Integer childID, int choiceNumber,
Integer seasonID) throws FinderException {
String[] caseStatus = { getCaseStatusPreliminary().getStatus(), getCaseStatusInactive().getStatus() };
return getAfterSchoolChoiceHome().findByChildAndChoiceNumberAndSeason(childID, new Integer(choiceNumber), seasonID,
caseStatus);
}
public Collection getOngoingAndNextSeasons(){
Collection currentAndNextSeasons = new LinkedList();
try {
SchoolSeason ongoingSeason= getCareBusiness().getSchoolSeasonHome().findSeasonByDate(getChildCareBusiness().getSchoolBusiness().getCategoryElementarySchool(), new IWTimestamp().getDate());
SchoolCategory category = getSchoolBusiness().getCategoryElementarySchool();
Collection allSeasons = getSchoolBusiness().findAllSchoolSeasons(category);
if (!allSeasons.isEmpty()) {
Iterator iter = allSeasons.iterator();
while (iter.hasNext()) {
SchoolSeason season = (SchoolSeason) iter.next();
if (! season.getSchoolSeasonStart().before(ongoingSeason.getSchoolSeasonStart())) {
currentAndNextSeasons.add(season);
}
}
}
}
catch (RemoteException e) {
e.printStackTrace();
}
catch (FinderException e) {
e.printStackTrace();
}
return currentAndNextSeasons;
}
public boolean hasOpenApplication(User child, SchoolSeason season, int choiceNumber) {
String[] caseStatus = { getCaseStatusReady().getStatus(), getCaseStatusContract().getStatus(), getCaseStatusGranted().getStatus() };
try{
getAfterSchoolChoiceHome().findByChildAndChoiceNumberAndSeason((Integer) child.getPrimaryKey(), new Integer(choiceNumber), (Integer) season.getPrimaryKey(), caseStatus);
return false;
}
catch (FinderException fe) {
return true;
}
}
public boolean hasCancelledApplication(User child, SchoolSeason season) {
String[] caseStatus = { getCaseStatusCancelled().getStatus() };
try{
getAfterSchoolChoiceHome().findByChildAndChoiceNumberAndSeason((Integer) child.getPrimaryKey(), new Integer(1), (Integer) season.getPrimaryKey(), caseStatus);
return false;
}
catch (FinderException fe) {
return true;
}
}
public AfterSchoolChoice findChoiceByChild(User child, SchoolSeason season, int choiceNumber) throws FinderException {
String[] caseStatus = { getCaseStatusPreliminary().getStatus(), getCaseStatusReady().getStatus(), getCaseStatusContract().getStatus(), getCaseStatusOpen().getStatus(), getCaseStatusGranted().getStatus(), getCaseStatusInactive().getStatus() };
return getAfterSchoolChoiceHome().findByChildAndChoiceNumberAndSeason(new Integer(child.getPrimaryKey().toString()), new Integer(choiceNumber), new Integer(season.getPrimaryKey().toString()), caseStatus);
}
public boolean acceptAfterSchoolChoice(Object afterSchoolChoiceID, User performer) {
AfterSchoolChoice choice = null;
try {
choice = getAfterSchoolChoice(afterSchoolChoiceID);
}
catch (FinderException fe) {
return false;
}
changeCaseStatus(choice, getCaseStatusGranted().getStatus(), performer);
return true;
}
public boolean denyAfterSchoolChoice(Object afterSchoolChoiceID, User performer) {
UserTransaction transaction = getSessionContext().getUserTransaction();
try {
transaction.begin();
AfterSchoolChoice choice = getAfterSchoolChoice(afterSchoolChoiceID);
changeCaseStatus(choice, getCaseStatusDenied().getStatus(), performer);
Iterator children = choice.getChildrenIterator();
if (children != null) {
while (children.hasNext()) {
choice = (AfterSchoolChoice) children.next();
changeCaseStatus(choice, getCaseStatusPreliminary().getStatus(), performer);
}
}
transaction.commit();
}
catch (Exception e) {
try {
transaction.rollback();
}
catch (SystemException se) {
throw new IBORuntimeException(se.getMessage());
}
throw new IBORuntimeException(e.getMessage());
}
return true;
}
public AfterSchoolChoice createAfterSchoolChoice(IWTimestamp stamp, User user, Integer childID, Integer providerID,
Integer choiceNumber, String message, CaseStatus caseStatus, Case parentCase, Date placementDate,
SchoolSeason season, boolean sendMessage, String subject, String body) throws CreateException, RemoteException {
return createAfterSchoolChoice(stamp, user, childID, providerID,
choiceNumber, message, caseStatus, parentCase, placementDate,
season, sendMessage, subject, body, false);
}
public AfterSchoolChoice createAfterSchoolChoice(IWTimestamp stamp, User user, Integer childID, Integer providerID,
Integer choiceNumber, String message, CaseStatus caseStatus, Case parentCase, Date placementDate,
SchoolSeason season, boolean sendMessage, String subject, String body, boolean isFClassAndPrio) throws CreateException, RemoteException {
if (season == null) {
try {
season = getChildCareBusiness().getCareBusiness().getCurrentSeason();
}
catch (FinderException fex) {
season = null;
}
}
AfterSchoolChoice choice = null;
if (season != null) {
try {
Integer seasonId = new Integer(season.getPrimaryKey().toString());
choice = findChoicesByChildAndChoiceNumberAndSeason(childID, choiceNumber.intValue(), seasonId);
}
catch (FinderException fex) {
choice = null;
}
}
if (choice == null) {
AfterSchoolChoiceHome home = this.getAfterSchoolChoiceHome();
choice = home.create();
}
choice.setOwner(user);
choice.setChildId(childID.intValue());
if (providerID != null) {
choice.setProviderId(providerID.intValue());
}
choice.setChoiceNumber(choiceNumber.intValue());
choice.setMessage(message);
if (season != null) {
Integer seasonId = new Integer(season.getPrimaryKey().toString());
choice.setSchoolSeasonId(seasonId.intValue());
}
if (placementDate != null) {
choice.setFromDate(placementDate);
}
choice.setQueueDate(stamp.getDate());
stamp.addSeconds(1 - choiceNumber.intValue());
choice.setCreated(stamp.getTimestamp());
choice.setCaseStatus(caseStatus);
choice.setApplicationStatus(getChildCareBusiness().getStatusSentIn());
choice.setHasPriority(true);
if (sendMessage) {
try {
if (stamp.isEarlierThan(getSchoolChoiceBusiness().getSchoolChoiceStartDate()) || (stamp.isLaterThan(getSchoolChoiceBusiness().getSchoolChoiceEndDate()))) {
String subjectP = getLocalizedString("After_school_care_request_subject", "After school care request");
String bodyP = getLocalizedString("After_school_care_request_body", "After school care request from {0}, {3}.");
if(choice.getChoiceNumber()==1) getChildCareBusiness().sendMessageToProvider(choice, subjectP, bodyP);
}
}
catch (RemoteException e) {
e.printStackTrace();
}
catch (FinderException e) {
e.printStackTrace();
}
}
if (caseStatus.equals(getCaseStatusPreliminary())) {
getChildCareBusiness().sendMessageToParents(choice, subject, body);
}
if (parentCase != null) {
choice.setParentCase(parentCase);
}
if(isFClassAndPrio){
choice.setFClass(true);
School provider = getChildCareBusiness().getSchoolBusiness().getSchool(providerID);
User applyingChild = getChildCareBusiness().getUserBusiness().getUser(childID);
SchoolChoiceBusiness scb = getSchoolChoiceBusiness();
if(scb.hasPriority(provider, choice.getOwner(), applyingChild)) {
choice.setHasQueuePriority(true);
}
}
try {
choice.store();
}
catch (IDOStoreException idos) {
idos.printStackTrace();
throw new IDOCreateException(idos);
}
return choice;
}
public List createAfterSchoolChoices(User user, Integer childId, Integer[] providerIDs, String message,
String[] placementDates, SchoolSeason season, String subject, String body) throws IDOCreateException {
return createAfterSchoolChoices(user, childId, providerIDs, message, placementDates, season, subject, body, false);
}
public List createAfterSchoolChoices(User user, Integer childId, Integer[] providerIDs, String message,
String[] placementDates, SchoolSeason season, String subject, String body, boolean isFClassAndPrio) throws IDOCreateException {
int caseCount = 3;
IWTimestamp stamp;
SchoolSeason computedSeason;
List returnList = new Vector(3);
javax.transaction.UserTransaction trans = this.getSessionContext().getUserTransaction();
try {
trans.begin();
CaseStatus first = super.getCaseStatusPreliminary();
CaseStatus other = super.getCaseStatusInactive();
CaseStatus status = null;
boolean firstIsFamilyFreetime = false;
AfterSchoolChoice choice = null;
IWTimestamp timeNow = new IWTimestamp();
for (int i = 0; i < caseCount; i++) {
if (providerIDs[i] != null && providerIDs[i].intValue() > 0) {
stamp = new IWTimestamp(placementDates[i]);
if (i == 0) {
status = first;
firstIsFamilyFreetime = isFamilyFreetime(providerIDs[i]);
}
else {
if (i == 1 && firstIsFamilyFreetime) {
status = first;
}
else {
status = other;
}
}
// get according season for the choice, if season is null
computedSeason = season;
if (computedSeason == null) {
// take requested placement date (stamp) and find according season for it
computedSeason = getCareBusiness().getSchoolSeasonHome().findSeasonByDate(
getChildCareBusiness().getSchoolBusiness().getCategoryElementarySchool(),
stamp.getDate());
}
choice = createAfterSchoolChoice(timeNow, user, childId, providerIDs[i], new Integer(i + 1), message, status,
choice, stamp.getDate(), computedSeason, true, subject, body, isFClassAndPrio);
returnList.add(choice);
}
}
trans.commit();
return returnList;
}
catch (Exception ex) {
try {
trans.rollback();
}
catch (javax.transaction.SystemException e) {
throw new IDOCreateException(e.getMessage());
}
ex.printStackTrace();
throw new IDOCreateException(ex);
}
}
private boolean isFamilyFreetime(Integer providerID) {
try {
School provider = getChildCareBusiness().getSchoolBusiness().getSchool(providerID);
Collection types = provider.findRelatedSchoolTypes();
Iterator iter = types.iterator();
while (iter.hasNext()) {
SchoolType element = (SchoolType) iter.next();
if (element.getIsFamilyFreetimeType()) {
return true;
}
}
}
catch (RemoteException re) {
log(re);
}
catch (IDORelationshipException ire) {
log(ire);
}
return false;
}
public Collection createContractsForChildrenWithSchoolPlacement(int providerId, User user, Locale locale, int seasonId) throws RemoteException {
Collection users = new ArrayList();
Collection applications = findChoicesByProvider(providerId, "c.QUEUE_DATE");
Iterator iter = applications.iterator();
while (iter.hasNext()) {
AfterSchoolChoice application = (AfterSchoolChoice) iter.next(); //AfterSchoolChoice extends ChildCareApplication
boolean hasSchoolPlacement = false;
try {
hasSchoolPlacement = getChildCareBusiness().getSchoolBusiness().hasActivePlacement(application.getChildId(), providerId,
getChildCareBusiness().getSchoolBusiness().getCategoryElementarySchool());
}
catch (RemoteException e) {
}
if (hasSchoolPlacement && (application.getApplicationStatus() == getChildCareBusiness().getStatusSentIn())) {
if (seasonId != application.getSchoolSeasonId() ) {
continue;
}
Date date = application.getFromDate();
try {
PlacementHelper helper = getChildCareBusiness().getPlacementHelper((Integer) application.getPrimaryKey());
java.util.Date earliestDate = helper.getEarliestPlacementDate();
if (earliestDate != null) {
date = new Date(earliestDate.getTime());
}
}
catch (Exception e) {
log(e);
}
if (application.getFromDate() == null) {
continue;
}
else {
if (application.getFromDate().getTime() > date.getTime()) {
date = application.getFromDate();
}
}
if (date != null) {
application.setFromDate(date);
application.setHasDateSet(true);
application.store();
}
else {
continue;
}
ICFile contractFile = getChildCareBusiness().assignContractToApplication(((Integer) application.getPrimaryKey()).intValue(), -1, null, null, -1, user,
locale, true);
if (contractFile != null) {
try {
PrintedLetterMessage message = (PrintedLetterMessage) ((PrintedLetterMessageHome) IDOLookup.getHome(PrintedLetterMessage.class)).create();
message.setOwner(application.getOwner());
message.setParentCase(application);
message.setSubject(getLocalizedString("after_school_care_contract_pdf", "After school care contract"));
message.setBody("");
message.setMessageData(contractFile);
message.store();
getChildCareBusiness().getMessageBusiness().flagMessageAsPrinted(user, message);
}
catch (CreateException ce) {
ce.printStackTrace();
}
catch (IDOLookupException ile) {
ile.printStackTrace();
}
catch (RemoteException re) {
re.printStackTrace();
}
users.add(application.getChild());
}
}
}
return users;
}
public Collection getDays(AfterSchoolChoice choice) {
try {
return getAfterSchoolCareDaysHome().findAllByApplication(choice);
}
catch (FinderException fe) {
fe.printStackTrace();
return new ArrayList();
}
}
public AfterSchoolCareDays getDay(AfterSchoolChoice choice, int dayOfWeek) throws FinderException {
return getAfterSchoolCareDaysHome().findByApplicationAndDayOfWeek(choice, dayOfWeek);
}
public void storeDays(ChildCareApplication application, int[] dayOfWeek, String[] timeOfDeparture, boolean[] pickedUp) {
try {
try {
Collection days = getAfterSchoolCareDaysHome().findAllByApplication(application);
Iterator iter = days.iterator();
while (iter.hasNext()) {
AfterSchoolCareDays day = (AfterSchoolCareDays) iter.next();
try {
day.remove();
}
catch (RemoveException re) {
re.printStackTrace();
}
}
}
catch (FinderException fe) {
//Nothing found...
}
for (int a = 0; a < dayOfWeek.length; a++) {
if (timeOfDeparture[a] != null && timeOfDeparture[a].length() > 0) {
AfterSchoolCareDays days = getAfterSchoolCareDaysHome().create();
days.setApplication(application);
days.setDayOfWeek(dayOfWeek[a]);
days.setPickedUp(pickedUp[a]);
IWTimestamp stamp = new IWTimestamp(timeOfDeparture[a]);
stamp.setAsTime();
days.setTimeOfDeparture(stamp.getTime());
days.store();
}
}
}
catch (CreateException ce) {
ce.printStackTrace();
}
}
public SchoolClass getDefaultGroup(Object schoolPK, Object seasonPK) {
try {
School school = getChildCareBusiness().getSchoolBusiness().getSchool(schoolPK);
SchoolSeason season = getChildCareBusiness().getSchoolBusiness().getSchoolSeason(seasonPK);
return getDefaultGroup(school, season);
}
catch (RemoteException re) {
throw new IBORuntimeException(re);
}
}
public SchoolClass getDefaultGroup(School school, SchoolSeason season) {
try {
try {
Collection groups = getChildCareBusiness().getSchoolBusiness().getSchoolClassHome().findBySchoolAndSeason(school, season);
if (!groups.isEmpty()) {
Iterator iter = groups.iterator();
while (iter.hasNext()) {
return (SchoolClass) iter.next();
}
}
throw new FinderException();
}
catch (FinderException fe) {
try {
SchoolClass group = getChildCareBusiness().getSchoolBusiness().getSchoolClassHome().create();
group.setSchool(school);
group.setSchoolSeason(season);
group.setValid(true);
group.setSchoolClassName(season.getName());
group.store();
return group;
}
catch (CreateException ce) {
throw new IBORuntimeException(ce);
}
}
}
catch (RemoteException re) {
throw new IBORuntimeException(re);
}
}
public AfterSchoolChoice storeAfterSchoolCare(IWTimestamp stamp, User user, User child, School provider, String message, SchoolSeason season, int[] days, String[] timeOfDeparture, boolean[] pickedUp, String payerName, String payerPersonalID, String cardType, String cardNumber, int validMonth, int validYear) {
return storeAfterSchoolCare(stamp, user, child, provider, message, season, days, timeOfDeparture, pickedUp, false, payerName, payerPersonalID, cardType, cardNumber, validMonth, validYear);
}
public AfterSchoolChoice storeAfterSchoolCare(IWTimestamp stamp, User user, User child, School provider, String message, SchoolSeason season, int[] days, String[] timeOfDeparture, boolean[] pickedUp, boolean wantsRefreshments, String payerName, String payerPersonalID, String cardType, String cardNumber, int validMonth, int validYear) {
try {
String subject = getLocalizedString("application.after_school_choice_received_subject", "After school care choice received");
String body = getLocalizedString("application.after_school_choice_received_body", "{1} has received the application for an after school care placing for {0}, {2}. The application will be processed.");
AfterSchoolChoice choice = createAfterSchoolChoice(stamp, user, (Integer) child.getPrimaryKey(), (Integer) provider.getPrimaryKey(), new Integer(1), message, getCaseStatusPreliminary(), null, season.getSchoolSeasonStart(), season, false, subject, body);
choice.setPayerName(payerName);
choice.setPayerPersonalID(payerPersonalID);
choice.setCardType(cardType);
choice.setCardNumber(cardNumber);
choice.setCardValidMonth(validMonth);
choice.setCardValidYear(validYear);
choice.setWantsRefreshments(wantsRefreshments);
choice.store();
storeDays(choice, days, timeOfDeparture, pickedUp);
// returns false if storing failed else true
return choice;
}
catch (RemoteException re) {
throw new IBORuntimeException(re);
}
catch (CreateException ce) {
ce.printStackTrace();
return null;
}
}
public SchoolBusiness getSchoolBusiness() {
try {
return (SchoolBusiness) this.getServiceInstance(SchoolBusiness.class);
}
catch (RemoteException e) {
throw new IBORuntimeException(e.getMessage());
}
}
public SchoolChoiceBusiness getSchoolChoiceBusiness() {
try {
return (SchoolChoiceBusiness) this.getServiceInstance(SchoolChoiceBusiness.class);
}
catch (RemoteException e) {
throw new IBORuntimeException(e.getMessage());
}
}
public ChildCareBusiness getChildCareBusiness() {
try {
return (ChildCareBusiness) IBOLookup.getServiceInstance(getIWApplicationContext(), ChildCareBusiness.class);
}
catch (IBOLookupException e) {
throw new IBORuntimeException();
}
}
public CareBusiness getCareBusiness() {
try {
return (CareBusiness) IBOLookup.getServiceInstance(getIWApplicationContext(), CareBusiness.class);
}
catch (IBOLookupException e) {
throw new IBORuntimeException();
}
}
}