function draw_index($url, $datatable = "", $idxchamps = "", $post_char = "", $title = "Index", $opt = 'std')
{
global $app;
if ($datatable != "") {
$var = explode(";", $datatable);
if (isset($var[1]) && $var[1] != "") {
$condition = $var[1];
} else {
$condition = "";
}
if ($condition != "") {
$condition = " WHERE " . $condition;
}
$db = new Tdb();
$Tindexexist = array();
$db->Execute("SELECT DISTINCT(" . $idxchamps . ") as 'indexfor' FROM " . $var[0] . " {$condition}");
while ($db->Get_line()) {
//print "<b>INDEX : ".$db->Get_field('indexfor')."<br></b>";
$Tindexexist[$db->Get_field('indexfor')] = true;
}
$db->close();
}
$nb_col = 0;
$old = $this->direct;
$r = '';
$this->direct = false;
$r .= "<br>";
$r .= $this->beg_cell();
$r .= "<br>";
$r .= $this->beg_tbl('form');
$r .= $this->beg_line();
if ($post_char == "all") {
$r .= $this->cell("<span class=\"lien_inactif\"><font color=red>Tous</font></span>");
} else {
$r .= $this->cell($this->link('Tous', $url . '&charIndex=all', 'lien'));
}
$nb_col++;
if ($post_char == "0") {
$r .= $this->cell("<span class=\"lien_inactif\"><font color=red>#</font></span>");
} else {
if ($datatable == "" || isset($Tindexexist['!']) || isset($Tindexexist['0'])) {
$r .= $this->cell($this->link('#', $url . '&charIndex=other', 'lien'));
} else {
$r .= $this->cell("<span class=\"lien_inactif\">#</span>");
}
}
$nb_col++;
$l = ord("A");
for ($i = $l; $i < $l + 26; $i++) {
if ($post_char == chr($i)) {
$r .= $this->cell("<span class=\"lien_inactif\"><font color=red>" . chr($i) . "</font></span>");
} else {
if ($datatable == "" || isset($Tindexexist[chr($i)])) {
$r .= $this->cell($this->link(chr($i), $url . '&charIndex=' . chr($i), 'lien'));
} else {
$r .= $this->cell("<span class=\"lien_inactif\">" . chr($i) . "</span>");
}
}
$nb_col++;
}
$r .= $this->end_line();
$r .= $this->end_tbl();
$r .= $this->end_cell();
if ($title) {
$r = $this->end_line() . $r;
$r = $this->Cell($title, -1, '', $nb_col) . $r;
$r = $this->beg_line('formheader0') . $r;
}
$r = $this->beg_tbl('formcadre') . $r;
$r .= $this->end_tbl();
$r .= "<br>";
$this->direct = $old;
if ($this->direct) {
echo $r;
} else {
return $r;
}
}
function get_tab_by_sql(&$db, $sql)
{
$Tab = array();
if (is_string($db) && $db == 'auto') {
$db = new Tdb();
}
$db->Execute($sql);
$THeader = array_keys($db->Get_lineHeader());
while ($db->Get_line()) {
$row = array();
foreach ($THeader as $key) {
$row[$key] = $db->Get_field($key);
}
$Tab[] = $row;
}
return $Tab;
}
