package pl.mikigal.ledcontroller;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.ImageButton;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class MainActivity extends AppCompatActivity {

    private ImageButton led1;
    private ImageButton led2;
    private ImageButton led3;
    private ImageButton led4;
    private ImageButton led5;
    private ImageButton led6;

    private boolean led1State = true;
    private boolean led2State = true;
    private boolean led3State = true;
    private boolean led4State = true;
    private boolean led5State = true;
    private boolean led6State = true;

    private Connection conn;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try {
            conn = DriverManager.getConnection("jdbc:mysql://192.168.0.189:3306/rpi", "root", "zaq1@WSX");
            System.out.println("fasdjkfbhauisdfgasiudfgasiufgiasudfgiaosudfgoasdfgiasoudfgasoidfgasioufgouasd");
        } catch (SQLException e) {
            e.printStackTrace();
        }

        led1 = (ImageButton) findViewById(R.id.led1);
        led2 = (ImageButton) findViewById(R.id.led2);
        led3 = (ImageButton) findViewById(R.id.led3);
        led4 = (ImageButton) findViewById(R.id.led4);
        led5 = (ImageButton) findViewById(R.id.led5);
        led6 = (ImageButton) findViewById(R.id.led6);

        led1.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led1State = reverse(led1State);
                setState("led1", led1State);
                updateDrawable(led1, led1State);
            }
        });
        led2.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led2State = reverse(led2State);
                setState("led2", led2State);
                updateDrawable(led2, led2State);
            }
        });
        led3.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led3State = reverse(led3State);
                setState("led3", led3State);
                updateDrawable(led3, led3State);
            }
        });
        led4.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led4State = reverse(led4State);
                setState("led4", led4State);
                updateDrawable(led4, led4State);
            }
        });
        led5.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led5State = reverse(led5State);
                setState("led5", led5State);
                updateDrawable(led5, led5State);
            }
        });
        led6.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                led6State = reverse(led6State);
                setState("led6", led6State);
                updateDrawable(led6, led6State);
            }
        });
    }

    public void setState(final String led, final boolean state){
        Thread t = new Thread(){
            @Override
            public void run(){
                try {
                    PreparedStatement ps = conn.prepareStatement("UPDATE `diody` SET `" + led + "`=" + state + " WHERE `id`=?");
                    ps.setInt(1, 1);
                    ps.executeUpdate();
                    ps.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        };
        t.start();
    }

    public boolean reverse(boolean b){
        if(b == true){
            return false;
        }
        return true;
    }
    public void updateDrawable(ImageButton ib, boolean state){
        if(state) {
            ib.setImageDrawable(getResources().getDrawable(R.drawable.on));
            return;
        }
        ib.setImageDrawable(getResources().getDrawable(R.drawable.off));
    }
}