1 /** initializes reports, some basid display settings,
2 * grabs and builds the IDL tree
4 function oilsInitReportBuilder() {
6 oilsReportBuilderReset();
7 DOM.oils_rpt_table.onclick =
8 function(){hideMe(DOM.oils_rpt_column_editor)};
11 hideMe(DOM.oils_rpt_tree_loading);
12 unHideMe(DOM.oils_rpt_table);
17 function oilsReportBuilderReset() {
18 var n = (oilsRpt) ? oilsRpt.name : "";
19 oilsRpt = new oilsReport();
21 oilsRptDisplaySelector = DOM.oils_rpt_display_selector;
22 oilsRptFilterSelector = DOM.oils_rpt_filter_selector;
23 oilsRptAggFilterSelector= DOM.oils_rpt_agg_filter_selector;
24 removeChildren(oilsRptDisplaySelector);
25 removeChildren(oilsRptFilterSelector);
26 removeChildren(oilsRptAggFilterSelector);
32 /* adds an item to the display window */
33 function oilsAddRptDisplayItem(path, name, tform, params) {
34 if( ! oilsAddSelectorItem(oilsRptDisplaySelector, path, name) )
37 /* add the selected columns to the report output */
38 name = (name) ? name : oilsRptPathCol(path);
39 if( !tform ) tform = 'Bare';
41 /* add this item to the select blob */
43 relation: oilsRptPathRel(path),
45 column: { transform: tform, colname: oilsRptPathCol(path) }
48 if( params ) sel.column.params = params;
49 oilsRpt.def.select.push(sel);
51 mergeObjects( oilsRpt.def.from, oilsRptBuildFromClause(path));
55 /* takes a column path and builds a from-clause object for the path */
56 function oilsRptBuildFromClause(path) {
58 /* the path is the full path (relation) from the source
59 object to the column in question (e.g. au-home_ou-aou-name)*/
60 var parts = path.split(/-/);
62 /* the final from clause */
65 /* reference to the current position in the from clause */
70 /* walk the path, fleshing the from clause as we go */
71 for( var i = 0; i < parts.length; i += 2 ) {
73 var cls = parts[i]; /* class name (id) */
74 var col = parts[i+1]; /* column name */
76 /* a "node" is a class description from the IDL, it
77 contains relevant info, plus a list of "fields",
79 var node = oilsIDL[cls];
80 var pkey = oilsRptFindField(node, node.pkey);
82 /* a "field" is a parsed version of a column from the IDL,
83 contains datatype, column name, etc. */
84 var field = oilsRptFindField(node, col);
86 /* re-construct the path as we go so
87 we know what all we've seen thus far */
88 newpath = (newpath) ? newpath + '-'+ cls : cls;
90 /* extract relevant info */
91 tobj.table = node.table;
93 _debug('field type is ' + field.type);
94 if( i == (parts.length - 2) ) break;
96 /* we still have columns left in the path, keep adding join's */
98 if(field.reltype != 'has_a')
99 col = pkey.name + '-' + col;
106 if( field.type == 'link' )
107 tobj.key = field.key;
109 newpath = newpath + '-'+ path_col;
112 _debug("built 'from' clause: path="+path+"\n"+formatJSON(js2JSON(obj)));
117 /* removes a specific item from the display window */
118 function oilsDelDisplayItem(val) {
119 oilsDelSelectorItem(oilsRptDisplaySelector, val);
122 /* removes selected items from the display window */
123 function oilsDelSelectedDisplayItems() {
124 var list = oilsDelSelectedItems(oilsRptDisplaySelector);
126 /* remove the de-selected columns from the report output */
127 oilsRpt.def.select = grep( oilsRpt.def.select,
129 for( var j = 0; j < list.length; j++ ) {
133 if( oilsRptPathRel(d) == i.relation && oilsRptPathCol(d) == col.colname ) {
134 //var param = (i.alias) ? i.alias.match(/::PARAM\d*/) : null;
135 // if( param ) delete oilsRpt.params[param];
143 if(!oilsRpt.def.select) {
144 oilsRpt.def.select = [];
145 //oilsReportBuilderReset();
148 for( var j = 0; j < list.length; j++ )
149 /* if there are no items left in the "select", "where", or "having" clauses
150 for the given relation, trim this relation from the "from" clause */
151 if( !grep(oilsRpt.def.select,
152 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
153 && !grep(oilsRpt.def.where,
154 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
155 && !grep(oilsRpt.def.having,
156 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
157 ) oilsRptPruneFromClause(oilsRptPathRel(list[j]));
163 /* for each item in the path list, remove the associated data
164 from the "from" clause */
166 function oilsRptPruneFromClause(relation, node) {
167 _debug("removing relation from 'from' clause " + relation);
168 if(!node) node = oilsRpt.def.from.join;
169 for( var i in node ) {
170 if( node[i].alias == relation ) {
172 /* if we have subtrees, don't delete our tree node */
180 if( oilsRptPruneFromClause(relation, node[i].join ) ) {
181 if(oilsRptObjectKeys(node[i].join).length == 0) {
183 /* if there are no items in the select clause with a relation matching
184 this nodes alias, we can safely remove this node from the tree */
185 if(!grep(oilsRpt.def.select,function(r){return (r.relation==node[i].alias)}))
196 /* adds an item to the display window */
197 function oilsAddRptFilterItem(path, tform, filter) {
198 _debug("Adding filter item for "+path+" tform="+tform+" filter="+filter);
199 if( ! oilsAddSelectorItem(oilsRptFilterSelector, path) )
203 relation: oilsRptPathRel(path),
204 column: { transform: tform, colname: oilsRptPathCol(path) },
207 where.condition[filter] = oilsRptNextParam();
209 oilsRpt.def.where.push(where);
210 mergeObjects( oilsRpt.def.from, oilsRptBuildFromClause(path));
214 /* removes a specific item from the display window */
215 //function oilsDelFilterItem(path) {
216 //oilsDelSelectorItem(oilsRptFilterSelector, path);
219 /* removes selected items from the display window */
220 function oilsDelSelectedFilterItems() {
221 var list = oilsDelSelectedItems(oilsRptFilterSelector);
223 /* remove the de-selected columns from the report output */
224 oilsRpt.def.where = grep( oilsRpt.def.where,
226 for( var j = 0; j < list.length; j++ ) {
230 if( oilsRptPathRel(d) == i.relation && oilsRptPathCol(d) == col.colname ) {
231 var param = (i.alias) ? i.alias.match(/::PARAM\d*/) : null;
232 if( param ) delete oilsRpt.params[param];
240 if(!oilsRpt.def.where) {
241 oilsRpt.def.where = [];
242 //oilsReportBuilderReset();
245 for( var j = 0; j < list.length; j++ )
246 /* if there are no items left in the "select", "where", or "having" clauses
247 for the given relation, trim this relation from the "from" clause */
248 if( !grep(oilsRpt.def.select,
249 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
250 && !grep(oilsRpt.def.where,
251 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
252 && !grep(oilsRpt.def.having,
253 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
254 ) oilsRptPruneFromClause(oilsRptPathRel(list[j]));
260 /* adds an item to the display window */
261 function oilsAddRptAggFilterItem(val) {
262 oilsAddSelectorItem(oilsRptAggFilterSelector, val);
265 /* removes a specific item from the display window */
266 function oilsDelAggFilterItem(val) {
267 oilsDelSelectorItem(oilsRptAggFilterSelector, val);
270 /* removes selected items from the display window */
271 function oilsDelSelectedAggFilterItems() {
272 var list = oilsDelSelectedItems(oilsRptAggFilterSelector);
274 /* remove the de-selected columns from the report output */
275 oilsRpt.def.having = grep( oilsRpt.def.having,
277 for( var j = 0; j < list.length; j++ ) {
281 /* if this columsn has a transform,
282 it will be an object { tform => column } */
283 if( typeof col != 'string' )
284 for( var c in col ) col = col[c];
286 /* if this transform requires params, the column
287 will be the first item in the param set array */
288 if( typeof col != 'string' ) col = col[0];
290 if( oilsRptPathRel(d) == i.relation && oilsRptPathCol(d) == col ) {
291 var param = (i.alias) ? i.alias.match(/::PARAM\d*/) : null;
292 if( param ) delete oilsRpt.params[param];
300 if(!oilsRpt.def.having) {
301 oilsRpt.def.having = [];
302 oilsReportBuilderReset();
305 for( var j = 0; j < list.length; j++ )
306 /* if there are no items left in the "select", "where", or "having" clauses
307 for the given relation, trim this relation from the "from" clause */
308 if( !grep(oilsRpt.def.select,
309 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
310 && !grep(oilsRpt.def.where,
311 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
312 && !grep(oilsRpt.def.having,
313 function(i){ return (i.relation == oilsRptPathRel(list[j])); })
314 ) oilsRptPruneFromClause(oilsRptPathRel(list[j]));
321 /* adds an item to the display window */
322 function oilsAddSelectorItem(sel, val, name) {
323 name = (name) ? name : oilsRptMakeLabel(val);
324 _debug("adding selector item "+name+' = ' +val);
325 for( var i = 0; i < sel.options.length; i++ ) {
326 var opt = sel.options[i];
327 if( opt.value == val ) return false;
329 insertSelectorVal( sel, -1, name, val );
334 /* removes a specific item from the display window */
335 function oilsDelSelectorItem(sel, val) {
336 _debug("deleting selector item "+val);
337 var opts = sel.options;
338 for( var i = 0; i < opts.length; i++ ) {
340 if( opt.value == val ) {
341 if( i == opts.length - 1 )
343 else opts[i] = opts[i+1];
349 /* removes selected items from the display window */
350 function oilsDelSelectedItems(sel) {
351 var list = getSelectedList(sel);
352 for( var i = 0; i < list.length; i++ )
353 oilsDelSelectorItem(sel, list[i]);
358 /* hides the different field editor tabs */
359 function oilsRptHideEditorDivs() {
360 hideMe(DOM.oils_rpt_tform_div);
361 hideMe(DOM.oils_rpt_filter_div);
362 hideMe(DOM.oils_rpt_agg_filter_div);
367 This draws the 3-tabbed window containing the transform,
368 filter, and aggregate filter picker window
370 function oilsRptDrawDataWindow(path) {
371 var col = oilsRptPathCol(path);
372 var cls = oilsRptPathClass(path);
373 var field = oilsRptFindField(oilsIDL[cls], col);
375 appendClear(DOM.oils_rpt_editor_window_label, text(oilsRptMakeLabel(path)));
376 appendClear(DOM.oils_rpt_editor_window_datatype, text(field.datatype));
378 _debug("setting update data window for column "+col+' on class '+cls);
380 var div = DOM.oils_rpt_column_editor;
381 /* set a preliminary top position so the page won't bounce around */
382 div.setAttribute('style','top:'+oilsMouseX+'px');
384 /* unhide the div so we can determine the dimensions */
387 /* don't let them see the floating div until the position is fully determined */
388 div.style.visibility='hidden';
390 oilsRptDrawTransformWindow(path, col, cls, field);
391 oilsRptDrawFilterWindow(path, col, cls, field);
393 //oilsRptSetFilters(field.datatype);
395 //oilsRptDoFilterWidgets();
397 //DOM.oils_rpt_filter_tform_selector.onchange = oilsRptDoFilterWidgets;
399 buildFloatingDiv(div, 600);
401 /* now let them see it */
402 div.style.visibility='visible';
404 oilsRptSetDataWindowActions(div);
408 function oilsRptSetDataWindowActions(div) {
409 /* give the tab links behavior */
410 DOM.oils_rpt_tform_tab.onclick =
411 function(){oilsRptHideEditorDivs();unHideMe(DOM.oils_rpt_tform_div)};
412 DOM.oils_rpt_filter_tab.onclick =
413 function(){oilsRptHideEditorDivs();unHideMe(DOM.oils_rpt_filter_div)};
414 DOM.oils_rpt_agg_filter_tab.onclick =
415 function(){oilsRptHideEditorDivs();unHideMe(DOM.oils_rpt_agg_filter_div)};
417 DOM.oils_rpt_tform_tab.onclick();
418 DOM.oils_rpt_column_editor_close_button.onclick = function(){hideMe(div);};
422 function oilsRptDrawFilterWindow(path, col, cls, field) {
423 DOM.oils_rpt_filter_submit.onclick = function() {
424 var tsel = $n(DOM.oils_rpt_filter_tform_table,'selector');
425 var fsel = $n(DOM.oils_rpt_filter_op_table,'selector');
426 var tform = getSelectorVal(tsel);
427 var filter = getSelectorVal(fsel);
428 oilsAddRptFilterItem(path, tform, filter);
430 oilsRptShowFilters($n(DOM.oils_rpt_filter_tform_table,'selector'), field.datatype, false, true);
433 oilsRptCurrentFilterTform = new oilsRptTFormManager(DOM.oils_rpt_filter_tform_table);
434 oilsRptCurrentFilterTform.build(field.datatype, false, true);
435 oilsRptCurrentFilterOpManager = new oilsRptOpManager(DOM.oils_rpt_filter_op_table);
439 function oilsRptShowFilters( selector, dtype, show_agg, show_noagg ) {
440 for( var i = 0; i < selector.options.length; i++ ) {
441 var opt = selector.options[i];
442 var t = opt.getAttribute('datatype');
443 if( t && t != dtype ){
446 var ag = opt.getAttribute('aggregate');
449 else if( ag && ! show_agg )
451 else if( !ag && show_noagg )
459 /* draws the transform window */
460 function oilsRptDrawTransformWindow(path, col, cls, field) {
461 DOM.oils_rpt_tform_label_input.value = oilsRptMakeLabel(path);
462 var dtype = field.datatype;
464 DOM.oils_rpt_tform_submit.onclick =
466 var sel = $n(DOM.oils_rpt_tform_table,'selector');
467 var tform = getSelectorVal(sel);
468 oilsAddRptDisplayItem(path, DOM.oils_rpt_tform_label_input.value, tform )
472 DOM.oils_rpt_tform_label_input.focus();
473 DOM.oils_rpt_tform_label_input.select();
476 oilsRptCurrentTform = new oilsRptTFormManager(DOM.oils_rpt_tform_table);
477 oilsRptCurrentTform.build(dtype, true, true);
480 _debug($n(DOM.oils_rpt_tform_table,'selector'));
482 oilsRptShowFilters($n(DOM.oils_rpt_tform_table,'selector'), dtype, true, true);
485 oilsRptHideTformFields();
486 oilsRptUnHideTformFields(dtype);
489 _debug("Building transform window for datatype "+dtype);
492 unHideMe($('oils_rpt_tform_'+dtype+'_div'));
493 $('oils_rpt_tform_all_raw').checked = true;
498 function oilsRptHideTformFields() {
499 var rows = DOM.oils_rpt_tform_tbody.childNodes;
500 for( var i = 0; i < rows.length; i++ )
501 if( rows[i] && rows[i].nodeType == 1 )
505 function oilsRptUnHideTformFields(dtype) {
506 var rows = DOM.oils_rpt_tform_tbody.childNodes;
507 for( var i = 0; i < rows.length; i++ ) {
509 if( row && row.nodeType == 1 &&
510 (row.getAttribute('datatype')=='all'
511 || row.getAttribute('datatype') == dtype)) {
518 function oilsRptGetTform(datatype) {
519 for( var i in oilsRptTransforms[datatype] )
520 if( $('oils_rpt_tform_'+datatype+'_'+oilsRptTransforms[datatype][i]).checked )
521 return oilsRptTransforms[datatype][i];
522 for( var i in oilsRptTransforms.all )
523 if( $('oils_rpt_tform_all_'+oilsRptTransforms.all[i]).checked )
524 return oilsRptTransforms.all[i];
531 function getRptTformParams(type, tform) {
537 DOM.oils_rpt_tform_string_substring_offset.value,
538 DOM.oils_rpt_tform_string_substring_length.value];
545 /* given a transform selector, this displays the appropriate
546 transforms for the given datatype.
547 if aggregate is true, is displays the aggregate transforms */
549 function oilsRptSetTransforms(sel, dtype, show_agg, show_noagg) {
550 for( var i = 0; i < sel.options.length; i++ ) {
551 var opt = sel.options[i];
552 var t = opt.getAttribute('datatype');
553 if( t && t != dtype ){
556 var ag = opt.getAttribute('aggregate');
559 else if( ag && ! show_agg )
561 else if( !ag && show_noagg )
571 /* displays the correct filter-transforms for the given datatype */
573 function oilsRptSetFilters(dtype) {
575 DOM.oils_rpt_filter_submit.onclick = function() {
576 var data = oilsRptDoFilterWidgets();
577 alert(js2JSON(data));
580 var sel = DOM.oils_rpt_filter_tform_selector;
581 for( var i = 0; i < sel.options.length; i++ ) {
582 var opt = sel.options[i];
583 _debug(opt.getAttribute('op'));
584 var t = opt.getAttribute('datatype');
585 if( t && t != dtype ) hideMe(opt);
591 /* hides all of the filter widgets */
592 function oilsRptHideFilterWidgets(node) {
594 node = DOM.oils_rpt_filter_tform_widget_td;
595 if( node.nodeType != 1 ) return;
596 if( node.getAttribute('widget') ) {
599 var cs = node.childNodes;
600 for( var i = 0; cs && i < cs.length; i++ )
601 oilsRptHideFilterWidgets(cs[i]);
605 /* what does this need to do? */
606 function oilsRptSetFilterOpActions() {
611 /* hides/unhides the appropriate widgets and returns the parameter
612 array appropriate for the selected widget */
613 function oilsRptDoFilterWidgets() {
614 filter = getSelectorVal(DOM.oils_rpt_filter_tform_selector);
615 oilsRptHideFilterWidgets();
622 /* generic transforms */
624 if(!op) op = 'equals';
628 if(!op) op = 'ilike';
640 if(!op) op = 'not in';
642 if(!op) op = 'between';
644 if(!op) op = 'not between';
645 unHideMe(DOM.oils_rpt_filter_tform_input);
646 params = [DOM.oils_rpt_filter_tform_input.value];
649 /* timestamp transforms */
651 if(!op) op = 'between';
652 case 'date_not_between':
653 if(!op) op = 'not between';
656 unHideMe(DOM.oils_rpt_filter_tform_date_1);
657 unHideMe(DOM.oils_rpt_filter_tform_date_2);
658 unHideMe(DOM.oils_rpt_filter_tform_date_hint);
659 DOM.oils_rpt_filter_tform_date_1.value = mkYearMonDay();
660 DOM.oils_rpt_filter_tform_date_2.value = mkYearMonDay();
662 DOM.oils_rpt_filter_tform_date_1.value,
663 DOM.oils_rpt_filter_tform_date_2.value
669 if(!tform) tform = 'dow';
670 case 'dow_not_between':
671 if(!op) op = 'not between';
672 if(!tform) tform = 'dow';
677 if(!tform) tform = 'dom';
678 case 'dom_not_between':
679 if(!op) op = 'not between';
680 if(!tform) tform = 'dom';
683 case 'month_between':
685 if(!tform) tform = 'moy';
686 case 'month_not_between':
687 if(!op) op = 'not between';
688 if(!tform) tform = 'moy';
691 case 'quarter_between':
693 if(!tform) tform = 'qoy';
694 case 'quarter_not_between':
695 if(!op) op = 'not between';
696 if(!tform) tform = 'qoy';
700 if(!op) op = 'between';
701 if(!tform) tform = 'year_trunc';
702 case 'year_not_between':
703 if(!op) op = 'not between';
704 if(!tform) tform = 'year_trunc';
708 if(!op) op = 'between';
709 if(!tform) tform = 'age';
710 case 'age_not_between':
711 if(!op) op = 'not between';
712 if(!tform) tform = 'age';
715 /* string transforms */
717 if(!tform) tform = 'substring';
722 if(!tform) tform = 'dow';
726 if(!tform) tform = 'dow';
728 /* numeric transforms */
731 if(!tform) tform = 'dow';
735 if(!tform) tform = 'dow';
738 return { op : op, params : params, tform : tform };