本文整理汇总了PHP中xtable::search_box方法的典型用法代码示例。如果您正苦于以下问题:PHP xtable::search_box方法的具体用法?PHP xtable::search_box怎么用?PHP xtable::search_box使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类xtable
的用法示例。
在下文中一共展示了xtable::search_box方法的12个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: if
} else {
$PSBar->end();
hiddenval('lokasi',$lok);
lokasi_warn(0,'float:left');
$PSBar->pass=false;
}
$s='<button style="float:left;margin:0px 4px 0px 4px" class="btn" title="Tampilkan" onclick="'.$fmod.'_get()"><div class="bi_srcb"> </div></button>';
$PSBar->selection('Periode',inputTanggal('tanggal1',$tanggal1).'<div style="float:left;margin:4px 12px 0px 8px">sampai</div> '.inputTanggal('tanggal2',$tanggal2).$s);
$PSBar->end();
if($PSBar->pass){
$xtable->btnbar_begin();
//echo '<button style="float:left;margin-right:4px" class="btn" title="Reload" onclick="'.$fmod.'_get()"><div class="bi_relb"> </div></button>';
$xtable->search_box();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
$membertipe=array(1=>'Siswa',2=>'Pegawai',3=>'Member luar');
if($xtable->ndata>0){
$xtable->head('@!ID Member','@Nama member','@Jenis member','@Jumlah Item Dipinjam{R,150px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
if($r['mtipe']==1){
$xtable->td($r['nis'],120);
$xtable->td($r['nsiswa']);
}
else if($r['mtipe']==2){
示例2: hiddenval
hiddenval('ff_departemen', $dept);
hiddenval('ff_angkatan', $angk);
departemen_warn(0);
$PSBar->pass = false;
}
if (count($angkatan) > 0) {
$PSBar->selection('Angkatan', iSelect('ff_angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get(1)"));
} else {
$PSBar->end();
hiddenval('ff_angkatan', $angk);
angkatan_warn(0);
$PSBar->pass = false;
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->search_box('nis atau nama siswa');
$db = siswa_db_byangkatan($angk);
$db->where_and("!( NOT EXISTS (SELECT aka_siswa_kelas.replid FROM aka_siswa_kelas WHERE aka_siswa_kelas.siswa=aka_siswa.replid AND aka_siswa_kelas.kelas='{$kls}') )");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('aka_siswa.nis', 'aka_siswa.nama'));
if ($xtable->ndata > 0) {
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@nis', '@nama', '{44px}');
$n = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['nis'], 100);
$xtable->td($r['nama']);
if (admin_isoperator()) {
示例3:
$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));
if($ncek_y<$ncek){
echo '<div class="infobox">Item yang sudah di cek : <b>'.$ncek_y.'</b> dari <b>'.$ncek.'</b> item.</div>';
} else {
echo '<div class="infobox">Semua item sebanyak <b>'.$ncek.'</b> item sudah dicek.</div>';
}
$xtable->search_box('cari barkode');
if($xtable->ndata>0){
// Table head
$xtable->head('@barkode','@judul','@Cek~C','@Waktu cek');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$t1=mysql_query("SELECT pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."'");
//echo
$r1=mysql_fetch_array($t1);
$xtable->td($r['barkode'],120);
$xtable->td(buku_judul($r['judul']));
$s='<span style="color:'.($r['cek']=='Y'?'':'#ff0000').'"><b>'.$r['cek'].'</b></span>';
$xtable->td($s,40,'c');
$d=explode(" ",$r['ts']);
if($r['cek']=='Y') $xtable->td(fftgl($d[0])." - ".$d[1],160);
示例4: xdb
$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");
$db->where_and("pus_buku.lokasi='$lok'");
$db->where_and("pus_buku.status='1'");
$db->where_and("!( NOT EXISTS (SELECT pus_tpjm.replid FROM pus_tpjm WHERE pus_tpjm.buku=pus_buku.replid ) )");
$db->where_and($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_katalog.judul'));
if($xtable->ndata>0){
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@Barkode','@Judul','{44px}');
示例5: xdb
// Query
$db = new xdb("keu_transaksi");
$db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'");
$db->where_and("keu_transaksi.tanggal>='{$tanggal1}'");
$db->where_and("keu_transaksi.tanggal<='{$tanggal2}'");
$db->where_and($w == "" ? "" : "(" . $w . ")");
$db->where_and($xtable->search_sql_get());
//$db->order("keu_transaksi.tanggal,keu_transaksi.nomer");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('keu_transaksi.tanggal', 'keu_transaksi.nomer', '', 'keu_transaksi.nominal'));
//$t=$db->query($xtable->pageorder_sql('kode','nama'));
$xtable->btnbar_begin();
//$xtable->btnbar_print();
//echo '<button class="btn" style="float:left;margin-right:4px" onclick="E(\'pageprinter\').submit()"><div class="bi_pri">Cetak</div></button>';
$xtable->search_box('Cari uraian atau nomor jurnal');
echo iCheckx('ct_jurnaldetil', 'Tampilkan detil jurnal', $ct_jurnaldetil, 'float:right;margin-left:4px;margin-right:30px;margin-top:4px', 'onclick="transaksi_jurnadetil(this.checked)"');
$xtable->btnbar_end();
$xtable->search_info('data transaksi dengan uraian atau nomor jurnal "<b>{keyw}</b>".');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@!Tanggal', '@!No. Jurnal / <br/>Jenis Bukti / <br/>No. Bukti', 'Uraian', '@nominal{R' . ($ct_jurnaldetil == 1 ? ',h' : '') . '}', 'Detil Jurnal' . ($ct_jurnaldetil == 1 ? '' : '{h}'));
$row = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($r['jenis'] == JT_INCOME) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_OUTCOME) {
$cl = '#ff1b1b';
} else {
示例6: COUNT
SELECT aka_siswa.replid, aka_siswa.nis, aka_siswa.nama, COUNT( pus_peminjaman.buku ) AS cnt
FROM aka_siswa
LEFT JOIN pus_peminjaman ON ( pus_peminjaman.member = aka_siswa.replid
AND pus_peminjaman.mtipe = '1' )
GROUP BY aka_siswa.replid
*/
// Query
$db=new xdb('pus_member');
$db->where_and($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_member.nid','pus_member.nama'));
$xtable->search_box('nomor ID atau nama member');
if($xtable->ndata>0){
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@!ID Member','@Nama','{44px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['nid'],80);
$xtable->td($r['nama']);
if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(3,'.$r['replid'].')">Pilih</button>~40px';
else $s='<div style="height:23px;width:40px"></div>';
$xtable->opt($r['replid'],$s);
$xtable->row_end();}$xtable->foot();
echo '</div>';
示例7: inputTanggal
if ($PSBar->pass) {
$s = '<button style="float:left;margin:0px 4px 0px 4px" class="btn" title="Tampilkan" onclick="' . $fmod . '_get()"><div class="bi_srcb"> </div></button>';
$PSBar->selection('Bulan', inputTanggal('tanggal', $tanggal, $fmod . '_get()', 'Ym') . ' ' . $s);
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$db = guru_db_bytahunajaran($tajar);
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('npegawai'));
$xtable->btnbar_begin();
echo '<button style="float:left;margin-right:6px" class="btnz" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_c . '\');presensiguru_form(\'af\',0)">Presensi hari ini</button>';
echo '<div class="sfont" style="float:left;margin-top:4px">atau klik pada tanggal utuk mengedit presensi guru.</div>';
$xtable->search_box('nama guru');
$xtable->btnbar_end();
$absensi = array('0' => '', 'h' => 'Hadir', 'a' => 'Abstain', 'i' => 'Ijin', 's' => 'sakit');
if ($xtable->ndata > 0) {
// Table head
$heads = array('@nama');
for ($i = 1; $i <= $dim; $i++) {
$s = '!<div class="presensi_tgl_btn" title="Edit presensi guru tanggal ' . $i . '" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_cm . $i . '\');presensiguru_form(\'af\',0)">' . $i . '</div>';
array_push($heads, $s . '{C,24px}');
}
array_push($heads, '%{C}');
array_push($heads, '{30px,C}');
$xtable->head($heads);
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
//$xtable->td($r['nis'],60);
示例8: ON
FROM aka_siswa
LEFT JOIN pus_peminjaman ON ( pus_peminjaman.member = aka_siswa.replid
AND pus_peminjaman.mtipe = '1' )
GROUP BY aka_siswa.replid
*/
// Query
$db=new xdb('hrd_pegawai');
$db->field("hrd_pegawai:replid,nip,nama");
$db->where_and($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('hrd_pegawai.nip','hrd_pegawai.nama'));
$xtable->search_box('nip atau nama member');
if($xtable->ndata>0){
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@!ID Member','@Nama','{44px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['nip'],80);
$xtable->td($r['nama']);
if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(2,'.$r['replid'].')">Pilih</button>~40px';
else $s='<div style="height:23px;width:40px"></div>';
$xtable->opt($r['replid'],$s);
$xtable->row_end();}$xtable->foot(0);
echo '</div>';
示例9: xdb
*/
// Query
$db=new xdb('hrd_pegawai');
$db->field('hrd_pegawai:replid,nip,nama',"COUNT(pus_peminjaman.buku) as cnt","SUM(CASE pus_peminjaman.status WHEN '1' THEN 1 ELSE 0 END) as cntpjm");
$db->join_cust("pus_peminjaman ON (pus_peminjaman.member = hrd_pegawai.replid AND pus_peminjaman.mtipe = '2')");
$db->where_and($xtable->search_sql_get());
$db->group("hrd_pegawai.replid");
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('hrd_pegawai.nip','hrd_pegawai.nama','','','cntpjm','cnt'));
$xtable->btnbar_begin();
//$xtable->btnbar_add();
$xtable->search_box('nip atau nama pegawai');
$xtable->btnbar_end();
if($xtable->ndata>0){
// Table head
$xtable->head('@!NIP','@Nama','Jml item sedang dipinjam{200px}','@Total peminjaman{120px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['nip'],80);
$xtable->td($r['nama']);
$xtable->td($r['cntpjm'],200);
$xtable->td($r['cnt'],120);
$xtable->opt_ud($r['replid']);
$xtable->row_end();}$xtable->foot();
}else{$xtable->nodata();}
示例10: iSelect
/*
// Page Selection Bar
$PSBar = new PSBar_2(100);
$PSBar->begin();
$PSBar->selection('Tampilkan',iSelect('tampilx',array(0=>'item belum dicek',1=>'item sudah dicek',2=>'semua item'),$tamp,$PSBar->selws,$fmod."_get()"));
$PSBar->end();
*/
echo '<div style="width:100%;float:left;height:20px"></div>';
$xtable->btnbar_begin();
echo '<div class="sfont" style="float:left;width:80px;margin-top:4px;margin-right:4px"><b>Tampilkan:</b></div>';
echo iSelect('tampil',array(0=>'item belum dicek',1=>'item sudah dicek',2=>'semua item'),$tamp,'float:left;margin-right:4px',$fmod."_get()");
//echo '<button class="btnz" style="float:left;margin-right:4px" onclick="stocktake_note()">Selesai</button>';
echo '<button title="Muat ulang." class="btn" style="float:left;margin-right:4px" onclick="stocktake_note()"><div class="bi_relb"> </div></button>';
//$xtable->btnbar_add();
$xtable->search_box('','barkode atau judul buku');
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
if($xtable->ndata>0){
// Table head
$n=0;
$xtable->head('@Barkode','@Judul','@Cek~C','Keterangan');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['barkode'],120);
$xtable->td(buku_judul($r['judul']),300);
$xtable->td($r['cek'],50,'c');
//td($a,$b='*',$c='',$k='',$atr=''){
示例11: xdb
$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');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.ct";
// Query
$db = new xdb("keu_transaksi");
$db->where_and("keu_transaksi.jenis='" . JT_INBRG . "'");
$db->where_and($xtable->search_sql_get());
//$db->order("keu_transaksi.tanggal,keu_transaksi.nomer");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql());
//$t=$db->query($xtable->pageorder_sql('kode','nama'));
$xtable->btnbar_begin();
echo '<button title="Penerimaan barang" class="btn" onclick="' . $fmod . '_form(\'af\')"><div class="bi_boxin">Penerimaan barang</div></button>';
$xtable->search_box('nomor transaksi atau uraian');
$xtable->btnbar_end();
$xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('!Tanggal/<br/>No. Transaksi{110px}', 'Uraian', 'Detil Jurnal', '{50px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($r['jenis'] == JT_INCOME) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_SISWA) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_CALONSISWA) {
$cl = '#00c804';
示例12: inputTanggal
if ($PSBar->pass) {
$s = '<button style="float:left;margin:0px 4px 0px 4px" class="btn" title="Tampilkan" onclick="' . $fmod . '_get()"><div class="bi_srcb"> </div></button>';
$PSBar->selection('Bulan', inputTanggal('tanggal', $tanggal, $fmod . '_get()', 'Ym') . ' ' . $s);
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$db = siswa_db_bykelas($kls, $ting);
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('nama'));
$xtable->btnbar_begin();
echo '<button style="float:left;margin-right:6px" class="btnz" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_c . '\');presensi_form(\'af\',0)">Presensi hari ini</button>';
echo '<div class="sfont" style="float:left;margin-top:4px">atau klik pada tanggal utuk mengedit presensi siswa.</div>';
$xtable->search_box('nama siswa');
$xtable->btnbar_end();
$absensi = array('0' => '', 'h' => 'Hadir', 'a' => 'Abstain', 'i' => 'Ijin', 's' => 'sakit');
if ($xtable->ndata > 0) {
// Table head
$heads = array('@nama');
for ($i = 1; $i <= $dim; $i++) {
$s = '!<div class="presensi_tgl_btn" title="Edit presensi tanggal ' . $i . '" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_cm . $i . '\');presensi_form(\'af\',0)">' . $i . '</div>';
array_push($heads, $s . '{C,24px}');
}
array_push($heads, '%{C}');
array_push($heads, '{30px,C}');
$xtable->head($heads);
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
//$xtable->td($r['nis'],60);