window.onload=systemSetup;
oldtabid=document.getElementById('defaulttab'); 
//adv proplist settings
lastselected=""; 
advPropselectedid="";
lasthighlightedColor="white";
var advPropFolderState=new Array();
var advfielddata="";
var pageselectedid="";
var oldHighLightColor="";
var browser="";
var linkline='';
var groupSelected;
var oldStatusBarMessage='';
var suggestCompany='';
var suggestElem;
var loadedAdData='';
var prevTodogrid;
var nlGroupsSelected=new Array();
var nlPathSelected='';
var nlTitleSelected='';
var totalTodoCount=0;
var globaltodoid;
var mouseStartY;
var mouseHandle;
var calStartYpos;
var calStartHeight;
var cal_scroll;
var cal_hourly;
var cal_halfday;
var cal_allday;
var searchTodogrid;
var browserVersion;
var statsList;
var myDate=new Date();
var dbToday=myDate.format("Y-m-d");
var duoDesktop='';
var searchNLValue;
var searchNLid;
var searchNLType;
var domain='';
var csvTempFile;
var sendTODOEmail="0";

var adminBookingDate=myDate.format("d/m/Y");
if(cookieVal('calyear')){
	var calMonth=cookieVal('calmonth');
	if(calMonth.lenth>2){//fix 0 before 10,11,12
		calMonth=calMonth.substring(1,3);
	}
	adminBookingDate=cookieVal('calday')+"/"+calMonth+"/"+cookieVal('calyear')+"/";
}

//----------------------------------

function systemSetup(){
	if(document.getElementById('duoClientSetup')){
		duoTestSetup();	
	}
	if(document.getElementById('csvUploadFrame')){
		objectListen(document.getElementById('csvUploadFrame'),"load",csvUserUpload);
	}
	
	if ('function' == typeof whichBrs){
		browser=whichBrs();
	}
	if(browser=="ie"){
		var userAgent=navigator.userAgent.toLowerCase();
		var bv=userAgent.match(/msie ([0-9.]*);/);
		browserVersion=bv[1];
	}
	if(!browserVersion){		
		var bods=document.getElementsByTagName('BODY');
		bods[0].id=browser;
	}
	if(document.getElementById('pagelist')){
		//load upload file list for banner manager
		pageListId='pagelist';
		pathAddressBar='pagelist';
		//loadPageList('0');	
		loadPageListFromPath('/images/banners/')	
	}
	todoAlerts();
	panelCollapseSetup();
	if(document.getElementById('siteLogs')){
		//setupLogs();
		var fields = {"logs|when": 1,  "logs|type": 0,  "pages|title": 1,"structure|path": 0, "users|username": 1,"structure|publish": 1};	
		var headers=new Array("Date Modified","Page Title","Username","Published?");
		logsgrid=new duoDataGrid('siteLogs','logs','siteLogToPath(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'','logsgrid');		
	}
	if(document.getElementById('userList')){
		var fields = {"users|id": 1,  "users|username": 1, "users|company": 1};	
		var headers=new Array("User Id","Username","Company");
		usersgrid=new duoDataGrid('userList','users','showUserInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'','usersgrid');		
	}
	//booking new setup
	if(document.getElementById('bd_username')){
		var userComplete=new duoAutoComplete(document.getElementById('bd_username'),'/duocms/calendar/getUsers/','compSuggest','bd_user_id');
		userComplete.setStorageId=bookingCompanyDetails;		
	}
	
	
	if(document.getElementById('bookingList')){
		var fields = {"bookings|id": 0,  "users|username": 1, "users|company": 1,  "pages|title": 1, "bookings|start_dt": 1, "bookings|end_dt": 1};	
		var headers=new Array("Username","Company","Title","Start Date / Time","End Date / Time");
		bookinggrid=new duoDataGrid('bookingList','calendar','showBookingInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'start_dt>="'+dbToday+'"','bookinggrid');		
	} 
	
	if(document.getElementById('prevBookingList')){
		var fields2 = {"bookings|id": 0,  "users|username": 1, "users|company": 1,  "pages|title": 1, "bookings|start_dt": 1, "bookings|end_dt": 1};	
		var headers2=new Array("Username","Company","Title","Start Date / Time","End Date / Time");
		prevBookinggrid=new duoDataGrid('prevBookingList','calendar','showBookingInfo(e)','highlightLine(e)','unhighlightLine(e)',fields2,headers2,'start_dt<="'+dbToday+'"','prevBookinggrid');		
	}
	//TODO Setup
	if(document.getElementById('todoList')){
		var fields = {"todos|id": 0, "users|username": 1, "users|company": 1,  "todos|reported_dt": 1, "todos|lastupdated_dt": 1,  "todos|status": 1, "todos|location": 1};	
		var headers=new Array("Username","Company","Reported","Updated","Status","Location");
		todogrid=new duoDataGrid('todoList','todos','showTodo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'status <> 4','todogrid');		
		//locations list with jquery - filters faults with cookie setting
		$('.locfilter').click(function(event){
			if(event.target.checked){
				cookieMaker(event.target.id,'1');
			}else{
				cookieMaker(event.target.id,'');
			}
			//reload list?
			todogrid.loadedrows='';
			todogrid.getRowCount();	
			totalTodoCount=0;
			todoGetAlertUpdate();	
			
		});
		$('#td_status').change(todoCompleted);
		//update tablecount but don't alert

	}
	
	if(document.getElementById('prevTodoList')){
		var fields = {"todos|id": 0,  "users|username": 1, "users|company": 1,  "todos|reported_dt": 1, "todos|lastupdated_dt": 1,  "todos|status": 1, "todos|location": 1};	
		var headers=new Array("Username","Company","Reported","Updated","Status","Location");
		prevTodogrid=new duoDataGrid('prevTodoList','todos','showTodo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'status = 4','prevTodogrid');		
	}
	
	if(document.getElementById('searchTodoList')){
		var fields = {"todos|id": 0,  "users|username": 1, "users|company": 1,  "todos|reported_dt": 1, "todos|lastupdated_dt": 1,  "todos|status": 1, "todos|location": 1};	
		var headers=new Array("Username","Company","Reported","Updated","Status","Location");
		searchTodogrid=new duoDataGrid('searchTodoList','todos','showTodo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'status = 4','prevTodogrid');		
	}
	
	
	
	if(document.getElementById('adList')){
		//setupLogs();
		var fields = {"ads|id": 0,"users|company": 1,  "ads|startdate": 1, "ads|enddate": 1, "ads|type": 1};	
		var headers=new Array("company","start date","end date","type");
		adgrid=new duoDataGrid('adList','ad_manager','showAdInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'','adgrid');		
	} 
	
	if(document.getElementById('pp_treeholder')){
		getAdvancedFieldsTickList();
		userFieldTickChangeSetup();
	}
	if(document.getElementById('tranactionList')){
		loadSuccessfulTransactions();
	}
	if(document.getElementById('fileTreeParent0')){
		loadSiteTreeBranch('0');
	}
	if ('function' == typeof setupTooltips){	
		setupTooltips();	
	}
	if($('#postageBlock').length>0){
		$('#postageBlock input').live('change',postCostUpdated);
		$('.postagerow').live('mouseup',selectPostageRow);
		$('#deletePostageButton').hide();
	}
}
/*--------------------------------------------------------------------------------
  Todo functions
--------------------------------------------------------------------------------*/
function showTodo(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}
	var rowid=item.id.replace('rowid','');
	//check which grid you're in
	var gridid=item;
	while(gridid.className!="tableContainer" && safecount<10){
		gridid=gridid.parentNode;	
		safecount++;	
	}
	if(gridid.id=='prevTodoList'){
		var todoid=prevTodogrid.storedData[rowid].id		
	}else if(gridid.id=='todoList'){
		var todoid=todogrid.storedData[rowid].id
	}else{
		var todoid=searchTodogrid.storedData[rowid].id
	}
	globaltodoid=todoid;
	var myConn = new XHConn();	
	document.getElementById('statusbar').innerHTML='Loading To-do Data';
	myConn.connect("/duocms/todos/getTodo/"+todoid, "POST", "", res_showTodo);
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	document.getElementById('todoTitle').innerHTML='Update To-do';	
	document.getElementById('deleteTodo').style.display="block";
	//autocomplete on user id 
}

function todoSearch(){
	if(document.getElementById('todosearchterm')){
		//show search tab
		showTab('searchtodoui',document.getElementById('searchTodoTab'));showStatus(true);searchTodogrid.loadedrows='';
		var newwhere=0;
		var term=document.getElementById('todosearchterm').value;
		var field="`"+document.getElementById('searchfield').value.replace('todos|','')+"`";
		if(field && term && term!='keyword'){		
			newwhere=field+" like '%"+term+"%'";
		}		
		if(field && term && newwhere!=searchTodogrid.sqlwhere){
			searchTodogrid.sqlwhere=newwhere;
			searchTodogrid.loadedrows='';
			searchTodogrid.getRowCount();
		}
	}	
}

function locationFilter(){
		//allow for two panels
		var mainpanelState=document.getElementById('maingenui').style.display;
		if(document.getElementById('locationFilter')){
		var newwhere;
		var term=document.getElementById('locationFilter').value;
		var filter;
		if(mainpanelState=="" || mainpanelState=="block"){
			filter="status <> 4";	
			var grid=todogrid;		
		}else{
			filter="status = 4";	
			var grid=prevTodogrid;
		}
		if(term==''){
			newwhere='status <> 4';
		}else{
			newwhere="location = "+term+" and "+filter;
		}
		if(newwhere!=grid.sqlwhere){
			grid.sqlwhere=newwhere;
			grid.loadedrows='';
			grid.getRowCount();
		}
	}	
}

function res_showTodo(data){
	if(!data.responseText){return;}
	sendTODOEmail=0;
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	var bd_data=data.info;
	for(row in bd_data){
		if(document.getElementById("td_"+row)){
			if(document.getElementById("td_"+row).tagName!="INPUT" && document.getElementById("td_"+row).tagName!="SELECT" && document.getElementById("td_"+row).tagName!="TEXTAREA"){			
				document.getElementById("td_"+row).innerHTML=bd_data[row].replace(/\n+/g,"<br />");//"
			}else{
				if(document.getElementById('td_'+row).type=="checkbox" && bd_data[row]=="1"){
					document.getElementById('td_'+row).checked=true;
				}else if(document.getElementById('td_'+row).type=="checkbox"){
					document.getElementById('td_'+row).checked=false;
				}else{
					document.getElementById('td_'+row).value=bd_data[row];	
				}
			}
		}		
	}
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;
	var userComplete=new duoAutoComplete(document.getElementById('td_username'),'/duocms/todos/getUsers/','compSuggest','td_user_id');
	userComplete.setStorageId=todoCompanyDetails;
	var actoinByComplete=new duoAutoComplete(document.getElementById('td_feedbackname'),'/duocms/todos/getUsers/','compSuggest','td_feedback_id');

}

function todoCompleted(e){
	if(document.getElementById('td_status') && document.getElementById('td_status').value==4){		
		sendTODOEmail="1";
	}	
}

function saveTodo(){
	var myConn = new XHConn();
	if (myConn){
		savingData=buildPOST('todoForm',document);
		//disable by cris 24 jun 2010
		//if(sendTODOEmail=='1' && confirm('Would you like an email sent to the fault reporter with your feedback?\n(this is development)')){
		//	sendTODOEmail='1';
		//}else{
			sendTODOEmail='0';
		//}
		//alert(savingData);		
		if(document.getElementById('td_id')){
			if(document.getElementById('td_id').value){
				myConn.connect("/duocms/todos/update/"+sendTODOEmail+"/", "POST", savingData, res_saveTodoInfo);		
			}else{
				myConn.connect("/duocms/todos/adminAdd/", "POST", savingData, res_saveTodoInfo);
			}
		}
	}
}


function res_saveTodoInfo(data){
	//alert(data.responseText);
	var data=eval('('+data.responseText+')');
	if(data && data.error){
		alert(data.error);
	}
	if(data && data.info){
		//alert(data.info.message);
		var todoid=data.info.id;
		//reload user
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		var myConn = new XHConn();	
		document.getElementById('statusbar').innerHTML='Loading To-do Data';
		myConn.connect("/duocms/todos/getTodo/"+todoid, "POST", "", res_showTodo);
		
		var mainpanelState=document.getElementById('maingenui').style.display;
		if(mainpanelState=="" || mainpanelState=="block"){
			var grid=todogrid;		
		}else{
			var grid=prevTodogrid;
		}
		grid.loadedrows='';
		grid.getRowCount();
	}
	
}


function addTodo(){
	//clear fields
	document.getElementById('todoForm').reset();
	var textareas=document.getElementsByTagName('TEXTAREA');
	for (i=0;i<textareas.length;i++){
		textareas[i].innerHTML='';		
	}	
	//set title
	document.getElementById('todoTitle').innerHTML='Create a New To-do';
	document.getElementById('deleteTodo').style.display="none";	
	//display details section
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';	
}

function closeTodoPanel(){
	document.getElementById('centerpanel2').style.display='none';
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midhalfblock','midfullblock');
	todogrid.loadedrows='';
	todogrid.getRowCount();
	if(prevTodogrid){
		prevTodogrid.loadedrows='';
		prevTodogrid.getRowCount();
	}
}

function todoAlerts(){
	if(document.getElementById('faultAlerts')){
		var tickbox=document.getElementById('faultAlerts').checked;
		if(tickbox){
			setTimeout("todoGetAlertUpdate()",60000);//check every minute 
		}
	}
}

function todoGetAlertUpdate(){
	var tickbox=document.getElementById('faultAlerts').checked;
	if(tickbox){
		var myConn = new XHConn();	
		document.getElementById('statusbar').innerHTML='Checking for updates';
		myConn.connect("/duocms/todos/tableCount", "POST", "", res_todoGetAlertUpdate);		
	}
}

function res_todoGetAlertUpdate(data){
	document.getElementById('statusbar').innerHTML='';
	if(!data.responseText){return;}
	var data=eval('('+data.responseText+')');
	if(data.info.total>totalTodoCount && totalTodoCount!=0){
		if(data.info.total-totalTodoCount==1){
			alert('A new fault has been reported.');
		}else{
			var count=data.info.total-totalTodoCount;
			alert(count+' new faults has been reported.');
		}
		todogrid.loadedrows='';
		todogrid.getRowCount();
		totalTodoCount=data.info.total;
	}
	if(totalTodoCount==0){
		totalTodoCount=data.info.total;
	}
	todoAlerts();
}

function deleteTodo(){
	if(!globaltodoid){alert('please select which item to delete');}
	if(!confirm('Are you sure you want to delete the selected fault?')){return;}
	var myConn = new XHConn();	
	document.getElementById('statusbar').innerHTML='Deleting Fault';
	myConn.connect("/duocms/todos/delete/"+globaltodoid+"/", "POST", "", res_deleteTodo);
}

function res_deleteTodo(data){
	todogrid.loadedrows='';
	todogrid.getRowCount();	
}


function todoCompanyDetails(val){
	if(document.getElementById('td_user_id')){document.getElementById('td_user_id').value=val;}
	var myConn = new XHConn();
	if (myConn){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Loading Company Data';
		myConn.connect("/duocms/todos/getCompanyDetails/"+val, "POST", "", res_todoCompanyDetails);
	}
}

function res_todoCompanyDetails(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(data.info){
		var Data=data.info;	
		document.getElementById('td_company').innerHTML=Data['bd_companyname'];
		document.getElementById('td_address').innerHTML=Data['td_address'].replace(/(\n|\r)/g,'<br>');
		document.getElementById('td_phone1').innerHTML=Data['td_phone1'];
	}else{
		document.getElementById('td_company').innerHTML='';
		document.getElementById('td_address').innerHTML='';
		document.getElementById('td_phone1').innerHTML='';
	}
}

/*--------------------------------------------------------------------------------
  Room Booking functions (old?)
--------------------------------------------------------------------------------*/
function showBookingInfo(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}
	var rowid=item.id.replace('rowid','');
	//check which grid you're in
	var gridid=item;
	while(gridid.className!="tableContainer" && safecount<10){
		gridid=gridid.parentNode;	
		safecount++;	
	}
	if(gridid.id=='prevBookingList'){
		var eventid=prevBookinggrid.storedData[rowid].id		
	}else{	
		var eventid=bookinggrid.storedData[rowid].id
	}
	var myConn = new XHConn();	
	document.getElementById('statusbar').innerHTML='Loading Booking Data';
	myConn.connect("/duocms/calendar/getRoomBooking/"+eventid, "POST", "", res_showBookingInfo);
	
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	//autocomplete on user id 
	var userComplete=new duoAutoComplete(document.getElementById('bd_username'),'/duocms/calendar/getUsers/','compSuggest','bd_user_id');
	userComplete.setStorageId=bookingCompanyDetails;
}

function bookingCompanyDetails(val){
	if(document.getElementById('bd_user_id')){document.getElementById('bd_user_id').value=val;}
	var myConn = new XHConn();
	if (myConn){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Loading Company Data';
		myConn.connect("/duocms/todos/getCompanyDetails/"+val, "POST", "", res_bookingCompanyDetails);
	}
}

function res_bookingCompanyDetails(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(data.info){
		var Data=data.info;	
		document.getElementById('bd_company').innerHTML=Data['companyname'];
		document.getElementById('bd_address').innerHTML=Data['address'].replace(/(\n|\r)/g,'<br>');
		document.getElementById('bd_phone1').innerHTML=Data['phone'];
	}else{
		document.getElementById('bd_company').innerHTML='';
		document.getElementById('bd_address').innerHTML='';
		document.getElementById('bd_phone1').innerHTML='';
	}
}


function res_showBookingInfo(data){
	if(!data.responseText){return;}
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	//clear old contact data
	document.getElementById('bd_company').innerHTML='';
	document.getElementById('bd_address').innerHTML='';
	document.getElementById('bd_phone1').innerHTML='';	
	var bd_data=data.info;
	for(row in bd_data){
		if(document.getElementById("bd_"+row) && bd_data[row]){
			if(document.getElementById("bd_"+row).tagName!="INPUT" && document.getElementById("bd_"+row).tagName!="SELECT"){			
				document.getElementById("bd_"+row).innerHTML=bd_data[row].replace(/\n+/g,"<br />");//"
			}else{
				document.getElementById("bd_"+row).value=bd_data[row];
			}
		}		
	}
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;
}

function deleteBookingInfo(){	
	//delete this element	
	var id=document.getElementById('bd_id').value;
	if(confirm('Are you sure you want to delete this booking?\nThis cannot be undone')){
		var myConn = new XHConn();
		document.getElementById('statusbar').innerHTML='Loading Booking Data';
		myConn.connect("/duocms/calendar/deleteRoomBooking/"+id+"/", "POST","", res_saveBookingInfo);	
	}
}

function saveBookingInfo(){
	//update booking info
	//get form
	var id=document.getElementById('bd_id').value;
	var startdate=document.getElementById('bd_startdate').value;
	var enddate=document.getElementById('bd_enddate').value;
	var start_dt=bookingFormatDate(startdate);
	var end_dt=bookingFormatDate(enddate);
	var vending=document.getElementById('bd_vendingcount').value;
	var cost=document.getElementById('bd_bookingcost').value;
	var userid=document.getElementById('bd_user_id').value;
	var strucid=document.getElementById('bd_structure_id').value;	
	if(!userid){alert('You must select a valid user to assign this booking to');return;}
	
	//
	var myConn = new XHConn();
	document.getElementById('statusbar').innerHTML='Loading Booking Data';
	myConn.connect("/duocms/calendar/setRoomBooking/"+start_dt+"/"+end_dt+"/"+strucid+"/"+userid+"/"+id+"/"+cost+"/"+vending+"/", "POST", "", res_saveBookingInfo);
}

function res_saveBookingInfo(data){
	if(!data.responseText){return;}
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
	}
	closeBookingPanel();
}

function closeBookingPanel(){
	document.getElementById('centerpanel2').style.display='none';
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midhalfblock','midfullblock');
	bookinggrid.loadedrows='';
	bookinggrid.getRowCount();
	prevBookinggrid.loadedrows='';
	prevBookinggrid.getRowCount();
}

function bookingFormatDate(indate){
	var hour=indate.match(/[0-9]*/);
	var minute=indate.match(/:([0-9]{2}) /);minute=minute[1];
	var day=indate.match(/ ([0-9]{1,2})\//);day=day[1];
	var month=indate.match(/\/([0-9]{1,3})\//);month=month[1];
	if(month.length>2){month=month.substring(1,3);}
	var year=indate.match(/[0-9]{1,2}\/[0-9]{1,3}\/([0-9]{2,4})/);year=year[1];
	return(year+"-"+month+"-"+day+" "+hour+":"+minute+":00");	
}

function addBooking(){
	document.getElementById('bookingForm').reset();
	document.getElementById('bd_id').value='';
	document.getElementById('bd_company').innerHTML='';
	document.getElementById('bd_address').innerHTML='';
	document.getElementById('bd_phone1').innerHTML='';
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	//autocomplete on user id 
	var userComplete=new duoAutoComplete(document.getElementById('bd_username'),'/duocms/calendar/getUsers/','compSuggest','bd_user_id');
	//set todays date
	var myDate=new Date();
	var thisMonth=parseInt(myDate.getMonth())+1;
    var today=myDate.format("d/m/Y");
	document.getElementById('bd_startdate').value="09:00 "+today;
	document.getElementById('bd_enddate').value="09:30 "+today;
	
}

function bookingSearch(){
	if(document.getElementById('usersearchterm')){
		var newwhere=0;
		var term=document.getElementById('usersearchterm').value;
		
		var field=document.getElementById('searchfield').value;
		if(field && term && term!='keyword'){		
			newwhere=field+" like '%"+term+"%' and start_dt>='"+dbToday+"'";
			newwhere2=field+" like '%"+term+"%' and start_dt<='"+dbToday+"'";
		}else{
			newwhere=field+" start_dt>='"+dbToday+"'";
			newwhere2=field+" start_dt<='"+dbToday+"'";
		}
		if(newwhere!=bookinggrid.sqlwhere){
			bookinggrid.sqlwhere=newwhere;
			bookinggrid.loadedrows='';
			bookinggrid.getRowCount();
		}
		if(newwhere2!=prevBookinggrid.sqlwhere){
			prevBookinggrid.sqlwhere=newwhere2;
			prevBookinggrid.loadedrows='';
			prevBookinggrid.getRowCount();	
		}
	}	
}
/*--------------------------------------------------------------------------------
  Room Booking functions (new?)
--------------------------------------------------------------------------------*/
function cal_selDate(seldate){
	if(seldate){//remove from db
		adminBookingDate=seldate;
		var id=document.getElementById('roomid').value;//get id from dropdown
		var myConn = new XHConn();	
		myConn.connect("/duocms/calendar/adminoutput/"+seldate+"/"+id+"/", "POST", '', cal_showLoadedCal);
	}
}

function cal_addbooking(obj){
	var top=obj.offsetTop;
	var cal=document.getElementById('caltimes');
	cal_clearForm();
	cal.innerHTML+='<div onmousedown="cal_getDetails(\'0\',this)" id="newbooking" class="bookedTimes newbooking" style="height:25px;top:'+top+'px" >NEW BOOKING<div class="resizeBottom"></div><div class="resizeTop" ></div></div>';	
	cal_getDetails(0,document.getElementById('newbooking'));
}

function cal_selRoom(){
	var id=document.getElementById('roomid').value;//get id from dropdown
	var myConn = new XHConn();	
	myConn.connect("/duocms/calendar/adminoutput/"+adminBookingDate+"/"+id+"/", "POST", '', cal_showLoadedCal);
}

function cal_showLoadedCal(data){
	var data=eval('('+data.responseText+')');	
	if(data && data.error){	
		alert(data.error);
	}
	if(data.info){
		document.getElementById('bookingcalendarinner').innerHTML=unt8Decode(data.info.cal);
		document.getElementById('daylist').innerHTML=unt8Decode(data.info.daylist);
		cal_hourly=data.info.prices.hourly;
		cal_halfday=data.info.prices.halfday;
		cal_allday=data.info.prices.allday;
	}
	document.getElementById('caltimes').scrollTop=cal_scroll;	
}

function cal_deleteBooking(){
	var id=document.getElementById('bd_id').value;
	if(confirm('Are you sure you want to delete this booking?\nThis cannot be undone')){
		var myConn = new XHConn();
		document.getElementById('statusbar').innerHTML='Deleting Booking Data';
		myConn.connect("/duocms/calendar/deleteRoomBooking/"+id+"/", "POST","", res_cal_bookRoom);	
		cal_closePanel();
	}
}

function cal_clearForm(){
	cal_resetTicks();
	document.getElementById('bookingForm').reset();
	document.getElementById('bd_id').value='';
	document.getElementById('bd_username').value='';
	document.getElementById('bd_company').innerHTML='';
	document.getElementById('bd_address').innerHTML='';
	document.getElementById('bd_phone1').innerHTML='';	
}

function cal_getDetails(eventid,obj){
	if(eventid=="0"){
		document.getElementById('bd_id').value='';
		cal_clearForm();
	}
	if(document.getElementById('calSelBlock')){
		var oldselected=document.getElementById('calSelBlock');
		if(oldselected==obj){return;}	
		oldselected.removeAttribute('id');	
		if(oldselected.className.match(/newbooking/i) && oldselected!=obj){
			oldselected.parentNode.removeChild(oldselected);
		}		
	}
	document.getElementById('maingenui').className='partcal';
	obj.id='calSelBlock';
	if(eventid){
		var myConn = new XHConn();	
		document.getElementById('statusbar').innerHTML='Loading Booking Data';
		myConn.connect("/duocms/calendar/getRoomBooking/"+eventid, "POST", "", res_cal_getDetails);
	}
	var handles=obj.getElementsByTagName('DIV');
	for(i=0;i<handles.length;i++){
		objectListen(handles[i],"mousedown",cal_retime);
	}
	objectListen(document.getElementById('calSelBlock'),"mousedown",cal_retime);
}

function res_cal_getDetails(data){
	if(!data.responseText){return;}
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	//clear old contact data
	document.getElementById('bd_company').innerHTML='';
	document.getElementById('bd_address').innerHTML='';
	document.getElementById('bd_phone1').innerHTML='';	
	var bd_data=data.info;
	if(bd_data){
		for(row in bd_data){
			if(document.getElementById("bd_"+row) && bd_data[row]){
				if(document.getElementById("bd_"+row).tagName!="INPUT" && document.getElementById("bd_"+row).tagName!="SELECT"){			
					document.getElementById("bd_"+row).innerHTML=bd_data[row].replace(/\n+/g,"<br />");//"
				}else{
					document.getElementById("bd_"+row).value=bd_data[row];
				}
			}		
		}	
		document.getElementById('cal_starttime').value=bd_data['startdate'].match(/[0-9]{1,2}:[0-9]{2}/);
		document.getElementById('cal_endtime').value=bd_data['enddate'].match(/[0-9]{1,2}:[0-9]{2}/);
		document.getElementById('statusbar').innerHTML=oldStatusBarMessage;
	}
}

function cal_updateTime(hourlyprice){
	var cal_starttime=document.getElementById('cal_starttime').value.split(':');
	var cal_endtime=document.getElementById('cal_endtime').value.split(':');
	var caltimeDurationH=cal_endtime[0]-cal_starttime[0];
	var caltimeDurationM=cal_endtime[1]-cal_starttime[1];
	if(caltimeDurationM<1){
		caltimeDurationM=30; 
		caltimeDurationH--;		
	}
	//update position of calendar item
	if(document.getElementById('calSelBlock')){
		document.getElementById('calSelBlock').style.top=((cal_starttime[0]-6)*52)+((cal_starttime[1]/60)*52)+9+"px";
		document.getElementById('calSelBlock').style.height=((caltimeDurationH)*52)+((caltimeDurationM/60)*52)+"px";		
	}
	var caltimeDuration='';
	if(caltimeDurationH){						caltimeDuration+=caltimeDurationH+" Hour";		}
	if(caltimeDurationH>1){						caltimeDuration+="s";			}
	if(caltimeDurationH && caltimeDurationM){	caltimeDuration+=" and ";						}
	if(caltimeDurationM){						caltimeDuration+=caltimeDurationM+" minutes ";	}
	document.getElementById('caltimeDuration').innerHTML=caltimeDuration;
	if(hourlyprice){
		var price=parseFloat((caltimeDurationH+(caltimeDurationM/60))*hourlyprice); 
		document.getElementById('bd_bookingcost').value=price.toFixed(2);
		cal_resetTicks();
	}
}

function cal_resetTicks(){
	var allInputs=document.getElementsByTagName('INPUT');
	for(i=0;i<allInputs.length;i++){
		if(allInputs[i].className=='bookingCheckBox'){
			allInputs[i].checked=false;
		}		
	}	
}

function updateScroll(){
	cal_scroll=document.getElementById('caltimes').scrollTop;
}

function cal_bookRoom(){
	var id=document.getElementById('bd_id').value;
	if(!id){id="0";}
	var startdate=document.getElementById('cal_starttime').value+" "+adminBookingDate;
	var enddate=document.getElementById('cal_endtime').value+" "+adminBookingDate;
	
	//alert("debugging: startdate="+startdate+" enddate"+enddate);
	
	var start_dt=bookingFormatDate(startdate);
	var end_dt=bookingFormatDate(enddate);
	var vending=document.getElementById('bd_vendingcount').value;
	var cost=document.getElementById('bd_bookingcost').value;
	var userid=document.getElementById('bd_user_id').value;
	var strucid=document.getElementById('roomid').value;	
	if(!userid){alert('You must select a valid user to assign this booking to');return;}
	var myConn = new XHConn();
	document.getElementById('statusbar').innerHTML='Loading Booking Data '+cal_scroll;
	myConn.connect("/duocms/calendar/setRoomBooking/"+start_dt+"/"+end_dt+"/"+strucid+"/"+userid+"/"+id+"/"+cost+"/"+vending+"/", "POST", "", res_cal_bookRoom);
}
function res_cal_bookRoom(data){
	cal_selRoom();
	if(!data.responseText){return;}
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
	}
	
}

function cal_setTimes(obj,start,end,price){
	document.getElementById('cal_starttime').value=start;
	document.getElementById('cal_endtime').value=end;
	document.getElementById('bd_bookingcost').value=price;
	cal_resetTicks();
	obj.checked=true;	
	cal_updateTime();
}

function cal_retime(e){
	if (!e) var e = window.event;
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	objectListen(document,"mousemove",cal_mouseMove);
	objectListen(document,"mouseup",cal_mouseMoveStop);
	mouseStartY=e.clientY;
	calStartHeight=document.getElementById('calSelBlock').offsetHeight;
	calStartYpos=document.getElementById('calSelBlock').offsetTop;
	mouseHandle=item;
}

function cal_mouseMove(e){
	if (!e) var e = window.event;
	var newy=(e.clientY - mouseStartY);
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	//toolbarSetPosition(toolbar,newx,newy);
	document.getElementById('statusbar').innerHTML=newy+" "+document.getElementById('calSelBlock').offsetHeight+" "+document.getElementById('calSelBlock').offsetTop;
	if(mouseHandle.className=='resizeBottom'){
		document.getElementById('calSelBlock').style.height=(calStartHeight+newy)+"px";
	}
	if(mouseHandle.className.substr(0,11)=='bookedTimes'){
		document.getElementById('calSelBlock').style.top=(calStartYpos+newy)+"px";
	}
	if(mouseHandle.className=='resizeTop'){
		document.getElementById('calSelBlock').style.top=(calStartYpos+newy)+"px";
		document.getElementById('calSelBlock').style.height=(calStartHeight-newy)+"px";
	}
//8 34 60 - 26 difference, 26	
}

function cal_mouseMoveStop(e){
	objectStopListen(document,"mousemove",cal_mouseMove);
	objectStopListen(document,"mouseup",cal_mouseMoveStop);
	//snap to nearest time
	var endtop=(Math.round((document.getElementById('calSelBlock').offsetTop-9)/26)*26)+9;
	document.getElementById('calSelBlock').style.top=endtop+"px";
	var endHeight=(Math.round((document.getElementById('calSelBlock').offsetHeight)/26)*26);
	document.getElementById('calSelBlock').style.height=endHeight+"px";	
	var endStartTime=cal_formatTime((((endtop-9)/26)+12)/2);
	var endEndTime=cal_formatTime((endHeight/52)+((((endtop-9)/26)+12)/2));
	document.getElementById('cal_starttime').value=endStartTime;
	document.getElementById('cal_endtime').value=endEndTime;
}

function cal_formatTime(dec){
	var retval='';
	var hour=Math.round(dec-0.5);
	var minute=(dec-Math.round(dec-0.5))*60;
	if(minute=="0"){minute="00";}
	if(hour>9){
		retval=hour+":"+minute;
	}else{
		retval="0"+hour+":"+minute;
	}
	return (retval);
}

function cal_closePanel(){
	document.getElementById('maingenui').className='fullcal';
	cal_clearForm();
	cal_selRoom();//reload to remove changes / added but unsaved
}

function cal_download(){
	window.location.href='/duocms/calendar/download/'+document.getElementById('accountsdate').value+'/';	
}
/*--------------------------------------------------------------------------------
  User functions
--------------------------------------------------------------------------------*/

function csvUserUpload(e){
	//alert('uploaded');
	var raw=new Object();
	document.getElementById('import2').style.display="block";
	document.getElementById('import3').style.display="none";
	raw.responseText=document.getElementById('csvUploadFrame').contentWindow.document.getElementsByTagName("body")[0].innerHTML;
	data=parseJSON(raw);
	if(data.error){
		alert(data.error);
		return;
	}
	csvTempFile=data.temp;
	var fieldList=document.getElementById('fieldList');
	var ourFields=document.getElementById('searchfield').innerHTML;
	var html='<table><thead><tr><th style="min-width:100px;">Uploaded CSV Fields</th><th>&nbsp;</th><th>Website Fields</th></tr></thead><tbody>';
	if(data.info){
		var count=0;
		var rows=data.info;
		for (var row in rows){
			if(typeof(rows[row])=="string"){
				html+="<tr><td>"+rows[row]+"</td><td> &nbsp; = &nbsp; </td><td><select id='field"+count+"'>"+ourFields+"<option value=''>no match</option></select></td></tr>";
				count++;
			}
		}
		html+="</tbody></table><p>Use the drop downs above to match the fields between your data and that of the website</p>";
		fieldList.innerHTML=html;
	}
	//have a educated guess at row names
	var count=0;
	var ddown;
	for (var row in rows){
		if(typeof(rows[row])=="string"){
			ddown=document.getElementById('field'+count).getElementsByTagName('option');
			for(var i=0;i<ddown.length;i++){
				if(ddown[i].innerHTML.toLowerCase()==rows[row].toLowerCase()){
					document.getElementById('field'+count).value=ddown[i].value;
				}
			}
			count++;
		}
	}
}

function csvCancel(e){
	document.getElementById('import3').style.display="none";
	document.getElementById('import2').style.display="none";
	document.getElementById('csvUploadForm').reset();
}

function csvImport(){
	//create array of fieldnames
	var fieldList=document.getElementById('fieldList').getElementsByTagName('SELECT');
	var cols='';
	var errors=0;
	for(var i=0;i<fieldList.length;i++){
		if(!fieldList[i].value){
			errors++;
			cols+='false,';
		}else{
			cols+=fieldList[i].value+",";
		}
	}
	if(cols.length<2){
		document.getElementById('fieldList').style.borderColor='red';
		alert('Please select which fields to import into before clicking import');
		document.getElementById('fieldList').style.borderColor='#cccccc';
	}
	//get list of groups
	var csvGroups=document.getElementById('csvGroups').getElementsByTagName('INPUT');
	var groups='';
	for(var i=0;i<csvGroups.length;i++){
		if(csvGroups[i].checked){
			groups+=csvGroups[i].id.replace(/[^0-9]*/,'')+",";
		}
	}	
	var qs="&groups="+groups+"&fields="+cols+"&file="+csvTempFile;
	var myConn = new XHConn();
	myConn.connect("/duocms/users/csvCreateUsers/", "POST",qs, csvImport_res);
}

function csvImport_res(raw){
	data=parseJSON(raw);
	document.getElementById('import2').style.display="none";
	document.getElementById('import3').style.display="block";
	document.getElementById('import3').innerHTML='';
	
	var rows=data.info;
	var html='<ul>';
	for (var row in rows){
		if(typeof(rows[row])=="string"){
			html+="<li>"+rows[row]+"</li>";
			count++;
		}
	}
	html+="</ul><p>"+data.total+" users imported / updated successfully.";
	document.getElementById('import3').innerHTML=html;
}


function showUserInfo(e){
	var userid=usersgrid.storedData[usersgrid.selectedId].id;
	var myConn = new XHConn();
	if (myConn){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Loading User Data';
		myConn.connect("/duocms/users/getUserData/"+userid, "POST", "", res_showUserInfo);
		//var myConn2 = new XHConn();//combined with getUserData
		//myConn2.connect("/duocms/users/getUserGroups/"+userid, "POST", "", res_showUserGroups);
	}
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
}

function res_showUserInfo(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(document.getElementById('companies_companyname')){//for company link table if it exists
		var userCompComplete=new duoAutoComplete(document.getElementById('companies_companyname'),'/duocms/users/getCompanys/','compSuggest','users_structure_id');
		userCompComplete.setStorageId=userCompanyUpdate;
	}
	if(data && data.info){
		document.getElementById('userinfoform').reset();//clear all, esp checkboxes
		var Data=data.info;	
		for (var Row in Data){
			if(document.getElementById('users_'+Row) && Row!="password"){
				if(document.getElementById('users_'+Row).type=="checkbox" && Data[Row]=="1"){
					document.getElementById('users_'+Row).checked=true;
				}else{
					document.getElementById('users_'+Row).value=Data[Row];	
				}
			}			
		}	
		//populate groups - was sep function originally	
		var Data=data.info.groups;	
		var groupslist=document.getElementById('panel_groups').getElementsByTagName('input');
		for(i=0;i<groupslist.length;i++){
			//reset
			if(groupslist[i].checked){groupslist[i].checked=false;}
			for (var Row in Data){			
				if(groupslist[i].parentNode.id.replace(/groupCheckBox/i,'')==Data[Row]){
					groupslist[i].checked=true;
				}
			}		
		}
		if(data.info.companies){
			
			Data=data.info.companies;
			for (var Row in Data){
				if(document.getElementById('companies_'+Row)){	
					if(document.getElementById('companies_'+Row).type=="checkbox" && Data[Row]=="1"){
						document.getElementById('companies_'+Row).checked=true;
					}else{
						document.getElementById('companies_'+Row).value=Data[Row];	
					}
				}
			}			
		}
	}
	document.getElementById('statusbar').innerHTML=	oldStatusBarMessage;
}

function userCompanyUpdate(val){
	if(document.getElementById('users_structure_id')){document.getElementById('users_structure_id').value=val;}
	user_getCompanyDetails(val);		
}

function user_getCompanyDetails(structureid){
	var myConn = new XHConn();
	if (myConn){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Loading Company Data';
		myConn.connect("/duocms/users/getCompanyDetails/"+structureid, "POST", "", res_user_getCompanyDetails);
	}
}

function res_user_getCompanyDetails(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(data.info){
	var Data=data.info;	
		for (var Row in Data){
			if(document.getElementById('companies_'+Row)){	
				if(document.getElementById('companies_'+Row).type=="checkbox" && Data[Row]=="1"){
					document.getElementById('companies_'+Row).checked=true;
				}else{
					document.getElementById('companies_'+Row).value=Data[Row];	
				}
			}
		}	
	}
}

function closeUserPanel(){
	document.getElementById('centerpanel2').style.display='none';
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midhalfblock','midfullblock');
}

function adduser(){
	//clear fields
	document.getElementById('userinfoform').reset();
	//set panel title
	document.getElementById('userpanelTitle').innerHTML="Add New User";
	//display details section
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
}

function deleteuser(){
	var id=document.getElementById('users_id').value;
	if(!id){
		if (document.getElementById('centerpanel2').style.display!='none'){
			closeUserPanel();	
		}else{
			alert('Please select which user you would like to delete first');
		}
	}else{
		if(confirm('Are you sure you want to delete the selected user?')){
			var myConn = new XHConn();
			if (myConn){
				myConn.connect("/duocms/users/deleteUser/"+id, "POST", "", res_deleteUser);			
				closeUserPanel();
			}
		}
	}
}

function res_deleteUser(data){
	usersgrid.loadedrows='';
	usersgrid.makeAllRows();
	usersgrid.loadData();	
}

function saveUserInfo(){
	var myConn = new XHConn();
	if (myConn){
		savingData=buildPOST('userinfoform',document);
		//get groups as csv
		var groupslist=document.getElementById('panel_groups').getElementsByTagName('input');
		var groupCSV='';
		for(i=0;i<groupslist.length;i++){
			if(groupslist[i].checked){
				groupCSV+=","+groupslist[i].parentNode.id.replace(/groupCheckBox/i,'');//remove leader from id to get db-id
			}		
		}
		groupCSV=groupCSV.substr(1);//remove first comma
		groupCSV+=",0";
		savingData+="&groups="+groupCSV;
		if(document.getElementById('users_id')){
			if(document.getElementById('users_id').value){
				myConn.connect("/duocms/users/updateUser/", "POST", savingData, res_saveUserInfo);		
			}else{
				savingData=buildPOST('userinfoform',document);
				myConn.connect("/duocms/users/addNewUser/", "POST", savingData, res_saveUserInfo);
			}
		}
	}
}

function res_saveUserInfo(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){
		alert(data.error);
	}
	if(data && data.info){
		alert(data.info.message);
		//reload user
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Loading User Data';
		var myConn = new XHConn();
		myConn.connect("/duocms/users/getUserData/"+data.info.id, "POST", "", res_showUserInfo);
		
		usersgrid.loadedrows='';
		usersgrid.makeAllRows();
		usersgrid.loadData();
	}
}

function userFieldTickChangeSetup(){
	//add function to tickboxes to do onchange handler
	var treeholder=document.getElementById('pp_treeholder');
	var fieldTicks=treeholder.getElementsByTagName('INPUT');
	if(fieldTicks.length==0){//if not loaded yet
		setTimeout("userFieldTickChangeSetup()",1000);//try again in a second
		return;
	}	
	var fields=cookieVal('adminUserFields');
	for(i=0;i<fieldTicks.length;i++){
		objectListen(fieldTicks[i],'click',userFieldTickChange);
		if(fields && fields.indexOf(fieldTicks[i].name)!="-1" || usersgrid.fields[fieldTicks[i].name]){
			fieldTicks[i].checked=true;
		}		
	}
}

function userFieldTickChange(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var fields=cookieVal('adminUserFields');
	if(fields){
		fields=fields.replace(item.name,'');
		fields=fields.replace(',,',',');	
		cookieMaker('adminUserFields',fields);
	}
	if(item.checked){
		var fields=cookieVal('adminUserFields');
		if(fields){
			fields+=","+item.name;	
		}else{
			fields=item.name;
		}
		fields=fields.replace(',,',',');	
		cookieMaker('adminUserFields',fields);
		usersgrid.fields[item.name]='1';
		//get name from label
		labels=getElementsByFor(document,item.name);
		usersgrid.headers.push(labels[0].innerHTML);
	}else{
		usersgrid.fields[item.name]='';	
	}	
	usersgrid.loadedrows='';
	usersgrid.makeAllRows();
	usersgrid.loadData();
}

function userSearch(){
	if(document.getElementById('usersearchterm')){
		var newwhere=0;
		var term=document.getElementById('usersearchterm').value;
		var field=document.getElementById('searchfield').value.replace('users|','');
		if(field && term && term!='keyword'){		
			newwhere=field+" like '"+term+"%'";
		}		
		if(newwhere!=usersgrid.sqlwhere){
			usersgrid.sqlwhere=newwhere;
			usersgrid.loadedrows='';
			usersgrid.getRowCount();
		}
	}	
}

function userSetGroupFilter(elem){
	var val=elem.value;
	cookieMaker('userGroupFilter',val);
	
	usersgrid.loadedrows='';
	usersgrid.getRowCount();
}

function userCompetionsDownload(){
	var chosen=document.getElementById('userCompetitionSelect');
	if(chosen && chosen.value){
		window.location="/duocms/competition/download/"+chosen.value+"/";
	}
}

//===============
//Permissions

function permissionsGroupHighlight(obj){	
	if(obj && obj.parentNode && obj.parentNode.className.match(/active/i)){
		obj.parentNode.className=obj.parentNode.className.replace(/ ?active/,'');
	}else{
		obj.parentNode.className+=" active";		
	}
}

function permissionsLoad(obj,groupid){
	oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
	document.getElementById('statusbar').innerHTML='Loading Permissions';
	groupSelected=groupid;
	if(document.getElementById('groupSelected')){
		document.getElementById('groupSelected').removeAttribute('id');
	}
	obj.id='groupSelected';
	var myConn = new XHConn();
	if (myConn && groupSelected){
		myConn.connect("/duocms/users/getGroupPermissions/"+groupSelected+"/", "POST", "", permissionsLoad_res);
	}
}

function permissionsLoad_res(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	var permissions=data.info;
	var permissionTicks=document.getElementById('groupPermissions').getElementsByTagName('LI');
	for(i=0;i<permissionTicks.length;i++){
		//1st deactive, only reactivate if sent from server
		if(permissionTicks[i].className.match(/active/i)){
			permissionTicks[i].className=permissionTicks[i].className.replace(/ ?active/,'');
		}
		for (var Row in permissions){
			if(permissionTicks[i].id.replace(/perm/i,'')==permissions[Row].permission_id){
				permissionTicks[i].className+=" active";
			}
		}
	}
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;
}


function permissionsSave(){
	if(!groupSelected){alert('Please select a group');return;}
	var permissionTicks=document.getElementById('groupPermissions').getElementsByTagName('LI');
	var ticked='';
	for(i=0;i<permissionTicks.length;i++){
		if(permissionTicks[i].className.match(/active/i)){
			ticked+=","+permissionTicks[i].id.replace(/perm/,'');
		}
	}
	//remove 1st comma
	ticked=ticked.substr(1);
	var myConn = new XHConn();
	if (myConn && groupSelected){
		myConn.connect("/duocms/users/setGroupPermissions/"+groupSelected+"/"+escape(ticked)+"/", "POST", "", permissionsLoad_res);
	}	
}

function groupReorder(direc){
	if(!document.getElementById('groupSelected')){
		alert('please select a group to re-order');	
		return;	
	}
	var elem=document.getElementById('groupSelected');
	listReorder(direc,elem);
	var myConn = new XHConn();
	if (myConn && groupSelected){
		myConn.connect("/duocms/users/reorderGroup/"+direc+"/"+groupSelected, "POST", "", nothing_res);
	}
}
function nothing_res(data){
	//does nothing, though could refresh orderlist with ajax??	
}

function groupAdd(){
	if(!document.getElementById('groupNewInput')){
		if(document.getElementById('groupSelected')){
			document.getElementById('groupSelected').removeAttribute('id');
			groupSelected='';
		}
		var grouplist=document.getElementById('permGroupList');
		if(grouplist){
			grouplist.innerHTML+="<li id='groupSelected'><input id='groupNewInput' type='text' /><a href='javascript:groupNewSave();'><img title='save group' alt='save group' src='/duocms-resources/icons/newfolder.gif' /></a></li>"	
		}
		document.getElementById('groupNewInput').focus();
	}
}

function groupEdit(){
	if(document.getElementById('groupSelected') && groupSelected){
		var selected=document.getElementById('groupSelected');
		var groupName=selected.innerHTML;
		//setOuterHTML(document.getElementById('groupSelected').parentNode,'');//remove from groups list
		//setOuterHTML(document.getElementById('groupCheckBox'+groupSelected),'');//remove from groups panel
		
		selected.parentNode.innerHTML="<div id='groupSelected'><input id='groupNewInput' value='"+groupName+"' type='text' /><a href='javascript:groupUpdate();'><img title='update group' alt='update group' src='/duocms-resources/icons/newfolder.gif' /></a></div>";
		//selected.parentNode.parentNode.setAttribute('id','groupSelected');
	}else{
		alert('Please select a group to edit');
	}
}

function groupUpdate(){
	var selected=document.getElementById('groupNewInput');
	if(selected && groupSelected && selected.value){
		var myConn = new XHConn();
		if (myConn){
			oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
			document.getElementById('statusbar').innerHTML='Updating Group Name';
			var name=selected.value;
			myConn.connect("/duocms/users/updateGroup/"+escape(name)+"/"+groupSelected+"/", "POST", "", groupNewSave_res);
		}
	}	
}

function groupNewSave(){
	if(document.getElementById('groupNewInput')){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Saving New Group';
		var name=document.getElementById('groupNewInput').value;
		var myConn = new XHConn();
		if (myConn && name){
			myConn.connect("/duocms/users/addGroup/"+escape(name)+"/", "POST", "", groupNewSave_res);
		}	
	}
}

function groupNewSave_res(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	var name=document.getElementById('groupNewInput').value;
	var id=data.info.id;
	var permGroupList=document.getElementById('permGroupList').getElementsByTagName('LI');
	if(permGroupList.length/2==Math.floor(permGroupList.length/2)){
		document.getElementById('groupSelected').className='odd';
	}
	document.getElementById('groupSelected').innerHTML='<a onclick="permissionsLoad(this,\''+id+'\')" href="javascript:void(0)">'+name+'</a>';
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;
	if(document.getElementById('groupCheckBox'+id)){
		document.getElementById('groupCheckBox'+id).innerHTML='<input class="checkbox" type="checkbox" /> '+name;
	}else{
		for(i=id;i>0;i--){
			if(document.getElementById('groupCheckBox'+i)){
				document.getElementById('groupCheckBox'+i).parentNode.innerHTML+='<div id="groupCheckBox'+id+'"><input class="checkbox" type="checkbox" /> '+name+'</div>';
				break;
			}
		}
	}
}


function groupDelete(){
	if(!confirm('Are you sure you want to delete this group?')){return;}
	if(document.getElementById('groupSelected') && groupSelected){
		setOuterHTML(document.getElementById('groupSelected').parentNode,'');//remove from groups list
		if(document.getElementById('groupCheckBox'+groupSelected)){
			setOuterHTML(document.getElementById('groupCheckBox'+groupSelected),'');//remove from groups panel
		} 
		var myConn = new XHConn();	
		myConn.connect("/duocms/users/deleteGroup/"+groupSelected+"/", "POST", "", groupDelete_res);	
	}	
}

function groupDelete_res(data){
	alert(data.responseText);	
}


function listReorder(direc,elem){
	var parNode=elem.parentNode;
	var parNode2=parNode.parentNode;
	if(direc=='up'){
		if(parNode.previousSibling && parNode.previousSibling.tagName=="LI"){
			parNode2.insertBefore(parNode,parNode.previousSibling);
		}else if(parNode.previousSibling){
			parNode2.insertBefore(parNode,parNode.previousSibling.previousSibling);
		}else{
			alert('Your\'re at the top');
		}
	}else{
		if(parNode.nextSibling && parNode.nextSibling.tagName=="LI" && parNode.nextSibling!=parNode2.lastChild){
			parNode2.insertBefore(parNode,parNode.nextSibling.nextSibling);
		}else if(parNode.nextSibling && parNode.nextSibling!=parNode2.lastChild){
			parNode2.insertBefore(parNode,parNode.nextSibling.nextSibling.nextSibling);
		}else{
			alert('Your\'re at the bottom');
		}
	}	
}




/*--------------------------------------------------------------------------------
  Newsletter functions
--------------------------------------------------------------------------------*/
function nlAddNewsletter(){
	window.location.href='/duocms/newsletter/addNewsletter/';	
}

function nlSelectNewsLetter(obj,path){
	nlPathSelected=path;
	nlTitleSelected=obj.innerHTML;
	if(document.getElementById('nlSelected')){
		document.getElementById('nlSelected').removeAttribute('id');
	}
	obj.id='nlSelected';//highlights in blue	
}

function nlEditNewsletter(){
	if(nlPathSelected){
		window.open(nlPathSelected);		
	}else{
		alert('Please select which newsletter you wish to edit');
	}
	
}

function nlSelectGroup(obj,groupid){
	groupSelected=groupid;
	if(document.getElementById('groupSelected')){
		document.getElementById('groupSelected').removeAttribute('id');
	}
	obj.id='groupSelected';//highlights in blue	
}

function nlUpdateGroupList(obj,groupid){
	if(obj.checked==true){
		nlGroupsSelected[groupid]=true;		
		cookieMaker('nlgroup'+groupid,'true');
	}else{
		nlGroupsSelected[groupid]=false;
		cookieMaker('nlgroup'+groupid,'');	
	}
}


function nlSendTest(){
	if(!nlPathSelected){alert('Please select which newsletter to send');return;}
	document.getElementById('statusbar').innerHTML='Sending Test Newsletter to You';
	var modPath=nlPathSelected.replace(/\//g,'|');
	var myConn = new XHConn();
	if (myConn){
		myConn.connect('/duocms/newsletter/sendTestNewsletter/'+modPath+'/'+escape(nlTitleSelected)+'/', "POST", "", res_nlUpdateNewsletter);
	}	
}

function nlSendNewsletter(){
	if(!nlPathSelected){alert('Please select which newsletter to send');return;}
	if(nlPathSelected  && confirm('Are you sure you want send this newsletter now?')){
		document.getElementById('statusbar').innerHTML='Sending Test Newsletter';
		var modPath=nlPathSelected.replace(/\//g,'|');
		var myConn = new XHConn();
		if (myConn){
			myConn.connect("/duocms/newsletter/sendNewsletter/"+modPath+"/", "POST", "", res_nlUpdateNewsletter);
		}
	}
}

function res_nlUpdateNewsletter(data){
	//alert(data.responseText);
	document.getElementById('statusbar').innerHTML='Newsletter Sent For Distribution';
}

function nlSetAllGroups(val){
	var NLGrouplist=document.getElementById('NLGrouplist');
	var tickboxes=NLGrouplist.getElementsByTagName('input');
	for(i=0;i<tickboxes.length;i++){
		tickboxes[i].checked=val;
		if(val){
			cookieMaker(tickboxes[i].name,'true');
		}else{
			cookieMaker(tickboxes[i].name,'');
		}
	}	
}

function nlPathShow(path){
	linkboxid=document.getElementById(path);
	document.getElementById('linkline').value=linkboxid.value;
	linkline='linkline';	
	document.getElementById('nlPathSelect').style.display='block';
}
function nlPathSelect(){
	linkboxid.value=document.getElementById('linkline').value;
	nlPathHide();
}
function nlPathHide(){
	document.getElementById('nlPathSelect').style.display='none';
}

/*
function nlAddnewsletter(){
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	document.getElementById('newsletterSched').reset();
	document.getElementById('newsletterid').value='';
}
*/

function nlUpdateNewsletter(){
	var myConn = new XHConn();
	if (myConn){
		savingData=buildPOST('newsletterSched',document);
		if(document.getElementById('newsletterid')){
			if(document.getElementById('newsletterid').value){
				myConn.connect("/duocms/newsletter/updateSchdule/", "POST", savingData, res_nlUpdateNewsletter);		
			}else{
				myConn.connect("/duocms/newsletter/addToSchedule/", "POST", savingData, res_nlUpdateNewsletter);
			}
		}
	}	
}

function nlDeleteNewsletter(){
	if(confirm('Are you sure you wish to delete this newsletter from your schedule?') && document.getElementById('newsletterid')){
		var id=document.getElementById('newsletterid').value;
		var myConn = new XHConn();
		if (myConn){
			myConn.connect("/duocms/newsletter/deleteSchedule/"+id+"/", "POST", "", res_nlUpdateNewsletter);
		}
	}	 
}




function nlLoadNewsLetterStats(){		
	document.getElementById('centerpanel').className=(document.getElementById('centerpanel').className.replace('midhalfblock','midfullblock'));
	var myConn = new XHConn();
	if (myConn){
		myConn.connect("/duocms/newsletter/loadNewsLetterStats/", "POST", "", res_nlLoadNewsLetterStats);
	}
}

function res_nlLoadNewsLetterStats(data){
	//document.getElementById('loadingDialogue').style.display="none";
	var Data=parseJSON(data);
	var dataArea=document.getElementById('newsletterStats');
	dataArea.innerHTML='';
	//alert(data.responseText);
	var graphCount=1;
	for (var Row in Data){
		if(Data[Row]['sent']){
				var graphData = new Array();
				graphData['graph_direction'] = "h";//set horizontal
				graphData['graph_title'] = "<a href='javascript:nlShowViewer("+Data[Row]['id']+")'>"+Data[Row]['subject']+"</a><br><small>"+Data[Row]['sentwhen']+"</small>";
				graphData['graph_data']= new Array();
				var nldata=Data[Row];
				var count=0;
				for(var typ in nldata){
					if(typeof(nldata[typ])=='string' && typ!='subject' && typ!='id'&& typ!='sentwhen'){	
						graphData['graph_data'][count] = new Array();
						graphData['graph_data'][count]['value'] = nldata[typ];
						graphData['graph_data'][count]['label'] = "<a href='javascript:nlLoadDetailedStats(\""+typ+"\","+Data[Row]['id']+")' >"+typ+"</a>";	
						count++;
					}
				}
			dataArea.innerHTML+='<div class="nlgraph" id="grapharea'+graphCount+'" ></div>';			
			var graph = new duo_jsGraph(graphData,'grapharea'+graphCount);
			graphCount++;
		}
	}
}
function nlShowViewer(id){
	document.getElementById('nlviewer').style.display="block";
	document.getElementById('backgroundFader').style.display="block";
	document.getElementById('nlviewerIframe').src="/duocms/newsletter/view/"+id+"/";
}


function nlLoadDetailedStats(type,nlid){
	document.getElementById('nldstats').style.display="block";
	document.getElementById('backgroundFader').style.display="block";
	document.getElementById('statsListInner').innerHTML='Loading Data';
	document.getElementById('nldstatsTitle').innerHTML='List of emails for '+type+' Newsletters';
	document.getElementById('searchBox').value='';
	//record globally for use with search later
	searchNLid=nlid;
	searchNLType=type;
	var myConn = new XHConn();
	if (myConn){
		myConn.connect("/duocms/newsletter/loadNewsLetterStats/"+type+"/"+nlid+"/", "POST", "", nlLoadDetailedStats_res);
	}
}

function nlLoadDetailedStats_res(data){
	objectListen(document.getElementById('searchBox'),'keyup', startNLSearch);
	objectListen(document.getElementById('searchCancelButton'),'mousedown', stopNLSearch);
	var Data=parseJSON(data);
	if(!statsList){statsList=new optiList();}
	statsList.listData=Data;
	statsList.idPrefix='stats';
	statsList.listId='statsListInner';
	statsList.filter=false;
	statsList.mouseDown=nlShowUserDetails;
	/*
	userList.mouseUp=userSelect;
	userList.mouseDown=userSelectMD;
	userList.filterArray=filterArray;
	userList.filter=filter;
	if(userSelectedId){
		userList.selectedId=userSelectedId;
	}
	userList.dblClick=companySelectDbl;
	*/
	statsList.makeList();
}

function nlShowUserDetails(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	if(item.tagName=="STRONG"){item=item.parentNode;}	
	if(item.tagName!="LI"){return;}	
	var userid=item.id.replace(/[a-z]*/i,'');
	window.open('/duocms/users/panel/'+userid);
	return false;
}

function nlCloseViewer(){
	objectStopListen(document.getElementById('searchBox'),'keyup', startNLSearch);
	objectStopListen(document.getElementById('searchCancelButton'),'mousedown', stopNLSearch);
	document.getElementById('nlviewer').style.display="none";
	document.getElementById('nldstats').style.display="none";
	document.getElementById('backgroundFader').style.display="none";		
}


function startNLSearch(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	if (item.value) {
		//run companies and users list with filter	
		searchNLValue = item.value;
		setTimeout(searchNLHasChanged,1000);//check in half a second if text has changed
	}
}

function searchNLHasChanged(){
	if (document.getElementById('searchBox').value == searchNLValue) {//only search if it's still the same
		var myConn = new XHConn();
		if (myConn && searchNLValue){
			myConn.connect(domain+"/duocms/newsletter/searchNewsletterStats/"+searchNLType+"/"+searchNLid+"/"+escape(searchNLValue)+"/", "POST", '', searchNLHasChanged_res);
		}
		searchNLValue='';//reset to stop repeat search
	}
}

function searchNLHasChanged_res(data){
	var data=parseJSON(data);
	statsList.filterArray=data.info;
	statsList.filter=true;
	statsList.makeList();
}

function stopNLSearch(e){
	//console.log('cancelling search');
	document.getElementById('searchBox').value='';
	statsList.filter=false;
	statsList.makeList();
}

/*--------------------------------------------------------------------------------
  Login functions
--------------------------------------------------------------------------------*/
function duoLogin(){
	var password=hex_md5(hex_md5(document.getElementById('duoPasswordent').value)+document.getElementById('duoPass_hash').value);
	var editor_name=document.getElementById('editor_name').value;
	var myConn = new XHConn();

	if (myConn){
		var savingData="editor_name="+escape(editor_name)+"&password="+escape(password);
		if(document.getElementById('loginsave')){
			savingData+='&loginsave='+document.getElementById('loginsave').value;	
		}		
		//alert(savingData); 
		myConn.connect("/duocms/users/login/", "POST", savingData, duoLoggedIn);
	}	
}

function duoLoggedIn(data){
	//alert(data.responseText);
	var data=eval(data.responseText);
	if(data && data[0] && data[0].error){
		if(document.getElementById('loginMessage')){
			document.getElementById('loginMessage').innerHTML=data[0].error;
		}
	}else{
		if(document.getElementById('return_path')){
			parent.window.location=document.getElementById('return_path').value;
		}else{
			var temp=parent.window.location; parent.window.location=temp;
		}	
	}
	
}

/*--------------------------------------------------------------------------------
  Admin Interface Functions
--------------------------------------------------------------------------------*/

function showTab(tabid,tabselected,hideClass){
	if(!hideClass){
		var hideClass="siteinfo";
	}
	
	if(document.getElementById('productfilters')){
		//e-commerce, hide right panels, clear table contents - keep things fast
		document.getElementById('productfilters').style.display='none';
		document.getElementById('orderfilters').style.display='none';
		document.getElementById('tableContainer').innerHTML='';
		document.getElementById('tableContainer2').innerHTML='';
		document.getElementById('tableContainer3').innerHTML='';
		document.getElementById('tableContainer4').innerHTML='';
	} 
	Targets=document.getElementsByTagName("div");
	var allLis=tabselected.parentNode.parentNode.childNodes;
	for(i=0;i<allLis.length;i++){
		if (allLis[i].tagName == "LI") {
			allLis[i].removeAttribute('class');
			if(allLis[i].className){allLis[i].className='';}//ie fix, remove attribut doesn't always work
		}		
	}
	tabselected.parentNode.className="active";
	for(i=0;i<Targets.length;i++){
		if(Targets[i].className.replace(hideClass,'')!=Targets[i].className ){
			Targets[i].style.display="none";	
		}
	}
	document.getElementById(tabid).style.display="block";
}

function showStatus(opt){
	if(opt){
		document.getElementById('statusbar').style.display="block";
	}else{
		document.getElementById('statusbar').style.display="none";
	}
	
}

function panelCollapseSetup(){
	//Targets=document.all;
	Targets=document.getElementsByTagName("div");
	for(i=0;i<Targets.length;i++){
		if(Targets[i].className.substring(0,8)=="glosstop" && (Targets[i].id!='centerpanel' && Targets[i].id!='centerpanel2')){
			panelChildren=Targets[i].childNodes;
			for(pc=0;pc<panelChildren.length;pc++){
				//alert(panelChildren[pc].className);
				if(panelChildren[pc].className=="glosstl"){
					
					if(document.addEventListener){
                		panelChildren[pc].addEventListener("click",panelSwitch,true);
					}else{
						panelChildren[pc].onclick=panelSwitch;
					}
					//if closed close...
					var panelid=Targets[i].id;
					var panelMode=cookieVal("panel"+panelid);
					if(panelMode=="closed"){
						Targets[i].style.height="26px";
						Targets[i].style.overflow="hidden";
					}
				}
			}
		}
	}
}

function panelSwitch(e){	
	if(!e){var panelid=window.event.srcElement;}else{var panelid=e.target;}
	while(panelid.className!="glosstl" && panelid.tagName!="HTML"){
		panelid=panelid.parentNode;
	}
	panelid=panelid.parentNode;
	if(panelid){
		if(!panelid.style.height || panelid.style.height=="auto"){
			panelid.style.height="auto";
			panelid.style.height=panelid.offsetHeight+"px";
			eval("document.panelheight_"+panelid.id+"="+panelid.offsetHeight+";");
		}
		if(parseInt(panelid.style.height)>31){
			panelid.style.overflow="hidden";
			panelShrink(panelid.id);
 		}else{
			panelGrow(panelid.id);
		}
	}
}

function panelShrink(identifyer){
 	panelid=document.getElementById(identifyer);
	var panelHeight=parseInt(panelid.style.height);
	if(panelHeight>31){
		panelHeightNew=((panelHeight-27)/1.4)+24;
		panelid.style.height=panelHeightNew+"px";
 		setTimeout("panelShrink('"+identifyer+"')",1);
 		cookieMaker("panel"+identifyer,"closed");
 	}
} 

function panelGrow(identifyer){
 	panelid=document.getElementById(identifyer);
	var panelHeight=panelid.clientHeight;
	//alert(eval("document.panelheight_"+identifyer)+" "+panelHeight);
	if((((panelHeight-18)*1.6)+20)<eval("document.panelheight_"+identifyer)){
		panelHeight=((panelHeight-18)*1.6)+20;
		panelid.style.height=panelHeight+"px";
 		setTimeout("panelGrow('"+identifyer+"')",1);
 	}else{
 		panelid.style.height="auto";
 		cookieMaker("panel"+identifyer,"");
 	}
}

function highlightLine(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while(((item.tagName!="TR" && item.className!="dgrow")  && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}
	if(safecount<10){
		oldHighLightColor=item.className;
		item.style.backgroundColor="#85B8D7";
	}
}

function unhighlightLine(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}	
	if(safecount<10){
		if(oldHighLightColor=="odd"){
			item.style.backgroundColor='#EEF1F8';
		}else{
			item.style.backgroundColor='#FFFFFF';
		}
	}	
}

/*--------------------------------------------------------------------------------
  Site Information Functions
--------------------------------------------------------------------------------*/

function updatePassword(){
	var p1=document.getElementById('password1').value;
	var p2=document.getElementById('password2').value;
	var myConn = new XHConn();
	if (myConn){
		var savingData="p1="+escape(p1)+"&p2="+escape(p2);
		myConn.connect("/duocms/users/updateMyPassword/", "POST", savingData, updatePassword_res);
	}
}

function updatePassword_res(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		document.getElementById('passwordMessage').innerHTML=data.error;
	}	
}

function backupDatabase(){
	var myConn = new XHConn();
	if (myConn){
		myConn.connect("/duocms/data/backupDatabase/", "POST", "", backupDatabase_res);
	}		
}

function backupDatabase_res(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		document.getElementById('backupDatabaseMessage').innerHTML=data.error;
	}	
}

function siteLogToPath(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}	
	if(safecount<10){
		var rowid=item.id.replace('rowid','');
		window.location=(logsgrid.storedData[rowid].path);		
	}
}

function filespaceOptimise(){
	var w = document.getElementById('fileOptimiseAge').selectedIndex;
	var selected_text = document.getElementById('fileOptimiseAge').options[w].text.toLowerCase();
	if(confirm('Are you sure you want to delete unused files '+selected_text+'?')){
		window.location.href='/duocms/files/optimise/'+document.getElementById('fileOptimiseAge').value+'/';
	}
		
}

/*--------------------------------------------------------------------------------
  Ecommerce Admin Functions
--------------------------------------------------------------------------------*/


function loadSuccessfulTransactions(){
		var fields = {"transactions|id": 0,"transactions|reference": 1,  "transactions|buyername": 1, "transactions|amount": 1, "transactions|when": 1, "transactions|buyerpostcode":1};	
		var headers=new Array("reference no","Name","Amount","When","Postcode");
		var sqlwhere="confirmed=1";
		transactiongrid=new duoDataGrid('tranactionList','transactions','downloadInvoice(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,sqlwhere,'transactiongrid');		
}

function loadUnsuccessfulTransactions(){
		var fields = {"transactions|id": 0,"transactions|reference": 1,  "transactions|buyername": 1, "transactions|amount": 1, "transactions|when": 1,"transactions|buyerpostcode":1};	
		var headers=new Array("reference no","Name","Amount","When","Postcode");
		var sqlwhere="confirmed=0";
		unsucTransactiongrid=new duoDataGrid('unsucTranactionList','transactions','showUserInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,sqlwhere,'unsucTransactiongrid');		
}

function downloadInvoice(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;	
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}	
	if(safecount<10){
		var rowid=item.id.replace('rowid','');
		var transactionid=transactiongrid.storedData[rowid].id;
		window.location.href='/duocms/transactions/makeInvoice/'+transactionid+'/';
	}	
}

function loadProducts(){
		var fields = {"products|title": 1,  "products|stocklevel": 1, "products|price": 1};	
		var headers=new Array("Title","Stock Level","Price");
		var sqlwhere="";
		productsgrid=new duoDataGrid('productList','products','showProductInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,sqlwhere,'productsgrid');		
}

function addPostageWeight(){
	var html=$('#postageBlock').html();
	var newRow="<div  class='postagerow'><span><input id='newWeight' value='' /></span><span><input id='new_1_newweight' value='' /></span><span><input id='new_2_newweight' value='' /></span><span><input id='new_3_newweight' value='' /></span></div>";
	//$('#postageBlock').html(html+newRow);
	$('#postageBlock').append(newRow);
	$("#postageBlock").scrollTop($("#postageBlock").scrollTop() + 100000);
	$('#addPostageButton').hide();
}

function postCostUpdated(event){
	event.target.className="updated";
	$.getJSON('/duocms/transactions/updatePostage/'+event.target.id+'/'+escape(event.target.value)+'/', function(data) {
		if(data.error){
			alert(data.error);
		}
		if(data.info.oldid){
			$('#'+data.info.oldid).attr('id',data.info.id);
		}
		if(data.info.oldweight){
			for(i=1;i<11;i++){
				$('#new_'+i+'_'+data.info.oldweight).attr('id','new_'+i+'_'+data.info.newweight);
			}
			$('#weight'+data.info.oldweight).attr('id','weight'+data.info.newweight);
		}
		$('.updated').attr('class','');
		if($('#newWeight').length==0){
			$('#addPostageButton').show();
		}
	});	
}

function selectPostageRow(event){
	$('#selectedPostageRow').attr('id','');
	if(event.target.tagName!="DIV"){
		$(event.target).parents("div").first().attr('id',"selectedPostageRow");
	}else{
		event.target.id="selectedPostageRow";
	}
	if($('#selectedPostageRow').length>0){
		$('#deletePostageButton').show();
	}
}

function delPostageWeight(){
	if(!confirm('Are you sure you want to delete this row?\nIt cannot be undone')){return;}
	var weight=$('#selectedPostageRow').find('input').first().attr('value');
	//delete row
	$('#selectedPostageRow').remove();
	if(weight){
		$.getJSON('/duocms/transactions/deletePostageWeight/'+weight+'/', function(data) {
			$('#deletePostageButton').hide();
		});
	}
}

function showProductInfo(e){
	var productId=productsgrid.storedData[productsgrid.selectedId].id;
	$.getJSON('/duocms/products/getProductInfo/'+productId+'/', function(data) {
		var panel=document.getElementById('centerpanel')
		panel.className=panel.className.replace('midfullblock','midhalfblock');
		document.getElementById('centerpanel2').style.display='block';
		document.getElementById('userpanelTitle').innerHTML="Product Details";
		var html=' \
	<form id="userinfoform"> \
	<div style="display:block;" id="panel89" class="userinfo adminform">\
		<div class="col1ui">\
			<dl>';
	var col=1;
	var i=0;
	for(row in data.info){
		html+='<dt>'+row+'</dt><dd><input type="text" id="'+row+'" name="'+row+'" value="'+data.info[row]+'" /></dd>';
		if(col==1 && i>5){
			html+='</div><div class="col2ui">';
			col++;
		}
		i++;
	}	
	html+='\
		</div>\
	</div>\
	<div class="bottomtools">\
		<div class="bluebutton"><a href="javascript:saveProductInfo();" title="save product information">save</a></div>\
		<div class="bluebutton"><a href="javascript:closeUserPanel();" title="close panel">close</a></div>\
	</div>\
	</form>';
	$('#detailsBlock').html(html);
	});

}

function saveProductInfo(){
	var postData=$('#userinfoform').serialize();
	$.post('/duocms/products/saveProductInfo/',postData,function(data){
		alert(data.error);
	},'json');
	
}


/*--------------------------------------------------------------------------------
  Advertising Functions
--------------------------------------------------------------------------------*/
var ad_selectedPage='';
var ad_selected;

function ad_addAdvertisement(){
	document.getElementById('adinfoform').reset();
	document.getElementById('ad_assignlist').innerHTML='';
	document.getElementById('ad_user_id').value='';
	document.getElementById('ad_id').value='';
	var compComplete=new duoAutoComplete(document.getElementById('ad_company'),'/duocms/ad_manager/getCompanys/','compSuggest','ad_user_id');
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	document.getElementById('userpanelTitle').innerHTML="Advertisement Details";
	loadedAdData='';
	pageListId='adpages';
	pathAddressBar='adpath';
	loadPageList('0');//list files called from filelist.js
	ad_loadBannerOptions(document.getElementById('ad_type'));
}

function ad_deleteAdvertisement(){
	//get selected from list,
	if(ad_selected){
		//send to server
		if(!confirm('are you sure you want to delete the selected advertisment?')){return;}
		var myConn = new XHConn();
		if (myConn){
			oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
			document.getElementById('statusbar').innerHTML='Deleting Advertisement Data';
			myConn.connect("/duocms/ad_manager/deleteAdData/"+ad_selected+"/", "POST",'', res_saveAdInfo);
		}	
	}else{
		alert('please select an advertisment to delete');
	}
}

function ad_deleteAdvertisement_res(data){
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;	
	window.location.href="/duocms/ad_manager/";//reset panels with page refresh
}

function showAdInfo(e){
	if(browser=="ie"){var item=window.event.srcElement;}else{var item=e.target;}
	var safecount=0;
	while((item.tagName!="TR" && item.className!="dgrow")  && safecount<10){
		item=item.parentNode;	
		safecount++;	
	}	
	if(safecount<10){
		//item.className='active';
		var rowid=item.id.replace('rowid','');
		ad_selected=adgrid.storedData[rowid].id
		var myConn = new XHConn();
		if (myConn){
			oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
			document.getElementById('statusbar').innerHTML='Loading Advertisement Data';
			myConn.connect("/duocms/ad_manager/getAdData/"+ad_selected, "POST", "", res_showAdInfo);
		}
		
		var myConn2 = new XHConn();
		if (myConn2){
			myConn2.connect("/duocms/ad_manager/monthTotals/"+ad_selected, "POST", "", res_showAdStats);
		}
		
	}
	var panel=document.getElementById('centerpanel')
	panel.className=panel.className.replace('midfullblock','midhalfblock');
	document.getElementById('centerpanel2').style.display='block';
	document.getElementById('userpanelTitle').innerHTML="Advertisement Details";
}

function res_showAdInfo(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(data && data.info){
		document.getElementById('adinfoform').reset();//clear all, esp checkboxes
		document.getElementById('ad_user_id').value='';
		document.getElementById('ad_id').value='';
		var Data=data.info;
		loadedAdData=Data;	
		for (var Row in Data){
			if(document.getElementById('ad_'+Row) && Row!="password"){
				if(document.getElementById('ad_'+Row).type=="checkbox" && Data[Row]=="1"){
					document.getElementById('ad_'+Row).checked=true;
				}else{
					document.getElementById('ad_'+Row).value=Data[Row];	
				}
			}			
		}
		document.getElementById('ad_assignlist').innerHTML='';
		if(Data.pages){
			Data=Data.pages;
			for (var Row in Data){
				if(Data[Row].title){
					ad_AddtoList(Data[Row].title,Data[Row].page_id,Data[Row].inherit);
				}
			}			
		}
	}
	ad_loadBannerOptions(document.getElementById('ad_type'));
	pageListId='adpages';
	pathAddressBar='adpath';
	loadPageList('0');//list files called from filelist.js
	document.getElementById('statusbar').innerHTML=	oldStatusBarMessage;
	var compComplete=new duoAutoComplete(document.getElementById('ad_company'),'/duocms/ad_manager/getCompanys/','compSuggest','ad_user_id');
}

function res_showAdStats(data){
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	if(data && data.info){
		var Data=data.info;
		var graphbar='';
		for (var Row in Data){
			if(document.getElementById(('adstats_'+Row))){
				graphbar=document.getElementById('adstats_'+Row);
				if(Data[Row]!='0'){					
					graphbar.style.height=((Data[Row]/Data['highest']*90)+1)+"%";				
				}else{
					graphbar.style.height="1%";	
				}
				graphbar.innerHTML=	Data[Row];
			}
		}	
	}	
}

function pageListSetup(pageListId,data){//called by loadPageList_res in filelist.js
	pageListData=data.info;
	//reorder alphabetically for image list
	if(pageListId=='pagelist'){		
		listPages(pageListId,pageListData,'ad_highLightSelected','loadPageListBannerUpload');//id,data,singleClick,doubleClick	
	}else{
		listPages(pageListId,pageListData,'ad_highLightSelected','loadPageListBannerSelect');//id,data,singleClick,doubleClick	
	}
}

function ad_highLightSelected(elem,id,e){
	if(document.getElementById('ad_page_selected')){
		var selected=document.getElementById('ad_page_selected');
		selected.removeAttribute('id');
	}
	elem.id='ad_page_selected';	
	ad_selectedPage=id;
}

function ad_Add(){
	if(document.getElementById('ad_page_selected') && document.getElementById('ad_assignlist')){
		var selected=document.getElementById('ad_page_selected');
		ad_AddtoList(selected.innerHTML,ad_selectedPage);
	}
}

function ad_AddtoList(title,id,tick){
	if(tick=="1"){var checked="checked";}else{var checked="";}
	var list=document.getElementById('ad_assignlist');
	var count=list.getElementsByTagName('DIV').length;
	if(count/2!=Math.round(count/2)){
		list.innerHTML+="<div onclick='ad_hightlight(this)' class='odd'><input type='hidden' value='"+id+"' /><input type='checkbox' "+checked+" /> "+title+"</div>";
	}else{
		list.innerHTML+="<div onclick='ad_hightlight(this)' ><input type='hidden' value='"+id+"' /><input type='checkbox' "+checked+" /> "+title+"</div>";
	}	
}

function ad_Remove(){
	if(document.getElementById('ad_ad_selected')){
		var selected=document.getElementById('ad_ad_selected');
		selected.parentNode.removeChild(selected);
	}
}

function ad_hightlight(elem){
	if(document.getElementById('ad_ad_selected')){
		var selected=document.getElementById('ad_ad_selected');
		selected.removeAttribute('id');
	}
	elem.id='ad_ad_selected';	
}

function ad_loadBannerOptions(elem){
	var chosen=elem.value;
	var myConn = new XHConn();
	if (myConn){
		document.getElementById('statusbar').innerHTML='Loading Banner Options';
		myConn.connect("/duocms/ad_manager/loadBannerFileList/"+chosen+"/", "POST",'', ad_loadBannerOptions_res);
	}
}

function ad_loadBannerOptions_res(data){
	//once loaded, populate file choice drop down
	var data=eval('('+data.responseText+')');
	if(data && data.error){	
		alert(data.error);
		return;
	}
	var select=document.getElementById('ad_filename');
		//clear options
		for (i = select.length; i>=0; i--) {
			select.remove(i);
	}
	if(data && data.info){
		var Data=data.info;	

		//add new ones	
		var lastpathbit='';	
		for (var Row in Data){
			if(Data[Row]['path']){
	    		elOptNew = document.createElement('option');
	    		lastpathbit=Data[Row]['path'].match(/\/([^/]*)\/$/i);
	    		elOptNew.text = lastpathbit[1];
	    		elOptNew.value = Data[Row]['path'];
	    		select.options[select.options.length]= elOptNew;
			}			
		}
	}
	//need to highlight selected one, if there is one
		if(loadedAdData){
		var Data=loadedAdData;
		for (var Row in Data){
			if(document.getElementById('ad_'+Row) && 'ad_'+Row=='ad_filename'){
				document.getElementById('ad_'+Row).value=Data[Row];	
			}			
		}
	}
}

function saveAdInfo(){
	//get ad details
	if(document.getElementById('ad_user_id').value==''){
		alert('A valid advertiser has not been assigned.\nPlease add an advertiser in the advertiser field which appears in the drop down.\nIf the correct advertiser does not appear please add them to the user management system');
		return;
	}	
	var savingData="&"+buildPOST('adinfoform',document);
	//get pages to put ad on
	var list=document.getElementById('ad_assignlist');
	var inputs=list.getElementsByTagName('INPUT');
	var qstring='';
	var counter=0;
	for(i=0;i<inputs.length;i++){
		qstring+="&p"+counter+"="+inputs[i].value;
		if(inputs[i+1].checked){
			qstring+=",1";
		}else{
			qstring+=",0";
		}
		i++;//double step as there are two inputs per line	
		counter++;	
	}
	savingData+=qstring;	
	var myConn = new XHConn();
	if (myConn){
		oldStatusBarMessage=document.getElementById('statusbar').innerHTML;
		document.getElementById('statusbar').innerHTML='Saving Advertisement Data';
		myConn.connect("/duocms/ad_manager/setAdData/", "POST",savingData, res_saveAdInfo);
	}
}

function res_saveAdInfo(data){
	//alert(data.responseText);
	document.getElementById('statusbar').innerHTML=oldStatusBarMessage;	
	var fields = {"ads|id": 0,"users|company": 1,  "ads|startdate": 1, "ads|enddate": 1, "ads|type": 1};	
	var headers=new Array("company","start date","end date","type");
	adgrid=new duoDataGrid('adList','ad_manager','showAdInfo(e)','highlightLine(e)','unhighlightLine(e)',fields,headers,'','adgrid');	
}

function ad_preview(){
	//get page to preview
	var list=document.getElementById('ad_assignlist');
	var inputs=list.getElementsByTagName('INPUT');	
	if(inputs.length<1){
		alert('please add a page to the list of pages the advertisment will appear on');
		return;
	}
	var adpath=document.getElementById('ad_filename').value;
	var ad_type=document.getElementById('ad_type').value;	
	window.open('/duocms/ad_manager/preview/'+inputs[0].value+'/'+ad_type+'/'+(adpath.replace(/\//g,'|'))+'/');
}

function loadPageListBannerUpload(pageid){
	pageListId='pagelist';
	pathAddressBar='pagelist';
	loadPageList(pageid);
}

function loadPageListBannerSelect(pageid){
	pageListId='adpages';
	pathAddressBar='adpath';
	loadPageList(pageid);
}


function duoTestSetup(){
	var panel=document.getElementById('duoClientSetup');
	var browser=duoTestBrowser();
	var flver=getFlashVersion();
	var html='<p align="center">';
	html+=browser[0]+" "+browser[1]+" - ";
	html+="Flash "+flver+"<br></p>";
	
	if(parseInt(flver)<9){
		html+='<p style="color:red">You need flash version 9 or above to use certain features of the CMS. <a href="http://get.adobe.com/flashplayer/" target="_blank">Click here to install</a></p>';	
	}
	if(browser[0]=="Safari" && parseInt(browser[1])<3){
		html+='<p style="color:red">You need Safari version 3 or above to use certain features of the CMS. <a href="http://www.apple.com/downloads/" target="_blank">Click here to upgrade</a></p>';	
	}
	if(browser[0]=="Firefox" && parseInt(browser[1])<3){
		html+='<p style="color:red">You need Firefox version 3 or above to use certain features of the CMS. <a href="http://www.mozilla-europe.org/en/firefox/" target="_blank">Click here to upgrade</a></p>';	
	}
	if(browser[0]=="Internet Explorer" && parseInt(browser[1])<7){
		html+='<p style="color:red">You need Internet Explorer version 7 or above to use certain features of the CMS. <a href="http://www.microsoft.com/downloads/" target="_blank">Click here to upgrade</a></p>';	
	}
	if(browser[0]=="unknown"){
		html+='<p style="color:red">The browser you are using is unknown. Duo CMS is compatible with IE 7/8+, Firefox 3+, Safari 3/4+. If you are not using one these browsers please upgrade.</p>';	
	}
	
	panel.innerHTML=html;
}

function duoTestBrowser(){
	var userAgent=navigator.userAgent.toLowerCase();
	var version;
	if (userAgent.indexOf("firefox") != -1){
		version=userAgent.match(/firefox\/([0-9.]*)/);
		return new Array('Firefox',version[1]);
	}
	if (userAgent.indexOf("safari") != -1){
		version=userAgent.match(/version\/([0-9.]*)/);
		if(!version){
			version=new Array('0','0');
		}
		return new Array('Safari',version[1]);
	}
	if (userAgent.indexOf("msie") != -1){
		version=userAgent.match(/msie ([0-9.]*);/);
		return new Array('Internet Explorer',version[1]);
	}
	return new Array('unknown','');
}