<?php
    namespace app\controllers;

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



    class MagisterrinciiController extends Controller
    {

         public function actionIndex()
    {


//data usia fakultas
        $categoryArray = [];

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

        array_push($categoryArray,
                    array('id'=>0,
                        'categories'=>$faculty));

        $faculty2 = array_map('floatval', $faculty);


        $lessthan25 = (new \yii\db\Query())
            ->select(['lessthan25'])
            ->from('temp_usia2011fak')
            ->limit(10)
            ->column();
            // print_r($lessthan25);die();
        $fakultas = $faculty;

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



        $lessthan25 = array_map('floatval', $lessthan25);

        foreach ($lessthan25 as $key => $lessthan25_value) {
            $lessthan25[$key] = [
                'name' => $fakultas.[$key],
                'y' => $lessthan25_value,
                'drilldown' => 'department'.$fakultas[$key].'less'
            ];
        };


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


        $between25to29 = array_map('floatval', $between25to29);

         foreach ($between25to29 as $key => $between25to29_value) {
            $between25to29[$key] = [
                'name' => $fakultas.[$key],
                'y' => $between25to29_value,
                'drilldown' => 'department'.$fakultas[$key].'betw'
            ];
        };

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


        $between30to34 = array_map('floatval', $between30to34);

         foreach ($between30to34 as $key => $between30to34_value) {
            $between30to34[$key] = [
                'name' =>  $fakultas.[$key],
                'y' => $between30to34_value,
                'drilldown' => 'department'.$fakultas[$key].'betw'
            ];
        };





        $data['lessthan25'] = json_encode($lessthan25);
        $data['between25to29'] = json_encode($between25to29);
        $data['between30to34'] = json_encode($between30to34);


// next
        $i = 1;
        $drilldownArray = [];
        foreach($faculty2 as $keyf=>$faculty_value){

        $department = (new \yii\db\Query())
            ->select(['Departemen'])
            ->from('temp_usia2011dept')
            ->where('Departemen like "'.$fakultas[$keyf].'%"')
            ->limit(10)
            ->column();

        array_push($categoryArray,
                    array('id'=>$i,
                        'categories'=>$department));



        $lessdepartment = (new \yii\db\Query())
            ->select(['lessthan25'])
            ->from('temp_usia2011dept')
            ->where('Departemen like "'.$fakultas[$keyf].'%"')
            ->limit(10)
            ->column();
         $lessdepartment = array_map('floatval', $lessdepartment);

        foreach ($lessdepartment as $key => $lessdepartment_value) {
                $lessdepartment[$key] = [
                'name' => $fakultas[$keyf].($key+1),
                'y' => $lessdepartment_value,
                'drilldown' => 'major1'
            ];
            };

        array_push($drilldownArray,
                    array('name'=>'lessthan25',
                        'xAxis'=> $keyf+1,
                        'id'=>'department'.$fakultas[$keyf].'less',
                        'data'=>$lessdepartment));


        $betweendepartment = (new \yii\db\Query())
            ->select(['btween25to29'])
            ->from('temp_usia2011dept')
            ->where('Departemen like "'.$fakultas[$keyf].'%"')
            ->limit(10)
            ->column();


        $betweendepartment = array_map('floatval', $betweendepartment);
        foreach ($betweendepartment as $key => $betweendepartment_value) {
                $betweendepartment[$key] = [
                'name' => $fakultas[$keyf].($key+1),
                'y' => $betweendepartment_value,
                'drilldown' => 'major2'
            ];
            };

            array_push($drilldownArray,
                    array('name'=>'btween25to29',
                        'xAxis'=> $keyf+1,
                        'id'=>'department'.$fakultas[$keyf].'betw',
                        'data'=>$betweendepartment));



            $i++;
        }

        // $data['department'] = json_encode($department);

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

        $data['categoryArray'] = json_encode($categoryArray);

        $data['drilldownArray'] = json_encode($drilldownArray);



//next

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

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

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


        $lessmajor = array_map('floatval', $lessmajor);
        $betweenmajor = array_map('floatval', $betweenmajor);


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






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

        }



    }