X

Create New Item

File Folder

X

Search Results

rec

File "frame_creation.php"

Full path: /home/meharicl/www/rec/frame_creation.php
File size: 12.42 KiB (12716 bytes)
MIME-type: text/html
Charset: utf-8

Download   Open   Edit   Advanced Edit   Back 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>
<title>Recensement</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="generator" content="HAPedit 3.1">
</head>
<body bgcolor="#FFFFFF">
<?
include('choix_xx.inc');
//nouvelle fiche???
if($_GET['id']==0){fait_new();$id=get_last();}
else{$id=$_GET['id'];}
echo("id=".$id."<br>");

$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
//mehari_an
$sql="UPDATE `rec_mehari_tmp` SET `mehari_an` = '".$_GET['mehari_an']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_type
$sql="UPDATE `rec_mehari_tmp` SET `mehari_type` = '".$_GET['mehari_type']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_numero_serie
$sql="UPDATE `rec_mehari_tmp` SET `mehari_numero_serie` = '".$_GET['mehari_numero_serie']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_enac
$sql="UPDATE `rec_mehari_tmp` SET `mehari_enac` = '".$_GET['mehari_enac']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_immatriculation
$sql="UPDATE `rec_mehari_tmp` SET `mehari_immatriculation` = '".$_GET['mehari_immatriculation']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_date_circulation
$sql="UPDATE `rec_mehari_tmp` SET `mehari_date_circulation` = '".$_GET['mehari_date_circulation']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//echo($sql."<br>");
//modele_id
$sql="UPDATE `rec_mehari_tmp` SET `modele_id` = '".$_GET['modele_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_couleur
$sql="UPDATE `rec_mehari_tmp` SET `mehari_couleur` = '".$_GET['mehari_couleur']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_place
$sql="UPDATE `rec_mehari_tmp` SET `mehari_place` = '".$_GET['mehari_place']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//recensement_note
//echo($_GET['recensement_note']);
$_GET['recensement_note']=str_replace("'","\'",$_GET['recensement_note']);
//$_GET['recensement_note']=str_replace('"','',$_GET['recensement_note']);
//echo($_GET['recensement_note']);
$sql="UPDATE `rec_mehari_tmp` SET `recensement_note` = '".$_GET['recensement_note']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//post forum
$sql="UPDATE `rec_mehari_tmp` SET `mehari_post_forum` = '".$_GET['mehari_post_forum']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);

//recensement_qui
$sql="UPDATE `rec_mehari_tmp` SET `recensement_qui` = '".$_GET['recensement_qui']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//recensement_email
$sql="UPDATE `rec_mehari_tmp` SET `recensement_email` = '".$_GET['recensement_email']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_pseudo_forum
$sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_forum` = '".$_GET['mehari_pseudo_forum']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//departement_id
$sql="UPDATE `rec_mehari_tmp` SET `departement_id` = '".$_GET['departement_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//mehari_numero_serie_id
$sql="UPDATE `rec_mehari_tmp` SET `mehari_numero_serie_id` = '".$_GET['mehari_numero_serie_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//update
//UPDATE `rec_mehari_tmp` SET `last_update` = '2020-10-03 14:27:51' WHERE `rec_mehari_tmp`.`id` = 2930;
$sql="UPDATE `rec_mehari_tmp` SET `last_update` = '".date("Y-m-d")."' WHERE `rec_mehari_tmp`.`id` = ".$id;
$result=$link->query($sql);
//Pseudo OK
if($_GET['mehari_pseudo_forum'])
{
  $sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_ok` = ".is_pseudo($_GET['mehari_pseudo_forum'])." WHERE `rec_mehari_tmp`.`id` = ".$id;
}
else
{
  $sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_ok` = ".'0'." WHERE `rec_mehari_tmp`.`id` = ".$id;
}
  $result=$link->query($sql);
$sql="UPDATE `rec_mehari_tmp` SET `mehari_doublon` = ".$_GET['mehari_doublon']." WHERE `rec_mehari_tmp`.`id` = ".$id;$link->query($sql);
$sql="UPDATE `rec_mehari_tmp` SET `mehari_erreur` = ".$_GET['mehari_erreur']." WHERE `rec_mehari_tmp`.`id` = ".$id;$link->query($sql);

fait_mail($id);
//header('Location:http://www.mehariclubdefrance.com/rec/saisie/saisie.php');

function fait_mail($id)
{
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql="SELECT * FROM `rec_mehari_tmp` WHERE `id` = ".$id;
$result_tmp=$link->query($sql);
while($resultat_tmp=$result_tmp->fetch_assoc())
    {
    $ref=$resultat_tmp['id']; echo('id='.$ref."<br>");
    $mail_to=$resultat_tmp['recensement_email'];echo('mail='.$mail_to."<br>");
    $pseudo=$resultat_tmp['mehari_pseudo_forum'];echo('pseudo='.$pseudo."<br>");
    $n_serie=back_mehari_an($resultat_tmp['mehari_an'])."-".$resultat_tmp['mehari_type'].'-'.$resultat_tmp['mehari_numero_serie'];echo('n_serie='.$n_serie."<br>");
    $immat=$resultat_tmp['mehari_immatriculation'];echo('immat='.$immat."<br>");
    $date_immat=fait_date($resultat_tmp['mehari_date_circulation']);echo('date_immat='.$date_immat."<br>");
    $departement=back_departement($resultat_tmp['departement_id']);echo('departement='.$departement."<br>");
    $couleur=back_couleur($resultat_tmp['mehari_couleur']);echo('couleur='.$couleur."<br>");
    $n_place=back_place($resultat_tmp['mehari_place']);echo('n_place='.$n_place."<br>");
    $modele=back_modele($resultat_tmp['modele_id']);echo('n_place='.$modele."<br>");
    $enac=$resultat_tmp['mehari_enac'];echo('enac='.$enac."<br>");
    $proprietaire=$resultat_tmp['recensement_qui'];echo('proprietaire='.$proprietaire."<br>");
    $note=$resultat_tmp['recensement_note'];echo('note='.$note."<br>");
    $query="SELECT * FROM `rec_numero_serie` WHERE `numero_serie_id` = ".$resultat_tmp['mehari_numero_serie_id'];



    $Texte='
    <html>
    <head>
    <title>Recensement M&eacute;hari Club De France</title>
    </head>
    <body> ';
    $Texte.='<p align="center"><img src="http://www.mehariclubdefrance.com/fait3-3/site_logo.gif" alt=""   height="100" border="0" /></p>';
    $Texte.='Bonjour '.$pseudo.'<br>'  ;
    $Texte.='Le recensement de votre M&eacute;hari &agrave; bien &eacute;t&eacute; r&eacute;ceptionn&eacute; sous la r&eacute;f&eacute;rence <b>Ref='.$id.'</b><br>';
    $Texte.='<table border="1" bordercolor="#FFFFFF"width="100%" ><tr><th  colspan="6" bgcolor="#FF8000">Informations transmises</th></tr>';
    $Texte.='<tr><td align="center">Num&eacute;ro s&eacute;rie<br>'.$n_serie."</td>";
    $Texte.='<td align="center">ENAC si 69<br>'.$enac."</td>";
    $Texte.='<td align="center">Immatriculation<br>'.$immat."</td>";
    $Texte.='<td align="center">Date Immatriculation<br>'.$date_immat."</td>";
    $Texte.='<td align="center">Mod&egrave;le<br>'.$modele."</td>";
    //$Texte.="<td>Ann&eacute;e Mod&egrave;le<br>"."--"."</td>";
    $Texte.='<td align="center">Couleur<br>'.$couleur."</td></tr>";
    $Texte.='<td align="center">Nb Places<br>'.$n_place."</td>";
    $Texte.='<td align="center"> Nom Recenseur<br>'.$proprietaire."</td>";
    $Texte.='<td align="center" colspan=2> Mail Recenseur<br>'.$mail_to."</td>";
    $Texte.='<td align="center"> Pseudo Recenseur <br>'.$pseudo."</td>";
    $Texte.='<td align="center">Localisation Recenseur  <br>'.$departement."</td></tr>";
    $Texte.='<tr><tr><td colspan="6" align="center"> Commentaire** <br>'.$note.'</td></tr>';
    $Texte.="</table>";
    $Texte.="Merci de votre collaboration, en cas de probl&egrave;me concernant votre fiche l'&eacute;quipe de recensement vous contacteras en MP";
    $Texte.='<p align="center"> L\'&eacute;quipe du recensement du MCDF</p>';
    $Texte.='</body></html>';


    $headers  = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
    $headers .= 'From: recensement@mehariclubdefrance.com'  ."\r\n";
    $headers .= "CC: webmaster@mehariclubdefrance.com". "\r\n";


    mail($mail_to,"Recensement MCDF",$Texte, $headers);



    }

}




function get_last()
{
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql="SELECT * FROM `rec_mehari_tmp` ORDER BY `rec_mehari_tmp`.`id` DESC LIMIT 1";
$result=$link->query($sql);
$num_id=$result->fetch_assoc();
return($num_id['id']);
}
function fait_new()
{
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql="SELECT * FROM `rec_mehari_tmp` ORDER BY `rec_mehari_tmp`.`mehari_id` DESC";
$result=$link->query($sql);
$l_id=$result->fetch_assoc();
$mehari_id=$l_id['mehari_id']+1;
$sql="INSERT INTO `rec_mehari_tmp` (`id`, `mehari_id`, `saisie`, `mehari_an`, `mehari_type`, `mehari_numero_serie`, `mehari_date_circulation`, `mehari_modele`, `departement_id`, `recensement_adherent`, `recensement_qui`, `recensement_email`, `mehari_enac`, `mehari_immatriculation`, `recensement_note`, `last_update`, `mehari_couleur`, `mehari_place`, `modele_id`, `mehari_pseudo_forum`, `mehari_pseudo_ok`, `recensement_actif`, `mehari_post_forum`, `mehari_numero_serie_id`) VALUES (NULL, '".$mehari_id."', CURRENT_DATE(), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CURRENT_DATE(), NULL, NULL, '0', NULL, '0', '1', NULL, '0');";
$result=$link->query($sql);
}


//****

/*
function fait_Dept()
{

global $Nom_Dept,$Nb_Dept;
$Nom_Dept="categories: [";
$Nb_Dept="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT departement_id, COUNT(*) FROM `rec_mehari_tmp` GROUP BY `departement_id` ORDER BY `COUNT(*)` DESC';
$result=$link->query($sql);

while($dept=$result->fetch_assoc())
  {
  //en France ?
  if(france($dept['departement_id'])==1)
      {
      $nom=nom_dept($dept['departement_id']);
      $nom=str_replace("'","\'",$nom);
      $Nom_Dept=$Nom_Dept."'".$nom."',";
      $Nb_Dept=$Nb_Dept.$dept['COUNT(*)'].",";
      }
      }
  $Nom_Dept=$Nom_Dept."],";
  $Nb_Dept=$Nb_Dept."]";
  $Nom_Dept=str_replace(",]","]",$Nom_Dept);
  $Nb_Dept=str_replace(",]","]",$Nb_Dept);
}
*/
//****
/*
function fait_Pays()
{
global $Nom_Pays,$Nb_Pays;
$Nom_Pays="categories: [";
$Nb_Pays="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
 $sql = 'SELECT rec_pays.pays_nom, Count( rec_mehari_tmp.mehari_id ) AS CompteDemehari_id FROM rec_mehari_tmp INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari_tmp.departement_id = rec_departements.departement_id GROUP BY rec_pays.pays_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 30';
  $result=$link->query($sql);
  while($pays=$result->fetch_assoc())
{
  $Nom_Pays=$Nom_Pays."'".$pays['pays_nom']."',";
  $Nb_Pays=$Nb_Pays.$pays['CompteDemehari_id'].",";
}
  $Nom_Pays=$Nom_Pays."],";
  $Nb_Pays=$Nb_Pays."]";
  $Nom_Pays=str_replace(",]","]",$Nom_Pays);
  $Nb_Pays=str_replace(",]","]",$Nb_Pays);
}
//*****
*/
/*
function fait_Type()
{
global $Nom_Type,$Nb_Type;
$Nom_Type="categories: [";
$Nb_Type="data: [";
$link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale");
$sql = 'SELECT rec_modele.modele_desc, Count( rec_mehari_tmp.mehari_id ) AS CompteDemehari_id FROM rec_mehari_tmp INNER JOIN rec_modele ON rec_mehari_tmp.modele_id = rec_modele.modele_id GROUP BY rec_modele.modele_id, rec_modele.modele_desc ORDER BY `CompteDemehari_id` DESC';
$result=$link->query($sql);

  while($type=$result->fetch_assoc())
  {
  $Nom_Type=$Nom_Type."'".$type['modele_desc']."',";
  $Nb_Type=$Nb_Type.$type['CompteDemehari_id'].",";
  };

  $Nom_Type=$Nom_Type."],";
  $Nb_Type=$Nb_Type."]";
  $Nom_Type=str_replace(",]","]",$Nom_Type);
  $Nb_Type=str_replace(",]","]",$Nb_Type);
}
/*
function is_pseudo($pseudo)
{
  $pseudo=strtolower($pseudo);
  $pseudo=utf8_decode($pseudo);
  $link = mysqli_connect("mehariclclobale.mysql.db", "mehariclclobale", "Pva131254", "mehariclclobale");
  $sql="SELECT COUNT(*) FROM `phpbb_3users` WHERE `username_clean` LIKE '".$pseudo."'";
  $result=$link->query($sql);
  $liste=$result->fetch_assoc();
  return($liste['COUNT(*)']);
}
*/

?>
</body>

</html>