PageRenderTime 47ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/movil/paginas/detalle.php

https://bitbucket.org/webdev_pe/dmejiasoft
PHP | 81 lines | 72 code | 9 blank | 0 comment | 1 complexity | 40429cc9f186c4b22d6d4a9316a84870 MD5 | raw file
    

  1. <?php
    2. 

  2. require("../../poo/clases/getConection.php");
    3. 

  3. $cod = $_GET['c'];
    4. 

  4. $cn=new getConection();
    5. 

  5. 

  6. $sql="select p.id_pre, p.cod_pre, p.mnt_pre, p.id_cli, p.tip_pre, p.est_pre
    7. 

  7. from si_clientes c, si_prestamos p 
    8. 

  8. where c.id_cli=p.id_cli and est_pre='a' and
    9. 

  9. cod_cli='".$cod."'";	
    10. 

  10. $cn->ejecutar_sql(base64_encode($sql));
    11. 

  11. ?>       
    12. 

  12. <!DOCTYPE html> 
    13. 

  13. <html class="ui-mobile-rendering"> 
    14. 

  14. 	<head>
    15. 

  15. 	<meta charset="utf-8">
    16. 

  16. 	<meta name="viewport" content="width=device-width, initial-scale=1"> 
    17. 

  17. 	<title>SIPC - PR&Eacute;STAMOS/COBRANZAS</title> 
    18. 

  18. 	<link rel="stylesheet"  href="../jquery_mobile/css/themes/default/jquery.mobile.css" /> 
    19. 

  19. 	<link rel="stylesheet" href="../jquery_mobile/docs/_assets/css/jqm-docs.css"/>
    20. 

  20. 

  21. 	<script data-main="../jquery_mobile/js/jquery.mobile.docs" src="../jquery_mobile/external/requirejs/require.js"></script>
    22. 

  22. 	<script src="../jquery_mobile/js/jquery.js"></script>
    23. 

  23. </head> 
    24. 

  24. <body> 
    25. 

  25. <div data-role="page" class="type-interior">
    26. 

  26. 

  27. 	<div data-role="header" data-theme="f">
    28. 

  28. 		<h1>Detalle de pr&eacute;stamos</h1>
    29. 

  29. 		<a href="../index.php" data-icon="home" data-iconpos="notext" data-direction="reverse" class="ui-btn-right jqm-home">Inicio</a>
    30. 

  30. 	</div><!-- /header -->
    31. 

  31. 

  32. 	<div data-role="content">		
    33. 

  33. 		<div class="content-primary">
    34. 

  34. 		<?php
    35. 

  35.         $cn2=new getConection();
    36. 

  36. 		$sql2="select concat(nom_cli,' ',ape_cli) as 'nombres' from si_clientes where cod_cli='".$cod."'";
    37. 

  37. 		$cn2->ejecutar_sql(base64_encode($sql2));
    38. 

  38. 		$cel2=$cn2->resultado_sql();
    39. 

  39. 		?>
    40. 

  40.         <strong>CLIENTE:</strong> <?=strtoupper($cel2['nombres'])?><br/>
    41. 

  41. 		<strong>C&Oacute;DIGO:</strong> <?=strtoupper($cod)?><hr/>
    42. 

  42.         <br/>
    43. 

  43.         <a href="prestamo.php?c=<?=$cod?>" data-role='button' data-icon='plus' data-iconpos='top' data-theme='b'>NUEVO CR&Eacute;DITO PARA <?=strtoupper($cod)?></a>
    44. 

  44. 		<br/>
    45. 

  45. 		<?php
    46. 

  46.             while($cel=$cn->resultado_sql()){
    47. 

  47. 				$p=($cel['tip_pre']=="p")?"C/MES":"C/D&Iacute;A";
    48. 

  48. 				$m=($cel['moroso']=="m")?"MOROSO":"";		
    49. 

  49. 				$idp=$cel['id_pre'];
    50. 

  50. 				if($cel['tip_pre']=="p"){
    51. 

  51. 					$detalle_cobranza="porcentual.php?i=$idp&c=$cod";
    52. 

  52. 					$formulario_cobro="formulario.php?i=$idp&c=$cod&p=".$cel['tip_pre'];
    53. 

  53. 				}else{
    54. 

  54. 					$detalle_cobranza="arrebatir.php?i=$idp&c=$cod";
    55. 

  55. 					$formulario_cobro="formulario.php?i=$idp&c=$cod&p=".$cel['tip_pre'];				
    56. 

  56. 				}
    57. 

  57. 			
    58. 

  58.                 $buttons.="
    59. 

  59.                 <a href='$formulario_cobro' data-role='button' data-icon='grid' data-iconpos='top' data-theme='a'>".$cel['cod_pre']." (".number_format($cel['mnt_pre'],2,'.',',').") - $p $m</a>
    60. 

  60.                 <a href='$detalle_cobranza' data-role='button' data-icon='search' data-iconpos='left' data-theme='b'>Ver detalle</a>				
    61. 

  61. 				<hr/>
    62. 

  62.                 ";
    63. 

  63.             }
    64. 

  64. 			echo $buttons;
    65. 

  65.         ?><br/>
    66. 

  66. 		</div>
    67. 

  67.         
    68. 

  68.         <div class="content-secondary">
    69. 

  69. 		<a href="modulos.php?c=<?=$cod?>" data-role='button' data-icon='arrow-l' data-iconpos='left' data-theme='a'>Regresar</a>
    70. 

  70.         </div>
    71. 

  71. 		</div><!-- /content -->
    72. 

  72. 

  73.         <div data-role="footer" class="footer-docs" data-theme="c">
    74. 

  74.                 <p>&copy; <?=date("Y")?> SIPC: Sistema Integral de Pr&eacute;stamos y Cobranzas</p>
    75. 

  75.         </div>
    76. 

  76. 	</div><!-- /content -->
    77. 

  77. 	
    78. 

  78. </div><!-- /page -->
    79. 

  79. 

  80. </body>
    81. 

  81. </html>
    82.