package academic.th;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.widget.Spinner;
import android.widget.Toast;

import academic.th.mMySQL.Downloader;

public class NotasActivity extends AppCompatActivity {


    //final static String urlAddress="http://lasalle.fin.ec/zacciones/obtener_trimestres.php";
    String codigo_alu="";


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_notas);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                        .setAction("Action", null).show();
            }
        });

        ////////////// CONSULTA PARAMETROS SQLITE

                AdminSQLite admin = new AdminSQLite(this,"administracion1",null,1);
                SQLiteDatabase bd= admin.getWritableDatabase();
                //String sclaumno1=calumno1.getText().toString();

                Cursor fila=bd.rawQuery("select calumno_alu,cpadre_alu,colegio_alu from alumno",null);

                if(fila.moveToFirst()){

                    codigo_alu=fila.getString(0);



                }
                else{

                    Toast.makeText(this,"El Alumno No esta ingresado",Toast.LENGTH_SHORT).show();
                    bd.close();
                }


         String urlAddress="http://lasalle.fin.ec/zacciones/obtener_trimestres.php?codigo_alu="+codigo_alu.toString();

        final Spinner spinertrimestre=(Spinner)findViewById(R.id.spinnerTrimestre1);
        new Downloader(NotasActivity.this,urlAddress,spinertrimestre).execute();



    }

}