þÿ<?php

	header("Access-Control-Allow-Origin: *");

	$servername = "localhost"; $username = "ViDsocial"; $password = "AQT4Fq5h"; $dataBase = "ViDsocial"; $conn = mysqli_connect($servername, $username, $password, $dataBase); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); }		
		
	
	if(isset($_GET['cupcake'])){
		$eventID = 4315;
	}else{
		$eventID = $_POST['eventid'];
	}
	echo "<div>||  $eventID  ||</div>";
	echo "working";
	
	// Ticket Options
	
	$ticketOptionArray_sql = "SELECT * FROM `vidsocial_eventOption` WHERE `eventID` = $eventID ORDER BY `eventOptionID` DESC";
	$ticketOptionArray_result = mysqli_query( $conn,$ticketOptionArray_sql);
	
	$ticketOptArray = "";
	while($row = mysqli_fetch_array( $ticketOptionArray_result )) {
		
		$ticketOptArray = $row['eventOptionTitle'].", $ticketOptArray";
		$ticketOptCost = $row['eventOptionCost'].", $ticketOptCost";
		
	};
	
	$ticketOptArray =  substr($ticketOptArray, 0, -2);
	$ticketOptCost =  substr($ticketOptCost, 0, -1);
	
	echo "<div>ticketOptArray : $ticketOptArray</div>";
	
	
	$TOptArray = (explode(',',$ticketOptArray));
	$TOptCost = (explode(',',$ticketOptCost));
	// Make Header
	foreach ($TOptArray as &$value) {
		
			$tickInfo = $tickInfo."$value, Qty, Cost, ";
		
		
		$count++;
		
	} 
	$tickInfo = str_replace('"', ' ', $tickInfo);
	$complete_array = "Name, Email, Sister Number, Phone, Shirt, $tickInfo Guest Name, Booking Status,  First Ever, Waver, Amount Paid, Timestamp";
	
	$complete_array = str_replace('"', '', $complete_array);
	
	echo "<div>$complete_array</div>";
	
	$explodeArray  = explode(",",$complete_array);
	
	$list = array ($explodeArray);
	
	
	
	// Event Options
	
		$sql_hostingnNameDate = "SELECT *
								FROM vidsocial_eventInfo 
								WHERE eventID = '$eventID'";
								
		$result_hostingEvent = mysqli_query( $conn,$sql_hostingnNameDate);
		
		if(isset($_GET['cupcake'])){
			echo "<div><small>". __LINE__ ." | ".$sql_hostingnNameDate. "</small></div>";
		}
		
		
		// Evnet Internal Type
		
		while($row = mysqli_fetch_array( $result_hostingEvent )) {
			$eventUserID = $row['userID'];
		}
	
	
	
	
	// Hostess Infoation
	
		$userInfo_sql = "SELECT * FROM `vidsocial_userInfo` WHERE `userID` = '$eventUserID'";
		$userInfo_result = mysqli_query( $conn, $userInfo_sql);
		
		echo "<div>$userInfo_sql </div>";
		if(isset($_GET['cupcake'])){
			echo "<div><small>". __LINE__ ." | ".$userInfo_sql. "</small></div>";
		}
		
		while($row = mysqli_fetch_array( $userInfo_result )) {
			
			$userFristName = $row['userFristName'];
			$userLastName = $row['userLastName'];
			$Email = $row['userEmail'];
			$Sister = $row['sisterID'];
			$Phone = $row['userPhone'];
			
				array_push(
					$list, array("$userFristName $userLastName ", "$Email", "$Sister", "$Phone", "n/a","Hostess", "n/a", " n/a", "n/a", "n/a")
				);
			
		}
		
		
	
	// Booking Info
	
	$sql_hostingEvent = "	SELECT *,
							vidsocial_eventBooking.userID as bookingUser
							FROM vidsocial_eventBooking 
							JOIN vidsocial_userInfo ON vidsocial_userInfo.userID = vidsocial_eventBooking.userID
							JOIN vidsocial_eventInfo ON vidsocial_eventBooking.eventID = vidsocial_eventInfo.eventID
							WHERE vidsocial_eventBooking.eventID = '$eventID' 
							ORDER BY `vidsocial_userInfo`.`userFristName` ASC";
		
		
	$hostingEvent_results = mysqli_query($conn, $sql_hostingEvent);
	
	$ticketOptCost = (explode(',',$ticketOptCost));
	
	$TOptArray = (explode(',',$ticketOptArray));
	
	while($row = mysqli_fetch_array( $hostingEvent_results )) {	
		
		$bookingUser = $row['bookingUser'];
		$userFristName = $row['userFristName'];
		$userLastName = $row['userLastName'];
		
		$Email = $row['userEmail'];
		$Sister = $row['sisterID'];
		$Phone = $row['userPhone'];
		$Amount = $row['bookingTotal'];
		$userScore = $row['userScore'];
		$paymentDate = $row['paymentDate'];
		
		$AmountSum = 0;
		
		$bookingGuestName = $row['bookingGuestName'];
		$bookingOptionArray = $row['bookingOptionArray'];
		$bookingComment = $row['bookingComment'];
		$eventAttend = $row['bookingAttend'];
		
		$bookingShirtSize = $row['bookingShirtSize'];
		$shirtString = "n/a";
	
		if($bookingShirtSize == 0){ $shirtString = "n/a";}
		if($bookingShirtSize == 1){ $shirtString = "XS";}
		if($bookingShirtSize == 2){ $shirtString = "S";}
		if($bookingShirtSize == 3){ $shirtString = "M";}
		if($bookingShirtSize == 4){ $shirtString = "L";}
		if($bookingShirtSize == 5){ $shirtString = "XL";}
		if($bookingShirtSize == 6){ $shirtString = "XXL";}
		if($bookingShirtSize == 7){ $shirtString = "XXXL";}
		
		
		$bookingStatus = $row['bookingStatus'];
		$bookingStatus_string ="";
		if($bookingStatus == 0){
			$bookingStatus_string = "Active";
		}
		if($bookingStatus == 1){
			$bookingStatus_string = "Cancelled";
		}
		if($bookingStatus == 2){
			$bookingStatus_string = "No-Show";
		}
		
		$booking1stEvent = $row['booking1stEvent'];
		
		if($booking1stEvent == 1){
			$booking1stEvent_string = "YES!";
		}else{
			$booking1stEvent_string = "No";
		}
		
		
		/* waver */
		/* new waver check */
		
		$currentWaver_sql = "SELECT * FROM vidsocial_waver WHERE waverStatus = 1 ORDER BY waverStatus ASC";		
		$currentWaver_result = mysqli_query( $conn,$currentWaver_sql);   
		
		$wavierCheck_string = "No";
		
		while($row = mysqli_fetch_array( $currentWaver_result )) {	
			
			$waverContent = $row['waverContent'];
			$waverID = $row['waverID'];
			
			$signCheck_sql = "SELECT * FROM `vidsocial_waverSign` WHERE `waverID` = $waverID AND `userID` = $bookingUser";
			echo "<div>signCheck_sql | $signCheck_sql</div>";
			
			$signCheck_result = mysqli_query( $conn, $signCheck_sql);
			
			while($row = mysqli_fetch_array( $signCheck_result )) {	
				
				$signCheck = $row["signID"];
				$wavierCheck_string = "YES!!";
			}
			
		}
		
		///
		
		$toggleUnattend = "";
		
		$bookingOptionArray =  substr($bookingOptionArray, 0, -1);
		$bookingOptionArray =  substr($bookingOptionArray, 1);
				
		
		$BOArray = (explode(',',$bookingOptionArray));
		
		$tickInfo = "";
		$count = 0;
		
		print_r($ticketOptCost);
		
		echo"<div>||$bookingOptionArray||</div>";
		
		foreach ($BOArray as &$value) {
			
			$totalValue = floatval($ticketOptCost[$count])* floatval($value);
			$AmountSum = $AmountSum  + $totalValue;
			echo "<div>$count | $totalValue = ".$ticketOptCost[$count]." * $value</div>";
			$tickInfo = $tickInfo." ".$TOptArray[$count].", $value, $totalValue, ";
			
			$count++;
			
		}
		
		if($bookingStatus == 1){ 
			$AmountSum = 0;
		}
		
		$tickInfo = str_replace('"', ' ', $tickInfo);
		
		echo "<div><small>". __LINE__ ." | bookingUser  ".$bookingUser. "</small></div>";
		
		$complete_array = "$userFristName $userLastName, $Email, $Sister, $Phone, $shirtString, $tickInfo $bookingGuestName, $bookingStatus_string, $booking1stEvent_string, $wavierCheck_string, $AmountSum , $paymentDate ";
		
		$complete_array = str_replace('"', '', $complete_array);
		echo "<div>$complete_array</div>";
		
		$explodeArray  = explode(",",$complete_array);
		
		array_push($list, $explodeArray);
		
	}	
	
	echo"<div>csv. $list_string</div>";
	
	print_r($list);
	$fp = fopen('eventAttendance.csv', 'w');
	foreach ($list as $fields) {
		fputcsv($fp, $fields);
	}
	fclose($fp);
	
?>