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 tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pbb', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pbb.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>DAFTAR JUMLAH SPPT DAN POKOK KETETAPAN PBB MENURUT KECAMATAN DI KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
$output = "<tr>";
$output .= "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>NO</th>";
$output .= "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Kecamatan</br><div style='font-style: italic;'>District</div></th>";
$output .= "<th colspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-top: 1px solid black;'>" . $tahun . "</br></th>";
$output .= "</tr>";
$output .= "<tr>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>PBB</br>(buah)</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>PBB Terhutang</th>";
$output .= "</tr>";
$title = "";
$no = 1;
$t_buah = 0;
$t_terhutang = 0;
foreach ($items as $item) {
$output .= "<tr>";
$output .= "<td width=50 align=center>" . $no . "</td>";
$output .= "<td>" . $item['wilayah_nama'] . "</td>";
$output .= "<td align='center'>" . number_format($item['sppt_pbb_buah'], 0, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['sppt_pbb_terhutang'], 0, ',', '.') . "</td>";
$output .= "</tr>";
$t_buah += $item['sppt_pbb_buah'];
$t_terhutang += $item['sppt_pbb_terhutang'];
$no++;
}
$output .= "<tr>";
$output .= "<th colspan=2 style='text-align:center;border-bottom: 1px solid black;border-top: 1px solid black;'>Kota Bandung</br><div style='font-style: italic;'>Bandung City</div></th>";
$output .= "<th style='text-align:center;border-bottom: 1px solid black;border-top: 1px solid black;'>" . number_format($t_buah, 0, ',', '.') . "</th>";
$output .= "<th style='text-align:center;border-bottom: 1px solid black;border-top: 1px solid black;'>" . number_format($t_terhutang, 0, ',', '.') . "</th>";
$output .= "</tr>";
$output .= "</table>";
echo $output;
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 tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pajak_daerah', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pajak_daerah.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>JUMLAH PENERIMAAN PAJAK DAERAH MENURUT JENIS PAJAK DAN PERSENTASE TARGET YANG DICAPAI KOTA BANDUNG </br>TAHUN ANGGARAN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
$output = "<tr>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>NO</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>JENIS PENERIMAAN</br><div style='font-style: italic;'>TYPE OF RECEIPTS</div></th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>TARGET</br><div style='font-style: italic;'>TARGET</div>(Rp 000) </th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>REALISASI</br><div style='font-style: italic;'>REALISATION</div>(Rp 000) </th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>PERSENTASE</br><div style='font-style: italic;'>PERCENTAGE</div>(%)</th>";
$output .= "</tr>";
$title = "";
$no = 1;
$t_persen = 0;
$t_real = 0;
$t_target = 0;
foreach ($items as $item) {
$output .= "<tr>";
$output .= "<td width=50 align=center>" . $no . "</td>";
$output .= "<td>" . $item['param_name'] . "</td>";
$output .= "<td align='center'>" . number_format($item['pjk_daerah_target'], 0, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['pjk_daerah_realisasi'], 0, ',', '.') . "</td>";
$jumlah = !empty($item['pjk_daerah_target']) ? $item['pjk_daerah_realisasi'] / $item['pjk_daerah_target'] * 100 : 0;
$output .= "<td align='center'>" . number_format($jumlah, 2, ',', '.') . "</td>";
$output .= "</tr>";
$t_persen += $jumlah;
$t_real += $item['pjk_daerah_realisasi'];
$t_target += $item['pjk_daerah_target'];
$no++;
}
$output .= "</table>";
echo $output;
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 pendidikan()
{
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_penduduk', 'method' => 'pendidikan', '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();
print_r("Error:" . $data['message']);
exit;
}
$items = $data['items'];
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pendidikan_penduduk.xls');
}
echo '<div class="body-wrap">';
echo '<div><h3>JUMLAH PENDUDUK MENURUT KELOMPOK PENDIDIKAN</h3></div>';
if (!empty($print)) {
echo '<table border=1 class="table-data">';
} else {
echo '<table class="table-data">';
}
echo '<tr>
<th width="30">No</th>
<th width="150">Pendidikan</th>
<th width="150">Jumlah Laki-laki</th>
<th width="150">Jumlah Perempuan</th>
<th width="150">Jumlah Total</th>
</tr>';
$i = 1;
foreach ($items as $item) {
$params = array('controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_penduduk', 'method' => 'getCountByPendidikanID', 'type' => '')), 'jsonItems' => json_encode(array('param_id' => $item['param_id'])));
$ws_data = self::getResultData($ws_client, $params);
$itemJumlah = $ws_data['data'];
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $item['param_name'] . '</td>';
echo '<td align="right"> ' . $itemJumlah['jumlah_l'] . '</td>';
echo '<td align="right"> ' . $itemJumlah['jumlah_p'] . '</td>';
echo '<td align="right"> ' . $itemJumlah['jumlah'] . '</td>';
echo '</tr>';
}
echo '</table>';
exit;
}
public static function tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_industri', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('industri.xls');
}
echo '<div class="body-wrap">';
if ($tahun != $tahun_akhir) {
echo '<div align="center"><h3>BANYAKNYA PERUSAHAAN INDUSTRI BESAR DAN SEDANG DAN TENAGA KERJA YANG DAPAT DISERAP DI KOTA BANDUNG TAHUN ' . $tahun . ' - ' . $tahun_akhir . '</h3></div><br>';
} else {
echo '<div align="center"><h3>BANYAKNYA PERUSAHAAN INDUSTRI BESAR DAN SEDANG DAN TENAGA KERJA YANG DAPAT DISERAP DI KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br>';
}
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
$output = "<tr>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Tahun<div style='font-style: italic;'>Year</div></th></th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Banyaknya Usaha</br><div style='font-style: italic;'>Number Of Establishment</div></th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Tenaga Kerja</br><div style='font-style: italic;'>Man Power</div></th>";
$output .= "</tr>";
$no = 1;
foreach ($items as $item) {
$output .= "<tr>";
$output .= "<td>" . $no . "</td>";
$output .= "<td>" . $item['industri_tahun'] . "</td>";
$output .= "<td align='center'>" . number_format($item['tot_industri'], 0, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['tot_pekerja'], 0, ',', '.') . "</td>";
$output .= "</tr>";
$no++;
}
$output .= "</table>";
echo $output;
exit;
}
public static function tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pasar_modern', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pasar_modern.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>PASAR MODERN DI KOTA BANDUNG MENURUT JENIS DAN LUAS GERAI TAHUN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
$output = "<tr>";
$output .= "<th rowspan='2' style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
$output .= "<th rowspan='2' style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>JENIS PASAR / <div style='font-style: italic;display: inline;'>MARKET TYPE</div></th></th>";
$output .= "<th colspan='2' style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah / <div style='font-style: italic;display: inline;'>NUMBER</div></th>";
$output .= "</tr>";
$output .= "<tr>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'> > 2000 M2 </th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'> < 2000 M2 </th>";
$output .= "</tr>";
$no = 1;
foreach ($items as $item) {
$output .= "<tr>";
$output .= "<td align='center'>" . $no . "</td>";
$output .= "<td>" . $item['param_name'] . "</td>";
$output .= "<td align='center'>" . number_format($item['mmart_luas_gt_2000'], 0, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['mmart_luas_lt_2000'], 0, ',', '.') . "</td>";
$output .= "</tr>";
$no++;
}
$output .= "</table>";
echo $output;
exit;
}
public static function tampil()
{
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$jenis = wbRequest::getVarClean('jenis', 'int', 0);
$kelompok = array('1' => 'Usia', '2' => 'Pendidikan');
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_rekap_penduduk', 'method' => 'tampil', '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'];
//timestamp
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('rekap_penduduk.xls');
}
echo '<div class="body-wrap">';
echo '<div><h3>JUMLAH PENDUDUK MENURUT KELOMPOK ' . strtoupper($kelompok[$jenis]) . '</h3></div>';
if (!empty($print)) {
echo '<table border=1 class="table-data">';
} else {
echo '<table class="table-data">';
}
echo '<tr>
<th width="30" style="text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;">No</th>
<th width="150" style="text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;">' . $kelompok[$jenis] . '</th>
<th width="150" style="text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;">Jumlah Laki-laki</th>
<th width="150" style="text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;">Jumlah Perempuan</th>
<th width="150" style="text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;">Jumlah Total</th>
</tr>';
$i = 1;
foreach ($items as $item) {
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td align="center"><b>' . $item['kelompok'] . '</b></td>';
echo '<td align="right">' . $item['laki'] . '</td>';
echo '<td align="right">' . $item['perempuan'] . '</td>';
echo '<td align="right">' . ($item['laki'] + $item['perempuan']) . '</td>';
echo '</tr>';
}
echo '</table>';
exit;
}
public static function tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pasar_daerah', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pasar_daerah.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>PASAR TRADISIONAL DI KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
echo "<tr>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Nama Pasar</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah Ruang</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Pedagang Aktif</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Pedagang Pasif</th>";
echo "</tr>";
$no = 1;
foreach ($items as $item) {
echo "<tr>";
echo "<td align='center'>" . $no . "</td>";
echo "<td>" . $item['pasar_name'] . "</td>";
echo "<td align='right'>" . number_format(!empty($item['jum_ruang']) ? $item['jum_ruang'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['aktif']) ? $item['aktif'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['pasif']) ? $item['pasif'] : 0, 0, ',', '.') . "</td>";
echo "</tr>";
$no++;
}
echo "</table>";
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 tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pemerintahan', 'method' => 'tampil', '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'];
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pemerintahan.xls');
}
//timestamp
echo '<html>';
echo '<div class="body-wrap">';
echo '<div align="center"><h3>BANYAKNYA RT DAN RW PER KELURAHAN DAN KECAMATAN DI KOTA BANDUNG</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
echo "<tr>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Kecamatan</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Kelurahan</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah RT</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah RW</th>";
echo "</tr>";
$title = "";
$no_urut_kec = 1;
foreach ($items as $item) {
if ($title != $item['kecamatan']) {
echo "<tr>";
echo "<td align='center'>" . $no_urut_kec . "</td>";
echo "<td>" . strtoupper($item['kecamatan']) . "</td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "</tr>";
$title = $item['kecamatan'];
$no_urut_kec++;
}
echo "<tr>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td>" . $item['kelurahan'] . "</td>";
echo "<td align='right'>" . $item['jum_rt'] . "</td>";
echo "<td align='right'>" . $item['jum_rw'] . "</td>";
echo "</tr>";
}
echo "</table></div>";
echo '</html>';
session_write_close();
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 angin()
{
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$jenis = wbRequest::getVarClean('jenis', 'int', 0);
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_cuaca', 'method' => 'angin', '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'];
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('cuaca_udara.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>CUACA MENURUT BULAN DAN KECEPATAN ANGIN (KNOT) DI KOTA BANDUNG PADA TAHUN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
$output = "<tr>";
$output .= "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
$output .= "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Bulan</br><div style='font-style: italic;'>Month</div></th>";
$output .= "<th colspan=4 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Angin(Knot)</th>";
$output .= "</tr>";
$output .= "<tr>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Kecepatan Rata-Rata</br><div style='font-style: italic;'>Speed Average</div>(mb)</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Arah Terbanyak</br><div style='font-style: italic;'>Mostly Directional</div>(mb)</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Kecepatan Terbesar</br><div style='font-style: italic;'>Mostly Velocity</div>(%)</th>";
$output .= "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Arah</br><div style='font-style: italic;'>Direction</div>(mb)</th>";
$output .= "</tr>";
$title = "";
$no = 1;
foreach ($items as $item) {
$output .= "<tr>";
$output .= "<td align='center'>" . $no . "</td>";
$output .= "<td>" . wbUtil::getMonthNames($item['bulan']) . " / <div style='display:inline;font-style: italic;'>" . wbUtil::getMonthFull($item['bulan']) . "</div></td>";
$output .= "<td align='center'>" . number_format($item['angin_rata2'], 2, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['arah_rata2'], 2, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['angin_max'], 2, ',', '.') . "</td>";
$output .= "<td align='center'>" . number_format($item['arah_max'], 2, ',', '.') . "</td>";
$output .= "</tr>";
$no++;
}
$output .= "</table>";
echo $output;
exit;
}
public static function tampil()
{
try {
$ws_client = self::getNusoap();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'statistik_pariwisata', 'method' => 'tampil', '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'];
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$print = wbRequest::getVarClean('print', 'int', 0);
if (!empty($print)) {
wbUtil::startExcel('pariwisata.xls');
}
echo '<div class="body-wrap">';
echo '<div align="center"><h3>JUMLAH PENGUNJUNG DAN TENAGA KERJA OBYEK WISATA. TAMAN REKREASI / MUSEUM DI KOTA BANDUNG TAHUN ' . $tahun . '</h3></div><br>';
if (!empty($print)) {
echo '<table border="1" width ="100%">';
} else {
echo '<table border="0" width ="100%">';
}
echo "<tr>";
echo "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>No</th>";
echo "<th rowspan=2 style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jenis Objek Wisata</th>";
echo "<th colspan=3 style='text-align:center;background-color: rgb(224, 224, 224);border-top: 1px solid black;'>Wisatawan</th>";
echo "<th colspan=3 style='text-align:center;background-color: rgb(224, 224, 224);border-top: 1px solid black;'>Tenaga Kerja</th>";
echo "</tr>";
echo "<tr>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Domestik</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Mancanegara</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Laki-laki</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Perempuan</th>";
echo "<th style='text-align:center;background-color: rgb(224, 224, 224);border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah</th>";
echo "</tr>";
$no = 1;
$tot_domestik = 0;
$tot_lokal = 0;
$tot_domlok = 0;
$tot_laki = 0;
$tot_wanita = 0;
$tot_laki_wanita = 0;
foreach ($items as $item) {
echo "<tr>";
echo "<td align='center'>" . $no . "</td>";
echo "<td>" . $item['wisata_name'] . "</td>";
echo "<td align='right'>" . number_format(!empty($item['wisdom']) ? $item['wisdom'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['wisman']) ? $item['wisman'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['jum_wis']) ? $item['jum_wis'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['peg_pria']) ? $item['peg_pria'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['peg_wanita']) ? $item['peg_wanita'] : 0, 0, ',', '.') . "</td>";
echo "<td align='right'>" . number_format(!empty($item['jum_peg']) ? $item['jum_peg'] : 0, 0, ',', '.') . "</td>";
echo "</tr>";
$no++;
$tot_domestik += $item['wisdom'];
$tot_lokal += $item['wisman'];
$tot_domlok += $item['jum_wis'];
$tot_laki += $item['peg_pria'];
$tot_wanita += $item['peg_wanita'];
$tot_laki_wanita += $item['jum_peg'];
}
echo "<tr>";
echo "<th colspan=2 style='text-align:center;border-bottom: 1px solid black;border-top: 1px solid black;'>Jumlah / <div style='font-style: italic;display: inline;'>Total</div></th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_domestik . "</th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_lokal . "</th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_domlok . "</th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_laki . "</th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_wanita . "</th>";
echo "<th style='text-align:right;border-bottom: 1px solid black;border-top: 1px solid black;'>" . $tot_laki_wanita . "</th>";
echo "</tr>";
echo "</table>";
exit;
}