Import package again after stripping private data which should not have been commited

1 files changed, 638 insertions, 0 deletions

diff --git a/Contact.php b/Contact.php
new file mode 100644
index 0000000..891ae06
--- /dev/null
+++ b/Contact.php
@@ -0,0 +1,638 @@
+<?php
+/**
+ * @version $Header: /cvsroot/bitweaver/_bit_contact/Contact.php,v 1.13 2010/04/18 02:27:23 wjames5 Exp $
+ *
+ * Copyright ( c ) 2006 bitweaver.org
+ * All Rights Reserved. See below for details and a complete list of authors.
+ * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details
+ *
+ * @package contact
+ */
+
+/**
+ * required setup
+ */
+require_once( CONTACT_PKG_PATH.'ContactXref.php' );
+require_once( CONTACT_PKG_PATH.'ContactType.php' );
+require_once( LIBERTY_PKG_PATH.'LibertyContent.php' );		// Contact base class
+require_once( NLPG_PKG_PATH.'lib/phpcoord-2.3.php' );
+
+define( 'CONTACT_CONTENT_TYPE_GUID', 'contact' );
+
+/**
+ * @package contact
+ */
+class Contact extends LibertyContent {
+	var $mParentId;
+	var $mDate;
+	var $mTypes;
+
+	/**
+	 * Constructor 
+	 * 
+	 * Build a Contact object based on LibertyContent
+	 * @param integer Contact Id identifer
+	 * @param integer Base content_id identifier 
+	 */
+	function Contact( $pContactId = NULL, $pContentId = NULL ) {
+		LibertyContent::LibertyContent();
+		$this->registerContentType( CONTACT_CONTENT_TYPE_GUID, array(
+				'content_type_guid' => CONTACT_CONTENT_TYPE_GUID,
+				'content_name' => 'Contact Entry',
+				'handler_class' => 'Contact',
+				'handler_package' => 'contact',
+				'handler_file' => 'Contact.php',
+				'maintainer_url' => 'http://lsces.co.uk'
+			) );
+		$this->mContentId = (int)$pContentId;
+		$this->mContentTypeGuid = CONTACT_CONTENT_TYPE_GUID;
+
+		// Date object to handle date and time display
+		$this->mDate = new BitDate();
+		$offset = $this->mDate->get_display_offset();
+
+		// Permission setup
+		$this->mViewContentPerm  = 'p_contact_view';
+		$this->mCreateContentPerm  = 'p_contact_create';
+		$this->mUpdateContentPerm  = 'p_contact_update';
+		$this->mExpungeContentPerm  = 'p_contact_expunge';
+		$this->mAdminContentPerm = 'p_contact_admin';
+		
+		$this->mTypes = new ContactType();
+		$this->mTypes->setup();
+	}
+
+	/**
+	 * Load a Contact content Item
+	 *
+	 * (Describe Contact object here )
+	 */
+	function load($pContentId = NULL) {
+		if ( $pContentId ) $this->mContentId = (int)$pContentId;
+		if( $this->verifyId( $this->mContentId ) ) {
+ 			$query = "select con.*, lc.*, ca.*,
+				uue.`login` AS modifier_user, uue.`real_name` AS modifier_real_name,
+				uuc.`login` AS creator_user, uuc.`real_name` AS creator_real_name
+				FROM `".BIT_DB_PREFIX."contact` con
+				LEFT JOIN `".BIT_DB_PREFIX."liberty_content` lc ON lc.content_id = con.content_id
+				LEFT JOIN `".BIT_DB_PREFIX."users_users` uue ON (uue.`user_id` = lc.`modifier_user_id`)
+				LEFT JOIN `".BIT_DB_PREFIX."users_users` uuc ON (uuc.`user_id` = lc.`user_id`)
+				LEFT JOIN `".BIT_DB_PREFIX."contact_address` ca ON ca.content_id = con.content_id
+				WHERE con.`content_id`=?";
+			$result = $this->mDb->query( $query, array( $this->mContentId ) );
+//				LEFT JOIN `".BIT_DB_PREFIX."contact` ci ON ci.contact_id = pro.owner_id
+//				LEFT JOIN `".BIT_DB_PREFIX."contact_address` a ON a.contact_id = pro.address_id
+//				LEFT JOIN `".BIT_DB_PREFIX."postcode` p ON p.`postcode` = a.`postcode`
+
+			if ( $result && $result->numRows() ) {
+				$this->mInfo = $result->fields;
+				$this->mContentId = (int)$result->fields['content_id'];
+//				$this->mParentId = (int)$result->fields['usn'];
+				$this->mContactName = $result->fields['title'];
+				$this->mInfo['creator'] = (isset( $result->fields['creator_real_name'] ) ? $result->fields['creator_real_name'] : $result->fields['creator_user'] );
+				$this->mInfo['editor'] = (isset( $result->fields['modifier_real_name'] ) ? $result->fields['modifier_real_name'] : $result->fields['modifier_user'] );
+				$this->mInfo['display_url'] = $this->getDisplayUrl();
+//				$os1 = new OSRef($this->mInfo['x_coordinate'], $this->mInfo['y_coordinate']);
+//				$ll1 = $os1->toLatLng();
+//				$this->mInfo['prop_lat'] = $ll1->lat;
+//				$this->mInfo['prop_lng'] = $ll1->lng;
+
+				$this->loadContentTypeList();
+				$this->loadXrefList();
+			}
+		}
+		LibertyContent::load();
+		return;
+	}
+
+	/**
+	* verify, clean up and prepare data to be stored
+	* @param $pParamHash all information that is being stored. will update $pParamHash by reference with fixed array of itmes
+	* @return bool TRUE on success, FALSE if store could not occur. If FALSE, $this->mErrors will have reason why
+	* @access private
+	**/
+	function verify( &$pParamHash ) {
+		// make sure we're all loaded up if everything is valid
+		if( $this->isValid() && empty( $this->mInfo ) ) {
+			$this->load( TRUE );
+		}
+
+		// It is possible a derived class set this to something different
+		if( empty( $pParamHash['content_type_guid'] ) ) {
+			$pParamHash['content_type_guid'] = $this->mContentTypeGuid;
+		}
+
+		if( !empty( $this->mContentId ) ) {
+			$pParamHash['content_id'] = $this->mContentId;
+			$pParamHash['contact_store']['content_id'] = $this->mContentId;
+		} else {
+			unset( $pParamHash['content_id'] );
+			$pParamHash['contact_store']['content_id'] = NULL;
+		}
+
+//		$pParamHash['contact_store']['comment'] = $pParamHash['comment'];
+//		$pParamHash['contact_store']['surname'] = $pParamHash['surname'];
+
+//		if ( empty( $pParamHash['parent_id'] ) )
+//			$pParamHash['parent_id'] = $this->mContentId;
+			
+		// content store
+		// check for name issues, first truncate length if too long
+/*		if( empty( $pParamHash['surname'] ) || empty( $pParamHash['forename'] ) )  {
+			$this->mErrors['names'] = 'You must enter a forename and surname for this contact.';
+		} else {
+			$pParamHash['title'] = substr( $pParamHash['prefix'].' '.$pParamHash['forename'].' '.$pParamHash['surname'].' '.$pParamHash['suffix'], 0, 160 );
+			$pParamHash['content_store']['title'] = $pParamHash['title'];
+		}	
+
+		// Secondary store entries
+		$pParamHash['contact_store']['prefix'] = $pParamHash['prefix'];
+		$pParamHash['contact_store']['forename'] = $pParamHash['forename'];
+		$pParamHash['contact_store']['surname'] = $pParamHash['surname'];
+		$pParamHash['contact_store']['suffix'] = $pParamHash['suffix'];
+		$pParamHash['contact_store']['organisation'] = $pParamHash['organisation'];
+
+		if ( !empty( $pParamHash['nino'] ) ) $pParamHash['contact_store']['nino'] = $pParamHash['nino'];
+		if ( !empty( $pParamHash['dob'] ) ) $pParamHash['contact_store']['dob'] = $pParamHash['dob'];
+		if ( !empty( $pParamHash['eighteenth'] ) ) $pParamHash['contact_store']['eighteenth'] = $pParamHash['eighteenth'];
+		if ( !empty( $pParamHash['dod'] ) ) $pParamHash['contact_store']['dod'] = $pParamHash['dod'];
+*/
+		return( count( $this->mErrors ) == 0 );
+	}
+
+	/**
+	* Store contact data
+	* @param $pParamHash contains all data to store the contact
+	* @param $pParamHash[title] title of the new contact
+	* @param $pParamHash[edit] description of the contact
+	* @return bool TRUE on success, FALSE if store could not occur. If FALSE, $this->mErrors will have reason why
+	**/
+	function store( &$pParamHash ) {
+		if( $this->verify( $pParamHash ) ) {
+			// Start a transaction wrapping the whole insert into liberty 
+
+			$this->mDb->StartTrans();
+			if ( LibertyContent::store( $pParamHash ) ) {
+				$table = BIT_DB_PREFIX."contact";
+
+				// mContentId will not be set until the secondary data has commited 
+				if( $this->verifyId( $this->mContentId ) ) {
+					if( !empty( $pParamHash['contact_store'] ) ) {
+						$result = $this->mDb->associateUpdate( $table, $pParamHash['contact_store'], array( "content_id" => $this->mContentId ) );
+					}
+				} else {
+					$pParamHash['contact_store']['content_id'] = $pParamHash['content_id'];
+					$pParamHash['contact_store']['parent_id'] = $pParamHash['content_id'];
+					$pParamHash['contact_store']['address_id'] = $pParamHash['content_id'];
+					$this->mParentId = $pParamHash['contact_store']['parent_id'];
+					$this->mContentId = $pParamHash['content_id'];
+					$result = $this->mDb->associateInsert( $table, $pParamHash['contact_store'] );
+				}
+				if( !empty( $pParamHash['contact_types'] ) ) {
+					$query = "DELETE FROM `".BIT_DB_PREFIX."contact_xref` WHERE `content_id` = ? AND `source` LIKE '$%'";
+					$result = $this->mDb->query($query, array($this->mContentId ) );
+					 foreach ( $pParamHash['contact_types'] as $key => $source ) {
+						$query = "INSERT INTO `".BIT_DB_PREFIX."contact_xref` (`content_id`, `source`, `last_update_date`) VALUES ( ?, ?, NULL )";
+						$result = $this->mDb->query($query, array( $this->mContentId, $source ) );
+					 }
+				}
+				// load before completing transaction as firebird isolates results
+				$this->load();
+				$this->mDb->CompleteTrans();
+			} else {
+				$this->mDb->RollbackTrans();
+				$this->mErrors['store'] = 'Failed to store this contact.';
+			}
+		}
+		return( count( $this->mErrors ) == 0 );
+	}
+
+	/**
+	 * Delete content object and all related records
+	 */
+	function expunge()
+	{
+		$ret = FALSE;
+		if ($this->isValid() ) {
+			$this->mDb->StartTrans();
+			$query = "DELETE FROM `".BIT_DB_PREFIX."contact_xref` WHERE `content_id` = ?";
+			$result = $this->mDb->query($query, array($this->mContentId ) );
+			if (LibertyContent::expunge() ) {
+			$ret = TRUE;
+				$this->mDb->CompleteTrans();
+			} else {
+				$this->mDb->RollbackTrans();
+			}
+		}
+		return $ret;
+	}
+
+	/**
+	 * Check if the current post can have comments attached to it
+	 */
+	function isCommentable(){
+		global $gBitSystem;	
+		return $gBitSystem->isFeatureActive( 'contact_post_comments' );
+	}
+
+	/**
+	 * Returns Request_URI to a Contact content object
+	 *
+	 * @param string name of
+	 * @param array different possibilities depending on derived class
+	 * @return string the link to display the page.
+	 */
+	function getDisplayUrl( $pContentId=NULL ) {
+		global $gBitSystem;
+		if( empty( $pContentId ) ) {
+			$pContentId = $this->mContentId;
+		}
+
+		return CONTACT_PKG_URL.'index.php?content_id='.$pContentId;
+	}
+
+	/**
+	 * Returns HTML link to display a Contact object
+	 * 
+	 * @param string Not used ( generated locally )
+	 * @param array mInfo style array of content information
+	 * @return the link to display the page.
+	 */
+	function getDisplayLink( $pText, $aux ) {
+		if ( $this->mContentId != $aux['content_id'] ) $this->load($aux['content_id']);
+
+		if (empty($this->mInfo['content_id']) ) {
+			$ret = '<a href="'.$this->getDisplayUrl($aux['content_id']).'">'.$aux['title'].'</a>';
+		} else {
+			$ret = '<a href="'.$this->getDisplayUrl($aux['content_id']).'">'."Contact - ".$this->mInfo['title'].'</a>';
+		}
+		return $ret;
+	}
+
+	/**
+	 * Returns title of an Contact object
+	 *
+	 * @param array mInfo style array of content information
+	 * @return string Text for the title description
+	 */
+	function getTitle( $pHash = NULL ) {
+		$ret = NULL;
+		if( empty( $pHash ) ) {
+			$pHash = &$this->mInfo;
+		} else {
+			if ( $this->mContentId != $pHash['content_id'] ) {
+				$this->load($pHash['content_id']);
+				$pHash = &$this->mInfo;
+			}
+		}
+
+		if( !empty( $pHash['title'] ) ) {
+			$ret = "Contact - ".$this->mInfo['title'];
+		} elseif( !empty( $pHash['content_name'] ) ) {
+			$ret = $pHash['content_name'];
+		}
+		return $ret;
+	}
+
+	/**
+	 * Returns list of contact entries
+	 *
+	 * @param integer 
+	 * @return array of contact entries
+	 */
+	function getList( &$pParamHash ) {
+		global $gBitSystem, $gBitUser;
+		
+		LibertyContent::prepGetList( $pParamHash );
+
+		$findSql = '';
+		$selectSql = '';
+		$joinSql = '';
+		$whereSql = '';
+		$bindVars = array();
+
+		if ( isset( $pParamHash['contact_type_guid'][0] ) ) {
+			$joinSql .= "JOIN `".BIT_DB_PREFIX."contact_xref` cx ON cx.`content_id` = con.`content_id` AND cx.`source` = ? ";
+			$bindVars[] = $pParamHash['contact_type_guid'][0];
+		}
+		
+		array_push( $bindVars, $this->mContentTypeGuid );
+		$this->getServicesSql( 'content_list_sql_function', $selectSql, $joinSql, $whereSql, $bindVars, NULL, $pParamHash );
+
+		// this will set $find, $sort_mode, $max_records and $offset
+		extract( $pParamHash );
+
+//		$pParamHash["listInfo"]["ihash"]['contact_type_guid'] = $contact_type_guid;
+
+		$t = $gBitSystem->getUTCTime();
+		if ( isset( $active ) ) {
+			if ( $active === 'Inactive' ) {
+				$whereSql .= " AND ( lc.`event_time` > 0 AND lc.`event_time` < $t ) ";
+			} 
+		} else {
+			$active = 'Active';
+		}
+		if ( $active == 'Active' ) {
+			$whereSql .= " AND ( lc.`event_time` = 0 OR lc.`event_time` > $t ) ";
+		} 
+		$pParamHash["listInfo"]["active"] = $active;
+
+		if( isset( $find_key ) and is_string( $find_key ) and $find_key <> '' ) {
+			$whereSql .= " AND UPPER( con.`xkey` ) = ? ";
+			$bindVars[] = strtoupper( $find_key );
+			$pParamHash["listInfo"]["ihash"]["find_key"] = $find_key;
+			$find_title = '';
+			$find_location = '';
+			$find_postcode = '';
+		}
+
+		if( isset( $find_title ) and is_string( $find_title ) and $find_title <> '' ) {
+			$whereSql .= " AND UPPER( lc.`title` ) like ? ";
+			$bindVars[] = '%' . strtoupper( $find_title ). '%';
+			$pParamHash["listInfo"]["ihash"]["find_title"] = $find_title;
+		}
+
+/*		if( isset( $find_name ) and is_string( $find_name ) and $find_name <> '' ) {
+		    $split = preg_split('|[,. ]|', $find_name, 2);
+			$whereSql .= " AND UPPER( ci.`surname` ) STARTING ? ";
+			$bindVars[] = strtoupper( $split[0] );
+		    if ( array_key_exists( 1, $split ) ) {
+				$split[1] = trim( $split[1] );
+				$whereSql .= " AND UPPER( ci.`forename` ) STARTING ? ";
+				$bindVars[] = strtoupper( $split[1] );
+			}
+			$pParamHash["listInfo"]["ihash"]["find_name"] = $find_name;
+		}
+*/
+		if( isset( $find_location ) and is_string( $find_location ) and $find_location <> '' ) {
+			$whereSql .= " AND ( UPPER( ca.`street` ) like ? OR UPPER( ca.`locality` ) like ? OR UPPER( ca.`town` ) like ? )";
+			$uploc = '%' . strtoupper( $find_location ). '%';;
+			$bindVars[] = $uploc;
+			$bindVars[] = $uploc;
+			$bindVars[] = $uploc;
+			$pParamHash["listInfo"]["ihash"]["find_location"] = $find_location;
+		}
+
+		if( isset( $find_postcode ) and is_string( $find_postcode ) and $find_postcode <> '' ) {
+			$whereSql .= " AND UPPER( `ca.postcode` ) LIKE ? ";
+			$bindVars[] = '%' . strtoupper( $find_postcode ). '%';
+			$pParamHash["listInfo"]["ihash"]["find_postcode"] = $find_postcode;
+		}
+
+		$query = "SELECT con.*, lc.*, ca.*,
+			(SELECT COUNT(*) FROM `".BIT_DB_PREFIX."contact_xref` x WHERE x.content_id = con.content_id AND x.source NOT STARTING WITH '$' ) AS refs,
+			(SELECT COUNT(*) FROM `".BIT_DB_PREFIX."contact_address` a WHERE a.content_id = con.content_id ) AS addresses
+			FROM `".BIT_DB_PREFIX."contact` con
+			LEFT JOIN `".BIT_DB_PREFIX."liberty_content` lc ON lc.`content_id` = con.`content_id`
+			LEFT JOIN `".BIT_DB_PREFIX."contact_address` ca ON ca.`content_id` = con.`content_id`
+			$findSql
+			$joinSql 
+			WHERE lc.`content_type_guid` = ? $whereSql
+			ORDER BY ".$this->mDb->convertSortmode( $sort_mode );
+
+//			(SELECT COUNT(*) FROM `".BIT_DB_PREFIX."task_ticket` e WHERE e.usn = ci.usn ) AS enquiries $selectSql 
+		$query_cant = "SELECT COUNT( * )
+			FROM `".BIT_DB_PREFIX."contact` con
+			LEFT JOIN `".BIT_DB_PREFIX."liberty_content` lc ON lc.content_id = con.content_id
+			LEFT JOIN `".BIT_DB_PREFIX."contact_address` ca ON ca.content_id = con.content_id
+			$joinSql WHERE lc.`content_type_guid` = ? $whereSql ";
+		$result = $this->mDb->query( $query, $bindVars, $max_records, $offset );
+		$ret = array();
+		while( $res = $result->fetchRow() ) {
+			if (!empty($parse_split)) {
+				$res = array_merge($this->parseSplit($res), $res);
+			}
+			$ret[] = $res;
+		}
+		$pParamHash["cant"] = $this->mDb->getOne( $query_cant, $bindVars );
+		$pParamHash["listInfo"]["count"] = $pParamHash["cant"];
+
+		LibertyContent::postGetList( $pParamHash );
+		return $ret;
+	}
+
+	/**
+	* Returns titles of the contact type table
+	*
+	* @return array List of contact type names from the contact mamager in alphabetical order
+	*/
+	function getContactGroupList() {
+		global $gBitUser, $gBitSmarty;
+
+		$roles = array_keys($gBitUser->mRoles);
+		$bindVars = array();
+		$bindVars = array_merge( $bindVars, $roles, array( $gBitUser->mUserId ) );
+
+		$query = "SELECT g.* FROM `".BIT_DB_PREFIX."contact_xref_type` g
+				  LEFT OUTER JOIN `".BIT_DB_PREFIX."users_roles_map` purm ON ( purm.`user_id`=".$gBitUser->mUserId." ) AND ( purm.`role_id`=g.`role_id` )
+				  WHERE g.`xref_type` > 0 AND (g.`role_id` IN(". implode(',', array_fill(0, count($roles), '?')) ." ) OR purm.`user_id`=?)
+				  ORDER BY g.`xref_type`";
+		$result = $this->mDb->query( $query, $bindVars );
+		$ret = array();
+		while ($res = $result->fetchRow()) {
+			$ret[] = $res;
+		}
+		return $ret;
+	}
+
+	/**
+	* Returns titles of the contact type table
+	*
+	* @return array List of contact type names from the contact mamager in alphabetical order
+	*/
+	function getContactSourceList() {
+		global $gBitUser, $gBitSmarty;
+
+		$roles = array_keys($gBitUser->mRoles);
+		$bindVars = array();
+		$bindVars = array_merge( $bindVars, $roles, array( $gBitUser->mUserId ) );
+
+		$query = "SELECT g.`cross_ref_title` AS `type_name`, g.`source` FROM `".BIT_DB_PREFIX."contact_xref_source` g
+				  LEFT OUTER JOIN `".BIT_DB_PREFIX."users_roles_map` purm ON ( purm.`user_id`=".$gBitUser->mUserId." ) AND ( purm.`role_id`=g.`role_id` )
+				  WHERE g.`xref_type` = 0 AND (g.`role_id` IN(". implode(',', array_fill(0, count($roles), '?')) ." ) OR purm.`user_id`=?)
+				  ORDER BY g.`cross_ref_title`";
+		$result = $this->mDb->query( $query, $bindVars );
+		$ret = array();
+
+		while ($res = $result->fetchRow()) {
+			$ret[$res["source"]] = trim($res["type_name"]);
+		}
+		return $ret;
+	}
+
+	/**
+	* Returns titles of the xref type table
+	* @param $xrefGroup selects a single group of xref types
+	* @return array List of xref type names from the contact mamager in alphabetical order
+	*/
+	function getXrefTypeList( $xrefGroup = 0 ) {
+		if ( $xrefGroup > -1 ) {
+			$query = "SELECT s.`cross_ref_title` AS `type_name`, s.`source`  FROM `".BIT_DB_PREFIX."contact_xref_source` s
+					  LEFT JOIN `".BIT_DB_PREFIX."contact_xref` x ON x.`source` = s.`source` AND x.`content_id` = ? 
+					  WHERE s.`xref_type` = ? AND ( x.`xref_id` IS NULL OR x.`xorder` > 0 )
+					  ORDER BY s.`cross_ref_title`";
+			$result = $this->mDb->query($query, array( $this->mContentId, $xrefGroup ) );
+		} else {
+			$query = "SELECT s.`cross_ref_title` AS `type_name`, s.`source`  FROM `".BIT_DB_PREFIX."contact_xref_source` s
+					  LEFT JOIN `".BIT_DB_PREFIX."contact_xref` x ON x.`source` = s.`source` AND x.`content_id` = ? 
+					  WHERE s.`xref_type` > 0 AND ( x.`xref_id` IS NULL OR x.`xorder` > 0 )
+					  ORDER BY s.`cross_ref_title`";
+			$result = $this->mDb->query($query, array( $this->mContentId ) );
+		}
+		$ret = array();
+
+		while ($res = $result->fetchRow()) {
+			$ret[$res["source"]] = trim($res["type_name"]);
+		}
+		return $ret;
+	}
+
+	/**
+	 * getXrefList( &$pParamHash );
+	 * Get list of xref records for this contact record
+	 */
+	function getContactTypes() {
+		return $this->mTypes->mContactType;
+	}
+	
+	/**
+	 * getXrefList( &$pParamHash );
+	 * Get list of xref records for this contact record
+	 */
+	function loadContentTypeList() {
+		if( $this->isValid() && empty( $this->mInfo['contact_types'] ) ) {
+			global $gBitUser;
+		
+			$roles = array_keys($gBitUser->mRoles);
+			$bindVars = array();
+			array_push( $bindVars, $this->mContentId );
+			$bindVars = array_merge( $bindVars, $roles, array( $gBitUser->mUserId ) );
+
+			$sql = "SELECT r.`source`, r.`cross_ref_title`, d.`content_id`
+					FROM `".BIT_DB_PREFIX."contact_xref_source` r
+					LEFT JOIN `".BIT_DB_PREFIX."contact_xref` d ON d.`content_id` = ? AND d.`source` = r.`source` 
+					LEFT OUTER JOIN `".BIT_DB_PREFIX."users_roles_map` purm ON ( purm.`user_id`=".$gBitUser->mUserId." ) AND ( purm.`role_id`=r.`role_id` )
+					WHERE r.xref_type = 0 AND (r.`role_id` IN(". implode(',', array_fill(0, count($roles), '?')) ." ) OR purm.`user_id`=?)
+					ORDER BY r.`source`";
+					
+			$result = $this->mDb->query( $sql, $bindVars );
+
+			while( $res = $result->fetchRow() ) {
+				$this->mInfo['contact_types'][] = $res;
+			}
+		}
+	}
+
+	/**
+	 * getXrefList( &$pParamHash );
+	 * Get list of xref records for this contact record
+	 */
+	function loadXrefList() {
+		if( $this->isValid() && empty( $this->mInfo['xref'] ) ) {
+			global $gBitUser;
+		
+			$roles = array_keys($gBitUser->mRoles);
+			$bindVars = array();
+			array_push( $bindVars, $this->mDb->NOW() );
+			array_push( $bindVars, $this->mContentId );
+			$bindVars = array_merge( $bindVars, $roles, array( $gBitUser->mUserId ) );
+
+			$sql = "SELECT s.xref_type, x.`xref_id`, x.`last_update_date`, x.`source`, t.`title` AS type_title,
+					CASE 
+					WHEN x.`end_date` < ? THEN 'history'
+					ELSE t.`source` END as type_source,
+					CASE
+					WHEN x.`xorder` = 0 THEN s.`cross_ref_title`
+					ELSE s.`cross_ref_title` || '-' || x.`xorder` END
+					AS source_title,
+					x.`xkey` AS cross_reference, x.`xkey`, x.`xkey_ext`, x.`data`,
+					x.`start_date`, x.`end_date`
+					FROM `".BIT_DB_PREFIX."contact_xref` x
+					JOIN `".BIT_DB_PREFIX."contact_xref_source` s ON s.`source` = x.`source`
+					JOIN `".BIT_DB_PREFIX."contact_xref_type` t ON t.`xref_type` = s.`xref_type`
+					LEFT OUTER JOIN `".BIT_DB_PREFIX."users_roles_map` purm ON ( purm.`user_id`=".$gBitUser->mUserId." ) AND ( purm.`role_id`=s.`role_id` )
+					WHERE x.content_id = ? AND (s.`role_id` IN(". implode(',', array_fill(0, count($roles), '?')) ." ) OR purm.`user_id`=?)
+					ORDER BY x.`source`, x.`xorder`";
+
+			$result = $this->mDb->query( $sql, $bindVars );
+
+			while( $res = $result->fetchRow() ) {
+				$this->mInfo[$res['type_source']][] = $res;
+			}
+		}
+	}
+
+	/**
+	 * loadXref( &$pParamHash );
+	 * find contact record that matches the supplied xref record
+	 */
+	function loadXref( $pXrefId = NULL ) {
+		if( @BitBase::verifyId( $pXrefId ) ) {
+			$xref = new ContactXref( $pXrefId );
+			if( $xref->mContentId ) {
+				$this->load( $xref->mContentId );
+				$this->mInfo['xref_title'] = $xref->mContentId;
+				$this->mInfo['xref_store'] = $xref->mInfo;
+				$this->mInfo['format_guid'] = 'text';
+			}
+		}
+	}
+
+	/**
+	 * storeXref( &$pParamHash );
+	 * store or update xref records for this contact record
+	 */
+	function storeXref( &$pParamHash ) {
+		$xref = new ContactXref( $pParamHash['xref_id'] );
+		if ( $xref->store( $pParamHash ) ) {
+				$this->mInfo['xref_title'] = $xref->mContentId;
+				$this->mInfo['xref_store'] = $xref->mInfo;
+				$pParamHash['xref_id'] = $xref->mXrefId;
+
+				return true;
+		} else return false;
+	}
+
+	/**
+	 * stepXref( &$pParamHash );
+	 * find contact record that matches the supplied xref record
+	 */
+	function stepXref( &$pParamHash ) {
+		$xref = new ContactXref( $pParamHash['xref_id'] );
+		if ( $xref->stepXref( $pParamHash ) ) {
+			$this->mInfo['xref_title'] = $xref->mContentId;
+			$this->mInfo['xref_store'] = $xref->mInfo;
+			return true;
+		} else return false;
+	}
+	
+	/**
+	 * ContactRecordLoad( $data );
+	 * simple csv contact list import 
+	 * Uncomment to enable
+	 */
+//   require( CONTENT_PKG_PATH.'import/ImportContact.php');
+
+	/**
+	 * SageRecordLoad( $data ); 
+	 * sage csv data import 
+	 * Uncomment to enable
+	 */
+//   require( CONTENT_PKG_PATH.'import/ImportSage.php');
+
+	/**
+	 * PhxRecordLoad( $data ); 
+	 * phoenix security csv data import 
+	 * Uncomment to enable
+	 */
+//	include( CONTENT_PKG_PATH.'import/ImportPhx2.php');
+
+	/**
+	 * wandeRecordLoad( $data ); 
+	 * wande data file import 
+	 * Uncomment to enable
+	 */
+//	include( CONTENT_PKG_PATH.'import/ImportWande.php');
+
+}
+?>