Main7Activity

package com.example.tabita.myapplication;

import android.app.ProgressDialog;
import android.content.Context;
import android.content.Intent;
import android.os.AsyncTask;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.app.DatePickerDialog;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.BaseAdapter;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import java.io.PrintWriter;
import java.io.StringWriter;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Locale;


public class Main7Activity extends AppCompatActivity implements View.OnClickListener {


    Button bfecha,bhoy,bbuscar;
    EditText efecha;
    private  int dia,mes,anio;

    private ArrayList<ClassListItems2> itemArrayList2;
    private Main7Activity.MyAppAdapter2 myAppAdapter2;
    private ListView listView;
    private boolean success = false;

    private String ip;
    private String base;
    private String user;
    private String pass;
    private String fecha;
    private String profe;
    private String todoeldia;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main7);

        bfecha=(Button)findViewById(R.id.bfecha);
        efecha=(EditText)findViewById(R.id.efecha);
        bfecha.setOnClickListener(this);

        bhoy=(Button)findViewById(R.id.bhoy);
        bhoy.setOnClickListener(this);

        bbuscar=(Button)findViewById(R.id.bbuscar);
        bbuscar.setOnClickListener(this);


        listView = (ListView) findViewById(R.id.listView_profesor_todoeldia);
        itemArrayList2 = new ArrayList<ClassListItems2>();


        Bundle bundle2 = getIntent().getExtras();
        ip = bundle2.getString("IP");
        base = bundle2.getString("BASE");
        user = bundle2.getString("USER");
        pass = bundle2.getString("PASS");

        Main7Activity.SyncData2 orderData = new Main7Activity.SyncData2();
        orderData.execute("");


    }


    @Override
    public void onClick(View v) {
        if(v==bfecha){
            final Calendar c= Calendar.getInstance();
            dia=c.get(Calendar.DAY_OF_MONTH);
            mes=c.get(Calendar.MONTH);
            anio=c.get(Calendar.YEAR);

            DatePickerDialog datePickerDialog = new DatePickerDialog(this, new DatePickerDialog.OnDateSetListener() {
                @Override
                public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
                    final String selectedDate = year+"-"+twoDigits(monthOfYear+1)+"-"+twoDigits(dayOfMonth);
                    efecha.setText(selectedDate);
                }
            }
                    ,anio,mes,dia);
            datePickerDialog.show();

        }
        if(v==bhoy){
            SimpleDateFormat formatoFecha = new SimpleDateFormat("yyyy-MM-dd", Locale.getDefault());
            Date date = new Date();
            efecha.setText(formatoFecha.format(date));
        }

        if(v==bbuscar){



        }

    }

    private String twoDigits(int n) {
        return (n<=9) ? ("0"+n) : String.valueOf(n);
    }






    private class SyncData2 extends AsyncTask<String, String, String> {
        String msg = "¡¡¡Internet/DB_Credentials/Windows_Firewall_TurnOn Error, Compruebe mensaje de error para más detalles!!!";
        ProgressDialog progress;

        @Override
        protected void onPreExecute() {
            progress = ProgressDialog.show(Main7Activity.this, "Sincronizando",
                    "Cargando ausencias. Por favor, espere....",true);
        }

        @Override
        protected String doInBackground(String... strings) {
            try{
                Class.forName("com.mysql.jdbc.Driver");
                Connection conexion_a_mysql = DriverManager.getConnection("jdbc:mysql://"+ip+":3306/"+base,user,pass);
                if(conexion_a_mysql == null){
                    success = false;
                }else{
                    String query = "SELECT id,idprofesor,todoeldia FROM ausencias WHERE '"+efecha+"' BETWEEN inicio AND fin";
                    Statement stmt = conexion_a_mysql.createStatement();
                    ResultSet rs = stmt.executeQuery(query);
                    if(rs != null){
                        while(rs.next()) {
                            try{
                                itemArrayList2.add(new ClassListItems2(rs.getInt("id"), rs.getString("idprofesor"), rs.getString("todoeldia")));
                            } catch (Exception ex){
                                ex.printStackTrace();
                            }
                        }
                        msg = "Ejecutado correctamente";
                        success = true;
                    } else{
                        msg = "ERROR en la ejecución";
                        success = false;
                    }
                }
            } catch (Exception ex){
                ex.printStackTrace();
                Writer writer = new StringWriter();
                ex.printStackTrace(new PrintWriter(writer));
                msg = writer.toString();
                success = false;
            }
            return msg;
        }

        @Override
        protected void onPostExecute(String msg) {
            progress.dismiss();
            Toast.makeText(Main7Activity.this, msg + "", Toast.LENGTH_LONG).show();
            if(success == false){
            }else{
                try{
                    myAppAdapter2 = new Main7Activity.MyAppAdapter2(itemArrayList2, Main7Activity.this);
                    listView.setChoiceMode(ListView.CHOICE_MODE_MULTIPLE);
                    listView.setAdapter(myAppAdapter2);
                } catch (Exception ex){

                }
            }
        }
    }

    public class MyAppAdapter2 extends BaseAdapter{
        public class ViewHolder{
            public TextView txtTodoeldia;
            public TextView txtProfe;
            public TextView textID;
        }

        public List<ClassListItems2> ausencias_list;

        public Context context;
        ArrayList<ClassListItems2> arrayList2;

        private MyAppAdapter2(List<ClassListItems2> apps, Context context) {
            this.ausencias_list = apps;
            this.context = context;
            arrayList2 = new ArrayList<ClassListItems2>();
            arrayList2.addAll(ausencias_list);
        }

        @Override
        public int getCount() { return  ausencias_list.size(); }

        @Override
        public Object getItem(int position) { return position; }

        @Override
        public long getItemId(int position) { return position; }

        @Override
        public View getView(final int position, View convertView, ViewGroup parent){
            View rowView = convertView;
            Main7Activity.MyAppAdapter2.ViewHolder viewHolder = null;
            if(rowView == null){
                LayoutInflater inflater = getLayoutInflater();
                rowView = inflater.inflate(R.layout.list_content2, parent, false);
                viewHolder = new Main7Activity.MyAppAdapter2.ViewHolder();
                viewHolder.textID = (TextView) rowView.findViewById(R.id.textID);
                viewHolder.txtProfe = (TextView) rowView.findViewById(R.id.textProfe);
                viewHolder.txtTodoeldia = (TextView) rowView.findViewById(R.id.textTodoeldia);
                rowView.setTag(viewHolder);
            } else{
                viewHolder = (Main7Activity.MyAppAdapter2.ViewHolder) convertView.getTag();
            }

            profe = (ausencias_list.get(position).getIdprofesor() + "");
            if (profe.equals("1")){
                viewHolder.txtProfe.setText("Administrador");
            }
            if (profe.equals("20186")){
                viewHolder.txtProfe.setText("Fernández Odero, José Luis");
            }
            if (profe.equals("88455")){
                viewHolder.txtProfe.setText("Urbano Montero, José Antonio");
            }
            if (profe.equals("112706")){
                viewHolder.txtProfe.setText("Sarmiento Molina, Manuela");
            }
            if (profe.equals("127354")){
                viewHolder.txtProfe.setText("Rodríguez Fernández, Eva");
            }
            if (profe.equals("132178")){
                viewHolder.txtProfe.setText("Rodríguez Macías, Víctor Miguel");
            }

            viewHolder.textID.setText(ausencias_list.get(position).getId() + "");

            viewHolder.txtTodoeldia.setText(ausencias_list.get(position).getTodoeldia() + "");
            todoeldia = (ausencias_list.get(position).getTodoeldia() + "");
            if (todoeldia.equals("1")){
                viewHolder.txtTodoeldia.setText("Sí" + "");
            }
            if (todoeldia.equals("0")){
                viewHolder.txtTodoeldia.setText("No" + "");
            }


            listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
                int ID = 0;
                @Override
                public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
                    ID = ausencias_list.get(position).getId();
                    Bundle bundle2 = new Bundle();
                    Intent desieteacinco = new Intent(Main7Activity.this,Main5Activity.class);
                    bundle2.putString("IP",ip);
                    bundle2.putString("BASE",base);
                    bundle2.putString("USER",user);
                    bundle2.putString("PASS",pass);
                    bundle2.putInt("ID",ID);


                    desieteacinco.putExtras(bundle2);
                    startActivity(desieteacinco);
                }
            });

            return  rowView;

        }
    }


}