Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.60 KB | None | 0 0
  1. $resISDEFE = mysqli_query($conexion,"SELECT * FROM personal_isdefe WHERE proyecto=".$idProyecto);
  2. if($resISDEFE->num_rows>0){
  3. $index=0;
  4. while($isdefe = mysqli_fetch_assoc($resISDEFE)){
  5. $resCategoria = mysqli_query($conexion,"SELECT * FROM categoria_isdefe WHERE id=".$isdefe['categoria']);
  6. $categoria = $resCategoria->fetch_row();
  7. $idISDEFE = $isdefe['id']; <-- I save the row's ID here -->
  8. echo "<tr id='isdefe'>";
  9. echo "<td><p>".$idISDEFE."</p></td>";
  10. echo "<td><p>".$categoria[1]."</p></td>";
  11. echo "<td><p>".$isdefe['edg']."</p></td>";
  12. echo "<td><p><a data-toggle='modal' data-target='#modalConcepto'>".$isdefe['porcentaje']."%</a></p></td>";
  13. echo "<td><p>".$isdefe['horas_contratadas']."</p></td>";
  14. $importe_prestacion = $isdefe['horas_contratadas'] * $categoria[2];
  15. echo "<td><p>".number_format($importe_prestacion,2,",",".")." €</p></td>";
  16.  
  17. echo "<td><p>".number_format(($isdefe['importe_variable']+$importe_prestacion),2,",",".")." €</p></td>";
  18. echo "</tr>";
  19.  
  20.  
  21. }
  22.  
  23. <div class="modal fade" id="modalConcepto" role="dialog">
  24. <div class="modal-dialog modal-lg">
  25. <div class="modal-content">
  26. <div class="modal-header">
  27. <h4 class="modal-title">Editar concepto</h4>
  28. </div>
  29. <div class="modal-body">
  30. <div class="form-group">
  31. <textarea class="form-control" rows="10" id="newConcepto"></textarea><br>
  32. </div>
  33. </div>
  34. <div class="modal-footer">
  35. <button type="button" class="btn btn-default" data-dismiss="modal" onclick='editConcepto(<?php $idISDEFE ?>)'>Guardar</button>
  36. <button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
  37. </div>
  38. </div>
  39. </div>
  40.  
  41. function newConcepto(id, newConcepto){
  42. if(newConcepto!=""){
  43. $.get("ajax/editarConceptoISDEFE.php?id="+id+"&con="+newConcepto, function(data){
  44. if(data=="1"){
  45. var time = setTimeout(function(){
  46. location.reload();
  47. },500);
  48. }
  49. else alert("Error al actualizar el concepto");
  50. });
  51. }
  52. }
  53.  
  54. function editConcepto(id){
  55. var newConcepto = $('#newConcepto').val();
  56. newConcepto(id,newConcepto);
  57. }
  58. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement