(file) Return to dsp_AddOrganization.cfm CVS log (file) (dir) Up to [Development] / p2rx-programs

  1 neenan 1.1 <!--- 	Name:  dsp_Addorganization.cfm
  2                	Purpose: It helps to add a organization in your dummy program database. It also transfers
  3            				all the form variables to act_addorganization.cfm where the actual action of inserting the data
  4            				into the table(dorganization) takes place.
  5            		Date created: 02/23/2005
  6                   	Dependancy: vtime - value of date being passed from dsp_Usersform.cfm that stores the unique date/time value at which the 
  7            					visitor/initial contact saved changes to the database.this value is used to remove any conflicts between other users
  8            					using the same form.
  9            		Variables: 	OrganizationName - Name of the organization (Required)
 10            					Division - Division of the organization if applicable
 11            					Address1 - Address of the organization (Required)
 12            					Address2 - Remaining part of the organization's address if applicable
 13            					City - City name of Organization's location (Required)
 14            					StateorProvince - Dropdown List values to select the appropriate State(Required)
 15            					PostalCode - Zipcode of the organization address (Required)
 16            					Phone_Area - Phone Area Number of the organization (Required)
 17            					Phone_Prefix - Phone Number Prefix of the organization (Required)
 18            					Phone_Num - Phone Number of the organization (Required)
 19            					Extension - Extension if applicable
 20            					FaxNumber_Area - Fax Area Number of the organization (Required)
 21            					FaxNumber_Prefix - Fax Number Prefix of the organization (Required)
 22 neenan 1.1 					FaxNumber_Num - Fax Number of the organization (Required)
 23            					TimeZone - TimeZone of the organization (Required)
 24            					EmailName - Email of the organization
 25            					HotLine_Area - HotLine Area Number of the organization 
 26            					HotLine_Prefix - Hotline Number Prefix of the organization
 27            					Hotline_Num - Phone Number of the organization 
 28            					GeoServiceID - Scope of the organization (Required)
 29            									Option - Local(5), Regional(3), State(2), National(1)
 30            					Visitor_ID - ID of the Initial user responsible for adding the organization information.
 31            					
 32            					Functions: 
 33            		Date changed: 
 34 pKanel 1.3 					02/23/2005		Prabin and Neena 	Created, Documentation
 35            					08/26/2005		Prabin				Added query so that states will be 
 36            														populated from the table.	
 37 neenan 1.1 ---> 
 38            
 39            
 40            
 41            <cfquery name="getGeoServices" datasource="#programsdb#">
 42            	Select 	GeoServiceID, GeoService
 43            	From	GeoServices
 44            </cfquery>
 45            
 46            <cfoutput>
 47            <cfquery name="GetvisitorID" datasource="#ProgramsDB#">
 48            	Select 		*
 49            	From 		OutsideUsers 
 50            	Where  vtime like '#userdate#'
 51            </cfquery>
 52            </cfoutput>
 53            
 54 pKanel 1.3 <!-- #BeginEditable "Content" -->
 55 neenan 1.1 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
 56                    <tr> 
 57                      <td> 
 58                        <p>	
 59 pKanel 1.3 			<span class="subheading">
 60            					ADD	A PROGRAM <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
 61            				ORGANIZATION INFO <!--- <img src="../images/siteimage/dart.gif" border="0"> ---></span>
 62            				<span class="sublink2">Step 1 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
 63            			<span class="redtext"><font style="color: red">* Required Fields</font></span>
 64 neenan 1.1 
 65            
 66            		<form name="addorg" action="addeditprograms.cfm?fuseaction=AddContacts" method="post">
 67            			<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
 68            				<tr>
 69            					<td><div class="formtext">Organization <font style="color: red">*</font></td>
 70            					<td><input type="text" size="40" name="OrganizationName" ></div>
 71            						<input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
 72            					</td>
 73            				</tr>
 74            				<tr>
 75            					<td><div class="formtext">Division</td>
 76            					<td><input type="text" size="40" name="Division" ></div></td>
 77            				</tr>
 78            				<tr>
 79            					<td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
 80            					<td><input type="text" size="40" name="Address1" ></div>
 81            						<input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
 82            					</td>
 83            				</tr>
 84            				<tr>
 85 neenan 1.1 					<td nowrap><div class="formtext">Address 2</td>
 86            					<td><input type="text" size="40" name="Address2" ></div></td>
 87            				</tr>
 88            				<tr>
 89            					<td><div class="formtext">City <font style="color: red">*</font></td>
 90            					<td align="justified" nowrap>
 91            						<input type="text" size="25" name="City" ></div>
 92            						<input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
 93            					</td>
 94            				</tr>
 95            				<tr>	
 96            					<td><div class="formtext">State <font style="color: red">*</font></td>
 97            					<td><select name="StateOrProvince">
 98 pKanel 1.3 							<cfoutput query="getState">
 99            							<option value="#Abbr#">#State#</option>
100            							</cfoutput>
101            					</select>
102            					
103            					
104            					
105            					</div>
106 neenan 1.1 					</td>
107            				</tr>
108            				<tr>
109            					<td><div class="formtext">Zip <font style="color: red">*</font></td>
110            					<td align="justified" nowrap>
111            						<input type="text" size="10" name="PostalCode" ></div>
112            						<input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
113            					</td>
114            				</tr>
115            				<tr>
116            					<td><div class="formtext">Country<font style="color: red">*</font>&nbsp;</td>
117            					<td><input type="text" size="18" name="Country" value="United States"></div>
118            						<input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
119            					</td>
120            				</tr>			
121            				
122            				
123            				<tr>
124            					<td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
125            					<td><input type="Text" size="3" maxlength="3" name="Phone_Area">-
126            						<input type="Text" size="3" maxlength="3" name="Phone_Prefix">-
127 neenan 1.1 						<input type="Text" size="4" maxlength="4" name="Phone_Num">
128            						<input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
129            						<input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
130            						<input type="hidden" name="Phone_Num_required" value="Please enter the phone number, or enter 'n/a'.">		
131            					    <font class="formtext">Ext.</font>
132            						<input type="text" size="5" name="Extension">
133            					</td>
134            				</tr>
135            				<tr>
136            					<td><div class="formtext">Organization Fax</td>
137            					<td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3">-
138            						<input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3">-
139            						<input type="Text" name="FaxNumber_Num" size="4" maxlength="4"></div>
140            					</td>
141            				</tr>
142            				<tr>
143            					<td><div class="formtext">Hotline</td>
144            					<td><input type="Text" name="Hotline_Area" size="3" maxlength="3">-
145            						<input type="Text" name="Hotline_Prefix" size="3" maxlength="3">-
146            						<input type="Text" name="Hotline_Num" size="4" maxlength="4"></div>
147            					</td>
148 neenan 1.1 				</tr>
149            
150            				<tr>
151            					<td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
152            					<td><select name="TimeZone">
153            							<option value="Pacific" selected> Pacific</option>
154            							<option value="Mountain"> Mountain</option>
155            							<option value="Central"> Central</option>
156            							<option value="Eastern"> Eastern</option>
157            							<option value="Atlantic"> Atlantic</option>
158            							<option value="Other"> Other</option>
159            						</select></div>
160            					</td>
161            				</tr>
162            				<tr>
163            					<td><div class="formtext">Email</td>
164            					<td><input type="text" size="40" name="EmailName"></div></td>
165            				</tr>
166            				<tr>
167            					<td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
168            					<td><select name="GeoServiceID">
169 neenan 1.1 						<cfoutput query="getgeoServices">
170            							<option value="#GeoServiceID#" selected>#GeoService#</option>
171            						</cfoutput>
172            						</select></div>
173            					</td>
174            				</tr>
175            				<tr>
176            				<tr>
177            					<td><div class="formtext">URL <font style="color: red">*</font></td>
178            					<td><input type="text" size="40" name="URL" value="http://"></div>
179            						<input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
180            					</td>
181            				</tr>
182            				<tr>	
183            					<td><div class="formtext">Logo URL <a href="javascript:newWindow ('help.cfm')"><font style="color: red" size="-1">Help</font></a></td>
184            					<td><input type="text" size="40" name="GraphicURL" value="http://"></div></td>
185            				</tr>
186            			<tr>
187            					<td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
188            					<td><textarea cols="35" rows="10" align="top" name="Profile"></textarea></div>
189            						<input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
190 neenan 1.1 					</td>
191            				</tr>	
192            				<tr>
193            					<td>&nbsp;</td>
194            				</tr>
195            				<tr> 
196            					<td>&nbsp;</td>
197                  				<td><div class="formtext"><INPUT type="submit" value="Add Organization">
198            	  				<INPUT type="reset" value="Reset"></div></td>
199 pKanel 1.3 					<cfoutput><input type="hidden" name="userdate" value="#GetvisitorID.visitor_id#"></cfoutput>
200 neenan 1.1     			</tr>
201            		</table>
202            	</form>
203            
204            </td>
205            </tr>
206            </table>
207            </p>
208 pKanel 1.3 <!--- <cfinclude template="../cfi/global_footer.cfm"> --->

CVS Admin
Powered by
ViewCVS 1.0-dev