function m1101(){
	menu.hide();
	var SQL = "select '1',id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_ from catalogue"; 
	var SQLCOLS = "id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_";
	var COPYCOLS = "id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
	GridDiv("Catalogue");
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm1101.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,Isbn,Title,Authors,Edition_,Publisher,Year,Country,Media,Web"); 
	mygrid.setColTypes("sub_row_grid,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("30,70,70,200,90,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(cataloguemenu);
	SQLCOLS = "1," + SQLCOLS;
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'catalogue');
	AddNewButton(mygrid,"catalogue","m1102.xml",SQLCOLS,"isbn_",'700','600',SQL);
	AddHelpButton("catalogue:bibliography","Catalogue - context: catalogue:bibliography");

	//add the copy sub grid
	mygrid.attachEvent("onSubGridCreated",function(subgrid,row_id,ind,value){
		var	copymenu = new dhtmlXMenuObject();
		copymenu.setImagePath("codebase/imgs/");
		copymenu.setIconsPath("imgs/");
		copymenu.renderAsContextMenu();
		copymenu.loadXML("_contextm1101c.xml");
		subgrid.setHeader("Id,Catalogue,Barcode,Category,Location,Site,Shelf,Status,Price"); 
		subgrid.setColAlign("left,left,left,left,left,left,left,left,left"); 
        subgrid.setInitWidths("80,80,80,80,80,80,80,80,80"); 
        subgrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro"); 
        subgrid.setSkin("blue"); 
        subgrid.init(); 
        subgrid.enableContextMenu(copymenu);
    	global_mysubgrid = subgrid;
        var myId = mygrid.cellById(row_id, 1).getValue();
        GetCopyLines(myId,subgrid);
        copymenu.attachEvent("onClick", function(menuitemId, type){
    		var SQLCOLS = "id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
    		var data = global_mysubgrid.contextID.split("_");
    	    var line ='';
            var a = new Array();
        	a = SQLCOLS.split(',');
        	ClearRecord();
        	for(var i=0;i<a.length;i++){
        		var myField = global_mysubgrid.cellById(data[0], i).getValue();
        		line += myField + ",";
        	}
            eval(menuitemId);
    	    return true;
      	});
     });

	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
	    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 GetCopyLines(id,subgrid){		//order id
    var SQL = "select id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_ from copies where catalogue_ = '" + id + "'";
	var SQLCOLS = "id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_"; 
	var result = new Array();
	AjaxSql("tab",SQL,SQLCOLS,result);
	var cnt = result[0];
	var v = SQLCOLS.split(',');
	var SIZE = v.length;
	if(cnt > 0){
		for(var j=0;j<cnt;j++){
			var pos = (j*SIZE)+1;
			var dlist = '';
			for(i=0;i<SIZE;i++){
				var x = result[pos+i];
				if( x == "0000-00-00")
					x = GetDate();
				dlist += x + ',';
			}
			subgrid.addRow(j,dlist);
			subgrid.setRowTextStyle(j, "color: green; ");
		}	
	}
}


function m1101cm1(line){
	currentline_ = 1;
	InitOrderLines();
	order_lines[0] = 0;
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 700, 450);
    dhxWins.attachEvent("onClose", function(win){
       	var SQL = "select '1',id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_ from catalogue order by id_ asc"; 
    	var SQLCOLS = "1,id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_";
    	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
    	showLoading(false);
        SetMouseKeys();
    	SetValidator();
    	GoClearAll("isbn_");
    	MakeDisableOnNew();
    	ClearRecord();
    	$("#catalogue_").val(line.split(',')[1]);
    	GoToField("#barcode_");
    });
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1103.xml");
} 

function m1101cm2(line){
	var SQL = "select '1',id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_ from catalogue order by id_ asc"; 
	var SQLCOLS = "id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_";
	var dhxWins, w1, tabbar;
		dhxWins = new dhtmlXWindows();
		dhxWins.enableAutoViewport(true);
		dhxWins.setImagePath("imgs/");
		w1 = dhxWins.createWindow("w1", 20, 30, 650, 450);
		w1.setText("Amend Catalogue Record");
		w1.denyMove();
		w1.denyResize();
		w1.clearIcon();
		w1.denyPark();
		dhxWins.attachEvent("onClose", function(win){
			var SQL = "select '1',id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_ from catalogue order by id_ asc"; 
			var SQLCOLS = "1,id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_";
			global_mygrid.clearAll();
			global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
			return 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);
	         var a = new Array();
	     	a = SQLCOLS.split(',');
	     	ClearRecord();
	     	for(var i=0;i<a.length;i++){
	     		var myField = line.split(',')[i+1];
	     		$("#" + a[i]).val(myField);
	     	}
	     	SetMouseKeys();
	     	SetValidator();
	     	MakeDisable();
	     	GoToField("#isbn_");
	 	});
	    tabbar.attachEvent("onXLS", function() {
	         showLoading(true);
	     });
} 

function m1101cm3(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 '1',id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_ from catalogue order by id_ asc"; 
    	var SQLCOLS = "1,id_,isbn_,title_,authors_,edition_,publisher_,pubyear_,pubcountry_,media_,web_";
    	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_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
  	    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("m1103.xml");

} 


function m1103(){	
	menu.hide();
	var SQL = "select '1',id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_  from copies"; 
	var SQLCOLS = "id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
	GridDiv("Copies");
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm1103.xml");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });
	mygrid.setHeader("&nbsp;,Id,Catalogue,Barcode,Category,Location,Site,Shelf,Status,Price"); 
	mygrid.setColTypes("sub_row_grid,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("30,70,70,70,70,70,70,70,70,100"); 
	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(cataloguemenu);
	global_mygrid = mygrid;
	SQLCOLS = "1," + SQLCOLS;
	GridInit(mygrid,SQL,SQLCOLS);
	AddGroupButton(mygrid,2);
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,"copies");
	AddNewButton(mygrid,"copies","m1103.xml",SQLCOLS,"catalogue_",'500','420',SQL);
	AddHelpButton("catalogue:copies","Catalogue - context: catalogue:copies");

	//add the sub grid
	mygrid.attachEvent("onSubGridCreated",function(subgrid,row_id,ind,value){
		subgrid.setHeader("Id,Isbn,Title,Author,Publisher,Media"); 
		subgrid.setColAlign("left,left,left,left,left,left"); 
        subgrid.setInitWidths("80,80,200,100,100,80"); 
        subgrid.setColTypes("ro,ro,ro,ro,ro,ro"); 
        subgrid.setSkin("blue"); 
        subgrid.init();
       	global_mysubgrid = subgrid;
        var myId = mygrid.cellById(row_id, 2).getValue();
        GetCatalogueLines(myId,subgrid);
        return false; //block default logic });
	});

	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
		var SQLCOLS = "id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
		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+1).getValue();
    		line += myField + ",";
    	}
        eval(menuitemId);
	    return true;
  	});
}

function m1103cm1(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 '1',id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_  from copies order by id_ asc"; 
    	var SQLCOLS = "1,id_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
    	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_,catalogue_,barcode_,category_,location_,site_,shelf_,status_,price_";
  	    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("#barcode_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1103.xml");

} 




function GetCatalogueLines(id,subgrid){		//catalogue id
	var SQL = "select id_,isbn_,title_,authors_,publisher_,media_ from catalogue where id_ = " + id;
	var SQLCOLS = "id_,isbn_,title_,authors_,publisher_,media_";  
	var result = new Array();
	AjaxSql("tab",SQL,SQLCOLS,result);
	var cnt = result[0];
	var v = SQLCOLS.split(',');
	var SIZE = v.length;
	if(cnt > 0){
		for(var j=0;j<cnt;j++){
			var pos = (j*SIZE)+1;
			var dlist = '';
			for(i=0;i<SIZE;i++){
				var x = result[pos+i];
				if( x == "0000-00-00")
					x = GetDate();
				dlist += x + ',';
			}
			subgrid.addRow(j,dlist);
			subgrid.setRowTextStyle(j, "color: green; ");
		}	
	}
}


function NextBarcode(){
	var myValue = $("#barcode_").val();
	if(myValue != ''){
		var copyfrom = $("#copyfrom").val(); 
		result = Populate("gophptable.php",copyfrom,"barcode_",myValue);
	}
	else{
       	$.ajax({
       	   	method: "get",url: "nextbarcode.php",
       	   	async: false,
       	   	beforeSend: function(){
       			$('#load_barcode_').html('<img src="/images/wait.gif" />');
       	      	$("#load_barcode_").show("fast");
       	   	},
       	    complete: function(){ 
       			$('#load_barcode_').html('');
       	   		$("#load_barcode_").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){
	        	   	var myData = $(this).find("barcode").text();
	        		$("#barcode_").val(myData);
	        	});
       	   	},
       	   	error: function(){
       	   		alert('here');
       	   	}
        });
   	}
}
function GoCopyBarcode(){
	var myValue = $("#copy_").val();
	if(myValue != ''){
		var copyfrom = $("#copyfrom").val(); 
		Populate("gophptable.php",copyfrom,"barcode_",myValue);
		setTimeout( function() { 
			$("#category_").focus(); 
		} , 500);
		$("#barcode_").val(myValue);
	}
}
function GoCatalogueAuthority(fieldname,header,phpfile,seed,popit,multi,finder,func){
	var copyfrom='';
	$("#catalogued_").val('');
	var ihtml=	"<div>Please choose the correct term</div>" +
	"	<div id=\"combo\" style=\"width:200px; height:15px;\"></div>";
	var myValue = $(popit).val();
	if(myValue == '')
		myValue = seed;
		Tip(
		ihtml,CLICKSTICKY, true, CLICKCLOSE, false, 
		CLOSEBTN, true,	
		TITLE, header + ' Authority', PADDING, 9,FIX, [570, 300],
		WIDTH,400,FONTFACE, 'Arial, Helvetica, sans-serif', FONTSIZE, '10pt',TITLEALIGN, 'center');
		var z = new dhtmlXCombo("combo", "alfa", 400);
		z.enableFilteringMode(true, phpfile, true, true);
		z.setComboText(myValue);
		z.setOptionHeight(300);
		if(finder != '')		//see if there is a valid entry already in the box
			copyfrom = $("#copyfrom").val();
		z.attachEvent("onChange", function(value,state){func(z);});
}

function CataloguePop(z){
	var x = z.getComboText().split('---');
	$("#id_").val(x[1]);
	UnTip();
	var copyfrom = $("#copyfrom").val(); 
	Populate("gophptable.php",copyfrom,"id_",$("#id_").val());
	var myDate = $("#catalogued_").val();
	if(myDate == '')
		$("#catalogued_").val(GetDate());
	setTimeout( function() { 
		$("#isbn_").focus(); 
	} , 500);
}
function AttachPop(z){
	var x = z.getComboText().split('---');
	$("#id_").val(x[1]);
	UnTip();
	var copyfrom = $("#copyfrom").val(); 
	Populate("gophptable.php",copyfrom,"id_",$("#id_").val());
	$("#catalogue_").val(x[1]);
	setTimeout( function() { 
		$("#barcode_").focus(); 
	} , 500);
}
function GoCatalogue(){
	$("#catalogued_").val('');
	var myValue = $("#id_").val();
	if(myValue != ''){
		var copyfrom = $("#copyfrom").val(); 
		Populate("gophptable.php",copyfrom,"id_",myValue);
		var myDate = $("#catalogued_").val();
		if(myDate == '')
			$("#catalogued_").val(GetDate());
		setTimeout( function() { 
			$("#isbn_").focus(); 
		} , 500);
	}
}

function GoAttachCatalogue(){
	var myValue = $("#id_").val();
	if(myValue != ''){
		var copyfrom = $("#copyfrom").val(); 
		Populate("gophptable.php",copyfrom,"id_",myValue);
		$("#catalogue_").val(myValue);
		$("#barcode_").val(''); 
		setTimeout( function() { 
			$("#barcode_").focus(); 
		} , 500);
	}
}