PHP xtable::pageorder_sql方法代码示例

<?php
$fmod='stocktake_hist';
$xtable=new xtable($fmod,'Riwayat Stock Opname');
$xtable->row_valign="top";
$xtable->pageorder="tanggal1";
$xtable->btnbar_begin();
	echo '<button class="btn" onclick="stocktake_hist_back()"><div class="bi_arrow">Kembali</div></button>';
$xtable->btnbar_end();

// Query
$sql="SELECT * FROM pus_stockhist";
$t=mysql_query($sql);
$xtable->ndata=mysql_num_rows($t);
$t=mysql_query($sql.$xtable->pageorder_sql('nama','tanggal1','tanggal2'));

if($xtable->ndata>0){
	// Table head
	$xtable->head('@Nama Stock Opname','@Tanggal Mulai','@Tanggal selesai','Rangkuman','keterangan');
	while($r=mysql_fetch_array($t)){$xtable->row_begin();
				
		$xtable->td($r['nama'],200);
		$xtable->td(fftgl($r['tanggal1']),120);
		$xtable->td(fftgl($r['tanggal2']),120);
		$tot=$r['nitem'];
		$ncek=$r['nceky'];
		$nnocek=$tot-$ncek;
		$nwn=$r['nnote'];
		$nnn=$nnocek-$nwn;
		
		$s='<table class="stable" cellspacing="0" cellpadding="0" border="0" style="border:none !important">';
		$s.='<tr><td style="border:none !important" width="180px">Total item di database</td><td style="border:none !important">: '.$tot.' item</td></tr>';

<?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();
        }

 $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");
 $db->field("pus_peminjaman:*", "pus_buku:barkode", "pus_katalog:judul", "DATEDIFF(pus_peminjaman.tanggal3,pus_peminjaman.tanggal2) as telat", "aka_siswa:nis,nama as nsiswa", "hrd_pegawai:nip,nama as npegawai");
 $db->join("buku", "pus_buku");
 $db->join("member", "aka_siswa");
 $db->join("member", "hrd_pegawai");
 $db->joinother("pus_buku", "katalog", "pus_katalog");
 $db->where("pus_peminjaman.status = '0'");
 $db->where_and("pus_peminjaman.tanggal3 >= '{$tanggal1}'");
 $db->where_and("pus_peminjaman.tanggal3 <= '{$tanggal2}'");
 $db->where_and($xtable->search_sql_get());
 $t = $db->query();
 $xtable->ndata = mysql_num_rows($t);
 $t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'nsiswa,npegawai', 'tanggal1', 'tanggal2', 'tanggal3', 'telat'));
 $xtable->btnbar_begin();
 if ($SOUF == 0) {
     $xtable->btnbar_add();
 } else {
     echo '<div class="warnbox">Pengembalian tidak dapat dilakukan selama proses stock opname berlangsung.</div>';
 }
 $xtable->search_box();
 //$xtable->btnbar_print();
 $xtable->btnbar_end();
 $xtable->search_info();
 if ($xtable->ndata > 0) {
     // Table head
     $xtable->head('@Barkode Item', '@Judul Item', '@Peminjam', '@Tgl peminjaman', '@Tgl pengembalian', '@Tgl dikembalikan', '@Terlambat{R}', 'Keterangan');
     while ($r = mysql_fetch_array($t)) {
         $xtable->row_begin();

if($opt=='af'||$opt=='uf') require_once(VWDIR.'en/katalog_form.php');
else{
// Query
$f=dbTF('pus_katalog:replid,judul,klasifikasi,pengarang,penerbit','pus_klasifikasi:kode as n1,kode','pus_pengarang:nama as n2','pus_penerbit:nama as n3');
$j=dbLJoin('pus_katalog','klasifikasi','pus_klasifikasi','replid');
$j.=dbLJoin('pus_katalog','pengarang','pus_pengarang','replid');
$j.=dbLJoin('pus_katalog','penerbit','pus_penerbit','replid');
$xtable->search_sql_set(array('judul'=>"pus_katalog.judul:LIKE",
			  'kode'=>"pus_klasifikasi.kode:=",
			  'pengarang'=>"pus_pengarang.nama:LIKE",
			  'penerbit'=>"pus_penerbit.nama:LIKE"));

$sql="SELECT ".$f." FROM pus_katalog ".$j." ".$xtable->search_sql_get();
$t=mysql_query($sql);
$xtable->ndata=mysql_num_rows($t);
$t=mysql_query($sql.$xtable->pageorder_sql('judul','n1','n2','n3'));

$xtable->btnbar_begin();
	$xtable->btnbar_add();
	$xtable->search_box();
	//$xtable->btnbar_print();
$xtable->btnbar_end();

$xtable->search_info();

if($xtable->ndata>0){
// Table head
	$xtable->head('@Title','@Classification','@Author','@Publisher');
	while($r=mysql_fetch_array($t)){$xtable->row_begin();
				
		$xtable->td($r['judul'],0,'','judul');

$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));

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');

	}
$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}');
	$n=0;
	while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);

		$xtable->td($r['barkode'],100);
		$xtable->td(buku_judul($r['judul']));
		
		if(admin_isoperator()) $s='<button class="btn" onclick="xtable3_cekall(false);xtable3_sel('.$n.');sirkulasi_peminjaman_form_buku_form(\'a\',\'0\',true)">Pilih</button>~40px';
		else $s='<div style="height:23px;width:40px"></div>';
		$xtable->opt($r['replid'],$s);
		
		$n++;

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();
    }
    $xtable->foot();
    echo '</div>';
} else {

$kat = $cid;
hiddenval('lokasi', $lok);
hiddenval('grup', $grup);
hiddenval('katalog', $kat);
if ($opt == 'af' || $opt == 'uf') {
    require_once VWDIR . 'katalog_form.php';
} else {
    // Katalog Query
    $tk = mysql_query("SELECT * FROM sar_katalog WHERE replid='{$cid}'");
    $rk = mysql_fetch_array($tk);
    // Query
    $sql = "SELECT * FROM sar_barang WHERE katalog='{$cid}'";
    $t = mysql_query($sql);
    $xtable->ndata = mysql_num_rows($t);
    // Page sort and order
    $po = $xtable->pageorder_sql('kode', 'barkode', 'kondisi');
    $t = mysql_query($sql . $po);
    $xtable->btnbar_f('b-Grup barang', '<button class="btn" onclick="katalog_form(\'uf\',\'' . $rk['replid'] . '\')"><div class="bi_edit">Edit informasi barang</div></button>', 'add');
    notifbox();
    hiddenval('opf', 'uni');
    hiddenval('kondisi_1', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='1'")));
    hiddenval('kondisi_2', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='2'")));
    hiddenval('kondisi_3', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='3'")));
    hiddenval('kondisi_4', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='4'")));
    ?>
<div class="tbltopmbar" style="float:left;margin-top:10px;margin-bottom:10px">
<table class="stable" cellspacing="0" cellpadding="0" width="100%"><tr valign="top">
<td width="400px">
	<table class="stable" cellspacing="0" cellpadding="0">
		<tr height="24px"><td colspan="2"><b>Informasi Barang :</b></td></tr>
		<tr height="24px"><td width="140px">Nama barang:</td><td><?php 

<?php

$fmod = 'posisi';
$xtable = new xtable($fmod, 'posisi pegawai');
// Query
$db = new xdb("hrd_m_posisi");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql('posisi'));
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
    // Table head
    $xtable->head('@Nama posisi', 'Keterangan');
    while ($r = mysql_fetch_array($t)) {
        $xtable->row_begin($r['replid']);
        $xtable->td($r['posisi'], 200);
        $xtable->td(nl2br($r['keterangan']));
        $xtable->opt_ud($r['replid']);
        $xtable->row_end();
    }
    $xtable->foot();
} else {
    $xtable->nodata();
}

<?php

$fmod = 'status';
$xtable = new xtable($fmod, 'status pegawai');
// Query
$db = new xdb("hrd_m_status");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql('status'));
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
    // Table head
    $xtable->head('@Nama status', 'Reminder', 'Keterangan');
    while ($r = mysql_fetch_array($t)) {
        $xtable->row_begin($r['replid']);
        $xtable->td($r['status'], 200);
        $xtable->td($r['reminder'] . ' hari', 200);
        $xtable->td(nl2br($r['keterangan']));
        $xtable->opt_ud($r['replid']);
        $xtable->row_end();
    }
    $xtable->foot();
} else {
    $xtable->nodata();
}

$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();
// Query
$db = new xdb("sar_grup", "", "lokasi='{$lok}'");
$t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama'));
$xtable->btnbar_begin();
$xtable->btnbar_add();
echo '<div class="sfont" style="float:right;margin-top:4px">Total aset: ' . fRp(lokasi_aset($lok)) . '</div>';
$xtable->btnbar_end();
if ($xtable->ndata > 0) {
    // Table head
    $xtable->head('@kode', '@nama Grup barang', 'Jumlah unit~C', 'Unit tersedia~C', 'Unit dipinjam~C', 'Total aset~R', 'Keterangan');
    $nom = 1;
    while ($r = mysql_fetch_array($t)) {
        $xtable->row_begin($r['replid']);
        $n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE grup='" . $r['replid'] . "'"));
        $xtable->td($r['kode'], 100);
        $xtable->td($r['nama'], 200);
        $xtable->td($n, 100, 'c');
        $xtable->td(0, 100, 'c');

 }
 $db = new xdb("aka_daftarnilai", "*", "penilaian='{$peni}'");
 $nlulus = 0;
 $t = $db->go();
 while ($r = dbFA($t)) {
     if ($r['nilai'] >= $dpeni['kkm']) {
         $nlulus++;
     }
 }
 $db = siswa_db_bykelas($kls);
 $db->field("aka_daftarnilai:nilai,keterangan as ketnilai", "IF(aka_daftarnilai.nilai < " . $dpeni['kkm'] . ", 1, 0) as tuntas");
 $db->join("siswa", "aka_daftarnilai", "siswa");
 $db->where_and("aka_daftarnilai.penilaian='{$peni}'");
 $t = $db->query();
 $xtable->ndata_db($t);
 $t = $db->query($xtable->pageorder_sql("aka_siswa:nis,nama", "aka_daftarnilai.nilai", "tuntas"));
 echo '<div style="width:100%;float:left">';
 $xtable->btnbar_begin();
 echo '<button class="btn" style="float:left;margin-right:4px" onclick="daftarnilai_form(\'uf\',0)"><div class="bi_edit">Edit nilai</div></button>';
 //echo '<button class="btn" style="float:left;margin-right:4px"><div class="bi_pri">Cetak</div></button>';
 $nlulus = $xtable->ndata == 0 ? 0 : $nlulus * 100 / $xtable->ndata;
 echo '<div class="sfont" style="float:right;margin-top:4px;margin-left:40px">Persentase ketuntasan siswa: <b>' . $nlulus . ' %</b></div>';
 echo '<div class="sfont" style="float:right;margin-top:4px;margin-left:10px">SKM: <b>' . $dpeni['kkm'] . '</b></div>';
 $xtable->btnbar_end();
 echo '</div>';
 //echo $xtable->ndata;
 if ($xtable->ndata > 0) {
     // Table head
     $xtable->head('@!NIS', '@Nama', '@Nilai{C}', '@Ketuntasan', 'Keterangan');
     while ($r = mysql_fetch_array($t)) {
         $xtable->row_begin($r['replid']);

}
$PSBar->end();
if ($PSBar->pass) {
    $db = new xdb("aka_penilaian");
    $db->field("SUM(aka_penilaian.bobot) as tbobot");
    $db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'");
    $t1 = $db->query();
    $r1 = mysql_fetch_array($t1);
    $tbobot = $r1['tbobot'];
    // Query
    $db = new xdb("aka_penilaian");
    $db->field("aka_penilaian:*");
    $db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'");
    $t = $db->query();
    $xtable->ndata_db($t);
    $t = $db->query($xtable->pageorder_sql("aka_penilaian:nama,kode,kkm,bobot"));
    $xtable->btnbar_f('add');
    //echo $xtable->ndata;
    if ($xtable->ndata > 0) {
        // Table head
        $xtable->head('@Penilaian', '@Kode{C}', '@bobot penilaian{C}', '!Persentase Bobot{C}', 'Keterangan');
        while ($r = mysql_fetch_array($t)) {
            $xtable->row_begin($r['replid']);
            $xtable->td($r['nama'], 300);
            $xtable->td($r['kode'], 100, 'c');
            //$xtable->td($r['kkm'],100,'c');
            $xtable->td($r['bobot'], 120, 'c');
            $xtable->td(number_format($r['bobot'] * 100 / $tbobot, 2) . ' %', 120, 'c');
            $xtable->td(nl2br($r['keterangan']));
            $s = '<button class="btn" title="Daftar nilai siswa." onclick="openPage(' . app_page_getindex('daftarnilai') . ',\'daftarnilai\',false,\'pelajaran=' . $pel . '&kelas=' . $kls . '&penilaian=' . $r['replid'] . '\')"><div class="bi_lis" style="">Nilai</div></button>&nbsp;&nbsp;~60';
            $xtable->opt($r['replid'], $s, 'u', 'd');

<?php

require_once MODDIR . 'control.php';
$fmod = 'inventaris';
$xtable = new xtable($fmod, 'Grup barang');
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok);
if (count($lokasi) > 0) {
    // Query
    $sql = "SELECT * FROM sar_grup WHERE lokasi='{$lok}'";
    $t = mysql_query($sql);
    $xtable->ndata = mysql_num_rows($t);
    // Page sort and order
    $po = $xtable->pageorder_sql('kode', 'nama');
    $t = mysql_query($sql . $po);
    $xtable->btnbar_sth();
    ?>
	<td width="80px" align="left"><b>Lokasi:</b></td>
	<td width="120px"><?php 
    echo iSelect('lokasi', $lokasi, $lok, '', $fmod . "_get()");
    ?>
</td>
	<td align="right">
	<?php 
    $xtable->btnbar_add();
    ?>
	</td>
<?php 
    $xtable->btnbar_stf();
    notifbox();
    ?>

$db->where_and($w3);
if($xtable->keyn=='memberid' && $xtable->page_search==1){
	$db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nis WHEN '2' THEN hrd_pegawai.nip ELSE pus_member.nid END) = '".$xtable->keyw."')");
} else if($xtable->keyn=='nama' && $xtable->page_search==1){
	if($xtable->keyw=='') $keywo=" = '' ";
	else $keywo=" LIKE '%".$xtable->keyw."%' ";
	$db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nama WHEN '2' THEN hrd_pegawai.nama ELSE pus_member.nama END) ".$keywo.")");
} else {
	$db->where_and($xtable->search_sql_get());
}
				

if(!($ct_sel1==0 || $ct_sel2==0 || $ct_sel3==0)){
	$t=$db->query();
	$xtable->ndata=mysql_num_rows($t);
	$t=$db->query($xtable->pageorder_sql('pus_peminjaman.tanggal1','nsiswa,npegawai,nmember','pus_buku.barkode','pus_katalog.judul','pus_peminjaman.tanggal2','pus_peminjaman.status','pus_peminjaman.tanggal3'));
}

echo '<table cellspacing="0" cellpadding="0" style="margin-bottom:20px"><tr valign="top"><td width="250px">';
	echo '<div class="sfont" style="float:left;width:100%;margin-top:0px;margin-bottom:10px"><b>Tampilkan catatan sirkulasi:</b></div>';
	echo '<div style="float:left;width:100%">';
		echo '<div style="float:left">';
		echo '<table cellspacing="0" cellpadding="0">';
		echo '<tr height="24px">',
			'<td>'.iCheckx('ct_pinjam','masih dipinjam',$ct_pinjam).'</td>',
		'</tr>';
		echo '<tr height="24px">',
			'<td>'.iCheckx('ct_kembali','sudah dikembalikan',$ct_kembali).'</td>',
		'</tr>';
		echo '</table>';
		echo '</div>';