public function actionFilterjurusan()
{

$data=Jurusan::model()->findAll('id_tingkatan=:id_tingkatan',array(':id_tingkatan'=>$_POST['id_tingkatan']));

$data=CHtml::listData($data,'id_jurusan','jurusan');
echo '<option value="">Pilih Jurusan</option>';
foreach($data as $value=>$name)
{
echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name),true);
}

}

public function actionFilterkelas()
{

$data=Kelas::model()->findAll('id_jurusan=:id_jurusan',array(':id_jurusan'=>$_POST['id_jurusan']));

$data=CHtml::listData($data,'kelas','kelas');
echo '<option value="">Pilih Kelas</option>';
foreach($data as $value=>$name)
{
echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name),true);
}

}

public function actionFiltersiswa()
{

$data=Siswa::model()->findAll('kelas=:kelas',array(':kelas'=>$_POST['kelas']));

$data=CHtml::listData($data,'nisn','nama');
foreach($data as $value=>$name)
{
echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name),true);
}

}

public function actionAutocomplete()
{
//$id = Yii::app()->session['idsatker'] and id_satuan_kerja = $id ;
if (isset($_GET['term'])) {
$qtxt =" SELECT * from siswa where nama LIKE :data ";

$command =Yii::app()->db->createCommand($qtxt);
$command->bindValue(":data",'%'.$_GET['term'].'%', PDO::PARAM_STR);
$res =$command->queryAll();

}

$arr = array();
foreach($res as $r)
{
$arr[] = array(
'label'=>$r['nama'].'-'.$r['kelas'], // label for dropdown list
'value'=>$r['nama'], // value for input field
'id'=>$r['nisn'],
// return value from autocomplete
);
}
echo CJSON::encode($arr);
}