<?php
// $Id: rescanton_pdf.inc,v 1.1 2008-11-24 11:13:42 fraynaud Exp $

/**
 * rescanton_pdf.inc
 * Ce fichier permet d'affecter les variables pour la génération
 * des sous-états nécessaires à l'état résultat canton
 * Paramètres : 
 * $sousetattab => canton, total, cantontotal mode du sous-état
 * $ville = Nom de la collectivité
 * $can = Libellé du canton
 * $nbcandidat_first = n° ordre 1er candidat à afficher
 * $nbcandidat_last = n° ordre dernier candidat à afficher
 * $largeurtab = Largeur du tableau en mm
 * $nbcandpage = Nombre de candidats par page
 * $affichernom = Afficher le nom ou le n° d'ordre du candidat
 * $key = Code du canton
 * $idx = Code de l'élection
 * $candidat = tableau des candidats
 */

/**
 * Titre de l'état
 */
if ($sousetattab == "canton")
{
    $sousetat['titre'] = $ville ." ". $can;
    $sousetat['titrehauteur'] = "4";
}
elseif ($sousetattab == "total")
{
    $sousetat['titre'] = "Total général ".$ville ;
    $sousetat['titrehauteur'] = "4";
}
elseif ($sousetattab == "totalcanton")
{
    $sousetat['titre'] = "";
    $sousetat['titrehauteur'] = "0";
}
$sousetat['titrefont'] = "helvetica";
$sousetat['titreattribut'] = "B";
$sousetat['titretaille'] = "8";
$sousetat['titrebordure'] = "0";
$sousetat['titrealign'] = "L";
$sousetat['titrefond'] = "0";
$sousetat['titrefondcouleur'] = array("243","246","246");
$sousetat['titretextecouleur'] = array("0","0","0");

/**
 * 
 */
$sousetat['intervalle_debut'] = 0;
$sousetat['intervalle_fin'] = 0;

/**
 * Entete
 */
if ($sousetattab == "canton" || $sousetattab == "total")
{
    $sousetat['entete_flag'] = "1";
}
else if ($sousetattab == "totalcanton")
{
    $sousetat['entete_flag'] = "0";
}
$sousetat['entete_orientation'] = array("0","0","45","45","0","45","45","0","45","0");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['entete_orientation'], "0");
        array_push ($sousetat['entete_orientation'], "0");
}
$sousetat['entete_fond'] = "1";
$sousetat['entete_hauteur'] = "6";
$sousetat['entetecolone_bordure'] = array("TBL","TBL","TBL","TBL","TB","TBL","TBL","TB","TBL","TBR");
for ($i = $nbcandidat_first; $i <= ($nbcandidat_last); $i++)
{
    if ($i == $nbcandidat_last)
    {
        array_push ($sousetat['entetecolone_bordure'], "TBL");
        array_push ($sousetat['entetecolone_bordure'], "TBR");
    }
    else
    {
        array_push ($sousetat['entetecolone_bordure'], "TBL");
        array_push ($sousetat['entetecolone_bordure'], "TB");
    }
}
$sousetat['entetecolone_align'] = array("C","C","L","L","C","L","L","C","L","C");
for ($i = $nbcandidat_first; $i <= ($nbcandidat_last); $i++)
{
        array_push ($sousetat['entetecolone_align'], "C");
        array_push ($sousetat['entetecolone_align'], "C");
}
$sousetat['entete_fondcouleur'] = array("180","180","180");
$sousetat['entete_textecouleur'] = array("0","0","0");

/**
 * Tableau
 */
$sousetat['tableau_largeur'] = $largeurtab;
$sousetat['tableau_bordure'] = "0";
$sousetat['tableau_fontaille'] = "6";
$sousetat['bordure_couleur'] = array("0","0","0");
if ($sousetattab == "canton" || $sousetattab == "total")
{
    $sousetat['se_fond1'] = array("243","243","246");
}
else if ($sousetattab == "totalcanton")
{
    $sousetat['se_fond1'] = array("160","180","200");
}
$sousetat['se_fond2'] = array("255","255","255");

/**
 * Cellules
 */
$sousetat['cellule_fond'] = "1";
$sousetat['cellule_hauteur'] = "3";
$sousetat['cellule_largeur'] = array ("5","40","10","10","11","10","10","11","10","11");
$largeur_restante = $sousetat['tableau_largeur'] - array_sum ($sousetat['cellule_largeur']);
if ($nbcandidat >= $nbcandpage)
{
    $vote = floor (($largeur_restante / $nbcandpage) / 2);
    $taux = ceil (($largeur_restante / $nbcandpage) / 2);
}
else
{
    $vote = floor (($largeur_restante / $nbcandidat) / 2);
    $taux = ceil (($largeur_restante / $nbcandidat) / 2);
}
for ($i = $nbcandidat_first; $i <= ($nbcandidat_last); $i++)
{
    array_push ($sousetat['cellule_largeur'], $vote);
    array_push ($sousetat['cellule_largeur'], $taux);
}
$sousetat['cellule_bordure_un']=array("TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBLR");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
    if ($i == $nbcandidat_last)
    {
        array_push ($sousetat['cellule_bordure_un'], "TBL");
        array_push ($sousetat['cellule_bordure_un'], "TBLR");
    }
    else
    {
        array_push ($sousetat['cellule_bordure_un'], "TBL");
        array_push ($sousetat['cellule_bordure_un'], "TBL");
    }
}
$sousetat['cellule_bordure']=array("TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBLR");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
    if ($i == $nbcandidat_last)
    {
        array_push ($sousetat['cellule_bordure'], "TBL");
        array_push ($sousetat['cellule_bordure'], "TBLR");
    }
    else
    {
        array_push ($sousetat['cellule_bordure'], "TBL");
        array_push ($sousetat['cellule_bordure'], "TBL");
    }
}
$sousetat['cellule_align']=array("C","L","R","R","R","R","R","R","R","R");
for ($i = $nbcandidat_first; $i <= ($nbcandidat_last); $i++)
{
        array_push ($sousetat['cellule_align'], "R");
        array_push ($sousetat['cellule_align'], "R");
}
$sousetat['cellule_numerique']=array("999","999","0","0","2","0", "0","2","0", "2");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_numerique'], "0");
        array_push ($sousetat['cellule_numerique'], "2");
}


/**
 * Inutile mais obligatoire pour les erreurs easyphp
 */
$sousetat['cellule_fond_total']="1";
$sousetat['cellule_fontaille_total']="10";
$sousetat['cellule_hauteur_total']="15";
$sousetat['cellule_fondcouleur_total']=array("196","213","215");

$sousetat['cellule_bordure_total']=array("TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_bordure_total'], "TBL");
        array_push ($sousetat['cellule_bordure_total'], "TBL");
}
$sousetat['cellule_align_total']=array("R","R","R","R","C","L","R","R","C","L");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_align_total'], "R");
        array_push ($sousetat['cellule_align_total'], "R");
}

$sousetat['cellule_fond_moyenne']="1";
$sousetat['cellule_fontaille_moyenne']="10";
$sousetat['cellule_hauteur_moyenne']="15";
$sousetat['cellule_fondcouleur_moyenne']=array("196","213","215");

$sousetat['cellule_bordure_moyenne']=array("TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_bordure_moyenne'], "TBL");
        array_push ($sousetat['cellule_bordure_moyenne'], "TBL");
}
$sousetat['cellule_align_moyenne']=array("R","R","R","R","C","L","R","R","C","L");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
       array_push ($sousetat['cellule_align_moyenne'], "R");
       array_push ($sousetat['cellule_align_moyenne'], "R");
}

$sousetat['cellule_fond_nbr']="1";
$sousetat['cellule_fontaille_nbr']="10";
$sousetat['cellule_hauteur_nbr']="15";
$sousetat['cellule_fondcouleur_nbr']=array("196","213","215");

$sousetat['cellule_bordure_nbr']=array("TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL","TBL", "TBL");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_bordure_nbr'], "TBL");
        array_push ($sousetat['cellule_bordure_nbr'], "TBL");
}
$sousetat['cellule_align_nbr']=array("R","R","R","R","C","L","R","R","C","L");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_align_nbr'], "R");
        array_push ($sousetat['cellule_align_nbr'], "R");
}

$sousetat['cellule_total']=array("0","0","0","0","0","0","0","0","0","0");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_total'], "0");
        array_push ($sousetat['cellule_total'], "0");
}
$sousetat['cellule_moyenne']=array("0","0","0","0","0","0","0","0","0","0");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_moyenne'], "0");
        array_push ($sousetat['cellule_moyenne'], "0");
}
        
$sousetat['cellule_compteur']=array("0","0","0","0","0","0","0","0","0","0");
for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
{
        array_push ($sousetat['cellule_compteur'], "0");
        array_push ($sousetat['cellule_compteur'], "0");
}

/**
 * Requête
 */
if ($sousetattab == "canton")
{
    $sousetat['sql'] = "select bureau.bureau as \"N°\", bureau.bureau_libelle as \"Bureaux\", inscrit as \"Ins\", votant as \"V/Em\", round((votant*100/inscrit),2) as \"%V\", (exprime+nul) as \"V/Ur\", nul as \"Nul\", round((nul*100/(exprime+nul)),2) as \"%N\", exprime as \"Exp\", round((exprime*100/(exprime+nul)),2) as \"%E\", ";
    if ($affichernom == 1)
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " candidat".$i." as '".$candidat [$i]."', round(((candidat".$i."*100)/exprime),2) as '%".$i."'";
            }
            else
            {
                $sousetat['sql'] .= " candidat".$i." as '".$candidat [$i]."', round(((candidat".$i."*100)/exprime),2) as '%".$i."',";
            }
        }
    }
    else
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " candidat".$i." as '".$i."', round((((candidat".$i.")*100)/exprime),2) as \"%".$i."\"";
            }
            else
            {
                $sousetat['sql'] .= " candidat".$i." as '".$i."', round((((candidat".$i.")*100)/exprime),2) as \"%".$i."\",";
            }
        }
    }
    $sousetat['sql'] .= "from bureau inner join resultat on bureau.bureau = resultat.bureau where election = '".$idx."' and canton = '".$key."' order by bureau.bureau";
}
elseif ($sousetattab == "total")
{
    $sousetat['sql'] = "select \"T\" as \"N°\", \"TOTAL\" as \"Bureaux\", sum(inscrit) as \"Ins\", sum(votant) as \"V/Em\", round((sum(votant)*100/sum(inscrit)),2) as \"%V\", sum(exprime+nul) as \"V/Ur\", sum(nul) as \"Nul\", round((sum(nul)*100/sum(exprime+nul)),2) as \"%N\", sum(exprime) as \"Exp\", round((sum(exprime)*100/sum(exprime+nul)),2) as \"%E\", ";
    if ($affichernom == 1)
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$candidat [$i]."', round(((sum(candidat".$i.")*100)/sum(exprime)),2) as '%".$i."'";
            }
            else
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$candidat [$i]."', round(((sum(candidat".$i.")*100)/sum(exprime)),2) as '%".$i."',";
            }
        }
    }
    else
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$i."', round((((sum(candidat".$i."))*100)/sum(exprime)),2) as '%".$i."'";
            }
            else
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$i."', round((((sum(candidat".$i."))*100)/sum(exprime)),2) as '%".$i."',";
            }
        }
    }
    $sousetat['sql'] .= "from bureau inner join resultat on bureau.bureau = resultat.bureau where election = '".$idx."'";
}
elseif ($sousetattab == "totalcanton")
{
    $sousetat['sql'] = "select \"".$key."\" as \"N°\", \"TOTAL DU CANTON\" as \"Bureaux\", sum(inscrit) as \"Ins\", sum(votant) as \"V/Em\", round((sum(votant)*100/sum(inscrit)),2) as \"%V\", sum(exprime+nul) as \"V/Ur\", sum(nul) as \"Nul\", round((sum(nul)*100/sum(exprime+nul)),2) as \"%N\", sum(exprime) as \"Exp\", round((sum(exprime)*100/sum(exprime+nul)),2) as \"%E\", ";
    if ($affichernom == 1)
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$candidat [$i]."', round(((sum(candidat".$i.")*100)/sum(exprime)),2) as '%".$i."'";
            }
            else
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$candidat [$i]."', round(((sum(candidat".$i.")*100)/sum(exprime)),2) as '%".$i."',";
            }
        }
    }
    else
    {
        for ($i = $nbcandidat_first; $i <= $nbcandidat_last; $i++)
        {
            if ($i == $nbcandidat_last)
            {
                $sousetat['sql'] .= " sum(candidat".$i.") as '".$i."', round((((sum(candidat".$i."))*100)/sum(exprime)),2) as '%".$i."'";
            }
            else
            {
            $sousetat['sql'] .= " sum(candidat".$i.") as '".$i."', round((((sum(candidat".$i."))*100)/sum(exprime)),2) as '%".$i."',";
            }
        }
    }
    $sousetat['sql'] .= "from bureau inner join resultat on bureau.bureau = resultat.bureau where election = '".$idx."' and canton = '".$key."'";
}
?>