PHP xdb::group 예제들

예제 #1

파일: statistik2.php 프로젝트: nickohappy7/sister

$tanggal2=gpost('tanggal2',$tgl2);

// Query
$xtable->search_keyon('memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ|pus_member.nid:EQ-0','nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE|pus_member.nama:LIKE-1');
				
$db=new xdb("pus_peminjaman");
$db->field("pus_peminjaman:replid,member,mtipe","COUNT(pus_peminjaman.member) as cnt","aka_siswa:nis,nama as nsiswa","hrd_pegawai:nip,nama as npegawai","pus_member:nid,nama as nmember");
$db->join("buku","pus_buku");
$db->join("member","aka_siswa");
$db->join("member","hrd_pegawai");
$db->join("member","pus_member");
$db->where($lok==0?"":"pus_buku.lokasi='$lok'");
$db->where_and("pus_peminjaman.tanggal1 >= '$tanggal1'");
$db->where_and("pus_peminjaman.tanggal1 <= '$tanggal2'");
$db->where_and($xtable->search_sql_get());
$db->group("pus_peminjaman.mtipe,pus_peminjaman.member");

$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('nis,nip,nid','nsiswa,npegawai,nmember','mtipe','cnt'));

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

예제 #2

파일: katalog.php 프로젝트: nickohappy7/sister

$xtable->search_keyon('judul=>pus_katalog.judul-0',
			  'isbn(barcode)=>pus_buku.barkode-1',
			  'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-2',
			  'pengarang(nama pengarang)=>pus_pengarang.nama:LIKE-3',
			  'penerbit(nama penerbit)=>pus_penerbit.nama:LIKE-4');
$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();

$xtable->btnbar_begin();
	if($SOUF==0) $xtable->btnbar_add();
	else echo '<div class="warnbox">Perubahan katalog tidak dapat dilakukan selama proses stock opname berlangsung.</div>';
	
	
	if($katalog_view=='detil'){
		echo '<button title="Tampilan daftar" class="btn" style="float:left;margin-right:4px" onclick="E(\'katalog_view\').value=\'list\';katalog_get()"><div class="bi_lis">Daftar</div></button>';
	} else {

예제 #3

파일: statistik1.php 프로젝트: epiii/siadu-epiii

$tanggal1 = gpost('tanggal1', $tgl1);
$tanggal2 = gpost('tanggal2', $tgl2);
// 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_peminjaman');
$db->field('pus_peminjaman:replid', 'pus_buku:callnumber', 'pus_katalog:judul,klasifikasi,pengarang,penerbit', 'pus_klasifikasi:kode as n1,kode', 'pus_pengarang:nama as n2', 'pus_penerbit:nama as n3', 'COUNT(pus_peminjaman.buku) as cnt');
$db->join('buku', 'pus_buku');
$db->joinother('pus_buku', '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("pus_peminjaman.tanggal1 >= '{$tanggal1}'");
$db->where_and("pus_peminjaman.tanggal1 <= '{$tanggal2}'");
$db->where_and($xtable->search_sql_get());
$db->group("pus_buku.katalog");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('judul', 'callnumber', 'n1', 'n2', 'n3', 'cnt'));
// Page Selection Bar
$PSBar = new PSBar_2(100, 450);
$PSBar->begin();
$PSBar->selection('Statistik', iSelect('statistik', $statistik, $stat, $PSBar->selws, $fmod . "_get()"));
if (count($lokasi) > 0) {
    $PSBar->selection('Lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()"));
} else {
    $PSBar->end();
    hiddenval('lokasi', $lok);
    lokasi_warn(0, 'float:left');
    $PSBar->pass = false;
}

예제 #4

파일: member_lain.php 프로젝트: nickohappy7/sister

$xtable->search_keyon('kunci=>pus_member.nid:EQ|pus_member.nama:LIKE-0,1');

/*
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->field('pus_member:*',"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 = pus_member.replid AND pus_peminjaman.mtipe = '3')");
$db->where_and($xtable->search_sql_get());
$db->group("pus_member.replid");

$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_member.nid','pus_member.nama','','','cntpjm','cnt'));

$xtable->btnbar_begin();
	$xtable->btnbar_add();
	$xtable->search_box('nomor ID atau nama member');
$xtable->btnbar_end();

if($xtable->ndata>0){
	// Table head
	$xtable->head('@!ID Member','@Nama','kontak','alamat','Jml item sedang dipinjam{200px}','@Total peminjaman{120px}');
	while($r=mysql_fetch_array($t)){$xtable->row_begin();
	

예제 #5

파일: member_pegawai.php 프로젝트: nickohappy7/sister

$xtable->search_keyon('kunci=>hrd_pegawai.nip:EQ|hrd_pegawai.nama:LIKE-0,1');

/*
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('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();