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; }