saw

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

class Mahasiswa extends CI_Controller {

    public function index()
    {
        $this->load->view('mahasiswa/header');
        $this->load->view('mahasiswa/index');
        $this->load->view('mahasiswa/footer');
    }

    public function about()
    {
        $this->load->view('mahasiswa/header');
        $this->load->view('mahasiswa/about');
        $this->load->view('mahasiswa/footer');
    }

    public function login()
    {
        $email_cust = $this->input->post("email_cust");
        $password_cust = $this->input->post("password_cust");
        $cnt =  $this->db->get_where('tb_mahasiswa', array('email_cust' => $email_cust, 'password_cust' => $password_cust))->num_rows();
        $mahasiswa = $this->db->get_where('tb_mahasiswa', array('email_cust' => $email_cust))->row_array();
        $this->email_cust = $email_cust;
            if ($cnt>0 && $mahasiswa['status']=='mahasiswa')
            {
                $this->db->update("tb_mahasiswa",
                    array(
                        'is_login_cust'=>'1'
                    ),
                    array(
                        'EMAIL_CUST' => $email_cust
                    )
                );

                $id = $mahasiswa['id_mahasiswa'];
                //array_push($user)
                $_SESSION['mahasiswa'] = $mahasiswa['status'];
                $_SESSION['EMAIL_MAHASISWA'] = $mahasiswa['email_mhs'];

                header('location:'.base_url().'index.php/mahasiswa/index');
            }
            else
            {
            header('location:'.base_url().'index.php/mahasiswa/index');
            }

    }

    public function logout()
    {
        $email_mhs = $_SESSION['email_mhs'];
        $mahasiswa == $this->db->get_where('tb_mahasiswa',array('email_cust' => $email_cust))->row_array();
        $this->db->update("tb_mahasiswa",
                    array(
                        'is_login_cust'=>'0'
                    ),
                    array(
                        'EMAIL_CUST' => $email_cust
                    )
                );
                session_destroy();
                header('location:'.base_url().'index.php/Crud/index');
    }

    public function pendaftaran_beasiswa()
    {
    $data = $this->db->query("SELECT MAX(id_mahasiswa) as id FROM tb_mahasiswa")->row_array();
    $data['id_terupdate']=$data['id']+1;

    $this->load->view('mahasiswa/header');
    $this->load->view('mahasiswa/v_pendaftaran_beasiswa',$data);
    $this->load->view('mahasiswa/footer');

    }

    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 minimal/maximal
        $sql="
            SELECT
                MAX(id_tingkat) AS max1,
                MAX(id_penghasilan) AS max2,
                MIN(id_ipk) AS min3,
                MAX(id_keaktifan) AS max4
            FROM
                tb_mahasiswa";
        $result = $this->db->query($sql);
        $minmax=$result->row_array();
        list($max1,$max2,$min3,$max4)=$minmax;
        //-- mencari bobot
        $sql="
            SELECT
                SUM(IF(id_kriteria=1,bobot,0)) AS bting,
                SUM(IF(id_kriteria=2,bobot,0)) AS bpeng,
                SUM(IF(id_kriteria=3,bobot,0)) AS bipk,
                SUM(IF(id_kriteria=4,bobot,0)) AS bakt,
            FROM tb_kriteria
            ";
        $result=$this->db->query($sql);
        $bobot=$result->row_array();
        list($bting,$bpend,$bipk,$bakt)=$bobot;

        $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>";
        }
    }

}