<!--#include virtual="/includes/topofpage.asp"-->
<%

Dim Page 
Page = "48"

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("conn_string")

If (UCase(Request.ServerVariables("REQUEST_METHOD")) = "POST" And Request.Form("page") = Page) Then

    'If Request.Form("cont") = "1" Then Response.Redirect "default.asp"
    'If Request.Form("cont") = "2" Then Response.Redirect "package-create-3.asp"

End If

'SQLPack = "select * from package p inner join package_type pt on pt.package_type_id = p.package_type_id inner join package_duration pd on pd.package_duration_id = p.package_duration_id where p.package_id = '" & Request("Package_ID") & "'"
'Set RSPack = Conn.Execute(SQLPack)


	SQL1 = "Select g.Group_ID, E.Entity_ID, E.[Name], ED.Address_1, ED.Address_2, ED.City, ED.State, ED.Zip, ED.Zip_4 from [Group] G "
	SQL1 = SQL1 & "inner join (Group_Entity_Map GEM inner join (Entity E inner join Entity_Detail ED on E.Entity_ID = ED.Entity_ID) on GEM.Entity_ID = E.Entity_ID) on G.Group_ID = GEM.Group_ID "
	SQL1 = SQL1 & "inner join Group_Realm_Map GRM On G.Group_ID = GRM.Group_ID "
'	If Session("SearchPrice") <> "" Then
'		SQL1 = SQL1 & "inner join Att_Group_Map AGM On AGM.Group_ID = G.Group_ID "
'    End If
	SQL1 = SQL1 & "Where (G.[Lookup_ID] = '6' Or G.[Lookup_ID] = '7') And G.[Private] = '0' And G.[Brand] = '0' "
	SQL1 = SQL1 & "And GRM.[Realm_ID] = '5' And ED.State = '" & Request("State") & "' And (ED.City like '" & Request("City") & "' "

	SQL4 = "Get_Combo_City @State_Abbr='" & Request("State") & "', @Child_City= '" & Request("City") & "', @Realm_ID='%'"
	Set RS4=Conn.Execute(SQL4)
	While Not RS4.EOF
		SQL1 = SQL1 & "Or ED.City like '" & RS4("Parent_City") & "' "
		SQL1 = SQL1 & "Or ED.City like '" & RS4("Child_City") & "' "
		RS4.MoveNext
	Wend
	Set RS4 = Nothing

	SQL4 = "Get_Combo_City @State_Abbr='" & Request("State") & "', @Parent_City= '" & Request("City") & "', @Realm_ID='%'"
	Set RS4=Conn.Execute(SQL4)
	While Not RS4.EOF
		SQL1 = SQL1 & "Or ED.City like '" & RS4("Parent_City") & "' "
		SQL1 = SQL1 & "Or ED.City like '" & RS4("Child_City") & "' "
		RS4.MoveNext
	Wend
	Set RS4 = Nothing

	SQL1 = SQL1 & ")"
	Set RSLodging = Conn.Execute(SQL1)	

'	Dim RSType, Package_type
'	Set RSType = Conn.Execute("Select * from Package_Type Where Package_Type_ID='" & Request("Package_Type_ID") & "'")
'	Package_Type = RSType("Type_Name")
'	Set RSType = Nothing
'<INPUT type="hidden" id=Package_Type name=Package_Type value="<Package_Type>">	
'Response.Write SQL1
%>
<html>
<STYLE>
BODY {SCROLLBAR-FACE-COLOR: #5e5ebe; SCROLLBAR-HIGHLIGHT-COLOR: #5e5ebe; SCROLLBAR-SHADOW-COLOR: #5e5ebe; SCROLLBAR-3DLIGHT-COLOR: #5e5ebe; SCROLLBAR-ARROW-COLOR:  #6666CC; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</STYLE>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.0
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && document.getElementById) x=document.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}

function Sub_Form (cont)
{
  form1.cont.value=cont
  form1.submit();
}
//-->
</script>
<link rel="stylesheet" href="/Style-sheets/headline.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/standard-input-form.css" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/icon-return-to-main-2.gif','images/icon-submit-changes-2.gif','images/icon-continue-wizard-2.gif')">
<form name="form1" method="post" action="package-create-3.asp">
<INPUT type="hidden" id=page name=page value="<%=Page%>">
<INPUT type="hidden" id=cont name=cont value="">
<%
Dim PackDur, PackSQL

For Each item in Request.Form
  If Not UCase(item) = "PAGE" And Not UCase(item) = "CONT"  And Not Mid(UCase(item),1, 8) = "PDURNAME"  And Not Mid(UCase(item),1, 9) = "PTYPENAME" Then
	For each value in Request.Form(item)
  	  If Mid(UCase(item), 1, 19) = "PACKAGE_DURATION_ID" Then
		%>
		
		<input type="hidden" name="Package_Duration_ID" value="<%=value%>">
		<input type="hidden" name="PDurName<%=value%>" value="<%=Request("PDURNAME" & value)%>">
		<%

		PackSQL = "Get_Package_Duration_Nights @Package_Duration_ID='" & value & "'"
		Set PackDur = Conn.Execute(PackSQL)

		%>
		
		<input type="hidden" name="Num_Nights" value="<%=PackDur("Num_Nights")%>">
<%
	  Else
%>
		<input type="hidden" name="<%=item%>" value="<%=value%>">
<%
	  End If
	Next
  End If
Next
%>

<table width="525" border="0" cellspacing="0" cellpadding="2" align="center">
  <tr bgcolor="#FFFFFF"> 
    <td width="467">&nbsp;</td>
    <td align="right" width="58">&nbsp;</td>
  </tr>
  <tr bgcolor="#5e5ebe">
    <td width="467" align="center" class="headline-ffffff">Select Lodging to Include</td>
    <td bgcolor="#5e5ebe" align="right" width="58"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/icon-return-to-main-2.gif',1)" onClick="MM_goToURL('parent','default.asp');return document.MM_returnValue"><img src="images/icon-return-to-main.gif" width="75" height="17" usemap="#returntomain" border="0" name="Image1"></a></td>
  </tr>
  <tr> 
    <td width="467" class="sm-hdln"><%=Request("Package_Name") & " - " & Package_Type %></td>
    <td width="58" class="sm-hdln">&nbsp;</td>
  </tr>
</table>
  <table width="500" border="0" cellspacing="0" cellpadding="0" align="center">
<% If Request("Lodging") = "1" Then %>
    <tr> 
      <td width="381" class="sm-hdln" height="11">&nbsp;</td>
      <td width="119" class="sm-hdln" align="center" height="11">Include in Package</td>
    </tr>
<% Do While Not RSLodging.EOF %>
    <tr> 
      <td width="381" class="standard-input-form"><input type="hidden" name="lodging_name<%=RSLodging("Group_ID")%>" value="<%=RSLodging("Name")%>"><%=RSLodging("Name")%></td>
      <td width="119" valign="top" class="standard-input-form" align="center"> 
        <input type="checkbox" name="lodging_group" value="<%=RSLodging("Group_ID")%>">
      </td>
    </tr>
    
<%  RSLodging.MoveNext
	Loop %>
<% Else %>
    <tr> 
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td colspan="2" class="manage-menu">Lodging Items not to be included in Package. Please click continue.</td>
    </tr>
<% End If %>
    <tr> 
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
   </table>
<table width="525" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr bgcolor="#5e5ebe">
    <td align="right" width="49%" height="18"><a href="javascript:Sub_Form('1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('submitchanges','','images/icon-submit-changes-2.gif',1)"><img src="images/icon-submit-changes.gif" width="200" height="15" name="submitchanges" border="0"></a></td>
    <td width="51%" height="18"><a href="javascript:Sub_Form('2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/icon-continue-wizard-2.gif',1)" target="content"><img src="images/icon-continue-wizard.gif" width="150" height="15" usemap="#continue" border="0" name="Image2"></a></td>
  </tr>
  <tr> 
    <td width="49%">&nbsp;</td>
    <td width="51%">&nbsp;</td>
  </tr>
</table>
</form>
</body>
</html>
