include("header.php");
$complet=0;
if(isset($_POST['Register']))
{
$erreur=0;
if(strlen($_POST['FirstName'])<2)
{
$erreur=1;
echo "Invalid First Name
";
}
if(strlen($_POST['Name'])<2)
{
$erreur=1;
echo "Invalid Name
";
}
if((strlen($_POST['Affiliation'])<2)||(ereg("http:",$_POST['Affiliation'])))
{
$erreur=1;
echo "Invalid Affiliation
";
}
if((strlen($_POST['Address'])<2)||(ereg("http:",$_POST['Address'])))
{
$erreur=1;
echo "Invalid Address
";
}
if(strlen($_POST['ZipCode'])<1)
{
$erreur=1;
echo "Invalid Zip Code
";
}
if(strlen($_POST['Town'])<1)
{
$erreur=1;
echo "Invalid Town
";
}
if(strlen($_POST['Country'])<2)
{
$erreur=1;
echo "Invalid Country
";
}
if((ereg("http:",$_POST['Comments']))||(ereg("http:",$_POST['MealsRestrict'])))
{
$erreur=1;
echo "Invalid Comments or Meals Restriction
";
}
if(!eregi('^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]{2,})+$',$_POST['Email']))
{
$erreur=1;
echo "Invalid Email
";
}
$bd = mysql_connect("localhost","RegistrationPMS", "RLx7zHWa6CC5Nz6F");
mysql_select_db("RegistrationPMS10", $bd);
$mail=$_POST['Email'];
$requete= mysql_query("SELECT Email FROM ListeReg WHERE Email='$mail'") or die('Erreur SQL !
'.mysql_error());
$result = mysql_fetch_row($requete);
if(!strcmp($_POST['Email'],$result[0]))
{
$erreur=1;
echo "This Email is already registered
";
}
if($erreur==0)
{
$p1=str_replace("'", "'",$_POST['FirstName']);
$p2=str_replace("'", "'",$_POST['Name']);
$p3=str_replace("'", "'",$_POST['Affiliation']);
$p4=str_replace("'", "'",$_POST['Address']);
$p5=str_replace("'", "'",$_POST['ZipCode']);
$p6=str_replace("'", "'",$_POST['Town']);
$p7=str_replace("'", "'",$_POST['Country']);
$p8=str_replace("'", "'",$_POST['Tel']);
$p9=str_replace("'", "'",$_POST['Email']);
$p10=str_replace("'", "'",$_POST['TypeReg']);
$p11=str_replace("'", "'",$_POST['NbAccomp']);
$p12=str_replace("'", "'",$_POST['TypePay']);
$p13=str_replace("'", "'",$_POST['MealsRestrict']);
$p14=str_replace("'", "'",$_POST['Comments']);
$p15=str_replace("'", "'",$_POST['WelcomeReception']);
$p16=str_replace("'", "'",$_POST['SocialActivities']);
$p17=str_replace("'", "'",$_POST['Galadiner']);
$p0= date("\l\e d-m-y \a H:m:s");
$requete= mysql_query("INSERT INTO ListeReg ( ID , Date , FirstName , Name , Affiliation , Address , ZipCode, Town, Country, Tel, Email, TypeReg, NbAccomp, TypePay, MealsRestrict, Comments, WelcomeReception, SocialActivities, Galadiner)
VALUES ('', '$p0', '$p1', '$p2', '$p3', '$p4','$p5','$p6', '$p7', '$p8', '$p9','$p10','$p11','$p12','$p13','$p14','$p15','$p16','$p17' )") or die('Erreur SQL !
'.mysql_error());
mysql_close($bd);
$complet=1;
}
else
{
mysql_close($bd);
}
}
else
{
$_POST['FirstName']="";
$_POST['Name']="";
$_POST['Affiliation']="";
$_POST['Address']="";
$_POST['ZipCode']="";
$_POST['Town']="";
$_POST['Country']="";
$_POST['Tel']="";
$_POST['Email']="";
$_POST['TypeReg']="Academic";
$_POST['NbAccomp']=0;
$_POST['TypePay']="Bank transfert";
$_POST['MealsRestrict']="";
$_POST['Comments']="";
$_POST['WelcomeReception']="1";
$_POST['SocialActivities']="1";
$_POST['Galadiner']="1";
}
if($complet==1)
{
$p1=str_replace("\'", "'",$p1);
$p2=str_replace("\'", "'",$p2);
$p3=str_replace("\'", "'",$p3);
$p4=str_replace("\'", "'",$p4);
$p5=str_replace("\'", "'",$p5);
$p6=str_replace("\'", "'",$p6);
$p7=str_replace("\'", "'",$p7);
$p8=str_replace("\'", "'",$p8);
$p9=str_replace("\'", "'",$p9);
$p10=str_replace("\'", "'",$p10);
$p11=str_replace("\'", "'",$p11);
$p12=str_replace("\'", "'",$p12);
$p13=str_replace("\'", "'",$p13);
$p14=str_replace("\'", "'",$p14);
$p15=str_replace("\'", "'",$p15);
$p16=str_replace("\'", "'",$p16);
$p17=str_replace("\'", "'",$p17);
/*PDF****/
include 'lib_pdf/class.ezpdf.php';//inclusion de la lib
$pdf= &new Cezpdf('a4','portrait');//constructeur du pdf au format A4 PORTRAIT
$pdf->selectFont('lib_pdf/fonts/Times-Roman.afm');
$pdf->ezStartPageNumbers(550,30,12,'right','{PAGENUM} / {TOTALPAGENUM}');
$pdf->ezSetMargins(30,30,30,30);
$pdf->addInfo('Author','Organizing Committee of PMS\'10');
$pdf->openHere('Fit');
$data=array(
array('PMS 2010',html_entity_decode("Christelle GRANGE / PMS'10")),
array('===================',html_entity_decode("Département Informatique de Polytech'Tours ")),
array('Project Management and Scheduling',html_entity_decode("64, avenue Jean Portalis, F-37200 Tours, France")),
array('12th International Workshop',html_entity_decode("christelle.grange@univ-tours.fr")),
array('April 26-28, 2010, Tours France',html_entity_decode("Fax number: +33 2 47 361 422 "))
);
$options=array(
'showLines'=>0,
'showHeadings'=>0,
'shaded'=>0,
'shadeCol'=>array(1,1,1,1,1),
'fontsize'=>14,
'xPos'=>'left',
'xOrientation'=>'right',
'width'=>575,
'maxWidth'=>575,
'cols'=> array(
array('justification'=>'left'),
array('justification'=>'left','width'=>230)
)
);
$title="";
$cols=array(
'1',
'2'
);
$pdf->ezTable($data,$cols,$title,$options);
$pdf->ezText(" ",8,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
$pdf->ezText(" REGISTRATION FORM ",20,array('justification'=>'center'));
$pdf->ezText(" ",11,array('justification'=>'left'));
$pdf->ezText("Fax, email or post this form to Christelle GRANGE.",11,array('justification'=>'left'));
$pdf->ezText("Registration forms without payment details will not be processed.",11,array('justification'=>'left'));
$pdf->ezText("Any questions, please call +33 2 47 361 427.",11,array('justification'=>'left'));
$pdf->ezText(" ",12,array('justification'=>'left'));
$pdf->ezText("Please ensure Sections 1, 2 and 3 are completed.",12,array('justification'=>'right'));
$pdf->ezText(" ",14,array('justification'=>'left'));
$pdf->saveState();
$pdf->setColor(0.9,0.9,0.9);
$pdf->filledRectangle($pdf->ez['leftMargin'],$pdf->y-$pdf->getFontHeight(14)+$pdf->getFontDecender(14),$pdf->ez['pageWidth']-$pdf->ez['leftMargin']-$pdf->ez['rightMargin'],$pdf->getFontHeight(14));
$pdf->restoreState();
$pdf->ezText("Section 1 : REGISTRATION DETAILS ",14,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
$data=array(
array('First Name: ',html_entity_decode($p1)),
array('Name: ',html_entity_decode($p2)),
array('Affiliation: ',html_entity_decode($p3)),
array('Address: ',html_entity_decode($p4)),
array('Zip Code: ',html_entity_decode($p5)),
array('Town: ',html_entity_decode($p6)),
array('Country: ',html_entity_decode($p7)),
array('Tel: ',html_entity_decode($p8)),
array('Email: ',html_entity_decode($p9)),
array('Meals restriction: ',html_entity_decode($p13)),
array(' ',html_entity_decode(" ")),
array('Comments: ',html_entity_decode($p14)),
array(' ',html_entity_decode(" "))
);
$options=array(
'showLines'=>0,
'showHeadings'=>0,
'shaded'=>0,
'shadeCol'=>array(1,1,1,1,1,1,1,1,1,1,1,1,1),
'fontsize'=>14,
'xPos'=>'left',
'xOrientation'=>'right',
'width'=>545,
'maxWidth'=>545,
'cols'=> array(
array('justification'=>'right','width'=>90),
array('justification'=>'left')
)
);
$title="";
$cols=array(
'1',
'2'
);
$pdf->ezTable($data,$cols,$title,$options);
$pdf->ezText(" ",14,array('justification'=>'left'));
$pdf->saveState();
$pdf->setColor(0.9,0.9,0.9);
$pdf->filledRectangle($pdf->ez['leftMargin'],$pdf->y-$pdf->getFontHeight(14)+$pdf->getFontDecender(14),$pdf->ez['pageWidth']-$pdf->ez['leftMargin']-$pdf->ez['rightMargin'],$pdf->getFontHeight(14));
$pdf->restoreState();
$pdf->ezText("Section 2 : SOCIAL EVENTS ",14,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
if($p15=="1")
$WR="X";
else
$WR=" ";
if($p16=="1")
$SA="X";
else
$SA=" ";
if($p17=="1")
$GD="X";
else
$GD=" ";
$pdf->ezText("[".$WR."]Welcome Reception (26th) [".$SA."] Social activity (27th) [".$GD."] Gala dinner (28th) ",10,array('justification'=>'justify'));
$pdf->ezText(" ",5,array('justification'=>'left'));
$pdf->ezText("The registration fees includes the welcome reception, the social activity and the gala dinner.",10,array('justification'=>'left'));
$pdf->ezText(" ",12,array('justification'=>'left'));
$pdf->ezText(" ",14,array('justification'=>'left'));
$pdf->saveState();
$pdf->setColor(0.9,0.9,0.9);
$pdf->filledRectangle($pdf->ez['leftMargin'],$pdf->y-$pdf->getFontHeight(14)+$pdf->getFontDecender(14),$pdf->ez['pageWidth']-$pdf->ez['leftMargin']-$pdf->ez['rightMargin'],$pdf->getFontHeight(14));
$pdf->restoreState();
$pdf->ezText("Section 3 : PAYMENT DETAILS ",14,array('justification'=>'left'));
$pdf->ezText(" ",8,array('justification'=>'left'));
$date_reg=date('m/d/Y');
$datefin='03/12/2010';
$dreg= explode("/", $date_reg);
$dfin= explode("/", $datefin);
$nb_date_reg = $dreg[2].$dreg[0].$dreg[1];
$nb_datefin = $dfin[2].$dfin[0].$dfin[1];
$totalEuro=0;
if($p10==Academic)
{
$totalEuro=320;
}
else
{
if($p10==Student)
{
$totalEuro=200;
}
else
{
$totalEuro=500;
}
}
if($nb_datefin<$nb_date_reg)
{ $totalEuro=$totalEuro+100; }
else
{
if(($p12!="Credit Card")&&($p12!="Bon de commande")&&($p12!="Bank transfert"))
{ $totalEuro=$totalEuro; }
}
$totalEuro=$totalEuro+$p11*80;
$data=array(
array('Registration type: ',html_entity_decode($p10)),
array('Registration date: ',html_entity_decode($date_reg)),
array('Number of accompanying persons: ',html_entity_decode($p11)),
array('(80 Euros per person) ',html_entity_decode(" ")),
array(' ',html_entity_decode(" ")),
array('Total amount :',"".html_entity_decode($totalEuro)." Euros"),
array(' ',"".html_entity_decode("(includes reception, conference proceedings, lunches, coffee breaks, gala dinner and social activity)"."")),
array('Payment mode: ',html_entity_decode($p12))
);
$options=array(
'showLines'=>0,
'showHeadings'=>0,
'shaded'=>0,
'shadeCol'=>array(1,1,1,1,1,1,1,1,1,1,1,1,1),
'fontsize'=>14,
'xPos'=>'left',
'xOrientation'=>'right',
'width'=>545,
'maxWidth'=>545,
'cols'=> array(
array('justification'=>'right','width'=>190),
array('justification'=>'left')
)
);
$title="";
$cols=array(
'1',
'2'
);
$pdf->ezTable($data,$cols,$title,$options);
$pdf->ezNewPage();
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText("",22,array('justification'=>'left'));
if($p12=="Bank transfert")
{
$pdf->ezText("How to pay by bank transfert?",14,array('justification'=>'left'));
$pdf->ezText("",22,array('justification'=>'left'));
$data=array(
array('A credit transfer must be carried out to: ',html_entity_decode("Agent Comptable de l'Université de Tours, TG Tours")),
array('Address: ',html_entity_decode("Trésorerie générale\n 92 boulevard Béranger\n 37 000 Tours, FRANCE")),
array('Reference: ',html_entity_decode("PMS10")),
array('Bank code: ',html_entity_decode("10071")),
array('Guichet code: ',html_entity_decode("37000")),
array('Account number: ',html_entity_decode("00001000075")),
array('Key: ',html_entity_decode("77")),
array('Code IBAN: ',"FR76 1007 1370 0000 0010 0007 577"),
array('BIC or Swift: ',"BDFEFRPPXXX")
);
$options=array(
'showLines'=>0,
'showHeadings'=>0,
'shaded'=>0,
'shadeCol'=>array(1,1,1,1,1,1,1,1,1),
'fontsize'=>14,
'xPos'=>'left',
'xOrientation'=>'right',
'width'=>545,
'maxWidth'=>545,
'cols'=> array(
array('justification'=>'right','width'=>190),
array('justification'=>'left')
)
);
$title="";
$cols=array(
'1',
'2'
);
$pdf->ezTable($data,$cols,$title,$options);
$pdf->ezText(" ",12,array('justification'=>'left'));
$pdf->ezText("Your name must be mentioned on the credit transfer order.",12,array('justification'=>'left'));
$pdf->ezText("A copy of the credit transfer order and this Registration Form must be mailed or faxed to: Christelle GRANGE / PMS'10 (fax number: +33 2 47 361 422).",12,array('justification'=>'left'));
}
else
{
if($p12=="Credit Card")
{
$pdf->ezText("How to pay by credit card?",14,array('justification'=>'left'));
$pdf->ezText("",14,array('justification'=>'left'));
$pdf->ezText("Please send this form with all the following fields filled.",12,array('justification'=>'left'));
$pdf->ezText(" ",12,array('justification'=>'left'));
$pdf->ezText("Credit card information: \t \t [_] Mastercard \t \t [_] Visa \t \t [_] American Express \t \t [_] Eurocard ",12,array('justification'=>'left'));
$pdf->ezText("",12,array('justification'=>'left'));
$pdf->ezText("\t Credit Card Number:......................................................................................................................................",12,array('justification'=>'left'));
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("\t Expiry date:.....................................................................................................................................................",12,array('justification'=>'left'));
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("\t Card Security Code (3-digit code):.................................................................................................................",12,array('justification'=>'left'));
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("\t Last name written on the card:........................................................................................................................",12,array('justification'=>'left'));
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("\t First name:......................................................................................................................................................",12,array('justification'=>'left'));
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("Send it by fax or mail to Christelle GRANGE (christelle.grange@univ-tours.fr, fax number +33 2 47 361 422).",12,array('justification'=>'left'));
}
else
{
if($p12=="Bon de commande")
{
$pdf->ezText("How to pay by bon de commande?",14,array('justification'=>'left'));
$pdf->ezText("",14,array('justification'=>'left'));
$pdf->ezText("This payment mode is only for french participants. \"Bon de Commande\" must be returned to:",12,array('justification'=>'left'));
$pdf->ezText("",12,array('justification'=>'left'));
$data=array(
array(' ',html_entity_decode("Christelle GRANGE / PMS'10")),
array(' ',html_entity_decode("Département Informatique de Polytech'Tours ")),
array(' ',html_entity_decode("64, avenue Jean Portalis, F-37200 Tours, France"))
);
$options=array(
'showLines'=>0,
'showHeadings'=>0,
'shaded'=>0,
'shadeCol'=>array(1,1,1,1,1),
'fontsize'=>16,
'xPos'=>'left',
'xOrientation'=>'right',
'width'=>575,
'maxWidth'=>575,
'cols'=> array(
array('justification'=>'left'),
array('justification'=>'left','width'=>400)
)
);
$title="";
$cols=array(
'1',
'2'
);
$pdf->ezTable($data,$cols,$title,$options);
$pdf->ezText("",8,array('justification'=>'left'));
$pdf->ezText("Send this registration form with the Bon de Commande.",12,array('justification'=>'left'));
}
else
{
if($p12=="French cheque")
{
$pdf->ezText("How to pay by french cheque?",14,array('justification'=>'left'));
$pdf->ezText("",14,array('justification'=>'left'));
$pdf->ezText("This payment mode is only for french participants. Please, enclose a cheque in EURO, with the following order: Agent Comptable de l'université de Tours.",12,array('justification'=>'left'));
}
else
{//Last minutes by Credit Card
$pdf->ezText("METHOD OF PAYMENT by last minutes by credit card:",14,array('justification'=>'left'));
$pdf->ezText("",14,array('justification'=>'left'));
$pdf->ezText("Payment by cash (in EURO) or Credit Card at the registration desk will be enabled only for last minutes registration at the cost of late registration.",12,array('justification'=>'left'));
}
}
}
}
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText(html_entity_decode(" Date: _______________________ "),14,array('justification'=>'right'));
$pdf->ezText("",22,array('justification'=>'left'));
$pdf->ezText(html_entity_decode("Signature: ____________________"),14,array('justification'=>'right'));
$pdfCode = $pdf->ezOutput();//sortie du texte pdf généré
//enregisetrement dans le fichier test.pdf
$p11=strtr($p1,'àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ','aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY');
$p22=strtr($p2,'àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ','aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY');
$p11=str_replace("'", "",$p11);
$p22=str_replace("'", "",$p22);
$p11=str_replace("-", "",$p11);
$p22=str_replace("-", "",$p22);
srand();
$rand = rand(1, 500);
$nomfic = "inscriptionPDF/".$p11."_"."$p22".$rand.".pdf";
$fh = fopen($nomfic,"wb") ;
fwrite($fh,$pdfCode) ;
fclose($fh) ;
include "libmail.php";
$m1= new Mail;
$m1->To( $p9 );
$m1->Bcc( "yannick.kergosien@univ-tours.fr" );
$m1->From("vincent.tkindt@univ-tours.fr" );
$m1->Subject( "Confirm your registration PMS'10" );
$corpsMsg = "Dear ".$p1.", \n\n To complete your registion, you need to fax, email, or post this registration form to the following address \n";
$corpsMsg=$corpsMsg."\t Christelle GRANGE / PMS'10 \n";
$corpsMsg=$corpsMsg."\t Département Informatique de Polytech'Tours \n";
$corpsMsg=$corpsMsg."\t 64, avenue Jean Portalis F-37200 Tours \n";
$corpsMsg=$corpsMsg."\t France \n";
$corpsMsg=$corpsMsg."\t Fax number: +33 2 47 361 422 \n";
$corpsMsg=$corpsMsg."\t christelle.grange@univ-tours.fr \n";
$corpsMsg=$corpsMsg." \n Thank you for your registration.\n \n Best regards. \n \t \t \t Organizing Committee.";
$m1->Body( $corpsMsg);
$m1->Attach( "$nomfic", "application/pdf " ) ;
$m1->Send();
?>
Registration form
First step of registration completed.
A mail was sent to with the following registration form.
If you receive any mail, please contact us (vincent.tkindt@univ-tours.fr or yannick.kergosien@univ-tours.fr).
Please send as soon as possible (by email, fax ou mail) this form together with the payment information or the bank transfert receipt (in case you choose a payment by bank transfert).
Any questions, please call +33 (0)2 47 361 427
}
else
{
?>
}
?>
include("footer.php"); ?>