<?php  																														require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php"); 	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php"); 	$App 	= new App();	$Nav	= new Nav();	$Menu 	= new Menu();		include("_projectCommon.php");    # All on the same line to unclutter the user's desktop'

	#*****************************************************************************
	#
	# Author: 		Donald Smith
	# Date:			2005-11-11
	#****************************************************************************

	#
	# Begin: page-specific settings.  Change these.
	$pageTitle 		= "Eclipse Membership";
	$pageKeywords	= "Type, page, keywords, here";
	$pageAuthor		= "Type your name here";

	# Add page-specific Nav bars here
	# Format is Link text, link URL (can be http://www.someothersite.com/), target (_self, _blank)
	# $Nav->addCustomNav("My Link", "mypage.php", "_self");
	# $Nav->addCustomNav("Google", "http://www.google.com/", "_blank");

	# End: page-specific settings

	//require_once("./scripts/dondebug.php");
	require_once("./scripts/db_access.php");
	require_once("../projects/web-api/commit-company-active-projects.php");

	$_DEBUG 			= ($_GET['debug'] ? $_GET['debug'] : $_POST['debug']);

	//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/dbconnection.class.php");
	//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/dbconnection_marketplace_ro.class.php");
	include("lookup_exceptions.php");

	function memberType ($_member_type)
	{
		if ($_member_type == "SD")
			$retVal = "Strategic Developer";
		elseif($_member_type == "SC")
			$retVal = "Strategic Consumer";
		elseif($_member_type == "ENTRP")
			$retVal = "Enterprise";
		elseif($_member_type == "AP")
			$retVal = "Solutions";
		elseif($_member_type == "AS")
			$retVal = "Associate";
	return $retVal;
	}

//	$dbc = new DBConnection();
//	$dbcHandle = $dbc->connect();
//
//	$dbcMarket = new DBConnectionMarket();
//	$dbcMarketHandle = $dbcMarket->connect();
	$_MEMBER_ID 	= $_POST['member_id'] 	? $_POST['member_id'] 	: $_GET['member_id'];
	if(!preg_match('/^[0-9]+$/', $_MEMBER_ID)) {
		unset($_MEMBER_ID);
	}

if (isset($_MEMBER_ID )) {
	$sntx = array("\"", "\\", "/", "*", "-", "=", "'", "#", ";", "<", ">", "+", "%");
	$_MEMBER_ID  = str_replace($sntx, "", $_MEMBER_ID ); }


	$orgSql =  "SELECT ORG.name1, ORG.member_type, ORGINFO.short_description, ORGINFO.long_description, ORGINFO.company_url
				FROM OrganizationInformation as ORGINFO
				INNER JOIN organizations as ORG on ORGINFO.OrganizationID = ORG.organization_id
				WHERE ORGINFO.OrganizationID = $_MEMBER_ID and ORG.member_type in ('SD', 'SC', 'AP', 'AS', 'ENTRP')";


	$result = $App->eclipse_sql($orgSql);
	$resultIterator = mysql_fetch_array($result);
	$_MEMBER_NAME = $resultIterator[0];
	$_MEM_TYPE = $resultIterator[1];
	$_SHORT_DESC = $resultIterator[2];
	$_LONG_DESC = $resultIterator[3];
	$_COMPANY_URL = $resultIterator[4];

	$_LONG_MEM_TYPE = "Eclipse " . memberType($_MEM_TYPE) . " Member";
	if ( $_MEMBER_NAME != "" )	{
		$exceptions = epicException($_MEMBER_ID);

		$marketplaceQuery = "SELECT N.title, NR.teaser, CTR.field_version_value, N.nid FROM content_type_resource as CTR
							 INNER JOIN node as N on CTR.nid = N.nid
							 INNER JOIN node_revisions as NR on CTR.nid = NR.nid
							 WHERE N.status = 1 AND CTR.field_companyname_value ";
		//$epicQuery = "SELECT pn_title, pn_cat_id, pn_description, pn_version FROM nuke_links_links WHERE pn_blocked = 0 AND pn_company ";
		if (sizeof($exceptions) > 0) {
			$marketplaceQuery .= "in ('$_MEMBER_NAME'";
			foreach($exceptions as $e)
				$marketplaceQuery .= ", '$e'";
			$marketplaceQuery .= ")";
		} else {
			$marketplaceQuery .= "= '$_MEMBER_NAME'";
		}

		$marketplaceTCQuery = "SELECT N.title, NR.teaser, N.nid, CTT.field_trainingdesc_value, CTT.field_consultingdesc_value FROM node as N
					 INNER JOIN node_revisions as NR on N.nid = NR.nid
					 INNER JOIN content_type_training as CTT on N.nid = CTT.nid
					 WHERE N.status = 1 AND N.type = 'training' AND N.title ";
		//$epicConsultingQuery = "SELECT pn_cat_id, pn_description_training, pn_trainingurl, pn_description_consulting, pn_consultingurl FROM nuke_services_links where pn_company ";
		if (sizeof($exceptions) > 0) {
			$marketplaceTCQuery .= "in ('$_MEMBER_NAME'";
			foreach($exceptions as $e)
				$marketplaceTCQuery .= ", '$e'";
			$marketplaceTCQuery .= ")";
		} else {
			$marketplaceTCQuery .= "= '$_MEMBER_NAME'";
		}
		if ($_DEBUG) echo $marketplaceTCQuery;

		$marketplaceResult = $App->marketplace_sql($marketplaceQuery);

		$marketplaceTCResult = $App->marketplace_sql($marketplaceTCQuery);
//		$epicResult = mysql_query($epicQuery, $dbcEpicHandle);
//		$epicConsultingResult = mysql_query($epicConsultingQuery, $dbcEpicHandle);

		$MARKET_STRING = '<div class="homeitem3col" style="clear:both"><h3>' . $_MEMBER_NAME . '\'s Marketplace Listings</h3><ul>';
		$EPICCOUNT = 0;
		while($marketplaceIterator = mysql_fetch_array($marketplaceResult))
		{
			$EPICCOUNT++;
			$plugin_name = $marketplaceIterator['title'];
			$pluginid = $marketplaceIterator['nid'];
			$plugin_short_desc = $marketplaceIterator['teaser'];
			$plugin_short_desc = substr(strip_tags(html_entity_decode($plugin_short_desc)), 0, 250) . "...";
			$pluginVersion = $marketplaceIterator['field_version_value'];

			$pluginNameOutput = $plugin_name;
			if ($pluginVersion != "")
				$pluginNameOutput .= " v" . $pluginVersion;

			$MARKET_STRING .= '<li><a href="http://marketplace.eclipse.org/node/' . $pluginid . '">' . $pluginNameOutput . '</a>' . ' - ' . $plugin_short_desc  . '</li>';
		}
		while($marketplaceIterator = mysql_fetch_array($marketplaceTCResult))
		{
			$EPICCOUNT++;
			$pluginURL = $marketplaceIterator['nid'];
			$plugin_train = $marketplaceIterator['field_trainingdesc_value'];
			$plugin_train_trim = substr(strip_tags(html_entity_decode($plugin_train)), 0, 250) . "...";
			$plugin_consult = $marketplaceIterator['field_consultingdesc_value'];
			$plugin_consult_trim = substr(strip_tags(html_entity_decode($plugin_consult)), 0, 250) . "...";

			if ($plugin_train != "")
				$MARKET_STRING .=
					'<li><a href="http://marketplace.eclipse.org/node/'
					.$pluginURL
					.'">' . $_MEMBER_NAME . ' Training</a>'
					. ' - '
					. $plugin_train_trim
					.'</li>';
			if ($plugin_consult != "")
			$MARKET_STRING .=
				'<li><a href="http://marketplace.eclipse.org/node/'
				.$pluginURL
				.'">' . $_MEMBER_NAME . ' Consulting</a>'
				. ' - '
				. $plugin_consult_trim
				.'</li>';
		}
		if ($EPICCOUNT == 0)
			$MARKET_STRING .= "<br/><i style=\"font-size:smaller\">No Marketplace listings found for ". $_MEMBER_NAME . "</i><br/>";
		$MARKET_STRING .= '</ul></div>';

		$NORGIE_SCRIPT = '<script language="javascript">function t(i, j) {
	               var e = document.getElementById(i);
	               var f = document.getElementById(j);
	               var t = e.className;
	               if (t.match(\'invisible\')) { t = t.replace(/invisible/gi, \'visible\'); }
	               else { t = t.replace(/visible/gi, \'invisible\'); }
	               e.className = t;
	               f.className = t;
	          } </script>';


	    $productQuery = "SELECT * from OrganizationProducts where OrganizationID = $_MEMBER_ID ORDER by ProductID";
	    $productResult = $App->eclipse_sql($productQuery);

	    $PRODUCTSCOUNT = 0;
		$PRODUCTS_STRING = '<div class="homeitem3col" style="clear:both"><h3>' . $_MEMBER_NAME . '\'s Other Products and Services</h3><ul>';;
		while ($productIterator = mysql_fetch_array($productResult))
		{
			$PRODUCTSCOUNT++;
			$product_name = $productIterator['name'];
			$product_desc = $productIterator['description'];
			$productURL = $productIterator['product_url'];

			$product_desc .= '  External Link:<a target="_blank" href="' . $productURL . '"><img src="/home/categories/images/homepage.gif"></a>';
			ob_start();
			?>

				<li>
					<div class="invisible"id="<?=$product_name;?>"><a name="<?=$product_name;?>" class="norgie" onClick="t('<?=$product_name;?>', '<?=$product_name;?>a');"></a>
					<a class="itemtitle" name="<?=$product_name;?>"onClick="t('<?=$product_name;?>', '<?=$product_name;?>a');"><?=$product_name;?></a>
					</div>
					<div class="invisible" id="<?=$product_name;?>a">
					<div class="item_contents"> <?=$product_desc;?></div></div>

				</li>
			<?
			$PRODUCTS_STRING .= ob_get_clean();
		}
		if ($PRODUCTSCOUNT ==0)
			$PRODUCTS_STRING .= "<br/><i style=\"font-size:smaller\">No other product listings found for ". $_MEMBER_NAME . "</i><br/>";
		$PRODUCTS_STRING .= '</ul></div>';

		$tag_sql = "SELECT TAG.tag_name, ORGTAG.TagID
					FROM OrganizationTags as ORGTAG
					INNER JOIN TagNames as TAG on ORGTAG.TagID = TAG.TagID
					WHERE ORGTAG.OrganizationID = $_MEMBER_ID";
		$tag_result = $App->eclipse_sql($tag_sql);

		$TAGS_STRING = '<ul>';
		while ($tagIterator = mysql_fetch_array($tag_result))
		{
			$TAGS_STRING .= '<li><a href="./showMembersWithTag.php?TagID=' . $tagIterator[1] . '">'. $tagIterator[0] . '</a></li>';
		}

		switch ($_MEM_TYPE) {
		case "ENTRP":
			$TAGS_STRING .= '<li><a href="./showMembersWithTag.php?TagID=enterprise">Other Enterprise Members</a></li>';
			break;
		case "AS":
			$TAGS_STRING .= '<li><a href="./showMembersWithTag.php?TagID=associate">Other Associates</a></li>';
			break;
		case "AP":
			$TAGS_STRING .= '<li><a href="./showMembersWithTag.php?TagID=addin">Other Solutions Members</a></li>';
			break;
		default:
			$TAGS_STRING .= '<li><a href="./showMembersWithTag.php?TagID=strategic">Other Strategics</a></li>';
		}
		$TAGS_STRING .= '</ul>';


		$activeProjects = get_projects_this_company_is_active_on( $_MEMBER_ID  );
		$ACTIVE_STRING = "";
		$HEART_STRING = "";
		if (sizeof($activeProjects) > 0) {
				$ACTIVE_STRING = '<div class="homeitem3col" style="clear:both"><h3 id="projects">' . $_MEMBER_NAME . ' is an Active Contributor to the following Project(s):</h3><table width="100%" border="0" style="margin-left: 10px">';
				$rowcnt = round(count($activeProjects)+2 / 3);
				for( $i = 0; $i < $rowcnt; $i += 3 ) {
					$ACTIVE_STRING .= '<tr><td><a href="/projects/project_summary.php?projectid='. $activeProjects[$i] . '">' . $activeProjects[$i] . '</a></td>';
					if( $i + 1 < count($activeProjects) ) {
						$ACTIVE_STRING .= '<td><a href="/projects/project_summary.php?projectid='. $activeProjects[$i + 1] . '">' . $activeProjects[$i + 1] . '</a></td>';
					}
					if( $i + 2 < count($activeProjects) ) {
						$ACTIVE_STRING .= '<td><a href="/projects/project_summary.php?projectid='. $activeProjects[$i + 2] . '">' . $activeProjects[$i + 2] . '</a></td>';
					}
					$ACTIVE_STRING .= '</tr>';
				}
				$ACTIVE_STRING .= '</table></div>';
			$HEART_STRING = '
				<div class="sideitem" style="text-align:center">
					<br><img src="http://dev.eclipse.org/huge_icons/emblems/emblem-favorite.png" align="center"><br>
					'. $_MEMBER_NAME . ' Contributes to one or more <a href="#projects">Eclipse Projects</a>!
				</div>';

		}


		$moreExplore = '<li><a href="/membership/suggestTags.php?id=' . $_MEMBER_ID . '">Suggest More Tags for ' . $_MEMBER_NAME . '</a></li>';
		$imageHTML = '<a href="'.$_COMPANY_URL.'"><img align="left" src="./scripts/get_image.php?id='.$_MEMBER_ID . '&size=large" style="padding:5px;" alt="'.$_MEMBER_NAME.'" /></a>';
   	} else {  #MEMBER NOT FOUND
		$_MEMBER_NAME = '<font color="red">INVALID MEMBER ID</font>';
		$_LONG_MEM_TYPE = "";
		$_MEMBER_ID = 0;
		$TAGS_STRING = "<ul><li>No related tags</li></ul>";
		$_LONG_DESC = '<br>No member could be found matching that ID.  There are three possible
		reasons why this can happen:  <br><ul><li>You reached
			this page through a bad link (malformed HTML),</li>
			<li>this organization is no longer an active member,</li>
			<li>OR, this organization has not yet setup their membership page.</li>
			</ul><br>
			Please <a href="mailto:membership@eclipse.org">email us</a> if you believe this
			is an error we can fix or better yet --
			<a href="https://bugs.eclipse.org/bugs/enter_bug.cgi?product=Community&version=unspecified&component=Website&rep_platform=PC&op_sys=Windows%20XP&priority=P3&bug_severity=normal&bug_status=NEW&bug_file_loc=http%3A%2F%2F&short_desc=Eclipse%20Membership%20Pages%20Suggestion%20or%20Issue&comment=&commentprivacy=0&maketemplate=Remember%20values%20as%20bookmarkable%20template&form_name=enter_bug&cc=membership%40eclipse.org">open a bug</a>
			.';
	}


	# Paste your HTML content between the EOHTML markers!
	$html = <<<EOHTML
<style>
.visible .item_contents { display:block; }
.invisible .item_contents { display: none; }
.visible .item_menu { display:block; }
.invisible .item_menu { display: none; }
.visible a.norgie { background: url('/home/categories/images/minus.gif') no-repeat; padding-right:2px;}
.invisible a.norgie { background: url('/home/categories/images/plus.gif') no-repeat; padding-right:2px;}
.item_menu { position:relative; left:5px;margin:10px; margin-left: 15px; padding-left: 5px; padding-bottom:5px; font-weight: bold;}
.item_contents { margin:10px;background-color:#F8F8F8;border:1px dashed black;padding:5px;}
a.norgie {float:left; clear:all;height: 20px; width: 10px; margin-top:5px; margin-bottom:-5px;}
.homeitem3col ul li { list-style-image:none !important; list-style-type:none;}
.itemtitle {color:#663366;}
</style>
$NORGIE_SCRIPT

<div id="maincontent">
	<div id="midcolumn">
		<h1>$_MEMBER_NAME</h1>
		<h2>$_LONG_MEM_TYPE</h2>
		$imageHTML
		$_LONG_DESC
		$MARKET_STRING
		$PRODUCTS_STRING
		$ACTIVE_STRING
	</div>
	<div id="rightcolumn">
		$HEART_STRING
		<div class="sideitem">
			<h6>Related Tags</h6>
				$TAGS_STRING
		</div>
		<div class="sideitem">
			<h6>Interact</h6>
			<ul>
				<li><a href="/membership/exploreMembership.php">Explore All Members</a></li>
				$moreExplore
				<li><a href="/membership/faq/editMembershipPage.php">Edit This Page</a></li>
			</ul>
		</div>
	</div>
</div>

EOHTML;

	$html = mb_convert_encoding($html, "HTML-ENTITIES", "auto");
	# Generate the web page
	$App->generatePage("solstice", $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);
?>