<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='stocktake_note'; $dbtable=stocktake_ctable(); $fform=new fform($fmod,$opt,$cid); $inp=app_form_gpost('note'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; $q=dbUpdate($dbtable,$inp,"replid='$cid'"); //$fform->notif($q); if($q) echo nl2br($inp['note']); else echo "-0-"; } else { $r=dbSFA("*",$dbtable,"W/replid='$cid'"); $t1=mysql_query("SELECT pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."' LIMIT 0,1"); $r1=mysql_fetch_array($t1); $fform->head(); if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form $fform->fc('Tambahkan catatan untuk item:'); $fform->fl('Barkode',$r['barkode']); $fform->fl('Judul',buku_judul($r1['judul'])); $fform->fa('Keterangan',iTextarea('note',$r['note'],$fform->rwidths,3)); } $fform->foot(); } ?>
<?php require_once(MODDIR.'xform/xform.php'); require_once(MODDIR.'fform/fform.php'); require_once(MODDIR.'xtable/xtable.php'); require_once(MODDIR.'control.php'); $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);