package com.example.topmeet;

import androidx.appcompat.app.AppCompatActivity;

import android.app.ProgressDialog;
import android.content.Intent;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import com.android.volley.Request;
import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;
import com.android.volley.toolbox.Volley;

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import java.util.ArrayList;

public class Magraden extends AppCompatActivity {

    TextView CorreuRebut;
    Button Home;

    private String url_String_Magraden = "http://topmeet.es/final/select_lista_magraden.php";
    private static ProgressDialog mProgressDialog;
    private ListView listView_Magraden;
    ArrayList<Usuaris> dataModelArrayListMagraden;
    private ListAdapterMagraden listAdapterMagraden;
    private RequestQueue mQueue;



    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_magraden);
        mQueue = Volley.newRequestQueue(this);

        Home = (Button)findViewById(R.id.Home);

        CorreuRebut = (TextView)findViewById(R.id.CorreuRebut);
        listView_Magraden = (ListView)findViewById(R.id.llista_Magraden);
        String correu = getIntent().getStringExtra("EnviarCorreu");
        CorreuRebut.setText(correu);

        leerjson();

        Home.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent home = new Intent(getApplicationContext(), Home.class);
                home.putExtra("Correuenviat", CorreuRebut.getText().toString());
                startActivity(home);
            }
        });
    }


    private void leerjson(){
        StringRequest stringRequest = new StringRequest(Request.Method.GET, url_String_Magraden,
                new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        try {
                            JSONObject obj = new JSONObject(response);
                            dataModelArrayListMagraden = new ArrayList<>();

                            JSONArray dataArray  = obj.getJSONArray("Usuaris");
                            for (int i = 0; i < dataArray.length(); i++) {

                                Usuaris playerModel = new Usuaris();
                                JSONObject dataobj = dataArray.getJSONObject(i);

                                playerModel.setIdUsuari(dataobj.getString("ultimId"));
                                playerModel.setNom(dataobj.getString("Nom"));
                                playerModel.setEdat(dataobj.getString("Edat"));
                                playerModel.setCiutat(dataobj.getString("Ciutat"));
                                //playerModel.setImgURL(dataobj.getString("imgURL"));



                                dataModelArrayListMagraden.add(playerModel);
                            }
                            setupListview();

                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                    }
                },
                new Response.ErrorListener() {
                    @Override
                    public void onErrorResponse(VolleyError error) {
                        //displaying the error in toast if occurrs
                        Toast.makeText(getApplicationContext(), error.getMessage(), Toast.LENGTH_SHORT).show();
                    }
                });

        RequestQueue requestQueue = Volley.newRequestQueue(this);
        requestQueue.add(stringRequest);

    }


    private void setupListview(){
        //will remove progress dialog
        listAdapterMagraden = new ListAdapterMagraden(this, dataModelArrayListMagraden, CorreuRebut.getText().toString());
        listView_Magraden.setAdapter(listAdapterMagraden);
    }
}


//////////////////////////////////////php


<?php

	$Correu = $_GET["Correu"];


	$con = new mysqli("sql261.main-hosting.eu","","","");

	$sql = "Select ultimId from Usuaris where Correu = '$Correu' ";

	$result = mysqli_query($con, $sql);

	while($row = mysqli_fetch_array($result)){


		$ultimIdMeu = $row[0];

	}

	$sql = "Select idPersonaSeleccionada from Magrada where ultimId = '$ultimId' ";

	$result = mysqli_query($con, $sql);

	while($row = mysqli_fetch_array($result)){


		$idPersonaSeleccionada = $row[0];

	}

	$sql = "Select DISTINCT Usuaris.ultimId, Usuaris.Correu, Usuaris.Pass, Usuaris.Nom, Usuaris.Edat, Usuaris.Telefon, Usuaris.Ciutat
			From Usuaris, Magrada
			Where  Usuaris.ultimId = Magrada.idPersonaSeleccionada and Magrada.idUsuariLoguejat =$ultimIdMeu";


	$result = mysqli_query($con, $sql);

	$usuaris = array(); //creamos un array

	while($row = mysqli_fetch_array($result)){

		$ultimId = $row['ultimId'];
		$Correu = $row['Correu'];
		$Pass = $row['Pass'];
		$Nom = $row['Nom'];
		$Edad = $row['Edat'];
		$Telefono = $row['Telefon'];
		$Ciutat = $row['Ciutat'];


		$usuaris[] = array('ultimId'=> $ultimId,'Nom'=> $Nom, 'Edat'=> $Edad, 'Ciutat'=> $Ciutat);


	}

	$json_string = json_encode(['Usuaris'=>$usuaris]);
	echo $json_string;


?>