
    j0                     0    d dl mZ ddedee         fdZdS )    	query_all   daysreturnc                 B    d}t          |d| i          }d |D             S )Na  
        SELECT ROUND(jd::NUMERIC, 3) AS lng,
               ROUND(wd::NUMERIC, 3) AS lat,
               COUNT(*) AS weight
        FROM "jcgkzx_monitor"."wcnr_ryrl_gj"
        WHERE shot_time >= CURRENT_TIMESTAMP - make_interval(days => %(days)s)
          AND jd IS NOT NULL
          AND wd IS NOT NULL
        GROUP BY ROUND(jd::NUMERIC, 3), ROUND(wd::NUMERIC, 3)
        ORDER BY weight DESC
    r   c           
      0   g | ]}|                     d           |                     d          ,t          |                     d                     t          |                     d                    t          |                     dd                    dS )lngNlatweightr   )r
   r   r   )getfloatint).0rows     L/home/longshao/multi-rider-rag/modules/dashboard/services/heatmap_service.py
<listcomp>zget_heatmap.<locals>.<listcomp>   s        775>>%#''%..*D ((((#''(A..//	
 	
 +E*D*D    r   )r   sqlrowss      r   get_heatmapr      sA    
C S64.))D     r   N)r   )shared.db.kingbaser   r   listdictr    r   r   <module>r      sL    ( ( ( ( ( ( c 4:      r   