PageRenderTime 48ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/sicpri/05_galerias/02_modificar.php

https://bitbucket.org/webdev_pe/dmejiasoft
PHP | 128 lines | 125 code | 3 blank | 0 comment | 12 complexity | d38759322d0d3438d1333296786cec37 MD5 | raw file
  1. <?php
  2. require("../../poo/clases/getConection.php");
  3. $id = $_POST['i'];
  4. $cod = $_POST['c'];
  5. $ver = $_POST['v'];
  6. $cn=new getConection();
  7. if(isset($id)){
  8. $sql="select id_gal, id_zon, cod_gal, nom_gal, dir_gal from si_galerias where id_gal=".$id;
  9. $cn->ejecutar_sql(base64_encode($sql));
  10. $cel=$cn->resultado_sql();
  11. }else if(isset($cod)){
  12. $sql="select id_gal, id_zon, cod_gal, nom_gal, dir_gal from si_galerias where cod_gal='".$cod."'";
  13. $cn->ejecutar_sql(base64_encode($sql));
  14. $cel=$cn->resultado_sql();
  15. }
  16. ?>
  17. <script type="text/javascript">
  18. $(document).ready(function(){
  19. $("#cod_gal").autocomplete({
  20. source: "sicpri/05_galerias/_buscar_codigo.php",
  21. minLength: 2/*, select: function(event,ui){ $("#id_con").val(ui.item.id); }*/
  22. });
  23. $("#zona").load("sicpri/funciones/getZonas.php",{i:"<?=$cel['id_zon']?>"},function(data){ $(this).selectmenu(); });
  24. $("#edit").click(function(){
  25. var i=$("#id").val();
  26. var nom=$("#tx_nom").val();
  27. var zon=$("#zona").val();
  28. var dir=$("#tx_dir").val();
  29. if(nom.length<1){ alert("Complete el campo Nombres."); $("#tx_nom").focus(); }
  30. else if(zon=="nn"){ alert("Asigne una zona a la galeria."); $("#zona").focus(); }
  31. else{
  32. $.post("sicpri/05_galerias/dao.php",{opt:"u", i:i, nom:nom, dir:dir, zon:zon},function(data){
  33. if(data==1){
  34. alert("Galeria modificada correctamente.");
  35. $.post("sicpri/05_galerias/06_historial.php",function(data){
  36. $("#contenido_sicpri").html(data);
  37. $("#sicpri_tit").empty().text("HISTORIAL DE GALERIAS");
  38. });
  39. }else{
  40. alert("Vuelva a intentarlo por favor.");
  41. }
  42. });
  43. }
  44. });
  45. $("#find").click(function(){
  46. var c=$("#cod_gal").val();
  47. if(c!=""){
  48. $.post("sicpri/05_galerias/02_modificar.php",{c:c},function(data){
  49. $("#contenido_sicpri").html(data);
  50. $("#sicpri_tit").empty().text("MODIFICAR GALERIA");
  51. });
  52. }else{ alert("Ingrese el codigo de zona a modificar."); $("#cod_gal").focus(); }
  53. });
  54. $("#hist").click(function(){
  55. $.post("sicpri/05_galerias/06_historial.php",function(data){
  56. $("#contenido_sicpri").html(data);
  57. $("#sicpri_tit").empty().text("HISTORIAL DE GALERIAS");
  58. });
  59. });
  60. });
  61. </script>
  62. <input type="hidden" id="id" value="<?=$cel['id_gal']?>" />
  63. <table width="100%" border="0" id="tbl_prp">
  64. <?php if(!isset($id) && !isset($cod)){?>
  65. <tr>
  66. <td colspan="2">
  67. <table width="100%" border="0" id="tbl_find">
  68. <tr>
  69. <td width="25%"><strong>Buscar zona:</strong></td>
  70. <td width="25%">&nbsp;</td>
  71. <td width="25%">&nbsp;</td>
  72. <td width="25%">&nbsp;</td>
  73. </tr>
  74. <tr>
  75. <td align="left" valign="top">
  76. C&oacute;digo de Galeria:<br />
  77. <input type="text" id="cod_gal" /><br />
  78. <button id="find" class="btn"><span class="ui-icon ui-icon-search"></span>Buscar galeria</button>
  79. </td>
  80. <td align="left" valign="top">
  81. </td>
  82. <td align="left" valign="top">
  83. </td>
  84. <td align="left" valign="top">
  85. </td>
  86. </tr>
  87. </table>
  88. </td>
  89. </tr>
  90. <?php }?>
  91. <tr>
  92. <td colspan="2">
  93. <table width="100%" border="0">
  94. <tr>
  95. <td width="25%"><strong>Datos de la galeria</strong></td>
  96. <td width="25%">&nbsp;</td>
  97. <td width="25%">&nbsp;</td>
  98. <td width="25%">&nbsp;</td>
  99. </tr>
  100. <tr>
  101. <td align="left" valign="top">
  102. Nombre<br/><input type="text" id="tx_nom" value="<?=$cel['nom_gal']?>" /><br/>
  103. Zona:<br /><select id="zona" ></select><br />
  104. Direcci&oacute;n<br/><input type="text" id="tx_dir" value="<?=$cel['dir_gal']?>"/><br/>
  105. </td>
  106. <td align="left" valign="top">&nbsp;</td>
  107. <td align="left" valign="top">&nbsp;</td>
  108. <td align="left" valign="top">&nbsp;</td>
  109. </tr>
  110. </table>
  111. </td>
  112. </tr>
  113. <tr>
  114. <td>
  115. </td>
  116. </tr>
  117. <tr>
  118. <td>
  119. <?php if(isset($id) || isset($cod)){ if(!isset($ver)){?>
  120. <button id="edit" class="btn"><span class="ui-icon ui-icon-disk"></span>Modificar galeria</button>
  121. <?php }}?>
  122. <button id="hist" class="btn"><span class="ui-icon ui-icon-folder-open"></span>Historial de galeria</button>
  123. </td>
  124. </tr>
  125. </table>