Return to dsp_editOrganization.cfm CVS log

Up to [Development] / p2rx-programs

Enhancements made to resolve programs added or udpated by Outsite users.

<!--- 	Name:  dsp_editorganization.cfm
    	Purpose: It helps to edit a currently added organization in your dummy program database. It also transfers
				all the form variables to act_updateorganization.cfm where the actual action of updating the data
				into the table(dorganization) takes place.
		Date created: 02/23/2005
       	Dependancy: None
		Variables: 	OrganizationName - Name of the organization (Required)
					Division - Division of the organization if applicable
					Address1 - Address of the organization (Required)
					Address2 - Remaining part of the organization's address if applicable
					City - City name of Organization's location (Required)
					StateorProvince - Dropdown List values to select the appropriate State(Required)
					PostalCode - Zipcode of the organization address (Required)
					Phone_Area - Phone Area Number of the organization (Required)
					Phone_Prefix - Phone Number Prefix of the organization (Required)
					Phone_Num - Phone Number of the organization (Required)
					Extension - Extension if applicable
					FaxNumber_Area - Fax Area Number of the organization (Required)
					FaxNumber_Prefix - Fax Number Prefix of the organization (Required)
					FaxNumber_Num - Fax Number of the organization (Required)
					TimeZone - TimeZone of the organization (Required)
					EmailName - Email of the organization
					HotLine_Area - HotLine Area Number of the organization 
					HotLine_Prefix - Hotline Number Prefix of the organization
					Hotline_Num - Phone Number of the organization 
					GeoServiceID - Scope of the organization (Required)
									Option - Local(5), Regional(3), State(2), National(1)
					Visitor_ID - ID of the Initial user responsible for adding the organization information.
		Functions: 
		Date changed: 
					02/23/2005			Prabin and Neena 	Created, Documentation
---> 



<cfquery name="editOrg" datasource="#programsdb#">
	Select 	*
	From 	dOrganization
	Where	OrgID = #URL.OrgID#
</cfquery>


<cfquery name="getGeoServices" datasource="#programsdb#">
	Select 	GeoServiceID, GeoService
	From	GeoServices
	Where	GeoServiceID = #editorg.GeoServiceID#
</cfquery>



<cfif 	#EditOrg.Phone# EQ "" OR #EditOrg.Phone# EQ "N/A">
	<cfset Phone_Area = ""> 
	<cfset Phone_Prefix = ""> 	
	<cfset Phone_Num = ""> 

<cfelse>
	<cfset Phone_Area = Left(EditOrg.Phone, 3)> 
	<cfset Phone_Prefix = Mid(EditOrg.Phone, 5, 3)> 	
	<cfset Phone_Num = right(EditOrg.Phone, 4)> 
</cfif>
 

<cfif 	#EditOrg.FaxNumber# EQ "" OR #EditOrg.FaxNumber# EQ "N/A">
		<cfset FaxNumber_Area = ""> 
		<cfset FaxNumber_Prefix = ""> 
		<cfset FaxNumber_Num = ""> 

<cfelse>
	<cfset FaxNumber_Area = Left(EditOrg.FaxNumber, 3)> 
	<cfset FaxNumber_Prefix = Mid(EditOrg.FaxNumber, 5, 3)> 
	<cfset FaxNumber_Num = right(EditOrg.FaxNumber, 4)> 
</cfif>


<cfif 	#EditOrg.Hotline# EQ "" OR #EditOrg.Hotline# EQ "N/A">
	<cfset Hotline_Area = ""> 
	<cfset Hotline_Prefix = ""> 
	<cfset Hotline_Num = ""> 
<cfelse>
	<cfset Hotline_Area = Left(EditOrg.Hotline, 3)> 
	<cfset Hotline_Prefix = Mid(EditOrg.Hotline, 5, 3)> 
	<cfset Hotline_Num = right(EditOrg.Hotline, 4)> 
</cfif>


<!-- #BeginEditable "Content" -->
<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
        <tr> 
          <td> 
            <p>	
			<span class="subheading">
					EDIT A PROGRAM <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
				ORGANIZATION INFO <!--- <img src="../images/siteimage/dart.gif" border="0"> ---></span>
				<span class="sublink2">Step 1<!---  <img src="../images/siteimage/dart.gif" border="0"> ---></span><br><br>
			<span class="redtext">* Required Fields</span>

		<cfif #URL.fuseaction# IS "EditOrg"> 
		<form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
		<cfelseif #URL.fuseaction# IS "Editorganization"> 
		<form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
		</cfif>

			<cfoutput query="EditORG">
			<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="##F4FFE9">
				<tr>
					<td><div class="formtext">Organization <font style="color: red">*</font></td>
					<td><input type="hidden" size="3" name="statename" value="#EditORG.StateOrProvince#">
						<input type="text" size="50" name="OrganizationName" value="#OrganizationName#" onfocus="return getStateOption3('addorg')"></div>
						<input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
											
					</td>
				</tr>
				<tr>
					<td><div class="formtext">Division</td>
					<td><input type="text" size="40" name="Division" value="#Division#"></div></td>
					
				</tr>
				<tr>
					<td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
					<td><input type="text" size="40" name="Address1" value="#Address1#"></div>
						<input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
					</td>
				</tr>
				<tr>
					<td nowrap><div class="formtext">Address 2</td>
					<td><input type="text" size="40" name="Address2" value="#Address2#" ></div></td>
				</tr>
				<tr>
					<td><div class="formtext">City <font style="color: red">*</font></td>
					<td align="justified" nowrap>
						<input type="text" size="25" name="City" value="#City#"></div>
						<input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
					</td>
				</tr>
				</cfoutput>
				<tr>	
					<td><div class="formtext"><font style="color: red">*</font>State</td>
					<td>
					<select name="State">
							<cfoutput query="getState">
							<option value="#Abbr#" <cfif #Abbr# EQ #editOrg.stateOrProvince#> selected </cfif>>#State#</option>
							</cfoutput>
					</select></div>
					</td>
				</tr>
				<cfoutput query="EditORG">
				<tr>
					<td><div class="formtext">Zip <font style="color: red">*</font></td>
					<td align="justified" nowrap>
						<input type="text" size="10" name="PostalCode" value="#PostalCode#"></div>
						<input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
					</td>
				</tr>
				<tr>
					<td><div class="formtext">Country<font style="color: red">*</font>&nbsp;</td>
					<td><input type="text" size="18" name="Country" value="United States"></div>
						<input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
					</td>
				</tr>			
				
				
				<tr>
					<td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
					<td><input type="Text" size="3" maxlength="3" name="Phone_Area" value="#Phone_Area#">-
						<input type="Text" size="3" maxlength="3" name="Phone_Prefix" value="#Phone_Prefix#">-
						<input type="Text" size="4" maxlength="4" name="Phone_Num" value="#Phone_Num#">
						<input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
						<input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
						<input type="hidden" name="Phone_Num_required" value="Please enter the numer of phone number, or enter 'n/a'.">		
					    <font class="formtext">Ext.</font>
						<input type="text" size="5" name="Extension">
					</td>
				</tr>
				<tr>
					<td><div class="formtext">Organization Fax</td>
					<td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3" value="#FaxNumber_Area#">-
						<input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3"  value="#FaxNumber_Prefix#">-
						<input type="Text" name="FaxNumber_Num" size="4" maxlength="4" value="#FaxNumber_Num#"></div>
					</td>
				</tr>
				<tr>
					<td><div class="formtext">Hotline</td>
					<td><input type="Text" name="Hotline_Area" size="3" maxlength="3" value="#Hotline_Area#">-
						<input type="Text" name="Hotline_Prefix" size="3" maxlength="3" value="#Hotline_Prefix#">-
						<input type="Text" name="Hotline_Num" size="4" maxlength="4" value="#Hotline_Num#"></div>
					</td>
				</tr>

				<tr>
					<td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
					<td><select name="TimeZone">
							<option value="#TimeZone#" selected> #TimeZone# </option>
							<option value="Pacific"> Pacific</option>
							<option value="Mountain"> Mountain</option>
							<option value="Central"> Central</option>
							<option value="Eastern"> Eastern</option>
							<option value="Atlantic"> Atlantic</option>
							<option value="Other"> Other</option>
						</select></div>
					</td>
				</tr>
				<tr>
					<td><div class="formtext">Email</td>
					<td><input type="text" size="40" name="EmailName" value="#EmailName#"></div></td>
				</tr>
				</cfoutput>
				<tr>
				
					<td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
					<td><select name="GeoServiceID">
							<cfoutput query="getgeoservices">
								<option value="#GeoServiceID#" selected>#GeoService#</option>
								</cfoutput>								
								<option value="5" > Local</option>
								<option value="3"> Regional</option>
								<option value="2"> State</option>
								<option value="1"> National</option>
						</select> </div>
					</td>
	
				</tr>
				<tr>
				<tr>
				<cfoutput query="EditORG">
					<td><div class="formtext">URL <font style="color: red">*</font></td>
					<td><input type="text" size="40" name="URL" value="#URL#"></div>
						<input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
					</td>
				</tr>
				<tr>	
					<td><div class="formtext">Graphic URL</td>
					<td><input type="text" size="40" name="GraphicURL" value="#GraphicURL#"></div></td>
				</tr>
				<tr>
					<td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
					<td><textarea cols="35" rows="10" align="top" name="Profile">#Profile#</textarea></div>
						<input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
					</td>
				</tr>	
				<tr>
					<td>&nbsp;</td>
				</tr>
				<tr> 
					<td>&nbsp;</td>
      				<td><div class="formtext"><INPUT type="submit" value="Edit Organization">
	  				<INPUT type="reset" value="Reset"></div></td>
    			</tr>
			</cfoutput>	
		</table>
	</form>
</td>
</tr>
</table>
</p>