acceptProposition.jsp 0100774 0000061 0000310 00000037643 07475611231 015220 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: acceptProposition.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Page show's details of a proposed subject and offers
* posibility to accept the proposition to a subject.
* The user can send email to the proposer to ask more
* details about the proposition.
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 24.4.2002
* Variables canAccept and canUpdate tell if the user can
* maintain the details. If both are false, the user is
* redirected to error page (has no access to this page)
*
* 25.4.2002 M. Ylitalo
* Lines and Types are selected and keywords appear properly
****************************************************************************************************/
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("errorProposeAccept.jsp?origid=bad");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
int proposedBy = -1;
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%-- Access right --%>
<% police.setDB(db);
boolean canAccept = false;
boolean canUpdate = false;
if ( police.hasPersonRightOriginal(allowPropAccept, personID, origID) ||
police.hasGroupRight(allowPropAccept, userAccessLevel) ) {
canAccept = true;
canUpdate = true;
}
%>
select assignmentoriginal.proposedby as proposedby
from assignmentoriginal
where assignmentoriginal.deleted = false
and assignmentoriginal.originalid = <%=origID%>;
<%
{ proposedBy = Integer.parseInt((String)pageContext.getAttribute("proposedby"));
if (proposedBy == personID) canUpdate = true;
}
%>
<%
if ( !canAccept && !canUpdate ) { // if both are false then redirect
response.sendRedirect("assignmentOriginalInfo.jsp?origid="+origID);
return;
}
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<% time timeformater = new time(); %>
Aihe-ehdotuksen <% if (canAccept) { %> hyvksyminen ja <% } %> tietojen muuttaminen
<%--
Seuraavissa kentiss on aiheen ehdottajan syttmt arvot. Voit muuttaa annettuja
arvoja, joilloin pivitetyt tiedot tallennetaan kantaan.
--%>
<%
if (request.getParameter("info") != null) {
%>
Tiedot tallennettu
<% } %>
<%@ include file="/shared/pageEnd.inc" %>
acceptPropositionInsert.jsp 0100774 0100306 0000144 00000036331 07501633656 016221 0 ustar mmhilleb users <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: acceptPropositionInsert.jsp
* LANGUAGE: JSP
* DATE: 11.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Update values or insert some fields
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
* 17.5.2002 M.Ylitalo
* - Added sendmail to proposer
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
/* Check the parameters */
if (request.getParameter("origid") == null) {
response.sendRedirect("errorAcceptPropInsert.jsp?orig=bad");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
time timeformater = new time();
%>
<%-- Check the user --%>
<%
police.setDB(db);
boolean canAccept = false;
boolean canUpdate = false;
if ( police.hasPersonRightOriginal(allowPropAccept, personID, origID) ||
police.hasGroupRight(allowPropAccept, userAccessLevel) ) {
canAccept = true;
canUpdate = true;
}
%>
select assignmentoriginal.proposedby as proposedby
from assignmentoriginal
where assignmentoriginal.deleted = false
and assignmentoriginal.originalid = <%=origID%>;
<%
{ int proposedBy = Integer.parseInt((String)pageContext.getAttribute("proposedby"));
if (proposedBy == personID) canUpdate = true;
}
%>
<%
if ( !canAccept && !canUpdate ) { // if both are false then redirect
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<%-- ---end of user check---------------------------------------- --%>
<%-- parameter check -------------------------------------------- --%>
<%
String title;
if (request.getParameter("title") == null) title="";
else title = (String)request.getParameter("title");
String description;
if (request.getParameter("description") == null) description="";
else description = (String)request.getParameter("description");
if (request.getParameter("validuntil") == null || ((String)request.getParameter("validuntil")).equals("") ) {
response.sendRedirect("error.jsp?page=acceptPropositionInsert&message=1");
return;
}
String validuntil = timeformater.monthToDBFormat((String)request.getParameter("validuntil"));
if (request.getParameter("line") == null || request.getParameter("type") == null ) {
response.sendRedirect("error.jsp?page=acceptPropositionInsert&message=1");
return;
}
if ( request.getParameter("update") == null &&
request.getParameter("accept") == null &&
request.getParameter("email") == null &&
request.getParameter("fail") == null ) {
response.sendRedirect("error.jsp?page=acceptPropositionInsert&message=1");
return;
}
/* For now on we go on one phase at a time */
/* ======================================= */
if (request.getParameter("fail") != null) {
// pagecontext.forward
if ( request.getParameter("message") != null )
session.setAttribute("message", request.getParameter("message"));
else session.setAttribute("message", "\n");
response.sendRedirect("proposeConfirmRemove.jsp?origid="+origID);
return;
}
/* *************** EMail ************************************************************* */
if (request.getParameter("email") != null) {
String mailmessage = "";
%>
select person.callname as firstname,
person.lastname as lastname
from person
where person.personid = <%=personID%>
<%
try {
if ( mail.sendMail( "koppelo@mit.jyu.fi" ,(String)request.getParameter("to"),
"Viesti KOPPELO-jrjestelmst", "TM ON AUTOMAATTINEN VIESTI KOPPELO-JRJESTELMST \n\n"+
"Lhettj: "+(String)pageContext.getAttribute("firstname")+" "+(String)pageContext.getAttribute("lastname")+
", "+ (String)request.getParameter("sender") + "\n\n" +
(String)request.getParameter("message")+
"\n\nOtsikko: "+(String)request.getParameter("title")+"\n\nKuvaus: "+
(String)request.getParameter("description")) ) {
response.sendRedirect("sendMail.jsp?success=1"); return;
}
} catch (Exception e) {}
response.sendRedirect("sendMail.jsp?success=2"); return;
}
/* **************************** ACCEPT ************************************* */
if (request.getParameter("accept") != null) {
if (!canAccept) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
update assignmentoriginal
set acceptedby = <%=personID%>,
accepteddate = (select current_date),
available = 1
where assignmentoriginal.originalid = <%=origID%>;
<%
// Tss lhtee postia...
String name="";
%>
select person.callname as firstname,
person.lastname as lastname,
personparameter.personparametervalue as email
from personparameter, person
where personparameter.personparametertypeid = 3
and personparameter.personid = person.personid
and person.personid = <%=personID%>
<% if ( pageContext.getAttribute("firstname") != null)
name=(String)pageContext.getAttribute("firstname")+" "+ (String)pageContext.getAttribute("lastname");
%>
select distinct personparametervalue as address,
current_date as day
from personparameter
where personparameter.personparametertypeid = 3
and personparameter.personid = <%=pageContext.getAttribute("proposedby")%>
<% mail.sendMail( "koppelo@it.jyu.fi",(String)pageContext.getAttribute("address"), title,
"Aihe-ehdotuksesi "+title+" on hyvksytty aiheeksi\n\n"+
request.getParameter("message")+"\n\n"+
"Ksittelij: "+ name +", "+timeformater.monthToOutFormat((String)pageContext.getAttribute("day"))+
"\n"+(String)pageContext.getAttribute("email") ); %>
<%
response.sendRedirect("assignmentAttach.jsp?origid="+(String)request.getParameter("origid") );
return;
}
/* ******************************** UPDATE ********************************* */
if (request.getParameter("update") != null) {
if (!canUpdate) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%-- title --%>
update assdetailtranslation
set name = '<%=title%>'
where languageid = <%=languageID%> and
detailid = (
select assignmentdetail.detailid
from assignmentdetail
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assignmentdetail.detailid = assdetailtranslation.detailid
);
<%-- description --%>
update assdetailtranslation
set name = '<%=description%>'
where languageid = <%=languageID%> and
detailid = (
select assignmentdetail.detailid
from assignmentdetail
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=descriptionID%>
and assignmentdetail.detailid = assdetailtranslation.detailid
);
<%-- validuntil --%>
update assignmentoriginal
set validuntil = '<%=validuntil%>'
where originalid = <%=origID%>
<%-- keywords --%>
update assoriginalrelkeyword
set deleted = true
where originalid = <%=origID%>
<%
boolean success = false;
if ( request.getParameter("keywords") != null) {
int i=0;
int lkm=0;
int beg = 0;
int end = 0;
String [] keys = new String [100];
String key = request.getParameter("keywords");
while ( end < key.length() ) {
end = key.indexOf(",", beg);
if ( end < 0 ) end = key.length();
if (beg >= end ) break;
keys[i] = (key.substring(beg, end)).trim();
beg = end+1;
i++;
}
lkm = i;
for (i=0; i < lkm; i++) {
int keyid = 1;
success=false;
%>
select assignmentkeyword.keywordid as id
from asskeywordtranslation
where asskeywordtranslation.deleted = false
and asskeywordtranslation.languageid = <%=languageID%>
and lower(asskeywordtranslation.name) like lower('<%=keys[i]%>')
and asskeywordtranslation.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false;
<% String apu = (String)pageContext.getAttribute("keyid");
if ( apu != null ) success = true; %>
<%
if (success) { keyid = Integer.parseInt((String)pageContext.getAttribute("keyid")); }
else {
%>
select max(keywordid)+1 as max from assignmentkeyword;
<% String apu = (String)pageContext.getAttribute("keyid");
if ( apu != null ) success = true; %>
<% if (success) keyid = Integer.parseInt((String)pageContext.getAttribute("keyid")); %>
insert into assignmentkeyword
(deleted, keywordid) values
('false', <%=keyid%>);
insert into asskeywordtranslation
(deleted, keywordid, languageid, name) values
('false', <%=keyid%>, <%=languageID%>, '<%=keys[i]%>');
<% }
// Finally update to relation table
try {
%>
insert into assoriginalrelkeyword
(deleted, originalid, keywordid) values
('false', <%=origID%>, <%=keyid%>);
<% } catch (Exception kex) {
%>
update assoriginalrelkeyword
set deleted = false
where originalid = <%=origID%>
and keywordid = <%=keyid%>;
<% }
}
}
%>
<%-- lines --%>
update assoriginalposline
set deleted = true
where originalid = <%=origID%>
<%
String[] lines = new String[100];
lines = request.getParameterValues("line");
if ( lines != null ) {
int i=0;
for (i=0; i < lines.length; i++) {
try {
%>
insert into assoriginalposline (deleted, originalid, lineid)
values (false, <%=origID%>, <%=lines[i]%>);
<%
} catch (Exception ep) {
%>
update assoriginalposline
set deleted = false
where originalid = <%=origID%>
and lineid = <%=lines[i]%>
<%
}
}
}
%>
<%-- types --%>
update assoriginalpostype
set deleted = true
where originalid = <%=origID%>
<%
String[] types = new String[100];
types = request.getParameterValues("type");
if ( types != null ) {
int i=0;
for (i=0; i < types.length; i++) {
try {
%>
insert into assoriginalpostype (deleted, originalid, typeid)
values (false, <%=origID%>, <%=types[i]%>);
<%
} catch (Exception ep) {
%>
update assoriginalpostype
set deleted = false
where originalid = <%=origID%>
and typeid = <%=types[i]%>
<%
}
}
}
response.sendRedirect("acceptProposition.jsp?info=ok&origid="+origID );
}
%>
addEvent.jsp 0100774 0000061 0000310 00000017057 07475376603 013255 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: addEvent.jsp
* LANGUAGE: JSP
* DATE: 4.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show Assignmentevent's details
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 13.5.2002 M.Ylitalo
* - Some bug fixes
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("assid") == null)
response.sendRedirect("error.jsp?page=addEvent&message=1") ;
int assID = Integer.parseInt((String)request.getParameter("assid"));
%>
select 1 as id
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.roleid = assrolerelright.roleid
and assrolerelright.deleted = false
and assrolerelright.rightid = <%=allowAssDetail%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
boolean isStudent = true;
String regid="";
%>
select assignmentrelatedperson.roleid as id,
assignmentrelatedperson.relationid as regid
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = <%=personID%>
<% try {
if ( Integer.parseInt((String)pageContext.getAttribute("roleid")) != studentID ) isStudent = false;
regid = (String)pageContext.getAttribute("regid");
} catch (Exception e) { response.sendRedirect("error.jsp?page=addEvent&message=2"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
Tapahtuman lisminen
select assdetailtranslation.name as assname,
assignment.assignmentid as assid
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
">
<%@ include file="/shared/pageEnd.inc" %>
adminAssRight.jsp 0100774 0000061 0000310 00000007130 07475376603 014247 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: adminAssRight.jsp
* LANGUAGE: JSP
* DATE: 6.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show all right related to assignments
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<% /* No relation to database is needed */
if ( userAccessLevel < 6 ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% String orderBy= "order by assroletranslation.name";
String order="";
if (request.getParameter("orderby") != null) order = request.getParameter("orderby");
if ( order.equals("rolename") ) orderBy = "order by assroletranslation.name";
if ( order.equals("rightname") ) orderBy = "order by assignmentright.name, assroletranslation.name";
%>
Opinnytteiden rooleihin liitetyt oikeudet
Alla on luettelo opinnytteisiin liittyvist oikeuksista
<%@ include file="/shared/pageEnd.inc" %>
adminAssRightGroup.jsp 0100774 0000061 0000310 00000007147 07475376603 015274 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: adminAssRightGroup.jsp
* LANGUAGE: JSP
* DATE: 6.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show all user group related rights
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<% /* No relation to database is needed */
if ( userAccessLevel < 6 ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% String orderBy= " order by accessrightleveltranslation.name";
String order="";
if (request.getParameter("orderby") != null) order = request.getParameter("orderby");
if ( order.equals("groupname") ) orderBy = " order by accessrightleveltranslation.name";
if ( order.equals("rightname") ) orderBy = " order by assignmentright.name, accessrightleveltranslation.name";
%>
ovat KOTKA-jrjestelmn kyttjryhmiin sidottuja oikeuksia KOPPELO-sovelluksessa.
Niden oikeuksien myntmisess pit aina kytt harkintaa, sill nill oikeuksilla
kyttjt voivat saada itselleen tarpeettoman suuren vallan KOPPELO-sovelluksessa.
Usein oikeuksien myntmiseen riitt roolikohtaiset oikeudet.
<%@ include file="/shared/pageEnd.inc" %>
assignment.jsp 0100774 0000061 0000310 00000051417 07475376603 013671 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignment.jsp
* LANGUAGE: JSP
* DATE: 4.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 27.4.2002 Minna Hillebrand
* Added all assignment related details
* 15.5.2002 Antti Vanhanen
* Modification to vocabulary
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%-- Check that all necessary parameters have been posted and the user
is related to the assignment --%>
<%
if (request.getParameter("assid") == null) {
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=assignment&message=1");
return;
}
int origid = Integer.parseInt(request.getParameter("origid"));
response.sendRedirect("assignmentInfo.jsp?origid="+origid);
return;
}
int assID = Integer.parseInt(request.getParameter("assid"));
%>
<%-- we need to figure out if the user can update assignment's detail or just watch the details --%>
<% police.setDB(db);
boolean canUpdate = false;
boolean canGrade = false;
boolean canFinish = false;
if ( ! police.hasPersonRight(allowAssDetail, personID, assID) ) {
response.sendRedirect("assignmentInfo.jsp?assid="+assID);
return;
}
if ( police.hasPersonRight(allowAssUpdate, personID, assID) ) canUpdate = true;
if ( police.hasPersonRight(allowGradeID, personID, assID) ) canGrade = true;
if ( police.hasPersonRight(allowAssFinish, personID, assID) ) canFinish = true;
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<% time timeformater = new time(); %>
select assdetailtranslation.name as title,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignment.assignmentid = <%=assID%>
and assignment.deleted = false
and assignmentreldetail.assignmentid = <%=assID%>
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=titleID%>
and descriptiontypetranslation.languageid = <%=languageID%>
select assdetailtranslation.name as descr,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignment.assignmentid = <%=assID%>
and assignment.deleted = false
and assignmentreldetail.assignmentid = <%=assID%>
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=descriptionID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=descriptionID%>
and descriptiontypetranslation.languageid = <%=languageID%>
Avainsanat
<% String akeys="";
boolean first=true;
%>
select asskeywordtranslation.name as keyw
from asskeywordtranslation
where assignmentrelkeyword.deleted = false
and assignmentrelkeyword.assignmentid = <%=assID%>
and assignmentrelkeyword.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false
and asskeywordtranslation.deleted = false
and assignmentkeyword.keywordid = asskeywordtranslation.keywordid
and asskeywordtranslation.languageid = <%=languageID%>
<% if (first) { akeys += pageContext.getAttribute("keys"); first = false; }
else akeys += ", " +pageContext.getAttribute("keys"); %>
<%=akeys%>
select
assignment.assignmenttypeid as asstypeid,
asstypetranslation.name as typename,
assignment.lineid as alineid,
course.courseid as asscourseid,
assignment.phaseid as assphaseid,
assphasetranslation.name as phasename,
assignment.warningtime as wtime,
assignment.publicgroup as pgroup,
assignmentoriginal.available as available,
assignment.begindate,
assignment.finisheddate
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignment.originalid = assignmentoriginal.originalid
and assignment.assignmenttypeid = assignmenttype.typeid
and assignmenttype.typeid = asstypetranslation.typeid
and asstypetranslation.languageid = <%=languageID%>
<%--
and assignment.lineid = studyline.lineid
and studyline.lineid = studylinetranslation.lineid
--%>
and assignment.courseid = course.courseid
and course.courseid = coursetranslation.courseid
and coursetranslation.languageid = <%=languageID%>
and assignment.phaseid = assignmentphase.phaseid
and assignmentphase.phaseid = assphasetranslation.phaseid
and assphasetranslation.languageid = <%=languageID%>
Tyyppi
Linja
<% try { %>
select studylinetranslation.name as linename,
organisationtranslation.name as orgname
from studyline
where studyline.deleted = false
and studyline.lineid =
and studyline.lineid = studylinetranslation.lineid
and studylinetranslation.languageid = <%=languageID%>
and studyline.organisationid = organisation.organisationid
and organisation.deleted = false
and organisation.organisationid = organisationtranslation.organisationid
and organisationtranslation.languageid = <%=languageID%>
,
<% } catch (Exception e) {} %>
select person.lastname || ' ' || person.firstnames as name,
assroletranslation.name as rolename,
person.personid as pid
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = person.personid
and person.deleted = false
and assignmentrelatedperson.roleid = assignmentrole.roleid
and assignmentrole.deleted = false
and assignmentrole.roleid = assroletranslation.roleid
and assroletranslation.deleted = false
and assroletranslation.languageid = <%=languageID%>
order by roleid, person.lastname;
select personparameter.personparametervalue as email
from personparameter
where personparameter.deleted = false
and personparameter.personid =
and personparameter.personparametertypeid = 3
Opinnytteeseen liittyvt tytehtvt
<% boolean titlerow=true; %>
select asstasktranslation.name as taskname,
asstaskcategorytranslation.name as catname,
assphasetranslation.name as taskphase
from assignmenttaskrelation
where assignmenttaskrelation.deleted = false
and assignmenttaskrelation.assignmentid = <%=assID%>
and assignmenttaskrelation.taskid = assignmenttask.taskid
and assignmenttask.deleted = false
and assignmenttask.taskid = asstasktranslation.taskid
and asstasktranslation.languageid = <%=languageID%>
and assignmenttask.categoryid = asstaskcategory.categoryid
and asstaskcategory.categoryid = asstaskcategorytranslation.categoryid
and asstaskcategorytranslation.languageid = <%=languageID%>
and assignmenttaskrelation.phaseid = assignmentphase.phaseid
and assignmentphase.phaseid = assphasetranslation.phaseid
and assphasetranslation.languageid = <%=languageID%>
order by catname, taskname
<% } %>
--%>
<% boolean firstgrade = true; %>
select
person.firstnames || ' ' || person.lastname as name,
assignmentfinished.gradedate,
assignmentfinished.gradedbyid,
gradetranslation.name as grade
from assignmentfinished, assignmentrelatedperson as GradedBy, assignmentrelatedperson as Student
where assignmentfinished.deleted = false
and assignmentfinished.gradedbyid = GradedBy.relationid
and GradedBy.assignmentid = <%=assID%>
and GradedBy.deleted = false
and GradedBy.personid = person.personid
and assignmentfinished.persontobegradedid = Student.relationid
and Student.deleted = false
and Student.personid = <%=personID%>
and assignmentfinished.gradeid = gradetranslation.gradeid
and gradetranslation.languageid = <%=languageID%>
<% if (firstgrade) { %>
select assignmentfinished.persontobegradedid as studentgrade,
Stu.firstnames || ' ' || Stu.lastname as stuname,
assignmentfinished.gradedate,
GradedBy.personid as gradeperson,
GradedBy.relationid as gradedbyid,
Tea.firstnames || ' ' || Tea.lastname as teaname,
gradetranslation.name as grade,
trunc(assignmentfinished.credits) as credits
from assignmentfinished, assignmentrelatedperson as Student, assignmentrelatedperson as GradedBy,
person as Stu, person as Tea
where assignmentfinished.deleted = false
and assignmentfinished.gradedbyid = GradedBy.relationid
and GradedBy.assignmentid = <%=assID%>
and GradedBy.deleted = false
and GradedBy.personid = Tea.personid
and assignmentfinished.persontobegradedid = Student.relationid
and Student.deleted = false
and Student.personid = Stu.personid
and Student.assignmentid = <%=assID%>
and assignmentfinished.gradeid = grade.gradeid
and grade.gradeid = gradetranslation.gradeid
and gradetranslation.languageid = <%=languageID%>
order by gradedate desc;
<% if ( Integer.parseInt((String)pageContext.getAttribute("gradeperson")) == personID ) { %>
select assignmentevent.eventid as eventid,
asseventtypetranslation.name as eventtype,
assignmentevent.title as title,
assignmentevent.eventdate as eventdate,
person.firstnames || ' ' || person.lastname as name
from asseventtypetranslation, person
where assignmentevent.deleted = 'false'
and assignmentevent.assignmentid = <%=assID%>
and assignmentevent.eventtypeid = asseventtype.typeid
and asseventtype.typeid = asseventtypetranslation.typeid
and asseventtypetranslation.languageid = <%=languageID%>
and assignmentevent.registratorid = assignmentrelatedperson.relationid
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = person.personid
order by assignmentevent.eventdate desc, assignmentevent.begintime desc, assignmentevent.endtime desc;
<% counter++; %>
<%@ include file="/shared/pageEnd.inc" %>
assignmentAttach.jsp 0100774 0000061 0000310 00000017072 07475376603 015015 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentAttach.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Promote subject to assignment
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 10.5.2002 Minna Hillebrand
* Functionality to change/adjust assignment's details
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=assignmentAttach&message=1");
return;
}
String origID = (String)request.getParameter("origid");
%>
<%-- Check that user is allowed --%>
select 1 as id
from asspersonrelright
where asspersonrelright.deleted = false
and asspersonrelright.personid = <%=personID%>
and asspersonrelright.rightid = <%=allowAssAttach%>
union
select 1 as id
from assusergrouprelright
where assusergrouprelright.deleted = false
and assusergrouprelright.groupid = <%=userAccessLevel%>
and assusergrouprelright.rightid = <%=allowAssAttach%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("assignment.jsp&origid="+origID);
return;
}
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/pageEnd.inc" %>
assignmentAttachInsert.jsp 0100774 0000061 0000310 00000015775 07475376603 016212 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentAttachInsert.jsp
* LANGUAGE: JSP
* DATE: 10.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Insert new assignment
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%-- Check parameters --%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=1");
return;
}
int origID = Integer.parseInt((String)request.getParameter("origid"));
if (request.getParameter("lineid") == null) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=1");
return;
}
String lineID = (String)request.getParameter("lineid");
if (request.getParameter("typeid") == null) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=1");
return;
}
int typeID = Integer.parseInt((String)request.getParameter("typeid"));
if (request.getParameter("courseid") == null) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=1");
return;
}
int courseID = Integer.parseInt((String)request.getParameter("courseid"));
if (request.getParameter("begindate") == null) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=1");
return;
}
time timeformater = new time();
String beginDate = timeformater.monthToDBFormat((String)request.getParameter("begindate"));
%>
<%-- Check that user is allowed --%>
select 1 as id
from asspersonrelright
where asspersonrelright.deleted = false
and asspersonrelright.personid = <%=personID%>
and asspersonrelright.rightid = <%=allowAssAttach%>
<% if ( ! lineID.equals("null") ) { %>
and asspersonrelright.lineid = <%=lineID%>
<% } %>
and asspersonrelright.asstypeid = <%=typeID%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<%-- Check that we haven't pushed back-button --%>
select available as av
from assignmentoriginal
where assignmentoriginal.originalid = <%=origID%>
and assignmentoriginal.deleted = false
<%
try {
int av = Integer.parseInt((String)pageContext.getAttribute("av"));
if ( av <= 0 ) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=3");
return;
}
} catch (Exception e) {
response.sendRedirect("error.jsp?page=assignmentAttachInsert&message=3");
return;
}
%>
<% boolean success = false; %>
select max(assignment.assignmentid)+1 as maxid from assignment;
<% if (pageContext.getAttribute("maxid") != null) success = true; %>
<%
int maxID = 1;
if (success) maxID = Integer.parseInt((String)pageContext.getAttribute("maxid"));
%>
insert into assignment
(deleted, assignmentid, warningtime, publicgroup, originalid,
assignmenttypeid, courseid, lineid, begindate, finisheddate, phaseid)
values
('false', <%=maxID%>, NULL, <%=defaultPublicGroup%>, <%=origID%>,
<%=typeID%>, <%=courseID%>, <%=lineID%>, '<%=beginDate%>' ,NULL, <%=defaultPhaseID%>);
<%-- sql to get maxid of table assignmentrelatedperson --%>
<% success = false; %>
select max(assignmentrelatedperson.relationid)+1 as maxid from assignmentrelatedperson;
<% if (pageContext.getAttribute("maxid") != null) success = true; %>
<% int relID = 1;
if (success) relID = Integer.parseInt((String)pageContext.getAttribute("maxid"));
%>
insert into assignmentrelatedperson (deleted, relationid, assignmentid, personid, roleid)
values
('false', <%=relID%>, <%=maxID%>, <%=personID%>, <%=chiefRoleID%>);
<%-- copy all raleted details --%>
insert into assignmentreldetail (deleted, assignmentid, detailid, allowupdate)
select 'false', <%=maxID%>, assoriginalreldetail.detailid, 'false'
from assoriginalreldetail
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.deleted = false;
<%-- copy all raleted keywords --%>
insert into assignmentrelkeyword (deleted, assignmentid, keywordid)
select 'false', <%=maxID%>, assoriginalrelkeyword.keywordid
from assoriginalrelkeyword
where assoriginalrelkeyword.originalid = <%=origID%>
and assoriginalrelkeyword.deleted = false;
<%-- no more available --%>
update assignmentoriginal
set available = (available-1)
where assignmentoriginal.originalid = <%=origID%>;
<% response.sendRedirect("assignmentUpdate.jsp?assid="+maxID); %>
assignmentEvent.jsp 0100774 0000061 0000310 00000023553 07475376603 014673 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentEvent.jsp
* LANGUAGE: JSP
* DATE: 4.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show assignment event's details
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("eventid") == null) {
response.sendRedirect("error.jsp?page=assignmentEvent&message=1");
return;
}
String eventID = request.getParameter("eventid");
%>
select 1 as id
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = assignmentevent.assignmentid
and assignmentevent.eventid = <%=eventID%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.roleid = assrolerelright.roleid
and assrolerelright.deleted = false
and assrolerelright.rightid = <%=allowAssDetail%>
union
select 1 as id from assusergrouprelright
where assusergrouprelright.deleted = false
and assusergrouprelright.groupid = <%=userAccessLevel%>
and assusergrouprelright.rightid = <%=allowAssDetail%>
union
select 1 as id from asspersonrelright
where asspersonrelright.deleted = false
and asspersonrelright.personid = <%=personID%>
and asspersonrelright.rightid = <%=allowAssDetail%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
Opinnytteeseen liittyvn tapahtuman tiedot
<% time timeformater = new time(); %>
select assdetailtranslation.name as assname,
assignment.assignmentid as assid
from assignment, assignmentdetail, assdetailtranslation, assignmentevent
where assignmentevent.eventid = <%=eventID%>
and assignment.assignmentid = assignmentevent.assignmentid
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
select asseventtypetranslation.name as eventtype,
assignmentevent.title as title,
assignmentevent.memo as memo,
assignmentevent.eventdate as edate,
assignmentevent.begintime as begintime,
assignmentevent.endtime as endtime,
person.firstnames as fnames,
person.lastname as lname,
personparameter.personparametervalue as email
from asseventtypetranslation, person
where assignmentevent.eventid = <%=eventID%>
and assignmentevent.eventtypeid = asseventtypetranslation.typeid
and asseventtypetranslation.languageid = <%=languageID%>
and assignmentevent.registratorid = assignmentrelatedperson.relationid
and assignmentrelatedperson.personid = person.personid
and person.personid = personparameter.personid
and personparameter.deleted = false
and personparameter.personparametertypeid = 3
select assignmentevent.eventid as eventid,
asseventtypetranslation.name as eventtype,
assignmentevent.title as title,
assignmentevent.eventdate as eventdate,
person.firstnames || ' ' || person.lastname as name
from asseventtypetranslation, person
where assignmentevent.deleted = 'false'
and assignmentevent.assignmentid = <%=assID%>
and assignmentevent.eventtypeid = asseventtype.typeid
and asseventtype.typeid = asseventtypetranslation.typeid
and asseventtypetranslation.languageid = <%=languageID%>
and assignmentevent.registratorid = assignmentrelatedperson.relationid
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = person.personid
order by assignmentevent.eventdate desc;
<% counter++; %>
select assdetailtranslation.name as assname
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
Opiskelijoiden nykyiset arvioinnit
Arvostelupiv
Opiskelija
Arvioitsija
Arvolause
OV
select assignmentfinished.persontobegradedid as studentgrade,
Stu.firstnames || ' ' || Stu.lastname as stuname,
assignmentfinished.gradedate,
GradedBy.personid as gradeperson,
GradedBy.relationid as gradedbyid,
Tea.firstnames || ' ' || Tea.lastname as teaname,
gradetranslation.name as grade,
trunc(assignmentfinished.credits) as credits
from assignmentfinished, assignmentrelatedperson as Student, assignmentrelatedperson as GradedBy,
person as Stu, person as Tea
where assignmentfinished.deleted = false
and assignmentfinished.gradedbyid = GradedBy.relationid
and GradedBy.assignmentid = <%=assID%>
and GradedBy.deleted = false
and GradedBy.personid = Tea.personid
and assignmentfinished.persontobegradedid = Student.relationid
and Student.deleted = false
and Student.personid = Stu.personid
and Student.assignmentid = <%=assID%>
and assignmentfinished.gradeid = grade.gradeid
and grade.gradeid = gradetranslation.gradeid
and gradetranslation.languageid = <%=languageID%>
order by gradedate desc;
<% if ( Integer.parseInt((String)pageContext.getAttribute("gradeperson")) == personID ) { %>
Opiskelijoiden arviointien vienti KORPPI-jrjestelmn kantaan
select assdetailtranslation.name as assname,
course.code as code
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and assignment.courseid = course.courseid
select assignmentfinished.persontobegradedid as studentgrade,
Stu.firstnames || ' ' || Stu.lastname as stuname,
assignmentfinished.gradedate,
GradedBy.personid as gradeperson,
GradedBy.relationid as gradedbyid,
Tea.firstnames || ' ' || Tea.lastname as teaname,
gradetranslation.name as grade,
trunc(assignmentfinished.credits) as credits
from assignmentfinished, assignmentrelatedperson as Student, assignmentrelatedperson as GradedBy,
person as Stu, person as Tea
where assignmentfinished.deleted = false
and assignmentfinished.gradedbyid = GradedBy.relationid
and GradedBy.assignmentid = <%=assID%>
and GradedBy.deleted = false
and GradedBy.personid = Tea.personid
and assignmentfinished.persontobegradedid = Student.relationid
and Student.deleted = false
and Student.personid = Stu.personid
and Student.assignmentid = <%=assID%>
and assignmentfinished.gradeid = grade.gradeid
and grade.gradeid = gradetranslation.gradeid
and gradetranslation.languageid = <%=languageID%>
order by gradedate desc, Stu.lastname desc;
<% if ( Integer.parseInt((String)pageContext.getAttribute("gradeperson")) == personID ) { %>
<%@ include file="/shared/pageEnd.inc" %>
assignmentGradeInsert.jsp 0100774 0000061 0000310 00000011614 07475376603 016014 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentGradeInsert.jsp
* LANGUAGE: JSP
* DATE: 3.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Insert or update assignment grade
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("assid") == null) {
response.sendRedirect("error.jsp?page=assignmentGradeInsert.jsp&message=1") ;
return;
}
int assID = 0;
try {
assID = Integer.parseInt((String)request.getParameter("assid"));
} catch (Exception novalue) { response.sendRedirect("error.jsp?message=2&page=assignmentGradeInsert"); return; }
time timeformater = new time();
police.setDB(db);
boolean canGrade = false;
if ( ! police.hasPersonRight(allowGradeID, personID, assID) ) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
if ( request.getParameter("studentid") == null ||
request.getParameter("gradedate") == null ||
request.getParameter("gradedby") == null ||
request.getParameter("memo") == null ||
request.getParameter("gradeid") == null ) {
response.sendRedirect("error.jsp?message=1&page=assignmentGradeInsert.jsp") ;
return;
}
String errormsg="";
double credits = 0;
if ( request.getParameter("credits") != null ) {
try {
credits = java.lang.Double.parseDouble((String)request.getParameter("credits"));
if (credits < 0 ) {
credits = 0;
errormsg += "Annoit opintoviikot vrin! ";
}
} catch (Exception e) { credits = 0; errormsg += "Annoit laittomat opintoviikkoarvon"; }
}
if ( request.getParameter("new") != null ) {
try {
%>
insert into assignmentfinished
(deleted, persontobegradedid, gradedbyid, gradeid, gradedate, credits, memo)
select 'false', <%=request.getParameter("studentid")%>, assignmentrelatedperson.relationid,
<%=request.getParameter("gradeid")%>, '<%=timeformater.monthToDBFormat(request.getParameter("gradedate"))%>',
<%=credits%>, '<%=request.getParameter("memo")%>'
from assignmentrelatedperson
where assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.assignmentid = <%=request.getParameter("assid")%>
<% } catch (Exception e) {
errormsg += "Tietojen tallennuksessa tapahtui virhe. Unohditko antaa joitain arvoja? Tarkasta, ette ole jo arvioinut ko. opiskelijaa.";
}
response.sendRedirect("assignmentGrade.jsp?updated=true&studentgrade="+
(String)request.getParameter("studentid") +
"&assid="+(String)request.getParameter("assid") +
"&error="+errormsg);
return;
}
// else we update existing grading
try {
%>
update assignmentfinished
set persontobegradedid = <%=request.getParameter("studentid")%>,
gradeid = <%=request.getParameter("gradeid")%>,
gradedate = '<%=request.getParameter("gradedate")%>',
credits = <%=credits%>,
memo = '<%=request.getParameter("memo")%>'
where assignmentfinished.persontobegradedid = <%=request.getParameter("update")%>
and assignmentfinished.gradedbyid = <%=request.getParameter("gradedby")%>
<% } catch (Exception e) { errormsg += "Tietojen tallennuksessa tapahtui virhe. Tarkasta, ettet ole jo arvioinut ko. opiskelijaa."; }
response.sendRedirect("assignmentGrade.jsp?updated=true&studentgrade="+
(String)request.getParameter("studentid") +
"&assid="+(String)request.getParameter("assid")+
"&error="+errormsg);
%>
assignmentGradeStudent.jsp 0100774 0000061 0000310 00000012631 07475376603 016176 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentGradeStudent.jsp
* LANGUAGE: JSP
* DATE: 3.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Grade details for student
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("assid") == null)
response.sendRedirect("error.jsp&page=assignmentGradeStudent.jsp&message=1") ;
int assID = Integer.parseInt((String)request.getParameter("assid"));
%>
<%-- check right to access page --%>
select 1 as id
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.roleid = <%=studentID%>
<%
try {
if ( Integer.parseInt((String)pageContext.getAttribute("gid")) != 1 ) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
} catch (Exception e) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
Arviointitiedot
<% time timeformater = new time(); %>
select assdetailtranslation.name as assname
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
select Student.firstnames || ' ' || Student.lastname as stuname,
Teacher.firstnames || ' ' || Teacher.lastname as teaname,
gradetranslation.name as gradevalue,
assignmentfinished.memo as memo,
trunc(assignmentfinished.credits) as credits,
assignmentfinished.gradedate as gradedate
from assignmentfinished, person as Student, assignmentrelatedperson as Studentrel,
person as Teacher, assignmentrelatedperson as Teacherrel
where assignmentfinished.deleted = false
and Studentrel.assignmentid = <%=assID%>
and Studentrel.personid = <%=personID%>
and Studentrel.personid = Student.personid
and Studentrel.relationid = assignmentfinished.persontobegradedid
and assignmentfinished.gradedbyid = Teacherrel.relationid
and Teacherrel.assignmentid = <%=assID%>
and Teacherrel.relationid = <%=request.getParameter("teacher")%>
and Teacherrel.personid = Teacher.personid
and assignmentfinished.gradeid = gradetranslation.gradeid
and gradetranslation.languageid = <%=languageID%>
<%@ include file="/shared/pageEnd.inc" %>
assignmentInfo.jsp 0100774 0000061 0000310 00000030666 07475376603 014510 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignment.jsp
* LANGUAGE: JSP
* DATE: 16.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show general information about assignment or subject.
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 27.4.2002 Minna Hillebrand
* Added assignment related details
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%
if ((request.getParameter("assid") == null) && (request.getParameter("origid") == null)) {
response.sendRedirect("error.jsp?page=assignmentInfo&message=1");
return;
}
if (request.getParameter("origid") != null) {
response.sendRedirect("assignmentOriginalInfo.jsp?origid="+ request.getParameter("origid") );
return;
}
if (request.getParameter("assid") == null) {
response.sendRedirect("error.jsp?page=assignmentInfo&message=1");
return;
}
int assID = Integer.parseInt(request.getParameter("assid"));
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
Opinnytteen yleiset tiedot
<% time timeformater = new time(); %>
<%--
Tll sivulla nytetn vain opinnytteen julkiset tiedot.
Tapahtumatietoihin pset tst.
--%>
select assdetailtranslation.name as title,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignment.assignmentid = <%=assID%>
and assignment.deleted = false
and assignmentreldetail.assignmentid = <%=assID%>
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=titleID%>
and descriptiontypetranslation.languageid = <%=languageID%>
select assdetailtranslation.name as descr,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignment.assignmentid = <%=assID%>
and assignment.deleted = false
and assignmentreldetail.assignmentid = <%=assID%>
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=descriptionID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=descriptionID%>
and descriptiontypetranslation.languageid = <%=languageID%>
Avainsanat
<% String akeys=""; boolean first=true; %>
select asskeywordtranslation.name as keyw
from asskeywordtranslation
where assignmentrelkeyword.deleted = false
and assignmentrelkeyword.assignmentid = <%=assID%>
and assignmentrelkeyword.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false
and asskeywordtranslation.deleted = false
and assignmentkeyword.keywordid = asskeywordtranslation.keywordid
and asskeywordtranslation.languageid = <%=languageID%>
<% if (first) { akeys = (String)pageContext.getAttribute("keys"); first = false; }
else akeys += ", " +(String)pageContext.getAttribute("keys"); %>
<%=akeys%>
select
assignment.assignmenttypeid as asstypeid,
asstypetranslation.name as typename,
assignment.lineid as alineid,
course.courseid as asscourseid,
assignment.phaseid as assphaseid,
assphasetranslation.name as phasename,
assignment.begindate,
assignment.finisheddate
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignment.originalid = assignmentoriginal.originalid
and assignment.assignmenttypeid = assignmenttype.typeid
and assignmenttype.typeid = asstypetranslation.typeid
and asstypetranslation.languageid = <%=languageID%>
and assignment.courseid = course.courseid
and course.courseid = coursetranslation.courseid
and coursetranslation.languageid = <%=languageID%>
and assignment.phaseid = assignmentphase.phaseid
and assignmentphase.phaseid = assphasetranslation.phaseid
and assphasetranslation.languageid = <%=languageID%>
Tyyppi
Linja
<% try { %>
select studylinetranslation.name as linename,
organisationtranslation.name as orgname
from studyline
where studyline.deleted = false
and studyline.lineid =
and studyline.lineid = studylinetranslation.lineid
and studylinetranslation.languageid = <%=languageID%>
and studyline.organisationid = organisation.organisationid
and organisation.deleted = false
and organisation.organisationid = organisationtranslation.organisationid
and organisationtranslation.languageid = <%=languageID%>
,
<% } catch (Exception e) {} %>
select person.lastname || ' ' || person.firstnames as name,
assroletranslation.name as rolename,
personparameter.personparametervalue as email
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = person.personid
and person.deleted = false
and assignmentrelatedperson.roleid = assignmentrole.roleid
and assignmentrole.deleted = false
and assignmentrole.roleid = assroletranslation.roleid
and assroletranslation.deleted = false
and assroletranslation.languageid = <%=languageID%>
and person.personid = personparameter.personid
and personparameter.deleted = false
and personparameter.personparametertypeid = 3
order by roleid, person.lastname;
, ()
Aiheeseen liittyvt tiedot
select assignmentoriginal.available,
proposer.firstnames || ' ' || proposer.lastname as pname,
assignmentoriginal.proposeddate,
assignmentoriginal.validuntil,
personparameter.personparametervalue as email
from assignmentoriginal, person as proposer
where assignmentoriginal.deleted = false
and assignment.assignmentid = <%=assID%>
and assignment.originalid = assignmentoriginal.originalid
and assignmentoriginal.proposedby = proposer.personid
and proposer.personid = personparameter.personid
and personparameter.deleted = false
and personparameter.personparametertypeid = 3
--%>
<%@ include file="/shared/pageEnd.inc" %>
assignmentOriginalInfo.jsp 0100774 0000061 0000310 00000022173 07475376603 016167 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentOriginalInfo.jsp
* LANGUAGE: JSP
* DATE: 22.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show general information about subject.
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=assignmentOriginalInfo&message=1");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% time timeformater = new time(); %>
Opinnytteen aiheen tiedot
select assdetailtranslation.name as title,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignmentoriginal.originalid = <%=origID%>
and assignmentoriginal.deleted = false
and assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=titleID%>
and descriptiontypetranslation.languageid = <%=languageID%>
select assdetailtranslation.name as descr,
descriptiontypetranslation.name as name
from assdetailtranslation
where assignmentoriginal.originalid = <%=origID%>
and assignmentoriginal.deleted = false
and assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=descriptionID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=descriptionID%>
and descriptiontypetranslation.languageid = <%=languageID%>
Avainsanat
<% String akeys=""; boolean first=true; %>
select asskeywordtranslation.name as keyw
from asskeywordtranslation
where assoriginalrelkeyword.deleted = false
and assoriginalrelkeyword.originalid = <%=origID%>
and assoriginalrelkeyword.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false
and asskeywordtranslation.deleted = false
and assignmentkeyword.keywordid = asskeywordtranslation.keywordid
and asskeywordtranslation.languageid = <%=languageID%>
<% if (first) { akeys = (String)pageContext.getAttribute("keys"); first = false; }
else akeys += ", " +(String)pageContext.getAttribute("keys"); %>
<%=akeys%>
Mahdolliset tyypit
<% try { %>
select asstypetranslation.name as typename
from assoriginalpostype
where assignmenttype.deleted = false
and assoriginalpostype.deleted = false
and assoriginalpostype.originalid = <%=origID%>
and assoriginalpostype.typeid = assignmenttype.typeid
and assignmenttype.typeid = asstypetranslation.typeid
and asstypetranslation.languageid = <%=languageID%>
<% } catch (Exception e) {} %>
Mahdolliset linjat
<% try { %>
select studylinetranslation.name as linename,
organisationtranslation.name as orgname
from assoriginalposline
where studyline.deleted = false
and assoriginalposline.deleted = false
and assoriginalposline.originalid = <%=origID%>
and assoriginalposline.lineid = studyline.lineid
and studyline.lineid = studylinetranslation.lineid
and studylinetranslation.languageid = <%=languageID%>
and studyline.organisationid = organisation.organisationid
and organisation.deleted = false
and organisation.organisationid = organisationtranslation.organisationid
and organisationtranslation.languageid = <%=languageID%>
,
<% } catch (Exception e) {} %>
select assignmentoriginal.available,
proposer.firstnames || ' ' || proposer.lastname as pname,
assignmentoriginal.proposeddate,
assignmentoriginal.validuntil,
personparameter.personparametervalue as email
from assignmentoriginal, person as proposer
where assignmentoriginal.deleted = false
and assignmentoriginal.originalid = <%=origID%>
and assignmentoriginal.proposedby = proposer.personid
and proposer.personid = personparameter.personid
and personparameter.deleted = false
and personparameter.personparametertypeid = 3
<% if (request.getParameter("updated") != null) { %>
Tiedot tallennettu
<% } %>
Opinnytteen yleiset tiedot
<%--
Opinnytteeseen liittyvt henkilt
select person.lastname || ' ' || person.firstnames as name,
assroletranslation.name as rolename,
personparameter.personparametervalue as email
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assID%>
and assignmentrelatedperson.personid = person.personid
and person.deleted = false
and assignmentrelatedperson.roleid = assignmentrole.roleid
and assignmentrole.deleted = false
and assignmentrole.roleid = assroletranslation.roleid
and assroletranslation.deleted = false
and assroletranslation.languageid = <%=languageID%>
and personparameter.deleted = false
and personparameter.personid = person.personid
and personparameter.personparametertypeid = 3
order by roleid, person.lastname;
--%>
<%--
Opinnytteeseen liittyvt tytehtvt
select asstasktranslation.name as taskname,
asstaskcategorytranslation.name as catname,
assphasetranslation.name as taskphase
from assignmenttaskrelation
where assignmenttaskrelation.deleted = false
and assignmenttaskrelation.assignmentid = <%=assID%>
and assignmenttaskrelation.taskid = assignmenttask.taskid
and assignmenttask.deleted = false
and assignmenttask.taskid = asstasktranslation.taskid
and asstasktranslation.languageid = <%=languageID%>
and assignmenttask.categoryid = asstaskcategory.categoryid
and asstaskcategory.categoryid = asstaskcategorytranslation.categoryid
and asstaskcategorytranslation.languageid = <%=languageID%>
and assignmenttaskrelation.phaseid = assignmentphase.phaseid
and assignmentphase.phaseid = assphasetranslation.phaseid
and assphasetranslation.languageid = <%=languageID%>
order by catname, taskname
select assdetailtranslation.name as assname,
assignment.assignmentid as assid
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
select assdetailtranslation.name as assname
from assignment
where assignment.deleted = false
and assignment.assignmentid = <%=assID%>
and assignmentreldetail.assignmentid = assignment.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>;
select asstasktranslation.name as taskname,
asstaskcategorytranslation.name as catname,
assphasetranslation.name as taskphase,
asstasktranslation.taskid as taskid,
assphasetranslation.phaseid as phaseid
from assignmenttaskrelation
where assignmenttaskrelation.deleted = false
and assignmenttaskrelation.assignmentid = <%=assID%>
and assignmenttaskrelation.taskid = assignmenttask.taskid
and assignmenttask.deleted = false
and assignmenttask.taskid = asstasktranslation.taskid
and asstasktranslation.languageid = <%=languageID%>
and assignmenttask.categoryid = asstaskcategory.categoryid
and asstaskcategory.categoryid = asstaskcategorytranslation.categoryid
and asstaskcategorytranslation.languageid = <%=languageID%>
and assignmenttaskrelation.phaseid = assignmentphase.phaseid
and assignmentphase.phaseid = assphasetranslation.phaseid
and assphasetranslation.languageid = <%=languageID%>
order by catname, taskname
--%>
<% }
} catch (Exception e) {} %>
<%-- in case of null warning time --%>
<%-- Poistetaan erntyneet aiheet --%>
update assignmentoriginal
set deleted = true
where validuntil <= current_date
<%-- Varoitusviesti jos aihe aiotaan poistaa --%>
select Original.validuntil as validuntil,
Original.originalid as origid,
personparameter.personparametervalue as email,
assdetailtranslation.name as title,
(Original.validuntil - current_date) as timeleft
from assignmentoriginal as Original
where Original.deleted = false
and Original.acceptedby = null
and Original.proposedby = person.personid
and person.personid = personparameter.personid
and personparameter.personparametertypeid = 3
and personparameter.deleted = false
and Original.originalid = assoriginalreldetail.originalid
and assoriginalreldetail.deleted = false
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = 8
and assignmentdetail.detailid = assdetailtranslation.detailid
and assdetailtranslation.languageid = 2
<%-- having 7 > ( select (Orig.validuntil - current_date)
from assignmentoriginal as Orig
where Orig.originalid = Original.originalid ) --%>
<%
if ( Integer.parseInt((String)pageContext.getAttribute("timeleft")) < 7 ) {
String message = "Tm on automaattisesti lhetetty viesti KOPPELO-sovelluksesta.\n\n"
+ "Aihe-ehdotustasi \"" + (String)pageContext.getAttribute("title") + "\"\n"
+ "ei ole viel hyvksytty. Aihe-ehdotuksen viimeinen voimassaolopiv on "
+ timeformater.monthToOutFormat((String)pageContext.getAttribute("vuntil")) + ".\n\n"
+ "Voit muuttaa aihe-ehdotuksen tietoja ja jatkaa sen voimassaoloaikaa sivulla\n"
+ "https://hartman.it.jyu.fi/kotka/koppelo/acceptProposition.jsp?origid="
+ (String)pageContext.getAttribute("origid")
+ "\npiti menn" +(String)pageContext.getAttribute("email");
mail.sendMail("nobody@it.jyu.fi", "mmhilleb@st.jyu.fi", // "(String)pageContext.getAttribute("email")",
"Aihe-ehdotuksesi " +(String)pageContext.getAttribute("title"), message);
}
%>
Tarvittavat viestit lhetetty
available.jsp 0100774 0000061 0000310 00000015076 07477466030 013436 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: available.jsp
* LANGUAGE: JSP
* DATE: 10.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show list of all subjects from witch user can start assignment
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% /* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
select 1 as id
from asspersonrelright
where asspersonrelright.deleted = false
and asspersonrelright.personid = <%=personID%>
and asspersonrelright.rightid = <%=allowAssAttach%>
union
select 1 as id
from assusergrouprelright
where assusergrouprelright.deleted = false
and assusergrouprelright.groupid = <%=userAccessLevel%>
and assusergrouprelright.rightid = <%=allowAssAttach%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<% time timeformater = new time(); %>
Varattavissa olevien aiheiden kiinnitys
Sivulla olevista varattavissa olevista aiheista voit aloittaa opinnytteen suorituksen. Aloittamisen
jlkeen voit kiinnitt opinnytteeseen opiskelijoita ja ohjaajia.
Sivu sislt ainoastaan ne aiheet, jotka on hyvksytty oman laitoksesi linjoille.
<%--
Ehdotettu
--%>
Hyvksytty aiheeksi/ Voimassa
Otsikko
<%--
Ehdottaja
Hyvksyj
--%>
Ryhmi vapaana
Tyypit
select distinct assignmentoriginal.originalid as origid,
assignmentoriginal.proposeddate as pdate,
assignmentoriginal.accepteddate as adate,
assignmentoriginal.available as available,
assignmentoriginal.validuntil,
Acceptor.firstnames || ' ' || Acceptor.lastname as acceptor,
Proposer.firstnames || ' ' || Proposer.lastname as proposer,
assdetailtranslation.name as title
from assignmentoriginal, person as Acceptor, person as Proposer
where assignmentoriginal.deleted = false
<%-- and assignmentoriginal.acceptedby <> null --%>
and assignmentoriginal.available > 0
and assignmentoriginal.originalid = assoriginalreldetail.originalid
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assignmentdetail.detailid = assdetailtranslation.detailid
and assdetailtranslation.languageid = <%=languageID%>
and assignmentoriginal.proposedby = Proposer.personid
and assignmentoriginal.acceptedby = Acceptor.personid
and assignmentoriginal.originalid = assoriginalposline.originalid
and assoriginalposline.lineid = studyline.lineid
and studyline.organisationid = <%=user.getOrganisationID()%>
and assignmentoriginal.validuntil >= current_date
order by adate asc;
select asstypetranslation.name as typename
from assoriginalpostype
where assoriginalpostype.originalid =
and assoriginalpostype.deleted = false
and assoriginalpostype.typeid = asstypetranslation.typeid
and asstypetranslation.languageid = <%=languageID%>
<%@ include file="/shared/pageEnd.inc" %>
availableStudent.jsp 0100774 0000061 0000310 00000013070 07477466065 015005 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: availableStudent.jsp
* LANGUAGE: JSP
* DATE: 13.5.2002
* AUTHOR: Marko Ylitalo, University of Jyvskyl (JYU)
* PURPOSE: Show list of all subjects from witch user can start assignment
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% /* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<% time timeformater = new time(); %>
Vapaat opinnytteiden aiheet
Sivulla esitetn ne laitoksellesi hyvksytyt opinnytteiden aiheet, joista voi aloittaa
opinnytteen suorituksen. Aiheen nimest pset tarkastelemaan aiheen tarkempia tietoja.
<%--
Ehdotettu
--%>
Hyvksytty aiheeksi/ Voimassa
Otsikko
<%--
Ehdottaja
Hyvksyj
--%>
Vapaa
Tyypit
select distinct assignmentoriginal.originalid as origid,
assignmentoriginal.proposeddate as pdate,
assignmentoriginal.accepteddate as adate,
assignmentoriginal.available as available,
assignmentoriginal.validuntil as validuntil,
Acceptor.firstnames || ' ' || Acceptor.lastname as acceptor,
Proposer.firstnames || ' ' || Proposer.lastname as proposer,
assdetailtranslation.name as title
from assignmentoriginal, person as Acceptor, person as Proposer
where assignmentoriginal.deleted = false
<%-- and assignmentoriginal.acceptedby <> null --%>
and assignmentoriginal.available > 0
and assignmentoriginal.originalid = assoriginalreldetail.originalid
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assignmentdetail.detailid = assdetailtranslation.detailid
and assdetailtranslation.languageid = <%=languageID%>
and assignmentoriginal.proposedby = Proposer.personid
and assignmentoriginal.acceptedby = Acceptor.personid
and assignmentoriginal.originalid = assoriginalposline.originalid
and assoriginalposline.lineid = studyline.lineid
and studyline.organisationid = <%=user.getOrganisationID()%>
and assignmentoriginal.validuntil >= current_date
order by adate asc;
select asstypetranslation.name as typename
from assoriginalpostype
where assoriginalpostype.originalid =
and assoriginalpostype.deleted = false
and assoriginalpostype.typeid = asstypetranslation.typeid
and asstypetranslation.languageid = <%=languageID%>
<%@ include file="/shared/pageEnd.inc" %>
error.jsp 0100774 0000061 0000310 00000004235 07475376603 012646 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: errorNoAccess.jsp
* LANGUAGE: JSP
* DATE: 18.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: General error page
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
Error
Virhe
Virhe tapahtui sivulla: <%=request.getParameter("page")%>.jsp
<% try {
int id = Integer.parseInt((String)request.getParameter("message"));
if ( id == 1 ) { %>
Liian vhn parametreja sivun kutsumiseen.
<% }
if ( id == 2 ) { %>
Odottamaton virhe.
<% }
if ( id == 3 ) { %>
Opinnyte ei vapaa kiinnitettvksi. Joko painoit selaimen
Back painiketta ja siten olit jo aiemmin kiinnittnyt aiheen ohjattavaksesi tai
toinen kyttj enntti kiinnitt aiheen itselleen.
<% }
if ( id == 4 ) { %>
Tietojen tallentamisessa tapahtui virhe. Annoitko <%
%> pivykseen ja kellonajoiksi jrkevi arvoja?
<% }
} catch (Exception e) {}
%>
errorNoAccess.jsp 0100774 0000061 0000310 00000002617 07475376603 014267 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: errorNoAccess.jsp
* LANGUAGE: JSP
* DATE: 18.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: General error page
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
Error
Sinulla ei ole oikeutta tlle sivulle
index.jsp 0120777 0000061 0000310 00000000000 07454621221 014237 2main.jsp ustar tomcat wwwadmin insertEvent.jsp 0100774 0000061 0000310 00000010342 07475376603 014017 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: studentAssEvent.jsp
* LANGUAGE: JSP
* DATE: 4.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Show Assignmentevent's details
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
if (request.getParameter("assid") == null) {
response.sendRedirect("error.jsp?page=insertEvent.jsp&message=1") ;
return;
}
int assid = Integer.parseInt((String)request.getParameter("assid"));
%>
select 1 as id
from assignmentrelatedperson
where assignmentrelatedperson.deleted = false
and assignmentrelatedperson.assignmentid = <%=assid%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.roleid = assrolerelright.roleid
and assrolerelright.deleted = false
and assrolerelright.rightid = <%=allowAssDetail%>
<%
try {
int id = Integer.parseInt((String)pageContext.getAttribute("did"));
} catch (Exception e) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<% boolean success = false; %>
select max(assignmentevent.eventid)+1 as newid
from assignmentevent;
<% if ( pageContext.getAttribute("maxid") != null ) success = true; %>
<% String maxid = "1";
if (success) maxid = (String)pageContext.getAttribute("maxid");
try {
%>
<% time timeformater = new time(); %>
INSERT INTO AssignmentEvent (Deleted, EventID, AssignmentID, RegistratorID,
EventDate, BeginTime, EndTime, Title, Memo, Taskid, EventTypeId)
VALUES (False, <%=maxid%>, <%=request.getParameter("assid")%>,
<%=request.getParameter("regid")%>, '<%=timeformater.monthToDBFormat((String)request.getParameter("date"))%>',
'<%=request.getParameter("begintime")%>', '<%=request.getParameter("endtime")%>',
'<%=request.getParameter("title")%>', '<%=request.getParameter("memo")%>',
<%=request.getParameter("taskid")%>, <%=request.getParameter("typeid")%>);
INSERT INTO unreadmessages (Deleted, asspersonid, eventid, toberemoved)
select 'false', assignmentrelatedperson.relationid, <%=maxid%>, current_date+10
where assignmentrelatedperson.deleted = 'false'
and assignmentrelatedperson.assignmentid = <%=assid%>
and assignmentrelatedperson.personid <> <%=personID%>
<% } catch (Exception e) {
response.sendRedirect("error.jsp?message=4&page=insertEvent");
return;
}
response.sendRedirect("assignmentEvent.jsp?eventid="+maxid);
%>
koppelo.jsp 0100774 0000061 0000310 00000003561 07475376603 013167 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: koppelo.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Marko Ylitalo, University of Jyvskyl (JYU)
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
* 13.05.2002 Antti Vanhanen, additions to contents
****************************************************************************************************
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
Aiheet ja haku
Opinnytteiden hallinto-osiossa voit ehdottaa uusia opinnytteiden aiheita
sek hakea jo ehdotettuja aiheita.
<%@ include file="/shared/pageEnd.inc" %>
main.jsp 0100774 0000061 0000310 00000034724 07475606047 012445 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: main.jsp
* LANGUAGE: JSP
* DATE: 19.3.2002
* AUTHOR: Markus Silvn, University of Jyvskyl (JYU)
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 4.4.2002 Made look like KOPPELO main page, Minna Hillebrand, JYU
* 18.4.2002 Added relations to AssignmentRight-tables, Minna Hillebrand, JYU
* 20.4.2002 Corrections to html printouts, Antti Vanhanen, JYU
* 28.4.2002 Corrections to sql-queries
* 30.5.2002 Wrong assignment phaseid corrected
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<% /* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
Opinnytteiden hallinta
<% time timeformater = new time(); %>
<%--
KOTKA-jrjestelmn opinnytteiden hallintaosassa voidaan yllpit kaikkea
opinnytteisiin liittyv tietoa. Tll psivulla net opinnytteisiisi
liittyvt lukemattomat tapahtumat ja linkit ohjaamiisi keskenerisiin opinnytteisiin.
<%-- All unread events related to user's assignments */ --%>
<% boolean firsttime=true; %>
Opinnytteisiin liittyvt uudet tapahtumat
select unreadmessages.eventid as eventid,
assignmentevent.title as title,
person.firstnames || ' ' || person.lastname as name,
assignmentevent.eventdate as eventdate,
assdetailtranslation.name as asstitle,
assignment.assignmentid as assid
from unreadmessages, assignmentrelatedperson as Reader, assignmentrelatedperson as Writer
where unreadmessages.deleted = false
and unreadmessages.asspersonid = Reader.relationid
and Reader.deleted = false
and Reader.personid = <%=personID%>
and unreadmessages.eventid = assignmentevent.eventid
and assignmentevent.assignmentid = assignment.assignmentid
and assignment.deleted = false
and assignmentevent.registratorid = Writer.relationid
and Writer.personid = person.personid
and assignment.assignmentid = assignmentreldetail.assignmentid
and assignmentreldetail.deleted = false
and assignmentreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assignmentdetail.deleted = false
and assignmentdetail.detailid = assdetailtranslation.detailid
and assdetailtranslation.languageid = <%=languageID%>
order by assignmentevent.eventdate desc, title desc;
<% if (firsttime) { firsttime=false; %>
select assignmentoriginal.originalid as origid,
assignmentoriginal.proposeddate as pdate,
assdetailtranslation.name as origname,
person.firstnames || ' ' || person.lastname as proposedby
from assignmentoriginal
where assdetailtranslation.languageid = <%=languageID%>
and assignmentoriginal.deleted = false
and assignmentoriginal.acceptedby = NULL
and assoriginalreldetail.originalid = assignmentoriginal.originalid
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assignmentdetail.detailid = assdetailtranslation.detailid
and assignmentoriginal.proposedby = person.personid;
">
--%>
Ohjaamasi opinnytteet
Vaihe
Tyyppi
Viimeisin tapahtuma
Otsikko
select assignment.assignmentid as assid,
assdetailtranslation.name as origname,
assphasetranslation.name as currentphase,
asstypetranslation.name as typename,
assignmentrelatedperson.roleid as roleid,
assignment.assignmenttypeid as typeid,
assignment.phaseid as phaseid
<%-- max(assignmentevent.eventdate) as lastdate We can't use due null values in event table --%>
from assignment
where assdetailtranslation.languageid = <%=languageID%>
and assphasetranslation.languageid = <%=languageID%>
and asstypetranslation.languageid = <%=languageID%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.deleted = false
and assignmentrelatedperson.roleid > <%=studentID%>
and assignmentrelatedperson.assignmentid = assignment.assignmentid
and assignment.assignmentid = assignmentreldetail.assignmentid
and assignmentdetail.detailid = assignmentreldetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentreldetail.detailid
and assignment.phaseid = assphasetranslation.phaseid
and assignment.phaseid <> <%=readyAssignmentID %>
and assignment.phaseid <> <%=incompleteAssignmentID%>
and assignment.assignmenttypeid = asstypetranslation.typeid
and assignment.deleted = false
<%-- and assignmentevent.assignmentid = assignment.assignmentid
group by assignment.assignmentid, origname, currentphase, typename, roleid,
assignment.assignmenttypeid, assignment.phaseid --%>
order by roleid desc, phaseid desc, typeid, origname, assignmentid;
<% }
if ( request.getParameter("student") != null ) {
%>
Omat opinnytteesi
Vaihe
Tyyppi
Viimeisin tapahtuma
Otsikko
select assignment.assignmentid as assid,
assdetailtranslation.name as origname,
assphasetranslation.name as currentphase,
asstypetranslation.name as typename,
assignmentrelatedperson.roleid as roleid,
assignment.assignmenttypeid as typeid,
assignment.phaseid as phaseid
from assignment
where assdetailtranslation.languageid = <%=languageID%>
and assphasetranslation.languageid = <%=languageID%>
and asstypetranslation.languageid = <%=languageID%>
and assignmentrelatedperson.personid = <%=personID%>
and assignmentrelatedperson.deleted = false
and assignmentrelatedperson.roleid = <%=studentID%>
and assignmentrelatedperson.assignmentid = assignment.assignmentid
and assignment.assignmentid = assignmentreldetail.assignmentid
and assignmentdetail.detailid = assignmentreldetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentreldetail.detailid
and assignment.phaseid = assphasetranslation.phaseid
and assignment.phaseid <> <%=readyAssignmentID %>
and assignment.assignmenttypeid = asstypetranslation.typeid
and assignment.deleted = false
order by roleid desc, phaseid desc, typeid, origname;
--%>
<%@ include file="/shared/pageEnd.inc" %>
propose.jsp 0100774 0000061 0000310 00000015232 07475376603 013203 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: propose.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Markus Silvn, University of Jyvskyl (JYU)
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
* 20.4.2002 Corrections to html printouts, Antti Vanhanen, JYU
* 23.4.2002 Added more fields, Minna Hillebrand, JYU
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
Ehdota aihetta opinnytetyksi
Kaikki kentt (avainsanoja lukuunottamatta) ovat pakollisia. Voit antaa
aihe-ehdotuksen vain oman laitoksesi linjoille.
<%--
Ehdota aihetta opinnytetyksi
--%>
Voit antaa useita avainsanoja pilkulla erottaen.
<%
java.util.Date today = new java.util.Date();
java.text.SimpleDateFormat parser = new java.text.SimpleDateFormat("dd.MM.yyyy");
%>
<%= parser.format(today) %>
select trunc(avg(assignmenttype.defaulttimeindb)) as deftime
from assignmenttype;
<% String defTime = (String)pageContext.getAttribute("deftime"); %>
piv
Opinnytteen tyyppi
Opinnytteen linja
<%--
--%>
<%-- all study types and ids --%>
<%--
--%>
<%-- --%>
<%@ include file="/shared/pageEnd.inc" %>
proposeConfirmRemove.jsp 0100774 0000061 0000310 00000007406 07475376603 015703 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: proposeConfirmRemove.jsp
* LANGUAGE: JSP
* DATE: 13.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Make sure that user want's to remove proposition
*
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
****************************************************************************************************/
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=proposeConfirmRemove&message=1");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%-- Access right --%>
<% police.setDB(db);
boolean canUpdate = false;
if ( police.hasPersonRightOriginal(allowPropAccept, personID, origID) ||
police.hasGroupRight(allowPropAccept, userAccessLevel) ) {
canUpdate = true;
}
if ( !canUpdate ) {
response.sendRedirect("errorNoAccess.jsp");
return;
}
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<% time timeformater = new time(); %>
<%
String term="aihe-ehdotuksen";
String capitalterm="Aihe-ehdotuksen";
String redirect = "propositions";
if ( request.getParameter("page") != null ) {
term = "aiheen";
capitalterm="Aiheen";
redirect = "available";
}
%>
<%=capitalterm%> hylkminen
<%-- TITLE --%>
select assdetailtranslation.name as name,
descriptiontypetranslation.name as type,
assignmentdetail.detailid as id
from assdetailtranslation, descriptiontypetranslation
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
and assdetailtranslation.detailid = assignmentdetail.detailid
and assdetailtranslation.languageid = <%=languageID%>
and descriptiontypetranslation.descriptiontypeid = <%=titleID%>
and descriptiontypetranslation.languageid = <%=languageID%>;
Halutko varmasti poistaa <%=term%>
""?
<% if ( request.getParameter("page") != null ) { %>
<% } %>
<%@ include file="/shared/pageEnd.inc" %>
proposeInsert.jsp 0100774 0000061 0000310 00000034374 07501557126 014367 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: proposeInsert.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Insert proposed subject into table AssignmentOriginal,
* send email to person responsible for accepeting propositions
* (if necessary) and redirect to thanks.jsp or to acceptProposition.jsp
* depending on the user related rights.
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
* 17.5.2002 M.Ylitalo
* - Added sendmail to person who can accept proposition
*
****************************************************************************************************/
%>
<% String baseAdd="https://hartman.it.jyu.fi/kotka/koppelo/"; %>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%
/* check that we've got all parameters */
if (request.getParameter("title") == null ||
((String)request.getParameter("title")).equals("") ||
((String)request.getParameter("title")).equals("null") ) {
response.sendRedirect("error.jsp?page=proposeInsert&message=1");
return;
}
String title = request.getParameter("title");
String description="";
if (request.getParameter("description") != null) {
description = request.getParameter("description");
}
if (request.getParameter("proposeddate") == null) {
response.sendRedirect("error.jsp?page=proposeInsert&message=1");
return;
}
time timeformater = new time();
String proposeddate = timeformater.monthToDBFormat((String)request.getParameter("proposeddate"));
if (request.getParameter("validdays") == null) {
response.sendRedirect("error.jsp?page=proposeInsert&message=1");
return;
}
int validdays = Integer.parseInt((String)request.getParameter("validdays"));
if ( (request.getParameter("line") == null ) ||
(request.getParameter("type") == null ) ) {
response.sendRedirect("error.jsp?page=proposeInsert&message=1");
return;
}
%>
<%-- THESE THING WE CANT DO --%>
<%-- Check that we have acceptable validdays value
select maxtimeindb as resultdate from assignmenttype where typeid = <%=typeID%>;
int maxdays = Integer.parseInt((String)pageContext.getAttribute("maxvalid"));
if (validdays > maxdays ) validdays = maxdays;
if (0 < validdays) validdays = maxdays;
check the lineid:s range, do not execute query witch will fail
select max(lineid) as max, min(lineid) as min from studyline;
int maxLineID = Integer.parseInt((String)pageContext.getAttribute("maxid"));
int minLineID = Integer.parseInt((String)pageContext.getAttribute("minid"));
if (lineID > maxLineID ) { response.sendRedirect("errorProposeInsert.jsp?line=liianiso"); return; }
if (lineID < minLineID ) { response.sendRedirect("errorProposeInsert.jsp?line=liianpieni"); return; }
--%>
<%-- This query gives the last date for proposition --%>
select cast('<%=proposeddate%>' as date) + <%=validdays%> as resdate;
<% String validuntil = (String)pageContext.getAttribute("validuntil"); %>
<%-- This query gives the maximum id of table AssignmentOriginal
The result is saved into variable maxID --%>
<% boolean success = false; %>
select max(assignmentoriginal.originalid)+1 as newid
from assignmentoriginal;
<% String apu = (String)pageContext.getAttribute("maxid");
if ( apu != null ) success = true; %>
<% int maxID = 1;
if (success) maxID = Integer.parseInt((String)pageContext.getAttribute("maxid"));
%>
<%-- This query gives the maximum id of table AssignmentDetail
The result is saved into variable detailID --%>
<% success = false; %>
select MAX(assignmentdetail.detailid)+1 as newid
from assignmentdetail;
<% String apu = (String)pageContext.getAttribute("maxid");
if ( apu != null ) success = true; %>
<% int detailID =1;
if (success) detailID = Integer.parseInt((String)pageContext.getAttribute("maxid"));
%>
<%-- ---- THE ACTION BEGINS ------------------------------------------------- --%>
<%-- The following section executes the insert-commands --%>
<% try { %>
insert into assignmentoriginal
(deleted, originalid, proposeddate, proposedby, acceptedby,
accepteddate, validuntil, available) values
('false', <%=maxID%>, '<%=proposeddate%>', <%=personID%>, NULL,
NULL, '<%=validuntil%>', 0);
<% } catch (Exception wrongdate) {
response.sendRedirect("error.jsp?page=proposeInsert&message=2");
return;
}
%>
<%-- set the possible lines and types --%>
<%
if (request.getParameter("line") != null) {
String[] lines = new String[100];
lines = request.getParameterValues("line");
int i;
for (i=0; i < lines.length; i++) {
try {
%>
insert into assoriginalposline
(deleted, originalid, lineid) values
('false', <%=maxID%>, <%=lines[i]%>);
<%
} catch (Exception nullline) {} // no big deal if the user has selected null value
}
}
if (request.getParameter("type") != null) {
String[] types = new String[100];
types = request.getParameterValues("type");
int i;
for (i=0; i < types.length; i++) {
%>
insert into assoriginalpostype
(deleted, originalid, typeid) values
('false', <%=maxID%>, <%=types[i]%>);
<% }
}
%>
<%-- Insert title --%>
insert into assignmentdetail (deleted, detailid, typeid)
values ('false', <%=detailID%>, <%=titleID%>);
insert into assdetailtranslation (deleted, detailid, languageid, name)
values ('false', <%=detailID%>, <%=languageID%>, '<%=title%>');
insert into assoriginalreldetail (deleted, originalid, detailid)
values ('false', <%=maxID%>, <%=detailID%>);
<% detailID = detailID+1; %>
<%-- Insert description --%>
insert into assignmentdetail (deleted, detailid, typeid)
values ('false', <%=detailID%>, <%=descriptionID%>);
insert into assdetailtranslation (deleted, detailid, languageid, name)
values ('false', <%=detailID%>, <%=languageID%>, '<%=description%>');
insert into assoriginalreldetail (deleted, originalid, detailid)
values ('false', <%=maxID%>, <%=detailID%>);
<% detailID = detailID+1; %>
<%--
m<%=request.getParameter("keywords")%>m
--%>
<%-- Section for keywords --%>
<%
if ( request.getParameter("keywords") != null) {
int i=0;
int lkm=0;
int beg = 0;
int end = 0;
String [] keys = new String [100];
String key = request.getParameter("keywords");
while ( end < key.length() ) {
end = key.indexOf(",", beg);
if ( end < 0 ) end = key.length();
if (beg >= end ) break;
keys[i] = (key.substring(beg, end)).trim();
beg = end+1;
i++;
}
lkm = i;
for (i=0; i < lkm; i++) {
int keyid = 1;
success=false;
%>
select assignmentkeyword.keywordid as id
from asskeywordtranslation
where asskeywordtranslation.deleted = false
and asskeywordtranslation.languageid = <%=languageID%>
and lower(asskeywordtranslation.name) like lower('<%=keys[i]%>')
and asskeywordtranslation.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false;
<% String apu = (String)pageContext.getAttribute("keyid");
if ( apu != null ) success = true; %>
<%
if (success) { keyid = Integer.parseInt((String)pageContext.getAttribute("keyid")); }
else {
%>
select max(keywordid)+1 as max from assignmentkeyword;
<% String apu = (String)pageContext.getAttribute("keyid");
if ( apu != null ) success = true; %>
<% if (success) keyid = Integer.parseInt((String)pageContext.getAttribute("keyid")); %>
insert into assignmentkeyword
(deleted, keywordid) values
('false', <%=keyid%>);
insert into asskeywordtranslation
(deleted, keywordid, languageid, name) values
('false', <%=keyid%>, <%=languageID%>, '<%=keys[i]%>');
<% }
/* Finally update to relation table */
%>
insert into assoriginalrelkeyword
(deleted, originalid, keywordid) values
('false', <%=maxID%>, <%=keyid%>);
<%
}
}
%>
<%-- SEND EMAIL TO PERSON WHO CAN ACCEPT THE PROPOSITION (if necessary) --%>
<%
// MUISTA VAIHTAA OIKEA SENDMAIL-RIVI!!!
String to="ylimark@st.jyu.fi";
String message = "Opinnytteen aiheeksi on ehdotettu seuraavaa aihetta: "+title+"\n\nPset hyvksymn sen seuraavasta linkist:\n\n"+baseAdd+"acceptProposition.jsp?origid="+maxID+"\n\n\n";
%>
select distinct personparametervalue as address
from personparameter
where personparameter.personparametertypeid = 3
and asspersonrelright.deleted = false
and asspersonrelright.personid = personparameter.personid
and asspersonrelright.lineid IN (
select lineid
from assoriginalposline
where assoriginalposline.originalid = <%=maxID%>
and assoriginalposline.deleted = false )
and asspersonrelright.asstypeid IN (
select typeid
from assoriginalpostype
where assoriginalpostype.originalid = <%=maxID%>
and assoriginalpostype.deleted = false )
and asspersonrelright.rightid = <%=allowPropAccept%>;
<&-- Ota kommentit pois oikeaan versioon, ett viestit lhtee hyvksyjille, eik minulle!--%>
<%-- mail.sendMail( "koppelo@it.jyu.fi", (String)pageContext.getAttribute("address"), "Aihe-ehdotus: "+title, message ); --%>
<% mail.sendMail( "koppelo@it.jyu.fi", to, "Aihe-ehdotus: "+title, message+(String)pageContext.getAttribute("address") ); %>
<%-- redirect to page thanks.jsp or proposeAccept.jsp according to user's rights --%>
<% police.setDB(db);
if ( police.hasPersonRightOriginal(allowPropAccept, personID, maxID) ||
police.hasGroupRight(allowPropAccept, userAccessLevel)) {
response.sendRedirect("acceptProposition.jsp?origid="+maxID); return;
}
response.sendRedirect("proposeThanks.jsp?origid="+maxID);
%>
proposeRemove.jsp 0100774 0000061 0000310 00000014301 07475376603 014355 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: proposeRemove.jsp
* LANGUAGE: JSP
* DATE: 13.5.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Remove proposition from assigntmentoriginal
*
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
* 20.5.2002 M.Ylitalo
* - Added sendmail to proposer
****************************************************************************************************/
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?page=proposeConfirmRemove&message=1");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<% time timeformater = new time(); %>
<%-- Access right --%>
<% police.setDB(db);
boolean canAccept = false;
boolean canUpdate = false;
if ( police.hasPersonRightOriginal(allowPropAccept, personID, origID) ||
police.hasGroupRight(allowPropAccept, userAccessLevel) ) {
canAccept = true;
canUpdate = true;
}
if ( !canAccept && !canUpdate ) { // if both are false then redirect
response.sendRedirect("errorNoAccess.jsp");
return;
}
try {
%>
update assignmentoriginal
set deleted = true
where assignmentoriginal.originalid = <%=origID%>
<% } catch (Exception e) {} %>
<%-- TSS LHTEE HYLKYSVIESTI AIHEEN EHDOTTAJALLE --%>
<% String from ="nobody&it.jyu.fi";
String to ="nobody&it.jyu.fi";
String title ="AIHE";
String description="KUVAUS";
%>
select name as title
from assdetailtranslation
where languageid = <%=languageID%>
and detailid = (
select assignmentdetail.detailid
from assignmentdetail
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=titleID%>
);
<%
if ( pageContext.getAttribute("title") != null )
title=(String)pageContext.getAttribute("title");
%>
select name as description
from assdetailtranslation
where languageid = <%=languageID%>
and detailid = (
select assignmentdetail.detailid
from assignmentdetail
where assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.typeid = <%=descriptionID%>
);
<%
if ( pageContext.getAttribute("description") != null )
description=(String)pageContext.getAttribute("description");
%>
select personparametervalue as add
from personparameter
where personparametertypeid = 3
and personparameter.personid = assignmentoriginal.proposedby
and assignmentoriginal.originalid = <%=origID%>
<% if ( pageContext.getAttribute("add") != null)
to=(String)pageContext.getAttribute("add");
%>
<%
String message = "";
if ( session.getAttribute("message") != null)
message = (String)session.getAttribute("message");
%>
select personparameter.personparametervalue as address,
person.callname as firstname,
person.lastname as lastname,
current_date as day
from personparameter, person
where personparameter.personparametertypeid = 3
and personparameter.personid = person.personid
and person.personid = <%=personID%>
<% if ( pageContext.getAttribute("address") != null)
from=(String)pageContext.getAttribute("address");
mail.sendMail( "koppelo@mit.jyu.fi", to, title,
"TM ON AUTOMAATTINEN VIESTI KOPPELO-JRJESTELMST.\n\n\nAihe-ehdotuksesi on hyltty.\n\nOtsikko: "+title+"\nKuvaus:\n"+description+
"\n\n\n\nKsittelijn "+ (String)pageContext.getAttribute("firstname") + " "+ (String)pageContext.getAttribute("lastname")+
", "+ timeformater.monthToOutFormat((String)pageContext.getAttribute("day")) + "\n" + from + "\n\n"+ message );
%>
<%
response.sendRedirect((String)request.getParameter("redirect")+".jsp");
%>
proposeThanks.jsp 0100774 0000061 0000310 00000003526 07475376603 014357 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: proposeThanks.jsp
* LANGUAGE: JSP
* DATE: 10.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Need I say more...
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("error.jsp?message=1&page=proposeThanks");
return;
}
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
Kiitos aihe-ehdotuksesta!
Aihe-ehdotuksesi on tallennettu. Pset muuttamaan ehdottamasi aiheen tietoja
">tst.
<%@ include file="/shared/pageEnd.inc" %>
propositionDetail.jsp 0100774 0000061 0000310 00000010764 07475376603 015231 0 ustar tomcat wwwadmin <%
/***************************************************************************************************
* PAGE DESCRIPTION
****************************************************************************************************
*
* NAME: assignmentUpdate.jsp
* LANGUAGE: JSP
* DATE: 22.4.2002
* AUTHOR: Minna Hillebrand, University of Jyvskyl (JYU)
* PURPOSE: Maintain assignment related information
*
****************************************************************************************************
* COPYRIGHT (C) KOPPELO PROJECT GROUP
* Limited rights granted. Please refer to GNU General Public License
* http://www.gnu.org/licenses/gpl.html
****************************************************************************************************
****************************************************************************************************
* UPDATES
****************************************************************************************************
*
*
*
****************************************************************************************************/
%>
<%@ include file="/shared/beans.inc" %>
<%@ include file="/shared/constants.inc" %>
<%@ include file="/shared/dbconnect.inc" %>
<%-- Check that user is allowed !!! tauluista roledepright, persondepright --%>
<%
/* No relation to database is needed because every KOTKA users are allowed to see this page */
if ( userAccessLevel < studentID ) { response.sendRedirect("errorNoAccess.jsp"); return; }
%>
<%
if (request.getParameter("origid") == null) {
response.sendRedirect("errorProposeDetail.jsp?origid=bad");
return;
}
int origID = Integer.parseInt(request.getParameter("origid"));
%>
<%@ include file="/shared/header.inc" %>
<%@ include file="/shared/menus.inc" %>
Aihe-ehdotuksen tiedot
Tm sivu pitisi nky vain henkilkunnalle, oikeuksia ei viel tehty
Opinnytteen aihe-ehdotuksen yleiset tiedot
select assdetailtranslation.name as name,
descriptiontypetranslation.name as typename
from assoriginalreldetail
where assoriginalreldetail.deleted = false
and assoriginalreldetail.originalid = <%=origID%>
and assoriginalreldetail.detailid = assignmentdetail.detailid
and assignmentdetail.deleted = false
and assignmentdetail.typeid = descriptiontypetranslation.descriptiontypeid
and descriptiontype.descriptiontypeid = descriptiontypetranslation.descriptiontypeid
and descriptiontypetranslation.languageid = <%=languageID%>
and assoriginalreldetail.detailid = assdetailtranslation.detailid
and assdetailtranslation.languageid = <%=languageID%>
order by descriptiontype.ordernum;
Avainsanat
select asskeywordtranslation.name as name
from assoriginalrelkeyword
where assoriginalrelkeyword.deleted = false
and assoriginalrelkeyword.originalid = <%=origID%>
and assoriginalrelkeyword.keywordid = assignmentkeyword.keywordid
and assignmentkeyword.deleted = false
and assignmentkeyword.keywordid = asskeywordtranslation.keywordid
and asskeywordtranslation.languageid = <%=languageID%>
<%-- order by descriptiontype.ordernum; --%>
select assignmentoriginal.proposeddate as pdate,
person.firstnames || ' ' || person.lastname as pby
from assignmentoriginal, person
where assignmentoriginal.originalid = <%=origID%>
and assignmentoriginal.deleted = false
and person.personid = assignmentoriginal.proposedby