<?php
    namespace app\controllers;

    use yii\web\Controller;
    use yii\helpers\Json;



    class MagisterrinciController extends Controller
    {
         public function actionIndex()
    {


//data usia fakultas
        $faculty = (new \yii\db\Query())
            ->select(['Faculty'])
            ->from('facultyin2011')
            ->limit(10)
            ->column();

        $lessfaculty = (new \yii\db\Query())
            ->select(['lessthan25'])
            ->from('facultyin2011')
            ->limit(10)
            ->column();
        $lessfaculty = array_map('floatval', $lessfaculty);


        $betweenfaculty = (new \yii\db\Query())
            ->select(['btween25to29'])
            ->from('facultyin2011')
            ->limit(10)
            ->column();
        $betweenfaculty = array_map('floatval', $betweenfaculty);



// next
        $department = (new \yii\db\Query())
            ->select(['Department'])
            ->from('department2011')
            ->limit(10)
            ->column();

        $lessdepartment = (new \yii\db\Query())
            ->select(['lessthan25'])
            ->from('department2011')
            ->limit(10)
            ->column();
         $lessdepartment = array_map('floatval', $lessdepartment);



        $betweendepartment = (new \yii\db\Query())
            ->select(['btween25to29'])
            ->from('department2011')

            ->limit(10)
            ->column();
        $betweendepartment = array_map('floatval', $betweendepartment);



    //next

        $major = (new \yii\db\Query())
            ->select(['major'])
            ->from('major2011')
            ->limit(10)
            ->column();

        $lessmajor = (new \yii\db\Query())
            ->select(['lessthan25'])
            ->from('department2011')
            ->limit(10)
            ->column();
         $lessmajor = array_map('floatval', $lessmajor);

        $betweenmajor = (new \yii\db\Query())
            ->select(['btween25to29'])
            ->from('department2011')
            ->limit(10)
            ->column();
        $betweenmajor = array_map('floatval', $betweenmajor);


        $faculty_lessarr=array();
        $drilldownArray=array();
        $faculty_betweenarr=array();



        foreach($faculty as $key=>$data){
                array_push($faculty_lessarr,
                    array('name'=>$faculty[$key]->Faculty,
                        'y'=>intval($lessfaculty[$key]->lessthan25),
                        'drilldown'=>$lessdepartment[$key]->lessthan25));

                array_push($drilldownArray,
                    array('name'=>$department[$key]->Department,
                        'id'=>$lessdepartment[$key]->lessthan25,
                        'data'=>array(['name'=>$department[$key]->Department,
                            'y'=>intval($lessdepartment[$key]->lessthan25),
                            'drilldown'=>$lessmajor[$key]->lessthan25])));

                array_push($faculty_betweenarr,
                    array('name'=>$faculty[$key]->Faculty,
                        'y'=>intval($betweenfaculty[$key]->btween25to29),
                        'drilldown'=>$betweendepartment[$key]->btween25to29));

                array_push($drilldownArray,
                    array('name'=>$department[$key]->Department,
                        'id'=>$betweendepartment[$key]->btween25to29,
                        'data'=>array(['name'=>$department[$key]->Department,
                            'y'=>intval($betweendepartment[$key]->btween25to29),
                            'drilldown'=>$betweenmajor[$key]->btween25to29])));
                        }

        foreach($department as $key=>$data){ //this is for third drilldown still trying
                        array_push($drilldownArray,
                            array('name'=>$department[$key]->Department,
                                'id'=>$lessmajor[$key]->lessthan25,
                                'data'=>array(['name'=>$major[$key]->major,
                                    'y'=>intval($lessmajor[$key]->lessthan25)])));
                        /*array_push($department_arr,array('name'=>$department[$key]['Department'],'y'=>intval($lessdepartment[$key]['lessthan25']),'drilldown'=>$lessmajor[$key]['lessthan25']));
                        array_push($department_arr,array('name'=>$department[$key]['Department'],'y'=>intval($betweendepartment[$key]['btween25to29']),'drildown'=>$betweenmajor[$key]['btween25to29']));*/
                        }

        $data['faculty'] = json_encode($faculty);
        $data['lessfaculty'] = json_encode($lessfaculty);
        $data['betweenfaculty'] = json_encode($betweenfaculty);

        $data['department'] = json_encode($department);
        $data['lessdepartment'] = json_encode($lessdepartment);
        $data['betweendepartment'] = json_encode($betweendepartment);

        $data['major'] = json_encode($major);
        $data['lessmajor'] = json_encode($lessmajor);
        $data['betweenmajor'] = json_encode($betweenmajor);



        return $this->render('index',$data);

        }



    }