1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144
|
<?php
$territoire=$_POST['territoire'];
if(isset($territoire)){
include("./../../fonctions.connect_2.php");
if($territoire=="commune"){
$commune=$_POST['comm'];
$req_com= pg_query($base,"SELECT * FROM commune_ceso WHERE insee='".$commune."'");
$rep_com = pg_fetch_assoc($req_com);
$epci=$rep_com['code_epci'];
$req_var= pg_query($base,"SELECT libgeo as nom, c10_men as men, c10_menpseul/c10_men*100 as menp, c10_mensfam/c10_men*100 as mens,
c10_menfam/c10_men*100 as menf, c10_mencoupsenf/c10_menfam*100 as mencs, c10_mencoupaenf/c10_menfam*100 as menca, c10_fam as fam,
c10_menfammono/c10_menfam*100 as menfm, p10_pmen/p10_men as mena, c10_ne24f0/c10_fam*100 as f0, c10_ne24f1/c10_fam*100 as f1, c10_ne24f2/c10_fam*100 as f2,
c10_ne24f3/c10_fam*100 as f3, c10_ne24f4p/c10_fam*100 as f4 FROM btx_cc_fam_2010 WHERE codgeo='".$commune."'");
$req_vor= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca,
sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(c10_fam) as fam, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_ne24f0)/sum(c10_fam)*100 as f0,
sum(c10_ne24f1)/sum(c10_fam)*100 as f1, sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3,
sum(c10_ne24f4p)/sum(c10_fam)*100 as f4 FROM btx_cc_fam_2010 WHERE codgeo IN (SELECT insee FROM commune_ceso WHERE code_epci='".$epci."')");
$req_vir= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca,
sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_fam) as fam, sum(c10_ne24f0)/sum(c10_fam)*100 as f0,
sum(c10_ne24f1)/sum(c10_fam)*100 as f1, sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3,
sum(c10_ne24f4p)/sum(c10_fam)*100 as f4 FROM btx_cc_fam_2010
WHERE codgeo IN (SELECT insee FROM commune_ceso WHERE code_epci!='17' GROUP BY insee)");
$req_ver= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca,
sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_fam) as fam, sum(c10_ne24f0)/sum(c10_fam)*100 as f0,
sum(c10_ne24f1)/sum(c10_fam)*100 as f1, sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3,
sum(c10_ne24f4p)/sum(c10_fam)*100 as f4 FROM btx_cc_fam_2010 WHERE dep='91'");
$rep_va = pg_fetch_assoc($req_var);
$rep_vo = pg_fetch_assoc($req_vor);
$rep_vi = pg_fetch_assoc($req_vir);
$rep_ve = pg_fetch_assoc($req_ver);
$tt1='"'.$rep_va['nom'].'"';
$p1=number_format($rep_va['mencs'],0,',',' '); $p2=number_format($rep_vo['mencs'],0,',',' ');
$p3=number_format($rep_vi['mencs'],0,',',' '); $p4=number_format($rep_ve['mencs'],0,',',' ');
$sf1=number_format($rep_va['menca'],0,',',' '); $sf2=number_format($rep_vo['menca'],0,',',' ');
$sf3=number_format($rep_vi['menca'],0,',',' '); $sf4=number_format($rep_ve['menca'],0,',',' ');
$af1=number_format($rep_va['menfm'],0,',',' '); $af2=number_format($rep_vo['menfm'],0,',',' ');
$af3=number_format($rep_vi['menfm'],0,',',' '); $af4=number_format($rep_ve['menfm'],0,',',' ');
$fa0=number_format($rep_va['f0'],0,',',' '); $fo0=number_format($rep_vo['f0'],0,',',' '); $fi2=number_format($rep_vi['f2'],0,',',' ');
$fi0=number_format($rep_vi['f0'],0,',',' '); $fe0=number_format($rep_ve['f0'],0,',',' '); $fa2=number_format($rep_va['f2'],0,',',' ');
$fa1=number_format($rep_va['f1'],0,',',' '); $fo1=number_format($rep_vo['f1'],0,',',' '); $fo2=number_format($rep_vo['f2'],0,',',' ');
$fi1=number_format($rep_vi['f1'],0,',',' '); $fe1=number_format($rep_ve['f1'],0,',',' '); $fe2=number_format($rep_ve['f2'],0,',',' ');
$fi3=number_format($rep_vi['f3'],0,',',' '); $fe3=number_format($rep_ve['f3'],0,',',' '); $fi4=number_format($rep_vi['f4'],0,',',' ');
$fa3=number_format($rep_va['f3'],0,',',' '); $fo3=number_format($rep_vo['f3'],0,',',' '); $fo4=number_format($rep_vo['f4'],0,',',' ');
$fe4=number_format($rep_ve['f4'],0,',',' '); $fa4=number_format($rep_va['f4'],0,',',' ');
echo "<br class='pdfsup'><br class='pdfsup'><h2>MÉNAGES : <b>".$rep_va['nom']."</b></h2><br class='pdfsup'><br class='pdfsup'><br>
<img src='./../../images/pix.jpg' class='pdfsup' onload='
grafmen(".$tt1.",".$p1.",".$p2.",".$p3.",".$p4.",".$sf1.",".$sf2.",".$sf3.",".$sf4.",".$af1.",".$af2.",".$af3.",".$af4.");
graffam(".$tt1.",".$fa0.",".$fa1.",".$fa2.",".$fa3.",".$fa4.",".$fe0.",".$fe1.",".$fe2.",".$fe3.",".$fe4.",
".$fi0.",".$fi1.",".$fi2.",".$fi3.",".$fi4.",".$fo0.",".$fo1.",".$fo2.",".$fo3.",".$fo4.");'>
<b>Ménages selon la structure familiale en 2010</b><br><br>
<center>
<table width='100%' id=table1>
<tr> <td class='border' width='40%'></td>
<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>".$rep_va['nom']."</h5></td>
<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>".$rep_com['epci']."</h5></td>
<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>CESO (7 EPCI)</h5></td>
<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>Essonne</h5></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FBBA00'><h4>Nombre de ménages en 2010</h4></td>
<td class='defaut'><h3><b>".number_format($rep_va['men'],0,',',' ')." </b></h3></td>
<td class='defaut'><h3><b>".number_format($rep_vo['men'],0,',',' ')." </b></h3></td>
<td class='defaut'><h3><b>".number_format($rep_vi['men'],0,',',' ')." </b></h3></td>
<td class='defaut'><h3><b>".number_format($rep_ve['men'],0,',',' ')." </b></h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages d'une personne</h4></td>
<td class='defaut'><h3>".number_format($rep_va['menp'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['menp'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['menp'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['menp'],1,',',' ')." % </h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages sans famille</h4></td>
<td class='defaut'><h3>".number_format($rep_va['mens'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['mens'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['mens'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['mens'],1,',',' ')." % </h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages avec famille(s) dont la famille principale est :</h4></td>
<td class='defaut'><h3>".number_format($rep_va['menf'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['menf'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['menf'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['menf'],1,',',' ')." % </h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>un couple sans enfant</h4></td>
<td class='defaut'><h3>".number_format($rep_va['mencs'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['mencs'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['mencs'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['mencs'],1,',',' ')." % </h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>un couple avec enfant(s)</h4></td>
<td class='defaut'><h3>".number_format($rep_va['menca'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['menca'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['menca'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['menca'],1,',',' ')." % </h3></td>
</tr>
<tr >
<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>une famille monoparentale</h4></td>
<td class='defaut'><h3>".number_format($rep_va['menfm'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vo['menfm'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_vi['menfm'],1,',',' ')." % </h3></td>
<td class='defaut'><h3>".number_format($rep_ve['menfm'],1,',',' ')." % </h3></td>
</tr>
</table>
<table width='100%' id=table1 style='padding-top: 10px;'>
<tr >
<td class='defaut' bgcolor='#FBBA00' width='40%'><h4>Taille moyenne des ménages</h4></td>
<td class='defaut' width='15%'><h3>".number_format($rep_va['mena'],1,',',' ')." </h3></td>
<td class='defaut' width='15%'><h3>".number_format($rep_vo['mena'],1,',',' ')." </h3></td>
<td class='defaut' width='15%'><h3>".number_format($rep_vi['mena'],1,',',' ')." </h3></td>
<td class='defaut' width='15%'><h3>".number_format($rep_ve['mena'],1,',',' ')." </h3></td>
</tr>
</table></center>
<h4>Source : Insee RP 2010</h4><br><br>
<center class='pdfsup'>
<div><b>Taille moyenne des ménages par communes du CESO en 2010</b><br><br>
<IFRAME src='carte_menage.html' width='805' height='550' scrolling='no' frameborder='0'></IFRAME></div><br>
</center>
?> |
Partager