do_pendaftaran.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Mahasiswa extends CI_Controller {
    public function do_pendaftaran()
    {
        $id_mahasiswa=$_POST['id_mahasiswa'];
        $nim=$_POST['nim'];
        $id_prodi= $_POST['id_prodi'];
        $id_tingkat= $_POST['id_tingkat'];
        $id_penghasilan= $_POST['id_penghasilan'];
        $id_ipk= $_POST['id_ipk'];
        $id_keaktifan= $_POST['id_keaktifan'];
        $alamat_mhs = $_POST['alamat_mhs'];
        $telp_mhs = $_POST['telp_mhs'];
        #Cari nilai maximal
        $carimax = $this->db->query("SELECT max(id_tingkat) as max1,
                                max(id_penghasilan) as max2,
                                max(id_ipk) as max3,
                                max(id_keaktifan) as max4
                                FROM tb_mahasiswa");
        $max1=$this->db->select_max('id_tingkat','max1');
        $max2=$this->db->select_max('id_penghasilan','max2');
        $max3=$this->db->select_max('id_ipk','max3');
        $max4=$this->db->select_max('id_keaktifan','max4');
        $this->db->get('tb_mahasiswa');

        $max = $carimax->num_rows();
        # Cari nilai minimal
        $carimin = $this->db->query("SELECT min(id_tingkat) as min1,
                                min(id_penghasilan) as min2,
                                min(id_ipk) as min3,
                                min(id_keaktifan) as min4
                                FROM tb_mahasiswa");
        $min1=$this->db->select_min('id_tingkat','min1');
        $min2=$this->db->select_min('id_penghasilan','min2');
        $min3=$this->db->select_min('id_ipk','min3');
        $min4=$this->db->select_min('id_keaktifan','min4');
        $this->db->get('tb_mahasiswa');

        $min = $carimin->num_rows();

        $this->db->select('bobot');
        $this->db->where('id_kriteria',1);
        $bobot_ting=$this->db->get('tb_kriteria');
        $bting= $bobot_ting->result_array();

        $this->db->select('bobot');
        $this->db->where('id_kriteria',2);
        $bobot_pe=$this->db->get('tb_kriteria');
        $bpeng= $bobot_pe->result_array();

        $this->db->select('bobot');
        $this->db->where('id_kriteria',3);
        $bobot_ipk=$this->db->get('tb_kriteria');
        $bipk= $bobot_ipk->result_array();

        $this->db->select('bobot');
        $this->db->where('id_kriteria',4);
        $bobot_akt=$this->db->get('tb_kriteria');
        $bakt= $bobot_akt->result_array();

        $hit_tingkat=(($id_tingkat/$max1)*$bting);
        $ha_tingkat= round($hit_tingkat,2);
        $hit_ipk=(($id_ipk/$max2)*$bipk);
        $ha_ipk= round($hit_ipk,2);
        $hit_penghasilan=(($min3/$id_penghasilan)*$bpeng);
        $ha_penghasilan= round($hit_penghasilan,2);
        $hit_keaktifan=(($id_keaktifan/$max4)*$bakt);
        $ha_keaktifan= round($hit_keaktifan,2);

        $nilai_akhir=($ha_tingkat+$ha_ipk+$ha_penghasilan+$ha_keaktifan);
        $ha_nilai_akhir=round($nilai_akhir,2);

        $data = array('nim'=>$nim, 'id_prodi'=>$id_prodi, 'id_tingkat' => $id_tingkat,'id_penghasilan' => $id_penghasilan,'id_ipk' => $id_ipk,'id_keaktifan' => $id_keaktifan, 'alamat_mhs' => $alamat_mhs, 'telp_mhs' => $telp_mhs, 'nilai_akhir' => $ha_nilai_akhir);
        $where = array('id_mahasiswa' => $id_mahasiswa);

        $this->form_validation->set_rules('alamat_mhs','alamat_mhs','trim|required');

        if ($this->form_validation->run() == FALSE){
            echo "<script> alert('DATA TELAH DIGUNAKAN!');
            window.location.href='pendaftaran_beasiswa';
            </script>";

        }else{
            $res=$this->mymodel->UpdateData('tb_mahasiswa',$data,$where);
            echo "
            <script> alert('PENDAFTARAN BERHASIL!');
            window.location.href='index';
            </script>";
        }
    }

}