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)&nbsp</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)&nbsp</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">&nbsp;' . $itemJumlah['jumlah_l'] . '</td>';
         echo '<td align="right">&nbsp;' . $itemJumlah['jumlah_p'] . '</td>';
         echo '<td align="right">&nbsp;' . $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;'> &gt; 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;'> &lt; 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>&nbsp</td>";
             echo "<td>&nbsp</td>";
             echo "<td>&nbsp</td>";
             echo "</tr>";
             $title = $item['kecamatan'];
             $no_urut_kec++;
         }
         echo "<tr>";
         echo "<td>&nbsp</td>";
         echo "<td>&nbsp</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;
 }