source.php

<?php
@set_time_limit(300);

if(isset($_GET["id"])) { // source.php is called from show_sources.php, sources.php
	$sourcenumber=$_GET["id"];
	source_display($sourcenumber);
}

/*--------------------[source_display]----------------------------
 * Show a single source.
 * RETURNS: shows a single source.
 *    NOTE: function can be called from sources.php and show_sources.php.
 *----------------------------------------------------------------
 */
function source_display($sourcenum) {
global $dbh, $db_functions, $tree_prefix_quoted, $dataDb, $user, $pdf, $screen_mode, $language;

if($screen_mode!="PDF") {
	include_once("header.php"); //returns CMS_ROOTPATH constant
	include_once(CMS_ROOTPATH."menu.php");
	include_once(CMS_ROOTPATH."include/date_place.php");
	include_once(CMS_ROOTPATH."include/process_text.php");
}

// *** Check user authority ***
if ($user['group_sources']!='j'){
	echo __('You are not authorised to see this page.');
	exit();
}
if($screen_mode!="PDF") {
	include_once(CMS_ROOTPATH."include/language_date.php");
	include_once(CMS_ROOTPATH."include/person_cls.php");
	echo '<table class="humo standard">';
	echo "<tr><td><h2>".__('Sources')."</h2>";
}

	$sourceDb=$db_functions->get_source ($sourcenum);

	// *** If an unknown source ID is choosen, exit function ***
	if (!isset($sourceDb->source_id)) exit(__('No valid source number.'));

	if ($sourceDb->source_title){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Title').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_title."\n");
		}
		else {
			echo '<b>'.__('Title').":</b> $sourceDb->source_title<br>";
		}
	}
	if ($sourceDb->source_date){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Date').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,language_date(strtolower($sourceDb->source_date))."\n");
		}
		else {
			echo '<b>'.__('Date').":</b> ".language_date(strtolower($sourceDb->source_date))."<br>";
		}
	}
	if ($sourceDb->source_publ){
		$source_publ=$sourceDb->source_publ;

		$pdflink=0;
		if (substr($source_publ,0,7)=='http://'){
			$link=$source_publ;
			$source_publ='<a href="'.$link.'">'.$link.'</a>';
			$pdflink=1;
		}
		if (substr($source_publ,0,8)=='https://'){
			$link=$source_publ;
			$source_publ='<a href="'.$link.'">'.$link.'</a>';
			$pdflink=1;
		}

		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Publication').": ");
			$pdf->SetFont('Arial','',10);
			if($pdflink==1) {
				$pdf->SetFont('Arial','U',10);  $pdf->SetTextColor(28,28,255);
				$pdf->Write(6,strip_tags($source_publ)."\n",strip_tags($source_publ));
				$pdf->SetFont('Arial','',10);  $pdf->SetTextColor(0);
			}
			else {
				$pdf->Write(6,strip_tags($source_publ)."\n");
			}
		}
		else {
			print '<b>'.__('Publication').":</b> $source_publ<br>";
		}
	}
	if ($sourceDb->source_place){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Place').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_place."\n");
		}
		else {
			print '<b>'.__('Place').":</b> $sourceDb->source_place<br>";
		}
	}
	if ($sourceDb->source_refn){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Own code').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_refn."\n");
		}
		else {
			print '<b>'.__('Own code').":</b> $sourceDb->source_refn<br>";
		}
	}
	if ($sourceDb->source_auth){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Author').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_auth."\n");
		}
		else {
			print '<b>'.__('Author').":</b> $sourceDb->source_auth<br>";
		}
	}
	if ($sourceDb->source_subj){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Subject').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_subj."\n");
		}
		else {
			print '<b>'.__('Subject').":</b> $sourceDb->source_subj<br>";
		}
	}
	if ($sourceDb->source_item){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Nr.').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_item."\n");
		}
		else {
			print '<b>'.__('Nr.').":</b> $sourceDb->source_item<br>";
		}
	}
	if ($sourceDb->source_kind){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Kind').": ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_kind."\n");
		}
		else {
			print '<b>'.__('Kind').":</b> $sourceDb->source_kind<br>";
		}
	}
	if ($sourceDb->source_repo_caln){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Archive')." ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_repo_caln."\n");
		}
		else {
			print '<b>'.__('Archive')."</b> $sourceDb->source_repo_caln<br>"; }
		}
	if ($sourceDb->source_repo_page){
		if($screen_mode=="PDF") {
			$pdf->SetFont('Arial','B',10);
			$pdf->Write(6,__('Page')." ");
			$pdf->SetFont('Arial','',10);
			$pdf->Write(6,$sourceDb->source_repo_page."\n");
		}
		else {
			print '<b>'.__('Page')."</b> $sourceDb->source_repo_page<br>";
		}
	}

	if ($sourceDb->source_text){
		if($screen_mode=="PDF") {
			$source_text=$sourceDb->source_text;
			$source_text=str_replace('<br>', '', $source_text);
			//$pdf->Write(6,html_entity_decode($source_text)."\n");
			$pdf->Write(6,$source_text."\n");
		}
		else {
			print '</td></tr><tr><td>'.process_text($sourceDb->source_text);
		}
	}


	// *** Source pictures not in use yet... ***

	// *** Show repository ***
	$repoDb=$db_functions->get_repository ($sourceDb->source_repo_gedcomnr);
	if ($repoDb){
		if($screen_mode=="PDF") {
			// NO REPOSITORIES IN PDF YET...
		}
		else{
			echo '</td></tr><tr><td>';

			echo '<h3>'.__('Repository').'</h3>';

			echo '<b>'.__('Title').':</b> '.$repoDb->repo_name.'<br>';

			if ($user['group_addresses']=='j'){
				echo '<b>'.__('Zip code').':</b> '.$repoDb->repo_zip.'<br>';
				echo '<b>'.__('Address').':</b> '.$repoDb->repo_address.'<br>';
			}

			if ($repoDb->repo_date){ echo '<b>'.__('Date').':</b> '.$repoDb->repo_date.'<br>'; }
			if ($repoDb->repo_place){ echo '<b>'.__('Place').':</b> '.$repoDb->repo_place.'<br>'; }	
			echo nl2br($repoDb->repo_text);
		}
	}

if($screen_mode!="PDF") { // we do not want all persons in the database as given online so
							// in the pdf file so we'll take just the above details
							// and leave references to persons

print '</td></tr>';
print '<tr><td>';

	$person_cls = New person_cls;

	// *** Find person data if source is connected to a family item ***
	// *** This seperate function speeds up the sources page ***
	function person_data($familyDb){
		global $dbh, $tree_prefix_quoted, $db_functions;
		if ($familyDb->fam_man)
			$personDb=$db_functions->get_person ($familyDb->fam_man);
		else
			$personDb=$db_functions->get_person ($familyDb->fam_woman);
		return $personDb;
	}


	// *** Sources in connect table ***
	//$connect_qry="SELECT * FROM ".$tree_prefix_quoted."connections
	$connect_qry="SELECT * FROM humo_connections WHERE connect_tree_id='".$tree_id."'
		AND connect_source_id='".$sourceDb->source_gedcomnr."'
		ORDER BY connect_kind, connect_sub_kind, connect_order";
	$connect_sql=$dbh->query($connect_qry);
	while($connectDb=$connect_sql->fetch(PDO::FETCH_OBJ)){
		// *** Person source ***
		if ($connectDb->connect_kind=='person'){
			if ($connectDb->connect_sub_kind=='person_source'){ echo __('Source for:'); }
			if ($connectDb->connect_sub_kind=='pers_name_source'){ echo __('Source for name:'); }
			if ($connectDb->connect_sub_kind=='pers_birth_source'){ echo __('Source for birth:'); }
			if ($connectDb->connect_sub_kind=='pers_bapt_source'){ echo __('Source for baptism:'); }
			if ($connectDb->connect_sub_kind=='pers_death_source'){ echo __('Source for death:'); }
			if ($connectDb->connect_sub_kind=='pers_buried_source'){ echo __('Source for burial:'); }
			if ($connectDb->connect_sub_kind=='pers_text_source'){ echo __('Source for text:'); }
			if ($connectDb->connect_sub_kind=='pers_sexe_source'){ echo __('Source for sexe:'); }
			//else { echo 'TEST'; }

			if ($connectDb->connect_sub_kind=='pers_event_source'){
				// *** Sources by event ***
				$event_Db=$db_functions->get_event ($connectDb->connect_connect_id);
				// *** Person source ***
				if ($event_Db->event_person_id){
					$personDb=$db_functions->get_person ($event_Db->event_person_id);
					$name=$person_cls->person_name($personDb);
					print __('Source for:').' <a href="'.CMS_ROOTPATH.'family.php?id='.$personDb->pers_indexnr.'&amp;main_person='.$personDb->pers_gedcomnumber.'">';
					echo $name["standard_name"].'</a>';
					if ($event_Db->event_event){ echo ' '.$event_Db->event_event; }
				}
			}
			//elseif ($connectDb->connect_sub_kind=='address_source'){
			elseif (substr($connectDb->connect_sub_kind,-14)=='address_source'){
				// *** Sources in address table ***
				//$address_sql="SELECT * FROM ".$tree_prefix_quoted."addresses WHERE address_id='".$connectDb->connect_connect_id."'";
				$address_sql="SELECT * FROM humo_addresses WHERE address_id='".$connectDb->connect_connect_id."'";
				@$address_qry=$dbh->query($address_sql);
				$address_Db=$address_qry->fetch(PDO::FETCH_OBJ);
				if ($address_Db->address_person_id){
					$personDb=$db_functions->get_person ($address_Db->address_person_id);
					$name=$person_cls->person_name($personDb);
					echo __('Source for address:').' <a href="'.CMS_ROOTPATH.'family.php?id='.$personDb->pers_indexnr.'&amp;main_person='.$personDb->pers_gedcomnumber.'">';
					echo $name["standard_name"].'</a>';
				}
			}
			else{

//$db_functions->set_tree_prefix($tree_prefix_quoted);
//echo 'TEST: '.$tree_id.' '.$connectDb->connect_sub_kind.' '.$connectDb->connect_connect_id.'<br>';

				$personDb=$db_functions->get_person ($connectDb->connect_connect_id);
				echo ' <a href="'.CMS_ROOTPATH.'family.php?id='.$personDb->pers_indexnr.'&amp;main_person='.$personDb->pers_gedcomnumber.'">';
				$name=$person_cls->person_name($personDb);
				echo $name["standard_name"].'</a>';
			}
		}

		// *** Family source ***
		if ($connectDb->connect_kind=='family'){
			if ($connectDb->connect_sub_kind=='family_source'){
				echo __('Source for family:');
			}
			if ($connectDb->connect_sub_kind=='fam_relation_source'){
				echo __('Source for cohabitation:');
			}
			if ($connectDb->connect_sub_kind=='fam_marr_notice_source'){
				echo __('Source for marriage notice:');
			}
			if ($connectDb->connect_sub_kind=='fam_marr_source'){
				echo __('Source for marriage:');
			}
			if ($connectDb->connect_sub_kind=='fam_marr_church_notice_source'){
				echo __('Source for marriage notice (church):');
			}
			if ($connectDb->connect_sub_kind=='fam_marr_church_source'){
				echo __('Source for marriage (church):');
			}
			if ($connectDb->connect_sub_kind=='fam_div_source'){
				echo __('Source for divorce:');
			}
			if ($connectDb->connect_sub_kind=='fam_text_source'){
				echo __('Source for family text:');
			}
			//else{
			//	echo 'TEST2';
			//}

			//if ($connectDb->connect_sub_kind=='event'){
			if ($connectDb->connect_sub_kind=='fam_event_source'){
				// *** Sources by event ***
				$event_Db=$db_functions->get_event ($connectDb->connect_connect_id);
				// *** Family source ***
				if ($event_Db->event_family_id){
					print __('Source for family:');
					$familyDb=$db_functions->get_family ($event_Db->event_family_id);
					$personDb=person_data($familyDb);
					echo ' <a href="'.CMS_ROOTPATH.'family.php?id='.$event_Db->event_family_id.'">';
					$name=$person_cls->person_name($personDb);
					echo $name["standard_name"].'</a>';
					if ($event_Db->event_event){ echo ' '.$event_Db->event_event; }
				}
			}
			else{
				$familyDb=$db_functions->get_family ($connectDb->connect_connect_id);
				$personDb=person_data($familyDb);
				echo ' <a href="'.CMS_ROOTPATH.'family.php?id='.$connectDb->connect_connect_id.'">';
				$name=$person_cls->person_name($personDb);
				echo $name["standard_name"].'</a>';
			}

		}

		// *** Source by address ***
		if ($connectDb->connect_kind=='address' AND $connectDb->connect_sub_kind=='address_source'){
			//$sql="SELECT * FROM ".$tree_prefix_quoted."addresses WHERE address_id='".$connectDb->connect_connect_id."'";
			$sql="SELECT * FROM humo_addresses WHERE address_id='".$connectDb->connect_connect_id."'";
			$address_sql=$dbh->query($sql); $addressDb=$address_sql->fetch(PDO::FETCH_OBJ);
			if ($addressDb->address_address) $text=$addressDb->address_address;
			if ($addressDb->address_place) $text.=' '.$addressDb->address_place;

			echo __('Source for address:');
			echo ' <a href="address.php?gedcomnumber='.$addressDb->address_gedcomnr.'">'.$text.'</a>';
		}

		// *** Extra source connect information by every source ***
		if ($connectDb->connect_date or $connectDb->connect_place){
			echo " ".date_place($connectDb->connect_date, $connectDb->connect_place);
		}
		// *** Source role ***
		if ($connectDb->connect_role){
			echo ', '.__('role').': '.$connectDb->connect_role;
		}
		// *** Source page ***
		if ($connectDb->connect_page){
			echo ', '.strtolower(__('Page')).': '.$connectDb->connect_page;
		}
		echo '<br>';
	}

print '</td></tr>';

print '</table>';

include_once(CMS_ROOTPATH."footer.php");

} // end if not PDF

} // end function source_display

?>