include("../include/c_session.php");
include("../include/c_mysql.php");
$id_service=$_GET[id_service];
$id_devis=$_GET[id_devis];
function format_colonne($debut,$sujet,$separateur){
$j=0;
$sortie="";
$tableau=explode("/",$sujet);
foreach($tableau as $value){
if(!empty($value)){
$sortie.=$value.$separateur;
$j++;
}
}
$sortie=substr($sortie,0,-2);
return $sortie;
}
function format_date($date){
$d=explode('-',$date);
$h=explode(' ',$d[2]);
$new_date=$h[0].'/'.$d[1].'/'.$d[0];
return $new_date;
}
if($id_service==10){
$service="Transport ";
$page="devis_transport_international.php";
$query="SELECT ident.statut_demandeur,db.* FROM identifiant_devis as ident,devis_transport as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$titre=$service." ".$d[pays_enlevement]." - ".$d[pays_livraison];
}
if($id_service==3){
$service="Accompagnement export";
$page="devis_conseil.php";
$query="SELECT ident.statut_demandeur,db.* FROM identifiant_devis as ident,devis_conseil as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$sujet=$d[t1]."/".$d[t2]."/".$d[t3]."/".$d[t4]."/".$d[t5]."/".$d[t6]."/".$d[t7]."/".$d[t8]."/";
$zone=$d[p1]."/".$d[p2]."/".$d[p3]."/".$d[p4]."/".$d[p5]."/".$d[p6]."/".$d[p7]."/".$d[p8]."/".$d[p9]."/";
$titre=$service.' '.format_colonne('',$sujet,' - ').' - '.$d[pays];
}
if($id_service==7){
$service="Légalisation de documents à l'export";
$page="devis_legalisation.php";
$query="SELECT ident.statut_demandeur,db.* FROM identifiant_devis as ident,devis_legalisation as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$document=$d[c1]."/".$d[c2]."/".$d[c3]."/".$d[c4]."/".$d[c5]."/".$d[c6]."/".$d[c7]."/".$d[c8]."/";
$titre=$service.' - '.$d[pays];
}
if($id_service==1){
$service="Assurance marchandises : Transport ";
$page="devis_assurance_marchandise.php";
$query="SELECT ident.statut_demandeur,db.* FROM identifiant_devis as ident,devis_assurance_marchandise as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$marchandise=$d[n1]."/".$d[n2]."/".$d[n3]."/".$d[n4]."/".$d[n5]."/".$d[n6]."/".$d[n7]."/".$d[n8]."/";
$transport=$d[t1]."/".$d[t2]."/".$d[t3]."/".$d[t4]."/".$d[t5]."/";
$zone=$d[g1]."/".$d[g2]."/".$d[g3]."/".$d[g4]."/".$d[g5]."/".$d[g6]."/".$d[g7]."/".$d[g8]."/".$d[g9]."/";
$titre=$service.format_colonne(' - ',$transport,' - ');
}
if($id_service==9){
$service="Traduction";
$page="devis_traduction.php";
$query="SELECT ident.statut_demandeur,ident.pays,db.* FROM identifiant_devis as ident,devis_traduction as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$titre=$service.' '.ucfirst($d[langue_source]).' '.ucfirst($d[langue_cible]);
}
if($id_service==6){
$service="Interprétariat";
$page="devis_interpretariat.php";
$query="SELECT ident.statut_demandeur,ident.pays,db.* FROM identifiant_devis as ident,devis_interpretariat as db WHERE db.id_devis='$id_devis' AND ident.id_user_devis=db.id_user_devis LIMIT 0,1";
$res=mysql_query($query);
$d=mysql_fetch_assoc($res);
$titre=$service.' '.ucfirst($d[langue_source]).' '.ucfirst($d[langue_cible]);
}
?>