var current_menu = '';
var current=0;
var global_mygrid;
var global_mysubgrid;
function m1110(filter){
	if(CheckFeature('purchasing') == false){
		alert("This feature is not part of FREE Cyberlibrary. Please email for prices");
		return;
	}
	menu.hide();
	if(filter == true){
		var SQL = "select '1',orderhead.id_,orderhead.order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead,orders where orders.order_ = orderhead.order_ and orders.received_ <> orders.quantity_ order by id_,supplier_ desc";
		var SQLCOLS = "id_,order_,supplier_,purchase_";
		GridDiv("Outstanding Orders");
	}
	else{
		var SQL = "select '1',id_,order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead order by id_,supplier_ desc"; 
		var SQLCOLS = "id_,order_,supplier_,purchase_";
		GridDiv("Purchase Orders");
	}
	var ORDERCOLS = "1,id_,isbn_,title_,authors_,media_,request_,budget_,quantity_,received_,unitprice_";
	var	ordermenu = new dhtmlXMenuObject();
	ordermenu.setImagePath("codebase/imgs/");
	ordermenu.setIconsPath("imgs/");
	ordermenu.renderAsContextMenu();
	ordermenu.loadXML("_context.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,Order,Supplier,Date"); 
	mygrid.setColTypes("sub_row_grid,ro,ro,ro,ro");
	mygrid.setInitWidths("30,80,80,200,600"); 
	mygrid.setColAlign("left,left,left,left,left"); 
	mygrid.setColSorting("connector,connector,connector,connector,connector");
	SQLCOLS = "1," + SQLCOLS;
	mygrid.enableContextMenu(ordermenu);
	GridInit(mygrid,SQL,SQLCOLS);
	global_mygrid = mygrid;
	AddPrintButton(mygrid);
	AddExportButton(SQL,SQLCOLS,'orders');
	if(CheckMyPriv('purchasing:x.c.x.x') == true)
		AddNewButton(mygrid,'orderhead',"m1111.xml",SQLCOLS,"order_",600,300,SQL);
//add the orders sub grid
	mygrid.attachEvent("onSubGridCreated",function(subgrid,row_id,ind,value){
		var	receiptmenu = new dhtmlXMenuObject();
		receiptmenu.setImagePath("codebase/imgs/");
		receiptmenu.setIconsPath("imgs/");
		receiptmenu.renderAsContextMenu();
		receiptmenu.loadXML("_context1.xml");
		subgrid.setHeader("&nbsp;,Id,Order,Isbn,Title,Author,Media,Request,Budget,Ordered,Received,Order Price"); 
		subgrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left,left"); 
        subgrid.setInitWidths("30,60,60,80,80,80,80,80,80,80,80,80"); 
        subgrid.setColTypes("sub_row_grid,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro"); 
        subgrid.setSkin("blue"); 
        subgrid.enableContextMenu(receiptmenu);
        subgrid.init();
    	global_mysubgrid = subgrid;
        var myId = mygrid.cellById(row_id, 2).getValue();
        GetOrderLines(myId,subgrid);
       receiptmenu.attachEvent("onClick", function(menuitemId, type){
    	    var data = global_mysubgrid.contextID.split("_");
    	    var line ='';
            var a = new Array();
        	a = ORDERCOLS.split(',');
        	ClearRecord();
        	for(var i=0;i<a.length;i++){
        		var myField = global_mysubgrid.cellByIndex(data[0], i).getValue();
        		line += myField + ",";
        	}
        	eval(menuitemId);
    	    return true;
      	});
        subgrid.attachEvent("onSubGridCreated",function(subsubgrid,row_id,ind,value){
        	subsubgrid.setHeader("Barcode,Price,Receipt,Location,Site,Shelf,Status"); 
        	subsubgrid.setColAlign("left,left,left,left,left,left,left"); 
        	subsubgrid.setInitWidths("80,80,80,80,80,80,80"); 
        	subsubgrid.setColTypes("ro,ro,ro,ro,ro,ro,ro"); 
        	subsubgrid.setSkin("blue"); 
        	subsubgrid.init();
        	var myId = subgrid.cellById(row_id, 1).getValue();
        	ordermenu.loadXML("_context1.xml");
        	GetReceipts(myId,subsubgrid);
        	return false; //block default logic }); 
        });
        return false; //block default logic }); 
	});


	ordermenu.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 order line
function m1110cm1(line){
	var SQL = "select '1',id_,order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead order by id_,supplier_ desc"; 
	var SQLCOLS = "id_,order_,supplier_,purchase_";
	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, 500);
    dhxWins.attachEvent("onClose", function(win){
    	global_mygrid.clearAll();
    	SQLCOLS = "1," + SQLCOLS;
    	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("isbn_");
    	MakeDisableOnNew();
    	ClearRecord();
    	$("#order_").val(line.split(',')[2]);
    	GoToField("#isbn_");
    });
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1112.xml");
} 

//amend order head
function m1110cm2(line){
	var SQL = "select '1',id_,order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead order by id_,supplier_ desc"; 
	var SQLCOLS = "id_,order_,supplier_,purchase_";
	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){
    	global_mygrid.clearAll();
    	SQLCOLS = "1," + SQLCOLS;
    	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);
        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("#supplier_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1111.xml");

} 

//amend order line
function m1110cm5(line){
	var SQL = "select '1',id_,order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead order by id_,supplier_ desc"; 
	var SQLCOLS = "id_,order_,supplier_,purchase_";
	var ORDERCOLS = "1,id_,order_,isbn_,title_,authors_,media_,request_,budget_,quantity_,received_,unitprice_";
	var dhxWins,w1,	tabbar;
	dhxWins = new dhtmlXWindows();
    dhxWins.enableAutoViewport(true);
    dhxWins.setImagePath("imgs/");
    w1 = dhxWins.createWindow("w1", 100, 100, 700, 600);
    dhxWins.attachEvent("onClose", function(win){
    	global_mygrid.clearAll();
    	SQLCOLS = "1," + SQLCOLS;
    	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);
        var a = new Array();
    	a = ORDERCOLS.split(',');
    	ClearRecord();
    	for(var i=0;i<a.length;i++){
    		var myField = line.split(',')[i];
    		$("#" + a[i]).val(myField);
    	}
    	SetMouseKeys();
    	SetValidator();
    	MakeDisable();
    	GoToField("#isbn_");
	});
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1112.xml");

} 
function m1110cm3(line){ 
}

//receipt order line
function m1110cm4(line){
	var SQL = "select '1',id_,order_,supplier_,DATE_FORMAT(purchase_,'%d/%m/%Y') as purchase_ from orderhead order by id_,supplier_ desc"; 
	var SQLCOLS = "id_,order_,supplier_,purchase_";
	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, 500);
    dhxWins.attachEvent("onClose", function(win){
    	global_mygrid.clearAll();
    	SQLCOLS = "1," + SQLCOLS;
    	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("isbn_");
    	MakeDisableOnNew();
    	ClearRecord();
    	$("#order_").val(line.split(',')[1]);
    	GoToField("#barcode_");
    });
    tabbar.attachEvent("onXLS", function() {
        showLoading(true);
    });
    tabbar.loadXML("m1113.xml");
} 

function GetOrderLines(id,subgrid){		//order id
    var SQL = "select '1' as a1,id_,order_,isbn_,title_,authors_,media_,request_,budget_,quantity_,received_,unitprice_ from orders where order_ = '" + id + "'";
	var SQLCOLS = "id_,order_,isbn_,title_,authors_,media_,request_,budget_,quantity_,received_,unitprice_";
	SQLCOLS = "a1," + SQLCOLS;
	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 GetReceipts(id,subgrid){
	var SQL = "select barcode_,price_,DATE_FORMAT(receipt_,'%d/%m/%Y') as receipt_,site_,location_,shelf_,status_ from copies where order_ = '" + id + "'";
	var SQLCOLS = "barcode_,price_,receipt_,site_,location_,shelf_,status_";
	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: red; ");
		}	
	}
}

function GoSaveReceipt(){
	var copyid =  $("#id_").val();
	var barcode = $("#barcode_").val();
	var order = $("#order_").val();
//update the item barcodes table
	var SQL = "update item_barcodes set taken_ = 'y' where barcode_ =" + barcode;
	var result = UpdateRecord(SQL,"order_");
	if(isNaN(result)){
		alert(result);
		return(false);
	}
	
// get the full order line
	var result = new Array();
	var SQL = "select title_,isbn_,authors_,edition_,publisher_,request_,media_,received_ from orders where id_ = " + order;  
	var SQLCOLS = "title_,isbn_,authors_,edition_,publisher_,request_,media_,received_";  
	AjaxSql("tab",SQL,SQLCOLS,result);
	var cnt = result[0];
//update the received count;
	var received = parseInt(result[8],10) + 1;
	var SQL = "update orders set received_ = " + received + " where id_ = " + order; 
	var result1 = UpdateRecord(SQL,"order_");
	if(isNaN(result1)){
		alert(result1);
		return(false);
	}
	if(result[2] != ''){	//see if isbn is in catalogue
		var SQL = "select id_ from catalogue where isbn_ = "  + "'" + result[2] + "'";
		var catalogueId = GetDbValue(SQL);
		if(isNaN(catalogueId)){		//not in catalogue make a new one
			var SQL = "insert into catalogue(isbn_,title_,authors_) values (" + "'" + result[2] + "'," + result[1] + "'," + result[3] + "')";
			var catalogueId = InsertRecord(SQL);
			if(isNaN(catalogueId)){			//invalid insert
				alert(result);
				return;
			} 
		}//update the copy record with the catalogue id
		SQL = "update copies set catalogue_=" + catalogueId + " where id_=" + copyid;
		var result = UpdateRecord(SQL,"order_");
		if(isNaN(result)){
			alert(result);
			return(false);
		}
	}
	else if(result[1] != ''){	//see if the title is in the catalogue
		var SQL = "select id_ from catalogue where title_ = "  + "'" + result[1] + "'";
		var catalogueId = GetDbValue(SQL);
		if(isNaN(catalogueId)){		//not in catalogue make a new one
			var SQL = "insert into catalogue(isbn_,title_,authors_) values (" + "'" + result[2] + "'," + result[1] + "'," + result[3] + "')";
			var catalogueId = InsertRecord(SQL);
			if(isNaN(catalogueId)){			//invalid insert
				alert(result);
				return;
			}
		}
		//update the copy record with the catalogue id
		SQL = "update copies set catalogue_=" + catalogueId + " where id_=" + copyid;
		var result = UpdateRecord(SQL,"order_");
		if(isNaN(result)){
			alert(result);
			return(false);
		}
	}
}


function loadTab(div,filename)
{
		$.ajax(
        {
        	method: "get",url: "gophpform.php",data: "filename=" + filename, 
        	async: false,
     	   	beforeSend: function(){
			$("#loadtab").html('<img src="images/wait.gif" />');
	      	$("#loadtab").show("fast");
	   	},
	    complete: function(){ 
			$("#loadtab").html('');
	   		$("#loadtab").hide("slow");
	   	},
           success: function(html) 
            {			    
                $(div).append(html); 
            }
        });			        
}


function SetUpAccordian(func,have_nextbutton){
$(document).ready(function(){
	$('label.required').append('&nbsp;<strong>*</strong>&nbsp;');
	var accordion = $("#stepForm").accordion({ autoHeight: false }); 
	$.validator.addMethod("pageRequired", function(value, element) {
		var $element = $(element);
		function match(index) {
			return current == index && $(element).parents("#sf" + (index + 1)).length;
		}
		if (match(0) || match(1) || match(2)) {
			return !this.optional(element);
		}
		return "dependency-mismatch";
	}, $.validator.messages.required);
	
	var v = $("#cmaForm").validate({
		errorClass: "warning",
		onkeyup: false,
		onblur: false,
		  onfocusout: false, 
		    onclick: false ,
		submitHandler: function() {
			func();
		},
		errorPlacement: function(error, element) { 
            offset = element.offset(); 
            error.insertBefore(element); 
            error.css('position', 'absolute'); 
            error.css('left', offset.left + element.outerWidth()); 
            error.css('top', offset.top); 
		}

	});
	$.validator.addMethod("checkIsbn", function(value, element) {
		if(value == '')
			return(true);
		var SQL = $("#" + element.id).attr('authority');
		SQL = SQL.replace("$value",value);
		var v = Exists(SQL);
		if(v == true){
			var where = window.confirm("This is a duplicate Isbn. Do you really want to save a copy of the record");
			if (where)
				return(true);
			else
				return(false);
		}
		else
			return(true);
	}, "Duplicate Isbn");

	$.validator.addMethod("AddAuthority", function(value, element) {
		var spl;
		var splitValue = new Array();
		if(value == '')
			return(true);
		var x = $("#" + element.id).attr('split');
		if(x == 'trim'){			//eg 004.456 PUT
			var sv = value.split(' ');
			splitValue[0] = sv[0];
		}	
		else if(x == 'split')
			splitValue = value.split(':');
		for(var i=0;i<splitValue.length;i++){			
			var SQL = $("#" + element.id).attr('authority');
			SQL = SQL.replace("$value",splitValue[i]);
			var v = Exists(SQL);
			if(v == false){
				var where = window.confirm("Unknown [" + splitValue[i] + "] authority. Would you like to save it");
				if (where){ //eg authority="select id_ from authors where author_ = '$value'"
					var table = SQL.split(' ')[3];
					var column = SQL.split(' ')[5];
					SQL = "insert into " + table + "(" + column + ")" + " values " + "('" + splitValue[i] + "')";
					var result = UpdateRecord(SQL,"loading");
					if(isNaN(result)){
						alert(result);
						return(false);
					}
					else{		
						alert("Authority saved");
						$("#" + element.id).focus('');
					}
				}
				else
					return(false);
			}
		}
		return(true);
	}, "Invalid Authority");
	// back buttons do not need to run validation
	$("#sf2 .prevbutton").click(function(){
		accordion.accordion("activate", 0);
		current = 0;
	}); 
	// these buttons all run the validation, overridden by specific targets above
	if(have_nextbutton){		//multiple page form
		$(".open1").click(function() {
			if (v.form()) {
				accordion.accordion("activate", 1);
				current = 1;
			}
	 
		});
		$(".open0").click(function() {
			if (v.form()) {
				accordion.accordion("activate", 0);
				current = 0;
			}
		});
	}
	$(document)[0].oncontextmenu = function() {return false;} ; 
	$("input").bind("mousedown", function(e){
		if( e.button == 2 ) {  
	         clickCheck(this);  
	         return false;  
	       } else {  
	         return true;  
	        }  
	    });
	$("textarea").bind("mousedown", function(e){
		if( e.button == 2 ) {  
	         clickCheck(this);  
	         return false;  
	       } else {  
	         return true;  
	        }  
	    });
	if ($.browser.mozilla) {
        $("input").keypress (checkForEnter);
    } else {
        $("input").keydown (checkForEnter);
    }

});
}


function GetDate(){
	var d = new Date();
	var m = d.getMonth()+1;
	if(m < 10)
		m = "0"+m;
	var t = d.getDate();
	if(t<10)
		t = "0"+t;
	return(t + "/" + m + "/" + d.getFullYear());
} 

function GetNextYear(){
	var d = new Date();
	var m = d.getMonth()+1;
	if(m < 10)
		m = "0"+m;
	var t = d.getDate();
	if(t<10)
		t = "0"+t;
	var y = parseInt(d.getFullYear(),10) + 1;
	return(t + "/" + m + "/" + y);
} 


function GetYear(){
	var d = new Date();
	return(d.getFullYear());
} 

function SetDate(myDate){
	var d = myDate.split('/');
	return(d[2] + "-" + d[1] + "-" +d[0]);
} 

function UnSetDate(myDate){
	if(myDate.indexOf('-') != -1){
		var d = myDate.split('-');
		return(d[2] + "/" + d[1] + "/" +d[0]);
	}
} 


function MakeInsertSql(sql,extra_field,extra_value){
	var field;
	var value;
	var SQL = sql;
	var pos1=SQL.indexOf('into');
	var str = SQL.substring(pos1+4,999);
	str = str.replace("(","");
	str = str.replace(/ /g,"");
	if(extra_field != '')
		SQL += extra_field + ',';
	$('label').each(function(x){
		field = $(this).attr(str);
		if(field)
			SQL += field + ",";
	});
	SQL += ")";
	SQL = SQL.replace(",)",")");
	SQL += " values (";
	if(extra_field != '')
		SQL += extra_value + ',';
	$('label').each(function(x){
		 var v = $(this).attr(str);
		 if(v){
			 value = $("#"+v).val(); 
			 if(!value)
				 value = '';
			 else{
				value = value.replace(/'/g,"\\'");
				value = value.replace(/"/g,"\"");
				value = value.replace(/\n/g,"");
				value = value.replace(/\r/g,"");
			 }
			 SQL += "'" + value + "'";
			 SQL += ",";
		 }
	});
	SQL += ")";
	SQL = SQL.replace(",)",")");
	return(SQL);
}


	



function GoClear(){
//	var where = window.confirm("This is a duplicate Isbn. Do you really want to save a copy of the record");
	//if (where)
		//return(true);
	//else
		//return(false);

	var v = $("#cmaForm").validate();
	$("#cmaForm").clearForm();
	v.prepareForm();
	v.hideErrors();


	$("#catalogued_").val(GetDate());
	$("#status_").val('SHE');
	$("#category_").val('Ordinary');
	$("#site_").val('Main');
	$("#location_").val('LRC');
	$("#price_").val('0.00');
	$("#unitprice_").val('0.00');
	$("#title_").attr("disabled",false);
	$("#id_").attr("disabled",false);
	$('form:first *:input[type!=hidden]:first').focus(); 
}

function GoClearAmend(){
	var v = $("#cmaForm").validate();
	$("#cmaForm").clearForm();
	v.prepareForm();
	v.hideErrors();
	$('form:first *:input[type!=hidden]:first').focus(); 
	MakeEnable();
}

function clickCheck(e){
	var authority = $($(e)).attr("src");
	eval(authority);
}

function checkForEnter (event) {
    if (event.keyCode == 13) {
    	event.preventDefault();
    	return false;
	}
} 

function Exists(SQL){
	var myData = '';
	$.ajax({
		type: "post",url: "exists.php", data:"cmd=" + SQL,
	    async: false,
	    beforeSend: function(){
		  $('#loading').html('<img src="images/wait.gif" />');
		  $("#loading").show("fast");
		},
		complete: function(){ 
			$("#loading").hide("fast");
		},
		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("id_").text();
			});
		},
		error: function(){
			alert("There has been an error");
			myData = "error";
		}
	});
	if(!isNaN(myData) && myData != ''){
		return(true);
	}
	return(false);
	
}
function GetServerDate(SQL){
	var myData = '';
	$.ajax({
		type: "post",url: "getdate.php", data:"cmd=" + SQL,
	    async: false,
	    beforeSend: function(){
		  $('#loading').html('<img src="images/wait.gif" />');
		  $("#loading").show("fast");
		},
		complete: function(){ 
			$("#loading").hide("fast");
		},
		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("thedate_").text();
			});
		},
		error: function(){
			alert("There has been an error");
			myData = "error";
		}
	});
	return(myData);
}

function GetDbValue(SQL){
	var myData = '';
	$.ajax({
		type: "post",url: "exists.php", data:"cmd=" + SQL,
	    async: false,
	    beforeSend: function(){
		  $('#loading').html('<img src="images/wait.gif" />');
		  $("#loading").show("fast");
		},
		complete: function(){ 
			$("#loading").hide("fast");
		},
		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("id_").text();
			});
		},
		error: function(){
			alert("There has been an error");
			myData = "error";
		}
	});
	return(myData);
}

function SaveAuthority(SQL){
	var SQL = MakeInsertSql($("#insert1").val(),'catalogue_',$("#id_").val());
	var result = InsertRecord(SQL);
	if(isNaN(result))
		alert(result);
	else{		//update the item_barcode table with taken
		alert("Record saved");
		var SQL = $("#afterinsert").val();
		var barcode = $("#barcode_").val();
		SQL = SQL.replace("$",barcode);
		UpdateRecord(SQL,"loading");
		$("#barcode_").val('');
		$("#barcode_").focus();
		return;
	}
	alert("Record not saved");
}

function SetValidator(n){
	if(!n)
		n = 120;
	$('label.required').append('&nbsp;<strong>*</strong>&nbsp;');
	$.validator.addMethod("pageRequired", function(value, element) {
		var $element = $(element);
		function match(index) {
			return current == index && $(element).parents("#sf" + (index + 1)).length;
		}
		if (match(0) || match(1) || match(2)) {
			return !this.optional(element);
		}
		return "dependency-mismatch";
	}, $.validator.messages.required);
	var v = $("#cmaForm").validate({
		errorClass: "warning",
		onkeyup: false,
		onblur: false,
		  onfocusout: false, 
		    onclick: false ,
		submitHandler: function() {
			func();
		},
		errorPlacement: function(error, element) { 
			var x = element.attr('id');
			$("#"+x).css("background-color", "pink"); 
		//	offset = element.offset(); 
          //  error.insertBefore(element); 
            //error.css('position', 'relative'); 
            //error.css('left', offset.left); 
            //error.css('top', offset.top); 
		}

	});
}

function SetMouseKeys(){
	$(document).ready(function() {
	     
	     $(this).oncontextmenu = function() {return false;} ;

	}); 
	$("input").dblclick(function() {
		clickCheck(this); 
		return false;
		});
 
	$("input").bind("mousedown", function(e){
		if(e.button == 2){  
			clickCheck(this);  
			return false;  
		} 
		else  
			return true;    
    });
	$("textarea").bind("mousedown", function(e){
		if(e.button == 2){  
			clickCheck(this);  
			return false;  
		} 
		else  
			return true;  
    });
	if ($.browser.mozilla)
		$("input").keypress(checkForEnter);
	else
		$("input").keydown(checkForEnter);
}