STOCK MATERIALES POR SECTOR
---------------------------------------------------------------------------
SELECT   
    s.codmat AS codigo, 
    m.DESCRIPCION AS material, 
    s.e120 as stock_central, 
    s.e121 as stock_sec, 
    r.DESCRIPCION AS rubro, 
    'Sector 1' AS grupo 
FROM 
    materiales_stock s 
    INNER JOIN materiales m ON s.codmat = m.codmat
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 21

UNION ALL

SELECT 
    '*' AS codmat, 
    '*' AS descripcion_mat, 
    '*' as stock_central, 
    '*' AS stock, 
    '*' AS rubro, 
    'Sector 11' AS grupo

UNION ALL

SELECT 
    s.codmat as codigo, 
    m.DESCRIPCION as material, 
    s.e120 as stock_central,  
    s.e122 as stock_sec,     
    r.DESCRIPCION as rubro, 
    'sector 2' 
FROM 
    materiales_stock s 
    INNER JOIN materiales m ON s.codmat = m.codmat
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 22

UNION ALL

SELECT 
    '*' AS codmat, 
    '*' AS descripcion_mat, 
    '*' as stock_central, 
    '*' AS stock,  
    '*' AS rubro, 
    'Sector 22' AS grupo

UNION ALL

SELECT 
    s.codmat as codigo, 
    m.DESCRIPCION as material, 
    s.e120 as stock_central, 
    s.e123 as stock_sec, 
    r.DESCRIPCION as rubro, 
    'sector 3' 
FROM 
    materiales_stock s 
    INNER JOIN materiales m ON s.codmat = m.codmat
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 23

ORDER BY 
    grupo,            
    rubro ASC, 
    material ASC;
---------------------------------------------------------------------------

STOCK MATERIALES POR SECTOR agrupados por rubros

SELECT   
    sum(s.e120) as stock_central, 
    sum(s.e121) as stock_sec, 
    r.DESCRIPCION AS rubro, 
    'Sector 1' AS grupo 
FROM 
    materiales_stock s 
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 21
GROUP by rubro, grupo

UNION ALL

SELECT 
    '*' as stock_central, 
    '*' AS stock, 
    '*' AS rubro, 
    'Sector 11' AS grupo

UNION ALL

SELECT 
    sum(s.e120) as stock_central,  
    sum(s.e122) as stock_sec,     
    r.DESCRIPCION as rubro, 
    'sector 2' 
FROM 
    materiales_stock s 
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 22
GROUP by rubro, grupo

UNION ALL

SELECT 
    '*' as stock_central, 
    '*' AS stock,  
    '*' AS rubro, 
    'Sector 22' AS grupo

UNION ALL

SELECT 
    sum(s.e120) as stock_central, 
    sum(s.e123) as stock_sec, 
    r.DESCRIPCION as rubro, 
    'sector 3' 
FROM 
    materiales_stock s 
    INNER JOIN rubros r ON m.CODRUB = r.CODRUB
    INNER JOIN mat_art_formula f ON m.codmat = f.codmat
WHERE 
    f.etapa = 23
GROUP by rubro, grupo

ORDER BY 
    grupo,            
    rubro ASC
---------------------------------------------------------------------------

select d.id, p.codart
from 
doc_etapas_pedid d inner join etapas_param_articulos_cli p on d.id = p.id_doc_etp
where 
d.id_doc_pedid in (9739, 9738, 9736, 9737)
and d.etapa1 = 5 and d.etapa2 = 110
and d.cant_exit = 0

select 
d.id, sum(p.cant_etp), d.id_doc_pedid
from 
doc_etapas_pedid d inner join etapas_param_articulos_cli p on d.id = p.id_doc_etp
where 
d.id_doc_pedid in (9739, 9738, 9736, 9737)
and d.etapa1 = 5 and d.etapa2 = 110
and d.cant_exit = 0  
GROUP by d.id, d.id_doc_pedid
ORDER BY `p`.`codart` ASC
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
select 
d.id, p.codart, p.cant_etp, d.id_doc_pedid
from 
doc_etapas_pedid d inner join etapas_param_articulos_cli p on d.id = p.id_doc_etp
where 
d.id_doc_pedid in (9732, 9733, 9734, 9735)
and d.etapa1 = 110 and d.etapa2 = 21
and d.cant_exit = 0  
ORDER BY `p`.`codart` ASC

select 
d.id, sum(p.cant_etp), d.id_doc_pedid
from 
doc_etapas_pedid d inner join etapas_param_articulos_cli p on d.id = p.id_doc_etp
where 
d.id_doc_pedid in (9732, 9733, 9734, 9735)
and d.etapa1 = 110 and d.etapa2 = 21
and d.cant_exit = 0  
GROUP by d.id, d.id_doc_pedid
ORDER BY `p`.`codart` ASC
---------------------------------------------------------------------------------