package com.example.aplikasidashboard2.menuremainder;

import androidx.appcompat.app.AppCompatActivity;

import android.app.DatePickerDialog;
import android.content.SharedPreferences;
import android.os.Bundle;
import android.preference.PreferenceManager;
import android.util.Log;
import android.view.Gravity;
import android.view.LayoutInflater;
import android.view.MotionEvent;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.PopupWindow;
import android.widget.ProgressBar;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;

import com.example.aplikasidashboard2.R;
import com.example.aplikasidashboard2.koneksiHRD;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Locale;

public class createjadwal extends AppCompatActivity {

    EditText inserttgl,insertsubjek;
    Spinner spinner1;
    ResultSet rs;
    koneksiHRD connect;
    Button simpandata, kembalibtn, tanggalbtn;
    TextView header;
    String namaproject, kodeproject, sp1, kodenya;
    ProgressBar pbbar;
    Boolean isSuccess = false;

    int hasil;



    PopupWindow popUp;
    LayoutInflater layoutInflater;
    LinearLayout linear;

    private SimpleDateFormat dateFormatter;
    private DatePickerDialog datePickerDialog;


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.remaindercreatejadwal);
        setTitle("Tambah Jadwal");

        popUp = new PopupWindow(this);
        linear = (LinearLayout) findViewById(R.id.relativbgt);

        header = (TextView) findViewById(R.id.headercreatejadwal);

        inserttgl = (EditText) findViewById(R.id.inserttgl);
        insertsubjek = (EditText) findViewById(R.id.insertsubjek);

        simpandata = (Button) findViewById(R.id.simpandata);
        kembalibtn = (Button) findViewById(R.id.kembalicreate);
        tanggalbtn = (Button) findViewById(R.id.tanggalbtn);

        spinner1 = (Spinner) findViewById(R.id.spinner1);

        pbbar = (ProgressBar) findViewById(R.id.pbbara);
        pbbar.setVisibility(View.GONE);

        dateFormatter = new SimpleDateFormat("yyyy-MM-dd", Locale.ENGLISH);

        kodenya = getIntent().getStringExtra("kode");
        Log.e("koderemainder2",""+kodenya);


        simpandata.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
//                AddPro addPro = new AddPro();
//                addPro.execute("");
                simpandata();
            }
        });

        kembalibtn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                finish();
            }
        });

        tanggalbtn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                showDateDialog();
            }
        });

        spinner1.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> adapterView, View view, int i, long l) {
                sp1 = spinner1.getSelectedItem().toString().trim();
                Log.e("pilihan", "" + sp1);
            }

            @Override
            public void onNothingSelected(AdapterView<?> adapterView) {

            }
        });


        connect = new koneksiHRD();
        Connection con = connect.CONN();


        try {
            String queryspin = "select kdproj, nmproj from hsewa where kdproj ='005'";
            Statement stmt = con.createStatement();
            rs = stmt.executeQuery(queryspin);

            ArrayList<String> data = new ArrayList<String>();

            data.add("Silahkan Pilih");

            while (rs.next()) {

                kodeproject = rs.getString(1);
                namaproject = rs.getString(2);

                data.add(namaproject);
            }

            String[] array = data.toArray(new String[0]);
            ArrayAdapter<String> NoCoreAdapter = new ArrayAdapter<String>(createjadwal.this, R.layout.textview_with_background, data);
//            spinner1.setAdapter(NoCoreAdapter);
            NoCoreAdapter.setDropDownViewResource(R.layout.textview_with_background);
            spinner1.setAdapter(NoCoreAdapter);
        } catch (Exception e) {
            Log.e("error", "" + e.getMessage());
        }
    }



    private void showDateDialog() {
        Calendar newCalendar = Calendar.getInstance();
        datePickerDialog = new DatePickerDialog(this, new DatePickerDialog.OnDateSetListener() {
            @Override
            public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {

                Calendar newDate = Calendar.getInstance();
                newDate.set(year, monthOfYear, dayOfMonth);
                inserttgl.setText(dateFormatter.format(newDate.getTime()));
            }
        }, newCalendar.get(Calendar.YEAR), newCalendar.get(Calendar.MONTH), newCalendar.get(Calendar.DAY_OF_MONTH));
        datePickerDialog.show();
    }

//    public class AddPro extends AsyncTask<String, String, String> {
//
//
//
//        @Override
//        protected void onPreExecute() {
//            pbbar.setVisibility(View.VISIBLE);
//        }
//
//        @Override
//        protected void onPostExecute(String r) {
//            pbbar.setVisibility(View.GONE);
//
//        }
//
//        @Override
//        protected String doInBackground(String... params) {
//            return z;
//        }
//    }
//
    public void simpandata(){
        String z = "";
        String tanggalnya = inserttgl.getText().toString();
        String keterangan = insertsubjek.getText().toString();

        if (sp1.trim().equals("Silahkan Pilih") || tanggalnya.trim().equals("") || keterangan.trim().equals("")) {
            z = "Silahkan Masukan Subjek Serta Tanggalnya";
            Toast.makeText(createjadwal.this,z, Toast.LENGTH_LONG).show();
        }
        else {
            try {
                SharedPreferences app_preferences = PreferenceManager.getDefaultSharedPreferences(createjadwal.this);
                SharedPreferences.Editor editor = app_preferences.edit();
                int hasil = app_preferences.getInt("key",0);

                hasil = ++hasil;
                editor.putInt("key",hasil).commit();

                connect = new koneksiHRD();
                Connection con = connect.CONN();
                if (con == null) {
                    z = "Periksa Koneksi Internet Anda";
                    Toast.makeText(createjadwal.this,z, Toast.LENGTH_LONG).show();

                } else {
                    String dates = new SimpleDateFormat("yyyy", Locale.ENGLISH).format(Calendar.getInstance().getTime());
                    String query =
                            "insert into dsewa (KDPROJ,Nobukti,NoUrut,TGLBUKTI,KET1,KET2) values ('" + kodeproject + "','"+kodeproject+"/"+kodenya+"/"+dates +"/"+hasil+"','"+hasil+"'," +
                                    "'" + tanggalnya + "','"+ sp1 +"','" + keterangan + "')";
                    PreparedStatement preparedStatement = con.prepareStatement(query);
                    preparedStatement.executeUpdate();

                    inserttgl.getText().clear();
                    insertsubjek.getText().clear();

                    layoutInflater = (LayoutInflater) getApplicationContext().getSystemService(LAYOUT_INFLATER_SERVICE);
                    ViewGroup container = (ViewGroup) layoutInflater.inflate(R.layout.popupceklistambahjadwal, null);

                    popUp  = new PopupWindow(container,1000,300, true);
                    popUp.showAtLocation(linear, Gravity.CENTER, 0,0);

                    container.setOnTouchListener(new View.OnTouchListener() {
                        @Override
                        public boolean onTouch(View view, MotionEvent motionEvent) {
                            popUp.dismiss();
                            return true;
                        }
                    });

                    z = "Berhasil Menambahkan Jadwal";
                    Toast.makeText(createjadwal.this,z, Toast.LENGTH_LONG).show();

                    isSuccess = true;
                }
            } catch (Exception ex) {
                isSuccess = false;
                z = "Gagal Menambahkan Jadwal";
                Toast.makeText(createjadwal.this,z, Toast.LENGTH_LONG).show();

            }
        }

    }
}