001: /* ====================================================================
002: * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
003: *
004: * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above copyright
011: * notice, this list of conditions and the following disclaimer.
012: *
013: * 2. Redistributions in binary form must reproduce the above copyright
014: * notice, this list of conditions and the following disclaimer in
015: * the documentation and/or other materials provided with the
016: * distribution.
017: *
018: * 3. The end-user documentation included with the redistribution,
019: * if any, must include the following acknowledgment:
020: * "This product includes software developed by Jcorporate Ltd.
021: * (http://www.jcorporate.com/)."
022: * Alternately, this acknowledgment may appear in the software itself,
023: * if and wherever such third-party acknowledgments normally appear.
024: *
025: * 4. "Jcorporate" and product names such as "Expresso" must
026: * not be used to endorse or promote products derived from this
027: * software without prior written permission. For written permission,
028: * please contact info@jcorporate.com.
029: *
030: * 5. Products derived from this software may not be called "Expresso",
031: * or other Jcorporate product names; nor may "Expresso" or other
032: * Jcorporate product names appear in their name, without prior
033: * written permission of Jcorporate Ltd.
034: *
035: * 6. No product derived from this software may compete in the same
036: * market space, i.e. framework, without prior written permission
037: * of Jcorporate Ltd. For written permission, please contact
038: * partners@jcorporate.com.
039: *
040: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
041: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
042: * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
043: * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
044: * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
045: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
046: * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
047: * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
048: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
049: * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
050: * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
051: * SUCH DAMAGE.
052: * ====================================================================
053: *
054: * This software consists of voluntary contributions made by many
055: * individuals on behalf of the Jcorporate Ltd. Contributions back
056: * to the project(s) are encouraged when you make modifications.
057: * Please send them to support@jcorporate.com. For more information
058: * on Jcorporate Ltd. and its products, please see
059: * <http://www.jcorporate.com/>.
060: *
061: * Portions of this software are based upon other open source
062: * products and are subject to their respective licenses.
063: */
064:
065: package com.jcorporate.expresso.ext.dbobj;
066:
067: import com.jcorporate.expresso.core.controller.ControllerRequest;
068: import com.jcorporate.expresso.core.db.DBException;
069: import com.jcorporate.expresso.core.dbobj.SecuredDBObject;
070: import com.jcorporate.expresso.core.misc.DateTime;
071:
072: /**
073: * DownloadLog
074: * Log the latest download of a file by a user
075: *
076: * @author Michael Nash
077: */
078: public class DownloadLog extends SecuredDBObject {
079:
080: /**
081: * Field name constant
082: */
083: public static final String FLD_LOG_ENTRY = "LogEntry";
084:
085: /**
086: * Field name constant
087: */
088: public static final String FLD_FILE_NUMBER = "FileNumber";
089:
090: /**
091: * Field name constant
092: */
093: public static final String FLD_EXP_UID = "ExpUid";
094:
095: /**
096: * Field name constant
097: */
098: public static final String FLD_DOWNLOADED = "Downloaded";
099:
100: /**
101: * Field name constant
102: */
103: public static final String FLD_FILEPATHNAME = "FilePathName";
104:
105: /**
106: * Field name constant
107: */
108: public static final String FLD_IP = "IPNumber";
109:
110: /**
111: * Constructor
112: */
113: public DownloadLog() throws DBException {
114: super ();
115: } /* DownloadLog() */
116:
117: /**
118: * Use over (String) constructor. Initializes the object in the context
119: * of the user who's uid belongs to the parameter.
120: *
121: * @param uid the Uid of the user context
122: * @throws DBException if there's an initialization problem
123: */
124: public DownloadLog(int uid) throws DBException {
125: super (uid);
126: }
127:
128: /**
129: * For using DBObjects within Controllers. Initializes based upon the current
130: * user and the requested db. [Of course this can be modified later]
131: *
132: * @param request - The controller request handed to you by the framework.
133: * @throws DBException upon error
134: */
135: public DownloadLog(ControllerRequest request) throws DBException {
136: super (request);
137: }
138:
139: /**
140: * Define the table and fields for this object
141: *
142: * @throws DBException If the fields cannot be set up
143: */
144: public void setupFields() throws DBException {
145: setTargetTable("DOWNLOADLOG");
146: setDescription("DBdownloadLog");
147: setCharset("ISO-8859-1");
148: addField("LogEntry", "auto-inc", 0, false, "logEntryNum");
149: addField("FileNumber", "int", 0, false, "fileNumber");
150: addField("ExpUid", "int", 0, false, "userId");
151: addField("Downloaded", "datetime", 0, true,
152: "dateTimeDownloaded");
153: addField("FilePathName", "varchar", 128, false, "filePath");
154: addField("IPNumber", "char", 20, false, "ipAddress");
155: setStringFilter("FilePathName", "stripFilter");
156: setLookupObject("ExpUid",
157: "com.jcorporate.expresso.core.security.User");
158: addKey("LogEntry");
159: }
160:
161: /**
162: * Override of add to set the 'Downloaded' time to when the record was created.
163: */
164: public synchronized void add()
165: throws com.jcorporate.expresso.core.db.DBException {
166: if (this .getDataField("Downloaded").isNull()
167: || this .getDataField("Downloaded").asString().length() == 0) {
168: this .set("Downloaded", DateTime.getDateTimeForDB(
169: new java.util.Date(), this .getDataContext()));
170: }
171:
172: super .add();
173: }
174: }
175:
176: /* DownloadLog */
|