";
$Vli_nbre_requete_bannette = mysql_num_rows($res_requete_bannette);
if($Vli_nbre_requete_bannette!=0)
{
foreach($val_requete_bannette as $key => $value)
{
if( !in_array($key, $Vlt_liste_nom_champs_requete) )
{
$Vls_menu_liste_champs_requete .= "
";
}
}
}
$Vls_menu_liste_champs_requete .= "
";
################################################################
### Recherche du nbre de champs déjà enregistrés
################################################################
$query_nbre_champs = "
SELECT
count(*)
FROM
gtb_tableau_champs gtc
WHERE
gtc.gtc_fkid_gtb_tableau = $Vli_id_tableau
";
$res_nbre_champs = mysql_query("$query_nbre_champs");
$val_nbre_champs = mysql_fetch_array($res_nbre_champs);
$Vli_nbre_champs = $val_nbre_champs[0];
################################################################
### Recherche de la taille du tableau
################################################################
$query_size_array = "
SELECT
SUM(gtc.gtc_taille_px)
FROM
gtb_tableau_champs gtc
WHERE
gtc.gtc_fkid_gtb_tableau = $Vli_id_tableau
";
$res_size_array = mysql_query("$query_size_array");
$val_size_array = mysql_fetch_array($res_size_array);
$Vli_size_array = $val_size_array[0];
if($Vls_multi_action=="Y")
{
$Vli_size_array += 33;
}
if($Vls_liste_bouton!="")
{
$Vlt_liste_bouton = explode("|", $Vls_liste_bouton);
$Vli_nbre_bouton = count($Vlt_liste_bouton);
$Vli_size_array += $Vli_nbre_bouton*26;
}
if($Vli_size_array=="")
{
$Vli_size_array=0;
}
################################################################
### Recherche de la taille du tableau imprimé
################################################################
$query_size_array_print = "
SELECT
SUM(gtc.gtc_taille_mm)
FROM
gtb_tableau_champs gtc
WHERE
gtc.gtc_fkid_gtb_tableau = $Vli_id_tableau
";
$res_size_array_print = mysql_query("$query_size_array_print");
$val_size_array_print = mysql_fetch_array($res_size_array_print);
$Vli_size_array_print = $val_size_array_print[0];
if($Vli_size_array_print=="")
{
$Vli_size_array_print=0;
}
################################################################
### Recherche de la liste des champs déjà enregistré
################################################################
$query_recherche_liste_champs = "
SELECT
gtc.gtc_id,
gtc.gtc_nom_champs_requete,
gtc.gtc_format,
gtc.gtc_alignement,
gtc.gtc_nom_entete,
gtc.gtc_position,
gtc.gtc_taille_px,
gtc.gtc_tri_dessus,
gtc.gtc_hidden,
gtc.gtc_limit_impression,
gtc.gtc_hidden_print,
gtc.gtc_taille_mm
FROM
gtb_tableau_champs gtc
WHERE
gtc.gtc_fkid_gtb_tableau = $Vli_id_tableau
ORDER BY
gtc.gtc_position
";
$res_recherche_liste_champs = mysql_query("$query_recherche_liste_champs");
$Vls_liste_champs_tableau = "";
$cpt = 1;
while($val_recherche_liste_champs = mysql_fetch_array($res_recherche_liste_champs))
{
$Vli_id_champs = $val_recherche_liste_champs[0];
$Vls_nom_champs_requete = strtolower($val_recherche_liste_champs[1]);
$Vls_format = $val_recherche_liste_champs[2];
$Vls_alignement = $val_recherche_liste_champs[3];
$Vls_nom_entete = $val_recherche_liste_champs[4];
$Vli_position = $val_recherche_liste_champs[5];
$Vli_taille_px = $val_recherche_liste_champs[6];
$Vls_tri_dessus = $val_recherche_liste_champs[7];
$Vls_hidden = $val_recherche_liste_champs[8];
$Vls_limit_impression = $val_recherche_liste_champs[9];
$Vls_hidden_print = $val_recherche_liste_champs[10];
$Vli_taille_mm = $val_recherche_liste_champs[11];
################################################################
### On remplace le $Vls_alignement parla bonne valeur
################################################################
switch($Vls_alignement)
{
case "left":
$Vls_alignement = _GTB_LEFT;
$Vls_selected_left = "selected";
$Vls_selected_center = "";
$Vls_selected_right = "";
break;
case "center":
$Vls_alignement = _GTB_CENTER;
$Vls_selected_left = "";
$Vls_selected_center = "selected";
$Vls_selected_right = "";
break;
case "right":
$Vls_alignement = _GTB_RIGHT;
$Vls_selected_left = "";
$Vls_selected_center = "";
$Vls_selected_right = "selected";
break;
}
################################################################
### Savoir si tri dessus et hidden sont cochés
################################################################
/*
if($Vls_tri_dessus=="Y")
{
$Vls_checked_tri_dessus = "checked";
}
else
{
$Vls_checked_tri_dessus = "";
}*/
if($Vls_hidden=="Y")
{
$Vls_checked_hidden = "checked";
}
else
{
$Vls_checked_hidden = "";
}
if($Vls_hidden_print=="Y")
{
$Vls_checked_hidden_print = "checked";
}
else
{
$Vls_checked_hidden_print = "";
}
################################################################
$reste = $cpt % 2;
if($reste!=0)
{$Vls_color_td = "color_impaire";}
else
{$Vls_color_td = "color_paire";}
$cpt++;
$Vls_liste_champs_tableau .= "
";
if($Vli_nbre_champs!=1 AND $Vls_table_base=="N")
{
if($Vli_position!=1)
{
$Vls_liste_champs_tableau .="
![\""._GTB_POSITION_UP."\"](\"modules/gtb/images/up.png\" "\\"\"._GTB_POSITION_UP.\"\\"")
|
";
}
else
{
$Vls_liste_champs_tableau .="
![\""._GTB_POSITION_DOWN."\"](\"modules/gtb/images/down.png\" "\\"\"._GTB_POSITION_DOWN.\"\\"")
|
";
}
/*if($Vli_position!=1)
{
$Vls_liste_champs_tableau .="
";
}
else
{
$Vls_liste_champs_tableau .="
|
";
}*/
/*$Vls_liste_champs_tableau .="
$Vli_position
|
";*/
if($Vli_position!=$Vli_nbre_champs AND $Vli_position!=1)
{
$Vls_liste_champs_tableau .="
|
|
";
}
}
else
{
$Vls_liste_champs_tableau .=" | ";
}
$Vls_liste_champs_tableau .="
|
$Vls_nom_champs_requete |
|
|
|
|
|
|
|
|
|
";
if($Vls_table_base=="N")
{
$Vls_liste_champs_tableau .="
![\""._GTB_FIELDS_DELETE."\"](\"modules/gtb/images/picto_delete.gif\" "\\"\"._GTB_FIELDS_DELETE.\"\\"")
|
";
}
$Vls_liste_champs_tableau .="
";
}
$Vls_affichage = "
"._GTB_LIST_FIELDS." :
";
########################################################
if($Vli_size_array>792)
{
$Vls_class_info = "info_size_array";
}
else
{
$Vls_class_info = "current_size_array";
}
$Vls_affichage .= "
"._GTB_LIMIT_DYNAMIC_ARRAY." : $Vli_size_array px / 792 px max
";
########################################################
if($Vli_size_array_print>190)
{
$Vls_class_info = "info_size_array";
}
else
{
$Vls_class_info = "current_size_array";
}
$Vls_affichage .= "
"._GTB_LIMIT_DYNAMIC_ARRAY_PRINT." : $Vli_size_array_print mm / 190 mm max
";
########################################################
$Vls_affichage .= "
"._GTB_INFO_FORMAT_COLUMN."
"._GTB_EXEMPLE_FORMAT_COLUMN."
"._GTB_INFO_TRI_COLUMN."
"._GTB_EXEMPLE_TRI_COLUMN."
"._GTB_INFO_PRINT_COLUMN."
";
################################################################
return $Vls_affichage;
}
?>
![\""._GTB_FIELDS_ADD."\"](\"modules/gtb/images/picto_add.gif\" "\\"\"._GTB_FIELDS_ADD.\"\\"")