PHP xtable::search_keyon方法代码示例

<?php require_once(MODDIR.'control.php'); require_once(MODDIR.'xtable/xtable.php');
$fmod='sirkulasi_peminjaman_form_buku_list';
$xtable=new xtable($fmod,'item','',3);
$xtable->search_keyon('kunci=>pus_buku.barkode:EQ|pus_katalog.judul:LIKE-0,1');
$xtable->search_box_pos('l');
$xtable->pageorder="pus_buku.barkode";
$xtable->use_select();
$xtable->select_noopt=true;
$xtable->select_cekfunc="sirkulasi_peminjaman_form_buku_list_cek(param)";

$lok=gpost('ff2_lokasi');
$lokasi=lokasi_r($lok);

$PSBar = new PSBar_2(100);
$PSBar->begin();
	if(count($lokasi)>0){
		$PSBar->selection('Lokasi',iSelect('ff2_lokasi',$lokasi,$lok,$PSBar->selws,"peminjaman_buku_get_cari(1)"));
	} else {
		$PSBar->end();
		hiddenval('pslokasi',$lok);
		lokasi_warn(0,'float:left');
		$PSBar->pass=false;
	}
$PSBar->end();
if($PSBar->pass){

$xtable->search_box('barkode atau judul item');
			  
$db=new xdb("pus_buku");
$db->field("pus_buku:replid","pus_buku:barkode","pus_katalog:judul");
$db->join("katalog","pus_katalog");

<?php

appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$fmod = 'transaksi';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
//$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1,2');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.ct";
$tanggal1 = gpost('tanggal1', date("Y-m") . "-1");
$tgl = explode("-", date("Y-m-d"));
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tanggal2 = gpost('tanggal2', date("Y-m") . "-" . $dim);
$ct_jurnaldetil = gpost('ct_jurnaldetil', 1);
$ct_umum = gpost('ct_umum', 1);
$ct_pemasukan = gpost('ct_pemasukan', 1);
$ct_pengeluaran = gpost('ct_pengeluaran', 1);
$ct_siswa = gpost('ct_siswa', 1);
$ct_calonsiswa = gpost('ct_calonsiswa', 1);
$ct_barang = gpost('ct_barang', 1);
$w = "";
$sel = 0;
if ($ct_umum != 0) {
    if ($w != "") {
        $w .= " OR ";
    }
    $w .= "keu_transaksi.jenis='" . JT_UMUM . "'";
    $sel++;
}
if ($ct_pemasukan != 0) {

<?php require_once(MODDIR.'xtable/xtable.php'); require_once(MODDIR.'control.php');
$SOUF=stocktake_unfinished();
$fmod='katalog_buku_daftar';
$xtable=new xtable($fmod,'koleksi');
if($SOUF==0)$xtable->use_select();
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-1');
$xtable->pageorder="pus_buku.barkode";
if($SOUF!=0)$xtable->noopt=true;

$kat=gpost('katalog',0);
$lok=gpost('lokasi');
$lokasi=lokasi_r($lokasi,1);

$db=new xdb("pus_buku");
$db->field("pus_buku.*","pus_lokasi:nama as nlokasi","pus_tingkatbuku:nama as ntingkat");
$db->join("lokasi","pus_lokasi");
$db->join("tingkatbuku","pus_tingkatbuku");
$db->where("pus_buku.katalog='$kat'");
$db->where_and($xtable->search_sql_get());
if($lok!=0) $db->where_and("pus_buku.lokasi='$lok'");

$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_buku.idbuku','pus_buku.callnumber','pus_buku.sumber','pus_buku.harga','pus_buku.tanggal','pus_buku.status','nlokasi','ntingkat'));

// Page Selection Bar
$PSBar = new PSBar_2(100);
$PSBar->begin();
	if(count($lokasi)>0){
		$PSBar->selection('Lokasi',iSelect('lokasi',$lokasi,$lok,$PSBar->selws,$fmod."_get()"));
	} else {

<?php

appmod_use('aka/tahunajaran', 'aka/guru', 'aka/presensi');
$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'presensiguru';
$xtable = new xtable($fmod, 'presensi');
$xtable->noopt = true;
$xtable->search_keyon('nama=>hrd_pegawai.nama:LIKE-0');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
    $tajar = gpost('tahunajaran');
    $tahunajaran = tahunajaran_r($tajar, $dept);
    $tanggal = gpost('tanggal');
    if ($tanggal == '') {
        $tanggal = date("Y-m-d");
    }
    $tgl = explode("-", $tanggal);
    $dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
    $tgl_f = $tgl[0] . "-" . $tgl[1] . "-1";
    $tgl_c = date("Y-m-d");
    $tgl_l = $tgl[0] . "-" . $tgl[1] . "-" . $dim;
    $tgl_cm = $tgl[0] . "-" . $tgl[1] . "-";
    $t0 = date('Y-m-d', strtotime('- 1 day', strtotime($tanggal)));
    $t1 = date('Y-m-d', strtotime('+ 1 day', strtotime($tanggal)));
    // Page Selection Bar
    $PSBar = new PSBar_2();
    $PSBar->begin();
    $PSBar->selection_departemen($fmod, $dept);
    if (count($tahunajaran) > 0) {

<?php

$SOUF = stocktake_unfinished();
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
    $cid = 0;
}
$keyw = gpost('keyword');
$keyn = gpost('keyon');
$fmod = 'pengembalian';
$xtable = new xtable($fmod, 'pengembalian');
$xtable->noopt = true;
$xtable->pageorder = "pus_peminjaman.tanggal3 DESC";
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'judul=>pus_katalog.judul:LIKE-1', 'memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ-2', 'nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE-2');
if ($opt == 'af' || $opt == 'uf') {
    require_once VWDIR . 'pengembalian_form.php';
} else {
    hiddenval('member_id', 0);
    hiddenval('member_tipe', 0);
    $tgl1 = date("Y-m-") . "1";
    $tgl2 = date("Y-m-") . cal_days_in_month(CAL_GREGORIAN, intval(date("m")), intval(date("Y")));
    $tanggal1 = gpost('tanggal1', $tgl1);
    $tanggal2 = gpost('tanggal2', $tgl2);
    $PSBar = new PSBar_2(100, 450);
    $PSBar->begin();
    $s = '<button style="float:left;margin:0px 4px 0px 4px" class="btn" title="Tampilkan" onclick="' . $fmod . '_get()"><div class="bi_srcb">&nbsp;</div></button>';
    $PSBar->selection('Periode', inputTanggal('tanggal1', $tanggal1) . ' <div style="float:left;margin:4px 8px 0px 8px">sampai</div> ' . inputTanggal('tanggal2', $tanggal2) . $s);
    $PSBar->end();
    // Query
    $db = new xdb("pus_peminjaman");

<?php

$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'pegawai';
if ($opt == 'af' || $opt == 'uf') {
    require_once VWDIR . 'pegawai_form.php';
} else {
    $xtable = new xtable($fmod, 'pegawai');
    $xtable->search_keyon('nama=>hrd_pegawai.nama:LIKE-0', 'nip=>hrd_pegawai.nip:EQ-1');
    $xtable->pageorder = "hrd_pegawai.nama";
    // Query
    $db = new xdb("hrd_pegawai");
    $db->field("hrd_pegawai:*", "hrd_m_status:status as nstatus");
    $db->join("status", "hrd_m_status");
    $db->where($xtable->search_sql_get());
    $t = $db->query();
    $xtable->ndata_db($t);
    $t = $db->query($xtable->pageorder_sql('hrd_pegawai.nama', 'hrd_pegawai.nip', 'hrd_pegawai.status'));
    $xtable->btnbar_f('add', 'print', 'srcbox');
    if ($xtable->ndata > 0) {
        // Table head
        $xtable->head('@Nama', '@!NIP', 'Status');
        while ($r = mysql_fetch_array($t)) {
            $xtable->row_begin($r['replid']);
            $xtable->td($r['nama'], 200);
            $xtable->td($r['nip'], 100);
            $xtable->td($r['nstatus']);
            //$xtable->td(nl2br($r['keterangan']));
            $xtable->opt_ud($r['replid']);
            $xtable->row_end();

hiddenval('katalog_view', $katalog_view);
hiddenval('opf', 'kat');
if ($opt == 'af' || $opt == 'uf') {
    require_once VWDIR . 'katalog_form.php';
} else {
    /*
       SELECT katalog.*, 
              COUNT(post_id) AS post_count
         FROM katalog 
    LEFT JOIN blogger_posts ON katalog.blogger_id = blogger_posts.blogger_id
        WHERE katalog.AUX = 3
     GROUP BY katalog.blogger_id
     ORDER BY post_count
    */
    $xtable = new xtable($fmod, 'katalog');
    $xtable->search_keyon('judul=>pus_katalog.judul-0', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-1', 'pengarang(nama pengarang)=>pus_pengarang.nama:LIKE-2', 'penerbit(nama penerbit)=>pus_penerbit.nama:LIKE-3');
    $xtable->pageorder = "pus_katalog.judul";
    $xtable->rpp = $katalog_view == 'list' ? $xtable->rpp : 21;
    // Query
    $db = new xdb("pus_katalog");
    $db->field("pus_katalog:replid,judul,klasifikasi,pengarang,penerbit,kota,tahunterbit,halaman,isbn,deskripsi,callnumber", "pus_klasifikasi:kode as n1,kode", "pus_pengarang:nama as n2,nama2 as nkutip", "pus_penerbit:nama as n3", "COUNT(pus_buku.replid) as buku_count");
    $db->join("replid", "pus_buku", "katalog");
    $db->join("klasifikasi", "pus_klasifikasi");
    $db->join("pengarang", "pus_pengarang");
    $db->join("penerbit", "pus_penerbit");
    $db->where($xtable->search_sql_get());
    $db->group("pus_katalog.replid");
    $t = $db->query();
    $xtable->ndata = mysql_num_rows($t);
    $t = $db->query($xtable->pageorder_sql('judul', 'n1', 'n2', 'n3', 'callnumber', 'buku_count'));
    $SOUF = stocktake_unfinished();

$fform->reg['btnlabel_a_y']='Tutup';
//$fform->reg['btnlabel_a_n']='Tutup';
$fform->dimension(650);
$fform->ptop=30;
$fform->yes_act='close_fform()';
$fform->head('Daftar Pengecekan Item');
echo '<tr><td><div id="data_member" style="height:350px;overflow:auto">';

$tbl=stocktake_ctable();

$fmod='stocktake_daftar';
$xtable=new xtable($fmod,'item');
$xtable->noopt=true;
$xtable->pageorder="cek,ts";
$xtable->search_box_pos('l');
$xtable->search_keyon('barkode=>'.$tbl.'.barkode:EQ-0');

// Query
//$sql="SELECT * FROM ".$tbl." ORDER BY cek,ts";
$db=new xdb($tbl);
$db->field($tbl.":*","josh.pus_katalog:judul");
$db->join("buku","josh.pus_buku");
$db->joinother("josh.pus_buku","katalog","josh.pus_katalog");
$db->where($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql($tbl.".barkode","josh.pus_katalog.judul",$tbl.".cek,@".$tbl.".barkode",$tbl.".ts"));

$ncek_y=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'"));
$ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl));

        //$s.='<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'\')"><b>&nbsp;</b></button>';
        $s .= '<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'H\')"><b>H</b></button>';
        $s .= '&nbsp;<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'S\')"><b>S</b></button>';
        $s .= '&nbsp;<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'I\')"><b>I</b></button>';
        $s .= '&nbsp;<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'A\')"><b>A</b></button>';
        $s .= '</div>';
        $xtable->select_opt = '<div class="sfont" style="width:164px;float:left;margin-top:4px;margin-left:0px;margin-right:5px">set presensi siswa yang dipilih:</div>' . $s;
        $xtable->foot();
        echo '</div>';
    } else {
        $xtable->nodata();
    }
} else {
    // Per siswa
    $xtable = new xtable($fmod, 'siswa', '', 2);
    $xtable->search_keyon('kunci=>aka_siswa.nama:LIKE-0');
    $xtable->search_box_pos('l');
    $xtable->pageorder = "aka_siswa.nis";
    $xtable->noopt = true;
    $xtable->use_select();
    echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto">';
    $xtable->head('Tgl{C}', 'Presensi{C}', 'Keterangan');
    for ($i = 1; $i <= $dim; $i++) {
        $xtable->row_begin($i);
        //$ctgl=$tgl_cm.$i;
        $r = array('replid' => $i);
        $xtable->td($i, 40, 'c');
        $t1 = mysql_query("SELECT absen,keterangan FROM aka_absen WHERE siswa='" . $cid . "' AND tanggal='" . $tgl_cm . $i . "'");
        if (mysql_num_rows($t1) > 0) {
            $r1 = mysql_fetch_array($t1);
            $absen = $r1['absen'];

if (count($kelas) > 0) {
    $PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()"));
} else {
    $PSBar->end();
    hiddenval('kelas', $kls);
    kelas_warn(1);
    exit;
}
$PSBar->end();
$xtable = new xtable($fmod, 'siswa');
$xtable->use_select();
// epi_edit
$xtable->select_noopt = true;
// epi_edit
// $xtable->select_cekfunc="siswa_pendataan_kelas_list_cek(param)";
$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_box_pos('l', '200px');
$db = siswa_db_bykelas($kls, $tingk);
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$xtable->search_box('nis atau nama siswa');
$xtable->search_info('data siswa dengan nis atau nama "<b>{keyw}</b>"' . ($angk == 0 ? '' : ' pada tahun ajaran ' . $tahunajaran[$tajar]) . '.');
$fid = 0;
if ($xtable->ndata > 0) {
    // $xtable->head('NIS','Nama','Tunggakan{R}','{40px}');
    $xtable->head('NIS', 'Nama', 'Uang Sekolah{R}', '{40px}');
    while ($r = mysql_fetch_array($t)) {
        // $xtable->row_begin();
        $xtable->row_begin($r['replid']);
        $t2 = dbQSql("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'");

$SOUF = stocktake_unfinished();
$fmod = 'daftarbuku';
$xtable = new xtable($fmod, 'Buku');
if ($SOUF == 0) {
    $xtable->use_select();
}
$xtable->pageorder = "barkode,judul";
if ($SOUF != 0) {
    $xtable->noopt = true;
}
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok, 1);
$jen = gpost('jenisbuku');
$jenisbuku = jenisbuku_r($jen, 1);
// Query
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'judul=>pus_katalog.judul-1', 'callnumber=>pus_buku.callnumber-2', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-3', 'pengarang(nama pengarang)=>pus_pengarang.nama-4', 'penerbit(nama penerbit)=>pus_penerbit.nama-5');
$db = new xdb('pus_buku');
$db->field('pus_buku:replid,katalog,lokasi,barkode,idbuku,callnumber,status', 'pus_katalog:judul,klasifikasi,pengarang,penerbit', 'pus_klasifikasi:kode as n1,kode', 'pus_pengarang:nama as n2', 'pus_penerbit:nama as n3');
$db->join('katalog', 'pus_katalog');
$db->joinother('pus_katalog', 'klasifikasi', 'pus_klasifikasi');
$db->joinother('pus_katalog', 'pengarang', 'pus_pengarang');
$db->joinother('pus_katalog', 'penerbit', 'pus_penerbit');
$db->where($lok == 0 ? "" : "pus_buku.lokasi='{$lok}'");
$db->where_and($jen == 0 ? "" : "pus_katalog.jenisbuku='{$jen}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'callnumber', 'n1', 'n2', 'n3', 'status'));
// Page Selection Bar
$PSBar = new PSBar_2(100);
$PSBar->begin();

<?php

appmod_use('aka/tahunlulus', 'aka/tingkat', 'aka/kelas', 'aka/siswa');
$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'alumni';
$xtable = new xtable($fmod);
$xtable->search_keyon('nisn=>aka_siswa.nisn:EQ-0', 'nama=>aka_siswa.nama:LIKE-1');
$xtable->pageorder = "aka_siswa.nisn";
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
    $tlulus = gpost('tahunlulus');
    $tahunlulus = tahunlulus_r($tlulus, $dept);
    // Page Selection Bar
    $PSBar = new PSBar_2();
    $PSBar->begin();
    $PSBar->selection_departemen($fmod, $dept);
    $s = '<button title="Tambah tahun kelulusan" class="btn" style="float:left" onclick="alumni_tahunlulus_form(\'af\')"><div class="bi_addb">&nbsp;</div></button>';
    $PSBar->selection('Tahun kelulusan', iSelect('tahunlulus', $tahunlulus, $tlulus, 'float:left;margin-right:4px;width:' . (intval($PSBar->selw) - 28) . 'px', $fmod . "_get()") . $s);
    if (count($tahunlulus) == 0) {
        $PSBar->pass = false;
    }
    $PSBar->end();
    if ($PSBar->pass) {
        // Query
        $db = new xdb("aka_alumni");
        $db->field("aka_alumni:replid,siswa as idsiswa,keterangan", "aka_siswa:nisn,nama", "departemen:nama as ndepartemen", "aka_angkatan:angkatan as nangkatan");
        $db->join("siswa", "aka_siswa");
        $db->joinother("aka_siswa", "angkatan", "aka_angkatan");
        $db->joinother("aka_angkatan", "departemen", "departemen");

        exit;
    }
    if (count($kelompok) > 0) {
        $PSBar->selection('Kelompok', iSelect('kelompok', $kelompok, $kel, $PSBar->selws, $fmod . "_get()"));
    } else {
        $PSBar->end();
        hiddenval('kelompok', $kel);
        kelompok_warn();
        exit;
    }
    $PSBar->end();
    if ($opt == 'af' || $opt == 'uf') {
        require_once VWDIR . 'pendataan_form.php';
    } else {
        $xtable->pageorder = "nopendaftaran,nama";
        $xtable->search_keyon('nopendaftaran(nomor pendaftaran)=>EQ-0', 'nama-1');
        // Query
        $db = new xdb("psb_calonsiswa");
        $db->where("proses='{$pros}' AND kelompok='{$kel}'");
        $db->where_and($xtable->search_sql_get());
        $t = $db->query();
        $xtable->ndata = mysql_num_rows($t);
        $xtable->opt_w = '50px';
        $t = $db->query($xtable->pageorder_sql('nopendaftaran', 'nama'));
        $xtable->btnbar_begin();
        ?>
	<div style="padding-top:4px;float:left;margin-right:10px"><b>Kuota:</b> <?php 
        echo $nsiswa . ' dari ' . $kapasitas;
        ?>
 siswa</div>
	<div style="float:left;border:1px solid #01a8f7;height:4px;width:<?php 

<?php

require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/guru');
$pel = gpost('pelajaran');
$tajar = gpost('tahunajaran');
$fmod = 'sks_guru_list';
$xtable = new xtable($fmod, 'item', '', 3);
$xtable->search_box_pos('l');
$xtable->search_keyon('kunci=>hrd_pegawai.nip:EQ|hrd_pegawai.nama:LIKE-0,1');
$xtable->pageorder = "hrd_pegawai.nama";
// Query
$db = guru_db();
$db->where_and("aka_guru.pelajaran='{$pel}'");
$db->where_and("aka_guru.tahunajaran='{$tajar}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('hrd_pegawai.nama', 'hrd_pegawai.nip'));
//$xtable->search_box('NIP atau nama guru');
if ($xtable->ndata > 0) {
    echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto">';
    $xtable->head('@Nama', '@!NIP', '{44px}');
    while ($r = mysql_fetch_array($t)) {
        $xtable->row_begin();
        $xtable->td($r['npegawai']);
        $xtable->td($r['nip'], 80);
        $s = '<button class="btn" onclick="sks_guru_set(' . $r['replid'] . ',\'' . $r['npegawai'] . '\')">Pilih</button>';
        $xtable->td($s, 40, 'c');
        $xtable->row_end();

 $PSBar->selection_departemen($fmod, $dept);
 if (count($angkatan) > 0) {
     $PSBar->selection('Angkatan', iSelect('angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get()"));
 } else {
     $PSBar->end();
     hiddenval('angkatan', $angk);
     angkatan_warn(0, 'float:left');
     $PSBar->pass = false;
 }
 $PSBar->end();
 if ($PSBar->pass) {
     if ($opt == 'af' || $opt == 'uf') {
         require_once VWDIR . 'siswa_form.php';
     } else {
         $xtable = new xtable($fmod, 'siswa');
         $xtable->search_keyon('nis=>aka_siswa.nis:EQ', 'nama=>aka_siswa.nama:LIKE');
         $xtable->docname = "Data Siswa Angkatan " . angkatan_name($angk);
         $xtable->printparams = array('angkatan' => angkatan_name($angk));
         // Query
         $db = new xdb("aka_siswa");
         $db->field("aka_siswa:replid,nis,nisn,nama,tmplahir,tgllahir");
         $db->where_and("aka_siswa.angkatan='{$angk}'");
         $db->where_and($xtable->search_sql_get());
         $t = $xtable->use_db($db, $xtable->pageorder_sql('nis', 'nisn', 'nama'));
         $xtable->btnbar_f('print', 'srcbox');
         if ($xtable->ndata > 0) {
             // Table head
             $xtable->head('@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir', '{50px}');
             while ($r = mysql_fetch_array($t)) {
                 $xtable->row_begin();
                 $xtable->td($r['nis'], 80);