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 02/23/2005 Prabin & Neena Created
32 02/23/2005 Neena Documentation
33 --->
34
35 <cfparam name="URL.EditContact" default="no">
36
37 <cfif #URL.fuseaction# IS "EditContacts" or #URl.fuseaction# is "editcontacts1">
38 <cfquery name="getcontacts" datasource="#programsdb#">
39 Select *
40 From dContacts, dOrganization
41 Where dContacts.OrgID = dOrganization.OrgID
42 And dOrganization.OrgID = #URL.OrgID#
43 neenan 1.1
44 </cfquery>
45 </cfif>
46
47 <cfif #URL.EditContact# IS "YES">
48 <cfquery name="getcontactsinfo" datasource="#programsdb#">
49 Select *
50 From dContacts, dOrganization
51 Where dContacts.OrgID = dOrganization.OrgID
52 And dOrganization.OrgID = #URL.OrgID#
53 And dContacts.ContactID = #URL.ContactID#
54 </cfquery>
55
56 <cfif #getcontactsinfo.WorkPhone# EQ "" OR #getcontactsinfo.WorkPhone# EQ "N/A">
57 <cfset WorkPhone_Area = "">
58 <cfset WorkPhone_Prefix = "">
59 <cfset WorkPhone_Num = "">
60
61 <cfelse>
62 <cfset WorkPhone_Area = Left(getcontactsinfo.WorkPhone, 3)>
63 <cfset WorkPhone_Prefix = Mid(getcontactsinfo.WorkPhone, 5, 3)>
64 neenan 1.1 <cfset WorkPhone_Num = right(getcontactsinfo.WorkPhone, 4)>
65 </cfif>
66
67
68 <cfif #getcontactsinfo.FaxNumber# EQ "" OR #getcontactsinfo.FaxNumber# EQ "N/A">
69 <cfset FaxNumber_Area = "">
70 <cfset FaxNumber_Prefix = "">
71 <cfset FaxNumber_Num = "">
72
73 <cfelse>
74 <cfset FaxNumber_Area = Left(getcontactsinfo.FaxNumber, 3)>
75 <cfset FaxNumber_Prefix = Mid(getcontactsinfo.FaxNumber, 5, 3)>
76 <cfset FaxNumber_Num = right(getcontactsinfo.FaxNumber, 4)>
77 </cfif>
78
79
80 <cfif #getcontactsinfo.MobilePhone# EQ "" OR #getcontactsinfo.MobilePhone# EQ "N/A">
81 <cfset MobilePhone_Area = "">
82 <cfset MobilePhone_Prefix = "">
83 <cfset MobilePhone_Num = "">
84 <cfelse>
85 neenan 1.1 <cfset MobilePhone_Area = Left(getcontactsinfo.MobilePhone, 3)>
86 <cfset MobilePhone_Prefix = Mid(getcontactsinfo.MobilePhone, 5, 3)>
87 <cfset MobilePhone_Num = right(getcontactsinfo.MobilePhone, 4)>
88 </cfif>
89 </cfif>
90
91 <!-- #BeginEditable "Content" -->
92 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
93 <tr>
94 <td>
95 <p>
96 <span class="subheading">
97 EDIT A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
98 EDIT CONTACT INFO <img src="../images/siteimage/dart.gif" border="0"></span>
99 <span class="sublink2">Step 2 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
100
101
102
103
104 <cfif getcontacts.recordcount gt 0>
105 <cfoutput query="getcontacts">
106 neenan 1.1 <span class="redtext">* Required Fields</span>
107 <br><br>
108 Please click on contact person's name to update information.<br><br>
109 <cfif #URL.fuseaction# Is "EditContacts1">
110 <a href="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=#OrgID#&ContactID=#ContactID#&EditContact=yes" class="linktext2">
111 <cfelseif #URL.fuseaction# Is "EditContacts">
112 <a href="addeditprograms.cfm?fuseaction=EditContacts&OrgID=#OrgID#&ContactID=#ContactID#&EditContact=yes" class="linktext2">
113 </cfif>
114 <strong>#FirstName# #LastName#</strong></a>
115 </cfoutput>
116 <cfelse>
117 <a href="addeditprograms.cfm?fuseaction=NewContact&OrgID=<cfoutput>#URL.orgid#</cfoutput>" class="linktext2">
118 <strong>Add a contact</strong></a>
119 </cfif>
120
121
122 <cfif #URL.fuseaction# is "editcontacts1" and #URL.EditContact# is "yes">
123 <form name="editContact" action="addeditprograms.cfm?fuseaction=EditMoreContacts1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onclick="return namevalidate(this);" method="post">
124 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
125 <cfoutput query="getcontactsinfo">
126 <tr>
127 neenan 1.1 <td><div class="formtext">Primary ?</td></div>
128 <td><cfif #Primary# is "1">
129 <input type="checkbox" name="Primary" value="1" checked>
130 <cfelse>
131 <input type="checkbox" name="Primary" value="1">
132 </cfif>
133 </td>
134 </tr>
135 <tr>
136 <td><div class="formtext">Prefix</td>
137 <td><input type="text" name="Prefix" size="4" value="#Prefix#"></div></td>
138 </tr>
139 <tr>
140 <td><div class="formtext">First Name <font style="color: red">*</font></td>
141 <td><input type="text" size="15" name="FirstName" value="#FirstName#">
142 <input type="hidden" name="FirstName_required" value="Please enter contact person's first name, or enter 'n/a'.">
143 </td>
144 </tr>
145 <tr>
146 <td><div class="formtext">Middle</td>
147 <td><input type="text" size="1" name="Middle"></div></td>
148 neenan 1.1 </tr>
149 <tr>
150 <td><div class="formtext">Last Name <font style="color: red">*</font></td>
151 <td><input type="text" size="15" name="LastName" value="#LastName#">
152 <input type="hidden" name="LastName_required" value="Please enter contact person's last name, or enter 'n/a'.">
153 </td>
154 </tr>
155 <tr>
156 <td><div class="formtext">Suffix </td>
157 <td><input type="text" size="5" name="NameSuffix" value="#NameSuffix#"></td>
158 </tr>
159 <tr>
160 <td><div class="formtext">Title</td>
161 <td><input type="text" size="20" name="Title" value="#Title#"></td>
162 </tr>
163 <tr>
164 <td><div class="formtext">Address</td>
165 <td>
166 <input type="text" size="25" name="Address" value="#Address#"></div>
167 </td>
168 </tr>
169 neenan 1.1 <tr>
170 <td><div class="formtext">City</td>
171 <td align="justified" nowrap>
172 <input type="text" size="25" name="City" value="#City#"></div>
173 </td>
174 </tr>
175 <tr>
176 <td><div class="formtext">State</td>
177 <td><select name="State">
178 <option value="AL" selected> Alabama</option>
179 <option value="AK"> Alaska</option>
180 <option value="AZ"> Arizona</option>
181 <option value="AR"> Arkansas</option>
182 <option value="CA"> California</option>
183 <option value="CO"> Colorado</option>
184 <option value="CT"> Connecticut</option>
185 <option value="DE"> Delaware</option>
186 <option value="DC"> District of Columbia</option>
187 <option value="FL"> Florida</option>
188 <option value="GA"> Georgia</option>
189 <option value="HI"> Hawaii</option>
190 neenan 1.1 <option value="ID"> Idaho</option>
191 <option value="IL"> Illinois</option>
192 <option value="IN"> Indiana</option>
193 <option value="IA"> Iowa</option>
194 <option value="KS"> Kansas</option>
195 <option value="KY"> Kentucky</option>
196 <option value="LA"> Louisiana</option>
197 <option value="ME"> Maine</option>
198 <option value="MD"> Maryland</option>
199 <option value="MA"> Massachusetts</option>
200 <option value="MI"> Michigan</option>
201 <option value="MN"> Minnesota</option>
202 <option value="MS"> Mississippi</option>
203 <option value="MO"> Missouri</option>
204 <option value="MT"> Montana</option>
205 <option value="NE"> Nebraska</option>
206 <option value="NV"> Nevada</option>
207 <option value="NH"> New Hampshire</option>
208 <option value="NJ"> New Jersey</option>
209 <option value="NM"> New Mexico</option>
210 <option value="NY"> New York</option>
211 neenan 1.1 <option value="NC"> North Carolina</option>
212 <option value="ND"> North Dakota</option>
213 <option value="OH"> Ohio</option>
214 <option value="OK"> Oklahoma</option>
215 <option value="OR"> Oregon</option>
216 <option value="PA"> Pennsylvania</option>
217 <option value="RI"> Rhode Island</option>
218 <option value="SC"> South Carolina</option>
219 <option value="SD"> South Dakota</option>
220 <option value="TN"> Tennessee</option>
221 <option value="TX"> Texas</option>
222 <option value="UT"> Utah</option>
223 <option value="VT"> Vermont</option>
224 <option value="VA"> Virginia</option>
225 <option value="WA"> Washington</option>
226 <option value="WV"> West Virginia</option>
227 <option value="WI"> Wisconsin</option>
228 <option value="WY"> Wyoming</option>
229 <option value="Other"> Other</option>
230 </select></div>
231 </td>
232 neenan 1.1 </tr>
233 <tr>
234 <td><div class="formtext">Zip</td>
235 <td align="justified" nowrap>
236 <input type="text" size="10" name="Zip" value="#Zip#"></div>
237 </td>
238 </tr>
239 <tr>
240 <td><div class="formtext">Country </td>
241 <td><input type="text" size="18" name="Country" value="United States"></div>
242 </td>
243 </tr>
244
245
246 <tr>
247 <td><div class="formtext">Contact Phone</td>
248 <td><input type="Text" size="3" maxlength="3" name="WorkPhone_Area">-
249 <input type="Text" size="3" maxlength="3" name="WorkPhone_Prefix">-
250 <input type="Text" size="4" maxlength="4" name="WorkPhone_Num">
251 <font class="formtext">Ext.</font>
252 <input type="text" size="5" name="WorkExtension">
253 neenan 1.1 </td>
254 </tr>
255 <tr>
256 <td><div class="formtext">Contact Fax</td>
257 <td><input type="Text" size="3" maxlength="3" name="FaxNumber_Area">-
258 <input type="Text" size="3" maxlength="3" name="FaxNumber_Prefix">-
259 <input type="Text" size="4" maxlength="4" name="FaxNumber_Num"></div>
260 </td>
261 </tr>
262 <tr>
263 <td><div class="formtext">Mobile Phone</td>
264 <td><input type="Text" size="3" maxlength="3" name="MobilePhone_Area">-
265 <input type="Text" size="3" maxlength="3" name="MobilePhone_Prefix">-
266 <input type="Text" size="4" maxlength="4" name="MobilePhone_Num"></div>
267 </td>
268 </tr>
269 <tr>
270 <td><div class="formtext">Email</td>
271 <td colspan="3"><input type="text" size="40" name="EmailName" value="@"></div></td>
272 </tr>
273 <tr>
274 neenan 1.1 <td> </td>
275 </tr>
276 <tr>
277 <td> </td>
278 <td><div class="formtext"><INPUT type="submit" value="EditContact">
279 <INPUT type="Hidden" name="contactID" value="#URL.ContactID#">
280 <INPUT type="reset" value="Reset"></div></td>
281 </tr>
282 </cfoutput>
283 </table>
284 </form>
285
286 <cfelseif #URL.fuseaction# is "editcontacts" and #URL.EditContact# is "yes">
287 <form name="editContact" action="addeditprograms.cfm?fuseaction=EditMoreContacts&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return namevalidate(this);" method="post">
288 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
289 <cfoutput query="getcontactsinfo">
290 <tr>
291 <td><div class="formtext">Primary ?</td></div>
292 <td><cfif #Primary# is "1">
293 <input type="checkbox" name="Primary" value="1" checked>
294 <cfelse>
295 neenan 1.1 <input type="checkbox" name="Primary" value="1">
296 </cfif>
297 </td>
298 </tr>
299 <tr>
300 <td><div class="formtext">Prefix</td>
301 <td><input type="text" name="Prefix" size="4" value="#Prefix#"></div></td>
302 </tr>
303 <tr>
304 <td><div class="formtext">First Name <font style="color: red">*</font></td>
305 <td><input type="text" size="15" name="FirstName" value="#FirstName#">
306 <input type="hidden" name="FirstName_required" value="Please enter contact person's first name, or enter 'n/a'.">
307 </td>
308 </tr>
309 <tr>
310 <td><div class="formtext">Middle</td>
311 <td><input type="text" size="1" name="Middle"></div></td>
312 </tr>
313 <tr>
314 <td><div class="formtext">Last Name <font style="color: red">*</font></td>
315 <td><input type="text" size="15" name="LastName" value="#LastName#">
316 neenan 1.1 <input type="hidden" name="LastName_required" value="Please enter contact person's last name, or enter 'n/a'.">
317 </td>
318 </tr>
319 <tr>
320 <td><div class="formtext">Suffix </td>
321 <td><input type="text" size="5" name="NameSuffix" value="#NameSuffix#"></td>
322 </tr>
323 <tr>
324 <td><div class="formtext">Title</td>
325 <td><input type="text" size="20" name="Title" value="#Title#"></td>
326 </tr>
327 <tr>
328 <td><div class="formtext">Address</td>
329 <td>
330 <input type="text" size="25" name="Address" value="#Address#"></div>
331 </td>
332 </tr>
333 <tr>
334 <td><div class="formtext">City</td>
335 <td align="justified" nowrap>
336 <input type="text" size="25" name="City" value="#City#"></div>
337 neenan 1.1 </td>
338 </tr>
339 <tr>
340 <td><div class="formtext">State</td>
341 <td><select name="State">
342 <option value="AL" selected> Alabama</option>
343 <option value="AK"> Alaska</option>
344 <option value="AZ"> Arizona</option>
345 <option value="AR"> Arkansas</option>
346 <option value="CA"> California</option>
347 <option value="CO"> Colorado</option>
348 <option value="CT"> Connecticut</option>
349 <option value="DE"> Delaware</option>
350 <option value="DC"> District of Columbia</option>
351 <option value="FL"> Florida</option>
352 <option value="GA"> Georgia</option>
353 <option value="HI"> Hawaii</option>
354 <option value="ID"> Idaho</option>
355 <option value="IL"> Illinois</option>
356 <option value="IN"> Indiana</option>
357 <option value="IA"> Iowa</option>
358 neenan 1.1 <option value="KS"> Kansas</option>
359 <option value="KY"> Kentucky</option>
360 <option value="LA"> Louisiana</option>
361 <option value="ME"> Maine</option>
362 <option value="MD"> Maryland</option>
363 <option value="MA"> Massachusetts</option>
364 <option value="MI"> Michigan</option>
365 <option value="MN"> Minnesota</option>
366 <option value="MS"> Mississippi</option>
367 <option value="MO"> Missouri</option>
368 <option value="MT"> Montana</option>
369 <option value="NE"> Nebraska</option>
370 <option value="NV"> Nevada</option>
371 <option value="NH"> New Hampshire</option>
372 <option value="NJ"> New Jersey</option>
373 <option value="NM"> New Mexico</option>
374 <option value="NY"> New York</option>
375 <option value="NC"> North Carolina</option>
376 <option value="ND"> North Dakota</option>
377 <option value="OH"> Ohio</option>
378 <option value="OK"> Oklahoma</option>
379 neenan 1.1 <option value="OR"> Oregon</option>
380 <option value="PA"> Pennsylvania</option>
381 <option value="RI"> Rhode Island</option>
382 <option value="SC"> South Carolina</option>
383 <option value="SD"> South Dakota</option>
384 <option value="TN"> Tennessee</option>
385 <option value="TX"> Texas</option>
386 <option value="UT"> Utah</option>
387 <option value="VT"> Vermont</option>
388 <option value="VA"> Virginia</option>
389 <option value="WA"> Washington</option>
390 <option value="WV"> West Virginia</option>
391 <option value="WI"> Wisconsin</option>
392 <option value="WY"> Wyoming</option>
393 <option value="Other"> Other</option>
394 </select></div>
395 </td>
396 </tr>
397 <tr>
398 <td><div class="formtext">Zip</td>
399 <td align="justified" nowrap>
400 neenan 1.1 <input type="text" size="10" name="Zip" value="#Zip#"></div>
401 </td>
402 </tr>
403 <tr>
404 <td><div class="formtext">Country </td>
405 <td><input type="text" size="18" name="Country" value="United States"></div>
406 </td>
407 </tr>
408
409
410 <tr>
411 <td><div class="formtext">Contact Phone</td>
412 <td><input type="Text" size="3" maxlength="3" name="WorkPhone_Area">-
413 <input type="Text" size="3" maxlength="3" name="WorkPhone_Prefix">-
414 <input type="Text" size="4" maxlength="4" name="WorkPhone_Num">
415 <font class="formtext">Ext.</font>
416 <input type="text" size="5" name="WorkExtension">
417 </td>
418 </tr>
419 <tr>
420 <td><div class="formtext">Contact Fax</td>
421 neenan 1.1 <td><input type="Text" size="3" maxlength="3" name="FaxNumber_Area">-
422 <input type="Text" size="3" maxlength="3" name="FaxNumber_Prefix">-
423 <input type="Text" size="4" maxlength="4" name="FaxNumber_Num"></div>
424 </td>
425 </tr>
426 <tr>
427 <td><div class="formtext">Mobile Phone</td>
428 <td><input type="Text" size="3" maxlength="3" name="MobilePhone_Area">-
429 <input type="Text" size="3" maxlength="3" name="MobilePhone_Prefix">-
430 <input type="Text" size="4" maxlength="4" name="MobilePhone_Num"></div>
431 </td>
432 </tr>
433 <tr>
434 <td><div class="formtext">Email</td>
435 <td colspan="3"><input type="text" size="40" name="EmailName" value="@"></div></td>
436 </tr>
437 <tr>
438 <td> </td>
439 </tr>
440 <tr>
441 <td> </td>
442 neenan 1.1 <td><div class="formtext">
443 <INPUT type="submit" value="Edit Contact">
444 <INPUT type="Hidden" name="contactID" value="#URL.ContactID#">
445 <INPUT type="reset" value="Reset"></div></td>
446 </tr>
447 </cfoutput>
448 </table>
449 </form>
450 </cfif>
451 </td>
452 </tr>
453 </table>
454 </p>
|
Return to
dsp_editcontact.cfm
CVS log
Up to [Development] / p2rx-programs