PageRenderTime 66ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/sicpri/01_cobranzas/08_reportes_hoy.php

https://bitbucket.org/webdev_pe/dmejiasoft
PHP | 200 lines | 187 code | 5 blank | 8 comment | 12 complexity | d2f137be582439f905fbfc535cf76375 MD5 | raw file
    

  1. <?php
    2. 

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

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

  4. $cod=$_POST['cod']; $cdc=$_POST['cdc']; $nom=$_POST['nom']; 
    5. 

  5. $dsd=($_POST['dsd']!="")?date("Y-m-d",strtotime($_POST['dsd'])):"";
    6. 

  6. $hst=($_POST['hst']!="")?date("Y-m-d",strtotime($_POST['hst'])):"";
    7. 

  7. $tip=$_POST['tip']; $opr=$_POST['opr']; $otx=$_POST['otx'];
    8. 

  8. $zon=$_POST['zon']; $gal=$_POST['gal']; $ztx=$_POST['ztx']; $gtx=$_POST['gtx'];
    9. 

  9. 

  10. if($cod!=""){	$add_search=" and cod_pre='$cod' "; 
    11. 

  11. }else{
    12. 

  12. 	$add_search =($cdc!="")?" cod_cli='$cdc' and ":"";
    13. 

  13. 	$add_search.=($nom!="")?" concat(l.nom_cli,' ',l.ape_cli) like '%$nom%' and ":"";
    14. 

  14. 	$add_search.=($dsd!="" && $hst=="")?" c.fecha >= '$dsd' and ":"";
    15. 

  15. 	$add_search.=($dsd=="" && $hst!="")?" c.fecha <= '$hst' and ":"";
    16. 

  16. 	$add_search.=($dsd!="" && $hst!="")?" c.fecha between '$dsd' and '$hst' and ":"";	
    17. 

  17. 	$add_search.=($tip!="t" && $tip!="")?" tip_pre='$tip' and ":"";
    18. 

  18. 	$add_search.=($opr!="nn" && $opr!="")?" p.id_usu=$opr and ":"";
    19. 

  19. 	$add_search.=($zon!="nn" && $zon!="")?" l.id_zon=$zon and ":"";	
    20. 

  20. 	$add_search.=($gal!="nn" && $gal!="")?" l.id_gal=$gal and ":"";	
    21. 

  21. 	$add_search=($add_search!="")?" and ".$add_search:"";	
    22. 

  22. 	$lenght=strlen($add_search);
    23. 

  23. 	$add_search=substr($add_search,0,($lenght-4));
    24. 

  24. }
    25. 

  25. 

  26. /*$sql="select id_cob, c.id_cob, mnt_cob, dias, adicional, interes, date_format(c.fecha,'%d.%m-%Y') as 'fecha', cierre,
    27. 

  27. p.cod_pre, l.cod_cli, concat(l.nom_cli,' ',l.ape_cli) as 'nombres', p.tip_pre
    28. 

  28. from si_cobranzas c, si_prestamos p, si_clientes l
    29. 

  29. where c.id_pre=p.id_pre and p.id_cli=l.id_cli ".$add_search." order by id_cob desc";*/
    30. 

  30. $sql="
    31. 

  31. select c.id_cob, p.id_pre, p.tip_pre, p.mnt_pre, p.fra_pre, mnt_cob,
    32. 

  32. p.dia_pre, p.int_pre, ((p.mnt_pre*p.int_pre)+p.mnt_pre)-mnt_cob as 'saldo_porcetaje', 
    33. 

  33. p.mnt_pre+(select sum(agregar) from si_cobranzas where id_pre=p.id_pre)-
    34. 

  34. (select sum(mnt_cob) from si_cobranzas where id_pre=p.id_pre) as 'capital_cobrar',
    35. 

  35. (select sum(real_int) from si_cobranzas where id_pre=p.id_pre and estado='1' and cierre!='pa')-
    36. 

  36. (select sum(interes) from si_cobranzas where id_pre=p.id_pre and estado='1' and cierre!='pa') as 'interes_cobrar',
    37. 

  37. dias, adicional, interes, 
    38. 

  38. date_format(c.fecha,'%d-%m-%Y') as 'fecha', cierre,
    39. 

  39. p.cod_pre, l.cod_cli, concat(l.nom_cli,' ',l.ape_cli) as 'nombres', agregar, dscto, z.nom_zon, g.nom_gal
    40. 

  40. from si_cobranzas c, si_prestamos p, si_clientes l, si_zonas z, si_galerias g
    41. 

  41. where c.id_pre=p.id_pre and p.id_cli=l.id_cli and l.id_zon=z.id_zon and l.id_gal=g.id_gal and c.fecha=curdate() and c.estado='1' ".$add_search." 
    42. 

  42. order by id_cob desc
    43. 

  43. ";
    44. 

  44. $cn->ejecutar_sql(base64_encode($sql));
    45. 

  45. $cn->cantidad_sql();
    46. 

  46. 

  47. #echo $sql;
    48. 

  48. ?>
    49. 

  49. <script type="text/javascript">
    50. 

  50. $(document).ready(function(){
    51. 

  51. 	$('#list_cob_filter').dataTable({
    52. 

  52.       /*"bProcessing": true,
    53. 

  53.       "bServerSide": true,
    54. 

  54.       "sAjaxSource": "content/scripts/propiedades.php",*/
    55. 

  55. 	  'bJQueryUI': true,
    56. 

  56. 	  'sPaginationType': 'full_numbers',	  
    57. 

  57. 	  'fnDrawCallback': function(oSettings){
    58. 

  58. 		  if(oSettings.bSorted || oSettings.bFiltered){
    59. 

  59. 			  for(var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++){
    60. 

  60. 				  $('td:eq(0)', oSettings.aoData[oSettings.aiDisplay[i]].nTr).html(i+1);
    61. 

  61. 			  }
    62. 

  62. 		  }
    63. 

  63. 	  },'aoColumnDefs': []
    64. 

  64. 	  ,"bAutoWidth" : false,	  
    65. 

  65. 	  "bSortClasses": false, 
    66. 

  66. 	  "aoColumns" : [
    67. 

  67. 		  { sWidth : '18px'},
    68. 

  68. 		  { sWidth : '70px'},
    69. 

  69. 		  { sWidth : '80px'},	  
    70. 

  70. 		  { sWidth : '70px'},
    71. 

  71. 		  { sWidth : 'auto'},	  
    72. 

  72. 		  { sWidth : '70px'},
    73. 

  73. 		  { sWidth : '90px'},
    74. 

  74. 		  { sWidth : '90px'},	  
    75. 

  75. 		  { sWidth : '90px'},		  		  	  	  		  	  
    76. 

  76. 		  { sWidth : '90px'},		  		  	  	  
    77. 

  77. 		  { sWidth : '90px'},
    78. 

  78. 		  { sWidth : '90px'},	
    79. 

  79. 		  { sWidth : '90px'},		  	  
    80. 

  80. 		  { sWidth : '90px'},		  	  
    81. 

  81. 		  { sWidth : '90px'}
    82. 

  82. 	  ],'aaSorting': [[0, 'asc']]
    83. 

  83. 	});
    84. 

  84. 	
    85. 

  85. 	$("#rept").click(function(){
    86. 

  86. 	  var s=$("#s").val();
    87. 

  87. 	  var new_tab=window.open("","_blank");		
    88. 

  88. 	 	<?php
    89. 

  89. $cod=$_POST['cod']; $cdc=$_POST['cdc']; $nom=$_POST['nom']; 
    90. 

  90. $dsd=($_POST['dsd']!="")?date("Y-m-d",strtotime($_POST['dsd'])):"";
    91. 

  91. $hst=($_POST['hst']!="")?date("Y-m-d",strtotime($_POST['hst'])):"";
    92. 

  92. $tip=$_POST['tip']; $opr=$_POST['opr']; $otx=$_POST['otx'];		
    93. 

  93. 		?>
    94. 

  94. 	  new_tab.location="sicpri/01_cobranzas/reporte.php?s="+s+"&cp=<?=base64_encode($cod)?>&cc=<?=base64_encode($cdc)?>&nc=<?=base64_encode($nom)?>&fd=<?=base64_encode($dsd)?>&fh=<?=base64_encode($hst)?>&tp=<?=base64_encode($tip)?>&op=<?=base64_encode($otx)?>&zn=<?=base64_encode($ztx)?>&gl=<?=base64_encode($gtx)?>";
    95. 

  95. 	});
    96. 

  96. });	
    97. 

  97. </script>
    98. 

  98. <style type="text/css">
    99. 

  99. .cobro{ background:#acdd4a; color:#ffffff;}
    100. 

  100. .saldo{ background:#ffe87b; color:#116194;}
    101. 

  101. </style>	
    102. 

  102.     <input type="hidden" id="i" value="" />
    103. 

  103. 	<input type="hidden" id="s" value="<?=base64_encode(utf8_encode($sql))?>" />
    104. 

  104. 	<button id="rept" class="btn"><span class="ui-icon ui-icon-clipboard"></span>Generar previo de resultados</button>
    105. 

  105. 	<table id="list_cob_filter" class="list_tbl" width="100%">
    106. 

  106. 	<thead>
    107. 

  107.         <tr>    
    108. 

  108. 	        <th rowspan="2">N&ordm;</th>
    109. 

  109. 	        <th rowspan="2">FECHA</th>    
    110. 

  110. 	        <th rowspan="2">PR&Eacute;STAMO</th>
    111. 

  111. 	        <th rowspan="2">CLIENTE</th>
    112. 

  112. 	        <th rowspan="2">NOMBRE DEL CLIENTE</th>
    113. 

  113. 	        <th rowspan="2">TIPO</th>
    114. 

  114. 	        <th class="ui-state-default">PORCENTAJE</th>
    115. 

  115.             <th class="ui-state-default">PORCENTAJE</th>
    116. 

  116.             <th colspan="2" class="ui-state-default">PAGO ARREBATIR</th>
    117. 

  117.             <th colspan="2" class="ui-state-default">SALDO POR COBRAR</th>            
    118. 

  118.             <th rowspan="2">DESCUENTO</th>
    119. 

  119.             <th rowspan="2">PR&Eacute;STAMO AGREGADO</th>
    120. 

  120.             <th rowspan="2">TOTAL</th>
    121. 

  121.         </tr>   
    122. 

  122.         <tr>    
    123. 

  123.         	<th>CUOTA</th>
    124. 

  124. 	        <th>SALDO</th>
    125. 

  125.             <th>CAPITAL</th>
    126. 

  126.             <th>INTER&Eacute;S</th>
    127. 

  127.             <th>CAPITAL</th>
    128. 

  128.             <th>INTER&Eacute;S</th>            
    129. 

  129.         </tr>           
    130. 

  130. 	</thead>
    131. 

  131. 	<tbody>
    132. 

  132.     <?php
    133. 

  133. 	$cn_c=new getConection();
    134. 

  134.     while($cell=$cn->resultado_sql()){	
    135. 

  135. 	?>
    136. 

  136.       <tr>    
    137. 

  137.         <td align="center"></td>
    138. 

  138.         <td align="center"><?=$cell['fecha']?></td>
    139. 

  139.         
    140. 

  140.         <td align="center"><?=$cell['cod_pre']?></td>    
    141. 

  141.         <td align="center"><?=$cell['cod_cli']?></td>
    142. 

  142.         <td align="left"><?=$cell['nombres']?> - (<?=$cell['nom_zon']?>-<?=$cell['nom_gal']?>)</td>
    143. 

  143.         <td align="center"><?=(($cell['tip_pre']=='p')?"Porcentaje":"Arrebatir")?></td>
    144. 

  144.         <?php 
    145. 

  145. 		if($cell['tip_pre']=='p'){
    146. 

  146. 		$total=$cell['mnt_cob'];
    147. 

  147. 		$acum1+=$total;
    148. 

  148. 		$acum9+=$cell['saldo_porcetaje'];
    149. 

  149. 		?>
    150. 

  150.         <td align="right" class="cobro"><span>S/.</span><?=number_format($cell['mnt_cob'],2,'.',',')?></td>
    151. 

  151.         <td align="right" class="saldo"><span>S/.</span><?=number_format($cell['saldo_porcetaje'],2,'.',',')?></td>
    152. 

  152.         <td align="right" class="cobro">---</td>
    153. 

  153.         <td align="right" class="cobro">---</td>        
    154. 

  154.         <td align="right" class="saldo">---</td>
    155. 

  155.         <td align="right" class="saldo">---</td>        
    156. 

  156.         <?php
    157. 

  157. 		}else{
    158. 

  158. 		$total=$cell['mnt_cob']+$cell['interes']-$cell['dscto'];
    159. 

  159. 		$acum2+=$cell['mnt_cob'];
    160. 

  160. 		$acum3+=$cell['interes'];
    161. 

  161. 		?>
    162. 

  162.         <td align="right" class="cobro">---</td>
    163. 

  163.         <td align="right" class="saldo">---</td>
    164. 

  164.         <td align="right" class="cobro"><span>S/.</span><?=number_format($cell['mnt_cob'],2,'.',',')?></td>
    165. 

  165.         <td align="right" class="cobro"><span>S/.</span><?=number_format($cell['interes'],2,'.',',')?></td>  
    166. 

  166.         <td align="right" class="saldo"><span>S/.</span><?=number_format(($cell['capital_cobrar']>0?$cell['capital_cobrar']:0),2,'.',',')?></td>
    167. 

  167.         <td align="right" class="saldo"><span>S/.</span><?=number_format(($cell['interes_cobrar']>0?$cell['interes_cobrar']:0),2,'.',',')?></td>                 
    168. 

  168. 		<?php
    169. 

  169. 		$acum7+=$cell['capital_cobrar']>0?$cell['capital_cobrar']:0;
    170. 

  170. 		$acum8+=$cell['interes_cobrar']>0?$cell['interes_cobrar']:0;		
    171. 

  171. 		}
    172. 

  172. 		$acum5+=$cell['agregar'];
    173. 

  173. 		$acum6+=$cell['dscto'];
    174. 

  174. 		?>
    175. 

  175.         <td align="right"><span>S/.</span><?=number_format($cell['dscto'],2,'.',',')?></td>
    176. 

  176.         <td align="right"><span>S/.</span><?=number_format($cell['agregar'],2,'.',',')?></td>
    177. 

  177.         <td align="right" class="cobro"><span>S/.</span><?=number_format($total,2,'.',',')?></td>
    178. 

  178.       </tr>
    179. 

  179.     <?php	
    180. 

  180. 	}
    181. 

  181. 	$cn->limpiar_sql();
    182. 

  182. 	$cn->cerrar_sql();
    183. 

  183. 	$acum4=$acum1+$acum2+$acum3-$acum6;
    184. 

  184.     ?>   
    185. 

  185.     </tbody>
    186. 

  186. 	<tfoot>    
    187. 

  187.         <tr bgcolor="#ededed">    
    188. 

  188. 	        <td colspan="6" align="center" style="color:#116194; font-weight:bold;">TOTALES</td>
    189. 

  189. 	        <td align="right" class="cobro" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum1,2,'.',',')?></td>
    190. 

  190.             <td align="right" class="saldo" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum9,2,'.',',')?></td>
    191. 

  191.             <td align="right" class="cobro" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum2,2,'.',',')?></td>                
    192. 

  192.             <td align="right" class="cobro" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum3,2,'.',',')?></td>
    193. 

  193. 			<td align="right" bgcolor="#ffe87b" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum7,2,'.',',')?></td>
    194. 

  194.             <td align="right" bgcolor="#ffe87b" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum8,2,'.',',')?></td>
    195. 

  195. 			<td align="right" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum6,2,'.',',')?></td>            
    196. 

  196. 			<td align="right" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum5,2,'.',',')?></td>
    197. 

  197.             <td align="right" class="cobro" style="color:#116194; font-weight:bold;"><span>S/.</span><?=number_format($acum4,2,'.',',')?></td>
    198. 

  198.         </tr>      
    199. 

  199. 	</tfoot>    
    200. 

  200.     </table>
    201.