|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--kolibribeans.QueryContainer
Title: Description: Copyright: Copyright (c) 2001 Company:
Field Summary | |
static int |
PRIORITY_HIGH
|
static int |
PRIORITY_LOW
|
static int |
PRIORITY_NORMAL
|
static int |
VISIBILITY_CONFIDENTIAL
|
static int |
VISIBILITY_PRIVATE
|
static int |
VISIBILITY_PUBLIC
|
static int |
VISIBILITY_RESERVABLE_TIME
|
Constructor Summary | |
QueryContainer()
|
|
QueryContainer(java.util.Calendar date,
java.lang.String http_referer)
|
Method Summary | |
static RS2 |
checkPrivateGroupParticipation(int personID)
Helps to check whether a user belongs to a so called private group. |
static RS2 |
checkRequestedGroup(int personID)
Helps to check whether person has right to view requested group data. |
static boolean |
checkRequestedGroup(int personID,
int groupID)
Helps to check whether person has right to view requested group data. |
static RS2 |
checkSpaceExistence()
Deprecated. Why this did not return code and spaceid of wanted space? |
static java.lang.String[] |
checkSpaceExistence(java.lang.String code)
Deprecated. Why this did not return code and spaceid of wanted space? |
static boolean |
checkTeacher(java.lang.String eventID,
int personID)
|
static void |
deleteEvent(java.lang.String eventID)
Deletes an event from DB, i.e. sets event.deleted=false. |
RS2 |
getAllGroupMembersEvents(Group group,
int languageID)
Gets all events of group. |
RS2 |
getAllGroupMembersEvents(Group group,
User user)
Gets all events of group. |
static RS2 |
getBookableEvents(int personid,
java.util.Calendar begindate)
Returns persons both booked and unbooked events. |
java.util.Calendar |
getDate()
Getter method for particular month used in restriction. |
static RS2 |
getEventData(int personID,
java.lang.String oeventID)
Retrieves person's general event data. |
static RS2 |
getEventFieldsIntoForm(java.lang.String eventID,
int languageID)
Retrieves event-related data that is to be publish on a form. |
static java.lang.String |
getEventGroupName(java.lang.String groupID)
|
static RS2 |
getEventsForMonth(java.util.Calendar cal,
int personID)
Gets begintimes for a person's events from a months period. |
static RS2 |
getEventsTimes(java.lang.String eventID)
Retrieves begin and end times for a certain event. |
static RS2 |
getGroup(int groupID)
Gets colums representing given group. |
static java.util.ArrayList |
getGroupMembersInArrayList(int groupID)
Returns groups members in ArrayList. |
static java.lang.String |
getGroupName(java.lang.String eventID)
Retrieves the name of the event group for requested event. |
static java.util.ArrayList |
getGroupsAllParentGroups(int groupID)
Returns recursively groupIDs of all parentGroups of given group. |
static RS2 |
getGroupsMembers(Group group,
User user)
Gets all members of single group and its subgroups. |
static RS2 |
getGroupsMembers(int[] groupID,
User user)
Gets all persons that are members of multiple groups. |
static RS2 |
getGroupsMembers(int[] groupID,
User user,
java.lang.String[] nonMembers)
|
static RS2 |
getGroupsMembers(int groupID,
User user)
Gets members of single group. |
static RS2 |
getGroupsSubGroups(int groupID)
Returns Groups subgroups. |
static RS2 |
getGroupsSubGroups(int groupID,
Group notAllowed)
Returns Groups subgroups. |
static RS2 |
getGroupsSubGroups(int groupID,
int[] notAllowedSubGroups)
Returns Groups subgroups. |
static java.util.ArrayList |
getGroupsSubGroupsInArrayList(int groupID)
returns groups subgroups of group in ArrayList. |
static RS2 |
getNotesForEvent(java.lang.String eventID)
Retrieves all notes for specified event. |
static RS2 |
getPersonsAllowedGroups(User user)
Return groups to wich user has rights, |
static RS2 |
getPriorityValues(int languageID)
Retrieves all possible priority values. |
java.lang.String |
getReferer()
Getter method for http_referer attribute. |
static RS2 |
getRepeatedEvents(java.lang.String eventID)
Retrieves all the instances of a single repeating event. |
boolean |
getRestrictQuery()
Getter method for RestrictedQuery option. |
boolean |
getShowUnbooked()
Get method for showUnbooked attribute. |
RS2 |
getSpacesEvents(int spaceID,
int languageID,
int priority,
java.lang.String info)
Gets all events of space. |
static java.util.ArrayList |
getSubGroupMembers(int groupID)
Returns subgroup members of group in ArrayList. |
static RS2 |
getSubGroupsForGroups(java.lang.String nameToSearch)
Returns subgroups. |
static RS2 |
getUserForGroup(int userID,
User user)
Gets persons to be added to group. |
RS2 |
getUsersEvents(int personID,
int languageID)
Returns events of single person. |
RS2 |
getUsersEvents(int personID,
int languageID,
int priority)
|
RS2 |
getUsersEvents(int personID,
int languageID,
int priority,
java.lang.String info)
Returns events of single person with given priority. |
RS2 |
getUsersEvents(User user)
Returns events of single person. |
RS2 |
getUsersEvents(User user,
java.lang.String info)
|
static RS2 |
getUsersForGroup(java.lang.String nameToSearch,
User user)
Returns persons to be added to group. |
static RS2 |
getUsersForGroup(java.lang.String nameToSearch,
User user,
int department,
int course)
Returns persons to be added to group. |
static RS2 |
getVisibilityValues(int languageID)
Retrieves all possible visibility values. |
static void |
insertEvent(int nextEID,
java.lang.String groupID,
java.lang.String startTimeStamp,
java.lang.String endTimeStamp,
java.lang.String sVisibility,
java.lang.String sPriority,
java.lang.String sDescription,
java.lang.String sComment)
Inserts an event into DB. |
static void |
insertEvent(int nextEID,
java.lang.String groupID,
java.lang.String startTimeStamp,
java.lang.String endTimeStamp,
java.lang.String sVisibility,
java.lang.String sPriority,
java.lang.String sDescription,
java.lang.String sComment,
int inheritedFrom)
|
static void |
insertEventSpace(int nextEID,
int nextSID)
Inserts an EventSpace-relation into DB. |
static void |
insertIntoPrivateGroup(int nextEGID,
java.lang.String names,
int nextGPID,
int personID)
Inserts a user into a so called private group. |
static void |
insertNote(int nextID,
java.lang.String eventID,
int personID,
java.lang.String sTitle,
java.lang.String sMsg)
Inserts a note into DB. |
static void |
insertSpace(int nextSID,
java.lang.String sLocation)
Inserts a new space into DB. |
static boolean |
isAllowedToModify(java.lang.String personid,
java.lang.String eventid)
The method tells if teh user has right to modify event's details. |
static boolean |
isValidGroupName(java.lang.String name,
int groupID)
Checks if given string is valid name for group. |
static java.lang.String |
numberOfArrayListToString(java.util.ArrayList list)
Cobines Stringvalues in arraylist to one string that can be used in "IN-clause" of query. |
void |
setDate(java.util.Calendar date)
Setter method for particular month used in restriction. |
void |
setReferer(java.lang.String referer)
Setter method for http_referer attribute. |
void |
setRestrictQuery(boolean restrictQuery)
Setter method for RestrictedQuery option. |
void |
setShowUnbooked(boolean show)
Set method for showUnbooked attribute. |
static void |
updateEvent(java.lang.String startTimeStamp,
java.lang.String endTimeStamp,
java.lang.String sVisibility,
java.lang.String sPriority,
java.lang.String sDescription,
java.lang.String eventID,
java.lang.String sComment)
Updates an event. |
static void |
updateEventSpace(java.lang.String eventID,
int nextSID)
Updates table called EventSpace. |
static void |
updateHoursAndRest(java.lang.String startHour,
java.lang.String endHour,
java.lang.String visibilityid,
java.lang.String priorityid,
java.lang.String description,
java.lang.String comment,
java.lang.String events)
starthour and endhour represented as timestamp and catenated to existing time stamp. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static int VISIBILITY_PUBLIC
public static int VISIBILITY_PRIVATE
public static int VISIBILITY_CONFIDENTIAL
public static int VISIBILITY_RESERVABLE_TIME
public static int PRIORITY_LOW
public static int PRIORITY_NORMAL
public static int PRIORITY_HIGH
Constructor Detail |
public QueryContainer()
public QueryContainer(java.util.Calendar date, java.lang.String http_referer)
Method Detail |
public void setRestrictQuery(boolean restrictQuery)
public boolean getRestrictQuery()
public void setDate(java.util.Calendar date)
date
- date in month to be used.public java.util.Calendar getDate()
public void setReferer(java.lang.String referer)
public java.lang.String getReferer()
public void setShowUnbooked(boolean show)
public boolean getShowUnbooked()
public RS2 getAllGroupMembersEvents(Group group, int languageID) throws java.lang.Exception
group
- Group whose events are wanted.languageID
- Language to use in translations.
java.lang.Exception
public RS2 getAllGroupMembersEvents(Group group, User user) throws java.lang.Exception
group
- Group whose events are wanted.user
- User whose language is used in translations.
java.lang.Exception
public RS2 getUsersEvents(int personID, int languageID) throws java.lang.Exception
languageID
- language to use in translations.
java.lang.Exception
public RS2 getUsersEvents(int personID, int languageID, int priority, java.lang.String info) throws java.lang.Exception
languageID
- language to use in translations.priority
- Get events with given priority.
java.lang.Exception
public RS2 getUsersEvents(int personID, int languageID, int priority) throws java.lang.Exception
java.lang.Exception
public RS2 getUsersEvents(User user) throws java.lang.Exception
user
- Person whose events are wanted.
java.lang.Exception
public RS2 getUsersEvents(User user, java.lang.String info) throws java.lang.Exception
java.lang.Exception
public static RS2 getUsersForGroup(java.lang.String nameToSearch, User user) throws java.lang.Exception
nameToSearch
- Name to be used is search.user
- User whose language is used in translations.
java.lang.Exception
public static RS2 getUsersForGroup(java.lang.String nameToSearch, User user, int department, int course) throws java.lang.Exception
nameToSearch
- Name to be used is search.user
- User whose language is used in translations.department
- DepartmentID of searched users. (Persons home organisation must be this)course
- CourseID of searched person. (Person must be on this course)
java.lang.Exception
public static RS2 getPersonsAllowedGroups(User user) throws java.lang.Exception
user
- User whose groups are searched.
java.lang.Exception
public static RS2 getSubGroupsForGroups(java.lang.String nameToSearch) throws java.lang.Exception
nameToSearch
- Name to search group.
java.lang.Exception
public static RS2 getGroupsSubGroups(int groupID) throws java.lang.Exception
groupID
- ID of group.
Exception.
java.lang.Exception
public static RS2 getGroupsSubGroups(int groupID, int[] notAllowedSubGroups) throws java.lang.Exception
groupID
- ID of group.notAllowedSubGroups
- Array of values that are not allowed as subgroups.
java.lang.Exception
- if something goes wrong.public static RS2 getGroupsSubGroups(int groupID, Group notAllowed) throws java.lang.Exception
groupID
- ID of group.
java.lang.Exception
- if something goes wrong.public static RS2 getGroupsMembers(int[] groupID, User user) throws java.lang.Exception
groupID
- Array of values that represent groupids.user
- User whose language is used in translations.
java.lang.Exception
public static RS2 getGroupsMembers(int[] groupID, User user, java.lang.String[] nonMembers) throws java.lang.Exception
java.lang.Exception
public static RS2 getGroupsMembers(int groupID, User user) throws java.lang.Exception
groupID
- value that represent groupID.user
- User whose language is used in translations.
java.lang.Exception
public static RS2 getGroupsMembers(Group group, User user) throws java.lang.Exception
group
- Group which members are wanted.user
- User whose language is used in translations.
java.lang.Exception
public static RS2 getGroup(int groupID) throws java.lang.Exception
groupID
- ID of group
java.lang.Exception
public static boolean isValidGroupName(java.lang.String name, int groupID) throws java.lang.Exception
name
- String to check
java.lang.Exception
public static RS2 getUserForGroup(int userID, User user) throws java.lang.Exception
userID
- ID of wanted user.user
- User whose language is used in translations.
java.lang.Exception
public static RS2 getEventsForMonth(java.util.Calendar cal, int personID) throws java.lang.Exception
cal
- month preferred to be queried.personID
- person's ID.
java.lang.Exception
public static RS2 getEventData(int personID, java.lang.String oeventID) throws java.lang.Exception
personID
- person's ID.
java.lang.Exception
- when something's gone wrong.public static RS2 checkRequestedGroup(int personID) throws java.lang.Exception
personID
- person's ID.
java.lang.Exception
- when something's gone wrong.public static boolean checkRequestedGroup(int personID, int groupID) throws java.lang.Exception
personID
- person's ID.
java.lang.Exception
- when something's gone wrong.public static RS2 getEventFieldsIntoForm(java.lang.String eventID, int languageID) throws java.lang.Exception
eventID
- event's ID.languageID
- preferred language.
java.lang.Exception
public static RS2 getVisibilityValues(int languageID) throws java.lang.Exception
languageID
- preferred language.
java.lang.Exception
- when something's gone wrong.public static RS2 getPriorityValues(int languageID) throws java.lang.Exception
languageID
- preferred language.
java.lang.Exception
- when something's gone wrong.public static RS2 getNotesForEvent(java.lang.String eventID) throws java.lang.Exception
java.lang.Exception
- when something's gone wrong.public static void insertNote(int nextID, java.lang.String eventID, int personID, java.lang.String sTitle, java.lang.String sMsg) throws java.lang.Exception
java.lang.Exception
- when something's gone wrong.public static RS2 checkPrivateGroupParticipation(int personID) throws java.lang.Exception
java.lang.Exception
- when something's gone wrong.public static void insertIntoPrivateGroup(int nextEGID, java.lang.String names, int nextGPID, int personID) throws java.lang.Exception
nextEGID
- next available primary key value.names
- user's names.nextGPID
- next available primary key value.
java.lang.Exception
- when something's gone wrong.public static java.lang.String[] checkSpaceExistence(java.lang.String code) throws java.lang.Exception
java.lang.Exception
- when something's gone wrong.checkSpaceExistence(String)
public static RS2 checkSpaceExistence() throws java.lang.Exception
java.lang.Exception
- when something's gone wrong.checkSpaceExistence(String)
public static void updateEvent(java.lang.String startTimeStamp, java.lang.String endTimeStamp, java.lang.String sVisibility, java.lang.String sPriority, java.lang.String sDescription, java.lang.String eventID, java.lang.String sComment) throws java.lang.Exception
eventID
- primary key for the event being updated.
java.lang.Exception
- when something's gone wrong.public static void updateHoursAndRest(java.lang.String startHour, java.lang.String endHour, java.lang.String visibilityid, java.lang.String priorityid, java.lang.String description, java.lang.String comment, java.lang.String events) throws java.lang.Exception
java.lang.Exception
public static void insertSpace(int nextSID, java.lang.String sLocation) throws java.lang.Exception
nextSID
- next available primary key value.sLocation
- name of the space to be added.
java.lang.Exception
- when something's gone wrong.public static void updateEventSpace(java.lang.String eventID, int nextSID) throws java.lang.Exception
eventID
- foreign key value(s).nextSID
- foreign key value.
java.lang.Exception
- when something's gone wrong.public static void insertEvent(int nextEID, java.lang.String groupID, java.lang.String startTimeStamp, java.lang.String endTimeStamp, java.lang.String sVisibility, java.lang.String sPriority, java.lang.String sDescription, java.lang.String sComment) throws java.lang.Exception
nextEID
- next available primary key value.groupID
- foreign key value.
java.lang.Exception
- when something's gone wrong.public static void insertEvent(int nextEID, java.lang.String groupID, java.lang.String startTimeStamp, java.lang.String endTimeStamp, java.lang.String sVisibility, java.lang.String sPriority, java.lang.String sDescription, java.lang.String sComment, int inheritedFrom) throws java.lang.Exception
java.lang.Exception
public static void insertEventSpace(int nextEID, int nextSID) throws java.lang.Exception
nextEID
- foreign key value.nextSID
- foreign key value.
java.lang.Exception
- when something's gone wrong.public static void deleteEvent(java.lang.String eventID) throws java.lang.Exception
eventID
- primary key value.
java.lang.Exception
- when something's gone wrong.public static RS2 getRepeatedEvents(java.lang.String eventID) throws java.lang.Exception
eventID
- primary key value.
java.lang.Exception
- when something's gone wrong.public static RS2 getEventsTimes(java.lang.String eventID) throws java.lang.Exception
java.lang.Exception
public static java.lang.String getGroupName(java.lang.String eventID) throws java.lang.Exception
java.lang.Exception
public static java.util.ArrayList getGroupsAllParentGroups(int groupID) throws java.lang.Exception
groupID
- ID of given group
java.lang.Exception
- thrown on error.public static java.util.ArrayList getGroupsSubGroupsInArrayList(int groupID) throws java.lang.Exception
groupID
- Id of group.
java.lang.Exception
public static java.lang.String numberOfArrayListToString(java.util.ArrayList list)
list
- ArrayList to be changed.
public static java.util.ArrayList getSubGroupMembers(int groupID) throws java.lang.Exception
groupID
- Group whose members are wanted.
java.lang.Exception
public static java.util.ArrayList getGroupMembersInArrayList(int groupID) throws java.lang.Exception
groupID
- Group whose members are wanted.
java.lang.Exception
public static java.lang.String getEventGroupName(java.lang.String groupID) throws java.lang.Exception
java.lang.Exception
public static boolean checkTeacher(java.lang.String eventID, int personID) throws java.lang.Exception
java.lang.Exception
public static RS2 getBookableEvents(int personid, java.util.Calendar begindate) throws java.lang.Exception
personid
- The person whose events we want
java.lang.Exception
public static boolean isAllowedToModify(java.lang.String personid, java.lang.String eventid)
public RS2 getSpacesEvents(int spaceID, int languageID, int priority, java.lang.String info) throws java.lang.Exception
spaceID
- Space which events are wanted.languageID
- Language to use in translations.
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |