1, 'html'=>""]; if ($tahun == 0 || Param::Get("reset", 0) == 1) { $form = new Form($db); $lthn = $form->option("_", "OPTION_THN", $tahun, true, false, tahun_ang()); $lbln = $form->option("_", "OPTION_BLN", $bulan, true, false, bulan_array()); $ajson['aktif'] = 0; $ajson['html'] = '

Bulan Data

'.$lbln.'

Tahun Data

'.$lthn.'

'; } } else if ( $data == "periode-simpan" ) { // penyimpanan periode tahun dan bulan login ! $alogin = $_SESSION['__WEB_APP']; $alogin['REAL_THN'] = Param::Get("OPTION_THN", $alogin['REAL_THN']); $alogin['REAL_BLN'] = Param::Get("OPTION_BLN", $alogin['REAL_BLN']); // mapping tahun nomenklatur submap $alogin['SUBMAP_TAHUN'] = map_tahun_submap($alogin['REAL_THN']); $alogin['REAL_FIELD'] = "_".isi_nol($alogin['REAL_BLN'], 2); $_SESSION['__WEB_APP'] = $alogin; $ajson['sukses'] = 1; } else if ( $data == "periode-info") { $ajson = ['html'=>'']; if ($tahun > 0) { $txtinfo = bulan_array()[$bulan] .' '.$tahun; $ajson['html'] = ''.$txtinfo.''; } } else if ( $data == "json-map" ) { $amap = json_decode(file_get_contents(__DIR__."/../../assets/json/map_mempawah.json"), true); echo json_encode($amap); exit; } else if ( $data == "chart-map" ) { $tot_pagu = 0; $ajson['data'] = []; $db->Query("SELECT SUM(Rupiah".$field_map.") Pagu FROM sapi_keg WHERE Tahun='".$tahun."'"); if ($db->Next()) $tot_pagu = $db->Row("Pagu", 0); $db->Query("SELECT IFNULL(L.LokasiID,0) LokasiID,A.Pagu FROM (SELECT KecID,SUM(Rupiah".$field_map.") Pagu FROM sapi_keg WHERE Tahun='".$tahun."' GROUP BY KecID) A LEFT JOIN para_lokasi L ON (L.LokasiID=A.KecID)"); while ($db->Next()) { if ($db->Row("LokasiID", 0) == 0) continue; $ajson['data'][] = ['id_kec'=>$db->Row("LokasiID"), 'value'=>uang2($db->Row("Pagu",0)>0?$tot_pagu/$db->Row("Pagu",0):0)]; } } else if ( $data == "chart-bar" ) { $ajson['tipe'] = "chart"; $db->Query("SELECT IFNULL(L.LokasiID,0) LokasiID,L.N_Lokasi,S.* FROM (SELECT KecID,SUM(IF(Jenis=1,Rupiah".$field_map.",0)) POK,SUM(IF(Jenis=2,Rupiah".$field_map.",0)) MUS,SUM(IF(Jenis=3,Rupiah".$field_map.",0)) REN FROM sapi_keg WHERE Tahun='".$tahun."' GROUP BY KecID) S LEFT JOIN para_lokasi L ON (L.LokasiID=S.KecID) ORDER BY L.K_Lokasi"); $adata['datasets'] = []; $adata['labels'] = []; $atmp1 = [0]; $atmp2 = [0]; $atmp3 = [0]; $adata['labels'][] = "Belum Ada Data Usulan"; if ($db->RecordCount()>0) { $atmp1 = []; $atmp2 = []; $atmp3 = []; $adata['labels'] = []; } while ($db->Next()){ if ($db->Row("LokasiID", 0) == 0) continue; $atmp1[] = round($db->Row("MUS"), 2); $atmp2[] = round($db->Row("POK"), 2); $atmp3[] = round($db->Row("REN"), 2); $adata['labels'][] = $db->Row("N_Lokasi"); } $adata['datasets'][] = ['data'=>$atmp1, 'label'=>"Asmas", 'backgroundColor'=>random_color(), 'order'=>1, 'datalabels'=>['align'=>"end", 'anchor'=>"end", 'color'=>"#d9eb36"]]; $adata['datasets'][] = ['data'=>$atmp2, 'label'=>"Pokir", 'backgroundColor'=>random_color(), 'order'=>2, 'datalabels'=>['align'=>"end", 'anchor'=>"end", 'color'=>"#36eb45"]]; $adata['datasets'][] = ['data'=>$atmp3, 'label'=>"Renja", 'backgroundColor'=>random_color(), 'order'=>3, 'datalabels'=>['align'=>"end", 'anchor'=>"end", 'color'=>"#4836eb"]]; $ajson['chart'] = ['type' => "bar", 'data' => $adata, 'options' => [ 'plugins' => [ 'title' => ['display' => true, 'text' => 'Penyebaran Pagu di Kecamatan', 'font' => [ 'size' => 20 ]], 'legend' => ['position' => "bottom"], 'tooltip' => [ 'mode' => 'index' ], ], 'responsive' => true, 'aspectRatio' => 1.5, 'layout' => ['padding' => ['top' => 10]], ] ]; } else if ( $data == "default" ) { $aapp = $_SESSION['__WEB_APP']; $ajson['content'] = '

'.$aapp['REG_ADDRESS'].'
'.$aapp['REG_CITY'].' '.$aapp['REG_POSTCODE'].'

Register ID : '.Register::reg_id().'

'.$aapp['APP_NAMES'].'
'.$aapp['APP_NAME'].' Ver. '.$aapp['APP_VER'].'
Updated : '.$aapp['APP_UPDATED'].'

'; } send_json($ajson); ?>