$chaine\n");
}
function panel($result, $id, $depart, $fin){
//print "phase1 $depart $fin";
//$sql ="SELECT code_ag, text_ag, image_ag FROM art_group WHERE code_ag > '$depart' AND code_ag <'$fin'";
//print " 
";
$qte=mysql_num_rows($result) ;
print ("\n");
for ($i=0; $i<$qte; $i++){
$fichier = mysql_fetch_row($result, MYSQL_NUM);
//print"| $fichier[1] | \n";
print ("![$fichier[1]]($Base_R/1computer/images/$fichier[2]) |
\n");
}
print ("
\n");
}
function affichelink($result){
$qte=mysql_num_rows($result);
$tabl=array (
"Go To Link",
$qte ." Comment Informations Remarques",
"Level",);
titre($tabl);
while ($row = mysql_fetch_row($result,MYSQL_NUM)) {
if($row[3] == ""){
print "$row[0] | ";//titre
}
else {
$RowColor = chgcolor();
print "";
print " | ";//lien
print "$row[1] | \n";//libelle
for ($index=0; $index<$row[3]; $index++)
print " ";//score
print " |
";
print "";
}
}
print "";
}
function montre($result){
$cache = microtime();
$perf = explode (" ", $cache);
$qte=mysql_num_rows($result) ;
$tabl=array (
"Code",
$depart." sur ".$qte ." Article (click pour Information)",
"Quantite",
"Date",
"Code Client");
print ("\n");
print ("\n");
titre($tabl);
while ($row = mysql_fetch_row($result,MYSQL_NUM)) {
$RowColor = chgcolor();
print "";
print "$row[0] | ";
print "$row[1] | ";
print "$row[2] | ";
print "$row[3] | ";
print "$row[4] | ";
//print " | ";
print " ";
print "";
}
print (" |
\n");
$microsecondes = $perf[0];
print "View in->$microsecondes ms \n
";
}
function affiche($result, $depart, $arive){
$cache = microtime();
$perf = explode (" ", $cache);
$qte=mysql_num_rows($result) ;
$tabl=array (
"No",
$depart." sur ".$qte ." Articles (click pour Information)",
"Fr CH",
"Tax %",);
print ("\n");
print ("\n");
titre($tabl);
for($index=$depart; $index<$arive; $index++){
mysql_data_seek($result, $index);
$fichier = mysql_fetch_row($result,MYSQL_NUM);
$RowColor = chgcolor();
print "";
print "$fichier[0] | \n";//article
print " | \n";//code
print "$fichier[2] | \n";//article
print "$fichier[3] | \n";//tax
//print " |
\n";
print ("
\n");
$microsecondes = $perf[0];
print "View in->$microsecondes ms \n
";
}
function affiche_admin($result, $depart, $arive){
$qte=mysql_num_rows($result) ;
$tabl=array (
"Code",
$depart." sur ".$qte ." Articles (click pour Information)",
"P. Achat",
"P.Vente",
"Four",
"Date",);
titre($tabl);
for($index=$depart; $index<$arive; $index++){
mysql_data_seek($result, $index);
$fichier = mysql_fetch_row($result,MYSQL_NUM);
$RowColor = chgcolor();
print "";
print "$fichier[0] | ";
print " | ";
print "$fichier[13] | "; // pa
print "$fichier[14] | "; //pv
print "$fichier[1] | "; //four
print "$fichier[17] | ";//date
}
print"";
}
function titre($tableau){
print "";
print "";
$i=0;
while($i$tableau[$i]";
$i++;
}
print "
";
}
function chgcolor(){
static $couleur;
if($couleur == "#ffbb00")
{
$couleur = "#ffdd99";
}
else
{
$couleur = "#ffbb00";
}
return($couleur);
}
function connect() {
global $MySQL_Host, $MySQL_User, $MySQL_Passw;
if (! $linkid=mysql_connect("$MySQL_Host","$MySQL_User","$MySQL_Passw")) {
echo "Impossible de se connecter à ",$MySQL_Host,"
";
exit;
}
return $linkid;
}
function createdb($db, $lkid) {
if (! $res=mysql_create_db($db, $lkid)) {
print mysql_error($lkid);
exit;
}
return $res;
}
function send_sql($db, $sql) {
if (! $res=mysql_db_query($db, $sql)) {
print "Erreur: ";
print mysql_error();
exit;
}
return $res;
}
function tab_out($result) {
$qte=mysql_num_fields($result);
print "";
print "";
for ($i=0;$i<$qte;$i++){
print "| ";
print mysql_field_name($result,$i);
print " | ";
}
print "
";
print "";
while ($row = mysql_fetch_row($result,MYSQL_ASSOC)) {
foreach ($row as $elem) {
print "$elem | ";
}
print "
";
}
print "
";
} // tab_out
function tab_out1($result,$Identif ) {
global $w;$Art=$w[Art];$NumArt=$w[NumArt];$Qte=$w[Number];
$qte=mysql_num_fields($result);
print "";
print "";
for ($i=0;$i<$qte;$i++){
print "| ";
print mysql_field_name($result,$i);
print " | ";
}
print "";print "+";print " | ";
print "";print "-";print " | ";
print "
";
print "";
while ($row = mysql_fetch_row($result,MYSQL_ASSOC)) {
foreach ($row as $elem) {
print "$elem | ";
}
print "";
print "";
print " | ";
print "";
print "";
print " | ";
print "
";
}
print "
";
} // tab_out1
//function tab_out2 ($result,$Identifiant) {
function tab_out2 ($result) {
//global $Base_R;
$qte=mysql_num_rows($result);
$ln=10;
print "";
print "";
print "| No. Client: | ";
print "$qte Nom (clik for Info) | ";
print "
";
print "";
$i=0 ;
while ($row = mysql_fetch_row($result,MYSQL_NUM)) {
$RowColor = chgcolor();
print "
";
$i++;
print "$row[0] | ";
print " | ";
//print " $i | ";
print "
";
}
print "
";
} // tab_out2
//function tab_out3 ($result,$Identifiant) {
function tab_out3 ($result) {
global $Base_R;
$qte= mysql_num_rows($result);
print "";
print "";
print "| Code: | ";
print "$qte Fournisseurs | ";
print "
";
print "";
while ($row = mysql_fetch_row($result,MYSQL_NUM)) {
// print "
";
print "$row[0] | ";
print " | ";
print "
";
print "";
}
print "
";
} // tab_out3
// liste du panier
//function tab_out6 (result, client) {
function tab_out6 ($result, $client) {
global $Base_R;
$qte= mysql_num_rows($result);
print "";
print "";
print "| Qte | \n";
print "$qte Articles | \n";
print "Total | \n";
print (" | \n");
print "
";
print "";
while ($row = mysql_fetch_row($result,MYSQL_NUM)) {
$tot=$row[2]*$row[3];
$RowColor = chgcolor();
print "
\n";
print "$row[3] | \n";//quantite
//print " | \n";//code
//print "$row[1] | ";//article
print " | \n";//article
//print "$row[2] | \n";//prix Unite
$tot=number_format($tot,'2') ;
print "$tot | \n";
print "\n";
print " | \n";
print "\n";
print "
";
print "";
$total=$total+($row[2]*$row[3]) ;
}
$total=number_format($total+20,'2');
print "
\n";
print "\n";
print "Tax Transport Fr 20.00 | Go order |
|---|
\n";
print "TTC SWISS CH Fr.$total | \n";
print (" | \n");
print ("
|---|
\n");
print ("
\n");
} // tab_out6