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.regobj;
066:
067: import com.jcorporate.expresso.core.db.DBConnection;
068: import com.jcorporate.expresso.core.db.DBException;
069: import com.jcorporate.expresso.core.dbobj.RequestContext;
070: import com.jcorporate.expresso.core.dbobj.ValidValue;
071: import com.jcorporate.expresso.core.misc.DateTime;
072: import com.jcorporate.expresso.services.dbobj.RegistrationDBObject;
073:
074: import java.util.Vector;
075:
076: /**
077: * Creation date: 2001-08-24 11:57:54
078: *
079: * @author Written by webAppWriter, an Expresso Program by Pete Carapetyan - webAppWriter.com
080: * HOWEVER - Most of the code included in this file is derived from code
081: * created directly by Michael Nash of jCorporate, or Adam Rossi of Platinum Solutions
082: */
083: public class Phone extends RegistrationDBObject {
084: public static final String FLD_TYPE = "PhoneType";
085: public static final String FLD_NUMBER = "PhoneNum";
086:
087: /**
088: * Constructor
089: *
090: * @throws DBException if there's an initialization problem
091: */
092: public Phone() throws DBException {
093: super ();
094: } /* User() */
095:
096: /**
097: * Constructor
098: *
099: * @param myConnection the database connection to use for SQL statement execution
100: * @throws DBException if there's an initialization problem
101: */
102: public Phone(DBConnection myConnection) throws DBException {
103: super (myConnection);
104: } /* User(String) */
105:
106: /**
107: * Use over (String) constructor. Initializes the object in the context
108: * of the user who's uid belongs to the parameter.
109: *
110: * @param uid the Uid of the user context
111: * @throws DBException if there's an initialization problem
112: */
113: public Phone(int uid) throws DBException {
114: super (uid);
115: }
116:
117: /**
118: * For using DBObjects within Controllers. Initializes based upon the current
119: * user and the requested db. [Of course this can be modified later]
120: *
121: * @param request - The controller request handed to you by the framework.
122: * @throws DBException if there's an initialization problem
123: */
124: public Phone(RequestContext request) throws DBException {
125: super (request);
126: }
127:
128: /**
129: * @throws DBException if there's an initialization problem
130: */
131: public void add() throws DBException {
132: setField("AddedOn", DateTime.getDateTimeForDB(this
133: .getDataContext()));
134: setField("UpdatedOn", DateTime.getDateTimeForDB(this
135: .getDataContext()));
136: super .add();
137: } /* add() */
138:
139: /**
140: * @param fieldName the name of the field to retrieve the valid values for
141: * @return Vector of Valid Value/Description pairs for User NameTables
142: * @throws DBException If the values cannot be retrieved
143: */
144: public Vector getValidValues(String fieldName) throws DBException {
145: Vector myValues = new Vector(4);
146:
147: if (fieldName.equals(FLD_TYPE)) {
148: myValues.addElement(new ValidValue("Primary Voice",
149: "Primary Voice"));
150: myValues.addElement(new ValidValue("Secondary Voice",
151: "Secondary Voice"));
152: myValues.addElement(new ValidValue("Mobile", "Mobile"));
153: myValues.addElement(new ValidValue("Pager", "Pager"));
154: myValues.addElement(new ValidValue("Other", "Other"));
155:
156: return myValues;
157: }
158:
159: return super .getValidValues(fieldName);
160: }
161:
162: /**
163: * @throws DBException if there's an initialization problem
164: * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject
165: */
166: public void setupFields() throws DBException {
167: setTargetTable("SMPREGPH");
168: setDescription("Phone Number(s)");
169: setCharset("ISO-8859-1");
170:
171: /*[addFieldsHere]*/
172: addField("PhoneID", "auto-inc", 0, false, "Phone ID");
173: addField("ExpUid", "int", 0, false, "Person ID Number");
174: addField(FLD_TYPE, "varchar", 20, false, "Type");
175: addField("CountryCode", "char", 3, false, "Country Code");
176: addField("AreaCode", "char", 3, false, "Area/City Code");
177: addField(FLD_NUMBER, "char", 10, false, "Phone Number");
178: addField("AddedOn", "datetime", 0, true, "Added On");
179: addField("UpdatedOn", "datetime", 0, true, "Updated On");
180: setReadOnly("AddedOn");
181: setReadOnly("UpdatedOn");
182:
183: /*[addDBObjSetupExtrasHere]*/
184: setReadOnly("PhoneID");
185: addKey("PhoneID");
186: setLookupObject("ExpUid",
187: "com.jcorporate.expresso.security.dbobj.DefaultUserInfo");
188: addKey("ExpUid");
189: setMultiValued(FLD_TYPE);
190: }
191:
192: /**
193: * @throws DBException
194: */
195: public void update() throws DBException {
196: setField("UpdatedOn", DateTime.getDateTimeForDB(this
197: .getDataContext()));
198: super .update();
199: } /* update() */
200:
201: } /* PersonalData */
202:
203: /* PersonalData */
|