Example #1
0
	function list_data($val) {
		unset($_SESSION[keuangan][lap_keuangan_bulanan]);
		//get data karcis dan BHP
		$objResponse = new xajaxResponse;
		$kon = new Konek;
		$title = "Laporan Keuangan Bulanan";
		$title .= "\nTahun " . $val[tahun];
		$sql = "
			SELECT
				MONTH(kw.tgl) as bulan,
				SUM(kb.mampu_bayar_bhp+kb.mampu_bayar_jasa) as bayar,
				CASE
					WHEN rk.cara_bayar IS NOT NULL THEN rk.cara_bayar
					WHEN lk.cara_bayar IS NOT NULL THEN lk.cara_bayar
					ELSE kk.cara_bayar
				END as cara_bayar,
				CASE
					WHEN rk.jenis_askes IS NOT NULL THEN rk.jenis_askes
					WHEN lk.jenis_askes IS NOT NULL THEN lk.jenis_askes
					ELSE kk.jenis_askes
				END as jenis_askes
			FROM
				kunjungan_bayar kb
				LEFT JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id)
				LEFT JOIN lab_kunjungan lk ON (lk.id = kb.lab_kunjungan_id)
				LEFT JOIN radio_kunjungan rk ON (rk.id = kb.radio_kunjungan_id)
				JOIN kwitansi kw ON (kw.id = kb.kwid)
			WHERE
				YEAR(kw.tgl) = '".$val[tahun]."'
				AND kb.kwid IS NOT NULL
			GROUP BY
				MONTH(kw.tgl), kk.cara_bayar, lk.cara_bayar, rk.cara_bayar, kk.jenis_askes, lk.jenis_askes, rk.jenis_askes
			ORDER BY
				MONTH(kw.tgl)
		";
		//$objResponse->addAssign("debug", "innerHTML", nl2br($sql));
		$kon->sql = $sql;
		$kon->execute();
		$data = $kon->getAll();

		$table = new Table;
		$table->cellspacing = "0";
		$table->anime_bg_color = false;
		$table->addTh("No", "Bulan", "Cara Pembayaran", "Jumlah", "Kumulatif", "Target", "% Pendapatan", "% Kumulatif");
		$table->addExtraTh("rowspan=\"2\"", "rowspan=\"2\"", "colspan=\"7\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"");
		$table->addTh("Umum", "Jamsostek", "Dana Reksa Desa", "Kontrak", "Askeskin", "Askes Lain", "Lain-lain");
		$table->addTh("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14");
		$new = array();
		for($i=0;$i<sizeof($data);$i++) {
			if($data[$i][bulan] == $data[$i-1][bulan]) {
				if($data[$i][cara_bayar] == "UMUM") {
					$new[$data[$i][bulan]][UMUM] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "JAMSOSTEK") {
					$new[$data[$i][bulan]][JAMSOSTEK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "DANA REKSA DESA") {
					$new[$data[$i][bulan]][DANA_REKSA_DESA] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "KONTRAK") {
					$new[$data[$i][bulan]][KONTRAK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "ASKES"){
					if($data[$i][jenis_askes] == "Askes Kin") {
						$new[$data[$i][bulan]][ASKESKIN] = $data[$i][bayar];
					} else {
						$new[$data[$i][bulan]][ASKES_LAIN] = $data[$i][bayar];
					}
				} else {
					$new[$data[$i][bulan]][LAIN] = $data[$i][bayar];
				}
				$new[$data[$i][bulan]][JUMLAH] += $data[$i][bayar];
			} else {
				if($data[$i][cara_bayar] == "UMUM") {
					$new[$data[$i][bulan]][UMUM] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "JAMSOSTEK") {
					$new[$data[$i][bulan]][JAMSOSTEK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "DANA REKSA DESA") {
					$new[$data[$i][bulan]][DANA_REKSA_DESA] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "KONTRAK") {
					$new[$data[$i][bulan]][KONTRAK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "ASKES"){
					if($data[$i][jenis_askes] == "Askes Kin") {
						$new[$data[$i][bulan]][ASKESKIN] = $data[$i][bayar];
					} else {
						$new[$data[$i][bulan]][ASKES_LAIN] = $data[$i][bayar];
					}
				} else {
					$new[$data[$i][bulan]][LAIN] = $data[$i][bayar];
				}
				$new[$data[$i][bulan]][JUMLAH] = $data[$i][bayar];
			}
		}
		for($i=1;$i<13;$i++) {
			$bulan = bulanIndo($i, "F");
			$kumulatif += $new[$i][JUMLAH];
			$persen_pendapatan = @round($new[$i][JUMLAH]*100/$kumulatif,2);
			$persen_kumulatif = @round($kumulatif*100/$val["bulan_" . $i],2);

			$table->addRow(
				$i, 
				$bulan, 
				uangIndo($new[$i][UMUM], false), 
				uangIndo($new[$i][JAMSOSTEK], false), 
				uangIndo($new[$i][DANA_REKSA_DESA], false), 
				uangIndo($new[$i][KONTRAK], false), 
				uangIndo($new[$i][ASKESKIN], false), 
				uangIndo($new[$i][ASKES_LAIN], false), 
				uangIndo($new[$i][LAIN], false), 
				uangIndo($new[$i][JUMLAH], false), 
				uangIndo($kumulatif, false), 
				uangIndo($val["bulan_" . $i], false), 
				uangIndo($persen_pendapatan, false), 
				uangIndo($persen_kumulatif)
			);
			$table->addExtraTd(
				"",
				"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\""
			);

			$total[UMUM] += $new[$i][UMUM];
			$total[JAMSOSTEK] += $new[$i][JAMSOSTEK];
			$total[DANA_REKSA_DESA] += $new[$i][DANA_REKSA_DESA];
			$total[KONTRAK] += $new[$i][KONTRAK];
			$total[ASKESKIN] += $new[$i][ASKESKIN];
			$total[ASKES_LAIN] += $new[$i][ASKES_LAIN];
			$total[LAIN] += $new[$i][LAIN];
			$total[JUMLAH] += $new[$i][JUMLAH];
			$total[kumulatif] += $kumulatif;
			$total[target] += $val["bulan_" . $i];
			
			$table->addExtraTr("onclick=\"setBg(this);\"");
		}
		$table->addTfoot(
			"TOTAL",
			uangIndo($total[UMUM], false),
			uangIndo($total[JAMSOSTEK], false),
			uangIndo($total[DANA_REKSA_DESA], false),
			uangIndo($total[KONTRAK], false),
			uangIndo($total[ASKESKIN], false),
			uangIndo($total[ASKES_LAIN], false),
			uangIndo($total[LAIN], false),
			uangIndo($total[JUMLAH], false),
			uangIndo($total[kumulatif], false),
			uangIndo($total[target], false),
			"-","-"
		);
		$table->addExtraTfoot("colspan=\"2\"");
		$content = $table->build();
		$judul = nl2br($title);
		//$objResponse->addAlert(print_r($new));
		$objResponse->addAssign("title", "innerHTML", $judul);
		$objResponse->addAssign("list_data", "innerHTML", $content);
		$_SESSION[keuangan][lap_keuangan_bulanan][title] = $judul;
		$_SESSION[keuangan][lap_keuangan_bulanan][content] = $content;
		return $objResponse;
	}
Example #2
0
	function list_data($val) {
		unset($_SESSION[igd][pendapatan]);
		//get data karcis dan BHP
		$objResponse = new xajaxResponse;
		$kon = new Konek;
		$title = "Laporan Pembagian Jasa IRD";
		if($val[jangka_waktu] == "tahun") {
			$q = "AND YEAR(kw.tgl) BETWEEN '".$val[thn_start]."' AND '".$val[thn_end]."'";
			$title .= "\nPeriode " . $val[thn_start] . " - " . $val[thn_end];
		} elseif($val[jangka_waktu] == "bulan") {
			$q = "AND EXTRACT(YEAR_MONTH FROM kw.tgl) BETWEEN '".$val[thn_start].$val[bln_start]."' AND '".$val[thn_end].$val[bln_end]."'";
			$title .= "\nPeriode " . bulanIndo($val[bln_start], "F") . " " . $val[thn_start] . " - " . bulanIndo($val[bln_end], "F") . " " . $val[thn_end];
		} else {
			$q = "AND DATE(kw.tgl) BETWEEN '".$val[thn_start]."-".$val[bln_start]."-".$val[tgl_start]."' AND '".$val[thn_end]."-".$val[bln_end]."-".$val[tgl_end]."'";
			$title .= "\nPeriode " . tanggalIndo($val[thn_start] . "-" . $val[bln_start] . "-" . $val[tgl_start], "j F Y") . " - " . tanggalIndo($val[thn_end] . "-" . $val[bln_end] . "-" . $val[tgl_end], "j F Y");
		}
		$sql = "
			SELECT
				kb.nama as nama,
				hak.nama as nama_hak,
				SUM(ROUND(kb.mampu_bayar_bhp * bhp_p)) as bhp_p,
				SUM(ROUND(kb.mampu_bayar_bhp * bhp_rs_adm)) as bhp_rs_adm,
				SUM(ROUND(kb.mampu_bayar_bhp * bhp_rs_op)) as bhp_rs_op,
				SUM(ROUND(kb.mampu_bayar_jasa * jasa_p)) as jasa_p,
				SUM(ROUND(kb.mampu_bayar_jasa * jasa_rs_adm)) as jasa_rs_adm,
				SUM(ROUND(kb.mampu_bayar_jasa * jasa_rs_sdm)) as jasa_rs_sdm,
				SUM(ROUND(kb.mampu_bayar_jasa * jasa_rs_kembang)) as jasa_rs_kembang,
				SUM(ROUND(kb.mampu_bayar_jasa * jasa_rs_op)) as jasa_rs_op,

				SUM(ROUND(kb.mampu_bayar_jasa * spesialis * netto)) as spesialis,
				SUM(ROUND(kb.mampu_bayar_jasa * spesialis_pendamping * netto)) as spesialis_pendamping,
				SUM(ROUND(kb.mampu_bayar_jasa * perawat_perinatologi * netto)) as perawat_perinatologi,
				SUM(ROUND(kb.mampu_bayar_jasa * dr_umum * netto)) as dr_umum,
				SUM(ROUND(kb.mampu_bayar_jasa * dr_gigi * netto)) as dr_gigi,
				SUM(ROUND(kb.mampu_bayar_jasa * assisten_non_dokter * netto)) as assisten_non_dokter,
				SUM(ROUND(kb.mampu_bayar_jasa * spesialis_anestesi * netto)) as spesialis_anestesi,
				SUM(ROUND(kb.mampu_bayar_jasa * aknest * netto)) as aknest,
				SUM(ROUND(kb.mampu_bayar_jasa * gizi * netto)) as gizi,
				SUM(ROUND(kb.mampu_bayar_jasa * fisioterapi * netto)) as fisioterapi,
				SUM(ROUND(kb.mampu_bayar_jasa * analis_pa * netto)) as analis_pa,
				SUM(ROUND(kb.mampu_bayar_jasa * bidan * netto)) as bidan,
				SUM(ROUND(kb.mampu_bayar_jasa * perawat * netto)) as perawat,
				SUM(ROUND(kb.mampu_bayar_jasa * penunjang * netto)) as penunjang,
				SUM(ROUND(kb.mampu_bayar_jasa * ugp * netto)) as ugp,
				SUM(ROUND(kb.mampu_bayar_jasa * grabaf * netto)) as grabaf,
				SUM(ROUND(kb.mampu_bayar_jasa * zakat * netto)) as zakat,
				SUM(ROUND(pajak * (kb.mampu_bayar_jasa - kb.mampu_bayar_jasa * kb.jasa_p - kb.mampu_bayar_jasa * kb.jasa_rs_op - kb.mampu_bayar_jasa * kb.jasa_rs_kembang - kb.mampu_bayar_jasa * kb.jasa_rs_adm - kb.mampu_bayar_jasa * kb.jasa_rs_sdm))) as pajak,
				SUM(kb.mampu_bayar_bhp+kb.mampu_bayar_jasa) as mampu_bayar
			FROM
				kunjungan_bayar kb
				JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id)
				JOIN hak ON (hak.id = kb.hak_id)
				JOIN kwitansi kw ON (kw.id = kb.kwid)
			WHERE
				(kb.karcis_id IS NOT NULL OR kb.bhp_id IS NOT NULL)
				AND kw.tempat_pembayaran = 'IRD'
				$q
			GROUP BY
				kb.karcis_id, kb.bhp_id, kb.hak_id
		";
		//$objResponse->addAssign("debug", "innerHTML", nl2br($sql));
		$kon->sql = $sql;
		$kon->execute();
		$data_karcis = $kon->getAll();

		$table = new Table;
		$table->anime_bg_color = false;
		$table->addTh("Jasa", "Pemilik", "BHP", "JASA RS", "Sp", "Sp1", "SpAn", "UGP", "GRABAF", "Prwt", /*"Ass Non Dokter", "Aknest", "Gizi", "Fisio", "Analis PA", "Bidan", */"Pnjg", "Zakat", "Pajak", "Sub Total");
		$table->addExtraTh("rowspan=\"2\"", "rowspan=\"2\"", "colspan=\"5\"", "colspan=\"5\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"", "rowspan=\"2\"");
		$table->addTh("Pemda", "Adm", "Op", "Rad", "Lab", "Pemda", "Adm", "Sdm", "Bang", "Op");
		for($i=0;$i<sizeof($data_karcis);$i++) {
			$table->addRow(
				$data_karcis[$i][nama], 
				$data_karcis[$i][nama_hak],
				$data_karcis[$i][bhp_p],
				$data_karcis[$i][bhp_rs_adm],
				$data_karcis[$i][bhp_rs_op],
				"?",
				"?",
				uangIndo($data_karcis[$i][jasa_p], false),
				uangIndo($data_karcis[$i][jasa_rs_adm], false),
				uangIndo($data_karcis[$i][jasa_rs_sdm], false),
				uangIndo($data_karcis[$i][jasa_rs_kembang], false),
				uangIndo($data_karcis[$i][jasa_rs_op], false),

				uangIndo($data_karcis[$i][spesialis], false),
				uangIndo($data_karcis[$i][spesialis_pendamping], false),
				uangIndo($data_karcis[$i][spesialis_anestesi], false),
				//uangIndo($data_karcis[$i][dr_umum] + $data_karcis[$i][dr_gigi] + $data_karcis[$i][ugp], false),
				uangIndo($data_karcis[$i][ugp], false),
				uangIndo($data_karcis[$i][grabaf], false),
				//uangIndo($data_karcis[$i][perawat] + $data_karcis[$i][perawat_perinatologi], false),
				uangIndo($data_karcis[$i][perawat], false),
				/*uangIndo($data_karcis[$i][assisten_non_dokter], false),
				uangIndo($data_karcis[$i][aknest], false),
				uangIndo($data_karcis[$i][gizi], false),
				uangIndo($data_karcis[$i][fisioterapi], false),
				uangIndo($data_karcis[$i][analis_pa], false),
				uangIndo($data_karcis[$i][bidan], false),*/
				uangIndo($data_karcis[$i][penunjang], false),
				uangIndo($data_karcis[$i][zakat], false),
				uangIndo($data_karcis[$i][pajak], false),
				uangIndo($data_karcis[$i][mampu_bayar], false)

				/*
				$data_karcis[$i][assisten_non_dokter],
				$data_karcis[$i][aknest],
				$data_karcis[$i][gizi],
				$data_karcis[$i][fisioterapi],
				$data_karcis[$i][analis_pa],
				$data_karcis[$i][bidan],
				*/
			);
			$table->addExtraTr("onclick=\"setBg(this);\"");

			$total[bhp_p] += $data_karcis[$i][bhp_p];
			$total[bhp_rs_adm] += $data_karcis[$i][bhp_rs_adm];
			$total[bhp_rs_op] += $data_karcis[$i][bhp_rs_op];
			$total[jasa_p] += $data_karcis[$i][jasa_p];
			$total[jasa_rs_adm] += $data_karcis[$i][jasa_rs_adm];
			$total[jasa_rs_sdm] += $data_karcis[$i][jasa_rs_sdm];
			$total[jasa_rs_kembang] += $data_karcis[$i][jasa_rs_kembang];
			$total[jasa_rs_op] += $data_karcis[$i][jasa_rs_op];
			$total[spesialis] += $data_karcis[$i][spesialis];
			$total[spesialis_pendamping] += $data_karcis[$i][spesialis_pendamping];
			$total[spesialis_anestesi] += $data_karcis[$i][spesialis_anestesi];
			//$total[ugp] += $data_karcis[$i][dr_umum] + $data_karcis[$i][dr_gigi] + $data_karcis[$i][ugp];
			$total[ugp] += $data_karcis[$i][ugp];
			$total[grabaf] += $data_karcis[$i][grabaf];
			//$total[perawat] += $data_karcis[$i][perawat]+$data_karcis[$i][perawat_perinatologi];
			$total[perawat] += $data_karcis[$i][perawat];
			/*$total[assisten_non_dokter] += $data_karcis[$i][assisten_non_dokter];
			$total[aknest] += $data_karcis[$i][aknest];
			$total[gizi] += $data_karcis[$i][gizi];
			$total[fisioterapi] += $data_karcis[$i][fisioterapi];
			$total[analis_pa] += $data_karcis[$i][analis_pa];
			$total[bidan] += $data_karcis[$i][bidan];*/
			$total[penunjang] += $data_karcis[$i][penunjang];
			$total[zakat] += $data_karcis[$i][zakat];
			$total[pajak] += $data_karcis[$i][pajak];
			$total[mampu_bayar] += $data_karcis[$i][mampu_bayar];
		}
		$table->addTfoot(
			"Total", 
			uangIndo($total[bhp_p], false), 
			uangIndo($total[bhp_rs_adm], false), 
			uangIndo($total[bhp_rs_op], false), 
			"?", 
			"?", 
			uangIndo($total[jasa_p], false), 
			uangIndo($total[jasa_rs_adm], false), 
			uangIndo($total[jasa_rs_sdm], false), 
			uangIndo($total[jasa_rs_kembang], false), 
			uangIndo($total[jasa_rs_op], false), 
			uangIndo($total[spesialis], false), 
			uangIndo($total[spesialis_pendamping], false), 
			uangIndo($total[spesialis_anestesi], false), 
			uangIndo($total[ugp], false), 
			uangIndo($total[grabaf], false), 
			uangIndo($total[perawat], false), 
			/*uangIndo($total[assisten_non_dokter], false), 
			uangIndo($total[aknest], false), 
			uangIndo($total[gizi], false), 
			uangIndo($total[fisioterapi], false), 
			uangIndo($total[analis_pa], false), 
			uangIndo($total[bidan], false), */
			uangIndo($total[penunjang], false), 
			uangIndo($total[zakat], false), 
			uangIndo($total[pajak], false), 
			uangIndo($total[mampu_bayar], false)
			);
		$table->addExtraTfoot("colspan=\"2\"");
		$content = $table->build();
		$judul = nl2br($title);
		$objResponse->addAssign("title", "innerHTML", $judul);
		$objResponse->addAssign("list_data", "innerHTML", $content);
		$_SESSION[igd][pendapatan][title] = $judul;
		$_SESSION[igd][pendapatan][content] = $content;
		return $objResponse;
	}
	function list_data($val) {
		unset($_SESSION[keuangan][lap_keuangan_bulanan]);
		//get data karcis dan BHP
		$objResponse = new xajaxResponse;
		$kon = new Konek;
		$title = "Laporan Keuangan Per Pelayanan";
		$title .= "\nPeriode " . tanggalIndo($val[thn_start] . "-" . $val[bln_start] . "-" . $val[tgl_start], "j F Y") . " - " . tanggalIndo($val[thn_end] . "-" . $val[bln_end] . "-" . $val[tgl_end], "j F Y");
		$sql = "
			SELECT
				CASE
					WHEN kb.lab_kunjungan_id IS NOT NULL THEN 'LAB'
					WHEN kb.radio_kunjungan_id IS NOT NULL THEN 'RADIO'
					ELSE pel.id
				END as id_pelayanan,
				CASE
					WHEN kb.lab_kunjungan_id IS NOT NULL THEN 'Laboratorium'
					WHEN kb.radio_kunjungan_id IS NOT NULL THEN 'Radiologi'
					WHEN pel.jenis = 'IGD' THEN 'IRD'
					ELSE CONCAT_WS(' - ', pel.jenis, pel.nama)
				END as nama_pelayanan,
				SUM(kb.mampu_bayar_bhp+kb.mampu_bayar_jasa) as bayar,
				CASE
					WHEN rk.cara_bayar IS NOT NULL THEN rk.cara_bayar
					WHEN lk.cara_bayar IS NOT NULL THEN lk.cara_bayar
					ELSE kk.cara_bayar
				END as cara_bayar,
				CASE
					WHEN rk.jenis_askes IS NOT NULL THEN rk.jenis_askes
					WHEN lk.jenis_askes IS NOT NULL THEN lk.jenis_askes
					ELSE kk.jenis_askes
				END as jenis_askes
			FROM
				kunjungan_bayar kb
				LEFT JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id)
				LEFT JOIN kamar kmr ON (kmr.id = kk.kamar_id)
				LEFT JOIN pelayanan pel ON (pel.id = kmr.pelayanan_id)
				LEFT JOIN lab_kunjungan lk ON (lk.id = kb.lab_kunjungan_id)
				LEFT JOIN radio_kunjungan rk ON (rk.id = kb.radio_kunjungan_id)
				JOIN kwitansi kw ON (kw.id = kb.kwid)
			WHERE
				DATE(kw.tgl) BETWEEN '".$val[thn_start]."-".$val[bln_start]."-".$val[tgl_start]."' AND '".$val[thn_end]."-".$val[bln_end]."-".$val[tgl_end]."'
				AND kb.kwid IS NOT NULL
			GROUP BY
				id_pelayanan, kk.cara_bayar, lk.cara_bayar, rk.cara_bayar, kk.jenis_askes, lk.jenis_askes, rk.jenis_askes
			ORDER BY
				1
		";
		//$objResponse->addAssign("debug", "innerHTML", nl2br($sql));
		$kon->sql = $sql;
		$kon->execute();
		$data = $kon->getAll();

		$table = new Table;
		$table->cellspacing = "0";
		$table->anime_bg_color = false;
		$table->addTh("No", "Pelayanan", "Cara Pembayaran", "Jumlah");
		$table->addExtraTh("rowspan=\"2\"", "rowspan=\"2\"", "colspan=\"7\"", "rowspan=\"2\"");
		$table->addTh("Umum", "Jamsostek", "Dana Reksa Desa", "Kontrak", "Askeskin", "Askes Lain", "Lain-lain");
		$table->addTh("1", "2", "3", "4", "5", "6", "7", "8", "9", "10");
		$new = array();
		$s = 0;
		for($i=0;$i<sizeof($data);$i++) {
			if($data[$i][id_pelayanan] == $data[$i-1][id_pelayanan]) {
				if($data[$i][cara_bayar] == "UMUM") {
					$new[$s][UMUM] += $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "JAMSOSTEK") {
					$new[$s][JAMSOSTEK] += $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "DANA REKSA DESA") {
					$new[$s][DANA_REKSA_DESA] += $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "KONTRAK") {
					$new[$s][KONTRAK] += $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "ASKES"){
					if($data[$i][jenis_askes] == "Askes Kin") {
						$new[$s][ASKESKIN] += $data[$i][bayar];
					} else {
						$new[$s][ASKES_LAIN] += $data[$i][bayar];
					}
				} else {
					$new[$s][LAIN] += $data[$i][bayar];
				}
				$new[$s][JUMLAH] += $data[$i][bayar];
			} else {
				if($i !=0 ) $s++;
				$new[$s][nama_pelayanan] = $data[$i][nama_pelayanan];
				if($data[$i][cara_bayar] == "UMUM") {
					$new[$s][UMUM] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "JAMSOSTEK") {
					$new[$s][JAMSOSTEK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "DANA REKSA DESA") {
					$new[$s][DANA_REKSA_DESA] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "KONTRAK") {
					$new[$s][KONTRAK] = $data[$i][bayar];
				} elseif($data[$i][cara_bayar] == "ASKES"){
					if($data[$i][jenis_askes] == "Askes Kin") {
						$new[$s][ASKESKIN] = $data[$i][bayar];
					} else {
						$new[$s][ASKES_LAIN] = $data[$i][bayar];
					}
				} else {
					$new[$s][LAIN] = $data[$i][bayar];
				}
				$new[$s][JUMLAH] = $data[$i][bayar];
			}
		}
		for($i=0;$i<sizeof($new);$i++) {
			$table->addRow(
				($i+1), 
				$new[$i][nama_pelayanan], 
				uangIndo($new[$i][UMUM], false), 
				uangIndo($new[$i][JAMSOSTEK], false), 
				uangIndo($new[$i][DANA_REKSA_DESA], false), 
				uangIndo($new[$i][KONTRAK], false), 
				uangIndo($new[$i][ASKESKIN], false), 
				uangIndo($new[$i][ASKES_LAIN], false), 
				uangIndo($new[$i][LAIN], false), 
				uangIndo($new[$i][JUMLAH], false)
			);
			$table->addExtraTd(
				"",
				"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\"",
				"style=\"text-align:right\""
			);

			$total[UMUM] += $new[$i][UMUM];
			$total[JAMSOSTEK] += $new[$i][JAMSOSTEK];
			$total[DANA_REKSA_DESA] += $new[$i][DANA_REKSA_DESA];
			$total[KONTRAK] += $new[$i][KONTRAK];
			$total[ASKESKIN] += $new[$i][ASKESKIN];
			$total[ASKES_LAIN] += $new[$i][ASKES_LAIN];
			$total[LAIN] += $new[$i][LAIN];
			$total[JUMLAH] += $new[$i][JUMLAH];
			
			$table->addExtraTr("onclick=\"setBg(this);\"");
		}
		$table->addTfoot(
			"TOTAL",
			uangIndo($total[UMUM], false),
			uangIndo($total[JAMSOSTEK], false),
			uangIndo($total[DANA_REKSA_DESA], false),
			uangIndo($total[KONTRAK], false),
			uangIndo($total[ASKESKIN], false),
			uangIndo($total[ASKES_LAIN], false),
			uangIndo($total[LAIN], false),
			uangIndo($total[JUMLAH], false)
		);
		$table->addExtraTfoot("colspan=\"2\"");
		$content = $table->build();
		$judul = nl2br($title);
		//$objResponse->addAlert(print_r($new));
		$objResponse->addAssign("title", "innerHTML", $judul);
		$objResponse->addAssign("list_data", "innerHTML", $content);
		$_SESSION[keuangan][lap_keuangan_bulanan][title] = $judul;
		$_SESSION[keuangan][lap_keuangan_bulanan][content] = $content;
		return $objResponse;
	}