// set filter flyouts to 0 (closed)
var adSearchTabState = 0;
var adTypeTabState = 0;
var adCountryTabState = 0;
var adLegisTabState = 0;
var cntry_arr = new Array();
var global_info = 0;
var global_doccnt = 0;
var global_sec = '';
var global_subsec = '';
var global_document = "";

//Global array for Reports
var global_DocItems;
//Global array for news
var global_NewsItems = "";
//Global array for events
var global_EventItems = "";
var cntry_arr = new Array();
var sectionx = new Array();

var fileSelected = 0;
var currFileName = "";

//Counter for Email Preview anchors
var emailPreviewNewsCounter = 0;
var emailPreviewEventsCounter = 0;

function fileState(inp) {
	fileSelected = inp;
}

/*$(function() {
	$( "#txtSubscStartDate" ).datepicker();
});*/
function popAWidget(){
	//alert("popAWidget");
	tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
	var curr_location = document.location.href;
	
	var wga_struct ="";
	//General Setup
	wga_struct +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div><div id='type' class='wg_filter'><div id='type_title' class='wg_ftitle'><span class='sp_left'>Type</span></span></div><div id='type_content' class='wg_fcontent'>Reports, News, Events</div><div id='type_info' class='wg_slidebar'><span class='sp_chkbx_type'><a id='lnkReports' href='javascript:adtoggleTick(4,\"type\",\"imgReports\",document.getElementById(\"imgReports\").src)'><img id='imgReports' name='imgReports' src='http://www.perchards.com/images/wid_checked.gif'/></a> Reports</span><span class='sp_chkbx_type'><a id='lnkNews' href='javascript:adtoggleTick(4,\"type\",\"imgNews\",document.getElementById(\"imgNews\").src)'><img id='imgNews' name='imgNews' src='http://www.perchards.com/images/wid_checked.gif'/></a> News</span><span class='sp_chkbx_type'><a id='lnkEvents' href='javascript:adtoggleTick(4,\"type\",\"imgEvents\",document.getElementById(\"imgEvents\").src)'><img id='imgEvents' name='imgEvents' src='http://www.perchards.com/images/wid_checked.gif'/></a> Events</span><span class='sp_chkbx_type'><a id='lnkSitePages' href='javascript:adtoggleTick(4,\"type\",\"imgSitePages\",document.getElementById(\"imgSitePages\").src)'><img id='imgSitePages' name='imgSitePages' src='http://www.perchards.com/images/wid_unchecked.gif'/></a> Site Pages</span><div id='typeButton' class='disableUpdate'>Update</div></div></div>";
	wga_struct +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct +="<div id='wg_rights'><div id='dispReports' class='wg_Display'><div id='ttleReports' class='dispTitle'>Reports</div><div id='rptContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div><div style='clear:both'>&nbsp;</div></div><div id='dispNews' class='wg_Display'><div id='ttleNews' class='dispTitle'>News<span class='dpView' style='display:none'>View <select id='selNews' onchange='ArchiveItems(\"News\");'><option value='All'>All Results</option><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last 12 Months</option></select></span></div><div id='nwsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div><div style='clear:both'>&nbsp;</div></div><div id='dispEvents' class='wg_Display'><div id='ttleEvents' class='dispTitle'>Events<span class='dpView' style='display:block'>View <select id='selEvent' onchange='ArchiveItems(\"Events\");'><option value='All'>All Results</option><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last Twelve Months</option></select></span></div><div id='evntsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div><div style='clear:both'>&nbsp;</div></div><div style='clear:both'>&nbsp;</div></div><div style='clear:both'>&nbsp;</div></div>";
	//News Setup
	var wga_struct_news = "";
	wga_struct_news +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct_news +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div>";
	wga_struct_news +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct_news +="<div id='wg_right'><div id='dispNews' class='wg_Display'><div id='ttleNews' class='dispTitle'>News<span id='dpView'>View <select><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last 12 Months</option><option value='All'>All Results</option></select></span></div><div id='nwsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div></div>";
	//Events Setup
	var wga_struct_events = "";
	wga_struct_events +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct_events +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div>";
	wga_struct_events +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct_events +="<div id='wg_rights'><div id='dispEvents' class='wg_Display'><div id='ttleEvents' class='dispTitle'>Events<span class='dpView' style='display:block'>View <select id='selEvent' onchange='ArchiveItems(\"Events\");'><option value='All'>All Results</option><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last Twelve Months</option></select></span></div><div id='evntsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div></div>";
	
	//LOAD THE WIDGET
	if (curr_location.indexOf("www.perchards.com") != -1 )
	{
		$("div.adminwidget").html(wga_struct);
	}else if (curr_location.indexOf("www.perchards.com") != -1 ){
		$("#general").html(wga_struct);
		$("#news").html(wga_struct_news);
		$("#events").html(wga_struct_events);
	}else if (curr_location.indexOf("www.perchards.com") != -1 ){
		$("div.adminwidget").html(wga_struct);
	}else if (curr_location.indexOf("www.perchards.com") != -1 ){
		$("div.adminwidget").html(wga_struct);
	}else{
		$("div.adminwidget").html("<div id='warning'>Invalid web location. This widget is not licenced for this client site.</div>");
	}
	adloadLegislation();
	adloadCountries();
	
	/*$('#legis_title').hover(function() {
		//close tabs
		adclosetabs();
		//Slide open legislation
		$('#legis').animate({
		    width: "453px"
		  }, 150 );
		$('#legis_content').animate({
		    width: "153px"
		  }, 150 );
		$('#legis_info').css('display','block');
		},
		function () {
		}
	);
	
	$('#cntry_title').hover(function() {
		//close tabs
		adclosetabs();
		//Slide open Country
		$('#cntry').animate({
		    width: "563px"
		  }, 100 );
		$('#cntry_content').animate({
		    width: "153px"
		  }, 100 );
		$('#cntry_info').css('display','block');
		},
		function () {
		}
	);
	
	$('#type_title').hover(function() {
		//close tabs
		adclosetabs();
		//Slide open Type
		$('#type').animate({
		    width: "353px"
		  }, 100 );
		$('#type_content').animate({
		    width: "153px"
		  }, 100 );
		$('#type_info').css('display','block');
		},
		function () {
		}
	);
	
	$('#srch_title').hover(function() {
		//close tabs
		adclosetabs();
		//Slide open Search
		$('#srch').animate({
		    width: "503px"
		  }, 100 );
		$('#srch_content').animate({
		    width: "153px"
		  }, 100 );
		$('#srch_info').css('display','block');
		},
		function () {
		}
	);
	/*$('.dbwidget').click(function(){
		adclosetabs();
	});*/
	/*$('#srch_submit').click(function(){
			adclosetabs();
		});
	$('#wg_rights').mouseover(function(){
			adclosetabs();
		});*/
	$('#legis_title').click(function() {
		//alert("legis filter");
		if (adLegisTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open legislation
			$('#legis').animate({
				width: "453px"
			  }, 150 );
			$('#legis_content').animate({
				width: "153px"
			  }, 150 );
			$('#legis_info').css('display','block');
			adLegisTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#cntry_title').click(function() {
		//alert("country filter");
		if (adCountryTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Country
			$('#cntry').animate({
				width: "605px"
			  }, 100 );
			$('#cntry_content').animate({
				width: "153px"
			  }, 100 );
			$('#cntry_info').css('display','block');
			adCountryTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#type_title').click(function() {
		//alert("type filter");
		if (adTypeTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Type
			$('#type').animate({
				//width: "353px"
				width: "413px"
			  }, 100 );
			$('#type_content').animate({
				width: "153px"
			  }, 100 );
			$('#type_info').css('display','block');
			adTypeTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#srch_title').click(function() {
		//alert("srch filter");
		if (adSearchTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Search
			$('#srch').animate({
				width: "503px"
			  }, 100 );
			$('#srch_content').animate({
				width: "153px"
			  }, 100 );
			$('#srch_info').css('display','block');
			adSearchTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#srch_submit').click(function(){
			adclosetabs();
	});
	$('#wg_rights').mouseover(function(){
			adclosetabs();
	});
		
	adcallSearch();
}

function popHalfWidget(){
	//alert("popHalfWidget");
	var curr_location = document.location.href;
	
	var wga_struct ="";
	//General Setup
	wga_struct +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div><div id='type' class='wg_filter'><div id='type_title' class='wg_ftitle'><span class='sp_left'>Type</span></span></div><div id='type_content' class='wg_fcontent'>Reports, News, Events</div><div id='type_info' class='wg_slidebar'><span class='sp_chkbx_type'><a id='lnkReports' href='javascript:adtoggleTick(4,\"type\",\"imgReports\",document.getElementById(\"imgReports\").src)'><img id='imgReports' name='imgReports' src='http://www.perchards.com/images/wid_checked.gif'/></a> Reports</span><span class='sp_chkbx_type'><a id='lnkNews' href='javascript:adtoggleTick(4,\"type\",\"imgNews\",document.getElementById(\"imgNews\").src)'><img id='imgNews' name='imgNews' src='http://www.perchards.com/images/wid_checked.gif'/></a> News</span><span class='sp_chkbx_type'><a id='lnkEvents' href='javascript:adtoggleTick(4,\"type\",\"imgEvents\",document.getElementById(\"imgEvents\").src)'><img id='imgEvents' name='imgEvents' src='http://www.perchards.com/images/wid_checked.gif'/></a> Events</span><span class='sp_chkbx_type'><a id='lnkSitePages' href='javascript:adtoggleTick(4,\"type\",\"imgSitePages\",document.getElementById(\"imgSitePages\").src)'><img id='imgSitePages' name='imgSitePages' src='http://www.perchards.com/images/wid_unchecked.gif'/></a> Site Pages</span><div id='typeButton' class='disableUpdate'>Update</div></div></div>";
	wga_struct +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct +="<div id='wg_rights'><div id='dispReports' class='wg_Display'><div id='ttleReports' class='dispTitle'>Reports</div><div id='rptContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div><div style='clear:both'>&nbsp;</div><div id='dispNews' class='wg_Display'><div id='ttleNews' class='dispTitle'>News<span class='dpView' style='display:none'>View <select id='selNews' onchange='ArchiveItems(\"News\");'><option value='All'>All Results</option><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last 12 Months</option></select></span></div><div id='nwsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div><div id='dispEvents' class='wg_Display'><div id='ttleEvents' class='dispTitle'>Events<span class='dpView' style='display:block'>View <select id='selEvent' onchange='ArchiveItems(\"Events\");'><option value='All'>All Results</option><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last Twelve Months</option></select></span></div><div id='evntsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div></div></div>";
	//News Setup
	var wga_struct_news = "";
	wga_struct_news +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct_news +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div>";
	wga_struct_news +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct_news +="<div id='wg_right'><div id='dispNews' class='wg_Display'><div id='ttleNews' class='dispTitle'>News<span id='dpView'>View <select><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last 12 Months</option><option value='All'>All Results</option></select></span></div><div id='nwsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div></div>";
	//Events Setup
	var wga_struct_events = "";
	wga_struct_events +="<div id='wg_leftunders'></div><div id='wg_lefts'><div class='wg_header'> Apply Filters:";
	wga_struct_events +="</div><div id='legis' class='wg_filter'><div id='legis_title' class='wg_ftitle'><span class='sp_left'>Legislation</span></div><div id='legis_content' class='wg_fcontent'>All</div><div id='legis_info' class='wg_slidebar'></div></div><div id='cntry' class='wg_filter'><div id ='cntry_title' class='wg_ftitle'><span class='sp_left'>Country</span></div><div id='cntry_content' class='wg_fcontent'>All</div><div id='cntry_info' class='wg_slidebar'></div></div>";
	wga_struct_events +="<div id='srch' class='wg_filter'><div id='srch_title' class='wg_ftitle'><span class='sp_left' >Search</span></div><div id='srch_content' class='wg_fcontent'>All</div><div id='srch_info' class='wg_slidebar'><input id='txt_srch' name='txt_srch' type='text' value=''><a href='javascript:selectTicks(\"srch\",1);adcallSearch();'><img src='http://www.perchards.com/images/wid_flyout_arrow.gif'/></a></input><span id='srchcmt'>Use quotation marks \"\" around the search term to search for an exact phrase </span></div></div></div>";
	wga_struct_events +="<div id='wg_rights'><div id='dispEvents' class='wg_Display'><div id='ttleEvents' class='dispTitle'>Events<span id='dpView'>View <select><option value='One'>Last 1 month</option><option value='Three'>Last 3 Months</option><option value='Twelve'>Last Twelve Months</option><option value='All'>All Results</option></select></span></div><div id='evntsContent' class='dispContent'>&nbsp;&nbsp;&nbsp;&nbsp;loading...</div></div></div>";
	
	//LOAD THE WIDGET
	if (curr_location.indexOf("www.perchards.com") != -1)
	{
		$("div.adminwidget").html(wga_struct);
	}else if (curr_location.indexOf("www.perchards.com") != -1){
		$("#general").html(wga_struct);
		$("#news").html(wga_struct_news);
		$("#events").html(wga_struct_events);
	}else if (curr_location.indexOf("www.perchards.com") != -1){
		$("div.adminwidget").html(wga_struct);
	}else if (curr_location.indexOf("www.perchards.com") != -1){
		$("div.adminwidget").html(wga_struct);
	}else{
		$("div.adminwidget").html("<div id='warning'>Invalid web location. This widget is not licenced for this client site.</div>");
	}
	adloadLegislation();
	adloadCountries();
	
	$('#legis_title').click(function() {
		if (adLegisTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open legislation
			$('#legis').animate({
				width: "453px"
			  }, 150 );
			$('#legis_content').animate({
				width: "153px"
			  }, 150 );
			$('#legis_info').css('display','block');
			adLegisTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#cntry_title').click(function() {
		if (adCountryTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Country
			$('#cntry').animate({
				//width: "563px"
				width: "605px"
			  }, 100 );
			$('#cntry_content').animate({
				width: "153px"
			  }, 100 );
			$('#cntry_info').css('display','block');
			adCountryTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#type_title').click(function() {
		if (adTypeTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Type
			$('#type').animate({
				//width: "353px"
				width: "413px"
			  }, 100 );
			$('#type_content').animate({
				width: "153px"
			  }, 100 );
			$('#type_info').css('display','block');
			adTypeTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	
	$('#srch_title').click(function() {
		if (adSearchTabState == 0){
			//close tabs
			adclosetabs();
			//Slide open Search
			$('#srch').animate({
				width: "503px"
			  }, 100 );
			$('#srch_content').animate({
				width: "153px"
			  }, 100 );
			$('#srch_info').css('display','block');
			adSearchTabState = 1;
		} else {
			adclosetabs();
		}	
	});
	/*$('.dbwidget').click(function(){
		adclosetabs();
	});*/
	$('#srch_submit').click(function(){
			adclosetabs();
		});
	$('#wg_rights').mouseover(function(){
			adclosetabs();
		});
}
function adclosetabs()
	{
		$('.wg_filter').animate({
		    width: "150px"
		  }, 150 );
		$('.wg_fcontent').animate({
		    width: "150px"
		  }, 150 );
		$('.wg_slidebar').css('display','none');	
		
		adSearchTabState = 0;
		adTypeTabState = 0;
		adCountryTabState = 0;
		adLegisTabState = 0;
	}
	function adloadCountries()
	{
		$.post("http://www.perchards.com/db_widget_src/getCountries.php", function(data) {
			var struct= "";
			   var params = data.split('@');
			   var paramslen = params.length -1;
			   for(i=0;i<paramslen;i++)
			   {
				   var c_id_names = params[i];
				   var c_names = c_id_names.split(',');
				   struct+="<span class='sp_chkbx_cntry'><a id='lnk"+c_names[1]+"' href='javascript:adtoggleTick("+paramslen+",\"cntry\",\"img"+c_names[1]+"\",document.getElementById(\"img"+c_names[1]+"\").src)'><img id='img"+c_names[1]+"' name='img"+c_names[1]+"' src='http://www.perchards.com/images/wid_checked.gif'/></a> "+c_names[1]+"</span>";  
			   }
			   struct += "<div id='bot_cntry'><a href='javascript:TickAll("+paramslen+");'> Select All</a><a href='javascript:unTickAll("+paramslen+");'>De-Select All</a></div>";
			   struct+="<div id='cntryButton' class='disableUpdate'>Update</div>";
			   $("#cntry_info").html(struct);
			   //Populate Countries
			   var imgArray = $('#cntry_info').find('img');
		cntry_arr = [];
			var cnt = 0;
			 $.each(imgArray,function(index,value)
			 {
				 if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
				 {
					 
				 }else{
					 var s_val = value.name;
					 cntry_arr[cnt] = s_val.replace("img"," ");
					 cnt++;
				 }
			 });
			 //alert(cntry_arr);
			 });
	}
	
	function adloadLegislation()
	{
		$.post("http://www.perchards.com/db_widget_src/getAdminLegis.php", function(data) {
			var struct= "";
			   var params = data.split(',');
			   var paramslen = params.length -1;
			   for(i=0;i<params.length-1;i++)
			   {
				   struct+="<span class='sp_chkbx_legis'><a id='lnk"+params[i]+"' href='javascript:adtoggleTick("+paramslen+",\"legis\",\"img"+params[i]+"\",document.getElementById(\"img"+params[i]+"\").src)'><img id='img"+params[i]+"' name='img"+params[i]+"' src='http://www.perchards.com/images/wid_checked.gif'/></a> "+params[i]+"</span>";  
			   }
			   struct+="<div id='legisButton' class='disableUpdate'>Update</div>";
			   $("#legis_info").html(struct);
			 });
	}
	function addatabaseAjaxSearch(legisArray,cntryArray,typeArray,srchWord)
	{
		$.post("http://www.perchards.com/db_widget_src/getSearchResults.php",{'legisArr[]':legisArray,'cntryArr[]':cntryArray,'typeArr[]':typeArray,'srch':srchWord},function(data){
				//alert(data);
				var grpArray = data.split("@");
				 $.each(grpArray,function(index,value)
				{
					 var sectArray = value.split(",");
					 var folderItems = "";
					 //Setup Image
					 var imageLink = "";
					 var sect = ""
					 if(sectArray[0] == 'r')
					 {
							imageLink = "http://www.perchards.com/images/wid_folder.gif";
							sect = "Reports";
							
					 }else if(sectArray[0] == 'n')
					 {
						 imageLink = "http://www.perchards.com/images/wid_news.gif";
						 sect = "News";
					 }else if(sectArray[0] == 'e')
					 {
						 imageLink = "http://www.perchards.com/images/wid_calendar.gif";
						 sect = "Events";
					 }
					 
					 for(r=1;r<sectArray.length-1;r++){
						  folderItems += "<div class='adDispFolder'><a href='javascript:addisplayItems(2,\""+sect+"\",\""+sect+"\",\""+legisArray[r-1]+"\")'><span class='imgFolder'><img src='"+imageLink+"'/></span><span class='textFolder'>"+legisArray[r-1]+"<br>"+sectArray[r]+"</span></a></div>";
					};
					folderItems += "<div style='clear:both'>&nbsp;</div>";
					if(sectArray[0] == 'r')
					{
						$('#rptContent').html(folderItems);
					}else if(sectArray[0] == 'n')
					{
						$('#nwsContent').html(folderItems);
					}else if(sectArray[0] == 'e')
					{
						$('#evntsContent').html(folderItems);
					}	 
				});
		});
		//$('.wg_Display').css('height','118px');
	}	
	function adtoggleTick(totItems,filterName,imageID,imageString)
	{
		if(imageString == 'http://www.perchards.com/images/wid_unchecked.gif')
		{
			document.getElementById(imageID).src = 'http://www.perchards.com/images/wid_checked.gif';
		}else
		{
			document.getElementById(imageID).src = 'http://www.perchards.com/images/wid_unchecked.gif';
		}
		adActivateUpdate();
		adselectTicks(filterName,totItems);
		//adcallSearch();
	}
	function adcallSearch()
	{
		var cntryArr = new Array();
		var legisArr = new Array();
		var typeArr = new Array();
		////Get Legislation Criteria
		var i = 0;
		var j = 0;
		var k = 0;
		var imgArrayL = $('#legis_info').find('img');
		var chck = 0;
		$.each(imgArrayL,function(index,value)
		{
			
			if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
			{
				//legisArr[i]= "";
				//var l = value.name
			}else
			{
				var l = value.name
				legisArr[i] = l.replace("img","");
				i++;
			}
		});
		//Check for none
		if($('#legis_content').html()== "None"){
			legisArr[0]= "none";
		}else{}
		//Get Country Crieteria
		var imgArrayC = $('#cntry_info').find('img');
		$.each(imgArrayC,function(index,value)
		{
			if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
			{
				cntryArr[j] = "";
			}else
			{
				var c = value.name
				cntryArr[j] =  c.replace("img","");
				j++;
			}
		});
		//Get Type Crieteria
		var imgArrayT = $('#type_info').find('img');
		$.each(imgArrayT,function(index,value)
		{
			if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
			{
				typeArr[k] = "";
				var t = value.name
				if(t == "imgReports")
				{
					$('#dispReports').hide();
				}else if(t == "imgEvents")
				{
					$('#dispEvents').hide();
				}else if(t == "imgNews")
				{
					$('#dispNews').hide();
				}else if(t == "imgSitePages")
				{
					$('#dispPages').hide();
				}else{}
				
			}else
			{
				var t = value.name
				
				if(t == "imgReports")
				{
					$('#dispReports').show();
					$('#ttleReports').html("<a href='javascript:popAWidget();'>Reports</a>");
				}else if(t == "imgEvents")
				{
					$('#dispEvents').show();
					$('#ttleEvents').html("Events");
				}else if(t == "imgNews")
				{
					$('#dispNews').show();
					$('#ttleNews').html("News");
				}else if(t == "imgSitePages")
				{
					$('#dispPages').show();
					$('#ttlePages').html("Site Pages");
				}else{}
				typeArr[k] =  t.replace("img","");
				k++;
			}
		});
		var srchWord;
		if($('#srch_content').html() == "All")
		{
			srchWord = "";
		}else
		{
			srchWord = $('#srch_content').html();
		}
		//For display on load of the widget
		if (legisArr[0] == null)
		{
			$.post("http://www.perchards.com/db_widget_src/getAdminLegis.php",function(data){
				var legArr = data.split(",");
				legArr.splice(legArr.length-1,1);
				addatabaseAjaxSearch(legArr,cntryArr,typeArr,srchWord)
			});
		}else{
			addatabaseAjaxSearch(legisArr,cntryArr,typeArr,srchWord)
		}
	}
	function adselectTicks(filter,totItems)
	{
		if(filter =='legis')
		{
			var cnt = 0;
			var imgArray = $('#legis_info').find('img');
			var legis_str ="";
			 $.each(imgArray,function(index,value)
			 {
				 if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
				 {
					 
				 }else{
					 cnt=cnt+1;
					 var s_val = value.name;
					 legis_str += s_val.replace("img"," ")+",";
				 }
			 });
			if(cnt==0)
			 {
				 $('#legis_content').html('None');
			 }else if(cnt<totItems)
			 {
				 var strArr = legis_str.split(",")
				 $('#legis_content').html(strArr[0]+" ...");
			 }else if(cnt==totItems)
			 {
				 $('#legis_content').html('All');
			 }else
			 {
				 
			 }
		}else if(filter =='cntry')
		{
			var cnt = 0;
			var imgArray = $('#cntry_info').find('img');
			var cntry_str ="";
			 $.each(imgArray,function(index,value)
			 {
				 if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
				 {
					 
				 }else{
					 cnt=cnt+1;
					 var s_val = value.name;
					 cntry_str += s_val.replace("img"," ") + ",";
				 }
			 });
			 if(cnt==0)
			 {
				 $('#cntry_content').html('None');
			 }else if(cnt<totItems)
			 {
				 var strArr = cntry_str.split(",")
				 $('#cntry_content').html(strArr[0]+", "+strArr[1]+" ...");
			 }else if(cnt==totItems)
			 {
				 $('#cntry_content').html('All');
			 }else
			 {
				 
			 }
		}else if (filter == 'type')
		{
			var cnt = 0;
			var imgArray = $('#type_info').find('img');
			var type_str ="";
			 $.each(imgArray,function(index,value)
			 {
				 if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
				 {
					 
				 }else{
					 cnt=cnt+1;
					 var s_val = value.name;
					 type_str += s_val.replace("img"," ") + ",";
				 }
			 });
			 if(cnt==0)
			 {
				 $('#type_content').html('None');
			 }else if(cnt<totItems)
			 {
				 var strArr = type_str.split(",")
				 $('#type_content').html(strArr[0]+", "+strArr[1]+" ...");
			 }else if(cnt==totItems)
			 {
				 $('#type_content').html('All');
			 }else
			 {
				 
			 }
		}else
		{
			if(document.getElementById('txt_srch').value == ""){
				$('#srch_content').html("All");
			}else{
				$('#srch_content').html(document.getElementById('txt_srch').value);
			}
		}
	}
	function adTickAll(totalItms)
	{
		var imgArray = $('#cntry_info').find('img');
		$.each(imgArray,function(index,value)
		{
			value.src = 'http://www.perchards.com/images/wid_checked.gif';
		});
		adselectTicks('cntry',totalItms);
		//adcallSearch();
	}
	function adunTickAll(totalItms)
	{
		var imgArray = $('#cntry_info').find('img');
		$.each(imgArray,function(index,value)
		{
					value.src = 'http://www.perchards.com/images/wid_unchecked.gif';
		});
		adselectTicks('cntry',totalItms);
		//adcallSearch();
	}
	function adBuildItemsList(Section,GroupStartNumber){
		
		if(Section == 'Report'){
			$('#rptContent').html("");
			var str = global_DocItems;
			//alert(str);
			docItmObject = JSON.parse(str);
		var doc_len = docItmObject.ReportItems.length;
		
		//alert(doc_len);
		var displayDocs = "<div class='dispTable'><table><tr><th></th><th>Country</th><th>Title</th><th>Updated</th></tr>";
		displayDocs += "<tr><td><img id='addimg' src='http://www.perchards.com/images/add-10x10.png' onclick='javascript:newReport(\""+ $('#ttleReports').text() +"\");'/></td><td colspan='3'><div id='adddoc' onclick='javascript:newReport(\""+ $('#ttleReports').text() +"\");'> Add New Report</div></td></tr>";
		for(lx=GroupStartNumber;lx<doc_len;lx++)
		{
			var LXdateStringArray = docItmObject.ReportItems[lx].DATE.split('-');
			var LXdateString = LXdateStringArray[2]+"/"+LXdateStringArray[1]+"/"+LXdateStringArray[0].substring(2)+"";
			if(docItmObject.ReportItems[lx].ACTIVE != 0)
					{
						imageLink = "<tr id='reportRow"+docItmObject.ReportItems[lx].ID+"'><td><img src='http://www.perchards.com/images/pdf_grey.gif'/></td><td>"+docItmObject.ReportItems[lx].COUNTRY+"</td><td><a href='javascript:editDocumentReport("+docItmObject.ReportItems[lx].ID+",\""+ $('#ttleReports').text() +"\");' title='Click to edit report'>"+docItmObject.ReportItems[lx].TITLE+"</a></td><td>"+LXdateString+"</td><td><a href='javascript:deleteThisDocument("+docItmObject.ReportItems[lx].ID+");' title='Click to delete report'>x</a></td></tr>";
						
					}else if(docItmObject.ReportItems[lx].ACTIVE != 1)
					{
						
							imageLink = "<tr id='reportRow"+docItmObject.ReportItems[lx].ID+"'><td><img src='http://www.perchards.com/images/pdf_red.gif'/></td><td>"+docItmObject.ReportItems[lx].COUNTRY+"</td><td><a href='javascript:editDocumentReport("+docItmObject.ReportItems[lx].ID+",\""+ $('#ttleReports').text() +"\");' title='Click to edit report'>"+docItmObject.ReportItems[lx].TITLE+"</a></td><td>"+LXdateString+"</td><td><a href='javascript:deleteThisDocument("+docItmObject.ReportItems[lx].ID+");' title='Click to delete report'>x</a></td></tr>";
							
					}else{
			
							imageLink = "<tr id='reportRow"+docItmObject.ReportItems[lx].ID+"' onclick='javascript:OpenDocumentView(0);'><td><img src='http://www.perchards.com/images/pdf_grey.gif'/></td><td>"+docItmObject.ReportItems[lx].COUNTRY+"</td><td><a href='javascript:editDocumentReport("+docItmObject.ReportItems[lx].ID+",\""+ $('#ttleReports').text() +"\");' title='Click to edit report'>"+docItmObject.ReportItems[lx].TITLE+"</a></td><td>"+LXdateString+"</td><td><a href='javascript:deleteThisDocument("+docItmObject.ReportItems[lx].ID+");' title='Click to delete report'>x</a></td></tr>";
					}
			
			if(lx<GroupStartNumber+15){	
			displayDocs+=imageLink;
				
			}
		}
		var links = "</table><div style='width:200px' class='list_paging'>";
		var t = 0;
		var u = 1;
		for(lx=0;lx<=doc_len-1;lx++)
		{
			if(lx == t){
				//alert(GroupStartNumber+","+t)
				if(GroupStartNumber == t){
					links += "<a href='javascript:adBuildItemsList(\"Report\","+t+")' class='list_paging_at'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
					//alert(t);
				}else{
					links += "<a href='javascript:adBuildItemsList(\"Report\","+t+")'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
				}
				t=t+15;
				u++;
			}
			
		}
		links +="</div>";
		displayDocs += links;
		displayDocs += "<div style='clear:both'>&nbsp;</div></div><div style='clear:both'>&nbsp;</div>";
		$('#rptContent').css('height','550px');
		$('#rptContent').html(displayDocs);
		}else if(Section == "News"){
			//alert("News [747]");
			$('#nwsContent').html("");
			var str = global_NewsItems;
			//alert(str);
			nwsItmObject = JSON.parse(str);
			//alert(nwsItmObject);
		var nw_len = nwsItmObject.NewsItems.length;
		//alert(nw_len);
		//alert(nwsItmString);
		//alert(clnt);
		/*var displayNews = "<table><tr><td>Title</td><td>Country</td><td>Date</td><td></td></tr><tr><td colspan='4'><img id='addimgNews' src='http://www.perchards.com/images/add-10x10.png' onclick='javascript:newNews(\""+ $('#ttleNews').text() +"\");'/> Add News</td></tr>";
						 var newsArray = data.split('@');
						 for(z=0;z<newsArray.length-1;z++){
							 var newsItemArray = newsArray[z].split('$');
							 var timestamp = newsItemArray[3].split(' ');
							 var date = timestamp[0];
							 displayNews+="<tr><td><a href='javascript:editNews("+newsItemArray[0]+",\""+ $('#ttleNews').text() +"\");' title='Click to edit news details'><img src='http://www.perchards.com/images/news_blue.gif'/></a> "+newsItemArray[1]+"</td><td>"+newsItemArray[4]+"</td><td>"+date+"</td></tr>";
						 }
						 displayNews+="</table>";
						 $('.wg_Display').css('height','400px');
						$('#nwsContent').html(displayNews);	
						$('#inpSection').val(rfilter);
						$('#dpView').show();*/
		var displayNews = "<table><tr><th colspan='3'>Title</th><th>Country</th><th width='50'>Date</th><th></th></tr>";
		displayNews+= "<tr><td colspan='6'><img id='addimgNews' src='http://www.perchards.com/images/add-10x10.png' onclick='javascript:newNews(\""+ $('#ttleNews').text() +"\");'/> Add News</td></tr>";
		for(lx=GroupStartNumber;lx<nw_len;lx++)
		{
			var strdNws = "";
			//alert(nwsItmObject.NewsItems[lx].PRVTE+","+document.getElementById('inClientID'));
			
				 strdNws = "<a href='javascript:editNews("+nwsItmObject.NewsItems[lx].ID+",\""+ $('#ttleNews').text() +"\");' title='Click to edit news details'><img src='http://www.perchards.com/images/news_blue.gif'/></a> "+nwsItmObject.NewsItems[lx].TITLE;
			
			var LXdateStringArray = nwsItmObject.NewsItems[lx].DATE.split('-');
			var LXdateString = LXdateStringArray[2]+"/"+LXdateStringArray[1]+"/"+LXdateStringArray[0].substring(2)+"";
			if(lx<GroupStartNumber+10){	
			//displayNews+="<tr id='newsRow"+nwsItmObject.NewsItems[lx].ID+"'><td>"+strdNws+"</td><td>"+nwsItmObject.NewsItems[lx].COUNTRY+"</td><td>"+LXdateString+"</td><td><a href='javascript:deleteThisNews("+nwsItmObject.NewsItems[lx].ID+");' title='Click to delete article'>x</a></td></tr>";
			
			displayNews+="<tr id='newsRow"+nwsItmObject.NewsItems[lx].ID+"' valign='top'><td valign='top'><a href='javascript:editNews("+nwsItmObject.NewsItems[lx].ID+",\""+ $('#ttleNews').text() +"\");' title='Click to edit news details'><img src='http://www.perchards.com/images/news_blue.gif'/></a></td><td valign='top'>"+nwsItmObject.NewsItems[lx].ID+"</td><td valign='top'>"+nwsItmObject.NewsItems[lx].TITLE+"</td><td valign='top'>"+nwsItmObject.NewsItems[lx].COUNTRY+"</td><td valign='top'>"+LXdateString+"</td><td valign='top'><a href='javascript:deleteThisNews("+nwsItmObject.NewsItems[lx].ID+");' title='Click to delete article'>x</a></td></tr>";
			}
		}
		var links = "</table><div style='width:200px;margin-left:5px' class='list_paging'>";
		var t = 0;
		var u = 1;
		for(lx=0;lx<=nw_len-1;lx++)
		{
			
			if(lx == t){
				if(GroupStartNumber == t){
					links += "<a href='javascript:adBuildItemsList(\"News\","+t+")' class='list_paging_at'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
				}else{
				links += "<a href='javascript:adBuildItemsList(\"News\","+t+")'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
				}
				t=t+10;
				u++;
			}
			
		}
		links +="</div><div style='clear:both'>&nbsp;</div>";
		displayNews += links;
	
		$('#nwsContent').html(displayNews);
		}else {
			$('#evntsContent').html("");
			var str = global_EventItems;
			evntsItmObject = JSON.parse(str);
		var evnt_len = evntsItmObject.EventItems.length;
		//alert(nwsItmString);
		var displayEvents = "<table><tr><th>Title</th><th>Country</th><th>Date</th><th></th></tr>";
		for(lx=GroupStartNumber;lx<evnt_len;lx++)
		{
			var LXdateStringArray = evntsItmObject.EventItems[lx].DATE.split('-');
			var LXdateString = LXdateStringArray[2]+"/"+LXdateStringArray[1]+"/"+LXdateStringArray[0].substring(2)+"";
			if(lx<GroupStartNumber+10){	
			displayEvents+="<tr id='eventRow"+evntsItmObject.EventItems[lx].ID+"'><td><a href='javascript:addisplayItems(3,\"Events\",\""+evntsItmObject.EventItems[lx].TITLE+"\",\""+evntsItmObject.EventItems[lx].CONTENT+"\");' title='Click to read News Details'><img src='http://www.perchards.com/images/news_blue.gif'/></a> "+evntsItmObject.EventItems[lx].TITLE+"</td><td>"+evntsItmObject.EventItems[lx].COUNTRY+"</td><td>"+LXdateString+"</td><td><a href='javascript:deleteThisEvent("+evntsItmObject.EventItems[lx].ID+");' title='Click to delete article'>x</a></td></tr>";
			}
		}
		var links = "</table><div style='width:200px;margin-left:5px' class='list_paging'>";
		var t = 0;
		var u = 1;
		for(lx=0;lx<=evnt_len-1;lx++)
		{
			
			if(lx == t){
				if(GroupStartNumber == t){
					links += "<a href='javascript:adBuildItemsList(\"Events\","+t+")' class='list_paging_at'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
				}else{
				links += "<a href='javascript:adBuildItemsList(\"Events\","+t+")'>"+u+"</a>&nbsp;&nbsp;&nbsp;";
				}
				t=t+10;
				u++;
			}
			
		}
		links +="</div>";
		displayEvents += links;
	
		$('#evntsContent').html(displayEvents);
		}
		
	}
	function addisplayItems(level,section,lvlname,rfilter,DocCount)
	{
		//alert("ln 870 : displayItems / DocCount = "+DocCount+", level:"+level+", section:"+section+", lvlname:"+lvlname+", rfilter:"+rfilter);
		
		//$('#loadingOverlay').css('display','block');
		//alert("display items");
		var imgArray = $('#cntry_info').find('img');
		//var cntry_arr = new Array();
		cntry_arr = [];
		var cnt = 0;
		$.each(imgArray,function(index,value)
		{
			if(value.src == 'http://www.perchards.com/images/wid_unchecked.gif')
			{
			 
			}else{
				var s_val = value.name;
				cntry_arr[cnt] = s_val.replace("img","");
				cnt++;
			}
		 });
			 
		if(section == "Reports")
		{
			$('#dispReports').show();
			$('#dispNews').hide();
			$('#dispEvents').hide();
			$('#dispPages').hide();
			$('.wg_Display').css('min-height','200px');
			if(level == 2){
				var arrString = $('#ttleReports').text().split('>');
				if(arrString[1] == undefined){
				$('#ttleReports').html("<a href='javascript:popAWidget();'>"+$('#ttleReports').html() +"</a> > "+ "<a href='javascript:addisplayItems("+level+",\""+section+"\",\""+lvlname+"\",\""+rfilter+"\");'>"+rfilter+"</a>");
				}else{
					$('#ttleReports').html("<a href='javascript:popAWidget();'>"+arrString[0] +"</a> >  <a href='javascript:addisplayItems("+level+",\""+section+"\",\""+lvlname+"\",\""+rfilter+"\");'>"+ arrString[1]+"</a>");
				}
			}else if(level == 3){
				
				var arrString = $('#ttleReports').text().split('>');
				if(arrString[2] == undefined){
					$('#ttleReports').html("<a href='javascript:popAWidget();'>"+$('#ttleReports').html() +"</a> > "+ "<a href='javascript:addisplayItems("+level+",\""+section+"\",\""+lvlname+"\",\""+rfilter+"\");'>"+rfilter+"</a>");
				}else{
				}
			}
		}else if(section == "News")
		{
			//alert(rfilter);
			$('#dispReports').hide();
			$('#dispNews').show();
			$('#dispEvents').hide();
			$('#dispPages').hide();
			$('.wg_Display').css('min-height','200px');
			//$('#ttleNews').html("<a href='javascript:loadWidget();'>News</a>");
			$('#ttleNews').html("<a href='javascript:popAWidget();'>News</a>" +" > "+ rfilter);
			if(level == 2){
				$.post("http://www.perchards.com/db_widget_src/getAdminNewsItems.php",
					   {
						'section':rfilter
					   },function(data){
					   	//alert(data);
							//alert(data);
								var nItems = "";
						 		var newsArray = data.split('***@***');
								//JSON
								global_NewsItems = '{"NewsItems":[';
						 		for(z=0;z<newsArray.length-1;z++)
								{
							 		//alert(newsArray[z]);
									var newsItemArray = newsArray[z].split('***$***');
							 		var timestamp = newsItemArray[3].split(' ');
							 		var datex = timestamp[0];
							 		
									//alert('"ID":'+newsItemArray[0]+',"TITLE":"'+newsItemArray[1]+'","CONTENT":"'+newsItemArray[2]+'","DATE":"'+datex+'","COUNTRY":"'+newsItemArray[4]+'');
									//BUILD A JSON FOR THE NEWSITEMS
									if(z == newsArray.length-2){
									//global_NewsItems += '{"ID":'+newsItemArray[0]+',"TITLE":"'+newsItemArray[1]+'","CONTENT":"'+newsItemArray[2]+'","DATE":"'+datex+'","COUNTRY":"'+newsItemArray[4]+'"}';	
									global_NewsItems += '{"ID":'+newsItemArray[0]+',"TITLE":"'+newsItemArray[1]+'","CONTENT":"Test","DATE":"'+datex+'","COUNTRY":"'+newsItemArray[4]+'"}';	
									}else{
									global_NewsItems += '{"ID":'+newsItemArray[0]+',"TITLE":"'+newsItemArray[1]+'","CONTENT":"Test","DATE":"'+datex+'","COUNTRY":"'+newsItemArray[4]+'"},';
									}
						 		}
								global_NewsItems += ']}';
								
								$('#dispNews').css('min-height','320px');
								$('#nwsContent').css('min-height','320px');
								
								adBuildItemsList("News",0);
						
						
					   });
			}else{
			
			}
		}else if(section == "Events")
		{
			$('#dispReports').hide();
			$('#dispNews').hide();
			$('#dispEvents').show();
			$('#dispPages').hide();
			$('.wg_Display').css('min-height','200px');
			//$('#ttleEvents').html()
			$('#ttleEvents').html("<a href='javascript:popAWidget();'>Events</a> > "+ rfilter);
			if(level == 2){
				$.post("http://www.perchards.com/db_widget_src/getAdminEventItems.php",
					   {
						'section':rfilter,
						'cntry[]':cntry_arr
					   },function(data){
					   	//alert(data);
						var displayEvents = "<table><tr><td>Title</td><td>Country</td><td>Date</td><td></td></tr><tr><td colspan='4'><img id='addimgEvents' src='http://www.perchards.com/images/add-10x10.png' onclick='javascript:newEvents(\""+ $('#ttleEvents').text() +"\");'/> Add Events</td></tr>";
						 var newsArray = data.split('***@***');
						 for(z=0;z<newsArray.length-1;z++){
							 var newsItemArray = newsArray[z].split('***$***');
							 var timestamp = newsItemArray[3].split(' ');
							 var date = timestamp[0];
							 displayEvents+="<tr id='eventRow"+newsItemArray[0]+"'><td><a href='javascript:editEvents("+newsItemArray[0]+",\""+ $('#ttleEvents').text() +"\");' title='Click to edit event details'><img src='http://www.perchards.com/images/news_blue.gif'/></a> "+newsItemArray[1]+"</td><td>"+newsItemArray[4]+"</td><td>"+date+"</td><td><a href='javascript:deleteThisEvent("+newsItemArray[0]+");' title='Click to delete article'>x</a></td></tr>";
						 }
						 displayEvents+="</table>";
						 $('.wg_Display').css('height','400px');
						$('#evntsContent').html(displayEvents);	
						$('#inpSection').val(rfilter);
						$('#dpView').show();
						
					   });
			}else{
			}
		}else if(section == "SitePages")
		{
			$('#dispReports').hide();
			$('#dispNews').hide();
			$('#dispEvents').hide();
			$('#dispPages').hide();
			$('.wg_Display').css('height','200px'); 
			$('#ttlePages').html($('#ttlePages').html() +" >"+ rfilter);
		}else{}
		if(level == 2){
		$.post("http://www.perchards.com/db_widget_src/getReportItemsAdmin.php",{'filter':rfilter,'cntry[]':cntry_arr},function(data){
			var folderItemz = "";
			var grpArr = data.split('@');
			for(i=0;i<grpArr.length-1;i++)
			{
				var x=0;
				var imageLink = "http://www.perchards.com/images/wid_folder.gif";
				var secArr = grpArr[i].split(',');
				 folderItemz += "<div class='dispFolder2'><a href='javascript:addisplayItems(3,\"Reports\",\""+rfilter+"\",\""+secArr[x]+"\",\""+secArr[x+1]+"\")'><span class='imgFolder'><img src='"+imageLink+"'/></span><span class='textFolder'>"+secArr[x]+"<br>"+secArr[x+1]+"</span></a></div>";
			}
			$('#rptContent').html(folderItemz);
		});
		}else if(level == 3){
			
		$.post("http://www.perchards.com/db_widget_src/getDocuments.php",
				   {
					 'section':lvlname,
				   	 'filter':rfilter,
				     'subscription':0,
					 'client':0,
					 'cntry[]':cntry_arr,
					 'srch':"",
					 'pageFrom':0,
					 'limit':2000
				   },
				   function(data){
					  // alert(data);
				var grpArr = data.split('@');
				global_DocItems = '{ "ReportItems":[';
				for(x=0;x<grpArr.length-1;x++)
				{
					var imageLink = "";
					var j=0;
					var secArr = grpArr[x].split('$')
					
					var sas = "";
					//CREATING A JSON OBJECT
					if(x == grpArr.length-2){
													  global_DocItems += '{"ACTIVE":"'+secArr[j]+'","COUNTRY":"'+secArr[j+1]+'","TITLE":"'+secArr[j+2]+'","DATE":"'+secArr[j+3]+'","ID":"'+secArr[j+4]+'","SUBS_AMT":"'+secArr[j+5]+'","SUBS_DOCID":"'+secArr[j+6]+'","CLIENT_DOCID":"'+secArr[j+7]+'","SECTION_ID":"'+secArr[j+8]+'"}';
					}else{
						global_DocItems += '{"ACTIVE":"'+secArr[j]+'","COUNTRY":"'+secArr[j+1]+'","TITLE":"'+secArr[j+2]+'","DATE":"'+secArr[j+3]+'","ID":"'+secArr[j+4]+'","SUBS_AMT":"'+secArr[j+5]+'","SUBS_DOCID":"'+secArr[j+6]+'","CLIENT_DOCID":"'+secArr[j+7]+'","SECTION_ID":"'+secArr[j+8]+'"},';
					}
					
					//tableItems += imageLink;
					//tableItems += "<tr><td>"+imageLink+"</td><td>"+secArr[j+1]+"</td><td>"+secArr[j+2]+"</td><td>"+sdate+"</td></tr>";
				}
				 global_DocItems += ']}';
				//tableItems += "</table><div style='clear:both'>&nbsp;</div></div><div style='clear:both'>&nbsp;</div>";
				//$('.wg_Display').css('height','400px');
				//$('#rptContent').html(tableItems);
				adBuildItemsList("Report",0)
				//alert(global_DocItems);
			});	/*$.post("http://www.perchards.com/db_widget_src/getDocuments.php",{'section':lvlname,'filter':rfilter,'subscription':0,'client':0,'cntry[]':cntry_arr},function(data){
																																											   				//alert(lvlname+"--"+rfilter+"---"+cntry_arr);
				var tableItems = "<div class='dispTable'><table><tr><th></th><th>Country</th><th>Title</th><th>Updated</th></tr>";
				tableItems += "<tr><td><img id='addimg' src='http://www.perchards.com/images/add-10x10.png' onclick='javascript:newReport(\""+ $('#ttleReports').text() +"\");'/></td><td colspan='3'><div id='adddoc' onclick='javascript:newReport(\""+ $('#ttleReports').text() +"\");'> Add New Report</div></td></tr>";
				var grpArr = data.split('@');
				for(x=0;x<grpArr.length-1;x++)
				{
					var imageLink = "";
					var j=0;
					var secArr = grpArr[x].split('$')
					var sdate = secArr[j+3];
					var docid = secArr[j+4];
					if(secArr[j]==0)
					{
						imageLink ="<img src='http://www.perchards.com/images/pdf_grey.gif'/>";
					}else if(secArr[j]== 1)
					{
						imageLink ="<img src='http://www.perchards.com/images/pdf_red.gif'/>";
					}else{
						imageLink ="<img src='http://www.perchards.com/images/pdf_grey.gif'/>";
					}
					tableItems += "<tr><td>"+imageLink+"</td><td>"+secArr[j+1]+"</td><td><a href='javascript:editDocumentReport("+docid+",\""+ $('#ttleReports').text() +"\");' title='Click to edit report'>"+secArr[j+2]+"</a></td><td>"+sdate+"</td><td><a href='javascript:deleteThisDocument("+docid+");' title='Click to delete report'>x</a></td></tr>";
				}
				tableItems += "</table></div>";
				$('.wg_Display').css('height','800px');
				$('#rptContent').html(tableItems);
			});*/
			
		}
	}
		function newNews(headerinfo){
		var hinfoarray = headerinfo.split('>');
		var strNewsPage = "<div id='nr_header' class='nr_line'> Add News </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td><b>Type:</b></td><td>"+hinfoarray[0]+"</td></tr><tr><td><b>Section:</b></td><td>"+hinfoarray[1]+"</td><td><input id='sec0' type='hidden' value='"+hinfoarray[1]+"' /></td></tr></table></span></div>";
		strNewsPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40'/></td></tr><tr><td>Date:</td><td><input type='text' id='datepicker'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='0'>-select-</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data){
			var cx = data.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strNewsPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
			strNewsPage +="</select></td></tr><tr><td>Private:</td><td><input id='chkPrivte' name='chkPrivte' type='Checkbox' /></td></tr><tr><td>Active:</td><td><input id='chkActve' name='chkActve' type='Checkbox' /></td></tr></table></div><div id='nr_upload' class='nr_line'><table><tr><td>News Content:</td><td><textarea id='txtContent' style='width:455px;min-height:320px '></textarea></td><td></td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Submit' type='button' onclick='putNews(-1,\""+hinfoarray[0]+"\");'/><input id='tback' value='Back' type='button' onclick='popAWidget();'/></div>";
			$('div.adminwidget').html(strNewsPage);
			setTimeout(function () {
				tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
				tinyMCE.execCommand('mceAddControl',false,'txtContent');
				//activateEditor("txtContent");
			}, 1000);
			
		});
		
	
	}
	function editNews(newsid,headerinfo){
		$.post("http://www.perchards.com/db_widget_src/getNewsInfo.php",
			   {'newsid':newsid
			   },
			   function(data){
				   //alert(data);
				   var hinfoarray = headerinfo.split('>');
				   var dataarr = data.split('***@***');
				   var strPrivate = "";
				   var strActive = "";
				   var strdate_arr = dataarr[3].split(' ');
				   var strdate = strdate_arr[0];
				   if(dataarr[4]== 1){
					   strPrivate = "Checked";
				   }
				   if(dataarr[5]== 1){
					   strActive = "Checked";
				   }
				   var strNewsPage = "<div id='nr_header' class='nr_line'> Edit News </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td><b>Type:</b></td><td>"+hinfoarray[0]+"</td></tr><tr><td><b>Section:</b></td><td>"+dataarr[8]+"</td><td><input id='sec0' type='hidden' value='"+dataarr[9]+"' /></td></tr></table></span></div>";
		strNewsPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40' value='"+dataarr[1]+"'/></td></tr><tr><td>Date:</td><td><input type='text' id='datepicker' value='"+strdate+"'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='"+dataarr[7]+"'>"+dataarr[6]+"</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data){
			var cx = data.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strNewsPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
			strNewsPage +="</select></td></tr><tr><td>Private:</td><td><input id='chkPrivte' name='chkPrivte' type='Checkbox' "+strPrivate+" /></td></tr><tr><td>Active:</td><td><input id='chkActve' name='chkActve' type='Checkbox'"+strActive+" /></td></tr></table></div><div id='nr_upload' class='nr_line'><table><tr><td>News Content:</td><td><textarea id='txtContent' style='width:455px;min-height:320px '>"+dataarr[2]+"</textarea></td><td></td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Update' type='button' onclick='putNews("+newsid+",\""+hinfoarray[0]+"\");'/><input id='tback' value='Back' type='button' onclick='popAWidget();'/></div>";
			$('div.adminwidget').html(strNewsPage);
			setTimeout(function () {
				tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
				tinyMCE.execCommand('mceAddControl',false,'txtContent');
				//activateEditor("txtContent");
			}, 1000);
			/*tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
			tinyMCE.execCommand('mceAddControl',false,'txtContent');
			tinyMCE.execCommand("mceRepaint");*/
			
			
		});
		
	});		
}
function putNews(NewsID,type){
	var dprivate = 0;
	var dactive = 0;
		dsection = document.getElementById("sec0").value;
		dtitle = document.getElementById("rtitle").value;
		ddate = document.getElementById("datepicker").value;
		dcountry = document.getElementById("rcountry").value;
		 if(document.getElementById("chkPrivte").checked == true)
		 {
			 dprivate = 1;
		 }
		 if(document.getElementById("chkActve").checked == true){
			dactive = 1;
		 }
		//dcontent = document.getElementById("txtContent").value;
		
		dcontent = tinyMCE.get('txtContent').getContent()
		
		/* taken from page edit save function */
		//ajaxSave(this,document.url,document.getElementById('site_pageid').value,tinyMCE.get('site_pcontent').getContent(),tinyMCE.get('site_plinks').getContent());
		//alert("section:"+dsection+", title:"+dtitle+", date:"+ddate+", country:"+dcountry+", private:"+dprivate+", active:"+dactive+", content:"+dcontent);
	
	//tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
	
	if(NewsID == -1){
		
	$.post("http://www.perchards.com/db_widget_src/putNews.php",
		   {
			   sections:""+dsection+"",
			   title:""+dtitle+"",
			   date:""+ddate+"",
			   country:""+dcountry+"",
			   private:""+dprivate+"",
			   active:""+dactive+"",
			   content:""+dcontent+""
			   },function(data){
				   if(data == "" || data == null || data == 0){
					   alert("Error creating news.")
				   }else{
					   alert("News created.");
					   popAWidget();
				   }
		   
		   });
	}else{
		$.post("http://www.perchards.com/db_widget_src/updateNews.php",
		   {
			   newsid:""+NewsID+"",
			   sections:""+dsection+"",
			   title:""+dtitle+"",
			   date:""+ddate+"",
			   country:""+dcountry+"",
			   private:""+dprivate+"",
			   active:""+dactive+"",
			   content:""+dcontent+""
			   },function(data){
		   			if(data ==1){
						alert("News updated.");
						popAWidget();
					}else{alert("Error updating news.")}
		   });
	}
	tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
}
function putEvents(EventID,type){
	var dprivate = 0;
	var dactive = 0;
		dsection = document.getElementById("sec0").value;
		dtitle = document.getElementById("rtitle").value;
		ddate = document.getElementById("datepicker").value;
		dcountry = document.getElementById("rcountry").value;
		 if(document.getElementById("chkPrivte").checked == true)
		 {
			 dprivate = 1;
		 }
		 if(document.getElementById("chkActve").checked == true){
			dactive = 1;
		 }
		//dcontent = document.getElementById("txtContent").value;
		dcontent = tinyMCE.get('txtContent').getContent()
		//alert("section:"+dsection+", title:"+dtitle+", date:"+ddate+", country:"+dcountry+", private:"+dprivate+", active:"+dactive+", content:"+dcontent);
	if(EventID == -1){
		
	$.post("http://www.perchards.com/db_widget_src/putEvents.php",
		   {
			   sections:""+dsection+"",
			   title:""+dtitle+"",
			   date:""+ddate+"",
			   country:""+dcountry+"",
			   private:""+dprivate+"",
			   active:""+dactive+"",
			   content:""+dcontent+""
			   },function(data){
				   if(data == "" || data == null || data == 0){
					   alert("Error creating events.")
				   }else{
					   alert("Events created.");
					   popAWidget();
				   }
		   
		   });
	}else{
		$.post("http://www.perchards.com/db_widget_src/updateEvents.php",
		   {
			   eventid:""+EventID+"",
			   sections:""+dsection+"",
			   title:""+dtitle+"",
			   date:""+ddate+"",
			   country:""+dcountry+"",
			   private:""+dprivate+"",
			   active:""+dactive+"",
			   content:""+dcontent+""
			   },function(data){
		   			if(data == 1){
						alert("Events updated");
						popAWidget();
					}else{alert("Error updating events.")}
		   });
	}
	tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
}
//Events

function newEvents(headerinfo){
		var hinfoarray = headerinfo.split('>');
		var strNewsPage = "<div id='nr_header' class='nr_line'> Add Events </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td><b>Type:</b></td><td>"+hinfoarray[0]+"</td></tr><tr><td><b>Section:</b></td><td>"+hinfoarray[1]+"</td><td><input id='sec0' type='hidden' value='"+hinfoarray[1]+"' /></td></tr></table></span></div>";
		strNewsPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40'/></td></tr><tr><td>Date:</td><td><input type='text' id='datepicker'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='0'>-select-</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data){
			var cx = data.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strNewsPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
			strNewsPage +="</select></td></tr><tr><td>Private:</td><td><input id='chkPrivte' name='chkPrivte' type='Checkbox' /></td></tr><tr><td>Active:</td><td><input id='chkActve' name='chkActve' type='Checkbox' /></td></tr></table></div><div id='nr_upload' class='nr_line'><table><tr><td>Event Content:</td><td><textarea id='txtContent' style='width:455px;min-height:320px '></textarea></td><td></td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Submit' type='button' onclick='putEvents(-1,\""+hinfoarray[0]+"\");'/><input id='tback' value='Back' type='button' onclick='popAWidget();'/></div>";
			$('div.adminwidget').html(strNewsPage);
			setTimeout(function () {
				tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
				tinyMCE.execCommand('mceAddControl',false,'txtContent');
				//activateEditor("txtContent");
			}, 1000);
			//tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
			//tinyMCE.execCommand('mceAddControl',false,'txtContent');
			//tinyMCE.execCommand('mceAddControl',false,'txtContent');
		});
		
	
	}
	function editEvents(eventid,headerinfo){
		$.post("http://www.perchards.com/db_widget_src/getEventsInfo.php",
			   {'eventid':eventid
			   },
			   function(data){
				   //alert(data);
				   var hinfoarray = headerinfo.split('>');
				   var dataarr = data.split('***@***');
				   var strPrivate = "";
				   var strActive = "";
				   var strdate_arr = dataarr[3].split(' ');
				   var strdate = strdate_arr[0];
				   if(dataarr[4]== 1){
					   strPrivate = "Checked";
				   }
				   if(dataarr[5]== 1){
					   strActive = "Checked";
				   }
				   var strNewsPage = "<div id='nr_header' class='nr_line'> Edit Events </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td><b>Type:</b></td><td>"+hinfoarray[0]+"</td></tr><tr><td><b>Section:</b></td><td>"+dataarr[8]+"</td><td><input id='sec0' type='hidden' value='"+dataarr[9]+"' /></td></tr></table></span></div>";
		strNewsPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40' value='"+dataarr[1]+"'/></td></tr><tr><td>Date:</td><td><input type='text' id='datepicker' value='"+strdate+"'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='"+dataarr[7]+"'>"+dataarr[6]+"</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data){
			var cx = data.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strNewsPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
			strNewsPage +="</select></td></tr><tr><td>Private:</td><td><input id='chkPrivte' name='chkPrivte' type='Checkbox' "+strPrivate+" /></td></tr><tr><td>Active:</td><td><input id='chkActve' name='chkActve' type='Checkbox'"+strActive+" /></td></tr></table></div><div id='nr_upload' class='nr_line'><table><tr><td>Event Content:</td><td><textarea id='txtContent' style='width:455px;min-height:320px '>"+dataarr[2]+"</textarea></td><td></td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Update' type='button' onclick='putEvents("+eventid+",\""+hinfoarray[0]+"\");'/><input id='tback' value='Back' type='button' onclick='popAWidget();'/></div>";
			$('div.adminwidget').html(strNewsPage);
			setTimeout(function () {
				tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
				tinyMCE.execCommand('mceAddControl',false,'txtContent');
				//activateEditor("txtContent");
			}, 1000);
			/*tinyMCE.execCommand('mceRemoveControl',false,'txtContent');
			tinyMCE.execCommand('mceAddControl',false,'txtContent');*/
			//tinyMCE.execCommand('mceAddControl',false,'txtContent');
			
		});
		
});		
}


	function newReport(headerinfo){
		var hinfoarray = headerinfo.split('>');
		var strReportPage = "<div id='nr_header' class='nr_line'> Add New Report </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td width='100px'><b>Type:</b></td><td>"+hinfoarray[0]+"</td></tr><tr><td><b>Section:</b></td><td>"+hinfoarray[1]+"</td><td><input id='sec0' type='hidden' value='"+hinfoarray[1]+"' /></td></tr><tr><td><b>Sub-Section:</b></td><td>"+hinfoarray[2]+"</td><td><input id='subsec0' type='hidden' value='"+hinfoarray[2]+"' /></td></tr></table></span><input type='button' id='addsection' name='addsection' value='Include in additional sections' onClick='addSection();'/></div>";
		strReportPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td width='100px'>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40'/></td></tr><tr><td>Date:</td><td><input type='text' id='datepicker'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='0'>-select-</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data){
			var cx = data.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strReportPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
			strReportPage +="</select></td></tr><tr><td>GBP:</td><td><input id='rgbp' name='rgbp' value=''/></td></tr><tr><td>EUR:</td><td><input id='reur' name='reur' value=''/></td></tr></table></div><div id='nr_upload' class='nr_line'><table width='600'><tr><td width='100px'>Redirect ID:</td><td><input id='redirectID' name='redirectID' type='text'/></td><td></td></tr></table></div><div id='nr_upload' class='nr_line'><table width='600'><tr><td width='100px'>Upload:</td><td><input id='fileToUpload' name='fileToUpload' type='file' size='50' style='width:480px'/></td><td></td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Submit' type='button' onclick='ajaxFileUploader(0,0);'/><input id='tback' value='Back' type='button' onclick='callbackPage(3,\""+hinfoarray[0]+"\",\""+hinfoarray[1]+"\",\""+hinfoarray[2]+"\");'/></div>";
			$('div.adminwidget').html(strReportPage);
			
		});
		
	
	}
	String.prototype.ltrim = function() {
		return this.replace(/^\s+/,"");
	}
	String.prototype.rtrim = function() {
		return this.replace(/\s+$/,"");
	}
	function callbackPage(no,Level1,Level2,Level3){
		//alert(no+"-"+Level1+"-"+Level2+"-"+Level3);
		var num = no;
		var l1 = Level1.ltrim().rtrim();
		var l2 = Level2.ltrim().rtrim();
		var l3 = Level3.ltrim().rtrim();
		popHalfWidget();
		$('#ttleReports').html($('#ttleReports').html()+ " > "+ Level2);
		//alert(num+","+l1+","+l2+","+l3);
		addisplayItems(num,l1,l2,l3);
	}
	function editDocumentReport(docid,headerinfo){
		$.post("http://www.perchards.com/db_widget_src/getDocumentInfo.php",
			   {'documentId':docid
			   },
			   function(data){
				   //alert(data);
				   var data_arr = data.split('@');
				   
		var hinfoarray = headerinfo.split(' > ');
		var strReportPage = "<div id='nr_header' class='nr_line'> Edit Report </div><div id='nr_sectioninfo' class='nr_line'><span id='sicontent'><table><tr><td width='100px'><b>Type:</b></td><td><select ><option value='"+hinfoarray[0]+"'>"+hinfoarray[0]+"</option></select></td></tr><tr><td><b>Section:</b></td><td><select id='sec0' onchange='javascript:addSubSection(\"subsec0\",\"sec0\");'><option value='"+hinfoarray[1]+"'>"+hinfoarray[1]+"</option>";
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
				{
					var rx = data.split('@@@');
					var rxlen = rx.length - 1;
					for(ds=0;ds<rxlen;ds++){
						var sx = rx[ds].split('$$$');
						var sxlen = sx.length;						
						for(fs=0;fs<sxlen;fs++)
						{
							if(fs==1 ){
								if(jQuery.trim(sx[fs]) != jQuery.trim(hinfoarray[1])){
									strReportPage +="<option value='"+sx[fs]+"'>"+sx[fs]+"</option>";
								}
							}else{
								
							}
						}
					}
				
				
		var date_outputarr = data_arr[4].split(' ');
		date_ouput = date_outputarr[0];
		strReportPage+="</select></td></tr><tr><td><b>Sub-Section:</b></td><td><select id='subsec0'><option value='"+hinfoarray[2]+"'>"+hinfoarray[2]+"</option>";
		strReportPage +="</select></td></tr></table></span><input type='button' id='addsection' name='addsection' value='Include in additional sections' onClick='addSection();'/>&nbsp;&nbsp;<span style=\"display:inline-block; background: #ccc; cursor:pointer; padding:3px;\" onclick=\"removeFromSection("+data_arr[0]+",'"+hinfoarray[1]+"','"+hinfoarray[2]+"');\">Remove from Section</span></div>";
			
		strReportPage += "<div id='nr_reportentry' class='nr_line'><table><tr><td width='100px'>Title:</td><td><input id='rtitle' name='rtitle' type='text' size='40' value='"+data_arr[3]+"'/></td></tr><tr><td>Date:</td><td><input id='datepicker' name='datepicker' type='text' size='40' value='"+date_ouput+"'/></td></tr><tr><td>Country:</td><td><select id='rcountry' name='rcountry'><option value='"+data_arr[1]+"'>"+data_arr[2]+"</option>";
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(datas){
			var cx = datas.split('@');
			var cxlen = cx.length-1;
			for(s=0;s<cxlen;s++){
				//alert(cx[s]);
				var dxs = cx[s];
				var dx = dxs.split(',');
				strReportPage +="<option value='"+dx[0]+"'>"+dx[1]+"</option>";
			}
		var uploadFileStr = data_arr[5].split('/');
		currFileName = uploadFileStr[2];
		strReportPage+="</select></td></tr><tr><td>GBP:</td><td><input id='rgbp' name='rgbp' value='"+data_arr[6]+"'/></td></tr><tr><td>EUR:</td><td><input id='reur' name='reur' value='"+data_arr[7]+"'/></td></tr></table></div><div id='nr_upload' class='nr_line'><table width='600'><tr><td width='100px'>Redirect ID:</td><td><input id='redirectID' name='redirectID' type='text' value='"+data_arr[8]+"'/></td><td></td></tr></table></div><div id='nr_upload' class='nr_line'><table><tr><td width='100px'>Upload:</td><td><input id='fileToUpload' name='fileToUpload' type='file' size='50' style='width:480px' onchange='fileState(1)' /><br>"+uploadFileStr[2]+"</td></tr></table></div><div id='nr_bottom' class='nr_noline'><input id='tsubmit' name='tsubmit' value='Update' type='submit' onclick='ajaxFileUploader("+docid+");'/><input id='tback' value='Back' type='button' onclick='callbackPage(3,\""+hinfoarray[0]+"\",\""+hinfoarray[1]+"\",\""+hinfoarray[2]+"\");'/></div>";
		$('div.adminwidget').html(strReportPage);
		});	
});
});		
		/*setTimeout(function(){
			var sdd = document.getElementById("sec0");
			var sdds = sdd.options[sdd.selectedIndex].value;
			alert(sdds);
		},3000);*/
}
function populateSectionArray(){
	//alert(global_info);
	global_sec = "";
	global_subsec = "";
	for(x=0;x<=global_info;x++){
		if(document.getElementById("sec"+x).value == "-select-" || document.getElementById("subsec"+x).value == "-select-"){
			alert("section not selected");
		}else{
			global_sec += document.getElementById("sec"+x).value;
			global_subsec += document.getElementById("subsec"+x).value;
			global_sec+= ",";
			global_subsec+=",";
			//alert(global_sec);
		}
	}
}
	function removeFromSection(id,section,subsection){
		alert(id+"-"+section+"-"+subsection);
		$.post("http://www.perchards.com/db_widget_src/removeFromSection.php",{
			docid:""+id+"",
			sectionname:""+section+"",
			subsectionname:""+subsection+""
			},function(data){
			alert(data);
			addisplayItems(2+","+"Reports"+","+section+","+subsection);
		});
	}
	
	function addSection(){
		global_info++;
		var stNewSubSection = "<select id='subsec"+global_info+"'><option value='-select-'>-select-</option>";
		var stNewSection = "<table><tr><td width='100px'>Section:</td><td><select id='sec"+global_info+"' onchange='javascript:addSubSection(\"subsec"+global_info+"\",\"sec"+global_info+"\");'><option value='-select-'>-select-</option>";
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
				{
					//alert(data);
					var rx = data.split('@@@');
					var rxlen = rx.length - 1;
					for(c=0;c<rxlen;c++){
						var sx = rx[c].split('$$$');
						var sxlen = sx.length;						
						for(d=0;d<sxlen;d++)
						{
							if(d==1){
							stNewSection +="<option value='"+sx[d]+"'>"+sx[d]+"</option>";
							}else{
							}}
					}
					stNewSubSection +="</select>"
					stNewSection += "</select></td></tr><tr><td>Sub-Section:</td><td>"+stNewSubSection+"</td></tr></table>";
					$('#sicontent').html($('#sicontent').html()+ stNewSection);
				});
		
	}
	function addSectionforNews(nwsSection){
		global_info++;
		var stNewSection = "<table><tr><td>Section:</td><td><select id='sec"+global_info+"'><option value='-select-'>-select-</option>";
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
				{
					var rx = data.split('@@@');
					var rxlen = rx.length - 1;
					for(c=0;c<rxlen;c++){
						var sx = rx[c].split('$$$');
						var sxlen = sx.length;						
						for(d=0;d<sxlen;d++)
						{
							if(d==1){
								if(nwsSection == sx[d]){}else{
								stNewSection +="<option value='"+sx[d-1]+"'>"+sx[d]+"</option>";
								}
							}else{
							}
						}
					}
					stNewSection += "</select></td></tr></table>";
					$('#sicontent').html($('#sicontent').html()+ stNewSection);
				});
		
	}
function addSubSection(SelectBoxID,SectionValue)
{
	
	var selBox = document.getElementById(SelectBoxID);
	selBox.options.length = 0;
	var istoption = document.createElement('option');
	var section = document.getElementById(SectionValue).value;
	$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
	{
		//console.log(data);
			var rx = data.split('@@@');
			var rxlen = rx.length - 1;
			for(c=0;c<rxlen;c++)
			{
				var sx = rx[c].split('$$$');
				var sxlen = sx.length;						
				for(d=0;d<sxlen;d++)
				{
					if(d==0)
					{
					}else
					{
						//console.log(sx[0]+","+section);
						if(sx[1]== section)
						{
							//if(d===3 || d%3 == 0){
							if(d>3 && d%3 == 0){
							var newoption = document.createElement('option');
							newoption.text = sx[d-1];
							newoption.value = sx[d-1];
							//console.log(sx[d]);
							try
							{
								
								selBox.add(newoption,null);
							}catch(ex)
							{
								selBox.add(newoption); //For IE
							}
							}
						};
					}
				}
			}
					
	});
	
}
//FUNCTIONS FOR THE COUNTRY TAB	
	function loadCountry(){
		
		$.post("http://www.perchards.com/db_widget_src/getCountries.php", function(data) {
			var struct= "";
			   var params = data.split('@');
			   var paramslen = params.length -1;
			   for(i=0;i<params.length-1;i++)
			   {
				   var c_id_names = params[i];
				   var c_names = c_id_names.split(',');
				   struct = struct +"<a href='javascript:addCn("+c_names[0]+",\""+c_names[1]+"\");' title='Click to edit Country'>"+c_names[1]+"</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href='javascript:deleteCountry("+c_names[0]+",\""+c_names[1]+"\");' title='Click to delete Country'> x </a><br>";
			   }
			   $("#cn_cn").html(struct);
			 });
	}
	function addCn(CountryID,CountryName){
		var newcn = "Edit Country<br><table><tr><td>Country:</td><td><input id='txtCntry' name='txtCntry' type='text' size='35px' value='"+CountryName+"'/><input id='idCntry' type='hidden' value='"+CountryID+"'/></td><td><input id='uptBut' type='button' value='Update' onclick='javascript:updateCountry(1,"+CountryID+");'/></td></tr></table>";
		$("#cn_add").html(newcn);
		$('#txtCntry').focus();
	}
	function deleteCountry(cntryid,cntryname){
		//alert(cntryid+","+cntryname);
		$.post("http://www.perchards.com/db_widget_src/deleteCountry.php",{country_id:""+cntryid+""},function(data){
			  // alert(data);
			   if(data==-1){
				 alert("Error deleting Country, Contact Administrator.")  
			   }else if (data==2){
				   alert("Country deleted");
				   loadCountry();
			   }else if(data==1){
				  alert("Country cannot be deleted because Documents/News/Events exist. ") 
			   }else{}
			   
							  });
	}
	function updateCountry(uptFlag,CountryID){
		if(uptFlag == 0){
		var cntry = document.getElementById('txtCntry').value;
		$.post("http://www.perchards.com/db_widget_src/putCountries.php",
			   {
				   country:""+cntry+""
				   },
			   function(data)
		{
			 if(data == -1){
				 alert("Error creating a Country!!!");
			 }else{
				 loadCountry();
				 document.getElementById('txtCntry').value = ""
			 }
		});
		}else{
			var cntry = document.getElementById('txtCntry').value;
			var cntryid = document.getElementById('idCntry').value;
			$.post("http://www.perchards.com/db_widget_src/updateCountry.php",
			   {
				   cntryid:""+cntryid+"",
				   cntryname:""+cntry+""
				   },
			   function(data)
		{
			 if(data == -1){
				 alert("Error updating Country.");
			 }else{
				 var strCountries = "<div id='' class='dbscreen'><div id='cn_head' class='nr_line'>Edit Countries</div><div id='cn_add' class='nr_line'> Add New Country<br><table><tr><td>Country:</td><td><input id='txtCntry' name='txtCntry' type='text' size='35px'/></td><td><input id='uptcnBut' type='button' value='Add' onclick='javascript:updateCountry(0,0);'/></td></tr></table></div>";
	strCountries += "<div id='cn_cn' class='nr_line'></div><div id='cn_bot' class='nr_noline'></div></div>";
				$("#tabcontent").html(strCountries);
				loadCountry();
			 }
		});
		}
	}
	//FUNCTIONS FOR THE SUBSCRIPTION TAB
	function setSupscriptions(Id){
		populateDocumentArray();
		var pname = document.getElementById("txtPackageName").value;
		var private = 0;
		if(document.getElementById("chkPrivate").checked == true){
			private = 1;
		}else{
			private = 0;
		}
		var active = 0;
		if(document.getElementById("chkActive").checked == true){
			active = 1;
		}else{
			active = 0;
		}
		var gbp = document.getElementById("txtGBP").value;
		var eur = document.getElementById("txtEUR").value;
		if(Id == 0){
		$.post("http://www.perchards.com/db_widget_src/putSubscription.php",{
			   PackName:""+pname+"",
			   Private :""+private+"",
			   Active:""+active+"",
			   Sterling:""+gbp+"",
			   Euros:""+eur+"",
			   DocIdString:""+global_document+""
			   },function(data){
				   if(data == -1){
					   alert(data);
				   }else{
					   showSubscriptionMain();
				   }
				   global_document = "";
									  
		 });
		}
		else{
			$.post("http://www.perchards.com/db_widget_src/updateSubscription.php",{
			   PackName:""+pname+"",
			   Private :""+private+"",
			   Active:""+active+"",
			   Sterling:""+gbp+"",
			   SubsDocumentID:""+Id+"",
			   Euros:""+eur+"",
			   DocIdString:""+global_document+""
			   },function(data){
				   //alert(data);
				   if(data == 1){
					   showSubscriptionMain();
				   }else{
					     alert(data);
				   }
					global_document = "";				  
		 });
			}
	}
	function populateDocumentArray(){
		
		var n = $("input:checked")
		for(x=0;x<n.length;x++){
			if(n[x].id == "chkActive" || n[x].id == "chkPrivate" || n[x].name == "Select"){
			}else{
				var b = n[x].id.split('-')
				global_document += b[1]+"@";
			}
		}
		//alert(global_document);	
	}
		function loadSubsSections(SubsID){
		var strSections = "<div id='dummySec' class='isec'><div id='dummyImgSec' class='imgSec'></div><div id='dummySecCont' class='sec_cont'></div></div>";
		var strsubSection = "";
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
		{
			//alert(data);
			var params = data.split('@@@');
			var paramslen = params.length - 1
			for(i=0;i<paramslen;i++)
			{
				strsubSection = "<div style='display:none' id='subsec"+i+"' class='isubsec'>"
				var sectar = params[i].split('$$$');
				//alert(sectar);
				for(j=1;j<sectar.length;j++)
				{
					if(j==1){
						strSections += "<div id='sec"+j+"' class='isec'><div class='imgSec'><img src='http://www.perchards.com/images/icon_plus.gif' width='15px' height='15px' onclick='javascript:toggleSub(\"subsec"+i+"\");'/></div><div class='sec_cont'>"+sectar[j]+"</div></div>";
					}else{
						if((j-2)%3!=0){
						}else if(j>2){
						/*if(j%3!=0){
						}else{*/
							var ChkGroupName = sectar[1]+"£"+sectar[j];
						strsubSection += "<div id='subsecx"+j+"' class='isubsecx'><div class='imgSubSec'><img src='http://www.perchards.com/images/icon_plus.gif'width='15px' height='15px' onclick='javascript:toggleSub(\"docs"+i+"-"+j+"\");' /></div><div class='subsec_cont'>"+sectar[j]+"</div><div id='docs"+i+"-"+j+"' class='docsecs' style='display:none'><div id='docheader' class='nr_line'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Select All <input id='chkAll"+i+"-"+j+"' name='Select' type='checkbox' onclick='toggleCheckDoc(\""+ChkGroupName+"\",\"chkAll"+i+"-"+j+"\");'/></div><div id='docbody"+i+"-"+j+"' class='docbody'> Document Information</div></div></div>";						
						loadSubscriptionDocuments(sectar[1],sectar[j],i+"-"+j,SubsID);
						}
					}
				}
				strsubSection += "</div>"
				strSections += strsubSection;
			}
			$("#sec_cn").html(strSections);
		});
	}
	function toggleCheckDoc(CheckGroupName,chkAllName)
	{
		for(x=0;x<document.getElementsByName(CheckGroupName).length;x++){
			if(document.getElementById(chkAllName).checked == false)
			{
				document.getElementsByName(CheckGroupName).item(x).checked = false;
			}else{
				document.getElementsByName(CheckGroupName).item(x).checked = true;
			}
		}
	}
	function loadSubscriptionDocuments(SectionID,SubSectionID, divID,SubsID){
		$.post("http://www.perchards.com/db_widget_src/getSubDocuments.php",
			   {'section':SectionID,'filter':SubSectionID,'subscription':SubsID,'client':0},
			   function(data){
				   var tableItems = "<table>";
				 	var grpArr = data.split('@');
				for(x=0;x<grpArr.length-1;x++)
				{
					var imageLink = "";
					var j=0;
					var secArr = grpArr[x].split('$')
					var sdate = secArr[j+3];
					var docid = secArr[j+4];
					var chkOutput = "";
					if(secArr[j+5] == 0){
						chkDocOutput = "";	
					}else{
						chkDocOutput = "Checked";
					}
						imageLink ="<img src='http://www.perchards.com/images/pdf_red.gif'/>";
					
					tableItems += "<tr><td>"+imageLink+"</td><td>"+secArr[j+1]+"</td><td>"+secArr[j+2]+"</td><td>"+sdate+"</td><td><input id='"+SubsID+"-"+docid+"' name='"+SectionID+"£"+SubSectionID+"' type='checkbox' "+chkDocOutput+"/></td></tr>";
				}
				tableItems += "</table>";
				$('#docbody'+divID).html(tableItems);  
				
			});
		
		}
	function loadSubscriptions(){
		var subs = "";
		$.post("http://www.perchards.com/db_widget_src/getSubscriptions.php",function(data){
					var arrSubs = data.split('@');
					for(s=0;s<arrSubs.length-1;s++){
						var arrSub = arrSubs[s].split('$');
						 subs +="<div id='row_subs' style='clear:both;float:left;margin:3px' onclick='showSubscriptionPage(\"edit\",\""+arrSub[0]+"\",\""+arrSub[1]+"\",\""+arrSub[2]+"\",\""+arrSub[3]+"\",\""+arrSub[4]+"\",\""+arrSub[5]+"\");'><div id='img_subs' style='float:left;margin-right:3px'><img src='http://www.perchards.com/images/icon_plus.gif' width='15px' height='15px' /></div><div id='content_subs' style='float:left'>"+arrSub[1]+"</div></div>"
						
					}
				$("#sec_cn").html(subs);	
					});	
		
	}
	function showSubscriptionPage(updateFlag,SubsID,SubsName,SubsPrivate,SubsActive,SubsGBP,SubsEUR){	
	 	var strpage = "";
		if(updateFlag == 'new'){
			strpage += "<div id='' class='adminwidget'><div id='sec_tit' class='nr_line'>Package Name: <input id='txtPackageName' size='40px' type='text' value=''/></div><div id='sec_cn' class='nr_line'></div><div id='sec_cn2' class='nr_line'><table><tr><td>Private:</td><td><input type='checkbox' id='chkPrivate'/></td></tr><tr><td>Active:</td><td><input type='checkbox' id='chkActive' /></td></tr><tr><td>GBP:</td><td><input type='text' id='txtGBP' size='20px'/></td></tr><tr><td>EUR:</td><td><input type='text' id='txtEUR' size='20px'/></td></tr></table></div><div id='sec_bot' class='nr_noline'><input id='btAdd' type='button' value='Add' onclick='javascript:setSupscriptions(0);'/><input id='btBack' type='button' value='Back' onclick='javascript:showSubscriptionMain();'/></div></div>";
			loadSubsSections();
		}else if (updateFlag == 'edit'){
			strPriv ="";
			strActv ="";
			if(SubsPrivate == '1'){
				strPriv = "Checked";
			}else{
				strPriv = "";
			}
			
			if(SubsActive == '1'){
				strActv = "Checked";
			}else{
				strActv = "";
			}
				strpage += "<div id='' class='adminwidget'><div id='sec_tit' class='nr_line'>Package Name: <input id='txtPackageName' size='40px' type='text' value='"+SubsName+"' /></div><div id='sec_cn' class='nr_line'></div><div id='sec_cn2' class='nr_line'><table><tr><td>Private:</td><td><input type='checkbox' id='chkPrivate' "+strPriv+"/></td></tr><tr><td>Active:</td><td><input type='checkbox' id='chkActive' "+strActv+"/></td></tr><tr><td>GBP:</td><td><input type='text' id='txtGBP' size='20px' value='"+SubsGBP+"'/></td></tr><tr><td>EUR:</td><td><input type='text' id='txtEUR' size='20px' value='"+SubsEUR+"'/></td></tr></table></div><div id='sec_bot' class='nr_noline'><input id='btUpt' type='button' value='Update' onclick='javascript:setSupscriptions("+SubsID+");'/><input id='btBack' type='button' value='Back' onclick='javascript:showSubscriptionMain();'/></div></div>";
				loadSubsSections(SubsID);
				
		}else{}
		$("#tabcontent").html(strpage);
	}

	function showSubscriptionMain()
	{
		var subs = "<div id='' class='adminwidget'><div id='sec_tit' class='nr_line'>Subscriptions</div><div id='sec_cn' class='nr_line'></div><div id='sec_bot' class='nr_noline'><div class='imgSubSec'><img src='http://www.perchards.com/images/add-10x10.png' width='15px' height='15px' /></div><div class='subsec_cont' onclick='showSubscriptionPage(\"new\",\"\",\"\",\"\",\"\",\"\",\"\" );'> Add Subscription</div></div></div>"
		$("#tabcontent").html(subs);
		loadSubscriptions();
	}
	//FUNCTIONS FOR THE SECTIONS TAB
	function loadSections(){
		var strSections = "<div id='dummySec' class='isec'><div id='dummyImgSec' class='imgSec'></div><div id='dummySecCont' class='sec_cont'></div><div id='dummySecPriv' class='imgPriv'>Private</div><div id='dummySecActive' class='imgActive'>Active</div></div>";
		var strsubSection = "";
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
		{
			var params = data.split('@@@');
			var paramslen = params.length - 1
			//alert(params.length);
			for(i=0;i<paramslen;i++)
			{
				strsubSection = "<div style='display:none' id='subsec"+i+"' class='isubsec'>"
				//alert(params[i]);
				var sectar = params[i].split('$$$');
				//alert(sectar);
				//alert(sectar.length-4);
				for(j=1;j<sectar.length;j++)
				{
					if(j==1){
						//alert(sectar[0]+" "+sectar[1]+" "+sectar[2]+" "+sectar[3]);
						if(sectar[2]==0){var thisPrivateCheck="icon_cross.gif";}else{var thisPrivateCheck="icon_tick.gif";}
						if(sectar[3]==1){var thisActiveCheck="icon_tick.gif";}else{var thisActiveCheck="icon_cross.gif";}
						strSections += "<div id='sec"+j+"' class='isec'><div class='imgSec'><img src='http://www.perchards.com/images/icon_plus.gif' width='15px' height='15px' onclick='javascript:toggleSub(\"subsec"+i+"\")'/></div><div class='sec_cont' onclick='javascript:forSection("+sectar[0]+",\"1\",\""+sectar[j]+"\",\""+/*thisPrivateCheck*/sectar[2]+"\",\""+thisActiveCheck+"\")'>"+sectar[j]+"</div><div class='imgPriv'><img src='http://www.perchards.com/images/"+thisPrivateCheck+"' width='15px' height='15px' /></div><div class='imgActive'><img src='http://www.perchards.com/images/"+thisActiveCheck+"' width='15px' height='15px' /></div></div>";
					}else{
						if((j-2)%3!=0){
						}else if(j>2){
						//alert(sectar[j-1]+" "+sectar[j]+" "+sectar[j+1]);
						strsubSection += "<div id='subsecx"+j+"' class='isubsecx'><div class='imgSubSec'><img src='http://www.perchards.com/images/icon_dot.gif'width='15px' height='15px' /></div><div class='subsec_cont' onclick='javascript:forSubSection(\"1\",\""+sectar[0]+"\",\""+sectar[1]+"\","+sectar[j-1]+",\""+sectar[j]+"\",\"icon_blank.gif\",\"icon_tick.gif\","+sectar[j+1]+")'>"+sectar[j]+"</div><div class='imgPriv'><img src='http://www.perchards.com/images/icon_blank.gif' width='15px' height='15px' onclick=''/></div><div class='imgActive'><img src='http://www.perchards.com/images/icon_tick.gif' width='15px' height='15px' onclick=''/></div></div>";
						}
					}
				}
				strsubSection += "<div id='addsec' class='isubsecx'><div class='imgSubSec'><img src='http://www.perchards.com/images/add-10x10.png' width='15px' height='15px' /></div><div class='subsec_cont' onclick='javascript:forSubSection(\"0\",\""+sectar[0]+"\",\""+sectar[1]+"\",0,\"\",\"\",\"\",0)'> Add Sub-Section </div></div></div>"
				strSections += strsubSection;
			}
			$("#sec_cn").html(strSections);
		});
	}
	function loadSectionsCombos(comboName,SectionTitle){
		var selBox = document.getElementById(comboName)
		$.post("http://www.perchards.com/db_widget_src/getSections.php",function(data)
				{
					var rx = data.split('@@@');
					var rxlen = rx.length - 1;
					for(c=0;c<rxlen;c++){
						var sx = rx[c].split('$$$');
						var sxlen = sx.length;
						for(d=0;d<sxlen;d++)
						{
							if(d==1){
								if(sx[d]==SectionTitle){}else{
									var newoption = document.createElement('option');
									newoption.text = sx[d];
									newoption.value = sx[d-1];
									//alert(sx[d]+""+sx[d-1]);
									try
									{
										selBox.add(newoption,null);
									}catch(ex)
									{
										selBox.add(newoption); //For IE
									}
								}
							}
						}
					}
				});
	}
	function toggleSub(subsection)
	{
		if(document.getElementById(subsection).style.display == "none")
		{
			document.getElementById(subsection).style.display = "block";
		}else
		{
			document.getElementById(subsection).style.display = "none";
		}
	}
	function forSection(sectionid,cflag,sectionname,privatevalue,activevalue){
		//alert(sectionid+" "+cflag+" "+sectionname+" "+privatevalue+" "+activevalue);
		var chkpflag = "";
		var chkaflag = "";
		/*if(privatevalue == "icon_tick.gif"){
			chkpflag = "checked";
		}*/
		if(activevalue == "icon_tick.gif"){
			chkaflag = "checked";
		}
		//var stnew = "<table><tr><td>Section:</td><td><input id='txtSection' type='text' size='40px' value=''/></td></tr><tr><td>Private:</td><td><input id='priv' type='checkbox' value='private'/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active'/></td></tr><tr><td></td><td><input id='butSave' type='button' value='Save' onclick='setSection(-1);'/></td></tr></table>"
		//var stedit = "<table><tr><td>Section:</td><td><input id='txtSection' type='text' size='40px' value=\""+sectionname+"\"/></td></tr><tr><td>Private:</td><td><input id='priv' type='checkbox' value='private' "+chkpflag+"/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active' "+chkaflag+"/></td></tr><tr><td></td><td><input id='butUpt' type='button' value='Update' onclick='setSection("+sectionid+");'/></td><td><input id='butDel' type='button' value='Delete' onclick='deleteConfirmBox("+sectionid+")';/></td></tr></table>";
		var stnew = "<table><tr><td>Section:</td><td><input id='txtSection' type='text' size='40px' value=''/></td></tr><tr><td>Private:</td><td><input id='priv' type='text' size='10px' value=''/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active'/></td></tr><tr><td></td><td><input id='butSave' type='button' value='Save' onclick='setSection(-1);'/></td></tr></table>"
		var stedit = "<table><tr><td>Section:</td><td><input id='txtSection' type='text' size='40px' value=\""+sectionname+"\"/></td></tr><tr><td>Private:</td><td><input id='priv' type='text' size='10px' value=\'"+privatevalue+"'\'/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active' "+chkaflag+"/></td></tr><tr><td></td><td><input id='butUpt' type='button' value='Update' onclick='setSection("+sectionid+");'/></td><td><input id='butDel' type='button' value='Delete' onclick='deleteConfirmBox("+sectionid+")';/></td></tr></table>";
		var stupdt = "<input id='butBck' type='button' value='Back' onclick='javascript:backtoSectionMain();'/>";
		if(cflag == "1"){
			$("#sec_cn").html(stedit);
		}else{
			$("#sec_cn").html(stnew);
		}
		$("#sec_bot").html(stupdt);
	}
	function forSubSection(cflag,sectionid,sectionname,subsectionid,subsection,privatevalue,activevalue,orderno){
		var chkaflag = "";
		if(activevalue == "icon_tick.gif"){
			chkaflag = "checked";
		}
		//alert(sectionid+","+sectionname);
		var stnew = "<table><tr><td>Section:</td><td><select id='selSection'><option value=\""+sectionid+"\">"+sectionname+"</option></select></td></tr><tr><td>Sub-Section Title:</td><td><input id='txtSubSection' type='text' size='40px' value=''/></td></tr><tr><td> Order:</td><td><input id='txtOrder' type='text' size='10px' value=''/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active' /></td></tr><tr><td></td><td><input id='butSave' type='button' value='Save' onclick='setSubSection(-1);'/></td></tr></table>"
			var stedit = "<table><tr><td>Section:</td><td><select id='selSection'><option value=\""+sectionid+"\">"+sectionname+"</option></select></td></tr><tr><td>Sub-Section Title:</td><td><input id='txtSubSection' type='text' size='40px' value=\""+subsection+"\"/></td></tr><tr><td> Order:</td><td><input id='txtOrder' type='text' size='10px' value=\""+orderno+"\"/></td></tr><tr><td>Active:</td><td><input id='actv' type='checkbox' value='active' "+ chkaflag+"/></td></tr><tr><td></td><td><input id='butUpt' type='button' value='Update' onclick='setSubSection("+subsectionid+");'/></td><td><input id='butDel' type='button' value='Delete' onclick='deleteSubConfirmBox("+subsectionid+");'/></td</tr></table>";
			var stupdt = "<input id='uptBck' type='button' value='Back' onclick='javascript:backtoSectionMain();'/>";
			if(cflag == "1"){
				$("#sec_cn").html(stedit);
			}else{
				$("#sec_cn").html(stnew);
			}
			$("#sec_bot").html(stupdt);
			loadSectionsCombos("selSection",sectionname);
	}
	//FOR THE SECTIONS TAB
	//Confirmation  Box
	function deleteConfirmBox(cFunctionParameter){
		var answer = confirm('All subsections and documents under this section will be deleted. Do you want to continue?');
		if(answer){
			deleteSection(cFunctionParameter);
		}else{}
	}
	function deleteSubConfirmBox(cFunctionParameter){
		var answer = confirm('All documents under this sub-section will be deleted. Do you want to continue?');
		if(answer){
			deleteSubSection(cFunctionParameter);
		}else{}
	}
	//Function to delete SubSections
	function deleteSubSection(ssid){
		$.post("http://www.perchards.com/db_widget_src/deleteSubSection.php",{
			   subsection_id:""+ssid+""
			   },function(data){
				   if(data != 1){
				   alert("Error deleting section. Try again later.");
				   }else{
						backtoSectionMain();
				   }
				});
	}
	//Function to delete sections
	function deleteSection(sid){
		$.post("http://www.perchards.com/db_widget_src/deleteSection.php",{
			   section_id:""+sid+""
			   },function(data){
				   if(data != 1){
				   alert("Error deleting section. Try again later.");
				   }else{
						backtoSectionMain();
				   }
				});
	}
	//Function to create and update the subsections
	function setSubSection(ssid){
		sec_id = document.getElementById('selSection').value;
		order = document.getElementById('txtOrder').value;
		ssname = document.getElementById('txtSubSection').value;
		if(document.getElementById('actv').checked ==true){
			sactive =1 ;
		}else{
			sactive =0 ;
		}
		
		//alert(sid+","+sname+","+spriv+","+sactive);
		if(ssid==-1){
		$.post("http://www.perchards.com/db_widget_src/putSubSection.php",
			   {
				   subsect_name:""+ssname+"",
				   order:""+order+"",
				   active:""+sactive+"",
				   sectionid:""+sec_id+""
				   },function(data){
			   			if(data == -1){
							alert("Error creating a Subsection.");
						}else{
							backtoSectionMain();
						}
				   });
		}else{
			$.post("http://www.perchards.com/db_widget_src/updateSubSection.php",
			   {
				   subsectionid:""+ssid+"",
				   subsect_name:""+ssname+"",
				   order:""+order+"",
				   active:""+sactive+"",
				   sectionid:""+sec_id+""
				   },function(data){
			   			if(data != 1){
							alert("Error creating Subsection.");
						}else{
							backtoSectionMain();
						}
				   });
		}
		
	}
	//Function to create and update the section
	function setSection(sid){
		sname = document.getElementById('txtSection').value;
		spriv = document.getElementById('priv').value;
		/*if(document.getElementById('priv').checked == true){
			spriv = 1;
		}else{
			spriv = 0;
		}*/
		if(document.getElementById('actv').checked ==true){
			sactive =1 ;
		}else{
			sactive =0 ;
		}
		
		//alert(sid+","+sname+","+spriv+","+sactive);
		if(sid==-1){
		$.post("http://www.perchards.com/db_widget_src/putSection.php",
			   {
				   sect_name:""+sname+"",
				   priv:""+spriv+"",
				   active:""+sactive+""
				   },function(data){
			   			//alert(data);
						backtoSectionMain();
				   });
		}else{
			$.post("http://www.perchards.com/db_widget_src/updateSection.php",
			   {
				   sect_id:""+sid+"",
				   sect_name:""+sname+"",
				   priv:""+spriv+"",
				   active:""+sactive+""
				   },function(data){
			   			//alert(data);
						backtoSectionMain();
				   });
		}
		
	}
	//Function to redirect back to the main section
	function backtoSectionMain()
	{
		var strSections = "<div id='' class='adminwidget'><div id='sec_tit' class='nr_line'>Edit Sections</div><div id='sec_cn' class='nr_line'></div><div id='sec_bot' class='nr_noline'><div class='imgSubSec'><img src='http://www.perchards.com/images/add-10x10.png' width='15px' height='15px' /></div><div class='subsec_cont' onclick='javascript:forSection(-1,\"0\",\"\",\"\",\"\")'> Add Section </div></div></div>";
		$("#tabcontent").html(strSections);
		loadSections();
	}
	//Function to show the subscription section
	
//OPERATIONAL FUNCTIONS
	function ajaxFileUploader(docid)
	{
		//alert(docid);		
		//alert(fileSelected);
		//if(fileSelected==1) {
			jQuery.ajaxFileUpload
			(
				{
					url:'http://www.perchards.com/db_widget_src/doajaxfileupload.php', 
					secureuri:false,
					fileElementId:'fileToUpload',
					dataType: 'json',
					success: function (data, status)
					
					{
						if(typeof(data.error) != 'undefined')
						{
							if(data.error == 'uploaded')
							{
								indexFile(data.msg,docid);
							}
							else if (data.error == 'Empty')
							{
								if(currFileName!=""){
									indexFile(currFileName,docid);
								}
							} 
							else
							{ 
								//alert(currFileName);
								if (data.error == 'No file was uploaded.')
								{
									if(currFileName!=""){
										indexFile(currFileName,docid);
									} else {
										alert("B "+data.error);
									}
								} else {
									alert("A "+data.error);
								}
							} 
						}
					},
					error: function (data, status, e)
					{
						alert(e);
					}
				}
			)
		/*}else if (fileSelected==0){
			if(currFileName==""){
				currFileName=$("fileToUpload").val();
			}
			//alert(currFileName);
			indexFile(currFileName,docid);
		}*/
		
		return false;

	}  
	function indexFile(file_name,doc_id){
		//alert(file_name+" , "+doc_id);
		$.post("http://www.perchards.com/db_widget_src/extractFile.php",
			   {
				   filename:""+file_name+""
				   }, function(data) {
				var cntry = document.getElementById("rcountry").value;
				var title = document.getElementById("rtitle").value;
				var fileloc = "../data_reports/"+file_name;
				var indxtxt = data;
				var gbp = document.getElementById("rgbp").value;
				var eur = document.getElementById("reur").value;
				var redirect = document.getElementById("redirectID").value;
				var dates = document.getElementById("datepicker").value;
				populateSectionArray();
				if(doc_id == 0){
					//alert("PUT");
					createReport(cntry,title,dates,fileloc,indxtxt,gbp,eur,redirect,global_sec,global_subsec);
				}else{
					//alert("EDIT");
					editReport(doc_id,cntry,title,dates,fileloc,indxtxt,gbp,eur,redirect,global_sec,global_subsec)
				}
			
			 });
		
	}
	function createReport(rcountry,rtitle,rdate,rfileloc,rindextext,rgbp,reur,redirect,sections,subsections){
		alert("Ln:2168 ----- Doc id: New - Sections: "+sections+" - Subsections: "+subsections+" - Redirect: "+redirect);
		$.post("http://www.perchards.com/db_widget_src/putReport.php",
			   {
				   country:""+rcountry+"",
				   title:""+rtitle+"",
				   date:""+rdate+"",
				   fileloc:""+rfileloc+"",
				   indextext:""+rindextext+"",
				   gbp:""+rgbp+"",
				   eur:""+reur+"",
				   redirectID:""+redirect+"",
				   sections:""+sections+"",
				   subsections:""+subsections+""
				   }, function(data) {
					   if(data == -1){
						    alert("Error creating document.");
							global_info = 0;
							global_sec = "";
							global_subsec = "";
					   }else{
							alert("Uploaded ----- "+data);
						   global_info = 0;
						   global_sec = "";
							global_subsec = "";
					   }
					//alert(global_info);
					closePage(this);
			 });
	}
	function editReport(docid,rcountry,rtitle,rdate,rfileloc,rindextext,rgbp,reur,redirect,sections,subsections){
		alert("Ln:2198 ----- Doc id: "+docid+" - Sections: "+sections+" - Subsections: "+subsections+" - Redirect: "+redirect);
		$.post("http://www.perchards.com/db_widget_src/updateReport.php",
			   {
				   docid:""+docid+"",
				   country:""+rcountry+"",
				   title:""+rtitle+"",
				   date:""+rdate+"",
				   fileloc:""+rfileloc+"",
				   indextext:""+rindextext+"",
				   gbp:""+rgbp+"",
				   eur:""+reur+"",
				   redirectID:""+redirect+"",
				   sections:""+sections+"",
				   subsections:""+subsections+""
				   }, function(data) {
					alert("Ln:2213 ----- "+data);
					global_info = 0;
				//Create arrays containing Section and subsection id's
					closePage(this);
				
			 });
	}
	function loadClients(){
		var clients = "";
		$.post("http://www.perchards.com/db_widget_src/getClients.php",function(data){
					var arrClients = data.split('£');
					for(s=0;s<arrClients.length-1;s++){
						var arrClient = arrClients[s].split('$');
						if(arrClient[2]){
							var activeString = "Active";
						} else {
							var activeString = "Suspended";
						}
						if(arrClient[3]!=""){
							var timestampStringArray = arrClient[3].split(' ');
							var dateStringArray = timestampStringArray[0].split('-');
							var dateString = dateStringArray[2]+"/"+dateStringArray[1]+"/"+dateStringArray[0]+"";
						} else {
							var dateString = "N/A";
						}
						
						 clients +="<div class='row_client' style='clear:both;float:left;margin:3px' onclick='showClientPage(\"edit\",\""+arrClient[0]+"\");'><div style='float:left; width:30px;'>"+arrClient[0]+"&nbsp;</div><div style='float:left; width:170px;'>"+arrClient[1]+"&nbsp;</div><div style='float:left; width:110px;'>"+arrClient[7]+" "+arrClient[8]+"&nbsp;</div><div style='float:left; width:70px;'>"+activeString+"&nbsp;</div><div style='float:left; width:70px;'>"+dateString+"&nbsp;</div><div style='float:left; width:70px;'>"+arrClient[4]+"&nbsp;</div><div style='float:left; width:200px;'>"+arrClient[5]+"&nbsp;</div><div style='float:left; width:50px;'>"+arrClient[6]+"&nbsp;</div></div>"
						
					}
				$("#clientList").html(clients);	
					});	
		
	}
	function showClientMain()
	{
		var clientShell = "<div id='' class='adminwidget'><div id='company_title' class='nr_line'>Client</div><div id='clientList' class='nr_line'></div><div id='sec_bot' class='nr_noline'><div class='imgSubSec'><img src='http://www.perchards.com/images/add-10x10.png' width='15px' height='15px' /></div><div class='subsec_cont' onclick='showClientPage(\"new\",\"\",\"\",\"\",\"\",\"\",\"\" );'> Add Client</div></div></div>"
		$("#tabcontent").html(clientShell);
		loadClients();
	}
	
	/* Add Documents Functions */
	
	function populateSectionsSelect()
	{
		$.post("http://www.perchards.com/db_widget_src/adminGetSections.php",function(data)
			{
					var sectionOptions = "<option value='-1'>Select Section</option>";

					var fullArray = data.split('@@@');
					var fullArraylen = fullArray.length - 1;
					for(pssi=0;pssi<fullArraylen;pssi++){
						var rowArray = fullArray[pssi].split('$$$');
							sectionOptions +="<option value='"+rowArray[0]+"'>"+rowArray[1]+"</option>";
					}

					$('select#sectionList').html(sectionOptions);
					$('select#sectionList').change(function() {
						var selectedSection = $('#sectionList').val();
						populateSubSectionsSelect(selectedSection);
					});
		});      	
	}
	
	function populateSubSectionsSelect(selectedSection)
	{
		$.post("http://www.perchards.com/db_widget_src/adminGetSubSections.php",
			   {section_id:""+selectedSection+""},
			   function(data)
				{
					var subSectionOptions = "<option value='-1'>Select Sub Section</option>";

					var fullArray = data.split('@@@');
					var fullArraylen = fullArray.length - 1;
					for(pssi=0;pssi<fullArraylen;pssi++){
						var rowArray = fullArray[pssi].split('$$$');
							subSectionOptions +="<option value='"+rowArray[0]+"'>"+rowArray[1]+"</option>";
					}

					$('select#subSectionList').html(subSectionOptions);
					$('select#subSectionList').change(function() {
						var selectedSubSection = $('#subSectionList').val();
						//alert(selectedSubSection);
						populateCountrySelect(selectedSubSection);
				});
		});      	
	}
	
	function populateCountrySelect(selectedSubSection)
	{
		$.post("http://www.perchards.com/db_widget_src/getCountries.php",function(data)
			{
					//alert(data);
					var countryOptions = "<option value='-1'>Select Country</option>";

					var fullArray = data.split('@');
					var fullArraylen = fullArray.length - 1;
					for(pssi=0;pssi<fullArraylen;pssi++){
						var rowArray = fullArray[pssi].split(',');
							countryOptions +="<option value='"+rowArray[0]+"'>"+rowArray[1]+"</option>";
					}

					$('select#countryList').html(countryOptions);
					$('select#countryList').change(function() {
						var selectedCountry = $('#countryList').val();
						//alert(selectedCountry);
						populateDocumentSelect(selectedCountry,selectedSubSection);
					});
		});      	
	}
	
	function insertNewDocument(selectedDocument)
	{
		var selectedClient = document.getElementById('txtClientID').value;
		$.post("http://www.perchards.com/db_widget_src/adminInsertDocument.php",
			{
				   client_ID:""+selectedClient+"",
				   doc_ID:""+selectedDocument+""
			},
			function(data)
			{
				alert(data);
				showClientPage("edit",selectedClient);
			}
		);
	}
	
	function populateDocumentSelect(selectedCountry,selectedSubSection)
	{
		$.post("http://www.perchards.com/db_widget_src/adminGetDocuments.php",
			{
				   subSection_id:""+selectedSubSection+"",
				   country_id:""+selectedCountry+""
			},
			function(data)
			{
					//alert(data);
					var documentOptions = "<option value='-1'>Select Document</option>";

					var fullArray = data.split('@@@');
					var fullArraylen = fullArray.length - 1;
					for(pssi=0;pssi<fullArraylen;pssi++){
						var rowArray = fullArray[pssi].split('$$$');
							documentOptions +="<option value='"+rowArray[0]+"'>"+rowArray[1]+"</option>";
					}

					$('select#documentList').html(documentOptions);
					$('select#documentList').change(function() {
						var selectedDocument = $('#documentList').val();
						//alert(selectedDocument);
						insertNewDocument(selectedDocument);
					});
		});      	
	}
	
	function adminCancelAddDocuments()
	{
		$('#additionalDocButton').html("<a href='javascript:void(0);adminAddDocuments()'>[ Add ]</a>");
	}
	
	function adminAddDocuments()
	{
		$('#additionalDocButton').html("<div id='selectDocumentDiv'><form id='addDocsForm' name='addDocsForm' style='border-bottom:1px solid gray;margin-bottom:6px; padding-bottom:6px; font-size: 9px;'><select id='sectionList'><option value='-1'>Section</option></select><select id='subSectionList'><option value='-1'>Sub Section</option></select><select id='countryList'><option value='-1'>Country</option></select><br/><select id='documentList'><option value='-1'>Document</option></select></form></div><a href='javascript:void(0);adminCancelAddDocuments()'>[ Cancel ]</a>");
		setTimeout(populateSectionsSelect(),1000);
	}

	function showClientPage(updateFlag,clientID)
	{
		var clientShell = "<div id='' class='adminwidget'><table><tr><td><input id='txtClientID' type='hidden' value=''/>Company Name:</td><td><input id='txtCompanyName' size='40px' type='text' value=''/></td></tr><tr><td>Branch:</td><td><input id='txtBranch' size='40px' type='text' value=''/></td></tr><tr><td>First Name:</td><td><input id='txtFirstName' size='40px' type='text' value=''/></td></tr><tr><td>Last Name:</td><td><input id='txtLastName' size='40px' type='text' value=''/></td></tr><tr><td>Email:</td><td><input id='txtEmail' size='40px' type='text' value=''/></td></tr><tr><td>Phone:</td><td><input id='txtPhone' size='40px' type='text' value=''/></td></tr><tr><td>Fax:</td><td><input id='txtFax' size='40px' type='text' value=''/></td></tr><tr><td>Address:</td><td><input id='txtAddress1' size='40px' type='text' value=''/></td></tr><tr><td>Address:</td><td><input id='txtAddress2' size='40px' type='text' value=''/></td></tr><tr><td>Town/City:</td><td><input id='txtTown' size='40px' type='text' value=''/></td></tr><tr><td>County/State:</td><td><input id='txtCounty' size='40px' type='text' value=''/></td></tr><tr><td>Postcode:</td><td><input id='txtPostcode' size='40px' type='text' value=''/></td></tr><tr><td>Country:</td><td><input id='txtCountry' size='40px' type='text' value=''/></td></tr><tr><td>Username:</td><td><input id='txtUsername' size='40px' type='text' value=''/></td></tr><tr><td>Password:</td><td><input id='txtPassword' size='40px' type='text' value=''/></td></tr><tr><td>Subscription Package:</td><td><select id='txtSubscPackage' ><option value='-select-'>-select-</option></select></td></tr><tr><td>Start Date:</td><td><input id='txtSubscStartDate' size='40px' type='text' value=''/>(YYYY-MM-DD)</td></tr><tr><td>Expiry Date:</td><td><input id='txtSubscExpiryDate' size='40px' type='text' value=''/>(YYYY-MM-DD)</td></tr><tr><td>Subscription Cost:</td><td><input id='txtSubscCost' size='40px' type='text' value=''/></td></tr><tr><td>Additional Documents:</td><td style='border:1px solid #ccc; padding:4px; font-size:12px; color: black'><div id='additionalDocDiv'>None</div><div id='additionalDocButton'><a href='javascript:void(0);adminAddDocuments()'>[ Add ]</a></div></td></tr><tr><td>Payment:</td><td><input id='txtPayment' size='40px' type='text' value=''/></td></tr><tr><td>Active:</td><td><input id='txtActive' size='40px' type='checkbox' value=''/></td></tr><tr><td>Newsletter:</td><td><input id='txtNewsletter' size='40px' type='checkbox' value=''/></td></tr></table><div id='sec_bot' class='nr_noline' style='clear:both'><input id='btUpdate' type='button' value='Add' onclick='javascript:updateClient();'/><input id='btDelete' type='button' value='Delete' onclick='javascript:deleteClient();'/><input id='btBack' type='button' value='Back' onclick='javascript:showClientMain();'/></div></div><br/><br/><br/><br/><br/><br/><br/><br/></div>";
		$("#tabcontent").html(clientShell);
		if(updateFlag=="edit"){
			document.getElementById('btUpdate').value = "Update";
			$.ajax({
				url: 'http://www.perchards.com/db_widget_src/admin_getClientDetails.php',
				data: 'clientID='+clientID+'',			
				type: 'POST',
				dataType: 'json',
				success: function(data) {
					update_CompanyName = data.return_CompanyName;
					update_Branch = data.return_Branch;
					update_FirstName = data.return_FirstName;
					update_LastName = data.return_LastName;
					update_Email = data.return_Email;
					update_Username = data.return_Username;
					update_Phone = data.return_Phone;
					update_Fax = data.return_Fax;
					update_Address1 = data.return_Address_1;
					update_Address2 = data.return_Address_2;
					update_Town = data.return_Town;
					update_County = data.return_County;
					update_Postcode = data.return_Postcode;
					update_Country = data.return_Country;
					update_Password = data.return_Password;
					update_SubscPackageID = data.return_SubscPackageID;
					update_SubscPackage = data.return_SubscPackage;
					update_AddDocsCount = data.return_AddDocsCount;
					update_SubscStartDate =  data.return_SubscStartDate;
					update_SubscExpiryDate = data.return_SubscExpiryDate;
					update_SubscCost = data.return_SubscCost;
					update_Payment = data.return_Payment;
					update_Active = data.return_Active;
					update_Newsletter = data.return_Newsletter;
					//alert(data.return_AddDocsCount);
					if(data.return_AddDocsCount>0){
						var addDocsString ="<table style='border-bottom:1px solid gray; margin-bottom:6px;'><tr style='font-weight:bold'><td style='padding:3px 6px;'>ID</td><td style='padding:3px 6px;'>Section</td><td style='padding:3px 6px;'>SubSection</td><td style='padding:3px 6px;'>Country</td><td style='padding:3px 6px;'>Title</td><td style='padding:3px 6px;'></td></tr>";
						for(i=0; i<data.return_AddDocsCount; i++){
							//alert(i);
							var documentID = 'data.return_DocID'+i;
							var documentTitle = 'data.return_DocTitle'+i;
							var documentCountry = 'data.return_DocCountry'+i;
							var documentSection = 'data.return_DocSection'+i;
							var documentSubSection = 'data.return_DocSubSection'+i;
							//alert(eval(documentTitle));
							eval("var update_AddDocID" + i +"='"+ eval(documentID)+"';");
							eval("var update_AddDocTitle" + i +"='"+ eval(documentTitle)+"';");
							eval("var update_AddDocCountry" + i +"='"+ eval(documentCountry)+"';");
							eval("var update_AddDocSection" + i +"='"+ eval(documentSection)+"';");
							eval("var update_AddDocSubSection" + i +"='"+ eval(documentSubSection)+"';");
							//alert(eval('update_AddDoc'+i));
							addDocsString +="<tr><td style='padding:3px 6px;'>";
							addDocsString += eval('update_AddDocID'+i);
							addDocsString +="</td><td style='padding:3px 6px;'>";
							addDocsString += eval('update_AddDocSection'+i);
							addDocsString +="</td><td style='padding:3px 6px;'>";
							addDocsString += eval('update_AddDocSubSection'+i);
							addDocsString +="</td><td style='padding:3px 6px;'>";
							addDocsString += eval('update_AddDocCountry'+i);
							addDocsString +="</td><td style='padding:3px 6px;'>";
							addDocsString += eval('update_AddDocTitle'+i);
							addDocsString +="</td><td style='padding:3px 6px;'>";
							addDocsString +="</td></tr>";
						}
						addDocsString +="</table>";
						$('#additionalDocDiv').html(addDocsString);
					} 
					document.getElementById('txtClientID').value = clientID;
					document.getElementById('txtCompanyName').value = update_CompanyName;
					document.getElementById('txtBranch').value = update_Branch;
					document.getElementById('txtFirstName').value = update_FirstName;
					document.getElementById('txtLastName').value = update_LastName;
					document.getElementById('txtEmail').value = update_Email;
					document.getElementById('txtPhone').value = update_Phone;
					document.getElementById('txtFax').value = update_Fax;
					document.getElementById('txtAddress1').value = update_Address1;
					document.getElementById('txtAddress2').value = update_Address2;
					document.getElementById('txtTown').value = update_Town;
					document.getElementById('txtCounty').value = update_County;
					document.getElementById('txtPostcode').value = update_Postcode;
					document.getElementById('txtCountry').value = update_Country;
					document.getElementById('txtCounty').value = update_County;
					document.getElementById('txtUsername').value = update_Username;
					document.getElementById('txtPassword').value = update_Password;
						var selBox = document.getElementById('txtSubscPackage');
						selBox.remove(0);
						var newoption = document.createElement('option');
						newoption.text = update_SubscPackage;
						newoption.value = update_SubscPackageID;
						try
						{
							selBox.add(newoption,null);
						}catch(ex)
						{
							selBox.add(newoption); //For IE
						}
						loadSubscCombo('txtSubscPackage',update_SubscPackageID);
					document.getElementById('txtSubscStartDate').value = update_SubscStartDate;
					document.getElementById('txtSubscExpiryDate').value = update_SubscExpiryDate;
					document.getElementById('txtSubscCost').value = update_SubscCost;
					document.getElementById('txtPayment').value = update_Payment;
					
					if(update_Active == 1){
						document.getElementById('txtActive').checked = true;
					}else{
						document.getElementById('txtActive').checked = false;
					}
					if(update_Newsletter == 1){
						document.getElementById('txtNewsletter').checked = true;
					}else{
						document.getElementById('txtNewsletter').checked = false;
					}
				
				}
			});
		}else{
			document.getElementById('btUpdate').value = "Add";
			loadSubscCombo('txtSubscPackage',"");
		}
		
		$(function() {
			$('#txtSubscStartDate').datepick();
		});
	}
	function loadSubscCombo(ComboName,SubscID){
		var selBox = document.getElementById(ComboName);
		$.post("http://www.perchards.com/db_widget_src/getSubscriptionInfo.php",function(data){
			   //alert(data);
			   var datar = data.split('@');
			   for(x=0;x<datar.length-1;x++){
				  var secar = datar[x].split('£$');
				  if(secar[0] == SubscID){}else{
				  var newoption = document.createElement('option');
						newoption.text = secar[1];
						newoption.value = secar[0];
						try
						{
							selBox.add(newoption,null);
						}catch(ex)
						{
							selBox.add(newoption); //For IE
						}
				  }
			   }
						   });
	}
	function deleteClient(){
		var ClientID = 0;
		if(document.getElementById('txtClientID').value == ""){
			alert("Illegal function...nothing to delete.");
		}else{
		ClientID = document.getElementById('txtClientID').value;
		$.post("http://www.perchards.com/db_widget_src/deleteClient.php",
			   {client_id:""+ClientID+""},
			   function(data){
					if(data==1){
						alert("Client deleted.")
						showClientMain();
					}else{alert("Error deleting client,Contact Administrator.");}
																							 
					});
		}
	}
	function updateClient()
	{
					var Active =0;
					var Newsletter = 0;
		
					ClientID = document.getElementById('txtClientID').value;
					CompanyName = document.getElementById('txtCompanyName').value ;
					Branch = document.getElementById('txtBranch').value ;
					FirstName = document.getElementById('txtFirstName').value ;
					LastName = document.getElementById('txtLastName').value ;
					Email = document.getElementById('txtEmail').value ;
					Phone = document.getElementById('txtPhone').value;
					Fax = document.getElementById('txtFax').value;
					Address1 = document.getElementById('txtAddress1').value;
					Address2 = document.getElementById('txtAddress2').value;
					Town = document.getElementById('txtTown').value;
					County = document.getElementById('txtCounty').value;
					Postcode = document.getElementById('txtPostcode').value;
					Country = document.getElementById('txtCountry').value;
					Username = document.getElementById('txtUsername').value;
					Password = document.getElementById('txtPassword').value;
					Package = document.getElementById('txtSubscPackage').value;
					StartDate = document.getElementById('txtSubscStartDate').value;
					ExpiryDate = document.getElementById('txtSubscExpiryDate').value;
					SubscCost = document.getElementById('txtSubscCost').value;
					Payment = document.getElementById('txtPayment').value;
					if(document.getElementById('txtActive').checked== true){
						Active = 1;
					}
					if(document.getElementById('txtNewsletter').checked==true){
						Newsletter = 1;
					}
					/*alert(ClientID+","+CompanyName+","+Branch+","+FirstName+","+LastName+","+Email+","+Phone +","+Fax+","+Address1+","+Address2+","+Town+","+County+","+Postcode+","+Country+","+Username+","+Password+","+Package+","+StartDate+","+ExpiryDate+","+Payment+","+Active+","+Newsletter+",");*/
			$.post("http://www.perchards.com/db_widget_src/updateClient.php",
			   {
				   client_id:""+ClientID+"",
			   	   comp_name:""+CompanyName+"",
				   branch:""+Branch+"",
				   f_name:""+FirstName+"",
				   l_name:""+LastName+"",
				   email:""+Email+"",
				   phone:""+Phone+"",
				   fax:""+Fax+"",
				   add1:""+Address1+"",
				   add2:""+Address2+"",
				   town:""+Town+"",
				   county:""+County+"",
				   pc:""+Postcode+"",
				   cntry:""+Country+"",
				   user:""+Username+"",
				   pass:""+Password+"",
				   pack:""+Package+"",
				   strtdate:""+StartDate+"",
				   expdate:""+ExpiryDate+"",
				   subsccost:""+SubscCost+"",
				   pyment:""+Payment+"",
				   active:""+Active+"",
				   newsletter:""+Newsletter+""
			   },
			   function(data){
				   //alert(data);
					if(data==1){
						alert("Client Added/Updated.");
						showClientMain();
					}else{alert("Error adding/updating client,Contact Administrator.");}
																							 
					})
}
function deleteThisDocument(documentID){
	var confirmOut = confirm("This document may be linked to clients/subscription/sections. Do you want to delete?");
	if(confirmOut){
	$.post("http://www.perchards.com/db_widget_src/deleteDocument.php",{'document_id':documentID},function(data){
					//alert(data);																						
		  if(data == 1){
				var reportRow = "#reportRow"+documentID;
				$(reportRow).remove();
			   alert("Document deleted.");
		   }else{
			   alert("Error deleting document.")
		   }
						  });
	}else{}
}
function deleteThisNews(newsID){
	var confirmOut = confirm("Do you want to delete this article?");
	if(confirmOut){
		$.post("http://www.perchards.com/db_widget_src/deleteNews.php",{'news_id':newsID},function(data){
					//alert(data);																						
			if(data == 1){
				var newsRow = "#newsRow"+newsID;
				$(newsRow).remove();
				alert("Document deleted. Code: "+data);
			}else{
				alert("Error deleting document. Code: "+data)
			}
		});
	}else{}
}
function deleteThisEvent(eventID){
	var confirmOut = confirm("Do you want to delete this article?");
	if(confirmOut){
		$.post("http://www.perchards.com/db_widget_src/deleteEvent.php",{'event_id':eventID},function(data){
					//alert(data);																						
			if(data == 1){
				var eventRow = "#eventRow"+eventID;
				$(eventRow).remove();
				alert("Document deleted. Code: "+data);
			}else{
				alert("Error deleting document. Code: "+data)
			}
		});
	}else{}
}
function triggerTinyMCE() {
	setTimeout(function () {
		tinyMCE.execCommand('mceRemoveControl',false,'eml_form_bodyText');
		//tinyMCE.execCommand('mceAddControl',false,'eml_form_bodyText');	
		tinyMCE.execCommand('mceRemoveControl',false,'page_content');
		tinyMCE.execCommand('mceAddControl',false,'page_content');	
		tinyMCE.execCommand('mceRemoveControl',false,'page_links');
		tinyMCE.execCommand('mceAddControl',false,'page_links');	
	}, 3000);
}
function clearTinyMCE() {	
	setTimeout(function () {
		tinyMCE.execCommand('mceRemoveControl',false,'eml_form_bodyText');
		tinyMCE.execCommand('mceRemoveControl',false,'page_content');
		tinyMCE.execCommand('mceRemoveControl',false,'page_links');
	}, 1000);
}
function adActivateUpdate(){
	//$('#legisButton').html("<span onclick='callSearch(1);'>Update</span>");
	$("#legisButton").removeClass("disableUpdate").addClass("enableUpdate");
	$("#legisButton").click(function(){adcallSearch()});
	$("#cntryButton").removeClass("disableUpdate").addClass("enableUpdate");
	$("#cntryButton").click(function(){adcallSearch()});
	$("#typeButton").removeClass("disableUpdate").addClass("enableUpdate");
	$("#typeButton").click(function(){adcallSearch()});
}

/* Email Preview Functions */
function emailTest(){
	//alert("Email Test");
	$.post("http://www.perchards.com/db_widget_src/email_testSend.php",function(data){
		//alert(data);																						
	});
	alert("Test Email sent, please check your inbox");
}

/* Change to preview layout */
function showPreview(){
	//alert("ln 2688: showPreview");
	var emailPreviewLayout = "<div id='emailPreviewDiv' class='adminwidget'><div id='emailTitle' class='nr_line'>Email Preview</div><div id='emailContent' class='nr_line' style='border:1px solid gray;'>";
	emailPreviewLayout += "<table width='100%'>";
	emailPreviewLayout += "<tr><td><div style='margin:0 auto;width:500px;'><img src='http://www.perchards.com/images/email_header_1.jpg'/></div><td><tr>";
	emailPreviewLayout += "<tr><td><div style='margin:0 auto;width:500px;'>";
	emailPreviewLayout += "<h1>"+formEmailTitle+"</h1>";
	emailPreviewLayout += formEmailText;
	emailPreviewLayout += "<p style='border-bottom: 1px solid gray;'>&nbsp;</p>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "<tr><td><div id='emailPreviewNewsTitle' style='margin:0 auto;width:500px;'>";
	//emailPreviewLayout += "<h2>Latest News Updates</h2>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "<tr><td><div id='emailPreviewNews' style='margin:0 auto;width:500px;'>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "<tr><td><div id='emailPreviewEventTitle' style='margin:0 auto;width:500px;'>";
	//emailPreviewLayout += "<h2>Latest Event Updates</h2>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "<tr><td><div id='emailPreviewEvents' style='margin:0 auto;width:500px;'>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "<tr><td><div style='margin:0 auto;width:500px;'>";
	emailPreviewLayout += "<p style='font-size:9px'>This email has been sent to our subscribers to keep you updated with the latest news and events. If you do not want to recieve these emails or if you believe it was sent in error, please email <a href='mailto:admin@perchards.com'>admin@perchards.com</a></p>";
	emailPreviewLayout += "<p><a href='http://www.perchards.com'>www.perchards.com</a></p>";
	emailPreviewLayout += "</div><td><tr>";
	emailPreviewLayout += "</table>";
	emailPreviewLayout += "</div><div style='padding:5px'>";
	emailPreviewLayout += "<input type='button' value='Back' onclick='emailAdmin();'/><input type='button' value='Test' onclick='emailTest();'/>";
	emailPreviewLayout += "</div></div>";

	$("#tabcontent").html(emailPreviewLayout);
	/* Get Selected News And Events */
	
	setTimeout(populateSelectedItems('preview'),1000);
}

/* Save Selected News And Events */
function saveSelectedEmailItems(){
	var x=document.getElementById("eml_form_selected");
	//var x=$("#eml_form_selected");
	var i;
	//alert("ln 2699 : "+x.length);
	if(x.length>0){
		for (i=0;i<x.length;i++)
		{
			var selectedOptionVal = $("#eml_form_selected option").eq(i).val();
			var selectedOptionID = $("#eml_form_selected option").eq(i).attr("id");
			var selectedOptionType = selectedOptionID.charAt(0);
			$.post("http://www.perchards.com/db_widget_src/email_updateContent.php",{'post_eml_OptionType':selectedOptionType,'post_eml_OptionVal':selectedOptionVal},function(data){
				//alert(data);																						
			});
		}
	}
	showPreview();
}

var formEmailTitle = "";
var formEmailText = "";

function emailPreview(){
	
	/* Save Title and Body Text */
	formEmailTitle = $("#eml_form_bodyTitle").val();
	formEmailText = tinyMCE.get('eml_form_bodyText').getContent()
	$.post("http://www.perchards.com/db_widget_src/email_updateDetails.php",{'post_eml_BodyTitle':formEmailTitle,'post_eml_BodyText':formEmailText},function(data){
		//alert(data);																						
	});

	/* Delete Previous News And Events Before Adding New*/
	$.post("http://www.perchards.com/db_widget_src/email_deleteOptions.php",function(ydata){
		//alert("ln 2695: "+ydata);
		saveSelectedEmailItems();
																					
	});	

	
	
}

/* Email Admin Functions */
function addEvents(){
	var selVal = $("#eml_form_events").val();
	var selText = $("#eml_form_events option:selected").html();
	var selectedOptionString = "";
	selectedOptionString += "<option id='";
	selectedOptionString += "eSelOpt"+selVal;
	selectedOptionString += "' value='";
	//selectedOptionString += "<option value='";
	selectedOptionString += selVal;
	selectedOptionString += "'>";
	selectedOptionString += selText;
	selectedOptionString += "</option>";
	$('#eml_form_selected').append(selectedOptionString);	
}
function addNews(){
	var selVal = $("#eml_form_news").val();
	var selText = $("#eml_form_news option:selected").html();
	var selectedOptionString = "";
	selectedOptionString += "<option id='";
	selectedOptionString += "nSelOpt"+selVal;
	selectedOptionString += "' value='";
	//selectedOptionString += "<option value='";
	selectedOptionString += selVal;
	selectedOptionString += "'>";
	selectedOptionString += selText;
	selectedOptionString += "</option>";
	$('#eml_form_selected').append(selectedOptionString);	
}
function removeFromSelected(){
	/*var selVal = $("#eml_form_selected").val();
	alert(selVal);*/
	var selID = $("#eml_form_selected option:selected").attr("id");
	//alert(selID);
	$("#"+selID).remove();
}
function populateEmailForm(){
	$.post("http://www.perchards.com/db_widget_src/email_populate.php",function(data){
		//alert(data);				
		var emailArray = data.split('@');
		var emailTitle = emailArray[0];
		var emailText = emailArray[1];
		//alert(emailTitle+","+emailText);
		$('#eml_form_bodyTitle').val(emailTitle);
		$('#eml_form_bodyText').val(emailText);																
	});	
}
function populateEmailEvents(){
	$.post("http://www.perchards.com/db_widget_src/email_events.php",function(data){
		//alert(data);		
		var eventsOptionString = "";		
		var emailEventsArray = data.split('@@@');
		//alert("number of news: "+emailNewsArray.length);
		var emailEventsArrayLength = emailEventsArray.length -1;
		for(i=0;i<emailEventsArrayLength;i++){
			
			var eventsRowArray = emailEventsArray[i].split('$$$');
			var timestamp = eventsRowArray[2].split(' ');
			var datex = timestamp[0];
			eventsOptionString += "<option id='";
			eventsOptionString += "eventOpt"+eventsRowArray[0];
			eventsOptionString += "' value='";
			//eventsOptionString += "<option value='";
			eventsOptionString += eventsRowArray[0];
			eventsOptionString += "'>";
			eventsOptionString += eventsRowArray[1]+" ("+datex+")";
			eventsOptionString += "</option>";
		}
		$('#eml_form_events').html(eventsOptionString);															
	});
}
function populateEmailNews(){
	$.post("http://www.perchards.com/db_widget_src/email_news.php",function(data){
		//alert(data);		
		var newsOptionString = "";		
		var emailNewsArray = data.split('@@@');
		//alert("number of news: "+emailNewsArray.length);
		var emailNewsArrayLength = emailNewsArray.length -1;
		for(i=0;i<emailNewsArrayLength;i++){
			
			var newsRowArray = emailNewsArray[i].split('$$$');
			var timestamp = newsRowArray[2].split(' ');
			var datex = timestamp[0];
			newsOptionString += "<option id='";
			newsOptionString += "newsOpt"+newsRowArray[0];
			newsOptionString += "' value='";
			//newsOptionString += "<option value='";
			newsOptionString += newsRowArray[0];
			newsOptionString += "'>";
			newsOptionString += newsRowArray[1]+" ("+datex+")";
			newsOptionString += "</option>";
		}
		$('#eml_form_news').html(newsOptionString);															
	});
}
function getEmailSelectedItem(itemType,itemID,step){
	//alert(step+","+itemType+","+itemID);
	if(itemType=="n"){
		//alert(itemID);
		$.post("http://www.perchards.com/db_widget_src/email_newsItem.php",
			{post_eml_newsID:""+itemID+""},
			function(data){
				//alert(data);
				var selectedRowArray = data.split('$$$');
				var timestamp = selectedRowArray[2].split(' ');
				var datex = timestamp[0];
				var selectedOptionString = "";
				
				if(step=="build"){
					selectedOptionString += "<option id='";
					selectedOptionString += "nSelOpt"+selectedRowArray[0];
					selectedOptionString += "' value='";
					selectedOptionString += selectedRowArray[0];
					selectedOptionString += "'>";
					selectedOptionString += selectedRowArray[1]+" ("+datex+")";
					selectedOptionString += "</option>";
					$('#eml_form_selected').append(selectedOptionString);	
				}else if(step=="preview"){
					if($("#emailPreviewNewsTitle").html()==""){
						 $("#emailPreviewNewsTitle").html("<h2>Latest News Updates</h2>");
					}
					//$("#emailPreviewNewsTitle").append("<a href='#emailPreviewNewsItem"+emailPreviewNewsCounter+">"+selectedRowArray[1]+"</a>");
					$("#emailPreviewNewsTitle").append("<div style='padding:6px; background-color:#ececec;'><a href='#emailPreviewNewsItem"+emailPreviewNewsCounter+"'>"+selectedRowArray[1]+"</a></div>");
					selectedOptionString += "<h3";
					selectedOptionString += " id='emailPreviewNewsItem"+emailPreviewNewsCounter;
					selectedOptionString += "'>";
					emailPreviewNewsCounter++;
					selectedOptionString += selectedRowArray[1];
					selectedOptionString += "</h3>";
					selectedOptionString += "<p><em>";
					selectedOptionString += datex;
					selectedOptionString += "</em></p>";
					selectedOptionString += "<p>";
					selectedOptionString += selectedRowArray[3];
					selectedOptionString += "</p>";
					selectedOptionString += "<p style='border-bottom: 1px solid gray;'>&nbsp;</p>";
					$('#emailPreviewNews').append(selectedOptionString);
					
				}
		});
	}else if (itemType=="e"){
		//alert(itemID);
		$.post("http://www.perchards.com/db_widget_src/email_eventItem.php",
			{post_eml_eventID:""+itemID+""},
			function(data){
				//alert(data);
				var selectedRowArray = data.split('$$$');
				//alert(selectedRowArray[2]);
				var timestamp = selectedRowArray[2].split(' ');
				var datex = timestamp[0];
				var selectedOptionString = "";
				
				if(step=="build"){
					selectedOptionString += "<option id='";
					selectedOptionString += "eSelOpt"+selectedRowArray[0];
					selectedOptionString += "' value='";
					selectedOptionString += selectedRowArray[0];
					selectedOptionString += "'>";
					selectedOptionString += selectedRowArray[1]+" ("+datex+")";
					selectedOptionString += "</option>";
					$('#eml_form_selected').append(selectedOptionString);	
				}else if(step=="preview"){
					if($("#emailPreviewEventTitle").html()==""){
						 $("#emailPreviewEventTitle").html("<h2>Latest Event Updates</h2>");
					}
					//$("#emailPreviewEventTitle").append("<a href='#emailPreviewEventsItem"+emailPreviewEventsCounter+">"+selectedRowArray[1]+"</a>");
					$("#emailPreviewEventTitle").append("<div style='padding:6px; background-color:#ececec;'><a href='#emailPreviewNewsItem"+emailPreviewNewsCounter+"'>"+selectedRowArray[1]+"</a></div>");
					selectedOptionString += "<h3";
					selectedOptionString += " id='emailPreviewNewsItem"+emailPreviewNewsCounter;
					selectedOptionString += "'>";
					emailPreviewNewsCounter++;
					selectedOptionString += selectedRowArray[1];
					selectedOptionString += "</h3>";
					selectedOptionString += "<p><em>";
					selectedOptionString += datex;
					selectedOptionString += "</em></p>";
					selectedOptionString += "<p>";
					selectedOptionString += selectedRowArray[3];
					selectedOptionString += "</p>";
					selectedOptionString += "<p style='border-bottom: 1px solid gray;'>&nbsp;</p>";
					$('#emailPreviewEvents').append(selectedOptionString);
				}
		});
	}else{
		alert("incorrect item type passed");
	}

}
function populateSelectedItems(step){
	//alert("ln 2897: "+ step);
	$.post("http://www.perchards.com/db_widget_src/email_selected.php",function(data){
		//alert("ln 2899: "+data);		
		var selectedOptionString = "";		
		var emailSelectedArray = data.split('@@@');
		//alert("number of news: "+emailNewsArray.length);
		var emailSelectedArrayLength = emailSelectedArray.length -1;
		for(i=0;i<emailSelectedArrayLength;i++){
			var emailSelectedArrayRow = emailSelectedArray[i].split('$$$');
			setTimeout(getEmailSelectedItem(emailSelectedArrayRow[1],emailSelectedArrayRow[0],step),1000);			
		}															
	});
}
function emailAdmin(){
	var emailAdminForm = "<div id='emailAdminDiv' class='adminwidget'><div id='emailTitle' class='nr_line'>Email Administration</div><div id='emailContent' class='nr_line'>";
	emailAdminForm += "<div id='email_BodyTitle' class='email_FormLabel'><p>Body Title</p></div><div class='email_FormInput'><input type='text' name='eml_form_bodyTitle' id='eml_form_bodyTitle'/></div>";
	emailAdminForm += "<div id='email_BodyText' class='email_FormLabel'><p>Body Text</p></div><div class='email_FormInput'><textarea cols='60' rows='10' name='eml_form_bodyText' id='eml_form_bodyText'></textarea></div>";
	emailAdminForm += "<div id='email_NewsList' class='email_FormLabel'><p>News Items</p></div><div class='email_FormInput'><select width='500px' name='eml_form_news' id='eml_form_news' size='10' multiple></select></div>";
	emailAdminForm += "<div class='email_FormLabel'><p>&nbsp;</p></div><div class='email_FormInput'><input class='stdButton' type='button' name='addNewsBtn' value='Add' onclick='addNews();'></div>";
	emailAdminForm += "<div id='email_EventList' class='email_FormLabel'><p>Event Items</p></div><div class='email_FormInput'><select width='500px' name='eml_form_events' id='eml_form_events' size='10' multiple></select></div>";
	emailAdminForm += "<div class='email_FormLabel'><p>&nbsp;</p></div><div class='email_FormInput'><input class='stdButton' type='button' name='addEventsBtn' value='Add' onclick='addEvents();'></div>";
	emailAdminForm += "<div id='email_SelectedList' class='email_FormLabel'><p>Selected</p></div><div class='email_FormInput' id='selectedDiv'><select style='width: 500px' width='500px' name='eml_form_selected' id='eml_form_selected' size='10' multiple></select></div>";
	emailAdminForm += "<div class='email_FormLabel'><p>&nbsp;</p></div><div class='email_FormInput'><input class='stdButton' type='button' name='removeSelectedBtn' value='Remove' onclick='removeFromSelected();'></div>";
	emailAdminForm += "<hr/><div class='email_FormLabel'><p>&nbsp;</p></div><div class='email_FormInput'><input class='stdButton' type='button' name='previewBtn' value='Preview Email' onclick='emailPreview();'></div>";
	emailAdminForm += "</div></div>";
	//alert("Email Administration");
	$("#tabcontent").html(emailAdminForm);
	populateEmailForm();
	setTimeout(function () {
		tinyMCE.execCommand('mceRemoveControl',false,'eml_form_bodyText');
		tinyMCE.execCommand('mceAddControl',false,'eml_form_bodyText');
		//alert("tiny mce");
	}, 1000);
	populateEmailNews();
	populateEmailEvents();
	populateSelectedItems('build');
}