<?php
// titre 
$sousetat["titre"][0]="Station(s) au £aujourdhui";
$sousetat['titrehauteur'][0]="8";
$sousetat['titrefont'][0]="arial";
$sousetat['titreattribut'][0]="B";
$sousetat['titretaille'][0]="11";
$sousetat['titrebordure'][0]="1";
$sousetat['titrealign'][0]="L";
$sousetat['titrefond'][0]=1;// 0- > FOND transparent 1 -> fond
$sousetat['titrefondcouleur'][0]=array("243","246","246");
$sousetat['titretextecouleur'][0]=array("0","0","0");
//intervalle avant et après tableau
$sousetat['intervalle_debut'][0]=5;
$sousetat['intervalle_fin'][0]=5;
// entete
$sousetat['entete_flag'][0]=1;//entete colonne : 0 -> non affichage , 1 -> affichage
$sousetat['entete_fond'][0]=1;// 0- > FOND transparent 1 -> fond
$sousetat['entete_hauteur'][0]=8;//hauteur ligne entete colonne
$sousetat['entetecolone_bordure'][0]=array("","LTB","LTB","LTB","LTB","LTB","LTBR","LTBR","LTBR","LTBR");// bordure entete colonne
$sousetat['entetecolone_align'][0]=array("","C","C","C","C","C","C","C","C","C"); // ALIGNEMENT entete colonne
$sousetat['entete_fondcouleur'][0]=array("248","204","160");// couleur fond  RVB
$sousetat['entete_textecouleur'][0]=array("0","0","0");// couleur fond  RVB
//variable tableau
$sousetat['tableau_largeur'][0]= 227;// -> widthtableau
$sousetat['tableau_bordure'][0]=1;// bordure 1ere  et derniere ligne  dutableau par page->0 ou 1
$sousetat['bordure_couleur'][0]=array("0","0","0");// couleur bordure RVB
$sousetat['se_fond1'][0]=array("243","246","246");// couleur fond
$sousetat['se_fond2'][0]=array("255","255","255");// couleur fond
$sousetat['tableau_fontaille'][0]= 9;
//variable cellule
// largeur de chaque cellule
$sousetat['cellule_largeur'][0]=array("","15","18","25","40","30","25","17","23","82");// cellule multiligne (1) ou compressée sur largeur (0)  ajout parc
$sousetat['cellule_multiligne'][0]=array("0","0","0","1","1","1","0","0","1","1");
// pourcentage de hauteur utilisée pour 1 ligne d'une cellule multiligne
$sousetat['cellule_hautmulti'][0]=1/2;
// HAUTEUR de chaque cellule 
$sousetat['cellule_hauteur'][0]=8;
$sousetat['cellule_bordure_un'][0]=array("","TLB","LTB","LTB","LTB","LTB","LTBR","LTBR","LTBR","LTBR"); //bordure cellule 1ère LIGNE TABLEAU
$sousetat['cellule_bordure'][0]=array("","LTB","LTB","LTB","LTB","LTB","LTBR","LTBR","LTBR","LTBR"); //bordure cellule
$sousetat['cellule_align'][0]=array("","L","L","L","L","L","L","L","L","L");// ALIGNEMENT de chaque cellule
$sousetat['cellule_fond'][0]=1;// 0- > FOND transparent 1 -> fond
// total
$sousetat['cellule_fondcouleur_total'][0]=array("250","242","234");
$sousetat['cellule_hauteur_total'][0]=10; //hauteurcellule
$sousetat['cellule_bordure_total'][0]=array("","LTB","TB","TB","TBLR","TBL","TBR","TBR","TBR","TBR"); //bordure cellule
$sousetat['cellule_align_total'][0]=array("","L","C","C","R","C","C","C","C","C");// ALIGNEMENT de chaque cellule
$sousetat['cellule_fond_total'][0]=1;// 0- > FOND transparent 1 -> fond
$sousetat['cellule_fontaille_total'][0]= 9;
//moyenne
$sousetat['cellule_fondcouleur_moyenne'][0]=array("250","232","214");
$sousetat['cellule_hauteur_moyenne'][0]=5; //hauteur cellule
$sousetat['cellule_bordure_moyenne'][0]=array("BTL","BT","BTLR"); //bordure cellule
$sousetat['cellule_align_moyenne'][0]=array("L","L","C");// ALIGNEMENT de chaque cellule
$sousetat['cellule_fond_moyenne'][0]=1;// 0- > FOND transparent 1 -> fond
$sousetat['cellule_fontaille_moyenne'][0]= 9;
//nbr enregistrement
$sousetat['cellule_fondcouleur_nbr'][0]=array("249","218","188");
$sousetat['cellule_hauteur_nbr'][0]=8; //hauteur cellule
$sousetat['cellule_bordure_nbr'][0]=array("","LTB","TB","TB","TBLR","TBL","TBR","TBR","TBR","TBR"); //bordure cellule
$sousetat['cellule_align_nbr'][0]=array("","L","C","R","R","C","C","C","C","R");// ALIGNEMENT de chaque cellule
$sousetat['cellule_fond_nbr'][0]=1;// 0- > FOND transparent 1 -> fond
$sousetat['cellule_fontaille_nbr'][0]= 9;
// type cellule
$sousetat['cellule_numerique'][0]=array("","999","999","999","999","999","999","999","999","999");// ch(amps)n(umerique)d(ecimale)0 à nn / 999->non, 0 à nn->nbr decimale(s) $chnd0
// affichage ligne total,moyenne, nbr
$sousetat['cellule_total'][0]=array("","0","0","0","0","0","0","0","0","0");// calcul et affichage totaux 1->Totaux 0->non
$sousetat['cellule_moyenne'][0]=array("","0","0","0","0","0","0","0","0","0");// calcul et affichage moyenne 1->Totaux 0->non
$sousetat['cellule_compteur'][0]=array("","0","0","1","0","0","0","0","0","0");// calcul et affichage nombre 1->Totaux 0->non
// SQL
$sousetat["table"][0]="station as s left join personnel on s.idutilisateur=personnel.idutilisateur left join service on s.idservice=service.idservice left join batiment on s.idbatiment=batiment.idbatiment left join tcpip on s.idstation=tcpip.idstation left join modeleelement as m0 on s.idsysteme=m0.idmodele";
$sousetat["champsaffiches"][0]="s.idstation as id,s.numero,s.numserie,concat(nom,' ',prenom) as nom,libservice as service,libbatiment as batiment,nomstation,adresseip,m0.libmodele as systeme,'subsql' as complement"; //s.datescan
$sousetat["selection"][0]="(isnull(tcpip.ipmaitre) or tcpip.ipmaitre='v')"; // and s.maj=0"; //temporaire com6
$sousetat["pretri"][0]="";
$sousetat["trialpha"][0]="nom,libbatiment,s.numero";
$sousetat["trinum"][0]="s.numero";
$sousetat['subsql'][1][0]="SELECT mp.libmodele as processeur FROM station as s left join element as ep on s.idstation=ep.idstation inner join modeleelement as mp on ep.idmodele=mp.idmodele WHERE mp.nature='processeur' and s.idstation=£ids";
$sousetat['subsql'][2][0]="SELECT sum(mm.taille) as memoire FROM station as s left join element as em on s.idstation=em.idstation inner join modeleelement as mm on em.idmodele=mm.idmodele WHERE mm.nature='memoire' and s.idstation=£ids GROUP BY em.idstation";
$sousetat['subsql'][3][0]="SELECT sum(mh.taille) as disque FROM station as s left join element as eh on s.idstation=eh.idstation inner join modeleelement as mh on eh.idmodele=mh.idmodele WHERE mh.nature='disquedur' and s.idstation=£ids GROUP BY eh.idstation";
$sousetat['subsql'][4][0]="SELECT me.libmodele as ecran FROM station as s left join element as ee on s.idstation=ee.idstation inner join modeleelement as me on ee.idmodele=me.idmodele WHERE me.nature='ecran' and s.idstation=£ids";
?>