package com.example.ujicobaspinner;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import android.annotation.SuppressLint;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

import androidx.appcompat.app.AppCompatActivity;


public class MainActivity extends AppCompatActivity {
    Spinner spinner1, spinner2, spinner3;
    String ip, db, un, passwords;
    Button btnsearch;
    EditText searchdata;
    EditText edtnobarang;
    Connection connect;
    PreparedStatement stmt;
    ResultSet rs;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        ip = "192.168.0.171";
        un = "sa";
        passwords = "arya281196";
        db = "aryaaa";

        btnsearch = (Button) findViewById(R.id.btnsearch);
        searchdata  = (EditText) findViewById(R.id.searchdata);
        edtnobarang = (EditText) findViewById(R.id.edtnobarang);
        spinner1 = (Spinner) findViewById(R.id.idspinner1);
        spinner2 = (Spinner) findViewById(R.id.idspinner2);
        //spinner3 = (Spinner) findViewById(R.id.idspinner3);


        btnsearch.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String search =  searchdata.getText().toString().trim();
                setSpinner1 (search);
                setSpinner2 (search);
            }
        });

        edtnobarang.setOnFocusChangeListener(new View.OnFocusChangeListener() {

            @Override
            public void onFocusChange(View arg0, boolean hasFocus) {
                // TODO Auto-generated method stub
                if(hasFocus){
                    spinner2.setVisibility(View.VISIBLE);

                }
            }
        });

        spinner1.setOnItemSelectedListener(new OnItemSelectedListener() {

            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                String name = spinner1.getSelectedItem().toString();
                if(name.equals("Pintu")){
                }

                Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
            }
            @Override
            public void onNothingSelected(AdapterView<?> parent) {
            }
        });


        spinner2.setOnItemSelectedListener(new OnItemSelectedListener() {

            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                String name = spinner2.getSelectedItem().toString();
                if (name.equals("")){

                }
                Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
            }
            @Override
            public void onNothingSelected(AdapterView<?> parent) {
            }
        });

//        spinner3.setOnItemSelectedListener(new OnItemSelectedListener() {
//            @Override
//            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
//                String name = spinner3.getSelectedItem().toString();
//                Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
//            }
//            @Override
//            public void onNothingSelected(AdapterView<?> parent) {
//            }
//        });
    }

    // set spinner pertama (1)
    public void setSpinner1(String kode) {
        connect = CONN(un, passwords, db, ip);
        String query1 = "select namabarang from Jenis_Barang where id = '"+kode+"' ";
        Log.e("query",""+query1);
        try {
            connect = CONN(un, passwords, db, ip);
            stmt = connect.prepareStatement(query1);
            rs = stmt.executeQuery();

            ArrayList<String> data = new ArrayList<String>();
            while (rs.next()) {
                String id = rs.getString(1);
                data.add(id);
                Log.e("idun",""+id);
            }
            String[] array = data.toArray(new String[0]);
            ArrayAdapter NoCoreAdapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, data);
            spinner1.setAdapter(NoCoreAdapter);
        } catch (Exception e) {
            e.printStackTrace();
            Log.e("errora",""+e.getMessage());
        }

    }


    //set spinner ke dua
    public void setSpinner2(String kode) {
        connect = CONN(un, passwords, db, ip);
        String query2 = "select namaitembarang from Item_Barang where id = '"+kode+"' ";
        Log.e("query",""+query2);
        try {
            connect = CONN(un, passwords, db, ip);
            stmt = connect.prepareStatement(query2);
            rs = stmt.executeQuery();

            ArrayList<String> data = new ArrayList<String>();
            while (rs.next()) {
                String id = rs.getString(1);
                data.add(id);
            }

            String[] array = data.toArray(new String[0]);
            ArrayAdapter NoCoreAdapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, data);
            spinner2.setAdapter(NoCoreAdapter);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }





    @SuppressLint("NewApi")
    private Connection CONN(String _user, String _pass, String _DB, String _server) {
        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
        StrictMode.setThreadPolicy(policy);
        Connection conn = null;
        String ConnURL = null;
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            ConnURL = "jdbc:jtds:sqlserver://" + _server + ";"
                    + "databaseName=" + _DB + ";user=" + _user + ";password="
                    + _pass + ";";
            conn = DriverManager.getConnection(ConnURL);
        } catch (SQLException se) {
            Log.e("ERRO", se.getMessage());
        } catch (ClassNotFoundException e) {
            Log.e("ERRO", e.getMessage());
        } catch (Exception e) {
            Log.e("ERRO", e.getMessage());
        }
        return conn;
    }
}