§
    s�’jQ  ã                  óf   — d dl mZ ddlmZmZmZmZmZmZm	Z	 de› de› de› de› de	› de› de› d�Z
dS )é    )Úannotationsé   )ÚMILESTONES_JOINÚPHASE_PROGRESS_JOINÚPHASE_SNAPSHOT_JOINÚ
RISKS_JOINÚSUMMARY_CARDS_JOINÚ
TASKS_JOINÚTIMELINE_JOINuS  
    SELECT
        p.project_code,
        p.project_name,
        COALESCE(p.client_name, c.display_name, c.legal_name, '') AS client_name,
        COALESCE(p.location, '') AS location,
        COALESCE(pm.full_name, '') AS project_manager,
        COALESCE(p.status, '') AS status,
        COALESCE(phase_snapshot.current_phase, '') AS current_phase,
        COALESCE(p.progress_percent, 0) AS overall_progress_percent,
        CASE
            WHEN p.contract_value IS NOT NULL AND p.budget_amount IS NOT NULL THEN
                CONCAT('NgÃ¢n sÃ¡ch ', TRIM(TO_CHAR(p.budget_amount, 'FM999999999990D00')), ' / Há»£p Ä‘á»“ng ', TRIM(TO_CHAR(p.contract_value, 'FM999999999990D00')))
            WHEN p.budget_amount IS NOT NULL THEN
                CONCAT('NgÃ¢n sÃ¡ch ', TRIM(TO_CHAR(p.budget_amount, 'FM999999999990D00')))
            WHEN p.contract_value IS NOT NULL THEN
                CONCAT('GiÃ¡ trá»‹ há»£p Ä‘á»“ng ', TRIM(TO_CHAR(p.contract_value, 'FM999999999990D00')))
            ELSE ''
        END AS budget_status,
        COALESCE(summary_cards.summary_cards::jsonb, '[]'::jsonb) AS summary_cards,
        COALESCE(phase_progress.phase_progress::jsonb, '[]'::jsonb) AS phase_progress,
        COALESCE(milestones.milestones::jsonb, '[]'::jsonb) AS milestones,
        COALESCE(timeline.timeline::jsonb, '[]'::jsonb) AS timeline,
        COALESCE(risks.risks::jsonb, '[]'::jsonb) AS risks,
        COALESCE(tasks.upcoming_tasks::jsonb, '[]'::jsonb) AS upcoming_tasks
    FROM projects p
    LEFT JOIN companies c ON c.id = p.company_id
    LEFT JOIN employees pm ON pm.id = p.project_manager_id
    z
    z,
    ORDER BY p.created_at DESC, p.id DESC;
N)Ú
__future__r   Úproject_management_subqueriesr   r   r   r   r	   r
   r   ÚFETCH_PROJECT_MANAGEMENT_SQL© ó    ú<C:\Projects\DSCons\app\core\postgres\project_mgmt\queries.pyú<module>r      só   ðØ "Ð "Ð "Ð "Ð "Ð "ðð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð$ ð8 ð9$ ð $ ð: ð;$ ð $ ð< ð=$ ð $ ð> ð?$ ð $ ð@ ðA$ ð $ ðB ðC$ ð $ ðD ðE$ ð $ ð $ Ð Ð Ð r   