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; }