annotate query_builder/querybuild.html @ 32:acc60a20582c

Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
author arussell
date Sat, 19 Dec 2015 09:15:43 -0500
parents 5384b71df52a
children 4bbb832c53ac
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
1 <!DOCTYPE html>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
2 <html>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
3 <head>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
4 <meta http-equiv="Content-Type" content="text/html" charset="UTF-8">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
5 <title>Query Builder</title>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
6 <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
7 <link rel="stylesheet" href="select2-4.0.1/dist/css/select2.min.css">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
8
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
9 <script type="text/javascript" src="js/d3.min.js"></script>
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
10 <script type="text/javascript" src="js/underscore-min.js"></script>
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
11 <script type="text/javascript" src="select2-4.0.1/vendor/jquery-2.1.0.js"></script>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
12 <script type="text/javascript" src="select2-4.0.1/dist/js/select2.full.min.js"></script>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
13
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
14
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
15
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
16 </head>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
17 <body style="background:none;">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
18 <div role="navigation" class="navbar navbar-default navbar-static-top">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
19 <div class="container">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
20 <div class="row">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
21 <div class="col-sm-6 col-md-6">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
22 <ul class="nav navbar-nav">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
23 </ul>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
24 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
25 <div class="navbar-header col-sm-6 col-md-6" style="height: auto;">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
26 <div class="col-md-6">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
27 <div class="navbar-brand">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
28 <div class="brand">ISMI Query Builder</div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
29 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
30 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
31 <div class="col-md-offset-6">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
32 <div class="logo-well" style="height: 60%; width: 60%;">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
33 <a href="//neo4j.com/developer-resources">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
34 <img src="//neo4j-contrib.github.io/developer-resources/language-guides/assets/img/logo-white.svg" alt="Neo4j World's Leading Graph Database" id="logo" style="max-height: 50%; width: 50%">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
35 </a>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
36 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
37 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
38 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
39 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
40 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
41 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
42 <div class="container">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
43 <div class="row" style="width: 95%">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
44 <div class="col-lg">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
45 <div class="panel panel-default">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
46 <div class="panel-heading" id="title">Query Builder</div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
47
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
48 <section>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
49 <div class="s2-example">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
50 <div id="filters">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
51 <div class="row" id="startrow" style="margin-top: 15px">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
52 <div class="col-sm-4 col-md-4" id="select-col1">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
53 <select class="selected-object form-control">
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
54 <option selected>Object type : </option>
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
55 </select>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
56 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
57 <div class="col-sm-4 col-md-4" id="select-col2">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
58 <select class="select-object1 form-control">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
59 <option selected>TEXT</option>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
60 <option>WITNESS</option>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
61 <option>PERSON</option>
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
62 <option>CODEX</option>
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
63 <option>PLACE</option>
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
64 <option>REPOSITORY</option>
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
65 <option>COLLECTION</option>
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
66 </select>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
67 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
68 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
69 <div class="row" id="row1" style="margin-top: 15px">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
70 <div class="col-sm-4 col-md-4" id="1filter-col1">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
71 <select class="filter-box1 form-control">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
72 <option value="" disabled selected>Choose filter...</option>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
73 </select>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
74 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
75 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
76 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
77 <div align="left" style="margin-top: 30px"><button id="minus_filter_button" class="btn btn-warning btn-md" type="button"> - </button>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
78 <button id="plus_filter_button" class="btn btn-warning btn-md" type="button"> + </button>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
79 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
80 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
81
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
82
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
83 <div class="container-fluid" style="margin-top: 15px">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
84 <form role="form">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
85 <div class="form-group">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
86 <label for="results-container">Results list</label>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
87 <select multiple class="form-control" id="results-container" style="min-height: 300px;">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
88 </select>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
89 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
90 </form>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
91
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
92 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
93
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
94 <!-- <pre data-fill-from=".js-code-data-array"></pre> -->
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
95 </section>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
96
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
97 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
98 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
99 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
100 </div>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
101
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
102
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
103
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
104
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
105
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
106
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
107 <script type="text/javascript" class="js-code-data-array">
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
108 //var queryData = [];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
109
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
110 // Defining initial variables and helper functions
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
111 var sourceType = "TEXT";
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
112 var targets = [];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
113 var targetTypes = [];
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
114 var targetObj = []; // The current objects on the display box
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
115 var numFilters = 1;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
116 var filters = [
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
117 { id: 0, text: 'has relation' },
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
118 { id: 1, text: 'attribute' }
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
119 ];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
120 $(".filter-box"+numFilters).select2({
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
121 // Initialize first filter box
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
122 data: filters,
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
123 minimumResultsForSearch: Infinity
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
124 });
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
125 var listTolerance = 100;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
126 //$("")
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
127
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
128 function filter_html(n) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
129 return '<div class="row" id="row'+n+'" style="margin-top: 15px">' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
130 '<div class="col-sm-4 col-md-4" id="'+n+'filter-col1">' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
131 '<select class="filter-box'+n+' form-control">' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
132 '<option value="" disabled selected>Choose filter...</option>' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
133 '</select>' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
134 '</div>' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
135 '</div>';
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
136 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
137 function constraint_html(classn) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
138 return '<div class="col-sm-4 col-md-4" id="'+classn+'filter-col2">' +
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
139 '<select class="rel-constraint-box'+classn+' form-control" >' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
140 '</select>' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
141 '</div>';
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
142 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
143 function attr_constraint_html(classn) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
144 return '<div class="col-sm-4 col-md-4" id="'+classn+'filter-col2">' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
145 '<select class="attr-constraint-box'+classn+' form-control" >' +
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
146 '</select>' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
147 '</div>';
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
148 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
149 function submit_html(classn) {
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
150 return '<div class="col-sm-4 col-md-4" id="'+classn+'filter-col3">' +
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
151 '<div class="form-group'+classn+'">' +
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
152 '<form onsubmit="return false;"> ' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
153 '<input type="text" name="attr-field" class="form-control" id="attr-input'+classn+'">' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
154 '</input>' +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
155 '</form>' +
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
156 '</div>' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
157 '</div>';
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
158 }
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
159 function select_html(selection, n) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
160 return '<div class="row" id="row'+n+'" style="margin-top: 15px">' +
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
161 '<div class="col-sm-4 col-md-4" id="select-col1"> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
162 '<select class="selected-object form-control"> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
163 '<option selected>Selected object is: </option> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
164 '</select> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
165 '</div> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
166 '<div class="col-sm-4 col-md-4" id="select-col2"> ' +
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
167 '<h4>' + selection +
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
168 '</h4>' +
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
169 '</div> ' +
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
170 '</div>';
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
171 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
172
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
173
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
174
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
175
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
176 // Button filters
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
177 $("#plus_filter_button").click(function() {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
178 console.log("add filter");
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
179 numFilters++;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
180 $("#filters").append(filter_html(numFilters));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
181 $(".filter-box"+numFilters).select2({
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
182 data: filters,
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
183 minimumResultsForSearch: Infinity
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
184 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
185 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
186 $("#minus_filter_button").click(function() {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
187 console.log("minus filter");
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
188 $("#row"+numFilters).remove();
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
189 numFilters--;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
190 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
191 $("#results-container").dblclick(function() {
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
192 var displayChoice = $("#results-container").find("option:selected").text();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
193 console.log(displayChoice + ".........");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
194 var selection;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
195
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
196 _.map(targetObj, function(obj){
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
197
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
198 if (_.values(_.values(targetObj))[1] === displayChoice) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
199 selection = (_.values(_.values(obj))[0])[1];
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
200 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
201 else {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
202 selection = (_.values(_.values(obj))[0])[0];
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
203 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
204 });
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
205 numFilters++;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
206 $("#filters").append(select_html(selection, numFilters));
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
207 // Generate inner relation list
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
208 //genRelations(sourceType, ".constraint-box"+numFilters);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
209 sourceType = selection;
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
210 console.log("add filter");
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
211 });
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
212 $(function() {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
213 $("input").submit(function(event, data) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
214 console.log($('.form-control').find("option:selected").text());
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
215 console.log(event);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
216 console.log(data);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
217 event.preventDefault();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
218
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
219 });
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
220 });
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
221
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
222
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
223 // Change Events
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
224 $('body').on('change', function(event){
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
225 var classname = (event.target.className).substr(0, (event.target.className).indexOf(" "));
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
226 var classnum = (event.target.className.match(/\d+\.\d+|\d+\b|\d+(?=\w)/g) || [] ).map(function (v) {return +v;}).shift();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
227 var allclass = '.'+classname;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
228 var selectedOption = $(allclass).find('option:selected').text();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
229 console.log("SEL "+ selectedOption);
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
230
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
231 // Change is on the filter box
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
232 if (classname.indexOf("filter-box") > -1) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
233 if (selectedOption === "has relation") {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
234 // Remove any other boxes in the row
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
235 $("#"+classnum+"filter-col2").remove();
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
236 $("#row"+classnum).append(constraint_html(classnum));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
237 // Generate inner relation list
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
238 genRelations(sourceType, ".rel-constraint-box"+classnum);
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
239 }
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
240 if (selectedOption === "attribute") {
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
241 $("#"+classnum+"filter-col2").remove();
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
242 $("#row"+classnum).append(attr_constraint_html(classnum));
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
243 genAttributes(sourceType, ".attr-constraint-box"+classnum);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
244 //$("#row"+classnum).append(submit_html(classnum));
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
245 $("#row"+classnum).append(submit_html(classnum));
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
246
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
247 }
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
248
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
249 // NOT IMPLEMENTED
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
250 /*
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
251 if (selectedOption === "return") {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
252 $("#"+classnum+"filter-col2").remove();
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
253 $("#row"+classnum).append(constraint_html(classnum));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
254 genAttributes(targetTypes, ".constraint-box"+classnum);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
255 }
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
256 */
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
257 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
258
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
259 // Change is on the relationship constraint box
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
260 if (classname.indexOf("rel-constraint-box") > -1) {
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
261 //$().remove();
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
262 genResults(sourceType, selectedOption, "results-container");
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
263 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
264
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
265 // Change is on the attr constraint box
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
266 if (classname.indexOf("attr-constraint-box") > -1) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
267 //$().remove();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
268 console.log("CHANGE ON ATTR");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
269 console.log("changing currentqueryattr to" + selectedOption);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
270 currentQueryAttr = selectedOption;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
271 console.log("currentQueryAttr is" + currentQueryAttr);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
272 //genResults(sourceType, selectedOption, "results-container");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
273 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
274
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
275 // Change is on subject scope
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
276 if (classname.indexOf("select-object") > -1) {
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
277 sourceType = selectedOption;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
278 console.log("CHANGE ON SCOPE");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
279 genResults(sourceType, "New Source", "results-container");
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
280
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
281 //ajax1(query, "results-container")
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
282 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
283 });
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
284 $("#filters").submit(function (event) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
285 var inputId = $("input:text[name=attr-field]")[0].id;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
286 var inputValue = $("input:text[name=attr-field]").val();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
287 // Alter results list
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
288 console.log("QUERY TYPE IS ATTRIBUTE NOW");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
289 currentQueryType = "attribute";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
290 console.log("SUBMITTED");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
291 genResults(sourceType, inputValue, "results-container")
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
292
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
293
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
294 });
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
295 // For use in the onchange events above
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
296 function genRelations(sourceNodeType, constraintBox) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
297 console.log("GENERATE ALL RELATIONS");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
298 var query = "match (source:"+sourceNodeType+")-[rel]-target return distinct rel.type";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
299 console.log("QUERY TYPE IS RELATION NOW");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
300 currentQueryType = "relation";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
301 ajax1(query, constraintBox);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
302 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
303 function genAttributes(sourceNodeType, constraintBox) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
304 console.log("GENERATE ALL ATTRIBUTES");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
305 var query = "match (n:"+sourceNodeType+") with keys(n) as collection unwind collection as attributes return distinct attributes";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
306 ajax1(query, constraintBox);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
307 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
308 function genResults(sourceNodeType, selected, constraintBox) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
309 // TODO: Return first the list of current values of the display box
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
310
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
311 if (selected === "New Source") {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
312 console.log("NEW SOURCE - UPDATE RESULTS");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
313 var query = "match (source:"+sourceNodeType+") return source._n_label, source.type";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
314 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
315 else if (currentQueryType === "attribute") {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
316 console.log("ATTR CHANGE - UPDATE RESULTS");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
317 console.log("before update currentQueryAttr is " + currentQueryAttr);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
318 var qAttr = currentQueryAttr;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
319 var query = "match (source:"+sourceNodeType+") where "+get_result_labels()+" AND source."+qAttr+"=~\"(?i).*"+selected+".*\" return distinct source._n_label, source.type limit 5";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
320 console.log(query);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
321 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
322 else if (currentQueryType === "relation") {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
323 var query = "match (source:" + sourceNodeType + ")-[rel:" + selected + "]->(target) return distinct target._n_label, target.type";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
324 console.log("REL CHANGE - UPDATE RESULTS");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
325 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
326 else {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
327 console.log("GENRESULTS IMPROPERLY CALLED");
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
328 return;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
329 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
330 ajax1(query, constraintBox);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
331 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
332 var currentQueryType;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
333 var currentQueryAttr;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
334 var resultLabelString = "";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
335 function get_result_labels() {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
336 return resultLabelString;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
337 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
338 function set_result_labels(currentResults) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
339 resultLabelString = "(";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
340 for (var i = 0; i < currentResults.length; i++) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
341 if (i > 0) resultLabelString += " OR ";
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
342 resultLabelString += 'source._n_label=\"'+currentResults[i].text.substr(1)+'\"';
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
343 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
344 resultLabelString += ")"
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
345 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
346 // to use contains
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
347 // TODO: start n = node(*) where n.Name =~ '.*SUBSTRING.*' return n.Name, n;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
348
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
349
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
350
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
351 // Ajax request function
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
352 function ajax1(q, resBox) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
353 $.ajaxSetup({
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
354 headers: {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
355 "Authorization": 'Basic ' + window.btoa("neo4j"+":"+"neo5j")
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
356 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
357 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
358 return $.ajax({
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
359 type: "POST",
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
360 url: "https://ismi-dev.mpiwg-berlin.mpg.de/neo4j-ismi/db/data/cypher",
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
361 accepts: "application/json",
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
362 dataType: "json",
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
363 data: {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
364 "query": q,
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
365 "params": {}
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
366 },
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
367 beforeSend: function (xhr) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
368 xhr.setRequestHeader ("Authorization", "Basic " + btoa('neo4j'+":"+'neo5j'));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
369 },
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
370 processResults: function (data, params) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
371 // parse the results into the format expected by Select2
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
372 // since we are using custom formatting functions we do not need to
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
373 // alter the remote JSON data, except to indicate that infinite
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
374 // scrolling can be used
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
375 params.page = params.page || 1;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
376 return {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
377 pagination: {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
378 more: (params.page * 30) < data.length
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
379 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
380 };
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
381 },
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
382 success: function (res, textStatus, jqXHR) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
383 ajaxCheck(res, resBox, textStatus);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
384 console.log(textStatus);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
385 },
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
386 error: function (jqXHR, textStatus, errorThrown) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
387 console.log(textStatus);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
388 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
389 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
390 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
391 // Check if request was successful
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
392 function ajaxCheck(a1, resBox, status){
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
393 if (status === 'error') console.log("error: bad ajax request");
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
394 //else dataGen(a1);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
395 dataGen(a1.data, resBox);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
396 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
397 // On success, generate new data
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
398 // TODO: might want to just always return nodes and then deal with the queryData different for each type of return
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
399 function dataGen(dataArr, resBox) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
400 var d = dataArr;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
401 targets = [];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
402
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
403 // Consider implementing localStorage to avoid reloading every time
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
404 var queryData = [];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
405 for (var i= 0; i<d.length; i++) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
406 var j = d[i];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
407 queryData.push({ id: j, text: j[0] });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
408 targets.push(j[1]);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
409 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
410 // Now that queryData array has been defined we will sort it by its label value and initialize the option.
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
411 queryData.sort(function(a,b){
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
412 var c = a.text.replace(/<|>/g, '');
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
413 var d = b.text.replace(/<|>/g, '');
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
414 return c.localeCompare(d);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
415 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
416
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
417 // Change the displayed results
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
418 if (resBox === "results-container") {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
419 process_display_results(queryData);
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
420 }
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
421 // Or fill any select boxes
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
422 else {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
423 $(resBox).select2({
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
424 data: queryData
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
425 });
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
426 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
427 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
428 function process_display_results(queryData) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
429 var weights = [];
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
430 var resultLength = queryData.length;
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
431 targetTypes = [];
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
432 targetObj = queryData;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
433 set_result_labels(queryData);
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
434 $('#results-container')
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
435 .find('option')
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
436 .remove()
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
437 .end()
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
438 ;
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
439 for (var i = 0; i < targets.length; i++) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
440 if (targetTypes.indexOf(targets[i]) == -1) {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
441 targetTypes.push(targets[i]);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
442 weights.push(1);
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
443 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
444 else {
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
445 weights[targetTypes.indexOf(targets[i])] += 1;
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
446 }
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
447 }
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
448 if (resultLength < listTolerance) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
449 for (var i = 0; i < resultLength; i++) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
450 // TODO: put this jQuery call into its own function to be called if the else statement occurs
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
451 // TODO: but the user actually does want to see the entire huge list.
32
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
452 // This next bit removes duplicate labels if we want to use that for things like cities
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
453 // would this throw issues with other things??
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
454 //$('#results-container option:contains('+queryData[i].text+')').each(function(){
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
455 // $(this).remove();
acc60a20582c Temporary Changes for querybuilder. Selecting attribute and having results list filter not fully working yet. Need 'ALL' option in attributes.
arussell
parents: 28
diff changeset
456 //});
28
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
457 $('#results-container')
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
458 .append($("<option></option>")
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
459 .attr("value", i)
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
460 .text(queryData[i].text));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
461 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
462 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
463 else {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
464 for (var i = 0; i < targetTypes.length; i++) {
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
465 $('#results-container')
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
466 .append($("<option></option>")
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
467 .text(targetTypes[i] + " [ " + weights[i] + " ]"));
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
468 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
469 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
470 }
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
471
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
472 </script>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
473
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
474 </body>
5384b71df52a querybuild.html added, beginning prototype.
arussell
parents:
diff changeset
475 </html>