| "+htmlEscape(showCell(-2,-1,0),true)+" | "; + for (var i=col0; i"; + } + } + } + out += " |
|---|---|
| "+htmlEscape(showCell(-1,-1,0),true)+" | "; + for (var i=col0; i"+htmlEscape(getCells(row,col,0),true)+" | "; + } else { + out += ""+htmlEscape(getCells(row,col,1),true)+" | "; + } + } + out += ""; + } + out += "
| "; + for (var i=col0; i |
+ * + *
java.lang.Object
+ */
+ public Object clone(){
+
+ SpreadsheetUser user = null;
+ try{
+ user = (SpreadsheetUser) super.clone();
+ user.setUid(null);
+ //never clone session
+ user.setSession(null);
+ } catch (CloneNotSupportedException e) {
+ log.error("When clone " + SpreadsheetUser.class + " failed");
+ }
+
+ return user;
+ }
+// **********************************************************
+ // Get/Set methods
+// **********************************************************
+ /**
+ * @hibernate.id generator-class="native" type="java.lang.Long" column="uid"
+ * @return Returns the uid.
+ */
+ public Long getUid() {
+ return uid;
+ }
+ /**
+ * @param uid The uid to set.
+ */
+ public void setUid(Long userID) {
+ this.uid = userID;
+ }
+
+ /**
+ * @hibernate.property column="user_id" length="20"
+ * @return Returns the userId.
+ */
+ public Long getUserId() {
+ return userId;
+ }
+ /**
+ * @param userId
+ * The userId to set.
+ */
+ public void setUserId(Long userID) {
+ this.userId = userID;
+ }
+
+ /**
+ * @hibernate.property length="255" column="last_name"
+ * @return
+ */
+ public String getLastName() {
+ return lastName;
+ }
+ public void setLastName(String lastName) {
+ this.lastName = lastName;
+ }
+ /**
+ * @hibernate.property length="255" column="first_name"
+ * @return
+ */
+ public String getFirstName() {
+ return firstName;
+ }
+ public void setFirstName(String firstName) {
+ this.firstName = firstName;
+ }
+
+
+ /**
+ * @hibernate.property column="login_name"
+ * @return
+ */
+ public String getLoginName() {
+ return loginName;
+ }
+
+ public void setLoginName(String loginName) {
+ this.loginName = loginName;
+ }
+ /**
+ * @hibernate.many-to-one column="session_uid"
+ * cascade="none"
+ * @return
+ */
+ public SpreadsheetSession getSession() {
+ return session;
+ }
+
+ public void setSession(SpreadsheetSession session) {
+ this.session = session;
+ }
+ /**
+ * @hibernate.many-to-one column="spreadsheet_uid"
+ * cascade="none"
+ * @return
+ */
+ public Spreadsheet getSpreadsheet() {
+ return spreadsheet;
+ }
+ public void setSpreadsheet(Spreadsheet spreadsheet) {
+ this.spreadsheet = spreadsheet;
+ }
+ /**
+ * @hibernate.many-to-one column="user_edited_spreadsheet_uid"
+ * cascade="all"
+ *
+ * @return
+ */
+ public UserEditedSpreadsheet getUserEditedSpreadsheet() {
+ return userEditedSpreadsheet;
+ }
+ public void setUserEditedSpreadsheet(UserEditedSpreadsheet userEditedSpreadsheet) {
+ this.userEditedSpreadsheet = userEditedSpreadsheet;
+ }
+ /**
+ * @hibernate.property column="session_finished"
+ * @return
+ */
+ public boolean isSessionFinished() {
+ return sessionFinished;
+ }
+
+ public void setSessionFinished(boolean sessionFinished) {
+ this.sessionFinished = sessionFinished;
+ }
+
+ public boolean equals(Object obj) {
+ if (this == obj)
+ return true;
+ if (!(obj instanceof SpreadsheetUser))
+ return false;
+
+ final SpreadsheetUser user = (SpreadsheetUser) obj;
+
+ return new EqualsBuilder().append(this.uid, user.uid).append(this.firstName, user.firstName)
+ .append(this.lastName,user.lastName).append(this.loginName, user.loginName).isEquals();
+
+ }
+
+ public int hashCode() {
+ return new HashCodeBuilder().append(uid).append(firstName)
+ .append(lastName).append(loginName)
+ .toHashCode();
+ }
+ public Date getAccessDate() {
+ return accessDate;
+ }
+ public void setAccessDate(Date accessDate) {
+ this.accessDate = accessDate;
+ }
+
+
+}
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/model/UserEditedSpreadsheet.hbm.xml
===================================================================
diff -u
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/model/UserEditedSpreadsheet.hbm.xml (revision 0)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/model/UserEditedSpreadsheet.hbm.xml (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,44 @@
+
+
+
+
+Spreadsheet by toolContentID.
+ * @param contentId
+ * @return
+ */
+ Spreadsheet getSpreadsheetByContentId(Long contentId);
+ /**
+ * Get a cloned copy of tool default tool content (Spreadsheet) and assign the toolContentId of that copy as the
+ * given contentId
+ * @param contentId
+ * @return
+ * @throws SpreadsheetApplicationException
+ */
+ Spreadsheet getDefaultContent(Long contentId) throws SpreadsheetApplicationException;
+
+ /**
+ * Upload instruciton file into repository.
+ * @param file
+ * @param type
+ * @return
+ * @throws UploadSpreadsheetFileException
+ */
+ SpreadsheetAttachment uploadInstructionFile(FormFile file, String type) throws UploadSpreadsheetFileException;
+
+ //********** user methods *************
+ /**
+ * Save or update SpreadsheetUser in database, mostly for saving userEditedSpreadsheet.
+ *
+ * @param user user which did modifications to spreadsheet
+ */
+ void saveOrUpdateUser(SpreadsheetUser spreadsheetUser);
+
+ /**
+ * Get user by given userID and toolContentID.
+ * @param long1
+ * @return
+ */
+ SpreadsheetUser getUserByIDAndContent(Long userID, Long contentId);
+
+ /**
+ * Get user by sessionID and UserID
+ * @param long1
+ * @param sessionId
+ * @return
+ */
+ SpreadsheetUser getUserByIDAndSession(Long long1, Long sessionId);
+
+// /**
+// * Get user list by sessionId and itemUid
+// *
+// * @param sessionId
+// * @param uid
+// * @return
+// */
+// ListSummary list according to sessionId and skipHide flag.
+ *
+ * @param sessionId
+ * @param skipHide true, don't get spreadsheet item if its isHide flag is true.
+ * Otherwise, get all spreadsheet item
+ * @return
+ */
+ public ListTicket to login and access the Content Repository.
+ *
+ * A valid ticket is needed in order to access the content from the
+ * repository. This method would be called evertime the tool needs to
+ * upload/download files from the content repository.
+ *
+ * @return ITicket The ticket for repostory access
+ * @throws SpreadsheetApplicationException
+ */
+ private ITicket getRepositoryLoginTicket() throws SpreadsheetApplicationException {
+ ICredentials credentials = new SimpleCredentials(
+ spreadsheetToolContentHandler.getRepositoryUser(),
+ spreadsheetToolContentHandler.getRepositoryId());
+ try {
+ ITicket ticket = repositoryService.login(credentials,
+ spreadsheetToolContentHandler.getRepositoryWorkspaceName());
+ return ticket;
+ } catch (AccessDeniedException ae) {
+ throw new SpreadsheetApplicationException("Access Denied to repository."
+ + ae.getMessage());
+ } catch (WorkspaceNotFoundException we) {
+ throw new SpreadsheetApplicationException("Workspace not found."
+ + we.getMessage());
+ } catch (LoginException e) {
+ throw new SpreadsheetApplicationException("Login failed." + e.getMessage());
+ }
+ }
+
+
+ public Spreadsheet getSpreadsheetByContentId(Long contentId) {
+ Spreadsheet rs = spreadsheetDao.getByContentId(contentId);
+ if(rs == null){
+ log.error("Could not find the content by given ID:"+contentId);
+ }
+ return rs;
+ }
+
+
+ public Spreadsheet getDefaultContent(Long contentId) throws SpreadsheetApplicationException {
+ if (contentId == null)
+ {
+ String error=messageService.getMessage("error.msg.default.content.not.find");
+ log.error(error);
+ throw new SpreadsheetApplicationException(error);
+ }
+
+ Spreadsheet defaultContent = getDefaultSpreadsheet();
+ //save default content by given ID.
+ Spreadsheet content = new Spreadsheet();
+ content = Spreadsheet.newInstance(defaultContent,contentId,spreadsheetToolContentHandler);
+ return content;
+ }
+
+ public SpreadsheetAttachment uploadInstructionFile(FormFile uploadFile, String fileType) throws UploadSpreadsheetFileException {
+ if(uploadFile == null || StringUtils.isEmpty(uploadFile.getFileName()))
+ throw new UploadSpreadsheetFileException(messageService.getMessage("error.msg.upload.file.not.found",new Object[]{uploadFile}));
+
+ //upload file to repository
+ NodeKey nodeKey = processFile(uploadFile,fileType);
+
+ //create new attachement
+ SpreadsheetAttachment file = new SpreadsheetAttachment();
+ file.setFileType(fileType);
+ file.setFileUuid(nodeKey.getUuid());
+ file.setFileVersionId(nodeKey.getVersion());
+ file.setFileName(uploadFile.getFileName());
+ file.setCreated(new Date());
+
+ return file;
+ }
+
+ public void saveOrUpdateUser(SpreadsheetUser spreadsheetUser) {
+ spreadsheetUserDao.saveObject(spreadsheetUser);
+ }
+
+ public SpreadsheetUser getUserByIDAndContent(Long userId, Long contentId) {
+ return (SpreadsheetUser) spreadsheetUserDao.getUserByUserIDAndContentID(userId,contentId);
+ }
+
+ public SpreadsheetUser getUserByIDAndSession(Long userId, Long sessionId) {
+ return (SpreadsheetUser) spreadsheetUserDao.getUserByUserIDAndSessionID(userId,sessionId);
+ }
+
+// public ListThis class act as the proxy between web layer and service layer. It is + * designed to decouple the presentation logic and business logic completely. + * In this way, the presentation tier will no longer be aware of the changes in + * service layer. Therefore we can feel free to switch the business logic + * implementation.
+ */ +public class SpreadsheetServiceProxy +{ + /** + * Return the domain service object. It will delegate to the Spring + * helper method to retrieve the proper bean from Spring bean factory. + * @param servletContext the servletContext for current application + * @return Shared spreadsheet service object. + */ + public static final ISpreadsheetService getSpreadsheetService(ServletContext servletContext) + { + return (ISpreadsheetService)getSpreadsheetDomainService(servletContext); + } + + public static final ToolSessionManager getSessionManager(ServletContext servletContext) + { + return (ToolSessionManager)getSpreadsheetDomainService(servletContext); + } + + public static final ToolContentManager getContentManager(ServletContext servletContext) + { + return (ToolContentManager)getSpreadsheetDomainService(servletContext); + } + + private static Object getSpreadsheetDomainService(ServletContext servletContext) + { + WebApplicationContext wac = WebApplicationContextUtils.getRequiredWebApplicationContext(servletContext); + return wac.getBean(SpreadsheetConstants.RESOURCE_SERVICE); + } + +} Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/service/UploadSpreadsheetFileException.java =================================================================== diff -u --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/service/UploadSpreadsheetFileException.java (revision 0) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/service/UploadSpreadsheetFileException.java (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,48 @@ +/**************************************************************** + * Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) + * ============================================================= + * License Information: http://lamsfoundation.org/licensing/lams/2.0/ + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 + * USA + * + * http://www.gnu.org/licenses/gpl.txt + * **************************************************************** + */ +/* $$Id$$ */ +package org.lamsfoundation.lams.tool.spreadsheet.service; + +public class UploadSpreadsheetFileException extends Exception{ + + public UploadSpreadsheetFileException() { + super(); + + } + + public UploadSpreadsheetFileException(String message, Throwable cause) { + super(message, cause); + + } + + public UploadSpreadsheetFileException(String message) { + super(message); + + } + + public UploadSpreadsheetFileException(Throwable cause) { + super(cause); + + } + +} Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/spreadsheetApplicationContext.xml =================================================================== diff -u --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/spreadsheetApplicationContext.xml (revision 0) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/spreadsheetApplicationContext.xml (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,136 @@ + + + +-
+
java.util.List from HttpSession by given name.
+ *
+ * @param request
+ * @param name
+ * @return
+ */
+ private List getListFromSession(SessionMap sessionMap,String name) {
+ List list = (List) sessionMap.get(name);
+ if(list == null){
+ list = new ArrayList();
+ sessionMap.put(name,list);
+ }
+ return list;
+ }
+
+ /**
+ * Get ToolAccessMode from HttpRequest parameters. Default value is AUTHOR mode.
+ * @param request
+ * @return
+ */
+ private ToolAccessMode getAccessMode(HttpServletRequest request) {
+ ToolAccessMode mode;
+ String modeStr = request.getParameter(AttributeNames.ATTR_MODE);
+ if(StringUtils.equalsIgnoreCase(modeStr,ToolAccessMode.TEACHER.toString()))
+ mode = ToolAccessMode.TEACHER;
+ else
+ mode = ToolAccessMode.AUTHOR;
+ return mode;
+ }
+
+
+ private ActionMessages validate(SpreadsheetForm spreadsheetForm, ActionMapping mapping, HttpServletRequest request) {
+ ActionMessages errors = new ActionMessages();
+// if (StringUtils.isBlank(spreadsheetForm.getSpreadsheet().getTitle())) {
+// ActionMessage error = new ActionMessage("error.resource.item.title.blank");
+// errors.add(ActionMessages.GLOBAL_MESSAGE, error);
+// }
+
+ //define it later mode(TEACHER) skip below validation.
+ String modeStr = request.getParameter(AttributeNames.ATTR_MODE);
+ if(StringUtils.equals(modeStr, ToolAccessMode.TEACHER.toString())){
+ return errors;
+ }
+
+ //Some other validation outside basic Tab.
+
+ return errors;
+ }
+
+}
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/ClearSessionAction.java
===================================================================
diff -u
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/ClearSessionAction.java (revision 0)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/ClearSessionAction.java (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,50 @@
+/****************************************************************
+ * Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org)
+ * =============================================================
+ * License Information: http://lamsfoundation.org/licensing/lams/2.0/
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License version 2.0
+ * as published by the Free Software Foundation.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
+ * USA
+ *
+ * http://www.gnu.org/licenses/gpl.txt
+ * ****************************************************************
+ */
+
+/* $Id$ */
+package org.lamsfoundation.lams.tool.spreadsheet.web.action;
+
+import javax.servlet.http.HttpSession;
+
+import org.lamsfoundation.lams.authoring.web.LamsAuthoringFinishAction;
+import org.lamsfoundation.lams.tool.ToolAccessMode;
+import org.lamsfoundation.lams.tool.spreadsheet.SpreadsheetConstants;
+import org.lamsfoundation.lams.web.util.AttributeNames;
+
+/**
+ * This class give a chance to clear HttpSession when user save/close authoring page.
+ * @author Steve.Ni
+ *
+ * @version $Revision$
+ */
+public class ClearSessionAction extends LamsAuthoringFinishAction {
+
+ @Override
+ public void clearSession(String customiseSessionID, HttpSession session, ToolAccessMode mode) {
+ if(mode.isAuthor()){
+ session.removeAttribute(customiseSessionID);
+ }
+ }
+
+
+}
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/LearningAction.java
===================================================================
diff -u
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/LearningAction.java (revision 0)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/LearningAction.java (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,453 @@
+/****************************************************************
+ * Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org)
+ * =============================================================
+ * License Information: http://lamsfoundation.org/licensing/lams/2.0/
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License version 2.0
+ * as published by the Free Software Foundation.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
+ * USA
+ *
+ * http://www.gnu.org/licenses/gpl.txt
+ * ****************************************************************
+ */
+
+/* $Id$ */
+package org.lamsfoundation.lams.tool.spreadsheet.web.action;
+
+import java.io.IOException;
+import java.sql.Timestamp;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.HashSet;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Set;
+import java.util.SortedSet;
+import java.util.TreeSet;
+
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
+
+import org.apache.commons.beanutils.PropertyUtils;
+import org.apache.commons.lang.StringUtils;
+import org.apache.log4j.Logger;
+import org.apache.struts.action.Action;
+import org.apache.struts.action.ActionErrors;
+import org.apache.struts.action.ActionForm;
+import org.apache.struts.action.ActionForward;
+import org.apache.struts.action.ActionMapping;
+import org.apache.struts.action.ActionMessage;
+import org.apache.struts.action.ActionMessages;
+import org.apache.struts.action.ActionRedirect;
+import org.apache.struts.config.ForwardConfig;
+import org.lamsfoundation.lams.notebook.model.NotebookEntry;
+import org.lamsfoundation.lams.notebook.service.CoreNotebookConstants;
+import org.lamsfoundation.lams.tool.ToolAccessMode;
+import org.lamsfoundation.lams.tool.spreadsheet.SpreadsheetConstants;
+import org.lamsfoundation.lams.tool.spreadsheet.model.Spreadsheet;
+import org.lamsfoundation.lams.tool.spreadsheet.model.SpreadsheetAttachment;
+import org.lamsfoundation.lams.tool.spreadsheet.model.SpreadsheetSession;
+import org.lamsfoundation.lams.tool.spreadsheet.model.SpreadsheetUser;
+import org.lamsfoundation.lams.tool.spreadsheet.model.UserEditedSpreadsheet;
+import org.lamsfoundation.lams.tool.spreadsheet.service.ISpreadsheetService;
+import org.lamsfoundation.lams.tool.spreadsheet.service.SpreadsheetApplicationException;
+import org.lamsfoundation.lams.tool.spreadsheet.service.UploadSpreadsheetFileException;
+import org.lamsfoundation.lams.tool.spreadsheet.web.form.ReflectionForm;
+import org.lamsfoundation.lams.tool.spreadsheet.web.form.SpreadsheetForm;
+import org.lamsfoundation.lams.usermanagement.dto.UserDTO;
+import org.lamsfoundation.lams.util.FileUtil;
+import org.lamsfoundation.lams.util.FileValidatorUtil;
+import org.lamsfoundation.lams.util.WebUtil;
+import org.lamsfoundation.lams.web.session.SessionManager;
+import org.lamsfoundation.lams.web.util.AttributeNames;
+import org.lamsfoundation.lams.web.util.SessionMap;
+import org.springframework.web.context.WebApplicationContext;
+import org.springframework.web.context.support.WebApplicationContextUtils;
+/**
+ *
+ * @author Steve.Ni
+ *
+ * @version $Revision$
+ */
+public class LearningAction extends Action {
+
+ private static Logger log = Logger.getLogger(LearningAction.class);
+
+ public ActionForward execute(ActionMapping mapping, ActionForm form,
+ HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
+
+ String param = mapping.getParameter();
+ //-----------------------Spreadsheet Learner function ---------------------------
+ if(param.equals("start")){
+ return start(mapping, form, request, response);
+ }
+ if (param.equals("initPage")) {
+ return initPage(mapping, form, request, response);
+ }
+ if (param.equals("saveUserSpreadsheet")) {
+ return saveUserSpreadsheet(mapping, form, request, response);
+ }
+ if(param.equals("finish")){
+ return finish(mapping, form, request, response);
+ }
+
+ //================ Reflection =======================
+ if (param.equals("newReflection")) {
+ return newReflection(mapping, form, request, response);
+ }
+ if (param.equals("submitReflection")) {
+ return submitReflection(mapping, form, request, response);
+ }
+
+ return mapping.findForward(SpreadsheetConstants.ERROR);
+ }
+
+ /**
+ * Read spreadsheet data from database and put them into HttpSession. It will redirect to init.do directly after this
+ * method run successfully.
+ *
+ * This method will avoid read database again and lost un-saved resouce item lost when user "refresh page",
+ *
+ */
+ private ActionForward start(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+
+ //initial Session Map
+ SessionMap sessionMap = new SessionMap();
+ request.getSession().setAttribute(sessionMap.getSessionID(), sessionMap);
+
+ //save toolContentID into HTTPSession
+ ToolAccessMode mode = WebUtil.readToolAccessModeParam(request,AttributeNames.PARAM_MODE, true);
+
+ Long sessionId = new Long(request.getParameter(SpreadsheetConstants.PARAM_TOOL_SESSION_ID));
+
+ request.setAttribute(SpreadsheetConstants.ATTR_SESSION_MAP_ID, sessionMap.getSessionID());
+ request.setAttribute(AttributeNames.ATTR_MODE,mode);
+ request.setAttribute(AttributeNames.PARAM_TOOL_SESSION_ID,sessionId);
+
+// get back the spreadsheet and item list and display them on page
+ ISpreadsheetService service = getSpreadsheetService();
+ SpreadsheetUser spreadsheetUser = null;
+ if ( mode != null && mode.isTeacher() ) {
+ // monitoring mode - user is specified in URL
+ // spreadsheetUser may be null if the user was force completed.
+ spreadsheetUser = getSpecifiedUser(service, sessionId,
+ WebUtil.readIntParam(request, AttributeNames.PARAM_USER_ID, false));
+ } else {
+ spreadsheetUser = getCurrentUser(service,sessionId);
+ }
+
+ Spreadsheet spreadsheet;
+ spreadsheet = service.getSpreadsheetBySessionId(sessionId);
+
+
+
+// SpreadsheetForm spreadsheetForm = (SpreadsheetForm)form;
+// spreadsheetForm.setSessionMapID(sessionMap.getSessionID());
+// spreadsheetForm.setSpreadsheet(spreadsheet);
+// sessionMap.put(SpreadsheetConstants.ATTR_RESOURCE_FORM, spreadsheetForm);
+// request.setAttribute("spreadsheet.code", spreadsheet.getCode());
+
+
+
+ //check whehter finish lock is on/off
+ boolean lock = spreadsheet.getLockWhenFinished() && spreadsheetUser !=null && spreadsheetUser.isSessionFinished();
+
+ // get notebook entry
+ String entryText = new String();
+ if ( spreadsheetUser != null ) {
+ NotebookEntry notebookEntry = service.getEntry(sessionId, CoreNotebookConstants.NOTEBOOK_TOOL,
+ SpreadsheetConstants.TOOL_SIGNATURE, spreadsheetUser.getUserId().intValue());
+ if (notebookEntry != null) {
+ entryText = notebookEntry.getEntry();
+ }
+ }
+
+ //basic information
+ sessionMap.put(SpreadsheetConstants.ATTR_TITLE,spreadsheet.getTitle());
+ sessionMap.put(SpreadsheetConstants.ATTR_RESOURCE_INSTRUCTION,spreadsheet.getInstructions());
+ sessionMap.put(SpreadsheetConstants.ATTR_FINISH_LOCK, lock);
+ sessionMap.put(SpreadsheetConstants.ATTR_LOCK_ON_FINISH, spreadsheet.getLockWhenFinished());
+ sessionMap.put(SpreadsheetConstants.ATTR_USER_FINISHED, spreadsheetUser !=null && spreadsheetUser.isSessionFinished());
+
+ sessionMap.put(AttributeNames.PARAM_TOOL_SESSION_ID,sessionId);
+ sessionMap.put(AttributeNames.ATTR_MODE,mode);
+ //reflection information
+ sessionMap.put(SpreadsheetConstants.ATTR_REFLECTION_ON,spreadsheet.isReflectOnActivity());
+ sessionMap.put(SpreadsheetConstants.ATTR_REFLECTION_INSTRUCTION,spreadsheet.getReflectInstructions());
+ sessionMap.put(SpreadsheetConstants.ATTR_REFLECTION_ENTRY, entryText);
+
+ //add define later support
+ if(spreadsheet.isDefineLater()){
+ return mapping.findForward("defineLater");
+ }
+
+ //set contentInUse flag to true!
+ spreadsheet.setContentInUse(true);
+ spreadsheet.setDefineLater(false);
+ service.saveOrUpdateSpreadsheet(spreadsheet);
+
+ //add run offline support
+ if(spreadsheet.getRunOffline()){
+ sessionMap.put(SpreadsheetConstants.PARAM_RUN_OFFLINE, true);
+ return mapping.findForward("runOffline");
+ }else
+ sessionMap.put(SpreadsheetConstants.PARAM_RUN_OFFLINE, false);
+
+ sessionMap.put(SpreadsheetConstants.ATTR_RESOURCE,spreadsheet);
+
+ return mapping.findForward(SpreadsheetConstants.SUCCESS);
+ }
+
+ /**
+ * Display same entire authoring page content from HttpSession variable.
+ * @param mapping
+ * @param form
+ * @param request
+ * @param response
+ * @return
+ * @throws ServletException
+ */
+ private ActionForward initPage(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws ServletException {
+ String sessionMapID = WebUtil.readStrParam(request, SpreadsheetConstants.ATTR_SESSION_MAP_ID);
+ SessionMap sessionMap = (SessionMap)request.getSession().getAttribute(sessionMapID);
+// SpreadsheetForm existForm = (SpreadsheetForm) sessionMap.get(SpreadsheetConstants.ATTR_RESOURCE_FORM);
+
+ //get mode and ToolSessionID from sessionMAP
+ ToolAccessMode mode = getAccessMode(request);
+ Long sessionId = (Long) sessionMap.get(AttributeNames.PARAM_TOOL_SESSION_ID);
+ //load up learner changes in spreadsheet if such option is activated in spreadsheet
+ ISpreadsheetService service = getSpreadsheetService();
+ Spreadsheet spreadsheet = (Spreadsheet) sessionMap.get(SpreadsheetConstants.ATTR_RESOURCE);
+ if(spreadsheet.isLearnerAllowedToSave() && !mode.isTeacher()){
+ SpreadsheetUser spreadsheetUser = getCurrentUser(service, sessionId);
+ if (spreadsheetUser.getUserEditedSpreadsheet() != null) {
+ spreadsheet.setCode(spreadsheetUser.getUserEditedSpreadsheet().getUserEditedSpreadsheet());
+ }
+ }
+
+
+
+// request.setAttribute(SpreadsheetConstants.ATTR_CODE, spreadsheet.getCode());
+// SpreadsheetForm spreadsheetForm = (SpreadsheetForm )form;
+// try {
+// PropertyUtils.copyProperties(spreadsheetForm, existForm);
+// } catch (Exception e) {
+// throw new ServletException(e);
+// }
+//
+ SpreadsheetForm spreadsheetForm = (SpreadsheetForm)form;
+// spreadsheetForm.setSessionMapID(sessionMap.getSessionID());
+ spreadsheetForm.setSpreadsheet(spreadsheet);
+// sessionMap.put(SpreadsheetConstants.ATTR_RESOURCE_FORM, spreadsheetForm);
+// request.setAttribute("spreadsheet.code", spreadsheet.getCode());
+
+
+
+
+ if(mode.isAuthor()) {
+ return mapping.findForward(SpreadsheetConstants.SUCCESS);
+ } else {
+ return mapping.findForward(SpreadsheetConstants.DEFINE_LATER);
+ }
+ }
+
+ /**
+ * Finish learning session.
+ * @param mapping
+ * @param form
+ * @param request
+ * @param response
+ * @return
+ */
+ private ActionForward saveUserSpreadsheet(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+
+ //get back SessionMap
+ String sessionMapID = request.getParameter(SpreadsheetConstants.ATTR_SESSION_MAP_ID);
+ SessionMap sessionMap = (SessionMap) request.getSession().getAttribute(sessionMapID);
+
+ //get mode and ToolSessionID from sessionMAP
+ ToolAccessMode mode = (ToolAccessMode) sessionMap.get(AttributeNames.ATTR_MODE);
+ Long sessionId = (Long) sessionMap.get(AttributeNames.PARAM_TOOL_SESSION_ID);
+
+ //save learner changes in spreadsheet if such option is activated in spreadsheet
+ ISpreadsheetService service = getSpreadsheetService();
+ Spreadsheet spreadsheet = (Spreadsheet) sessionMap.get(SpreadsheetConstants.ATTR_RESOURCE);
+ Spreadsheet spreadsheetPO = service.getSpreadsheetByContentId(spreadsheet.getContentId());
+ if(spreadsheetPO.isLearnerAllowedToSave() && !mode.isTeacher()){
+
+ SpreadsheetUser spreadsheetUser = getCurrentUser(service,sessionId);
+ UserEditedSpreadsheet userEditedSpreadsheet = new UserEditedSpreadsheet();
+ String code = ((SpreadsheetForm)form).getSpreadsheet().getCode();
+ userEditedSpreadsheet.setUserEditedSpreadsheet(code);
+ spreadsheetUser.setUserEditedSpreadsheet(userEditedSpreadsheet);
+ service.saveOrUpdateUser(spreadsheetUser);
+ }
+
+ boolean finishSession = WebUtil.readBooleanParam(request, "finishSession");
+ ForwardConfig conf = finishSession ? mapping.findForwardConfig("finishSession") : mapping.findForwardConfig("continueReflect");
+ ActionRedirect redirect = new ActionRedirect(conf);
+ redirect.addParameter(SpreadsheetConstants.ATTR_SESSION_MAP_ID, sessionMapID);
+ redirect.addParameter(AttributeNames.PARAM_TOOL_SESSION_ID, sessionId);
+ return redirect;
+ }
+
+ /**
+ * Finish learning session.
+ * @param mapping
+ * @param form
+ * @param request
+ * @param response
+ * @return
+ */
+ private ActionForward finish(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+
+ //get back SessionMap
+ String sessionMapID = request.getParameter(SpreadsheetConstants.ATTR_SESSION_MAP_ID);
+ SessionMap sessionMap = (SessionMap) request.getSession().getAttribute(sessionMapID);
+
+ //get mode and ToolSessionID from sessionMAP
+ Long sessionId = (Long) sessionMap.get(AttributeNames.PARAM_TOOL_SESSION_ID);
+
+ ISpreadsheetService service = getSpreadsheetService();
+ // get sessionId from HttpServletRequest
+ String nextActivityUrl = null ;
+ try {
+ HttpSession ss = SessionManager.getSession();
+ UserDTO userDTO = (UserDTO) ss.getAttribute(AttributeNames.USER);
+ Long userID = new Long(userDTO.getUserID().longValue());
+
+ nextActivityUrl = service.finishToolSession(sessionId,userID);
+ request.setAttribute(SpreadsheetConstants.ATTR_NEXT_ACTIVITY_URL,nextActivityUrl);
+ } catch (SpreadsheetApplicationException e) {
+ log.error("Failed get next activity url:" + e.getMessage());
+ }
+
+ return mapping.findForward(SpreadsheetConstants.SUCCESS);
+ }
+
+ /**
+ * Display empty reflection form.
+ * @param mapping
+ * @param form
+ * @param request
+ * @param response
+ * @return
+ */
+ private ActionForward newReflection(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+
+ //get session value
+ String sessionMapID = WebUtil.readStrParam(request, SpreadsheetConstants.ATTR_SESSION_MAP_ID);
+
+ ReflectionForm refForm = (ReflectionForm) form;
+ HttpSession ss = SessionManager.getSession();
+ UserDTO user = (UserDTO) ss.getAttribute(AttributeNames.USER);
+
+ refForm.setUserID(user.getUserID());
+ refForm.setSessionMapID(sessionMapID);
+
+// get the existing reflection entry
+ ISpreadsheetService submitFilesService = getSpreadsheetService();
+
+ SessionMap map = (SessionMap)request.getSession().getAttribute(sessionMapID);
+ Long toolSessionID = (Long)map.get(AttributeNames.PARAM_TOOL_SESSION_ID);
+ NotebookEntry entry = submitFilesService.getEntry(toolSessionID, CoreNotebookConstants.NOTEBOOK_TOOL, SpreadsheetConstants.TOOL_SIGNATURE, user.getUserID());
+
+ if (entry != null) {
+ refForm.setEntryText(entry.getEntry());
+ }
+
+ return mapping.findForward(SpreadsheetConstants.SUCCESS);
+ }
+ /**
+ * Submit reflection form input database.
+ * @param mapping
+ * @param form
+ * @param request
+ * @param response
+ * @return
+ */
+ private ActionForward submitReflection(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+ ReflectionForm refForm = (ReflectionForm) form;
+ Integer userId = refForm.getUserID();
+
+ String sessionMapID = WebUtil.readStrParam(request, SpreadsheetConstants.ATTR_SESSION_MAP_ID);
+ SessionMap sessionMap = (SessionMap) request.getSession().getAttribute(sessionMapID);
+ Long sessionId = (Long) sessionMap.get(AttributeNames.PARAM_TOOL_SESSION_ID);
+
+ ISpreadsheetService service = getSpreadsheetService();
+
+ // check for existing notebook entry
+ NotebookEntry entry = service.getEntry(sessionId, CoreNotebookConstants.NOTEBOOK_TOOL, SpreadsheetConstants.TOOL_SIGNATURE, userId);
+
+ if (entry == null) {
+ // create new entry
+ service.createNotebookEntry(sessionId, CoreNotebookConstants.NOTEBOOK_TOOL, SpreadsheetConstants.TOOL_SIGNATURE, userId, refForm.getEntryText());
+ } else {
+ // update existing entry
+ entry.setEntry(refForm.getEntryText());
+ entry.setLastModified(new Date());
+ service.updateEntry(entry);
+ }
+
+ return finish(mapping, form, request, response);
+ }
+
+ //*************************************************************************************
+ // Private methods
+ //*************************************************************************************
+
+ private ISpreadsheetService getSpreadsheetService() {
+ WebApplicationContext wac = WebApplicationContextUtils.getRequiredWebApplicationContext(getServlet().getServletContext());
+ return (ISpreadsheetService) wac.getBean(SpreadsheetConstants.RESOURCE_SERVICE);
+ }
+
+ private SpreadsheetUser getCurrentUser(ISpreadsheetService service, Long sessionId) {
+ //try to get form system session
+ HttpSession ss = SessionManager.getSession();
+ //get back login user DTO
+ UserDTO user = (UserDTO) ss.getAttribute(AttributeNames.USER);
+ SpreadsheetUser spreadsheetUser = service.getUserByIDAndSession(new Long(user.getUserID().intValue()),sessionId);
+
+ if(spreadsheetUser == null){
+ SpreadsheetSession session = service.getSpreadsheetSessionBySessionId(sessionId);
+ spreadsheetUser = new SpreadsheetUser(user,session);
+ service.saveOrUpdateUser(spreadsheetUser);
+ }
+ return spreadsheetUser;
+ }
+ private SpreadsheetUser getSpecifiedUser(ISpreadsheetService service, Long sessionId, Integer userId) {
+ SpreadsheetUser spreadsheetUser = service.getUserByIDAndSession(new Long(userId.intValue()),sessionId);
+ if ( spreadsheetUser == null ) {
+ log.error("Unable to find specified user for spreadsheet activity. Screens are likely to fail. SessionId="
+ +sessionId+" UserId="+userId);
+ }
+ return spreadsheetUser;
+ }
+
+ /**
+ * Get ToolAccessMode from HttpRequest parameters. Default value is AUTHOR mode.
+ * @param request
+ * @return
+ */
+ private ToolAccessMode getAccessMode(HttpServletRequest request) {
+ ToolAccessMode mode;
+ String modeStr = request.getParameter(AttributeNames.ATTR_MODE);
+ if(StringUtils.equalsIgnoreCase(modeStr,ToolAccessMode.TEACHER.toString()))
+ mode = ToolAccessMode.TEACHER;
+ else
+ mode = ToolAccessMode.AUTHOR;
+ return mode;
+ }
+}
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/MonitoringAction.java
===================================================================
diff -u
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/MonitoringAction.java (revision 0)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/web/action/MonitoringAction.java (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,214 @@
+/****************************************************************
+ * Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org)
+ * =============================================================
+ * License Information: http://lamsfoundation.org/licensing/lams/2.0/
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License version 2.0
+ * as published by the Free Software Foundation.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
+ * USA
+ *
+ * http://www.gnu.org/licenses/gpl.txt
+ * ****************************************************************
+ */
+
+/* $Id$ */
+package org.lamsfoundation.lams.tool.spreadsheet.web.action;
+
+import java.io.IOException;
+import java.util.ArrayList;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+import java.util.TreeMap;
+
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.apache.log4j.Logger;
+import org.apache.struts.action.Action;
+import org.apache.struts.action.ActionForm;
+import org.apache.struts.action.ActionForward;
+import org.apache.struts.action.ActionMapping;
+import org.lamsfoundation.lams.notebook.model.NotebookEntry;
+import org.lamsfoundation.lams.notebook.service.CoreNotebookConstants;
+import org.lamsfoundation.lams.tool.spreadsheet.SpreadsheetConstants;
+import org.lamsfoundation.lams.tool.spreadsheet.dto.ReflectDTO;
+import org.lamsfoundation.lams.tool.spreadsheet.dto.StatisticDTO;
+import org.lamsfoundation.lams.tool.spreadsheet.dto.Summary;
+import org.lamsfoundation.lams.tool.spreadsheet.model.Spreadsheet;
+import org.lamsfoundation.lams.tool.spreadsheet.model.SpreadsheetSession;
+import org.lamsfoundation.lams.tool.spreadsheet.model.SpreadsheetUser;
+import org.lamsfoundation.lams.tool.spreadsheet.service.ISpreadsheetService;
+import org.lamsfoundation.lams.util.WebUtil;
+import org.lamsfoundation.lams.web.util.AttributeNames;
+import org.lamsfoundation.lams.web.util.SessionMap;
+import org.springframework.web.context.WebApplicationContext;
+import org.springframework.web.context.support.WebApplicationContextUtils;
+
+public class MonitoringAction extends Action {
+ public static Logger log = Logger.getLogger(MonitoringAction.class);
+
+ public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
+ HttpServletResponse response) throws IOException, ServletException {
+ String param = mapping.getParameter();
+
+ request.setAttribute("initialTabId",WebUtil.readLongParam(request, AttributeNames.PARAM_CURRENT_TAB,true));
+
+ if (param.equals("summary")) {
+ return summary(mapping, form, request, response);
+ }
+ if (param.equals("doStatistic")) {
+ return doStatistic(mapping, form, request, response);
+ }
+ if (param.equals("editMark")) {
+ return editMark(mapping, form, request, response);
+ }
+// if (param.equals("listuser")) {
+// return listuser(mapping, form, request, response);
+// }
+ if (param.equals("viewReflection")) {
+ return viewReflection(mapping, form, request, response);
+ }
+
+ return mapping.findForward(SpreadsheetConstants.ERROR);
+ }
+
+ private ActionForward summary(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
+ //initial Session Map
+ SessionMap sessionMap = new SessionMap();
+ request.getSession().setAttribute(sessionMap.getSessionID(), sessionMap);
+ request.setAttribute(SpreadsheetConstants.ATTR_SESSION_MAP_ID, sessionMap.getSessionID());
+// save contentFolderID into session
+ sessionMap.put(AttributeNames.PARAM_CONTENT_FOLDER_ID,WebUtil.readStrParam(request,AttributeNames.PARAM_CONTENT_FOLDER_ID));
+
+ Long contentId = WebUtil.readLongParam(request, AttributeNames.PARAM_TOOL_CONTENT_ID);
+ ISpreadsheetService service = getSpreadsheetService();
+ List- groupList = new ArrayList
- Punkt 1
- Punkt 2
- Punkt 3
- bullet 1
- bullet 2
- bullet 3
- ();
+ if(group.size() > 0)
+ groupList.add(group);
+
+ // Add flag to indicate whether to render user notebook entries
+ sessionMap.put(SpreadsheetConstants.ATTR_REFLECTION_ON, content.isReflectOnActivity());
+
+ // Create reflectList if reflection is enabled.
+ if (content.isReflectOnActivity()) {
+ // Create reflectList, need to follow same structure used in teacher
+ // see service.getReflectList();
+ Map
+
+
-
+
${activity.title}
+ -
+
+
+
+
+
+
+
+
+
+
Index: lams_tool_spreadsheet/web/WEB-INF/tags/TabName.tag
===================================================================
diff -u
--- lams_tool_spreadsheet/web/WEB-INF/tags/TabName.tag (revision 0)
+++ lams_tool_spreadsheet/web/WEB-INF/tags/TabName.tag (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,60 @@
+<%/****************************************************************
+ * Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org)
+ * =============================================================
+ * License Information: http://lamsfoundation.org/licensing/lams/2.0/
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License version 2.0
+ * as published by the Free Software Foundation.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
+ * USA
+ *
+ * http://www.gnu.org/licenses/gpl.txt
+ * ****************************************************************
+ */
+
+/**
+ * TabName Tag
+ * Author: Mitchell Seaton
+ * Description: Shortens name that are too long to fit inside a tab
+ */
+
+ %>
+<%@ tag body-content="scriptless" %>
+
+<%@ attribute name="url" required="true" rtexprvalue="true"%>
+<%@ attribute name="highlight" required="false" rtexprvalue="true" %>
+
+<%@ taglib uri="tags-core" prefix="c"%>
+<%@ taglib uri="tags-function" prefix="fn"%>
+
+Index: lams_tool_spreadsheet/web/common/header.jsp =================================================================== diff -u --- lams_tool_spreadsheet/web/common/header.jsp (revision 0) +++ lams_tool_spreadsheet/web/common/header.jsp (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,17 @@ +<%@ include file="/common/taglibs.jsp"%> +
+
+
+
+
+|
+Simple Spreadsheet +English - +Deutsch - +Italiano - +Espa�ol - +Nederlands - +Fran�ais - +Polski + + |
| onkeydown | onkeyup | onkeypress | +|
|---|---|---|---|
| keycode | + | ||
| charCode | + | ||
| which | + |
Simple Spreadsheet Function Reference
++ +Simple Spreadsheet Online Manual + + +View modes + +Values: shows all calculated values on the screen (default) + Auto-Calculate: All values are automatically calculated + Manual: Disables automatic recalculation (gives better performance) + Refresh: Recalculates all values if Auto-Refresh is disabled + +Formulas: shows all formulas on the screen +Styles: shows all styles on the screen + +Cell References + += A1 // gives A1 += A2:A4 // gives array of A2,A3,A4 += [A2,A4] // gives array of A2,A4 += a1 // does not give A1 + +Aggregate Functions + += sum(A2:A4) // gives A2+A3+A4 += sum(A2:B3) // gives A2+A3+B2+B3 += avg(2,3,4) // gives (2+3+4)/3 = 3 += min(2,3,4) // gives 2 += max(2,3,4) // gives 4 += count(A2:A4) // gives 3 + +Math Functions + +Math.abs(a) // the absolute value of a +Math.acos(a) // arc cosine of a +Math.asin(a) // arc sine of a +Math.atan(a) // arc tangent of a +Math.atan2(a,b) // arc tangent of a/b +Math.ceil(a) // integer closest to a and not less than a +Math.cos(a) // cosine of a +Math.exp(a) // exponent of a +Math.floor(a) // integer closest to and not greater than a +Math.log(a) // log of a base e +Math.max(a,b) // the maximum of a and b +Math.min(a,b) // the minimum of a and b +Math.pow(a,b) // a to the power b +Math.random() // pseudorandom number in the range 0 to 1 +Math.round(a) // integer closest to a +Math.sin(a) // sine of a +Math.sqrt(a) // square root of a +Math.tan(a) // tangent of a + +Numbers + +conventional decimal numbers: 5, 137, 1.3 +decimal numbers in exponential form: 6.67e-11, -1.127e20 + +octal numbers, for example: 01234, -077, 0312 +(Positive octal numbers must begin with 0 (zero) and negative octal numbers must begin with -0.) + +hexadecimal numbers, for example: 0xFF -0xCCFF 0xabcdef +(Positive hexadecimals must begin with 0x and negative hexadecimals must begin with -0x.) + + +Constants + +Math.PI // pi = 3.14159265... +Math.E // e = 2.71828182... +Math.LOG2E // log of e base 2 +Math.LOG10E // log of e base 10 +Math.LN2 // log of 2 base e +Math.LN10 // log of 10 base e +Math.SQRT2 // square root of 2 +Math.SQRT1_2 // square root of 1/2 + +Base conversion + += (32767).toString(16) // this gives "7fff" += (255).toString(8) // this gives "377" += (1295).toString(36) // this gives "zz" += (127).toString(2) // this gives "1111111" + +Arithmetic operations + +Unary operations have one argument (in the following examples, the argument is a): + +-a // change the sign of a +~a // bitwise NOT a +++a // add 1 to a (before using a) +a++ // add 1 to a (after using a) +--a // subtract 1 from a (before using a) +a-- // subtract 1 from a (after using a) + +Binary operations operations have two arguments (in the following examples, the arguments are a and b): + +a * b // multiply a by b +a / b // divide a by b +a % b // find the remainder of division of a by b +a + b // add a and b +a - b // subtract b from a +a & b // bitwise a AND b +a | b // bitwise a OR b +a ^ b // bitwise a XOR b + +Shifts are the following operations: + +a << b // shift a by b bits to the left + // (padding with zeros) +a >> b // shift a by b bits to the right + // (copying the sign bit) +a >>> b // shift a by b bits to the right + // (padding with zeros) + + +Random Numbers + += Math.random() // gives random, 0 to 1 + +If you need random floating-point numbers in the range from A to B, use this code: + += A + (B-A)*Math.random() // gives random, from A to B + +Rounding + +Math.round(10*X)/10; // round to tenths +Math.round(100*X)/100; // round to hundredths +Math.round(1000*X)/1000; // round to thousandths + +Substrings + +string.substring(start,end) + +Here +string is the string from which you want to extract a substring. +start is the number specifying the position of the character at which the substring begins. (The character at start itself will be included in the substring.) +end is the number specifying the position of the character at which the substring ends. (The character at end will not be included in the substring.) + +Note that the first character in the string corresponds to position 0, and the last character to position string.length-1. + +Examples: + +'Hello'.substring(0,2) // 'He' +'Hello'.substring(0,4) // 'Hell' + +String operations + +string.toUpperCase(); // Converts the string to upper case. +string.toLowerCase(); // Converts the string to lower case. +string.indexOf("B"); // Returns the index of the given character in a string. +string.lastIndexOf("B"); // Returns the last index of a given character in a string. +string.split(","); // Splits a string into an array of substrings. +string.charAt(1); // Returns the character at a given index. +string.charCodeAt(1); // Converts the char at the given index to an ASCII value. +String.fromCharCode(65,66,67); // Return a string from a number of Unicode character values. + +string.replace(new RegExp("A","gi"),"B"); +// Can be used to replace a string given as a regular expression with another string. + +string.match("A"); +// Can be used to match a regular expression against a string. It returns an array of the matches. + +string.search(/^[a-z]*@[a-z]*$/i); +// Can be used to with a regular expression to search for a special format. + +String Quoting + += 'I\'m not a JavaScript hacker.' + +Conditions + += D2==10?"yes it is 10!":"other case" + + +Graph functions + +=graph(graph type,graph title,values y-axis,labels x-axis,caption x-axis,caption y-axis,width,height) + +The graph function creates an image with one graph inside. + +Graph types: bar, pie, line, linesteps, scatter +Optional: caption x-axis, caption y-axis, width, height + +Example: =graph('bar',E11,F12:F15,E12:E15,'quarter','value') + + +=graph2(graph type,graph title,values y-axis graph 1,values y-axis graph 2,labels x-axis,caption x-axis,caption y-axis,width,height) + +The graph2 function creates an image with two graphs inside. + +Graph2 types: bar, baraccumulate, line, linesteps +Optional: caption x-axis, caption y-axis, width, height + +Example: =graph2('bar','Bar graph (2 bars)',F12:F15,G12:G15,E12:E15) + +Multiline editing + +Use "\n" in the formula to force a line-break and open the multiline editor + +HTML editing + +Use "html:" at the beginning of the formula to force the interpretation as HTML code. +Using "html:" as prefix automatically opens the HTML editor. + +Styles: Font decoration / font effects (use the style field next to the formula) + +bold: font-weight:bold; +italic: font-style:italic; +underlined: text-decoration:underline; ++ + \ No newline at end of file Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print.css =================================================================== diff -u --- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print.css (revision 0) +++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print.css (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,38 @@ +/* +// GPL +*/ + +body,table,div { + font-family: Arial, Helvetica, Verdana, sans-serif; + font-size:13px; + font-weight:normal; +} +body,input,textarea,div,table { + margin:0px; + padding:0px; +} +#table { + border-left:1px solid #666666; + border-top:1px solid #666666; +} +th { + color:#666666; + background-color:#EFEFEF; + border-right:1px solid #666666; + border-bottom:1px solid #666666; +} +th div { + padding:1px; + font-size:11px; + font-weight:normal; +} +td { + border-right:1px solid #CCCCCC; + border-bottom:1px solid #CCCCCC; + height:18px; + padding-left:4px; + padding-right:4px; +} +#spacer { + display:none; +} \ No newline at end of file Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print_noline.css =================================================================== diff -u --- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print_noline.css (revision 0) +++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/print_noline.css (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,37 @@ +/* +// GPL +*/ + +body,table,div { + font-family: Arial, Helvetica, Verdana, sans-serif; + font-size:13px; + font-weight:normal; +} +body,input,textarea,div,table { + margin:0px; + padding:0px; +} +#table { + border-left:1px solid #666666; + border-top:1px solid #666666; +} +th { + color:#666666; + background-color:#EFEFEF; + border-right:1px solid #666666; + border-bottom:1px solid #666666; +} +th div { + padding:1px; + font-size:11px; + font-weight:normal; +} +td { + border:0px; + height:18px; + padding-left:4px; + padding-right:4px; +} +#spacer { + display:none; +} \ No newline at end of file Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/spreadsheet.js =================================================================== diff -u --- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/spreadsheet.js (revision 0) +++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/spreadsheet.js (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8) @@ -0,0 +1,1601 @@ +/**************************************************************************\ + * Simple Groupware 0.410 * + * http://www.simple-groupware.de * + * Copyright (C) 2002-2008 by Thomas Bley * + * ------------------------------------------------------------------------ * + * This program is free software; you can redistribute it and/or * + * modify it under the terms of the GNU General Public License Version 2 * + * as published by the Free Software Foundation; only version 2 * + * of the License, no later version. * + * * + * This program is distributed in the hope that it will be useful, * + * but WITHOUT ANY WARRANTY; without even the implied warranty of * + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * + * GNU General Public License for more details. * + * * + * You should have received a copy of the GNU General Public License * + * Version 2 along with this program; if not, write to the Free Software * + * Foundation, Inc., 59 Temple Place - Suite 330, Boston, * + * MA 02111-1307, USA. * + \**************************************************************************/ + +// Translations implemented by Sophie Lee. + +var agent = navigator.userAgent.toLowerCase(); +if (agent.indexOf("konqueror")!=-1) agent = "konqueror"; + else if (agent.indexOf("safari")!=-1) agent = "safari"; + else if (agent.indexOf("opera")!=-1) agent = "opera"; + else if (agent.indexOf("firefox")!=-1) agent = "firefox"; + else if (agent.indexOf("msie")!=-1) agent = "msie"; + +window.onerror=handleErr; + +if (agent=="msie" || agent=="safari") { // cursor keys only in keydown + document.onkeydown = keypress; +} else document.onkeypress=keypress; + +var init_data = ""; +var auto_recalc = true; +var cols = 7; +var rows = 17; +var row0 = 0; +var col0 = 0; +var col_min_width = "87px"; + +/* format: cells[row][column][type] +type: +0 = formula +1 = styling +2 = cell description +3 = current value +*/ +var cells = new Array(); +var marks = new Array(); +var view = "values"; +var currRow = 0; +var currCol = 0; +var multiRange = new Array(); +var clipboard_row = 0; +var clipboard_col = 0; +var clipboard_range = new Array(); +var clipboard_mode = ""; +var active = ""; +var showColumnGroups = false; +var allowPaging = true; +var registerFuncs = ""; +var isMouseDown = 0; +var isShiftDown = 0; +var sgs_folder = 0; +var sgs_view = ""; +var saveMethod = "save('js')"; +var closeMethod = ""; +var isWriteable = true; +var tab = String.fromCharCode(9); +var printstyle = "print.css"; + +function trans(key) { + if (strings[key]) return strings[key]; else return "["+key+"]"; +} + +function keypress(event) { + if (!getObj("value") || active=="code") return true; + var event = (event)?event:window.event; + // TODO2 test safari change dimensions / positions + var keyCode = getmykey(event); + var ret = true; + if (active=="position") { + if (keyCode==13) { + gotoCell(getObj("field").value); + active="content"; + ret = false; + } + return ret; + } + if (active=="dimensions") { + if (keyCode==13) { + rows=parseInt(getObj("rows").value); + cols=parseInt(getObj("cols").value); + active="content"; + display(); + ret = false; + } + return ret; + } + if (getObj("styling").disabled) { + getObj("focus").focus(); // avoid window scrolling + active = "content"; + var shift = event.shiftKey; + var alt = event.altKey; + var ctrl = event.ctrlKey; + + if ((ctrl && (keyCode==88 || keyCode==120)) || (shift && keyCode==46)) { // ctrl-x = cut || shift-del = cut + cutcopy("cut","#FFDDDD"); + ret=false; + } else if ((ctrl && (keyCode==67 || keyCode==99)) || ctrl && keyCode==45) { // ctrl-c = copy || ctrl-ins = copy + cutcopy("copy","#DDDDFF"); + ret=false; + } else if (((ctrl && (keyCode==86 || keyCode==118)) || (shift && keyCode==45)) && clipboard_mode!="") { // ctrl-v = paste || shift-ins = paste + paste(); + ret=false; + } + + if (shift && !isShiftDown) { + highlightRange(multiRange,"cell"); + multiRange = new Array(currRow,currCol,currRow,currCol); + isShiftDown = 1; + } else if (!alt && !ctrl && !shift && multiRange.length>0 && keyCode!=46) { + highlightRange(multiRange,"cell"); + multiRange = new Array(); + isShiftDown=0; + isMouseDown=0; + } + + if (!alt && !ctrl && keyCode!=0) { + if (keyCode==33) { // page up + if (currRow-10 <= row0 && currRow > 10) { + row0 -= rows; + display(); + mouseoverCell(currRow-10,currCol); + scrollDown(); + } else { + mouseoverCell(currRow>=10?currRow-10:0,currCol); + scrollUp(); + } + ret=false; + } else if (keyCode==34) { // page down + if (currRow+10 >= row0+rows) { + row0 += rows; + display(); + mouseoverCell(currRow+10,currCol); + scrollUp(); + } else { + mouseoverCell(currRow+10,currCol); + scrollDown(); + } + ret=false; + } else if (keyCode==36) { // home + if (currCol!=col0) { + mouseoverCell(currRow,col0); + } else if (currCol+1 >= cols) { + col0 -= cols; + display(); + mouseoverCell(currRow,currCol-cols); + } else if (currRow > row0) { + mouseoverCell(row0,currCol); + } else if (currRow+1 > rows) { + row0 -= rows; + display(); + mouseoverCell(currRow-rows,currCol); + } + scrollLeft(); + ret=false; + } else if (keyCode==35) { // end + if (currCol!=(col0+cols-1)) { + mouseoverCell(currRow,col0+cols-1); + } else { + col0 += cols; + display(); + mouseoverCell(currRow,currCol+cols); + } + scrollRight(); + ret=false; + } else if (keyCode==39 || keyCode==9) { // right + goRight(); + ret=false; + } else if (keyCode==40) { // down + goDown(); + ret=false; + } else if (keyCode==38 && currRow>-2) { // up + goUp(); + ret=false; + } else if (keyCode==37 && currCol>-1) { // left + goLeft(); + ret=false; + } else if (!shift && keyCode==46 && isWriteable && confirm(trans("Really empty cell(s) ?"))) { + removeSelectedCell(); + ret=false; + } else if ((keyCode<33 || keyCode>40) && keyCode!=46 && keyCode!=45 && + keyCode!=16 && keyCode!=17 && keyCode!=18) { + editCell(currRow,currCol,keyCode); + if (keyCode==13) ret=false; + } + } + if (isShiftDown) { + highlightRange(multiRange,"cell"); + multiRange[2] = currRow; + multiRange[3] = currCol; + highlightRange(multiRange,"cell_highlight_over"); + } + } else { + if (keyCode==13) { + saveCell(); + ret=false; + } else if (keyCode==27) { + cancelCell(); + ret=false; + } + } + return ret; +} + +function goLeft() { + if (currCol <= col0 && currCol > 0) { + col0 -= cols; + display(); + mouseoverCell(currRow,currCol-1); + scrollRight(); + } else { + mouseoverCell(currRow,currCol-1); + scrollLeft(); + } +} + +function goUp() { + if (currRow <= row0 && currRow > 0) { + row0 -= rows; + display(); + mouseoverCell(currRow-1,currCol); + scrollDown(); + } else { + mouseoverCell(currRow-1,currCol); + scrollUp(); + } +} + +function goRight() { + if (currCol+1 >= col0+cols) { + col0 += cols; + display(); + mouseoverCell(currRow,currCol+1); + scrollLeft(); + } else { + mouseoverCell(currRow,currCol+1); + scrollRight(); + } +} + +function goDown() { + if (currRow+1 >= row0+rows) { + row0 += rows; + display(); + mouseoverCell(currRow+1,currCol); + scrollUp(); + } else { + mouseoverCell(currRow+1,currCol); + scrollDown(); + } +} + +function display() { + marks = new Array(); + isMouseDown=0; + var scrollX = 0; // keep scrolling states + var scrollY = 0; + if (getObj("content")) { + scrollX = getObj("content").scrollLeft; + scrollY = getObj("content").scrollTop; + } + var out = "strikethrough: text-decoration:line-through; +bold italic: font-weight:bold; + +font-size "120%": font-size:120%; +font-size "18px": font-size:18px; + +font-family "Helvetica": font-family:Helvetica; +font-family "Verdana": font-family:Verdana; +font-family "sans-serif": font-family:sans-serif; +font-family "Courier": font-family:Courier; + +font color red: color:red; +font color blue: color:blue; +font color green: color:green; + +background color yellow: background-color:yellow; +background color red: background-color:red; +background color light-green; background-color:lightgreen; + +Styles: Text alignment + +Text align left: text-align:left; +Text centered: text-align:center; +Text align right: text-align:right; +Text justified: text-align:justify; + +Override automatic line-break: white-space:nowrap; + +Cell width "250px": width:250px; +Cell height "100px": height:250px; + +Styles: Data formats + +Currency Euro (10 => 10 �): format:euro; +Currency Dollar (10 => $10): format:dollar; +Percent value (10 => 10%): format:percent; + +Time format (14:11:12 => 2:11:12 pm): format:time; +Date format (1.2.2004 => 2/1/2004): format:date; + +Full date format (02/26/2006 => Sunday, February 26 2006): format:datefull; +Datetime format (03/27/2007 9:11:12 => 3/27/2007 9:11:12 am): format:datetime; +Full datetime format (03/27/2007 9:11:12 => Tuesday, March 27 2007, 9:11:12 am): format:datefulltime; + +Styles: Cell protection + +Lock the value of a cell: readonly:true; + +Keyboard access keys [Alt+x or Alt+Shift+x] + +* g = switch to goto field +* x = cut cell +* c = copy cell +* v = paste cell +* e = empty cell +* p = print + +* n = create a new spreadsheet +* l = load a spreadsheet +* s = save spreadsheet (if run inside Simple Groupware) +* q = close Simple Spreadsheet (if run inside Simple Groupware) +* m = change auto-refresh +* r = refresh (if auto-refresh is off) +* h = function reference + +* 1 = values view +* 2 = formulas view +* 3 = styles view + +Keyboard shortcuts + +* enter / start typing = edit cell +* ctrl+x or shift+del = cut cell +* ctrl+c or ctrl+ins = copy cell +* ctrl+v or shift+ins = paste cell +* del = empty cell +* cursor up = go up +* cursor down = go down +* cursor left = go left +* cursor right = go right +* home = go to first cell in row or page left/up if already in first cell +* end = go to last cell in row or page right if already in last cell +* page up = go 10 rows down +* page down = go 10 rows up + +// TODO2 dates / date functions +// http://www.merlyn.demon.co.uk/js-dates.htm +// http://www.tizag.com/javascriptT/javascriptdate.php + +Sources: +- JavaScripter.net. Copyright � 1999-2000, Alexei Kourbatov +
| "; + out += ""; + out += " "; + if (isWriteable) { + out += ""+trans("New")+" - "; + } + if (top.window!=window && closeMethod!="") out += ""+trans("Close")+" - "; + if (allowPaging) { + if (col0-cols>=0 || row0-rows>=0) { + out += ""+trans("Home")+" - "; + } + if (col0-cols>=0) { + out += ""+trans("<<")+" - "; + } else out += "<< - "; + out += ""+trans(">>")+" - "; + if (row0-rows>=0) { + out += ""+trans("Up")+" - "; + } else out += trans("Up")+" - "; + out += ""+trans("Down")+" - "; + out += " | "; + out += " x "; + out += " - "; + } + out += " - "; + out += " | "; + out += ""; + out += " "; + out += " "; + out += " | "; + if (isWriteable) { + out += " "; + out += " - "; + } else out += " "; + if (view=="values") { + if (isWriteable) { + out += ""+(auto_recalc?trans("Auto")+"-"+trans("Refresh"):trans("Manual"))+""; + if (!auto_recalc) out += " "+trans("Refresh")+""; + } + out += " - "+trans("Values")+" - "; + } else if (view=="formulas") { + out += ""+trans("Formulas")+" - "; + } else { + out += ""+trans("Styles")+" - "; + } + out += ""; + out += ""; + out += ""; + out += ""+trans("Help")+" - "; + + // You are not allowed to remove or alter the About button and/or the copyright. + out += ""+trans("About")+" "; + out += " |
"+value+"
";
+ obj2.innerHTML = val;
+ if (val.indexOf(""); + } + return str; +} +function handleErr(msg,url,l) { + alert(trans("There was an error on this page.")+"\n\n"+trans("Error:")+" "+msg+"\n"+trans("Url")+": "+url+"\n"+trans("Line:")+" "+l); + return true; +} + +// convert 26 to AA, 0 to A +function buildColName(num) { + var val = ""; + var result = ""; + if (num>=702) { + val = (Math.floor(num/676)-1)%26; + result += String.fromCharCode(val+65); + } + if (num>=26) { + val = (Math.floor(num/26)-1)%26; + result += String.fromCharCode(val+65); + } + result += String.fromCharCode(num%26+65); + return result; +} +//convert AA to 26 +function colstrToColnum(col_str) { + var col_num = 0; + for (var i=0; i
+
+
+
+
\ No newline at end of file
Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles.css
===================================================================
diff -u
--- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles.css (revision 0)
+++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles.css (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,144 @@
+/*
+// GPL
+*/
+body {
+ overflow:hidden;
+ background-color:#FFFFFF;
+}
+body,table,div {
+ font-family: Arial, Helvetica, Verdana, sans-serif;
+ font-size:13px;
+ font-weight:normal;
+}
+body,input,textarea,div,table {
+ margin:0px;
+ padding:0px;
+}
+iframe {
+ border:0px;
+}
+input {
+ height:20px;
+ border:1px solid #999999;
+ padding-left:2px;
+ padding-right:2px;
+}
+
+#content {
+ position:absolute;
+ top:23px;
+ left:0px;
+ right:0px;
+ bottom:18px;
+ width:100%;
+ overflow:auto;
+}
+#multiline {
+ display:none;
+ position:absolute;
+ width:425px;
+ top:22px;
+ height:250px;
+}
+#tconsole {
+ position:absolute;
+ width:400px;
+ top:20px;
+ left:600px;
+ height:250px;
+}
+.table {
+ border-left:1px solid #666666;
+ border-top:1px solid #666666;
+}
+th {
+ color:#666666;
+ background-color:#EFEFEF;
+ border-right:1px solid #666666;
+ border-bottom:1px solid #666666;
+ padding-left:5px;
+ padding-right:5px;
+}
+th div {
+ padding:1px;
+ font-size:11px;
+ font-weight:normal;
+ display:inline;
+}
+td {
+ border-right:1px solid #CCCCCC;
+ border-bottom:1px solid #CCCCCC;
+ height:18px;
+ padding-left:4px;
+ padding-right:4px;
+}
+.default_table td {
+ border:0px;
+}
+.header td {
+ padding:0px;
+ border:0px;
+}
+.header {
+ position:absolute;
+ background-color:#C0C0FF;
+ width:100%;
+ z-index:2;
+ padding-top:1px;
+ height:22px;
+ color:#333333;
+}
+.header a,.header,.footer a,.footer {
+ color:#333333;
+}
+.footer {
+ position:absolute;
+ border-top:1px solid #666666;
+ background-color:#C0C0FF;
+ width:100%;
+ z-index:2;
+ height:18px;
+ bottom:0px;
+}
+.status {
+ position:absolute;
+ border-top:1px solid #666666;
+ border-left:1px solid #666666;
+ background-color:#C0C0FF;
+ z-index:2;
+ height:18px;
+ bottom:0px;
+ right:3px;
+ padding-left:5px;
+}
+.empty {
+ padding:0px;
+ margin:0px;
+ border:0px;
+}
+.cell_highlight {
+ background-color:#FFFFC0;
+}
+.cell_highlight_over {
+ background-color:#EFEFEF;
+}
+.border_highlight {
+ background-color:#C0FFC0;
+}
+.data {
+ display:none;
+}
+#code {
+ width:100%;
+ height:85%;
+ overflow:auto;
+}
+#source {
+ width:100%;
+ height:95%;
+}
+#focus {
+ height:0px;
+ position:absolute;
+ top:-30px;
+}
Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles_noline.css
===================================================================
diff -u
--- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles_noline.css (revision 0)
+++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/styles_noline.css (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,144 @@
+/*
+// GPL
+*/
+body {
+ overflow:hidden;
+ background-color:#FFFFFF;
+}
+body,table,div {
+ font-family: Arial, Helvetica, Verdana, sans-serif;
+ font-size:13px;
+ font-weight:normal;
+}
+body,input,textarea,div,table {
+ margin:0px;
+ padding:0px;
+}
+iframe {
+ border:0px;
+}
+input {
+ height:20px;
+ border:1px solid #999999;
+ padding-left:2px;
+ padding-right:2px;
+}
+
+#content {
+ position:absolute;
+ top:23px;
+ left:0px;
+ right:0px;
+ bottom:18px;
+ width:100%;
+ overflow:auto;
+}
+#multiline {
+ display:none;
+ position:absolute;
+ width:425px;
+ top:22px;
+ height:250px;
+}
+#tconsole {
+ position:absolute;
+ width:400px;
+ top:20px;
+ left:600px;
+ height:250px;
+}
+.table {
+ border-left:1px solid #666666;
+ border-top:1px solid #666666;
+}
+th {
+ color:#666666;
+ background-color:#EFEFEF;
+ border-right:1px solid #666666;
+ border-bottom:1px solid #666666;
+ padding-left:5px;
+ padding-right:5px;
+}
+th div {
+ padding:1px;
+ font-size:11px;
+ font-weight:normal;
+ display:inline;
+}
+td {
+ border-right:0px solid #CCCCCC;
+ border-bottom:0px solid #CCCCCC;
+ height:18px;
+ padding-left:4px;
+ padding-right:4px;
+}
+.default_table td {
+ border:0px;
+}
+.header td {
+ padding:0px;
+ border:0px;
+}
+.header {
+ position:absolute;
+ background-color:#C0C0FF;
+ width:100%;
+ z-index:2;
+ padding-top:1px;
+ height:22px;
+ color:#333333;
+}
+.header a,.header,.footer a,.footer {
+ color:#333333;
+}
+.footer {
+ position:absolute;
+ border-top:1px solid #666666;
+ background-color:#C0C0FF;
+ width:100%;
+ z-index:2;
+ height:18px;
+ bottom:0px;
+}
+.status {
+ position:absolute;
+ border-top:1px solid #666666;
+ border-left:1px solid #666666;
+ background-color:#C0C0FF;
+ z-index:2;
+ height:18px;
+ bottom:0px;
+ right:3px;
+ padding-left:5px;
+}
+.empty {
+ padding:0px;
+ margin:0px;
+ border:0px;
+}
+.cell_highlight {
+ background-color:#FFFFC0;
+}
+.cell_highlight_over {
+ background-color:#EFEFEF;
+}
+.border_highlight {
+ background-color:#C0FFC0;
+}
+.data {
+ display:none;
+}
+#code {
+ width:100%;
+ height:85%;
+ overflow:auto;
+}
+#source {
+ width:100%;
+ height:95%;
+}
+#focus {
+ height:0px;
+ position:absolute;
+ top:-30px;
+}
Index: lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/tinymce/blank.htm
===================================================================
diff -u
--- lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/tinymce/blank.htm (revision 0)
+++ lams_tool_spreadsheet/web/includes/javascript/simple_spreadsheet/tinymce/blank.htm (revision 7f9f772433a7fd55c4475241d4e3bc0765f474e8)
@@ -0,0 +1,9 @@
+
+
+","gi");content=tinyMCE.regexpReplace(content,"\r\r","
","gi");content=tinyMCE.regexpReplace(content,"\n\n","
","gi");if((pos=content.indexOf('
'))!=-1){tinyMCE.execCommand("Delete");var node=tinyMCE.selectedInstance.getFocusElement();var breakElms=new Array();do{if(node.nodeType==1){if(node.nodeName=="TD"||node.nodeName=="BODY")break;breakElms[breakElms.length]=node}}while(node=node.parentNode);var before="",after="
";before+=content.substring(0,pos);for(var i=0;i";content=before+content.substring(pos+7)+after}}if(tinyMCE.getParam("paste_create_linebreaks",true)){content=tinyMCE.regexpReplace(content,"\r\n"," $1 "+middot+"$1 <\/p>/gi,"");content=content.replace(/-- page break --/gi,"");if(!tinyMCE.settings['force_p_newlines']){content=content.replace('','','gi');content=content.replace(' ');content=content.replace(/<\/h[1-6]>/gi,'
","gi");content=tinyMCE.regexpReplace(content,"\r","
","gi");content=tinyMCE.regexpReplace(content,"\n","
","gi")}}tinyMCE.execCommand("mceInsertRawHTML",false,content)}},_insertWordContent:function(content){if(content&&content.length>0){var bull=String.fromCharCode(8226);var middot=String.fromCharCode(183);var cb;if((cb=tinyMCE.getParam("paste_insert_word_content_callback",""))!="")content=eval(cb+"('before', content)");var rl=tinyMCE.getParam("paste_replace_list",'\u2122,TM,\u2026,...,\u201c|\u201d,",\u2019,\',\u2013|\u2014|\u2015|\u2212,-').split(',');for(var i=0;i
","gi"),"
]*>/gi,"");if(tinyMCE.getParam("paste_remove_styles",true))content=content.replace(new RegExp('<(\\w[^>]*) style="([^"]*)"([^>]*)','gi'),"<$1$3");content=content.replace(/<\/?font[^>]*>/gi,"");switch(tinyMCE.getParam("paste_strip_class_attributes","all")){case"all":content=content.replace(/<(\w[^>]*) class=([^ |>]*)([^>]*)/gi,"<$1$3");break;case"mso":content=content.replace(new RegExp('<(\\w[^>]*) class="?mso([^ |>]*)([^>]*)','gi'),"<$1$3");break}content=content.replace(new RegExp('href="?'+TinyMCE_PastePlugin._reEscape(""+document.location)+'','gi'),'href="'+tinyMCE.settings['document_base_url']);content=content.replace(/<(\w[^>]*) lang=([^ |>]*)([^>]*)/gi,"<$1$3");content=content.replace(/<\\?\?xml[^>]*>/gi,"");content=content.replace(/<\/?\w+:[^>]*>/gi,"");content=content.replace(/-- page break --\s*
','gi')}if(!tinyMCE.isMSIE&&!tinyMCE.settings['force_p_newlines']){content=content.replace(/<\/?p[^>]*>/gi,"")}content=content.replace(/<\/?div[^>]*>/gi,"");if(tinyMCE.getParam("paste_convert_middot_lists",true)){var div=document.createElement("div");div.innerHTML=content;var className=tinyMCE.getParam("paste_unindented_list_class","unIndentedList");while(TinyMCE_PastePlugin._convertMiddots(div,"--list--"));while(TinyMCE_PastePlugin._convertMiddots(div,middot,className));while(TinyMCE_PastePlugin._convertMiddots(div,bull));content=div.innerHTML}if(tinyMCE.getParam("paste_convert_headers_to_strong",false)){content=content.replace(/