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 #167
4 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
29/05/26, 09:32:29Cancellazioneplan_assignments4259app interna · app · magic_plan_confirm · magic_plan:2026-06-01:2026-06-05
id: 4259 → ∅; date: 2026-06-03 → ∅; notes: Auto-generato (Ordine #307) → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 4259
  },
  "date": {
    "new": null,
    "old": "2026-06-03"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #307)"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 28
  },
  "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": 100
  },
  "planned_quantity": {
    "new": null,
    "old": 167
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 4259,
  "date": "2026-06-03",
  "notes": "Auto-generato (Ordine #307)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 100,
  "planned_quantity": 167,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
28/05/26, 11:53:57Inserimentoplan_assignments4259app interna · app · magic_plan_confirm · magic_plan:2026-06-01:2026-06-05
id: ∅ → 4259; date: ∅ → 2026-06-03; notes: ∅ → Auto-generato (Ordine #307); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4259,
    "old": null
  },
  "date": {
    "new": "2026-06-03",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #307)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "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": 100,
    "old": null
  },
  "planned_quantity": {
    "new": 167,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4259,
  "date": "2026-06-03",
  "notes": "Auto-generato (Ordine #307)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 100,
  "planned_quantity": 167,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 12:44:59Modificaproduct_codes167—
throughput_per_shift: 98 → 735
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 735,
    "old": 98
  }
}
Prima
{
  "id": 167,
  "code": "00408542/T",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 8542",
  "short_label": null,
  "raw_material_id": 61,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 98,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 167,
  "code": "00408542/T",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 8542",
  "short_label": null,
  "raw_material_id": 61,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 735,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 14:55:36Cancellazioneplan_assignments1684—
id: 1684 → ∅; date: 2026-04-09 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2324 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1684
  },
  "date": {
    "new": null,
    "old": "2026-04-09"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2324"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 25
  },
  "operator_id": {
    "new": null,
    "old": 27
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "workedCasting": 1
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 114
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 167
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1684,
  "date": "2026-04-09",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2324",
  "shift": "T2",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 27,
  "scrap_by_type": {
    "workedCasting": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 167,
  "setup_from_product_code_id": null
}
Dopo
null