public function getDetailVas()
    {
        //succes rate
        $succes = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SUCCESS" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_DIALOG_TIMEOUT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_DIALOG_TIMEOUT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_PROVIDER_ABORT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_PROVIDER_ABORT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_DIALOG_USER_ABORT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_DIALOG_USER_ABORT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_DIALOG_REJECTED = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_DIALOG_REJECTED" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();




        //error
        $FAILED_SYSTEM_FAILURE = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_SYSTEM_FAILURE" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_MAP_ERROR_COMPONENT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_MAP_ERROR_COMPONENT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_MAP_REJECT_COMPONENT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_PROVIDER_ABORT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $ABORT_APP = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="ABORT_APP" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_DIALOG_REJECTED  = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_DIALOG_REJECTED" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_PROVIDER_ABORT  = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_PROVIDER_ABORT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_DIALOG_USER_ABORT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_DIALOG_USER_ABORT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_DIALOG_TIMEOUT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_DIALOG_TIMEOUT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_MAP_REJECT_COMPONENT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_MAP_REJECT_COMPONENT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_ABSENT_SUBSCRIBER = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_ABSENT_SUBSCRIBER" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_CALL_BARRED = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_CALL_BARRED" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_TELESERVICE_NOT_PROVISIONED = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_TELESERVICE_NOT_PROVISIONED" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_UNKNOWN_SUBSCRIBER = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_UNKNOWN_SUBSCRIBER" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $SRI_MAP_ERROR_COMPONENT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="SRI_MAP_ERROR_COMPONENT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_INVOKE_TIMEOUT  = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_INVOKE_TIMEOUT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_APP_TIMEOUT = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_APP_TIMEOUT" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_CORRUPTED_MESSAGE = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_CORRUPTED_MESSAGE" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_TRANSPORT_ERROR = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_TRANSPORT_ERROR" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();
        $FAILED_TRANSPORT_FAILURE  = $this->db->query('SELECT FROM_UNIXTIME( ( UNIX_TIMESTAMP(time) DIV (15* 60) ) * (15*60) ) time , counter , SUM(count) count FROM umb.ussdnode72 WHERE counter ="FAILED_TRANSPORT_FAILURE" GROUP BY UNIX_TIMESTAMP(time) DIV (15* 60) desc')->row();

        //total error
        $totalError = $FAILED_SYSTEM_FAILURE->count + $FAILED_MAP_ERROR_COMPONENT->count +
                      $FAILED_MAP_REJECT_COMPONENT->count + $ABORT_APP->count+
                      $SRI_DIALOG_REJECTED->count +  $SRI_PROVIDER_ABORT +
                      $SRI_DIALOG_USER_ABORT->count + $SRI_DIALOG_TIMEOUT->count +
                      $SRI_MAP_REJECT_COMPONENT->count + $SRI_ABSENT_SUBSCRIBER +
                      $SRI_CALL_BARRED->count + $SRI_TELESERVICE_NOT_PROVISIONED +
                      $SRI_UNKNOWN_SUBSCRIBER->count + $SRI_MAP_ERROR_COMPONENT +
                      $FAILED_INVOKE_TIMEOUT->count + $FAILED_APP_TIMEOUT->count +
                      $FAILED_CORRUPTED_MESSAGE->count + $FAILED_TRANSPORT_ERROR->count +
                      $FAILED_TRANSPORT_FAILURE->count;


       //tampung total succes
       $totalSuccess = $succes->count + $FAILED_DIALOG_TIMEOUT->count +
                      $FAILED_PROVIDER_ABORT->count + $FAILED_DIALOG_USER_ABORT->count +
                      $FAILED_DIALOG_REJECTED->count;
        echo "<br>";
        echo "total success = ".$totalSuccess  ;
        echo "<br>";
        echo "total error = ".$totalError;
        echo "<br>";
        // total success + total error
        $jumlahseluruh   = $totalSuccess + $totalError;
        // echo $jumlahseluruh;
         $hasilbagi = $totalSuccess / $jumlahseluruh ;
         $hasilkali = $hasilbagi * 100;
         echo "hitung hasil =". $hasilkali;
         echo "<br>";

    //   $hasilSucess = $totalSuccess/($totalSuccess + $totalError);
    //   echo "hasil success ".$hasilSucess * 100;
    //   echo "<br>";

    //   $hasilError = $totalError / ($totalSuccess+$totalError);
    //   echo "hasil error ". $hasilError ;



    }