Forum BlogTesla : Discussions, Astuces et Infos sur Tesla

Code : Tout sélectionner

SELECT DISTINCT 
  a.name AS name, 
  a.latitude AS latitude, 
  a.longitude AS longitude 
FROM charging_processes cp
JOIN addresses a ON cp.address_id = a.id
JOIN charges c ON c.charging_process_id = cp.id
WHERE cp.car_id IN (${car_id:csv}) 
  AND $__timeFilter(cp.start_date)
  AND (a.name ILIKE '%supercharger%' OR c.fast_charger_brand = 'Tesla')
  AND cp.charge_energy_added > 0

Code : Tout sélectionner

SELECT
  COALESCE(g.name, a.name) AS "Station",
  round(cp.charge_energy_added,2) AS "kWh ajoutés",
  round(extract(epoch FROM (cp.end_date - cp.start_date))/60,1) AS "Durée (min)",
  round(cp.cost,2) AS "Coût (€)"
FROM charging_processes cp
LEFT JOIN geofences g ON g.id = cp.geofence_id
LEFT JOIN addresses a ON a.id = cp.address_id
WHERE cp.car_id IN (${car_id:csv})
AND $__timeFilter(cp.start_date)
AND cp.end_date IS NOT NULL
ORDER BY cp.start_date DESC;

Code : Tout sélectionner

SELECT DISTINCT 
  COALESCE(g.name, a.name, a.city, 'Lieu inconnu') AS name, 
  a.latitude AS latitude, 
  a.longitude AS longitude 
FROM charging_processes cp
JOIN addresses a ON cp.address_id = a.id
LEFT JOIN geofences g ON cp.geofence_id = g.id
LEFT JOIN charges c ON c.charging_process_id = cp.id AND c.date = cp.end_date
WHERE cp.car_id IN (${car_id:csv}) 
  AND $__timeFilter(cp.start_date)
  AND cp.charge_energy_added > 0
  -- On exclut le domicile et le travail
  AND (g.name IS NULL OR (g.name <> '${home}' AND g.name <> '${work}'))
  -- On exclut les Superchargers Tesla
  AND (g.name IS NULL OR g.name NOT LIKE '${suc}%')
  AND (c.fast_charger_brand IS NULL OR c.fast_charger_brand <> 'Tesla')
  -- PROTECTION AJOUTÉE ICI : gère le nom vide chez ton ami
  AND (a.name IS NULL OR a.name NOT ILIKE '%supercharger%')

Code : Tout sélectionner

SELECT
  COALESCE(g.name, a.name, a.city, 'Lieu inconnu') AS "Station",
  round(cp.charge_energy_added,2) AS "kWh ajoutés",
  round(extract(epoch FROM (cp.end_date - cp.start_date))/60,1) AS "Durée (min)",
  round(cp.cost,2) AS "Coût (€)"
FROM charging_processes cp
LEFT JOIN geofences g ON g.id = cp.geofence_id
LEFT JOIN addresses a ON a.id = cp.address_id
WHERE cp.car_id IN (${car_id:csv})
AND $__timeFilter(cp.start_date)
AND cp.end_date IS NOT NULL
ORDER BY cp.start_date DESC;