<?php
/*******************************************************************************
 * Copyright (c) 2010 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Wayne Beaton (Eclipse Foundation)- initial API and implementation
 *******************************************************************************/

require_once(dirname(__FILE__) . '/common.inc');
mustBeEclipseFoundationCaller();

header("Content-type: text/plain");
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php";

  $_dbcf = new DBConnectionFoundation();
  $_dbhf = $_dbcf->connect();

    $foundation_query = "SELECT DISTINCT People.PersonID, Name1, Name2, FName, LName from People
		LEFT JOIN OrganizationContacts ON People.PersonID = OrganizationContacts.PersonID AND Relation IN ('CC', 'EMPLY')
		LEFT JOIN Organizations ON Organizations.OrganizationID = OrganizationContacts.OrganizationID
		;";
//    echo( $foundation_query . "\n" );
    $result = mysql_query($foundation_query, $_dbhf);
    if( !$result ) {
        echo("MySQL Error: ". mysql_error());
        echo( $foundation_query . "\n" );
        exit( "Stopped because error\n" );
    }
    while( $row = mysql_fetch_array($result) ) {
    	$company = $row[1] . $row[2];
	    //$company = preg_replace( "/[^A-Za-z0-9_\.\-]/", "", $company );
	    $login = trim($row[0]);
	    $fullname = $row[3] . " " . $row[4];
	    if( $company == "" ) $company = "individual";
	    echo "$login\t$company\t$fullname\n";
    }

?>