SOPHIAKNOWS | CODEBASE > JAVASCRIPT

<head>
<script type='text/javascript'>
<!--
/* --------------------------------- */
/*     SOPHIAKNOWS: JAVASCRIPT       */
/* --------------------------------- */
/*         DATABASE: TOOLS           */
/* --------------------------------- */
/*  Created:  2002-01-15             */
/*  Issued:   2002-01-15             */
/*  Modified: 2006-03-17             */
/*  Copyright (c) 2002-2006          */
/*  Tony Pisarra, SophiaKnows        */
/* --------------------------------- */
/* --------------------------------- */

// DATABASE: ALL (begin)

// DATABASE: CONSTRUCTOR:
function Database(list) {
    this.list=list;
    this.length=this.list.length;
    this.editor="";
    this.selected=0;
    this.next=((this.selected+1<this.length)?this.selected+1:0);
    this.back=((this.selected>0)?this.selected-1:this.length-1);
    this.params=new Array();
    for(keys in this.list[0]) { this.params[this.params.length]= keys; }
    }

// DATABASE: METHODS (begin)

// DATABASE: METHODS
// ADD ENTRY
Database.prototype.add_entry = function (s) {
    this.list[this.list.length]= new Object;
    for(i in this.params) {
        this.list[(this.list.length-1)][this.params[i]]="";
        }
    this.length=this.list.length;
    this.form_show(this.list.length-1);
    }

// DATABASE: METHODS
// ADD ENTRY
Database.prototype.delete_entry = function () {
    var new_list = new Array();
    if(!confirm("Delete Item?")) return false;
    for(i in this.list) {
        if(i != this.selected) {
            new_list[new_list.length]=this.list[i];
            }
        }
    for(i in this.list)  this.list[i]=new_list[i];
    this.length = this.list.length = new_list.length;
    this.selected=0;
    this.form_show(0);
    }

// DATABASE: METHODS
// INIT FORM
Database.prototype.init_form = function (s) {
    this.autopopulate(s);
    this.show_detail(s)
    }

// DATABASE: METHODS    
// AUTO POPULATE
Database.prototype.autopopulate = function (s) {
    var props=new Array();
    s.length=this.list.length;
    for (i in this.list) {
        s.options[i].value=i;
        s.options[i].text=this.list[i][this.params[0]];
        }
    s.selectedIndex=0;
    }

// DATABASE: METHODS    
// SHOW DETAIL
Database.prototype.show_detail = function (s) {
    if(s.length) {
        q=((s.selectedIndex>-1)?s.options[s.selectedIndex].value:s.options[0].values);
        viewer=document.getElementById('detail');
        viewer.innerHTML=this.return_detail(q);
        this.form_show(q)
        }
    }

// DATABASE: METHODS    
// MAKE HIDDENS
Database.prototype.mkhiddens = function () {
    var hiddens="";
    for(p in this.params) {
        hiddens+="<input type=hidden name=\""+this.params[p]+"\" value=\""+this.params[p]+"\">";
        }
    return hiddens;
    }
    
// DATABASE: METHODS    
// RETURN DETAIL
Database.prototype.return_detail = function(m) {
    var detail="";
    detail+="<table width=100% align=center cellpadding=4 cellspacing=1 style=margin-top:20px;>";
    for(keys in this.list[m]) {    
        detail+="<tr><th>"+keys+":<\/th>";
        detail+="<td><a href=\"javascript:dosub(document.forms['dbviewer']."+keys+")\" title='click to copy'>"+this.list[m][keys]+"</a><\/td><\/tr>";
        }
    detail+="<\/table>";
    return detail;
    }

// DATABASE: METHODS
// BACK OPTION
Database.prototype.back_option = function (s) {
    if(s.selectedIndex>-1) {
        s.selectedIndex=((s.selectedIndex>0)?  s.selectedIndex-1 : s.length-1);
        } else {s.selectedIndex=0;}
    this.show_detail(s);
    }

// DATABASE: METHODS
// NEXT OPTION    
Database.prototype.next_option = function (s) {
    if(s.selectedIndex>-1) {
        s.selectedIndex=((s.selectedIndex<(s.length-1))?s.selectedIndex+1 : 0);
        } else {s.selectedIndex=0;}
    this.show_detail(s);
    }

// DATABASE: METHODS
// TYPE DOWN 
Database.prototype.type_down = function (s,t) {
    stext=new Array();
    skeys=new Array();
    var y=0;
    for(m=0;m<this.list.length;m++) {     // GET MATCHES
        if(this.list[m][this.params[0]].toLowerCase().indexOf(t.value.toLowerCase())>-1) {
            stext[y]=this.list[m][this.params[0]];
            skeys[y]=m;
            y++;
            }
        }
    s.length=skeys.length;     // RESET SELECT LENGTH
    for(i=0;i<skeys.length;i++) {     // POPULATE SUGGESTIONS
        s.options[i].value=skeys[i];    
        s.options[i].text=stext[i];    
        }
    s.selectedIndex=0;
    this.show_detail(s);
    }

// DATABASE: METHODS
// FORM: MAKE FORM
Database.prototype.mkform = function () {
    the_form="";

    for(i in this.params) {
        the_form+="<tr><td>"+this.params[i]+"<td><input name=\""+this.params[i]+"\" / ></td></tr>";
        }
    return the_form;
    } 

// DATABASE: METHODS
// FORM: FORM SHOW
Database.prototype.form_show = function (i) {
    this.editor=((document.forms['dbeditor'])?document.forms['dbeditor']:document.forms['dbviewer']);
    if(this.selected!=i) this.form_save(this.selected);
    this.selected=i;
    this.next=((this.selected+1<this.length)?this.selected+1:0);
    this.back=((this.selected>0)?this.selected-1:this.length-1);
    if(this.editor.counter) this.editor.counter.value=(this.selected+1);
    if(this.editor.allcount) this.editor.allcount.value=this.length;
    for(p in this.params) {
        if(this.editor.elements[this.params[p]]) {
            this.editor.elements[this.params[p]].value=this.list[i][this.params[p]];
            }
        }
    return false;
    } 

// DATABASE: METHODS
// FORM: FORM SAVE
Database.prototype.form_save = function (i) {
    this.editor==((document.forms['dbeditor'])?document.forms['dbeditor']:document.forms['dbviewer']);
    if(this.editor) {
    for(p in this.params) {
        if(this.editor.elements[this.params[p]]) {
            this.list[i][this.params[p]]=this.editor.elements[this.params[p]].value;
            }
        }
        }
    } 

// DATABASE: METHODS
// FORM: EXPORT JS
Database.prototype.export_js = function () {
    this.form_save(this.selected);
    exp="";
    exp+="function Item("+this.params.join()+") {\n";
    for(p in this.params) { exp+="this."+this.params[p]+"="+this.params[p]+";\n";}
    exp+="}\n\n";
    exp+="items = new Array();\n";
    for(n in this.list) {
        exp+="items";
        exp+="["+n+"] = new Item(\"";
        for(p in this.params) {
            exp+=this.list[n][this.params[p]]+((p<this.params.length-1)?"\",\"":"");
            }
        exp+="\");\n";
        }
    expWindow = window.open();
    expWindow.document.write("<pre>");
    expWindow.document.write(exp.replace(/</g,"<"));
    expWindow.document.write("</pre>");
    expWindow.document.close();

    } 

// DATABASE: METHODS
// FORM: EXPORT TXT
Database.prototype.export_txt = function () {
    this.form_save(this.selected);
    exp="";
    for(n in this.list) {
        for(p in this.params) {
            exp+=this.list[n][this.params[p]]+((p<this.params.length-1)?"\t":"");
            }
        exp+="\n";
        }
    expWindow = window.open();
    expWindow.document.write("<pre>");
    expWindow.document.write(exp.replace(/</g,"<"));
    expWindow.document.write("</pre>");
    expWindow.document.close();
    } 
    

// DATABASE: METHODS (end)
// DATABASE: ALL (end)