db->query($sql_21); foreach($query_21->result() as $row_21) { $anggaran_21 = $row_21->total_anggaran; }*/ $sql_b21 = "SELECT sum(nominal) AS total_b21 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '21'"; $query_b21 = $this->db->query($sql_b21); foreach($query_b21->result() as $row_b21){ $tot_b21 = $row_b21->total_b21; } //$banding21 = $anggaran_21 - $tot_b21; //$persen21 = ($banding21/$anggaran_21)*100; //$f_agr_21 = number_format($anggaran_21,0,',','.'); $f_tot_21 = number_format($tot_b21,0,',','.'); //$f_bdg_21 = number_format($banding21,0,',','.'); //$f_prs_21 = number_format($persen21,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_111); foreach($query_111->result() as $row_111) { $anggaran_111 = number_format($row_111->total_anggaran,0,',','.'); $realisasi_111 = number_format($row_111->total_realisasi,0,',','.'); $perbandingan_111 = number_format($row_111->perbandingan,0,',','.');*/ echo ""; echo ""; echo ""; echo ""; /* echo ""; echo ""; echo ""; echo ""; }*/ ?> db->query($sql_22); foreach($query_22->result() as $row_22) { $anggaran_22 = $row_22->total_anggaran; }*/ $sql_b22 = "SELECT sum(nominal) AS total_b22 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '22'"; $query_b22 = $this->db->query($sql_b22); foreach($query_b22->result() as $row_b22){ $tot_b22 = $row_b22->total_b22; } //$banding22 = $anggaran_22 - $tot_b22; //$persen22 = ($banding22/$anggaran_22)*100; //$f_agr_22 = number_format($anggaran_22,0,',','.'); $f_tot_22 = number_format($tot_b22,0,',','.'); //$f_bdg_22 = number_format($banding22,0,',','.'); //$f_prs_22 = number_format($persen22,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; /* echo ""; echo ""; */ ?> db->query($sql_112); foreach($query_112->result() as $row_112) { $anggaran_112 = number_format($row_112->total_anggaran,0,',','.'); $realisasi_112 = number_format($row_112->total_realisasi,0,',','.'); $perbandingan_112 = number_format($row_112->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_23); foreach($query_23->result() as $row_23) { $anggaran_23 = $row_23->total_anggaran; }*/ $sql_b23 = "SELECT sum(nominal) AS total_b23 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '23'"; $query_b23 = $this->db->query($sql_b23); foreach($query_b23->result() as $row_b23){ $tot_b23 = $row_b23->total_b23; } //$banding23 = $anggaran_23 - $tot_b23; //$persen23 = ($banding23/$anggaran_23)*100; //$f_agr_23 = number_format($anggaran_23,0,',','.'); $f_tot_23 = number_format($tot_b23,0,',','.'); //$f_bdg_23 = number_format($banding23,0,',','.'); //$f_prs_23 = number_format($persen23,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_113); foreach($query_113->result() as $row_113) { $anggaran_113 = number_format($row_113->total_anggaran,0,',','.'); $realisasi_113 = number_format($row_113->total_realisasi,0,',','.'); $perbandingan_113 = number_format($row_113->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_24); foreach($query_24->result() as $row_24) { $anggaran_24 = $row_24->total_anggaran; }*/ $sql_b24 = "SELECT sum(nominal) AS total_b24 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '24'"; $query_b24 = $this->db->query($sql_b24); foreach($query_b24->result() as $row_b24){ $tot_b24 = $row_b24->total_b24; } //$banding24 = $anggaran_24 - $tot_b24; //$persen24 = ($banding24/$anggaran_24)*100; //$f_agr_24 = number_format($anggaran_24,0,',','.'); $f_tot_24 = number_format($tot_b24,0,',','.'); //$f_bdg_24 = number_format($banding24,0,',','.'); //$f_prs_24 = number_format($persen24,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_11); foreach($query_11->result() as $row_11) { $anggaran_h_11 = $row_11->total_anggaran; $realisasi_h_11 = $row_11->total_realisasi; $perbandingan_h_11 = $row_11->perbandingan; $anggaran_11 = number_format($row_11->total_anggaran,0,',','.'); $realisasi_11 = number_format($row_11->total_realisasi,0,',','.'); $perbandingan_11 = number_format($row_11->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_25); foreach($query_25->result() as $row_25) { $anggaran_25 = $row_25->total_anggaran; }*/ $sql_b25 = "SELECT sum(nominal) AS total_b25 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '25'"; $query_b25 = $this->db->query($sql_b25); foreach($query_b25->result() as $row_b25){ $tot_b25 = $row_b25->total_b25; } //$banding25 = $anggaran_25 - $tot_b25; //$persen25 = ($banding25/$anggaran_25)*100; //$f_agr_25 = number_format($anggaran_25,0,',','.'); $f_tot_25 = number_format($tot_b25,0,',','.'); //$f_bdg_25 = number_format($banding25,0,',','.'); //$f_prs_25 = number_format($persen25,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_26); foreach($query_26->result() as $row_26) { $anggaran_26 = $row_26->total_anggaran; }*/ $sql_b26 = "SELECT sum(nominal) AS total_b26 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '26'"; $query_b26 = $this->db->query($sql_b26); foreach($query_b26->result() as $row_b26){ $tot_b26 = $row_b26->total_b26; } //$banding26 = $anggaran_26 - $tot_b26; //$persen26 = ($banding26/$anggaran_26)*100; //$f_agr_26 = number_format($anggaran_26,0,',','.'); $f_tot_26 = number_format($tot_b26,0,',','.'); //$f_bdg_26 = number_format($banding26,0,',','.'); //$f_prs_26 = number_format($persen26,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_27); foreach($query_27->result() as $row_27) { $anggaran_27 = number_format($row_27->total_anggaran,0,',','.'); }*/ $sql_b27 = "SELECT sum(nominal) AS total_b27 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '27'"; $query_b27 = $this->db->query($sql_b27); foreach($query_b27->result() as $row_b27){ $tot_b27 = $row_b27->total_b27; } //$banding27 = $anggaran_27 - $tot_b27; //$persen27 = ($banding27/$anggaran_27)*100; //$f_agr_27 = number_format($anggaran_27,0,',','.'); $f_tot_27 = number_format($tot_b27,0,',','.'); //$f_bdg_27 = number_format($banding27,0,',','.'); //$f_prs_27 = number_format($persen27,2,',','.'); echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_121); foreach($query_121->result() as $row_121) { $anggaran_121 = number_format($row_121->total_anggaran,0,',','.'); $realisasi_121 = number_format($row_121->total_realisasi,0,',','.'); $perbandingan_121 = number_format($row_121->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_28); foreach($query_28->result() as $row_28) { $anggaran_28 = $row_28->total_anggaran; } */ $sql_b28 = "SELECT sum(nominal) AS total_b28 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '28'"; $query_b28 = $this->db->query($sql_b28); foreach($query_b28->result() as $row_b28){ $tot_b28 = $row_b28->total_b28; } //$banding28 = $anggaran_28 - $tot_b28; //$persen28 = ($banding28/$anggaran_28)*100; //$f_agr_28 = number_format($anggaran_28,0,',','.'); $f_tot_28 = number_format($tot_b28,0,',','.'); //$f_bdg_28 = number_format($banding28,0,',','.'); //$f_prs_28 = number_format($persen28,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_122); foreach($query_122->result() as $row_122) { $anggaran_122 = number_format($row_122->total_anggaran,0,',','.'); $realisasi_122 = number_format($row_122->total_realisasi,0,',','.'); $perbandingan_122 = number_format($row_122->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_29); foreach($query_29->result() as $row_29) { $anggaran_29 = $row_29->total_anggaran; }*/ $sql_b29 = "SELECT sum(nominal) AS total_b29 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '29'"; $query_b29 = $this->db->query($sql_b29); foreach($query_b29->result() as $row_b29){ $tot_b29 = $row_b29->total_b29; } //$banding29 = $anggaran_29 - $tot_b29; //$persen29 = ($banding29/$anggaran_29)*100; //$f_agr_29 = number_format($anggaran_29,0,',','.'); $f_tot_29 = number_format($tot_b29,0,',','.'); //$f_bdg_29 = number_format($banding29,0,',','.'); //$f_prs_29 = number_format($persen29,2,',','.'); //echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_123); foreach($query_123->result() as $row_123) { $anggaran_123 = number_format($row_123->total_anggaran,0,',','.'); $realisasi_123 = number_format($row_123->total_realisasi,0,',','.'); $perbandingan_123 = number_format($row_123->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_210); */ $sql_b210 = "SELECT sum(nominal) AS total_b210 FROM buku_b WHERE id_thn_akad = '$id_thn_akad' AND urut_mtagr = '210'"; $query_b210 = $this->db->query($sql_b210); foreach($query_b210->result() as $row_b210){ $tot_b210 = $row_b210->total_b210; } //$anggaran_210 = number_format($row_210->total_anggaran,0,',','.'); //$realisasi_210 = number_format($row_210->total_realisasi,0,',','.'); //$perbandingan_210 = number_format($row_210->perbandingan,0,',','.'); //echo ""; $f_tot_210 = number_format($tot_b210,0,',','.'); echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; ?> db->query($sql_124); foreach($query_124->result() as $row_124) { $anggaran_124 = number_format($row_124->total_anggaran,0,',','.'); $realisasi_124 = number_format($row_124->total_realisasi,0,',','.'); $perbandingan_124 = number_format($row_124->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> db->query($sql_12); foreach($query_12->result() as $row_12) { $anggaran_h_12 = $row_12->total_anggaran; $realisasi_h_12 = $row_12->total_realisasi; $perbandingan_h_12 = $row_12->perbandingan; $anggaran_12 = number_format($row_12->total_anggaran,0,',','.'); $realisasi_12 = number_format($row_12->total_realisasi,0,',','.'); $perbandingan_12 = number_format($row_12->perbandingan,0,',','.'); echo ""; echo ""; echo ""; echo ""; }*/ echo ""; echo ""; echo ""; echo ""; ?> $total_agr_pendapatan"; echo ""; echo ""; echo "";*/ ?> "; echo ""; echo ""; echo ""; */ ?>

KODE MA	URAIAN PENDAPATAN	ANGGARAN	REALISASI	PERBANDINGAN	%	KODE MA	URAIAN BELANJA	ANGGARAN	REALISASI	PERBANDINGAN	%
1.1	PENERIMAAN INTERNAL					2.1	Belanja Pegawai	$f_agr_21		$f_tot_21			$f_bdg_21	$f_prs_21
1.1.1	Dana Penyelenggara Pendidikan (DPP)					$anggaran_111	$realisasi_111	$perbandingan_111	%	2.2	Pendidikan	$f_agr_22		$f_tot_22			$f_bdg_22	$f_prs_22
1.1.2	Dana Pengembangan Kampus (DPK)	$anggaran_112	$realisasi_112	$perbandingan_112	%					2.3	Penelitian	$f_agr_23		$f_tot_23			$f_bdg_23	$f_prs_23
1.1.3	Lain-lain	$anggaran_113	$realisasi_113	$perbandingan_113	%					2.4	Pengabdian Pada Masyarakat	$f_agr_24		$f_tot_24			$f_bdg_24	$f_prs_24
	JUMLAH PENERIMAAN INTERNAL	$anggaran_11	$realisasi_11	$perbandingan_11	%					2.5	Belanja Barang dan Jasa	$f_agr_25		$f_tot_25			$f_bdg_25	$f_prs_25
						2.6	Belanja Pemeliharaan	$f_agr_26		$f_tot_26			$f_bdg_26	$f_prs_26
1.2	PENERIMAAN EXTERNAL					2.7	Penunjang Kegiatan Pendidikan		$f_tot_27			$f_bdg_27	$f_prs_27
1.2.1	Beasiswa	$anggaran_121	$realisasi_121	$perbandingan_121	%					2.8	Transfer Dana Pengembangan Kampus (DPK)	$f_agr_28		$f_tot_28			$f_bdg_28	$f_prs_28
1.2.2	Hibah	$anggaran_122	$realisasi_122	$perbandingan_122	%					2.9	Belanja Khusus	$f_agr_29		$f_tot_29			$f_bdg_29	$f_prs_29
1.2.3	Sertifikasi Dosen	$anggaran_123	$realisasi_123	$perbandingan_123	%					2.10	Belanja Lain-lain	$anggaran_210		$f_tot_210			$perbandingan_210	%
1.2.4	Lain-lain	$anggaran_124	$realisasi_124	$perbandingan_124	%
	JUMLAH PENERIMAAN EXTERNAL	$anggaran_12	$realisasi_12	$perbandingan_12	%	0
	JUMLAH PENDAPATAN	$total_agr_realisasi	$total_agr_perbandingan	%	0	JUMLAH BELANJA	result() as $row_dall_thn){ echo number_format($row_dall_thn->tot_dall,0,',','.'); } /*$sql_tot2 = "SELECT sum(total_anggaran) as total_anggaran FROM anggaran_kompilasi WHERE id_mtagr IN ('21', '22', '23', '24', '25', '26', '27', '28', '29', '210') AND id_thn_akad = '$id_thn_akad' and kdfakultas='$kd_fakultas'"; $query_tot2 = $this->db->query($sql_tot2); foreach($query_tot2->result() as $row_tot2) { $agr_tot2 = number_format($row_tot2->total_anggaran,0,',','.'); } $sql_b2 = "SELECT sum(nominal) AS total_b2 FROM buku_b WHERE id_mtagr IN ('21', '22', '23', '24', '25', '26', '27', '28', '29', '210') AND id_thn_akad = '$id_thn_akad'"; $query_b2 = $this->db->query($sql_b2); foreach($query_b2->result() as $row_b2){ $tot_b2 = $row_b2->total_b2; } $banding2 = $tot_b2 - $agr_tot2; $persen2 = ($banding2/$agr_tot2)*100; $f_agr_2 = number_format($agr_tot2,0,',','.'); $f_tot_2 = "";//number_format($tot_b2,0,',','.'); $f_bdg_2 = number_format($banding2,0,',','.'); $f_prs_2 = number_format($persen2,',','.'); echo "	$f_agr_2	$f_tot_2	$f_bdg_2	$f_prs_2