SELECT 	CFGV.ID as ID,
                                            ART.DESCRIPCION as DESCRIPCION,
                                            ART.FAMILIA as FAMILIA,
                                            ART.SUBFAMILIA as SUBFAMILIA,
                                            DET.CANTIDAD as CANTIDAD,
                                            CFGV.NOMBREVENDEDOR as VENDEDOR,
                                            CFGV.ID as IDVENDEDOR,
                                            (DET.IMPORTELINEA+DET.IMPIVA) AS TOTAL, 
                                            DET.PRECIO + (DET.PRECIO * (DET.PORCIVA/100)) as PRECIO,
                                            PRE.PVP3 as PVP3,
                                            'DOCTOS.' AS FORMLISTA,
                                            EXTRACT(DAY FROM CFGD.FECHA) as DIA,
                                            EXTRACT(MONTH FROM CFGD.FECHA) as MES,
                                            EXTRACT(YEAR FROM CFGD.FECHA) as ANIO,
                                            MV.VMENSUAL as VMENSUAL,
                                            MV.VDIARIO as VDIARIO,
                                            MV.IMENSUAL as IMENSUAL,
                                            MV.IDIARIO as IDIARIO
                                    From 		ref_pedidospresup CFGD 
                                    INNER JOIN CFG_METASVENDEDOR MV on CFGD.fk1mcfg_vendedores=MV.IDVENDEDOR AND ART.FAMILIA=MV.FAMILIA
                                    inner join cfg_vendedores CFGV on CFGV.id=CFGD.fk1mcfg_vendedores 
                                    inner join REF_DETPEDIDOSPRESUP DET on CFGD.ID=DET.FKPADREF_PEDIDOSPRESUP 
                                    inner join CFG_ARTICULOS ART on DET.CODIGO=ART.CODIGOARTICULO 
                                    inner join CFG_PRECIOSXALMACENES PRE on PRE.FK1MCFG_ARTICULOS=ART.ID and PRE.FK1MCFG_ALMACENES=10754
                                    Where 		EXTRACT(YEAR FROM CFGD.FECHA)=$anio";
        if($mes>0)
            $queryVentas.= "        AND 	EXTRACT(MONTH FROM CFGD.FECHA)=$mes"; 
        if($dia>0)
            $queryVentas.= "        AND 		EXTRACT(DAY FROM CFGD.FECHA)=$dia";
        $queryVentas.= "            AND NOT CFGD.ESPEDLIQAPARTADO='AA' 
                                    AND 		CFGD.SERDOCTO<>'CREDITO' 
                                    AND 		ART.FAMILIA NOT IN ('OXIFUEL','CONTRAPESO','CONTRAPESO')
                                    AND 		CFGD.DOCTOESPECIAL='' 
                                    AND 		CFGD.STATUS IN ('PEDIDO EMITIDO','PEDIDO FACTURADO')
                                    Order by CFGV.NOMBREVENDEDOR,TOTAL DESC