1 neenan 1.1 <!--- Name: dsp_editcontact.cfm
2 Purpose: It helps to edit an existing contact information while editing the recently added organization
3 and related information in the database. It also transfers all the form variables to act_updatecontact.cfm
4 and the actual action of updating the data in the dcontact table. URL.ContactID is passed on to the action
5 form to retreive the necessary contact info.
6 Date created: 02/23/2005
7 Dependancy: URL.Orgid and URL.ContactID
8 Variables: Primary - Primary contact or not
9 FirstName - First Name of the contact(Required)
10 Middle - Middle name of the contact if applicable.
11 LastName - Phone Number of the organization (Required)
12 NameSuffix - Suffix such as Mr, Mrs or Miss
13 Title - Title of the contact
14 Address - Postal address of the contact
15 City- Contact's city name
16 Zip - Zip code for the contact's address
17 Country - Country of official residence.
18 WorkPhone_Area - Work Phone Area Number of the contact
19 WorkPhone_Prefix - Work Phone Prefix of the contact
20 WorkPhone_Num - Work Phone Number of the contact
21 WorkExtension - Extension if applicable
22 neenan 1.1 FaxNumber_Area - Fax Area Number of the contact
23 FaxNumber_Prefix - Fax Number Prefix of the contact
24 FaxNumber_Num - Fax Number of the contact
25 MobilePhone_Area - Mobile Phone Area of the contact
26 MobilePhone_Prefix - Mobile Phone Prefix of the contact
27 MobilePhone_Num - Mobile Phone Number of the contact
28 EmailName - Email of the contact
29 Functions:
30 Date changed:
|
31 pKanel 1.4 02/23/2005 Prabin & Neena Created
32 02/23/2005 Neena Documentation
33 03/22/2005 Neena Commented out the Span and image tags
34 08/15/2005 Terry Added hyperlink for user to skip step
35 08/26/2005 Prabin Added qery to get states and populate
36 the value of the state.
|
37 neenan 1.1 --->
38
39 <cfparam name="URL.EditContact" default="no">
40
41 <cfif #URL.fuseaction# IS "EditContacts" or #URl.fuseaction# is "editcontacts1">
42 <cfquery name="getcontacts" datasource="#programsdb#">
43 Select *
44 From dContacts, dOrganization
45 Where dContacts.OrgID = dOrganization.OrgID
46 And dOrganization.OrgID = #URL.OrgID#
47
48 </cfquery>
49 </cfif>
50
51 <cfif #URL.EditContact# IS "YES">
52 <cfquery name="getcontactsinfo" datasource="#programsdb#">
53 Select *
54 From dContacts, dOrganization
55 Where dContacts.OrgID = dOrganization.OrgID
56 And dOrganization.OrgID = #URL.OrgID#
57 And dContacts.ContactID = #URL.ContactID#
58 neenan 1.1 </cfquery>
59
60 <cfif #getcontactsinfo.WorkPhone# EQ "" OR #getcontactsinfo.WorkPhone# EQ "N/A">
61 <cfset WorkPhone_Area = "">
62 <cfset WorkPhone_Prefix = "">
63 <cfset WorkPhone_Num = "">
64
65 <cfelse>
66 <cfset WorkPhone_Area = Left(getcontactsinfo.WorkPhone, 3)>
67 <cfset WorkPhone_Prefix = Mid(getcontactsinfo.WorkPhone, 5, 3)>
68 <cfset WorkPhone_Num = right(getcontactsinfo.WorkPhone, 4)>
69 </cfif>
70
71
72 <cfif #getcontactsinfo.FaxNumber# EQ "" OR #getcontactsinfo.FaxNumber# EQ "N/A">
73 <cfset FaxNumber_Area = "">
74 <cfset FaxNumber_Prefix = "">
75 <cfset FaxNumber_Num = "">
76
77 <cfelse>
78 <cfset FaxNumber_Area = Left(getcontactsinfo.FaxNumber, 3)>
79 neenan 1.1 <cfset FaxNumber_Prefix = Mid(getcontactsinfo.FaxNumber, 5, 3)>
80 <cfset FaxNumber_Num = right(getcontactsinfo.FaxNumber, 4)>
81 </cfif>
82
83
84 <cfif #getcontactsinfo.MobilePhone# EQ "" OR #getcontactsinfo.MobilePhone# EQ "N/A">
85 <cfset MobilePhone_Area = "">
86 <cfset MobilePhone_Prefix = "">
87 <cfset MobilePhone_Num = "">
88 <cfelse>
89 <cfset MobilePhone_Area = Left(getcontactsinfo.MobilePhone, 3)>
90 <cfset MobilePhone_Prefix = Mid(getcontactsinfo.MobilePhone, 5, 3)>
91 <cfset MobilePhone_Num = right(getcontactsinfo.MobilePhone, 4)>
92 </cfif>
93 </cfif>
94
95 <!-- #BeginEditable "Content" -->
96 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
97 <tr>
98 <td>
99 <p>
|
100 neenan 1.2 <!--- <span class="subheading"> --->
101 EDIT A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
102 EDIT CONTACT INFO <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
|
103 pKanel 1.4 <!--- <span class="sublink2"> --->Step 2 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
|
104 neenan 1.1
105 <cfif getcontacts.recordcount gt 0>
106 <cfoutput query="getcontacts">
|
107 neenan 1.2 <!--- <span class="redtext"> --->* Required Fields<!--- </span> --->
|
108 neenan 1.1 <br><br>
|
109 pKanel 1.4 Please click on contact person's name to update information or click <a href="addeditprograms.cfm?fuseaction=editProgramTypes1&OrgID=<cfoutput>#URl.Orgid#</cfoutput>"><strong>here</strong></a> to proceed to the next step.<br><br>
|
110 neenan 1.1 <cfif #URL.fuseaction# Is "EditContacts1">
111 <a href="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=#OrgID#&ContactID=#ContactID#&EditContact=yes" class="linktext2">
112 <cfelseif #URL.fuseaction# Is "EditContacts">
113 <a href="addeditprograms.cfm?fuseaction=EditContacts&OrgID=#OrgID#&ContactID=#ContactID#&EditContact=yes" class="linktext2">
114 </cfif>
115 <strong>#FirstName# #LastName#</strong></a>
116 </cfoutput>
117 <cfelse>
118 <a href="addeditprograms.cfm?fuseaction=NewContact&OrgID=<cfoutput>#URL.orgid#</cfoutput>" class="linktext2">
119 <strong>Add a contact</strong></a>
120 </cfif>
|
121 pKanel 1.4
|
122 neenan 1.1
123 <cfif #URL.fuseaction# is "editcontacts1" and #URL.EditContact# is "yes">
124 <form name="editContact" action="addeditprograms.cfm?fuseaction=EditMoreContacts1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onclick="return namevalidate(this);" method="post">
125 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
126 <cfoutput query="getcontactsinfo">
127 <tr>
128 <td><div class="formtext">Primary ?</td></div>
129 <td><cfif #Primary# is "1">
130 <input type="checkbox" name="Primary" value="1" checked>
131 <cfelse>
132 <input type="checkbox" name="Primary" value="1">
133 </cfif>
134 </td>
135 </tr>
136 <tr>
137 <td><div class="formtext">Prefix</td>
138 <td><input type="text" name="Prefix" size="4" value="#Prefix#"></div></td>
139 </tr>
140 <tr>
141 <td><div class="formtext">First Name <font style="color: red">*</font></td>
142 <td><input type="text" size="15" name="FirstName" value="#FirstName#">
143 neenan 1.1 <input type="hidden" name="FirstName_required" value="Please enter contact person's first name, or enter 'n/a'.">
144 </td>
145 </tr>
146 <tr>
147 <td><div class="formtext">Middle</td>
148 <td><input type="text" size="1" name="Middle"></div></td>
149 </tr>
150 <tr>
151 <td><div class="formtext">Last Name <font style="color: red">*</font></td>
152 <td><input type="text" size="15" name="LastName" value="#LastName#">
153 <input type="hidden" name="LastName_required" value="Please enter contact person's last name, or enter 'n/a'.">
154 </td>
155 </tr>
156 <tr>
157 <td><div class="formtext">Suffix </td>
158 <td><input type="text" size="5" name="NameSuffix" value="#NameSuffix#"></td>
159 </tr>
160 <tr>
161 <td><div class="formtext">Title</td>
162 <td><input type="text" size="20" name="Title" value="#Title#"></td>
163 </tr>
164 neenan 1.1 <tr>
165 <td><div class="formtext">Address</td>
166 <td>
167 <input type="text" size="25" name="Address" value="#Address#"></div>
168 </td>
169 </tr>
170 <tr>
171 <td><div class="formtext">City</td>
172 <td align="justified" nowrap>
173 <input type="text" size="25" name="City" value="#City#"></div>
174 </td>
175 </tr>
|
176 pKanel 1.4 </cfoutput>
|
177 neenan 1.1 <tr>
178 <td><div class="formtext">State</td>
|
179 pKanel 1.4 <td>
180 <select name="State">
181 <cfoutput query="getState">
182 <option value="#Abbr#" <cfif #Abbr# EQ #getcontactsinfo.stateOrProvince#> selected </cfif>>#State#</option>
183 </cfoutput>
|
184 neenan 1.1 </select></div>
185 </td>
186 </tr>
|
187 tehuss 1.5 <cfoutput query="getcontactsinfo">
|
188 neenan 1.1 <tr>
189 <td><div class="formtext">Zip</td>
190 <td align="justified" nowrap>
191 <input type="text" size="10" name="Zip" value="#Zip#"></div>
192 </td>
193 </tr>
194 <tr>
195 <td><div class="formtext">Country </td>
196 <td><input type="text" size="18" name="Country" value="United States"></div>
197 </td>
198 </tr>
199
200
201 <tr>
202 <td><div class="formtext">Contact Phone</td>
203 <td><input type="Text" size="3" maxlength="3" name="WorkPhone_Area">-
204 <input type="Text" size="3" maxlength="3" name="WorkPhone_Prefix">-
205 <input type="Text" size="4" maxlength="4" name="WorkPhone_Num">
206 <font class="formtext">Ext.</font>
207 <input type="text" size="5" name="WorkExtension">
208 </td>
209 neenan 1.1 </tr>
210 <tr>
211 <td><div class="formtext">Contact Fax</td>
212 <td><input type="Text" size="3" maxlength="3" name="FaxNumber_Area">-
213 <input type="Text" size="3" maxlength="3" name="FaxNumber_Prefix">-
214 <input type="Text" size="4" maxlength="4" name="FaxNumber_Num"></div>
215 </td>
216 </tr>
217 <tr>
218 <td><div class="formtext">Mobile Phone</td>
219 <td><input type="Text" size="3" maxlength="3" name="MobilePhone_Area">-
220 <input type="Text" size="3" maxlength="3" name="MobilePhone_Prefix">-
221 <input type="Text" size="4" maxlength="4" name="MobilePhone_Num"></div>
222 </td>
223 </tr>
224 <tr>
225 <td><div class="formtext">Email</td>
226 <td colspan="3"><input type="text" size="40" name="EmailName" value="@"></div></td>
227 </tr>
228 <tr>
229 <td> </td>
230 neenan 1.1 </tr>
231 <tr>
232 <td> </td>
233 <td><div class="formtext"><INPUT type="submit" value="EditContact">
234 <INPUT type="Hidden" name="contactID" value="#URL.ContactID#">
235 <INPUT type="reset" value="Reset"></div></td>
236 </tr>
237 </cfoutput>
238 </table>
239 </form>
240
241 <cfelseif #URL.fuseaction# is "editcontacts" and #URL.EditContact# is "yes">
242 <form name="editContact" action="addeditprograms.cfm?fuseaction=EditMoreContacts&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return namevalidate(this);" method="post">
243 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
|
244 pKanel 1.4
|
245 neenan 1.1 <tr>
246 <td><div class="formtext">Primary ?</td></div>
|
247 pKanel 1.4 <cfoutput query="getcontactsinfo">
|
248 neenan 1.1 <td><cfif #Primary# is "1">
249 <input type="checkbox" name="Primary" value="1" checked>
250 <cfelse>
251 <input type="checkbox" name="Primary" value="1">
252 </cfif>
253 </td>
254 </tr>
255 <tr>
256 <td><div class="formtext">Prefix</td>
257 <td><input type="text" name="Prefix" size="4" value="#Prefix#"></div></td>
258 </tr>
259 <tr>
260 <td><div class="formtext">First Name <font style="color: red">*</font></td>
261 <td><input type="text" size="15" name="FirstName" value="#FirstName#">
262 <input type="hidden" name="FirstName_required" value="Please enter contact person's first name, or enter 'n/a'.">
263 </td>
264 </tr>
265 <tr>
266 <td><div class="formtext">Middle</td>
267 <td><input type="text" size="1" name="Middle"></div></td>
268 </tr>
269 neenan 1.1 <tr>
270 <td><div class="formtext">Last Name <font style="color: red">*</font></td>
271 <td><input type="text" size="15" name="LastName" value="#LastName#">
272 <input type="hidden" name="LastName_required" value="Please enter contact person's last name, or enter 'n/a'.">
273 </td>
274 </tr>
275 <tr>
276 <td><div class="formtext">Suffix </td>
277 <td><input type="text" size="5" name="NameSuffix" value="#NameSuffix#"></td>
278 </tr>
279 <tr>
280 <td><div class="formtext">Title</td>
281 <td><input type="text" size="20" name="Title" value="#Title#"></td>
282 </tr>
283 <tr>
284 <td><div class="formtext">Address</td>
285 <td>
286 <input type="text" size="25" name="Address" value="#Address#"></div>
287 </td>
288 </tr>
289 <tr>
290 neenan 1.1 <td><div class="formtext">City</td>
291 <td align="justified" nowrap>
292 <input type="text" size="25" name="City" value="#City#"></div>
293 </td>
294 </tr>
|
295 pKanel 1.4 </cfoutput>
|
296 neenan 1.1 <tr>
297 <td><div class="formtext">State</td>
298 <td><select name="State">
|
299 pKanel 1.4 <cfoutput query="getState">
300 <option value="#Abbr#" <cfif #Abbr# EQ #getcontactsinfo.stateOrProvince#> selected </cfif>>#State#</option>
301 </cfoutput>
|
302 neenan 1.1 </select></div>
303 </td>
304 </tr>
|
305 pKanel 1.4 <cfoutput query="getcontactsinfo">
|
306 neenan 1.1 <tr>
307 <td><div class="formtext">Zip</td>
308 <td align="justified" nowrap>
309 <input type="text" size="10" name="Zip" value="#Zip#"></div>
310 </td>
311 </tr>
312 <tr>
313 <td><div class="formtext">Country </td>
314 <td><input type="text" size="18" name="Country" value="United States"></div>
315 </td>
316 </tr>
317
318
319 <tr>
320 <td><div class="formtext">Contact Phone</td>
321 <td><input type="Text" size="3" maxlength="3" name="WorkPhone_Area">-
322 <input type="Text" size="3" maxlength="3" name="WorkPhone_Prefix">-
323 <input type="Text" size="4" maxlength="4" name="WorkPhone_Num">
324 <font class="formtext">Ext.</font>
325 <input type="text" size="5" name="WorkExtension">
326 </td>
327 neenan 1.1 </tr>
328 <tr>
329 <td><div class="formtext">Contact Fax</td>
330 <td><input type="Text" size="3" maxlength="3" name="FaxNumber_Area">-
331 <input type="Text" size="3" maxlength="3" name="FaxNumber_Prefix">-
332 <input type="Text" size="4" maxlength="4" name="FaxNumber_Num"></div>
333 </td>
334 </tr>
335 <tr>
336 <td><div class="formtext">Mobile Phone</td>
337 <td><input type="Text" size="3" maxlength="3" name="MobilePhone_Area">-
338 <input type="Text" size="3" maxlength="3" name="MobilePhone_Prefix">-
339 <input type="Text" size="4" maxlength="4" name="MobilePhone_Num"></div>
340 </td>
341 </tr>
342 <tr>
343 <td><div class="formtext">Email</td>
344 <td colspan="3"><input type="text" size="40" name="EmailName" value="@"></div></td>
345 </tr>
346 <tr>
347 <td> </td>
348 neenan 1.1 </tr>
349 <tr>
350 <td> </td>
351 <td><div class="formtext">
352 <INPUT type="submit" value="Edit Contact">
353 <INPUT type="Hidden" name="contactID" value="#URL.ContactID#">
354 <INPUT type="reset" value="Reset"></div></td>
355 </tr>
356 </cfoutput>
357 </table>
358 </form>
359 </cfif>
360 </td>
361 </tr>
362 </table>
363 </p>
|
Return to
dsp_editcontact.cfm
CVS log
Up to [Development] / p2rx-programs