".htmlentities($msg["nettoyage_reindex_sug"], ENT_QUOTES, $charset)."
";
$query = mysql_query("SELECT id_suggestion, titre, editeur, auteur, code, commentaires FROM suggestions LIMIT ".$start.", ".$lot." ");
if(mysql_num_rows($query)) {
// définition de l'état de la jauge
$state = floor($start / ($count / $jauge_size));
$state .= "px";
// mise à jour de l'affichage de la jauge
print "";
print " |
";
// calcul pourcentage avancement
$percent = floor(($start/$count)*100);
// affichage du % d'avancement et de l'état
print "$percent%
";
while($row = mysql_fetch_object($query)) {
// index acte
$req_update = "UPDATE suggestions ";
$req_update.= "SET index_suggestion = ' ".strip_empty_words($row->titre)." ".strip_empty_words($row->editeur)." ".strip_empty_words($row->auteur)." ".$row->code." ".strip_empty_words($row->commentaires)." ' ";
$req_update.= "WHERE id_suggestion = ".$row->id_suggestion." ";
$update = mysql_query($req_update);
}
mysql_free_result($query);
$next = $start + $lot;
print "
";
} else {
// mise à jour de l'affichage de la jauge
print "| ";
print " |
";
print "100%
";
$v_state .= "
".htmlentities($msg["nettoyage_reindex_sug"], ENT_QUOTES, $charset)." $count ".htmlentities($msg["nettoyage_res_reindex_sug"], ENT_QUOTES, $charset);
print "
";
}
break ;
case 'ENTITES' :
if (!$count) {
$entites = mysql_query("SELECT count(1) FROM entites", $dbh);
$count = mysql_result($entites, 0, 0);
}
print "
".htmlentities($msg["nettoyage_reindex_ent"], ENT_QUOTES, $charset)."
";
$query = mysql_query("SELECT id_entite, raison_sociale FROM entites LIMIT ".$start.", ".$lot." ");
if(mysql_num_rows($query)) {
// définition de l'état de la jauge
$state = floor($start / ($count / $jauge_size));
$state .= "px";
// mise à jour de l'affichage de la jauge
print "| ";
print " |
";
// calcul pourcentage avancement
$percent = floor(($start/$count)*100);
// affichage du % d'avancement et de l'état
print "$percent%
";
while($row = mysql_fetch_object($query)) {
// index acte
$req_update = "UPDATE entites ";
$req_update.= "SET index_entite = ' ".strip_empty_words($row->raison_sociale)." ' ";
$req_update.= "WHERE id_entite = ".$row->id_entite." ";
$update = mysql_query($req_update);
}
mysql_free_result($query);
$next = $start + $lot;
print "
";
} else {
// mise à jour de l'affichage de la jauge
print "| ";
print " |
";
print "100%
";
$v_state .= "
".htmlentities($msg["nettoyage_reindex_ent"], ENT_QUOTES, $charset)." $count ".htmlentities($msg["nettoyage_res_reindex_ent"], ENT_QUOTES, $charset);
print "
";
}
break ;
case 'ACTES':
if (!$count) {
$actes = mysql_query("SELECT count(1) FROM actes", $dbh);
$count = mysql_result($actes, 0, 0);
}
print "
".htmlentities($msg["nettoyage_reindex_act"], ENT_QUOTES, $charset)."
";
$query = mysql_query("SELECT actes.id_acte, actes.numero, entites.raison_sociale, actes.commentaires, actes.reference FROM actes, entites where num_fournisseur=id_entite LIMIT ".$start.", ".$lot." ");
if(mysql_num_rows($query)) {
// définition de l'état de la jauge
$state = floor($start / ($count / $jauge_size));
$state .= "px";
// mise à jour de l'affichage de la jauge
print "| ";
print " |
";
// calcul pourcentage avancement
$percent = floor(($start/$count)*100);
// affichage du % d'avancement et de l'état
print "$percent%
";
while($row = mysql_fetch_object($query)) {
// index acte
$req_update = "UPDATE actes ";
$req_update.= "SET index_acte = ' ".$row->numero." ".strip_empty_words($row->raison_sociale)." ".strip_empty_words($row->commentaires)." ".strip_empty_words($row->reference)." ' ";
$req_update.= "WHERE id_acte = ".$row->id_acte." ";
$update = mysql_query($req_update);
//index lignes_actes
$query_2 = mysql_query("SELECT id_ligne, code, libelle FROM lignes_actes where num_acte = '".$row->id_acte."' ");
if (mysql_num_rows($query_2)){
while ($row_2 = mysql_fetch_object($query_2)) {
$req_update_2 = "UPDATE lignes_actes ";
$req_update_2.= "SET index_ligne = ' ".strip_empty_words($row_2->libelle)." ' ";
$req_update_2.= "WHERE id_ligne = ".$row_2->id_ligne." ";
$update_2 = mysql_query($req_update_2);
}
mysql_free_result($query_2);
}
}
mysql_free_result($query);
$next = $start + $lot;
print "
";
} else {
// mise à jour de l'affichage de la jauge
print "| ";
print " |
";
print "100%
";
$v_state .= "
".htmlentities($msg["nettoyage_reindex_act"], ENT_QUOTES, $charset)." $count ".htmlentities($msg["nettoyage_res_reindex_act"], ENT_QUOTES, $charset);
print "
";
}
break ;
case 'FINI':
$spec = $spec - INDEX_ACQUISITIONS;
$v_state .= "
".htmlentities($msg["nettoyage_reindex_acq_fini"],ENT_QUOTES,$charset);
print "
";
break ;
}