p2rx-programs/dsp_editcontact.cfm - annotate

Return to dsp_editcontact.cfm CVS log

Up to [Development] / p2rx-programs

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

CVS Admin