// armar query obtener facturas pagadas y por cobrar
    $sql_prev_real  = ' SELECT
                                p.proyecto_id,
                                p.ref,
                                p.title,
                                p.description,
                                COALESCE(p.budget_amount, 0) as budget_amount,
                                COALESCE(i.total, 0) as valor_real,
                                COALESCE(i.facturado_mes, 0) as facturado_mes,
                                COALESCE(i.facturado_meses_anteriores, 0) as facturado_meses_anteriores,
                                COALESCE(ip.total, 0) as pendiente_facturar,
                                COALESCE(ipp.total, 0) as cobrado,
                                COALESCE(ip.total, 0) - COALESCE(ipp.total, 0) as pendiente_cobrar
                                ,DATE(p.dateo) AS dateo, DATE(p.datee) AS datee
                                ,(CASE
    WHEN fk_statut = 0 THEN "Borrador"
        WHEN fk_statut = 1 THEN "Activo"
    WHEN fk_statut = 2 THEN "Cerrado"
    ELSE "Desconocido"
END) AS status

                        FROM dim_proyectos as p';
    $sql_prev_real .= ' LEFT JOIN (SELECT
                                        proyecto_id,
                                        SUM(multicurrency_total_ttc_d) as total,
                                        SUM(CASE
                                                WHEN (MONTH(datef) = '.$month_mayor.') AND (YEAR(datef) = '.$year_mayor.') THEN multicurrency_total_ttc_d
                                                ELSE 0
                                            END) as facturado_mes,
                                        SUM(CASE
                                                WHEN (MONTH(datef) < '.$month_mayor.') AND (YEAR(datef) <= '.$year_mayor.') THEN multicurrency_total_ttc_d
                                                ELSE 0
                                                END) as facturado_meses_anteriores
                                   FROM fact_ingresos
                                   WHERE fk_statut = 2';
    $sql_prev_real .= '            AND type = 0
                                   GROUP BY proyecto_id  ) as i ON p.proyecto_id = i.proyecto_id';
    $sql_prev_real .= ' LEFT JOIN (SELECT
                                        proyecto_id,
                                        SUM(multicurrency_total_ttc_d) as total
                                   FROM fact_ingresos
                                   WHERE fk_statut = 1';
    $sql_prev_real .= '                AND YEAR(datef) IN ('.$years.')';
    $sql_prev_real .= '                AND MONTH(datef) IN ('.implode(",",$months).')';
    $sql_prev_real .= '            GROUP BY proyecto_id) as ip ON p.proyecto_id = ip.proyecto_id';
    $sql_prev_real .= ' LEFT JOIN (SELECT
                                        fpi.fk_projet,
                                        SUM(fpi.multicurrency_amount_pf) as total
                                   FROM fact_pagos_ingresos as fpi
                                   INNER JOIN dim_ingresos as di ON(fpi.fk_facture = di.ingreso_id)
                                   WHERE di.fk_statut = 1';
    $sql_prev_real .= '                AND YEAR(datep) IN ('.$years.')';
    $sql_prev_real .= '                AND MONTH(datep) IN ('.implode(",",$months).')';
    $sql_prev_real .= '            GROUP BY fk_projet) as ipp ON p.proyecto_id = ipp.fk_projet';
    die($sql_prev_real);