<?php header('Content-Type: text/xml'); echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; require ('../config/config.php'); include ('../function/tanggal/tanggal.php'); include "../report/report_engine.php"; include "report_services.php"; //echo 'ada'; $REPORT=new report_engine(); $REPORT_SERVICES = new REPORT_SERVICES(); //echo 'ada'; list ($tanggal_awal, $bulan_awal, $tahun_awal) = explode ('-',$get_tanggal_awal); list ($tanggal_akhir, $bulan_akhir, $tahun_akhir) = explode ('-',$get_tanggal_akhir); $tgl_awal = "$tahun_awal-$bulan_awal-$tanggal_awal"; $tgl_akhir = "$tahun_akhir-$bulan_akhir-$tanggal_akhir"; $parameter = array( 'tgl_awal'=>$tgl_awal, 'tgl_akhir'=>$tgl_akhir ); $filter_satker = $REPORT->_cek_data_satker_mutasi($parameter); if ($filter_satker) { $filter_satker_mutasi = $REPORT->get_rekap_laporan_mutasi($filter_satker, $tgl_awal, $tgl_akhir);
<?php header('Content-Type: text/xml'); echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; require '../config/config.php'; include '../function/tanggal/tanggal.php'; include "../report/report_engine.php"; include "report_services.php"; $REPORT = new report_engine(); $REPORT_SERVICES = new REPORT_SERVICES(); if ($status == 'get') { $modul = $_REQUEST['menuID']; $mode = $_REQUEST['mode']; $tab = $_REQUEST['tab']; $kelompok = $_REQUEST['kelompok_id1']; $tahun = $_REQUEST['tahun_1']; //$namabarang = $_REQUEST['namabarang']; //$nama_satker = $_REQUEST['Satker_ID']; //$kib = $_REQUEST['kib']; //$skpd_id = $_REQUEST['skpd_id']; $data = array("modul" => $modul, "mode" => $mode, "tahun_prc" => $tahun, "skpd_id" => $skpd_id, "kelompok" => $kelompok, "tab" => $tab); //mendeklarasikan report_engine. FILE utama untuk reporting //menggunakan api untuk query berdasarkan variable yg telah dimasukan $REPORT->set_data($data); //mendapatkan jenis query yang digunakan //$query=$REPORT->list_query(); /*echo $query; exit;*/ $query = "select STD.Spesifikasi,STD.NilaiStandar,STD.Keterangan,STD.TglUpdate,K.Kelompok_ID,K.Uraian from StandarHarga as STD \n left outer join Kelompok as K on STD.Kelompok_ID=K.Kelompok_ID \n where STD.StatusPemeliharaan is not null {$limit}"; /*$query = "SELECT PRC.NamaAset as namabarang, K.Kelompok_ID as Kelompok_ID, STD.StatusPemeliharaan AS StatusPemeliharaan, A.Satuan as satuan, STD.NilaiStandar as NilaiPerolehan, STD.Keterangan as keterangan, STD.Spesifikasi as spesifikasi, S.NamaSatker as NamaSatker, S.Satker_ID as Satker_ID FROM Perencanaan PRC