Fungsi tambahan untuk file Alumni_model.php

part_alumni_model.php

public function get_location_by_id($id)
{
	$this->db->select('al.nm_alumni,CONCAT(rd.name, \', \', rp.name) AS lokasi')
				->from('modul_alumni AS al')
				->join('villages AS rd','al.id_wil=rd.id')
				->join('districts AS rk','rd.district_id=rk.id')
				->join('regencies AS rb','rk.regency_id=rb.id')
				->join('provinces AS rp','rb.province_id=rp.id')
				->where('al.id_wil',$id);
	return $this->db->get();
}