$this->db->trans_begin();
$this->db->set($data)->insert('santri');
$santri_id = $this->db->insert_id();
$kelas_id = $data['kelas_id'];
$this->db->select('biaya_id, nominal');
$this->db->from('biaya_per_kelas');
$this->db->where('kelas_id', $kelas_id);
$query = $this->db->get();
if ($query->num_rows() > 0){
foreach ($query->result_array() as $biaya) {
$this->db->set('santri_id', $santri_id);
$this->db->set('biaya_id', $biaya['biaya_id']);
$this->db->set('nominal', $biaya['nominal']);
$this->db->insert('tagihan');
}
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
return true;
} else {
$this->db->trans_commit();
return false;
}