<?php
	include_once("../DAL/config.php");
	include_once("../DAL/meeting.php");
	include_once("../DAL/category.php");
	include_once("../include/functions.php");
	
	if(isset($_REQUEST["action"]))
	{
		$thisAction = $_REQUEST["action"];
		switch($thisAction)
		{
			
			case "VIEWALL":
				outputCSV();
				exit;
			break;
			
			case "VIEWLONDON":
				$part = (isset($_REQUEST['part'])) ? (int) $_REQUEST['part'] : NULL;
				outputLondonCSV($part);
				
				exit;
			break;
			
			default:
				$thisAction = "HOME";
				
			break;
		}
	}
	else
	{
		$thisAction = "HOME";
	}
	
	
	function outputCSV()
	{
		$csvMode = "ALL";
		outputFileHeader(MEETINGS_CSV_NAME);
		
		outputCSVHeaderRow($csvMode);
		
		$meetingsList = getAllMeetingsForCSV();
		
		generateCSV($meetingsList);
	}
	
	function outputLondonCSV($part = 0)
	{
		$csvMode = "LONDON";
		outputFileHeader(LONDON_MEETINGS_CSV_NAME, $part);	
		
		outputCSVHeaderRow($csvMode);

		$meetingsList = getAllMeetingsForLondonCSV($part);

		generateLondonCSV($meetingsList);
	}
	
	// Outputs all header content for CSV
	function outputFileHeader($filename, $part = 0)
	{
		header('Content-type: text/csv');
		if ($part)
		{
			$part = (int) $part;
			$fileparts = explode('.', $filename);
			$fileparts[0] .= '-' . $part;
			$filename = implode('.', $fileparts);
		}
		header('Content-disposition: attachment; filename="'.$filename.'"');
	}
	
	// Outputs the first line of the csv file
	function outputCSVHeaderRow($csvMode)
	{
		switch($csvMode)
		{
			case "ALL":
				echo "\"County\",\"Town\",\"Day\",\"Start Time\",\"Name\",\"Address1\",\"Address2\",\"Notes\",\"ContactA\",\"ContactATel\",\"ContactB\",\"ContactBTel\",\"WA\",\"CW\",\"Chit\",\"Open\",\"Variations\",\"Smoking\",\"Creche\"";
			break;
			
			case "LONDON":
				echo "\"Day\",\"Start Time\",\"Name\",\"Address1\",\"Address2\",\"Location\",\"Notes\",\"Tube\",\"Bus\",\"ContactA\",\"ContactATel\",\"ContactB\",\"ContactBTel\",\"WA\",\"CW\",\"Chit\",\"Open\",\"Variations\",\"Smoking\",\"Creche\"";
			break;			
		}
		
		echo "\n";
	}
	
	function outputCSVRow($countyName, $townName, $meeting)
	{
		echo "\"{$countyName}\",\"{$townName}\",\"".getDayOfWeek($meeting['dayOfWeekNum'])."\",\"".convertTimeTo12Hour($meeting['startTime'])."\",\"{$meeting['meetingName']}\",\"{$meeting['address1']}\",\"{$meeting['address2']}\",\"{$meeting['notes']}\"";
		if($meeting["makeContactPublic"] == 1)
			echo ",\"{$meeting['contactName']}\",\"{$meeting['contactPhone']}\",\"{$meeting['contactName2']}\",\"{$meeting['contactPhone2']}\"";
		else
			echo ",\"\",\"\",\"\",\"\"";
				
		echo ",\"{$meeting['hasWheelChairAccess']}\",\"{$meeting['allowsChildren']}\",\"{$meeting['isChit']}\",\"{$meeting['isOpen']}\",\"{$meeting['dayNotes']}\",\"{$meeting['isSmokingAllowed']}\",\"{$meeting['hasCreche']}\"";
			
		echo "\n";	
	}
	
	function outputLondonCSVRow($dayName, $meeting)
	{
		$location = "";
		if($meeting['address3'] == "")
		{
			$location = $meeting['londonLocation'];
		}
		else
		{
			$location = $meeting['address3'];
		}
		
		echo "\"{$dayName}\",\"".convertTimeTo12Hour($meeting['startTime'])."\",\"{$meeting['meetingName']}\",\"{$meeting['address1']}\",\"{$meeting['address2']}\",\"{$location}\",\"{$meeting['notes']}\",\"{$meeting['londonTube']}\",\"{$meeting['londonBuses']}\"";
		if($meeting["makeContactPublic"] == 1)
			echo ",\"{$meeting['contactName']}\",\"{$meeting['contactPhone']}\",\"{$meeting['contactName2']}\",\"{$meeting['contactPhone2']}\"";
		else
			echo ",\"\",\"\",\"\",\"\"";
				
		echo ",\"{$meeting['hasWheelChairAccess']}\",\"{$meeting['allowsChildren']}\",\"{$meeting['isChit']}\",\"{$meeting['isOpen']}\",\"{$meeting['dayNotes']}\",\"{$meeting['isSmokingAllowed']}\",\"{$meeting['hasCreche']}\"";
			
		echo "\n";	
	}
	
	function generateCSV($meetingArray)
	{
		$currentCounty = "";
		$currentTown = "";
		$scotlandArray = array();
		$walesArray = array();
		
		foreach($meetingArray as $meeting)
		{
			if($meeting["categoryId"] == SCOTLAND_CAT_ID)
			{
				// Place it in the scotland array
				array_push($scotlandArray, $meeting);
			}
			else if($meeting["categoryId"] == WALES_CAT_ID)
			{
				// Place it in the wales array
				array_push($walesArray, $meeting);
			}
			else if($meeting["categoryId"] != LONDON_CAT_ID)
			{	
				if($meeting["categoryName"] != $currentCounty)
				{
					$currentCounty = $meeting["categoryName"];
					$countyToOutput = $currentCounty;
				}
				else
				{
					$countyToOutput = "";
				}
				
				if($meeting["address3"] != $currentTown)
				{
					$currentTown = $meeting["address3"];
					$townToOutput = $currentTown;
				}
				else
				{
					$townToOutput = "";
				}
				
				// Output the rest of the meeting
				outputCSVRow($countyToOutput, $townToOutput, $meeting);
			}
		}
		
		foreach($scotlandArray as $meeting)
		{
			if($meeting["categoryName"] != $currentCounty)
			{
				$currentCounty = $meeting["categoryName"];
				$countyToOutput = $currentCounty;
			}
			else
			{
				$countyToOutput = "";
			}
			
			if($meeting["address3"] != $currentTown)
			{
				$currentTown = $meeting["address3"];
				$townToOutput = $currentTown;
			}
			else
			{
				$townToOutput = "";
			}
			
			// Output the rest of the meeting
			outputCSVRow($countyToOutput, $townToOutput, $meeting);
		}
		
		foreach($walesArray as $meeting)
		{
			if($meeting["categoryName"] != $currentCounty)
			{
				$currentCounty = $meeting["categoryName"];
				$countyToOutput = $currentCounty;
			}
			else
			{
				$countyToOutput = "";
			}
			
			if($meeting["address3"] != $currentTown)
			{
				$currentTown = $meeting["address3"];
				$townToOutput = $currentTown;
			}
			else
			{
				$townToOutput = "";
			}
			
			// Output the rest of the meeting
			outputCSVRow($countyToOutput, $townToOutput, $meeting);
		}
	}
	
	function generateLondonCSV($meetingArray)
	{
		$currentDay = "";
		$dayToOutput = "";
		
		foreach($meetingArray as $meeting)
		{
			if(getDayOfWeek($meeting["dayOfWeekNum"]) != $currentDay)
			{
				$currentDay = getDayOfWeek($meeting["dayOfWeekNum"]);
				$dayToOutput = $currentDay;
			}
			else
			{
				$dayToOutput = "";
			}
						
			// Output the rest of the meeting
			outputLondonCSVRow($dayToOutput, $meeting);
		}
	}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Narcotics Anonymous - Meetings</title>
<META name="author" content="NA">
<META name="robots" content="index,follow">
<meta name="description" content="This website contains information about Narcotics Anonymous, including meetings listing for England, Scotland & Wales and a forum with a wealth of information about the nature of addiction">
<meta name="keywords" content="Narcotics, Anonymous, addiction, drug, drugs,problem, addict, addicted, crack, smack, weed, speed, hash, pills, prescription, addictive, recovery, recover, meetings, NA, 12, step, 12step, fellowship">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
<link href="../../css/styles.css" rel="stylesheet" type="text/css" media="screen">
<link href="../css/print.css" rel="stylesheet" type="text/css" media="print">
</head>


<body>
<table class="empty" width="100%" cellspacing="0" cellpadding="0" border="0">
	<tr class="emtpy">
		<td class="empty" valign="top" bgcolor="#00639C">
		<!-- START Menu -->		


<table cellspacing="0" width="140" cellpadding="0" height="100%">
  <tr>
<td width="100%" height="100%" bgcolor="#00639C" valign="top"> 
      <p align="center"> <br>
<font size="1" face="Arial"> 
<a class="meeting" target="_top" href="/index.htm"> 
<img border="0" src="nalogo_blue.gif" alt="Home" width="100" height="58"></a><br>
  <br>
  <br>
  <a class="meeting" href="../info/what-is-na.htm"> <font color="#FFFF99">What is NA?</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/addict.htm"><font color="#FFFF99">Am I an addict?</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/for_profs.htm"><font color="#FFFF99">For Professionals</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../p&c/index.htm"><font color="#FFFF99">Parents &amp; Carers</font></a><br>
  <font color="#FFFF99"><br>
  </font> <a class="meeting" href="../ukso/ukso.html"><font color="#FFFF99">NA Literature</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/helpline.htm"><font color="#FFFF99">The NA Helpline</font></a><br>
  <font color="#FFFF99"><br>
  </font> <a class="meeting" href="../info/12th_step.htm"><font color="#FFFF99">12th Step</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../meetings/"><font color="#FFFF99">UK Meetings</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/links.htm"><font color="#FFFF99">NA World Links</font></a><br>
  <br>
  <a class="meeting" href="../info/link_to_us.htm"><font color="#FFFF99">Link to us</font></a> <br>
  <font color="#FFFF99"><br>
  </font> <a class="meeting" href="../info/contacts.htm"><font color="#FFFF99">Contacts</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/events.htm"><font color="#FFFF99">NA Events</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../info/notices.htm"><font color="#FFFF99">NA Notices</font></a><font color="#FFFF99"><br>
  <br>
  </font> <a class="meeting" href="../forum/index.php"><font color="#FFFF99">Message Boards</font></a></font></p>

<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
      </script>
<script type="text/javascript">
_uacct = "UA-666733-1";
urchinTracker();
      </script>

    </td>
    </tr>
    </table>


		<!-- ENDE Menu -->		
		</td>
		<td class="empty" align="center">
		

<div id="wrap">
	
<?php include("include/header.php"); ?>
	  
<?php 
	$activeLink = "DOWNLOAD";
	include("include/nav.php");
?>
		
	<div id="bodywrap">
	
		<div id="meet">
		<div class="mtg-box">
			<?php
				if($thisAction == "HOME")
				{
					echo "<h2 class=\"blue-bg\">
            <img border="0" src="../downloads/spacer.png" width="422" height="171"><ul><li>
              <p align="left"><a href="../downloads/meetings.csv">View all meetings</a> (except London)<li>
              <p align="left">
              <a href="../downloads/londonMeetings.csv">View London meetings</a> (All days)</ul>
			</div>
		</div>   <!-- end #meet -->
	
		<div id="sidebar">
			<h3>Remember</h3>
			<p>This information changes often. Meetings change time, or move 
            because of redecoration of venue etc, so if you are downloading or 
            printing, please do so regularly so that your information is as bang 
            up-to-date as the website&#39;s.</div>
	</div> <!-- end #bodywrap -->
   
    <?php include("../include/footer.php"); ?>
</div> <!-- end #wrap -->