function Authority(header,table,fields,columns,context,form,gotofield,w,h){
	menu.hide();
	var SQL = "select " + fields +  " from " + table;
	//	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_";
	var SQLCOLS = fields;
	GridDiv(header);
	var	addressmenu = new dhtmlXMenuObject();
	addressmenu.setImagePath("codebase/imgs/");
	addressmenu.setIconsPath("imgs/");
	addressmenu.renderAsContextMenu();
	addressmenu.loadXML(context);
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
 	mygrid.setHeader(columns); 
 	var x = columns.split(',');
 	var str = '';
 	var str1 = '';
 	var str2 = '';
 	var str3 = '';
 	for(var i=0;i<x.length;i++){
 		str += 'ro';
 		str += ',';
 		str1 += '80';
 		str1 += ',';
 		str2 += 'left';
 		str2 += ',';
 		str3 += 'connector';
 		str3 += ',';
 	}
 	str += ',';
 	str = str.replace(",,",'');
 	str1 += ',';
 	str1 = str1.replace(",,",'');
 	str2 += ',';
 	str2 = str2.replace(",,",'');
 	str3 += ',';
 	str3 = str3.replace(",,",'');
	mygrid.setColTypes(str);
	mygrid.setInitWidths(str1); 
	mygrid.setColAlign(str2);
	mygrid.setColSorting(str3);
	//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,table);
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,table,form,SQLCOLS,gotofield,w,h,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 AuthorityUpdate(line,table,fields,form,gotofield,w,h){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, w, h);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select " + fields +  " from " + table;
    	var SQLCOLS = fields;
//    	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 Record");
	global_window = w1;
	w1.setModal(true);
    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_";
    	var SQLCOLS = fields;
    	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("#" + gotofield);
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML(form);

}

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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,'library',"m41.xml",SQLCOLS,"site_",600,630,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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
function m41cm1(line){
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 630);
    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 Record");
	global_window = w1;
	w1.setModal(true);
    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();
	//main form
		var h = new Array();
		var f = new Array();
		var l = new Array();
		var a = new Array();
		var SQL;
		var SQLCOLS;
		GridDiv("Theaurus");
		GridStyle('800px','260px');
		var mygrid;
		mygrid = new dhtmlXGridObject('gridholder');
		mygrid.attachEvent("onXLE", function() {
			showLoading(false);
		});
	    mygrid.attachEvent("onXLS", function() {
	        showLoading(true);
	    });  
	    ParseForm("m49.xml",h,f,l,a);
	    GridShow(mygrid,h,f,l,a,999,false); 
	    SQL = "select " + f + " from thesaurus";
	    SQLCOLS = f;
		GridInit(mygrid,SQL, SQLCOLS);

		AddExportButton(SQL,SQLCOLS,"thesaurus");
		global_mygrid = mygrid;
	   	mygrid.enableColumnAutoSize(false);
		AddPrintButton(mygrid);
		if(CheckMyPriv('manage:x.c.x.x') == true)
			AddNewButton(mygrid,'thesaurus',"m49.xml",SQLCOLS,"subjectcategory",800,600,SQL);
		var	cataloguemenu = new dhtmlXMenuObject();
		cataloguemenu.setImagePath("codebase/imgs/");
		cataloguemenu.setIconsPath("imgs/");
		cataloguemenu.renderAsContextMenu();
		cataloguemenu.loadXML("_context49.xml");
		mygrid.enableContextMenu(cataloguemenu);

		cataloguemenu.attachEvent("onClick", function(menuitemId, type){
		    var data = global_mygrid.contextID.split("_");
		    var line ='';
		    var cols = f;
	    	ClearRecord();
	    	for(var i=0;i<f.length;i++){//i=1 if subrow
	    		var myField = global_mygrid.cellById(data[0], i).getValue();
	    		line += myField + "|";
	    	}
	        eval(menuitemId);
		    return true;
	  	});

    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
function m49cm1(line,cols){

	if(CheckMyPriv('manage:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}

	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 800, 600); //width height
		global_window = w1;
		w1.setText("Amend Theaurus Record:m49.xml");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		dhxWins.attachEvent("onClose", function(win){
			var SQL = "select " + cols + " from thesaurus"; 
			var SQLCOLS =  cols;
			global_mygrid.clearAll();
			if(global_thisId != ''){
	    		var ESQL = SQL + " where id_ = " + 	global_thisId; 
	    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
	    	}
	    	else{
	    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
	    	}
			return true; 
		 });
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m49.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split('|')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =  $("#id_").val();
	     	GoToField("#subjectcategory");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });

}
function m42(){
	menu.hide();
	var SQL = "select id_,name_,login_,password_,privileges_,site_,location_,telephone_,email_ from users";
	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,location_,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,Location,Telephone,Email"); 
	mygrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("80,80,80,80,80,80,80,80,80"); 
	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,'users');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,'Users',"m42.xml",SQLCOLS,"name_",600,400,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
    	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,location_,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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
function m42cm1(line){
	if(CheckMyPriv('manage:x.x.u.x') == false){
		alert("Please login to perform this operation");
		return true;
	}
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 500);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select id_,name_,login_,password_,privileges_,site_,location_,telephone_,email_ from users";
    	var SQLCOLS = "id_,name_,login_,password_,privileges_,site_,location_,telephone_,email_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Amend Record");
	global_window = w1;
	w1.setModal(true);
    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_,location_,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";
	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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
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";
   	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 Record");
	global_window = w1;
	w1.setModal(true);
    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";
	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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
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";
   	var SQLCOLS = "id_,context_,helptext_";
  	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Record");
	global_window = w1;
	w1.setModal(true);
    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";
	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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
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";
    	var SQLCOLS = "id_,word_";
    	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Record");
	global_window = w1;
	w1.setModal(true);
    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";
    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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		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";
    	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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
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";
    	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 Record");
	global_window = w1;
	w1.setModal(true);
    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";
   	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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		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";
       	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;
     });
    $('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}
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";
       	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 Record");
	global_window = w1;
	w1.setModal(true);
    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 h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	var SQL;
	var SQLCOLS;
	GridDiv("Action Catalogue Deletions");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m1102.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    SQL = "select " + f + " from catalogue where action_ = 'DEL'";
    SQLCOLS = f;
	GridInit(mygrid,SQL,SQLCOLS);
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'catalogue_deletions');
	AddRemoveDeletionsButton(mygrid);
	$('#click_movie').bind('click', function() {
		 GoVideo("manage.mov");
		});
}

function GoDelete(mygrid){
	var msg = "Are you sure you want to remove these catalogue records. You should export or print first";
	var where = window.confirm(msg);
	if (!where){	
		alert("Records not removed");
		return false;
	}
	mygrid.forEachRow(function(id){
		var cellObj = mygrid.cellById(id, 0);
		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_,status_ from copies where catalogue_ = " + catalogue_;
		var SQLCOLS = "id_,status_";
		var cresult = new Array();
	  	AjaxSql("tab",SQL,SQLCOLS,cresult);		//results in result[i] etc
		if(cresult[0] == 0){  //no copies just delete the catalogue record
			var SQL = "delete from catalogue where id_ = " + catalogue_;
			var result = UpdateRecord(SQL,"tab");
			if(isNaN(result)){
				alert(result);
				mygrid.setRowTextStyle(id, "color: green; ");
			}
			else
				mygrid.setRowTextStyle(id, "color: red; ");
		}
		else{		//one copy or more delete the copies first then the catalogue record
//more than one copy just delete the copy
			var cnt = cresult[0];
			var v = SQLCOLS.split(',');
			var SIZE = v.length;
			var flag = false;
			for(var j=0;j<cnt;j++){
				pos = (j*SIZE)+1;
				var id_ = cresult[pos];
				var status_ = cresult[pos+1];
				if(status_ == 'LOA'){
					flag = true;
				}
				else{
					var SQL = "delete from copies where id_ = " + id_;
					var result = UpdateRecord(SQL,"tab");
					var result = 0;
					if(isNaN(result)){
						alert(result);
						flag = true;
					}
				}
			}
			if(flag == false){
				var SQL = "delete from catalogue where id_ = " + catalogue_;
				var result = UpdateRecord(SQL,"tab");
				var result = 0;
				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 Record");
	global_window = w1;
	w1.setModal(true);
    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"; 
    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');
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,'Trap message',"m4942.xml",SQLCOLS,"trap_",600,300,SQL);
    addressmenu.attachEvent("onClick", function(menuitemId, type){
       	var SQL = "select id_,trap_ from traps"; 
        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"; 
    	var SQLCOLS = "id_,trap_";
       	global_mygrid.clearAll();
    	global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	return true; 
    });
    w1.setText("Enter Record");
	global_window = w1;
	w1.setModal(true);
    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 Record");
	global_window = w1;
	w1.setModal(true);
    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();
//main form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	var SQL;
	var SQLCOLS;
	GridDiv("Stock categories");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m4951.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    SQL = "select " + f + " from item_category";
    SQLCOLS = f;
	GridInit(mygrid,SQL, SQLCOLS);

	AddExportButton(SQL,SQLCOLS,"item_cagtegory");
	global_mygrid = mygrid;
   	mygrid.enableColumnAutoSize(false);
	AddPrintButton(mygrid);
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,"item_category","m4951.xml",SQLCOLS,"category_",'700','550',SQL);
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm4951.xml");
	mygrid.enableContextMenu(cataloguemenu);

	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
	    var data = global_mygrid.contextID.split("_");
	    var line ='';
	    var cols = f;
    	ClearRecord();
    	for(var i=0;i<f.length;i++){//i=1 if subrow
    		var myField = global_mygrid.cellById(data[0], i).getValue();
    		line += myField + ",";
    	}
        eval(menuitemId);
	    return true;
  	});
}
function m4951cm1(line,cols){
	if(CheckMyPriv('manage:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}
	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 700, 550); //width height
		global_window = w1;
		w1.setText("Amend Category Record:m4951.xml");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		dhxWins.attachEvent("onClose", function(win){
			var SQL = "select " + cols + " from item_category"; 
			var SQLCOLS =  cols;
			global_mygrid.clearAll();
			if(global_thisId != ''){
	    		var ESQL = SQL + " where id_ = " + 	global_thisId; 
	    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
	    	}
	    	else{
	    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
	    	}
			return true; 
		 });
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m4951.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =  $("#id_").val();
	     	GoToField("#category_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });
} 

function m4952(){
	menu.hide();
//main form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	var SQL;
	var SQLCOLS;
	GridDiv("Borrower categories");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m4952.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    SQL = "select " + f + " from borrower_category";
    SQLCOLS = f;
	GridInit(mygrid,SQL, SQLCOLS);

	AddExportButton(SQL,SQLCOLS,"borrower_cagtegory");
	global_mygrid = mygrid;
   	mygrid.enableColumnAutoSize(false);
	AddPrintButton(mygrid);
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,"borrower_category","m4952.xml",SQLCOLS,"category_",'700','550',SQL);
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm4952.xml");
	mygrid.enableContextMenu(cataloguemenu);

	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
	    var data = global_mygrid.contextID.split("_");
	    var line ='';
	    var cols = f;
    	ClearRecord();
    	for(var i=0;i<f.length;i++){//i=1 if subrow
    		var myField = global_mygrid.cellById(data[0], i).getValue();
    		line += myField + ",";
    	}
        eval(menuitemId);
	    return true;
  	});
}
function m4952cm1(line,cols){
	if(CheckMyPriv('manage:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}
	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 700, 650); //width height
		global_window = w1;
		w1.setText("Amend Category Record:m4952.xml");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		dhxWins.attachEvent("onClose", function(win){
			var SQL = "select " + cols + " from borrower_category"; 
			var SQLCOLS =  cols;
			global_mygrid.clearAll();
			if(global_thisId != ''){
	    		var ESQL = SQL + " where id_ = " + 	global_thisId; 
	    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
	    	}
	    	else{
	    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
	    	}
			return true; 
		 });
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m4952.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =  $("#id_").val();
	     	GoToField("#category_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });
} 

function m4953(){
	menu.hide();
//main form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	var SQL;
	var SQLCOLS;
	GridDiv("Matrix categories");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m4953.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    SQL = "select " + f + " from lending_categories";
    SQLCOLS = f;
	GridInit(mygrid,SQL, SQLCOLS);

	AddExportButton(SQL,SQLCOLS,"lending_categories");
	global_mygrid = mygrid;
   	mygrid.enableColumnAutoSize(false);
	AddPrintButton(mygrid);
	if(CheckMyPriv('manage:x.c.x.x') == true)
		AddNewButton(mygrid,"lending_categories","m4953.xml",SQLCOLS,"category_",'700','550',SQL);
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm4953.xml");
	mygrid.enableContextMenu(cataloguemenu);

	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
	    var data = global_mygrid.contextID.split("_");
	    var line ='';
	    var cols = f;
    	ClearRecord();
    	for(var i=0;i<f.length;i++){//i=1 if subrow
    		var myField = global_mygrid.cellById(data[0], i).getValue();
    		line += myField + ",";
    	}
        eval(menuitemId);
	    return true;
  	});
}
function m4953cm1(line,cols){
	if(CheckMyPriv('manage:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}
	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 700, 550); //width height
		global_window = w1;
		w1.setText("Amend Category Record:m4953.xml");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		dhxWins.attachEvent("onClose", function(win){
			var SQL = "select " + cols + " from lending_categories"; 
			var SQLCOLS =  cols;
			global_mygrid.clearAll();
			if(global_thisId != ''){
	    		var ESQL = SQL + " where id_ = " + 	global_thisId; 
	    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
	    	}
	    	else{
	    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
	    	}
			return true; 
		 });
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m4953.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =  $("#id_").val();
	     	GoToField("#category_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });
} 

function m4960(){
	menu.hide();
	//catalogue form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	ParseForm("m1102.xml",h,f,l,a);

	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 data = global_mygrid.contextID.split("_");
		var myId = global_mygrid.cellById(data[0], 0).getValue();
		var SQLCOLS =f.toString();
		var cols = f;
		var SQL = "select " + SQLCOLS + " from catalogue where id_ =" + myId ;
		var result = new Array();
		AjaxSql("tab",SQL,SQLCOLS,result);
		var cnt = result[0];
		var line ='';
		if(cnt > 0){
	    	for(var i=1;i<=f.length;i++){
	    		line += result[i];
	    		line += ",";
	    	}
		}
        eval(menuitemId);
    	return true;
     });
}
function m4960cm1(line,cols){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}

	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 750, 500);
		global_window = w1;
		w1.setText("Amend Catalogue Record: m1101cm2");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m1102.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =     	$("#id_").val();
	     	GoToField("#isbn_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });
}

function m4961(){
	menu.hide();
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	ParseForm("m1102.xml",h,f,l,a);
	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 data = global_mygrid.contextID.split("_");
		var myId = global_mygrid.cellById(data[0], 0).getValue();
		var SQLCOLS =f.toString();
		var cols = f;
		var SQL = "select " + SQLCOLS + " from catalogue where id_ =" + myId ;
		var result = new Array();
		AjaxSql("tab",SQL,SQLCOLS,result);
		var cnt = result[0];
		var line ='';
		if(cnt > 0){
	    	for(var i=1;i<=f.length;i++){
	    		line += result[i];
	    		line += ",";
	    	}
		}
        eval(menuitemId);
    	return true;
     });
}
function m4961cm1(line,cols){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}

	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 750, 500);
		global_window = w1;
		w1.setText("Amend Catalogue Record: m1101cm2");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m1102.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =     	$("#id_").val();
	     	GoToField("#isbn_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });

}

function m4962(){
	menu.hide();
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
	ParseForm("m1102.xml",h,f,l,a);
	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 data = global_mygrid.contextID.split("_");
		var myId = global_mygrid.cellById(data[0], 0).getValue();
		var SQLCOLS =f.toString();
		var cols = f;
		var SQL = "select " + SQLCOLS + " from catalogue where id_ =" + myId ;
		var result = new Array();
		AjaxSql("tab",SQL,SQLCOLS,result);
		var cnt = result[0];
		var line ='';
		if(cnt > 0){
	    	for(var i=1;i<=f.length;i++){
	    		line += result[i];
	    		line += ",";
	    	}
		}
        eval(menuitemId);
    	return true;
     });

}
function m4962cm1(line,cols){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return true;
	}

	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 750, 500);
		global_window = w1;
		w1.setText("Amend Catalogue Record: m1101cm2");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		w1.setModal(true);
		tabbar = w1.attachTabbar("top");
		tabbar.setSkin("dhx_skyblue");
		tabbar.setImagePath("imgs/");
	    tabbar.loadXML("m1102.xml");
	    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
	        showLoading(false);
	    	ClearRecord();
	     	for(var i=0;i<cols.length;i++){
	     		var myField = line.split(',')[i];
	     		$("#" + cols[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	MakeDates();
	    	global_thisId =     	$("#id_").val();
	     	GoToField("#isbn_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });

}


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

function UpdateFines(){
	var myData;
	
		$.ajax({
			type: "post",url: "updatefinesweb.php",
		    async: false,
			beforeSend: function(){
				$("#tab").html('<img src="images/wait.gif" />');
				$("#tab").show("fast");
			},
			complete: function(){ 
				$("#tab").html('');
				$("#tab").hide("slow");
			},
			success: function(data){
				var xml;
				if($.browser.msie){
					if (typeof data == "string") {
						xml = new ActiveXObject("Microsoft.XMLDOM");
						xml.async = false;
						xml.loadXML(data);
					} 
					else
						xml = data;	
				}
				else 
					xml = data;
				$(xml).find('record').each(function(x){
					myData = $(this).find("pkey").text();
				});
			},
			error: function(){
				alert("There has been an error");
				myData = "error";
			}
		});
		if(isNaN(myData))
			alert(myData);
		else
			alert("Done");

}