Advertisement
Guest User

gblk

a guest
Mar 24th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.22 KB | None | 0 0
  1. <?php
  2.  
  3. class RefJurnalObj extends DaftarObj2{
  4. var $Prefix = 'RefJurnal';
  5. var $elCurrPage="HalDefault";
  6. var $SHOW_CEK = TRUE;
  7. var $TblName = 'ref_jurnal'; //daftar
  8. var $TblName_Hapus = 'ref_jurnal';
  9. var $MaxFlush = 10;
  10. var $TblStyle = array( 'koptable', 'cetak','cetak'); //berdasar mode
  11. var $ColStyle = array( 'GarisDaftar', 'GarisCetak','GarisCetak');
  12. var $KeyFields = array('ka','kb','kc','kd','ke','kf');
  13. var $FieldSum = array();//array('jml_harga');
  14. var $SumValue = array();
  15. var $FieldSum_Cp1 = array( 14, 13, 13);//berdasar mode
  16. var $FieldSum_Cp2 = array( 1, 1, 1);
  17. var $checkbox_rowspan = 1;
  18. var $PageTitle = 'Referensi Data';
  19. var $PageIcon = 'images/masterData_01.gif';
  20. var $pagePerHal ='';
  21. var $cetak_xls=TRUE ;
  22. var $fileNameExcel='usulansk.xls';
  23. var $Cetak_Judul = 'JURNAL';
  24. var $Cetak_Mode=2;
  25. var $Cetak_WIDTH = '30cm';
  26. var $Cetak_OtherHTMLHead;
  27. var $FormName = 'RefJurnalForm';
  28.  
  29. function setTitle(){
  30. return 'Daftar Akun';
  31. }
  32. function setMenuEdit(){
  33. return
  34. "<td>".genPanelIcon("javascript:".$this->Prefix.".Baru()","new_f2.png","Baru",'Baru')."</td>".
  35. "<td>".genPanelIcon("javascript:".$this->Prefix.".Edit()","edit_f2.png","Edit", 'Edit')."</td>".
  36. "<td>".genPanelIcon("javascript:".$this->Prefix.".Hapus()","delete_f2.png","Hapus", 'Hapus').
  37. "</td>";
  38. }
  39. function setMenuView(){
  40. return "";
  41. }
  42. function setCetak_Header($Mode=''){
  43. global $Main, $HTTP_COOKIE_VARS;
  44.  
  45. //$fmSKPD = cekPOST($this->Prefix.'SkpdfmSKPD'); //echo 'fmskpd='.$fmSKPD;
  46. //$fmUNIT = cekPOST($this->Prefix.'SkpdfmUNIT');
  47. //$fmSUBUNIT = cekPOST($this->Prefix.'SkpdfmSUBUNIT');
  48. return
  49. "<table style='width:100%' border=\"0\">
  50. <tr>
  51. <td class=\"judulcetak\">".$this->setCetakTitle()."</td>
  52. </tr>
  53. </table>";
  54. /*"<table width=\"100%\" border=\"0\">
  55. <tr>
  56. <td class=\"subjudulcetak\">".PrintSKPD2($fmSKPD, $fmUNIT, $fmSUBUNIT)."</td>
  57. </tr>
  58. </table><br>";*/
  59. }
  60.  
  61. //function setPage_IconPage(){ return 'images/masterData_ico.gif'; }
  62. function simpan(){
  63. global $HTTP_COOKIE_VARS;
  64. global $Main;
  65. $uid = $HTTP_COOKIE_VARS['coID'];
  66. $cek = ''; $err=''; $content=''; $json=TRUE;
  67. //get data -----------------
  68. $fmST = $_REQUEST[$this->Prefix.'_fmST'];
  69. $idplh = $_REQUEST[$this->Prefix.'_idplh'];
  70. $kode_jurnal = $_REQUEST['kode_jurnal'];
  71. $nm_account = $_REQUEST['nm_account'];
  72. /*if($err=='' && $kode_jurnal =='' ) $err= 'Kode Akun belum diisi';
  73. if($err=='' && $nama_jurnal =='' ) $err= 'Nama Akun belum diisi';*/
  74.  
  75. if($fmST == 0){ //input ref_jurnal
  76. if($err==''){
  77. $kode_jurnal = explode('.',$_REQUEST['kode_jurnal']);
  78. $ka=$kode_jurnal[0];
  79. $kb=$kode_jurnal[1];
  80. $kc=$kode_jurnal[2];
  81. $kd=$kode_jurnal[3];
  82. $ke=$kode_jurnal[4];
  83. $kf=$kode_jurnal[5];
  84. $aqry1 ="INSERT into ref_jurnal (ka,kb,kc,kd,ke,kf, nm_account)
  85. "."values('$ka','$kb','$kc','$kd','$ke','$kf','$nm_account')"; $cek .= $aqry1;
  86. $qry = mysql_query($aqry1);
  87. if($qry==FALSE) $err="Gagal Simpan Kode Akun Sudah Ada";
  88.  
  89. }else{
  90. $err="Gagal Simpan Kode Akun Sudah Ada";
  91. }
  92. }elseif($fmST == 1){
  93. if($err==''){
  94. $kode_jurnal = explode('.',$idplh);
  95. $ka=$kode_jurnal[0];
  96. $kb=$kode_jurnal[1];
  97. $kc=$kode_jurnal[2];
  98. $kd=$kode_jurnal[3];
  99. $ke=$kode_jurnal[4];
  100. $kf=$kode_jurnal[5];
  101.  
  102. $aqry2 = "UPDATE ref_jurnal
  103. set "." nm_account = '$nm_account' ".
  104. "WHERE concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf)= '".$_REQUEST['kode_jurnal']."'"; $cek .= $aqry2;
  105. $qry = mysql_query($aqry2);
  106. if($qry==FALSE) $err="Gagal Edit jurnal";
  107. }else{
  108. $err="Gagal menyimpan jurnal";
  109. }
  110. }else{
  111. /*if($err==''){
  112. $kode_barang = explode(' ',$idplh);
  113. $f=$kode_barang[0];
  114. $g=$kode_barang[1];
  115. $h=$kode_barang[2];
  116. $i=$kode_barang[3];
  117. $j=$kode_barang[4];
  118.  
  119. $aqry1 = "INSERT into ref_hargabarang_persediaan (f,g,h,i,j,tahun_anggaran,harga)
  120. "."values('$f','$g','$h','$i','$j','$tahun_anggaran','$harga')"; $cek .= $aqry1;
  121. $qry = mysql_query($aqry1);
  122.  
  123. }*/
  124. } //end else
  125.  
  126. return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
  127. }
  128.  
  129. function set_selector_other2($tipe){
  130. global $Main;
  131. $cek = ''; $err=''; $content=''; $json=TRUE;
  132.  
  133. return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content, 'json'=>$json);
  134. }
  135.  
  136. function set_selector_other($tipe){
  137. global $Main;
  138. $cek = ''; $err=''; $content=''; $json=TRUE;
  139.  
  140. switch($tipe){
  141.  
  142. case 'formBaru':{
  143. $fm = $this->setFormBaru();
  144. $cek = $fm['cek'];
  145. $err = $fm['err'];
  146. $content = $fm['content'];
  147. break;
  148. }
  149.  
  150. case 'formEdit':{
  151. $fm = $this->setFormEdit();
  152. $cek = $fm['cek'];
  153. $err = $fm['err'];
  154. $content = $fm['content'];
  155. break;
  156. }
  157.  
  158. case 'windowshow':{
  159. $fm = $this->windowShow();
  160. $cek = $fm['cek'];
  161. $err = $fm['err'];
  162. $content = $fm['content'];
  163. break;
  164. }
  165.  
  166. case 'getdata':{
  167.  
  168. $ref_pilihjurnal = $_REQUEST['id'];
  169. $kode_jurnal = explode(' ',$ref_pilihjurnal);
  170. $ka=$kode_jurnal[0];
  171. $kb=$kode_jurnal[1];
  172. $kc=$kode_jurnal[2];
  173. $kd=$kode_jurnal[3];
  174. $ke=$kode_jurnal[4];
  175. $kf=$kode_jurnal[5];
  176. //query ambil data ref_jurnal
  177. $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"));
  178. $kode_account=$get['ka'].'.'.$get['kb'].'.'.$get['kc'].'.'.$get['kd'].'.'.$get['ke'].'.'.$get['kf'];
  179.  
  180. $content = array('kode_account'=>$kode_account, 'nama_account'=>$get['nm_account']);//, 'tahun_account'=>$get['thn_akun']);
  181. break;
  182. }
  183.  
  184.  
  185. case 'simpan':{
  186. $get= $this->simpan();
  187. $cek = $get['cek'];
  188. $err = $get['err'];
  189. $content = $get['content'];
  190. break;
  191. }
  192.  
  193. default:{
  194. $other = $this->set_selector_other2($tipe);
  195. $cek = $other['cek'];
  196. $err = $other['err'];
  197. $content=$other['content'];
  198. $json=$other['json'];
  199. break;
  200. }
  201. }//end switch
  202.  
  203. return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content, 'json'=>$json);
  204. }
  205.  
  206. function setPage_OtherScript(){
  207. $scriptload =
  208.  
  209. "<script>
  210. $(document).ready(function(){
  211. ".$this->Prefix.".loading();
  212. });
  213.  
  214. </script>";
  215.  
  216. return
  217. "<script type='text/javascript' src='js/master/ref_aset/".strtolower($this->Prefix).".js' language='JavaScript' ></script>".
  218. $scriptload;
  219. }
  220. function Hapus_Validasi($id){//id -> multi id with space delimiter
  221. $errmsg ='';
  222. $kode_jurnal = explode(' ',$id);
  223. $ka=$kode_jurnal[0];
  224. $kb=$kode_jurnal[1];
  225. $kc=$kode_jurnal[2];
  226. $kd=$kode_jurnal[3];
  227. $ke=$kode_jurnal[4];
  228. $kf=$kode_jurnal[5];
  229.  
  230. $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'";
  231. $dt3 = mysql_fetch_array(mysql_query($quricoy));
  232. $korong = $dt3 ['cnt'];
  233.  
  234. if($korong>0){
  235.  
  236. $korong;
  237. $errmsg = "ada kode barang tidak bisa di edit/hapus, karena masih ada rinciannya !";
  238. }
  239.  
  240. if($errmsg=='' &&
  241. mysql_num_rows(mysql_query(
  242. "select Id from buku_induk where ka='$ka' and kb='$kb' and kc='$kc' and kd='$kd' and ke='$ke' and kf='$kf' ")
  243. ) >0 )
  244. { $errmsg = 'Gagal Hapus! KODE AKUN Sudah ada di Buku Induk!';}
  245. return $errmsg;
  246. }
  247. //form ==================================
  248. function setFormBaru(){
  249. //$cbid = $_REQUEST[$this->Prefix.'_cb'];
  250. //$c = $_REQUEST[$this->Prefix.'SkpdfmSKPD'];
  251. //$d = $_REQUEST[$this->Prefix.'SkpdfmUNIT'];
  252. //$e = $_REQUEST[$this->Prefix.'SkpdSUBUNIT'];
  253. $cek =$cbid[0];
  254. $this->form_idplh = $cbid[0];
  255. $kode = explode(' ',$this->form_idplh);
  256. $this->form_fmST = 0;
  257. $dt['readonly']='';
  258. $fmBIDANG = $_REQUEST['fmBIDANG'];
  259. $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
  260. $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
  261. $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
  262. if(!empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  263. {
  264. $dt['kode_jurnal']=$fmBIDANG.'.';
  265. }
  266. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  267. {
  268. $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.';
  269. }
  270. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  271. {
  272. $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.'.$fmSUBKELOMPOK.'.';
  273. }
  274. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && !empty($fmSUBSUBKELOMPOK))
  275. {
  276. $dt['kode_jurnal']=$fmBIDANG.'.'.$fmKELOMPOK.'.'.$fmSUBKELOMPOK.'.'.$fmSUBSUBKELOMPOK.'.';
  277. }
  278. $fm = $this->setForm($dt);
  279. return array ('cek'=>$cek.$fm['cek'], 'err'=>$fm['err'], 'content'=>$fm['content']);
  280. }
  281.  
  282. function setFormEdit(){
  283. $cbid = $_REQUEST[$this->Prefix.'_cb'];
  284. //$c = $_REQUEST[$this->Prefix.'SkpdfmSKPD'];
  285. //$d = $_REQUEST[$this->Prefix.'SkpdfmUNIT'];
  286. //$e = $_REQUEST[$this->Prefix.'SkpdSUBUNIT'];
  287. $cek =$cbid[0];
  288. $this->form_idplh = $cbid[0];
  289. $kode = explode(' ',$this->form_idplh);
  290. $this->form_fmST = 1;
  291. //get data
  292. $ka=$kode[0];
  293. $kb=$kode[1];
  294. $kc=$kode[2];
  295. $kd=$kode[3];
  296. $ke=$kode[4];
  297. $kf=$kode[5];
  298. //$bulan=date('Y-m-')."1";
  299. //query ambil data ref_jurnal
  300. $aqry = "select * from ref_jurnal where concat(ka,'.',kb,'.',kc,'.',kd,'.'ke,'.',kf)='".$ka.'.'.$kb.'.'.$kc.'.'.$kd.'.'.$ke.'.'.$kf."'"; $cek.=$aqry;
  301. $dt = mysql_fetch_array(mysql_query($aqry));
  302. $dt['kode_jurnal']=$ka.'.'.$kb.'.'.$kc.'.'.$kd.'.'.$ke.'.'.$kf;
  303. $dt['readonly']='readonly';
  304. $fm = $this->setForm($dt);
  305.  
  306. return array ('cek'=>$cek.$fm['cek'], 'err'=>$fm['err'], 'content'=>$fm['content']);
  307. }
  308.  
  309. function setForm($dt){
  310. global $SensusTmp;
  311. $cek = ''; $err=''; $content='';
  312.  
  313. $json = TRUE; //$ErrMsg = 'tes';
  314.  
  315. $form_name = $this->Prefix.'_form';
  316. $this->form_width = 550;
  317. $this->form_height = 120;
  318. if ($this->form_fmST==0) {
  319. $this->form_caption = 'BARU';
  320. }else{
  321. $this->form_caption = 'EDIT';
  322. }
  323.  
  324.  
  325. //query ref_batal
  326. //$queryKB = "SELECT f,nama_barang FROM ref_barang_persediaan where f !=0 and g=0";
  327. //items ----------------------
  328. $this->form_fields = array(
  329. 'kode_jurnal' => array(
  330. 'label'=>'Kode Akun',
  331. 'labelWidth'=>100,
  332. 'value'=>"<input type='text' name='kode_jurnal' value='".$dt['kode_jurnal']."' size='17px' id='kode_jurnal' ".$dt['readonly'].">&nbsp&nbsp <font color=red>*1.3.1.1.1.1</font>"
  333. ),
  334.  
  335. 'nm_account' => array(
  336. 'label'=>'Nama Akun',
  337. 'labelWidth'=>100,
  338. 'value'=>$dt['nm_account'],
  339. 'type'=>'text',
  340. 'id'=>'nm_account',
  341. 'param'=>"style='width:250ppx;text-transform: uppercase;' size=50px"
  342. ),
  343.  
  344. );
  345. //tombol
  346. $this->form_menubawah =
  347. "<input type='button' value='Simpan' onclick ='".$this->Prefix.".Simpan()' title='Batal kunjungan' >".
  348. "<input type='button' value='Batal' onclick ='".$this->Prefix.".Close()' >";
  349.  
  350. $form = $this->genForm();
  351. $content = $form;//$content = 'content';
  352. return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
  353. }
  354.  
  355. function windowShow(){
  356. $cek = ''; $err=''; $content='';
  357. $json = TRUE; //$ErrMsg = 'tes';
  358. $form_name = $this->FormName;
  359.  
  360. //$fmSKPD = $_REQUEST['fmSKPD'];
  361. //$fmUNIT = $_REQUEST['fmUNIT'];
  362. //$fmSUBUNIT = $_REQUEST['fmSUBUNIT'];
  363. //$tahun_anggaran = $_REQUEST['tahun_anggaran'];
  364.  
  365. //if($err=='' && ($fmSKPD=='00' || $fmSKPD=='') ) $err = 'Bidang belum diisi!';
  366. //if($err=='' && ($fmUNIT=='00' || $fmUNIT=='' )) $err = 'Asisten/OPD belum diisi!';
  367. //if($err=='' && ($fmSUBUNIT=='00' || $fmSUBUNIT=='')) $err='BIRO / UPTD/B belum diisi!';
  368. //if($err==''){
  369. $FormContent = $this->genDaftarInitial($fmSKPD, $fmUNIT, $fmSUBUNIT,$tahun_anggaran);
  370. $form = centerPage(
  371. "<form name='$form_name' id='$form_name' method='post' action=''>".
  372. createDialog(
  373. $form_name.'_div',
  374. $FormContent,
  375. 800,
  376. 500,
  377. 'Pilih Akun',
  378. '',
  379. "<input type='button' value='Pilih' onclick ='".$this->Prefix.".windowSave()' >".
  380. "<input type='button' value='Batal' onclick ='".$this->Prefix.".windowClose()' >".
  381. "<input type='hidden' id='".$this->Prefix."_idplh' name='".$this->Prefix."_idplh' value='$this->form_idplh' >".
  382. "<input type='hidden' id='".$this->Prefix."_fmST' name='".$this->Prefix."_fmST' value='$this->form_fmST' >".
  383. "<input type='hidden' id='sesi' name='sesi' value='$sesi' >"
  384. ,//$this->setForm_menubawah_content(),
  385. $this->form_menu_bawah_height
  386. ).
  387. "</form>"
  388. );
  389. $content = $form;//$content = 'content';
  390. //}
  391.  
  392. return array ('cek'=>$cek, 'err'=>$err, 'content'=>$content);
  393. }
  394.  
  395. function genDaftarInitial($nm_account='', $height=''){
  396. $filterAkun = $_REQUEST['filterAkun'];
  397. $vOpsi = $this->genDaftarOpsi();
  398. return
  399. "<div id='{$this->Prefix}_cont_title' style='position:relative'></div>".
  400. "<div id='{$this->Prefix}_cont_opsi' style='position:relative'>".
  401. //"<input type='hidden' id='".$this->Prefix."SkpdfmSKPD' name='".$this->Prefix."SkpdfmSKPD' value='$fmSKPD'>".
  402. //"<input type='hidden' id='".$this->Prefix."SkpdfmUNIT' name='".$this->Prefix."SkpdfmUNIT' value='$fmUNIT'>".
  403. //"<input type='hidden' id='".$this->Prefix."SkpdfmSUBUNIT' name='".$this->Prefix."SkpdfmSUBUNIT' value='$fmSUBUNIT'>".
  404. "<input type='hidden' id='".$this->Prefix."nm_account' name='".$this->Prefix."nm_account' value='$nm_account'>".
  405. //"<input type='hidden' id='".$this->Prefix."tahun_anggaran' name='".$this->Prefix."tahun_anggaran' value='$tahun_anggaran'>".
  406. "<input type='hidden' id='filterAkun' name='filterAkun' value='".$filterAkun."'>".
  407. "</div>".
  408. "<div id=garis style='height:1;border-bottom:1px solid #E5E5E5;'></div>".
  409. "<div id=contain style='overflow:auto;height:$height;'>".
  410. //"<div id=contain style='overflow:auto;height:256;'>".
  411. "<div id='{$this->Prefix}_cont_daftar' style='position:relative' >".
  412. "</div>
  413. </div>".
  414. "<div id='{$this->Prefix}_cont_hal' style='position:relative'>".
  415. "<input type='hidden' id='".$this->Prefix."_hal' name='".$this->Prefix."_hal' value='1'>".
  416. "</div>";
  417. }
  418.  
  419. //daftar =================================
  420. function setKolomHeader($Mode=1, $Checkbox=''){
  421. $NomorColSpan = $Mode==1? 2: 1;
  422. $fmBIDANG = $_REQUEST['fmBIDANG'];
  423. $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
  424. $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
  425. $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
  426. $headerTable =
  427. "<thead>
  428. <tr>
  429. <th class='th01' width='50' >No.</th>
  430. $Checkbox
  431. <th class='th01' align='center' width='100'>Kode Akun</th>
  432. <th class='th01' align='center' width='800'>Nama Akun</th>
  433. </tr>
  434. </thead>";
  435.  
  436. return $headerTable;
  437. }
  438.  
  439. function setKolomData($no, $isi, $Mode, $TampilCheckBox){
  440. global $Ref;
  441. global $Main;
  442. $isi = array_map('utf8_encode', $isi);
  443.  
  444. $kode_jurnal=$isi['ka'].'.'.$isi['kb'].'.'.$isi['kc'].'.'.$isi['kd'].'.'.$isi['ke'].'.'.$isi['kf'];
  445. $Koloms = array();
  446. $Koloms[] = array('align="center" width=""', $no.'.' );
  447. if ($Mode == 1) $Koloms[] = array(" align='center' ", $TampilCheckBox);
  448. $Koloms[] = array('align="center" width="" ',$kode_jurnal);
  449. $Koloms[] = array('align="left" width=""',$isi['nm_account']);
  450. return $Koloms;
  451. }
  452.  
  453. function genDaftarOpsi(){
  454. global $Ref, $Main, $HTTP_COOKIE_VARS;
  455.  
  456. $cek = '';
  457.  
  458. $fmBIDANG = cekPOST('fmBIDANG');
  459. $fmKELOMPOK = cekPOST('fmKELOMPOK');
  460. $fmSUBKELOMPOK = cekPOST('fmSUBKELOMPOK');
  461. $fmSUBSUBKELOMPOK = cekPOST('fmSUBSUBKELOMPOK');
  462. $fmKODE = cekPOST('fmKODE');
  463. $fmAKUN = cekPOST('fmAKUN');
  464. //$fmThnAnggaran= $_COOKIE['coThnAnggaran'];
  465. $filterAkun = cekPOST('filterAkun');
  466.  
  467. //$fmPILCARI = $_REQUEST['fmPILCARI'];
  468. //$fmPILCARIvalue = $_REQUEST['fmPILCARIvalue'];
  469. //$fmORDER1 = cekPOST('fmORDER1');
  470. //$fmDESC1 = cekPOST('fmDESC1');
  471.  
  472.  
  473. $arr = array(
  474. //array('selectAll','Semua'),
  475. array('selectfg','Kode Barang'),
  476. array('selectbarang','Nama Barang'),
  477. );
  478.  
  479.  
  480. //data order ------------------------------
  481. $arrOrder = array(
  482. array('1','Kode Barang'),
  483. array('2','Nama Barang'),
  484. );
  485.  
  486. /*if($Main->WITH_THN_ANGGARAN){
  487. $aqry1 = "select Max(thn_akun) as thnMax from ref_jurnal where
  488. thn_akun<=$fmThnAnggaran"; $cek.=$aqry1;
  489. $qry1=mysql_query($aqry1);
  490. $qry_jurnal=mysql_fetch_array($qry1);
  491. $thn_akun=$qry_jurnal['thnMax'];
  492. //$arrKondisi[] = " thn_akun = '$thn_akun'";
  493. $vthnakun = " and thn_akun=$thn_akun ";
  494.  
  495. } */
  496.  
  497.  
  498. if(!empty($_POST['filterAkun'])) {
  499. $arrakun = explode('.',$filterAkun);
  500. if($arrakun['0'] <> '') {
  501. $fmBIDANG = $arrakun['0'];
  502. $get = mysql_fetch_array(mysql_query(
  503. "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='0'"));// $vthnakun "
  504.  
  505. $listBidang = $get['ka'].'. '. $get['nm_account']."<input type='hidden' id= 'fmBIDANG' name='fmBIDANG' value='$fmBIDANG' >";
  506. }
  507. if($arrakun['1'] <> '') {
  508. $fmKELOMPOK = $arrakun['1'];
  509. $get = mysql_fetch_array(mysql_query(
  510. "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='$fmKELOMPOK' and kc='0'")); //$vthnakun
  511.  
  512. $listKelompok = $get['ka'].'.'.$get['kb'].'. '. $get['nm_account']."<input type='hidden' id= 'fmKELOMPOK' name='fmKELOMPOK' value='$fmKELOMPOK' >";
  513. }
  514. if($arrakun['2'] <> ''){
  515. $fmSUBKELOMPOK = $arrakun['2'];
  516. $get = mysql_fetch_array(mysql_query(
  517. "select ka,kb,kc,kd, nm_account from ref_jurnal where ka='$fmBIDANG' and kb='$fmKELOMPOK' and kc='$fmSUBKELOMPOK' and kd='0'"));// $vthnakun
  518.  
  519. $listSubKelompok = $get['ka'].'.'.$get['kb'].'.'.$get['kc'].'. '.$get['nm_account']."<input type='hidden' id= 'fmSUBKELOMPOK' name='fmSUBKELOMPOK' value='$fmSUBKELOMPOK' >";
  520. }
  521. if($arrakun['3'] <> '') {
  522. $fmSUBSUBKELOMPOK = $arrakun['3'];
  523. $get = mysql_fetch_array(mysql_query(
  524. "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
  525.  
  526. $listSubSubKelompok = $get['ka'].'. '.$get['kb'].'.'.$get['kc'].'.'.$get['kd'].'. '.$get['nm_account']."<input type='hidden' id= 'fmSUBSUBKELOMPOK' name='fmSUBSUBKELOMPOK' value='$fmSUBSUBKELOMPOK' >";
  527. }
  528. //if($arr['4'] <> '') $fmBIDANG = $arr['4'];
  529. //if($arr['5'] <> '') $fmBIDANG = $arr['5'];
  530. //$konFiltAkun = " and concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['filterAkun']."%'";
  531. }
  532. $cek .= " select ka,nm_account from ref_jurnal where ka<>'0' and kb='0'";// $vthnakun; ";
  533. 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','');
  534.  
  535. 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','');
  536.  
  537. 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','');
  538.  
  539. 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','');
  540.  
  541.  
  542. if($Main->SHOW_CEK== FALSE) $cek = '';
  543.  
  544. $TampilOpt =
  545. //"<tr><td>".
  546. "<div style='display:none;'> $cek </div>".
  547. "<div class='FilterBar'>".
  548. //<table style='width:100%'><tbody><tr><td align='left'>
  549. //<table cellspacing='0' cellpadding='0' border='0' style='height:28'>
  550. //<tbody><tr valign='middle'>
  551. // <td align='left' style='padding:1 8 0 8; '>".
  552. //"<div style='float:left;padding: 2 8 0 0;height:20;padding: 4 4 0 0'>Urutkan : </div>".
  553.  
  554. "<table style='width:100%'>
  555. <tr>
  556. <td style='width:150px'>BIDANG</td><td style='width:10px'>:</td>
  557. <td>".//$fmThnAnggaran - $aqry1 - ".
  558. //"select ka,nm_account from ref_jurnal where ka<>'0' and kb='0' $vthnakun ".
  559. $listBidang.
  560. "</td>
  561. </tr><tr>
  562. <td>KELOMPOK</td><td>:</td>
  563. <td>".
  564. $listKelompok.
  565. "</td>
  566. </tr><tr>
  567. <td>SUB KELOMPOK</td><td>:</td>
  568. <td>".
  569. $listSubKelompok.
  570. "</td>
  571. </tr><tr>
  572. <td>SUB SUB KELOMPOK</td><td>:</td>
  573. <td>".
  574. $listSubSubKelompok.
  575. "</td>
  576. </tr>
  577.  
  578. </table>".
  579. "</div>".
  580. "<div class='FilterBar'>".
  581. "<table style='width:100%'>
  582. <tr><td>
  583. Kode Akun : <input type='text' id='fmKODE' name='fmKODE' value='".$fmKODE."' maxlength='' size=10px>&nbsp
  584. Nama Akun : <input type='text' id='fmAKUN' name='fmAKUN' value='".$fmAKUN."' size=30px>&nbsp".
  585. "<input type='hidden' id='filterAkun' name='filterAkun' value='".$filterAkun."'>".
  586. "<input type='button' id='btTampil' value='Tampilkan' onclick='".$this->Prefix.".refreshList(true)'>
  587. </td></tr>
  588. </table>".
  589. "</div>".
  590. "<input type='hidden' id='fmORDER18' name='fmORDER18' value='".$fmORDER18."'>".
  591. "<input type='hidden' id='fmORDER19' name='fmORDER19' value='".$fmORDER19."'>"
  592. ;
  593. return array('TampilOpt'=>$TampilOpt);
  594. }
  595.  
  596. function getDaftarOpsi($Mode=1){
  597. global $Main, $HTTP_COOKIE_VARS;
  598. $UID = $_COOKIE['coID'];
  599. //$thn_akun = $HTTP_COOKIE_VARS['coThnAnggaran'];
  600. //kondisi -----------------------------------
  601.  
  602. $arrKondisi = array();
  603. $fmPILCARI = $_REQUEST['fmPILCARI'];
  604. $fmPILCARIvalue = $_REQUEST['fmPILCARIvalue'];
  605. $fmBIDANG = $_REQUEST['fmBIDANG'];
  606. $fmKELOMPOK = $_REQUEST['fmKELOMPOK'];
  607. $fmSUBKELOMPOK = $_REQUEST['fmSUBKELOMPOK'];
  608. $fmSUBSUBKELOMPOK = $_REQUEST['fmSUBSUBKELOMPOK'];
  609. //$fmThnAnggaran= $_COOKIE['coThnAnggaran'];
  610. $filterAkun = cekPOST('filterAkun');
  611.  
  612. /*if($Main->WITH_THN_ANGGARAN){
  613. $aqry1 = "select Max(thn_akun) as thnMax from ref_jurnal where
  614. thn_akun<='$fmThnAnggaran'";
  615. $qry1=mysql_query($aqry1);
  616. $qry_jurnal=mysql_fetch_array($qry1);
  617. $thn_akun=$qry_jurnal['thnMax'];
  618. $arrKondisi[] = " thn_akun = '$thn_akun'";
  619.  
  620. }*/
  621. //$fmKODE = $_REQUEST['fmKODE'];
  622. //$fmAKUN = $_REQUEST['fmAKUN'];
  623.  
  624. /*switch($fmPILCARI){
  625. case 'selectfg': $arrKondisi[] = " concat(f,g) like '%$fmPILCARIvalue%'"; break;
  626. case 'selectbarang': $arrKondisi[] = " nama_barang like '%".$fmPILCARIvalue."%'"; break;
  627. }*/
  628.  
  629. if(empty($fmBIDANG)) {
  630. $fmKELOMPOK = '';
  631. $fmSUBKELOMPOK='';
  632. $fmSUBSUBKELOMPOK='';
  633. }
  634. if(empty($fmKELOMPOK)) {
  635. $fmSUBKELOMPOK='';
  636. $fmSUBSUBKELOMPOK='';
  637. }
  638. if(empty($fmSUBKELOMPOK)) {
  639. $fmSUBSUBKELOMPOK='';
  640. }
  641.  
  642. if(empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  643. {
  644. //$arrKondisi[]= "ka !=00 and kb=00 and kc=00 and kd=00 and ke=00";
  645. }
  646. elseif(!empty($fmBIDANG) && empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  647. {
  648. $arrKondisi[]= "ka =$fmBIDANG";//$arrKondisi[]= "ka =$fmBIDANG and kb!=00 and kc=00 and kd=00 and ke=00";
  649. }
  650. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  651. {
  652. $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK";//$arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc!=00 and kd=00 and ke=00";
  653. }
  654. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && empty($fmSUBSUBKELOMPOK))
  655. {
  656. $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK";//$arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK and kd!=00 and ke=00";
  657. }
  658. elseif(!empty($fmBIDANG) && !empty($fmKELOMPOK) && !empty($fmSUBKELOMPOK) && !empty($fmSUBSUBKELOMPOK))
  659. {
  660. $arrKondisi[]= "ka =$fmBIDANG and kb=$fmKELOMPOK and kc=$fmSUBKELOMPOK and kd=$fmSUBSUBKELOMPOK";
  661. }
  662. if(!empty($_POST['fmKODE'])) $arrKondisi[] = " concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['fmKODE']."%'";
  663. if(!empty($_POST['fmAKUN'])) $arrKondisi[] = " nm_account like '%".$_POST['fmAKUN']."%'";
  664.  
  665. if(!empty($_POST['filterAkun'])) $arrKondisi[] = " concat(ka,'.',kb,'.',kc,'.',kd,'.',ke,'.',kf) like '".$_POST['filterAkun']."%'";
  666.  
  667.  
  668.  
  669.  
  670.  
  671. $Kondisi= join(' and ',$arrKondisi);
  672. $Kondisi = $Kondisi =='' ? '':' Where '.$Kondisi;
  673.  
  674. //Order -------------------------------------
  675. $fmORDER1 = cekPOST('fmORDER1');
  676. $fmDESC1 = cekPOST('fmDESC1');
  677. $Asc1 = $fmDESC1 ==''? '': 'desc';
  678. $arrOrders = array();
  679. switch($fmORDER1){
  680. case '': $arrOrders[] = " concat(ka,kb,kc,kd,ke,kf) $ASC " ;break;
  681. case '1': $arrOrders[] = " concat(ka,kb,kc,kd,ke, kf) $Asc1 " ;break;
  682. case '2': $arrOrders[] = " nama_barang $Asc1 " ;break;
  683.  
  684. }
  685.  
  686. $Order= join(',',$arrOrders);
  687. $OrderDefault = ' order by ka,kb,kc,kd,ke,kf ';// Order By no_terima desc ';
  688. $Order = $Order ==''? $OrderDefault : ' Order By '.$Order;
  689. //}
  690. //$Order ="";
  691. //limit --------------------------------------
  692. /**$HalDefault=cekPOST($this->Prefix.'_hal',1); //Cat:Settingan Lama
  693. $Limit = " limit ".(($HalDefault *1) - 1) * $Main->PagePerHal.",".$Main->PagePerHal; //$LimitHal = '';
  694. $Limit = $Mode == 3 ? '': $Limit;
  695. //noawal ------------------------------------
  696. $NoAwal= $Main->PagePerHal * (($HalDefault*1) - 1);
  697. $NoAwal = $Mode == 3 ? 0: $NoAwal;
  698. **/
  699. $pagePerHal = $this->pagePerHal =='' ? $Main->PagePerHal: $this->pagePerHal;
  700. $HalDefault=cekPOST($this->Prefix.'_hal',1);
  701. //$Limit = " limit ".(($HalDefault *1) - 1) * $Main->PagePerHal.",".$Main->PagePerHal; //$LimitHal = '';
  702. $Limit = " limit ".(($HalDefault *1) - 1) * $pagePerHal.",".$pagePerHal; //$LimitHal = '';
  703. $Limit = $Mode == 3 ? '': $Limit;
  704. //noawal ------------------------------------
  705. $NoAwal= $pagePerHal * (($HalDefault*1) - 1);
  706. $NoAwal = $Mode == 3 ? 0: $NoAwal;
  707.  
  708. return array('Kondisi'=>$Kondisi, 'Order'=>$Order ,'Limit'=>$Limit, 'NoAwal'=>$NoAwal);
  709.  
  710. }
  711.  
  712. }
  713. $RefJurnal = new RefJurnalObj();
  714.  
  715. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement