Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.04 KB | None | 0 0
  1. StringRequest stringRequest = new StringRequest(Request.Method.GET, testInserirPontoURL,
  2. new Response.Listener<String>() {
  3. @Override
  4. public void onResponse(String response) {
  5. Toast.makeText(getApplicationContext(), response, Toast.LENGTH_SHORT).show();
  6. }
  7. },
  8. new Response.ErrorListener() {
  9. @Override
  10. public void onErrorResponse(VolleyError error) {}
  11. }) {
  12. @RequiresApi(api = Build.VERSION_CODES.O)
  13. @Override
  14. public Map<String, String> getHeaders() throws AuthFailureError {
  15. String codColab = getIntent().getStringExtra("codigo colaborador");
  16. LocalDate ldHoraEntrada = LocalDate.of(ponto.getEntrada().get(Calendar.YEAR), ponto.getEntrada().get(Calendar.MONTH) + 1, ponto.getEntrada().get(Calendar.DAY_OF_MONTH));
  17. String horaEntrada = ldHoraEntrada + " " + sdfHora2.format(ponto.getEntrada().getTime());
  18. LocalDate ldSaidaAlmoco = LocalDate.of(ponto.getSaidaAlmoco().get(Calendar.YEAR), ponto.getSaidaAlmoco().get(Calendar.MONTH) + 1, ponto.getSaidaAlmoco().get(Calendar.DAY_OF_MONTH));
  19. String saidaAlmoco = ldSaidaAlmoco + " " + sdfHora2.format(ponto.getSaidaAlmoco().getTime());
  20. LocalDate ldEntradaTarde = LocalDate.of(ponto.getEntradaTarde().get(Calendar.YEAR), ponto.getEntradaTarde().get(Calendar.MONTH) + 1, ponto.getEntradaTarde().get(Calendar.DAY_OF_MONTH));
  21. String entradaTarde = ldEntradaTarde + " " + sdfHora2.format(ponto.getEntradaTarde().getTime());
  22. LocalDate ldHoraSaida = LocalDate.of(ponto.getSaida().get(Calendar.YEAR), ponto.getSaida().get(Calendar.MONTH) + 1, ponto.getSaida().get(Calendar.DAY_OF_MONTH));
  23. String horaSaida = ldHoraSaida + " " + sdfHora2.format(ponto.getSaida().getTime());
  24.  
  25. Map<String, String> map = new HashMap<String, String>();
  26. map.put("horaEntrada", horaEntrada);
  27. map.put("saidaAlmoco", saidaAlmoco);
  28. map.put("entradaTarde", entradaTarde);
  29. map.put("horaSaida", horaSaida);
  30. map.put("cod_colab", codColab);
  31. return map;
  32. }
  33. };
  34. RequestQueue requestQueue = Volley.newRequestQueue(PontoActivity.this);
  35. requestQueue.add(stringRequest);
  36.  
  37. if($_SERVER['REQUEST_METHOD']=='GET'){
  38.  
  39. $horaEntrada = $_GET['horaEntrada'];
  40. $saidaAlmoco = $_GET['saidaAlmoco'];
  41. $entradaTarde = $_GET['entradaTarde'];
  42. $horaSaida = $_GET['horaSaida'];
  43. $cod_colab = $_GET['cod_colab'];
  44.  
  45. $sql= "INSERT INTO ponto (hora_entrada,saida_almoco,entrada_tarde,hora_saida,cod_colab) VALUES ('".$horaEntrada."', '".$saidaAlmoco."', '".$entradaTarde."', '".$horaSaida."', '".$cod_colab."')";
  46. //$sql= "INSERT INTO `ponto` (`id`, `hora_entrada`, `saida_almoco`, `entrada_tarde`, `hora_saida`, `cod_colab`) VALUES (NULL, '2019-05-15 10:25:41', '2019-05-09 14:25:37', '2019-05-16 11:20:13', '2019-05-09 13:25:30', '1')";
  47. //$sql= "INSERT INTO ponto (hora_entrada,saida_almoco,entrada_tarde,hora_saida,cod_colab) VALUES ('$horaEntrada', '$saidaAlmoco', '$entradaTarde', '$horaSaida', '$cod_colab')";
  48.  
  49. if (mysqli_query($conn, $sql)){
  50. echo "registado";
  51. } else {
  52. echo "erro a registar";
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement