search

betagouv / conseillers-entreprises

Le service d’accompagnement des entreprises
https://conseillers-entreprises.service-public.fr/
15 stars 7 forks source link

BUG MER ok mais analyse incomplète #3581

Closed clairezed closed 1 month ago

clairezed commented 2 months ago

Cf mail reminder_involvment qui bug.

Need.joins(:diagnosis, :matches).where.not(diagnosis: { step: :completed }).where.not(matches: { sent_at: nil }).order(created_at: :desc).distinct.map do |n|
  [n.id, n.solicitation.created_at.strftime("%d/%m/%Y %H:%M:%2N"), n.diagnosis.created_at.strftime("%d/%m/%Y %H:%M:%2N"), n.created_at.strftime("%d/%m/%Y %H:%M:%2N"), n.matches.map{|m| m.created_at.strftime("%d/%m/%Y %H:%M:%2N")}, n.matches.map{|m| m.sent_at.strftime("%d/%m/%Y %H:%M:%2N")}]
end

[id,     solicitation,           diagnosis,            need,                  matches created_at,       matches sent_at ]   
[134427, "08/08/2024 08:04:40", "08/08/2024 10:32:79", "08/08/2024 10:32:52", ["08/08/2024 10:32:83"], ["08/08/2024 10:32:91"]],
[134423, "08/08/2024 08:03:60", "08/08/2024 10:25:05", "08/08/2024 10:25:06", ["08/08/2024 10:25:20"], ["08/08/2024 10:25:87"]],
[134421, "08/08/2024 08:59:69", "08/08/2024 10:25:15", "08/08/2024 10:25:69", ["08/08/2024 10:25:76"], ["08/08/2024 10:25:78"]],
[134415, "08/08/2024 08:03:68", "08/08/2024 10:19:03", "08/08/2024 10:19:05", ["08/08/2024 10:19:18"], ["08/08/2024 10:19:03"]],
[134414, "08/08/2024 06:58:35", "08/08/2024 10:19:56", "08/08/2024 10:19:28", 
  ["08/08/2024 10:19:58", "08/08/2024 10:19:61"], 
  ["08/08/2024 10:19:54", "08/08/2024 10:19:54"]],
[134406, "08/08/2024 08:08:28", "08/08/2024 10:07:25", "08/08/2024 10:07:27", 
  ["08/08/2024 10:07:42", "08/08/2024 10:07:41"], 
  ["08/08/2024 10:07:83", "08/08/2024 10:07:83"]], 
[134404, "08/08/2024 08:42:61", "08/08/2024 10:05:36", "08/08/2024 10:05:39", ["08/08/2024 10:05:45"], ["08/08/2024 10:05:46"]], 
[130578, "15/07/2024 13:35:26", "15/07/2024 14:24:57", "15/07/2024 14:24:23", ["15/07/2024 14:24:40"], ["15/07/2024 14:24:42"]], 
[130181, "09/07/2024 17:04:32", "09/07/2024 17:11:02", "12/07/2024 09:20:45", 
  ["12/07/2024 09:20:02", "12/07/2024 09:20:81", "12/07/2024 09:20:00"], 
  ["12/07/2024 09:21:94", "12/07/2024 09:21:94", "12/07/2024 09:21:94"]]

Beaucoup de bugs le 8/08/2024, à un moment où il y avait pas mal d'erreur 500 RNE (cf https://mattermost.incubateur.net/betagouv/pl/ahx1dfuyj38jfemccn4t4a96io)

Correction des besoins :

Besoin pas ok : 

Solicitation.find(sol_id).update(status: :in_progress)
Diagnosis.find(diag_id).update(step: :matches)
Match.find(match_id).update(sent_at: nil, status: :quo)
Need.find(need_id).update_status

Besoin ok : 

Solicitation.find(sol_id).update(status: :processed)
Diagnosis.find(diag_id).update(step: :completed, advisor_id: advisor_id)
# Match.find(match_id).update(sent_at: nil, status: :quo)
Need.find(need_id).update_status