<?
include("./inc/lib.php");

$accent='ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËéèêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ'; 
$noaccent='AAAAAAaaaaaaOOOOOOooooooEEEEeeeeCcIIIIiiiiUUUUuuuuyNn'; 


//************************************************************************************************
//selection des infos concernant le contact (contact, type, user, organisme)

	$sqlcontact = "select * from contacts, user where PKuser=".$_POST['pk_user']." AND PKuser=FKuser";
	$dbcontact = new class_db($sqlcontact);
	if ($dbcontact->next_record())
	{
		$PK_Contact = $dbcontact->Record[PKcontact];
		$FKSC = $dbcontact->Record[FKsecurite];
		$FKtypeC = $dbcontact->Record[FKtypeContact];
		$FKuser = $dbcontact->Record[FKuser];
		$titreC = $dbcontact->Record[titreContact];
		$desC = $dbcontact->Record[desContact];
		$categC = $dbcontact->Record[categContact];
		$adrC = $dbcontact->Record[adrContact];
		$cpC = $dbcontact->Record[CPContact];
		$villeC = $dbcontact->Record[villeContact];
		$paysC = $dbcontact->Record[paysContact];
		$melC = $dbcontact->Record[melContact];
		$tel1C = $dbcontact->Record[tel1Contact];
		$tel2C = $dbcontact->Record[tel2Contact];
		$faxC = $dbcontact->Record[faxContact];
		$sitewebC = $dbcontact->Record[sitewebContact];
		$anneesortieC = $dbcontact->Record[anneesortieContact];
		$nationaliteC = $dbcontact->Record[nationaliteContact];
		$nationaliteAffichC = $dbcontact->Record[nationaliteAffich];
		$adrAffichC = $dbcontact->Record[adrContactAffich];
		$orgAffichC = $dbcontact->Record[orgAffich];
		$tel1AffichC = $dbcontact->Record[tel1Affich];
		$tel2AffichC = $dbcontact->Record[tel2Affich];
		$faxAffichC = $dbcontact->Record[faxAffich];
		$melAffichC = $dbcontact->Record[melAffich];
		$sitewebAffichC = $dbcontact->Record[sitewebAffich];
		$commentaireAudioC = $dbcontact->Record[commentaireAudioContact];
		$commentaireAudioAffichC = $dbcontact->Record[commentaireAudioAffich];
		$autreOeuvreC = $dbcontact->Record[autreOeuvreContact];
		$autreOeuvreAffichC = $dbcontact->Record[autreOeuvreAffich];
		$titreMemC = $dbcontact->Record[titreMemContact];
		$titreMemAffichC = $dbcontact->Record[titreMemAffich];

		$sqluser = "select * from user where PKuser = ".$_POST['pk_user'];
		$dbuser = new class_db($sqluser);
		if ($dbuser->next_record())
		{
				$modif = 1;
				$FKSU = $dbuser->Record[Fksecurite];
				$nomU = $dbuser->Record[nom];
				$prenomU = $dbuser->Record[prenom];
				$civiliteU = $dbuser->Record[civilite];
				$loginU = $dbuser->Record[login];
				$pswU = $dbuser->Record[psw];
				$dateNaissanceU = $dbuser->Record[dateNaissance];
				$dateNAffichU = $dbuser->Record[dateNAffich];
				$civiliteAffichU = $dbuser->Record[civiliteAffich];
				$sqlorg = "select organisme.PKorganisme, organisme.FKsecurite, organisme.raisonSOrg, organisme.desOrg, organisme.adrOrg, organisme.CPOrg, organisme.villeOrg, organisme.paysOrg, organisme.melOrg, organisme.tel1Org, organisme.tel2Org, organisme.faxOrg, organisme.sitewebOrg, organisme.securiteOrg, appartenance.adrAffich, appartenance.tel1Affich, appartenance.tel2Affich, appartenance.faxAffich, appartenance.melAffich from organisme, appartenance ";
				$sqlorg .= "where appartenance.FKcontact = ".$PK_Contact." and appartenance.FKorganisme = organisme.PKorganisme"; // and appartenance.isonlineApp = 1 and organisme.isonlineOrg = 1 and securiteApp <= ".$secure_id." and organisme.securiteOrg <= ".$secure_id;
				$dborg = new class_db($sqlorg);
				if ($dborg->next_record())
				{
					$PKorganisme = $dborg->Record[PKorganisme];
					$FKSO = $dborg->Record[FKsecurite];
					$raisonSO = $dborg->Record[raisonSOrg];
					$desO = $dborg->Record[desOrg];
					$adrO = $dborg->Record[adrOrg];
					$cpO = $dborg->Record[CPOrg];
					$villeO = $dborg->Record[villeOrg];
					$paysO = $dborg->Record[paysOrg];
					$melO = $dborg->Record[melOrg];
					$tel1O = $dborg->Record[tel1Org];
					$tel2O = $dborg->Record[tel2Org];
					$faxO = $dborg->Record[faxOrg];
					$sitewebO = $dborg->Record[sitewebOrg];
					$securiteO = $dborg->Record[securiteOrg];
					$adrAffichO = $dborg->Record[adrAffich];
					$tel1AffichO = $dborg->Record[tel1Affich];
					$tel2AffichO = $dborg->Record[tel2Affich];
					$faxAffichO = $dborg->Record[faxAffich];
					$melAffichO = $dborg->Record[melAffich];
					$IsCreaOrg = 0;
				}
				else
				{
					$sqlapp = "select PKorganisme from organisme, appartenance where appartenance.FKcontact = ".$PK_Contact." and appartenance.FKorganisme = organisme.PKorganisme";
					$dbapp = new class_db($sqlapp);
					if ($dbapp->next_record())
					{
						$IsCreaOrg = 0;
					}else{
						$IsCreaOrg = 1;
					}
				}
		}
		else
		{
			$NonTrouve = 1;
		}
	}
	else
	{
		$NonTrouve = 1;
	}
?>
<HTML>
<HEAD>
<TITLE></TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</HEAD>

<BODY LEFTMARGIN=0 MARGINHEIGHT=0 MARGINWIDTH=0 TOPMARGIN=0 bgcolor=black>
<style type="text/css">
.colorBox {
	background-color:#000000;
}
</style>

<table border=0 cellpadding=0 cellspacing=0 width=100% height="171" background="./images/bandeau.jpg">
<tr>
	<td colspan=2>&nbsp;</td>
</tr>
<tr>
	<td width="165">&nbsp;</td>
	<form action="index.php" METHOD="post"><td><INPUT TYPE="submit" name="look" VALUE="Nouvelle recherche" style="font-family:verdana;font-size:9;color:#FFFFFF;background:#9C0001;"></td></form>
</tr>
</table>

<table border=0 cellpadding=0 cellspacing=0 width=100% bgcolor=CE0000>
<FORM NAME="form_liste" METHOD="post" action="fiche_print.php" target="_blank">
<input type="hidden" name="pk_user" value="">
<input type="hidden" name="pk_contact" value="">
<tr>
	<td>&nbsp;<br><br>&nbsp;</td>
</tr>
<tr>
<td valign=top align="center">
	
	<table border=1 cellpadding=0 cellspacing=0 width=750 bgcolor="#FFFFFF" bordercolor="#9C0001">
	<tr>
	<td align=center>

		<table width="90%" border=0 bgcolor="#FFFFFF" cellpadding="0" cellspacing="0">
		<tr>
			<td colspan=2>&nbsp;</td>
		</tr>
		<tr>
			<td valign="top" width="46%">
				<font face=verdane size=2>
				<font size=3>&nbsp;&nbsp;<b></b></font><br><br>
<?
if ($titreC != '')
{
?>
				<font color=#FFFFFF class="colorBox">&nbsp;&nbsp;</font><br>
<?
}

if (($nationaliteAffichC == 'O') && ($nationaliteC != ''))
{
?>

				nationalité <br>
<?
}

if (($dateNAffichU == 'O') && ($dateNaissanceU != ''))
{
?>
				né<? if (($civiliteU == 'Madame')||($civiliteU == 'Mademoiselle')||($civiliteU == 'Mme')||($civiliteU == 'Mlle')){?>e<?}?> le <br>
<?
}
?>
				<b>
<?
if ($adrAffichC == 'O')
{
?>
				<? if ($adrC != "") { echo $adrC."<br>"; }?>
				<? if ($cpC != "") { echo $cpC; }?>&nbsp;<? if ($villeC != "") { echo $villeC."<br>"; }?>
				<? if ($paysC != "") { echo $paysC."<br>"; }?>
<?
}
?>				
				<?if (($tel1C != "") && ($tel1AffichC == "O")) { echo $tel1C."<br>"; }?>
				<? if (($tel2C != "") && ($tel2AffichC == "O")) { echo $tel2C."<br>"; }?>
				<? if (($melC != "") && ($melAffichC == "O")) { echo $melC."<br>"; }?>
				<? if (($sitewebC != "") && ($sitewebAffichC == "O")) { echo $sitewebC."<br>"; }?>
				</b>
<?
if ($adrAffichO == 'O')
{
?>
				<br>
				<b><? if ($raisonSO != "") { echo $raisonSO."<br>"; }?>
				<? if ($adrO != "") { echo $adrO."<br>"; }?>
				<? if ($cpO != "") { echo $cpO; }?>&nbsp;<? if ($villeO != "") { echo $villeO."<br>"; }?>
				<? if ($paysO != "") { echo $paysO."<br>"; }?>
<?
}
?>
				<? if (($tel1O != "") && ($tel1AffichO == "O")) { echo $tel1O."<br>"; }?>
				<? if (($tel2O != "") && ($tel2AffichO == "O")) { echo $tel2O."<br>"; }?>
				<? if (($faxO != "") && ($faxAffichO == "O")) { echo $faxO."<br>"; }?>
				<? if (($melO != "") && ($melAffichO == "O")) { echo $melO."<br>"; }?>
				<? if (($sitewebO != "") && ($sitewebAffichO == "O")) { echo $sitewebO."<br>"; }?>
				</b>
				<br><br><br>
				<img src="images/fleche.gif" width="7" height="7" border="0" alt="">&nbsp;<b>études</b><br>
				DEPARTEMENT <br>
				PROMOTION <?//=$desC?><?// if ($anneesortieC != '') { echo " - ".$anneesortieC; }?><br><br>
<?
if (($titreMemAffichC == 'O') && ($titreMemC != ''))
{
?>
				mémoire : <br><br>
<?
}

				// Films Femis
				$sql = "select * from filmcontact,film where filmcontact.FKuser = ".$_POST['pk_user']." AND film.femisFilm = 'O' AND film.PKfilm = filmcontact.FKfilm AND filmcontact.filmAffich = 'O' ORDER BY anneeFilm DESC";
				$db = new class_db($sql);
				$nbfilmcontact = $db->num_rows();
				if ($nbfilmcontact > 0)
				{
					while ($db->next_record())
					{
						$fonctionC = $db->Record[fonction];
						$titreF = $db->Record[titreFilm];
						$anneeF = $db->Record[anneeFilm];
						$typeexoF = $db->Record[typeexoFilm];
						$genreF = $db->Record[genreFilm];
?>
						<? if ($fonctionC != "") { echo $fonctionC. " - "; }?><? if ($titreF != "") { echo "<em>".$titreF."</em> "; }?><? if ($typeexoF != "") { echo "(".$typeexoF.")"; }?><br><? if ($genreF != "") { echo $genreF; if ($anneeF != "") { echo ", "; } }?><? if ($anneeF != "") { echo $anneeF; }?><br>
<?
					}
				}
?>
				</font>
			</td>
			<td valign="top" width="8%">
			&nbsp;
			</td>
			<td valign="top" width="46%">
				<font face=verdane size=2>
<?
				//recup info films apresFemis
				$sql = "select * from filmcontact,film where filmcontact.FKuser = ".$_POST['pk_user']." AND film.femisFilm = 'N' AND film.PKfilm = filmcontact.FKfilm AND filmcontact.filmAffich = 'O' ORDER BY anneeFilm DESC";
				$db = new class_db($sql);
				$dbfilm = new class_db($sql);
				$nbfilmcontact = $db->num_rows();
				if ($nbfilmcontact > 0)
				{
					$lenbfilm = 0;
					while ($db->next_record())
					{
						$fonctionC = $db->Record[fonction];
						$remunerationFilmC = $db->Record[remuneration];
						$statutEmploiFilmC = $db->Record[statutEmploi];
						$titreF = $db->Record[titreFilm];
						$genreF = $db->Record[genreFilm];
						$metragecineF = $db->Record[metragecineFilm];
						$metragetvF = $db->Record[metragetvFilm];
						$metrageautreF = $db->Record[metrageautreFilm];
						$dureeF = $db->Record[dureeFilm];
						$anneeF = $db->Record[anneeFilm];
						$realisateurF = $db->Record[realisateurFilm];
						$employeurF = $db->Record[employeurFilm];

						if ($lenbfilm == 0) { echo '<img src="images/fleche.gif" width="7" height="7" border="0" alt="">&nbsp;<b>filmographie</b><br>'; }
?>
						<? if ($fonctionC != "") { echo $fonctionC. " - "; }?><? if ($titreF != "") { echo "<em>".$titreF."</em> - "; }?><? if ($metragecineF != "") { echo $metragecineF." métrage de "; }?><? if ($genreF != "") { echo $genreF;  if ($anneeF != "") { echo ", "; } }?><? if ($anneeF != "") { echo $anneeF; }?><br>
<?
						$lenbfilm++;
					}
				}

				if ($lenbfilm != 0) { echo '<br><br><br>'; }

				if ($nbfilmcontact > 0)
				{
					$lenbfilm2 = 0;
					while ($dbfilm->next_record())
					{
						$FKfilmC = $dbfilm->Record[FKfilm];
						$titreF = $dbfilm->Record[titreFilm];

						$sql3 = "select * from prixfilm where FKfilm = $FKfilmC ORDER BY anneePFilm DESC";
						$db3 = new class_db($sql3);
						$nbprix = $db3->num_rows();
						if ($nbprix > 0)
						{
							$lenbpx = 0;
							while ($db3->next_record())
							{
								$FKprixfilm = $db3->Record[PKprixfilm];
								$FKfestivalPFilm = $db3->Record[FKfestival];
								$anneePF = $db3->Record[anneePFilm];
								$prixPF = $db3->Record[prixPFilm];
								$festivalPF = $db3->Record[festivalPFilm];

								$affichPF='O';
								$sql3bis = "select * from affichprixfilm where FKprixfilm = ".$FKprixfilm." AND FKcontact=".$PK_Contact;
								$db3bis = new class_db($sql3bis);
								while ($db3bis->next_record())
								{
									$affichPF = $db3bis->Record[affichPF];
								}

								if ($affichPF == 'O')
								{
									if ($lenbfilm2 == 0) { echo '<img src="images/fleche.gif" width="7" height="7" border="0" alt="">&nbsp;<b>sélections et prix</b><br>'; }
									if ($lenbpx == 0) { echo "<em>".$titreF."</em><br>"; }
									//echo strtolower($prixPF);
									echo ucfirst($prixPF);
									if ($festivalPF != '') { echo " au ".ucfirst($festivalPF).", "; } else { echo ", "; }
									echo $anneePF."<br>";
									$lenbpx++;
									$lenbfilm2++;
								}
							}
						}
					}
				}

				if ($lenbfilm2 != 0) { echo '<br><br><br>'; }

				//recup info emplois secteur ciné
				$sql = "select * from emploi where FKcontact = ".$PK_Contact." AND liencineEmploi = 'O' AND affichEmploi = 'O' ORDER BY anneeDebutEmploi DESC";
				$db = new class_db($sql);
				$nbemploi = $db->num_rows();
				if (($nbemploi > 0) || (($autreOeuvreAffichC == 'O')&&($autreOeuvreC != '')) || (($commentaireAudioAffichC == 'O')&&($commentaireAudioC != '')))
				{
?>
				<img src="images/fleche.gif" width="7" height="7" border="0" alt="">&nbsp;<b>autres</b><br>
<?
				  while ($db->next_record())
				  {
					$posteemploiC = $db->Record[posteEmploi];
					$anneedebutemploiC = $db->Record[anneeDebutEmploi];
					$anneefinemploiC = $db->Record[anneeFinEmploi];
					$employeurC = $db->Record[employeurEmploi];

					echo $posteemploiC;
					if ($employeurC != "") { echo " chez ".$employeurC; }
					if ($anneefinemploiC != "") { echo " de $anneedebutemploiC à $anneefinemploiC"; }else{ echo " depuis $anneedebutemploiC"; }
					echo "<br>";

				  }
				}
?>
				<? if (($autreOeuvreC != '') && ($autreOeuvreAffichC == 'O')) { echo $autreOeuvreC."<br><br>"; }?>
				<? if (($commentaireAudioC != '') && ($commentaireAudioAffichC == 'O')) { echo $commentaireAudioC; }?>
				</font>
			</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
<?
			if ((ereg("MSIE", $_SERVER["HTTP_USER_AGENT"])) || (ereg("Mac_PowerPC", $_SERVER["HTTP_USER_AGENT"])))
			{
				$lelien = "fiche_print.php";
			}
			else
			{
				$lelien = "fiche_printsimple.php";
			}
?>
			<td colspan="2" height="100" align="center" valign="middle"><a href="#" onClick="document.form_liste.action=''; document.form_liste.submit();"><img src="./images/save.jpg" width="20" height="20" border="0" alt="Enregistrer la fiche"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="#" onClick="document.form_liste.action=''; document.form_liste.submit();"><img src="./images/print.gif" width="20" height="20" border="0" alt="Imprimer la fiche"></a></td>
		</tr>
		</table>

	</td>
	</tr>
	</table>

</td>
</tr>
<tr>
	<td>&nbsp;<br><br>&nbsp;</td>
</tr>
</FORM>
</table>

</BODY>
</HTML>