// Title: Tigra Tables PRO // URL: http://www.softcomplex.com/products/tigra_tables_pro/ // Version: 1.1 // Date: 12-11-2002 (mm-dd-yyyy) // Technical Support: support@softcomplex.com (specify product title and order ID) // Notes: Registration needed to use this script legally. // Visit official site for details. var path_to_files = '/ttp_files/'; var d = document, TTablePRO = [], NUM = 'NUM', STR = 'STR',DATE='DATE',CURRENCY='CURRENCY'; function TCastSTR(s_){return s_.replace(/<[^>]+>/ig,'')+'';} // accept first valid number in string as sort id and accept ',' as well as '.' function TCastNUM(s_){return s_.replace(/^[^0-9\-\,]*/g, '').replace(/[\.]/g, '').replace(/,/g,'.')*1;} function TCastDATE(s_,s_format){ if(s_format) return set_date_by_format(s_format,stripHTML(s_)); else return set_date_by_format('Y-m-d',stripHTML(s_)); } // Basically same an NUM function TCastCURRENCY(s_){return TCastNUM(s_)} // Added by EvL for exporting to newly opened window and writing content as text // Use this one for exporting tables with a selection box in the first column only. // The standard export uses Ttable_export, defined below this function function TTP_export(id,sTitle,nSkip) {with (TTablePRO[id]){ var s,i,j,c,w=window.open("about:blank", "exportwindow"); var d = w.document.open("text/html", "replace") var v,r var sMsg, pct, d1, d0 = new Date(), sBut; s = ""; sTS = get_date_by_format(d0,"Ymd_His"); sMsg = ""; r = new RegExp("<[/a-zA-Z][^>]*>","g"); sBut = ' '+ ''; d.write('Export Table
'); d.write('

'+sTitle+'

'); d.write('') d.write(''); d.write(''); if(sMsg!="") w.alert(sMsg); d.close(); }} function stripHTML(sVar){ var Re= /<\S[^>]*>/g; sVar = sVar.replace(Re,""); sVar = sVar.replace("&", "&"); sVar = sVar.replace(">", ">"); sVar = sVar.replace("<", "<"); sVar = sVar.replace("€", "€"); return sVar; } // Added by EvL for exporting to newly opened window and writing content as text function Ttable_export(id,sTitle,iType) {with (TTablePRO[id]){ var s,i,j,w,d,a,ix=0; a = new Array(a_f_body.length+1); s = ""; // header for(j=0;jExport Table'); d.write('\n'); d.write(''); // d.write(''); d.write(''); d.write(''); d.write('

'+sTitle+'

'); d.write('Let op! wordt de download geblokkeerd en krijg je een gele balk van Internet Explorer ? Klik dan op de knop \'Opnieuw Exporteren\'

'); d.write('

'); d.write(''); d.write(''); d.write(''); d.write(''); d.write(''); break; default: alert('Interne fout. Onbekend export type ('+iType+')'); } return false; }} function TTPGetSelection() { var i,j,frm,s = '' for(i=0;i> 1][this.o_sort.n_col], i = l, j = h, t = []; do { while (i <= h && (this.a_cont_d[i][this.o_sort.n_col]< x)) i ++; while (j >= l && (x< this.a_cont_d[j][this.o_sort.n_col])) j --; if (i <= j) { t = this.a_body[i]; this.a_body[i] = this.a_body[j]; this.a_body[j] = t; t = this.a_cont_d[i]; this.a_cont_d[i] = this.a_cont_d[j]; this.a_cont_d[j] = t; i++; j-- } } while (i < j); if (l < j) this.exeQSRT(l, j); if (i < h) this.exeQSRT(i, h); } function TTable(a_capt, a_cont, o_look) { var c = 0, filters = ['substring','match','regexp'], i, a_css = ['main', 'captCell', 'captText', 'head', 'foot', 'pagnCell', 'pagnText', 'pagnPict', 'filtCell', 'filtPatt', 'filtSelc']; this.a_capt = []; this.a_head = []; this.a_body = [];this.a_sel_capt=[], this.a_foot = [];this.a_cont_d=[]; this.a_part = ['Capt()', 'HdFt("a_head")', 'Body()', 'HdFt("a_foot")', 'Page()', 'Filt()']; this.id = TTablePRO.length; TTablePRO[this.id] = this; this.n_fcol = null; this.s_fpat = ''; this.s_light = ''; this.s_click = ''; this.a_index=[]; this.a_index_d=[]; this.a_marked=[]; this.buildCapt = TTPBuildCapt; this.buildHdFt = TTPBuildFreeze; this.buildBody = TTPBuildBody; this.buildPage = TTPBuildPage; this.buildFilt = TTPBuildFilt; this.build = TTPBuild; this.f_show = TTPShow; this.buildCell = TTPBuildCell; this.exeSort = TTPExeSort; this.exeQSRT = TQSRT; this.exePage = TTPExePage; this.exeFilt = TTPExeFilt; this.callFilt = TTPCallFilt; this.callSort = TTPCallSort; this.go = TTPGo; this.o_css = []; this.s_filthtml=''; this.b_date=false; this.f_onclick = o_look.onclick; this.n_key = o_look.key || 0; with (o_look) { for (i in a_css) this.o_css[a_css[i]] = css != null && css[a_css[i]] ? ' class="' + css[a_css[i]] + '"' : ''; this.o_css.body = []; this.n_padding = params[0] || 0; this.n_spacing = params[1] || 0; this.o_color = colors || {}; this.a_struc = structure; if (!paging) var paging = []; this.o_paging = { 's_pf' : paging.pf || '««', 's_pp' : paging.pp || '«', 's_pn' : paging.pn || '»', 's_pl' : paging.pl || '»»', 's_tt' : paging.tt || ' ', 'b_sh' : paging.sh, 'n' : paging.by && paging.by > 0 ? paging.by : a_cont.length, 'c' : 0 }; if (!sorting) var sorting = []; this.o_sort = { 's_as' : sorting.as || '', 's_ds' : sorting.ds || '', 's_no' : sorting.no || '', 'n_col' : sorting.cl, 'b_ord' : sorting.or }; this.btn_ok=filter.btn_ok; this.btn_no=filter.btn_no; this.exp_to = exp_to.type; this.exp_name = exp_to.name; this.btn_exp_text = exp_to.btn_exp_text; this.btn_exp_excel = exp_to.btn_exp_excel; this.btn_exp_clip = exp_to.btn_exp_clip; this.a_filters = filters; this.n_filters = 3; for (i = filters.length-1; i >=0; i--){ if (!((1 << i) & filter.type)) { this.a_filters[i] = 0; this.n_filters --; } else this.n_ftype = i; } var n_head = freeze[0] * 1, n_foot = freeze[1] * 1; } this.b_markmulty = o_look.multy_mark; this.n_rows = a_cont.length - n_head - n_foot; this.n_cols = a_capt.length; for (var i in a_capt) { this.o_css.body[i] = !o_look.css || !o_look.css.body ? '' : typeof(o_look.css.body) != 'object' ? o_look.css.body : o_look.css.body[i] ? ' class="' + o_look.css.body[i] + '"' : ''; this.a_sel_capt[i]={'name': a_capt[i].name.replace(/<[^>]+>/ig,'')}; this.a_capt[i] = { 'name' : a_capt[i].name, 'type' : a_capt[i].type, 'b_hide' : a_capt[i].hide, 'cast' : typeof(window['TCast'+a_capt[i].type]) == 'function' ? window['TCast'+a_capt[i].type] : function (s_) {return s_}, 'f_css' : typeof(a_capt[i].format) == 'function' ? a_capt[i].format : function () {return null} }; if(a_capt[i].type==DATE){ if(!this.b_date){ this.getparseDate = get_date_by_format; this.b_date=true; }; this.a_capt[i].format_input = a_capt[i].format_input || ''; this.a_capt[i].format_output = a_capt[i].format_output || ''; } } for (i = 0; i < a_cont.length; i ++) for (j = 0; j < a_cont[0].length; j ++) if (a_cont[i][j] + '' == ''||a_cont[i][j]==null) a_cont[i][j] = ' '; for (i = 0; i < n_head; i ++) this.a_head[i] = a_cont[c++]; for (i = 0; i < this.n_rows; i ++){ this.a_cont_d[i]=[]; for (var _j = 0; _j < this.n_cols; _j ++) { var s_ = a_cont[i][_j]+''; if(this.a_capt[_j]['type']==DATE){ this.a_cont_d[i][_j]= this.a_capt[_j].cast(s_,this.a_capt[_j].format_input); a_cont[i][_j] = this.getparseDate(this.a_cont_d[i][_j],this.a_capt[_j].format_output); } else this.a_cont_d[i][_j]= this.a_capt[_j].cast(s_); } this.a_body[i] = a_cont[c++]; } for (i = 0; i < n_foot; i ++) this.a_foot[i] = a_cont[c++]; this.go(); } function TTPBuildCapt() { var a_ = [''], i, b_order, s_img, n_cnt = 1; for (i in this.a_capt) if (!this.a_capt[i].b_hide) if (this.a_capt[i].type) { b_order = Boolean(this.o_sort.n_col == i && this.o_sort.b_ord != 1); s_img = this.o_sort[this.o_sort.n_col != i ? 's_no' : this.o_sort.b_ord ? 's_ds' : 's_as']; s_lnk = 'TTablePRO[' + this.id + '].exeSort(' + i + ',' + b_order + ')'; a_[n_cnt++] = this.buildCell(['
Bestandsnaam:
'+sBut+'
', '
', this.a_capt[i].name, '', s_img, '
'].join(''), this.o_css.captCell); } else a_[n_cnt++] = this.buildCell(['
', this.a_capt[i].name, '
'].join(''), this.o_css.captCell); a_[n_cnt++] = ''; return a_.join(''); } function TTPBuildFilt() { if (this.s_filthtml) return this.s_filthtml; if (this.n_filters==0&&this.exp_to==0) return ''; var a_ = [''], n_cnt = 7; if(this.exp_to>0) { a_[n_cnt++] = ''; } } if(this.n_filters > 0) { a_[n_cnt++]=''; //xx.xx; } a_[n_cnt++] = '
'; if(this.exp_to&1) { // clipboard a_[n_cnt++] = ''+this.btn_exp_clip+' '; } if(this.exp_to&2) { // text a_[n_cnt++] = ''+this.btn_exp_text+' '; } if(this.exp_to&4) { // excel a_[n_cnt++] = ''+this.btn_exp_excel+''; a_[n_cnt++] = 'Filter als '; if (this.n_filters > 1) { a_[n_cnt++] = ''; for (var i = 0; i < this.a_filters.length; i++) if (this.a_filters[i]) a_[n_cnt++] = ['
'; this.s_filthtml=a_.join(''); return this.s_filthtml; } function TTPBuildPage() { var n_a = Math.ceil(this.n_rows / this.o_paging.n) - 1; if (n_a <= 0 && !this.o_paging.b_sh) return ''; var a_ = [''], n_cnt = 4; this.o_paging.c = this.o_paging.c * 1; var s_ = ''; if (this.o_paging.s_pp) a_[n_cnt ++] = s_ + (this.o_paging.c - 1) + ')" title="Vorige pagina">' + this.o_paging.s_pp + ''; } a_[n_cnt++] = ''; if (this.o_paging.c < n_a) { if (this.o_paging.s_pn) a_[n_cnt ++] = s_ + (this.o_paging.c + 1) + ')" title="Volgende pagina">' + this.o_paging.s_pn + ''; if (this.o_paging.s_pl) a_[n_cnt ++] = s_ + n_a + ')" title="Laatste pagina">' + this.o_paging.s_pl + ''; } a_[n_cnt++] = '
' + this.o_paging.s_pf + '' + this.o_paging.s_tt.replace('%ind', this.o_paging.c+1).replace('%pgs', n_a+1).replace('%rcs', this.n_rows) + '
'; return a_.join(''); } function TTPBuildCell(value, s_CSS, s_add) { return '' + value + ''; } function TTPBuildFreeze(s_what) { var s_ = '', i, j; for (i = 0; i < this[s_what]; i++) { s_ += ''; for (j in this.a_capt) if (!this.a_capt[j].b_hide) s_ += this.buildCell(this[s_what][i][j], this.o_css[s_what]); s_ += ''; } return s_; } function TTPBuild () { var i, s_ = ""; for (i in this.a_struc) { if(typeof(bNoFormTable)=="undefined" && this.a_part[this.a_struc[i]] == 'Body()') s_ += ''; s_ += eval('this.build' + this.a_part[this.a_struc[i]]); if(typeof(bNoFormTable)=="undefined" && this.a_part[this.a_struc[i]] == 'Body()') s_ += ''; } s_ += "
"; return s_ ; } function TTPExeFilt(i_) { if (i_) { var e_form=d.forms['TTForm'+this.id]; this.n_fcol = !e_form.filtCol ? 0 : e_form.filtCol.type.indexOf('select-') > -1 ? e_form.filtCol.options[e_form.filtCol.selectedIndex].value : e_form.filtCol.value; this.s_fpat = e_form.filtPatt.value; this.n_ftype = e_form.filtType && e_form.filtType.type.indexOf('select-') > -1 ? e_form.filtType.options[e_form.filtType.selectedIndex].value : this.n_ftype; } else { this.n_fcol = null; this.s_fpat = ''; } this.o_paging.c = 0; this.f_show(); return false; } function TTPExePage(n) { this.o_paging.c = n; this.f_show(); } function TTPExeSort(n_col, n_ord) { var n_col_old = this.o_sort.n_col; this.o_sort.n_col = n_col; this.o_sort.b_ord = n_ord; this.o_paging.c = 0; this.f_show(true, n_col_old); } function TTPCallSort(n_col_old) { var i,j=0; if (n_col_old == this.o_sort.n_col){ this.a_body = this.a_body.reverse(); this.a_cont_d = this.a_cont_d.reverse(); } else { if(!this.a_index[this.o_sort.n_col]){ this.exeQSRT(0, this.a_cont_d.length - 1); this.a_index[this.o_sort.n_col]=[]; this.a_index_d[this.o_sort.n_col]=[]; for (i = 0; i < this.a_body.length; i ++){ this.a_index[this.o_sort.n_col][j]=this.a_body[i]; this.a_index_d[this.o_sort.n_col][j++]=this.a_cont_d[i]; } this.a_index[this.o_sort.n_col]['b_ord']=this.o_sort.b_ord; }else{ if (this.a_index[this.o_sort.n_col]['b_ord']!=this.o_sort.b_ord){ this.a_body = this.a_index[this.o_sort.n_col].reverse(); this.a_cont_d = this.a_index_d[this.o_sort.n_col].reverse(); }else{ this.a_body = this.a_index[this.o_sort.n_col]; this.a_cont_d = this.a_index_d[this.o_sort.n_col]; } } if (this.o_sort.b_ord){ this.a_body = this.a_body.reverse(); this.a_cont_d = this.a_cont_d.reverse(); } } } function TTPCallFilt() { if (!this.s_fpat || this.n_fcol == null) return this.a_body; var a_body = []; if (this.n_ftype == 2) var r_ = eval('/' + this.s_fpat + '/i'); for (i = 0; i < this.a_body.length; i ++) if ( (this.n_ftype == 2 && (''+this.a_cont_d[i][this.n_fcol]).search(r_) > -1) || (this.n_ftype == 1 && (''+this.a_cont_d[i][this.n_fcol]).toLowerCase() == this.s_fpat.toLowerCase()) || (this.n_ftype == 0 && (''+this.a_cont_d[i][this.n_fcol]).toLowerCase().indexOf(this.s_fpat.toLowerCase()) > -1) ) a_body[a_body.length] = this.a_body[i]; return a_body; } d.write(''); d.write('')