관리-도구

편집 파일: tix_seating.php

<?php
session_start();
	$dbhost = 'internal-db.s3783.gridserver.com';
	$dbusername = 'aaronmeyer';
	$dbuserpassword = 'CQDZZDsu';
	$default_dbname = 'db3783_ticketingSystem';
	$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
	$dbid = mysql_select_db($default_dbname);

$seatnumber = 1;
	$i = $_SESSION['res_seating'];
	
	if ($_POST['Submit'])
	{
		while ($seatnumber <= $i)
		{		
			$seatnum = "seatnumber" . $seatnumber;
			$qq = "insert into tempseating_details values ('". $_SESSION['visitIp'] ."','" . $_POST[$seatnum] . "','','')";
			$ww = mysql_query($qq);
			$seatnumber++;
		}?>
		<html><body>
		<form name="FrmX" id="FrmX" method="post" action="tix_details.php">
		  <input type="hidden" name="res_seating" id="res_seating" value="0" >
		</form>
		</body></html>
		<script language="javascript">
			document.FrmX.submit();
		</script>	
	<?php } else
	{
		$sql = "select * from eventseatingplan where featuredeventid='" . $_SESSION['event_eid'] . "' and bookingid=0 order by Id";
		$seatnumber = 1;
		$i = $_SESSION['res_seating'];
	?>
<link rel="stylesheet" href="../../inc/styles.css" type="text/css" />
<style type="text/css">

</style>
<script type="text/JavaScript">

function validatedrops()
{
	var i;
	var str="";
	for(i=0; i<document.form1.elements.length; i++)
	{
		if(document.form1.elements[i].type=='select-one')
		{
			str = str + document.form1.elements[i].value + ", ";
		}
	}
	temp=str.split(", ")
	newArr=[]
	str = "true"
	for(var i=0;i<temp.length;i++)
	{
		isIn=0
		for(var j=0;j<newArr.length;j++)
		{
			if(temp[i]==newArr[j])
			{
				isIn=1
				str = "false"
			}
		}
		if(isIn==0)
		{
			newArr.push(temp[i])
		}
	}

if (str=="true")
	{
		return true
	}
	else
	{
		alert("Please correct Seat Selection. You cannot proceed with same seats");
		return false
	}
}
</script>
	<form id="form1" name="form1" method="post" action="tix_seating.php" onsubmit="return validatedrops();">
	  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
		<tr>
		  <td><table width="100%" border="0" cellspacing="1" cellpadding="4">
			<tr>
			 <td width="50%" height="25" bgcolor="#FFFFFF">
	<?
			echo '<b class="red">'."Zupan's Markets Aaron Meyer Holiday Concerts & CD Release".'</b><p>';		
			echo 'Presented by American Industries, Inc.<br><em><b>'.'Experience A Northwest Holiday Tradition'.'</em></b><br><br>';
			echo '<b>Venue Information:<br>First Congregational Church</b> - the historic church with the white tower - 1126 SW Park Ave between Madison & Main across from Portland Art Museum and next to Portland Center for Performing Arts.  For directions <a href="http://www.mapquest.com/maps?city=Portland&state=OR&address=1126+SW+Park+Avenue&zipcode=97205" target="_BLANK">click here</a><br>';
	?>		</td>
			<td width="50%" align="center" valign="middle" bgcolor="#FFFFFF"><a href="#" onClick="MM_openBrWindow('../seating.gif','splan','width=730,height=580')"><img src="../seating.gif" width="250" height="180" /></a><br />
			  Click to zoom </td>
			</tr>
        <tr>
          <td colspan="2" bgcolor="#FFFFFF" class="style15">Your Current Selection....</td>
        </tr>
        <tr>
          <td colspan="2" bgcolor="#000000"><table width="100%" border="0" cellpadding="3" cellspacing="2" bgcolor="#FFFFFF">
            <tr>
              <td width="52%" align="right" bgcolor="#F8F8F8" class="style14">Reserved Seats </td>
              <td width="4%" align="right" bgcolor="#F0F0F0" class="style14"><?php echo $_SESSION['res_seating']; ?></td>
              <td width="44%" align="right" bgcolor="#EBEBEB" class="style14">
                <?php
			  if ($_SESSION['res_seating']=='0')
			  	echo 'No Reserved Seats Selected';
			  else
				echo 'Selected Seats - ' . $_SESSION['res_seating'];
				?>
              </td>
            </tr>
            <tr>
              <td align="right" bgcolor="#F8F8F8" class="style14">General Admission Adult </td>
              <td align="right" bgcolor="#F0F0F0" class="style14"><?php echo $_SESSION['gen_1_seating']; ?></td>
              <td align="right" bgcolor="#EBEBEB" class="style14"><?php
			  if ($_SESSION['gen_1_seating']=='0')
			  	echo 'No General Admission (Adult) tickets purchased';
			  else
				echo $_SESSION['gen_1_seating'] . ' General Admission Tickets Selected';
				?>              </td>
            </tr>
            <tr>
              <td align="right" bgcolor="#F8F8F8" class="style14">General Admission (Seniors, Children, Students) </td>
              <td align="right" bgcolor="#F0F0F0" class="style14"><?php echo $_SESSION['gen_2_seating']; ?></td>
              <td align="right" bgcolor="#EBEBEB" class="style14"><?php
			  if ($_SESSION['gen_2_seating']=='0')
			  	echo 'No General Admission (Seniors, Children, Students) tickets selected';
			  else
				echo $_SESSION['gen_2_seating'] . ' General Admission Tickets Selected';
				?>              </td>
            </tr>
          </table></td>
        </tr>
        
        <tr>
          <td colspan="2" bgcolor="#FFFFFF" class="style4">&nbsp;</td>
        </tr>
		<?php
		$sql = "select * from eventseatingplan where featuredeventid='" . $_SESSION['event_eid'] . "' and bookingid=0 order by Id";
		$seatnumber = 1;		
		?>
		<tr>
			  <td height="30" colspan="2" bgcolor="#FFFFFF" class="style4"><div align="center">Select Seats for Reserved Seating 
				<input name="res_seating" id="res_seating" type="hidden" value="0" />
				&nbsp;</div></td>
			  </tr>
			<tr>
			  <td colspan="2" align="right" bgcolor="#FFFFFF" class="style14"><a href="#" onClick="MM_openBrWindow('seatingplan.php?eid=<?php echo $_SESSION['event_eid']; ?>','splan','width=1200,height=670')">Click here to view available seats</a></td>
			  </tr>       
			<?php while ($seatnumber <= $i) {
			$res = mysql_query($sql);?>
	
			<tr>
			  <td width="50%" align="right" bgcolor="#FFFFFF" class="style14">Select Seat <?php echo $seatnumber ?> : </td>
			  <td width="50%" bgcolor="#FFFFFF" class="style14"><label>
				<select name="seatnumber<?php echo $seatnumber; ?>">
				<?php while ($row = mysql_fetch_row($res))
				{ 
				$seatid = substr($row[2],0,6);
				?>
				<option value="<?php echo $row[0]; ?>"><?php echo $seatid; ?></option>
				<?php } ?>
				</select>
			  </label></td>
			</tr>
			<?php $seatnumber++;
			
			}?>
			
			<tr>
			  <td height="45" colspan="2" bgcolor="#FFFFFF"><label>
				<div align="center">
				  <input type="submit" name="Submit" value="     Proceed with Selected Seats     " />
				  </div>
			  </label></td>
			  </tr>
		  </table></td>
		</tr>
	  </table>
	</form>
	<?php  } ?>