Files

gsinghpal b5416d242c test(numbering): E2E walkthrough — quote -> SO -> WO -> IN -> CoC -> DLV -> RCV -> Hold -> RMA

Verified pass on entech (parent=30015): all linked docs share the
parent number, immutability + unlink-block + direct-invoice-block
all enforced. NCR/CAPA fall back to legacy sequences as designed.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

2026-05-12 14:35:29 -04:00

__init__.py

feat(jobs): Phase 7 — migration script + legacy id fields

2026-04-25 00:15:23 -04:00

audit_post_migration.py

feat(jobs): Phase 7 — migration script + legacy id fields

2026-04-25 00:15:23 -04:00

audit_pre_migration.py

feat(jobs): Phase 7 — migration script + legacy id fields

2026-04-25 00:15:23 -04:00

cleanup_demo_data.py

fix(jobs): cleanup script — delete SOs, invoices, payments, pickings, quotes

2026-04-25 09:16:48 -04:00

migrate_to_fp_jobs.py

feat(jobs): cutover - bridge_mrp gate, menu nesting, migration robustness

2026-04-25 04:05:02 -04:00

numbering_e2e_walkthrough.py

test(numbering): E2E walkthrough — quote -> SO -> WO -> IN -> CoC -> DLV -> RCV -> Hold -> RMA

2026-05-12 14:35:29 -04:00

README.md

feat(jobs): Phase 7 — migration script + legacy id fields

2026-04-25 00:15:23 -04:00

seed_demo_data.py

feat(jobs): cleanup + seed scripts for demo data reset

2026-04-25 05:43:48 -04:00

seed_direct_orders.py

feat(jobs): seed orders via fp.direct.order.wizard (estimator path)

2026-04-25 10:02:52 -04:00

seed_part_coatings.py

feat(jobs): demo data — work centres + part coatings

2026-04-25 05:53:52 -04:00

seed_work_centres.py

feat(jobs): demo data — work centres + part coatings

2026-04-25 05:53:52 -04:00

seed_workflow_states.py

feat(jobs): comprehensive workflow seed — quotation through paid invoice

2026-04-25 09:56:36 -04:00

README.md

Native job migration scripts

migrate_to_fp_jobs.py

Copies live mrp.production / mrp.workorder records into the native fp.job / fp.job.step model. Idempotent — safe to run multiple times.

Usage

Run from the host (e.g. entech) using odoo shell:

ssh pve-worker5 "pct exec 111 -- bash -c 'su - odoo -s /bin/bash -c \"/usr/bin/odoo shell -c /etc/odoo/odoo.conf -d admin\" < /mnt/extra-addons/custom/fusion_plating_jobs/scripts/migrate_to_fp_jobs.py'"

Or interactively from odoo shell (Python exec builtin, not a shell call):

exec(open('/mnt/extra-addons/custom/fusion_plating_jobs/scripts/migrate_to_fp_jobs.py').read())

What it does

For every mrp.production record, creates a parallel fp.job with the same name and fields. Skips MOs that already have a fp.job mirror (fp.job.legacy_mrp_production_id == mo.id).
For every mrp.workorder record, creates a parallel fp.job.step. Skips already-migrated WOs.
Migrates mrp.workorder.time_ids to fp.job.step.timelog.
Rebinds cross-references on dependent models (batches, holds, certs, deliveries, portal jobs, racking inspections).
Audit log written to /tmp/fp_jobs_migration.log and to a chatter post on each migrated job.

Safety

Idempotent. Re-running skips already-migrated records.
Read-only on legacy MO/WO records. Original data untouched.
Cross-reference rebinds add new x_fc_job_id / x_fc_step_id values without removing legacy production_id / workorder_id values. Both stay populated for the 2-week shadow period.
Wrap in a transaction (default for odoo shell); if anything fails, rollback.

Pre-migration audit

Run audit_pre_migration.py first to see what's about to happen. The script uses Python's exec builtin to load the file inside the running shell session — no shell exec involved.

Reports counts of MO/WO/dependent records and any data-quality concerns (MOs with no recipe, WOs with no work centre, etc).

Post-migration audit

Run audit_post_migration.py after to verify counts match.

Reports row counts on fp.job, fp.job.step, and confirms all dependent records have new x_fc_*_id values.