<?php
@mysql_connect($hote, $user, $pass);
?>
<SCRIPT LANGUAGE="JavaScript">
function DeplacerItemDeVers(de, vers) {
var zlAv = "zlItem"+de+"[]";
var zlAp = "zlItem"+vers+"[]";
if (document.frmDemo2.elements[zlAv].options.selectedIndex >= 0) {
while (document.frmDemo2.elements[zlAv].options.selectedIndex >= 0) {
ind = document.frmDemo2.elements[zlAv].options.selectedIndex;
texte = document.frmDemo2.elements[zlAv].options[ind].text;
valeur = document.frmDemo2.elements[zlAv].options[ind].value;
document.frmDemo2.elements[zlAv].options[ind] = null;
var user = new Option(texte, valeur);
lg = document.frmDemo2.elements[zlAp].options.length;
document.frmDemo2.elements[zlAp].options[lg] = user;
}
} else {
alert("Aucun Item sélectionné !");
}
return(false);
}
function SelectionnerItems(form) {
zl = "zlItemIN[]";
lg = document.frmDemo2.elements[zl].options.length;
for (cpt = 0; cpt < lg; cpt++) {
document.frmDemo2.elements[zl].options[cpt].selected = true;
}
zl = "zlItemOUT[]";
lg = document.frmDemo2.elements[zl].options.length;
for (cpt = 0; cpt < lg; cpt++) {
document.frmDemo2.elements[zl].options[cpt].selected = true;
}
return( true );
}
</SCRIPT>
<?php
echo "<FORM METHOD=POST NAME='frmDemo2'>";
$sql = "SELECT demo_item.code, item, demo_rubrique.code, rubrique ";
$sql .= "FROM demo_item, demo_rubrique ";
$sql .= "WHERE demo_item.code_rub = demo_rubrique.code ";
$sql .= "ORDER BY rubrique, item";
$resultat = mysql_db_query($Base, $sql);
$listeIn = "<SELECT NAME=zlItemIN[] SIZE='10' MULTIPLE>";
$listeOut = "<SELECT NAME=zlItemOUT[] SIZE='10' MULTIPLE>";
while ($enr = mysql_fetch_array($resultat)) {
// condition quelconque pour mettre dans l'une ou l'autre des listes
$liste = ($enr[2] == 1 ? "listeOut" : "listeIn");
$$liste .= "<OPTION VALUE='".$enr[0]."'>".$enr[3]." - ".$enr[1]."</OPTION>\n";
}
$listeIn .= "</SELECT> ";
$listeOut .= "</SELECT> ";
echo "<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><TR>";
echo "<TD ALIGN='center'> <B>IN</B> <BR> ".$listeIn." </TD>";
echo "<TD ALIGN='center'> ";
echo "<INPUT TYPE='submit' VALUE='<<' ";
echo "onClick='return DeplacerItemDeVers(\"OUT\", \"IN\")'> <BR><BR> ";
echo "<INPUT TYPE='submit' VALUE='>>' ";
echo "onClick='return DeplacerItemDeVers(\"IN\", \"OUT\")'>";
echo " </TD>";
echo "<TD ALIGN='center'> <B>OUT</B> <BR> ".$listeOut." </TD>";
echo "<TD VALIGN='center'> <INPUT TYPE='submit' VALUE='Valider' ";
echo "OnClick='return SelectionnerItems()'> </TD>";
echo "</TR></TABLE>\n";
echo "</FORM>";
// ----------------------------------------------------------------------------
// Résultats des sélections
// ----------------------------------------------------------------------------
echo "Sélection :\n";
if (isset($zlItemIN)) {
echo "<BR>IN:";
for ($cpt = 0; $cpt < sizeof($zlItemIN); $cpt++) {
$sql = "SELECT code, item FROM demo_item WHERE code='".$zlItemIN[$cpt]."'";
$resultat = @mysql_db_query($Base, $sql);
$enr = @mysql_fetch_array($resultat);
echo " $enr[1] ($enr[0])";
}
}
if (isset($zlItemOUT)) {
echo "<BR>OUT:";
for ($cpt = 0; $cpt < sizeof($zlItemOUT); $cpt++) {
$sql = "SELECT code, item FROM demo_item WHERE code='".$zlItemOUT[$cpt]."'";
$resultat = @mysql_db_query($Base, $sql);
$enr = @mysql_fetch_array($resultat);
echo " $enr[1] ($enr[0])";
}
}
?>
|
|