Fungsi Pak Rio

$fiscal = 14;

//$query1       = "SELECT * FROM tbl_hotel WHERE status = 1 ORDER BY hotel_id ASC'";
//$arrQuery     = $this->db->query($query1)->result();

$arrQuery   = $this->model_fiscal->select_data()->result();
foreach ($arrQuery as $data1) {
    $KodeHotel = $data1->hotel_id;
    $NamaHotel = $data1->hotel_name;
    $Formula1  = $data1->formula_1;
    $Formula2  = $data1->formula_2;
    $Formula3  = $data1->formula_3;
    $Formula4  = $data1->formula_4;

    // ambil data actual
    //$query2   = "SELECT * FROM tbl_plactual WHERE hotel_id = '$KodeHotel' AND fiscal_id = '".$fiscal."'";
    //$data2    = $this->db->query($query2)->row(); // 1 Record, ganti result() kalau mau banyak data
    $data2 = $this->mode_fiscal->select_plactual_by_hotel($KodeHotel, $fiscal)->row();
    // 1 Record, ganti result() kalau mau banyak data

    // ambil data budget
    //$query3       = "SELECT * FROM tbl_plbudget WHERE hotel_id = '$KodeHotel' AND fiscal_id = '".$fiscal."'";
    //$data3    = $this->db->query($query3)->row(); // 1 Record, ganti result() kalau mau banyak data
    $data3 = $this->mode_fiscal->select_plbudget_by_hotel($KodeHotel, $fiscal)->row();
}