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 #189
11 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
27/05/26, 12:44:59Modificaproduct_codes189—
assembly_throughput: 26.32 → 197; throughput_per_shift: 24 → 180
Dettagli before/after
Diff
{
  "assembly_throughput": {
    "new": 197,
    "old": 26.32
  },
  "throughput_per_shift": {
    "new": 180,
    "old": 24
  }
}
Prima
{
  "id": 189,
  "code": "MNA1810071",
  "notes": null,
  "active": true,
  "customer": "MAN",
  "flow_type": "assembly",
  "description": "Deckel MAN 071",
  "short_label": null,
  "raw_material_id": 74,
  "packaging_quantity": 3,
  "production_flow_id": 2,
  "assembly_throughput": 26.32,
  "throughput_per_shift": 24,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 189,
  "code": "MNA1810071",
  "notes": null,
  "active": true,
  "customer": "MAN",
  "flow_type": "assembly",
  "description": "Deckel MAN 071",
  "short_label": null,
  "raw_material_id": 74,
  "packaging_quantity": 3,
  "production_flow_id": 2,
  "assembly_throughput": 197,
  "throughput_per_shift": 180,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 14:55:30Cancellazioneplan_assignments1791—
id: 1791 → ∅; date: 2026-04-17 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2512 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1791
  },
  "date": {
    "new": null,
    "old": "2026-04-17"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2512"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 21
  },
  "operator_id": {
    "new": null,
    "old": 25
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "processing": 5
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 102
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1791,
  "date": "2026-04-17",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2512",
  "shift": "T1",
  "status": "completed",
  "machine_id": 21,
  "operator_id": 25,
  "scrap_by_type": {
    "processing": 5
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 102,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1784—
id: 1784 → ∅; date: 2026-04-17 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2499 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1784
  },
  "date": {
    "new": null,
    "old": "2026-04-17"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2499"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 22
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 135
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1784,
  "date": "2026-04-17",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2499",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 22,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 135,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1779—
id: 1779 → ∅; date: 2026-04-17 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2490 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1779
  },
  "date": {
    "new": null,
    "old": "2026-04-17"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2490"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 30
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 210
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1779,
  "date": "2026-04-17",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2490",
  "shift": "T1",
  "status": "completed",
  "machine_id": null,
  "operator_id": 30,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 210,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1767—
id: 1767 → ∅; date: 2026-04-16 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2474 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1767
  },
  "date": {
    "new": null,
    "old": "2026-04-16"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2474"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 21
  },
  "operator_id": {
    "new": null,
    "old": 28
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "processing": 2
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 134
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1767,
  "date": "2026-04-16",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2474",
  "shift": "T2",
  "status": "completed",
  "machine_id": 21,
  "operator_id": 28,
  "scrap_by_type": {
    "processing": 2
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 134,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1761—
id: 1761 → ∅; date: 2026-04-16 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2467 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1761
  },
  "date": {
    "new": null,
    "old": "2026-04-16"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2467"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 22
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 180
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1761,
  "date": "2026-04-16",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2467",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 22,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 180,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1751—
id: 1751 → ∅; date: 2026-04-15 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2447 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1751
  },
  "date": {
    "new": null,
    "old": "2026-04-15"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2447"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 21
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 120
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1751,
  "date": "2026-04-15",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2447",
  "shift": "T2",
  "status": "completed",
  "machine_id": 21,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 120,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1736—
id: 1736 → ∅; date: 2026-04-14 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2420 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1736
  },
  "date": {
    "new": null,
    "old": "2026-04-14"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2420"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 21
  },
  "operator_id": {
    "new": null,
    "old": 25
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 58
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1736,
  "date": "2026-04-14",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2420",
  "shift": "T1",
  "status": "completed",
  "machine_id": 21,
  "operator_id": 25,
  "scrap_by_type": {
    "processing": 7
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 58,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:30Cancellazioneplan_assignments1733—
id: 1733 → ∅; date: 2026-04-14 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2416 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1733
  },
  "date": {
    "new": null,
    "old": "2026-04-14"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2416"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 21
  },
  "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": 189
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 150
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1733,
  "date": "2026-04-14",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2416",
  "shift": "T2",
  "status": "completed",
  "machine_id": 21,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 189,
  "planned_quantity": null,
  "produced_quantity": 150,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:26:27Inserimentoorders390app interna · csv_import · orders_import · orders_import:269
id: ∅ → 390; status: ∅ → confirmed; customer: ∅ → MAN; quantity: ∅ → 500; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 390,
    "old": null
  },
  "status": {
    "new": "confirmed",
    "old": null
  },
  "customer": {
    "new": "MAN",
    "old": null
  },
  "quantity": {
    "new": 500,
    "old": null
  },
  "delivery_date": {
    "new": "2026-07-01",
    "old": null
  },
  "product_code_id": {
    "new": 189,
    "old": null
  },
  "current_stage_id": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 0,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 390,
  "status": "confirmed",
  "customer": "MAN",
  "quantity": 500,
  "delivery_date": "2026-07-01",
  "product_code_id": 189,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:24:46Modificaorders144app 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": 144,
  "status": "confirmed",
  "customer": "MAN",
  "quantity": 500,
  "delivery_date": "2026-07-01",
  "product_code_id": 189,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 144,
  "status": "obsolete",
  "customer": "MAN",
  "quantity": 500,
  "delivery_date": "2026-07-01",
  "product_code_id": 189,
  "current_stage_id": null,
  "produced_quantity": 0
}