forked from ArctosDB/arctos
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfindContainer.cfm
180 lines (167 loc) · 6.75 KB
/
findContainer.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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
<cfinclude template="/includes/_header.cfm">
<cfset title='Find Containers'>
<script type='text/javascript' src='/includes/dhtmlxtree.js'><!-- --></script>
<script type="text/javascript" src="/includes/dhtmlxcommon.js"></script>
<link rel="STYLESHEET" type="text/css" href="/includes/dhtmlxtree.css">
<script src="/includes/jquery/jquery-autocomplete/jquery.autocomplete.pack.js" language="javascript" type="text/javascript"></script>
<script>
jQuery(document).ready(function() {
jQuery("#part_name").autocomplete("/ajax/part_name.cfm", {
width: 320,
max: 20,
autofill: true,
highlight: false,
multiple: false,
scroll: true,
scrollHeight: 300
});
$("#begin_parent_install_date").datepicker();
$("#end_parent_install_date").datepicker();
});
</script>
<style >
.cTreePane {
height:400px;
overflow-y:scroll;
overflow-x:auto;
padding-right:10px;
}
.ajaxWorking{
top: 20%;
color: green;
text-align: center;
margin: auto;
position:absolute;
max-width: 50%;
right:2%;
background-color:white;
padding:1em;
border:1px solid;
overflow:hidden;
z-index:1;
overflow-y:scroll;
}
.ajaxDone {display:none}
.ajaxMessage {color:green;}
.ajaxError {color:red;}
</style>
<script type='text/javascript' src='/includes/_treeAjax.js'></script>
<cfquery name="contType" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
select container_type from ctContainer_Type order by container_type
</cfquery>
<cfquery name="collections" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
select collection_id, guid_prefix from collection order by guid_prefix
</cfquery>
<cfquery name="ctcoll_other_id_type" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
select OTHER_ID_TYPE from
ctcoll_other_id_type
group by OTHER_ID_TYPE
order by OTHER_ID_TYPE
</cfquery>
<cfoutput>
<div id="ajaxMsg"></div>
<table border width="100%">
<tr>
<td valign="top"><!--------------------------- search pane ----------------------------->
<div id="searchPane">
<form onSubmit="loadTree();return false;">
<input type="hidden" name="transaction_id" id="transaction_id">
<label for="cat_num">Cat Num (comma-list OK)</label>
<input type="text" name="cat_num" id="cat_num" />
<label for="barcode">Barcode (comma-list OK)</label>
<input type="text" name="barcode" id="barcode" />
<label for="container_label">Label (% for wildcard)</label>
<input type="text" name="container_label" id="container_label" />
<label for="collection_id">Collection</label>
<select name="collection_id" id="collection_id" size="1">
<option value=""></option>
<cfloop query="collections">
<option value="#collection_id#">#guid_prefix#</option>
</cfloop>
</select>
<label for="begin_parent_install_date">Earliest Install Date</label>
<input type="text" name="begin_parent_install_date" id="begin_parent_install_date" />
<label for="end_parent_install_date">Latest Install Date</label>
<input type="text" name="end_parent_install_date" id="end_parent_install_date" />
<label for="description">Description (% for wildcard)</label>
<input type="text" name="description" id="description" />
<label for="part_name">Part</label>
<input type="text" id="part_name" name="part_name">
<label for="container_type">Container Type</label>
<select name="container_type" id="container_type" size="1">
<option value=""></option>
<cfloop query="contType">
<option value="#contType.container_type#">#contType.container_type#</option>
</cfloop>
</select>
<label for="in_container_type">Contained By Container Type</label>
<select name="in_container_type" id="in_container_type" size="1">
<option value=""></option>
<cfloop query="contType">
<option value="#contType.container_type#">#contType.container_type#</option>
</cfloop>
</select>
<label for="other_id_type">OID Type</label>
<select name="other_id_type" id="other_id_type" size="1" style="width:120px;">
<option value=""></option>
<cfloop query="ctcoll_other_id_type">
<option value="#ctcoll_other_id_type.other_id_type#">#ctcoll_other_id_type.other_id_type#</option>
</cfloop>
</select>
<label for="other_id_value">OID Value (% for wildcard)</label>
<input type="text" name="other_id_value" id="other_id_value" />
<label for="loan_number">Loan Number</label>
<input type="text" name="loan_number" id="loan_number" />
<input type="hidden" name="collection_object_id" id="collection_object_id" />
<input type="hidden" name="loan_trans_id" id="loan_trans_id" />
<input type="hidden" name="container_id" id="container_id" />
<input type="hidden" name="table_name" id="table_name" />
<br>
<input type="submit" value="Search" class="schBtn">
<input class="clrBtn" type="button" value="Clear" onclick='document.location="/findContainer.cfm";'/>
</form>
<span class="likeLink" onclick="downloadTree()">Flatten Part Locations</span>
<br><span class="likeLink" onclick="showTreeOnly()">Drag/Print</span>
<br><span class="likeLink" onclick="printLabels()">Print Labels</span>
</div>
</td><!--------------------------------- end search pane ------------------------------------->
<td><!------------------------------------- tree pane --------------------------------------------->
<div id="treePane" class="cTreePane"></div>
</td><!------------------------------------- end tree pane --------------------------------------------->
<td valign="top">
<div id="detailPane"></div>
</td>
</tr>
</table>
<div id="thisfooter">
<cfinclude template="/includes/_footer.cfm">
</div>
<cfif isdefined("url.collection_object_id") and len(url.collection_object_id) gt 0 and not isdefined("url.showControl")>
<script language="javascript" type="text/javascript">
try {
parent.dyniframesize();
} catch(err) {
// not where we think we are, maybe....
}
showSpecTreeOnly('#url.collection_object_id#');
</script>
<cfelse>
<cfset autoSubmit=false>
<cfloop list="#StructKeyList(url)#" index="key">
<cfif len(#url[key]#) gt 0>
<cfset autoSubmit=true>
<script language="javascript" type="text/javascript">
if (document.getElementById('#lcase(key)#')) {
document.getElementById('#lcase(key)#').value='#url[key]#';
}
</script>
</cfif>
</cfloop>
<cfif autoSubmit is true>
<script language="javascript" type="text/javascript">
loadTree();
</script>
</cfif>
</cfif>
</cfoutput>