public static function main()
{
if (!wbUser::isLoggedIn()) {
$redirecturl = wbModule::url('bds', 'bds', 'main');
wbResponse::Redirect(wbModule::url('base', 'base', 'loginform', array('redirecturl' => urlencode($redirecturl))));
}
$loadjsmod = wbRequest::getVarClean('loadjsmod', 'str', '');
wbPage::setPage('jspage');
$userInfo = wbUser::getSession();
$role = '';
if (isset($userInfo['roles'][0]['role_name'])) {
$role = strtolower($userInfo['roles'][0]['role_name']);
}
$script = <<<HEREDOC
Webi.ROUTE_URL = "ws.php?type=json&module=bds";
var _UNAME = "{$userInfo['user_name']}";
var _RNAME = "{$userInfo['user_realname']}";
var _GNAME = "{$role}";
HEREDOC;
wbPage::addScriptCode($script);
wbPage::addScript('modules/bds/views/script/properties.js');
wbPage::addScript('modules/bds/views/script/GridPanel.js');
wbPage::addScript('modules/bds/views/script/FormPanel.js');
wbPage::addScript('modules/bds/views/script/ModulePanel.js');
wbPage::addScript('modules/base/views/script/roles-jsloader.php');
wbPage::addScript('modules/bds/views/script/jsloader.php');
return array('loadjsmod' => $loadjsmod);
}
public static function ganti_password($args = array())
{
// Security check
//if (!wbSecurity::check('t_vat_settlement')) return;
// Get arguments from argument array
extract($args);
$email = wbRequest::getVarClean('email', 'str', '');
$npwpd = wbRequest::getVarClean('npwpd', 'str', '');
$user_name = wbRequest::getVarClean('user_name', 'str', '');
$question = wbRequest::getVarClean('question', 'str', '');
$answer = wbRequest::getVarClean('answer', 'str', '');
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
try {
$table =& wbModule::getModel('bds', 't_vat_settlement');
$query = "select dbms_random.string('x',10) AS new_password";
$new_password = $table->dbconn->GetOne($query);
$query = "update p_app_user set user_pwd = md5('" . $new_password . "') where app_user_name = '" . $user_name . "'";
$table->dbconn->Execute($query);
$query = "update t_customer_user set user_pwd = md5('" . $new_password . "') where user_name = '" . $user_name . "'";
$table->dbconn->Execute($query);
$data['items'] = '';
$data['total'] = '';
$data['success'] = true;
$data['message'] = $new_password;
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
return $data;
}
function wbMain()
{
wbCore::init();
list($module, $class, $method) = wbRequest::getController();
// theme override
$theme = wbRequest::getVarClean('theme');
if (!empty($theme)) {
wbPage::setTheme($theme);
}
$page = wbRequest::getVarClean('page');
if (!empty($page)) {
wbPage::setPage($page);
}
ob_start();
$modView = wbModule::getView($module, $class, $method);
if (ob_get_length() > 0) {
$rawOutput = ob_get_contents();
$modView = 'The following lines were printed in raw mode by module, however this
should not happen. The module is probably directly calling functions
like echo, print, or printf. Please modify the module to exclude direct output.
The module is violating Webi architecture principles.<br /><br />' . $rawOutput . '<br /><br />This is the real module output:<br /><br />' . $modView;
}
ob_end_clean();
wbPage::render($modView);
}
public static function angin()
{
$sort = wbRequest::getVarClean('sort', 'str', 't_cuaca_id');
$dir = wbRequest::getVarClean('dir', 'str', 'DESC');
$query = wbRequest::getVarClean('query', 'str', '');
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$jenis = wbRequest::getVarClean('jenis', 'int', 0);
try {
$table =& wbModule::getModel('bds', 't_cuaca');
//Set default criteria. You can override this if you want
foreach ($table->fields as $key => $field) {
if (!empty(${$key})) {
// <-- Perhatikan simbol $$
if ($field['type'] == 'str') {
$table->setCriteria($table->getAlias() . $key . $table->likeOperator . '?', array(${$key}));
} else {
$table->setCriteria($table->getAlias() . $key . ' = ?', array(${$key}));
}
}
}
$query = $table->getDisplayFieldCriteria($query);
if (!empty($query)) {
$table->setCriteria($query);
}
$items = $table->getAll(0, -1, $sort, $dir);
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$data['items'] = $items;
$data['success'] = true;
return $data;
}
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 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 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 tampil()
{
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$wilayah =& wbModule::getModel('bds', 'p_parameter');
$items = $wilayah->pbb_sppt($tahun);
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$data['items'] = $items;
$data['success'] = true;
return $data;
}
public static function getItem()
{
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$tTernak =& wbModule::getModel('bds', 't_ternak');
$itemTernak = $tTernak->getItem($item['tahun'], $item['param_id']);
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $itemTernak;
return $data;
}
public static function getJumlahPerKecamatan()
{
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$tPuskesmas =& wbModule::getModel('bds', 'd_puskesmas');
$jumlah = $tPuskesmas->getJumlahPerKecamatan($item['wilayah_id']);
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $jumlah;
return $data;
}
public static function getItem()
{
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$tArmada =& wbModule::getModel('bds', 't_armada');
$itemArmada = $tArmada->getItem($item['tahun'], $item['trayek_id']);
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $itemArmada;
return $data;
}
public static function getJumlahPerJenis()
{
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$tRumahSakit =& wbModule::getModel('bds', 'd_rumahsakit');
$jumlah = $tRumahSakit->getJumlahPerJenis($item['param_id']);
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $jumlah;
return $data;
}
public static function tampil()
{
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$daerah =& wbModule::getModel('bds', 'd_pasar');
$items = $daerah->rekapPasar($tahun);
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$data['items'] = $items;
$data['success'] = true;
return $data;
}
public static function getProduksiKomoditas()
{
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$tProduksi =& wbModule::getModel('bds', 't_agr_komod_prod');
$itemProduksi = $tProduksi->getProduksiKomoditas($item['tahun'], $item['d_agr_komiditas_id']);
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $itemProduksi;
return $data;
}
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;
}
function ws_proccess($search, $getParams, $controller, $postParams, $jsonItems, $start, $limit)
{
$GLOBALS["Webi_PageTime"] = microtime(true);
include 'lib/bootstrap.php';
/* Load Webi Core */
sys::import('webi.core');
wbCore::init();
$_GET['jsonItems'] = $jsonItems;
if (!empty($getParams)) {
$getParams =& wbUtil::jsonDecode($getParams);
} else {
$getParams = array();
}
if (json_decode($postParams) > 0) {
$postParams = json_decode($postParams);
} else {
$postParams = array();
}
$controller =& wbUtil::jsonDecode($controller);
$type = $controller['type'];
if (!empty($getParams)) {
foreach ($getParams as $key => $value) {
$_GET[$key] = $value;
}
}
if (!empty($postParams)) {
foreach ($postParams as $key => $value) {
$_POST[$key] = $value;
}
}
$_GET['module'] = $controller['module'];
$_GET['class'] = $controller['class'];
$_GET['method'] = $controller['method'];
list($module, $class, $method) = wbRequest::getController();
$callback = wbRequest::getVarClean('callback');
if (!wbModule::isAvailable($module, $class, $type)) {
header("HTTP/1.1 400 Bad Request");
return;
}
try {
$result = wbModule::call($module, $class, $method, array(), $type);
} catch (Exception $e) {
$result = array('items' => array(), 'total' => 0, 'success' => false, 'message' => $e->getMessage());
}
$return = array();
$return['success'] = $result['success'];
$return['message'] = $result['message'];
$return['total'] = (int) $result['total'];
$return['data'] = $result['items'];
$return['current'] = (int) $result['current'];
$return['rowCount'] = (int) $result['rowCount'];
$return = base64_encode(serialize($return));
return $return;
}
public static function tampil()
{
$tahun = wbRequest::getVarClean('tahun', 'int', 0);
$tahun_akhir = wbRequest::getVarClean('tahun_akhir', 'int', 0);
$industri =& wbModule::getModel('bds', 't_industri');
$items = $industri->rekapIndustriTahun($tahun, $tahun_akhir);
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$data['items'] = $items;
$data['success'] = true;
return $data;
}
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;
}
/**
* read
* controler for get all items
*/
public static function read($args = array())
{
// Security check
//if (!wbSecurity::check('p_vat_type')) return;
// Get arguments from argument array
extract($args);
$start = wbRequest::getVarClean('start', 'int', 0);
$limit = wbRequest::getVarClean('limit', 'int', 50);
$sort = wbRequest::getVarClean('sort', 'str', 'p_region_id');
$dir = wbRequest::getVarClean('dir', 'str', 'ASC');
$query = wbRequest::getVarClean('query', 'str', '');
$p_region_id = wbRequest::getVarClean('p_region_id', 'int', 0);
$parent_id = wbRequest::getVarClean('parent_id', 'int', 0);
$description = wbRequest::getVarClean('description', 'str', '');
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
try {
$table =& wbModule::getModel('bds', 'p_sub_region');
//Set default criteria. You can override this if you want
foreach ($table->fields as $key => $field) {
if (!empty(${$key})) {
// <-- Perhatikan simbol $$
if ($field['type'] == 'str') {
$table->setCriteria($table->getAlias() . $key . $table->likeOperator . '?', array(${$key}));
} else {
$table->setCriteria($table->getAlias() . $key . ' = ?', array(${$key}));
}
}
}
if (!empty($parent_id)) {
$table->setCriteria('parent_id = ', array($parent_id));
} else {
$table->setCriteria("parent_id = 749");
}
if (!empty($code)) {
$table->setCriteria('(code ILIKE ?)', array('%' . $code . '%'));
}
$query = $table->getDisplayFieldCriteria($query);
if (!empty($query)) {
$table->setCriteria($query);
}
$items = $table->getAll($start, $limit, $sort, $dir);
$total = $table->countAll();
$data['items'] = $items;
$data['total'] = $total;
$data['success'] = true;
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
return $data;
}
public static function send_email()
{
$email = wbRequest::getVarClean('email', 'str', '');
$npwpd = wbRequest::getVarClean('npwpd', 'str', '');
$user_name = wbRequest::getVarClean('user_name', 'str', '');
$question = wbRequest::getVarClean('question', 'str', '');
$answer = wbRequest::getVarClean('answer', 'str', '');
$msg = '';
if (empty($npwpd) or empty($email) or empty($user_name) or empty($answer)) {
$msg .= 'Semua isian harus diisi. ';
}
if (!empty($msg)) {
wbResponse::Redirect(wbModule::url('bds', 'helper', 'lupa_password', array('email' => $email, 'npwpd' => $npwpd, 'user_name' => $user_name, 'question' => $question, 'answer' => $answer, 'errorMsg' => $msg)));
}
/*cek jabawan*/
try {
$ws_client = self::getNusoap();
$data2 = array();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'helper', 'method' => 'cek_jawaban', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data2['items'] = $ws_data['data'];
$data2['total'] = $ws_data['total'];
$data2['message'] = $ws_data['message'];
$data2['success'] = $ws_data['success'];
} catch (Exception $e) {
$data2['message'] = $e->getMessage();
}
$items = $data2['items'];
if ($data2['total'] > 0 and $data2['success']) {
/* Ganti Password*/
try {
$ws_client = self::getNusoap();
$data3 = array();
$params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 'helper', 'method' => 'ganti_password', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit);
$ws_data = self::getResultData($ws_client, $params);
$data3['items'] = $ws_data['data'];
$data3['total'] = $ws_data['total'];
$data3['message'] = $ws_data['message'];
$data3['success'] = $ws_data['success'];
} catch (Exception $e) {
$data3['message'] = $e->getMessage();
}
/* Kirim Email */
$new_password = $data3['message'];
$respons = file_get_contents('http://202.154.24.3:81/mpd/send_email_forgot_password.php?receiver=' . $email . '&username='******'&password='******'bds', 'helper', 'lupa_password', array('errorMsg' => 'Password Berhasil Diubah. Silahkan cek email Anda untuk mengetahui password terbaru Anda.')));
} else {
wbResponse::Redirect(wbModule::url('bds', 'helper', 'lupa_password', array('email' => $email, 'npwpd' => $npwpd, 'user_name' => $user_name, 'question' => $question, 'answer' => $answer, 'hasil_query' => $items, 'errorMsg' => 'Data yang cocok tidak ditemukan.' . $data2['message'])));
}
}
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_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 show()
{
$tJalan =& wbModule::getModel('bds', 'd_jalan');
$jenis_jalan = wbRequest::getVarClean('jenis_jalan', 'int', 0);
//timestamp
$t = wbRequest::getVarClean('t', 'str', '');
if (empty($jenis_jalan)) {
exit;
}
$items = $tJalan->getAllByJenisJalan($jenis_jalan);
$data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => '');
$data['items'] = $items;
$data['success'] = true;
return $data;
}
public static function login()
{
$redirecturl = wbRequest::getVarClean('redirecturl');
$username = wbRequest::getVarClean('username');
$password = wbRequest::getVarClean('password');
try {
$uid = wbUser::logIn($username, $password);
if (!empty($redirecturl)) {
wbResponse::Redirect($redirecturl);
} else {
wbResponse::Redirect('index.php');
}
} catch (UserLoginFailedException $e) {
wbResponse::Redirect(wbModule::url('base', 'base', 'loginform', array('username' => $username, 'redirecturl' => urlencode($redirecturl), 'msg' => $e->getMessage())));
}
}
public static function getCountByPendidikanID()
{
$tWarga =& wbModule::getModel('bds', 'd_warga');
$jsonItems = wbRequest::getVarClean('jsonItems', 'str', '');
$item = wbUtil::jsonDecode($jsonItems);
$jumlah = $tWarga->getCountByAge($item['param_id']);
$jumlah_l = $tWarga->getCountByAge($item['param_id'], 6);
$jumlah_p = $tWarga->getCountByAge($item['param_id'], 7);
$itemJumlah = array();
$itemJumlah['jumlah'] = $jumlah;
$itemJumlah['jumlah_l'] = $jumlah_l;
$itemJumlah['jumlah_p'] = $jumlah_p;
$data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => '');
$data['items'] = $itemJumlah;
return $data;
}
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;
}