<?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
