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 #161
5 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
28/05/26, 15:51:27Inserimentoplan_assignments4394
id: ∅ → 4394; date: ∅ → 2026-05-25; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4394,
    "old": null
  },
  "date": {
    "new": "2026-05-25",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 38,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "raw": 16,
      "processing": 14
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 109,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 161,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4394,
  "date": "2026-05-25",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 38,
  "scrap_by_type": {
    "raw": 16,
    "processing": 14
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 109,
  "planned_quantity": null,
  "produced_quantity": 161,
  "setup_from_product_code_id": null
}
27/05/26, 12:44:59Modificaproduct_codes161
throughput_per_shift: 95 → 713
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 713,
    "old": 95
  }
}
Prima
{
  "id": 161,
  "code": "00330145",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0145",
  "short_label": null,
  "raw_material_id": 60,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 95,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 161,
  "code": "00330145",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0145",
  "short_label": null,
  "raw_material_id": 60,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 713,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
26/05/26, 11:47:31Inserimentoplan_assignments3538
id: ∅ → 3538; date: ∅ → 2026-05-25; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 3538,
    "old": null
  },
  "date": {
    "new": "2026-05-25",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 38,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "raw": 16,
      "processing": 14
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 109,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 161,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 3538,
  "date": "2026-05-25",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 38,
  "scrap_by_type": {
    "raw": 16,
    "processing": 14
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 109,
  "planned_quantity": null,
  "produced_quantity": 161,
  "setup_from_product_code_id": null
}
22/05/26, 14:55:24Cancellazioneplan_assignments1809
id: 1809 → ∅; date: 2026-04-20 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2540 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1809
  },
  "date": {
    "new": null,
    "old": "2026-04-20"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2540"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 39
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "assembly"
  },
  "product_code_id": {
    "new": null,
    "old": 134
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 161
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1809,
  "date": "2026-04-20",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2540",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 39,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 161,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2075
id: 2075 → ∅; date: 2026-05-08 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2936 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2075
  },
  "date": {
    "new": null,
    "old": "2026-05-08"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2936"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 39
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "assembly"
  },
  "product_code_id": {
    "new": null,
    "old": 134
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 161
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2075,
  "date": "2026-05-08",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2936",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 39,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 161,
  "setup_from_product_code_id": null
}
Dopo
null