| <?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"; | |
| } | |
| ?> |