本文整理汇总了PHP中xtable类的典型用法代码示例。如果您正苦于以下问题:PHP xtable类的具体用法?PHP xtable怎么用?PHP xtable使用的例子?那么, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了xtable类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: appmod_use
<?php
require_once MODDIR . 'xtable/xtable.php';
appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$pemb = pembayaran_getdatabysubj($modul, $siswaid);
$fmod = 'pembayaran';
$xform = new xform($fmod);
$xform->table_begin();
$xform->col_begin();
$xtable = new xtable($fmod, 'pembayaran');
$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.nomer";
// Query
$db = new xdb("keu_transaksi");
$db->where_and("keu_transaksi.pembayaran='" . $pemb['replid'] . "'");
//$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'));
$s = '<button style="float:left;margin-right:4px" class="btng" onclick="E(\'jenistransaksi\').value=' . JT_INCOME . ';transaksi_form(\'af\')">
<table cellspacing="0" cellpadding="0"><tr>
<td><div style="width:20px;height:20px;background:url(' . IMGR . 'inco.png) center no-repeat;margin-right:6px"></div></td><td><span style="font:bold 11px Verdana,Tahoma;color:#fff;margin-right:4px"><b>Pembayaran</b></span></td>
</tr></table>
</button>';
$xtable->btnbar_f($pemb['lunas'] == 1 ? '<div class="infobox" style="float:left;margin-right:10px">Pembayaran sudah lunas.</div>' : 'add', 'print');
$xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".');
示例2: xtable
<?php
require_once MODDIR . 'xtable/xtable.php';
$fmod = 'pendataan_saudara';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
// Query
$sql = "SELECT * FROM psb_tmp_saudara WHERE sesid='" . session_id() . "' ORDER BY replid";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
$xtable->begin();
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$s = '<div class="psf12200">Nama: <b>' . $r['nama'] . '</b></div>';
if ($r['tgllahir'] != '0000-00-00') {
$s .= '<div class="psf12200">Tanggal lahir: ' . fftgl($r['tgllahir']) . '</div>';
}
if ($r['sekolah'] != '') {
$s .= '<div class="psf12200">Sekolah: ' . $r['sekolah'] . '</div>';
}
$xtable->td($s);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
}
示例3: session_id
<?php
$ssid = session_id();
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
$mtipe = gpost('mtipe');
if ($mtipe == '') {
$mtipe = 0;
}
$fmod = 'peminjaman_buku';
$xtable = new xtable($fmod, 'Item');
$xtable->optw = '50px';
// Query
$db = new xdb("pus_peminjaman");
$db->field('pus_peminjaman:*', 'pus_buku:callnumber,barkode', 'pus_katalog:judul');
$db->join('buku', 'pus_buku');
$db->joinother('pus_buku', 'katalog', 'pus_katalog', 'replid');
$db->where("pus_peminjaman.member='{$cid}' AND pus_peminjaman.mtipe='{$mtipe}'");
$db->order("pus_peminjaman.status DESC");
//echo $db->getsql();
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
//$xtable->btnbar_begin();
// echo '<button class="btn" title="Tambah item" onclick="'.$fmod.'_form(\'af\')"><div class="bi_add">Item</div></button>';
//$xtable->btnbar_end();
echo '<div style="float:none !important">';
示例4: xtable
<?php
require_once MODDIR . 'control.php';
$fmod = 'ruang';
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
// Query
$sql = "SELECT * FROM aka_ruang WHERE departemen='{$dept}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
$t = mysql_query($sql . $xtable->pageorder_sql('kode', 'nama'));
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
$PSBar->end();
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Kode Ruang', '@Nama Ruang', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 100);
$xtable->td($r['nama'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
示例5: stocktake_unfinished
<?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"> </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");
示例6: fform
$fmod="siswakelas";
$fform=new fform($fmod,'af',$cid,'Cari siswa');
$fform->globalkey='0';
$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"));
示例7: xtable
<?php
require_once APPMOD . 'psb/proses.php';
$fmod = 'kelompok';
$xtable = new xtable($fmod, 'kelompok pendaftaran');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
if (count($departemen) > 0) {
// Query
$sql = "SELECT * FROM psb_kelompok WHERE proses='{$pros}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
// Page sort and order
$po = $xtable->pageorder_sql('kelompok', 'kapasitas');
$t = mysql_query($sql . $po);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($proses) > 0) {
$PSBar->selection('Periode', iSelect('proses', $proses, $pros, "width:" . $PSBar->selw, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('proses', $pros);
proses_warn();
exit;
}
$PSBar->end();
$bcolor = array("#86c2ff", "#ffb129", "#00fa29", "#ffcf0d", "#00eb27", "#89bc02", "#ff8001");
示例8: xtable
<?php
require_once MODDIR . 'control.php';
$fmod = 'tahunajaran';
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
// Query
$t = mysql_query("SELECT * FROM aka_tahunajaran WHERE departemen='{$dept}' ORDER BY tglmulai DESC,replid DESC");
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
$PSBar->end();
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Tahun Ajaran', 'Tanggal Mulai', 'Tanggal Akhir', 'Keterangan', 'Status~C');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['tahunajaran'], 200);
$xtable->td(fftgl($r['tglmulai']), 120);
$xtable->td(fftgl($r['tglakhir']), 120);
$xtable->td($r['keterangan']);
if ($r['aktif'] == '1') {
$s = '<button class="btns" title="Klik untuk me-non aktifkan." style="width:85px" onclick="tahunajaran_status_form(\'uf\',' . $r['replid'] . ')">Aktif</button>';
} else {
$s = '<button class="btn" title="Klik untuk mengaktifkan." style="width:85px" onclick="tahunajaran_status_form(\'uf\',' . $r['replid'] . ')">Tidak Aktif</button>';
示例9: gpost
<?php
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
$peminjaman = gpost('peminjaman');
if ($peminjaman == '') {
$peminjaman = 0;
}
hiddenval('peminjaman', $peminjaman);
$fmod = 'pengembalian';
$xtable = new xtable($fmod);
$lok = gpost('lokasi');
$lokasi = lokasi_opt($lok);
if (count($lokasi) > 0) {
if ($opt == 'af' || $opt == 'uf') {
require_once VWDIR . 'pengembalian_form.php';
} else {
// Page sort and order
//$po=$xtable->pageorder_sql('peminjam','nama');
//$t=mysql_query($sql.$po);
$PSBar = new PSBar_2();
// Page selection bar
$PSBar->begin();
if (count($lokasi) > 0) {
$PSBar->selection('lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
示例10: appmod_use
<?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) {
示例11: xtable
<?php
$fmod = 'tempat';
$xtable = new xtable($fmod);
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok);
$PSBar = new PSBar_2();
// Page selection bar
$PSBar->begin();
if (count($lokasi) > 0) {
$PSBar->selection('lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('lokasi', $lok);
lokasi_warn();
exit;
}
$PSBar->end();
$t = mysql_query("SELECT * FROM sar_tempat WHERE lokasi='{$lok}' ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Tempat', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nama'], 250);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
示例12: appmod_use
<?php
appmod_use('aka/tahunajaran');
$fmod = 'tesakademik';
$xtable = new xtable($fmod, 'jenis penilaian');
$xtable->use_urut('aka_tes');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
// Query
$t = mysql_query("SELECT * FROM aka_tes WHERE tahunajaran='{$tajar}' ORDER BY urut");
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($tahunajaran) > 0) {
$PSBar->selection('Tahun ajaran', iSelect('tahunajaran', $tahunajaran, $tajar, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('tahunajaran', $tajar);
tahunajaran_warn(0, 'float:left');
$PSBar->pass = false;
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_f('add', 'updn');
if ($xtable->ndata > 0) {
// Table head
示例13: hiddenval
if($ct_lain!=0){if($w2!="")$w2.=" OR ";
$w2.="pus_peminjaman.mtipe='3'";
$ct_sel2++;}
$w2=($w2==''||$ct_sel2==3)?'':'('.$w2.')';
$tgl=explode("-",date("Y-m-d")); $dim=cal_days_in_month(CAL_GREGORIAN,intval($tgl[1]),intval($tgl[0]));
$tgl_f=date("Y-m")."-1";
$tgl_c=date("Y-m-d");
$tgl_l=date("Y-m")."-".$dim;
$stanggal1=gpost('stanggal1',$tgl_f);
$stanggal2=gpost('stanggal2',$tgl_l);
hiddenval('tanggal_f',$tgl_f);
hiddenval('tanggal_c',$tgl_c);
hiddenval('tanggal_l',$tgl_l);
$xtable = new xtable($fmod,'peminjaman');
$xtable->pageorder="pus_peminjaman.tanggal1 DESC,pus_peminjaman.replid DESC";
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-2',
'judul=>pus_katalog.judul:LIKE-3',
'memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ|pus_member.nid:EQ-1',
'nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE|pus_member.nama:LIKE-1');
// Query
$db=new xdb("pus_peminjaman");
$db->field("pus_peminjaman:*","pus_buku:barkode","pus_katalog:judul","aka_siswa:nis,nama as nsiswa","hrd_pegawai:nip,nama as npegawai","pus_member:nid,nama as nmember");//,"(CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nis WHEN '2' THEN hrd_pegawai.nip ELSE pus_member.nid END) as id_member");//,"@id_member:= as idmmbr");//,"(CASE pus_peminjaman.status='1' AND '".date("Y-m-d")."' > pus_peminjaman.tanggal2 WHEN TRUE THEN '1' ELSE '0' END) as telat1","(CASE pus_peminjaman.status='0' AND pus_peminjaman.tanggal3 > pus_peminjaman.tanggal2 WHEN TRUE THEN '1' ELSE '0' END) as telat2");
$db->join("buku","pus_buku");
$db->join("member","aka_siswa");
$db->join("member","hrd_pegawai");
$db->join("member","pus_member");
$db->joinother("pus_buku","katalog","pus_katalog");
示例14: xtable
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'apps/aka.php';
$fmod = 'peminjaman_member_get_siswa';
$xtable = new xtable($fmod, 'siswa');
$keyw = gpost('keyword');
$xtable->keyw = $keyw;
$xtable->keyph = 'nis atau nama siswa';
$xtable->search_box_pos('l');
$dept = gpost('psdepartemen');
$departemen = departemen_r($dept);
$tajar = gpost('pstahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$ting = gpost('pstingkat');
$tingkat = tingkat_r($ting, $tajar);
$kls = gpost('pskelas');
$kelas = kelas_r($kls, $ting);
?>
<div class="fftabbar">
<div class="fftab1" onclick="<?php
echo $fmod;
?>
_get(0)">Siswa</div>
<div class="fftab" onclick="siswa_saudara_siswapilih(0)">Pegawai</div>
<div class="fftab" onclick="siswa_saudara_siswapilih(0)">Member luar</div>
</div>
<?php
$PSBar = new PSBar_2(100);
$PSBar->begin();
示例15: xtable
<?php
$fmod = 'angsuran';
$xtable = new xtable($fmod);
$xtable->btnbar_f('add');
// Query
$sql = "SELECT * FROM psb_angsuran";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
//echo "gpost('page_number')";
$t = mysql_query($sql . $xtable->pageorder_sql('cicilan', 'keterangan'));
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Jumlah angusran (bulan)~C', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['cicilan'], 200, 'c');
$xtable->td($r['keterangan']);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}