PHP xtable::search_box_pos Exemples

Exemple #1

Fichier : stocktake_daftar.php Projet : nickohappy7/sister

$fform->reg['title_af']='<idata>';
$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));

Exemple #2

Fichier : siswa_list_kelas_get.php Projet : epiii/siadu-epiii

    $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'] . "'");
        $r2 = dbFA($t2);