API tools faq
paste
Advertisement
Guest User

generateGambar

a guest
Sep 20th, 2019
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.69 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include "config.php";
  3. class GenerateJSON extends Config{
  4. var $arrayFixIndexTable = array();
  5. var $blockListExtension = array(
  6. array('.bck'),
  7. array('bck'),
  8. array(',bck'),
  9. array('.BCK'),
  10. array('.backup'),
  11. array('.201'),
  12. array('201'),
  13. array('.php_'),
  14. array('.php_'),
  15. array('.bck'),
  16. array('.git'),
  17. array('_DOC'),
  18. array('.doc'),
  19. array('.xls'),
  20. );
  21. function __construct(){
  22. $getDataGambar = $this->sqlQuery("select idbi,count(Id) from gambar group by idbi");
  23. while ($dataGambar = $this->sqlArray($getDataGambar)) {
  24. $getDataBukuInduk = $this->sqlArray($this->sqlQuery("select jml_gambar from buku_induk where idawal = '".$dataGambar['idbi']."'"));
  25. // echo $dataGambar['idbi']." => ".$dataGambar['count(Id)']." : ".$getDataBukuInduk['jml_gambar']." \n";
  26. $queryUpdate = "UPDATE buku_induk set jml_gambar = '".$dataGambar['count(Id)']."' where idawal = '".$dataGambar['idbi']."' ";
  27. echo $queryUpdate."\n";
  28. $this->sqlQuery($queryUpdate);
  29. }
  30.  
  31.  
  32. }
  33.  
  34. function prosesSync($arrayPost){
  35. $tahunAnggaran = "2018";
  36. $err = "";
  37. $cek = "";
  38. $statusSelesai = "belom";
  39. $explodeArrayPost = explode(";",$arrayPost);
  40. $kodeSKPD = $explodeArrayPost[0];
  41. $kodeBarang = $explodeArrayPost[1];
  42. $logHitung = "$nomorPost/$jumlahData update rusak berat $kodeBarang .... ";
  43. $getSettingInventaris = $this->sqlArray($this->sqlQuery("select * from setting_inventaris where thn_sensus = '".$tahunAnggaran."'"));
  44. $getSaldoAwal = $this->sqlArray($this->sqlQuery("select count(id) as jumlah_saldo_awal, sum(nilai_buku_prev) as harga_saldo_awal from buku_induk where thn_perolehan >='".$getSettingInventaris['thn_perolehan1']."' and thn_perolehan <= '".$getSettingInventaris['thn_perolehan2']."' and concat(f1,'.',f2,'.',f,'.',g,'.',h,'.',i,'.',j) = '$kodeBarang' and concat(c1,'.',c,'.',d,'.',e,'.',e1) = '$kodeSKPD' "));
  45. $logHitung = "KODE SKPD : $kodeSKPD => KODE BARANG : ".$kodeBarang." => ".$getSaldoAwal['jumlah_saldo_awal']." Rp. ".$getSaldoAwal['harga_saldo_awal'];
  46. // if($nomorPost == $jumlahData){
  47. // $statusSelesai = "OK";
  48. // $logHitung = "sync data finished.";
  49. // }else{
  50. // $statusSelesai = "lanjutkan";
  51. // }
  52. $explodeKodeSKPD = explode(".",$kodeSKPD);
  53. $explodeKodeBarang = explode(".",$kodeBarang);
  54. if($this->sqlRowCount($this->sqlQuery("select * from rekap_inventaris where and concat(f1,'.',f2,'.',f,'.',g,'.',h,'.',i,'.',j) = '$kodeBarang' and concat(c1,'.',c,'.',d,'.',e,'.',e1) = '$kodeSKPD' and tahun='".$tahunAnggaran."' ")) == 0){
  55.  
  56. $dataInsertRekapInventaris = array(
  57. "c1" =>$explodeKodeSKPD[0],
  58. "c" =>$explodeKodeSKPD[1],
  59. "d" =>$explodeKodeSKPD[2],
  60. "e" =>$explodeKodeSKPD[3],
  61. "e1" =>$explodeKodeSKPD[4],
  62. "f1" =>$explodeKodeBarang[0],
  63. "f2" =>$explodeKodeBarang[1],
  64. "f" =>$explodeKodeBarang[2],
  65. "g" =>$explodeKodeBarang[3],
  66. "h" =>$explodeKodeBarang[4],
  67. "i" =>$explodeKodeBarang[5],
  68. "j" =>$explodeKodeBarang[6],
  69. "j" =>$explodeKodeBarang[6],
  70. "tahun" =>$tahunAnggaran,
  71. "jumlah_saldo_awal" =>$getSaldoAwal['jumlah_saldo_awal'],
  72. "harga_saldo_awal" =>$getSaldoAwal['harga_saldo_awal'],
  73. );
  74. $queryInsertRekapInventaris = $this->sqlInsert("rekap_inventaris",$dataInsertRekapInventaris);
  75. $this->sqlQuery($queryInsertRekapInventaris);
  76. $cek = $queryInsertRekapInventaris;
  77. }else{
  78. $dataInsertRekapInventaris = array(
  79. "jumlah" =>$getJumlahBarangDiBI,
  80. );
  81. $queryInsertRekapInventaris = $this->sqlUpdate("rekap_inventaris",$dataInsertRekapInventaris," concat(f1,'.',f2,'.',f,'.',g,'.',h,'.',i,'.',j) = '$kodeBarang' and concat(c1,'.',c,'.',d,'.',e,'.',e1) = '$kodeSKPD' and tahun='".$tahunAnggaran."' ");
  82. $this->sqlQuery($queryInsertRekapInventaris);
  83. $cek = $queryInsertRekapInventaris;
  84. }
  85.  
  86.  
  87. $content = array(
  88. 'statusSelesai' => $statusSelesai,
  89. 'persen' => ($nomorPost / $jumlahData ) * 100,
  90. "logHitung" => $logHitung,
  91.  
  92. );
  93. return $logHitung;
  94. }
  95. function updateRusakBeratJSON($fileName){
  96. $arrayIdRusakBerat = json_decode(file_get_contents($fileName));
  97. for ($i=0; $i < sizeof($arrayIdRusakBerat) ; $i++) {
  98. echo $this->prosesUpdateRusakBerat($arrayIdRusakBerat[$i])."\n";
  99. }
  100. }
  101. function updateRusakBerat($fileName){
  102. $arrayIdRusakBerat = explode("\n",file_get_contents($fileName));
  103. // $arrayIdRusakBerat = array("7988");
  104. for ($i=0; $i < sizeof($arrayIdRusakBerat) ; $i++) {
  105. echo $this->prosesUpdateRusakBerat($arrayIdRusakBerat[$i])."\n";
  106. }
  107. }
  108. function updateTidakAda($fileName){
  109. $arrayIdTidakAda = explode("\n",file_get_contents($fileName));
  110. // $arrayIdTidakAda = array("3223349","3223346","3224962");
  111. for ($i=0; $i < sizeof($arrayIdTidakAda) ; $i++) {
  112. echo $this->prosesUpdateTidakAda($arrayIdTidakAda[$i])."\n";
  113. }
  114. }
  115. function updateTidakAdaJSON($fileName){
  116. $arrayIdTidakAda = json_decode(file_get_contents($fileName));
  117. // $arrayIdTidakAda = array("3223349","3223346","3224962");
  118. for ($i=0; $i < sizeof($arrayIdTidakAda) ; $i++) {
  119. echo $this->prosesUpdateTidakAda($arrayIdTidakAda[$i])."\n";
  120. }
  121. }
  122. function prosesUpdateRusakBerat($idUpdate){
  123.  
  124. if (!empty($idUpdate)) {
  125. $thn_login = "2018";
  126. $uid = "BOT CLI";
  127. $cek = '';
  128. $err = '';
  129. $content = '';
  130. $json = TRUE;
  131. $fmST = $_REQUEST[$this->Prefix . '_fmST'];
  132. $idubah = $idUpdate;
  133. $_REQUEST['tgl_sk'] = "31-12-2018";
  134. $_REQUEST['thn_buku'] = "2018";
  135. $_REQUEST['tgl_buku'] = "31-12-2018";
  136. $no_sk = "CLI DZAKIR";
  137.  
  138. $gen_tgl = $_REQUEST['tgl_buku'] . '-' . $_REQUEST['thn_buku'];
  139. $tgl = "2018-12-31";
  140.  
  141. $tgl_sk = date('Y-m-d', strtotime($_REQUEST['tgl_sk']));
  142. $KondisiBarang = array(
  143. array("1","Baik"),
  144. array("2","Kurang Baik"),
  145. array("3","Rusak Berat")
  146. );
  147. $kondisi_baru = $KondisiBarang[2][0];
  148. $ket = "Reklas RB dari Inventaris";
  149.  
  150.  
  151.  
  152. $exptglsk = explode('-', $_REQUEST['tgl_sk']);
  153. $cektglsk = $exptglsk[2] . '-' . $exptglsk[1] . '-' . $exptglsk[0];
  154.  
  155. if ($err == '' && $no_sk == '')
  156. $err = 'NOMOR belum diisi !';
  157.  
  158. if ($err == '' && !$this->cektanggal($tgl))
  159. $err = 'TANGGAL BUKU salah!';
  160. if ($err == '' && !$this->cektanggal($cektglsk))
  161. $err = 'TANGGAL BAST salah!';
  162. $thn_bast = substr($tgl_sk, 0, 4);
  163. if ($err == '' && $thn_bast > $thn_login)
  164. $err = 'TAHUN BAST maximal ' . $thn_login . ' !';
  165. if ($err == '' && $this->compareTanggal($tgl, date('Y-m-d')) == 2)
  166. $err = 'TANGGAL BUKU tidak lebih besar dari Hari ini!';
  167. if ($err == '') {
  168. $limit = 2;
  169. $getcnt = "select * from buku_induk where id = '$idUpdate' and kondisi !=$kondisi_baru and id not in(select idbi from t_kondisi where kond_akhir =$kondisi_baru and year(tgl)=$thn_login) limit 0,$limit";
  170.  
  171. //$err='qyr='.$getcnt;
  172. $jml = $this->sqlRowCount($this->sqlQuery($getcnt));
  173. $content->jml = $jml;
  174. $result = $this->sqlQuery($getcnt);
  175. while ($old = $this->sqlArray($result)) {
  176. $idbiawal = $old['idawal'];
  177. $idbi = $old['id'];
  178. $kondisi = $old['kondisi'];
  179. $staset_lama = $old['staset'];
  180. $status_barang = $old['status_barang'];
  181. $noreg = $old['noreg'];
  182. $dif_kondisi = $kondisi_baru - $kondisi;
  183. $nilai_buku = $this->getNilaiBuku($idbi, $tgl, 0);
  184. $nilai_susut = $this->getAkumPenyusutan($idbi, $tgl);
  185.  
  186. // $cekbi = cekBI($idbi);
  187. $cekbi = "";
  188. // if ($err == '' && !empty($cekbi) )
  189. // $err = 'Warning,ID Barang ' . $idbi . ' rusak (' . $cekbi . '),Harap hubungi admin!';
  190.  
  191. $maxtrans = $this->sqlArray($this->sqlQuery("select max(tgl_buku) as maxtgl from t_transaksi where idbi='$idbi'"));
  192. if ($err == '' && $this->compareTanggal($tgl, $maxtrans['maxtgl']) == 0)
  193. $err = 'TANGGAL BUKU tidak lebih kecil dari tanggal transaksi sebelumnya!';
  194.  
  195. $tgl_susutAkhir = $this->sqlArray($this->sqlQuery("select tgl from penyusutan where idbi='$idbi' and jns_trans2=30 order by id desc limit 1"));
  196. // if ($err == '' && sudahClosing($tgl, $old['c'], $old['d'], $old['e'], $old['e1'], $old['c1']))
  197. // $err = 'Tanggal sudah Closing !';
  198. if ($err == '' && $tgl <= $tgl_susutAkhir['tgl'])
  199. $err = "Id Barang " . $idbi . " Sudah ada penyusutan !";
  200. // - tanggal harus <= tgl hari ini
  201. //tgl >=tgl_buku
  202. if ($this->compareTanggal($tgl, $old['tgl_buku']) == 0)
  203. $err = "TANGGAL BUKU tidak lebih kecil dari TANGGAL BUKU BARANG!";
  204. if ($err == '' && $status_barang != 1)
  205. $err = "Id Barang " . $idbi . " Status barang bukan Inventaris !";
  206. if ($err == '' && $noreg == '0000')
  207. $err = 'Id Barang ' . $idbi . ' No. Register masih 0000,belum di generate !';
  208.  
  209. $cekpmfsebagian = $this->sqlArray($this->sqlQuery("select count(*) as cnt from pemanfaatan where bentuk_pemanfaatan=7 and idbi_awal = '$idbiawal'"));
  210. if ($err == '' && $cekpmfsebagian['cnt'] > 0)
  211. $err = "Gagal,Id Barang " . $idbi . " sudah di pemanfaatan sebagian !";
  212.  
  213. if ($err == '') {
  214. $bi = $this->sqlArray($this->sqlQuery("select * from buku_induk where id='$idbi'"));
  215. $aqry = "insert into t_kondisi (tgl,idbi,uid,tgl_update,ket, kond_awal,kond_akhir,idbi_awal,dif_kondisi,no_bast,tgl_bast,dokumen_sumber,staset_lama,nilai_buku,nilai_susut) " . " values('$tgl','$idbi','$uid',now(),'$ket', '$kondisi','$kondisi_baru','" . $bi['idawal'] . "','$dif_kondisi','$no_sk','$tgl_sk','6','$staset_lama','$nilai_buku','$nilai_susut') ";
  216. $cek .= $aqry;
  217. $qry = $this->sqlQuery($aqry);
  218.  
  219. $exequery = "UPDATE buku_induk set kondisi='$kondisi_baru',staset=9 where id='$idbi' ";
  220. $qry = $this->sqlQuery($exequery);
  221. //$err.='cek='.$aqry;
  222. }
  223. } //end while
  224. } //end if
  225.  
  226.  
  227. $dataUpdataTidakTercatat = array(
  228. 'idbi' => $getIdBi['max(id)']
  229. );
  230.  
  231. $cek = $getcnt;
  232.  
  233. }
  234. return $idUpdate." -> OK ". $err;
  235. }
  236. function prosesUpdateTidakAda($idUpdate){
  237. $getDataBukuInduk = $this->sqlArray($this->sqlQuery("select * from buku_induk where id = '$idUpdate'"));
  238. $tahun = "2018";
  239. $uid = "BOT CLI";
  240. //get data -----------------
  241. $fmST = $_REQUEST[$this->Prefix . '_fmST'];
  242. //$idplh = $_REQUEST[$this->Prefix.'_idplh'];
  243. $c1_lama = $getDataBukuInduk['c1'];
  244. $c_lama = $getDataBukuInduk['c'];
  245. $d_lama = $getDataBukuInduk['d'];
  246. $jmldata = $_REQUEST['jmldata'];
  247. $idubah = $_REQUEST['idubah'];
  248. $cbid = $_REQUEST['cidBI'];
  249. $idubah = $idUpdate;
  250. $idplh = $idUpdate;
  251. $gen_tgl = "31-12" . '-' . "2018";
  252. $tgl_buku = date('Y-m-d', strtotime($gen_tgl));
  253. $no_sk = "CLI DZAKIR";
  254. $tgl_sk = date('Y-m-d', strtotime("31-12-2018"));
  255. $cr_pemusnahan = "SENSUS";
  256. $ket = 'CLI DZAKIR';
  257. //$err.='tgll='.$tgl_sk;
  258. $_REQUEST['tgl_sk'] = "31-12-2018";
  259. $_REQUEST['thn_buku'] = "2018";
  260. $_REQUEST['tgl_buku'] = "31-12-2018";
  261. $idPemusnahan = "0";
  262. $exptglsk = explode('-', $_REQUEST['tgl_sk']);
  263. $cektglsk = $exptglsk[2] . '-' . $exptglsk[1] . '-' . $exptglsk[0];
  264.  
  265. if ($err == '' && $no_sk == '')
  266. $err = 'NOMOR belum diisi !';
  267. if ($err == '' && $_REQUEST['tgl_sk'] == '')
  268. $err = 'TANGGAL belum diisi!';
  269. if ($err == '' && $_REQUEST['tgl_buku'] == '')
  270. $err = 'TANGGAL BUKU belum diisi!';
  271. //if($err=='' && !$this->cektanggal($tgl_buku)) $err = 'TANGGAL BUKU salah!';
  272. if ($err == '' && !$this->cektanggal($cektglsk))
  273. $err = 'TANGGAL SK salah!';
  274. $thn_bast = substr($tgl_sk, 0, 4);
  275. if ($err == '' && $thn_bast > $_REQUEST['thn_buku'])
  276. $err = 'TAHUN SK maximal ' . $_REQUEST['thn_buku'] . ' !';
  277. if ($err == '' && $this->compareTanggal($tgl_buku, date('Y-m-d')) == 2)
  278. $err = 'TANGGAL BUKU tidak lebih besar dari Hari ini!';
  279. if ($err == '' && $cr_pemusnahan == '')
  280. $err = 'CARA PEMUSNAHAN belum diisi !';
  281. if ($err == '') {
  282.  
  283. if ($idPemusnahan == '0') {
  284. $query = "INSERT into pemusnahan(uid,tgl_update,sttemp,no_ba,tgl_ba,tgl_buku,cara_pemusnahan,ket,thn_anggaran) " . "values('$uid',NOW(),'0','$no_sk','$tgl_sk','$tgl_buku','$cr_pemusnahan','$ket','$tahun')"; //$err.=$query;
  285. $result = $this->sqlQuery($query);
  286. $getDataPemusnahan = $this->sqlArray($this->sqlQuery("select max(id) from pemusnahan where uid = '$uid'"));
  287. $idPemusnahan = $getDataPemusnahan['max(id)'];
  288. }
  289. $getcnt = "select * from buku_induk where id = '$idUpdate' and status_barang!=3 and id not in(select id_bukuinduk from pemusnahan_det )";
  290. $jml = mysql_num_rows($this->sqlQuery($getcnt));
  291. $content->jml = $jml;
  292. $result = $this->sqlQuery($getcnt);
  293. while ($old = $this->sqlArray($result)) {
  294. $idbiawal = $old['idawal'];
  295. $idbi = $old['id'];
  296. $staset = $old['staset'];
  297. $status_barang = $old['status_barang'];
  298. $a1 = $old['a1'];
  299. $a = $old['a'];
  300. $b = $old['b'];
  301. $c1 = $old['c1'];
  302. $c = $old['c'];
  303. $d = $old['d'];
  304. $e = $old['e'];
  305. $e1 = $old['e1'];
  306. $f1 = $old['f1'];
  307. $f2 = $old['f2'];
  308. $f = $old['f'];
  309. $g = $old['g'];
  310. $h = $old['h'];
  311. $i = $old['i'];
  312. $j = $old['j'];
  313. $kondisi = $old['kondisi'];
  314. $noreg = $old['noreg'];
  315. $thn_perolehan = $old['thn_perolehan'];
  316. $nilai_buku = $this->getNilaiBuku($idbi, $tgl_buku, 0);
  317. $nilai_susut = $this->getAkumPenyusutan($idbi, $tgl_buku);
  318. $concatkd = $Main->KD_BARANG_P108 ? "f1,f2,f,g,h,i,j" : "f,g,h,i,j";
  319. $kdBarang = $Main->KD_BARANG_P108 ? $f1 . $f2 . $f . $g . $h . $i . $j : $f . $g . $h . $i . $j;
  320. $query_brg = "select * from ref_barang where concat($concatkd)='$kdBarang'";
  321. $brg = $this->sqlArray($this->sqlQuery($query_brg));
  322. $query_jurnal = "select thn_akun,nm_account from ref_jurnal where ka='" . $brg['ka'] . "' and kb='" . $brg['kb'] . "'
  323. and kc='" . $brg['kc'] . "' and kd='" . $brg['kd'] . "'
  324. and ke='" . $brg['ke'] . "' and kf='" . $brg['kf'] . "'"; //$cek.='jurnal='.$query_jurnal;
  325. $jurnal = $this->sqlArray($this->sqlQuery($query_jurnal));
  326. $ka = $brg['ka'];
  327. $kb = $brg['kb'];
  328. $kc = $brg['kc'];
  329. $kd = $brg['kd'];
  330. $ke = $brg['ke'];
  331. $kf = $brg['kf'];
  332. $thn_akun = $jurnal['thn_akun'];
  333. if ($err == '' && $this->compareTanggal($tgl_buku, $old['tgl_buku']) == 0) {
  334. $err = 'TANGGAL BUKU dengan Id ' . $idbi . ' tidak lebih kecil dari Tanggal Buku Barang!';
  335. }
  336. if ($err == '') {
  337. $ceksusut = $this->sqlArray($this->sqlQuery("select tgl as tgl_penyusutan from penyusutan where idbi='$idbi' and jns_trans2=30 order by Id desc limit 0,1"));
  338. if ($tgl_buku <= $ceksusut['tgl_penyusutan'])
  339. $err = "Gagal penghapusan,Id Barang " . $idbi . " sudah penyusutan !";
  340. }
  341. $hps = $this->table_get_rec("select count(*)as cnt from penghapusan where mutasi=1 and id_bukuinduk='$idbi'");
  342. if ($err == '' && $status_barang != 1)
  343. $err = 'Id Barang ' . $idbi . ' Status barang harus Inventaris !';
  344. if ($err == '' && $status_barang == 5)
  345. $err = 'Barang sudah di Tuntutan Ganti Rugi!';
  346. if ($err == '' && $hps['cnt'] > 1)
  347. $err = 'Barang sudah di Penghapusan!';
  348. $transaksi = $this->sqlArray($this->sqlQuery("select max(tgl_buku) as maxtgl from t_transaksi where idbi = '$idbi'"));
  349. if ($err == '' && ($this->compareTanggal($tgl_buku, $transaksi['maxtgl']) == 0))
  350. $err = 'TANGGAL BUKU harus lebih besar dari Tanggal Transaksi lainnya!';
  351. $exequery = "INSERT pemusnahan_det (id_bukuinduk,idbi_awal,c1,c,d,e,e1,f1,f2,f,g,h,i,j," . "thn_perolehan,noreg,jumlah_harga,nilai_susut,kondisi,ket," . "k,l,m,n,o,p,thn_akun,tgl_buku,staset,tgl_create,uid_create,tgl_update,sttemp,refid_pemusnahan)" . "values ('$idbi','$idbiawal','$c1','$c','$d','$e','$e1'," . "'$f1','$f2','$f','$g','$h','$i','$j','$thn_perolehan','$noreg','$nilai_buku','$nilai_susut','$kondisi','$ket'," . "'$ka','$kb','$kc','$kd','$ke','$kf','$thn_akun','$tgl_buku','$staset',NOW(),'$uid',NOW(),1,'$idPemusnahan')";
  352. $cek = $exequery;
  353. $qry = $this->sqlQuery($exequery);
  354. if ($qry) {
  355. $updbi = "UPDATE buku_induk set staset=14,status_barang=6 where id='$idbi'";
  356. $resultbi = $this->sqlQuery($updbi);
  357. }
  358. }
  359. }
  360.  
  361. return $idUpdate." - > OK";
  362. }
  363. function getDataTidakAda(){
  364.  
  365. $arrayIdTidakAda = array();
  366. $getDataUPTDisdik = $this->sqlQuery("select * from ref_skpd where concat(c1,'.',c,'.',d) = '1.01.01' and e!='00' and e1='000' ");
  367. while ($dataUPT = $this->sqlArray($getDataUPTDisdik)) {
  368. $concatUPT = $dataUPT['c1'].".".$dataUPT['c'].".".$dataUPT['d'].".".$dataUPT['e'];
  369. $getData = $this->sqlQuery("select aa.id as idTidakAda from buku_induk aa inner join inventaris bb on aa.id=bb.idbi and concat(c1,'.',c,'.',d,'.',e) = '$concatUPT' and staset_prev = 3 and status_barang not in(3,4,5) and bb.ada=2 and aa.id not in(select id_bukuinduk from v_pemusnahan where 1=1 and concat(c1,'.',c,'.',d,'.',e) = '$concatUPT') ");
  370. while ($dataTidakAda = $this->sqlArray($getData)) {
  371. $arrayIdTidakAda[] = $dataTidakAda['idTidakAda'];
  372. echo $dataTidakAda['idTidakAda']."\n";
  373. }
  374. }
  375. // echo json_encode($arrayIdTidakAda,JSON_PRETTY_PRINT);
  376. }
  377. function getDataRusakBerat(){
  378. $arrayIdRusakBerat = array();
  379. $getDataUPTDisdik = $this->sqlQuery("select * from ref_skpd where concat(c1,'.',c,'.',d) = '1.01.01' and e!='00' and e1='000' ");
  380. while ($dataUPT = $this->sqlArray($getDataUPTDisdik)) {
  381. $concatUPT = $dataUPT['c1'].".".$dataUPT['c'].".".$dataUPT['d'].".".$dataUPT['e'];
  382. $getDataSubUnit = $this->sqlQuery("select * from ref_skpd where concat(c1,'.',c,'.',d,'.',e) = '$concatUPT' and e1!='000' ");
  383. while ($dataSubUnit = $this->sqlArray($getDataSubUnit)) {
  384. $concatSubUnit = $dataSubUnit['c1'].".".$dataSubUnit['c'].".".$dataSubUnit['d'].".".$dataSubUnit['e'].".".$dataSubUnit['e1'];
  385. $getData = $this->sqlQuery("select aa.id as idRusakBerat from buku_induk aa inner join inventaris bb on aa.id=bb.idbi and concat(c1,'.',c,'.',d,'.',e,'.',e1) = '$concatSubUnit' and status_barang not in(3,4,5) and staset = 3 and bb.kondisi=3");
  386. while ($dataRusakBerat = $this->sqlArray($getData)) {
  387. $arrayIdRusakBerat[] = $dataRusakBerat['idRusakBerat'];
  388. echo $dataRusakBerat['idRusakBerat']."\n";
  389. }
  390. }
  391.  
  392. }
  393. // echo json_encode($arrayIdRusakBerat,JSON_PRETTY_PRINT);
  394. }
  395. function cektanggal($strTgl)
  396. {
  397. $arr = split('-', $strTgl); //yyyy-mm-dd
  398.  
  399. return checkdate($arr[1], $arr[2], $arr[0]);
  400.  
  401. }
  402.  
  403. function compareTanggal($strTgl1, $strTgl2)
  404. {
  405. // bandingkan 2 tanggal, return 0. lebih kecil, 1.sama dengan, 2.lebih besar
  406. //format tgl yyyy-mm-dd
  407. $hsl = -1;
  408. $tgl1 = $strTgl1; // strtotime($strTgl1);
  409. $tgl2 = $strTgl2; //strtotime($strTgl2);
  410. if ($tgl1 < $tgl2) {
  411. $hsl = 0; //lebih kecil
  412. } else if ($tgl1 == $tgl2) {
  413. $hsl = 1; //sama dengan
  414. } else {
  415. $hsl = 2; //lebih besar
  416. }
  417. //echo " $tgl1 - $tgl2 = $hsl ";
  418. return $hsl;
  419. }
  420.  
  421. function table_get_rec($sqry)
  422. {
  423. $jml = 0;
  424. $qry = $this->sqlQuery($sqry);
  425. $row = $this->sqlArray($qry);
  426. return $row;
  427. }
  428. function getNilaiBuku($idbi, $tgl, $StSusut){
  429. //berdasar tgl buku
  430. global $Main;
  431. $aqry="select get_nilai_buku($idbi,'$tgl',$StSusut) as NilaiBuku " ;
  432. $get = $this->sqlArray($this->sqlQuery($aqry));
  433. return $get['NilaiBuku'];
  434. }
  435. function getAkumPenyusutan($idbi, $tgl ){
  436. $hrgSusut = 0;
  437. $aqry = "select sf_getAkumSusut('$idbi', '$tgl') as hrg_susut; ";
  438. $qry = $this->sqlQuery($aqry);
  439. while($isi = $this->sqlArray($qry)){
  440. $hrgSusut = $isi['hrg_susut'];
  441. }
  442. return $hrgSusut;
  443. }
  444. }
  445.  
  446. $generateJSON = new GenerateJSON();
  447.  
  448.  
  449. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!