select 
k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL as Total_FC, Sum(ifnull(f.total, 0)) as Total_RC, h.PAGO
FROM
enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido
inner join MOV_CLIENTES m on p.id = m.Id
inner join FECHAS_VENTAS h on m.Id = h.Id
left join enlaces_factura f on p.id = f.Id_factura
WHERE
p.doc < 4 and k.id_pack = '338'
GROUP BY
k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO

**********************************************************************************************************
select 
k.id_pack, c.FECHA , c.NUMSUC, c.NUMDOC , m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL as Total_FC, Sum(ifnull(f.total, 0)) AS Total_RC, h.PAGO, t.pedido, t.E1 , t.fc , t.E5 
FROM
enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido
inner join DOC_PEDIDOS c on p.Id_pedido = c.Id 
inner join MOV_CLIENTES m on p.id = m.Id
inner join FECHAS_VENTAS h on m.Id = h.Id
inner join doc_pedidos_totales t on p.Id_pedido = t.id_pedido 
left join enlaces_factura f on p.id = f.Id_factura
WHERE
p.doc < 4 and k.id_pack = '338'
GROUP BY k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO

*********************************************************************************************************
select 
k.id_pack, sum(pedido-E1), sum(pedido-E5), sum(pedido-fc), pago
FROM
enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido
inner join FECHAS_VENTAS h on m.Id = h.Id
inner join doc_pedidos_totales t on p.Id_pedido = t.id_pedido 
WHERE
p.doc < 4 and k.id_pack = '338'
GROUP BY k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO

*********************************************************************************************************
select 
k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.pedido-t.E5) as entrega, sum(t.pedido-t.fc) as factura
FROM 
enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido 
where k.id_pack = '338'
group by k.id_pack 

*********************************************************************************************************
select 
k.id_pack, sum(t.E0)/sum(t.pedido)*100 as nulo, sum(t.pedido) as pedido, sum(t.E1)/(sum(t.pedido)-sum(t.E0))*100 as recepcion, sum(t.E5)/(sum(t.pedido)-sum(t.E0))*100 as entrega, sum(t.fc)/(sum(t.pedido)-sum(t.E0))*100 as factura
FROM 
enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido 
where k.id_pack = '338'
group by k.id_pack 

*********************************************************************************************************
select 
k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.E5) as entrega, sum(t.fc) as factura
FROM 
enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido 
where k.id_pack = '338'
group by k.id_pack 

*********************************************************************************************************


select 
k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.E5) as entrega, sum(t.fc) as factura, Sum(ifnull(f.total, 0)) AS Total_RC
FROM 
enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido
INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido
left join enlaces_factura f on p.id = f.Id_factura 
where k.id_pack = '338' and p.doc < 4
group by k.id_pack 
*********************************************************************************************************

BEGIN
UPDATE doc_pedidos_totales SET fc_importe = fc_importe + NEW.total_final where id_pedido = NEW.id_doc_p and NEW.CANTIDAD > 0;
UPDA


select 
k.id_pack, sum(p.cantidad*p.precio*(1+p.tasa_iva)) as pedido, sum(p.cantidad*p.precio*(1+p.tasa_iva)) as pedido
FROM 
enlaces_pack k INNER JOIN PEDID_PARAM_ARTICULOS p on k.id_pedido = p.id_doc
inner join ETAPAS_TRZ_MOVIMIENTOS m on p.id = m.id_art
where k.id_pack = '338'
group by k.id_pack 


65866.0475




select 
p.Id_pedido, v.fecha, v.numsuc, v.numdoc, v.TOTAL_FINAL, f.doc 
from 
enlaces_pedido p inner join DOC_VENTAS v on p.id = v.id 
LEFT join enlaces_factura f on v.id = f.id_factura 
where 
p.doc < 4 and f.doc > 17 and ISNULL(f.DOC)