var global_barcodeTaken = false;
var global_thisJournalId = '';
var global_thisRouteId = '';
var global_myreceiptsubgrid;
var global_myroutesubgrid;
function m1121(){	
	if(CheckFeature('journals') == false){
		alert("This feature is not part of FREE Cyberlibrary. Please email for prices");
		return;
	}
	menu.hide();
//main form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
//receipt form
	var h1 = new Array();
	var f1 = new Array();
	var l1 = new Array();
	var a1 = new Array();
	ParseForm("m1121.xml",h,f,l,a);
	 ParseForm("m1122.xml",h1,f1,l1,a1);
	var SQL = "select '1',id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_ from catalogue where media_ = 'Journal'"; 
	var SQLCOLS = "id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_";
	GridDiv("Journals");
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm1121.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,Issn,Title,Class,Publisher,Media,Holding,Date,Subprice,Startsub,Renew,Supplier,Web,Email"); 
	mygrid.setColTypes("sub_row_grid,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
	mygrid.setInitWidths("30,70,70,200,70,100,70,70,70,70,70,70,70,70,70"); 
	mygrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left,left,left,left"); 
	mygrid.setColSorting("na,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector,connector");
	mygrid.enableContextMenu(cataloguemenu);
	SQLCOLS = "1," + SQLCOLS;
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	var col1 = "<div style='padding-right:3px'><a href='javascript:doJournalFilter();'><img src='images/go.gif' title='Apply filter' border='0'/></a></div>";
	var col2 = "<div id='id_flt' style='padding-right:3px' onClick='(arguments[0]||window.event).cancelBubble=true;'><input type='text' id='search_id' style='width: 100%; border:1px solid gray;'/></div>";
	var col3 = "<div id='issn_flt' style='padding-right:3px' onClick='(arguments[0]||window.event).cancelBubble=true;' ><input type='text' id='search_issn' style='width: 100%; border:1px solid gray;'/></div>";
	var col4 = "<div id='title_flt' style='padding-right:3px' onClick='(arguments[0]||window.event).cancelBubble=true;' ><input type='text' id='search_title' style='width: 100%; border:1px solid gray;'/></div>";
	 
	mygrid.enableColumnAutoSize(false);
    mygrid.attachHeader(col1 + "," + col2 + "," + col3 + "," + col4);

	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,"journals");
	if(CheckMyPriv('journals:x.c.x.x') == true)
		AddNewButton(mygrid,"catalogue","m1121.xml",SQLCOLS,"issn_",'700','650',SQL);
//add the receipt grid
	mygrid.attachEvent("onSubGridCreated",function(subgrid,row_id,ind){
		subgrid.setHeader("Id,Catalogue Id,Barcode,Year,Volume,Issue,Location,Site,Shelf,Status,Date,Missing"); 
		subgrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left"); 
        subgrid.setInitWidths("60,60,70,60,60,60,60,60,60,60,60,60"); 
        subgrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro"); 
        subgrid.setSkin("blue"); 
        subgrid.enableColumnAutoSize(false);
    	 
        subgrid.init();
        var	receiptmenu = new dhtmlXMenuObject();
        receiptmenu.setImagePath("codebase/imgs/");
        receiptmenu.setIconsPath("imgs/");
        receiptmenu.renderAsContextMenu();
        receiptmenu.loadXML("_contextm1122.xml");
        subgrid.enableContextMenu(receiptmenu);
    	global_myreceiptsubgrid = subgrid;
        var myId = mygrid.cellById(row_id, 1).getValue();
        JournalSubGrid(myId,subgrid);
        receiptmenu.attachEvent("onClick", function(menuitemId, type){
        
        	var data = global_myreceiptsubgrid.contextID.split("_");

    	    var line ='';
    	    var ccols = f1;
    	    var cols = f;
        	ClearRecord();
        	for(var i=0;i<f1.length;i++){
        		var myField = global_myreceiptsubgrid.cellById(data[0], i).getValue();
 
        		line += myField + ",";
        	}
        
            eval(menuitemId);
    	    return true;
      	});
        return false; //block default logic });
	});
	cataloguemenu.attachEvent("onClick", function(menuitemId, type){
	    var data = global_mygrid.contextID.split("_");
	    var line ='';
        var a = new Array();
    	a = SQLCOLS.split(',');
    	ClearRecord();
    	var x = a.length;
    	for(var i=0;i<x-1;i++){
    		var myField = global_mygrid.cellById(data[0], i+1).getValue();
    		line += myField + ",";
    	}
        eval(menuitemId);
	    return true;
  	});
	$('#click_movie').bind('click', function() {
		 GoVideo("journals.mov");
		});
}

//receipt
function m1121cm1(line){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return;
	}
	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, 550);
    dhxWins.attachEvent("onClose", function(win){
       	var SQL = "select '1',id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_ from catalogue "; 
    	var SQLCOLS = "1,id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_";
 		global_mygrid.clearAll();
		if(global_thisJournalId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisJournalId;
    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
    	}
    	else{
    		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
    	showLoading(false);
        SetMouseKeys();
    	SetValidator();
    	GoClearAll("issn_");
    	MakeDisableOnNew();
    	ClearRecord();
    	$("#catalogue_").val(line.split(',')[0]);
    	global_thisJournalId =     	$("#catalogue_").val();
    	GoToField("#barcode_");
    });
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1122.xml");
} 
//amend journal record
function m1121cm2(line){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return;
	}
	var SQL = "seclect '1',id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_"; 
	var SQLCOLS = "id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_";
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 700, 600);
	global_window = w1;
	w1.setModal(true);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select '1',id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_ from catalogue  "; 
    	var SQLCOLS = "1,id_,issn_,title_,class_,publisher_,media_,holding_,catalogued_,subprice_,startsub_,renew_,supplier_,web_,email_";
 		global_mygrid.clearAll();
 		if(global_thisJournalId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisJournalId;
    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
    	}
    	else{
    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	}
		return true; 
    });
    w1.setText("Amend Record: m1121.xml");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    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];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	MakeDates();
    	GoToField("#issn_");
    	global_thisJournalId =     	$("#id_").val();
    	
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1121.xml");

} 


//amend receipt record
function m1122cm1(line,cols,ccols){
	if(CheckMyPriv('catalogue:x.c.x.x') == false){
		alert("Please login to perform this operation");
		return;
	}
var dhxWins, w1, tabbar;
	dhxWins = new dhtmlXWindows();
	dhxWins.enableAutoViewport(true);
	dhxWins.setImagePath("imgs/");
	w1 = dhxWins.createWindow("w1", 20, 30, 600, 600);
	global_window = w1;
	w1.setText("Amend Receipt Record: m1122cm1");
	w1.denyMove();
	w1.denyResize();
	w1.clearIcon();
	w1.denyPark();
	w1.setModal(true);
	dhxWins.attachEvent("onClose", function(win){
		var SQL = "select '1'," + cols + " from catalogue"; 
		var SQLCOLS = "1," + cols;
		global_mygrid.clearAll();
	   	if(global_thisId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisJournalId; 
    		
    		if(global_location != '')
    			ESQL += " and location_ =  " + "'" + global_location + "'";

    		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("m1122.xml");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
        showLoading(false);
     	ClearRecord();
     	for(var i=0;i<ccols.length;i++){
     		var myField = line.split(',')[i];
     		$("#" + ccols[i]).val(myField);
     	}
     	SetMouseKeys();
     	SetValidator();
     	MakeDisable();
		MakeDates();
		global_thisJournalId =     	$("#catalogue_").val();
    	if(global_location != ''){
    		   // 		$("#location_").val(global_location);
    		    		$("#location_").attr("disabled",true);
    		    	}
     	GoToField("#volume_");
 	});
    tabbar.attachEvent("onXLS", function() {
         showLoading(true);
     });
    }

//route
function m11221(){
	//main form
	var h = new Array();
	var f = new Array();
	var l = new Array();
	var a = new Array();
//receipt form
	var h1 = new Array();
	var f1 = new Array();
	var l1 = new Array();
	var a1 = new Array();
	ParseForm("m1123.xml",h,f,l,a);
	 ParseForm("m1124.xml",h1,f1,l1,a1);
	menu.hide();
	var SQL = "select '1',id_,name_ from route"; 
	var SQLCOLS = "id_,name_";
	GridDiv("Routing");
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm11221.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,Name"); 
	mygrid.setColTypes("sub_row_grid,ro,ro");
	mygrid.setInitWidths("30,70,350"); 
	mygrid.setColAlign("left,left,left"); 
	mygrid.setColSorting("na,connector,connector");
	mygrid.enableContextMenu(cataloguemenu);
	SQLCOLS = "1," + SQLCOLS;
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,"Routes");
	if(CheckMyPriv('journals:x.c.x.x') == true)
		AddNewButton(mygrid,"route","m1123.xml",SQLCOLS,"name_",'500','420',SQL);
//add the sub grid

	mygrid.attachEvent("onSubGridCreated",function(subgrid,row_id,ind){
		subgrid.setHeader("Id,Route,Member,Priority"); 
		subgrid.setColAlign("left,left,left,left"); 
        subgrid.setInitWidths("80,80,80,80"); 
        subgrid.setColTypes("ro,ro,ro,ro"); 
        subgrid.setSkin("blue"); 
        subgrid.init();
        var	membertmenu = new dhtmlXMenuObject();
        membertmenu.setImagePath("codebase/imgs/");
        membertmenu.setIconsPath("imgs/");
        membertmenu.renderAsContextMenu();
        membertmenu.loadXML("_contextm11222.xml");
        subgrid.enableContextMenu(membertmenu);
    	global_myroutesubgrid = subgrid;
        var myId = mygrid.cellById(row_id, 1).getValue();
        RouteSubGrid(myId,subgrid);
        membertmenu.attachEvent("onClick", function(menuitemId, type){
        
        	var data = global_myroutesubgrid.contextID.split("_");

    	    var line ='';
    	    var ccols = f1;
    	    var cols = f;
        	ClearRecord();
        	for(var i=0;i<f1.length;i++){
        		var myField = global_myroutesubgrid.cellById(data[0], i).getValue();
 
        		line += myField + ",";
        	}
            eval(menuitemId);
    	    return true;
      	});

        return false; //block default logic });
	});
	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;
  	});
}

//add member to route
function m11221cm1(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, 600, 300);
	global_window = w1;
	w1.setModal(true);
    dhxWins.attachEvent("onClose", function(win){
       	var SQL = "select '1',id_,name_ from route"; 
    	var SQLCOLS = "1,id_,name_";
    	global_mygrid.clearAll();
    	if(global_thisRouteId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisRouteId;
    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
    	}
    	else{
    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	}
    	return true; 
    });
  
    w1.setText("Enter Record");
    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();
    	MakeDisableOnNew();
    	ClearRecord();
    	$("#route_").val(line.split(',')[1]);
    	global_thisRouteId =     	$("#route_").val();
    	GoToField("#member_");
    });
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1124.xml");
} 

function m11221cm2(line){
	var SQL = "select '1',id_,name_ from route"; 
	var SQLCOLS = "id_,name_";
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 600, 300);
	global_window = w1;
	w1.setModal(true);
    dhxWins.attachEvent("onClose", function(win){
    	var SQL = "select '1',id_,name_ from route"; 
    	var SQLCOLS = "1,id_,name_";
    	global_mygrid.clearAll();
    	if(global_thisRouteId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisRouteId;
    		global_mygrid.loadXML("connector.php?cmd="+ESQL+"&cols="+SQLCOLS+"&");
    	}
    	else{
    		global_mygrid.loadXML("connector.php?cmd="+SQL+"&cols="+SQLCOLS+"&");
    	}
    	return true; 
    });
    w1.setText("Amend Record");
    tabbar = w1.attachTabbar();
    tabbar.setSkin("dhx_skyblue");
    tabbar.setImagePath("imgs/");
    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();
    	MakeDates();
    	global_thisRouteId =     	$("#id_").val();
    	GoToField("#name_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1123.xml");

} 
//amend member record
function m11222cm1(line,cols,ccols){
var dhxWins, w1, tabbar;
	dhxWins = new dhtmlXWindows();
	dhxWins.enableAutoViewport(true);
	dhxWins.setImagePath("imgs/");
	w1 = dhxWins.createWindow("w1", 20, 30, 600, 300);
	global_window = w1;
	w1.setText("Amend Member Record: m11222cm1");
	w1.denyMove();
	w1.denyResize();
	w1.clearIcon();
	w1.denyPark();
	w1.setModal(true);
	dhxWins.attachEvent("onClose", function(win){
		var SQL = "select '1'," + cols + " from route"; 
		var SQLCOLS = "1," + cols;
		global_mygrid.clearAll();
	   	if(global_thisId != ''){
    		var ESQL = SQL + " where id_ = " + 	global_thisRouteId; 
    		
    		if(global_location != '')
    			ESQL += " and location_ =  " + "'" + global_location + "'";

    		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("m1124.xml");
    tabbar.attachEvent("onXLE", function() { //row_id will be the first row
        showLoading(false);
     	ClearRecord();
     	for(var i=0;i<ccols.length;i++){
     		var myField = line.split(',')[i];
     		$("#" + ccols[i]).val(myField);
     	}
     	SetMouseKeys();
     	SetValidator();
     	MakeDisable();
		MakeDates();
		global_thisRouteId =     	$("#route_").val();
    	if(global_location != ''){
    		   // 		$("#location_").val(global_location);
    		    		$("#location_").attr("disabled",true);
    		    	}
     	GoToField("#member_");
 	});
    tabbar.attachEvent("onXLS", function() {
         showLoading(true);
     });
    }

function JournalSubGrid(id,subgrid){		//catalogue id
	var SQL = "select id_,catalogue_,barcode_,journalyear_,journalvolume_,journalissue_,location_,site_,shelf_,status_,receipt_,missing_ from copies where catalogue_ = " + id + " order by receipt_ asc";
	var SQLCOLS = "id_,catalogue_,barcode_,journalyear_,journalvolume_,journalissue_,location_,site_,shelf_,status_,receipt_,missing_";  
	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 RouteSubGrid(id,subgrid){		//catalogue id
	var SQL = "select id_,route_,member_,priority_ from routelist where route_ = '" + id + "'";
	var SQLCOLS = "id_,route_,member_,priority_";  
	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];
				dlist += x + ',';
			}
			subgrid.addRow(j,dlist);
			subgrid.setRowTextStyle(j, "color: green; ");
		}	
	}
}

function Goreceipt(mygrid,table,formname,COLS){
	var cnt = 1;
	currentline_ = 1;
	InitOrderLines();
	order_lines[0] = 0;
	var checked=mygrid.getCheckedRows(1);
	var a = checked.split(',');
	order_lines[0] = a.length;
	for(var i=0;i<a.length;i++){
		var myId = mygrid.cellById(a[i], 2).getValue();
		order_lines[i+1] = myId;
	}
	EntryForm(mygrid,formname,COLS);
}



function GoJournalExport(mygrid){
	

}


function m1124(){
	menu.hide();
	GridDiv("");
	loadTab("#wizard","m1124.div");
	SetMouseKeys();
	SetValidator();
	current_menu = 'm1124';
	currentline_ = 1;
	InitOrderLines();
	GoToField("#name_");
}


function m1121Save(){
	var v = $("#cmaForm").validate();
	if(v.form()){
		var id_ = $("#id_").val();
		var old = $("#id_").val();
		if(id_ != ''){
			var SQL = MakeUpdateSql($("#amend1").val());
			var result = UpdateRecord(SQL,"loading");
			if(isNaN(result))
				alert(result);
			else{		
				alert("Record amended");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
		else{
			//checkIsbn
			var SQL = MakeInsertSql($("#insert1").val(),'','');
			var result = InsertRecord(SQL);
			if(isNaN(result))
				alert(result);
			else{
				alert("Record saved");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
	}

}

function m1123Save(){
	var v = $("#cmaForm").validate();
	if(v.form()){
		var id_ = $("#id_").val();
		var old = $("#id_").val();
		if(id_ != ''){
			var SQL = MakeUpdateSql($("#amend1").val());
			var result = UpdateRecord(SQL,"loading");
			if(isNaN(result))
				alert(result);
			else{		
				alert("Record amended");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
		else{
			var SQL = MakeInsertSql($("#insert1").val(),'','');
			var result = InsertRecord(SQL);
			if(isNaN(result))
				alert(result);
			else{
				alert("Record saved");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
	}

}
function m1124Save(){
	var v = $("#cmaForm").validate();
	if(v.form()){
		var id_ = $("#id_").val();
		var old = $("#id_").val();
		if(id_ != ''){
			var SQL = MakeUpdateSql($("#amend1").val());
			var result = UpdateRecord(SQL,"loading");
			if(isNaN(result))
				alert(result);
			else{		
				alert("Record amended");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
		else{
			var SQL = MakeInsertSql($("#insert1").val(),'member_',$("#barcode_").val());
			prompt("",SQL);
			var result = InsertRecord(SQL);
			if(isNaN(result))
				alert(result);
			else{
				alert("Record saved");
				GoToField("#id_");
				GoClearAmend();
				$("#id_").val(old);
			}
		}
	}

}
function GoJournal(){
	//barcode format 
	//9 771234 567010 01 raw
	//977123456701001
	//...journal code 0-
	//   .......issn 3-11
	//          ..varient
	//            .check digit
	//             ..issue number
	var myValue = $("#barcode_").val();
	if(myValue == ''){
		GoNext();
		global_barcodeTaken = true;
	}
	else{
		myValue = myValue.replace(/ /g,"");
		myValue = myValue.replace(/-/g,"");
		myValue = myValue.replace(/\./g,"");
		$("#barcode_").val(myValue + "/copy 1");
//get issn
		var issn = myValue.substr(3,7);
//get issue
		var issue = myValue.substr(13,2);
		$("#journalissue_").val(issue);
		if(myValue != ''){
			var copyfrom = $("#copyfrom").val(); 
			Populate("gophptable.php",copyfrom,"issn_",issn);
		}
		global_barcodeTaken = false;
	}
}


function GoClearJournal(){

	var v = $("#cmaForm").validate();
	$("#cmaForm").clearForm();
	v.prepareForm();
	v.hideErrors();
$('.gc').each(function(x){
	var field = ($(this).attr("id"));
	var value = ($(this).attr("default"));
	$("#" + field).val(value);
});
$("#receipt_").val(GetDate());
$("#barcode_").focus('');
$("#journalyear_").val(GetYear());
}
function GoRouteAuthority(fieldname,header,phpfile,seed,popit,multi,finder,func){
	var copyfrom='';
	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 RouteFMPop(z){
	UnTip();
	var x = z.getComboText().split('\t');
	$("#find_member_").val(x[2]);
	var route = $("#find_route_").val();
	if(route != ''){
		var copyfrom = "select id_,route_,member_,priority_ from routelist where route_ = '" + route + "' and $param = '$param_value' limit 1";
		Populate("gophptable.php",copyfrom,"member_",$("#find_member_").val());
	}
}

function RouteFRPop(z){
	UnTip();
	var x = z.getComboText();
	$("#find_route_").val(x);
	var member = $("#find_member_").val();
	if(member != ''){
		var copyfrom = "select id_,route_,member_,priority_ from routelist where route_ = '" + x + "' and $param = '$param_value' limit 1";
		Populate("gophptable.php",copyfrom,"member_",$("#find_member_").val());
	}
}
function RouteMPop(z){
	UnTip();
	var x = z.getComboText().split('\t');
	$("#member_").val(x[0]);
	$("#barcode_").val(x[2]);
	GoToField("#route_");
}

function RouteRPop(z){
	UnTip();
	var x = z.getComboText();
	$("#route_").val(x);
	GoToField("#priority_");
}

function m1125(){
	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("Journal subscription Renewals");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m1121.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    SQL = "select " + f + " from catalogue where media_ = 'journal' and renew_ < now() order by title_ asc";
    SQLCOLS = f;
	GridInit(mygrid,SQL, SQLCOLS);

	AddExportButton(SQL,SQLCOLS,"renewals");
	global_mygrid = mygrid;
   	mygrid.enableColumnAutoSize(false);
	AddPrintButton(mygrid);
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm1125.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 m1125cm1(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 Journal Record:m1121.xml");
	w1.denyMove();
	w1.denyResize();
	w1.clearIcon();
	w1.denyPark();
	w1.setModal(true);
	dhxWins.attachEvent("onClose", function(win){
		var SQL = "select " + cols + " from catalogue"; 
		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("m1121.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();
    	$("#id_").val(line.split(',')[0]);
    	global_thisId =  $("#id_").val();
     	GoToField("#issn_");
 	});
    tabbar.attachEvent("onXLS", function() {
         showLoading(true);
     });

}

function m1126(){
	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("Missing Journal Issues");
	GridStyle('800px','260px');
	var mygrid;
	mygrid = new dhtmlXGridObject('gridholder');
	mygrid.attachEvent("onXLE", function() {
		showLoading(false);
	});
    mygrid.attachEvent("onXLS", function() {
        showLoading(true);
    });  
    ParseForm("m1122.xml",h,f,l,a);
    GridShow(mygrid,h,f,l,a,999,false); 
    
    SQL = "select " + f + " from copies where  missing_ = 'yes'";
    SQLCOLS = f;
	GridInit(mygrid,SQL, SQLCOLS);

	AddExportButton(SQL,SQLCOLS,"renewals");
	global_mygrid = mygrid;
   	mygrid.enableColumnAutoSize(false);
	AddPrintButton(mygrid);
	var	cataloguemenu = new dhtmlXMenuObject();
	cataloguemenu.setImagePath("codebase/imgs/");
	cataloguemenu.setIconsPath("imgs/");
	cataloguemenu.renderAsContextMenu();
	cataloguemenu.loadXML("_contextm1126.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 m1126cm1(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 Receipt Record:m1122.xml");
	w1.denyMove();
	w1.denyResize();
	w1.clearIcon();
	w1.denyPark();
	w1.setModal(true);
	dhxWins.attachEvent("onClose", function(win){
		var SQL = "select " + cols + " from copies "; 
		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("m1122.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();
    	$("#id_").val(line.split(',')[0]);
    	global_thisId =  $("#id_").val();
     	GoToField("#issn_");
 	});
    tabbar.attachEvent("onXLS", function() {
         showLoading(true);
     });

}