Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class RefJurnalObj extends DaftarObj2{
- var $Prefix = 'RefJurnal';
- var $elCurrPage="HalDefault";
- var $SHOW_CEK = TRUE;
- var $TblName = 'ref_jurnal'; //daftar
- var $TblName_Hapus = 'ref_jurnal';
- var $MaxFlush = 10;
- var $TblStyle = array( 'koptable', 'cetak','cetak'); //berdasar mode
- var $ColStyle = array( 'GarisDaftar', 'GarisCetak','GarisCetak');
- var $KeyFields = array('ka','kb','kc','kd','ke','kf');
- var $FieldSum = array();//array('jml_harga');
- var $SumValue = array();
- var $FieldSum_Cp1 = array( 14, 13, 13);//berdasar mode
- var $FieldSum_Cp2 = array( 1, 1, 1);
- var $checkbox_rowspan = 1;
- var $PageTitle = 'Referensi Data';
- var $PageIcon = 'images/masterData_01.gif';
- var $pagePerHal ='';
- var $cetak_xls=TRUE ;
- var $fileNameExcel='usulansk.xls';
- var $Cetak_Judul = 'JURNAL';
- var $Cetak_Mode=2;
- var $Cetak_WIDTH = '30cm';
- var $Cetak_OtherHTMLHead;
- var $FormName = 'RefJurnalForm';
- function setTitle(){
- return 'Daftar Akun';
- }
- function setMenuEdit(){
- return
- "<td>".genPanelIcon("javascript:".$this->Prefix.".Baru()","new_f2.png","Baru",'Baru')."</td>".
- "<td>".genPanelIcon("javascript:".$this->Prefix.".Edit()","edit_f2.png","Edit", 'Edit')."</td>".
- "<td>".genPanelIcon("javascript:".$this->Prefix.".Hapus()","delete_f2.png","Hapus", 'Hapus').
- "</td>";
- }
- function setMenuView(){
- return "";
- }
- function setCetak_Header($Mode=''){
- global $Main, $HTTP_COOKIE_VARS;
- //$fmSKPD = cekPOST($this->Prefix.'SkpdfmSKPD'); //echo 'fmskpd='.$fmSKPD;
- //$fmUNIT = cekPOST($this->Prefix.'SkpdfmUNIT');
- //$fmSUBUNIT = cekPOST($this->Prefix.'SkpdfmSUBUNIT');
- return
- "<table style='width:100%' border=\"0\">
- <tr>
- <td class=\"judulcetak\">".$this->setCetakTitle()."</td>
- </tr>
- </table>";
- /*"<table width=\"100%\" border=\"0\">
- <tr>
- <td class=\"subjudulcetak\">".PrintSKPD2($fmSKPD, $fmUNIT, $fmSUBUNIT)."</td>
- </tr>
- </table><br>";*/
- }
- //function setPage_IconPage(){ return 'images/masterData_ico.gif'; }
- function simpan(){
- global $HTTP_COOKIE_VARS;
- global $Main;
- $uid = $HTTP_COOKIE_VARS['coID'];
- $cek = ''; $err=''; $content=''; $json=TRUE;
- //get data -----------------
- $fmST = $_REQUEST[$this->Prefix.'_fmST'];
- $idplh = $_REQUEST[$this->Prefix.'_idplh'];
- $kode_jurnal = $_REQUEST['kode_jurnal'];
- $nm_account = $_REQUEST['nm_account'];
- /*if($err=='' && $kode_jurnal =='' ) $err= 'Kode Akun belum diisi';
- if($err=='' && $nama_jurnal =='' ) $err= 'Nama Akun belum diisi';*/
- if($fmST == 0){ //input ref_jurnal
- if($err==''){
- $kode_jurnal = explode('.',$_REQUEST['kode_jurnal']);
- $ka=$kode_jurnal[0];
- $kb=$kode_jurnal[1];
- $kc=$kode_jurnal[2];
- $kd=$kode_jurnal[3];
- $ke=$kode_jurnal[4];
- $kf=$kode_jurnal[5];
- $aqry1 ="INSERT into ref_jurnal (ka,kb,kc,kd,ke,kf, nm_account)
- "."values('$ka','$kb','$kc','$kd','$ke','$kf','$nm_account')"; $cek .= $aqry1;
- $qry = mysql_query($aqry1);
- if($qry==FALSE) $err="Gagal Simpan Kode Akun Sudah Ada";
- }else{
- $err="Gagal Simpan Kode Akun Sudah Ada";
- }
- }elseif($fmST == 1){
- if($err==''){
- $kode_jurnal = explode('.',$idplh);
- $ka=$kode_jurnal[0];
- $kb=$kode_jurnal[1];
- $kc=$kode_jurnal[2];
- $kd=$kode_jurnal[3];
- $ke=$kode_jurnal[4];
- $kf=$kode_jurnal[5];
- $aqry2 = "UPDATE ref_jurnal
- set "." nm_account = '$nm_account' ".
- "WHERE concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf)= '".$_REQUEST['kode_jurnal']."'"; $cek .= $aqry2;
- $qry = mysql_query($aqry2);
- if($qry==FALSE) $err="Gagal Edit jurnal";
- }else{
- $err="Gagal menyimpan jurnal";
- }
- }else{
- /*if($err==''){
- $kode_barang = explode(' ',$idplh);
- $f=$kode_barang[0];
- $g=$kode_barang[1];
- $h=$kode_barang[2];
- $i=$kode_barang[3];
- $j=$kode_barang[4];
- $aqry1 = "INSERT into ref_hargabarang_persediaan (f,g,h,i,j,tahun_anggaran,harga)
- "."values('$f','$g','$h','$i','$j','$tahun_anggaran','$harga')"; $cek .= $aqry1;
- $qry = mysql_query($aqry1);
- }*/
- } //end else
- return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
- }
- function set_selector_other2($tipe){
- global $Main;
- $cek = ''; $err=''; $content=''; $json=TRUE;
- return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content, 'json'=>$json);
- }
- function set_selector_other($tipe){
- global $Main;
- $cek = ''; $err=''; $content=''; $json=TRUE;
- switch($tipe){
- case 'formBaru':{
- $fm = $this->setFormBaru();
- $cek = $fm['cek'];
- $err = $fm['err'];
- $content = $fm['content'];
- break;
- }
- case 'formEdit':{
- $fm = $this->setFormEdit();
- $cek = $fm['cek'];
- $err = $fm['err'];
- $content = $fm['content'];
- break;
- }
- case 'windowshow':{
- $fm = $this->windowShow();
- $cek = $fm['cek'];
- $err = $fm['err'];
- $content = $fm['content'];
- break;
- }
- case 'getdata':{
- $ref_pilihjurnal = $_REQUEST['id'];
- $kode_jurnal = explode(' ',$ref_pilihjurnal);
- $ka=$kode_jurnal[0];
- $kb=$kode_jurnal[1];
- $kc=$kode_jurnal[2];
- $kd=$kode_jurnal[3];
- $ke=$kode_jurnal[4];
- $kf=$kode_jurnal[5];
- //query ambil data ref_jurnal
- $get = mysql_fetch_array( mysql_query("select * from ref_jurnal where ka=$ka and kb=$kb and kc=$kc and kd=$kd and ke=$ke and kf=$kf"));
- $kode_account=$get['ka'].'.'.$get['kb'].'.'.$get['kc'].'.'.$get['kd'].'.'.$get['ke'].'.'.$get['kf'];
- $content = array('kode_account'=>$kode_account, 'nama_account'=>$get['nm_account']);//, 'tahun_account'=>$get['thn_akun']);
- break;
- }
- case 'simpan':{
- $get= $this->simpan();
- $cek = $get['cek'];
- $err = $get['err'];
- $content = $get['content'];
- break;
- }
- default:{
- $other = $this->set_selector_other2($tipe);
- $cek = $other['cek'];
- $err = $other['err'];
- $content=$other['content'];
- $json=$other['json'];
- break;
- }
- }//end switch
- return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content, 'json'=>$json);
- }
- function setPage_OtherScript(){
- $scriptload =
- "<script>
- $(document).ready(function(){
- ".$this->Prefix.".loading();
- });
- </script>";
- return
- "<script type='text/javascript' src='js/master/ref_aset/".strtolower($this->Prefix).".js' language='JavaScript' ></script>".
- $scriptload;
- }
- function Hapus_Validasi($id){//id -> multi id with space delimiter
- $errmsg ='';
- $kode_jurnal = explode(' ',$id);
- $ka=$kode_jurnal[0];
- $kb=$kode_jurnal[1];
- $kc=$kode_jurnal[2];
- $kd=$kode_jurnal[3];
- $ke=$kode_jurnal[4];
- $kf=$kode_jurnal[5];
- $quricoy="select count(*) as cnt from ref_barang where ka='$ka' and kb='$kb' and kc='$kc' and kd='$kd' and ke='$ke' and kf='$kf'";
- $dt3 = mysql_fetch_array(mysql_query($quricoy));
- $korong = $dt3 ['cnt'];
- if($korong>0){
- $korong;
- $errmsg = "ada kode barang tidak bisa di edit/hapus, karena masih ada rinciannya !";
- }
- if($errmsg=='' &&
- mysql_num_rows(mysql_query(
- "select Id from buku_induk where ka='$ka' and kb='$kb' and kc='$kc' and kd='$kd' and ke='$ke' and kf='$kf' ")
- ) >0 )
- { $errmsg = 'Gagal Hapus! KODE AKUN Sudah ada di Buku Induk!';}
- return $errmsg;
- }
- //form ==================================
- function setFormBaru(){
- //$cbid = $_REQUEST[$this->Prefix.'_cb'];
- //$c = $_REQUEST[$this->Prefix.'SkpdfmSKPD'];
- //$d = $_REQUEST[$this->Prefix.'SkpdfmUNIT'];
- //$e = $_REQUEST[$this->Prefix.'SkpdSUBUNIT'];
- $cek =$cbid[0];
- $this->form_idplh = $cbid[0];
- $kode = explode(' ',$this->form_idplh);
- $this->form_fmST = 0;
- $dt['readonly']='';
- $fmBIDANG = $_REQUEST['fmBIDANG'];
- $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
- $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
- $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
- if(!empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $dt['kode_jurnal']=$fmBIDANG.'.';
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.';
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.'.$fmSUBKELOMPOK.'.';
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && !empty($fmSUBSUBKELOMPOK))
- {
- $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.'.$fmSUBKELOMPOK.'.'.$fmSUBSUBKELOMPOK.'.';
- }
- $fm = $this->setForm($dt);
- return array ('cek'=>$cek.$fm['cek'], 'err'=>$fm['err'], 'content'=>$fm['content']);
- }
- function setFormEdit(){
- $cbid = $_REQUEST[$this->Prefix.'_cb'];
- //$c = $_REQUEST[$this->Prefix.'SkpdfmSKPD'];
- //$d = $_REQUEST[$this->Prefix.'SkpdfmUNIT'];
- //$e = $_REQUEST[$this->Prefix.'SkpdSUBUNIT'];
- $cek =$cbid[0];
- $this->form_idplh = $cbid[0];
- $kode = explode(' ',$this->form_idplh);
- $this->form_fmST = 1;
- //get data
- $ka=$kode[0];
- $kb=$kode[1];
- $kc=$kode[2];
- $kd=$kode[3];
- $ke=$kode[4];
- $kf=$kode[5];
- //$bulan=date('Y-m-')."1";
- //query ambil data ref_jurnal
- $aqry = "select * from ref_jurnal where concat(ka,'.',kb,'.',kc,'.',kd,'.'ke,'.',kf)='".$ka.'.'.$kb.'.'.$kc.'.'.$kd.'.'.$ke.'.'.$kf."'"; $cek.=$aqry;
- $dt = mysql_fetch_array(mysql_query($aqry));
- $dt['kode_jurnal']=$ka.'.'.$kb.'.'.$kc.'.'.$kd.'.'.$ke.'.'.$kf;
- $dt['readonly']='readonly';
- $fm = $this->setForm($dt);
- return array ('cek'=>$cek.$fm['cek'], 'err'=>$fm['err'], 'content'=>$fm['content']);
- }
- function setForm($dt){
- global $SensusTmp;
- $cek = ''; $err=''; $content='';
- $json = TRUE; //$ErrMsg = 'tes';
- $form_name = $this->Prefix.'_form';
- $this->form_width = 550;
- $this->form_height = 120;
- if ($this->form_fmST==0) {
- $this->form_caption = 'BARU';
- }else{
- $this->form_caption = 'EDIT';
- }
- //query ref_batal
- //$queryKB = "SELECT f,nama_barang FROM ref_barang_persediaan where f !=0 and g=0";
- //items ----------------------
- $this->form_fields = array(
- 'kode_jurnal' => array(
- 'label'=>'Kode Akun',
- 'labelWidth'=>100,
- 'value'=>"<input type='text' name='kode_jurnal' value='".$dt['kode_jurnal']."' size='17px' id='kode_jurnal' ".$dt['readonly'].">   <font color=red>*1.3.1.1.1.1</font>"
- ),
- 'nm_account' => array(
- 'label'=>'Nama Akun',
- 'labelWidth'=>100,
- 'value'=>$dt['nm_account'],
- 'type'=>'text',
- 'id'=>'nm_account',
- 'param'=>"style='width:250ppx;text-transform: uppercase;' size=50px"
- ),
- );
- //tombol
- $this->form_menubawah =
- "<input type='button' value='Simpan' onclick ='".$this->Prefix.".Simpan()' title='Batal kunjungan' >".
- "<input type='button' value='Batal' onclick ='".$this->Prefix.".Close()' >";
- $form = $this->genForm();
- $content = $form;//$content = 'content';
- return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
- }
- function windowShow(){
- $cek = ''; $err=''; $content='';
- $json = TRUE; //$ErrMsg = 'tes';
- $form_name = $this->FormName;
- //$fmSKPD = $_REQUEST['fmSKPD'];
- //$fmUNIT = $_REQUEST['fmUNIT'];
- //$fmSUBUNIT = $_REQUEST['fmSUBUNIT'];
- //$tahun_anggaran = $_REQUEST['tahun_anggaran'];
- //if($err=='' && ($fmSKPD=='00' || $fmSKPD=='') ) $err = 'Bidang belum diisi!';
- //if($err=='' && ($fmUNIT=='00' || $fmUNIT=='' )) $err = 'Asisten/OPD belum diisi!';
- //if($err=='' && ($fmSUBUNIT=='00' || $fmSUBUNIT=='')) $err='BIRO / UPTD/B belum diisi!';
- //if($err==''){
- $FormContent = $this->genDaftarInitial($fmSKPD, $fmUNIT, $fmSUBUNIT,$tahun_anggaran);
- $form = centerPage(
- "<form name='$form_name' id='$form_name' method='post' action=''>".
- createDialog(
- $form_name.'_div',
- $FormContent,
- 800,
- 500,
- 'Pilih Akun',
- '',
- "<input type='button' value='Pilih' onclick ='".$this->Prefix.".windowSave()' >".
- "<input type='button' value='Batal' onclick ='".$this->Prefix.".windowClose()' >".
- "<input type='hidden' id='".$this->Prefix."_idplh' name='".$this->Prefix."_idplh' value='$this->form_idplh' >".
- "<input type='hidden' id='".$this->Prefix."_fmST' name='".$this->Prefix."_fmST' value='$this->form_fmST' >".
- "<input type='hidden' id='sesi' name='sesi' value='$sesi' >"
- ,//$this->setForm_menubawah_content(),
- $this->form_menu_bawah_height
- ).
- "</form>"
- );
- $content = $form;//$content = 'content';
- //}
- return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
- }
- function genDaftarInitial($nm_account='', $height=''){
- $filterAkun = $_REQUEST['filterAkun'];
- $vOpsi = $this->genDaftarOpsi();
- return
- "<div id='{$this->Prefix}_cont_title' style='position:relative'></div>".
- "<div id='{$this->Prefix}_cont_opsi' style='position:relative'>".
- //"<input type='hidden' id='".$this->Prefix."SkpdfmSKPD' name='".$this->Prefix."SkpdfmSKPD' value='$fmSKPD'>".
- //"<input type='hidden' id='".$this->Prefix."SkpdfmUNIT' name='".$this->Prefix."SkpdfmUNIT' value='$fmUNIT'>".
- //"<input type='hidden' id='".$this->Prefix."SkpdfmSUBUNIT' name='".$this->Prefix."SkpdfmSUBUNIT' value='$fmSUBUNIT'>".
- "<input type='hidden' id='".$this->Prefix."nm_account' name='".$this->Prefix."nm_account' value='$nm_account'>".
- //"<input type='hidden' id='".$this->Prefix."tahun_anggaran' name='".$this->Prefix."tahun_anggaran' value='$tahun_anggaran'>".
- "<input type='hidden' id='filterAkun' name='filterAkun' value='".$filterAkun."'>".
- "</div>".
- "<div id=garis style='height:1;border-bottom:1px solid #E5E5E5;'></div>".
- "<div id=contain style='overflow:auto;height:$height;'>".
- //"<div id=contain style='overflow:auto;height:256;'>".
- "<div id='{$this->Prefix}_cont_daftar' style='position:relative' >".
- "</div>
- </div>".
- "<div id='{$this->Prefix}_cont_hal' style='position:relative'>".
- "<input type='hidden' id='".$this->Prefix."_hal' name='".$this->Prefix."_hal' value='1'>".
- "</div>";
- }
- //daftar =================================
- function setKolomHeader($Mode=1, $Checkbox=''){
- $NomorColSpan = $Mode==1? 2: 1;
- $fmBIDANG = $_REQUEST['fmBIDANG'];
- $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
- $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
- $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
- $headerTable =
- "<thead>
- <tr>
- <th class='th01' width='50' >No.</th>
- $Checkbox
- <th class='th01' align='center' width='100'>Kode Akun</th>
- <th class='th01' align='center' width='800'>Nama Akun</th>
- </tr>
- </thead>";
- return $headerTable;
- }
- function setKolomData($no, $isi, $Mode, $TampilCheckBox){
- global $Ref;
- global $Main;
- $isi = array_map('utf8_encode', $isi);
- $kode_jurnal=$isi['ka'].'.'.$isi['kb'].'.'.$isi['kc'].'.'.$isi['kd'].'.'.$isi['ke'].'.'.$isi['kf'];
- $Koloms = array();
- $Koloms[] = array('align="center" width=""', $no.'.' );
- if ($Mode == 1) $Koloms[] = array(" align='center' ", $TampilCheckBox);
- $Koloms[] = array('align="center" width="" ',$kode_jurnal);
- $Koloms[] = array('align="left" width=""',$isi['nm_account']);
- return $Koloms;
- }
- function genDaftarOpsi(){
- global $Ref, $Main, $HTTP_COOKIE_VARS;
- $cek = '';
- $fmBIDANG = cekPOST('fmBIDANG');
- $fmKELOMPOK = cekPOST('fmKELOMPOK');
- $fmSUBKELOMPOK = cekPOST('fmSUBKELOMPOK');
- $fmSUBSUBKELOMPOK = cekPOST('fmSUBSUBKELOMPOK');
- $fmKODE = cekPOST('fmKODE');
- $fmAKUN = cekPOST('fmAKUN');
- //$fmThnAnggaran= $_COOKIE['coThnAnggaran'];
- $filterAkun = cekPOST('filterAkun');
- //$fmPILCARI = $_REQUEST['fmPILCARI'];
- //$fmPILCARIvalue = $_REQUEST['fmPILCARIvalue'];
- //$fmORDER1 = cekPOST('fmORDER1');
- //$fmDESC1 = cekPOST('fmDESC1');
- $arr = array(
- //array('selectAll','Semua'),
- array('selectfg','Kode Barang'),
- array('selectbarang','Nama Barang'),
- );
- //data order ------------------------------
- $arrOrder = array(
- array('1','Kode Barang'),
- array('2','Nama Barang'),
- );
- /*if($Main->WITH_THN_ANGGARAN){
- $aqry1 = "select Max(thn_akun) as thnMax from ref_jurnal where
- thn_akun<=$fmThnAnggaran"; $cek.=$aqry1;
- $qry1=mysql_query($aqry1);
- $qry_jurnal=mysql_fetch_array($qry1);
- $thn_akun=$qry_jurnal['thnMax'];
- //$arrKondisi[] = " thn_akun = '$thn_akun'";
- $vthnakun = " and thn_akun=$thn_akun ";
- } */
- if(!empty($_POST['filterAkun'])) {
- $arrakun = explode('.',$filterAkun);
- if($arrakun['0'] <> '') {
- $fmBIDANG = $arrakun['0'];
- $get = mysql_fetch_array(mysql_query(
- "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='0'"));// $vthnakun "
- $listBidang = $get['ka'].'. '. $get['nm_account']."<input type='hidden' id= 'fmBIDANG' name='fmBIDANG' value='$fmBIDANG' >";
- }
- if($arrakun['1'] <> '') {
- $fmKELOMPOK = $arrakun['1'];
- $get = mysql_fetch_array(mysql_query(
- "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='$fmKELOMPOK' and kc='0'")); //$vthnakun
- $listKelompok = $get['ka'].'.'.$get['kb'].'. '. $get['nm_account']."<input type='hidden' id= 'fmKELOMPOK' name='fmKELOMPOK' value='$fmKELOMPOK' >";
- }
- if($arrakun['2'] <> ''){
- $fmSUBKELOMPOK = $arrakun['2'];
- $get = mysql_fetch_array(mysql_query(
- "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='$fmKELOMPOK' and kc='$fmSUBKELOMPOK' and kd='0'"));// $vthnakun
- $listSubKelompok = $get['ka'].'.'.$get['kb'].'.'.$get['kc'].'. '.$get['nm_account']."<input type='hidden' id= 'fmSUBKELOMPOK' name='fmSUBKELOMPOK' value='$fmSUBKELOMPOK' >";
- }
- if($arrakun['3'] <> '') {
- $fmSUBSUBKELOMPOK = $arrakun['3'];
- $get = mysql_fetch_array(mysql_query(
- "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='$fmKELOMPOK' and kc='$fmSUBKELOMPOK' and kd='$fmSUBSUBKELOMPOK' and ke='0'"));//$vthnakun
- $listSubSubKelompok = $get['ka'].'. '.$get['kb'].'.'.$get['kc'].'.'.$get['kd'].'. '.$get['nm_account']."<input type='hidden' id= 'fmSUBSUBKELOMPOK' name='fmSUBSUBKELOMPOK' value='$fmSUBSUBKELOMPOK' >";
- }
- //if($arr['4'] <> '') $fmBIDANG = $arr['4'];
- //if($arr['5'] <> '') $fmBIDANG = $arr['5'];
- //$konFiltAkun = " and concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['filterAkun']."%'";
- }
- $cek .= " select ka,nm_account from ref_jurnal where ka<>'0' and kb='0'";// $vthnakun; ";
- if($arrakun['0'] == '') $listBidang = cmbQuery1("fmBIDANG",$fmBIDANG,"select ka,nm_account from ref_jurnal where ka<>'0' and kb='0' ","onChange=\"$this->Prefix.refreshList(true)\"",'Pilih','');
- if($arrakun['1'] == '') $listKelompok = cmbQuery1("fmKELOMPOK",$fmKELOMPOK,"select kb,nm_account from ref_jurnal where ka='$fmBIDANG' and kb<>'0' and kc='0' ","onChange=\"$this->Prefix.refreshList(true)\"",'Pilih','');
- if($arrakun['2'] == '') $listSubKelompok = cmbQuery1("fmSUBKELOMPOK",$fmSUBKELOMPOK,"select kc,nm_account from ref_jurnal where ka='$fmBIDANG' and kb ='$fmKELOMPOK' and kc<>'0' and kd='0' ","onChange=\"$this->Prefix.refreshList(true)\"",'Pilih','');
- if($arrakun['3'] == '') $listSubSubKelompok = cmbQuery1("fmSUBSUBKELOMPOK",$fmSUBSUBKELOMPOK,"select kd,nm_account from ref_jurnal where ka='$fmBIDANG' and kb ='$fmKELOMPOK' and kc = '$fmSUBKELOMPOK' and kd<>'0' and ke='0' ","onChange=\"$this->Prefix.refreshList(true)\"",'Pilih','');
- if($Main->SHOW_CEK== FALSE) $cek = '';
- $TampilOpt =
- //"<tr><td>".
- "<div style='display:none;'> $cek </div>".
- "<div class='FilterBar'>".
- //<table style='width:100%'><tbody><tr><td align='left'>
- //<table cellspacing='0' cellpadding='0' border='0' style='height:28'>
- //<tbody><tr valign='middle'>
- // <td align='left' style='padding:1 8 0 8; '>".
- //"<div style='float:left;padding: 2 8 0 0;height:20;padding: 4 4 0 0'>Urutkan : </div>".
- "<table style='width:100%'>
- <tr>
- <td style='width:150px'>BIDANG</td><td style='width:10px'>:</td>
- <td>".//$fmThnAnggaran - $aqry1 - ".
- //"select ka,nm_account from ref_jurnal where ka<>'0' and kb='0' $vthnakun ".
- $listBidang.
- "</td>
- </tr><tr>
- <td>KELOMPOK</td><td>:</td>
- <td>".
- $listKelompok.
- "</td>
- </tr><tr>
- <td>SUB KELOMPOK</td><td>:</td>
- <td>".
- $listSubKelompok.
- "</td>
- </tr><tr>
- <td>SUB SUB KELOMPOK</td><td>:</td>
- <td>".
- $listSubSubKelompok.
- "</td>
- </tr>
- </table>".
- "</div>".
- "<div class='FilterBar'>".
- "<table style='width:100%'>
- <tr><td>
- Kode Akun : <input type='text' id='fmKODE' name='fmKODE' value='".$fmKODE."' maxlength='' size=10px> 
- Nama Akun : <input type='text' id='fmAKUN' name='fmAKUN' value='".$fmAKUN."' size=30px> ".
- "<input type='hidden' id='filterAkun' name='filterAkun' value='".$filterAkun."'>".
- "<input type='button' id='btTampil' value='Tampilkan' onclick='".$this->Prefix.".refreshList(true)'>
- </td></tr>
- </table>".
- "</div>".
- "<input type='hidden' id='fmORDER18' name='fmORDER18' value='".$fmORDER18."'>".
- "<input type='hidden' id='fmORDER19' name='fmORDER19' value='".$fmORDER19."'>"
- ;
- return array('TampilOpt'=>$TampilOpt);
- }
- function getDaftarOpsi($Mode=1){
- global $Main, $HTTP_COOKIE_VARS;
- $UID = $_COOKIE['coID'];
- //$thn_akun = $HTTP_COOKIE_VARS['coThnAnggaran'];
- //kondisi -----------------------------------
- $arrKondisi = array();
- $fmPILCARI = $_REQUEST['fmPILCARI'];
- $fmPILCARIvalue = $_REQUEST['fmPILCARIvalue'];
- $fmBIDANG = $_REQUEST['fmBIDANG'];
- $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
- $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
- $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
- //$fmThnAnggaran= $_COOKIE['coThnAnggaran'];
- $filterAkun = cekPOST('filterAkun');
- /*if($Main->WITH_THN_ANGGARAN){
- $aqry1 = "select Max(thn_akun) as thnMax from ref_jurnal where
- thn_akun<='$fmThnAnggaran'";
- $qry1=mysql_query($aqry1);
- $qry_jurnal=mysql_fetch_array($qry1);
- $thn_akun=$qry_jurnal['thnMax'];
- $arrKondisi[] = " thn_akun = '$thn_akun'";
- }*/
- //$fmKODE = $_REQUEST['fmKODE'];
- //$fmAKUN = $_REQUEST['fmAKUN'];
- /*switch($fmPILCARI){
- case 'selectfg': $arrKondisi[] = " concat(f,g) like '%$fmPILCARIvalue%'"; break;
- case 'selectbarang': $arrKondisi[] = " nama_barang like '%".$fmPILCARIvalue."%'"; break;
- }*/
- if(empty($fmBIDANG)) {
- $fmKELOMPOK = '';
- $fmSUBKELOMPOK='';
- $fmSUBSUBKELOMPOK='';
- }
- if(empty($fmKELOMPOK)) {
- $fmSUBKELOMPOK='';
- $fmSUBSUBKELOMPOK='';
- }
- if(empty($fmSUBKELOMPOK)) {
- $fmSUBSUBKELOMPOK='';
- }
- if(empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- //$arrKondisi[]= "ka !=00 and kb=00 and kc=00 and kd=00 and ke=00";
- }
- elseif(!empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $arrKondisi[]= "ka =$fmBIDANG";//$arrKondisi[]= "ka =$fmBIDANG and kb!=00 and kc=00 and kd=00 and ke=00";
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK";//$arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc!=00 and kd=00 and ke=00";
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
- {
- $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK";//$arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK and kd!=00 and ke=00";
- }
- elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && !empty($fmSUBSUBKELOMPOK))
- {
- $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK and kd=$fmSUBSUBKELOMPOK";
- }
- if(!empty($_POST['fmKODE'])) $arrKondisi[] = " concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['fmKODE']."%'";
- if(!empty($_POST['fmAKUN'])) $arrKondisi[] = " nm_account like '%".$_POST['fmAKUN']."%'";
- if(!empty($_POST['filterAkun'])) $arrKondisi[] = " concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['filterAkun']."%'";
- $Kondisi= join(' and ',$arrKondisi);
- $Kondisi = $Kondisi =='' ? '':' Where '.$Kondisi;
- //Order -------------------------------------
- $fmORDER1 = cekPOST('fmORDER1');
- $fmDESC1 = cekPOST('fmDESC1');
- $Asc1 = $fmDESC1 ==''? '': 'desc';
- $arrOrders = array();
- switch($fmORDER1){
- case '': $arrOrders[] = " concat(ka,kb,kc,kd,ke,kf) $ASC " ;break;
- case '1': $arrOrders[] = " concat(ka,kb,kc,kd,ke, kf) $Asc1 " ;break;
- case '2': $arrOrders[] = " nama_barang $Asc1 " ;break;
- }
- $Order= join(',',$arrOrders);
- $OrderDefault = ' order by ka,kb,kc,kd,ke,kf ';// Order By no_terima desc ';
- $Order = $Order ==''? $OrderDefault : ' Order By '.$Order;
- //}
- //$Order ="";
- //limit --------------------------------------
- /**$HalDefault=cekPOST($this->Prefix.'_hal',1); //Cat:Settingan Lama
- $Limit = " limit ".(($HalDefault *1) - 1) * $Main->PagePerHal.",".$Main->PagePerHal; //$LimitHal = '';
- $Limit = $Mode == 3 ? '': $Limit;
- //noawal ------------------------------------
- $NoAwal= $Main->PagePerHal * (($HalDefault*1) - 1);
- $NoAwal = $Mode == 3 ? 0: $NoAwal;
- **/
- $pagePerHal = $this->pagePerHal =='' ? $Main->PagePerHal: $this->pagePerHal;
- $HalDefault=cekPOST($this->Prefix.'_hal',1);
- //$Limit = " limit ".(($HalDefault *1) - 1) * $Main->PagePerHal.",".$Main->PagePerHal; //$LimitHal = '';
- $Limit = " limit ".(($HalDefault *1) - 1) * $pagePerHal.",".$pagePerHal; //$LimitHal = '';
- $Limit = $Mode == 3 ? '': $Limit;
- //noawal ------------------------------------
- $NoAwal= $pagePerHal * (($HalDefault*1) - 1);
- $NoAwal = $Mode == 3 ? 0: $NoAwal;
- return array('Kondisi'=>$Kondisi, 'Order'=>$Order ,'Limit'=>$Limit, 'NoAwal'=>$NoAwal);
- }
- }
- $RefJurnal = new RefJurnalObj();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement