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> </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> </td>
194 </tr>
195 <tr>
196 <td> </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"> --->
|