Advertisement
sigitsuryono25

getDetailByBulan

Mar 31st, 2020
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. function getDetailByBulan($idAnggaran, $tahun, $idPos, $idBulan) {
  2. return $this->db->query("SELECT * FROM `tbl_detail_anggaran` "
  3. . "INNER JOIN tbl_anggaran "
  4. . "ON tbl_detail_anggaran.id_anggaran=tbl_anggaran.id_anggaran "
  5. . "INNER JOIN tbl_pos "
  6. . "ON tbl_detail_anggaran.id_pos=tbl_pos.id_pos "
  7. . "WHERE tbl_detail_anggaran.id_anggaran='$idAnggaran' "
  8. . "AND tbl_anggaran.tahun='$tahun' "
  9. . "AND tbl_detail_anggaran.id_pos='$idPos' "
  10. . "AND tbl_anggaran.id_bulan='$idBulan'")->result();
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement