function m41(){
	menu.hide();
	var SQL = "select id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_ from library";
	var SQLCOLS = "id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_";
	GridDiv("Library details");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextl.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
 	mygrid.setHeader("Id,Site,Contact,Department,Institution,Adress,,,,,Post Code,Telephone,Fax,Email"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("80,80,80,80,80,80,80,80,80,80,80,80,80,80"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'library');
	AddNewButton(mygrid,'library',"m41.xml",SQLCOLS,"site_",600,550,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQL = "select id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_ from library";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m41cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 550);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_ from library";
    	var SQLCOLS = "id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,site_,contact_,department_,institution_,ad1_,ad2_,ad3_,ad4_,ad5_,postcode_,telephone_,fax_,email_";
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#site_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m41.xml");

}
function m49(){
	menu.hide();
	var SQL = "select id_,subjectcategory,descriptor,relatedterm,usedfor,useas,broaderterm,scopenote,narrowerterm,historynote,status,inputdate,approveddate,lastupdated from thesaurus order by subjectcategory asc";
	var SQLCOLS = "id_,subjectcategory,descriptor,relatedterm,usedfor,useas,broaderterm,scopenote,narrowerterm,historynote,status,inputdate,approveddate,lastupdated";
	GridDiv("Thesaurus");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_context49.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
 	mygrid.setHeader("Id,Subject category,Descriptor,Related term,Used for,Use as,Broader term,Scope note,Narrower term,History note,Status,Input date,Approved date,Last updated"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("80,80,80,80,80,80,80,80,80,80,80,80,80,80"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddGroupButton(mygrid,1);
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'library');
	AddNewButton(mygrid,'library',"m49.xml",SQLCOLS,"subjectcategory",600,550,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
        var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m49cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 550);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,subjectcategory,descriptor,relatedterm,usedfor,useas,broaderterm,scopenote,narrowerterm,historynote,status,inputdate,approveddate,lastupdated from thesaurus order by subjectcategory asc";
    	var SQLCOLS = "id_,subjectcategory,descriptor,relatedterm,usedfor,useas,broaderterm,scopenote,narrowerterm,historynote,status,inputdate,approveddate,lastupdated";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,subjectcategory,descriptor,relatedterm,usedfor,useas,broaderterm,scopenote,narrowerterm,historynote,status,inputdate,approveddate,lastupdated";
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	alert(line);
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#subjectcategory");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m49.xml");

}
function m42(){
	menu.hide();
	var SQL = "select id_,name_,login_,password_,privileges_,site_,telephone_,email_ from users";
	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,telephone_,email_";
	GridDiv("Library users");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextu.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
 	mygrid.setHeader("Id,Name,Login,Password,Privileges,Site,Telephone,Email"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("80,80,80,80,80,80,80,80"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'users');
	AddNewButton(mygrid,'Users',"m42.xml",SQLCOLS,"name_",600,400,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,telephone_,email_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m42cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 400);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,name_,login_,password_,privileges_,site_,telephone_,email_ from users";
    	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,telephone_,email_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,telephone_,email_";
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#name_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m42.xml");

}



function m43(){
	menu.hide();
	var SQL = "select id_,date_,type_,login_,password_,result_ from logins order by date_ desc";
	var SQLCOLS = "id_,date_,type_,login_,password_,result_";
	GridDiv("Logins");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextu.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Date,Type,Login,Password,Result"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,90,90,90,90,315"); 
	mygrid.setColAlign("left,left,left,left,left,left");  
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'logins');
	AddNewButton(mygrid,'Logins',"m43.xml",SQLCOLS,"date_",600,400,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQLCOLS = "id_,date_,type_,login_,password_,result_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m43cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 400);
    dhxWins.attachEvent("onClose", function(win){
   	var SQL = "select id_,date_,type_,login_,password_,result_ from logins order by date_ desc";
   	var SQLCOLS = "id_,date_,type_,login_,password_,result_";
   	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,date_,type_,login_,password_,result_";	
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#date_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m43.xml");

}

function m44(){
	menu.hide();
	var SQL = "select id_,context_,helptext_ from help order by id_ asc";
	var SQLCOLS = "id_,context_,helptext_";
	GridDiv("Help text");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextt.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Context,Help Text"); 
	mygrid.setColTypes("ro,ro,ro");
	mygrid.setInitWidths("70,90,550"); 
	mygrid.setColAlign("left,left,left"); 
	mygrid.setColSorting("connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'help');
	AddNewButton(mygrid,'Help text',"m44.xml",SQLCOLS,"context_",600,400,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQLCOLS = "id_,context_,helptext_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m44cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 700, 350);
    dhxWins.attachEvent("onClose", function(win){
   	var SQL = "select id_,context_,helptext_ from help order by id_ asc";
   	var SQLCOLS = "id_,context_,helptext_";
  	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,context_,helptext_";
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#context_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m44.xml");

}

function m45(){
	menu.hide();
	var SQL = "select id_,word_ from dictionary order by word_ asc";
	var SQLCOLS = "id_,word_";
	GridDiv("Dictionary");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextd.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Word"); 
	mygrid.setColTypes("ro,ro");
	mygrid.setInitWidths("70,650"); 
	mygrid.setColAlign("left,left"); 
	mygrid.setColSorting("connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'help');
	AddNewButton(mygrid,'Dictionary',"m45.xml",SQLCOLS,"word_",500,300,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQLCOLS = "id_,word_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m45cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 500, 300);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,word_ from dictionary order by word_ asc";
    	var SQLCOLS = "id_,word_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
      	var SQLCOLS = "id_,word_";
      	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#word_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m45.xml");

}
function m46(){
	menu.hide();
   	var SQL = "select id_,DATE_FORMAT(return_,'%d/%m/%Y') as return_,purpose_,active_,DATE_FORMAT(holidaystart_,'%d/%m/%Y') as holidaystart_,DATE_FORMAT(holidayend_,'%d/%m/%Y') as holidayend_,discount_ from specialdates order by holidaystart_ asc";
    var SQLCOLS = "id_,return_,purpose_,active_,holidaystart_,holidayend_,discount_";
	GridDiv("Closed days");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextc.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Return,Purpose,Active,Holiday start,Holiday end,Discount"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,300,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'specialdates');
	AddNewButton(mygrid,'Dictionary',"m46.xml",SQLCOLS,"return_",600,400,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQL = "select id_,return_,purpose_,active_,DATE_FORMAT(holidaystart_,'%d/%m/%Y') as holidaystart_,DATE_FORMAT(holidayend_,'%d/%m/%Y') as holidayend_,discount_ from specialdates order by holidaystart_ asc";
    	var SQLCOLS = "id_,return_,purpose_,active_,holidaystart_,holidayend_,discount_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m46cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 400);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,DATE_FORMAT(return_,'%d/%m/%Y') as return_,purpose_,active_,DATE_FORMAT(holidaystart_,'%d/%m/%Y') as holidaystart_,DATE_FORMAT(holidayend_,'%d/%m/%Y') as holidayend_,discount_ from specialdates order by holidaystart_ asc";
    	var SQLCOLS = "id_,return_,purpose_,active_,holidaystart_,holidayend_,discount_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,return_,purpose_,active_,holidaystart_,holidayend_,discount_";
      	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#return_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m46.xml");

}
function m47(){
	menu.hide();
  	var SQL = "select id_,budget_,control_,expense_,allocated_,committed_,spent_,DATE_FORMAT(start_,'%d/%m/%Y') as start_,DATE_FORMAT(end_,'%d/%m/%Y') as end_,notes_ from budget order by id_ asc";
   	var SQLCOLS = "id_,budget_,control_,expense_,allocated_,committed_,spent_,start_,end_,notes_";
	GridDiv("Budgets");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextb.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Budget,Control,Expense,Allocated,Committed,Spent,Start,End,Notes"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,70,70,70,70,70,70,70,200"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'budgets');
	AddNewButton(mygrid,'Budgets',"m47.xml",SQLCOLS,"budget_",600,450,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
      	var SQL = "select id_,budget_,control_,expense_,allocated_,committed_,spent_,DATE_FORMAT(start_,'%d/%m/%Y') as start_,DATE_FORMAT(end_,'%d/%m/%Y') as end_,notes_ from budget order by id_ asc";
       	var SQLCOLS = "id_,budget_,control_,expense_,allocated_,committed_,spent_,start_,end_,notes_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m47cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 450);
    dhxWins.attachEvent("onClose", function(win){
      	var SQL = "select id_,budget_,control_,expense_,allocated_,committed_,spent_,DATE_FORMAT(start_,'%d/%m/%Y') as start_,DATE_FORMAT(end_,'%d/%m/%Y') as end_,notes_ from budget order by id_ asc";
       	var SQLCOLS = "id_,budget_,control_,expense_,allocated_,committed_,spent_,start_,end_,notes_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
       	var SQLCOLS = "id_,budget_,control_,expense_,allocated_,committed_,spent_,start_,end_,notes_";
     	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#budget_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m47.xml");

}


function m48(type){
	menu.hide();
	var SQL = "select barcode_,catalogue_,title_,authors_,isbn_,price_, location_,site_,shelf_,status_ from copies,catalogue where copies.catalogue_ = catalogue.id_ and status_ = 'DEL' order by title_"; 
	var SQLCOLS = "barcode_,catalogue_,title_,authors_,isbn_,price_, location_,site_,shelf_,status_";
	GridDiv("Action Deletions");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.setHeader("Barcode,Catalogue,Title,Authors,Isbn,Price,Location,Site,Shelf,Status"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,200,90,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	GridInit(mygrid,SQL,SQLCOLS);
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'budgets');
	AddRemoveButton();
}

function GoDelete(mygrid){

	mygrid.forEachRow(function(id){
		var cellObj = mygrid.cellById(id, 0);
		var barcode_ = cellObj.getValue();
		cellObj = mygrid.cellById(id, 1);
		var catalogue_ = cellObj.getValue();
// see if this is the only copy
//if it is then delete the copy and the catalogue record
//if not just delete the copy
		var SQL = "select id_ from copies where catalogue_ = " + catalogue_;
		var SQLCOLS = "id_";
		var result = new Array();
	  	AjaxSql("tab",SQL,SQLCOLS,result);		//results in result[i] etc
		if(result[0] == 1){
			mygrid.setRowTextStyle(id, "color: green; ");
//more than one copy just delete the copy
		}
		else{
			var SQL = "delete from copies where barcode_ = " + barcode_;
			var result = UpdateRecord(SQL,"tab");
			if(isNaN(result)){
				alert(result);
				mygrid.setRowTextStyle(id, "color: green; ");
			}
			else
				mygrid.setRowTextStyle(id, "color: red; ");
		}
	});
}
	
function m4941(){
	menu.hide();
	var SQL = "select id_,barcode_,catalogue_,copytrap_ from copies where copytrap_ <> ''"; 
	var SQLCOLS = "id_,barcode_,catalogue_,copytrap_";
  	GridDiv("Trapped copies");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contexta.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Barcode,Catalogue,Trap"); 
	mygrid.setColTypes("ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,70,200"); 
	mygrid.setColAlign("left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'traps');
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQL = "select id_,barcode_,catalogue_,copytrap_ from copies"; 
    	var SQLCOLS = "id_,barcode_,catalogue_,copytrap_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4941cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 300);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,barcode_,catalogue_,copytrap_ from copies where copytrap_ <> ''"; 
    	var SQLCOLS = "id_,barcode_,catalogue_,copytrap_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,barcode_,catalogue_,copytrap_";
     	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#copytrap_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4941.xml");

}
function m4942(){
	menu.hide();
   	var SQL = "select id_,trap_ from traps order by trap_ asc"; 
    var SQLCOLS = "id_,trap_";
 	GridDiv("Trap Messages");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextr.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Alert"); 
	mygrid.setColTypes("ro,ro");
	mygrid.setInitWidths("70,650"); 
	mygrid.setColAlign("left,left"); 
	mygrid.setColSorting("connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'traps');
	AddNewButton(mygrid,'Trap message',"m4942.xml",SQLCOLS,"trap_",600,300,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
       	var SQL = "select id_,trap_ from traps order by trap_ asc"; 
        var SQLCOLS = "id_,trap_";
    	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4942cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 300);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,trap_ from traps order by trap_ asc"; 
    	var SQLCOLS = "id_,trap_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,trap_";
    	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#trap_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4942.xml");

}

function m4943(){
	menu.hide();
	var SQL = "select id_,barcode_,trap_ from members where trap_ <> ''"; 
	var SQLCOLS = "id_,barcode_,trap_";
  	GridDiv("Trapped borrowers");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4943.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Barcode,Trap"); 
	mygrid.setColTypes("ro,ro,ro");
	mygrid.setInitWidths("70,70,200"); 
	mygrid.setColAlign("left,left,left"); 
	mygrid.setColSorting("connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'traps');
	addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQL = "select id_,barcode_,trap_ from members where trap_ <> ''"; 
    	var SQLCOLS = "id_,barcode_,trap_";
       	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4943cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 300);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,barcode_,trap_ from members where trap_ <> ''"; 
    	var SQLCOLS = "id_,barcode_,trap_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,barcode_,trap_";
       	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#trap_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4943.xml");

}

function m4951(){
	menu.hide();
	var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from item_category order by category_"; 
	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
  	GridDiv("Stock privileges");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4951.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Category,Loans,Renews,Reserves,Ceiling,Trap,Expires,Period,Return"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,70,70,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'category');
	AddNewButton(mygrid,'Stock privileges',"m4951.xml",SQLCOLS,"category_",600,450,SQL);
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from item_category order by category_"; 
		var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
      	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4951cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 450);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from item_category order by category_"; 
    	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
       	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#category_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4951.xml");

}
function m4952(){
	menu.hide();
	var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from borrower_category order by category_"; 
	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
  	GridDiv("Stock privileges");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4952.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Category,Loans,Renews,Reserves,Ceiling,Trap,Expires,Period,Return"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,70,70,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'category');
	AddNewButton(mygrid,'Borrower privileges',"m4952.xml",SQLCOLS,"category_",600,450,SQL);
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from borrower_category order by category_"; 
		var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
      	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4952cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 450);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,category_,loans_,renews_,reserves_,ceiling_,trap_,DATE_FORMAT(expires_,'%d/%m/%Y') as expires_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_ from borrower_category order by category_"; 
    	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,category_,loans_,renews_,reserves_,ceiling_,trap_,expires_,period_,return_";
       	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#category_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4952.xml");

}
function m4953(){
	menu.hide();
	var SQL = "select id_,description_,borrower_,item_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_,loans_,renews_,reserves_ from lending_categories order by id_ asc";
	var SQLCOLS = "id_,description_,borrower_,item_,period_,return_,loans_,renews_,reserves_";
  	GridDiv("Matrix privileges");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4953.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Description,Borrower,Item,Period,Return,Loans,Renews,Reserves"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,70,70,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(addressmenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'category');
	AddNewButton(mygrid,'Matrix privileges',"m4953.xml",SQLCOLS,"description_",600,450,SQL);
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var SQL = "select id_,description_,borrower_,item_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_,loans_,renews_,reserves_ from lending_categories order by id_ asc";
		var SQLCOLS = "id_,description_,borrower_,item_,period_,return_,loans_,renews_,reserves_";
      	var data = global_mygrid.contextID.split("_");
    	var line ='';
        var a = new Array();
        a = SQLCOLS.split(',');
        ClearRecord();
        for(var i=0;i<a.length;i++){
        	var myField = global_mygrid.cellById(data[0], i).getValue();
        	line += myField + ",";
        }
        eval(menuitemId);
    	return true;
     });
}
function m4953cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 450);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,description_,borrower_,item_,period_,DATE_FORMAT(return_,'%d/%m/%Y') as return_,loans_,renews_,reserves_ from lending_categories order by id_ asc";
    	var SQLCOLS = "id_,description_,borrower_,item_,period_,return_,loans_,renews_,reserves_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Records");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
    	var SQLCOLS = "id_,description_,borrower_,item_,period_,return_,loans_,renews_,reserves_";
       	showLoading(false);
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#description_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m4953.xml");
}

function m4960(){
	menu.hide();
	GridDiv("Bad catalogue data ");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4960.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Title,Subjects,Series,Synopsis,Keywords"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,250,150,70,70,150"); 
	mygrid.setColAlign("left,left,left,left,left,left"); 
	mygrid.setColSorting("str,str,str,str,str,str");
 	mygrid.enableContextMenu(addressmenu);
 	mygrid.setSkin("light"); 
 	mygrid.enableSmartRendering(true, 50);
	mygrid.init();
	global_mygrid = mygrid;
	mygrid.enableColumnAutoSize(true);
	mygrid.enablePaging(true,50,10,"pagingarea",true);
	mygrid.setPagingSkin("bricks");
	mygrid.loadXML("baddata.php");
	AddPrintButton(mygrid);
	AddExportButton('','','baddata');
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var line ='';
        var myField = global_mygrid.cellById(data[0], i).getValue();
        line += myField + ",";
        eval(menuitemId);
    	return true;
     });
}
function m4960cm1(line){
}

function m4961(){
	menu.hide();
	GridDiv("Empty Fields");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4961.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("Id,Title,Author,Class"); 
	mygrid.setColTypes("ro,ro,ro,ro");
	mygrid.setInitWidths("70,350,150,150"); 
	mygrid.setColAlign("left,left,left,left"); 
	mygrid.setColSorting("str,str,str,str");
 	mygrid.enableContextMenu(addressmenu);
 	mygrid.setSkin("light"); 
 	mygrid.enableSmartRendering(true, 50);
	mygrid.init();
	global_mygrid = mygrid;
	mygrid.enableColumnAutoSize(true);
	mygrid.enablePaging(true,50,10,"pagingarea",true);
	mygrid.setPagingSkin("bricks");
	mygrid.loadXML("empty.php");
	AddPrintButton(mygrid);
	AddExportButton('','','empty');
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var line ='';
        var myField = global_mygrid.cellById(data[0], i).getValue();
        line += myField + ",";
        eval(menuitemId);
    	return true;
     });
}
function m4961cm1(line){
}

function m4962(){
	menu.hide();
	GridDiv("Spelling errors");
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML("_contextm4961.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
 	mygrid.setHeader("Id,Title,Subjects,Series,Synopsis,Keywords"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("70,200,150,150,150,150"); 
	mygrid.setColAlign("left,left,left,left,left.left");
	mygrid.setColSorting("str,str,str,str,str,str");
 	mygrid.enableContextMenu(addressmenu);
 	mygrid.setSkin("light"); 
 	mygrid.enableSmartRendering(true, 50);
	mygrid.init();
	global_mygrid = mygrid;
	mygrid.enableColumnAutoSize(true);
	mygrid.enablePaging(true,50,10,"pagingarea",true);
	mygrid.setPagingSkin("bricks");
	mygrid.loadXML("spelling.php");
	AddPrintButton(mygrid);
	AddExportButton('','','spelling');
	addressmenu.attachEvent("onClick", function(menuitemId, type){
		var line ='';
        var myField = global_mygrid.cellById(data[0], i).getValue();
        line += myField + ",";
        eval(menuitemId);
    	return true;
     });
}
function m4962cm1(line){
}


function showLoading(fl) {
	if(fl == true){
		$("#tab").html('<img src="/images/wait.gif" />');
     	$("#tab").show("fast");
    }
	else{
		$("#tab").html('');
   	   	$("#tab").hide("slow");
	}
}