/reportes_sistema/reporte_categoria_marcas.php

https://gitlab.com/Oskrin/inventario · PHP · 137 lines · 129 code · 7 blank · 1 comment · 8 complexity · 69bf41e3ad759bc1c9354b5e45b3501d MD5 · raw file 

    

  1. <?php
    2. 

  2. require('../reportes/dompdf/dompdf_config.inc.php');
    3. 

  3. session_start();
    4. 

  4.     $codigo='<html> 
    5. 

  5.     <head> 
    6. 

  6.         <link rel="stylesheet" href="../css/estilosAgrupados.css" type="text/css" /> 
    7. 

  7.     </head> 
    8. 

  8.     <body>
    9. 

  9.         <header>
    10. 

  10.             <img src="../images/logo_empresa.jpg" />
    11. 

  11.             <div id="me">
    12. 

  12.                 <h2 style="text-align:center;border:solid 0px;width:100%;">'.$_SESSION['empresa'].'</h2>
    13. 

  13.                 <h4 style="text-align:center;border:solid 0px;width:100%;">'.$_SESSION['slogan'].'</h4>
    14. 

  14.                 <h4 style="text-align:center;border:solid 0px;width:100%;">'.$_SESSION['propietario'].'</h4>
    15. 

  15.                 <h4 style="text-align:center;border:solid 0px;width:100%;">'.$_SESSION['direccion'].'</h4>
    16. 

  16.                 <h4 style="text-align:center;border:solid 0px;width:100%;">Telf: '.$_SESSION['telefono'].' Cel:  '.$_SESSION['celular'].' '.$_SESSION['pais_ciudad'].'</h4>
    17. 

  17.             </div>        
    18. 

  18.     </header>        
    19. 

  19.     <hr>
    20. 

  20.     <div id="linea">
    21. 

  21.         <h3>LISTA DE PRODUCTOS POR CATEGORÍAS Y MARCAS</h3>
    22. 

  22.     </div>';
    23. 

  23.     include '../procesos/base.php';
    24. 

  24.     conectarse();    
    25. 

  25.     $total=0;
    26. 

  26.     $repetido=0;   
    27. 

  27.     $codigo.='<div id="cuerpo">';
    28. 

  28.     
    29. 

  29.     if($_GET['marca']=="" && $_GET['categoria']==""){
    30. 

  30.          $codigo.='<h2 style="font-weight: bold;font-size:12px;padding:5;margin:0px;border:solid 1px #000;color:blue;background:beige">MARCA: '."Todas".'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CATEGORÍA: '."Todas".'</h2><br />'; 
    31. 

  31.         $codigo.='<table border=0>';
    32. 

  32.          $codigo.='<tr style="font-weight:bold;">                
    33. 

  33.         <td style="width:200px;text-align:center;">Código</td>
    34. 

  34.         <td style="width:200px;text-align:center;">Producto</td>
    35. 

  35.         <td style="width:100px;text-align:center;">Precio Minorista</td>
    36. 

  36.         <td style="width:100px;text-align:center;">Precio Mayorista</td>
    37. 

  37.         <td style="width:100px;text-align:center;">Stock</td>
    38. 

  38.         </tr>
    39. 

  39.         <tr><td colspan=5><hr></td></tr>';
    40. 

  40.         $sql=pg_query("select codigo,cod_barras,articulo,iva_minorista,iva_mayorista,stock,categoria,marca from productos ");
    41. 

  41.         while($row=pg_fetch_row($sql)){
    42. 

  42.             $codigo.='<tr>                
    43. 

  43.             <td style="width:200px;text-align:center;">'.$row[0].'</td>    
    44. 

  44.             <td style="width:200px;text-align:center;">'.$row[2].'</td>
    45. 

  45.             <td style="width:100px;text-align:center;">'.$row[3].'</td>
    46. 

  46.             <td style="width:100px;text-align:center;">'.$row[4].'</td>
    47. 

  47.             <td style="width:100px;text-align:center;">'.$row[5].'</td>
    48. 

  48.             </tr>';
    49. 

  49.         }
    50. 

  50.         $codigo.='</table>';   
    51. 

  51.     }    
    52. 

  52.     if($_GET['marca']=="" && $_GET['categoria']!=""){
    53. 

  53.          $codigo.='<h2 style="font-weight: bold;font-size:12px;padding:5;margin:0px;border:solid 1px #000;color:blue;background:beige">MARCA: '."Todas".'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CATEGORÍA: '.$_GET['categoria'].'</h2><br />';  
    54. 

  54.          $codigo.='<table border=0>';
    55. 

  55.         $codigo.='<tr style="font-weight:bold;">                
    56. 

  56.         <td style="width:200px;text-align:center;">Código</td>
    57. 

  57.         <td style="width:200px;text-align:center;">Producto</td>
    58. 

  58.         <td style="width:100px;text-align:center;">Precio Minorista</td>
    59. 

  59.         <td style="width:100px;text-align:center;">Precio Mayorista</td>
    60. 

  60.         <td style="width:100px;text-align:center;">Stock</td>
    61. 

  61.         </tr>
    62. 

  62.         <tr><td colspan=5><hr></td></tr>';
    63. 

  63.          $sql=pg_query("select codigo,cod_barras,articulo,iva_minorista,iva_mayorista,stock,categoria,marca from productos where categoria='$_GET[categoria]'");
    64. 

  64.          while($row=pg_fetch_row($sql)){
    65. 

  65.             $codigo.='<tr>                
    66. 

  66.             <td style="width:200px;text-align:center;">'.$row[0].'</td>    
    67. 

  67.             <td style="width:200px;text-align:center;">'.$row[2].'</td>
    68. 

  68.             <td style="width:100px;text-align:center;">'.$row[3].'</td>
    69. 

  69.             <td style="width:100px;text-align:center;">'.$row[4].'</td>
    70. 

  70.             <td style="width:100px;text-align:center;">'.$row[5].'</td>
    71. 

  71.             </tr>';
    72. 

  72.          }
    73. 

  73.         $codigo.='</table>';  
    74. 

  74. 

  75.     }
    76. 

  76.     if($_GET['marca']!="" && $_GET['categoria']==""){
    77. 

  77.          $codigo.='<h2 style="font-weight: bold;font-size:12px;padding:5;margin:0px;border:solid 1px #000;color:blue;background:beige">MARCA: '.$_GET['marca'].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CATEGORÍA: '."Todas".'</h2><br />';    
    78. 

  78.          $codigo.='<table border=0>';
    79. 

  79.         $codigo.='<tr style="font-weight:bold;">                
    80. 

  80.         <td style="width:200px;text-align:center;">Código</td>
    81. 

  81.         <td style="width:200px;text-align:center;">Producto</td>
    82. 

  82.         <td style="width:100px;text-align:center;">Precio Minorista</td>
    83. 

  83.         <td style="width:100px;text-align:center;">Precio Mayorista</td>
    84. 

  84.         <td style="width:100px;text-align:center;">Stock</td>
    85. 

  85.         </tr>
    86. 

  86.         <tr><td colspan=5><hr></td></tr>';
    87. 

  87.          $sql=pg_query("select codigo,cod_barras,articulo,iva_minorista,iva_mayorista,stock,categoria,marca from productos where marca='$_GET[marca]'");
    88. 

  88.          while($row=pg_fetch_row($sql)){
    89. 

  89.             $codigo.='<tr>                
    90. 

  90.             <td style="width:200px;text-align:center;">'.$row[1].'</td>    
    91. 

  91.             <td style="width:200px;text-align:center;">'.$row[2].'</td>
    92. 

  92.             <td style="width:100px;text-align:center;">'.$row[3].'</td>
    93. 

  93.             <td style="width:100px;text-align:center;">'.$row[4].'</td>
    94. 

  94.             <td style="width:100px;text-align:center;">'.$row[5].'</td>
    95. 

  95.             </tr>';
    96. 

  96.          }
    97. 

  97.         $codigo.='</table>';
    98. 

  98.     }
    99. 

  99.     if($_GET['marca']!="" && $_GET['categoria']!=""){
    100. 

  100.          $codigo.='<h2 style="font-weight: bold;font-size:12px;padding:5;margin:0px;border:solid 1px #000;color:blue;background:beige">MARCA: '.$_GET['marca'].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CATEGORÍA: '.$_GET['categoria'].'</h2><br />';    
    101. 

  101.         $codigo.='<table border=0>';
    102. 

  102.         $codigo.='<tr style="font-weight:bold;">                
    103. 

  103.         <td style="width:200px;text-align:center;">Código</td>
    104. 

  104.         <td style="width:200px;text-align:center;">Producto</td>
    105. 

  105.         <td style="width:100px;text-align:center;">Precio Minorista</td>
    106. 

  106.         <td style="width:100px;text-align:center;">Precio Mayorista</td>
    107. 

  107.         <td style="width:100px;text-align:center;">Stock</td>
    108. 

  108.         </tr>
    109. 

  109.         <tr><td colspan=5><hr></td></tr>';
    110. 

  110.          $sql=pg_query("select codigo,cod_barras,articulo,iva_minorista,iva_mayorista,stock,categoria,marca from productos where categoria='$_GET[categoria]' and marca='$_GET[marca]'");
    111. 

  111.          while($row=pg_fetch_row($sql)){
    112. 

  112.             $codigo.='<tr>                
    113. 

  113.             <td style="width:200px;text-align:center;">'.$row[1].'</td>    
    114. 

  114.             <td style="width:200px;text-align:center;">'.$row[2].'</td>
    115. 

  115.             <td style="width:100px;text-align:center;">'.$row[3].'</td>
    116. 

  116.             <td style="width:100px;text-align:center;">'.$row[4].'</td>
    117. 

  117.             <td style="width:100px;text-align:center;">'.$row[5].'</td>
    118. 

  118.             </tr>';
    119. 

  119.          }
    120. 

  120.         $codigo.='</table>';
    121. 

  121.     }
    122. 

  122.     $codigo.='</div>';
    123. 

  123. 

  124.     
    125. 

  125.     
    126. 

  126.     
    127. 

  127.     $codigo.='</body></html>';                           
    128. 

  128.     $codigo=utf8_decode($codigo);
    129. 

  129. 

  130.     $dompdf= new DOMPDF();
    131. 

  131.     $dompdf->load_html($codigo);
    132. 

  132.     ini_set("memory_limit","100M");
    133. 

  133.     $dompdf->set_paper("A4","portrait");
    134. 

  134.     $dompdf->render();
    135. 

  135.     //$dompdf->stream("reporteRegistro.pdf");
    136. 

  136.     $dompdf->stream('reporte_agrupados_prov.pdf',array('Attachment'=>0));
    137. 

  137. ?>
    138.