ULTRA [ dhmd.unla.ac.id ]

Linux unla-WEB 3.19.0-80-generic #88~14.04.1-Ubuntu SMP Fri Jan 13 14:54:07 UTC 2017 x86_64

Apache/2.4.7 (Ubuntu)

103.184.53.210 | Your IP: 192.168.112.121

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ home / unla.ac.id / application / backend / controllers / e_akademic /

Home Upload Mass Deface Mass Delete Back Connect Notify

c_kartuhasilstudi.php

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

class C_kartuhasilstudi extends Controller {

/*membuka koneksi database untuk d_mahasiswa*/
    public function __construct()
    {
        parent::Controller();
        $this->load->library('session');
        
    }
       
    function nm_field($column,$tbl,$whereb, $wherea){
        $q = "SELECT ".$column." as nm FROM ".$tbl." where ".$whereb." = '".$wherea."' " ;
        $query  = $this->db->query($q);
        $nm= ''; 
                    
        if ($query->num_rows() != 0)
        {
            $row = $query->row();
            $nm=$row->nm;
        }
        return $nm;
    }

function grid(){ //ISTRA

$kdstsemester  = $this->input->post("kdstsemester");
        $nim           = $this->input->post("nim");
        
        $KEDUA= $this->load->database('second', TRUE);
  
        
        
		$where= array();

if($kdstsemester !=''){
             $where['kdstsemester']=$kdstsemester;
        }
		
		if($nim !=''){
             $where['nim']=$nim;
        }
			
			$KEDUA->select('*');
			$KEDUA->from('v_nilai_semester');
			
			$KEDUA->where($where);
        $q = $KEDUA->get();
       
        $data = array();
        if ($q->num_rows() > 0) {
            $data = $q->result();
        }
        $ttl = count($data);
        
        $build_array = array ("success"=>true,"results"=>$ttl,"data"=>array());

foreach($data as $row) {
            array_push($build_array["data"],array(
                'kdmk'=>$row->kdmk,
                'nmmk'=>$row->nmmkind,
                'jmlsks'=>$row->jmlsks,
                'nilaihuruf'=>$row->nilaihuruf,
				'bobotnilai'=>$row->bobotnilai,
                'mutu'=>$row->mutu,//$row->nmmkind,
                'sm'=>(floatval($row->jmlsks) * floatval($row->mutu)),//$row->nmmkind,
                'dsnpengampu'=>$row->nmdosdgngelar,
                
            ));
        }
            echo json_encode($build_array);

}
    
	 function form_mhs(){ //ISTRA
        $KEDUA= $this->load->database('second', TRUE);  /*membuka koneksi database untuk d_mahasiswa*/
           
       // $nama              = $this->input->post("nama");
        $userid     = $this->input->post("userid");
        $KEDUA->select("*");
        $KEDUA->from("vv_mahasiswa_profile2"); 
        
        if($userid!=''){
            $where['nim']=$userid;
            $KEDUA->where($where);
        }
   
        $q = $KEDUA->get(); 
       
        if ($q->num_rows() > 0)
        {
            $row = $q->row();
            
            $nim=$row->nim;
            $nmmhs=$row->nmmhs;
            $nmfakultas=$row->nmfakultas;
            $nmprodi=$row->nmprodi;
            $kdprodi=$row->kdprodi;
			$idklsmhs=$row->idklsmhs;
            $tahunmsk=$row->thnmasuk; //in beda
            $persen='-';//'100',
            $stbayar='-';
            $foto=$row->foto;
            $idjnssemester=$row->idjnssemester;
            $kdstsemester=$this->input->post("kdstsemester");
            $kdthnakademik=$row->kdthnakademik.' '.$row->nmjnssemester;
            //$nmstaktivitasmhs=$row->nmstaktivitasmhs;
        } else {
		
            $nim="-";
            $nmmhs="-";
            $nmfakultas="-";
            $nmprodi="-";
            $kdprodi="-";
			$idklsmhs="-";
            $tahunmsk="-";
            $persen="-";
            $stbayar="-";
            $foto="-";
            $idjnssemester="-";
            $kdstsemester="-";
            $kdthnakademik="-";
		}
		
		$countkhs = $this->count_khs($nim,$kdstsemester);
		$countkuisioner = $this->count_kuisioner($nim,$kdstsemester);
           
       echo '{"nim":"'.$nim.'","nmmhs":"'.$nmmhs.'","nmfakultas":"'.$nmfakultas.'","nmprodi":"'.$nmprodi
               .'","kdprodi":"'.$kdprodi.'","idklsmhs":"'.$idklsmhs.'","tahunmsk":"'.$tahunmsk.'","persen":"'.$persen
               .'","stbayar":"'.$stbayar.'","foto":"'.$foto.'","idjnssemester":"'.$idjnssemester
               .'","kdstsemester":"'.$kdstsemester.'","kdthnakademik":"'.$kdthnakademik
			   .'","countkhs":"'.$countkhs.'","countkuisioner":"'.$countkuisioner.'"}';
    }
	
	function count_khs($nim,$kdstsemester){
		$KEDUA= $this->load->database('second', TRUE);
		$q =$KEDUA->query("SELECT *
							FROM
							  nilai
							WHERE
							  nim = '".$nim."'
							  AND kdstsemester = '".$kdstsemester."'
							  AND idstsetuju=1");

return $q->num_rows();
	
	}
	
	function count_kuisioner($nim,$kdstsemester){
		$KEDUA= $this->load->database('second', TRUE);
		$q =$KEDUA->query("SELECT *
						FROM
						  kuisionerdet
						WHERE
						  nim = '".$nim."'
						  AND kdstsemester = '".$kdstsemester."' 
						group by kdmk");
  
		return $q->num_rows();
	
	}
   	
	
    function kelengkapan(){
        $KEDUA= $this->load->database('second', TRUE);
        $nim                      = $this->input->post("nim");
        $kdprodi                  = $this->input->post("kdprodi");
		$idklsmhs                 = $this->input->post("idklsmhs");
        $tahunmsk                 = $this->input->post("tahunmsk");
		$kdstsemester            = $this->input->post("kdstsemester");

$q = "SELECT getkelengkapan('".$nim."','".$kdprodi."','".$idklsmhs."','".$tahunmsk."','".$kdstsemester."') as nm;";
		
        $query  = $KEDUA->query($q);
        $nm= ''; 
                    
        if ($query->num_rows() > 0)
        {
            $row = $query->row();
            $nm=$row->nm;
        }
        echo $nm;
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2023-09-12 07:22:27
..	dir	-	root/root	drwxr-xr-x	2024-07-20 07:18:31
c_cetak_kartu_ujian.php	text/x-php	6 KB	root/root	-rwxr-xr-x	2018-07-13 02:07:46
c_kartuhasilstudi.php	text/x-php	5.44 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_karturencanastudi - Copy.php	text/x-php	26.06 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_karturencanastudi - normal.php	text/x-php	31.16 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_karturencanastudi.php	text/x-php	42.95 KB	root/root	-rwxr-xr-x	2024-10-13 07:22:41
c_matkulabsennilaimhsdos.php	text/x-php	8.91 KB	root/root	-rwxr-xr-x	2021-11-13 02:15:31
c_perwalian - Copy.php	text/x-php	24.6 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_perwalian.php	text/x-php	22.81 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_pesan.php	text/x-php	4.1 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_studentbody.php	text/x-php	5.93 KB	root/root	-rwxr-xr-x	2015-08-13 11:46:18
c_transkripakademik.php	text/x-php	8.83 KB	root/root	-rwxr-xr-x	2017-01-03 02:35:37