Phone


1   /* ====================================================================
2    * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
3    *
4    * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
5    *
6    * Redistribution and use in source and binary forms, with or without
7    * modification, are permitted provided that the following conditions
8    * are met:
9    *
10   * 1. Redistributions of source code must retain the above copyright
11   *    notice, this list of conditions and the following disclaimer.
12   *
13   * 2. Redistributions in binary form must reproduce the above copyright
14   *    notice, this list of conditions and the following disclaimer in
15   *    the documentation and/or other materials provided with the
16   *    distribution.
17   *
18   * 3. The end-user documentation included with the redistribution,
19   *    if any, must include the following acknowledgment:
20   *       "This product includes software developed by Jcorporate Ltd.
21   *        (http://www.jcorporate.com/)."
22   *    Alternately, this acknowledgment may appear in the software itself,
23   *    if and wherever such third-party acknowledgments normally appear.
24   *
25   * 4. "Jcorporate" and product names such as "Expresso" must
26   *    not be used to endorse or promote products derived from this
27   *    software without prior written permission. For written permission,
28   *    please contact info@jcorporate.com.
29   *
30   * 5. Products derived from this software may not be called "Expresso",
31   *    or other Jcorporate product names; nor may "Expresso" or other
32   *    Jcorporate product names appear in their name, without prior
33   *    written permission of Jcorporate Ltd.
34   *
35   * 6. No product derived from this software may compete in the same
36   *    market space, i.e. framework, without prior written permission
37   *    of Jcorporate Ltd. For written permission, please contact
38   *    partners@jcorporate.com.
39   *
40   * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
41   * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
42   * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
43   * DISCLAIMED.  IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
44   * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
45   * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
46   * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
47   * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
48   * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
49   * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
50   * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
51   * SUCH DAMAGE.
52   * ====================================================================
53   *
54   * This software consists of voluntary contributions made by many
55   * individuals on behalf of the Jcorporate Ltd. Contributions back
56   * to the project(s) are encouraged when you make modifications.
57   * Please send them to support@jcorporate.com. For more information
58   * on Jcorporate Ltd. and its products, please see
59   * <http://www.jcorporate.com/>.
60   *
61   * Portions of this software are based upon other open source
62   * products and are subject to their respective licenses.
63   */
64  
65  package com.jcorporate.expresso.ext.dbobj.regobj;
66  
67  import com.jcorporate.expresso.core.db.DBConnection;
68  import com.jcorporate.expresso.core.db.DBException;
69  import com.jcorporate.expresso.core.dbobj.RequestContext;
70  import com.jcorporate.expresso.core.dbobj.ValidValue;
71  import com.jcorporate.expresso.core.misc.DateTime;
72  import com.jcorporate.expresso.services.dbobj.RegistrationDBObject;
73  
74  import java.util.Vector  ;
75  
76  
77  /**
78   * Creation date: 2001-08-24 11:57:54
79   *
80   * @author Written by webAppWriter, an Expresso Program by Pete Carapetyan - webAppWriter.com
81   *         HOWEVER - Most of the code included in this file is derived from code
82   *         created directly by Michael Nash of jCorporate, or Adam Rossi of Platinum Solutions
83   */
84  public class Phone
85          extends RegistrationDBObject {
86      public static final String   FLD_TYPE = "PhoneType";
87      public static final String   FLD_NUMBER = "PhoneNum";
88  
89  
90      /**
91       * Constructor
92       *
93       * @throws DBException if there's an initialization problem
94       */
95      public Phone()
96              throws DBException {
97          super();
98      } /* User() */
99  
100     /**
101      * Constructor
102      *
103      * @param myConnection the database connection to use for SQL statement execution
104      * @throws DBException if there's an initialization problem
105      */
106     public Phone(DBConnection myConnection)
107             throws DBException {
108         super(myConnection);
109     } /* User(String) */
110 
111     /**
112      * Use over (String) constructor.  Initializes the object in the context
113      * of the user who's uid belongs to the parameter.
114      *
115      * @param uid the Uid of the user context
116      * @throws DBException if there's an initialization problem
117      */
118     public Phone(int uid)
119             throws DBException {
120         super(uid);
121     }
122 
123     /**
124      * For using DBObjects within Controllers.  Initializes based upon the current
125      * user and the requested db. [Of course this can be modified later]
126      *
127      * @param request - The controller request handed to you by the framework.
128      * @throws DBException if there's an initialization problem
129      */
130     public Phone(RequestContext request)
131             throws DBException {
132         super(request);
133     }
134 
135     /**
136      * @throws DBException if there's an initialization problem
137      */
138     public void add()
139             throws DBException {
140         setField("AddedOn", DateTime.getDateTimeForDB(this.getDataContext()));
141         setField("UpdatedOn", DateTime.getDateTimeForDB(this.getDataContext()));
142         super.add();
143     } /* add() */
144 
145 
146     /**
147      * @param fieldName the name of the field to retrieve the valid values for
148      * @return Vector of Valid Value/Description pairs for User NameTables
149      * @throws DBException If the values cannot be retrieved
150      */
151     public Vector   getValidValues(String   fieldName)
152             throws DBException {
153         Vector   myValues = new Vector  (4);
154 
155         if (fieldName.equals(FLD_TYPE)) {
156             myValues.addElement(new ValidValue("Primary Voice",
157                     "Primary Voice"));
158             myValues.addElement(new ValidValue("Secondary Voice",
159                     "Secondary Voice"));
160             myValues.addElement(new ValidValue("Mobile", "Mobile"));
161             myValues.addElement(new ValidValue("Pager", "Pager"));
162             myValues.addElement(new ValidValue("Other", "Other"));
163 
164             return myValues;
165         }
166 
167         return super.getValidValues(fieldName);
168     }
169 
170     /**
171      * @throws DBException if there's an initialization problem
172      * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject
173      */
174     public void setupFields()
175             throws DBException {
176         setTargetTable("SMPREGPH");
177         setDescription("Phone Number(s)");
178         setCharset("ISO-8859-1");
179 
180         /*[addFieldsHere]*/
181         addField("PhoneID", "auto-inc", 0, false, "Phone ID");
182         addField("ExpUid", "int", 0, false, "Person ID Number");
183         addField(FLD_TYPE, "varchar", 20, false, "Type");
184         addField("CountryCode", "char", 3, false, "Country Code");
185         addField("AreaCode", "char", 3, false, "Area/City Code");
186         addField(FLD_NUMBER, "char", 10, false, "Phone Number");
187         addField("AddedOn", "datetime", 0, true, "Added On");
188         addField("UpdatedOn", "datetime", 0, true, "Updated On");
189         setReadOnly("AddedOn");
190         setReadOnly("UpdatedOn");
191 
192         /*[addDBObjSetupExtrasHere]*/
193         setReadOnly("PhoneID");
194         addKey("PhoneID");
195         setLookupObject("ExpUid",
196                 "com.jcorporate.expresso.security.dbobj.DefaultUserInfo");
197         addKey("ExpUid");
198         setMultiValued(FLD_TYPE);
199     }
200 
201     /**
202      * @throws DBException
203      */
204     public void update()
205             throws DBException {
206         setField("UpdatedOn", DateTime.getDateTimeForDB(this.getDataContext()));
207         super.update();
208     } /* update() */
209 
210 
211 } /* PersonalData */
212 
213 /* PersonalData */
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags