var insecureGetSelectServletURL='/servlets/InsecureGetSelectServlet';

var secureGetSelectServletURL='/secured/admin/servlets/SecureGetSelectServlet';

var verySecureGetSelectServletURL='/secured/sa/servlets/VerySecureGetSelectServlet';

var userRecordTemplateURL='/templatePages/user_record_template.html';

var reviewRecordTemplateURL='/templatePages/review_record_template.html';

var eventRecordTemplateURL='/templatePages/event_record_template.html';

var playbookRecordTemplateURL='/templatePages/playbook_record_template.html';

var inappropriateRecordTemplateURL='/templatePages/inappropriate_record_template.html';

var complimentRecordTemplateURL='/templatePages/compliment_record_template.html';

var feedbackServletURL='/secured/servlets/FeedbackServlet';

var secureUserUtilServletURL='/secured/servlets/SecureUserUtilServlet';

var insecureUserUtilServletURL='/servlets/InsecureUserUtilServlet';


    function createCookie(name,value,days) {
        if (days) {
            var date = new Date();
            date.setTime(date.getTime()+(days*24*60*60*1000));
            var expires = "; expires="+date.toGMTString();
        }
        else var expires = "";
        document.cookie = name+"="+value+expires+"; path=/";
    }

    function eraseCookie(name) {
        createCookie(name,"",-1);
    }

    function readCookie(name) {
        var nameEQ = name + "=";
        var ca = document.cookie.split(';');
        for(var i=0;i < ca.length;i++) {
            var c = ca[i];
            while (c.charAt(0)==' ') c = c.substring(1,c.length);
            if (c.indexOf(nameEQ) == 0) return c.substring(nameEQ.length,c.length);
        }
        return null;
    }

function validateComplaintForm(frm)
{
  var itemID=frm.itemid.value;
  var submitter=frm.submitterid.value;
  var text=frm.complaint.value;
  var tp=frm.formtype.value;
  var url=feedbackServletURL;
  var xy='',xx='';

  if(itemID!=null)
  {
    if(itemID!='')
    {
      if(submitter!=null)
      {
        if(submitter!='')
        {
          if(text!=null)
          {
            if(text!='')
            {
              if(tp=='pb' || tp=='rv' || tp=='hd')
              {
                if(tp=='pb')
                  url=url+'/PlaybookComplaint';
                if(tp=='rv')
                  url=url+'/ReviewComplaint';
                if(tp=='hd')
                  url=url+'/HuddleComplaint';

                url=url+"?SID="+submitter;
                url=url+"&IID="+itemID;
                url=url+"&TXT="+escape(text);
                xy=getFromServer(url);
                if(xy.charAt(0)=='E' && xy.charAt(1)=='R' && xy.charAt(2)=='R' && xy.charAt(3)==':')
                {
                  xx=xy.substr(4);
                  alert('An error occured processing your request : '+xx);
                }
                else
                  alert('You have successfully requested that the selected content me marked as inappropriate');
              }
              else
                alert('Unknown complaint type');
            }
            else
              alert('Missing Text');
          }
          else
            alert('Missing Text');
        }
        else
          alert('Missing Submitter ID');
      }
      else
        alert('Missing Submitter ID');
    }
    else
      alert('Missing Item ID');
  }
  else
    alert('Missing Item ID');

  this.close();
  return(false);
}

function validateComplimentForm(frm)
{
  var itemID=frm.itemid.value;
  var submitter=frm.submitterid.value;
  var text=frm.compliment.value;
  var tp=frm.formtype.value;
  var url=feedbackServletURL;
  var xy='',xx='';

  if(itemID!=null)
  {
    if(itemID!='')
    {
      if(submitter!=null)
      {
        if(submitter!='')
        {
          if(text!=null)
          {
            if(text!='')
            {
              if(tp=='rv')
              {
                url=url+'/ReviewCompliment';

                url=url+"?SID="+submitter;
                url=url+"&IID="+itemID;
                url=url+"&TXT="+escape(text);
                xy=getFromServer(url);
                if(xy.charAt(0)=='E' && xy.charAt(1)=='R' && xy.charAt(2)=='R' && xy.charAt(3)==':')
                {
                  xx=xy.substr(4);
                  alert('An error occured processing your request : '+xx);
                }
                else
                  alert('You have successfully complimented the selected content');
              }
              else
                alert('Unknown compliment type');
            }
            else
              alert('Missing Text');
          }
          else
            alert('Missing Text');
        }
        else
          alert('Missing Submitter ID');
      }
      else
        alert('Missing Submitter ID');
    }
    else
      alert('Missing Item ID');
  }
  else
    alert('Missing Item ID');

  this.close();
  return(false);
}

function validatePlaybookRatingForm(frm)
{
  var itemID=frm.itemid.value;
  var submitter=frm.submitter.value;
  var text=frm.comment.value;
  var rat=frm.rating.value;
  var url=feedbackServletURL;
  var xy='',xx='';

  if(itemID!=null)
  {
    if(itemID!='')
    {
      if(submitter!=null)
      {
        if(submitter!='')
        {
          if(text!=null)
          {
            if(text!='')
            {
              if(rat>0)
              {
                url=url+'/PlaybookScore';

                url=url+"?SID="+submitter;
                url=url+"&IID="+itemID;
                url=url+"&RATE="+rat;
                url=url+"&TXT="+escape(text);
                xy=getFromServer(url);
                if(xy.charAt(0)=='E' && xy.charAt(1)=='R' && xy.charAt(2)=='R' && xy.charAt(3)==':')
                {
                  xx=xy.substr(4);
                  alert('An error occured processing your request : '+xx);
                }
                else
                  alert('You have successfully rated the selected playbook');
              }
              else
                alert('You have not rated the playbook, please provide a rating score.');
            }
            else
              alert('Missing Text');
          }
          else
            alert('Missing Text');
        }
        else
          alert('Missing Submitter ID');
      }
      else
        alert('Missing Submitter ID');
    }
    else
      alert('Missing Item ID');
  }
  else
    alert('Missing Item ID');

  return(false);
}

function sendReviewCompliment(uid,rid)
{
  var xy;

  if(uid>-1)
  {
    xy=getFromServer(complimentRecordTemplateURL);
    xy=xy.replace(':vt:','rv');
    xy=xy.replace(':sid:',uid);
    xy=xy.replace(':iid:',rid);

    var win=top.open("about:blank","Compliment","toolbar=no,menubar=no,width=720,height=300,resizable=yes");
    win.document.writeln(xy);
  }
  else
    alert('You must be logged in to leave a compliment');

  return(false);
}


function sendPlaybookInappropriate(uid,pid)
{
  var xy;

  if(uid>-1)
  {
    xy=getFromServer(inappropriateRecordTemplateURL);
    xy=xy.replace(':vt:','pb');
    xy=xy.replace(':sid:',uid);
    xy=xy.replace(':iid:',pid);

    var win=top.open("about:blank","Inappropriate","toolbar=no,menubar=no,width=720,height=500,resizable=yes");
    win.document.writeln(xy);
  }
  else
    alert('You must be logged in to leave a complaint');

  return(false);
}

function sendReviewInappropriate(uid,rid)
{
  var xy;

  if(uid>-1)
  {
    xy=getFromServer(inappropriateRecordTemplateURL);
    xy=xy.replace(':vt:','rv');
    xy=xy.replace(':sid:',uid);
    xy=xy.replace(':iid:',rid);

    var win=top.open("about:blank","Inappropriate","toolbar=no,menubar=no,width=720,height=500,resizable=yes");
    win.document.writeln(xy);
  }
  else
    alert('You must be logged in to leave a complaint');

  return(false);
}

function sendHuddleInappropriate(uid,hid)
{
  var xy;

  if(uid>-1)
  {
    xy=getFromServer(inappropriateRecordTemplateURL);
    xy=xy.replace(':vt:','hd');
    xy=xy.replace(':sid:',uid);
    xy=xy.replace(':iid:',hid);

    var win=top.open("about:blank","Inappropriate","toolbar=no,menubar=no,width=720,height=500,resizable=yes");
    win.document.writeln(xy);
  }
  else
    alert('You must be logged in to leave a complaint');

  return(false);
}




function validateSearchForm(frm)
{

   return(true);
}

function validateEventApprovalForm(frm)
{
  return(true);
}

function validatePlaybookForm(frm)
{
  return(true);
}

function validatePlaybookApprovalForm(frm)
{
  return(true);
}

function validateHuddleResponseForm(frm)
{
  var uid=frm.submitter.value;
  var RetVal=false;

  if(uid>-1)
    RetVal=true;
  else
    alert('You must be logged in to participate in a huddle');

  return(RetVal);
}

function validatePlaybookScoreForm(frm)
{
  var uid=frm.submitter.value;
  var RetVal=false;

  if(uid>-1)
    RetVal=validatePlaybookRatingForm(frm);
  else
    alert('You must be logged in to score a playbook');

  return(RetVal);
}

function validateUserRegistrationForm(frm)
{
  return(true);
}

function validateBusinessSelectionForm(frm)
{
  return(true);
}

function validateReviewForm(frm)
{
  return(true);
}

function validateUserInformationForm(frm)
{
  return(true);
}

function validateUserApprovalForm(frm)
{
  return(true);
}

function validateReviewApprovalForm(frm)
{
  return(true);
}

function updateUserPicture(frm)
{
  var win=top.open("/secured/uploadPhoto.jsp","NewPhoto","toolbar=no,menubar=no,width=450,height=245,resizable=no");
}

function setUserPicture(frm)
{
  var win=top.open("/uploadPhoto.jsp","NewPhoto","toolbar=no,menubar=no,width=450,height=245,resizable=no");
}

function userPhotoUpdated()
{
  document.location.refresh(true);
}

function changeUserPassword(frm)
{
  var win=top.open("/secured/changePassword.jsp","ChangePassword","toolbar=no,menubar=no,width=450,height=255,resizable=no");
}

function userPasswordChanged()
{
  alert('Password has been changed');
}

function showUserPopupForSelectedUser(lst)
{
  var counter, selCount=0, selValue, selIndex=-1;
  if(lst!=null)
  {
    if(lst.length>0)
    {
      for(counter=0;counter<lst.length;counter++)
      {
        if(lst.options[counter].selected)
        {
          selIndex=counter;
          selValue=lst.options[counter].value;
          selCount++;
        }
      }

      if(selCount>0)
      {
        if(selCount==1)
        {
          showUserPopup(selValue);
        }
        else
          alert('You can only select a single user from the list for viewing');
      }
      else
        alert('No users are selected from the list');
    }
    else
      alert('The list is empty');
  }
  else
    alert('Error - No LIST parameter passed to function');
}

function showReviewPopupForSelectedReview(lst)
{
  var counter, selCount=0, selValue, selIndex=-1;
  if(lst!=null)
  {
    if(lst.length>0)
    {
      for(counter=0;counter<lst.length;counter++)
      {
        if(lst.options[counter].selected)
        {
          selIndex=counter;
          selValue=lst.options[counter].value;
          selCount++;
        }
      }

      if(selCount>0)
      {
        if(selCount==1)
        {
          showReviewPopup(selValue);
        }
        else
          alert('You can only select a single review from the list for viewing');
      }
      else
        alert('No reviews are selected from the list');
    }
    else
      alert('The list is empty');
  }
  else
    alert('Error - No LIST parameter passed to function');
}

function showEventPopupForSelectedReview(lst)
{
  var counter, selCount=0, selValue, selIndex=-1;
  if(lst!=null)
  {
    if(lst.length>0)
    {
      for(counter=0;counter<lst.length;counter++)
      {
        if(lst.options[counter].selected)
        {
          selIndex=counter;
          selValue=lst.options[counter].value;
          selCount++;
        }
      }

      if(selCount>0)
      {
        if(selCount==1)
        {
          showEventPopup(selValue);
        }
        else
          alert('You can only select a single event from the list for viewing');
      }
      else
        alert('No events are selected from the list');
    }
    else
      alert('The list is empty');
  }
  else
    alert('Error - No LIST parameter passed to function');
}

function showPlaybookPopupForSelectedReview(lst)
{
  var counter, selCount=0, selValue, selIndex=-1;
  if(lst!=null)
  {
    if(lst.length>0)
    {
      for(counter=0;counter<lst.length;counter++)
      {
        if(lst.options[counter].selected)
        {
          selIndex=counter;
          selValue=lst.options[counter].value;
          selCount++;
        }
      }

      if(selCount>0)
      {
        if(selCount==1)
        {
          showPlaybookPopup(selValue);
        }
        else
          alert('You can only select a single playbook from the list for viewing');
      }
      else
        alert('No playbooks are selected from the list');
    }
    else
      alert('The list is empty');
  }
  else
    alert('Error - No LIST parameter passed to function');
}

function getFromServer(url)
{
  var RetVal='';
  var theRequest=null;




    if (window.XMLHttpRequest) {
        theRequest = new XMLHttpRequest();
        if (theRequest.overrideMimeType) {
            theRequest.overrideMimeType('text/xml');
        }
    }
    else
    if (window.ActiveXObject) {
        try
        {
            theRequest = new ActiveXObject("Msxml2.XMLHTTP");
        }
        catch (e)
        {
            try
            {
                theRequest = new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch (e) {
            }
        }
    }




	if(theRequest!=null)
	{
 		theRequest.open("GET", url,false);
        theRequest.onreadystatechange=processChange;
		theRequest.send("");
		while(true)
		{
		  if(theRequest.readyState==4)
		    break;
    }
		RetVal=theRequest.responseText;
	}
	else
	{
		alert('Error creating XMLHttpRequest Object');
	}

	return(RetVal);
}

function getFromServerUsingPOST(url)
{
  var RetVal='';
  var theRequest=null;


  if(window.XMLHttpRequest)          {
    theRequest=new XMLHttpRequest();
     if (theRequest.overrideMimeType) {
       theRequest.overrideMimeType('text/xml');
     }
  }
  else
    if (window.ActiveXObject) {
        try
        {
            theRequest = new ActiveXObject("Msxml2.XMLHTTP");
        }
        catch (e)
        {
            try
            {
                theRequest = new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch (e) {
            }
        }
    }
    if(theRequest!=null)
	{
 		theRequest.open("POST", url,false);
        theRequest.onreadystatechange=processChange;
		//theRequest.onreadystatechange=function()
    //{
		//  if (theRequest.readyState==4)
    //  {
    //    RetVal=theRequest.responseText;
    //    alert('All='+RetVal);
		//  }
		//}
		theRequest.send("");
		while(true)
		{
		  if(theRequest.readyState==4)
		    break;
    }
		RetVal=theRequest.responseText;
	}
	else
	{
		alert('Error creating XMLHttpRequest Object');
	}

	return(RetVal);
}


function getUserField(fld)
{
  var RetVal='';
  var theRequest=secureUserUtilServletURL+'/GetField?field='+fld;

  RetVal=getFromServer(theRequest);

  if(RetVal!=null)
  {
    // check for error conditions maybe
  }
  else
  {
    RetVal='???';
  }

  return(RetVal);
}



function redirectIfLoggedIn()
{
  if(isUserLoggedIn())
  {
    location="welcome.html";
  }
}

function redirectIfNotLoggedIn()
{
  if(!isUserLoggedIn())
  {
    location="tbl_login.jsp";
  }
}

function isUserLoggedIn()
{
  var RetVal=false;
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/IsLoggedIn';

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    fmSvr=trim(fmSvr);
    if(fmSvr=='TRUE')
      RetVal=true;
  }
  else
  {
    // error ?
  }

  return(RetVal);
}


function checkEmail(email)
{
  var RetVal=false;
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/CHECKEMAIL?email=' + email;

  fmSvr=getFromServerUsingPOST(theRequest);

  return true;
}

function canCookieLogIn()
{
  var RetVal=false;
  var fmSvr='';
  var username = readCookie('bzh_user');
  var password = readCookie('bzh_pass');
  if (username == null || password == null) return false;
  var theRequest=insecureUserUtilServletURL+'/CanLogIn?user=' + username + '&pass=' + password;

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    fmSvr=trim(fmSvr);
    if(fmSvr=='TRUE')
      RetVal=true;
  }
  else
  {
    // error ?
  }

  return(RetVal);
}



function getUserID()
{
  var RetVal='-1';
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/GetUserID';

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    RetVal=trim(fmSvr);
  }
  else
  {
    // error ?
  }

  return(RetVal);

}

function getUserName()
{
  var RetVal='';
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/GetUserName';

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    RetVal=trim(fmSvr);
  }
  else
  {
    // error ?
  }

  return(RetVal);
}

function getUserFirstName()
{
  var RetVal='';
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/GetUserFirstName';

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    RetVal=trim(fmSvr);
  }
  else
  {
    // error ?
  }

  return(RetVal);
}


function getUserFullName()
{
  var RetVal='';
  var fmSvr='';

  var theRequest=insecureUserUtilServletURL+'/GetUserFullName';

  fmSvr=getFromServerUsingPOST(theRequest);

  if(fmSvr!=null)
  {
    RetVal=trim(fmSvr);
  }
  else
  {
    // error ?
  }

  return(RetVal);
}

function getUserPicLink()
{
    return '/servlets/PictureServlet/GetUserPicture?idx=' + getUserID();
}















function processChange()
{
}

function showUserPopup(idx)
{
  var queryString=secureGetSelectServletURL+'?table=users&fields=FirstName,LastName,Login,EMailAddress,DOB,PrimaryPhoneNumber&query=WHERE ID='+idx;
  var ar,xy,xx;
  var counter;

  xy=getFromServer(userRecordTemplateURL);
  xx=getFromServer(queryString);

  ar=xx.split('|');
  for(counter=0;counter<6;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(trim(ar[counter])=='null') ar[counter]='';
  }

  xy=xy.replace(':fn:',trim(ar[0]));
  xy=xy.replace(':ln:',trim(ar[1]));
  xy=xy.replace(':lo:',trim(ar[2]));
  xy=xy.replace(':em:',trim(ar[3]));
  xy=xy.replace(':db:',trim(ar[4]));
  xy=xy.replace(':ph:',trim(ar[5]));

  var win=top.open("about:blank","UserRecord","toolbar=no,menubar=no,width=500,height=420,resizable=yes");
  win.document.writeln(xy);
}

function showReviewPopup(idx)
{
  var queryString=secureGetSelectServletURL+'?table=review_view&fields=Businesses_ID,Rating,Login,BusinessName,BusinessAddress,BusinessZIP&query=WHERE ID='+idx;
  var ar,xy,xx;
  var counter

  // Get template page
  xy=getFromServer(reviewRecordTemplateURL);

  // Get Review View
  xx=getFromServer(queryString);
  ar=xx.split('|');
  for(counter=0;counter<6;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(trim(ar[counter])=='null') ar[counter]='';
  }

  xy=xy.replace(':lo:',trim(ar[2]));
  xy=xy.replace(':bn:',trim(ar[3]));
  xy=xy.replace(':sa:',trim(ar[4]));
  xy=xy.replace(':zip:',trim(ar[5]));

  switch(trim(ar[1]))
  {
    case '1':
      xy=xy.replace(':rate:','Terrible');
      break;
    case '2':
      xy=xy.replace(':rate:','Some Problems');
      break;
    case '3':
      xy=xy.replace(':rate:','Average');
      break;
    case '4':
      xy=xy.replace(':rate:','Above Average');
      break;
    case '5':
      xy=xy.replace(':rate:','Excellent');
      break;
    default:
  }

  // Get the Review itself
  queryString=secureGetSelectServletURL+'?table=review_view&fields=Review&query=WHERE ID='+idx;
  xx=getFromServer(queryString);
  xy=xy.replace(':rev:',xx);

  // Get City ID
  queryString=secureGetSelectServletURL+'?table=businesses&fields=Cities_ID&query=WHERE ID='+idx;
  xx=getFromServer(queryString);

  // Get Additional Address Information
  queryString=secureGetSelectServletURL+'?table=cities_view&fields=CityName,StateName,CountryName&query=WHERE CityID='+xx;

  xx=getFromServer(queryString);
  ar=xx.split('|');
  for(counter=0;counter<3;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(trim(ar[counter])=='null') ar[counter]='';
  }
  xy=xy.replace(':ct:',trim(ar[0]));
  xy=xy.replace(':st:',trim(ar[1]));
  xy=xy.replace(':co:',trim(ar[2]));

  var win=top.open("about:blank","ReviewRecord","toolbar=no,menubar=no,width=500,height=650,resizable=yes");
  win.document.writeln(xy);
}

function showEventPopup(idx)
{
  var queryString=secureGetSelectServletURL+'?table=events_view&fields=Name,Location,InfoPhone,InfoURL,EventStart,EventEnd,ListFrom,ListTo,Cities_ID,StreetAddress,ZIP,Login,CategoryName&query=WHERE ID='+idx;
  var ar,xy,xx;
  var counter;

  // Get template page
  xy=getFromServer(eventRecordTemplateURL);

  // Get Review View
  xx=getFromServer(queryString);
  ar=xx.split('|');
  for(counter=0;counter<13;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(trim(ar[counter])=='null') ar[counter]='';
  }
  xy=xy.replace(':en:',trim(ar[0]));
  xy=xy.replace(':ven:',trim(ar[1]));
  xy=xy.replace(':ph:',trim(ar[2]));
  xy=xy.replace(':url:',trim(ar[3]));
  xy=xy.replace(':evsd:',trim(ar[4]));
  xy=xy.replace(':eved:',trim(ar[5]));
  xy=xy.replace(':lsd:',trim(ar[6]));
  xy=xy.replace(':led:',trim(ar[7]));
  xy=xy.replace(':sa:',trim(ar[9]));
  xy=xy.replace(':zip:',trim(ar[10]));
  xy=xy.replace(':lo:',trim(ar[11]));
  xy=xy.replace(':cat:',trim(ar[12]));

  // Get the Event itself
  queryString=secureGetSelectServletURL+'?table=events_view&fields=Description&query=WHERE ID='+idx;
  xx=getFromServer(queryString);
  xy=xy.replace(':des:',xx);

  // Get Additional Address Information
  queryString=secureGetSelectServletURL+'?table=cities_view&fields=CityName,StateName,CountryName&query=WHERE CityID='+ar[8];
  xx=getFromServer(queryString);
  ar=xx.split('|');
  for(counter=0;counter<3;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(ar[counter]=='null') ar[counter]='';
  }
  xy=xy.replace(':ct:',trim(ar[0]));
  xy=xy.replace(':st:',trim(ar[1]));
  xy=xy.replace(':co:',trim(ar[2]));

  var win=top.open("about:blank","EventRecord","toolbar=no,menubar=no,width=550,height=800,resizable=yes");
  win.document.writeln(xy);
}

function showPlaybookPopup(idx)
{
  var queryString=secureGetSelectServletURL+'?table=playbook_view&fields=Subj,CategoryName,Login&query=WHERE ID='+idx;
  var ar,xy,xx;
  var counter;

  // Get template page
  xy=getFromServer(playbookRecordTemplateURL);

  // Get Review View
  xx=getFromServer(queryString);
  ar=xx.split('|');
  for(counter=0;counter<3;counter++)
  {
    if(ar[counter]==null) ar[counter]='';
    if(trim(ar[counter])=='null') ar[counter]='';
  }
  xy=xy.replace(':tit:',trim(ar[0]));
  xy=xy.replace(':cat:',trim(ar[1]));
  xy=xy.replace(':lo:',trim(ar[2]));

  // Get the Playbook itself
  queryString=secureGetSelectServletURL+'?table=playbook_view&fields=Body&query=WHERE ID='+idx;
  xx=getFromServer(queryString);
  xy=xy.replace(':book:',xx);

  var win=top.open("about:blank","PlaybookRecord","toolbar=no,menubar=no,width=550,height=800,resizable=yes");
  win.document.writeln(xy);
}

function loadSel(sel,tableName,fieldList,query,someFlag)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);
    
    //if(someFlag==null)
        loadSelectSearch(sel,ar1, someFlag);
    //else
    //    loadSelect(sel,ar1,true);
}

function getValue(tableName,fieldList,query,extraText)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1 = createSelectArrays(xx);    
    return ar1.texts[0];

}


function loadSelNew(sel,tableName,fieldList,query,extraText)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearch(sel, ar1, extraText);
}

function loadSelSelected(sel,tableName,fieldList,query,extraText, value)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchSelected(sel, ar1, extraText, value);
}

function loadJobFunctions(sel,tableName,fieldList,query,extraText)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+'ID,Name';
    var xx,ar1, ar2;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+'ID,Indent';
    xx=getFromServer(queryString);
    ar2=createSelectArrays(xx);

    loadSelectJob(sel, ar1, ar2, extraText);
}



function loadSelCountry(sel,tableName,fieldList,query,extraText, extraValue)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchCountry(sel,ar1, extraText, extraValue);
}

function loadCountriesWithAll(sel,tableName,fieldList,query)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchCountryWithAll(sel,ar1);
}


function loadSelSearchCountry(sel,tableName,fieldList,query,someFlag)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchCountry(sel, ar1, '', '');
}

function loadSelState(sel,tableName,fieldList,query,someFlag)
{
   
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchState(sel,ar1, someFlag);
}

function cntSelState(tableName,fieldList,query,someFlag)
{
    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    return ar1.arrayLengths;
}

function loadStatesWithAll(sel,tableName,fieldList,query)
{
    loadStatesWithAllEx("all", sel,tableName,fieldList,query)
}

function loadStatesWithAllEx(allLabel, sel,tableName,fieldList,query)
{

    var queryString=insecureGetSelectServletURL+'?table='+tableName+'&fields='+fieldList;
    var xx,ar1;

    if(query!=null)
    queryString=queryString+'&query='+query;

    xx=getFromServer(queryString);
    ar1=createSelectArrays(xx);

    loadSelectSearchStateWithAllEx(allLabel,sel,ar1);
}