public static function show()
{
$type_id = wbRequest::getVarClean('type_id', 'int', 0);
$tahun = wbRequest::getVarClean('tahun', 'str', '');
//timestamp
$t = wbRequest::getVarClean('t', 'str', '');
if (empty($type_id) or empty($tahun)) {
exit;
}
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pertanian', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$items = $data['items']['items'];
$itemParameter = $data['items']['itemParameter'];
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('rumah_sakit.xls');
}
echo '<div class="body-wrap">';
echo '<div style="float:left;margin:5 5 0 5;">';
echo '<div><h3>PRODUKSI PERTANIAN ' . $itemParameter['param_name'] . ' - TAHUN ' . $tahun . '</h3></div>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" class="table-data" width ="100%">';
}
echo '<tr>
<th width="15">No</th>
<th width="200">Jenis Komoditas</th>
<th width="160">Luas Tanaman(Ha)</th>
<th width="160">Luas Panen(Ha) </th>
<th width="160">Produktivitas(Ku/Ha)</th>
<th width="160">Produksi(Ton)</th>
</tr>';
$i = 1;
foreach ($items as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pertanian', 'method' => 'getProduksiKomoditas', 'type' => '')), 'jsonItems' => json_encode(array('tahun' => $tahun, 'd_agr_komiditas_id' => $item['d_agr_komiditas_id'])));
$ws_data = self::getResultData($ws_client, $params);
$itemProduksi = $ws_data['data'];
//if (empty($itemProduksi))continue;
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['komoditas_name'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemProduksi['luas_tanam'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemProduksi['luas_panen'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemProduksi['productivity'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemProduksi['produksi'], 0) . '</td>';
echo '</tr>';
}
echo '</table>';
exit;
}
public static function show()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_rute_angkutan', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$itemsTrayek = $data['items'];
//timestamp
$tahun = wbRequest::getVarClean('tahun', 'int', '');
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('rute_angkutan.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>JUMLAH ARMADA ANGKUTAN KOTA DI KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br/>';
if (!empty($print)) {
echo '<table border="1" width ="90%">';
} else {
echo '<table border="0" class="table-data" width ="90%">';
}
echo '<tr>';
echo '<th>No</th>';
echo '<th>Kode Trayek</th>';
echo '<th>Lintasan Trayek(Route)</th>';
echo '<th>Jarak(Km)</th>';
echo '<th>Jumlah Armada</th>';
echo '<th>Jumlah Angkot</th>';
echo '</tr>';
$no = 1;
foreach ($itemsTrayek as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_rute_angkutan', 'method' => 'getItem', 'type' => '')), 'jsonItems' => json_encode(array('tahun' => $tahun, 'trayek_id' => $item['trayek_id'])));
$ws_data = self::getResultData($ws_client, $params);
$itemArmada = $ws_data['data'];
if (empty($itemArmada)) {
continue;
}
echo '<tr>';
echo '<td align=center>' . $no++ . '</td>';
echo '<td>' . $item['trayek_code'] . '</td>';
echo '<td>' . $item['trayek_name'] . '</td>';
echo '<td>' . $item['trayek_panjang'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemArmada['armada_jml'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemArmada['armada_jml_angkot'], 0) . '</td>';
echo '</tr>';
}
echo '</table>';
echo '</div>';
echo '</div>';
exit;
}
public static function show()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_puskesmas', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$itemsWilayah = $data['items'];
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('puskesmas.xls');
}
echo '<div class="body-wrap">';
echo '<div style="float:left;margin:5 5 0 5;">';
echo '<div><h3>JUMLAH PUSKESMAS BERDASARKAN KECAMATAN</h3></div>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
echo '<tr>
<th width="30">No</th>
<th width="200">Kode Wilayah</th>
<th width="200">Kecamatan</th>
<th width="100">Jumlah</th>
</tr>';
$i = 1;
$total = 0;
$jumlahPuskesmas = 0;
foreach ($itemsWilayah as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_puskesmas', 'method' => 'getJumlahPerKecamatan', 'type' => '')), 'jsonItems' => json_encode(array('wilayah_id' => $item['wilayah_id'])));
$ws_data = self::getResultData($ws_client, $params);
$jumlahPuskesmas = $ws_data['data'];
$total += $jumlahPuskesmas;
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['wilayah_kode'] . '</td>';
echo '<td>' . $item['wilayah_nama'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($jumlahPuskesmas, 0) . '</td>';
echo '</tr>';
}
echo '<tr>';
echo '<td colspan="3" align="center"> <b>TOTAL PUSKESMAS</b> </td>';
echo '<td align="right"> <b>' . wbUtil::numberFormat($total, 0) . '</b> </td>';
echo '</tr>';
echo '</table>';
echo '</div>';
echo '</div>';
exit;
}
public static function show()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_peternakan', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$itemsJenis = $data['items'];
//timestamp
$tahun = wbRequest::getVarClean('tahun', 'int', '');
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('rumah_sakit.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>POPULASI TERNAK KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br/>';
if (!empty($print)) {
echo '<table border="1" width ="90%">';
} else {
echo '<table border="0" class="table-data" width ="90%">';
}
echo '<tr>';
echo '<th>No</th>';
echo '<th>Jenis Ternak</th>';
echo '<th>Populasi</th>';
echo '<th>Jumlah Potong</th>';
echo '<th>Produksi Daging</th>';
echo '</tr>';
$no = 1;
foreach ($itemsJenis as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_peternakan', 'method' => 'getItem', 'type' => '')), 'jsonItems' => json_encode(array('tahun' => $tahun, 'wilayah_id' => $item['wilayah_id'])));
$ws_data = self::getResultData($ws_client, $params);
$itemTernak = $ws_data['data'];
//if (empty($itemTernak))continue;
echo '<tr>';
echo '<td>' . $no++ . '</td>';
echo '<td>' . $item['param_name'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemTernak['ternak_populasi'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemTernak['ternak_jml_potong'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($itemTernak['ternak_produksi_daging'], 0) . '</td>';
echo '</tr>';
}
echo '</table>';
echo '</div>';
echo '</div>';
exit;
}
public static function show_per_jenis()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_rumahsakit', 'method' => 'show_per_jenis', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$itemsJenis = $data['items'];
$print = wbRequest::getVarClean('print', 'int', 0);
$t = wbRequest::getVarClean('t', 'str', '');
//timestamp
if (!empty($print)) {
wbUtil::startExcel('rumah_sakit.xls');
}
echo '<div class="body-wrap">';
echo '<div style="float:left;margin:5 5 0 5;">';
echo '<div><h3>JUMLAH RUMAH SAKIT BERDASARKAN JENISNYA</h3></div>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
echo '<tr>
<th width="30">No</th>
<th width="200">Jenis Rumah Sakit</th>
<th width="100">Jumlah</th>
</tr>';
$i = 1;
$total = 0;
foreach ($itemsJenis as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_rumahsakit', 'method' => 'getJumlahPerJenis', 'type' => '')), 'jsonItems' => json_encode(array('param_id' => $item['param_id'])));
$ws_data = self::getResultData($ws_client, $params);
$jumlahRS = $ws_data['data'];
$total += $jumlahRS;
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['param_name'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($jumlahRS, 0) . '</td>';
echo '</tr>';
}
echo '<tr>';
echo '<td colspan="2" align="center"> <b>TOTAL RUMAH SAKIT</b> </td>';
echo '<td align="right"> <b>' . wbUtil::numberFormat($total, 0) . '</b> </td>';
echo '</tr>';
echo '</table>';
echo '</div>';
echo '</div>';
exit;
}
public static function show()
{
$level_id = wbRequest::getVarClean('level_id', 'int', 0);
$tahun = wbRequest::getVarClean('tahun', 'str', '');
//timestamp
$t = wbRequest::getVarClean('t', 'str', '');
if (empty($level_id) or empty($tahun)) {
exit;
}
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_pendidikan', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$items = $data['items']['items'];
$itemLevel = $data['items']['itemLevel'];
//$items = $tSchoolType->getAllByLevelID($level_id, $tahun);
//$itemLevel = $tSchoolLevel->get($level_id);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pendidikan_dashboard.xls');
}
echo '<div class="body-wrap">';
echo '<div style="float:left;margin:5 5 0 5;">';
echo '<div><h3>JUMLAH SISWA ' . strtoupper($itemLevel['description']) . ' <br/>BERDASARKAN JENISNYA - TAHUN ' . $tahun . '</h3></div>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" class="table-data" width ="100%">';
}
echo '<tr>
<th width="15">No</th>
<th width="150">Jenis ' . $itemLevel['description'] . '</th>
<th width="100">Jumlah Masuk </th>
<th width="100">Jumlah Lulus </th>
<th width="100">Jumlah Aktif </th>
</tr>';
$i = 1;
$datay = array();
$dataCode = array();
foreach ($items as $item) {
$datay[] = $item['jml_masuk'];
$dataCode[] = $item['code'];
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['code'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($item['jml_masuk'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($item['jml_lulus'], 0) . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($item['jml_aktif'], 0) . '</td>';
echo '</tr>';
}
echo '</table>';
wbCore::loadJPGraph();
// Create the graph and setup the basic parameters
$graph = new Graph(550, 300, 'auto');
$graph->img->SetMargin(40, 30, 40, 40);
$graph->SetScale("textint");
$graph->SetFrame(true, 'white', 1);
$graph->SetColor('#C9C9C9');
$graph->SetMarginColor('#D0DEF0');
// Add some grace to the top so that the scale doesn't
// end exactly at the max value.
//$graph->yaxis->scale->SetGrace(20);
// Setup X-axis labels
$graph->xaxis->SetTickLabels($dataCode);
$graph->xaxis->SetFont(FF_FONT1);
$graph->xaxis->SetColor('#400000', 'black');
// Stup "hidden" y-axis by given it the same color
// as the background
$graph->yaxis->SetColor('lightblue', '#004080');
$graph->ygrid->SetColor('white');
// Setup graph title ands fonts
$graph->title->Set('GRAFIK SISWA ' . strtoupper($itemLevel['description']) . ' - TAHUN ' . $tahun);
// Create a bar pot
$bplot = new BarPlot($datay);
$bplot->SetFillColor('#6C6CFF');
$bplot->SetColor('darkblue');
$bplot->SetWidth(0.5);
$bplot->SetShadow('darkgray');
// Setup the values that are displayed on top of each bar
$bplot->value->Show();
// Must use TTF fonts if we want text at an arbitrary angle
$bplot->value->SetFont(FF_ARIAL, FS_NORMAL, 8);
$bplot->value->SetFormat('%d');
// Black color for positive values and darkred for negative values
$bplot->value->SetColor("black", "darkred");
$graph->Add($bplot);
// Finally stroke the graph
$graph->Stroke('var/dashboard/dashboard_pendidikan.png');
echo '</div>';
echo '</div>';
echo '<div style="float:right;margin:15 5 0 5;"> <img src="' . wbServer::getBaseURL() . 'var/dashboard/dashboard_pendidikan.png?' . $t . '" alt="' . $t . '" /> </div>';
exit;
}
public static function show()
{
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$jenis_jalan = wbRequest::getVarClean('jenis_jalan', 'int', 0);
if (empty($jenis_jalan)) {
exit;
}
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'dashboard_jalan', 'method' => 'show', 'type' => '')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data['items'] = $ws_data['data'];
$data['total'] = $ws_data['total'];
$data['message'] = $ws_data['message'];
$data['success'] = $ws_data['success'];
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$items = $data['items'];
echo '<div class="body-wrap">';
echo '<div style="float:left;margin:5 5 0 5;">';
echo '<div><h3>DATA JALAN</h3></div>';
echo '<table class="table-data">';
echo '<tr>
<th width="30">No</th>
<th width="200">Jenis Jalan</th>
<th width="100">Panjang(Km)</th>
</tr>';
$i = 1;
$datay = array();
$dataCode = array();
foreach ($items as $item) {
$datay[] = $item['panjang'];
$dataCode[] = $item['param_name'];
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['param_name'] . '</td>';
echo '<td align="right">' . wbUtil::numberFormat($item['panjang'], 0) . '</td>';
echo '</tr>';
}
echo '</table>';
wbCore::loadJPGraph();
// Create the graph and setup the basic parameters
$graph = new Graph(550, 300, 'auto');
$graph->img->SetMargin(40, 30, 40, 40);
$graph->SetScale("textint");
$graph->SetFrame(true, 'white', 1);
$graph->SetColor('#C9C9C9');
$graph->SetMarginColor('#D0DEF0');
// Add some grace to the top so that the scale doesn't
// end exactly at the max value.
//$graph->yaxis->scale->SetGrace(20);
// Setup X-axis labels
$graph->xaxis->SetTickLabels($dataCode);
$graph->xaxis->SetFont(FF_FONT1);
$graph->xaxis->SetColor('#400000', 'black');
// Stup "hidden" y-axis by given it the same color
// as the background
$graph->yaxis->SetColor('lightblue', '#004080');
$graph->ygrid->SetColor('white');
// Setup graph title ands fonts
$graph->title->Set('DATA JALAN');
// Create a bar pot
$bplot = new BarPlot($datay);
$bplot->SetFillColor('#6C6CFF');
$bplot->SetColor('darkblue');
$bplot->SetWidth(0.5);
$bplot->SetShadow('darkgray');
// Setup the values that are displayed on top of each bar
$bplot->value->Show();
// Must use TTF fonts if we want text at an arbitrary angle
$bplot->value->SetFont(FF_ARIAL, FS_NORMAL, 8);
$bplot->value->SetFormat('%d');
// Black color for positive values and darkred for negative values
$bplot->value->SetColor("black", "darkred");
$graph->Add($bplot);
// Finally stroke the graph
$graph->Stroke('var/dashboard/dashboard_jalan.png');
echo '</div>';
echo '</div>';
echo '<div style="float:right;margin:15 5 0 5;"> <img src="var/dashboard/dashboard_jalan.png?' . $t . '" alt="' . $t . '" /> </div>';
exit;
}
