Audit modifiche

Consulta le modifiche registrate dai trigger database. Gli intervalli data/ora sono interpretati come orario italiano Europe/Rome.

Azzera filtri
Filtro record attivo: codice prodotto #182
14 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
05/06/26, 13:46:43Inserimentoplan_assignments4575app interna · app · magic_plan_confirm · magic_plan:2026-06-08:2026-06-12
id: ∅ → 4575; date: ∅ → 2026-06-09; notes: ∅ → Auto-generato (Ordine #328); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4575,
    "old": null
  },
  "date": {
    "new": "2026-06-09",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #328)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 27,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 113,
    "old": null
  },
  "planned_quantity": {
    "new": 182,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4575,
  "date": "2026-06-09",
  "notes": "Auto-generato (Ordine #328)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 25,
  "operator_id": 27,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 113,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
28/05/26, 13:05:20Inserimentoplan_assignments4383app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 4383; date: ∅ → 2026-05-29; notes: ∅ → Auto-generato (Ordine #388); shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4383,
    "old": null
  },
  "date": {
    "new": "2026-05-29",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #388)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 33,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 119,
    "old": null
  },
  "planned_quantity": {
    "new": 182,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4383,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 33,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
28/05/26, 13:03:55Cancellazioneplan_assignments4251
id: 4251 → ∅; date: 2026-05-29 → ∅; notes: Auto-generato (Ordine #388) → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 4251
  },
  "date": {
    "new": null,
    "old": "2026-05-29"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #388)"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 25
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 119
  },
  "planned_quantity": {
    "new": null,
    "old": 182
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 4251,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
28/05/26, 11:52:07Inserimentoplan_assignments4251app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 4251; date: ∅ → 2026-05-29; notes: ∅ → Auto-generato (Ordine #388); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4251,
    "old": null
  },
  "date": {
    "new": "2026-05-29",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #388)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 25,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 119,
    "old": null
  },
  "planned_quantity": {
    "new": 182,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4251,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
28/05/26, 11:41:43Cancellazioneplan_assignments4142
id: 4142 → ∅; date: 2026-05-29 → ∅; notes: Auto-generato (Ordine #388) → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 4142
  },
  "date": {
    "new": null,
    "old": "2026-05-29"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #388)"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 25
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 119
  },
  "planned_quantity": {
    "new": null,
    "old": 182
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 4142,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
28/05/26, 11:40:16Inserimentoplan_assignments4142app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 4142; date: ∅ → 2026-05-29; notes: ∅ → Auto-generato (Ordine #388); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4142,
    "old": null
  },
  "date": {
    "new": "2026-05-29",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #388)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 25,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 119,
    "old": null
  },
  "planned_quantity": {
    "new": 182,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4142,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
28/05/26, 11:38:46Cancellazioneplan_assignments4033
id: 4033 → ∅; date: 2026-05-29 → ∅; notes: Auto-generato (Ordine #388) → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 4033
  },
  "date": {
    "new": null,
    "old": "2026-05-29"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #388)"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 25
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 119
  },
  "planned_quantity": {
    "new": null,
    "old": 182
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 4033,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
28/05/26, 11:37:52Inserimentoplan_assignments4033app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 4033; date: ∅ → 2026-05-29; notes: ∅ → Auto-generato (Ordine #388); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4033,
    "old": null
  },
  "date": {
    "new": "2026-05-29",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #388)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 25,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 119,
    "old": null
  },
  "planned_quantity": {
    "new": 182,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4033,
  "date": "2026-05-29",
  "notes": "Auto-generato (Ordine #388)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": 182,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 12:44:59Modificaproduct_codes182
throughput_per_shift: 182 → 1365
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 1365,
    "old": 182
  }
}
Prima
{
  "id": 182,
  "code": "D0502002",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 2002",
  "short_label": null,
  "raw_material_id": 68,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 182,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 182,
  "code": "D0502002",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 2002",
  "short_label": null,
  "raw_material_id": 68,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 1365,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 14:55:24Cancellazioneplan_assignments1867
id: 1867 → ∅; date: 2026-04-23 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2630 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1867
  },
  "date": {
    "new": null,
    "old": "2026-04-23"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2630"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 20
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "processing": 19
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 182
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 695
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1867,
  "date": "2026-04-23",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2630",
  "shift": "T2",
  "status": "completed",
  "machine_id": 20,
  "operator_id": 35,
  "scrap_by_type": {
    "processing": 19
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 182,
  "planned_quantity": null,
  "produced_quantity": 695,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2066
id: 2066 → ∅; date: 2026-05-08 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2925 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2066
  },
  "date": {
    "new": null,
    "old": "2026-05-08"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2925"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 20
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "raw": 4,
      "processing": 9
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 182
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 291
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2066,
  "date": "2026-05-08",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2925",
  "shift": "T2",
  "status": "completed",
  "machine_id": 20,
  "operator_id": 35,
  "scrap_by_type": {
    "raw": 4,
    "processing": 9
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 182,
  "planned_quantity": null,
  "produced_quantity": 291,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2051
id: 2051 → ∅; date: 2026-05-07 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2900 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2051
  },
  "date": {
    "new": null,
    "old": "2026-05-07"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2900"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 20
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "raw": 8,
      "processing": 5
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 182
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 799
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2051,
  "date": "2026-05-07",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2900",
  "shift": "T2",
  "status": "completed",
  "machine_id": 20,
  "operator_id": 35,
  "scrap_by_type": {
    "raw": 8,
    "processing": 5
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 182,
  "planned_quantity": null,
  "produced_quantity": 799,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2029
id: 2029 → ∅; date: 2026-05-06 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2871 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2029
  },
  "date": {
    "new": null,
    "old": "2026-05-06"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2871"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 20
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "raw": 10,
      "processing": 26
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 182
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 850
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2029,
  "date": "2026-05-06",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2871",
  "shift": "T2",
  "status": "completed",
  "machine_id": 20,
  "operator_id": 35,
  "scrap_by_type": {
    "raw": 10,
    "processing": 26
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 182,
  "planned_quantity": null,
  "produced_quantity": 850,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2007
id: 2007 → ∅; date: 2026-05-05 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2844 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2007
  },
  "date": {
    "new": null,
    "old": "2026-05-05"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2844"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 20
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "processing": 7
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 182
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 851
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2007,
  "date": "2026-05-05",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2844",
  "shift": "T2",
  "status": "completed",
  "machine_id": 20,
  "operator_id": 35,
  "scrap_by_type": {
    "processing": 7
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 182,
  "planned_quantity": null,
  "produced_quantity": 851,
  "setup_from_product_code_id": null
}
Dopo
null