== Tables mail/queue/workflow/wfm ==
  tblemaillists
  tblemailtemplates
  tblextended_email_log_activity
  tblextended_email_settings
  tbllead_integration_emails
  tblleads_email_integration
  tbllistemails
  tblmail_attachment
  tblmail_conversation
  tblmail_inbox
  tblmail_outbox
  tblmail_queue
  tblmailbox_ai_accounts
  tblmailbox_ai_ai_log
  tblmailbox_ai_ai_preferences
  tblmailbox_ai_attachment_extractions
  tblmailbox_ai_attachments
  tblmailbox_ai_autoreplies
  tblmailbox_ai_autoreply_log
  tblmailbox_ai_categories
  tblmailbox_ai_drafts
  tblmailbox_ai_email_links
  tblmailbox_ai_email_tags
  tblmailbox_ai_email_vectors
  tblmailbox_ai_emails
  tblmailbox_ai_enrichment
  tblmailbox_ai_scheduled
  tblmailbox_ai_sender_check
  tblmailbox_ai_tags
  tblmailbox_ai_templates
  tblmaillistscustomfields
  tblmaillistscustomfieldvalues
  tblnotifman_tpl_queue
  tblplayground_reminders
  tblplayground_tracked_mails
  tblreminders
  tblscheduled_emails
  tblsurveysemailsendcron
  tbltracked_mails
  tblwfm_applied
  tblwfm_checklists
  tblwfm_fields
  tblwfm_tasks
  tblwfm_workflows

== Nadege (staff) ==
  {"staffid":"6","firstname":"Nadége","lastname":"Profil Sous traitant","email":"nadege@goaper.fr","active":"1"}

== Taches 'VISA' (les 40 plus recentes) ==
  {"id":"24","name":"suivi obtention VISA","rel_type":"customer","rel_id":"4","dateadded":"2026-07-06 16:56:23","addedfrom":"5","status":"1"}
-- total taches VISA --
  {"n":"1"}
-- repartition par jour --
  {"j":"2026-07-06","n":"1"}

== Assignations de ces taches (tbltask_assigned) ==
  {"taskid":"24","staffid":"6","name":"suivi obtention VISA","dateadded":"2026-07-06 16:56:23"}
  {"taskid":"24","staffid":"5","name":"suivi obtention VISA","dateadded":"2026-07-06 16:56:23"}

== Projets referencés par ces taches : existent-ils encore ? ==
  {"rel_id":"4","nb_taches":"1","projet_existe":null}

== Notifications recentes vers Nadege ==
  {"id":"1185","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-08-03 15:29:08","link":"projects\/view\/14?group=project_files&file_id=88"}
  {"id":"1176","description":"not_task_marked_as_complete","fromuserid":"5","touserid":"6","date":"2026-08-03 14:09:55","link":"#taskid=65"}
  {"id":"75","description":"ebenef_not_doc_uploaded","fromuserid":"0","touserid":"6","date":"2026-07-09 08:05:39","link":"admin\/projects\/view\/14?group=ebenef_docs"}
  {"id":"71","description":"ebenef_not_file_uploaded","fromuserid":"0","touserid":"6","date":"2026-07-09 07:58:25","link":"admin\/projects\/view\/14?group=project_files"}
  {"id":"62","description":"not_task_status_changed","fromuserid":"5","touserid":"6","date":"2026-07-07 17:04:39","link":"#taskid=37"}
  {"id":"57","description":"not_staff_added_as_project_member","fromuserid":"5","touserid":"6","date":"2026-07-07 16:39:25","link":"projects\/view\/17"}
  {"id":"55","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 16:12:00","link":"projects\/view\/8?group=project_files&file_id=39"}
  {"id":"54","description":"not_task_marked_as_complete","fromuserid":"5","touserid":"6","date":"2026-07-07 16:07:25","link":"#taskid=26"}
  {"id":"53","description":"not_task_unmarked_as_complete","fromuserid":"5","touserid":"6","date":"2026-07-07 16:06:54","link":"#taskid=26"}
  {"id":"52","description":"not_task_marked_as_complete","fromuserid":"5","touserid":"6","date":"2026-07-07 16:05:13","link":"#taskid=26"}
  {"id":"51","description":"not_task_marked_as_complete","fromuserid":"5","touserid":"6","date":"2026-07-07 15:49:36","link":"#taskid=72"}
  {"id":"49","description":"not_staff_added_as_project_member","fromuserid":"5","touserid":"6","date":"2026-07-07 15:49:23","link":"projects\/view\/15"}
  {"id":"47","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:41:07","link":"projects\/view\/14?group=project_files&file_id=38"}
  {"id":"45","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:39:39","link":"projects\/view\/14?group=project_files&file_id=34"}
  {"id":"44","description":"not_task_new_comment","fromuserid":"5","touserid":"6","date":"2026-07-07 15:30:49","link":"#taskid=65#comment_16"}
  {"id":"43","description":"not_task_status_changed","fromuserid":"5","touserid":"6","date":"2026-07-07 15:30:15","link":"#taskid=65"}
  {"id":"41","description":"not_staff_added_as_project_member","fromuserid":"5","touserid":"6","date":"2026-07-07 15:20:10","link":"projects\/view\/14"}
  {"id":"39","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:17:34","link":"projects\/view\/12?group=project_files&file_id=33"}
  {"id":"37","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:16:59","link":"projects\/view\/11?group=project_files&file_id=29"}
  {"id":"35","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:15:28","link":"projects\/view\/11?group=project_files&file_id=28"}
  {"id":"33","description":"not_project_file_uploaded","fromuserid":"5","touserid":"6","date":"2026-07-07 15:13:46","link":"projects\/view\/10?group=project_files&file_id=25"}
  {"id":"32","description":"not_task_new_comment","fromuserid":"5","touserid":"6","date":"2026-07-07 14:31:14","link":"#taskid=58#comment_14"}
  {"id":"31","description":"not_task_status_changed","fromuserid":"5","touserid":"6","date":"2026-07-07 14:30:33","link":"#taskid=58"}
  {"id":"29","description":"not_staff_added_as_project_member","fromuserid":"5","touserid":"6","date":"2026-07-07 14:29:45","link":"projects\/view\/13"}
  {"id":"28","description":"not_task_status_changed","fromuserid":"5","touserid":"6","date":"2026-07-07 14:21:06","link":"#taskid=44"}
  {"id":"27","description":"not_task_new_comment","fromuserid":"5","touserid":"6","date":"2026-07-07 14:19:40","link":"#taskid=51#comment_10"}
  {"id":"26","description":"not_task_marked_as_complete","fromuserid":"5","touserid":"6","date":"2026-07-07 14:18:59","link":"#taskid=51"}
  {"id":"24","description":"not_staff_added_as_project_member","fromuserid":"5","touserid":"6","date":"2026-07-07 14:18:50","link":"projects\/view\/12"}
  {"id":"23","description":"not_task_new_comment","fromuserid":"5","touserid":"6","date":"2026-07-07 14:17:22","link":"#taskid=37#comment_9"}
  {"id":"22","description":"not_task_new_comment","fromuserid":"5","touserid":"6","date":"2026-07-07 14:15:51","link":"#taskid=44#comment_8"}

== Historique notif_manager (si tache VISA) ==
  ERR: Table 'symbiorcrm.tblnotifman_history' doesn't exist | SELECT * FROM tblnotifman_history WHERE 1 ORDER BY id DESC LIMIT 5
done