forked from UCLALibrary/public_service_statistics
-
Notifications
You must be signed in to change notification settings - Fork 0
/
createAccount.cfm
129 lines (124 loc) · 3.7 KB
/
createAccount.cfm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<cfquery name="GetCircUnit" datasource="#CircStatsDSN#">
SELECT
UnitID,
Unit
FROM
CircUnit
WHERE
Active = 1
ORDER BY
Unit
</cfquery>
<cfquery name="GetRefUnit" datasource="#CircStatsDSN#">
SELECT DISTINCT
SUBSTRING(UnitID, 1, 3) AS ParentUnitID,
CASE
WHEN SUBSTRING(UnitID, 1, 3) = 'ART' THEN 'Arts Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'BIO' THEN 'Biomed Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'CLK' THEN 'Clark Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'COL' THEN 'Powell Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'EAL' THEN 'East Asian Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'LAW' THEN 'Law Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'MAN' THEN 'Management Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'MUS' THEN 'Music Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'RBR' THEN 'Rieber Hall'
WHEN SUBSTRING(UnitID, 1, 3) = 'SEL' THEN 'Science & Engineering Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'SRL' THEN 'SRLF'
WHEN SUBSTRING(UnitID, 1, 3) = 'YRL' THEN 'Young Research Library'
ELSE NULL
END AS "ParentUnit"
FROM
View_RefUnit
ORDER BY
ParentUnit
</cfquery>
<html>
<head>
<title>UCLA Library Public Service Statistics</title>
<cfinclude template="../library_pageincludes/banner.cfm">
<cfinclude template="../library_pageincludes/nav.cfm">
<!--begin you are here-->
Public Service Statistics
<!-- end you are here -->
<CFINCLUDE TEMPLATE="../library_pageincludes/start_content.cfm">
<h1>Public Service Statistics</h1>
<p>
Welcome to UCLA Library Public Service Statistics Web site.
</p>
<form action="addAccount.cfm"
method="post"
name="Login"
id="Login">
<!--onsubmit="JavaScript:return validateForm(this);"-->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right">User name</td>
<td> </td>
<td>
<input name="LogonID" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Password</td>
<td> </td>
<td>
<input name="newPassword" type="password" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">First Name</td>
<td> </td>
<td>
<input name="FirstName" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Last Name</td>
<td> </td>
<td>
<input name="LastName" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Email Address</td>
<td> </td>
<td>
<input name="EmailAddress" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Circ Unit</td>
<td> </td>
<td>
<select name="CircUnit" class="form">
<cfoutput query="GetCircUnit">
<option value="#GetCircUnit.UnitID#">#GetCircUnit.Unit#</option>
</cfoutput>
</select>
</td>
</tr>
<tr>
<td align="right">Ref Unit</td>
<td> </td>
<td>
<select name="RefUnit" class="form">
<cfoutput query="GetRefUnit">
<option value="#GetRefUnit.ParentUnitID#">#GetRefUnit.ParentUnit#</option>
</cfoutput>
</select>
</td>
</tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td> </td>
<td align="right">
<input type="submit" class="mainControl" value="Create Account">
</td>
<td valign="top">
</td>
</tr>
</table>
</form>
<CFINCLUDE TEMPLATE="../library_pageincludes/footer.cfm">
<CFINCLUDE TEMPLATE="../library_pageincludes/end_content.cfm">