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 #198
5 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
18/06/26, 13:53:26Inserimentoplan_assignments4692app interna · app · magic_plan_confirm · magic_plan:2026-06-15:2026-06-19
id: ∅ → 4692; date: ∅ → 2026-06-16; notes: ∅ → Auto-generato (Ordine #234); shift: ∅ → T2; +14 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4692,
    "old": null
  },
  "date": {
    "new": "2026-06-16",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #234)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 17,
    "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
  },
  "planned_minutes": {
    "new": 252,
    "old": null
  },
  "product_code_id": {
    "new": 141,
    "old": null
  },
  "capacity_minutes": {
    "new": 450,
    "old": null
  },
  "planned_quantity": {
    "new": 42,
    "old": null
  },
  "order_allocations": {
    "new": [
      {
        "code": "11400141",
        "orderId": 234,
        "quantity": 42,
        "deliveryDate": "2026-05-02",
        "productCodeId": 141,
        "productionDeadline": "2026-04-30"
      }
    ],
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "residual_capacity_minutes": {
    "new": 198,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4692,
  "date": "2026-06-16",
  "notes": "Auto-generato (Ordine #234)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 17,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "planned_minutes": 252,
  "product_code_id": 141,
  "capacity_minutes": 450,
  "planned_quantity": 42,
  "order_allocations": [
    {
      "code": "11400141",
      "orderId": 234,
      "quantity": 42,
      "deliveryDate": "2026-05-02",
      "productCodeId": 141,
      "productionDeadline": "2026-04-30"
    }
  ],
  "produced_quantity": null,
  "residual_capacity_minutes": 198,
  "setup_from_product_code_id": null
}
27/05/26, 12:44:59Modificaproduct_codes198—
throughput_per_shift: 20 → 150
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 150,
    "old": 20
  }
}
Prima
{
  "id": 198,
  "code": "MNA2305081",
  "notes": null,
  "active": true,
  "customer": "MAN",
  "flow_type": "direct",
  "description": "BRACKET ASSY MAN 5081",
  "short_label": null,
  "raw_material_id": 20,
  "packaging_quantity": 1,
  "production_flow_id": 2,
  "assembly_throughput": null,
  "throughput_per_shift": 20,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 198,
  "code": "MNA2305081",
  "notes": null,
  "active": true,
  "customer": "MAN",
  "flow_type": "direct",
  "description": "BRACKET ASSY MAN 5081",
  "short_label": null,
  "raw_material_id": 20,
  "packaging_quantity": 1,
  "production_flow_id": 2,
  "assembly_throughput": null,
  "throughput_per_shift": 150,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 16:03:27Inserimentoplan_assignments2670—
id: ∅ → 2670; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2670,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 35,
    "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": null,
    "old": null
  },
  "produced_quantity": {
    "new": 198,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2670,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 14,
  "operator_id": 35,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": null,
  "produced_quantity": 198,
  "setup_from_product_code_id": null
}
22/05/26, 14:54:47Cancellazioneplan_assignments2226—
id: 2226 → ∅; date: 2026-05-20 → ∅; notes: ∅ → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2226
  },
  "date": {
    "new": null,
    "old": "2026-05-20"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 35
  },
  "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": null
  },
  "produced_quantity": {
    "new": null,
    "old": 198
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2226,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 14,
  "operator_id": 35,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": null,
  "produced_quantity": 198,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 12:28:14Inserimentoplan_assignments2226—
id: ∅ → 2226; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2226,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 35,
    "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": null,
    "old": null
  },
  "produced_quantity": {
    "new": 198,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2226,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 14,
  "operator_id": 35,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 119,
  "planned_quantity": null,
  "produced_quantity": 198,
  "setup_from_product_code_id": null
}