$sql0 = "select proveedor, total, conceptolargo, fechafactura
from flujo
where year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result0 = mysql_query ($sql0);
$sql = "select proveedor, total, conceptolargo, fechafactura
from flujo
where month(fechafactura) = '".$mes."' and year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result = mysql_query ($sql);
$row = mysql_fetch_row($result);
///////////////////////////////////////////////////
$sql1 = "select proveedor, total, conceptolargo, fechafactura
from flujo
where month(fechafactura) = '01' and year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result1 = mysql_query ($sql1);
$row1 = mysql_fetch_row($result1);
///////////////////////////////////////////////
$sql2 = "select proveedor, total, conceptolargo, fechafactura
from flujo
where month(fechafactura) = '02' and year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result2 = mysql_query ($sql2);
///////////////////////////////////////////////
$sql3 = "select proveedor, total, conceptolargo, fechafactura
from flujo
where month(fechafactura) = '03' and year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result3 = mysql_query ($sql3);
////////////////////////////////////////////////
if (! $result){ echo "La consulta SQL contiene errores.".mysql_error();
exit();
}else { echo "<table id='EXPORTA_EXCEL'>
<tr bgcolor='#cccccc' align='center' id='enc'>
<th><strong>PROVEEDOR</strong></th>";
if ($mes = 1) { echo"<th><strong>ENERO</strong></th>";
}
else{ echo"<th hidden='hidden'><strong>ENERO</strong></th>";
}
echo"<th><strong>FEBRERO</strong></th>";
echo"<th><strong>MARZO</strong></th>
<th><strong>CONCEPTO</strong></td>
<th><strong>FECHA</strong></td>
</tr>";
while ($row0 = mysql_fetch_row($result0)){
for ($mes = 1; $mes < 13; $mes++) {
$sql1 = "select proveedor, total, conceptolargo, fechafactura
from flujo
where month(fechafactura) = '01' and year(fechafactura) = '2020' and categoria = 'FABRICACION' and fechaflujo is NULL";
$result1 = mysql_query ($sql1);
if($mes == 1){ while ($row1 = mysql_fetch_row($result1)){ echo "<tr><td>".$row1[0]."</td><td>".$row1[1]."</td><td></td><td></td><td>".$row1[2]."</td><td>".$row1[3]."</td></tr>";
}
}
else { "ok";
}
if($mes == 2){
while ($row2 = mysql_fetch_row($result2)){ echo "<tr><td>".$row2[0]."</td><td></td><td>".$row2[1]."</td><td></td><td>".$row2[2]."</td><td>".$row2[3]."</td></tr>";
}
}
else { "ok";
}
if($mes == 3){
while ($row3 = mysql_fetch_row($result3)){ echo "<tr><td>".$row3[0]."</td><td></td><td></td><td>".$row3[1]."</td><td>".$row3[2]."</td><td>".$row3[3]."</td></tr>";
}
}
else { "ok";
}
}
echo "</table>";
}
}
?>
