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

CVS Admin