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 #143
15 eventi mostrati · offset 100Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 14:55:08Cancellazioneplan_assignments2041—
id: 2041 → ∅; date: 2026-05-07 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2889 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2041
  },
  "date": {
    "new": null,
    "old": "2026-05-07"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2889"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 18
  },
  "operator_id": {
    "new": null,
    "old": 31
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "processing": 1
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 143
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 52
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2041,
  "date": "2026-05-07",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2889",
  "shift": "T1",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 31,
  "scrap_by_type": {
    "processing": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 143,
  "planned_quantity": null,
  "produced_quantity": 52,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2032—
id: 2032 → ∅; date: 2026-05-06 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2874 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2032
  },
  "date": {
    "new": null,
    "old": "2026-05-06"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2874"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 18
  },
  "operator_id": {
    "new": null,
    "old": 40
  },
  "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": 143
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 39
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2032,
  "date": "2026-05-06",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2874",
  "shift": "T2",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 40,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 143,
  "planned_quantity": null,
  "produced_quantity": 39,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:02Cancellazioneplan_assignments2081—
id: 2081 → ∅; date: 2026-05-12 → ∅; notes: ∅ → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2081
  },
  "date": {
    "new": null,
    "old": "2026-05-12"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 18
  },
  "operator_id": {
    "new": null,
    "old": 20
  },
  "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": 143
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 54
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2081,
  "date": "2026-05-12",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 20,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 143,
  "planned_quantity": null,
  "produced_quantity": 54,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:02Cancellazioneplan_assignments2092—
id: 2092 → ∅; date: 2026-05-12 → ∅; notes: ∅ → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2092
  },
  "date": {
    "new": null,
    "old": "2026-05-12"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 18
  },
  "operator_id": {
    "new": null,
    "old": 31
  },
  "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": 143
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 53
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2092,
  "date": "2026-05-12",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 31,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 143,
  "planned_quantity": null,
  "produced_quantity": 53,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:54:47Cancellazioneplan_assignments2190—
id: 2190 → ∅; date: 2026-05-18 → ∅; notes: ∅ → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2190
  },
  "date": {
    "new": null,
    "old": "2026-05-18"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 19
  },
  "operator_id": {
    "new": null,
    "old": 30
  },
  "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": 134
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 143
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2190,
  "date": "2026-05-18",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 19,
  "operator_id": 30,
  "scrap_by_type": {
    "workedCasting": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 143,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:38:27Modificainventory_balances1599app interna · app · inventory_manual_adjustment · product:143:atExternalTreatment
quantity: 107 → 378; updated_at: 2026-05-13T08:49:37.147 → 2026-05-22T12:38:27.933
Dettagli before/after
Diff
{
  "quantity": {
    "new": 378,
    "old": 107
  },
  "updated_at": {
    "new": "2026-05-22T12:38:27.933",
    "old": "2026-05-13T08:49:37.147"
  }
}
Prima
{
  "id": 1599,
  "quantity": 107,
  "warehouse": "at_external_treatment",
  "updated_at": "2026-05-13T08:49:37.147",
  "product_code_id": 143
}
Dopo
{
  "id": 1599,
  "quantity": 378,
  "warehouse": "at_external_treatment",
  "updated_at": "2026-05-22T12:38:27.933",
  "product_code_id": 143
}
22/05/26, 14:38:27Inserimentoinventory_movements2833app interna · app · inventory_manual_adjustment · product:143:atExternalTreatment
id: ∅ → 2833; reason: ∅ → manual_adjustment; metadata: ∅ → {"note":null,"warehouse":"at_external_treatment","targetValue":378}; reference: ∅ → manual:at_external_treatment; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2833,
    "old": null
  },
  "reason": {
    "new": "manual_adjustment",
    "old": null
  },
  "metadata": {
    "new": {
      "note": null,
      "warehouse": "at_external_treatment",
      "targetValue": 378
    },
    "old": null
  },
  "reference": {
    "new": "manual:at_external_treatment",
    "old": null
  },
  "warehouse": {
    "new": "at_external_treatment",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-15T10:38:00",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": 271,
    "old": null
  },
  "product_code_id": {
    "new": 143,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2833,
  "reason": "manual_adjustment",
  "metadata": {
    "note": null,
    "warehouse": "at_external_treatment",
    "targetValue": 378
  },
  "reference": "manual:at_external_treatment",
  "warehouse": "at_external_treatment",
  "occurred_at": "2026-05-15T10:38:00",
  "scrap_by_type": null,
  "quantity_delta": 271,
  "product_code_id": 143
}
22/05/26, 14:38:11Modificainventory_balances1600app interna · app · inventory_manual_adjustment · product:143:semiFinished
quantity: 303 → 32; updated_at: 2026-05-13T08:49:37.149 → 2026-05-22T12:38:11.103
Dettagli before/after
Diff
{
  "quantity": {
    "new": 32,
    "old": 303
  },
  "updated_at": {
    "new": "2026-05-22T12:38:11.103",
    "old": "2026-05-13T08:49:37.149"
  }
}
Prima
{
  "id": 1600,
  "quantity": 303,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-13T08:49:37.149",
  "product_code_id": 143
}
Dopo
{
  "id": 1600,
  "quantity": 32,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-22T12:38:11.103",
  "product_code_id": 143
}
22/05/26, 14:38:11Inserimentoinventory_movements2832app interna · app · inventory_manual_adjustment · product:143:semiFinished
id: ∅ → 2832; reason: ∅ → manual_adjustment; metadata: ∅ → {"note":null,"warehouse":"semi_finished","targetValue":32}; reference: ∅ → manual:semi_finished; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2832,
    "old": null
  },
  "reason": {
    "new": "manual_adjustment",
    "old": null
  },
  "metadata": {
    "new": {
      "note": null,
      "warehouse": "semi_finished",
      "targetValue": 32
    },
    "old": null
  },
  "reference": {
    "new": "manual:semi_finished",
    "old": null
  },
  "warehouse": {
    "new": "semi_finished",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-15T10:38:00",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": -271,
    "old": null
  },
  "product_code_id": {
    "new": 143,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2832,
  "reason": "manual_adjustment",
  "metadata": {
    "note": null,
    "warehouse": "semi_finished",
    "targetValue": 32
  },
  "reference": "manual:semi_finished",
  "warehouse": "semi_finished",
  "occurred_at": "2026-05-15T10:38:00",
  "scrap_by_type": null,
  "quantity_delta": -271,
  "product_code_id": 143
}
22/05/26, 14:26:27Inserimentoorders485app interna · csv_import · orders_import · orders_import:269
id: ∅ → 485; status: ∅ → confirmed; customer: ∅ → BITRON; quantity: ∅ → 360; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 485,
    "old": null
  },
  "status": {
    "new": "confirmed",
    "old": null
  },
  "customer": {
    "new": "BITRON",
    "old": null
  },
  "quantity": {
    "new": 360,
    "old": null
  },
  "delivery_date": {
    "new": "2026-09-02",
    "old": null
  },
  "product_code_id": {
    "new": 143,
    "old": null
  },
  "current_stage_id": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 0,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 485,
  "status": "confirmed",
  "customer": "BITRON",
  "quantity": 360,
  "delivery_date": "2026-09-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:26:27Inserimentoorders412app interna · csv_import · orders_import · orders_import:269
id: ∅ → 412; status: ∅ → confirmed; customer: ∅ → BITRON; quantity: ∅ → 480; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 412,
    "old": null
  },
  "status": {
    "new": "confirmed",
    "old": null
  },
  "customer": {
    "new": "BITRON",
    "old": null
  },
  "quantity": {
    "new": 480,
    "old": null
  },
  "delivery_date": {
    "new": "2026-07-02",
    "old": null
  },
  "product_code_id": {
    "new": 143,
    "old": null
  },
  "current_stage_id": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 0,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 412,
  "status": "confirmed",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-07-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:26:27Inserimentoorders268app interna · csv_import · orders_import · orders_import:269
id: ∅ → 268; status: ∅ → confirmed; customer: ∅ → BITRON; quantity: ∅ → 480; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 268,
    "old": null
  },
  "status": {
    "new": "confirmed",
    "old": null
  },
  "customer": {
    "new": "BITRON",
    "old": null
  },
  "quantity": {
    "new": 480,
    "old": null
  },
  "delivery_date": {
    "new": "2026-06-02",
    "old": null
  },
  "product_code_id": {
    "new": 143,
    "old": null
  },
  "current_stage_id": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 0,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 268,
  "status": "confirmed",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-06-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:24:46Modificaorders153app interna · app · order_bulk_status_update · orders:17,16,19,20,15,18,45,46,49,51,50,48,52,53,54,61,62,63,65,66,69,70,59,58,57,56,64,43,67,55,68,60,77,73,75,76,72,74,79,78,80,83,81,87,85,84,86,82,93,92,91,90,89,88,95,98,99,101,100,96,94,108,113,107,114,106,105,104,103,102,112,111,110,109,141,136,139,116,115,120,97,119,118,117,221,121,122,140,206,222,214,193,123,124,215,194,223,207,200,130,131,132,133,134,135,195,224,201,208,137,138,142,126,127,128,129,144,143,196,145,146,147,148,149,150,151,152,153,154,155,156,157,158,202,209,216,225,159,160,161,162,226,203,217,210,197,163,211,227,204,218,198,219,199,205,212,228,164,220,165,177,166,178,167,168,179,229,213,180,169,181,170,171,182,183,172,184,173,185,174,186,175,176,187
status: confirmed → obsolete
Dettagli before/after
Diff
{
  "status": {
    "new": "obsolete",
    "old": "confirmed"
  }
}
Prima
{
  "id": 153,
  "status": "confirmed",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-07-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 153,
  "status": "obsolete",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-07-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:24:46Modificaorders107app interna · app · order_bulk_status_update · orders:17,16,19,20,15,18,45,46,49,51,50,48,52,53,54,61,62,63,65,66,69,70,59,58,57,56,64,43,67,55,68,60,77,73,75,76,72,74,79,78,80,83,81,87,85,84,86,82,93,92,91,90,89,88,95,98,99,101,100,96,94,108,113,107,114,106,105,104,103,102,112,111,110,109,141,136,139,116,115,120,97,119,118,117,221,121,122,140,206,222,214,193,123,124,215,194,223,207,200,130,131,132,133,134,135,195,224,201,208,137,138,142,126,127,128,129,144,143,196,145,146,147,148,149,150,151,152,153,154,155,156,157,158,202,209,216,225,159,160,161,162,226,203,217,210,197,163,211,227,204,218,198,219,199,205,212,228,164,220,165,177,166,178,167,168,179,229,213,180,169,181,170,171,182,183,172,184,173,185,174,186,175,176,187
status: confirmed → obsolete
Dettagli before/after
Diff
{
  "status": {
    "new": "obsolete",
    "old": "confirmed"
  }
}
Prima
{
  "id": 107,
  "status": "confirmed",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-06-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 107,
  "status": "obsolete",
  "customer": "BITRON",
  "quantity": 480,
  "delivery_date": "2026-06-02",
  "product_code_id": 143,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 12:28:13Inserimentoplan_assignments2190—
id: ∅ → 2190; date: ∅ → 2026-05-18; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2190,
    "old": null
  },
  "date": {
    "new": "2026-05-18",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 19,
    "old": null
  },
  "operator_id": {
    "new": 30,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 1
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 134,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 143,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2190,
  "date": "2026-05-18",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 19,
  "operator_id": 30,
  "scrap_by_type": {
    "workedCasting": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 143,
  "setup_from_product_code_id": null
}
← Precedenti