//ICMap, Copyright 2006, clifford L. Collins, Collins Software, all rights reserved, http://collinssoftware.com, not for distribution or resale, use License is required: icdatabase
function passed(A)
{
if((A==null)||(A==undefined))return false;
return true;
}
function ic$Database(id,receiver,database,table,column,Q,dataElement,countElement,navButtons,imgElement,onFormatField,onShowTable,onFail)
{
this.id=id;
this.database=database;
this.data=null;
this.count=null;
this.navButtons=null;
this.img=null;
if(passed(dataElement))this.data=dataElement;
if(passed(countElement))this.count=countElement;
if(passed(navButtons))this.navButtons=navButtons
if(passed(imgElement))this.img=imgElement;
this.onFormatField=onFormatField;
this.onShowTable=onShowTable;
this.onFail=onFail;
this.isRecordModified=false;
this.isTableModified=false;
this.tableName=table;
this.columnName=column;
this.Q=Q;
this.receiver=receiver+"?database="+this.database+'&';
this.makeElements=$490;
this.makeButtons=$507;
this.readTable=$498;
this.readGraphicTable=$499;
this.getX=$487X;
this.getY=$487Y;
this.getHref=$487Href;
this.newRecord=$488;
this.newPointRecord=$489;
this.resolve=$503;
this.deleteRecord=$504;
this.deleteRecordAll=$504All;
this.deleteRecord_A=$504_A;
this.isImg=$508;
this.execute=$500;
this.saveRecord=$502;
this.saveTable=$501;
this.first=$494;
this.last=$497;
this.next=$496;
this.prev=$495;
this.put=$486;
this.get=$487;
}
function $486(name,value)
{
if(this.rs.status==0)return false;
try
{
f=this.rs.Fields.Item(name);
f.value=value;
return true;
}
catch(e){ return false }
}
function $487(name)
{
var f,value;
if(this.rs.status==0)return"";
try
{
f=this.rs.Fields.Item(name);
value=f.value;
if(value==null)value="";
if(value.length >1000)value=value.substr(1,400);
return value;
}
catch(e){ return"" }
}
function $488()
{
if(this.rs.status==0)return 0;
this.saveRecord();
this.rs.AddNew();
this.makeElements();
return this.rs.RecordCount;
}
function $489(x,y,href)
{
if(this.rs.status==0)return 0;
this.saveRecord();
this.rs.AddNew();
this.put("xmin",x);
this.put("ymin",y);
this.put("xmax",x);
this.put("ymax",y);
this.put("x",x);
this.put("y",y);
this.put("href",href);
this.makeElements();
return this.rs.RecordCount;
}
function $490()
{
var text;
var v,n,xname;
var i,add;
text="";
if(this.data !=null)this.data.innerHTML=text;
if(this.count !=null)this.count.innerText=""
this.isRecordModified=false;
if((! this.rs)||(this.rs.BOF&& this.rs.EOF))
{
if(this.onFail !=null)text=this.onFail();
if(this.data !=null)this.data.innerHTML=text;
return false;
}
def=true;
if(this.onFormatField !=null)def=false;
if(def){ text="<table width='100%' bgcolor=\"#FFFFFF\">"; }
for(i=0; i <this.rs.Fields.Count; i++)
{
if(this.isImg(this.rs.Fields(i)))continue;
v="";
if(this.rs.Fields(i).value)v=this.rs.Fields(i).value.toString();
if(v==null)v="";
if(v==undefined)v="";
while(v.indexOf("'")>=0)
{ v=v.replace("'"," "); }
while(v.indexOf("\"")>=0)
{ v=v.replace("\""," "); }
n=this.rs.Fields(i).name;
if(def)
{
xname=n.toUpperCase();
if(xname=="X")continue;
if(xname=="Y")continue;
if(xname=="ID")continue;
if(xname=="XMIN")continue;
if(xname=="YMIN")continue;
if(xname=="XMAX")continue;
if(xname=="YMAX")continue;
add="";
if(xname=='HREF'&&(!((v==null)||(v==""))))add=" <input type=button value=\"go\" onClick=\"window.open('"+v+"','icHref')\">";
more=" id=\"DB_"+xname+"\"";
more=more+" onMouseDown=\"DBUpdate('"+this.id+"')\"";
text=text+"<tr><td width=80 align=\"right\">"+
"<b><font color=blue size=1>"+n+"</font></b></td>"+
"<td width=550><font size=2><Input "+more+" type=text size=30 value=\""+v+"\"></font>"+add+"</td></tr>";
}
else
{
text=text+this.onFormatField(this.rs.Fields(i),n,v,i+1,this.rs.Fields.Count);
}
}
if(def)text=text+'</table>'
if(this.onShowTable !=null)
{ this.onShowTable(text)}
else{ if(this.data !=null)this.data.innerHTML=text;}
if(this.count==null)return;
if( this.rs.RecordCount >0)
if(this.count !=null)this.count.innerText=this.rs.AbsolutePosition+' of '+this.rs.RecordCount;
}
function $487X()
{
var x;
try
{
x=this.rs.Fields('x').value;
}
catch(e){ x=0}
return x;
}
function $487Href()
{
var h;
try
{
h=this.rs.Fields('Href').value;
}
catch(e){ h="" }
return h;
}
function $487Y()
{
var y;
try
{
y=this.rs.Fields('y').value;
}
catch(e){ y=0 }
return y;
}
function $494(){
try
{
this.saveRecord();
this.rs.MoveFirst();
this.makeElements();
return true;
}
catch(e){ return false }
}
function $495(){
try
{
this.saveRecord();
this.rs.MovePrevious();
if(this.rs.BOF)this.rs.MoveFirst();
this.makeElements();
return true;
}
catch(e){ return false }
}
function $496(){
try
{
this.saveRecord();
this.rs.MoveNext();
if(this.rs.EOF)this.rs.MoveLast();
this.makeElements();
return true;
}
catch(e){ return false }
}
function $497(){
try
{
this.saveRecord();
this.rs.MoveLast();
this.makeElements();
return true;
}
catch(e){ return false }
}
function $498(tableName){
var text;
this.isModified=false;
try
{
this.table=tableName;
this.rs=new ActiveXObject("ADODB.Recordset");
this.xmlDoc=new ActiveXObject("MsDB2.DOMDocument");
this.xmlhttp=new ActiveXObject("MsDB2.XMLhttp");
text=this.receiver+"getRecordset=YES&Table="+tableName;
this.xmlhttp.Open("Get",text,false);
this.xmlhttp.send();
this.xmlDoc.loadXML(this.xmlhttp.responseText);
this.rs.Open(this.xmlDoc);
if(this.navButtons !=null)this.navButtons.style.display='';
this.makeElements();
return true;
}
catch(e){ window.alert(e.description); return false }
}
function $499(tableName,xmin,ymin,xmax,ymax){
var text;
this.isModified=false;
try
{
this.table=tableName;
this.rs=new ActiveXObject("ADODB.Recordset");
this.xmlDoc=new ActiveXObject("MsDB2.DOMDocument");
this.xmlhttp=new ActiveXObject("MsDB2.xmlhttp");
text=this.receiver+"getRecordset=YES&Table="+tableName+
"&Graphic=YES"+
"&xmin="+xmin+"&ymin="+ymin+
"&xmax="+xmax+"&ymax="+ymax;
this.xmlhttp.Open("Get",text,false);
this.xmlhttp.send();
this.xmlDoc.loadXML(this.xmlhttp.responseText);
this.rs.Open(this.xmlDoc);
if(this.navButton !=null)this.navButtons.style.display='';
this.makeElements();
return true;
}
catch(e){ window.alert(e.description); return false }
}
function $500(sql){
var text;
if(this.rs)
{
if(!(this.rs.BOF&& this.rs.EOF))
{
if(this.rs.status !=0)this.rs.close();
}
}
this.isModified=false;
try
{
this.table="";
this.rs=new ActiveXObject("ADODB.Recordset");
this.xmlDoc=new ActiveXObject("MsXml2.DOMDocument");
this.xmlhttp=new ActiveXObject("MsXml2.xmlhttp");
text=this.receiver+"getRecordset=YES&SQL="+sql;
this.xmlhttp.Open("Get",text,false);
this.xmlhttp.send();
strToFile(this.xmlhttp.responseText,'c:/xx.htm');
this.xmlDoc.loadXML(this.xmlhttp.responseText);
this.rs.Open(this.xmlDoc);
if(this.navButtons !=null)this.navButtons.style.display='';
this.makeElements();
return true;
}
catch(e){ window.alert(e.description); return false }
}
function $501()
{
var text;
if(! this.isTableModified)return;
if(this.rs.status==0)return;
try
{
var DBstream=new ActiveXObject("ADODB.Stream");
DBstream.Mode=3;
DBstream.Open();
DBstream.Type=1;
this.rs.Save(DBstream,0);
this.xmlhttp=new ActiveXObject("Msxml2.xmlhttp");
this.xmlhttp.Open("POST",this.receiver+"getRecordset=NO",false);
this.xmlhttp.setRequestHeader("Content-Length",DBstream.Size);
this.xmlhttp.send(DBstream.Read(DBstream.Size));
alert(this.xmlhttp.responseText);
return true;
}
catch(e){ window.alert(e.description); return false }
}
function $502()
{
if(this.rs.status==0)return;
if(this.rs.RecordCount <=0)return;
if(! this.isRecordModified)return;
this.lastMsg="";
try
{
for(i=0; i <this.rs.Fields.Count; i++)
{
n=this.rs.Fields(i).name;
xname=n.toUpperCase();
if(xname=="X")continue;
if(xname=="Y")continue;
if(xname=="ID")continue;
if(xname=="XMIN")continue;
if(xname=="YMIN")continue;
if(xname=="XMAX")continue;
if(xname=="YMAX")continue;
this.lastMsg="failed to update column "+xname;
name="DB_"+xname;
obj=eval(name);
if(obj==null)continue;
text=obj.value;
if(text=="")text=null;
this.rs.Fields(i).value=text;
}
this.lastMsg
this.rs.Update();
this.isRecordModified=false;
this.isTableModified=true;
}
catch(e)
{
window.alert(this.lastMsg+'\n'+DBError(e,this.xmlhttp,this.xmlDoc));
throw(e);
}
}
function DBError(e,x,d)
{
var text;
text=e.description;
return text;
}
function DBUpdate(name)
{
var obj;
obj=eval(name);
if(obj==null)return;
obj.isRecordModified=true;
}
function $503(text)
{
var temp,name;
name=this.get('name');
temp=text.replace('{DB.name}',name);
return temp;
}
function $504()
{
var adAffectCurrent=1;
return this.deleteRecord_A(adAffectCurrent);
}
function $504All()
{
var adAffectAll=3;
return this.deleteRecord_A(adAffectAll);
}
function $504_A(type)
{
if(this.rs.status==0)return false;
if(this.rs.RecordCount==0)return false;
try
{
this.rs.Delete(type);
this.next();
this.makeElements();
return true;
}
catch(e)
{
window.alert(e.description);
return false;
}
}
function $507()
{
var t,obj;
if(this.navButtons==null)
{
window.alert('DB.makeButtons - Could not find Element: navButtons');
return;
}
t="";
t=t+"<INPUT ID=DBNavFirst TYPE=BUTTON VALUE=\"<<\" onclick=\""+this.id+".first()\">";
t=t+"<INPUT ID=DBNavPrev  TYPE=BUTTON VALUE=\"<\" STYLE=\"width:20px\" onclick=\""+this.id+".prev()\">";
t=t+"<INPUT ID=DBNavNext  TYPE=BUTTON VALUE=\">\" STYLE=\"width:20px\" onclick=\""+this.id+".next()\">";
t=t+"<INPUT ID=DBNavLast  TYPE=BUTTON VALUE=\">>\" onclick=\""+this.id+".last()\">";
t=t+"&nbsp;&nbsp;&nbsp;&nbsp;";
t=t+"<INPUT ID=DBNavRollback TYPE=BUTTON VALUE=\"undo\" onclick=\""+this.id+".makeElements()\">";
t=t+"<INPUT ID=DBNavDeleteRecord TYPE=BUTTON VALUE=\"Delete Record\" onclick=\""+this.id+".deleteRecord()\">";
t=t+"<INPUT ID=DBNavSaveRecord TYPE=BUTTON VALUE=\"Save Record\" onclick=\""+this.id+".saveRecord()\">";
this.navButtons.innerHTML=t;
this.navButtons.style.display='none';
}
function $508(f)
{
var b,ms,o,c;
if(f.name.toUpperCase()!="PICTURE")return false;
if(this.img==null)return true;
if(f.value==null)return true;
try
{
tr=this.rs.GetString(2);
size=f.ActualSize;
this.img.src=tr
}
catch(e){window.alert(e.description)}
return true;
}